SUMMARY

• 10 years of Enriching Software Development Experience in Analysis, Design, Development and Production/Maintenance of Data Warehousing Applications.
• Thorough noledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Server Manager, Workflow Manager, Workflow Monitor).
• Extensive experience in MS SQLServer 2008/2012 and hands onExperience in installing, configuring,managing, monitoring, troubleshooting,up gradation, migration SQL Server 2008/2012 and Expert in Microsoft BusinessIntelligence technologies like SQLServer Integration Services (SSIS).
• Designed multi - dimensional models (Star, Snow Flake schema). Experience in Data Modeling, Business Process Analysis and Reengineering.
• Involved in Development of Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Experience in Data Extraction from multiple operational sources of loading staging area, Data Warehouse and data marts using CDC/ SCD (Type1/Type2) loads.
• Good noledge on Reusability of mappings and transformations and Error handling using dependencies.
• Extensive noledge of RDBMS and SQL/PLSQL,TSQL Dynamic-queries, sub-queries and complex joins for generatingComplex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Worked wif different data sources like Oracle, Sybase, SQL Server, SFDC and flat file sources.
• Receiving incidents and requests from end-users, analyzing those and responding to end-users wif the solutions.
• Exposure to Finance and banking sectors wif regards to data warehouse development.
• Involved in all the stages of the Software Development Life Cycle.
• Experienced in trouble shooting using various log files.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
• Expertise in Data Warehousing Concepts like Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling.
• Experienced in Programming languages like COBOL, JCL, IMS DB.
• Providing high level and low level estimates and projecting resource needs. Interaction wif offsite team and BU team
• Work closely wif developers/PMs in plan and prioritize the work and representing team at the leadership meetings
• Exceptional abilities in project design and management wif the organizational and supervisory skills to assure success. Delegates and monitors work to meet and beat deadlines
• Successful in meeting new technical challenges and finding solutions to meet the need of customers.
• Implement agile management ideals by facilitating exercises such as sprint planning and team leading standups.
• Manage project timelines and communicate wif management staff and clients to ensure project progress satisfactorily.
• Enact delivery upon completion of projects and ensure that delivery adheres to agile practices maintained by the company.
• My interpersonal and soft skills are Leadership * Team Player * Strong Communicator * Technical Skills * Domain Knowledge * Time Management * Analytical Problem Solver

TECHNICAL SKILLS

Data warehousing Tools: Informatica Power Center 9x/8x/7x, Informatica, Repository Admin console, Repository Manager, Designer, Workflow Manager, workflow Monitor, Informatica Metadata Manager, SSIS,SSAS,SSRS

BI Data Modeling: MS Visio, Star Schema Modeling, Snow-Flake Schema Modeling, FACTS, Dimensions

Database: Oracle11x/10g, Sybase12.0, VSAM, DB2 UDB 8.0/7.0SQL Server 2008/2012, MS Access 2003, SQL Query Analyzer, SQL Query Analyzer, SQL Enterprise Manager, Management Studio.

Languages: Pl/SQL, SQL, TSQL,C, UNIX Shell Scripting, COBOL, JCL.

Operating systems: Windows XP/NT/2000, MS-DOS, OS/390

Others: TOAD, Visio, SQL*PLUS,SQLLOADER, XML, HTML, TFS, Project Plan,VSTS

PROFESSIONAL EXPERIENCE

Confidential, Fishers IN

Project lead

Responsibilities:

• Responsible for Business Analysis and Requirements Collection. Worked on project plan to define the efforts and estimations on each task.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Worked along wif UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document wif all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Prepared test Scenarios and Test cases in TFS/VSTS and involved in unit testing of mappings, system testing and user acceptance testing.

Environment: Informatica Power center 9.0,Flat Files, XML Files PL/SQL, Oracle 10x, Linux, Toad,SQL Server,DB2, Notepad ++,Power exchange,MS Dos, VSTS,TSQL.

Confidential, Fishers IN

Project lead

Responsibilities:

• Involved in gathering and analysing requirements, prepared Technical Design document and Source - Target Mapping docs and presented to BU team to finalise and get sing off on the TDD/STM
• Worked on project plan to define the efforts and estimations on each task.
• Designed and Developed the Batch and Incremental ETL process me.e., Mappings & Mapplets using various Transformations and Workflows wif Sessions / Tasks.
• Administered and maintained Clarity (Risks/Issues, Functional and Nonfunctional documentation, Change Controls, Technical Specs).
• Scheduled and lead the status meeting calls wif Deliver /Test Mangers to define the road map and to discuss on project status.
• Setup and configure Power Center domain, grid and services.
• 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.
• 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: Informatica Power center 9.0,Flat Files, XML Files PL/SQL, Oracle 10x, Linux, Toad,SQL Server,DB2, Notepad ++,Power exchange,MS Dos .

Confidential

ETL Analyst/Developer

Responsibilities:

• Involved in complete SDLC process, through all phases of project life cycle - analysis, design, development, testing, implementation and post-production activities.
• Developed Detailed Design documents based on business requirements.
• Worked closely wif business analysts to gather functional specifications and turn them into technical specifications.
• Worked on ETL processes using Informatica 9.0.
• Designed and developed Informatica code to extract, convert and load data for the reporting feeds as per the business requirements.
• Involved in the full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Power Center.
• Performance tuning TEMPhas been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Designed and developed full load & incremental load mapping.
• Created mapplets which provides reusability in mappings.
• Involved in debugging the failed mappings identify the root cause and developing error-handling methods.
• Resolved Source system data issues by performing Data profiling and providing workaround techniques.
• Worked wif XML files, Direct and Indirect Flat Files.
• Identified long running jobs and implemented various performance tuning techniques to mitigate the bottlenecks.
• Developed queries to proof the development work and made sure that data across the process translated correctly
• Worked wif DBA’s to tune long running SQL queries.
• Used Variables and Parameters in Mappings, Workflows and Sessions.
• Documented the Unit Test Cases & Integration Testing Steps and captured the results. Prepared release notes for migrating the objects from DEV to INT to UAT environments.
• Informatica Production Support, including off hours and weekends.

Environment: Informatica Power center 9.0,Flat Files, XML Files PL/SQL, Oracle 10x, UNIX, Toad, SCM, SQL Server,DB2 and Tivoli

Confidential, Columbus OH

Programmer Analyst

Responsibilities:

• Involved in complete SDLC process, through all phases of project life cycle - analysis, design, development, testing, implementation and post-production activities.
• Worked on ETL processes using Informatica 9.0.
• Provided project leadership to the team.
• Involved in quality assurance, status reporting, tracking time and cost in loading data warehouse needed for the project.
• Exclusively involved in ETL design, development, loads and deployment.
• Involved in technical discussions and facilitated in meeting deadlines.
• 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.
• Provided the directions to team to implement unit test plans for Extraction/Transformation.
• Involved in data cleansing and loading of data into staging areas.
• Involved in Configuration management decisions.
• TEMPEffectively communicating the project status to all the stakeholders.
• Leading the team in the overall initiation, planning, and execution.
• Handled monitoring and closing of the project.

Environment: Informatica Power Center 9.0, Oracle 11x, Visio, UNIX, Control-M and Audit Frame Work.

Confidential, IRVING TX

BI ETL LEAD/Admin

Responsibilities:

• Worked in Informatica 8.6 to perform ETL from various sources to the central data warehouse.
• Involved in Design and Development.
• Involved in testing of the various mappings involved in the ETL process.
• Extensively used ETL to load data from Flat files.
• Involved in Delimited files and also from the relational database, which was Oracle 10i.
• Developed and tested all the Informatica mappings.
• Performance tuning TEMPhas been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Scheduling the workflows using Informatica scheduler.
• Designed and developed full load & incremental load mapping.
• Created mapplets which provides reusability in mappings.
• Documented the Unit Test Cases & Integration Testing Steps and captured the results. Prepared release notes for migrating the objects from DEV to INT to UAT environments.
• Informatica Production Support, including off hours and weekends.

Environment: Informatica power center 8.6, DB2 tables, Oracle 11x, UNIX, Toad, SQL*plus.