PROFILE:

• Confidential has 13 years of IT experience in ETL Architecture, Development, Enhancement, Maintenance, Production support, Data Modeling, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses for Insurance and Banking domains.
• Implemented ETL/Informatica architecture for Data Warehousing projects which includes creating data lineage, relational database objects, data modelling.
• Working with Informatica suite of products for 10 years. Architecture, Design, development, ETL deployment with various versions of Informatica, Informatica PowerCenter 10.2/9.6.1/9.1/8.6.1/7.1 , and Informatica power exchange 9.6/9.1, Informatica developer 10.1
• Experienced in Dimensional Data Modeling, Star Schema, Snow - Flake schema, FACT and Dimensions Tables.
• Experience in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, XML, VSAM, Mainframe Files, DB2, Oracle, SQL Server, Teradata.
• Automation, Scheduling and monitoring of jobs with scheduler AutoSys and Zena.
• Experienced in Agile Methodology and Waterfall methodology both. Worked in several areas of SDLC including Analysis, Requirement Gathering, Design, Development, Testing, and Implementation.
• He has played the role of scrum master.
• Experience in working with UNIX Shell scripts, Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• He has excellent technical and analytical skills, with sound understanding of relational data models & databases.
• He has also worked in production support teams with good experience in L1 and L2 support.
• Management skills include Team Management, Project Planning, Monitoring, and self-starter with good communication skills and ability to work independently and as part of a team.
• Ability to adjust to the people, circumstances & responsibility, with a Drive for results through self-motivation & self-candor.

TECHNICAL SKILLS:

Databases: Teradata, Oracle 11g, 12c, SQL Server, DB2

ETL Tools: Informatica PowerCenter 10.1, 9.6.1, Informatica Cloud, Designer, Informatica Workflow Designer, Repository Manager, Workflow Monitor, Informatica PowerExchange 9.6, Informatica Data Quality 9.6.1.

Scripting/Other skills: Unix/Linux Shell Scripting, Autosys (Job Scheduling), Zena scheduling, SOAP UI Tool, Microsoft Visio.

Test Management: HP ALM Mercury Quality Center

Operating System: Windows NT/95/98/2000/XP/7/8, UNIX/LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Bloomington, IL

Responsibilities:

• He has been the single point of contact for Informatica for all the Development and Support work under Billing program.
• He has been working closely with SME and business analysts and translated Business Requirements into technical specifications.
• He has been working with enterprise architect to create low level design documents and design ETL jobs and processes.
• He has been doing effort estimation and is responsible for gap analysis.
• He has developed complex mappings in Informatica to load the data from source files including xml sources. He has used different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure, Router, normalizer, webservice consumer, and Mapplets.
• Wrote test plans and executed it at UNIT testing and supported for system testing, volume testing and Integration testing
• He has developed ETL processes using XML sources and target and making SOAP calls using webservice consumer transformations.
• He has been working with multiple vendors and managing the offshore team of four members proactively.
• He is responsible for end to end process integration and deployment of modules to QA and production.
• He has been creating deployment documents and helping business with post implementation verification
• He has been providing warranty support for production.

Confidential, New York, NY

Responsibilities:

• Confidential has played a role of a Project lead and he had performed various responsibilities in this project.
• He was responsible for L1, L2 and L3 support for RADAR application which was a 24 X 7 application and required support on weekends.
• He conducted Implementation overviews to Business and performed Deployment activities in production and pre-production environments for Unix and Informatica which were biweekly.
• He was responsible for analysis of user issues on Radar application. engagement of upstream and downstream teams and defect tracking for closure of defects.
• He coordinated the releases and handled offshore team and by distributing work among them.
• He developed UNIX shell scripts to automate the Data Load processes to the target
• He did data cleansing and file validations for production files
• He was responsible for Automation, Scheduling and monitoring of jobs with scheduler AutoSys.
• Involved in preparing test strategy, test plan, test scenarios, traceability matrix, test reports and defect metrics.

Confidential, Charlotte, NC

Responsibilities:

• Talking to business stake holders, understanding and converting model requirement into technical specifications
• Design ETL methodologies to transform/move data across different Database
• Extracting product and corresponding rate information from different SORs and loading into Landing Zone incrementally using Informatica/ETL process. This data is further moved to Production Data warehouse in Texas and Virginia
• Worked on Design, Development and Implementation of Data movement effort for moving huge Confidential data to Data Warehouse.
• He also played the role of scrum master in this project.
• Post Development activities involving dry run testing and code deployment

Confidential

Responsibilities:

• Creation of new database model in Oracle.
• Designing new schema, tables, constraints, primary- foreign key relationships.
• Creation of Mapping, sessions and workflows in Informatica.
• Creation of Unix scripts to assist few processes developed in Informatica.
• Data comparison of source data and new Oracle tables.
• Creating status report, project trackers and effort estimation for modules.
• Prepared complex set of source to target SQLs to validate against the ETL jobs in Informatica.
• Involved in Defect Management and Tracking.
• Offshore lead for the project. He coordinated the work done by other team members.