SUMMARY:

• Over 11 years of IT experience in ETL Architecture, Analysis, design, development, testing, implementation, maintenance and supporting of Enterprise level Data Integration, Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store(ODS)Data Warehouse (DW)/Data Mart (DM), ETL, OLAP, ROLAP Client/Server and Web applications on Windows and Unix platforms.
• Over 7 years’ experience in using Informatica Power Center 9.x/8.x/7.x Data Stencil, Designer, Repository Manager, Server Manager, Workflow Manager, Workflow Monitor including Administration and performance tuning of Informatica transformations/mappings/sessions/workflow's.
• Over 11 years of experience working in large scale data warehouse using Databases like Oracle 11g/10g/9i, MS Access 2000/2002, XML, IBM DB2, SQL Server 2000,Tera Data, MS Excel and Flat files.
• Over 11 Years of experience in using SQL, PL/SQL Dynamic SQL,Stored procedures/functions, triggers and packages, complex joins, correlated sub - queries, aggregate functions analytic functions, materialized views, indexing, partitioning and performance tuning the same using explain plan.
• Have Good understanding of ETL/Informatica standards and best practices, Confirmed Dimensions, Slowly Changing Dimensions (SCD1,SCD2,SCD3)
• Very good proficiency in Informatica Data Quality 9.5.1/9.6.1,
• Very good knowledge in Master Data Management.
• Experience in writing UNIX Korn shell scripting.
• Experience creating dimensions and cubes
• Experience in Data Quality Analysis, Data Profiling, Data cleansing and Master data management
• Experience in testing coordination, writing test cases and executing test scripts, And logged defects in HP Quality Center(QC),StarTeam
• Maintaining and Supporting during Assembly/Integration Test, QA, UAT, and Production for Issues/Bug fixes/Defects.
• Good Experience in Power Center Administration Support (Installation, Configuring, Tuning, Administration).
• Experience on Node, Grid and High availability configurations, Setup LDAP authentication Security in Informatica.
• Experience in all phases of agile System Development Life Cycle(SDLC)
• Excellent team player with very good communication skills and leadership qualities.
• Experience with coordinating and leading onsite-offshore development. Efficient team player with excellent communication skills and good interaction.
• Good experience in working as Lead managing small and large teams as well.
• Excellent analytical, problem solving skills with strong technical background and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Information Data Quality 9.5.1/9.6.1, Informatica Analyst tool 9.x and Informatica Power center 9.x/8.x

Scheduling Tools: Autosys, Control-M, Tivoli, and DAC.

RDBMS: Oracle 11g/10g, MS SQL Server 2008/2005, DB2 v8.1, Teradata 14.

Reporting Tools: Business Objects XI. Crystal Report 9.

Languages: SQL, PL/SQL, UNIX, XML, PERL

Programing Languages: C, XML, Java, and J2ee.

Data Modeling Tools: Erwin, MS Visio

Web Servers: WebSphere, WebLogic.

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS, Z-OS

EXPERIENCE:

Confidential - MI

Senior Data Warehouse /ETL/Informatica Developer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents
• Extracted data from excel files, high volume of data sets from data files, Oracle, DB2,SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
• Created re-usable transformations/mapplets and used across various mappings
• Wrote complex PLSQL scripts /functions/procedures/packages
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created Tidal jobs to schedule Informatica Workflows
• Executed workflows using Tidal scheduler
• Wrote Unit Test cases and executed unit test scripts successfully.
• Involved in performance tuning of Informatica code using standard informatica tuning steps.
• Involved in the performance tuning of SQL/PLSQL scripts based on explain plan.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Wrote UNIX Korn shell scripts for file transfer/archiving./Email notifications.
• Schedule daily backup of Informatica environment, restore Informatica environment when required.
• Administer projects, roles, user, and privileges across all three environments, Configure and setup LDAP security integration with Informatica, Load balancing of the ETL services
• Provided 24/7 production support to all the ETL Informatica applications and Projects.
• Involved in code Reviews as per ETL/Informatica standards and best practices.

Environment: Informatica 9.6.1(Repository Manager, Admin Console, Designer, Workflow Manager Workflow Monitor), Toad, Oracle 11g, UNIX, SAP BO

Confidential

Senior Data Warehouse /ETL/Informatica Developer

Responsibilities:

• Extensively worked on Informatica IDE/IDQ.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data.
• And extensively worked on IDQ admin tasks and worked as both IDQ Admin and IDQ developer.
• Performed many multiple tasks effectively and involved in troubleshooting the issues.
• Created references tables, applications and workflows and deployed that to Data integration service for further execution of workflow.
• Played a very important role in team in development of mappings, workflows and troubleshooting the issues.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality 9.1 environment
• Develop MDM solutions for workflows, de-duplication, validations etc., and Facilitate Data load and syndication
• Worked on deploying metadata manager like extensive metadata connectors for data integration visibility, advanced search and browse of metadata catalog, data lineage and visibility into data objects, rules, transformations and reference data.
• Used IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.

Environment: Oracle 11g, PL/SQL, Informatica Data Quality 9.x, IDQ admin console, UNIX.

Confidential

Senior Data Warehouse /ETL/Informatica Developer

Responsibilities:

• Involved in business requirement analysis and design, prepared functional and technical design document
• Involved in creating logical, physical data models for cleansing model
• Involved in data profiling, data quality and data cleansing and metadata management
• Extracted data from Salesforce.com(SFDC),Oracle, excel, data files using Informatica ETL mappings/SQL PLSQL scripts
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to Cleansing area
• Wrote complex PLSQL functions/procedures/packages
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Wrote Test cases and executed test scripts in Cleansing area
• Involved in performance tuning of Informatica code and PLSQL scripts
• Supported during QA/UAT/PROD deployments
• Wrote UNIX Korn shell scripts for file transfer/archiving.
• Involved in Reviews as per ETL/Informatica standards and best practices
• Created Autosys JIL files and executed to generate Autosys Jobs.
• Scheduling of Informatica workflows/sessions using Autosys

Environment: Informatica 9.5.1(Repository Manager, Admin Console, Designer, Workflow Manager, Workflow Monitor), Toad, Teradata, Oracle, UNIX, Autosys.

Confidential

Data Warehouse /ETL/Informatica Lead

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database instar Schema
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.
• Performed Power Center User Administration, Folder creation and User access control
• Performed Code Migration across various environments like DEV, TEST, STG, and PROD. Informatica SCM(Folder Level migration/Object Level Migration)
• Informatica object Migration using Repository Manager
• Informatica Administration activity(by using Admin console)
• Hotfix Implementation.
• Performed root-cause analysis for production issues across multiple projects, and implemented code fixes (if needed) for same

Environment: Informatica Power Center Designer 9.5.1, Informatica Repository Manager, TeraData14, Erwin, oracle 10g, DB2, TOAD, and SAP Version: 3.1.H, Unix- SunOS, PL/SQL, and SQL Developer

Confidential

Senior Data Warehouse /ETL/Informatica Developer

Responsibilities:

• Gathered business scope and Technical requirements.
• Worked with Power Center Designer tools in developing mappings and mapplets to extract and load the data from flat files and Oracle (source) to Oracle (target).
• Extensively used All Fusion-Erwin for Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator
• Created reusable transformations and mapplets to use the transformation logic in multiple mappings
• Worked on Repository manager to create and manage user profiles.
• Scheduled Sessions on the Informatica Server using Informatica workflow Manager
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Extensively used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router and Joiner transformation.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage
• Involved in fine Tuning queries for better performance (includes indexing and pre-joining and materializing views).
• Created views and altered some of the Dimensional tables to satisfy their Reporting needs.
• Created reports like, Reports by Department, Reports by Supplier, Reports by Period, Demographic reports and Comparative reports
• Created different types of reports such as Master/Detail, Cross Tab and Chart.

Environment: Informatica Power Center 9.1(Repository Manager, Admin Console, Designer, Workflow Manager, Workflow Monitor), Toad, UNIX, TeradataR14

Confidential

Informatica Developer

Responsibilities:

• Involved in System Study and Transferred knowledge to offshore team
• Involved in production support and ensured ETL processes works as expected
• Involved in researching and resolving production issues
• Involved in technical supporting, troubleshooting data warehouse application to meet Service Level Agreement (SLA's)
• Handling of CR's (Change Requests) and enhancements for existing application and followed change management process
• Understanding the business requirement specifications provided by the client.
• Involved in Data Quality, Data profiling, Data Cleansing and metadata management
• Performing impact analysis and handling ETL change requests based on the business rules.
• Created design specifications for ETL coding and mapping standards
• Created complex mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to staging area.
• Wrote PLSQL procedures/Functions and called from Informatica
• Involved in test data preparation for all releases.
• Wrote Test cases and executed test scripts in Data warehouse
• Establish performance and tuning methods for mappings, workflows
• Distribution of work to onsite and offshore team and follow-ups.
• Reviewing the work and submitting the work to client with sufficient documentation
• Created timelines for project completion and cost estimation.

Environment: Informatica Power Center 8.6.1, Orcle10g, Windows2000, Autosys, HP Quality Center, WinSCP.

Confidential

Sr. Java Developer

Responsibilities:

• Involved in Developing of Application based on J2EE using Struts, Hibernate and spring frameworks.
• Involved in all the test cases and fixed any bugs or any issues identified during the testing period.
• Involved in writing detailed Functional document and Technical document identify integration points and review technical specifications created by other developers with the team and across interfacing teams.
• Used apache-maven tool to build, configure, and package and deploy an application project.
• Used Sub version to maintain different versions of application code.
• Involved in fixing the production defects.
• Created deployment guide for Production.
• Deployed application ears on IBM WebSphere Application Server Network Deployment in Development, System Test and Performance Test on a daily basis and troubleshoot various configuration and application issues.
• Configured WebSphere resources such as JDBC Providers, Data Sources and Connection Pooling and administered performance tuning.
• Configured Admin console security on WebSphere and creating users with various roles to access the WebSphere admin console users and groups and added them in LDAP Console Groups using Admin console.
• Configured SVN and implementing project

Environment: Java, Servlets, JSPs, Struts1.x, XML, IBM WebSphere, MyEclipse, Oracle, SVN

Confidential

Java Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
• Worked on all phases of application development to implement the assigned use cases successfully.
• Deployed the application on IBM Web Sphere application server.
• Involved in coding for different modules by using JSP, Servlets.
• Involved Bug Fixing and Migrating the Application in Different Environments.
• Deployed application ears on IBM WebSphere Application Server Network Deployment in Development, System Test and Performance Test on a daily basis and troubleshoot various configuration and application issues.
• Configured WebSphere resources such as JDBC Providers, Data Sources, and Connection Pooling and administered performance tuning.
• Configured Admin console security on WebSphere and creating users with various roles to access the WebSphere admin console users and groups and added them in LDAP Console Groups using Admin console.
• Developed Crystal Reports based on user requirements
• Deploying and Configure Reports in BO Server
• Developed Crystal Reports and deployed in BO Server.

Environment: Java, J2EE, JSP, IBM Web Sphere Application server, My Eclipse, JavaScript, Oracle 9i, JDBC, SVN, Crystal Reports 9.