SUMMARY:

• Over 10+ years of professional Information Technology experience, with expertise in the field of Enterprise Data Warehousing,Data Integration.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post - implementation review.
• Experience in using Informatica ETL tool v 9.1.0/9.0.1/8.6.1/8.1.1/7.1.3/6.2/5.1 , Informatica PowerExchange 8, Informatica Developer 9.1.0, Informatica Analyst, Informatica Administrator with industry best practices and experience in Reporting tools like Business Objects and Cognos.
• Full life-cycle development experience in Data Warehousing and ETL/Data Integrationprojects.
• Experience in using Oracle RDBMS v11g/10g/9i with proficiency in writing SQL queries and PL/SQL procedures.
• Worked extensively in Design and Development of Data Warehouse andData Integrationprojects using ETL tool Informatica Power Center and Data bases like MS SQL Server, MySQL, MS Access, Oracle, Teradata and DB2 and is versed in PL/SQL.
• Experience in creating UNIX shell scripts and Windows Scripting.
• Experience in integration of various data sources from Databases like Oracle, SQL Server, DB2 and formats like flat-files, CSV files, COBOL files and XML files.
• Extensive experience in performance tuning and code optimization.
• Expert on various UNIX (AIX, SUN, HP - UX and SVR) systems and Scheduling tools like AUTOSYS, Tivoli & CONTROL-M.
• Extensive experience in SQL, PL/SQL, stored procedures/packages, Functions, Triggers, Synonyms, Sequences, Materialized Views and other Oracle Objects and UNIX/Linux environments and Shell scripting.
• Possessing strong leadership qualities, good communication, strong interpersonal skills, problem solving skills, good team coordination and commitment to work.
• Having good Analytical skills in taking innovative decisions and providing solutions.
• Demonstrated Strong Communication, Leadership, Analytical and Problem Solving Skills.
• Involved in planning project tasks, estimating project size, scheduling and tracking tasks.
• Proficient in analyzing and translating business requirements to technical requirements.
• Guided the entire project team on the project’s quality process. Conducted variance analysis and defect analysis. Conducted causal analysis meetings and discussed with the project team on the causes and corrective actions and tracked to closure.
• Allocation of tasks to team and guiding team to timely completion of project work.
• Involved in effective reviews of code, test plans and guided the team in following the best code practices and creation of effective test cases.
• Involved in tracking the reviews and testing defects to closure.
• Managing the timely delivery of project work. Providing updates to senior manager on project progress.
• Involved in client status calls every week and provided updates on tasks. Involved in client interaction on any queries / risks in tasks and provided solutions.
• Defined number of process improvement to eliminate the person dependent approach

TECHNICAL EXPERIENCE:

• Demonstrated technical expertise on conversion project and converted 98.5% against client expectation of 92% of old data by defining rules efficiently
• Informatica Expertise
• Handled the complex ETL code like Informatica code generator and delivered 850 warehouses mapping for CDC and load process in 3 weeks.
• Implemented the client coding standard on the code generator to avoid rework
• Trained number of newly joining team member in the Informatica tool and delivered the project defect free utilizing them.
• Data sources handled - Oracle, Teradata, SQL Server, XML, Flat file, CSV, COBOL VSAM. Etc
• The successful implementation of full Push down optimization (PDO) in all the load job and loaded 1million record in 15sec.
• Hands-on experience in various project’s life cycles - Estimation, definition, development, implementation and support of delivered projects
• Performed designer role and created Macro and Micro Design Document for the project
• Experience in leading and managing teams. Handled multiple roles - Technical Lead, Team Lead, Designer, Business Analyst and Developer.
• Good team player with excellent inter-personal, written and oral communication skills.
• Conducted frequent audits during the course of the project and during each deliverable to keep track of the process followed and reported the audit findings to the Software Quality Assurance Leader.
• Being the co-coordinator of the SQA/SCM group, involved in all process audits and provided solutions for the project process.
• Being a Quality Leader, guided the team members to follow the Quality Process as defined in the project, thus delivered work product of good quality.

TECHNICAL SKILLS:

Data warehousing /BI Tools ETL Tool: Informatica Power Center 9.x/8.x/7.x/6.x/, Informatica Power Exchange

Reporting Tool: Business Objects 6.x, Brio 8.2

Replication Tool: InfoSphere Replication Server (IRS)

Database: Oracle 11g/10g/9i, Teradata V2R5/V2R6/V2R12, DB2, MS SQL Server 2005/2008, MySQL, MS Access, Netezza.

Querying Tools: SQL Plus, TOAD, SQL developer, SQL Navigator, Query Analyzer

Scripting: PL/SQL, Shell, Perl

O/S: MS DOS, Windows NT/2000, UNIX, Linux, AIX

Testing tools: Application Lifecycle Management

Scheduling Tool: Autosys, Control M, Tivoli Work Scheduler

Other Application Knowledge: Siebel CRM, Network Engineer & Granite(GIS tool), Smart Ops, Employee Field action system, SAP BW, Spot fire, Workday, GetPaid

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Lead /Architect Data Integration - Informatica

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements
• Prioritized Business requirements and translated those requirements into functional/technical requirements.
• Expertise in conducting code reviews, generating development specifications, writing and executing test plans, change control and other quality control functions
• Coordinate onsite and offshore developers to provide business requirement for development and modification.
• Work with Business clients and other infrastructure groups to resolve issues
• Suggested some software and hardware infrastructure recommendations
• Created Unit test cases and performed the Unit test and assisted the testing team in System Test and Production move
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Involved in migration of mappings and sessions from development repository to production repository
• Designed and developed several Mapplets and worklets for reusability. Extensively used ETL to load data from heterogeneous sources like flat files, Oracle tables, XML and Teradata.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Transaction Control, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations
• Creating the scheduling jobs and sheets using the scheduling toolTivoli.
• Created SQL views and SQL queries to access data from different databases (TeraData, Oracle)
• Created Unit test cases and performed the Unit test and assisted the testing team in System Test and Production move. Provide data Integration related support to client during daily business operations.
• Within the 3months learnt IRS tool and working as a Primary Onsite support person for the tool.
• Handled most complex situation in IRS effectively.

Environment: Informatica 9.1.0 & 8.6.1, Oracle, IRS (Infosphere Replication Server), UNIX, Tivoli Work Scheduler, Oracle 11G, Teradata, XML, Flat Files, SQLGE Capital - Chicago, IL

Technical Lead/DI Designer - Informatica

Confidential

Responsibilities:

• Significantly contributed for the preparation of micro design document.
• Lead build team to ensure quality of deliverable and supported the team on any technical challenges.
• Lead team to support data profiling activities.
• Created code generator for this project to deliver larger number for mapping in short duration of time
• Actively involved in data design, analysis, development, testing and performance tuning.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2)
• Created a flexible design model for the complete job execution using static oracle tables and script.
• Created the Design solution for Incremental loading, Exception Handling and Process/Error Logging mechanisms.
• Involved in Design review, code review, Performance analysis and Performance test
• Coordinated with network team to establish connectivity with GE through LAN.

Environment: Informatica 9.1.0 & 8.6.1, Teradata, UNIX

Confidential

Technical Lead - Informatica

Responsibilities:

• Data Analysis using Informatica ETL tool involving Simple and Complex ETL Mappings
• Understand business requirements completely to gather all the needs of clients
• Performed detailed impact analysis to come up with better solution for the given requirement.
• Preparing the estimates for implementing the solution, with the high level design approach
• Delivering the technical design document for getting the approval from clients
• Developing the system by coding in easily understandable way for the better maintenance
• Testing the changes with the prepared test plan and test scripts
• Solving the defects raised by testing team and tracking them with HP Quality Center and MQC
• Implement the performance tuning techniques in ETL mappings to optimize the regular data loads that helped in resolving critical performance issues in the project
• Adhered to the set of defined processes involved in the execution of requests from development to deployment
• Learned Siebel CRM application concepts and EIM processes involved in it.
• Trained team members on Informatica ETL tool and flow process and guided the team members in development and testing

Environment: Informatica 8.1.1, Oracle 10g, Windows

Confidential, Broomfield, CO

Module Lead

Responsibilities:

• Extensively used the Power Center client tools Designer, Workflow Manager, and Workflow Monitor
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy
• Extensively used PL/SQL for creating procedures and functions
• Performed security and user management repository backup using the same tool
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer
• Involved in the development of Informatica mappings and also performed tuning for better performance
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time
• Experience in automating the entire processes using Unix shell scripting
• Using Autosys to schedule UNIX shell scripts, PL/SQL scripts and Informatica jobs
• Created Migration Documentation and Process Flow for mappings and sessions.

Environment: UNIX, Oracle 10g, Siebel V7.8, Informatica 8.1.1, PL/SQL

Confidential, Broomfield, CO

Module Lead

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements
• Interacted with DBA and Source systems and resolved the Issues
• Worked extensively on designing the ETL solution using Informatica Power Center
• Extracted the data from Flat Files and loaded the data into Oracle using Informatica Power Center
• Created shortcuts for source and target and also created Reusable Transformations 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
• Worked extensively on different types of transformations like Source Qualifier, Expression, Router, Filter, Update strategy, Connected and Un-connected lookup, Normalizer
• Created sessions, worklets and workflows for carrying out test loads
• Designed/created the plan for the Master workflows that are to be scheduled to run on daily and monthly basis
• 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 Trouble shooting
• Created the Deployment groups to move the workflows from one environment to the other
• Got exposure to use Network Engineer tool.

Environment: UNIX, Oracle 10g, Informatica 8.1.1, Network Engineer 5.0.0, Granite 5.0.3, Brio 8.2

Confidential

Senior Developer

Responsibilities:

• Perform impact analysis and provide solutions
• Estimate and plan the execution of work
• Responsible for Information required for Tech writer
• Created High Level / Detail Design documents and developed Informatica Mappings for data movement.
• Generated Target Flat Files and loaded the data into database tables using the Informatica Mappings and used extensively all types of Transformations.
• Responsible for automation of Informatica Mappings using Shell Scripts.
• Was involved in analyzing and designing of the Oracle database
• Monitored SQL jobs to ensure successful execution
• QA, UAT and beta testing before Roll out to Production

Environment: UNIX, Oracle 9i, Informatica 7.1.4, Crystal Report

Confidential

Developer

Responsibilities:

• Designed and developed Informatica Mappings based on the business requirements
• Extensively used Informatica Power Center Designer to create source and target definitions, mappings, mapplets, transformations, re-usable transformations
• Used various Transformations such as Aggregator, Update Strategy, Router, Sorter, Source Qualifier, Filter, Expression, Connected/Unconnected Lookup, Sequence Generator, and Joiner.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
• Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links and logs.

Environment: Windows 2003, Informatica 6.1, Business Objects 6.5, Oracle 9i

Confidential

Developer

Responsibilities:

• Creating the Informatica mapping and reusable sessions.
• Involving Bug fix and enhancement in ETL code.
• Involved in Development, Testing and Production support.

Environment: Windows 2003, Informatica 6.1, Business Objects 6.5, Oracle 9i