SUMMARY:

• 7+ years of work experience in Information Technology as Informatica Developer with strong background in ETL Data warehousing and as Database Developer in MS SQL Server technology.
• Over 8 years experience in IT industry with an outstanding record of meeting project delivery deadlines. In depth understanding of requirement gathering, analysis, development and production support processes.
• Experience in using Informatica Power Center tools Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager, metadata Manager.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Extensive experience in Business intelligence tools like Business Objects, Cognos and OBIEE.
• Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat files, MS Excel, and XML files.
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake).
• Schema, FACT & Dimension Tables), OLTP and OLAP.
• Migration, up-gradation, Development, Administration and Support experience in Business Objects XI tool suite
• Strong hands-on experience in creating/enhancing Universes using BO Designer and in creating and maintaining reports using Business objects, Crystal reports, Web Intelligence, WebI Rich Client and Desktop Intelligence.
• Experience inbuilding, enhancing and managing Universes, creatingWebI, DeskI,Complex,Ad-hocReports, Canned Reports, Charts using Business Objects.
• Experience in complex data analysis in Designer, used data from multiple data providers, performed extensive data analysis with complex queries, drill up, drill down, slice and dice.
• Working knowledge of scheduling WFs through Control-M.
• Used Debugger in Informatica Power Center Designer to check the errors in mapping.
• Experience in writing complex SQL queries and PL/SQL, including the use of stored procedures, functions and triggers to implement business rules and validations.
• Excellent skills in fine-tuning the ETL mappings in Informatica.
• Conducted End-to-End testing as a part of project plan to complete mock and INT cycles leading up to the foundation release.
• Expertise in scheduling Informatica jobs using Informatica, windows scheduler and the Unix corn.
• Expertise in creating Unix shell scripts.
• Experience in Data Modeling tool Erwin and Data Warehousing Concepts.
• Strong knowledge of Relational Database modeling and Dimensional modeling concepts.
• End-to-End understanding of agile/waterfall process. Working experience in all phases of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Data Warehousing: Informatica Power center 9.x/8.x/7.x, Power Connect MS SQL ServerAnalysis Services, OLAP,OLTP, ETL.

Reporting Tools: Business Objects XI-R3/XI.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005.

RDMS: Load Tools TOAD 8.x, SQL Developer (Database tool), SQL Assistant.

Languages/Web: SQL, PL/SQL, C, C#, Data Structures.

Environment: Unix, Windows 2003/XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Single handedly developed the module by dumping the data from source to a staging area, the staging data was then cleansed and validated against the specified business rules and loaded into Intermediate layer.
• The cleansed data from the Intermediate layer was then loaded into Data Repository after applying the required transformation rules.
• Improved error handling and reduced the number of defects by implementing Audit Balance Control (ABC) usingInformaticaand DB2 to maximize the quality of the deliverables.
• Analyzed the data for gap analysis between source and target structure.
• Performed data profiling to understand the data pattern usingInformatica
• Performance tuned the module using techniques like cache, scripting and transformation improvements.
• Wrote Unit Test Plan, Module Test Scripts, Module Test Plan, and Failure Modes & Effective Analysis.
• Understand the overall Investment Management business so that identification of processes becomes simple.
• Involved in Analysis Phase to gather the requirements provided by user and prepare the functional document.
• Interacting with BA's and downstream end users to understand the requirements clearly.
• Customization/Creation of ETL components as part of development.
• Create the Unit Test Cases and done SIT testing for ETL & Reporting.
• Performance tuning of new or existing application wherever required.
• Handled complete configuration of customized/new tasks and loading process through Control-M jobs.
• Migrated Universes and Reports from one Repository to other by using Import Wizard.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with Business Objects.
• Created various standard reports and queries based on the existing classes/objects. Exported reports to Excel based on the user requirements.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc
• Used Alerters, Filters, Breaks, Sorts and Rankings, Customizing User Objects, List Of Value (LOV’s) in the reports.
• Configured E-mail functionality in Business Objects
• Scheduled WebIreports to run weekly/monthly automatically and sent the reports as PDF to DHS and FEMA users
• CreatedWebIAudit reportsfor the management to view the usage of Business Objects application
• Set up Domain level security in Central Management Console(CMC)in Business Objects
• Understand the Business requirements and estimate the effort for the new requirements.
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required.
• Designed logical and physical data model. Designed ETL process from source to target.
• Created database objects like staging tables, target tables, synonyms, sequences, triggers and stored procedures to move data to target.
• DevelopedInformaticamappings. Unit test ETL mapping codes and validated the result set data.
• Developed Shell scripts to run ETL batch through Control-M schedule.
• Documented validation rules, exception processing and test strategy of the mappings
• Migrated ETL codes from Development to Test to Production.

Environment: Informatica 9.5, Control-M, Rapid SQL, FileZila,Business Objects XI-R3/XI,Oracle 11g, Sybase, DB2,, Erwin, Shell Script

Confidential, Seattle, WA

Sr. Informatica Developer

Responsibilities:

• Involved in preparation of technical specifications to developInformatica ETL mappings to load data into various staging, Data warehousing and Data marts.
• Involved in Designing Logical and physical data models using Erwin following Star Schema methodology.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe
• Created, enhanced and maintained Universesfor different domains and defined various Classes and objects according to the Business Requirements provided
• Using Business Objects XI3.1 Designer
• Performed Unit/Integration Testing on the WebI and DeskI reports and deployed them from Local to Development environment.
• Analyzed the functional specifications provided by the data architect and created Technical Specification Documents and Detail Design Documents for all the mappings.
• Fine tuned the complex SQL queries on SQL Assistant, analyzed the Explain Plains and came up with Cost Effective Solutions.
• Deployed the WebI reports/Universes as BIAR from Test to Production for the go-live, performed Smoke testing and validated the reports working.
• Performed Root Cause Analysis to address production issues related to BO application.
• Extensively wrote several BTEQ scripts for data manipulations.
• Created mappings and Mapplets using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy.
• Designing MLOAD scripts to load data into multiple tables based on Multiload Layout Labels.
• Used Dynamic Lookup transformation for implementing Slowly Changing Dimensions and synchronizing the target load rows throughout the session run.
• Created Workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs and sessions to run a mapping.
• DevelopingInformaticascripts to load flat files into Teradata for Transformations.
• Verified target definitions based on star schema design and developed transformation logic for loading data into target data warehouse.
• Developed schedules to automate the update processes andInformaticasessions and batches
• Solved multiple DQ issues for various projects after interacting with BA's / Developers.

Environment: InformaticaPower Center 8.6, Teradata V2R12, Erwin, Business Objects XI-R3/XI,Oracle 11g, SQL, BTEQ, UNIX, Windows 7 Professional, SQL Developer, Quality Center.

Confidential, Washington, D.C

ETL/Informatica Developer

Responsibilities:

• Designed and Implemented the ETL Process using Informatica power center.
• Sourced Data from the work unit’s span across huge variety of data sources like Oracle, Flat Files, MS Access and Spread Sheets.
• Developer ETL flows from Source to Stage, Stage to Work tables and Stage to Target Tables.
• Source and Target Definitions are imported from Source Analyzer and Target Designer connecting to databases using Relational and ODBC Connections.
• Developed several complex Informatica Mappings using different transformations like Normalizer, SQL Transformation, Expression, Aggregator, Joiner, Lookup,Sorter, Filter, Router etc.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Utilization of TOAD for writing and analyzing SQL Queries.
• Migrated Informatica Folders from Development Environment to Test and System Test Environment.
• Worked with Admins to migrate the same to Production environments.
• Wrote PL/SQL procedures for reconciliation of data between source and target.
• Involved in automating testing phases for preliminary validation.

Environment: Informatica Power Center 8.6, (Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager), Oracle, ETL, Flat files, Oracle, PL/SQL, SQL * Loader, TOAD, Excel, Windows.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Responsible for deliverables of the project.
• Estimation of Work in terms of Informatica Mappings.
• Assist and mentor team members in technical and functional areas.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure and Lookup.
• Filter, Joiner, Rank, Router, and Update Strategy.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Used File list to load multiple Flat files into the staging tables.
• Created command tasks which included the DBMS Stat tasks for SQL optimization.
• Used Hints in the Lookup Queries and Source Qualifier.
• Created post session email tasks to notify users.
• Preparation of detailed design documents.
• Perform design and mapping reviews of the Team.
• Created test plans and test scripts to test the data based on business requirements.

Environment: Informatica Power Center 8.6 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, UNIX, Flat files,Windows XP professional.

Confidential

ETL Developer (Informatica)

Responsibilities:

• UsedInformaticato load data from Flat Files, which includes fixed-length as well as delimited files and SQL Server to the Data mart on Oracle database.
• Developed Mapplets, reusable transformations, source and target definitions and mappings usingInformatica.
• Developed mapping using parameters and variables.
• Worked withInformaticaDebugger to debug the mappings in Designer.
• Created complex workflows, with multiple sessions, work lets with consecutive or concurrent sessions and other tasks like Timer, Event Raise, Event Wait, Decisions, and Email.
• Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.
• Implemented source and target based partitioning for existing workflows in production, to improve the performance and cut back the running time.
• Analyzed the session, event and error logs for trouble shooting mapping sessions.
• Extensively used reverse engineering in Erwin to understand the existing data model of the data warehouse.
• Involved in unit testing for mappings, sessions and workflows.
• Involved in migrating the application from development environment to testing environment.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

Environment: InformaticaPower Center 6.0, Oracle 8i, SQL Server2000, MS Access, SQL, PL/SQL, Windows NT.