Technical Lead Resume Sunnyvale-CA - Hire IT People

SUMMARY:

Passionate and versatile engineer with proven experience in Application Development, Support, Data Analysis and Testing.
Hands on working experience in requirements gathering, reporting, documentation, planning, data analysis and testing.
Excellent knowledge in manipulating, cleansing & processing data using Excel and SQL.
Expert in writing complex SQL and Pl/Sql queries using Hive, Oracle, Vertica and Teradata
Hands on experience in working on Big Data platform.
Outstanding organizational skills including ability to multitask, prioritize, and manage complex issues.
Strong verbal and written communication skills.
Experience in multiple business domains (Health care, Financial, Retail, Advertising, Banking and Hi - Tech)
Strong exposure to SDLC and experience in working in agile and scrum methodologies.
An accomplished leader, a great team player.
Have interest in working and learning new technologies and tools

TECHNICAL SKILLS:

Languages: SQL, Pl/SQL

Scripting Language: Unix Shell Script, Python

DBMS/RDBMS: Oracle, SQL Server, MYSQL, Teradata, Hive

BI Tools: Informatica, Tableau, Business Objects, Hadoop

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale-CA

Technical Lead

Responsibilities:

Responsible for In-depth knowledge of data and understanding the business requirement and analysis
Support business users for their adhoc queries
Perform data analysis at every stage of the ETL process
Involved in test planning, Test scripts design and reviews.
Involved in UAT signoff before production deployments.
Monitor and co-ordinate to close defects by working closely with multiple teams.
Project planning and status reporting to the client.

Confidential,

Data Quality Analyst

Responsibilities:

Responsible for In-depth knowledge of data, process or application in the specific areas of responsibility.
Worked as part of an agile team to solve problems and deliver projects.
Coordinating defect triage and UAT kick off meetings
Write and manage complex SQL scripts to inspect data pre and post validation using SQL server and Oracle database.
Working with business users to identify and resolve problem.
Validating the cash flow reports on business object platform.

Confidential

Data Analyst

Responsibilities:

Working with Clients to understand the business requirement
Responding appropriately and in timely manner to user queries.
Preparing Functional specification documents from business requirement document
Presenting key finding to business stakeholders.
Test data set up, test planning and execution of test cases based on functional specification.
Developed complex SQL queries to verify the data for each stage of the ETL process and validate the Tableau dashboards against the database.
Track the data issues in Jira and own them till closure.

Confidential, Cupertino-CA

Data Quality Analyst

Responsibilities:

Understanding of Business Requirement Specifications and System Requirement Specifications for all new features added to the Ad Server.
Involved in test planning, test data setup, test scenario simulation and test review.
Involved in load/performance testing using Jmeter.
Study and verify the server logs to debug the issues.
Developing Sql scripts for soak testing in QE environment and validating the backend data.
Creating Hive scripts to validate the transaction data for iAd.
Involved in monthly release cycles to validate the data deployment in production environment.

Confidential, Cupertino - CA

Technical Lead

Responsibilities:

Implemented procedures for testing, debugging and documentation of applications with Teradata and Hadoop/Hive.
Assisted in preparation of work estimates and timelines.
Conducted detailed review and analysis of test conditions, test cases and scripts.
Supported technical team members writing, execution and debugging of SQL queries.
Responsible for testing high volume data on Hadoop environment
Monitor the automation Jobs for validation on Hadoop platform for performance and take corrective action in case it conflicts with other ETL jobs.
Onsite Offshore co-ordination and status reporting to client.

Confidential, Cupertino - CA

Technical Lead (ETL Development)

Responsibilities:

Highly involved in functional requirement gathering, creating business requirement document and design document.
Developed complex procedures using Teradata 12.0.
Participated in performance review with Teradata performance team by sharing the queries used and the stats details.
Worked with data modeling team to confirm about the columns created as part of the new tables and the naming standards maintained.
Designed Complex Mappings for Slowly Changing Dimensions.
Job creation, scheduling and monitoring using Autosys.

Confidential, IL

Technical Lead

Responsibilities:

Understanding the functionality of the application and provide production support.
Involved in documenting the project related documents.
Onsite offshore co-ordination.
Worked on user queries for production issues and resolve them.