firstname.lastname@example.org ● Seattle, WA ● 201-***-**** ● US Citizen
Experienced Data Engineering Professional with 12 years of industry experience in end to end design and implementation of cutting edge ETL solutions for Data Warehousing applications. Adept at analyzing project requirements and developing appropriate strategies. Committed to ensuring adherence to technology standards while utilizing business resources. Ability to quickly master new skill, technology or role.
• Proven success in various roles, such as Solution architect, Team Lead, Lead Developer
• Design, develop, implement and maintain ETL solutions for enterprise level data warehouses and data marts.
• Strong understanding of Data Warehousing Design & Data Modeling concepts - Ralph Kimball & Inmon methodologies for OLAP, OLTP databases.
• Spearheaded database migration initiatives related to SQL server and Netezza.
• Proficiency in writing complex T-SQL queries and stored procedures.
• Experience in analyzing data and deriving meaningful business insights.
• SDLC Implementation in Multi-Vendor and Multi Geographical Delivery Model.
• Client and Partner Relationship Management.
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility. Technical Skills:
Databases: MS-SQL Server, Netezza, Oracle, Informix Languages: T-SQL, NZPLSQL, PL/SQL
ETL Tools: Alteryx, SQL Server Integration Services (SSIS), Ab-Initio Tools & Miscellaneous: SQL Server Agent, Autosys, HP Quality Center, Visio, ER Studio Change Management: Perforce, VSS
Operating System: Windows
ShareTracker March 2014 – Till Date
Senior Data Engineer March 2016 – Till Date
ShareTracker is the largest U.S. market research company dedicated to telecom market share measurement analytics. For over 10 years, ShareTracker has helped the communications industry keep score by consistently delivering highly accurate market share and FlowShare measurement across all fixed and mobile services. Key flagship projects and deliverables: Internal Line Number Portability (LNP), Line Level Automation, Business Tablets MarketShare (currently in build phase).
Implemented Internal LNP database, to build a centralized database maintaining number portability information on a daily basis for 250 MM+ phone numbers. Successfully diverted all the internal products to use this DB leading to annual cost savings of $300K.
Designed and developed several automated products leading to head count efficiency and cost savings of $200K+.
Actively partner with key stakeholders to ensure quality product delivery and pre-sales for incremental new business.
Led product development and process improvement projects from conceptualization to closure by working closely with cross-functional teams, business unit leaders and engineering.
Estimate work effort, task planning, resource forecasting and developing strategy for delivering ETL solutions adhering to Agile development principles.
Actively manage ad-hoc request from both internal business departments as well as external clients.
Provided technical leadership and hands-on implementation in the areas of data techniques including data access, integration, modeling, mining, design and implementation. Data Engineer (Consultant through Infocepts, USA) March 2014 – February 2016 Key flagship projects and deliverables: Wireless Flowshare, Big C, IOT
Led the team of 9 offshore and onshore resources to transition the company’s flagship product (Wireless Flowshare) to a new database platform. It included data and process optimization for migration from Netezza to SQL Server.
Provide technical oversight on consulting engagements to ensure the solutions recommended and delivered are best in class.
Designed rule-based product model to support ever changing business requirements with minimal code changes, thereby resulting in smaller sprints and thus quicker “Go Live” time.
Relationship manager for onsite and interface between onsite and offshore where I allocated tasks, provided status update and led training and development initiatives.
CEO recognition as “Champions of ShareTracker” for strong customer focus, exemplary leadership and end to end ownership. Nielsen Media (Consultant through Infocepts, USA and India) September 2008 – January 2013 Data Warehouse Consultant
Delivered key migration and simplification projects involving Netezza and SQL Server.
Analyzed the requirements and transformation logic present in various Microsoft excels and scripts, created stored procedures for data transformation to implement same logic.
Designed and developed SSIS Mappings for populating the tables in Microsoft SQL Server.
Designed data mart on SQL Server to be used by Cognos reports.
Worked with UI team to understand their requirements and created materialized views to improve UI screen’s performance.
Conducted design walkthroughs for client and team members. Recognized as “Quality Champion” for two consecutive years for outstanding product delivery. Wachovia Financial Services (Consultant through Infosys) May 2006 – August 2008 ETL Developer
Worked on multiple data warehousing development/maintenance projects for Wachovia Financial Services.
Was responsible for all work related to assigned module; based on Ab-Initio, Informix and Autosys.
Analyzed the requirements provided by the clients and designed, built and tested the Ab-Initio graphs to fulfill the requirements.
Conducted Unit and Integrating Testing, created and reviewed Test Plan, Test Cases and Test Report.
Packaged the code for release.
Created relevant documentation at every step of SDLC process.
Involved in the development work related to the enhancements of the RISK application. Received “Shared Success Award” for delivering above and beyond client expectations. Key Strengths
Customer focused, analytical mindset, detail oriented, dealing with ambiguity.
Excellent communication and interpersonal skills, fast learner, hardworking and a versatile team player. Education
Bachelor of Technology, Visvesvaraya National Institute of Technology, India 2006 Certifications:
Netezza Silver certification
Teradata Basics V2R5