SUMMARY

• 8+ years of IT experience in Analysis, Design, Development, Testing, Implementation and Maintenance of business application systems for Financial, Health care and Aviation Sectors.
• Data Warehousing ETL and Reporting experience of using Informatica Power Center 9x/8.x/7.x, Informatica Power Mart (Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Task Manager),Cognos8 (Report Studio, Query Studio, Framework Manager)MS SQL Server 2000 /2005.
• Good knowledge in SDLC and worked on both Waterfall model and Agile methodology.
• Having expertise in working with various transformations in developing ETL mappings involving business validations and creation of sessions and workflows to load the target systems.
• Identifying the bottleneck and involved in performance tuning and optimization of ETL loads both at the mapping and the session level and also at the database level.
• Implemented error handling through Informatica. Worked with Pushdown Optimization and external loaders in Informatica to optimize the ETL Load.
• Having Good Knowledge in Reporting tool Cognos8 (Report Studio, Query Studio) in Developing Standard reports, List, Crosstab reports, Prompts, Charts, Master Detail Reports, drill through reports, Report Template, creating flat files.
• Having expertise in creating Adhoc reports in query studio using Published package.
• Implemented Slowly Changing Dimensions in most of the projects.
• Excellent understanding of Data Warehousing concepts and Dimensional modeling (Star Schema and Snow Flake Schema).
• Excellent understanding of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle, Relational, DB2, Teradata and SQL Server using Informatica.
• Proficient in analyzing business processes requirements and translating them into technical requirements.
• Excellent team player and can work on both development and maintenance phases of the project.
• Having knowledge of writing test plans and working with HP Quality center for executing the test plans, fixing the bugs and defects raised during testing.
• Worked on incident management tool (REMEDY) to track the status of all the incidents which are created by helpdesk and assigned to application support team.
• Have Good communication skills, excellent analytical, problem solving skills with a as strong technical background and good interpersonal skills with strong ability to perform part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica 7.x/8.x/,9x

OLAP Tools: Cognos 8, Knowledge of Business Objects (BOXI R2)

Database: Oracle 8i/9i/10g, Sybase, SQL server, PL/SQL, TeradataFlat files, XML, DB2 and Ms Access

Programming Languages: C, Core Java, RDBMS, XML, SQL, PL/SQL, Shell Scripting

Operating Systems: Windows XP/2000/NT/9x, Windows 98, UNIX (Solaris)LINUX

Document Tools: MS Office 2003/2007, MS Project 2003/2007

Web Technologies: HTML, Java Script

Tools: & Utilities TOAD, EDITPLUS, Erwin, Visio, Control - M, Autosys

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Lead Informatica Developer

Responsibilities:

• Performed business analysis and requirements per high-end users and managers and prepared design documents.
• Guided the team members through complex technical requirements.
• Coordinated the project tasks with the offshore team lead and ensured that the projects are completed on time.
• Developed an enterprise-wide policy Vouchering data warehouse to analyze the voucher hours of all employees for the client.
• Responsible for coding of mappings and unit testing and integration testing.
• Used SQL*Loader to first write the target rows to a flat file and then upload the data to the tables in the Oracle database.
• Worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Worked on various kinds of the transformations which were used to implement simple and complex business logic.
• As report author, Designed Standard reports, Ad hoc and drill through reports based on client requirements.
• Creating Union joins, Calculations, Conditions & Filters.
• Created Adhoc reports in query studio and also shared knowledge with users on Adhoc reporting to generate reports as per the business need
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target tables in warehouse using InformaticaWorkflow Manager..
• Tuning InformaticaMappings and Sessions for optimum performance.
• Designed and developed UNIX scripts for scheduling the jobs and generating parameter file automatically and Good knowledge of Control-M, Autosys job scheduling system.
• Translated business requirements into Informatica mappings/workflows.
• Worked with various transformations like aggregators, filters, connected and unconnected lookups, joiners, normalizers, source qualifiers, application source qualifier, update strategy etc.
• Created many reusable transformations using lookups, expressions etc.
• Designing technical specification document for all the developed mappings.
• Knowledge on Master Data Management,Transformation and Exchange using various databases.
• Co-ordinated among various teams like DBA, UNIX, Ops and testing team to get the database and UNIX environment setup for the release.
• Created and maintained all the release documents and migration forms for tracking reasons.
• Received numerous letters of recommendation, appreciation from customers and Business Management for the performance and almost all my developments went live as FTR (First Time Right) in the project.

Environment: Informatica 8.1, 9,Cognos 8, Flat files, Oracle 9i, SQL Server, UNIX, TOAD, PL/SQL and SQL*Loader

Confidential, Atlanta, GA

ETL/Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development and testing. Interacted with business analysts, data architects, application developers to understand the data model.
• Developed Data warehouse to view financial datal on year to date snapshot.
• Extensively worked on Informatica 7.1 and its tools; Repository Manager, Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor.
• Designed the strategies to load the data into the target Data warehouse. Responsible for design, developing and implementing the batch ETL system using UNIX scripting and Informatica.
• As report author, generated new simple list reports, Crosstab reports based on client requirements
• Scheduled reporting as per the business needs and also modified prompts to schedule few reports. I was given webinar on cognos for the whole team and on fixing issues.
• Fixing in complex data type issues, Performance tuning tasks and formatting issues always before the deadline.
• Implementation/Deployment of minor Enhancements/Changes Requested in ETL for the developed process.
• Implemented Slowly Changing Dimensions (SCDs, Type 1, Type 2 and Type 3).
• Worked with Oracle, Teradata, Relational, SQL Server, flat file and XML sources.
• Developed both usable and reusable tasks like Session, Email, Decision, Assignment, Command, Event Wait and Event Raise.
• Performed Exception Handling and executed Stored Procedures and Functions using PL/ SQL.
• Used SQL*Loader for bulk loading the data into the target tables.
• Implemented Performance Tuning for transformations to increase the session performance time.
• Used TOAD 8.0 to analyse the execution of SQL queries for performance tuning purposes.
• Worked extensively on SQL, PL/SQL, Perl and UNIX shell scripting.
• Used session and workflow error logs to debug the session and find problems in the mapping.
• Attending status meetings and swat calls. Worked in Production Support environment for the previous ongoing projects.
• Good understanding with all the team members for performing project task effectively
• Ability to work independently with minimal supervision and effectively meet project deliverables on time.

Environment: Informatica 8.1, Cognos 8, Oracle 8i/9i, XML files, Unix, Windows XP, TOAD 8.0, SQL Server 2000, SQL*Loader, PL/SQL

Confidential, Houston, TX

ETL/Informatica Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Worked on Informatica Power Center 7.1 tools - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager, Mapplets and Reusable Transformations.
• Developed InformaticaMappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Utilized aggregate, expression, lookup, update strategy and router transformation. Utilized joiner transformation to extract data from multiple sources.
• Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
• Used Utilized InformaticaServer Manager to create, schedule and monitor sessions and send pre and post session emails to communicate success or failure of session execution. Involved in performance tuning of sources, targets, mappings, transformations and sessions to optimize session performance.
• Provide technical support to Quality Assurance team and Production group. Used Repository Manager to add Repository, to create folders, User groups, Users and managed users by setting up their privileges and profiles. Troubleshoot problems by checking session’s logs.
• Generated new simple list and crosstab reports based on clients requirements.
• Developed Prompts for filtering the data
• Fixing tickets as part of production support and Ensuring On time Delivery.
• Involved in unit testing and system integration testing and preparing Unit Test Plan (UTP) and System Test Plan (STP) documents.
• Designing technical specification document for all the developed mappings.
• Worked on Change Requests (CR) while integration testing and UAT are in progress
• Has Successfully met 100% SLA in all the tasks assigned to me

Environment: Informatica 8.1, Cognos 8, Windows XP, Oracle 9i, DB2, Cobol files, TOAD 8.0, SQL Server 2000, SQL*Loader, PL/SQL

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in designing the specifications, design documents, data modeling and design of data warehouse.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Participated in Migration Applications in Cognos8.
• Actively shared the multiple projects functional specification knowledge with clients in data warehousing.
• Have worked on Proof of concepts in Data Warehousing, Reporting and ETL with different case study’s.
• Received numerous letters of management for the POC’s made and received accolades from Business Management for the performance in the project
• Created InformaticaMappings to load data using transformations.
• Implemented Slowly Changing Dimensions (SCDs, Both Types 1, 2).
• Cleansed the source, extracted and transformed data with business rules, implemented Boolean logic to address complex business requirements, and built reusable transformation logic, known as ‘Mapplets’ using InformaticaDesigner.
• Involved in the development of Informaticamappings and also performed tuning for better performance.
• Extensively worked on tuning and thereby improving the load time.
• Extensively used PL/SQL for creating packages, procedures and functions.
• Written Unix Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
• Tested the target data against source system tables by writing some QA Procedures.
• Created documentation for the Informatica processes, naming conventions and best practices.
• Shared Knowledge through sessions to ELTP’s. Conducted Competency tests to business unit’s associates based on their domain for testing knowledge.

Environment: Informatica 7.1, Cognos 8, Oracle and Windows XP.

Confidential

ETL Developer

Responsibilities:

• Attended knowledge transfer sessions for requirements gathering.
• Participated in the requirement definition and analysis in support of Data Warehousing efforts.
• Involved in the creation of Data marts using star schema.
• Transformations are created using Informatica tool and the sources included Oracle Databases and flat files.
• Created Stored Procedure functions on specific requirements.
• Performed data cleansing & Transformation fixing.
• Sophisticated transformations rules are implemented using Informatica features like Aggregation, Filter, Router, Expression, Sequence Generator, Lookup, Update Strategy, Stored Procedure and Source Qualifier.
• The data was standardized to store various Business Units in tables.
• Wrote test cases and involved in unit testing of mappings that I developed.

Environment: Informatica Power Center 6.0, Flat files, Oracle 8i, SQL, PL/SQL, Windows 2000 Server