adhoq0@r.postjobfree.com 405-***-**** www.linkedin.com/apurva-wankhade github.com/ApurvaW

SUMMARY:

Highly motivated, hard-working and meticulous Data Analyst passionate about helping businesses succeed. My job has enhanced my abilities to work individually as well in groups, similarly in multicultural environments too. Apart from my technical background, my strong co-curricular background has enkindled excellent crisis management skills in me. I am a quick learner and if given an opportunity; I ensure to strive hard and utilize my skills to be an asset to the company. TECHNICAL SKILLS:

Python, R, SAS, SQL, Tableau, Informatica, C/ C++, JavaScript, Java, HTML5, PHP.

Machine Learning, Advanced Analytics, Data Mining, Natural Language Processing, Statistics and Probability, Data Warehousing, Data Visualization, Data Quality Assessment, Data Analysis, Pattern and Trend Identification.

Agile Development, Project and Team Management, MS Visio, Balsamiq, JIRA, Git, Excel, PowerPoint. PROFESSIONAL EXPERIENCE:

Data Reporting Analyst Arizona Department of Child Safety June 2020- Present

Successfully created Tableau reports to identify and analyze the unnotified child abuse, child fatality and many more thereby, saved 5% of children from their perpetrators.

Lead the definition of operational reports, decision support tools, KPIs, dashboards, and analytic models that provide enhanced insight and improve organizational decision-making.

Assisted Data Architects in designing the database and identified the relationship between data marts using SQL.

Performed analysis to bridge the technical expertise with operational experts and subsequently documented the enhancements to meet the end state requirements.

Identified the data requirements, gathered and integrated the data from disparate sources using SQL along with designing and maintaining data sets and databases.

Created Source-to-Target data Mapping document and ensured that data is mapped correctly across applications maintaining data quality using SQL.

Collaborated with business and product teams to identify opportunities for process optimization, recommend system modifications, and develop policies for data governance and created artifacts.

Conducted thorough quality assurance process and engaged relevant team members to ensure high quality analysis and valid insights were derived.

Assisted Project Manager and Test team Lead to track development of the product by designing the artifacts as Project Plan document and Test Plan document based on Business Requirements, technical specifications, improvements recommended and/or product knowledge. Data Analyst Blue Cross Blue Shield, IL July 2018- May 2020

Essayed a key role in reducing the time span of processing reports from 20 mins to 12 secs, by using complex SQL queries and Shiny-R interface, thus reducing the revenue spent on the task and increasing the product efficiency by 89%.

Created interactive web application using Shiny-R for audience to understand the quotation trends for last 2 SFY using interactive graphs and integrated downloadable reports for multiple providers through multiple networks.

Proficiently queried in SQL to perform ETL, data validation and generated reports using SQL and SAS.

Commendably headed data analysis & reporting of over 50 ad hoc reports to facilitate statistical analysis & data integrity checks for identifying key risk indicators and remediate the business process.

Identified variances between expenses & costs to monitor budget variances and facilitated more effective planning and budgeting/forecasting of spend on premiums using SQL.

Developed and monitored KPI’s for fruitful cost utilization and other fundamentals for all included states using Tableau interactive dashboard.

Assisted the Data Architect to build new Data Marts that provided with clean and integrated data to the engineering team.

Created Source-to-Target data Mapping document and ensured that data is mapped correctly across applications maintaining data quality using SAS and SQL.

Created appropriate artifacts that allows stakeholders to understand the steps of the data analysis process and replicate the analysis if necessary.

Performed GAP analysis to bridge the technical expertise with operational experts and subsequently documented the enhancements to meet the end state requirements.

Planned and administered Research and Development (R&D) resources (staff, vendors, hardware, and software) to improve product offerings.

Conducted thorough quality assurance process and engaged relevant team members to ensure high quality analysis and valid insights are derived.

Actively involved in user training sessions for User Acceptance Testing (UAT) team and participated in user testing.

Assisted Project Manager and Test team Lead in development of planning artifacts as Project Plan document and Test Plan document based on Business Requirements, technical specifications, improvements recommended and/or product knowledge. Electronic Template Designer/Analyst University of Massachusetts, Dartmouth September 2016- June 2017

Successfully designed Templates for University students to write thesis aligned with the rules and regulations of the University. Achieved to reduce the time consumption of students and officials to 50%.

Conducted and participated in brainstorming sessions with administration staff and system users to collect the Template Requirement Specifications.

Created User Requirements Document (URD), Business Requirements Document (BRD) and Functional Requirements Document (FRD) along with wireframes and mock-ups.

Acquired the business Sign-Off on the Business Requirements Document (BRD) and functional requirement document (FRD).

Ensured data integrity of the application and made sure that the product meets the business needs by manually verifying the contents of the template. Web Designer University of Massachusetts, Dartmouth January 2017- May 2017

Efficiently enhanced the University’s official website along with other social sites, thereby increased the revenue by 11%.

Conducted brainstorming meeting to identify enhancement features and documented Business and Technical Requirement artifacts.

Collaborated and facilitated meetings with development team to design wireframes and mockups for website enhancement and ensured understanding of functional requirements using Balsamiq tool.

Created and maintained Use Cases, visual models including activity diagram, logical Business process models and sequences diagrams using MS- Visio.

Assisted Project Manager and Test team Lead in development of planning artifacts as Project Plan document and Test Plan document based on Business Requirements, technical specifications, improvements recommended and/or product knowledge.

Trained university students in designing webpage layouts and developing their own websites using HTML/CSS. Also troubleshooted any issues students encountered while developing the websites. Business Data Analyst Sapas Solution Pvt. Ltd Nov 2012 – March 2015

Successfully Queried extensively in SQL to perform ETL, data validation and generate reports using SQL and R.

Assisted in developing ETL framework for processing and monitoring import of flat files in SSIS for key clients.

Created more than 100 SQL Ad-Hoc reports supporting business decisions by providing insights to improve accuracy and reduce the timeline of decision making.

Facilitated brainstorming meetings with cross-functional teams to identify opportunities for process improvements, recommend system modifications, and develop policies for data governance along with creating deliverables.

Built and published 10 customized interactive reports and dashboards in Tableau for different business lines which would effectively communicate trends, patterns, and predictions using relevant data.

Identified the correct data and variables, gathered and integrated the data from disparate sources using SQL along with designing and maintaining data sets and databases.

Provided data support such as data extraction, data manipulation and quality check to assist ad-hoc analysis.

Acted as liaison to developers, clients and the senior management to resolve issues, assess user needs, provide training and recommend system changes.

Ensured that project requirements gathering, business and technical analysis of requirements, team deployment, and project execution are successfully executed, and the project meets stakeholders’ expectations.

Coordinated the daily progress of application development and testing, holding daily and weekly team meetings to address open issues and scheduling concerns. EDUCATION: University of Massachusetts, Dartmouth: Master’s in Computer Science. Jan 2016- Jan 2018 APURVA WANKHADE

ANALYTICS & DATA SCIENCE

Contact this candidate