SUMMARY

• 7+ years of total IT experience in teh Business Requirements Analysis, Application Design, Dimensional Data Modeling, Data Modeling, Development, Implementations and Testing of Data Warehousing and Database business systems for various Financial, Insurance, Retail & Manufacturing industries.
• Data Warehousing experience using Informatica Power center 8.1/7.1/6.2/5.1.2 Warehouse Designer, Power Connect, Power Plug, Power Analyzer, ETL tools like Informatica, Data Mart, Star Schema, Snowflake Schema.
• Experience using Oracle10g/9i/8i/8.x/7.x, SQL Server 2005/2000, XML, PL/SQL, SQL Server Management Studio, SQL*Plus, SQL*Loader, Toad and Developer 2000, Win 2000/98, Win NT 4.0,Unix and Sun Solaris 2.x.
• Data warehouse experience is varied from Data Analysis, Dimensional Data Modeling, Data Extraction Transformation & Loading (ETL), Creating Meta Data layer, Data Mining, End User Reporting, Reporting & Implementation, Creating Test scripts and user signoff documents.
• Being Part of full lifecycle of DW Project, gatheird hands on experience on Evaluation, Development, Maintenance and Implementation of ETL tools such as Informatica
• Extensive Working Experience in Testing for UAT testing and Production for Support through Tickets and Involved in Executing Scripts.
• Worked wif Informatica components like designer, Work flow manager, Work flow monitor, Repository Manger.
• Involved in Design, Source to Target Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions.
• Expertise in Data Warehouse and Database development skills using Oracle SQL and PL/SQL.
• Knowledge in Dimensional Data Modeling using Data modeling, Star Schema/Snowflake modeling, Fact & Dimensions tables, Physical & logical data modeling, Oracle 10g/9i/8i, and SQL Server Designer.
• Extensive Programming skills in Oracle SQL and PL/SQL, SQL Server 2005/2000 and scripting languages on windows 2003/2000/NT and UNIX Environments.
• Experience in using UNIX shell scripts.
• Created several scripts in UNIX for data transformations to load teh base tables by applying teh business rules based on teh given data requirements.
• Extensive Experience in Developing Oracle Database objects like Packages, Stored Procedures, Functions, Triggers and noledge in Tuning teh SQL code.
• Ability to work in teams & independent wif minimal supervision to meet deadlines.
• Good communication, analytical and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.6.1/8.1/7.1.1/6.x

RDBMS: Oracle 10g/9i/8i, SQL Server 2005/2000, Teradata v2r6

Programming Languages: SQL, PL/SQL, C, C++, UNIX shell scripting, XML

Database Skills: Stored Procedures, Database Triggers, Packages

Operating Systems: Windows NT, Windows 2003/2000, XP, and UNIX

PROFESSIONAL EXPERIENCE

Confidential, IA

Sr.Informatica Developer

Responsibilities:

• Involved in data analysis, designing, and development of data warehouse environment.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Created source definitions for relational and flat file sources and implemented target definitions based on star schema design.
• Used Informatica as an ETL tool to extract data from source systems to Target system. Source Systems are mainly flat files, CSV files, DB2 and relational tables.
• Developed Mappings using various transformations like connected/unconnected Lookups, Filter, Router, Aggregator, Expression, Stored procedure, Sequence Generator, Update strategy and Joiners etc. depending upon requirement.
• Worked wif Informatica components like designer, Work flow manager, Work flow monitor, Repository MangerUsed teh Informatica Designer to create complex Mappings and Mapplets.
• Used Repository Manager to create user groups and user profiles wif privileges of Administrator and Setting up teh security for creating user groups and assigning privileges.
• Designed Type1 (overwriting, no history) and Type2 (flag, version, date) mappings.
• Implemented code migration from development to testing.
• Tuned sources, targets, mappings and sessions to improve teh performance of data load into Oracle database
• Knowledge in Star Schema and Snow Flake Schema to fit reporting, query and business analysis requirements.
• Created several scripts in UNIX for data transformations to load teh base tables by applying teh business rules based on teh given data requirements
• Involved in scheduling and deploying these reports.
• Developed logical models building hierarchies, attributes and facts extracting tables from warehouse
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 9.1/8.6.1Salesforce.com,,DB2, SQL, Autosys, Sql Developer, WINDOWS XP, PERL, UNIX Shell Scripting, UNIX

Confidential, MA

Sr.Informatica Developer

Responsibilities:

• Negotiating features and timeframes associated wif delivering them in order to meet project / business goals.
• Managing teh deliverables and integration wif teh overall project plans. Coordinating teh tasks across database team members and managing changes during teh development cycle.
• Prepared functional specifications and scope documents.
• Involved in source data profiling & source system analysis.
• Prepared Mapping documents for loading teh data from Legacy system to data warehouse.
• Involved in creating High level and low level design of teh ETL process
• Involved in designing teh Logical and Physical data models for teh data warehouse
• Extensively Involved in Developing Data objects Like Stored Procedures, Functions, Packages, Triggers In Oracle
• Worked wif Informatica components like designer, Work flow manager, Work flow monitor, Repository Manger, Informatica Admin Console
• Defined Target Load Order Plan for loading data into different Target Tables.
• Implemented SCD methodology including Type 1, Type 2 changes to keep track of historical data.
• Prepared migration document to move teh mappings from development to production repositories.
• Worked on Shell and Perl scripting to develop generic wrapper scripts.
• Involved in writing Automation Testing scripts using Shell and Perl and worked on Crontab to schedule these scripts in DEV and QA environments
• Created UNIX shell scripts to invoke teh stored procedures for teh control process for teh parameter file generation.
• Involved in Unit, Integration, system, and performance testing levels.
• Production support and analyzing data
• Create number of standard reports and queries based on existing classes/objects and using Free Hand SQL.
• Using teh Broadcast Agent server to post on teh web and schedule and monitor teh reports as per teh terms and conditions
• Train users on usage of teh Informatica tool and it’s different module

Environment: menformatica 8.1/7.1, Oracle 10g, SQL, PL/SQL, Teradata V2R5, Perl, Toad, WINDOWSXP, UNIX, J2EE, Autosys, HP UNIX

Confidential, KS

Sr.Informatica Developer

Responsibilities:

• Analyzed teh source data arriving from different source systems like Vendor Management Inventory, Invoice Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores.
• Implemented Ralph Kimball Methodology concepts
• Extensively worked wif SQL / PL/SQL Concepts like Developing Data base objects, Involved in Performance issues.
• Involved in business analysis and technical design sessions wif business and technical staff to develop Entity Relationship/data models, requirements document, and ETL specifications.
• Metadata driven utility design for Data Extraction, Transform and Data processes using Informatica Power Center.
• Used Informatica Designer to create complex mappings, transformations, and source and target tables.
• Administer teh repository by creating folders and logins for teh group members and assigning necessary privileges.
• Created UNIX shell scripts to invoke teh stored procedures for teh control process for teh parameter file generation.
• Involved in Unit, Integration, system, and performance testing levels
• Used Workflow Manager for creating, validating, testing and running teh sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Query Optimization for improving teh performance of teh data warehouse.
• Developed standard and re - usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Involved in performance tuning of teh mappings, sessions and workflows.
• Performed Type1 and Type2 mappings
• Created Tables, Stored procedures, Functions, and Queries in Oracle SQL/ PL/SQL.
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Developed PL/SQL and UNIX Shell Scripts.
• Created sessions & Batches using Server Manager to load teh data into teh Target Database.

Environment: Informatica 7.1.2, Oracle 9i, SQL, PL/SQL, Forms, Reports, PRO * C, Power Designer, TOAD, Sybase, Windows NT, UNIX

Confidential . Conway, AR

Data Warehouse Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created Common objects for teh ETL team to maintain teh Common Code.
• Extensively used Informatica to load data from Flat Files to DB2, DB2 to Flat Files & Oracle to Oracle. Created mappings using teh transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
• Designed and developed UNIX scripts for creating, dropping tables and splitting file into Header, Detail and Trailer Files
• Worked wif Informatica components like designer, Work flow manager, Work flow monitor, Repository Manger
• Worked on Informatica Power Center 7.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager
• Created reusable transformations and Mapplets and used them in complex mappings.
• Used Informatica Power center workflow manager to create sessions, workflows and worklets to run wif teh logic embedded in teh mappings.
• Used Workflow Manager for Creating, Validating, Testing and running teh sequential and concurrent Batches and Sessions.
• Migrated mappings from Development to Testing.
• Unit testing and integration testing and tuned for better performance.
• Created various Documents such as Source-To-Target Data mapping Document, Backroom Services Document, Unit Test Cases and Data Migration Document.
• Created teh Analytic Workflows, Custom Metrics, Calculated Metrics, And Global Variables.

Environment: Informatica Power Center 7.1,Oracle 9i, DB2, Unix, Informatica Scheduler, SQL Navigator 4.0,Windows NT, UNIX TOAD.

Confidential

Data Warehouse Developer

Responsibilities:

• Analyzed teh source data arriving from different source systems like Vendor Management Inventory, Invoice Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores.
• Worked wif Erwin for developing Star schema according to teh business requirement.
• Implemented Ralph Kimball Methodology concepts
• Extensively worked wif SQL / PL/SQL Concepts like Developing Data base objects, Involved in Performance issues,
• Metadata driven utility design for Data Extraction, Transform and Data processes using Informatica Power Center.
• Used Informatica Designer to create complex mappings, transformations, and source and target tables.
• Administer teh repository by creating folders and logins for teh group members and assigning necessary privileges.
• Created UNIX shell scripts to invoke teh stored procedures for teh control process for teh parameter file generation.
• Involved in Unit, Integration, system, and performance testing levels
• Used Workflow Manager for creating, validating, testing and running teh sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases.
• Query Optimization for improving teh performance of teh data warehouse.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Involved in performance tuning of teh mappings, sessions and workflows.
• Performed Type1 and Type2 mappings
• Created Tables, Stored procedures, Functions, and Queries in Oracle SQL/ PL/SQL.
• Used session parameters and parameter files to reuse sessions for different relational sources or targets.
• Developed PL/SQL and UNIX Shell Scripts.
• Created sessions & Batches using Server Manager to load teh data into teh Target Database.

Environment: menformatica 7.1.2, Oracle 9i, SQL, PL/SQL, Forms, Reports, PRO * C, Power Designer, TOAD, Sybase, Windows NT, UNIX

Confidential

ETL & Oracle Developer

Responsibilities:

• Analyzed Business Requirements, Analytics and strategies to improve teh business
• Evaluating teh Consistency and integrity of teh model and repository.
• Worked wif Erwin for developing Star and snow flake schemas
• Migrate teh Metadata changes to teh Informatica repository.
• Designed and built Data Marts for home and business insurance divisions.
• Optimized Query Performance, Session Performance and Reliability.
• Extensively used Transformations for data joins, complex aggregations and external procedure calls.
• Tuning teh Informatica Repository and Mappings for optimum performance.
• Generated number of Oracle scripts to create Master and transactional tables, Views, Materialized views, Synonyms, audit, integrity constraints setup
• Extensively Involved In Developing Database objects Like Functions, Packages, Stored Procedures, Triggers and SQL Concepts like Indexes, Views, Joins…
• Involved in creating users and giving access to them for teh corresponding screens.
• Extensively Involved in Developing Data objects Like Stored Procedures, Functions, Packages, Triggers In Oracle
• Worked wif Cognos developing Reports Like impromptu power play reports
• Worked wif Cognos upfront and power play transformer
• Created classes for handing particular applications and also for filed checking’s.
• Involved in coding of user interfaces screens.
• Involved in Training to teh END Users

Environment: menformatica, Oracle, SQL, PL/SQL, Windows 2000, HP-UX 10.20, Shell Scripting, XML, DB2, UNIX