Summary of Qualifications

• Over 12 years of experience in System Analysis, Design, Development, Testing and Implementation of Software Applications.
• Over 4 years of ETL Data warehousing experience using Informatica Power Center 9.0/8.6.1 (Source Analyzer, Mapping Designer, Mapplets Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager).
• Hands on experience in Full Life Cycle Development of Data warehouse design Process.
• Over 6 years of prior experience using AS/400 I-Series, RPG/400, CL/400, DB2/400, ILE RPG, Sub files, DB2, SQL RPGLE, Embedded SQL and Web service programs on I- Series
• Worked with different data sources non-relational Databases such as Flat files, XML files and other relational sources such as Oracle, Sql Server and DB2.
• Worked extensively with Data migration, Data Cleansing, (ETL) Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Experience in performance tuning at source, target, mapping level and session optimization for efficient workflow performance.
• Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Expert in coding complex and advanced PL/SQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.
• Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings, PL/SQL Stored Procedure and Triggers
• Experience in Data modelling (logical and Physical), Forward Engineering, and Reverse Engineering & Complete Compare using Erwin 7.
• Expertise in design and implementation of SCD - Slowly changing dimensions types (1, 2 and 3) and CDC – Change data capture.
• Extensively worked with Stored Procedures, Triggers, Cursors, Indexes, Functions and Packages.
• Experience in using Workflows, Worklets and Mapplets.
• Functioned as Onsite Coordinator/Team Lead of 10 people working from offshore site in India.
• Experienced in requirement gathering design & development, testing & review, deployment, code conversion, preparation of feasibility reports and project proposals and planning.
• Extensive Experience in Insurance, Banking, Finance, Retail and Transportation Industries.
• Experienced in preparing HLD & LLD, Technical Design and Documentations.
• Experience in project deployments and preparation implementation documents and preparation of issue logs, run books for completed implemented projects.
• Experience with SDLC using waterfalls, Scrum, Rapid application development and spiral model.
• Worked on Database Analysis and Change management Software in different environments.
• Effective team lead/member with excellent interpersonal, analytical, and communication skills.

Technical Summary

Data Warehousing: InformaticaPowerMart7.1.1, Informatica PowerCenter 9.0/8.6.1, Mapping Designer, Warehouse Designer, IBM DataStage (Ascential DataStage and Ardent DataStage).
Operating Systems: IBM OS/400V7R1, WINDOWS 7/XP, UNIX, IBM AIX 7.1.
Databases: Oracle11gr2/10g/9i/8i, IBM DB2/400, SQL Server 2005 SSIS, Informix 4.12, Teradata 13.1, Knowledge on IBM Netteza Twin Fin.
Prog Lang: PL/SQL, ILE RPGIV, I-Series, RPG, SQL, SQLRPG, CL/400, COBOL/400, SQL/400, C, VB, XML, Perl 5.0, HTTP, Jwalk4.2C4, SOAP (Simple Object Access Protocol) methods in web server programs. Stored Procedures, JavaScript, SQL*Loader, procedures in SQL Server, Support for EDI developer’s tool, Planet press (PP) report generator ver 4.0
Packages: Visio Professional, MS-Project, Artius, Seagull Jwalk package 4.0C13
Case Tool: AS/400 Tool Kit for Java, OBIEE, Optio tool, Implementer tool, MQSeries, JD Edwards, DBU tools, HTTP API browser (sends and receives the data from a web server), Aldon tool, Implementer, Visual source safe (VSS) 6.0, Synon/2E, Actuate 4.0, Toad 9.1, Four-Gen Form Painter 4.12UC1, Visio Professional, UML, Test Director 5.01, OLAP Tools BO 6.5, AbInitio GDE, Artius Rating Environment (ARE), Crystal reports XI R2, Sampling tools, Quality Center, Load Runner 7.2, Robot Automated Operations Solution, ACORD agency uploads, Peregrine Service center
GUI/Tools: Actuate Reporting tool , CloverETL Data profile tools, Test Director 7.6, Maestro, Robot Scheduler, FTP, Visual Age for Java, RLU, SDA, DBU, SEQUEL, Jwalk tools.
Methodologies: Data Modeling DDM, Star Join Schema, Snow Flake Modeling, Fact and Dimensions,
ER diagrams 5, ERWIN 7.0

Professional Experience

Confidential,Columbus, OH 03/2008 – till date
Senior Systems Analyst /Informatica Application Consultant

MAPFRE Insurance, a brand of the American Commerce Insurance Company (ACIC) has consistently provided superior personal lines property and casualty insurance products to agents and insureds. Core product lines include personal automobile, homeowners, and commercial automobile insurance. MAPFRE USA partners with a network of more than 3,200 independent agents and brokers located across the United States. MAPFRE is the leading insurer in both Spain and Latin America, the tenth largest non-life insurer in Europe, and employs over 25,000 people worldwide. MAPFRE is the leader reinsurer company in Spain and it ranks amongst the 20 largest reinsurers in the world.

Main objective of this project is to providing an Insurance system with all the information regarding policies sales and premiums and transactions and agent’s level commissions of entire Organization all over the USA. Company having 4 branches (CIC, ACIC, CWIC and SWIC) in different locations in USA with different technologies on database DB2 UDB and all data migrated into DWH with target database Oracle 10g using the ETL tool of Informatica on UNIX. Domains like Auto, Home and Commercial property insurances from 4 locations. Get the daily transaction data from all branches logic based on Branch numbers, Company numbers and policy types. Load all historical data into DWH and once finished historical data then load Delta Loads. This Delta loads are scheduled daily basis.

• Involved in Analysis, Requirements Gathering and documenting Functional & Technical specifications.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager.
• Developed data Mappings between source systems and warehouse components
• Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. and Fine-tuned the mappings for optimal performance.
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Informatica Debugger
• Working on the Data analytical process and Data profiling using the CloverETL data profiler.
• Familiar with batch scheduling using Maestro Job Scheduler
• Created Informatica mappings for data conversion processes and scheduled the workflow in parallel mode for better performance, created pipeline partitions, SQL Override in source qualifier.
• Coordinating with the DBA’s for managing the databases in different environments for UAT and system testing, also involving with DBA’s during the release nights and troubleshooting with any of the production problems.
• Created the conceptual model for the data warehouse with emphasis on insurance, claims and annuity using ER Studio data modeling tool.
• Experienced in preparing the Technical Design and Documentation.
• Implemented SCD2 type mapping for customer dimension (CIPPLE) and account dimension (CINMAD) to keep history of the customers and accounts.
• Involved in performance tuning in the ETL processes with PDO (Pushdown Optimization) methodology.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Involved in the project deployments and preparation of implementation documents.
• Worked with testing team in trouble shooting the defects in application.
• Used Informatica as a tool for the test data preparation in various environments
• Involved in performance tuning of SQL Queries.
• Created ftp connections, database connections (ODBC) for the sources and targets.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Loaded consolidated data using external SQL*Loaders.
• Balance reports generation for Claims and market conduct report with BI team
• Developed Session scripts to automate the data load processes to target Data warehouse
• Provided on-call support for the nightly load process.
• Prepared and participated with client in Week status meetings and setup the meetings with clients.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections

Environment: Informatica Power Center 9.0/8.6.1/7/1.4, DB2 UDB, PL/SQL, IBM Tivoli Workload Scheduler 8.2 (Maestro), UNIX, AIX Shell Scripting, Oracle 11g r2, ER Studio 7.1.1, OBIEE, Windows XP, TOAD, and OLAP BO 6.5.

Confidential,Columbus, OH 10/2005 – 03/2008
Programmer Analyst II /Team Lead

American Commerce Insurance Company is the leading provider of both automobile and homeowners insurance in USA. The Commerce Group Company announced plans to strategically align company branding efforts with that of MAPFRE, displaying the financial strength and stability gained from MAPFRE’s acquisition of The Commerce Group, Inc. in June 2008. MAPFRE is the leading insurer in both Spain and Latin America, the tenth largest non-life insurer in Europe, and employs over 25,000 people world wide.

• Design & Development of new states (OH, ID, NJ, and NY) programs for specialty insurance system for Auto and Home insurance products with coding in RPGLE, CLLE, Embedded SQL programs, ILE programs and Development of several maintenance programs on SQLRPGLE and Coding of the trigger programs and procedures.
• Development and Support for Agency Download programs with ACORD (Association for Cooperative Operations Research and Development) format.
• Design & Development of Jwalk Front-end for state (OH, ID, NJ, and NY) Agents.
• Jwalk Implementations, deployments and Support on Seagull JWalk server4.2C4 issues
• Working on the Production support issues using the Peregrine service center.
• Design and development of Monthly, Quarterly and yearly balance reports by using RLU
• Prepare the Entity Relationship(ER) diagrams illustrate the logical structure of databases for reports and billing cycles.
• Development of Web service Programs (interface I-series programs call SOAP Web service) for address verification and to get the territory for given address/zip code
• Development and upgrade of interface programs from APOS (point of sale-Agency port) to SIS (specialty insurance system) for Line of businesses Auto (Personal Auto, Boat) and Home (Home, mobile Home) Policy/Quote upload using for T21.
• Monthly Vesta Data Extraction for Premium and Claims and Analysis of Error Files and send them to Clients
• Print Forms/Labels/Form Segments set up Insurance forms using Optio tools
• Mapping & design of Planet press documents/forms from SIS (AS/400 system) DB files
• Development of Specialized in insurance products Artius (ARE) interface programs using XML objects in RPGLE.
• Customization of SIS system package in line of business PA, HO/MH and CA with coding in RPGLE, CLLE, Embedded SQL programs, ILE programs and Development of several maintenance programs on SQLRPGLE and Coding of the trigger programs and procedures

Environment: I-series Mid-range AS/400( CGIL5, CGIL4, ACICPRD, ACICDEV) , RPGLE, CL/400, DB2 UDB for I-series SQL server, OS/400-V7R1, Windows XP, IBM PC 5250, IFS, Jwalk 4.2C4, ER diagrams, Optio tools, Embedded SQL, Artius rating environment) tool for insurance policy ratings, Insurance packages, SQL Server Integration Services (SSIS), Lotus notes, ROBOT Scheduler , VIN updations tools, Test tract pro for defects, Actuate, Implementer, Planet press print tools, Sampling tools, Peregrine Service center .

Confidential,Greenwich, CT 12/2003 – 9/2005
Project Lead

• Functioned as Team lead and an onsite coordinator on Status Side (AS/400).
• Study of requirements at project initial stage and preparation of project proposal.
• Support of AS/400 RPGLE, CL programs related to Tank containers.
• Worked on Synon case tool for AS/400 on Data base modeling, screen editing action diagrams.
• Quote/Move Inquiry/Maintenance on Tank movements in status application.
• Defect analysis and fixing as per the Defect Resolution process defined by tickets.
• Worked on program enhancements in applications.
• Deployment of fixes to production system from development environment.
• Provided Accounting and Invoice reports maintenance support.
• Worked on Database Analysis and Change management system in different environments on AS/400 and Aldon Interfaces.
• Support of AS/400 RPG program called by Web hub programs and Robot Alerts messages.
• Worked on AS/400 Implementer for program check-out in between the production and MVTEST/UTTEST environments.
• Prepared and participated with client in Week status meetings and setup the meetings with clients and offshore teams managers.
• Knowledge transfer between onsite & offshore model
• Working on BPCS inventory level and Orders a credit holder alerts.
• Prepared the document for coding standards checking list, quality document, test cases, and review documents.
• Functioned as QA tester and debugger of programs.
• Synon Cool 2E in a multi model environment generating RPG code for ship scheduler
• Utilized tools such as Optio, Implementer and Java interface programs in between java and AS/400 in Webhub application.

Environment: Mid range AS/400 I Series, RPGLE, CL/400, COBOL/400, Euro Kit, MpGen, Optio Tools, Synon/2E , Winrunner, VSS, DB2/400 and DB2 UDB for iSeries SQL/DDL, Aldon tools interface, JD Edwards, Versata work-flow engine, OS/400-V4R5 and later, Windows NT 4.0, Pentium PC, SN400 SYSTEM, IBM 3270

Confidential,Shelton, CT 09/2002 – 12/2003
Analyst/Developer

Modules: Order fulfillment, Inventory management, Replenishment, Security systems.

• Gathered requirements from the client in meetings, preparing specifications, and then development, testing.
• Prepared Technical Specifications and Test Plans.
• Migration of RPG to ILE RPG.
• Experience on Supply chain management –Warehouse management solutions.
• Analyzed of problems sent by Onsite team.
• Customized code and Code modification.

Environment: IBM3720, AS/400 RPGIII, Source Convert, Actuate Developer Workbench, Window 98/NT, Visual source Safe, 4GL-Informix

Education Summary

• Masters of Technology
• Bachelors of Engineering

Recognition & Awards

• Received an Appreciation letter from client STOLT-CT the best results and on time delivery.
• Receive the BRAVO award for fixing the major balancing issue for reports in 2010 at Mapfre.