SUMMARY:

• 11 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Financial, Telecom and Timeshare Sectors.
• Strong 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.
• Strong Data Warehousing ETL experience of using Informatica 9.x/8.6.1/ Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Experience working on Data quality tools Informatica IDQ 9.x, Informatica MDM 9.x .
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin and ER-Studio.
• Expertise in working with various sources such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, Teradata, flat files, XML, COBOL, Mainframe.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, T-SQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Created pre-session, post session, pre-sql, post sql commands in Informatica.
• Worked with different Informatica transformations like Aggregator, Lookup, Joiner, Filter, Router, Update strategy, Transaction Control, Union, Normalizer, SQL in ETL development.
• Worked with Event wait, and event raise tasks, mapplets, reusable transformations.
• Worked with Parameter file for ease of use in connections across Dev/QA/Prod environments.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys, Tidal, Control-M, Tivoli scripts.
• Experience working with Power Exchange.
• Worked extensively with slowly changing dimensions SCD Type1 and Type2.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

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

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, MI

Sr 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 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 Tivoli jobs to schedule Informatica Workflows
• Executed workflows using Tivoli 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

Informatica IDQ 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.

Informatica/IDQ 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.
• Worked on UC4 as job scheduler and used to run the created application and respective workflow in this job scheduler in selected recursive timings
• Played a very important role in team in development of mappings, workflows and troubleshooting the issues.
• Worked very closely with SQA team all the time in order to fix the issues and completed tasks effectively in time and proceeded to production level.
• Very familiar about Sorter, Filter, Expression, Consolidation, Match, Exception, Association and Address validator transformations.
• 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

Environment: Informatica 9.x(Repository Manager, Admin Console, Designer, Workflow Manager, Workflow Monitor), Informatica Data Quality 9.x, Toad, Oracle, UNIX, Autosys.

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, Unix- SunOS, PL/SQL, and SQL Developer

Senior 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

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.

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

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.