Highlights:

R Programming

AGILE Methodology

Data Science Methodology

Data Analyst

Technical design

Technical Lead

Test Cases

Vendor Testing

SDLC Expert

Banking and Financial Services

UAT Support

Personal Lines Insurance

Data Migration

Code Review

Coding and Modularization

Professional Summary:

Highly skilled software development professional bringing more than 12 years in software design, development and integration. Advanced knowledge of Oracle and PL/SQL, Data Analyst.

Technical Lead with expertise in all aspects of the software development life cycle, including requirements analysis, design, development and production support.

AGILE Methodology – Scrum Framework –attending Daily Scrum Meeting/SPRINT Review Meeting

Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end users.

Worked in Data Migration Projects.

Worked in Banking and Financial Projects and Life Sciences Projects and having exposure to BFS and Life sciences domain.

Self-directed and motivated Software Engineer who works effectively in a dynamic environment. Fluent in Oracle, PL/SQL, RTC/CVS,SVN, TOAD, TDP, PL/SQL developer and UNIX.

Software Engineer well-versed in creating test cases, as well as covering all test conditions and eliminating redundancy and duplications.

Expert Software Developer dedicated to constantly improving tools and infrastructure to maximize productivity, minimize system downtime and quickly respond to the changing needs of the business

Expertise in Property and Causality Insurance specifically Personal Automobile and Home Owners. Having good knowledge in insurance processes and platforms which includes Technical underwriting, Rating, Claims management, treasury and Interfaces.

Involved in New Project Proposals, Project Planning, Project Scoping, Estimations and Resource Planning.

Active member of Code Review team and involved in reviewing the design documents and code deliverables.

Worked as a Key resource in Data Analysis and perform Data Migration.

Assisted in the maintenance of the risk/issues logs, change control process, traceability matrix, business process documentation, interface with testing team for defect management, etc.

Experience in preparing test scenarios, test cases and test plans based on business requirements and functional requirements

Actively involved in successful Business Application deployment, production support and UAT support.

Build and maintain strong relationships with business partners, customers, technology teams and Management team.

Ability to work efficiently independently and as part of a team.

Critical thinker, excellent negotiating skills, writing skills and communication skills. Great team member and leader.

Aspiring to work in a real professional atmosphere that enables me to cope with the latest emerging technologies, thus helping to widen the spectrum of my knowledge as well as organizational growth.

Project Experience –

Cognizant Technology Solutions

AT&T Feb’17 – Present

Bothell, WA

Database Analyst

ORACLE, PLSQL, UNIX

Project Scope

The Common Product Catalog (CPC), an interface provides service to deliver rich product information to clients to faciliate their application flows. The system was first created in 2005 to supply market rate plans/features and equipment reference data,later it was extended to become the product catalog, providing product data customized at the FAN level to business customers. Since early 2008, it has been extended again to provide product information for other channels and applications.

ROLES AND RESPONSIBILITIES

Analyzing the requirement and discussing with the Technical Lead (@Client) to gather all the information related to the requirements.

Working closely with the Lead (@ Client) and developing the code based on the requirements

Performing the ETL - Analyzing the requirement and discussing with the Technical Lead (@Client) to gather all the information related to the requirements for each sprint.

Creating Metadata and Stored procedure/batch to perform data load in CPC database.

Creating Test cases and performing Unit Testing to validate the code following the requirements.

Delivering the code for the deployment.

Cognizant Technology Solutions

ADP June ’16 – Jan ’17

Alpharetta, GA

Data Analyst

ORACLE, PLSQL

Project Scope

ADP national payroll services are running Payforce application since 1999. This application is used to process payroll for hundreds of customers. ADP decided to move away from Payforce and migrate all its clients eventually to their newly designed product, Vantage. The present analysis is done for 750 clients selected by ADP for data migration. Although the critical path of this migration involves Security, Portal, Interfaces and Reports the spirit of this migration is to move data from Payforce to Vantage database. Analysis is performed to derive a wave based iterative approach to transfer client batch by batch to Vantage. Another objective of the analysis is to find out the most efficient data migration solution with as much automation as possible.

ROLES AND RESPONSIBILITIES

Onshore Data Analyst responsible for Data Migration from source legacy Payforce system to target Vantage Database by analyzing the data based on the functional requirement and migrated the data to Vantage database without any issues for 10 clients(Simpson Thacher, Rose International, Tillys, Triple Canopy, Goodwill of AZ, Garmin, Savation Amy, Headwaters, Planet Hollywood, Martinrea) both in UAT and Production.

Execute various jobs to load table data from source to target and analyze the data and fixed any issues faced.

Responsible for triaging the issues faced and perform corrections where necessary to migrate data to target without rejections.

Work with offshore team to load data and clarify any technical questions raised by them.

Work with ADP team to clarify queries or any technical assistance when necessary.

Creation of Snapshot and Staging databases from Database Dump which will be used as the source.

Review BRD for the client specific documentations and load data accordingly.

Communicate with various stakeholders like Business Analysts, Upgrade Consultants, and Program Managers Security testing team, Data testing team and Functional QA teams if there are any issues or doubts.

Fixing the defects which were raised by the QA team after the data load.

MAPFRE Tronweb Jan ’11 – Jan ’16

Webster, MA

Technical Lead

ORACLE, PLSQL, UNIX, Jasper Reports

TRONWeb is MAPFRE's core Insurance Processing System. TRONWeb is the enterprise wide project that will implement a single insurance processing system across all of the MAPFRE USA locations. It is a fully integrated Insurance processing system. The TRONWeb System utilizes a Client – Server Architecture. The Graphical User Interface (GUI) is created using the Java programming language (AWT). Business logic objects are implemented in PL/SQL procedures running over an Oracle 11g release 2 Database. Currently many projects in MAPFRE are using the Tronweb Database which is hosted on AIX Server. TRONWeb usage is confined to Internal Users. External users like third party, uses WebTRONWeb (WTW). TRONWeb handles the modules like Issues, Claims, Treasury, Accounting, AFE and etc.

Project Scope

Implementation of New Business of CA Home Insurance.

Implementation of New Business of AZ, FL, PA Auto Insurance.

OFAC – Office of Foreign Assets Control.

Car fax – Connected to THP Web to gather the Vehicle history details.

ROLES AND RESPONSIBILITIES

Analyzed the product requirements, scoping the requirements, analyzing input contents provided by the product managers, clarifying issues regarding the requirement and contents provided with MAPFRE product managers which involves MAPFRE specific domain knowledge

Discussed with the Users/BA to gather all the information related to the requirements if there is any GAP

Allocating tasks to offshore team based on client’s requirements and coordinating with the team on a daily basis

Performed Technical design prepared by offshore team to meet the requirements

Performed Code Review using the Cognizant Customized tool SONAR to deliver the quality code to the Client

Coordinating with the Cognizant Offshore Team to fix the code review comments if there is any deviation

Validated the Code for business logic before delivering

Reviewed Unit Test Cases prepared by offshore team

Resolved defects raised in HP ALM

Involved in Vendor Testing and worked in Vendor Server side changes to accept the files

Conducted knowledge transfer sessions to key resources for smooth implementation

Acted as SME for the Claims, Interfaces & Reports Module

Cognizant Technology Solutions

WellPoint April’10 – Dec ‘10

Mason, OH

Technical Analyst

ORACLE, PLSQL, UNIX

Project Scope

There are two main SIT environments in which the batch needs to be run. They are 4.41 and 4.71, under which 4.41 have AIMS_MAINTSYS and AIMS_MEDD and 4.71 have AIMS_SYS and WCRMEDD. The testers used to place the job request through OWEN – Online Work Entry Network tool on each and every environment. The job needs to run following the specified order.

ROLES AND RESPONSIBILITIES

Scheduled and ran the jobs in the WLM Scheduler in Unit Test environment

Monitored the job runs and provided the status to the testers(who requested the jobs) and the Client on a daily basis

Prepared the failure tracker and shared everyone

Provided Assistance and Training to the Offshore Team

Handover the jobs monitor to Offshore Team to continue

Cognizant Technology Solutions

The Northern Trust May ’08 – April ‘10

Chicago, IL

Team Lead

ORACLE, PLSQL

Project Scope

General Ledger Reporting (GLR) is one of the projects in Wealth Passport which allows the clients to view their Balance sheet, Income Statement, Transaction Activity, Interface Listing and Trial Balance through various reports. This project deals mainly with the report generation process based on the client request. These reports are very useful to track the performance of their investment. All these information’s are saved in GLR database. Apart from this, GLR supports a unique concept called ‘CUSTOMIZATION’. Through this the user can select their own preferred columns for display/grouping or sorting purposes in the reports. There are number of batch processes running on a daily basis to get data from external applications and updates that information in GLR.

ROLES AND RESPONSIBILITIES

Coordinated with systems partners to finalize designs and confirm requirements.

Implemented technical procedures and standards for preserving the integrity and security of data, reports and access.

Implemented designs, including experimentation and multiple iterations.

Modified existing software to correct errors, upgrade interfaces and improve performance.

Prepared detailed reports concerning project specifications and activities.

Consulted regularly with customers on project status, proposals and technical issues.

Worked closely with other team members to plan, design and develop robust solutions in a timely manner.

Interfaced with business analysts, developers and technical support to determine the best requirement specifications.

Prepared test cases, test data based on functional requirements and business requirements

Performed Design / Code review developed by the team members

Prepared status report and shared to Client

Cognizant Technology Solutions

IMS Europe June ’06 – Dec ‘07

Chennai, India

Team Member

ORACLE, PLSQL, UNIX

IMS Health (Inter-continental Marketing Services) (NYSE: RX) is an intern consulting and data services company that supplies the pharmaceutical industry with sales data and consulting services. IMS Health was founded in 1954 by Bill Froch and David Dow. Today IMS has operations in more than 100 countries, a global workforce of 7,600+ employees and revenues of $2bn. It recently moved its headquarters from Fairfield, CT to Norwalk, CT.

Project Scope

LPIN has a GUI built in PowerBuilder which provides access to an Oracle database that contains all LPIN data, stored procedures and triggers. The combination of UNIX shell scripts and Oracle scripts are employed for generating the LPIN extracts. NDF (National Description File) which contains product and pack details, CHRON (Pack / Product Changes Files), CPI (Common Product Interface) which contains both Product and Pack details in a Single CPI file are the files extracted in LPIN system and are transferred to various IMS systems.

Implementation of Italy, Algeria, and Tunisia Rollouts

ROLES AND RESPONSIBILITIES

Gathered information on the requirement from the user and prepared the design document and sent to Team lead for the review

Performed Coding and Test cases and sent to Team Lead for the review

Involved in Integration / Regression Testing Support and resolved defects

Prepared the daily status and shared to Team Lead

Conducted knowledge transfer sessions to key resources for smooth implementation

Polaris Software Lab Ltd

Citibank Oct ’03 – Jun ‘06

Chennai, India

Team Member

ORACLE, PRO*C, PLSQL, UNIX

Project Scope

Email ID Search – Look for the Customer details by passing Email ID.

KYC – Report to gather the Customer Inflow/OutFlow to/from the bank.

ROLES AND RESPONSIBILITIES

Gathered information on the requirement from the user and prepared the design document and sent to Team lead for the review

Performed Coding and Test cases and sent to Team Lead for the review

Involved in Integration / Regression Testing Support and resolved defects

Prepared the daily status and shared to Team Lead

Conducted knowledge transfer sessions to key resources for smooth implementation

Education:

Master of Computer Applications, University of Madras, India May 2003

Bachelor of Computer Science, University of Madras, India May 2000

Certification: Introduction to R Programming, Big Data Fundamentals, Data Science Methodology, Oracle Certified Associate, Brain Bench – Oracle, PLSQL, Completed L0 – Life Sciences

Contact this candidate