SUCHITA AMTE

adwp3d@r.postjobfree.com ● Seattle, WA ● 201-***-****

Summary:

Data Engineering Professional with over 15 years of cross industry experience in designing and implementing end-to-end ETL solutions for Data Warehousing applications. Managed individuals and teams across the regions to successfully achieve organizational and professional goals.

Core Competencies:

• Expertise in end to end designing and implementation of ETL solutions for Data Warehousing applications.

• Adept at analyzing project requirements and developing appropriate strategies.

• 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.

• Ability to quickly master new skill, technology or role.

• Proven success in various roles, such as Solution architect, Team Lead, Lead Developer 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 Big Data Tech Stack: Snowflake, DBT, Airflow, Python, Athena, Glue, Scala, AWS S3 Tools & Miscellaneous: SQL Server Agent, Autosys, HP Quality Center, Visio, ER Studio Change Management: Git, Perforce, VSS

Professional Experience:

Indeed.com September 2022 – March 2023

Sr. Data Engineer

Indeed is an American worldwide employment website for job listings. Indeed strives to put job seekers first, giving them free access to search for jobs, post resumes, and research companies. Key flagship projects and deliverables: Jobseeker data mart, Geolocation API Logging

• Led data model design for Jobseeker subject area.

• Designed and built DBT models, unit and schema tests to implement the model in Snowflake using CI/CD pipeline.

• Implemented a creative QA strategy during the deployment freeze resulting in on-time PROD release.

• Thorough data validation and testing resulting in identifying issues in pre-built pipelines.

• Developed cost-performant code. Total approximate cost of creating all the Jobseeker datasets is ~$400/month.

• UAT showed that coverage of metrics increased (7%-25%) and no bugs were reported.

• Built reusable logging framework for Geolocation API module. Opensignal (acquired ShareTracker in October 2020) October 2020 – August 2022 Sr. Staff Engineer

Opensignal (rebranded from Comlinkdata) is the leading data and analytics provider to the global telecom industry. Specialist in network insights, business and residential subscriber behavior, and sales enablement across wireless, wireline, broadband, and device ecosystems.

Key flagship projects and deliverables: Integration initiatives, Tablets MarketShare, Xfinity Ingestion

• Leading creation of Tablets MarketShare and B2B file generation using Bigdata tech stack (Athena, Glue and Scala).

• Incorporating feed from Xfinity into Opensignal’s core Wireless MarketShare product.

• Integrated daily porting segmentation details in Opensignal’s flagship Carrier Vision product.

• Leading discussions to build roadmap for integrating ShareTracker products with Opensignal’s product suite. ShareTracker March 2016 – October 2020

Team Lead & Senior Data Warehouse Engineer

ShareTracker is one of the largest U.S. market research companies dedicated to telecom and broadband market share measurement analytics.

Key flagship projects and deliverables: Internal Line Number Portability (LNP), Line Level Automation, Consumer and Business MarketShare

• Implemented Internal LNP database, to build a centralized database maintaining number portability information on a daily basis for 330 MM+ phone numbers. Successfully diverted all the internal products to use this DB leading to annual cost savings of $100K.

• Designed and developed several automated products leading to head count efficiency and cost savings of $100K+.

• 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, design, and implementation.

CEO recognition as “Champions of ShareTracker” for strong customer focus, exemplary leadership and end to end ownership. Data Warehouse Engineer (Consultant through Infocepts, USA) March 2014 – February 2016 Key flagship projects and deliverables: Wireless Flowshare, Big C, IOT

• Led the team of 6 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.

• Provided technical oversight 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.

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.

• Led cross team engagements for requirements gathering for efficient UI experience.

• 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 & Certifications

• Bachelor of Technology (National Institute of Technology, India) GPA 3.5 2006

• Netezza Silver certification

• Teradata Basics V2R5

Contact this candidate