SUMMARY:

• Information Technology Professional with 14+ years of experience and Data warehousing professional with 12+ years of data warehousing experience with extensive knowledge in data warehousing concepts, data modeling, ETL and BI - Informatica, Oracle SQL/PLSQL, MSBI, Unix
• Design and develop data warehouse solutions, along with appropriate ETL logics to extract data from flat files, XML, XSD, DT, Oracle, Teradata v12, DB2, SAP sources and other external sources and load data into Oracle DW tables, flat files and external target
• Worked in different positions like Business Analyst, Developer, System Tester, Team lead, Project lead and Project manager
• Expertise in developing applications using Oracle PL/SQL Packages, Procedures, Functions etc
• 3+ years of hands on experience with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, address standardization, exception handling, and reporting and monitoring capabilities of IDQ
• 5+ years of programming experience on VB.Net, ASP.Net, Visual Basic 6, VBS on Windows platforms and Excel sheets
• Proven ability to work with end users to translate high level requirements into a solution approach including both high level and detailed estimates
• Experience modeling and designing Relational Databases, Star, Snow-Flake Schemas, and cubes (Kimball)
• Highly organized team player with the ability to innovate, multi-task and set priorities effectively
• Write, test and implement Teradata TPT, Fastload, Multiload, BTEQ scripts, DML and DDL scripts.
• Delivered high profit margins while executing large complex information management projects ranging from $6 - $8 million dollars over 12 years as a Project lead. Supervised 40 + technical staff in international geographical locations.
• Clientele includes Confidential, Confidential & Confidential, Confidential, Coventry, Cox, Cbeyond, Confidential and Government projects.
• Adept in designing, building and managing end-to-end Data Management, data architecture, data integration and Business Intelligence solutions.
• Gathered system requirements using use-cases by defining actor, events and path / relationships
• Created both logical and physical Data models using ERWin data modeling tool and generated database tables
• Created both Relational models and Dimensional models using Erwin, as well as worked on reverse engineered data models
• Designed Reports to facilitate business needs in a faster and timely manner using Summary tables, Materialized views.
• Strong working knowledge in architecting Data warehouse, landing zone, stage and ODS areas using ETL and other tools.
• Strong experience in Microsoft SSIS and SSRS and procedure development to processes data and generate reports
• Strong working knowledge in Confidential -SQL and Oracle SQL, PL/SQL and OBIEE
• Informatica Certified Developer, hands on working knowledge in IDQ, MDM and DT tools
• Strong working knowledge on Informatica Pushdown Optimization, Informatica Partitioning at various levels
• Excellent working experience in ETL production support role
• Excellent working knowledge on performance tuning on large size ETL processes and huge data sets.
• Familiar with design and implementation of de-normalized multi-dimensional data marts using various schemas
• Sound exposure to SDLC, E-R model & dimensional modeling concepts. And hands on experience on different RDBMS like Oracle and SQL SERVER
• Excellent working knowledge in UNIX scripting and implementation of scripting logics needed for projects
• Good theoretical knowledge in C, C++, Java and in various flavors of UNIX and Linux
• Excellent communication and interpersonal skills. Strong analytical and problem solving skills
• Ability of analytical thinking when assessing a complex situations and business needs, and when identifying root causes
• Successful working experience in an offshore onsite model
• Created and scheduled complex apps and jobs using CA ESP work automation using external Jobs and DB triggers

TECHNICAL SKILLS:

ETLTools: Informatica Power Center 7.x, 8.x, 9.x, 9.6.1, DT, MDM, IDQ, Power Connect, Informatica PowerMart 6.1/5, MSBI, SSIS, SSRS and SSAS, IBM Data stage 6 and Oracle SQL/PL-SQL

Data Modeling: Dimensional Data modeling, Star & Snow-Flake Schema, Physical & logical data modeling

OLAP/BITools: OBIEE 10g, Cognos 8, MSBI SSRS reporting, Business Objects, SAP Crystal Reports

Databases: Oracle 9i, 10g, SQLServer 2012, Teradata

Tools: ERwin 7, TOAD for Oracle, Visual Basic 6, Unix and MS-DOS script

Domain Experience: Healthcare,Automotive, Banking, Financial services, Consumer goods, Utilities and Tele-communication

PROFESSIONAL EXPERIENCE;

Confidential, Plano, TX

Environment: Informatica Power center 9.6.1, DT, SQL Server 2008, Oracle PL/SQL and Unix, MSBI, SSRS

Responsibilities:

• Understanding the Project requirements and implementation of ETL components
• Working with various teams to understand functional, data, requirements and translate them into technical specifications and walk through them for reviews
• Design, implement and support end to end data integration solutions using ETL tools
• Work with other ETL developers and make sure they get inputs on the tasks they need to deliver.
• Analyze, review and modify existing PL/SQL Procedures and functions
• Working with data modelers, DBAs, ETL and application developers through the project life cycle and guiding solutions
• Created both logical and physical Data models using ERWin data modeling tool and generated database tables
• Created both Relational models and Dimensional models using Erwin, as well as worked on reverse engineered data models
• Designed Reports to facilitate business needs in a faster and timely manner using Summary tables, Materialized views.
• Testing workflows with test data, and applying performance precautions when needed
• Support Activities - Job monitoring, tuning, bug fixes, deployment and rotational basis prod support
• MSBI SSRS reports development, and Converted Crystal Reports to SSRS reports
• Enhanced interface code on C#, ASP .net and VB.net
• Created and scheduled complex apps and jobs using CA ESP work automation using external Jobs and DB triggers

Confidential, Greensboro, NC

Environment: Informatica Power center 9.6, DB2, Oracle, SAP ECC/BW and UNIX

Responsibilities:

• Analyze the requirements and implementation data conversion ETL components
• Working with business team to understand data requirements and translate them into technical specifications
• Design, develop, migrate and support end to end data integration solutions using ETL tools, and Oracle PL/SQL
• Develop Oracle PL/SQL standalone blocks, procedures, functions in order to populate business required data tables for the purpose of reconsile purposes.
• Production support and work with ESP teams and ESP jobs
• Analyze, Apply performance tuning techniques such as PDO, Partitioning, Indexing, Oracle Hints, Analyze table etc, reduce the complexity of the ETL logic etc in order to imporove the overall performance of the troubled ETL loads.
• Work with data modelers, DBAs, ETL Administrators and SAP BW developers through the project life cycle and guiding solutions
• Testing workflows with test data, and applying performance precautions when needed
• Responsible for developing complex reusable Informatica code components such transformations, mappings, worklets and workflows

Confidential, Raleigh, NC

Environment: Informatica Power center 9, IDQ, MDM, DB2, SQL Server 2008, Oracle PL/SQL and Unix

Responsibilities:

• Understanding the requirements from conversion lead and implementation data conversion ETL components
• Working with various Analyst team to understand data requirements and translate them into technical specifications
• Design, implement and support end to end data integration solutions using ETL tools
• Analyze, review and modify existing PL/SQL Procedures and functions
• Working with data modelers, DBAs, ETL and application developers through the project life cycle and guiding solutions
• Testing workflows with test data, and applying performance precautions when needed
• Responsible for developing complex reusable Informatica code components such transformations, mappings, worklets and workflows

Confidential, Plano, TX

Environment: SSIS, SSRS, SQL Server 2008 R2, Informatica Power center 9.1, XML, XSD, Server 2008 R2, Oracle 10g and Unix, Hadoop, Teradata

Responsibilities:

• Understanding the requirements from analyst and implementation data migration components
• Working with various Analyst team to understand data requirements and translate them into technical specifications
• Design, implement and support end to end data integration solutions using ETL tools and Oracle functions, proceduers etc.
• Working with data modelers, DBAs, ETL and application developers through the project life cycle and guiding solutions
• Guide and mentor other staff with design & development tasks
• Responsible for developing complex reusable Informatica code components such transformations, mappings, worklets and workflows
• Testing workflows with test data, and applying performance precautions when needed
• Involved in development of a Hadoop project

Confidential, PA

Environment: Informatica Power center 9, MDM, IDQ, Oracle 10g and Unix

ETL Architect & Technical Lead

Responsibilities:

• Created both logical and physical Data models using ERWin data modeling tool and generated database tables
• Architecting Data warehouse, landing zone, stage and ODS areas using ETL Informatica.
• Working with various IT and business groups to understand data requirements and translate them into technical specifications
• Data cleaning, data matching, data conversion, address standardization, exception handling, and reporting and monitoring using Informatica IDQ tool
• Worked with healthcare claims, member, provider and xref (cross reference) cleansing and standardization
• Design and development on Teradata database, BTEQ scripting, using the fastload and mload methods.
• Design, implement and support end to end data integration solutions using ETL tools
• Working with data modelers, DBAs, ETL and application developers through the project life cycle and guiding solutions
• Lead data initiatives/ projects from inception to delivery
• Assist with defining standards, best practices and governance processes
• Guide and mentor other staff with design & development tasks
• Understanding the requirements from analyst and implementation data migration components
• Responsible for developing complex reusable Informatica code components such transformations, mappings, worklets and workflows
• Testing workflows with test data, and applying performance precautions when needed

Confidential, Atlanta

Business Analyst & Technical Lead

Responsibilities:

• Gathered system requirements using use-cases by defining actor, events and path / relationships
• Created both logical and physical Data models using ERWin data modeling tool and generated database tables
• Created both Relational models and Dimensional models using Erwin, as well as worked on reverse engineered data models
• Designed Reports to facilitate business needs in a faster and timely manner using Summary tables, Materialized views.
• Enhance and support mappings & workflows that load data into Teradata work closely with the Project managers, Business analysts, other architects and the developers to create specific designs for the integration or movement of data between various enterprise applications and the DW environment.
• Guidelines towards the capabilities of relevant ETL tools - Informatica, SSIS and generic database functionality (e.g. MS SQL Server TSQL and Oracle SQL).
• Define the future direction of data integration architecture
• Design and development on Teradata database, BTEQ scripting, using the fastload and mload methods.
• Provide the best practices for dealing with data warehouse structures, such as fact tables and the various types of slowly changing dimensions.
• Design, implement and support end to end data integration solutions using ETL tools
• Working with data modelers, DBAs, ETL and application developers through the project life cycle and guiding solutions
• Technical Lead, responsible for ETL and Reporting design & development
• Identifying dataflow and implementation of populating test data for Dimension and fact tables
• Responsible for developing Informatica code components like mappings, worklets and workflows
• Testing workflows with test data, and applying performance precautions when needed
• OBIEE reports development
• Coordination in Onsite offshore model
• Write complex SQL and prepare PL/SQL programs to fulfill the technical requirements
• Prepare BTEQ scripts for the purpose of data transform

Confidential, Atlanta

Environment: SSIS, SSRS, SQL SERVER 2005, InformaticaPower center 8, DataStage 6, Oracle 10g, Teradata v12, OBIEE and Unix

Business Analyst & Technical Lead

Responsibilities:

• Gathered system requirements using use-cases by defining actor, events and path / relationships
• Created both logical and physical Data models using ERWin data modeling tool and generated database tables
• Created both Relational models and Dimensional models using Erwin, as well as worked on reverse engineered data models
• Designed Reports to facilitate business needs in a faster and timely manner using Summary tables, Materialized views.
• Architecting Data warehouse, landing zone, stage and ODS areas using ETL Informatica.
• Siebel BI Migration of Informatica objects 7 to Informatica 8.6.
• Production support activities, also support on non business hours.
• Prepare complex SQL and prepare PL/SQL programs to fulfill the technical requirements
• Support Informatica Pushdown Optimization, Informatica Partitioning at various levels as in when needed for the troubled ETL data loads
• Hands on Datastage development
• Used oracle Hints, Index building, analyze tables etc in order to improve overall data loads
• Support & Enhance mappings & workflows that load data into Teradata
• Work closely with the Project managers, Business analysts, other architects and the developers to create specific designs for the integration or movement of data between various enterprise applications and the DW environment.
• Define the future direction of data integration architecture
• Provide the best practices for dealing with data warehouse structures, such as fact tables and the various types of slowly changing dimensions.
• Design, implement and support end to end data integration solutions using ETL tools
• Technical Lead, responsible for ETL design & development.
• Identifying dataflow and implementation of populating test data for dimension and fact tables
• Responsible for developing Informatica code components like mappings, worklets and workflows
• Testing workflows with test data, and applying performance precautions when needed
• OBIEE reports development
• Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL

Confidential

Environment: SQL Server SSIS, SSRS and SSAS, Informatica Power center, MS-SQL 2005 Oracle 9i, Cognos Report net and Unix

Team Lead, ETL Developer

Responsibilities:

• Identifying Dataflow and implementation of populating test data for Dimension and fact tables
• Responsible for developing Mapplets, mappings and worklets and workflows
• Testing workflows with test data, and applying performance precautions when needed
• Preparation of Low Level Design Documents
• Informatica and Cognos administration
• Database maintenance activities
• Teammanagement
• Prepare complex SQL and prepare PL/SQL programs to fulfill the technical requirements

Confidential

Environment: Informatica Power center 7.1.3, Oracle 9i, MS SQL server2000 and Unix

Senior ETL Developer

Responsibilities:

• IdentifyingDataflow and implementation of populating test data for Dimension and Fact tables
• Responsible for developing mapplets, mappings and worklets and workflows
• Testing workflows with test data, and applying performance precautions when needed
• Preparation of Low Level Design Documents
• Prepare complex SQL and prepare PL/SQL programs to fulfill the technical requirements

Confidential

Environment: Informatica Power center 7.1.2, Oracle 9i and Unix

ETL Developer

Responsibilities:

• Design and development of various costs in to dimension tables and fact tables.
• Creation of new mappings to load history data and modification of existing regular mappings.
• Review & understanding existing mappings & workflows, Identifying Dataflowtesting them and dealing with performance issues
• Prepare complex SQL and prepare PL/SQL programs to fulfill the technical requirements

Confidential

Environment: Informatica Power center 6.2 & 7, Business Objects, Oracle 9i andUnix

ETL Developer

Responsibilities:

• Review & understanding existing mappings & workflows, Identifying Dataflow andidentify performance bottlenecks and apply performance improvement resolutions.
• Coding for requested enhancements for the existing mapping. Extracting, Transforming and Loading activities.
• Testing the workflows for and solving any issues raised with the new enhancements.
• Migration of Informatica 6.2 mappings to 7
• Prepare complex SQL and prepare PL/SQL programs to fulfill the technical requirements