SUMMARY

• Over seven years of IT experience in development, design and implementation with major focus on database and data warehousing applications
• Strong in Data warehousing Concepts, Star Schema and Snowflakes Schema methodologies, understanding business process/requirements.
• Experienced with dimensional and relational database design.
• Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle.
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Extensively worked on Extraction Transformation and Loading (ETL) using Informatica 8.6.1/8.1/7.1/6.1.2/5.1/4.7 (Power Center).
• Worked extensively with OLAP / BI tools such as Webfocus, Business Objects, Cognos.
• Excellent experience in tuning Informatica Mappings and Sessions for optimum performance.
• Involved in massive data cleansing prior to data staging.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Expert in implementing business rules by creating Re - Usable Transformations like Mapplets and Mappings.
• Proficient in using Informatica Server Manager to create & schedule sessions and batches.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Experience using Teradata utilities BTEQ, FastLoad, MultiLoad, FastExport, Tpump, SQL Assistant, SQL Administrator.
• Experience in writing PL/SQL (Stored Procedures, Triggers, Functions) and SQL statements.
• Worked with testing team to create test cases for unit and system testing.
• Experience in Repository administration (Creating back-up and User Groups).
• Good knowledge in Scheduling ETL Jobs tools like Autosys, Appworx.
• Experience in UNIX shell scripting, CRON, FTP, WFTP and file management in various UNIX environments.
• Experience in development methodologies like RUP, SDLC and Waterfall.
• Post production support, handling new enhancements and customer support.
• Exceptionally well organized, strong work ethics and willingness to work hard to achieve employer objectives.
• Effective in cross-functional and global environments to manage multiple tasks & assignments concurrently.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.6/8.5.1/8.1.1/7.1.4/6.2/5.1 (PowerCenter/PowerMart), SQL Server SSIS/DTS

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 3.5.2/3.x, Oracle Designer

Business Intelligence: OBIEE 10.1.3.2/10.1.3.4.1, Business Objects 6.5.1/6.1b/5.1, MS Access Reports

Databases: Teradata V2R12/V2R6/V2R5, Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000/2000, DB2 UDB, MS Access 2000, Sybase Server 12.x/11.x.

Others: Java, Toad, SQL Navigator, Harvest, Maestro, Autosys, HTML 4.0, DHTML, XML 1.0, SQL, PL/SQL, Rational Clear Quest, Clear Case, Unix Shell Scripting

Environment: AIX, NCR UNIX SVR4 MP-RAS, HP-UX, MS DOS 6.22, Win NT/2000/2003

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, Missouri

Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model.
• Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalizer, rank and router transformations.
• Worked informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Worked Extensively with Slowly Changing Dimensions i.e. Type1 & Type2
• Developed informatica mappings and also tuned for better performance.
• Worked with MLOAD, FASTLOAD, TPUMP and BTEQ utilities of Teradata for faster loading and to improve the performance.
• Extensively used Informatica to load data from flat files, Oracle, Teradata database.
• Teradata views have been developed against the Departmental database and claims engine database to get the required data.
• Developed application views in Teradata and using expression and router implemented the Change Data Capture (CDC) process.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• These views are built through Harvest Change Manager Tool in desired schema in Teradata Warehouse and used as one of the sources for informatica.
• Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involved in Unit testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
• Worked with many existing Informatica mappings to produce correct output.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Detail system defects are created to inform the project team about the status throughout the process.
• Development is done by following SDLC and later now following RUP (Rational Unified Processing).

Environment: Informatica Power Center 9.1.0/8.6.1/8.1.3, Oracle 10g, UNIX Shell Scripting, Rational Clear Quest, HIGH RUP (Highmark’s Rational Unified Processing), Windows.

Confidential, Farmington hills, Michigan

ETL Developer

Responsibilities:

• Analyzing the source data coming from different sources and working with business users and developers to develop the Model.
• Extracted data from flat files and oracle database applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter8.6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1. for extraction, loading and transformation (ETL) of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented slowly changing dimensions to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Tuned performance of Informatica sessions for large data files by implementing pipeline partitioning and increasing block size, data cache size, sequence buffer length and target based commit interval and resolved bottlenecks
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Created and implemented variables and parameters in the Mapping Designer
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents based on the BRD and SRS.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQL, PL/SQL, XML, AS 400, MS Access, Web services, JAVA, UNIX, UDB DB2 8.1, Shell Script, Business Objects.

Confidential, Sacramento, CA

Informatica Developer

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Created logical and physical data models using Erwin.
• Created Entity Relationship (ER) diagrams based on requirements.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Migrated repository and Informatica mapping from 7.1.4 to 8.5.1
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Developed mapplets and worklets for reusability.
• Implemented weekly error tracking and correction process using Informatica.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Created multiload/tpump scripts for data loading.
• Creation of customized Mload scripts on UNIX platform for Teradata loads
• Written several Teradata BTEQ scripts to implement the business logic.
• Created Test tables and worktables on development and production on Teradata.
• Worked extensively with the Teradata Queryman to interface with the Teradata.
• Extensively used Stored Procedures, Triggers, Functions and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Created Maestro schedules/jobs for automation of ETL load process.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Extracted the JMS text messages from the Oracle Advance Queue (JMS Provider) through the JMS Adapters installed on Informatica Power Center Server.
• Worked with JMS text messages as a source system, which arrive in the form of XML payload and also implemented Mid-stream transformations such as XML parser transformation to parse the XML string.
• Formatted Reports as per the user requirements using extensive functionalities in Business Objects, which allows the users to analyze the data.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, functions, Cross Tab, Master/Detail and Formulae etc.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.
• Involved in the Production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 8.5.1/7.1.4, Teradata V2R5, Oracle 10g, Unix, DB2,Sybase 12.x, MS SQL server 2005, TIBCO, TOAD, Erwin, WINCVS, XML, HP-UNIX.

Confidential

Informatica Developer

Responsibilities:

• Involved in gathering of business scope and technical requirements and written technical specifications.
• Involved in all phases of software development life cycle (SDLC) in RUP framework.
• Fine-tuned existing Informatica maps for performance optimization.
• Developed complex mappings inInformaticato load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected)
• Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in massivedata cleansingand data profiling of the production data load.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys
• Stored procedure transformation type for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions.
• Created FTP scripts to transfer data from consumer systems to Confidential systems, and Conversion scripts to convert data into flat files to be used for Informatica sessions.
• Worked onInformaticatool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet and Transformations.
• Involved in capturing slowly changing dimensions of all varieties including type-I, type-II, type-III.
• Used ready wizards in Informatica to capture and implement SCD Type-II (Changing Data) and tuned it requirement.
• Involved in the development of Informatica mappings and alsotuned for better performance.
• Extensively used ETL to load data from flat files (excel/access),Teradata database.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Involved in the Unit testing, Event & Thread testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required.
• Develop and execute load scripts using Teradata client utilities MULTILOAD, FASTLOAD and BTEQ.
• Written JCL scripts and created stored procedures in TERADATA SQL Assistant.
• UsedUNIXto run FTP scripts, which transferred data from the UNIX server to the Windows NT server.
• Made adjustments in Data Model andSQLscripts to create and alter tables.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Wrote many SQL/PLSQL scripts to verify data in the DB.
• Involved in Data Validating, Data integrity, Performance related to DB, Filed Size Validations, Check Constraints and Data Manipulation and Updates by using SQL Single Row Functions.
• Scheduled and monitored automated weekly jobs under UNIX environment.
• Extensively involved in testing the system from beginning to end to ensure the quality of the adjustments made to oblige the source system up-gradation.
• Involved in tracking and reporting defects using Clear Quest and was also responsible for communicating the status to the team in bug meetings.
• Worked with many existingInformaticaMappings to produce correct output.
• Made use of Server Manager to create and monitor sessions and batches.
• Efficient Documentation was generated for all mappings and workflows.

Environment: InformaticaPower Center 8.5.1/7.1.2, Custom programming using Perl,IMS Data(Xponent, Xponent Plantrak, PlanTrak, Rx Data), Teradata V2R6,Oracle 10g, MS SQL Server 2005/2000, RTMS, HPUNIXShell Scripting,PL/SQL, Syncsort forUNIX,Rational Clear Quest, Windows 2000, HP-UX.