SUMMARY

• Over 9+ years of experience in IT ETL Design, Data warehousing and business intelligence using ETL tool Informatica and Business Objects.
• Expertise in Informatica PowerCenter7.x/8.x/9.1Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Maple Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator transformation, Active andPassive transformations,Joiner and Update Strategy transformations.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Experience in working with Mainframe files, XML, and Flat Files.
• Experience in using Shell scripts to move the file in server to local folders.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.
• Experienced in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Produced Dimensional (Star Schema) data models for Data Warehouse/OLAP applications using data modeling - best practices- modeling skills and the Ralph Kimball methodology
• "Meta-Meta" Data Modeling: Modeled Repository Objects For ExtensibilityProficient working with Unix/Linux environments and writing UNIX shell scripts
• Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work effectively as a team member as well as independently.
• Good exposer to informatica Data Quality
• Good exposure in informatica MDM where data Cleaning, De-duping and Address correction were performed
• Worked on the Business Objects XI,XIR2,3.0/3.1
• Worked in design, development and implementing Web intelligence reports using Business Objects XIR2.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.x/9.x,BODS

OLAP Tools: SAP Business Objects XI, XIR2, 3.0,3.1,4.1

Scheduling Tools: CA7, AUTOSYS

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

Databases: Oracle11g/ 10g/9i/8i/8.0/7.0, DB2 8.0/7.0, Teradata, MS SQL Server

GUI: TOAD, SQL Developer

Programming: SQL, PL/SQL, SQL, HTML, DHTML, C, C++, XML, XSD, UNIX Shell Scripting.

Design Tools: Erwin 4.0/3.5, Oracle Designer / 2000.

Environment: UNIX AIX 5.2/5.3, Windows95/98/2000/XP/VISTA, WinNT 4.0, MSDOS.

PROFESSIONAL EXPERIENCE

Confidential - Johnston, IA

INFORMATICA Consultant

Responsibilities:

• Analyzed functional requirements and provided end-to-end ETL development in a BI Environment supporting project.
• Designed and developed various ETL processes to support different projects in the EDW Framework.
• Worked on Informatica Grid for sharing resources and load and High availability which cluster the systems.
• Worked with business analysts, and end users to define business rules and interpret data.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the Process of loading, pulling and pushing data from & to different servers.
• Involved in Designing and developing ETL mappings from varied transformation logics like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Integrated various data sources of Oracle, SQL server and sequential files into staging area.
• Error handling in ETL processes using SQL queries or transformations like Router and Lookup.
• Developed reusable transformations, Mapplets and Worklets to reduce development time.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Worklets.
• Worked closely with reporting team supporting large database clusters running state-of-the-Art Vertical column store database.

Environment: Informatica 9.6,Unix, BO, Oracle 11g, DB2, Flat files, SQL server, SQL Developer, CA7

Confidential -Dallas, TX

INFORMATICA Consultant

Responsibilities:

• Conduct studies, gather and analyze data from various databases and sources
• Extensive interaction with clients and business teams to get the report code and generation
• Designed and developed various ETL processes to support different projects in the EDW Framework.
• Worked on Informatica Grid for sharing resources and load and High availability which cluster the systems.
• Worked with business analysts, and end users to define business rules and interpret data.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the Process of loading, pulling and pushing data from & to different servers.
• Involved in Designing and developing ETL mappings from varied transformation logics like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Integrated various data sources of Oracle, SQL server and sequential files into staging area.
• Error handling in ETL processes using SQL queries or transformations like Router and Lookup.
• Developed reusable transformations, Mapplets and Worklets to reduce development time.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Worklets.
• Worked closely with reporting team supporting large database clusters running state-of-the-Art Vertical column store database.

Environment: Informatica 9.6,Unix, BO, Oracle 11g, DB2, Flatfiles, SQL server, TOAD, CA7

Confidential -WASHINGTON, DC

INFORMATICA Developer

Responsibilities:

• Involved in gathering and analyzing requirements, prepared Technical Design document and Source - Target Mapping docs and presented to BU team to finalize and get sign off on the TDD/STM
• Worked on project plan to define the efforts and estimations tasks.
• Created SCD Type 2 mappings using Date Flagging Method.
• Designed and Developed the Batch and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Scheduled and lead the status meeting calls with Deliver /Test Managers to define the road map and to discuss on project status.
• Identify root cause and implement resolution for production Processing issues.
• Perform object deployments on versioned repositories from QA to Production.
• Setup and administer Power Center security.
• Setup the Databases and File transfer system.
• Experience with Automic Scheduler to schedule the Stored Procs.
• Create test cases and used Debugger to test the mappings and fixed the bugs.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica8.6, OBIEE, DB2, Oracle10g, UNIX, TOAD, AUTOSYS

Confidential -RALEIGH, NC

INFORMATICA DEVELOPER

Responsibilities:

• Involved in complete SDLC process, through all phases of project life cycle - analysis, design, development, testing, implementation and post-production activities.
• Analyzed modules to create business and technical documents.
• Worked on ETL processes using Informatica 9.0.
• Involved in quality assurance, status reporting, tracking time and cost in loading data warehouse needed for the project.
• Extensively used the “Add Currently Processed Flat File Name port” to load the flat file name and to load contract number coming from flat file name into Target.
• Involved in data cleansing and loading of data into staging areas and Configuration management.
• Effectively communicating the project status to all the stakeholders.
• Leading the team in the overall initiation, planning and execution and monitoring and closing of the project.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time

Environment: Informatica 8.6,UNIX, Oracle 11g, SQL server, AUTOSYS

Confidential -Seatlle, WA

Informatica Developer

Responsibilities:

• Requirement gathering for enhancements
• Review HLD & LLD documents based on business requirements
• Supported AML investigation requirements
• Conducted monitoring of AML exception reports
• Developing mappings, workflows as per the requirement.
• Handling High priority and criticality incidents
• Handling work requests and project requests
• Provided backup liaison with business and IT.
• Understanding the functionality of the application from the business prospective.
• Monitoring and maintaining the scheduled jobs.
• Providing 24x7 support.
• Resolving the issues within the SLA time to avoid business loss.
• Managing critical recovery call.

Environment: Informatica 8.6,UNIX, Oracle8i, AUTOSY, TOAD

Confidential -WEST FILED, OH

Informatica Developer

Responsibilities:

• Understanding the Business rules completely and implemented data transformation methodologies, Involved in designing the E.T.L mapping documents.
• Involved in the mapping with a slowly changing dimension Type2 to keep track of historical data.
• Involved in developing Mapplets, Mappings and Transformations as per the requirements.
• Extracting data from different relational databases, Flat files using Informatica Power Center.
• Analyzing the issues and resolve with the scheduled time to avoid SLC.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager
• Creating Various Transformations like Interpreter, Preparer, Expression, Aggregator, Rank, Joiner, Sequence Generator, Lookup, and Update Strategy etc.
• Analyzed workflow, session, event and error logs for trouble shooting Informatica ETL process.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.

Environment: Informatica8.6, DB2, Oracle, Sqlserver-2005, AUTOSY, TOAD, UNIX

Confidential -ArlingTON, VA

.net Developer

Responsibilities:

• Interacted with the Users for collecting their requirements for report design and formatting designing the Forms, Developing the User Applications.
• Interacted with the functional experts to gather and understand Business logics
• Solving issues independently and liaising with business analysts and issue managers to resolve issues proactively
• Developed WebForms using C# and ASP.NET.
• Involved in unit test cases and regression testing
• Coordinated in fixing the bugs with manual testing and after implementing

Environment: ASP.NET, C#, SQL SERVER