SUMMARY

• Around 10+ years of IT experience with expertise in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) involving RDBMS like Oracle, 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,
• Extensive knowledge on Master Data Management (MDM) concepts.
• Extensive experience on Designing, Managing and administrating MDM/DIW objects using Kalido DIW/MDM8.5/9 tool.
• Worked on designing catalogs, categories, sub-category and user roles using Kalido MDM 9.
• Populated the MDM tables using Stating table feed or File feed.
• Developed the windows batch script to load the master data for the Kalido MDM tables.
• Shared the knowledge with Business people on how to work on MDM interface, key-in the master data, authorize and publish the data.
• Worked on providing the data security for the MDM categories. Only the assigned role people can enter the data in Kalido MDM interface and to authorize or approve the master data.
• 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 like Oracle, Flat files, XML files and MS SQL Server into Oracle, XML and SQL server targets.
• Extensive experience in implementing 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 ensure data 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 the Toad for Oracle, SQL loader Imports & UTL files based on file formats.
• Converted the SSIS packages into Informatica mappings.
• Extensively worked on Repository Manager, Server Manager, Workflow Manager, and Workflow Monitor.
• Familiar with Business Objects 5.x.
• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Used Data Integration Designer to create Pentaho ETL transformations
• Developed several reports that exploited the use of Sub reports, report grouping, Pentaho Sub Confidential.
• Created dashboards in Pentaho using Pentaho Dashboard Designer.
• Designed and developed a series of complex Business Intelligence solutions using Pentaho Report Designer
• Designed, developed, implemented and maintained Informatica Power Center and IDQ 8.6.1 application for matching and merging process.
• Utilized of Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Developed mappings and workflows which supported the mappings in PowerCenter, IDQ and MDM
• Exported the IDQ Mappings and Mapplets to power center and automated the scheduling process.
• Knowledge of data profiling using Informatica Data Quality(IDQ
• Experienced with DVO, Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Designed, tested, and deployed plans using IDQ 8.5
• Production support and fix the problem by understanding its priority.
• Experienced in Software Development Life Cycle (SDLC), which includes Requirements collection, Design, Development, Testing, Deployment, Post Deployment Support
• Experienced in Data Quality Management, Master Data Management and Metadata Management
• Experienced in software development using Waterfall and Agile software development methodologies
• Experienced in Data Warehouse Application Maintenance, which includes operational excellence, change management, application performance management, data privacy management
• Experienced in data warehousing applications development for Airlines and Manufacturing industries
• Acquired Working knowledge of Repository (RPD) and Datawarehouse Application Console (DAC).

TECHNICAL SKILLS

Databases: Oracle 10g/11i, SQL Server 2012/2008 R2/2008/2005, DB2, Teradata, SQL Assistant, Teradata 14/13, My SQL 5.0/4.1, MS-Access. Editors (SQL Navigator, Toad)

ETL Tools: Informatica Powercenter 9.x, 8.x, 7.x, Informatica 9, Kalido DIW/MDM version 9

Data Modeling Tools: ERWIN, ER/Studio

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

Methodologies: Data Modeling - Logical, Physical Dimensional Modeling - Star / Snowflake

Reporting Tools: MS SQL Server Reporting services 2008 R2, Developer 2000(Forms 5.0, Reports 6i), Crystal Reports 10, OBIEE, Business Objects, and Cognos.

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

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Sr. Informatica Developer

Responsibility:

• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases, and user guides.
• Actively involved in the Design and development of the STAR schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Mentored Informatica developers on project for development, implementation, performance tuning of mappings and code reviews.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Developed Informatica mappings/mapplets, sessions, Workflows for data loads and automated data loads using UNIX shell scripts.
• Used variouslookup caches like Static, Dynamic, Persistent and Non-Persistent in Lookup transformation.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.
• Successfully migrated objects to the production environment while providing both technical and functional support.
• Used Power exchange CDC (change data capture) for pulling from oracle source.
• Developed E-MAIL tasks to send mails to production support and operations.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Installed/configured Teradata Power Connect for Fast Export for Informatica.
• Resolved Skewness in Teradata.
• Created jobs for Informatica data replication fast clone to get data from oracle and load it into Teradata.
• Wrote BTEQ scripts of Teradata extensively.
• Worked on different types of prompts like value, text, date, time etc in Cognos reporting.
• Drill through the parent-child hierarchy based on ID in Cognos reporting.
• Worked with framework manager, Cognos connection, query reporting, report studio.
• Worked on standalone and embedded reports of Cognos.
• Designed and developed UNIX Scripts to automate the tasks.
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle db).
• Extracted and Transformed data into Staging Servers named as PStaging Server for historical data and TStaging Server for load increment.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Extensively worked on Power Center 9.5.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed & developed Informatica mappings, mapplets, worklets and workflows to create load-ready data files for loading Oracle E-Business Suite (EBS).
• Did data validations in Informatica mappings and loaded the target validation tables.
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes
• Created data objects in Informatica Data Quality
• Previewed the data objects in csv files and ran the validation scripts in Excel.
• Created expression rules and ran profiles on the source data.
• Created scorecards for redundant data and created validation rules using word wrapper in IDQ.
• Created reference tables in Oracle 11g and used it as database dictionaries in IDQ.
• Did data profiling for the column/across table data validation.
• Parsed the target data in IDQ using parser transformation.

Environment: Informatica Power Center 9.5.1 HF3/9.1.0 HF1, Informatica IDQ 9.6.X, Informatica Cloud, Oracle 11g, SQL Server 2012/2008 R2, Erwin - 4.0, TOAD 9.x, Oracle EBS, Shell Scripting, Teradata 14, SQL Assistant, Oracle SQL *Loader, Cognos e-business suite, PL/SQL, SSIS and Sun Solaris UNIX, Windows-XP.

Confidential, Houston, TX

Senior 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.
• Did the managed file transfer (MFT) from the legacy server to Informatica server.
• 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, work lets, 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.
• Worked extensively on Cognos cube development for the financial reports.
• Changed Cognos financial reports based on end user requirement by applying appropriate filters.
• Created the Cognos connections for web portal and content store.
• Developed a query subject in framework manager in Cognos.
• Integrated the sales force data into target Oracle using Informatica cloud.
• Validated the sales force target data in force.com application.
• Created Invoices, Cash Receipts, RMA, RMA Start into Sales Force from Oracle EBS.
• Extensive knowledge on Master Data Management (MDM) concepts.
• Extensive experience on Designing, Managing and administrating MDM/DIW objects using Kalido DIW/MDM8.5/9 tool.
• Configured business objects Universe.
• Made changes to BO financial reports based on user input.
• Calculated the KPI’s and worked with the end users for OBIEE report changes.
• Created the RPD for OBIEE.
• Worked on creating physical layer, business model, mapping and presentation layer in OBIEE.
• Created source system containers for OBIEE.
• Created subject areas in containers for OBIEE.
• Created narrative reports in OBIEE.
• Administrative role and monitoring and support for several projects in Staging and Production environments for Informatica and OBIEE.
• Created the metadata layer for OBIEE.
• Installed/configured SAP adaptor and JD Edwards (Power Exchange) for Informatica.
• Configured Informatica for the SAP Connector.
• Extracted data from SAP and loaded into Oracle EBS
• Retrieved data from SAP using Informatica Power Exchange.
• Configured SAP IDoc connector for Informatica.
• Retrieved data from SAP IDocs using Informatica connector.
• Configured Informatica Power Exchange add on for SAP Hana (Power Connect)
• Worked on designing catalogs, categories, sub-category and user roles using Kalido MDM 9.
• 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 Standard 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 Powercenter 9.1.0 HF1, Oracle 11g, SQL Server 2012/2008 R2, SSIS, Netezza 7.2.0, Oracle SQL* LOADER, Flat Files, UNIX Shell Scripting, TOAD Informatica 9, SalesForce dot com(SFDC), OBIEE, Business Objects.

Confidential, Norfolk, VA

ETL/Informatica Developer

Responsibilities:

• Perform analysis and gathering requirement by coordinating with Business Users.
• Prepare High Level and Low Level Design Specifications.
• Prepare Source to Target mapping documents for ease of ETL implementation.
• Prepare specifications to create new Data model by coordinating with Data Architect and DBA.
• Created and reviewed Informatica mappings, sessions and workflows.
• Created test data, test scripts, perform testing and review test results.
• Extensively worked on created and reviewing SQL scripts and UNIX shell Scripts.
• Tuned embedded SQL in Informatica mappings.
• Extensively tuned Informatica mappings, sessions by following best practices to avoid unnecessary caching of records by the lookups.
• Created and used native SQL for performing updates where Informatica is taking more time on huge dataset tables.
• Created SSIS packages using BIDS.
• Imported data from AS400 to be loaded into SQL Server 2008 into the dbo schema through import wizard and stored it as an SSIS package.
• Worked with the business objects developers in building the universes.
• Made changes to BO reports from the user’s input.
• Configured the fast export utility of Teradata.
• Loaded data using the Teradata utilities like FLoad, MLoad.
• Retrieved data from Teradata using the fast export utility.
• Purging old data using Post-SQL in Informatica mappings.
• Created Crystal reports connections to Oracle and SQL Server using deisgner.
• Optimized the crystal reports queries for faster reports retrieval.
• Involved in development of Informatica interfaces.
• Involved in periodic team Meetings to get regular updates from the team.
• Involved in pulling data from XML files, flat Files, SQL Server into Data warehouse and then Data Mart.
• Participated in logical & physical and STAR Schema for designing the Data Marts.
• Wrote complex SQL scripts to avoid Informatica Joiners, Unions and Look-ups to improve the performance as the volume of the data was heavy.
• Provided requirements to the Business Objects development team to create reports.
• Involved in working with the Business Objects team to create required Universe measures to auto populate values at the report level.

Environment: Informatica Powercenter 8.6, Windows XP/2003, UNIX, XML, Oracle 10g, Teradata 14, IBM Mainframes, SQL Server, EJB, JSP, JDBC,VISIO, Cognos, SQL and PL/SQL, Power Exchange. Business Objects XI edition.

Confidential, Bloomington, IL

ETL/Informatica Developer

Responsibilities:

• Coordinated the meetings with Architects and Business analysts for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.
• Involved with source systems owners, day-to-day ETL progress monitoring, Data warehouse target schema design (star schema) and maintenance.
• Worked with Team Lead and Data Modeler to design data model using Erwin 7.1
• Extensively worked on multiple sources like Oracle 10g, DB2, MS SQL server, XML and delimited flat files to staging database and from staging to the target XML and Oracle Data Warehouse database.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica PowerCenter 8.6.1/7.1.4.
• Worked closely with the Cognos reports development team in configuring the cubes.
• Created Cognos cubes and denormalized the data for faster access.
• Customized the Cognos reports.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Most of the transformations were used like the Source qualifier, Router, Aggregators, Connected & Unconnected Lookups, Unions, and Filters & Sequence.
• Worked on requirement gathering for B2B XML’s feed (Customer and Product).
• Developed XML’s using XML parser Transformation for large scale data transmission.
• Developed functional and Technical design documents for implementing Informatica web services.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Used SQL tools like TOAD 9.6.1 to run SQL queries and validate the data in warehouse.
• Used Unix Shell Scripts for automation of ETL Batch Jobs.
• Involved Bulk data loading used J2EE Web Service to FTP XML’s Feed (Customer & Product) to B2B.
• Performed various operations like scheduling, publishing and retrieving reports from corporate documents using the business objects reporting.
• Conducted interviews and organized sessions with Business and SMEs located at various theaters across the globe to obtain domain level information and conduct analysis.
• Involved in preparing Test script documentation for Load Testing and involved in ping tests conducted on servers from different theaters across the globe
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements.

Environment: Informatica Powercenter 8.1, Oracle 10g/9i, Linux, XML, SQL SERVER, PL/SQL, TOAD 9.6.1, Unix, Business Objects XI, Cognos E-Business Suite, Cognos BI Suite 6.0/7.2, Shell Scripts, SQL Navigator.

Confidential, Pittsburg, PA

Informatica Developer/ Data Analyst

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.
• 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.
• Worked closely with crystal reports developers in populating the reporting layer denormalized data.
• Involved in DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Standard 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 Powercenter 8.1.1 SP4, Oracle 10g, Oracle SQL * Loader, Flat Files, UNIX Shell Scripting, TOAD, Approrx 6.0, Crystal reports.

Confidential

Sr. Informatica Developer

Responsibilities:

• Moved data from legacy systems to Oracle Server 7.3 using SQL*LOADER and PL/SQL procedures
• Involved in data modeling.
• Creating physical data model.
• Designed the application security.
• Created all Oracle schema objects.
• Wrote triggers and stored procedures.
• Analyzed various Schemas for Implementation and Modeled the Data Warehousing Data marts using Star Schema.
• Created mappings using the Transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, Update Strategy etc.
• Extracted data form flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed complex mappings and mapplets in Informatica to load the data using different transformations.
• Created and Monitored Sessions and Batches using Server Manager.
• Extensively used various Performance tuning Techniques to improve the session performance (Partitioning etc).
• Successfully moved the Sessions and Batches from the development to production environment.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Generated completion messages and status reports using Workflow manager.
• Created workflows and worklets for designed mappings.
• Developed mappings and loaded data on to the relational database. Worked on Dimension as well as Fact tables.
• Extensively used PL/SQL Procedures/Functions to build business rules.
• Created User conditions and Filters to improve the report generation.

Environment: Informatica PowerCenter 8.1, Oracle8i, Flat files, SQL, PL/SQL, UNIX, Developer2000, SQL*Loader, PL/SQL procedures, Windows 2000.