PROFESSIONAL SUMMARY:

• A result driven professional wif 10+ years of experience in Requirements analysis, design, development, data conversion and implementation of various projects using Data Warehousing tools and IBM Mainframe Technologies.
• Strong hands on experience in DataWarehousing Tools - Informatica 8.6/9.1/9.6.1, Teradata, MS SqlServer,Oracle, SAP Business Objects XI 3.0/3.1/4.0/4.1 (Designer, CMC, Web Intelligence, Desktop Intelligence, Import Wizard, Crystal Reports),Mainframe Technologies(OS/390) - Jcl, Natural, Adabas, Cobol, Eazytrieve.
• Strong experience in reporting tools like SAP BO (Webi, Dashboard Designer, Crystal Reports, and Universe Designer.
• Extensively used Business Objects reporting functionalities such as Drill down, Slice and Dice, Breaks, Filters, Formulas, Variables, Prompts, Ranking, Alerts, Section and Grouping.
• Expertise in planning, designing, developing, distributing and maintaining Universes from scratch, migrating to different environments.
• Experienced in full lifecycle Data warehouses and Business Data marts wif Star Schemas, Snowflake Schema Modeling.
• Experienced in full life cycle of software development including Requirement gathering, Analysis, Preparation of Design Document, Functional and Technical Specification Document, Unit Test Plan, Coding, Unit Testing, Integrated Testing, Maintenance and Documentation, Implementation and Production Support.
• Worked extensively wif the onsite-offshore model and managed technical teams, main responsibilities including client expectation management, understanding the client requirements, provide estimations and cost effective solutions.
• Experience 5+years of Expertise in development and designing of ETL methodology for supporting data transformations using Informatica Power Center.
• Strong working experience in the DataAnalysis, Design, Development, Implementation and Testing of Data Warehousing using DataExtraction, DataTransformation and DataLoading (ETL).
• Knowledge of different RDBMS like Oracle, SQL Server, DB2, Sybase, Teradata
• Informatica (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager and Workflow Manager) and implementation of Data warehouse and Datamarts using Power center wif Oracle, DB2, SQL server and Teradata Databases.
• Strong Experience in developing Sessions,Workflows using Workflow Manager Tools - Task Developer, Workflow Designer.
• Extensively worked wif different data sources non-relational databases such as Flat files and other relational sources such as Oracle, SQL Server and DB2.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Worked on UNIX-shell Scripting for Pre-Session, Post-Sessions tasks and also automated the scripts
• Worked on Informatica Scheduler to schedule the jobs automatically.
• Expertise in doing Data Validation, Unit testing and UAT support for developed Informatica Mappings.
• Strong hands on experience in Teradata Load Utilities - BTEQ,MLOAD,FASTLOAD
• Little Experience and good noledge on FASTEXPORT,TPUMP.
• Worked on identifying long running queries, scripts, Spool space issues etc...,and implementing appropriate performance tuning methods.
• Hands on experience in Mainframe tools - FILE-AID, CA7,TOUA
• Self-motivated wif the ability to work both independently and in a team environment.
• Excellent analytical, problem solving and troubleshooting abilities.
• Experience in document process and training team members by creating and maintaining technical documentation, deployment diagrams and checklists.
• Experience in a wide range of Business Domains - Finance,Banking and Insurance.
• Extensive noledge of Agile Methodologies and Waterfall of Software Development Life Cycle (SDLC).
• Excellent communication and interpersonal skills, good analytical reasoning, high adaptability to new technologies and tools, highly organized wif attention to details.

TECHNICAL SKILLS:

ETL TOOLS: Informatica Power Center 9.6.1/9.1/8.6.1

BI TOOLS: SAP BO XI 3.1/4.0/4.1

DATA BASES: MS SQL Server, Teradata 14/12/V2R6/V2R5, Oracle 10g, ADABAS,DB2

TOOLS: Winsql, Rapid Sql, Autosys, Mainframe - File-Aid, CA7

TERADATA UTILITIES: BTEQ, MLOAD,FASTLOAD,TPUMP,FASTEXPORT

PROGRAMMING LANGUAGES: Natural, JCL, COBOL, Eazytrieve, Teradata Sql, Basics of Unix Scripting, KornShell Scripting

VERSION CONTROL: TOUA, ChangeMan

OPERATING SYSTEMS: IBM OS/390, WINDOWS XP

PROFESSIONAL EXPERIENCE:

Confidential

Senior Developer/Business Advisor

Responsibilities:

• As part of L3 support, would track the jobs which fail due to performance/spool space issue and would work on the permanent fix for the same
• Inorder to ensure stability of the system, would look the frequent failures of the jobs and provide the permanent fix to avoid reoccurrence of the issue.
• Provides 24/7 support to 250 plus BI ETL applications wif 7000 plus jobs.
• Completely driven by Incident Management process, maintains SLAs, ensures zero backlogs and fully compliant on Wisdom linkage.
• Ensure all critical reporting (like CSR, WWR) delivery on time wifout compromise to SLAs.
• Provides timely status updates to the Management on the daily failures, action items taken forward as permanent fixes or for the stability to the system.
• Coordinates wif multiple teams to resolve issues though incidents/tasks/bridge calls and invokes MIM as needed.
• Completely process driven and focused on eliminating person dependency.
• Maintains high level of synergy wifin the team and wif external teams like L3, GIS, BI Operations etc.
• Handles outages, MEND/QEND/YEND activities effectively.
• Good at using BMC Remedy, we pick the Adhoc incidents, auto BMC incidents. Also raise the Critical/High/Medium & low priority incidents to source teams to fix any missing files issue.
• Open to play the role of independent contributor in handling a complex task Team Player wif Good Communication skills and Strong Technical skills.
• Implemented changes (solutions) to a given process (issue) through a formal change ticket process by making the approvers understand the impact of change.
• Re-extraction of orders, tags and also working on data issues at database level

Environment: Informatica 10.0,SQL,Teradata V14, XML, Putty, Control M, Windows XP, Ultra Edit, Lotus Notes, Microsoft Visio.

Confidential, Bloomington, IL

Senior Informatica Developer

Responsibilities:

• Identified ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Has developed Proof of concept, prototypes.
• Coordinated and communicated the overall project execution status wif Scrum Master and Team Lead.
• Developed complex mappings to extract data according to the Transformation Business Rules and User requirements.
• Developed (Slowly Changing dimensions) SCD Type 1 and Type 2 mappings.
• Worked wif InformaticaPowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping designer, Mapplet designer etc..
• Developed new ETL mappings according to the requirements using InformaticaPowerCenter9.1
• Performed unit, system testing, and regression testing to ensure business requirements are met.
• Assisted QA Team to fix and find solutions for the production issues.
• Worked closely wif all team members to resolve the technical issues and business related questions.
• Managed timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections
• Implemented ETL standards and Best Practices while naming Maps and processes.

Environment: Informatica9.1SQL, PL/SQL, Oracle, TOAD, Doors, XML, Putty,, Control M, Windows XP, UNIX,Linux,VI Editor, Ultra Edit, Lotus Notes, Microsoft Visio.

Confidential, Milwaukee,WI

Technology Lead / Development Team Lead

Responsibilities:

• Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Gatheird requirements from users and designing reports as per the business requirements.
• Responsible to document changes to the User requirements, Universe Design and Report functionality.
• Responsible to make changes to existing universes according to the changes in the User requirements using Designer module
• Use of Designer module to implement Universes, linkages between tables, creating prompts, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Defined Classes, Objects in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Responsible for creating interactive dashboards by using Crystal Xcelsius.
• Created reports like, reports by product, reports by customer, reports by period, demographic reports and comparative reports.
• Extensively used calculations, variables, breaks, sorting, drill down and alerts for creating Business Objects reports.
• Developed/Enhanced the existing reports by accessing multiple universe built on two different databases using Merged Dimensions, thus eliminating the extraction of data from one database to other.s
• Prepared the Test Cases Document.

Environment: SAP Business Objects, DB2

Confidential, Milwaukee,WI

Technology Lead / Development Team Lead

Responsibilities:

• Participated in the requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
• Identified ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Participated in development efforts (proof of concept, prototypes).
• Implemented ETL standards and Best Practices while naming Maps and processes.
• Handled team of size 5. Did effort estimation and task distribution for the team members.
• Coordinated and communicated the overall project execution status wif Project Manager and Technical Delivery Manager
• Developed complex maps to extract data according to the Transformation Business Rules and User requirements.
• Modified several of the existing maps and created several new maps based on the user requirement.
• Worked wif InformaticaPowerCenter client tools like Source Analyzer, Warehouse Designer and Mapping designer.
• Developed new ETL mappings according to the requirements using InformaticaPowerCenter9.1
• Debugged code, testing and validated data after processes are run in development according to business Rules.
• Assisted QA Team to fix and find solutions for the production issues.
• Worked closely wif all team members to resolve the technical issues and business related questions.
• Managed timely written and verbal communication on project progress, load status, issue tracking, and concerns for management attention and/or escalation. Written documentation to describe program development, logic, coding, testing, changes and corrections.
• An enthusiastic and project-oriented team player wif solid communication and leadership skills and the ability to develop different solutions for challenging client needs.

Environment: Informatica 9.1.0, Oracle, Microsoft SQL Server(Rapid Sql), Unix Scripting

Confidential, Madison, WI

Technology Lead / Development Team Lead

Responsibilities:

• Identifying ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Participated in development efforts (proof of concept, prototypes).
• Implementing ETL standards and Best Practices while naming Maps and processes.
• Handled team of size 6. Did effort estimation and task distribution for the team members.
• Coordinated and communicated the overall project execution status wif Project Manager and Technical Delivery Manager
• Developing complex maps to extract data according to the Transformation Business Rules and User requirements.
• Modified several of the existing maps and created several new maps based on the user requirement.
• Worked wif InformaticaPowerCenter client tools like Source Analyzer, Warehouse Designer and Mapping designer.
• Developed new ETL mappings according to the requirements using InformaticaPowerCenter9.1
• Debugging code, testing and validated data after processes are run in development according to business Rules.
• Assisted QA Team to fix and find solutions for the production issues.
• Working closely wif all team members to resolve the technical issues and business related questions.
• Worked on the preparation of Data Lineage documents.
• Responsible for developing and implementing performance tuning tasks.
• Responsible for identifying the bottlenecks in the workflows which take longer run time or the flows which increase number of direct hits to the target table database thus reducing the overall performance.
• Responsible for implementation,pre and post-implementation support and maintenance.
• Developed mappings using the mappings specs and process flow, used Joiners, aggregators, update strategy, Lookup, expression, sorter, filter, routeretc transformations in mappings
• Done extensive testing which includes Unit,System and Regression Testing.
• Responsible for implementation,pre and post-implementation support and maintenance.Troubleshooting of production systems as required during production job failure, resolving production problems, optimizing performance.

Environment: Informatica9.0.1, Oracle 10g (WinSQL Tool)

Confidential, Madison, WI

Technology Lead / Development Team Lead

Responsibilities:

• Has been part of Business requirements meetings from end users, has developed prototypes
• Designed and created the BusinessObjectsUniverses.
• Created contexts and aliases for resolving loops in the Universes.
• Use of Business Objects Designer module to implement Universes, linkages between tables, creatingprompts and queries, parsing the Universes, applyingcontexts and alias tables to remove cyclicdependencies.
• Modify/Create new Business Objects Deski/Webi reports and universes.
• Created different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Created reports like, reports by Field representative, using merged dimension for the creation of joint-work of FR’s.
• Created various static and ad-hoc reports using drill down/up, slice and dice, breaks, filters and alerts.
• Prepared Unit, integration and system test plans, checklists and test data.
• Taken care of code migration for BusinessObjects and Crystalreports for ProductionEnvironment.
• Has supported jobs during post-implementation checkouts.
• Used Crystal Xcelsius to build Dashboards and Scorecard presentation.