Home

Savitha - Senior Data Analyst

[email protected]

Location: Jersey City, New Jersey, USA

Relocation: Yes

Visa: CPT

Resume file: Savitha- Data Analyst_1757429357000.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

SAVITHA +1 609-357-4757 [email protected] SUMMARY Over 9 years of experience in Data Visualization, ETL, and Business Intelligence. Expertise in Microsoft Power BI, SQL, ETL, Python and PySpark. Skilled in designing interactive dashboards, automating workflows, and leveraging advanced analytics to drive business decisions. WORK EXPERIENCE Biglots Columbus, OH Sr. Data Analytics Engineer | May 2024 Present Led analytics engineering initiatives analyzing 18+ months of historical sales data across multiple product categories to understand true item profitability by region, while processing real-time inventory movements using Databricks on ADLS for optimal performance and scalability Designed system architecture for web application analytics platform with REST API backend integration, enabling real-time data processing for Order Management System (Sterling OMS) and inventory monitoring (IBM SIP) with microservices architecture Developed scalable web application backend integrating multiple APIs (payment processing, inventory management, order routing) with Databricks as the data processing engine, handling 10,000+ concurrent transactions daily Designed and implemented automated testing frameworks using Python and PySpark for data pipeline validation, reducing manual testing efforts by 85% and ensuring data quality compliance Created comprehensive technical documentation including Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), and source-to-target mapping documents, translating complex business logic into Gherkins feature files for automated testing Developed analytics-ready datasets in Databricks using advanced SQL and PySpark transformations, enabling self-service analytics for Stores, Finance, and Sales teams Built interactive Power BI dashboards leveraging Databricks as the data source, implementing Row-Level Security (RLS) and automated refresh schedules for executive stakeholders Led product data discovery efforts to identify opportunities for maximizing business outcomes through workflow automation and analytics enablement, resulting in 30% improvement in operational efficiency Mentored junior data engineers on best practices for data modeling, pipeline validation, and business metrics interpretation Collaborated cross-functionally with Customer Service, Finance, and Operations teams to ensure alignment on business definitions and user stories, translating complex business logic into automated test cases Zoetis Columbus, OH Analytics Engineer | Dec 2023 May 2024 Migrated legacy AERA reports to Power BI with Databricks as the backend data platform, reducing subscription costs by 30% and improving report performance by 15% Built robust ETL workflows in Databricks extracting and transforming planning data from SAP IBP for demand forecasting, implementing automated data quality checks and validation processes Designed scalable data models for Production Forecast, Sales Forecast, and Sales Adjustment processes, achieving 40% faster processing time through optimized PySpark transformations Implemented automated testing frameworks for data pipeline validation using Python and SQL, ensuring data accuracy and consistency across cross-regional implementations Created executive dashboards with real-time KPI monitoring, leveraging Databricks Delta Lake for reliable data versioning and lineage tracking Developed parameterized reports and paginated reports using Power BI Report Builder, enabling dynamic filtering and improved stakeholder usability Lapetus Solutions Inc. Wilmington, NC Data Engineer Consultant | Aug 2023 Nov 2023 Developed automated data acquisition solution using Python and REST APIs for web scraping mortality data, implementing Databricks workflows for data processing and validation Enhanced client insights by 30% through comprehensive Power BI reports on underwriting metrics, utilizing Databricks for advanced analytics and risk assessment modeling Capgemini Client: Bayer BI Consultant | Dec 2020 Aug 2021 Reduced monthly manual reporting efforts by 90% by automating the data extraction, transformation and load process and creating a financial dashboard using Tableau for higher management of a leading pharma company to track KPIs like YTD sales, LE, LY, COGS, A&P, SG&A, GP, CAAP, and Contribution Single point of contact for all the support, deployment, and maintenance related activities for data loading process chains in SAP Business Warehouse on HANA. Infosys Client: Epiroc, Syngenta Business Intelligence Developer | Dec 2014 Nov 2020 Worked on requirement gathering, Business Requirement Document creation, Technical Specification document creation, UAT test script creation, UAT support, and hyper care support activities. Worked on SAP BI, Tableau applications and provided support and maintenance to 100% of client-critical applications. Involved in ETL development, enhancements, and development of Reporting application. Developed HR, pricing, inventory management, financial planning reports and dashboards by interpreting insights in data for driving business decision making solutions using SAP BEX, Tableau and Tableau dashboards for higher executives of one of the top 10 leading agricultural companies in the world. Recommended solution and prototypes to increase system effectiveness by 70% by developing a data quality framework and maintaining data governance. Performed RCA while handling incidents and tickets by providing solution & preventive measures within defined SLA s. University of North Carolina Wilmington Research Assistant Capstone Research: Statistical Analysis and Survey of ChatGPT tool in Computing Education. Performed t-tests and calculated p-values for different groups of data collected (Python) American Hospital Association (AHA): Extracted insights from AHA survey data in Python and applying Machine Learning techniques for hospital market segmentation. Achieved an accuracy of 78% Deep-Learning (Computer Vision): Developed a solution for fall detection within SoccerNet data, using object detection framework YOLOv3. Achieved an accuracy of 83% (Python) CERTIFICATIONS Power BI Data Analytics CodeBasics (Aug 2023) Microsoft Certified: Azure Enterprise Data Analyst Associate (Aug 2023) Practical Data Science on the AWS Cloud Specialization (June 2023) TECHNICAL SKILLS Languages: T-SQL, SQL, Python, R Database: MySQL, PostgreSQL, Oracle, HANA Cloud Databases: ADLS, Databricks Libraries: Pytorch, Tensorflow, Keras, OpenCV, Sklearn, Pandas, Numpy, PySpark Developer Tools: JupyterNotebook, SAP Netweaver, Git, Snowflake, Oracle Data Visualization: Tableau, Microsoft PowerBI, SAP Business Objects, Matplotlib, Shiny, Seaborn EDUCATION University of North Carolina Wilmington Master of Science in Computer Science and Information Science Osmania University Bachelor of Engineering in Computer Science and Engineering Keywords: business intelligence rlang logistics execution North Carolina Ohio