Data engineer

APEKSHA RATHI

~Mobile No.: +1-469-***-****~E-Mail: **************@*****.***

~ LinkedIn - https://www.linkedin.com/in/apeksha-rathi-86171714/

Core Competencies

Technical Leadership & Project Management Lead Data Engineer Teradata Vantage Migration Lead Azure Cloud Platform Python Big Data Consulting

Professional Summary

Bringing 18 years of extensive experience in architecture, leadership, and delivery management, with a strong focus on data warehousing, data modeling, ETL, and business intelligence technologies. Proven ability in solving complex customer challenges and driving enterprise product development both on-premises and in the cloud.

Consistently demonstrated strengths in business acumen, technical expertise, and customer insight to drive successful business outcomes.

Leveraged extensive experience as a Delivery and Migration Consultant, specializing in migrating from Oracle, Netezza, and DB2 to Teradata. Provided valuable insights and recommendations in areas such as estimation, migration strategies, and architecture design. Played a key role in scoping efforts and contributed technical expertise to the development of Statements of Work (SOWs).

Proficient in complex Teradata SQL's & query optimization, tuning and python scripting. Data quality, metadata management, data discovery, reporting, and analytics using python. Provide best model with high query performance, optimized space CPU and memory utilization, Load balancing with concurrent job execution and parallel processing.

Collaborated closely with Business Analysts and Data Stewards to support data profiling, data mapping, and security and governance initiatives.

Contributed to proof of concepts (POCs), assisting the solution architect in recommending comprehensive cloud-based and on-premises solutions customized to meet specific client needs.

A strong combination of leadership, technical expertise, domain knowledge, and commercial experience.

Diversified industry experience such as Retail, Banking, Healthcare, and Insurance domains.

Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure Cloud.

Design and architect an EDW in the Microsoft Azure platform using Azure Data Factory, Azure Databricks and Azure Data Lake.

Machine Learning Experience - Creating data regression models using predictive data modelling and analysis data mining algorithms to deliver insights and implement action-oriented solutions to complex business problems.

Technical Skills

Data Modeling Tool

CA Erwin, Visio

Project Management Tool

MS Project

Cloud Platform

Azure, Teradata Cloud Lake, Conceptual Knowledge on AWS

Database

Teradata Vantage, Oracle, Microsoft SQL Server, DB2 UDB, Microsoft Access, Microsoft Excel.

BI Tools

MicroStrategy, Exposure on: Business Objects, Crystal Xcelsius 2008, Microsoft SQL Server 2005 (Analysis and Reporting Services) and other open source ETL and Reporting tools like Pentaho and Talent.

ETL Tools

Working knowledge on Abinitio, Informatica and DataStage.

Service Management Tool

Service-Now

Work Profile

Teradata USA Pvt. Ltd – Lead Consultant – September 2022 to May 2023

Teradata Operation INC – PS Consultant – December 2016 to January 2022

Teradata India Pvt. Ltd. – Sr. Technical Consultant – April 2012 to December 2016

Teradata India Pvt. Ltd. – Technical Consultant – January 2010 to March 2012

Syntel - Analyst Programmer – July 2008 to December 2009

Aztecsoft (MindTree) - Senior Software Engineer - December 2007 to July 2008

Infosys Technologies Ltd - Software Engineer - September 2005 to December 2007

Certifications

Project Management Professional (PMP) (2023)

ITIL Foundation (Year – 2013)

Teradata TE0 121 Basic Certification (Year - 2011)

MicroStrategy Certified Engineer (MCE) (Year - 2007)

oMicroStrategy Project Designer

oMicroStrategy Report Developer

oMicroStrategy Platform Administrator

MCP Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. (Year - 2007)

NCFM - Financial Markets: A Beginners’ Module

Achievements

Teradata Top 3 Project Lead and Handled – Q1 2023

Teradata Employee of the Quarter – Q4 2015

Teradata Project Long Service Award, 2015

Teradata Employee of the Quarter - Q2 2013

Syntel Star Performer for Innovation - 2009

Career Profile Highlights:

Teradata inc,TX

Sep 2022 – Till now

Technical Lead Consultant / Migration Lead

Consulting engagement scoping, planning, and organizing — Define project scope, estimate time, cost, and resources requirements. Plan projects designing according to Teradata PM Methodology. Assess project risk, develop risk mitigation strategies, and support the sales team to develop contracts and project pricing.

Develop and own technical and architectural vision to build a scalable and robust solution. Monitor and audit existing solutions and propose/develop a plan for continuous improvement.

Identify the business needs of our current and future customers to determine how our technology teams can best assist them.

Articulate ideas between product owners and developers and among different teams.

Teradata Inc, USA.

Dec 2016 – Jan 2022

Lead Data Architect / Technical Lead Consultant / Migration Lead (Azure) / PS Consultant

Implementation of Microsoft Azure. Real Time Streaming, Big Data, Data Mining and Predictive analysis.

Define cloud network architecture using Azure virtual networks, VPN and express route to establish connectivity between on premise and cloud.

Develop custom features in Visual Studio based on specifications and technical designs.

Design and develop Azure pipelines to implement and migrate data, as well as support development activities, including PySpark to address streaming requirements using Azure Databricks and Azure Data Lake.

Hands-on experience in driving solution strategy and managing end-to-end Software Development encompassing design, prototyping, development, validation, testing, support and sustaining and customer engagement.

Teradata India Pvt. Ltd., India.

Jan 2010 – Dec 2016

Lead Data Engineer / Consultant

As a Lead Consultant, define, develop, and implement strategy by working closely with customers, internal teams, engineering, and senior management team.

Aligning Business Intelligence Management solutions with strategic technology roadmap and emerging industry trends.

Data Architecture and Modeling. Modelling existing system processes and data flows.

Adopting Agile Methodology to reduce development time and saving on project cost.

Develops and recommends strategies based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.

Working on different phases of the development life cycle for the DWH like analysis, design and build estimations, designing, development, testing and manual data validation.

Consistently demonstrates ability to effectively coach and mentor; regarded and sought by more junior staff as a coach and mentor.

Achieve maximum ETL performance by reducing overall execution time by tuning ETL workflow and tasks.

Worked on translating business requirements into Teradata Value Analyzer – design, testing and implementation. Design of source/ target and driver criteria, modeling and promoting to higher environment. Translate TVA rules and results into model and analytical data set for Model analysis.

Syntel, India.

July 2008 – Dec 2009

Lead Software Engineer

Participating in Scope analysis, estimation, and deliverable.

Analysis data and existing data applications.

Participated to create an optimize Semantic Layer on top of the implemented using Teradata.

Participated in creating an efficient Data Model using Erwin data modeler to adhere all Business requirements.

Utilizing the DWH BI Semantic Layer to create schema objects (Metadata) in MicroStrategy 9.0.x

Creating report specific objects and utilizing them to create Sales specific reports and Dashboards. Creating Dashboards in MicroStrategy and Tableau, to be utilized by the client top management.

Tuning created reports and dashboards for getting optimal performance on MicroStrategy and Tableau. Worked on performance tuning on MicroStrategy and Tableau front. Handling huge metadata with multiple application objects.

Aztecsoft (A MindTree Organization), India.

Dec 2007 – July 2008

Senior Software Engineer

As a senior developer, provides solutions to facilitate successful data migration from source to the target database tables, code releases and quality of experience for the consumers.

Development of ETL using Ab Initio and Pl/SQL.

Converting the existing store procedure in from on graphs with optimal performance and generating the reports through MicroStrategy and Tableau.

Infosys Technologies Ltd., India.

Sep 2005 – Dec 2007

Software Engineer

As a developer, was involved in requirements gathering, preparing design documents for ETL Processes, and designing data warehouse schema.

Development of ETL using Informatica and Ab Initio.

Involved in building MicroStrategy and Tableau schema object and security objects.

Development of BI Dashboards and Reports to address business requirements.

Training and Seminars

Project Management Training

AZURE and AWS Vendor Training

Teradata and related Training

Vendor training on MicroStrategy

Vendor training on Abinitio

Business Objects, Crystal Xcelsius

Academic Profile

Post -Graduate in Data Science and Business Analytics, Austin, Texas (2022)

Graduate in Engineering from Shri Ramdeobaba College of Engineering and Management, Nagpur University, India (2005)

** Client Information, Project Details and Professional references available on request. Please feel free to reach out for further information. **

Contact this candidate