SUMMARY

• Total 14 years of IT Experience working extensively on ETL tool - INFORMATICA Power Center & INFORMATICA Cloud
• Experienced in using IDQ tool for Data Profiling, applying Data Quality Rules and develop mappings to move data from source to target systems
• Hands on Data profiling, Score card preparation and Trend chart analysis
• Various kinds of GENERAL and DATA QUALITY transformations were used to implement simple and complex data quality rules
• Customized and Defining data alignment plan, including Data Mapping, Data Quality Rules, using Standardizer, Labeler, Parser, Match, Key Generator and Exception Transformation, Human Task, Exclusive Gateway Task, Notification Task, Command Task etc.
• Involved in migration of the mappings from IDQ to power center
• Involved in full life cycle implementations for different modules involving Development, Testing, and Documentation and Requirement analysis, Data loading and Production Support
• Extensive experience in client training in Data Warehousing and ETL. Conducted trainings and workshops for end-users and project team members
• Implemented Type 1, Type2, Type 3 slowly changing dimension mappings based on user requirements
• Ability to understand and implement complex business scenarios
• Knowledge in data modeling, Data warehousing, and data migration
• Scripting and coding experience including KSH, SQL, PL/SQL procedures/functions, triggers and exceptions
• Instant troubleshooting of Informatica jobs during quick-fixes
• Experience in addressing production issues like performance tuning and unique constraint errors
• Execution of test plans for loading the data successfully
• Strong database skills with DB2, Oracle and SQL Server
• Experience writing UNIX (AIX) Shell scripts and Perl scripting
• Worked on scheduling tools like Tivoli, Autosys
• Strong interpersonal, written and verbal communication skills
• Highly organized professional with strong technical skills

TECHNICAL SKILLS

ETL: INFORMATICA Power Center 10.x/9.x/8.x/7.x, Informatica Data Quality 9.x/10.x

Databases: HANA, Oracle 11g/10g/9i/8i/8/7.x, DB2, SQL Server

Programming: UNIX Shell Scripting, AIX, C, C++, SQL, PL/SQL

Environment: Windows NT/95/98/2000/XP/VISTA, UNIX, MS DOS

PROFESSIONAL EXPERIENCE

Data Conversion Lead

Confidential, Miami, FL

Environment: Informatica Power Center 10.x, MS Sql Server, Oralce, DB2, Power BI, Workday

Responsibilities:

• Leading the Unify project for GL Conversions area
• Work with business to understand the requirements
• Discussing the strengths and weaknesses of various alternative solution approaches with business
• Work with business to understand the Foundational Data Model and stage the data further to be used as reference data during the conversion process
• Work with Data Architects in laying out the design to implement business requirements
• Translate business requirement into technical documents
• Work with development team in getting the coding and testing done for the requirements
• Build reusable components which can be used across multiple areas and create Informatica mappings to implement complex business requirements
• Effectively use Informatica client tools - Source Analyzer, Warehouse Designer, Mapping Designer and Informatica Workflow Manager
• Work with team in preparing source to target mapping documents
• Attend daily status meeting with business to provide updates
• Closely work with business to identify the data gaps and variances
• Work with business in planning the data loads to Workday
• Provide UAT, bug fixes and deployment support
• Work with Business and Change Management team for pre-prod and prod cutover activities

INFORMATICA Technical Lead

Confidential - Madison, WI

Environment: Informatica Power Center 10.x, Informatica Cloud, Business Objects Data Services 4.0, Oralce, DB2, GreenPlum, Attunity, Autosys scheduling, WinSQL, SQL Developer

Responsibilities:

• Analyzing system and program requirements for complex Informatica projects
• Understanding the client’s ( Confidential ) business requirements in detail to plan and convert into technical requirements
• Analyzing database schemas and table volume
• Assessing the landscape and architecture of the existing databases including, environment, coding and integration standards
• Assessing design, build and Development Process
• Discussing the strengths and weaknesses of various alternative solution approaches with respective business units
• Working with the client and business analysts to finalize technical documents in order to start coding
• Discuss and review Development strategy
• Designs and develops specifications for complex or cross-functional systems and Data structures
• Working with business analysts for requirement gathering, analyze business functionalities, and translate the business requirements into technical specifications
• Interact/Meet with Development team, Program & Project Management; Architects & BA’s to understand release schedule, Business rule & scenarios for both Functional & System analysis
• Effectively use Informatica client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Informatica Repository Manager, and Informatica Workflow Manager
• Provide UAT support and deployment support
• Use the beneficiary’s expertise in UNIX shell scripting and automation of ETL processes using scheduling tool such as Autosys

INFORMATICA Technical Lead Consultant

Confidential - Minneapolis, MN

Environment: SAP ECC 6.0,SAP BI7.3, Informatica Power Center 10.2, Informatica Cloud, Informatica Data Quality 10.x, Business Objects Data Services 4.0, SAP HANA 1.X, SAP BOXI 3.1, SAP BO 4, Tivoli scheduling jobs and UNIX

Responsibilities:

• Interacting with clients to get the Business Requirements.
• Converting the Business Requirement Documents into Design Documents
• Design the Mapping Level Document
• Handling the development team.
• Doing the code Review and tune them for better performance.
• Writing the UNIX shell scripts and modifying the existing ones to run the mapping.
• Creating automation scripts to run the mapping using UNIX scripts.
• Writing the scheduling scripts in Tivoli to run the jobs on timely basis.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information
• Monitoring and troubleshooting data loads at Informatica & BODS
• Applied the rules and profiled the source and target table's data using IDQ
• Create Score cards and Trend chart analysis
• Created Mappings and Reusable Mapplets and rules in IDQ to cleansing, standardization and transform data
• Extensively used Standardizer, Labeler, Parser, Address Validator, Match, Merge, and Consolidation transformations
• Created human task workflow scenarios and IDQ scenarios to support data remediation
• Created and executed data quality specific ETL jobs(address standardization and validation, email cleans ups, name cleanup, parsing, etc.) utilizing IDQ and Informatica
• Developed matching rules help to determine best matching algorithm, configure identity matching and analyze duplicates
• Created Informatica workflows and IDQ mappings for - Batch and Real Time
• Extensively worked on performance tuning of Informatica and IDQ mappings

INFORMATICA Technical Lead Consultant

Confidential - Cary NC

Environment: Informatica 9.1, DB2, SQL Server, ICM and UNIX

Responsibilities:

• Check feasibility and usability of the source system interfaces
• Convert business requirements into detailed technical requirements
• Assess the source data systems, identify gaps versus requirements
• Create logical data mappings from the staging to the ODS layer
• Create logical data mappings from the ODS layer and ICM to downstream tables
• Conduct data mapping reviews with Confidential subject matter experts (SME)
• Develop data integration components to implement Staging, Transformation, ODS Load processes
• Unit test ETL processes and ODS functionality
• Involved in code reviews and integration testing to ensure high quality deliverables
• Responsible for supporting business users during UAT

INFORMATICA Technical Lead Consultant

Confidential

Environment: Informatica Power Center 9.x, Informatica Data Quality 9.x, DB2, Tivoli scheduling jobs and UNIX

Responsibilities:

• Implemented the Data Quality Rules based on the result of Data Profiling
• Worked on Score card preparation and Trend chart analysis
• Implemented Data Quality Rules, using Standardizer, Labeler, Parser, Match, Key Generator and Exception Transformation
• Involved in migration of the mappings from IDQ to power center
• Responsible to assign the task to the team and review the progress
• Responsible for providing regular updates to Management
• Responsible for communicating with Client to set up the process to deliver the files to ETL Server
• Created mapping to read data from emails using Power Exchange for email server
• Implemented Type 2 SCD
• Responsible for coordinating with the teams to gather the data issues and highlight them to the Client

INFORMATICA Support Specialist

Confidential

Environment: Informatica Power Center 8.5.1, Oracle 10g, SQL Server, DB2, Unix

Responsibilities:

• Responsible for supporting the applications to our customer in the healthcare project
• Deliver new and complex high quality solutions to clients in response to varying business requirements. Tasks like Event - Wait, Email and Decision are used
• Mapping client’s requirements and implementing processes in line with the guidelines specified by the client through ETL process
• Provided timely solutions to the service calls on priority, to improve troubleshooting efficiency

INFORMATICA Developer

Confidential

Environment: Informatica Power Center 8.1.1, Oracle 10g, Unix.

Responsibilities:

• Involved in analyzing high level design and prepared low level design specification document
• Involved in loading of data from flat files to stage and stage to Data Mart
• Used parameters and variables in mappings for extracting incremental data.
• Created Event Wait task for file watching to check whether all related files are present in the specified directory thereby kicking-off Session
• Implemented SCD Type-II as per business requirement