SUMMARY

• Over 9 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Financial, Health care and Pharmaceutical Sectors.
• Strong Data Warehousing ETL experience of using IICS and Informatica PowerCenter 10.X, 9.x Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Integration Service, Repository Service manager.
• Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Expertise in ODS, OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.x,8.x (Power Center) (Designer, Workflow Manager, Workflow Monitor and Repository Manager) and Business Objects.
• Expertise in working with relational databases such as Teradata 13.0, Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0 and MS Access
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Ability to work effectively in a rapidly changing, individual, team-based environment. Experience working in Agile environments.
• Proficient in creating documentation like LLD, HLD, Project end User Manual and Operations Hand off guide
• Excellent communication and collaboration skills with business and technical communities
• Ability to handle multiple tasks with minimal supervision and work effectively within a team or independently

TECHNICAL SKILLS

ETL TOOLS: Informatica Power Center 9.x/8.x (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), Data Stage.

Scripting Languages: VB Script, Java Script

CRM: Remedy, Siebel and Salesforce

Databases: Teradata 13.0, Oracle 11g/10g/9i/8i, DB2 v8.1

Operating Systems: Windows XP/2000/NT, UNIX, LINUX and AIX.

Applications: MS Office, MS Project and MS Visio.

Programming Languages: UNIX Shell Scripting, SQL, Turbo C and HTML

Scheduling Tools: Autosys, Tidal

Testing Tools: Load Runner, Quality Center, Test Director

PROFESSIONAL EXPERIENCE

Confidential, MI

Informatica Admin

Responsibilities:

• Worked on multiple projects, mainly supporting data loads inbound and outbound from Salesforce application and EDW.
• Extensively worked on projects to load data into Salesforce and extract data from Salesforce.
• Created Mapping, Mapping Tasks and Task flows based on the requirements.
• Worked closely with data analyst team on requirements/ data profiling.
• Created complex data mappings to accommodate the business requirements.
• Used various transformations like Joiner, Aggregators, Connected & unconnected lookups, Union, Filters, Sequence generators, Routers, Expression, Sorter etc.
• Modified existing mappings for enhancements of new business requirements.
• Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets.
• Developed SQL Scripts and ad-hoc queries for data verification, validation and reporting.
• Converted existing power center objects to IICS mappings.
• Deploy the code between DEV, SIT, UAT and Prod environments.
• Worked closely with data molders in the design and database changes.
• Created production transaction documents and project related documents.
• Documented Release management process, ETL migration and Database changes.

Environment: IICS, Informatica 10.2.0/9.6.1 , Informatica MDM 10.1.0, WINDOWS 2012, LINUX 6.7, Oracle 12c/11g, Sql Server, Informatica PowerExchange 10.2.0

Confidential, TX

Informatica Developer

Responsibilities:

• Worked closely with Project Teams and SME's to clarify business requirements and translate the requirements into technical specifications.
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
• Worked on different subject areas like Membership, Claims, Provider and Capitation. performed necessary transformations as per the business requirements and loaded the data in to the final target EDW.
• Developed Teradata BTEQ scripts to populate target tables, performed impact analysis, data profiling, data mapping, data loading, and data validation
• Worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Used various transformations like Joiner, Aggregators, Connected & unconnected lookups, Union, Filters, Sequence generators, Routers, Expression, Sorter etc.
• Modified existing mappings for enhancements of new business requirements.
• Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets.
• Developed SQL Scripts and ad-hoc queries for data verification, validation and reporting.
• Wrote UNIX shell scripts commands for FTP of files from remote server and backup of repository and folder.
• Managed QA and PROD deployments and automation of ETL Jobs.
• Provided 24x7 support for production operations (incident break/fix, change, service request, project, and databases)

Environment: Informatica 9.1/9.5, Teradata 13.0, SQL server 2008, SQL Assistant, Facets 4.5, FLAT FILES, Tidal, Jira.

Confidential

Informatica Developer

Responsibilities:

• Created and Maintained the Repositories using Power Center Web Based Administration Console.
• Used the Web Based Administration Console to manage of Data Sources distributed across the Network
• Used the Web Based Administration Console to Create User Accounts Privileges for each user and also to create Database Connections.
• Extensively worked with Informatica to load data from different sources to target database.
• Extracted and Processed data from various sources like Flat Files and Relational Databases.
• Monitored the Workflows using the Web Services Hub.
• Worked with the team on System Performance optimization issues
• Documented all errors and the solutions implemented
• Documented the complete ETL Process along with the Performance Issues
• Defined the process to convert Cognos data manager/decision stream ETL to Informatica 8.6.
• Created various Transformations like Expression, Joiner, Lookup, Filter, Stored Procedure and Router for implementing core data validations and business rules.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Involved effectively in defining new ETL solutions by analyzing the existing code and on time delivery.
• Involved in the Development of different mappings and tuned for better performance.
• Deployment to Production, Scheduling the Informatica Jobs through UC4 and Warranty Support for the Deliverables.
• Documented Release management process, ETL migration and Database changes.
• Preparation of Test Plans and testing with the same.
• Extensively worked with Flat files and Database tables.

Environment: Informatica Power Center 8.6.1/8.1.1 , Test Director, IBM-AIX, Windows 2003, Oracle 10g/9i, DB2 UDB