SUMMARY:

• Enterprising professional with over 7 Years of experience across Production Support, ETL Architecture and Development
• Drove effective testing of Data Warehouses and Database Business Systems across verticals including Life Science, Healthcare and Health Insurance
• Expertise in concepts of end - to-end project planning & implementation from scope management, to activity sequencing, effort, risk analysis to quality management in line with norms
• Problem solver with a passion for technology with skills in grasping the big picture and applying appropriate technology/ mix of technologies that meet business needs while minimizing risks
• Extensive project management experience, proficient in gathering requirements , developing, implementing solutions, partnering closely with stakeholders to achieve higher levels of efficiency and effectiveness
• R ich experience in managerial activities entailing rendering technical leadership & guidance to the team members, planning, scheduling tasks, and holding analytic discussions with different functions & management for reviews and analysis.
• Introductory knowledge of Big Data concepts.

SOFT SKILLS:

• Communicator Innovator
• Thinker
• Collaborator Intuitive

KEY SKILLS:

• Requirement Analysis
• Data Modelling
• Unix Scripting
• Informatica
• Mainframe Scheduler
• IT Project Management & Execution
• Application Development
• Gap Analysis
• ETL Architecture & Development
• Agile/Scrum Methodologies
• Oracle (PL/SQL)
• Stakeholder Management

IT SKILLS:

Data Warehousing: Informatica Power Centre 9.6.1/9.5.1 HF4, Star and Snowflake Schema

Dimensional Data Modelling Tools: Dimensional Data Modelling, Data Modelling, Star Schema Modelling, Snow- Flake Modelling, Fact and Dimensions Tables, Logical and Physical Data Modelling

ETL Tools: Informatica Power Centre

Reporting Tools: SAP-Business Objects, BI-4.0

Databases: Oracle 11g/10g, MS SQL Server 2008, DB2

Scheduling Tools: NCA 3270 Mainframe Scheduler, Informatica Scheduler

Operating Systems: UNIX, Linux, Windows XP/7

PROFESSIONAL EXPERIENCE:

Confidential

ETL/Informatica Developer

Responsibilities:

• Steering the maintenance and enhancement of contact centre operations by monitoring system performance
• Identifying and resolving problems, developing and implementing action plans and rendering assistance in successfully completing system audits and analyses
• Tracking emerging trends in contact centre operations management; attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices
• Participating in project planning sessions with Project Managers, Business Analysts and Team Members to analyse business requirements and outline the proposed solution
• Finding new process, determining gaps in existing process and implementing new processes; participating in design reviews and contributing in allocation of functionality to specific system components
• Ensuring that the project delivery team structure is adequate and enforces compliance, best practices, approach & direction for the technical aspects of the organization's practice; providing technical leadership
• Simulating, designing, developing & deploying computationally complex and practical data; building and delivering comprehensive data strategy roadmaps; ensuring final deliverables are of the highest quality
• Establishing architectural roadmap, direction and work packets for ETL needs
• Implementing detail layout of ETL testing plan procedures; designed Audit Balance and Control for ETL process
• Preparing mapping documents that assisted the ETL Team to build effective and efficient mappings
• Managing the migration process from development, test and production environments; established standards for naming conventions and best practices for Informatica Mapping Development.
• Efficient team player with excellent communication skills and good interaction with end users.

Confidential

Responsibilities:

• Analysing requirements by going through requirement document and through meetings with Business Analysts
• Developing High level and low level design document and presenting to Solution Architect and Client.
• Coordinating with Offshore team members on daily basis for tasks
• Managing and directing discussions with EDA for Database tables design
• Leading the creation of Source to Target mapping (STM)
• Designing new mappings and enhanced existing ones according to the business requirement
• Testing the mappings and ensure that the mappings do the transformations as proposed.
• Managing daily calls with other technology experts to discuss the end to end flow of project.

Confidential

Responsibilities:

• Understanding requirements by going through requirement document
• Creating High level and low level design document and presenting to client
• Creating Source to Target mapping (STM)
• Created new mappings and enhanced existing ones according to the business requirement
• Responsible for testing the mappings and ensure that the mappings do the transformations as proposed
• Estimating the work and converting into efforts per day per resource.

Confidential

Responsibilities:

• Executed Business Analysis, Requirements Collection and HLD creation
• Administered code designs to Client
• Coordinated with offshore team members for their queries on design, unit test cases and on other queries related to various day to day tasks
• Managed daily tasks status call with offshore team members
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Modified existing mappings for enhancements of new business requirements
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings
• Executed testing of the mappings and ensured that the mappings do the transformations as proposed
• Involved in creating tasks, Worklets workflows to load various dimensions that include Products, Product Categories.
• Developed mapping parameters and variables to support SQL override.
• Delegated to make it sure that team uses ETL basic standards to develop mappings
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatics Designer
• Involved in Performance tuning at source, target, mappings, sessions, and system levels
• Applied slowly changing techniques and Dynamic lookup techniques
• Defined Target Load Order Plan for loading data into Target Tables
• Resolved various Production issues of High Priority in very short span of time
• Authored for fixing production job failures
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Worked with other teams like Database Administrators and Informatica Admins to quickly resolve the production issues

Confidential

Responsibilities:

• Managed daily task status call with Onshore Lead
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Modified existing mappings for enhancements of new business requirements.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings
• Chaired testing of the mappings and ensured that the mappings do the transformations as proposed
• Involved in Creating tasks, workflows to load various dimensions that include Products, Product Categories
• Developed mapping parameters and variables to support SQL override
• Used existing ETL standards to develop these mappings
• Spearheaded various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatics Designer
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Applied slowly changing techniques and Dynamic lookup techniques
• Defined Target Load Order Plan for loading data into Target Tables
• Resolved various Production issues of High Priority in very short span of time
• Planned for fixing production job failures
• Prepared migration document to move the mappings from development to testing and then to production repositories

Confidential

Responsibilities:

• Developed SCD type 2 Informatica mapping to store group information
• Used concept of full outer join and MD5 function to compare between current and previous data
• Utilized Router group I/U, U and Flagging approach for maintaining historical data in target table
• Created various flat files (Header, Footer, Data file) and merged them for sending the information to third party vendor
• Developed Response job to update the response from third party vendor into our table
• Worked with DBA/Tech Archs to create target table, constraints in lower and higher environments
• Collaborated with Informatica Admin team to create relational connection in lower & higher environments, migration of code in SIT and prod environments
• Involved with mainframe scheduling team for automating the job
• Created UTP document, estimate sheet, SDM and worked with QA team for SIT support
• Catapulted on two minor/major enhancements of this project after implementation

Confidential

Responsibilities:

• Develop informatica mappings, workflows to load the data
• Worked extensively on fixed width flat files, relational tables and XML target file.
• Developed mappings to load 8 tables with PK-FK relationship. As flat file was used as source, most of the logic was implemented in informatica. Used basic and advanced transformations to implement required functionality.
• Developed error handling logic to compare source and target record counts & triggering email notification in case of mismatch.
• Worked on Mainframe JCL programming to UNZIP source file, format the file, FTP files from UNIX to windows, merging historical files & creating single file etc.
• Worked on Interfaces like Tibco, Pega and Mobility for Request/response for XMLs (email and push alerts).
• Worked with DBA/Tech Archs to create target tables, indexes, constraints, triggers, application users in lower & higher environments etc.
• Worked with Informatica Admin team to create relational, ODBC connections in lower & higher environments, migration of code in SIT and prod environments.
• Worked with mainframe scheduling team for automating the job.
• Created UTP document, estimate sheet, SDM and worked with QA team for SIT support.

Confidential

Responsibilities:

• Created Universe using Information Design tool using SQL Server and Oracle Database.
• Created BO report to calculate the risks associated with a particular study and highlight them with different font and colors
• Tested the report and created unit test case document.
• Regular client calls to showcase the work and get new requirements.
• Worked with other migration teams to migrate the reports from one environment to other environments.
• Daily Status Call within team

Confidential

Responsibilities:

• Monitored ETL jobs for all the applications
• Identified the reason and fixed jobs in case of failures
• Worked with Informatica Admin and DBA teams to resolve the production job failures
• Chaired Client calls for getting new Requirements for minor/major enhancement
• Administered requirement and design document to finalize the requirement and design
• Assessed tickets using HP Service Center with other teams for resolving job failures