SUMMARY

• Over 7 years of experience in designing, developing and maintaining large business applications such as data migration, integration, conversion, data warehouse and Testing
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Expertise in data warehousing, ETL architecture, Data Profiling using Informatica Powercenter 9.0.1/8.6/8.1/7.1/6.2 - Client, Server tools and power exchange
• Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Mart/ Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, ERP Source Qualifiers, XML, Aggregators, Filters, Joiners
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in Dimensional Data Modeling experience using Data modeling, Erwin Modeling (Erwin 4.0/4.0) like Physical & logical data modeling.
• Experience with Data Extraction, Transformation and Loading from different data sources like Oracle, MS SQL Server etc. into a common analytical data model using InformaticaPower Center 9.x/8.x/7.x/6.x.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, transformations & Sessions.
• Expert in Teradata SQL, Teradata (TD) Utilities (BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert, TD Administrator 7.1, TD SQL Assistant 7.1).
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in writing shell scripting for various ETL needs and worked on integrating data from flat files (mainframe).
• Experienced in working with the tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Experience with UNIX Shell Scripting, PL/SQL Coding, Normalized Database creation in relational databases like Oracle 9i/8i, MS-SQL Server 2000 and optimizing the SQL to improve the performance.
• Business Intelligence experience using Business Objects 6.x/5.x/4.5x, Web Intelligence 2.5, Cognos 8 Suite, Cognos Impromptu 8.x/7.x/6.x, Power play, Transformer, and Impromptu Web Reports.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Link.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions.
• Strong experience in Oracle database Performance Tuning and extensive experience in SQL * Loader Imports/Exports
• Expert in creating Data Structures i.e. Tables & Views and applying the referential Integrity.
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x,Star Schema, Snowflake Schema, OLAP, OLTP, Power Exchange 9.x/8.x/7.x.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.x

Databases: Oracle 11g/10g/9i/8i, SQL Server 2008, Teradata, DB2, MS Access 2008.

Reporting Tools: BUSINESS OBJECTS - Designer and Supervisor, Cognos 8.x suite.

GUI: Visual Basic, Macromedia Dreamweaver MX, FrontPage 98/2K, Visio, MS ProjectTOAD, SQL Navigator, Teradata SQL Assist, Putty & SSH.

Programming: SQL, PL/SQL, Transact SQL, HTML, DHTML, XML, C, C++, ASP.NET and Shell.

Environment: Windows95/98/2000/XP/ 2003/2005/2007 , Unix-AIX 5.2/4.3, Sun Solaris 2.6/2.7/2.8/8.0 , Red Hat Linux, WinNT4.0

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. Informatica Developer

Responsibilities:

• Accurately identifying the business information that must be contained in the Warehouse.
• Identifying and prioritizing subject areas to be included in the Data Warehouse.
• Developing a scaleable architecture to serve as the Warehouse's technical and application foundation, and identifying and selecting the hardware/software/middleware components to implement it
• Managing the scope of each subject area which will be implemented into the warehouse on iterative basis.
• Accurately identifying the business information that must be contained in the Warehouse.
• Worked handling a team of developers in technical discussions and routing of data.
• Involved in designing dimensional modeling and implemented STAR flake, SNOW flake schemas.
• Extracting, cleansing, aggregating, transforming and validating the data to ensure accuracy and consistency.
• Defining the correct level of summarization to support business decision making.
• Providing user-friendly, powerful tools at the desktop to access the data in the Warehouse.
• Educating the business community about the realm of possibilities that are available to them through Data Warehousing.
• Establishing a Data Warehouse Help Desk and training users to effectively utilize the desktop tools.
• Establishing processes for maintaining, enhancing, and ensuring the ongoing success and applicability of the Warehouse.
• Defining the correct level of summarization to support business decision making.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Performed the performance evaluation of the ETLs for full load cycle.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, and sequence generator.
• Used Joins and other complex queries to view the results that meet the business decision.
• Created Database Objects like Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure and Constraints.
• Prepared and implemented data verification and testing methods for the Data Warehouse as well as to design and implement data staging methods and stress testing of ETL routines to make sure that they don’t break on heavy loads.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Automation of job processing, establish automatic email notification to the concerned persons.

Environment: Informatica Power Center 9.x/8.x, Oracle 11g/10g/9i, MS SQL 2008,, Toad 8.6, Sun Solaris 9/10, SQL, MS Office Visio 2003, Appworx Enterprise Job Scheduler, Tidal Enterprise Job Scheduler .

Confidential, TX

Sr Informatica Developer

Responsibilities:

• Extensively involved in writing ETL Specs for Development and conversion projects
• Based on the business requirements designed and developed Informatica Mappings.
• Extracted the data from Facets to ODS.
• Developed Informatica mappings that performed transformations on Facets data resulting in oracle and flat files that will be sent to the ODS.
• Created shortcuts for source and target and also created Reusable Transformations, Mapplets in Shared folder.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Used Change Data Capture (CDC) for moving data from Source to Target.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, and sequence generator.
• Used mapping parameters and variables
• Creating sessions, worklets and workflows for carrying out test loads.
• Performed the performance evaluation of the ETLs for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex Problem troubleshooting.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Scheduled the batches using UNIX.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Automation of job processing, establish automatic email notification to the concerned persons.
• Coordinated with testing team in all three phases of testing including end-to-end testing.
• Written Detail design documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 8.1, Oracle 10g, MS SQL 2008, VSAM Files, Eclipse 3.0, Toad 8.6, Unix Shell Scripts, Unix Server, Sun Solaris 9/10, SQL, MS Office Visio 2003.

Confidential, TN (Nashville)

Sr Informatica Developer

Responsibilities:

• Based on the business requirements created High level and low level Design Documents.
• Coordinated with team and Performed code review
• Interacted with Data modular and DBA and Source systems and resolved the Issues.
• Designed and Developed Informatica mappings serving as interfaces betweenmultiple environments.
• Involved in creating Informatica mapping to populate staging tables and data warehouse tables from Mainframe sources.
• Extensively involved in writingETL Specsfor Development and conversion projects.
• Created shortcuts for source and target and also createdReusable Transformations,Mappletsin Shared folder.
• Extensively usedInformaticaclient tools - Source Analyzer, Warehouse designer, MappingDesigner, Mapplet Designer,TransformationDeveloper, InformaticaRepository Managerand InformaticaWorkflow Manager.
• Worked extensively on different types of transformations like Source qualifier, Expression, Aggregator, Router, Filter, Lookup, update Strategy & Sequence Generator.
• Used mapping parameters and variables
• Creatingsessions, worklets and workflowsfor carrying out test loads.
• WrotePL/SQL Stored Proceduresbased on the Requirements.
• Extensively createdBTEQscripts to implement post load processes.
• Extensively createdMLOAD,FLOADandTPUMPcontrol files to load data in to DW.
• Extensively used FAST EXPORT script to unload data from DW and send them to other systems to use them as source.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Checked Sessions and error logs to troubleshoot problems and also useddebuggerfor complex Problem troubleshooting.
• Identified and fixedbottlenecksand tuned the complex Informatica mappings for better Performance.
• Scheduled the workflows using Autosys for daily loads and monthly loads.
• Worked onParameterizeof all variables, connections at all levels in UNIX.
• Automation of job processing, establish automatic email notification to the concerned persons.
• Created test cases for carrying out unit testing and part of functional testing.
• Coordinated with testing team in all three phases of testing including end-to-end testing.

Environment: Informatica Power Center 7.1.4 Oracle 9i/10g, DB2 UDB, Teradata, ERWIN 4.0, Toad 8.6, Unix Shell Scripts, Unix Server, HP-UX 11i, Sun Solaris 5.4, SQL,MS Office Visio 2003

Confidential

Sr Informatica Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Created Metadata - Identified Source-to Target mapping, mappings logic and calculations
• Performed reverse Engineering and de-normalized dimensions.
• Created Star Schema with slowly changing Dimension Type 1 and Type 2.
• Worked extensively on different types of transformations like Source qualifier, Expression, Aggregator, Router, Filter, Update strategy, Lookup, Sorter, Normalizer and Sequence generator.
• Used mapping parameters and variables.
• Designed the data-hub to include meta-data for Auditing and error/exception processing needs
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Used Change Data Capture (CDC) for moving data from Source to Target.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Work closely with various levels of individuals to coordinate and prioritize multiple projects. Estimate, schedule and track ETL projects throughout SDLC
• Migrated DTS Packages to SSIS packages
• Strong leader with experience in SSIS training, advising developers on SSIS tuning and best practices.
• Integration of mainframe and Unix environments in Data warehousing
• Creating sessions, worklets and workflows for carrying out test loads.
• Involved in performance tunings - Removed bottlenecks, partitioned tables and sessions, created materialized views with query-rewrite.
• Tuned buffer block size, Index cache size and data cache size for Aggregator Lookup and Joiner transformations.
• Involved in Package Management.
• Developed List of Values, Dynamic Cascading prompts, Business Views to be used in the reports.
• Worked on UNIX directory setup for database scripts and logs.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Developed Korn shell scripts in UNIX to automate the log file backup process.
• Log analysis in UNIX environment.
• Used Power exchange to get main frame data in a single step.
• User administration and file/folder administration in UNIX environment.
• Participated in User Acceptance Testing (UAT).
• Created pre- and post-load scripts to drop indexes and key constraints before session and rebuild those indexes and key constraints after the session completes.

Environment: Informatica Power Center 7.1 Oracle 9i, MS SQL, Business Objects, Crystal Report, Mainframes DB2 UDB, Informatica Power Connect/ Power Exchange, VSAM Files, Toad, Unix Shell Scripts, Unix Server, HP-UX, Sun Solaris 9/10, SQL, MS Office Visio 2003.

Confidential

Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Played a key role in designing the application that would migrate the existing data into Annuity warehouse effectively by using Informatica Power Center.
• Data modeling and design of for data warehouse and data marts in star schema methodology with conformed and granular dimensions and FACT tables.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created and managed the local repositories and permissions using Repository Manager in Oracle Database.
• Created users and groups and assigned privileges using Repository Manager.
• Involved in the creation of Fact Tables and Cubes (Dimensions and Measures).
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Moving mapping and sessions from development to production environment.
• Created Schema objects like Indexes, Views, and Sequences.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
• Tuned mappings for improving performance.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length.
• Siebel Analytics was used for the reporting Queues, Adviser and Managers performance.
• Responsible for extracting data from Siebel OLTP data base
• Automated load run on Informatica sessions through UNIX Korn, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures with successful notification through email.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Used Power Exchange to provide Change Data Capture and Real Time support from Mainframe
• Developed Stored Procedures.
• Involved in Working with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.

Environment: Informatica Power Center 6.2(Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), SQL Server 2000/2005(Query Analyzer, DTS, TSQL), Oracle, PL/SQL, SQL* Loader, TOAD, Siebel OLTP, Business Objects 6.0, Sun Solaris 2.7,, Mainframes DB2 UDB, Power Exchange.