SUMMARY

• 8+ years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Healthcare, Aerospace/ Defense and Public Sectors.
• 8+years of design and development of complex ETL processes using Informatica Power Center (9.x/8.x/7.x).
• 5+ years of Lead experience managing team of 10 BI Resources. And Data modeling experience using Erwin.
• Experience with relational databases such as Oracle8i/9i/10g/11g, unstructured data sources (XML, COBOL and flat files)
• Strong Knowledge of Informatica Data Transformation (DT) Studio development
• Involvement in all phases of SDLC (Systems Development Life Cycle) from analysis and planning to development and deployment.
• Srong experience in PL/SQLDevelopment
• Strong experience designing Star Schema and Snowflakes Schema in relational
• Data Profiling and Data cleansing experience.
• Has led the team for Stress testing and optimization for Informatica.
• Experience of production support and making sure loads are done in an efficient manner
• Strong skills in SQL, PL/SQL packages, functions, stored procedures and materialized views to implement business logic in oracle database.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Worklets and Workflows for data loads.
• Experience in identifying and resolve ETL production root cause issues. Expertise in maintenance, enhancements, performance tuning of ETL code.
• Knowledge of Informatica administration in windows and Linux environment.
• Developed test cases for business and user requirements to perform System/Integration/User Acceptance testing.
• Interact with business units to understand their needs and design appropriate RPD objects.
• Experience in designing out - of-the-box RPD objects and report layout framework, designing various dimensions and facts for star/snowflake and practical knowledge to design the ETL and reporting layer for the same.
• Prepared technical documentation for all new or modified RPD objects and ETL mappings.
• Prepared Code Migration requests using automated code migration tool.
• Participated in design of new data warehouse tables as needed
• Designed and conducted unit tests of new or changed RPD objects and ETL mappings

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.1/6.2/5.1, Power Exchange 8.6.1, Informatica MDM, BO Data Integrator, Informatica IDQ, Informatica DVO, Informatica B2B Data Exchange 8.6

Data Modeling: ERWin Data Modeler r7.3/4.x (ERD),MS Visio 2000

Databases: Oracle 8i/9i/10g MS SQL Server 2000/2005, MS Access

Job Schedulers: Tidal, Control M

Languages: SQL, Oracle PL/SQL, Korn Shell Scripting (KSH)

Version Control: MS Visual Source Safe (VSS), IBM Rational ClearCase

Others: Microsoft Office 2010 (Excel, PowerPoint), WINSCP, PUTTY.

PROFESSIONAL EXPERIENCE

Confidential

Sr Informatica Dev

Responsibilities:

• Developed ETL Design Documents and managed the Business rules and data validation.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Worked with transformations such as expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation.
• Simple, Medium, complex mapping design, development and scheduling.

Environment: Windows vista/7, PL/SQL developer, Sybase, Informatica Powercenter, Oracle, SQL Server, Erwin, Agile/Scrum development methodology

Sr. Informatica Dev

Confidential, Omaha, NE

Responsibilities:

• Interacted with Business Owner for day-to-day ETL progress monitoring.
• Project coordination, End User meetings.
• Researched Sources and identified necessary Reusable Components for Mapplets and Reusable Transformations.
• Co-coordinated with Source System Owners for proper data feeds and Defaults for the Incoming Data.
• Populated data into staging tables from flat files, XML sources, Cobol Copybooks and Relational Sources.
• Installed Informatica Power Center on Client and Server Machines and Configure the Informatica Server and Register Server.
• Hands on experience working with IMS data.
• Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
• Responsible for moving mapping elements to UAT, QA and production by Importing/exporting as XML files, subsequently create the data migration documents for UAT.QA & PROD.
• Performed Data Migration where the relational data is extracted from different sources (Flat files / Excel sheets / XML files), transformed and loaded into the target Oracle database without any data loss.
• Extensively involved in code conversion and Data Migration activities while moving the code from DB2 to Oracle 10g.
• Used Power Connect to extract data from SAP into the target database.
• Experience Star Schema modeling, and Snowflake modeling. Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment and CDC (change data capture).
• Used Workflow Manager, Repository Manager for Creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
• Tuned the Informatica Mappings for optimum performance. Replaced filters with Routers and SQL overrides in place of homogeneous sources.

Confidential

Sr Informatica Consultant

Responsibilities:

• Designed the ETL solution for doing various complex computations (involving Pivoting, Interpolation, Logarithmic calculation, Rounding to match Access Database for accuracy of up to 16 decimal precision accuracy
• Used Informatica's Data Transformation Accelerator to map customer information contained in an XML file and map it to different XML file format for the downstream application
• Also Sourced XML files containing market data. Used source qualifier transformation to Pass XML data and an output file name to the Unstructured Data transformation. Used data Transformation Engine to transform the XML data to a Microsoft Excel file. Used XML Parser transformation to split the input data into segments. Sending the header and detail rows to relational targets for downstream processing while returning the pass-through data to a Filter transformation
• Successfully delivered most complex ETL code with only 1 defect under constantly changing user requirements.
• Using Informatica MDM solution for doing impact analysis and preparing the lineage chart for business.
• Proficient in understanding COBOL and XML files and experience loading data using Unstructured data transformation, XML Parser, Normalizer, WSDL transformations.
• Preparing the audit procedure to provide User with flexibility to rerun the process for any previous day, to align the audit procedure to track the data flow from different source system including the daily market data and the updated product portfolio.
• Helped the QA team by preparing complex SQL queries (to reproduce highly complex ETL code having around 150 columns) thus decreasing the testing times by almost 30-40%.
• Analysis, design, development, production migration and troubleshooting of complex ETL mappings.
• Designed the ETL solution for doing various complex computations (involving Pivoting, Interpolation, Logarithmic calculation, Rounding to match Access Database for accuracy of upto 16 decimal precision accuracy.
• Preparing the audit procedure to provide User with flexibility to rerun the process for any previous day, to align the audit procedure to track the data flow from different source system including the daily market data and the updated product portfolio.
• Successfully promoted the first phase of ETL development under constantly changing

Environment: based on CR that needs to be incorporated after analyzing the throughput of downstream application.

Confidential

Sr Informatica Developer

Responsibilities:

• Designed data model and an optimized ETL solution for populating Facts, Dimensions, Minidimension, Factless fact, Bridge tables, audit and error table.
• Design & Build BI Delivery components (Dashboards, Reports, iBots, etc.).
• Translated business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Reports and dashboards development inOBIEEusing data from both relational and OLAP data sources.
• Expertise in understanding the Reporting/OLAP concepts.
• Implemented Change Data capture, pushdown optimization, Partitioning in Informatica.
• Prepared fully excel based automated test scripts for reducing the time required by developer for testing ETL code.
• Preparing higher level and lower level design of the Informatica maps.
• Implementing different Change Data capture and incremental technique while pulling the data from DB2, flat file, SAP and SQL server and populating in SQL server.
• Currently designing the data profiling and data cleansing approach since the Data Warehouse involves integrating the data from SAP, DB2, flat file, Oracle and SQL server.
• Actively involved in designing, developing, creating complex and simple mappings, Mapplets using Informatica source, warehouse and loading the data.
• Mentoring the team on standard design and development practices and doing POC for different team to facilitate their work using the Informatica ETL.
• Hands on various Informatica transformations like expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation, normalize etc.

Environment: Windows vista/7, Informatica 9.1.0, SQL Server Management Studio, Toad, DB2, Fixed width flat file, OBIEE 11g

Confidential

Solution Architect

Responsibilities:

• Designing the table level structure for an optimized ETL solution, denormalizing the table as required.
• Successfully led a team of 7 resources (including Informatica and DBA’s) and build a data mart from scratch, the project was delivered on time and within budget.
• me worked as a Developer to prepare a POC where we used Unstructured Data transformation to call a Data Transformation parser service to extract order information from a Microsoft Word document and write the order information to an order header table and an order detail table.
• Used Unstructured Data transformation to call a Data Transformation parser serviceto extract order information from a Microsoft Word document and write the order information to an order header table and an order detail table.
• UsedData Transformation Parser and Mapper componentsto transform data from word fileto generate XML data.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency.
• Created Power Exchange Data maps to Capture Changed data (CDC) from Legacy Systems
• Created JMS services to read source file for each partner and assigning to real time workflow.
• Installed Data Transformation Engine, Studio, configured JMS to pass source as BUFFER and pass Data By Reference to Data Transformation.
• Created scripts by parsing different formats of sources like .xls, cvs, xml, pdf, etc. and related variables and assigning values for source and target columns and passing into mapping.
• Validating, Running the scripts and deploying the scripts in server DB folder.
• Designed the ETL solution for doing various computations required for Forecasting, Valuation and Material Management.
• RPD Development for Sales subject area using OBIEE administration tool (Building hierarchies, Using bridge tables, Aggregate tables and Partitioning).
• Developed dashboards and assisted in development of complex ad hoc queries and analyses. (Using prompts, filters, sections and various views).
• Mentoring the team on standard design and development practices and doing POC for different team to facilitate their work using the Informatica ETL.
• Understanding SAP R/3 business functional areas and discussing with users the report layout structure and getting the UAT signoff’s.
• Actively involved in designing complex and simple mappings, Mapplets using Informatica source, warehouse and loading the data.
• Working as an ETL onsite lead and making sure the implementation is done according to standards and is optimizally designed.
• Reviewing Informatica maps developed by the offshore people on a daily basis.
• Preparing higher level and lower level design of the Informatica maps.
• Interacting with multiple vendors for successful of the project.
• Designed the OBIEE repository and report layout, resolving the fan traps, designing the star schemas, hands on experience working OBIEE.
• Experience with UNIX shell (Scripts) for processing, FTP, file listing concept.

Environment: Windows vista/7, Informatica8.6.1, SAP R/3, OBIEE 11g

Confidential

Informatica Consultant

Responsibilities:

• Conduct a gap analysis between Current and Future Service and Application model options and identify required changes to processes and technology and successfully implement the organizational redesign.
• Actively involved in designing, developing, creating complex and simple mappings, Mapplets using Informatica source, warehouse and loading the data.
• Scheduled the workflows using Informatica scheduler and enhanced the data mart as per business specifications.
• Used XML Parsers and Generators to handle inbound and outbound XMLs in Informatica.
• Installing Informatica Power center 9.0/8.x/7.x/6.x on windows/ Linux environment.
• Developed ETL Design Documents and managed the Business rules and data validation.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Worked with transformations such as expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation.
• Conducted Dimensional Modeling Analysis for each ORDM subject area
• Used inline Lookup within the transformation language script (tgp) in DT studio andusing an external table (XML),and dynamically using variables of type code: lookup Table
• Used mapper, serialiser, parser for parsing COBOL files (EBCDIC)
• Used Power center unstructured datatransformation to automate real time transformation of unstructured data.
• Was responsible for Data Modeling of events and filings subject area using Erwin.
• Loading XML files to oracle using Informatica, handling variable length XML files using Informatica.
• Has led the team for Stress testing and optimization.
• Experience processing multiple XML files using Informatica.
• Coordinated the release management and migration support for PAT.
• Business requirement gathering by conducting several iterative Joint Application Design (JAD) sessions and interviews with the business user community and business analysts for the new CCMS application.
• Preparing the macro design document and creating High Level design document translating business requirements into functional specifications and writing pseudo codes
• Translate functional specifications document into technical specifications explain business and technical transformation rules.
• Collaborated with the BI Architect / BI Team and the business community to define information use cases and approaches for supporting them with Oracle BI Analytics dashboards & reports
• Maintained and extended company's BI platform, including hands-on technical development of Oracle BI Dashboards, Reports and ETLs.
• Developed usingOBIEE10g Components: Server, Administrator, Presentation Services, Dashboards, and Answers and Semantic Models.
• Developed dashboards with grids, charts, KPIs, filters and drill down.
• Used query as web option to build visualizations based on the reports built in Business Objects.
• Exported visualization contents to various file formats (PDF, PPT, HTML and Flash).
• Involved in troubleshooting the visualizations for various problems faced during data connectivity.
• Managed development and production environments using Power Center, MS SQL Server. Monitored the load jobs, error log files for regular load and interacting with end users.
• Checked the accuracy of data loaded into Teradata.
• Tuned Teradata SQL queries (explain plans, collect statistics, primary and secondary indexes) for better performance.
• Maintained both development and production environments since a long time using Power Center, Oracle (PL/SQL). Monitoring the load jobs, checking the error log files for regular load and interacting with users were my primary focus areas
• Use ClearCase for version control across common source code used by developers
• Deploy all the code that has to be migrated to QA/Production environment
• Coordinate with System Testing and UAT team to analyze and resolve opened defects.

Environment: Windows vista/7, Informatica9.0.1, MS SQL Server 2008, Erwin, XML, OBIEE 10g

Confidential

Data Modeler

Responsibilities:

• Duties during Application Functional Design Approach: The core of the Data Warehouse design process was an iterative Joint Application Design (JAD) and involved close interactions with business and IT Subject Matter Experts (SME) on a daily basis.
• Worked as a Data modeler to build conceptual and physical data model using Erwin for subject areas like engineering, supply chain and integrated operations to define entities, attributes and their relationships.
• Loading XML files to oracle using Informatica, handling variable length XML files using Informatica.
• Technical Design Overview phase had following duties: The functional specification was translated into a technical design to support configuration and build of the application.
• Upon completion of design, major responsibility involved handing over and communicating the complete design to offshore team to develop the code and resolve any technical and design issues faced by the team
• Responsibilities included designing architecture and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Used Mapping Designer, Workflow Manager, Workflow Monitor extensively to create, execute and monitor a mapping’s run process.
• Experience in Building Slowly Changing Dimensions
• Extensively worked with various transformations like expression, filter, joiner, aggregator, lookup, rank, sequence generator, sorter, etc.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.
• Worked with trouble shooting in Production support and was responsible for fixing bugs in Production Server.
• Coordinated with system and business analyst for early investigation of data.
• My role also included analyzing ETL loads, data quality of the Dimensional Data Warehouse, auditing the error handling modules.
• Proficient in Installing Informatica Power Center
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation
• Knowledge transfers with team members for efficient design of the mappings and programs.

Environment: Informatica 9.0.1, Teradata, WINSCP, PUTTY, ERWIN, XML

Confidential

Informatica Consultant

Responsibilities:

• Advanced Informatica (using Dynamic lookup, Parameters, Advanced transformations) mappings.
• Designed and conducted unit tests of new or changed RPD objects and ETL mappings
• Interacted with business units to understand their needs and design appropriate RPD objects.
• Developed and maintained corporate data model, documented various data sources.
• Worked in conjunction with users for developing dashboards.
• Developed complex OBIEE reports, building RPD, designing aggregate tables, reports and dashboards. Did performance tuning for Informatica mappings and RPD object.
• Business requirement gathering by studying the current enterprise model
• Interview Subject Matter Experts and IT team and develop foundational understanding of current system architecture
• Develop high-level estimate using Microsoft Project Plan, schedule, resource plan and risk analysis
• Develop a full lifecycle proof of concept to further explore selected technology option
• Supplement financial analysis by comparing performance over time across key value drivers using Value Analytics
• Actively involved in designing, developing, creating mappings, mapplets using Informatica source, warehouse and loading the data.
• Scheduled the workflows using Informatica scheduler and enhanced the data mart as per business specifications.
• Developed ETL Design Documents and managed the Business rules and data validation.
• Worked as Informatica Administrator.
• Hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man).
• Checked the accuracy of data loaded into Teradata.
• Tuned Teradata SQL queries (explain plans, collect statistics, primary and secondary indexes) for better performance.
• Working with ETL leads to formulate ETL approach and appropriately uses Teradata Tools and Utilities.
• Analyzed the Fulfillment requests (FR) and Change request (CR) as per requests from HPPM.
• Installing Informatica Power center 8.5.1 on HP-UNIX.
• Creating SR to Informatica Inc- related to any Power center product issues.
• As per Fulfillment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Performed Upgrading Informatica Power center Version 7.x to Informatica Power center 8.X.
• Ensures proper configuration of the Power Center Domain components.
• Experience in nodes, Repository services and Integration services.
• Ensures proper application of the licensing files.
• Create, backup, restore for Informatica Repositories.

Environment: Informatica7.1.1, TOAD, Oracle9i, MS SQL Server, Teradata and sql, Informatica9.0.1, Oracle, OBIEE 10g, Control M

Confidential

Sr. Informatica developer

Responsibilities:

• Involved in Requirement gathering.
• Creating the Technical design specifications based on Client functional specifications.
• Worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Worked extensively on different types of transformations like Joiner, Aggregator, Router, and Expression, Normalizer, connected/ unconnected Lookups, Data Masking transformation and Update strategies.
• Created Slice and Dice, Drill down and Cross Tab reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Various ad hoc reports were created using User module in Business Objects according to the given requirements.
• Modified two universes, Market Risk and Interest Risk on Wells Fargo Bank side with SQL Server 2005 as DBMS.
• Created classes, aliases, halp text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Worked on data modeling by creating derived tables on universe level.
• Used POWEREXCHANGE for SAP R/3to connect and import source data.
• Designed mappings which identify duplicate customer records. Match and merged records based on business rules.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Developing PL/SQL Packages, procedures, Functions, Triggers, Cursors as per the business requirements.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
• Performance tune ETL mappings, Maintenance, enhancements and deployment of ETL code.
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Created several projects, packages and metadata models in Cognos Framework Manager.

Environment: InformaticaPowerCenter7.0.1, Power Exchange, IDQ, IDE,Oracle10g,PL/SQL,SQL Server 2005,DB2,SAP R/3,SAP BW, Erwin, Data Modeler r7.3,AutoSys,Toad.