SUMMARY

• Highly motivated and dedicated IT professional with 11 years of experience, specializing in Architecting & Building Enterprise Data Warehouse, Data Modeling, Big Data Stack, and Business requirement analysis, Design, Development, Problem Solving, Performance Tuning and Technical Support.
• Extensive experience in architecting the Data warehouse & Data Mart solutions
• Data analysis and Reporting using Business Objects, SQL Server Reporting Services(SSRS), Tableau, Oracle, Teradata, SQL Server, DB2, MySQL,
• Good experience in Big Data Hadoop, HDFS, Map Reduce, Pig, Hive, HBase, Python, Mongo DB & Greenplum database
• Proficient in data warehousing concepts - Star Schema, Snowflake Schema and Slowly Changing Dimensions
• Experience with database Performance Tuning (query optimization) and performance tuning related to ETL development
• Extensive experience in developing complex mappings using different transformations like aggregator, sorter, expression, look up, update strategy, normalizer
• Proficient in working with SQL, PL/SQL to write stored procedures, Functions, Cursors, Triggers and Packages.
• Proficient in writing B-teq, M-load, Fast-load, Fast-Export, TPump utilities in Teradata
• Certified Teradata Professional with proficient knowledge on the understanding of the Teradata MPP Architecture (Massively Parallel Processing) and design experience in Financial Services Logical Data Model (FS-LDM)
• Experience in designing BI reporting solutions, Web Intelligence, Desktop Intelligence, Designer, and Crystal Reports
• Experience in writing Python, Perl, UNIX shell scripting using awk, sed etc
• Excellent analytical, written & verbal communication, interpersonal skills and ability to effectively communicate conceptual and technical subjects.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.X/8.X/7.X/6.X, Data Stage, SSIS, ODI

OLAP Tools: Business Objects 6.1/5.1/ XI R2,SSRS, SSAS, OBIEEE 10.1.3.3.3, Tableau

Big Data: Hive, Pig, Map Reduce, HDFS, HBase, NoSQL, Mongo DB, Sqoop, Yarn

Databases: Teradata, Oracle 11g/10g/9i/8i, SQL Server, DB2, MySQL, Mongo DB, Netezza

Languages: C, C++, SQL, PL/SQL, T-SQL, Java, Python, Perl

OS: Windows 98/2000/XP, UNIX, Linux

Others: Erwin 4.0, Toad, IBM Tivoli 5.3, Control M, Redwood Cronacle 6, $U, Clear Quest, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto

Data Warehouse Architect/BI Analytics ETL Lead

Responsibilities:

• Gathering requirements, assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Architect an overall analytical Data warehouse & Data Mart strategy, including how to structure, where to host, and how to analyze and report on the data
• Determine the right measures/key performance indicators (KPIs), starting with industry standards, and defining different measures for different levels of management team
• Handle different types of relevant data which affect speed of assimilation as well as information recall, e.g., structured data and unstructured data
• Developed the Informatica ETL code to pull the data from multiple data sources and populating into the data warehouse
• Worked with Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor
• Successfully implemented ETL error handling, ETL control tables, ETL audit process, generated automatic loading and error monitoring reports.
• Designed the Product Engineering data mart which will correlate the data from multiple data sources and to generate the Tableau reports and developed the Informatica ETL code to populate the data mart
• Architect the solution and ensure that it fits into the overall ETL/Informatica architecture at Client
• Worked on HDFS, Map Reduce, HBase, Pig, Hive, Python etc.

Environment: Informatica PowerCenter 9.6, Perforce P4V, Bugzilla, HPALM, MySQL, Oracle 11g, UNIX, Tableau & ERWIN

Confidential, Santa Clara

Data Analyst, Lead BI Developer

Responsibilities:

• Gathering requirements, assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Performed data analysis on the Profiles, Orders, Return Orders, Sales Pricing & Promotions, Kohl’s Cash, and Sweepstakes emails data for migrating data from BM to ATG platform by considering the volumes (Millions & Billions) of the data to present to the customer and worked on the performance tuning
• Developed Technical Design / Specifications, develop Informatica mappings for data extraction and loading
• Developed the Source to Target mapping(STM’s) which specified how to populate the attribute from BM for migrating the data from BM to ATG platform
• Successfully implemented ETL error handling, ETL control tables, ETL audit process, generated automatic loading and error monitoring reports.
• Extensively worked on complex ETL mapping by using Informatica Normalizer, Aggregator, Lookup, Update Strategy, Joiner, Union, Router, Sorter
• Responsible for Bug fixing, Trouble Shooting, improving ETL and System performance.

Environment: Informatica PowerCenter 9.6, Blue Martini, ATG, Oracle 11g, Control M, Business Objects & UNIX

Confidential, San Jose

Data Analyst, Lead BI Developer

Responsibilities:

• Assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Architect the solution and ensure that it fits into the overall ETL/Informatica architecture at Client and ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view
• Gathering and documenting the technical and business meta data about the data as well as providing insight into the data itself by developing data flow diagrams and mapping specifications and Technical Design.

Environment: Informatica PowerCenter 9.1, Oracle 11g, $U, OBIEE

Confidential, San Diego

Business Analyst, Data Analyst, Lead ETL Developer

Responsibilities:

• Assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Coordinate all aspects of the project with other teams, such as Data Architecture, Reporting, Quality Assurance, Support, Infrastructure as well as business owners and management
• Perform impact assessment and scope the size of the effort based on the requirements
• Architect the solution and ensure that it fits into the overall ETL/Informatica architecture at Client and ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view
• Gathering and documenting the technical and business meta data about the data as well as providing insight into the data itself by developing data flow diagrams and mapping specifications and Technical Design.

Environment: Informatica PowerCenter 8.1, Oracle 11g, Control M, Business Objects & UNIX

Confidential, San Diego

Business Analyst, Data Analyst, ETL Lead Developer

Responsibilities:

• Assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Coordinate all aspects of the project with other teams, such as Data Architecture, Reporting, Quality Assurance, Support, Infrastructure as well as business owners and management
• Perform impact assessment and scope the size of the effort based on the requirements
• Architect the solution and ensure that it fits into the overall ETL/Informatica architecture at Client and ensure new features and subject areas are modeled to integrate with existing structures and provide a consistent view
• Gathering and documenting the technical and business meta data about the data as well as providing insight into the data itself by developing data flow diagrams and mapping specifications and Technical Design.

Environment: Informatica PowerCenter 8.1, Oracle 11g, Control M, Business Objects & UNIX

Confidential

Data Architect, Data Analyst

Responsibilities:

• Assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of artifacts.
• Requirement analysis/documentation, functional documentation, DW and ETL designing, developing detailed mapping specifications
• Ensured new features and subject areas are modeled to integrate with existing structures and provide a consistent view
• Gathered and documented the technical and business metadata about the data as well as providing insight into the data itself.
• Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences.

Environment: Informatica PowerCenter 8.1, Teradata, Business Objects, UNIX & Erwin

Confidential

Sr ETL Lead Developer & Teradata Developer

Responsibilities:

• Worked in BAU(Business As Usual), (Production) support in the Issue fixing Team and supporting EWSS project
• Involved in the development, testing and go live phases of EWSS and moved into BAU support for EWSS, assisted with build, test, and deploy activities
• Leading the team with the size of 5 and effectively getting the work from the team
• Worked on B-Teq Scripts, M-Load, Fast load to load the data from the source tables to target tables in Teradata
• Worked in Deploying and Managing SSIS Packages
• Create complex interactive reports as well as ad-hoc queries (Deski, Webi).

Environment: Informatica PowerCenter 7.1.2, Teradata V2R5, MS BI, Business Objects, UNIX & Erwin

Confidential

ETL Developer/Lead & Teradata Developer

Responsibilities:

• Analyzing & reviewing the client’s source map specifications and involving the walk through phases for each module prior to development.
• Leading the team with the size of 5 and effectively getting the work from the team
• Responsible to document design /technical process and get sign of from Client
• Worked on M-Load, Fast load to load the data from the source tables to target tables in Teradata

Environment: Informatica PowerCenter 7.1.2, Teradata V2R5, Business Objects & UNIX