SUMMARY

• 7 years of experience in Information Technology with emphasis on Data warehouse, Database and Business Intelligent experiences.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Exceptional background in analysis, design, development, customization, implementation and testing of software application and products.
• Good experience in using ETL tools like Informatica Power Center, including SQL Server Integration Services (SSIS), RDBM systems like SQL Servers, Oracle, DB2.
• Extensively worked on Informatica Power Center 9.x/8.x/7.x tool to develop mapping designing, mapplet transformation, workflow and sessions.
• Good understanding on Unified Dimensional Model, Dimensional Data Modeling and Star/Snowflake schemas.
• Good knowledge on OLAP and OLTP process.
• Good experience on Business Intelligent tools like Business Objects and Crystal Reports.
• Good knowledge on standard reporting, dashboard and scorecards.
• Good Knowledge on ETL Life Cycle (Kimball life cycle) and Analytic Cycle for Business Intelligence.
• Experience in interacting with business analysts, developers, technical support and help the base line the requirement specifications.
• Worked on standard Unix Shell Script with Informatica Power center.
• Strong Knowledge in SQL and PL/SQL, Database Triggers, Stored Procedures, Functions, Constraints, Collections, Functions, Procedures, Packages, Indices, Materialized Views and Database Objects.
• Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica PowerCenter 8.x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, Salesforce connector and Informatica Server) ETL, Repository, Metadata, Data Mart, Physical & logical data modeling.

Databases: Oracle 11g/10g/9i/8.0, MS SQL Server 2000/2005/2008 , Teradata,DB2

Programming: SQL, T - SQL, PL/SQL, SQL*Plus, SQL*Loader, C, C++

Tools: Test Director, Erwin, TOAD, Excel, Word, MS-Project, Autosys

Reporting Tools: Business Objects 6.5/xir2/xir3, Crystal Reports

Environment: UNIX, Windows 2000/NT.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Data Analyst/ETL Developer

Responsibilities:

• Involved in analysis and resolving the data issues related to clients, Financial Advisors.
• Involved in review and finalizing the technical specs of source-target mapping documents.
• Involved in designing Error handling strategy using Error detection/Notification/Re-Processing processes.
• Experience in working with ETL against large scale terabytes of data and databases.
• Developed scripts for automating workflows using shell scripting.
• Involved in designing Audit process for the sessions loaded as part of mapping design as well querying against Informatica repository tables
• Involved in data migration procedure and mapped data from legacy systems to new existing systems for providing a design for data extraction and data loading.
• Involved in all data migration phases like design, extraction, cleansing, load and verification.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy.
• Designed and Deployed extract-transform-load (ETL) and extract-load-transform (ELT) processes using Informatica.
• Involved in performance tuning Informatica mappings with XML, Normalizer, Joiner, Aggregator, Union, Router, Filter transformations.
• Loading the data into salesforce using Salesforce connector.
• Used Apex Explorer to query the salesforce data.
• Migration of code from windows to Linux platform.
• Extensively used Web Intelligence, Info view, reporter and explorer for querying, reporting and analysis tasks.
• Resolved loops by creating Aliases and Contexts.
• Used Workflow Manager for creating workflows, Worklets, emails, and command tasks.
• Involved in scheduling the Informatica workflows.
• Verified and Validated the Automated Test scripts.
• Strong skills in writing SQL queries to ensure data integrity and validate business rules.
• Involved in tuning the mappings with audit, error design and reprocessing strategies.
• Implemented load parallelism using Informatica database partitioning.
• Documented and updated production support team prior to release.
• Performed Unit Testing and Integration Testing on the mappings.

Environment: Informatica Power Center 9.1, Metadata Manager, Oracle 11g, SSIS, Salesforce, XIR3.

Confidential, NJ

ETL DEVELOPER

Responsibilities:

• Analyzed specifications and identified source data needs to be moved to data Mart, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical teams.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and Mapplets to load data from external flat files and RDBMS.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the mappings between sources (external files and databases) to operational staging targets.
• Participated in the analysis of development environment of extraction process and development architecture of ETL process. Used Informatica Power Center 8.6 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, and Update Strategy & Sequence Generator.
• Extensively used Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica 8.6.
• Extensively used various techniques like Merged Dimensions, Ranking, Breaks, Sorting, and Ranking, Report Filtering, Query Filtering, Alters and sections to develop the WebI reports.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.
• Worked on Informatica Schedulers to schedule the workflows.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Extensively worked with the QA team to get the system and unit testing done successfully.
• Involved in Database testing by writing & executing SQL&PLSQL queries by using SQL & TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Created Task Session, Email and Workflow to execute the mappings. Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Coordinated with the QA team for release before it moved into production.
• Worked in Repository Manager to create Folders, Groups and Users.

Environment: Informatica Power Center 8.6, Power Connect, Power exchange, Oracle 10g, SQL, SQL*PLUS, SQL*LOADER, XIR2.

Confidential, Delaware

Informatica ETL Developer

Responsibilities:

• Gathering the end-user requirements.
• Analyzed the logical model of the Databases and normalized it when necessary.
• Identified entities and relationships in a business environment using an event-oriented focus.
• Performed mapping to identify the customer profitability, customer lifetime value, and to understand customer segmentation, attrition analysis, and affinity analysis, campaign analysis.
• Extensively used Informatica Power center for extracting, transforming and loading into different databases.
• Designed, Developed and Tested the Different Mappings according to Requirements.
• Worked on Informatica tool Source Analyzer, Data Warehousing designer, Mapping Designer, Workflow Monitor, Workflow Manager and Repository Manager.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas.
• Used the Mapping Designer to map the sources and target.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Rank, Lookup, Stored procedure, Sequence generator and Joiner.
• Created and scheduled Worklets, Configured email notifications, set up Workflows to schedule the loads at required frequency, generate completion messages and status reports using Power Center Workflow Manager. Administrated Workflow Manager to run Tasks & Worklets.
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created stored procedures for customer requirement.
• Resolving production and data quality issues.
• Created, modified, deployed, optimized, and maintained Business Objects Universes using Designer.
• Performed Chart Creation, Numerical Data Report Generation using Business Objects 6.5.

Environment: Informatica Power Center 8.1 (Designer, Repository Manager, Server Manager), Business Objects 6.5, Oracle 9i.

Confidential, San Francisco - CA

ETL Developer

Responsibilities:

• Involved in preparing technical design/specifications for data Extraction, Transformation and Loading.
• Created Repository, Folders, Users, and user privileges using Repository Manager.
• Extensively used ERwin for Logical / Physical data modeling and Dimensional Data Modeling, and designed Star Schemas
• Define, create and access data source layouts and target data warehouse and data mart schemas through Informatica Power Mart Designer.
• Involved in data modeling and design of data warehouse in star schema methodology with confirmed granular dimensions and Fact tables.
• Developed various Mappings, reusable Transformations and Mapplets for transformation of data using Informatica Designer.
• Configure Informatica Server Manager, created sessions and batches to execute the sessions.
• Create and control the Informatica Metadata Repository using Repository Manager.
• Created Database objects in oracle database.
• Develop Reports based on user requirements from Business Support users - both for standard reporting and ad hoc requests using Business Objects.
• Analyzed and Validated test results to ensure existing functionality and recommend corrective action where necessary.
• Analyzed sales using Business objects sales analytics product.
• Done the Unit Testing and Integration testing of the module.

Environment: Informatica Power Center 7.1, Informatica Power Connect, Oracle9i, PL/SQL, Business Objects 6.5.

Confidential

Oracle Developer

Responsibilities:

• Actively participated in the requirement analysis, database design and modeling.
• Participated in the implementation of a payroll system using SQL, Oracle forms & triggers on WINDOWS platform.
• Also involved in performing development tasks such as writing extensive PL/SQL programs units like triggers and forms.
• Involved in database administration. Design, development and implementation.
• Responsible for development of forms and interfacing the data selection from the database.
• Assisted in the Development of several reports including tabular, master detail reports.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, Oracle Developer 6i, WinNT4.0.