SUMMARY

• I.T Professional with over 7 years of experience in application designing, development and implementation of Data Warehouses & Data Marts using ETL tools Informatica for Automotive, Retailers and Marketing Industries.
• Extensive experience with Oracle 10.6.0g with Toad as the tool to work with Oracle and SQL server 2005/2008 codes.
• Experienced in creating ER diagrams in ERWIN and documenting existing entities.
• Extensive worked with .Net technologies. Designed webpages using Asp.Net and coded with C#.net
• Extensive exposure to OBIEE Reporting Tool and expert in writing UNIX shell scripts.
• Extensive experience in requirement gathering from business users to create Functional Specification Document (FSD) used by ETL/BI teams to build ETL/BI architecture.
• Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, stored procedure, sequence generator, etc.
• Extensive experience in debugging mappings. Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
• Extensive experience in implementing business requirements, error handling, job control & job auditing using Informatica PowerCenter tool.
• Expertise in Kimball Data Warehousing Methodology and Data warehousing concepts like OLTP/OLAP System Study, data modeling, and developing database schemas like Star schema and Snowflake schema used in relational and dimensional modeling.
• Expert knowledge in working with Data Warehousing tools (ETL tools) like Informatica Power Center 9.0/8.6/8.1/7.1/6.1 and exposure to Informatica Power Exchange.
• Expert in RDBMS concepts, SQL, PL/SQL (Oracle 10G, Oracle 9i, Sql Server 2000). Expert in UNIX Shell scripting.
• Extensive experience with all tasks in Workflow Manager to implement job control in Informatica to support dependencies in loading data in target systems including Pre - Post session commands/SQL.
• Expert in SDLC process and various deliverables in SDLC. Analyzed Business and Functional Specifications and assisted the QA team for writing a comprehensive test plan / writing test cases.
• Highly motivated, Reliable, Responsible and a Good team player

TECHNICAL SKILLS

• ETL Informatica (Power Center/ Power Mart) 9.0/ 8.6/8.5/8.1.1/7.1.2/6.1 /5.1 . SSIS Reporting Tools OBIEE
• Web Intelligence
• Crystal Reports 8.X/10.X Database Modeling Erwin 9.0
• Rational rose Databases Oracle 10g/9i/8i/7.x
• SQL Server 7.0/2000/2005/2008 Languages SQL
• COBOL
• PL/SQL
• JAVA
• C. DB Tools SQL* plus
• SQL* Loader
• SQL*Forms
• TOAD . Web Tools HTML
• XML
• JavaScript
• Servlets
• EJB OS MS-WINDOWS NT/2000/2003
• UNIX
• Linux.

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

ETL Developer/Data Modeler

Responsibilities:

• Gathered Business requirements and Based on business requirements developed ETL strategies, error handling.
• Responsible for developing and maintaining data models, data lineage documents, and ETL (Extract, Transfer, and Load) programs which sourced from fiat files and oracle tables into targets using truncate and load or type 2 methodologies which adhered to standards.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed mappings, sessions, workflows to load the data into DataMart From oracle and FlatFile.
• Heavily used mapping variables, workflow variables & session parameters to implement incremental loading & automatic un-scheduling for workflows when there is no data to process from source systems.
• Designed and Developed the work-flows for the mappings by validating the dependencies in between the work-flows which involved various tasks like even-wait, command, session tasks.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows
• Involved in Updating Data Models using Erwin 9.0.
• Worked on various Transformations like Expression, Update Stratergy, Router, Lookup, Joiner, Filter, Aggregator Transformations.
• Did unit tesing and also writing test cases for Flat Files and Oracle Databases.
• Performed SQL tuning by rewriting SQL statements, dropping/creating indexes using hints & explain plan, Informatica mapping tuning by utilizing partitioning options in Informatica.
• Created Migration Plan document to migrate mappings, workflows to the testing.
• Scheduled the Work-flows using the Informatica scheduler and monitored using the workflow monitor. Used workflow monitor to monitor the jobs, reviewed error logs.
• Wrote UNIX shell scripts and used them as Pre/Post Session commands in the Sessions.
• Extensively worked on visual source safe.

Environment: ETL Informatica (Power Center)9.0, Oracle 10.6.0g,UNIX Shell Scripting, Putty, Windows XP, Erwin 9.0, TOAD.

Confidential, Detroit, MI

ETL Developer

Responsibilities:

• Effective involvement in requirement gathering, analysis and study of existing source & target.
• Based on business requirements developed ETL strategies, error handling, job control & job auditing.
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Prepared Detail design documents for the project as per the ETL standards, procedures and naming conventions.
• Designed and developed mappings/sessions/workflows/scripts to load data into ODS from Oracle, SQL Server, flat files source systems in to target oracle through typical staging, transforming, joining, data cleansing process.
• Designed the various complex mappings like SCD TYPE-2, TYPE-1, incremental loading & slowly growing type.
• Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure, etc.
• Involved in updating data model in ERWIN 7.2 with all related entities, attributes and relationship with each entity based on the rules provided by the process owners.
• Generated DDL, DMLS for various schemas to build physical data models to support Staging/ODS Systems.
• Performed SQL tuning by rewriting SQL statements, dropping/creating indexes using hints & explain plan, Informatica mapping tuning by utilizing partitioning options in Informatica.
• Heavily used mapping variables, workflow variables & session parameters to implement incremental loading & automatic un-scheduling for workflows when there is no data to process from source systems.
• Designed and Developed the work-flows for the mappings by validating the dependencies in between the work-flows which involved various tasks like even-wait, command, session tasks.
• Documented the number of source / target rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Created Migration Plan document to migrate mappings, workflows to the testing.
• Scheduled the Work-flows using the Informatica scheduler and monitored using the workflow monitor. Used workflow monitor to monitor the jobs, reviewed error logs.
• Wrote UNIX shell scripts and used them as Pre/Post Session commands in the Sessions.

Environment: ETL Informatica (Power Center/ Power Mart) 8.6/8.5/8.1.1/7.1.2/6.1 /5.1 , Oracle 10g, SQL Plus, PL/SQL, DB2 & SQL Server 2003, UNIX Shell Scripting, Sun Solaris 5.8 Windows XP, Erwin 7.2, TOAD.

Confidential, Oakland, CA

Informatica Developer

Responsibilities:

• Involved in creating the technical architecture and design documents for small project change requests.
• Work with business users directly in gathering requirement and implementing them and working close with offshore developers.
• Prepared user requirement documentation for mapping and additional functionality.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the requirements and framed the business logic for the ETL process.
• Assisted in the creation and implementation of the business rules via stored procedures.
• Extensively used ETL to load data using PowerCenter from source systems like XML Files, Flat Files, and Excel Files into staging tables and load the data into the target database (Oracle, SQL Server).
• Developed mappings to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner, Normalizer transformations.
• Developed Slowly changing dimension mappings (Type 1 and Type 2).
• Worked on populating the EDW / Data Marts, multiple fact and dimension tables with star methodology.
• Designed and developed reusable mapplets and used mapping variable and mapping parameters in the ETL mapping.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the different bottlenecks.
• Involved in documenting the deployment plan and the unit test plan and other UAT related documents.
• Did unit testing to identify what can be done to improve effectiveness and efficiency.
• Did the User Acceptance Testing (UAT) to see that the system under test meets the user’s needs.
• Used HP Quality center to create and for tracking of defects.

Environment: Informatica PowerCenter v8.6, Oracle 11g / 10g, Teradata 12 / 13, SQL Server 2005, XML Files, CSV, Files, Business Objects XI R3, TWS (Tivoli Workflow Scheduler),Windows-XP (Client), Unix (Solaris), SQL Developer, DB Visualizer 5.0, TOAD 9.0, SSH (Secure Shell), Ultra Edit.

Confidential, RedwoodCity, CA

ETL Developer/Administrator

Responsibilities:

• Involved in Design Part of the Project by Creating Functional Specification Document & Business mapping documents.
• Involved in gathering Business Requirements from Business Analyst. Study and understanding business logic.
• Prepared low level Source to Target mapping documents.
• Created and Imported/Exported various Sources, Targets, and Transformations using Informatica Power Center 8.6. Extracting data from several source systems and loading data into RSST data base and also feeding data into some external systems.
• Re-engineered lots of existing mappings to support new/changing business requirements.
• Worked on Power Center Designer client tools like Source Analyzer, Designer, Mapping Designer and Mapplet Designer.
• Developed reusable transformations, mapplets, sessions, worklets to make Informatica code very modular and reuse as required.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Involved in designing the web pages using .Asp Net and coding using C#.Net.
• Involved in performance tuning with Informatica and database.
• Used mapping variables, parameters, workflow variables & parameter files to support change data capture and automate workflow execution process to provide 24x7 available data processing unit via Informatica PC tool.
• Involved in writing UNIX shell scripts (Pre/Post Session commands) for the Sessions & wrote shell scripts to kickoff workflows, unschedule workflows, get status of workflows.
• Performed Informatica administration like user, privileges, migrations, starting, stopping pmrep/pmserver. Backup and restore repository service.
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.

Environment: Informatica Power Center 8.6, SQL Developer, Oracle 10g, SQL Server 2008, Unix, Erwin, PL/SQL Developer & Windows XP.

Confidential, Columbus, OH

ETL Developer/Administrator

Responsibilities:

• Assisted in the dimensional database design (Star schema). Reviewed multiple data source systems and recommended data acquisition and transformation strategy.
• Using Informatica ETL tool created detailed mappings to load data from multiple source SQL Server, Oracle, flat files to target Oracle. Implemented Aggregator, Joiner, Sorter, Router, Lookup, Update Strategy, Stored procedure transformations to optimize mappings.
• Responsible for data modeling using Erwin 3.5.2.
• Created and monitored Sessions and Batch jobs to execute the mappings. Provided primary support for divisional Data Mart applications.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using Pmcmd (start workflow, get workflow details, schedworkflow, etc) on UNIX Environment.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed and recommended solutions within an Enterprise Data Warehousing environment.
• Analyzed, designed, developed, deployed, and maintained the Multidimensional OLAP Cubes, drill-through targets for the Cubes, Impromptu Web Reports, PowerPlay Portable Reports and ReportNet Reports.
• Created reports like Cross Tab, Stored Procedure, Invoices and many more reports in Impromptu.
• Created cubes and published cubes using PowerPlay Transformer and created explorer & reporter reports using Power Play.
• Wrote stored procedures, functions. Occasionally Extracted data from other Oracle databases using Database Links.

Environment: Informatica PowerCenter 7.1/6.2.2/6.1 , Microsoft SQL Server 2000, Oracle 9i/8i, SQL Plus, PL/SQL, UNIX Shell Scripting, Linux, Windows XP, Erwin 3.5 & flat files.

Confidential

Database Developer

Responsibilities:

• Involved in gathering the requirements by conducting meetings and prepared the technical Design documents.
• Installed new databases, upgraded existing databases, created new database instances.
• Involved in creating PL/SQL Packages, Procedures, Triggers and Cursors.
• Involved in creation of database objects like tables, views, stored procedures, Indexes and Collections.
• Implemented SQL*Loader direct path option for bulk inserts into database.
• Written many database triggers for automatic updating the tables and views.
• Designed logical and physical DB layouts to minimize I/O contentions among data Files.
• Involved in creating user documentation and providing End user training.
• Involved in creating complex queries Using joins, sub queries and correlated sub queries.
• Performed Unit testing for the Developed component.

Environment: Oracle 8i/7, PL/SQL, SQL Plus.