SUMMARY

• Around 4 years of experience and expertise in Design, Development and Implementation of Data Warehouse and its applications
• Involved in the entire life cycle of Data warehouse design, development and Implementation
• Designed, constructed, maintained and documented Data Warehouses using Informatica PowerCenter/IDQ/Informatica Developer/Informatica Analyst/SSIS
• Strong noledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema
• Good noledge in analyzing the architectures (Inmon and Ralph Kimball).
• Working noledge on different data sources ranging from Flat files, Excel, Oracle, SQL Server, UDB DB2 databases, Sybase IQ, XML, and VSAM files
• Proficient in various databases like Oracle 11g/10g/9i/8.x, UDB DB2, MS SQL Server 2008/7.0/6.5 and strong noledge of database programming using SQL, PL/SQL.
• Excellent noledge of UNIX environments and has good noledge of UNIX Shell scripting
• Reviewed functional designs, technical designs, code reviews, test strategies, and implementation plans.
• Created test strategy documents for System, Integration, Regression testing and Unit test case documents.
• Involved extensively in System, Regression, Integration, and UAT testing.
• Working experience of Lean & Agile Strategy and Scrum Methodology
• Excellent communication, interpersonal and team organizing skills
• Excellent Analytical & Programming skills

TECHNICAL SKILLS

ETL tools: Informatica PowerCenter 9.x/8.x, IDQ 9.1.0

OLAP Tools: Business Objects XI R2, SAP Business Objects 4.0

RDBMS: Oracle 11g/10g/9i, MS SQL server 2008/7.x/6.x, Sybase, UDB DB2 11.x

Scripting: UNIX shell scripting

Procedural language: PL/SQL

Operating Systems: Windows NT/9x/2000/XP, UNIX, LINUX, SOLARIS, MS - DOS

Other Tools: TOAD, SQL Navigator, Control-M, Tidal, PVCS, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Louisville, Kentucky

ETL/Informatica Developer

Responsibilities:

• Analyze the Client requirements, understand the business process and coordinate wif the Business Analyst/Architect/Project lead and prepare ETL design doc
• Maintain Data Flow Diagrams (DFDs) and ETL Technical Specs or lower level design documents for all the source applications
• Developed slowly changing dimensional mappings for Type 2 dimensions.
• After the code was developed SQLs were sent to DBA reviews and made the necessary changes to finalize SQLs and Overrides.
• Developed many simple to complex mappings wif in a very short period and fine tuned the mappings before migrating to TEST and PROD
• Implemented Error Handling strategy to minimize the failures during the nightly process and either addressed or re directed to the right support team
• We even queried the metadata stored in the views of the Repository for any impact analysis of informatica objects changes.
• Extensively used Mapplets, Reusable transformations for the common business logic across the mappings and normalizer and sql transformations were also used.
• Informatica Versioning was turned on for DEV environment and we extensively used this feature by doing check ins and check outs and avoiding contingencies
• Involved in Informatica and Database objects migrations, filling the migration request forms and moving the objects up the environments.
• Performance tuning of the mappings, sessions, sqls and stored procedures was done before promoting the objects from one environment to other
• Collected and recorded the run stats and load testing was done by our testing team, Unit testing test cases were prepared for all the mappings we developed.
• Involved in the UAT and Integration testing wif Business Analysts and wifin a minimum ETA made required changes and ensured the data integrity and quality.
• Suggested constraints, indexes and partitions on the tables in order to improve the performance of the queries.

Environment: Informatica Powercenter 9.6.1, SQL Server 2008, UDB DB2,Oracle 11g, SQL Server 2008 Management Studio, TOAD 5.0.2, Control-M, HP Quality Center, SAP Business Objects 4.1

Confidential, Newark, NJ

ETL Developer

Responsibilities:

• Analyze the Client requirements, understand the business process and coordinate wif the Business Analyst/Architect/Team lead and prepare ETL design document.
• Involved in designing and developing logical & physical data models to support strategic business decisions using Erwin 4.1
• Implemented Slowly Changing Dimensions (SCD-1 and SCD-2) for loading the dimension tables.
• Extensively used the transformations like Router, Aggregator, Normalizer, Connected and Unconnected Lookups, and reusable transformations.
• Created User Defined functions and Mapplets where ever their is redundant logic dat can be used across the mappings.
• Resolved performance issues by doing test runs and incorporating tuning measures like joining tables in SQL override rather than Joiner, keeping the Filter as close as possible to the source, using unconnected lookup, optimize SQL overrides, increasing target commit intervals etc.
• Apart from setting the ‘Stop on Errors’ properties in session we even used to handle the errors (Error Handling) in mapping level by routing the errors or discrepancies to a flat file or Data Maintenance Log tables.
• On regular basis used to write many UNIX scripts especially for FTP, Concatenation of files like header and data files, delete huge files from the server to retain some space, etc.
• Used to import the Source and Target definitions to the ETL SHARED OBJECTS folders to reflect the changes of the underlying database table structure.
• Designed and developed mapping templates to load data from source to stage, stage to ODS and ODS to ADS.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Closely worked wif the QA team as well as wif UAT team in order to fix any code defects or to in corporate new design changes wifin a short time.
• Worked wif PVCS (version control), Autosys (scheduling) and Test Director (to trace defects).
• Coordinated wif the Business Objects developer in creating the Universe and reports. Business Objects interfaces wif the IDM ADS, which contains the Analytical Data used for reporting.
• Involved in noledge transfer and training to production support team

Environment: Informatica Powercenter 9.6, DB2 UDB 10.5, Oracle 11g, DB Visualizer Personal .*, Visual Explain Version 8, Hummingbird Neighborhood Version 10.0.0.0, Unix Solaris 8, DB2 Command Center, SQL Navigator 7, Business Objects XI Release 2, Autosys 11.0, Erwin

Confidential, Fort Wayne, IN

Programmer Analyst

Responsibilities:

• Analyze the Client requirements, understand the business process and coordinate wif the Business Analyst/Architect/Project lead and prepare ETL design doc
• Involved in the design of Functional Design Specification and Technical Transformation Design Technical Specification and getting a sign off from business
• Presented a prototype for the entire ETL flow and Job Scheduling by using sample files and mock up data and reviewed the results wif the team to come up wif any changes
• Incorporated and made changes to the LFG Informatica ETL Standards and Autosys Standards
• Extensively used Mapplets, Reusable transformations for the common business logic across the mappings and normalizer and sql transformations were also used.
• Data Quality checks were done and Data Cleansing rules were applied on the data coming from the flat files before loading into the staging area and core DI Hub, ODS.
• Extensively used Error handling strategy to log the errors and reject the file if the errors has reached the threshold during our simple and combo edit check file loading the Financial Detail and Summary tables
• Developed the Stored Procedures required for the project, which even involves creation of readymade procedures for doing impact analysis, data points check across the tables.
• Wrote Unix Scripts to send archival files (ftp) from one server to other server, delete huge files from the server to retain some space, did checksum validations, did duplicate file check, Header Row count, Credit debit validations
• Involved in the conceptual and logical database designing for Data integration Hub and ODS
• Logged the open issues and decisions in the Raid Log(Risk, Issue, Assumptions and dependencies) and made sure actions items were addressed by right persons and closed
• Involved in Informatica and Database objects migrations, filling the migration request forms and moving the objects up the environments.
• We followed Lean agile Strategy as this project is time critical, which helps in achieving the timelines by removing the communication gap between the business users and the developers.
• Performance tuning of the mappings, sessions, sqls and stored procedures was done before promoting the objects and long running jobs in production were tuned from time to time.
• Coordinated wif the Business Objects developer in creating and enhancing the Universe and reports

Environment: Informatica Powercenter 9.1, DB2 UDB 8.1,Oracle 11g,Peoplesoft, PL SQL Developer, Embarcadero, Hummingbird Neighborhood Version 10.0.0.0, Unix Solaris 8, Erwin 7.2, Serena PVCS 8.2, Business Objects XI R2, HP Quality Center 9.2, Powercenter Data analyzer, Autosys 11.0

Confidential, Portsmouth, NH

Informatica/ETL Consultant

Responsibilities:

• Analyze the Client requirements, understand the business process and coordinate wif the Business Analyst/Architect/Project lead and prepare ETL design doc
• Analyze the root cause of the issues logged by the Data Governance team in to the ITSM tool.
• Propose two to three solutions to fix the issue in an efficient way and go over wif the Data Governance team to select one best solution.
• Build the design documents related to the ITSM and lay out the data flow diagrams, root cause and the solution for the ITSM.
• Did thorough impact analysis before we suggested any changes to the existing mappings or procedures and proposed changes to the impacted down streams.
• Always communicated the downstream applications for any data or structural changes we made so dat they can do their impact analysis.
• Backfills are implemented on needed basis and filled the gaps created by the changes to the old or existing logic.
• For some releases developed the mappings and written unit test plans which involved unit testing and regression testing and reviewed them wif the team and testing team before promoting to the integration environment.
• Build the deployment plan for every release to consolidate all the objects and backfills to the upper environments and laid out the execution plan.
• Filled the required migrations documents related to Informatica and Autosys after we review the code wif the peers and label the Informatica objects.
• We constantly monitored the cycle run times and looked into the long running jobs and did performance tuning in order to meet the SLAs
• Extensively used reusable transformations and mapplets to reduce the redundancy of the logic implementation.
• Used parameter files for our incremental loadings and error handling strategies by using mapping parameters and variables.
• Maintained all the standards and implemented the best practices in our development process.

Environment: Informatica Powercenter 9.1,Oracle 11g, Business Objects XI R2, SQL Server 2008, Rapid SQL, SQL Developer, Windows 7, Sharepoint 2010, Unix Solaris 8, Autosys 11., Service Now