Data Analyst Resume Boston, MA - Hire IT People

SUMMARY:

WORK EXPERIENCE:

Data Analyst

Confidential, Boston, MA

Responsibilities:

Collaborated with developer team to build a user-friendly search tool using Kibana & Elasticsearch for policy master data that reduced report generation time from weeks to minutes
Built a prototype application for UnitedHealth Care National Issues Tracking to improve the tracking user experience
Gathered and Documented requirement s from Client Directors for BI reporting on managing national customer accounts
Created Tableau Dashboards to enable Client Management Team in managing client issues more effectively
Lead Intern developer team as the Scrum Master while following Agile Methodologies

Data Analyst/Supply Chain Co-Op

Confidential, Piscataway, NJ

Responsibilities:

Supported the Health-Care Customer Logistics team by monitoring product trends and generating reports on periodic KPIs
Partnered with analysts and senior Confidential planners to support Pharmaceutical, Medical Device and LifeScan businesses
Responsible for monitoring shipment of cold-chain pharmaceutical products to protect against weather related delays and damages
Utilize ValueTrak, Tableau, and JD Edwards databases to support cross-sector cross-functional business functions
Provided information to stakeholders such as product availability, sales data, product launch insights, and other ad-hoc requests
Trained users on various reporting tools and dashboards in Excel and Tableau
Implemented automated system to cleanse imported ValueTrak data using Alteryx resulting in an efficiency gain of 45%
Earned Lean Yellow Belt in Process Excellence (Six Sigma)
Queried SAP BW to extract downstream sales data for various litigation purposes and ad-hoc requests
Cleansed and prepped sales and inventory data using Alteryx, created SLA dashboards in Tableau, thus automating base business reports, cutting down weekly reporting time by 70%, and allowing for more robust analysis of customer ordering trends

IT Business Intelligence Intern

Confidential, Camp Hill PA

Responsibilities:

Lead a committee involving various company executives of different divisions across North America, Australia and Europe
Researched means to identify and consolidate MicroStrategy dashboards that were valuable to the merchants, allocators and planners
Created reports using the Microstrategy BI tool to analyze the usage of reports and dashboards at Confidential
Gathered and Documented reporting requirements and Identified similar but slightly variant ad hoc reports built by end users. Came up with strategy to consolidate them into OLAP cubes to enhance the BI environment and improve the overall performance of BI system

Data Quality Improvement Intern

Confidential, Harrisburg, PA

Responsibilities:

Created dashboards and scorecards using Excel (VLOOKUP, macros) and Access to rate various ACAs and Hospitals
Obtained data from multiple internal and external sources as appropriate for benchmark use.
Developed SAS programs to extract claim data from Data Warehouse(Netezza)
Applied statistical analyses methods to discover the trend of providers' performance
Collaborated with manager on complex data analysis and interpretation
Lead a group to implement a DBMS solution for a small business, reducing downtime by 70% and improving productivity
Collaborated with a group to simulate a business model in the mikes bikes software with the aim of maximizing shareholder value