OBJECTIVE:

• To be a part of the challenging environment that can give me the growth potential and provide exposure to project delivery.

SUMMARY

• Over twelve years of experience in Banking and Financial Services & Healthcare domain in IT Service Management
• Effective team leader with strong interpersonal, communication and presentation skills
• Self - starter with a positive attitude, willingness to learn new concepts
• Strong analytical skills focused on improving the speed and effectiveness of service management
• Extremely Process Oriented. Wealth of experience in adhering to ITIL standards.
• Experience in Software Configuration Management, Build/Release and Deployment Management and Change/Incident Management.
• Expertise in development and designing of ETL methodology for supporting data transformations using Informatica Powercenter 10.x/9.x/8.x
• Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, and reusable transformations using Informatica Power Center
• Strong work experience in data mart life cycle development, performed ETL procedure to load data from different sources into data marts and data warehouse using Powercenter Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor
• Extensive Knowledge in Architecture design of Extract, Transform, Load environment using Informatica Power Center.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions

TECHNICAL SKILLS

• UNIX (AIX), Windows, Linux
• WebSphere Application Server V7.0, Weblogic Server 10.3.6 and 12.1.1, Windows Application Server
• Concurrent Version System(CVS), TFS Visual Studio, Github
• Oracle 11g, Apache Hive, SQL Server
• Informatica 10.x/9.x/8.x,, SQL Developer, Opcon Scheduling Tool, Attlassian JIRA, Putty, Eclipse, IBM Managenow, Gomez, Event Analyzer, Consult, Control-M, Remedy, Rapid SQL 8.1.0, CGSD(CG Software Distribution), Hadoop® Infrastructure of Hortonworks Data Platform (HDP®)

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead

Responsibilities:

• Integration of datasets from various data sources originating from RDBMS and Big Data technologies by leveraging the latest technologies/tools such as Hadoop, Hive
• Analyzed and helped Data modelers in Logical and Physical models for project.
• Demonstrated proficiency with large-scale databases and database languages (SQL, Hadoop)
• Responsible for Design, Development and Unit Testing of ETL processes.
• Responsible for providing specific files in specific file format for generating Reports.
• Managed and compiled documentation for all ETL processes.
• Worked on projects of moderate to high complexity across two or more development environments, worked on multiple projects as a Team lead & Developer
• Closely involved with testing team for INT, SAT, UAT and Load testing for resolving bugs.
• Involved with team in code migration and deployment.
• Worked closely with team lead and other team members for fixing the bottlenecks.

Confidential

Senior Informatica Lead Developer

Responsibilities:

• Participated in design sessions where decisions were made involving the transformation from source to target.
• Successfully lead teams to successful completion of Initiatives.
• Analyzed and helped Data modelers in Logical and Physical models for project.
• Responsible for developing various data extracts and loading routine using Informatica and Oracle.
• Responsible for Design, Development and Unit Testing of ETL processes.
• Responsible for providing specific files in specific file format for generating Reports.
• Managed and compile documentation for all ETL processes.
• Designed and implemented the Exception handling and Restartability strategy for ETL team.
• Monitored data warehouse month-end loads to ensure successful completion.
• Involved in Performance tuning of Informatica Mappings and Sessions for optimizing performance.
• Closely involved with testing team for INT, SAT, UAT and Load testing for resolving bugs.
• Involved with team in code migration and deployment.
• Worked closely with team lead and other team members for fixing the bottlenecks.

Confidential

Senior Informatica Developer

Responsibilities:

• Collaborate with Techno-Functional Lead to understand the requirements and design ETL for the data warehouse
• Work with data modelers and DBA’s to design the dimensional model
• Document technical analysis and design of ETL processes and testing of those processes.
• Help the team to overcome issues, challenges in ETL process.
• Create Validation scripts for the ETL load
• Coordinate the project tasks with the team and ensured that the projects are completed on time.
• Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
• As a value added measure, created a new “Validation Tool” from scratch that validates whether the incoming data complies with the new T-MSIS format or not.
• Confidential is also considering making it a proprietary tool and to sell it to other states.