SUMMARY

• Over 7 years of experience and expertise in analysis, design, development and implementation of Data Warehouses, Data Marts and Decision Support Systems (DSS) involving RDBMS likeOracle, MS SQL server on Windows and UNIX platforms.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Data modeling tool ERWIN and Dimensional modeling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Experience in developing and maintaining logical and physical Data models for Data Warehouse applications using tools like Erwin and ER/Studio.
• Extensively used Informatica Client Tools - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Expertise in implementing complex Business rules by creating robust mappings, Mapplets, shortcuts, reusable transformations using transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources likeOracle, Flat files, XML files and MS SQL Server into Oracle, XML and SQL server targets.
• Extensive experience in implementing Change Data Capture (CDC) using Informatica Power Exchange 8.x/7.x.
• Used IBM information analyzer extensively for complete source system profiling and analysis, to validate data values, validate column/table relationships and drill down to exception rows for further analysis to ensuredata projects contain trusted information and lower the risk of propagating bad data.
• Worked on Quality Stage jobs using Match, Standardize and Survivor stages. Used Quality Stage plug-in within Data Stage jobs.
• Created and verified Quality Stage jobs for Match and un-duplication of data.
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions and Triggers and involved in Query Optimization.
• Experience in Data loads using Toad for Oracle, SQL loader Imports & UTL files based on file formats.
• Extensively worked on Repository Manager, Server Manager, Workflow Manager, and Workflow Monitor
• Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
• Strong in UNIX Shell and PERL scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Maestro, Control-M.
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8.x/7.x, SQL Server 2008/2005/2003/2000 , DB2, SQL Assistant, My SQL 5.0/4.1, MS-Access. Editors (SQL Navigator, Toad)

ETL Tools: Informatica (PowerCenter 9.x/8.x/7.x, PowerMart 6.2), IBM Information Server 8.1

Data Modeling Tools: Data Modeling - Logical, Physical

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, HTML, JAVA Script, J2EE, CSS

Dimensional Modeling - Star / Snowflake: ERWIN, ER/Studio

Reporting Tools: MS SQL Server Reporting services 2005, Developer 2000(Forms 5.0, Reports 6i), Crystal Reports 10, Crystal Reports 2008

Operating Systems: UNIX (Sun-Solaris, HP/UX), Windows 95/98/00/NT/XP

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

Sr. Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, SQL Server and XML Files.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Worked on Migration of mappings from Data Stage to Informatica.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Used SQL Loader to load huge flat files into Oracle database.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Confidential Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Developed a UNIX Shell scripts which will send the reports to client over the network by using file transfer protocol (FTP & SFTP) and generating the log file, which will keep the history for the FTP reports.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center 9.1.0, Oracle 10g, Oracle SQL* LOADER, Flat Files, UNIX Shell Scripting, TOAD, Crontab

Confidential, Fort Worth, TX

Sr. Informatica Developer

Responsibilities:

• Involved in collection and analysis of Business requirements with the business analysts and converted them in to Functional specifications.
• Designed and developed conceptual, logical and physical data model of the star schema using VISIO.
• Extensively used transformations like Source Qualifier, XML, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Sequence Generator transformations.
• Implemented Change Data Capture (CDC) using Power exchange.
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements.
• Developed Workflows and session to load data into targets.
• Created Confidential and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Involved in unit testing of the mappings and mapplets.
• Used different kind of tasks like Event wait and Event raise in the Workflow designer.
• Used Debugger in Mappings to debug the Complex mappings and fixed the errors.
• Developed Informatica mappings to replace the existing PL/SQL code
• Involved in ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project development to testing and then to Production Environment.
• Designed and developed UNIX Scripts to automate the tasks.
• Prepared and used test data cases to verify accuracy and completeness of ETL process.
• Performance tuned Informatica mappings using Pushdown Optimization, Variables and Dynamic Cache.
• Hands on experience with Scheduling tool Appworx to schedule workflows by running shell scripts through it.
• Used Connect: direct to get files from mainframe to unix server.
• End-to-end ETL development of the Marketing Data Warehouse.

Environment: InformaticaPowerCenter 8.6.1, Oracle, SQL Server, XML, Flat files, Toad, UNIX, Appworx, Sterling Connect: direct.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Interactedwith business users, analysts to gather, understand, analyze, program and document the requirements of Data Warehouse.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Created complexity mappings using Aggregator, connected, unconnected and dynamic Lookup, Joiner and created reusable transformations and mapplets in the mappings.
• Using Sequencegenerator for Surrogate keys in the dimensions to reduce the complexity and for improving the performance of composite keys.
• Worked on Workflow Manager to Schedule the workflows and run the sessions according to job dependency.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Troubleshoot the issues by checking sessions and workflow logs.
• Conducting debugging sessions and fixing invalid mappings.
• Created the Data Flow Diagrams to check the dependency.
• Involved in DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Developed unit testing, systems testing and post-production verification.
• Involved in writing the test cases and documentation
• Involved in extensive Performance tuning by determining bottlenecks at various points like targets, sources and systems. This led to better session performance.
• Participated in weekend reviews with team members and Business People.

Environment: Informatica Power Center 8.1/ 8.6, Oracle 11i/10g, Oracle SQL * Loader, Flat Files, UNIX Shell Scripting, TOAD, Approrx 6.0

Confidential

Jr. Informatica Developer

Responsibilities:

• Worked with business analyst in requirement gathering and involved in developing technical specifications from business requirements to build data base.
• Installed and Configured Informatica 6.1
• Created necessary Repositories to handle the metadata in the ETL process.
• Performed Extraction, Transformation and Loading Process.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.
• Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
• Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema.
• Created the Source and Target Definitions in InformaticaPowerCenter Designer.
• Created Reusable Transformations and Mapplets to use in Multiple Mappings.
• Created Sessions and Batches using Server Manager for data movement through Mappings.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for Consistent access to SQL data source.
• Designed and developed backed Data base in Oracle 8.
• Used SQL Loader to load the data into Oracle database.
• Developed PL/SQL procedures, functions to facilitate specific requirement.

Environment: Informatica 6.X/ 7.X, Oracle 8, Visual Basic 6.0 / Windows NT 4.0, Windows 2000 server, SQL* Plus, SQL, PL/SQL., SQL *Loader.