Amita Akole

Jersey City, NJ ***** +1-201-***-**** ad0cuq@r.postjobfree.com

SUMMARY

A dedicated data analyst with 4 years of experience in experience identifying efficiencies and problem areas within data streams, while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams, including SQL, and Excel data sources. Bringing forth the ability to synthesize quantitative information and interact effectively with colleagues and clients. Proven track record of generating summary documents for senior management. Experience in interpreting and presenting large datasets to improve spend efficiency across organizations. Experience in analyzing market tends and developing dynamic business strategies. Adept in collaborating with cross-functional teams and delivering projects on-time and on-budget. KEY SKILLS

Technical Skills: Data Analysis, Python, SQL, Excel, PowerPoint, Microsoft Azure Databricks

Visualization Tools: Tableau, Power BI, Microsoft Excel, Visio

Database: MySQL, SQL Server

Soft skills: Communication, Presentation, Problem-solving, Organizational, Critical-Thinking, Strong Analytical Skills, Dashboard and Metrics generation EXPERIENCE

METLIFE New Jersey (Dec 2021 – Present)

Data Analyst

Developed numerous supply chain KPI's including freight cost rate, order tracking, forecast volume, various inventory reports, backorders, internal customer service report etc using MS access and Excel.

Analyzing company financial information, conducting market research to plan the budget, forecasting the profit in Excel and presenting analysis reports to senior management for decision making.

Developed and implemented data pipelines using Azure Data Factory resulting in a 50% reduction in processing time to establish data flows in and out of the data storages.

Conducted efficient meetings, effectively articulating recommendations and solutions to stakeholders and communicated and presented default customers profiles along with reports using Tableau, analytical results and strategic implications to senior management for strategic decision making.

Implementation of excel formulas for analyzing cost savings, reporting on performance metrics and data integrity.

Built out the data and reporting infrastructure from the ground up using Tableau and SQL to provide real-time insights into the product, marketing funnels and business KPIs.

Reduced operational costs by 19% through research into multiple information sources and successful root cause analysis of production and performance problems.

Used SQL, Tableau, and Cloudera to compile monthly 40+ page summaries of company operations, identifying key areas for improvement for senior management.

Elicit, analyze, interpret business and data requirements to develop complete business solutions, includes data models (entity relationship diagrams, dimensional data models), ETL and business rules, data life-cycle management, governance, data lineage, metadata and reporting elements.

Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights.

Created the product backlog and roadmap based upon the company vision provided by the strategic goals and client needs.

EMPOWER MX REMOTE (Oct 2020 – Nov 2021)

Data Analyst (Apr 2021 – Nov 2021)

Led analysis of healthcare data for improving healthcare delivery and informing healthcare transformation initiatives and conducted statistical analysis using SQL on large datasets.

Designed and implemented predictive models to identify patient risk factors and predict adverse events.

Utilized Cognos to generate regular and ad-hoc medical reports.

Develop and maintain business intelligence applications including operational reports, dashboards, and ad hoc reporting.

Support the analytics needs of business units using tools by Adobe Analytics and Google Analytics to analyze web traffic.

Leveraged expertise in data modeling, SQL, and data manipulation to effectively handle large, complex, and disparate data sets.

Responsible for working with internal and external stakeholders to create and support business applications, data models, optimized data warehousing and reporting workflows, dynamic reports, and workflows using Power BI.

Design, implement reporting platforms (modeling, ETL, BI framework) and complex ETL frameworks that meet business requirements.

Business Analyst (Oct 2020 – March 2021)

Identified steps to reduce return rates by 10% resulting in an eventual $75k cost savings.

Responsible for gathering business and technical requirements, data profiling, requirements documentation for ETL and report development.

Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP. Extracted, interpreted and analyzed data using MS Excel to identify key metrics and transform raw data into meaningful, actionable information.

Analyzed the historical data for the incidents reported and the reoccurring issues. Presented this data to the business stakeholders to identify trends and opportunities for the improvement using SAP BI and ServiceNow Reporting.

BIRLA SOFT INDIA(Aug 2017 – Aug 2019)

Junior Data Analyst

Design user-friendly, time-saving macros for operations, lean, finance, and product marketing departments and created visualizations and published multiple dashboards and reports using Tableau.

Spearheaded a major pricing restructure by redirecting focus on consumer willingness to pay instead of product cost; implemented a three-tiered pricing model which increased average sale 35% and margin 12% and extracted and compiled data to analyze customer acquisition process.

Demonstrated strong verbal, written, and presentation skills using Google Slides to communicate complex concepts and findings to both technical and non-technical audiences.

Utilized advanced MS Office skills, including PowerPoint and Excel, to create professional presentations, and effectively analyze data using spreadsheet analysis and applied strong organizational skills to manage and prioritize multiple projects and tasks simultaneously. EDUCATION

PACE UNIVERSITY New York, NY 2019-2021

Master of Science in Information Systems

SAVITRIBAI PHULE PUNE UNIVERSITY INDIA 2014-2018 Bachelor of Engineering in Computer Engineering

Contact this candidate