Post Job Free

Resume

Sign in

PL/SQL and Unix

Location:
Orlando, FL
Posted:
January 30, 2016

Contact this candidate

Resume:

Eperience Summary

Over All * Years and * months of Work Experience in IT Industry

• Work Experience in Financial Services (Payment Processing and Mortgage) Domain.

• Experienced in Project Management, Requirements study, Design (Low Level and High Level), Development, Implementation, Testing, Execution/Maintenance and Delivery of a project.

• Experienced in Manual Testing.

• Involved in Process improvements, Project Co-ordinations, Client Interactions and Knowledge Transfer sessions to the team and been part of the Accenture Level Trainings.

• Expertise in Trouble shooting the production issues/problems.

• Experience in programming languages like Oracle PL/SQL, Oracle Pro*C, Unix Shell Scripting.

• Experience in Fair Isaac FICO product and Shadowbase Software

• Exposure to JAVA, C, C++, Microsoft Visual Basic 6.0, Vertex, Power Builder 10.

• Been part of the interview process.

Career Objective

Seeking a career position which provides scope to implement the functional, technical, analytical and managerial skills I have cultivated in the years of my learning to make a good leader and an asset to my work place.

Educational Qualification

• Bachelor of Engineering in Electronics and Communication [2001 – 2004], from Vellore Engineering College, Anna University.

• Diploma in Computer Technology [1998 – 2001], from Institute of Road Transport.

• Matriculation - Matriculation Board of TamilNadu [April 1998] .

Professional Experience

Accenture Services Ltd as Associate Manager

Mar 2014 – till date

Accenture Services Ltd as Team Lead

Sep 2010 – Feb 2014

Accenture Services Ltd as Senior Software Engineer

Sep 2008– Aug 2010

Accenture Services Ltd as Software Engineer

Sep 2007 – Aug 2008

Accenture Services Ltd as Associate Software Engineer

Apr 2006 – Aug 2007

`

Skills

• Programming Languages Oracle PL/SQL, VB 6.0, Oracle Pro*C, C, C++

• Scripting Languages Unix Shell Scripting

• Data Base Oracle, MS-Access

• Third Party Applications Fair Issac Corporation’s FALCON Fraud Manager

Vertex Tax Decision Modeler

Shadowbase Replication Software

• Tools Oracle SQL Developer, TOAD, Connect Direct, Putty, Quality Center

• Version Control IBM Clearcase

• Batch Job Scheduling Tools CA Scheduler

• Operating System Sun Solaris 5.10, Sun Solaris 5.08

• Functional Domain Financial Services (Payment Processing), Financial Services (Mortgage Solutions)

• Good Knowledge in Relational Database Concepts & SDLC cycle

• Project Co-ordination, tracking progress and tracking various issues to closure

Project Experience

Accenture Services Pvt Ltd

First Data Corporation

First Data Corp. is a leading provider of electronic commerce and payment solutions for businesses worldwide, with operations in 38 countries. First Data serves over 5 million merchant locations, 1,900 card issuers and their customers.

The company's portfolio of services and solutions includes merchant transaction processing services; credit, debit, private-label, gift, payroll and other prepaid card offerings; fraud protection and authentication solutions; receivables management solutions; electronic check acceptance services through TeleCheck; as well as Internet commerce and mobile payment solutions

Title Application Development/Enhancements/Maintenance to Transaction Warehouse (TRDW), Real Time Enterprise Data (RED), Card Database (CRD), Fraud Risk Identification System (FRIS), Summary Totals Repository (STOR), MAC Billing, IRS (Interchange Reporting System), CMA Batch and SRS Applications.

Period Jul 2008 – June 2015

Client Name First Data Corporation (Debit Card processing) Wilmington, United States

Position Project Lead/Associate Manager/Team Lead/Programmer/Onshore Coordinator

Team Size 10+

Project Lead Responsibilities

Track project activities/issues

Follow up on each application team’s progress

Project Activity/Effort Tracking

Weekly Update of project’s status to leadership

Meet with Business Analysts for requirements clarification

Documenting meeting minutes and tracking action items to closure

Co-ordinate client review of phase-wise deliverables

Prepare Implementation plan

Co-ordination with Client Project Teams

Project management and delivery

Co-ordinate project implementations

Team Lead Responsibilities

Requirement Analysis

Top Down/Bottoms Up estimations

Documenting Assumptions/Risks involved

Scheduling of Phase-wise Milestones

Assess conflicts with already planned projects and future projects

Resource Allocation, Capacity Forecasting and Planning

Technical Analysis and Design

Peer Reviews

Project Activity/Effort Tracking

Co-ordination with Client Project Teams

Project management and delivery

Co-ordinate project/change implementations

Application Maintenance as per SLAs

Team management - Maintaining team’s motivation and involvement

Programmer Responsibilities

Business Requirement Analysis

Design

Build

Peer Reviews

Tracking Defects to closure

System Maintenance

Co-ordination with Client Teams and Other interfacing Teams

Project

o Transaction Repository and Data Warehousing (TRDW) is one of First Data Debit Services’ self built data Warehousing application, comprises of a 24x7 batch application built on Pro*C, this system writes to the database the ATM/POS transactions logged by North-East Switch at near real-time. The system is also capable of matching the dependant transactions (reversals/purchase completions) to its corresponding original transactions (withdrawals/pre-authorization transactions). This data warehouse provides ability clients to view their respective banking transactions through a client user interface called New Star Station (NSS). Data in the warehouse is also used for various data reporting to clients through files transmitted using Network Data Mover (NDM). All the GUI applications will fetch data through procedures and function.

o Real-Time Enterprise Data (RED) is a system where the transformed data of transaction warehouse resides. The system comprises of 24x7 Pro*C batch application and a database which resides multiple level summary of transaction data. This data enables Client teams in assessing the Switch Processor Interface (PI) performance and ATM/POS transaction activities.

o Fraud Risk Identification Program (FRIS) system which scores transactions for fraud using a third-party application called FALCON Fraud Manager. The system comprises of components to load STAR transactions into database, FALCON processes to score transactions, create Fraud Cases for Fraud Analysts’ review and also an interface to Omaha Dialer.

o Card Database (CRD) is a repository of customer cards data for which is replicated from a Tandem system called “CMA (Card Management) through Shadow-base replication software.

o 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.

o 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).

o 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

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-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 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)

• 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.

o Incoming and Outgoing interface Impact analysis as part of the DCC project.

o Identifying the impacted programs and developing the respective code changes.

o Setting up of the new Development Environment on Solaris 10 and Oracle 10g.

o Co-ordination with various teams (Oracle DBA’s, Server Technology Support, etc) for completing the Pre-implementation activities.

Oracle Version Upgrade:

o Update the existing sql and PL/SQL block to be incompatible with Oracle 11g

o Validate the performance of the existing sql and pl/sql code and fine tune the queries.

o Upgrade Shadowbase software to be in compatible with Oracle 11g.

o Validate the GUI application on the performance.

o Tokenization projects for all the applications handled.

• Tokenization/STAR Automated Fraud Reporting/STAR Contactless Program and MasterCard/VISA 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

Languages Oracle PL/SQL (9i/10g/11g), Pro *C, UNIX Shell Scripting, JAVA

Special Software Oracle PL/SQL Developer, Clear case, Connect Direct, CA Scheduler, Putty, Vertex Tax Software, Fair Isaac Fraud Software, ShadowBase.

Project Location Chennai, India

Wilmington, United States

Bank of America

Bank of America is a financial services company, the largest banking holding company in the United States. It plays major role in the Mortgage industry.

Consumer Real Estate deals with Mortgage. It has a set of applications which includes the front application to apply a mortgage loan, loan processing application and fulfillment applications

Title Manual Testing

Period Jul 2006 – May 2008

Client Name Bank of America (Consumer Real Estate)

Position Test Engineer

Team Size 5+

Responsibilities

• Developing test scenarios and test cases for business and functional requirements.

• Raised mapping sheet clarification and updating.

• Tracking the test case execution status.

• Raising and tracking the defects in Quality Center.

• Status updating and reporting on periodic intervals.

• Understanding the customer requirements and tracking the requirement changes in the test cases to make sure that each of the requirements gets mapped to a test case.

• Given Knowledge Transfer sessions and assigning task to the junior team members.

• Interactions with BA & Dev. teams to resolve the issues.

• Reporting daily testing status report.

• Developed, Reviewed & Executed Test Scripts and Designed test data.

• Played Test Lead role.

• Followed Testing Center of Excellence (TCoE) standards for all the deliverables

Project Location Chennai, India

Other Acknowledgements

o Greenfield Training Top performer.

o Received Accenture Celebrates Excellence Award for Excellence in Business Operations.

o Received First Data Project Excellence “Going the Extra Mile” “Catalyst Performer” “Mentor” and “Star of the Month” award.

o Received Bank of America project “Star of the Month” award.

Corporate Training

Accenture Services Pvt Ltd, Chennai

Duration: Apr’06 - Jun’06

Certification:

• Banking Foundation Certification

• Credit Card for Bankers Certification

• OCA

• CSTE

• SCJP

Personal Information

• Date of Birth 30-July-1983

• Languages known English, Tamil, Telugu

Contact Details

• Mobile +1-302-***-****

• E-mail Id

actb2u@r.postjobfree.com

• Address 10564, Bastille Lane,

Apt 210,

Orlando,

Florida – 32836

I hereby declare that the above mentioned details are perfect and true to the best of my Knowledge.

Kokila Ramamurthy



Contact this candidate