SUMMARY

• 8+ years of experience on Data warehouse & Business intelligence technologies, ETL development and designing, data modelling, Business/Data Analysis and project management.
• Excellent working experience & sound knowledge on Informatica ETL tool.
• Expertise in reusability, parameterization, workflow design, designing and developing ETL mappings and scripts.
• Strong proficiency in writing SQL (including Oracle, Teradata, SQL Server).
• 6+ years of good exposure on optimizing the SQL and performance tuning.
• Excellent knowledge on SAP Business objects & Xcelsius.
• Expertise knowledge on SAP BO DI ETL tool with DQ, data migration and ETL experience.
• Solid understanding of both technical and functional data quality concepts.
• Excellent experience on Oracle 8i/9i/10g, SQL server 2005 & Teradata.
• Experience in developing analytics, dashboards, adhoc reports, published reports, static reports through SAP BO, Xcelsius. Well versed with all phases of SDLC.
• Expertise in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, aliases, contexts, aggregate awareness using business objects designer.
• Expertise in UNIX shell scripting.
• Extensive Knowledge of RDBMS concepts, PL/SQL, Stored Procedure and Normal Forms.
• Good knowledge of DollarU tool for scheduling the jobs.
• Expertise in setting up load strategy, dynamically passing the parameters to mappings and workflows in Informatica & workflows & data flows in SAP Business Objects data services integration tools.
• Experience in developing end to end business solution by providing design solutions on technologies to be used.
• Well experienced in functional and technical systems analysis & design, systems architectural design, presentation, process interfaces design, process data flow design, and system impact analysis and design documentation and presentation.
• Experience with dimensional modelling with both star and snow flake schema using Ralf Kimball methodology with experience in manufacturing & logistics projects. Well versed with extract and loads of large data volumes.
• Experience in extracting data through Mainframes, Relational databases, flat files, excels, XML files & SAP R/3.
• Excellent knowledge of SQL, T - SQL, PL/SQL, cube design.
• Proficiency in SQL in both relational and star-schema environments
• Proven experience in project and team leading with zero defect delivery. Equally comfortable working independently as well as in a team environment
• Experience of handling large scale projects.
• Excellent experience on implementing slowly changing dimensions - Type I, II & III
• Demonstrated ability to lead projects from planning through completion under fast paced and time sensitive environments
• Excellent experience in handling and leading team of 10 people which involve onsite and offshore model.
• Excellent knowledge of planning, estimation, project coordination and leadership in managing large scale projects.
• Good interpersonal communicator who effectively interacts with clients and customers
• Decisive, energetic and focused team lead/player who takes ownership and responsibility for requirements and contributes positively to the team.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post-implementation review.
• Experience of CMM Level-5 project processes, methodology and Implementation
• Competent technical knowledge with 9+ years of hands on experience. Strong problem solver who can design & develop solutions and assist developers with issues.

TECHNICAL SKILLS

Programming Languages: SQL,T-SQL, PL/SQL, stored proc

DBMS: Oracle 8i/9i/10g, SQL-Server 2005, Access, Teradata

Reporting Tools: Webi, DeskI, SAP BOXI, Xcelsius

ETL Tools: Informatica 7.1, 8.1 & 8.6, SAP BO DI

Design/CASE Tools: MS Project, Visio

Operating Systems: Win 2003/XP/2000/NT, MS DOS, UNIX

Miscellaneous: MS VSS, WEBI, universe and ERWIN, TOAD 7.x

PROFESSIONAL EXPERIENCE

Technical Lead

Confidential

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Involved in defining the overall strategy for design and standards by creating many checklists for smooth deployments.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Worked on extracting real time data and loading to data warehouse.
• Lead a team of 10 (3 onsite, 7 offshore) delivering the best solution to the client.
• Usage of reusability in Informatica, parameterization, workflow design and mapping design.
• Scheduling and performance tuning of Informatica mappings.
• Wrote PL/SQL stored procedures, functions, nested tables. Extensive hands on experience in PL/SQL.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Extensively used ETL to load data from different source systems like Teradata Objects, Oracle, Flat files, etc., into the Staging table and load the data into the Target database.
• Collaborated with data modellers, ETL developers in the creating the Data Functional Design documents.
• Created the Staging mappings for delta detection using the different Transformations (Expression, Lookup, Joiner, Filter, Router, Stored Procedure etc.)
• Writing BTEQ scripts for Teradata DDL & DML statements.
• Free hand SQL, reports with calculation context and drill down features.
• Project estimation, planning and Tracking.
• Requirements analysis, Design, Code and Design reviews.
• Designed and implemented star and snowflake schemas to handle 1:N and M:N relationships.
• Used CVS for deployment, Autosys and Crontab for scheduling.
• TOAD - is used extensively for connecting to Oracle databases and running the SQL scripts and PL/SQL jobs.
• Involved in project planning, estimation, design and architectural discussion with architecture team for data warehouse.

Environment: Informatica 8.6 on UNIX, Oracle 10g, Teradata 12.0, BTEQ and PL/SQL, TOAD.

Technical Lead

Confidential, San Jose CA

Responsibilities:

• INFORMATICA - extraction from Oracle DB, transform and load to Teradata & Oracle DB. Excellent knowledge on work flows, sessions, tasks, transformations, mappings, file lists, performance tuning.
• Lead a team of 10 (3 onsite, 7 offshore) delivering the best solution to the client.
• Usage of reusability in Informatica, parameterization, workflow design and mapping design.
• Scheduling and performance tuning of Informatica mappings.
• Prepared mapping documents and technical specifications
• Writing PL/SQL stored procedures, functions, nested tables. Extensive hands on experience in PL/SQL.
• Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
• Extensively used ETL to load data from different source systems like Teradata Objects, Oracle, Flat files, etc., into the Staging table and load the data into the Target database.
• Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Collaborated with data modellers, ETL developers in the creating the Data Functional Design documents.
• Created the Staging mappings for delta detection using the different Transformations (Expression, Lookup, Joiner, Filter, Router, Stored Procedure etc.)
• Writing BTEQ scripts for Teradata DDL & DML statements.
• Free hand SQL, reports with calculation context and drill down features.
• Universe with aggregate navigation and derived tables.
• Scheduled & adhoc Webi reports.
• Dashboards creation using Xcelsius.
• Project estimation, planning and Tracking.
• Requirements analysis, Design, Code and Design reviews.
• Designed and implemented star and snowflake schemas to handle 1:N and M:N relationships.
• Scheduling and broadcasting of reports.
• Knowledge of various DW industry tools, so able to suggest a best solution at the right time.
• Writing PL/SQL functions and procedures, use of cursors, complex queries and ability to guide the team. Excellent communication skills
• PVCS - Polytron Version Control System, is used extensively for Configuration management purposes to store the versions of SQL scripts, Informatica code, DollarU jobs etc.
• Quality Center - is used for tracking the defects, maintaining and running the test cases.
• Extensively used Kintana tool for creating the packages and migrating the code.
• TOAD - is used extensively for connecting to Oracle databases and running the SQL scripts and PL/SQL jobs.
• Involved in project planning, estimation, design and architectural discussion with architecture team for data warehouse.

Environment: Informatica 8.6 on UNIX, Business objects XI R2 on Windows XP (DeskI, WebI reports)Oracle 10g, Teradata, BTEQ and PL/SQL, Xcelsius, TOAD.

Technical Lead

Confidential, Rochester NY

Responsibilities:

• Lead a team of 8 (4 onsite, 4 offshore) at client location in Rochester, NY
• Involved in discussion and participation in designing a new EDW data warehouse with architects.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Analyzed both the source systems - Legacy and new commerce platform to map the data into data warehouse accordingly.
• Designed and developed SAP BO DI jobs and workflows to load data from Source systems to ODS and then to Data Mart.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Excellent knowledge of dimensional, relational, logical & physical data modelling helped clients build efficient data model. A new enterprise data warehouse was built as part of the project.
• Build reports using SAP BO, Universe, WebI and DeskI
• Wrote stored procs, T-SQL, complex queries and guide team for technical and domain related issues. Excellent communication skills
• Scheduling of DWH jobs, scheduling of BO reports.
• Excellent knowledge on materialized views.
• Creation of Join conditions, Filters, LOV, cardinality, aliases, contexts, aggregate awareness using business objects designer

Environment: SAP BO DI, Business objects XI R2/R3 on Windows XP (DeskI, WebI reports)Oracle 10g, SQL Server 2005, PL/SQL, T-SQL, Xcelsius.

Technical Lead

Confidential, Buffalo NY

Responsibilities:

• One point of contact for handling Order management, procure to pay, Finance areas and was involved in project planning, estimation, coordination with onsite-offshore and clients, smooth delivery.
• Lead a team of 6 at client’s location.
• Experience in handling critical projects with demanding client. Experience working on Informatica, Oracle, Teradata & SAP Business objects.
• Experience in PL/SQL, stored procs, BTEQ, Complex Informatica mappings, Unix shell script.
• Experience in SAP BODI, DQXI, understanding of data quality concepts
• Experience in providing lights on support on datawarehouse environment. Excellent analysis and resolution skills.
• Handled end to end standalone projects independently delivering them efficiently and effectively. Gained confidence and appreciations from client.
• Experience in working with multilingual people and worked with business users from Canada, Germany, Latin America, UK & Singapore.
• Knowledge of OLAP, static and adhoc reporting tools.

Environment: Informatica 8.6 on UNIX, Business objects XI R2 on Windows XP (DeskI, WebI reports)Oracle 10g, Teradata, BTEQ and PL/SQL, SAP BO DI.

Software Engineer

Confidential

Responsibilities:

• Involved in preparing Impact Analysis, High level design and program specification documents.
• Involved in coding and testing of individual modules using Oracle warehouse builder.
• Involved in system and integration test plan creation and testing
• Peer and group review of individual modules.
• Involved in discussion with clients and onsite team for understanding the requirements

Software Engineer

Confidential

Responsibilities:

• Carried out design and analysis
• System analysis and coding programs
• Requirements analysis and high level design documentation.