SUMMARY

• Over Eight years in Information Technology with experience in Data Warehousing teamed with Business Requirements Analysis, Application design, Data Modeling, Development, Testing and Documentation.
• Eight years of strong Data Warehousing experience using Informatica Power Center (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica Power Mart, Power Connect, Power Exchange, Data Quality(IDQ), OLAP, ROLAP, MOLAP, OLTP.
• Proficient in Data Warehousing Concepts like Ralph Kimball and Bill Inmon Methodologies and Seven Plus (7+) years of Dimensional Data Modeling experience using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN 4.5/4.0/3.x and Oracle Designer.
• Extensive experience in ETL processes in extracting data from operational and legacy systems to data warehouse using Informatica. Understands complex mappings, transformation rules, data conversion and efficient in performance tuning of sources, mappings, targets and sessions. Extensively used various active and passive transformations like Filter, Router, Expression Transformation, Source Qualifier, Joiner, Sequence Generator, Update Strategy, Rank, Normalizer, Sorter, Aggregator and Look Up.
• Experienced in estimation, planning, Risk Management, finalization of technical / functional specifications, communication management and quality management of an application. Sound knowledge in tuning Informatica mappings and identifying bottlenecks and resolving the issues to improve the performance.
• Seven Plus (7) years of experience using Oracle 10g/9i/8x/7.x, 8.0/7.0/6.0, Teradata, MS SQL Server, DB2, Oracle Report Writer, M - Load, TPUMP, BTEQ, Fast Load, Erwin 4.x/3.x, XML, XSD, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 98/2000/XP, Autosys, Control M, UNIX Shell Scripting.
• Excellent Client Interaction, Communication and Presentation Skills.

TECHNICAL SKILLS

ETL: Informatica Power Center 9.1,8.6.1/8.1,7.1 (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager). Informatica Power Exchange, Informatica Data Quality 9.1/8.5, DataStage 8.1, SSIS 2008 R2.

BI & Reporting: Functional knowledge on Business Objects XI/ 6.5/6.0/5.1/5.0 , Business Objects SDK.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 4.5/4.0/3.5.2/2. x, OLAP Cubes.

Databases: Oracle 10g/9i/8i/8.0/7.3, MS SQL Server 2008/7.0/6.5 , IBM DB 2 9.1/ 8.0/7.0 , MS Access 2000, SAP, IDOC, Sybase, ABAP, Teradata V2R5/V2R4/V2R3 with M-Load, TPUMP & BTEQ.

Job Scheduling & Other tools: CA Autosys, BMC Control M, Tivoli, Clear Case, Ultra Edit, SEN, TOAD, Quest Central for DB2, AQT 9.0, Compare data, SQL Developer, MDM Siperian, Informatica Data quality, Microsoft Visual Studio 2008/2010.

Environment: UNIX (Sun Solaris, Confidential -UX, AIX), Windows 2003/2000/XP/98, Sun-Ultra, Sun-Spark, Sun Classic, RS/6000, Confidential 9000, SCO UNIX, Mainframes.

Others: Java, XML, HTML, DHTML, C++, VBScript, CSS, SQL, Dream weaver, PL/SQL, LAN, WAN, TCP/IP, D-AMPS, GSM, W-CDMA, Networking.

Functional Knowledge: Utility, Pharmaceutical, Health Care, Telecom and Finance.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Informatica Developer/Analyst

Responsibilities:

• Analyzed existing functional specifications and Worked extensively with Business community and database administrators to identify the Data Load issues and participated in team meetings proposed ETL framework.
• Replaced tables with Materialized views and enabled parallel hints for long running queries and documented results of performance improvements.
• Monitored workflows and collected performance data to maximize the session performance. And resolved memory related issues to optimize session runs.
• Created several jobs in Tidal to schedule Informatica workflows as per business requirement.
• Analyzed the data loads for Voyager load process and Involved in Performance Tuning of SQL Queries and handled daily load issues in Data Extracts.
• Involved in Unit testing, System testing and regression testing of tuned data extracts by coordinating with offshore team.
• Provided detailed technical, process and support documentation like daily process and detailed specifications document for Voyager load and Data Extracts with the workflows and their dependencies.
• Worked closely with Business analysts to gather requirement documents and convert to technical specifications.
• Worked on migration documentation, coding and testing of Sybase to Oracle for Embrace aplication.
• Worked on Coding, testing and tuning of Informatica Jobs and performed extensive Data analyzing and testing on reporting files coordinating with accounts team.
• Created HPSM tickets for production deployments. Coordinated with Informatica Admins for completing production migration. Processed/Resolved many Change Request tickets raised by accounts team.
• Analyzed Informatica Data Quality rules for Data Intake process and documented technical defects coordinating with Application DBA to identify Data related issues in UAT and BAT.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager)Oracle 11G, Tidal, PL/SQL, Flat Files, Informatica Data Quality 9.1, UNIX, Sybase, SQL Developer 3.2.

Confidential

DW/Informatica Developer

Responsibilities:

• Collaborated with business analysts and technical team for requirement gathering and business analysis and prepared high level design document to provide an overview of technical design specification system.
• Analyzed the existing application physical data model and suggested changes to data Model based on the ETL and Referential Integrity gap requirements. Accommodated ETL Mappings according to Database Management change requests. Developed Data Quality architecture for ETL environment.
• Created User Defined functions, reusable transformations to be re-used during the development life cycle
• Coordinated with Source System Owners to analyze sources for data feeds, mappings and Defaults in the Data and Created folders, shared folders for shortcuts, groups, users and assigned permissions and privileges to groups and users using the Informatica Repository Manager.
• Extensively used Informatica Data Quality for applying several rules against data coming from mainframes and VSAM files for data cleansing.
• Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance of data loads and extracts and SQL overrides in place of homogeneous sources. Designed and coded rejected row handling process.
• Designed and implemented CDC backup process for Mainframes. Designed data loading sequence and populated data into ODS, staging and warehouse with business rules following Data warehouse methodologies. Implemented SCD Type 1 and Type 2 to update the dimensional schema.
• Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Added enhancements such as mail functioning, success flag, pre and post session functions etc.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the ETL defects.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Responsible for best practices like naming conventions, Error Handling and Responsible for Performance Tuning at the Source, Targets, Transformations, Mappings and Session Level.
• Involved in Unit Testing, System Testing, User Acceptance Testing to check whether the data load into target are accurate which was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test cases based on the pre-defined test plans.
• Created data lineage documents for data flow and ETL process based on Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Autosys, Oracle 11g, DB2 V 9.1, PL/SQL,Flat Files, AQT, Erwin, Data quality, Power Exchange, Ultra Edit, UNIX Scripting, AIX, Windows XP.

Confidential, Princeton, NJ

DW/Informatica Developer

Responsibilities:

• Analyzed functional specifications provided by data architect and created technical spec document for ETL process and developed mappings based on STT documents provided by Data Modelers.
• Researched sources and identified necessary reusable components for Mapplets and Transformations
• Populated data into staging tables as a process of data integration from various heterogeneous sources.
• Installed Informatica Power Center on Client Machines and Configured the Informatica Server.
• Used Metadata data Manager for analyzing data structures, collect and link various sources.
• Worked on MDM to develop complete and accurate data feeds for storage and administration.
• Extensively used PL/SQL programming in procedures to implement business rules.
• Extensively used Unix Scripting and used PMCMD commands to interact with Informatica Server from command mode. Worked on Control M to schedule the Jobs and involved in code migrations.
• Used Workflow Manager for Creating, Validating, Testing, running Batches, scheduling sessions to run at specified time and used pre-session, post-sessions commands for calling UNIX scripts.
• Bench Mark testing of Hardware and Informatica Power Center mappings to calculate the load times for batch processing and tuning the mappings, SQL Queries, Sources, Targets, Transformations, Sessions.
• Designed and customized Data models for Data Warehouse supporting data from multiple sources.
• Extensively used PL/SQL programming in procedures to implement business rules and to achieve Data Import/Export, also used pre-post SQL scripts at session level to drop and recreate indexes.

Environment: Informatica Power Center 8.6.1(Designer, Workflow Monitor, Workflow Manager), SSIS 2008, Control-M, Master Data Management(MDM), Oracle 11g, Flat Files, Cubes, Toad, UNIX, PERL Scripting, AIX, Windows XP.

Confidential, Mettawa, IL

DW/Informatica Developer

Responsibilities:

• Worked extensively with Business community and database administrators to identify the business requirements and data realties and participated in team meetings proposed ETL strategy.
• Worked on Data Quality for quality data assurance by data cleansing, data profiling at SOR level.
• Involved in parsing high-level design specification to simple ETL coding and mapping standards and Participated in all phases including Requirement Analysis, Design, Coding, Testing and Documentation.
• Coordinated with Source System Owners to analyze true sources for data feeds which were maintained in DB2 and Data Integration from various sources like DB2, flat files, Mainframes for Teradata migration.
• Worked on Teradata SQL Assistant 7.2 to create BTEQS which are called in the informatica workflows.
• Used FastLoad and MultiLoad Types to load the bulk data into the Teradata Database Tables.
• Worked on Teradata Parallel Transporter(TPT) scripts to load Flat files into staging environment.
• Extensively worked on TPT for data integration from various heterogeneous sources and to eliminate bottlenecks in data load and Performed unit testing by generating SQL based on the Test Plans.
• Worked on Autosys to schedule the Jobs and Extensively used Unix Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.Worked with Informatica Administrator to move the Components of Informatica to the Test and Production Environments.
• Designed and Developed PL/SQL procedures to implement business rules and Data Import/Export, Designed new database tables in Teradata to meet business information needs that reflect in DB2.

Environment: Informatica Power Center 8.1(Designer, Workflow Monitor, Workflow Manager), Erwin 4.5, Flat files, IDQ, Unix Shell Programming, Autosys, IBM DB2 8.0, Data Quality 8.5Teradata V2R4, Microsoft Visual Studio, Windows 2003.

Confidential, Dallas

DW / Informatica Developer

Responsibilities:

• Worked on Field analyzing like identifying the business logic for each field, Participated in team meetings and proposed ETL Strategy. Worked on documenting solution and detail documents for the High level Design Specifications for ETL Coding and mapping standards.
• Worked in Service Oriented Architecture (SOA) and familiar with transact oriented data warehouse where data is updated and fetched real time. Worked on change data capture (CDC) while loading Dimensions by implementing SCD type 1 and type 2 from complex data extractions following business rules.
• Designed new database tables to meet business information needs. Designed Mapping document which is a guideline to ETL Coding. Documented standards handbook for Informatica code development.
• Worked with the EAI Team for error detection and correction provided a management console for performing batch validation, conversion, transformations and reporting on schemas, DTDs and XML files.
• Developed and implemented the Audit and Error handling standards for all interfaces which were Developed Using TIBCO EMS and Involved in Archiving and Maintaining TIBCO Tables(CLE).
• Extensively worked on SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, Database Triggers) to implement ETL and involved in data modeling using Erwin.
• Monitored workflows and collected performance data to maximize the session performance. And resolved memory related issues like DTM buffer size, cache size to optimize session runs.

Environment: Informatica Power Center 7.1, Power connect, Erwin 4.5, Flat files, Oracle9i, SQL Server 2005, SSIS, SSRS, PL/SQL, TIBCO BW 5.6, UNIX Shell scripts, SQL*Loader, OLAP Cubes, SAP, ABAP, Tivoli, Windows 2003.

Confidential

DW/ Informatica Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL using Informatica Power Center 7.1-Source Analyzer, Warehouse designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager. Involved in gathering business requirements to integrate SAP system to database.
• Used SAP R\3 Design Time Adapter to configure SAP Services to IDOC’s and extracted data from SAP.
• Designed new Database tables to meet business needs, created mapping document which is a guideline to ETL Coding. Developed PL\SQL procedures for processing business logic in the database and tuned SQL queries for better performance for Data extraction and processing Delta loads.
• Designed the process monitor for automation of the system which keeps the load history, load summary, load status of the system and migrated data from various source systems for building data warehouse.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Database filtering using Unix Shell Scripts (awk, sed). Shell Scripts were run through UNIX Cron scheduling Batch sessions and created Autosys entries for various data cleansing scripts and loading.
• Analyzing the data loads and supporting the production and Involved in Performance Tuning and Handled daily load issue and standardizing the system to business as usual state.

Environment: Informatica Power Center 7.1, Oracle 9i, Erwin, SQL Navigator, SAP R\3 Adapter 5.2, PERL, Win XP.

Confidential

Programmer/ Analyst

Responsibilities:

• Analysis Design & coding of the specifications and Interacted with end users to gathering requirements.
• Extensively used PL/SQL to implement cursors, triggers & packages and reports request screens.
• Co-Ordination with users and SQL tuning on existing reports and Tested Database for Performance.
• Involved in system study (Including User Requirement Study, Functional Specification).
• Developed Reports, Forms and Report format Design and Developed user friendly screen using forms
• System Testing and Client Site Implementations

Environment: Java, HTML, Oracle 8i, Developer 2000 (Forms 4.5, Reports 2.5), Windows 95/98, UML.