SUMMARY

• Eight plus years of IT experience in the Data Analysis, Design, Development and Implementation of business application systems for a tier 1 Insurance client.
• Experienced in performing as a team player, team lead. Comfortable with Offshore Onsite Model.
• Strong experience in projects with Agile and Waterfall model execution.
• Strong Data Warehousing ETL experience of using Informatica 9.X/8.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager
• Extensive testing of ETL experience using Informatica 9.X/8.1(Power Center - Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Strong experience in Dimensional Modeling, Identifying Facts and Dimensions.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Confidential (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange as ETL tool on Oracle, DB2 and SQL Server Databases
• Strong Experience in upgrade Informatica upgrade and Oracle Database upgrade related projects.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using Oracle PL/SQL and SQL Server, TSQL.
• Experience in resolving on-going maintenance issues and bug fixes in Informatica sessions as well as performance tuning of mappings and sessions.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in using Automation Scheduling tools like Control-M.
• Guidewire Claim Center data model exposure.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Hands on coordinating Integration and UAT testing for all projects in the common testing environments.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Confidential 8.1/9.1/9.6/10.2 , Informatica Power Exchange, Change Data Capture (CDC)

Scheduler: Control-M

Databases: Oracle 9i/10g/11g/12c

Database Tools: SQL Developer & TOAD, Microsoft SQL Server Management Studio, SQL Plus

Scripting: UNIX Schell Scripting, Linux Shell Script, Oracle PL/SQL

UNIX Tool: SecureCRT, WinScp

Support Tool: BMC Remedy, Team track, ServiceNow

PROFESSIONAL EXPERIENCE

Confidential

Team Lead

Responsibilities:

• Discussed with Business to define and get the requirement on what is getting replaced by Workday for each feeds and type of feeds to downstream applications.
• Reviewed the current Data warehouse application design of impact analysis over current Accounting Center.
• Developed UNIX Shell Scripting to perform file transfer from workday server and change file formats, Load the files, Clean up files in remote server after successful loading.
• Developed SQL Loader control files, required Parameter files and Sql scripts to do certain jobs.
• Modified existing Informatica mapping in related to use of files as inputs.
• Updated many Sql jobs the current financial balancing logic as two different financials are sent part of Workday whereas currently receive single financials from Accounting Center.
• New data integrity checks logic created by UNIX shell scripts and PLSQL for many financial feeds from workdays.
• Leading team of 3 members from offshore.
• Co-ordination with Infrastructure teams for required code migration and environment set up.
• Co-ordination with vendors for data transformation dependencies from Legacy systems.
• Execution of all feeds in CUT for unit testing and in ETE for multiple integration testing and in DRT for UAT testing.
• Test and ensure the quality of the Oracle code, UNIX Shell Scripts, Informatica code to meet the test cases output.

Skill set: Oracle PLSQL/SQL, UNIX Shell Scripting, Informatica 9.6, Control-m

Confidential

Development Lead

Responsibilities:

• Discussed with Business Analyst for corresponding line of business to define and get the requirement on changes related to project requirements.
• Providing PIE which is initial estimations based on impacted items and provide the project plan with the resources.
• Scheduled multiple sessions and update the JIRA board to have stories and Sprint Planning for project with the timelines.
• Developed ETL workflows, SQLS, PLSQL jobs and UNIX Shell Scripting to construct the code for the requirements.
• Performed UNIT testing for each test cases written by QA for the project and Move the code to IT testing environments.
• Performed ETE testing and move to the code to DRT environment for UAT sign off and get ready for deployments.
• Attending daily Scrum calls with product owner and Scrum master to update on stories and Backlog grooming session to move the stories for next sprint and Retrospective sessions to review last sprint for what went well, what did not go wrong.
• Conduct daily offshore/onshore call to hand off the project activities.
• Leading team of 5 members from offshore.
• Co-ordination with Infrastructure teams for required code migration and environment set up.
• Co-ordination with other vendors for testing dependencies for the common testing projects.
• Ensure all code migrations activities planned and executed as per deployment checklists created for each project. Send communications emails to Business people post successful deployment and validations.

Skill set: Oracle PLSQL/SQL, UNIX Shell Scripting, Informatica 9.6 Power Center and PowerExchange, Control-m

Confidential

Onsite Lead

Responsibilities:

• Identified the impacted applications and gathered the list of Informatica Powercenter objects such as mapping and shared folder, workflows, worklets, sessions, mappings, relational and ODBC connectors, source and target objects for all applications.
• Validated and verified all objects against informatica Database.
• Worked with ETL Admin to configure required connectorsand ODBC set up.
• Worked with ETL Admin to set up and configure Integration Services, Group access PMRoot directories and soft links and file systems in informatica Servers.
• Worked with Linux Admin and DBA admin for the required file systems for applications on informatica Server and DBA commands set up in a way job to perform some DDL operations.
• Validate the migrated components done by ETL Admin for all objects in Powercenter and data maps from PowerExchange.
• Execution of UNIT testing and ETE cycle 1, cycle 2 testing for all application for CUT and ETE repositories. Execute performance testing as cycle 3 in DRT.
• Leading team of 15 plus as no of applications are high.
• The project followed waterfall methodology and was deployed by three phases

Skill set: Informatica 9.6.1, Informatica 8.1x, Informatica 8.6x, Oracle 12c, Oracle 10g, Sql server,UNIX Shell scripting, Informatica PowerExchange, Control-m