Data Analyst/ Business Analyst
Pushpak Eksambekar
Phone: ------------ | Email: ------------ | Address: 4474 N Oakland Ave, Wisconsin, 53211 | ------------/in/pushpak-eksambekar
Data Analyst | Business Analyst | SQL | Integration and Reporting Services | BI | Tableau and Power BI | Agile | Data Scientist | Statistical Analytics | ETL
PROFESSIONAL SUMMARY
• Data Analyst with 1+ years of experience interpreting analysing data in order to drive successful business solutions. Proficient knowledge in statistics, mathematics and analytics. Excellent understanding of business operations and analytics tools for effective analyses of data and reporting. Leading ad-hoc analysis projects and custom reports to identify business growth or process improvement opportunities and present execution plans to help resolve the gaps and achieve business KPI targets.
SKILLS AND CERTIFICATIONS
• Data Analytics A/B testing, Structured & Unstructured Data Analysis in R Regression (Linear, Logistic,
Random Forest, Ridge, Lasso, GLM),
• Languages & Tools SQL, MS Access, Python, R, SharePoint, Excel, Power BI, Tableau, VBA, SAP HANA, SPSS,
MS Project, Lean, Agile, Scrum, Linux, Hadoop, Visual Studio Code, MS SQL Server
• Core Competencies SSIS Integration Services, SSRS Reporting Services, Data Cleaning, ETL Techniques (Gathering,
Cleaning, Transformation), Data Warehousing & Analytics, Data Modeling, Documentation,
SAP HANA, BW Modelling, Data Mining, Data Scraping, Statistical Techniques.
• Certifications 1. Tableau 2. PostgreSQL 3. SQL Integration Services 4. Database Administration
EDUCATION
• University of Wisconsin-Milwaukee (M.S. Information Technology Management) Graduated, Dec 2020
GPA- 3.8
Relevant courses- Business Intelligence and Solutions, Data Science, Data and Information Management, Service Oriented Analysis, Information Technology Strategy and Management, Seminar in Data Science.
• Datta Meghe College of Engineering (B.E Electronics) June 2012- July 2016
WORK HISTORY
Tutor for Tableau and R at University of Wisconsin Milwaukee Sept 2020-Current
• Successfully implemented 40 dashboards, bar graphs, geographical graphs, scattered plots, bubble plots in Tableau to help understand over 150 students to create meaningful Data Visualization.
• Created Tableau Scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Identify, analyse, and interpret trends or patterns in data, analysing user behaviour and build reports to help track the metrics
• Successfully designed and build Business Intelligence reports that meet user requirements.
• Advanced experience in implementing predictive models and help understanding R software and its applications in Predictive analytics using Regression, Probability, Multiple Regression, Data Science, significance of P-value.
•
Program Support Assistant- UWM School of Continuing Education Aug 2019- Aug 2020
• Developed and implemented programs and interpreted the program’s policies and procedures.
• Performed an array of technical, training, research, planning, policy, program assessment, and administrative activities.
• Contributed to the effectiveness of the team by using appropriate communication, problem-solving, conflict management strategies and completing required paperwork.
• Updating and maintaining the UWM SCE website regularly and taking backup using Oracle DBA.
• Work with Sales and Operations team leaders to identify opportunities for improvement.
Data Analyst Intern at AIR INDIA LTD. June 2015- July 2015
• Prepared and cleaned 1.6 Billion data records retrieved from SQL Server and produced Visualizations using Tableau and Power BI.
• Performed Market analysis to efficiently achieve objectives, increasing sales by 25%.
• Tracked the site traffic, cleaned data and extracted monthly traffic reports from Google analytics to evaluate page performance of 4000+ products and to simplify the process of website redesign project.
• Conduct extensive Data modelling and data transformation using Data Warehousing and ETL techniques.
Pushpak Eksambekar
Phone: ------------ | Email: ------------ | Address: 4474 N Oakland Ave, Wisconsin, 53211 | ------------/in/pushpak-eksambekar
Data Analyst | Business Analyst | SQL | Integration and Reporting Services | BI | Tableau and Power BI | Agile | Data Scientist | Statistical Analytics | ETL
PROFESSIONAL SUMMARY
• Data Analyst with 1+ years of experience interpreting analysing data in order to drive successful business solutions. Proficient knowledge in statistics, mathematics and analytics. Excellent understanding of business operations and analytics tools for effective analyses of data and reporting. Leading ad-hoc analysis projects and custom reports to identify business growth or process improvement opportunities and present execution plans to help resolve the gaps and achieve business KPI targets.
SKILLS AND CERTIFICATIONS
• Data Analytics A/B testing, Structured & Unstructured Data Analysis in R Regression (Linear, Logistic,
Random Forest, Ridge, Lasso, GLM),
• Languages & Tools SQL, MS Access, Python, R, SharePoint, Excel, Power BI, Tableau, VBA, SAP HANA, SPSS,
MS Project, Lean, Agile, Scrum, Linux, Hadoop, Visual Studio Code, MS SQL Server
• Core Competencies SSIS Integration Services, SSRS Reporting Services, Data Cleaning, ETL Techniques (Gathering,
Cleaning, Transformation), Data Warehousing & Analytics, Data Modeling, Documentation,
SAP HANA, BW Modelling, Data Mining, Data Scraping, Statistical Techniques.
• Certifications 1. Tableau 2. PostgreSQL 3. SQL Integration Services 4. Database Administration
EDUCATION
• University of Wisconsin-Milwaukee (M.S. Information Technology Management) Graduated, Dec 2020
GPA- 3.8
Relevant courses- Business Intelligence and Solutions, Data Science, Data and Information Management, Service Oriented Analysis, Information Technology Strategy and Management, Seminar in Data Science.
• Datta Meghe College of Engineering (B.E Electronics) June 2012- July 2016
WORK HISTORY
Tutor for Tableau and R at University of Wisconsin Milwaukee Sept 2020-Current
• Successfully implemented 40 dashboards, bar graphs, geographical graphs, scattered plots, bubble plots in Tableau to help understand over 150 students to create meaningful Data Visualization.
• Created Tableau Scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Identify, analyse, and interpret trends or patterns in data, analysing user behaviour and build reports to help track the metrics
• Successfully designed and build Business Intelligence reports that meet user requirements.
• Advanced experience in implementing predictive models and help understanding R software and its applications in Predictive analytics using Regression, Probability, Multiple Regression, Data Science, significance of P-value.
•
Program Support Assistant- UWM School of Continuing Education Aug 2019- Aug 2020
• Developed and implemented programs and interpreted the program’s policies and procedures.
• Performed an array of technical, training, research, planning, policy, program assessment, and administrative activities.
• Contributed to the effectiveness of the team by using appropriate communication, problem-solving, conflict management strategies and completing required paperwork.
• Updating and maintaining the UWM SCE website regularly and taking backup using Oracle DBA.
• Work with Sales and Operations team leaders to identify opportunities for improvement.
Data Analyst Intern at AIR INDIA LTD. June 2015- July 2015
• Prepared and cleaned 1.6 Billion data records retrieved from SQL Server and produced Visualizations using Tableau and Power BI.
• Performed Market analysis to efficiently achieve objectives, increasing sales by 25%.
• Tracked the site traffic, cleaned data and extracted monthly traffic reports from Google analytics to evaluate page performance of 4000+ products and to simplify the process of website redesign project.
• Conduct extensive Data modelling and data transformation using Data Warehousing and ETL techniques.