Rss

Contact_user

Kokila R

Business Analyst

Occupation:

Business Analyst

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

CAREER SUMMARY Over All 9 Years and 9 months of Work Experience mainly in Oracle PL/SQL and Unix Shell Scripting. * Work Experience in Financial Services (Payment Processing and Mortgage) Domain. * Deep knowledge on end to end debit card payment processing. * Experience in Performance Tuning. * Experience in handling large volume of data. * Experience in programming languages like Oracle PL/SQL, Oracle Pro*C, Unix Shell Scripting. * Experience in Fair Isaac FICO product and Shadowbase replication Software. * Experience in Quality Center and exposure to the testing automation tools. * Exposure to JAVA, C, C++, Microsoft Visual Basic 6.0, Vertex. * Experienced in Manual Testing. * Worked on File Transmissions through NDM/MessageWay/scp/sftp. Summary Totals Repository (STOR) is another client proprietary self-modeled data warehousing system where transaction summary details/customer billing and interchange fee level revenue details are extracted, transformed and loaded to database. This data is available for customer viewing and as well to client management through a GUI interface. * MAC Billing is a First Data Debit Services' billing system and refers to Money Access Control Billing system. The Billing system is used for billing the First Data Corporation's clients for the various services they provide to the clients (participants). * IRS refers to Interchange Reporting system for First Data Debit Services and is used for calculating the interchange fee (fee charged for transacting on other ATMs) on every transaction * Participant Management is a place where the new Financial Institutes/Card Prefix/Terminals are created and maintained and it's a central repository and it serves the participant/prefix/terminal details to the other system. Following are some of the activities/projects carried out : * Worked with Business Analysts and users to frame and finalize the requirements. * Performed Knowledge Transition Assessment and also was involved in obtaining transition of above systems during the timeframe of April 2008. - August 2008. * Analysis of the Business Requirements for the development work on the applications handled. * Functional analysis and Technical Design for any application development work. * Create the required PL/SQL (Procedure/function/trigger/views) Pro*C, Unix and Java Code as needed. * Fine tune the SQL queries. * Preparation of test plan and test cases for each development work . * Responsible for project delivery i.e. Involved in the weekly status call to discuss about the Application Development and maintenance work * Database development and performance tuning. * Unix shell scripting, scheduling cronjobs and monitoring. * Involved in Requirement gathering, analysis and impact analysis. * Functional and technical design, logical data model design and data mapping. * Coding in database packages, procedures, triggers, functions and anonymous blocks. * Design reviews and code reviews. * Integration with remote database using DB link designing interfaces. * Deploying the application in Development Environment, migrating code to upper environments and QA. * Preparing rollouts for deployments, rollback strategies and support post deployment. * Support for QA and UAT * Document and KT for new resources * Collaborating with the Business group in the analysis and setting up of the MAC Billing and IRS pricing configuration for various First Data's services/clients being done. * Involved in the Effort Estimations for all the Application Development and Enhancement work * Production support activities on all the applications. * Task allocation to team members as the team performs both Application Maintenance and Application Development activities * Timely notification of progress to issue resolutions to engagement leadership * Requirement review discussions with business and obtaining clarifications * Estimate effort and draft schedules for the delivery * Plan the capacity for future months and revise to accommodate high priority projects * Track effort and revise effort in case of justified over/under run by submitting project change requests * Co-ordinate production change implementations with teams (DBA, Server support, Transmission and Job scheduling teams) * Work with Transmission team to set up ndm/message way to transfer files to various interfacing systems. * Working with the scheduling team to schedule batch jobs. * Work with Business Users and Business Analyst to create various reports for statistics and analytics and also based on business needs. * Support internal business users like STAR Marketing and Strategy analyst team in coming up with new product strategies by providing production transaction data for research purposes. Data Center Consolidation project (DCC) - The batch application residing on Solaris 8/Oracle 9i is being upgraded to Solaris 10/Oracle 10g. * Incoming and Outgoing interface Impact analysis as part of the DCC project. * Identifying the impacted programs and developing the respective code changes. * Setting up of the new Development Environment on Solaris 10 and Oracle 10g. * Co-ordination with various teams (Oracle DBA's, Server Technology Support, etc) for completing the Pre-implementation activities. Oracle Version Upgrade: * Update the existing sql and PL/SQL block to be incompatible with Oracle 11g * Validate the performance of the existing sql and pl/sql code and fine tune the queries. * Upgrade Shadowbase software to be in compatible with Oracle 11g. * Validate the GUI application on the performance. * Tokenization/EMV/STAR Automated Fraud Reporting/STAR Contactless Program and MasterCard/VISA/Pulse Compliance projects for the applications handled. * MC 250 byte Interchange file processing /MC Quarterly reporting/report creation for multiple clients and Other critical projects. * Creation of utilities for frequently occurring issues/similar projects and data extract requests to reduce cost and effort. * As the subject matter expert of the IRS system, I was engaged with one of First Data's Strategic Consultant in a critical product decision exercise for the client. This exercise involved multiple iterations of creating different model for the client to see the effect of the interchange rate changes. The outcome of the exercise was new competitive rates the client can impose on their customers for STAR POS transactions. This also enabled the client to enroll new customers for the year. * Work with the users on the data extract and service requests and to clarify user queries. * Work with the finance team to set up the interchange and billing set up. Hardware SUN Operating System Solaris 5.8/5.10, Windows XP/Windows 7

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom