Data Project

AKSHAY SHASHIKANT KADAM

Email: ***************@*****.***/313-***-****/LinkedIn: http://www. linkedin.com/in/akshaykadam1106

Experience Summary:

Highly motivated professional with 4+ years of experience in data visualization, data analytics, BI development, data modelling, data integration, Lean Six Sigma and continuous process improvement.

Proficient in Predictive Modelling, Statistical Analysis and Data Mining

Executed ad hoc Analysis in various domains such as Health care, Sales, Manufacturing, preventive maintenance, Inventory management, mechanical integrity and risk assessment studies.

Committed to maintaining cutting edge technical skills and up-to date industry knowledge.

Expert in eliciting, analysing and documenting requirements for business process and information systems.

TECHNICAL SKILLS:

BI Tools Microsoft Visual Studio 2017 (SSIS, SSRS, SSAS), Microsoft SSMS 2017, Access, Excel Power Query, Power Pivot

Databases Oracle 10g, SQL Server

Visualization Tools Microsoft Power BI, Tableau, QlikView, Excel Power view, Power Map.

Data Analysis Tools MS Excel data analysis, Minitab, SPSS, SAS, Alteryx.

IOT Applications ThingWorx

Languages T-SQL, MDX, R, Python.

Software’s Microsoft Office (Visio, SharePoint, Project), Lucid chart, AutoCAD, ANSYS.

Six Sigma Tools DFMEA, PDCA, DMAIC, PMC, Value Stream Mapping, Root Cause Analysis, 5S, Pareto Charts, Histograms, Cause-and-Effect matrix, PPAP.

Domain Knowledge Enterprise Architecture, Project Management, Manufacturing and Industrial operations.

Soft Skills Client interaction, Capturing business requirements, Team leadership and management.

Methodologies Waterfall, Agile (Scrum)

Project Management Microsoft (MS) Project, Smartsheet

Platform Microsoft Windows, Mac OSX

EDUCATIONAL QUALIFICATIONS:

Master of Science in Industrial Engineering (Wayne State University, Detroit) Aug 2016 - May 2018

Concentration: Operations and Big Data Analytics CGPA: 3.93

Relevant Coursework: Applied Statistics, Operation Research, Deterministic Optimization, Six Sigma (Green Belt), Supply Chain Management and Analytics, Lean Operations, Project Management, Production systems, Database Management, Data Science Strategy and Leadership and Business Analytics

Bachelor of Engineering (University of Mumbai, India) Aug 2010 – Jul 2014

Concentration: Mechanical Engineering CGPA: 3.7

CERTIFICATIONS:

MCSA: BI Reporting Microsoft

MCSA: SQL 2016 BI Development Microsoft

Lean Six Sigma: Green Belt WSU

Thingworx IOT Fundamentals and Development PTC

PROFESSIONAL EXPERIENCE:

United States Steel Corporation, Michigan May 2018- Till Date

Data Analytics Developer

Monitored metrics, researched existing processes, set goals, and measured results of experiments which derived optimal solutions for USS Inventory management system.

Developed Python aggregation and predictive analysis scripts.

Responsible for migrating analytical data from disparate sources.

Gathered business requirements and led cross-functional teams to implement advanced analytics to schedule and sequence Coil flow processes to avoid material flow congestion.

Responsible for creating visualizations and demonstrating past processes breakdowns using 5Ys techniques.

Minimized reporting delay by almost 90% by Designing Tableau and Power BI dashboards for day-to-day sales analysis

Environment: Tableau, Python, SQL, Microsoft SQL Server 2017, Access, Oracle SQL Developer, SSMS, R, PTC Thingworx, Minitab, Microsoft Power BI.

MASCO Corporation, Michigan May 2017- April 2018

Business Intelligence Developer (Home Depot Support Services)

Implemented BI solution for cross-retailer sales reporting and analysis.

Involved in full project life cycle planning which comprised of data interviewing sessions with source system owners, investigating raw POS data, designing intricate data models and managing data flow.

Executed SSIS for data scrubbing, validation and integrating processed data into repository marts.

Saved 70% resource time by automating business reporting using measures, calculated columns and scheduling jobs.

Designed interactive dashboards and custom reports using data visualization tools like Power BI.

Helped stakeholders forecast sales and analyse trend using analytics tools like Minitab, Excel and SAS.

Business Units - Liberty Hardware Manufacturing, Brass craft Manufacturing, Delta Faucet Company.

Retailers - Home Depot, Lowe’s.

Environment: Microsoft SQL Server 2017, SSMS 17, SSIS, SSAS, SSRS, Power BI, Excel Power Query, Alteryx, R, DAX, Scrum (Agile), Smartsheet, MS Visio.

Precision Group, Mumbai, India Oct 2015 – Jul 2016

Data Visualization Engineer

Created Tableau, Qlik view and Excel Dashboards with interactive views, trends and drill downs along with user level security.

Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.

Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.

Precision Group, Mumbai, India Jul 2014 – Sep 2015

Process Development Engineer (Quality and Industrial Operations)

Educed and designed roadmap using Quality management tools

Showcased extensive data analysis using statistics and MS Excel based analytics validation products.

Demonstrated ken while translating Business requirements into technical specification.

Conducted risk analysis and process improvement plans through impact assessment sessions to ensure successful project delivery.

Documented business needs through multiple cross-functional client interactions.

Performed comprehensive vendor analysis, change management assessment, data collection plan and incorporated industry’s best practices to Generate new business by developing POA (Plan of Action).

Environment: Microsoft Excel Power Query, View, Maps, MS Access, Oracle, SSMS, SSIS, SSAS, Tableau, MS Project, Agile, Minitab, Visio, MS Office suite, NDT, Lean Six Sigma

ACADEMIC EXPERIENCE:

BI Analytics for MRP Inventory management system Gammon Skills: Data Modelling

Centralized the database system by designing ER model, relational model, triggers, stored procedures and SQL queries.

Sliced and diced OLAP cubes to identify expense centres and develop insightful dashboards.

Provided cost saving insights into resource utilization, by formulating LPP and ILP analysis giving a deep cost cut of around $20,000 per order.

Conducted successful presentation walkthrough with the business owners.

Analysis and Visualization of Donors choose Data project Lions club Skills: ETL, data visualization

Performed pre-processing on millions of rows of data using multiple datasets to analyse various aspects of donations

Developed dashboards and reports using Tableau to understand the social impact of donations to various projects

AFT and EFT click-to-ship time analysis Amazon Skills: Data analytics

Formulated predictive model to reduce ‘click to ship’ time by 2.3 hours.

Increased existing data infrastructure performance and devised a comprehensive model for analysis study.

Introduced PERT to reduce redundancy in material pick time by 0.33 hours

Charted dashboards to evaluate variations during peak and no-peak conditions at EFP and AFT Facilities.

Financial risk analysis and Data management Precision Group Skills: Financial Accounting, Data Management

Framed financial layout model by implementing data collection plan and realigning with existing ERP system.

Developed Finance management plan and mapped rise in performance efficiency by 43% within six months duration.

AWARDS & HONORS:

Awarded ‘Retention Scholarship’ at Wayne State University, USA. Jan 2018

Felicitated as ‘Zenith Star 2015’ at Precision Group, India for all-round performance. Dec 2015

Contact this candidate