SUMMARY

• 10 + years of experience in Business Intelligence & Data Warehousing
• Strong domain knowledge on business functions including XaaS(Software as a Service), Bookings, Revenue, Finance & Marketing worked in big data environment and responsible to coordinate teams and architect cross functional data flow in Hadoop, Teradata and Oracle platforms with Good knowledge of Hadoop architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node, Resource Manager, Node Manager
• Hands on experience in installing, configuring, and using Hadoop ecosystem components like Hadoop MapReduce, HDFS, HBase, Oozie, Hive, Sqoop, Pig, Zookeeper, Flume
• Experience in analyzing data using HiveQL and Experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice - versa
• Knowledge of job workflow scheduling and monitoring tools like Oozie and Zookeeper
• Strong skills in Data Analysis, Data Requirement Analysis, Data Mapping for ETL processes and extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files with a Strong experience in Data Warehousing and ETL using Informatica Power Centre 9.6.1 & 10.1.0
• Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC)
• Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing
• Performance tuned Teradata SQL queries by using query plan and creating indexes to minimize query execution times.
• Strong Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multi Load, Fast Export, Tpump, TPT)
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies
• An enthusiastic and project-oriented team leader with solid communication and leadership skills, self-driven and the ability to develop creative solutions for challenging client needs

TECHNICAL SKILLS

Operating Systems: Windows, Unix, Linux

RDBMS: Teradata v15, Oracle

ETL: Data Analysis Tools

Informatica: Hive, Pig, Sqoop, Oozie, Flume, Zoo Keeper

Reporting Tools: Tableau

DW Domain Knowledge: XaaS, Bookings, Revenue, Marketing

Languages: Hiveql, SQL

Process & Methodologies: Waterfall, Agile Methodology

Other Tools & Utilities: $Universe (Job scheduling tool), Serena PVCS Version Management tool, Kintana - HP Project and Portfolio Management, HP Quality center, Rally, Udeploy & Urelease, TES Jobs

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Tech Lead

Responsibilities:

• Responsible for managing the offshore team and to ensure timely delivery of all capacities needed by reporting application team
• User/stakeholder interaction, working with clients on requirements based on their business needs.
• Effort estimation, Planning resources, task allocation, test scenario authoring Test planning, execution and defect monitoring with on time delivery.
• Tracking and Reviewing of weekly status, consolidation of status, escalation of issues and any re-planning
• Udeploy & U Release deployment in Teradata, monitoring and reporting, Identifying risks- prioritize the risks and plan mitigations.
• Tuning Teradata SQL queries by using query plan and creating indexes to minimize query execution times.
• Extraction of incremental data using ETL (Informatica) tool from Oracle to Teradata.
• E2E, ETL, Functional validations from source to target, Data analysis and defect reporting
• Providing support to various down streams, business and User acceptance testing.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives
• Involving in Functional Testing & Regression Testing, writing complex SQL queries to verify data from Source to Target
• Used Rally for creating and documenting Test Plans and Test Cases and register the expected results.
• Using Rally for storing, maintaining the test repository, bug tracking and reporting

Environment: Agile,Teradata, Informatica, Udeploy & Urelease, Artifactory, Oracle, UNIX, Rally

Confidential, Milpitas, CA

Tech Lead

Responsibilities:

• Implementation of Enterprise XaaS for Bookings, Revenue in Enterprise warehouse for various monetization models on cloud SaaS including perpetual(own upfront), Subscribe(Prepaid term or SaaS) and Utility(pay as you go models)
• User/stakeholder interaction, working with clients on requirements based on their business needs.
• Effort estimation, Planning resources, task allocation, test scenario authoring Test planning, execution and defect Monitoring with on time delivery.
• Worked with application teams to install operating system and Hadoop updates, patches, version upgrades as required
• Created Hive Tables and extensively used SQL and HQL for processing the data. Integrated data from various sources into Hadoop and Move data from Hadoop to other databases using Sqoop import and Export
• Wrote SQL queries to load the required data to HDFS and Experienced in managing and reviewing Hadoop log files
• Extraction of incremental data using ETL (Informatica) tool from Oracle to Teradata.
• E2E, ETL, Functional validations from source to target, Data analysis and defect reporting
• Providing support to various down streams, business and User acceptance testing.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives
• Involving in Functional Testing & Regression Testing, writing complex SQL queries to verify data from Source to
• Target
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

Environment: Teradata, Hadoop, Informatica, HDFS, Hiveql, Oozie, Zookeeper, Linux, Udeploy & Urelease, Artifactory, Tableau

Confidential, Milpitas, CA

QA Analyst

Responsibilities:

• Responsible for managing the offshore team and to ensure timely delivery of all capacities needed by reporting application team
• User/stakeholder interaction, working with clients on requirements based on their business needs.
• Effort estimation, Planning resources, task allocation, test scenario authoring Test planning, execution and defect monitoring with on time delivery.
• Tracking and Reviewing of weekly status, consolidation of status, escalation of issues and any re-planning
• Kintana package deployment in Teradata, monitoring and reporting, Identifying risks- prioritize the risks and plan mitigations.
• Tuning Teradata SQL queries by using query plan and creating indexes to minimize query execution times.
• Huge volume of Data migration from 11i to R12 for bookings, revenue and customers.
• Extraction of incremental data using ETL (Informatica) tool from Oracle to Teradata.
• E2E, ETL, Functional validations from source to target, Data analysis and defect reporting
• Providing support to various down streams, business and User acceptance testing.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives
• Involving in Functional Testing & Regression Testing, writing complex SQL queries to verify data from Source to Target
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

Environment: Teradata, Informatica, Oracle, Unix, Kintana, Dollar U, PVCS, HP Quality Center

Confidential, Milpitas, CA

ETL Tester

Responsibilities:

• User/stakeholder interaction, working with clients on requirements based on their business needs.
• Effort estimation, Planning resources, task allocation, test scenario authoring Test planning, execution and defect monitoring with on time delivery.
• Tracking and Reviewing of weekly status, consolidation of status, escalation of issues and any re-planning
• Kintana package deployment in Teradata, monitoring and reporting, Identifying risks- prioritize the risks and plan mitigations.
• Tuning Teradata SQL queries by using query plan and creating indexes to minimize query execution times.
• Huge volume of Data migration from 11i to R12 for bookings, revenue and customers.
• Extraction of incremental data using ETL (Informatica) tool from Oracle to Teradata.
• E2E, ETL, Functional validations from source to target, Data analysis and defect reporting
• Providing support to various down streams, business and User acceptance testing.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives
• Involving in Functional Testing & Regression Testing, writing complex SQL queries to verify data from Source to Target
• Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

Environment: Teradata, Informatica, Oracle, Unix, Kintana, Dollar U, PVCS, HP Quality Center