SUMMARY

• Seasoned data analytics professional with 7+ years of broad industry experience in data analysis, data mining, statistical modelling and reporting in various industries, such as Healthcare, Manufacturing, Real Estate, and Insurance
• Extremely passionate about data analytics and data visualization with rich experience in turning large data sets into valuable and actionable business insights using Power BI, Tableau, R and Python
• Experience in identifying critical information in process automation, supply chain analytics, building vendor relationships, manufacturing losses reduction, marketing analytics, and building claims forecasting models
• Highly proficient in statistical data analysis, data mining, machine learning, text mining, data pre - processing and feature engineering, data visualization, problem solving and data-driven decision making
• Experience in diverse set of procedures but not limited to methods such as machine learning, deep learning, Bayesian algorithm, Regressions, cluster analysis, decision trees, time series, resampling and regularization, NLP, and other techniques
• Strong working experience with various python libraries such as NumPy, SciPy for mathematical calculations, Pandas for data preprocessing/wrangling, Matplotlib, Seaborn for data visualization, Sklearn for machine learning, TensorFlow, Keras for Deep leaning and NLTK for NLP
• Experience with common Machine Learning Algorithms like Regression, Classification and Ensemble models
• Expertise in applying data mining techniques and optimization techniques and proficient in Machine Learning, Data/Text Mining, Statistical Analysis and Predictive Modeling
• Expertise in creating dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data
• Proficient in design and development of various dashboards, reports utilizing advanced Tableau Visualizations like Pareto chart, Funnel chart, Tree maps, Scatter plots, geographic visualization and making use of actions, local and global filters according to the end user requirement
• Used different self-service exploratory data analytics tools such as Tableau, QlikView and MS Power BI for data preparation and visual analytics
• Extensive experience in Tableau Desktop in creating highly interactive Data visualization Reports and dashboards using Data Blending, Extracts, Calculation Fields, LOD, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures, Page Trails etc.
• Experience in developing multiple dashboards/reports using various charts like Stacked Bar/Pie, Line/Area, Donut, Dual-axes charts, Geo-Maps, Bubble, Scatter and Heat Maps
• Expertise in SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints
• Expert in ETL tools like Import/Export wizard and SSIS for transferring Data from different sources to a centralized SQL server
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data
• Coordinated technical reviews, developed system requirements, test requirements, test plans, scripts, test conditions and test data. Supported status reporting and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT)
• Experience working with cross functional teams by supporting programs, projects, portfolio applications & tools, business processes to drive business unit vison towards digital roadmap
• Strong leadership skills: able to prioritize, delegate tasks, and make decisions quickly while maintaining a focus on the bottom line
• Organized, goal-oriented, self-starter, and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision
• Competent, confident, and strategic decision maker organized with effective Time Management and Prioritizing skills in conflicting demands to execute business objectives

TECHNICAL SKILLS

Methodologies: AGILE/SCRUM, WATERFALL

BI Tools: Tableau, Power BI

Programming languages: Python, R

MS Office: Excel (pivot tables, v-lookups), Access, PowerPoint, Visio

Database: SQL Queries (SQL Server, MySQL, Db2)

ETL Tool: Informatica

Task Management Tools: Jira

Others: User Stories, Business Requirements, Functional Requirements, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams

PROFESSIONAL EXPERIENCE

Confidential

Supply Chain Data Analyst

Responsibilities:

• Partnered with Materials Management Information Systems (MMIS) team to build an email classification model using python. Part of the complete project from model development, testing, and validation that solved the major email overload problem for the customer service team by 90%
• Developed interactive dashboards using Tableau for the Supply Chain reporting & analytics team to monitor operational KPI’s
• Collaborated with value analysis teams to identify, track, and validate over $25M in cost savings initiatives
• Built reports to monitor data quality of Business units as a part of the Data Foundations initiative and accordingly worked with the ETL development team to fill the gaps
• Collaborated with MMIS team to help automate several business processes and execute process transformation using data mapping techniques
• Introduced a standardized template for all the vendors related to tracings reports that improved the efficiency by 80%
• Managed vendor relationships to ensure Contract Administration Fee (CAF) is collected from vendors and is accurate
• Provided numerous Ad Hoc reports and analysis as requested by the senior leadership team to support strategic initiatives and help executives drive data driven decisions by understanding business goals
• Worked with cross-functional Users from different Units and understood business challenges in terms of providing reporting solutions across the global organization
• Documented, tracked, and monitored progress on key project milestones

Confidential

Business Analyst/ Business Intelligence Analyst

Responsibilities:

• Streamlined sales processes by designing KPI reports that resulted in increased transparency and overall efficiency by 15%
• Extracted the workers’ compensation claims data from Microsoft Dynamics CRM, created the data sets and analyzed data based on the demographic information, industry
• Implemented and analyzed daily, weekly, monthly, and quarterly reports that enabled data driven business decisions
• Identified defects in Microsoft Dynamics CRM database, performed detailed root cause analysis and determined corrective action plans for closure
• Created complex and reusable Macros and extensively used existing macros and developed procedures for Data Cleaning, Validation, Analysis and Report generation
• Collaborated with other analysts and department management to meet or exceed the company's reporting and analytical needs
• Improved client satisfaction by automating reports in SQL that reduced report generation time by 70%
• Created dashboards using Power BI to track employee’s performance that improved employee efficiency by 26%