Data Analytical Engineer

ANKITH REDDY MORA

Data Analyst

Phone Number: +1-330-***-**** Email ID: ***************@*****.***, amora1@kent,edu LinkedIn : Ankith Reddy Mora

SUMMARY:

Azure-certified Data Analyst with 3 years of experience designing and implementing scalable data solutions on Azure.

Expertise in building ETL pipelines, managing data lakes, optimizing SQL databases, and enabling real-time analytics. Proficient in leveraging Azure services like Azure Data Factory, Synapse Analytics, Databricks, and Azure SQL Database to process and analyse large datasets.

Developed automation scripts using Python and PowerShell for data orchestration and pipeline monitoring.

Developed and deployed machine learning models using scikit-learn, XGBoost, and Azure ML, achieving high accuracy and F1 scores in predictive analytics tasks.

Created 20+ interactive dashboards using Tableau and Power BI, enhancing data visualization and stakeholder engagement for over team members.

WORK EXPERIENCE:

Cigna

Data Analytics Engineer January 2024 - Present

Directed projects using Agile Methodology with Jira, adhering to iterative and incremental development strategies to optimize outcomes for claims processing and third-party spending data.

Implemented Informatica PowerCenter to automate data extraction, transformation, and loading (ETL) from diverse sources, achieving a reduction of manual effort by 30 hours per week and a 20% increase in data integration efficiency.

Managed third-party vendor expense data by developing automated scripts in Python, using NumPy for efficient numerical operations, Pandas for data manipulation and analysis, and Matplotlib for visualizing trends and patterns, enhancing data formatting efficiency by 9%.

Orchestrated the creation of customized Power BI dashboards for visualizing claims data and monitoring claims processing efficiency, with KPIs including claims processing time, approval rates and backlog, notably reducing claims processing time.

Leveraged Azure services to establish a scalable data infrastructure and conduct advanced analytics on extensive datasets.

Engineered and maintained a MySQL database on Databricks, Azure Synapse Analytics facilitating data manipulation and generating dynamic reports via Power BI.

Elevated data visualization capabilities by deploying Tableau, creating interactive and insightful reports for stakeholders, and reducing data extraction times by 18% through streamlined integration with various data sources.

Conducted ad-hoc statistical analyses to answer management queries and support business strategies.

Wells Fargo

Data Analytics Engineer January 2021 - April 2022

Spearheaded a credit card offer optimization project, increasing approval rates by 22% while maintaining risk levels.

Developed a machine learning model using Python and scikit-learn to predict customer response to credit card offers.

Design and implement secure data pipelines into a Snowflake data warehouse from on-premises and cloud data sources

Prepared data warehouse using Star/Snowflake schema concepts in Snowflake using SQL.

Analyzed 5 years of historical data, encompassing over 50 million credit card transactions and 2 million customer profiles.

Utilized SQL and Spark for large-scale data processing, reducing analysis time from 2 weeks to 3 days.

Created Tableau and Power BI dashboards to visualize offer performance metrics, used by 200+ marketing team members to make informed decisions.

Implemented an A/B testing framework for offer strategies, resulting in a 15% increase in customer acquisition rates.

Collaborated with risk management to develop a custom credit scoring model, improving default prediction accuracy by 8%.

Used Azure Machine Learning to deploy and monitor machine learning models in the production environment, enhancing model reliability and reducing downtime.

Conducted cohort analysis to identify high-lifetime value customers, increasing targeted marketing ROI by 30%.

Developed an ETL pipeline using Databricks, Synapse Analytics processing 500GB of daily transaction data for real-time fraud detection.

Utilized time series forecasting to predict spending patterns, helping to optimize credit limits for 1.5 million cardholders.

Job Router

Data Research Associate May 2020 – October 2020

Managed the architect and implementation of data pipelines to aggregate, clean, and transform research data for 5 major research projects, improving data quality by 35%.

Utilized SQL and Python to organize and structure data, enhancing the overall quality and usability for key business insights.

Collaborated with 3 cross-functional teams, improving reporting efficiency by 20%.

Mindler

Digipreneur (Digital Marketing & Entrepreneurship) September 2019 –March 2020

Analyzed social media and marketing data using VLOOKUP, pivot tables to derive actionable insights, using SQL to query data and Excel for visualizations.

Developed automated reporting solutions using Zoho Desk, like ServiceNow support, which improved the efficiency of customer support processes by reducing response time.

Analyzed user behavior metrics for 5000+, enhancing program engagement by 15%.

PROJECTS:

Dashboards and Interactive Data Visualization using Tableau and D3.js:

Formulated interactive dashboards to visualize 3 high-dimensional datasets, enabling users to explore data through drill-down analysis and brushing techniques with D3.js.

Automated the extraction and transformation of data using SQL and Python before feeding it into Tableau for real-time visualization.

Created custom views for 5 key stakeholders, decreasing analysis time by 50%.

Agricultural Crop Recommendations:

Developed ETL pipelines to pre-process large agricultural datasets using Apache Spark and Kafka, ensuring real-time

data flow and accurate machine learning model inputs.

Engineered predictive models for crop recommendations using Python, achieving 90% prediction accuracy.

Deployed the model in a scalable environment, storing processed data in MongoDB for fast and efficient access.

Initiated APIs for integrating data with Power BI, improving visualization load time by 40%.

Power Supplier Recommendation using Big Data Analytics:

Led a predictive analytics project in the US energy sector by designing and enforcing an end-to-end data pipeline.

Applied Apache Spark for large-scale data processing and Elasticsearch for fast retrieval of supplier recommendations.

Improved model accuracy from 47.5% to 94.66% by optimizing clustering algorithms and linear regression techniques

within distributed data environments.

Visualized insights for 100+ energy suppliers using Tableau.

Real-Time Emotion Recognition and Sign Language Translation:

Built a robust data ingestion pipeline using Python and libraries like TensorFlow, NumPy, Pandas for handling 1000fps video data for hand gesture recognition.

Used MongoDB to store processed frames and corresponding sign language annotations, ensuring scalable and efficient data retrieval.

Integrated deep learning models for real-time classification, achieving 90% accuracy in sign language translation, and

optimized system performance to handle 15 FPS for live video feeds.

EDUCATIONAL QUALIFICATIONS:

Kent State University, Ohio - Masters – Computer Science 2022-2024

Vidya Jyothi Institution of Technology, Hyderabad - Bachelors – Computer Science 2018-2022

SKILLS:

Languages : C, Java, Python, R

Scripting Languages : PHP, JavaScript, Pyspark

Databases : MySQL, SQL, MongoDB, Kafka, Blob Storage, MySQL DB

Web Technologies : HTML, CSS, XML

Tools : Microsoft Office, Service Now, Apache Spark, Excel

Visualization Tools : Power Bi, Tableau, D3.js, Alteryx

Cloud Services : Azure (Data Bricks, Data Lake, Data Factory)

Other Skills : SSIS, SSRS, Machine Learning Algorithms, Probability distributions, Hypothesis Testing, Regression Analysis, Linear Algebra, Advance Analytics, A/B Testing, Clustering, Classification, Regression, A/B Testing, Data Wrangling, Jira, Git, GitHub, ANOVA

TRAINING AND CERTIFICATIONS:

Azure Data Associate Engineer (Dp-203) by Microsoft

ServiceNow Application Developer by ServiceNow

ServiceNow Associate& Professional System Administrator by ServiceNow

HTML, CSS, JavaScript essentials, by LinkedIn

Introduction to MongoDB by MongoDB association

PCPA-Programming Essentials in Python, by Indian Society for Education, on CISCO

Contact this candidate