Ankit D

ANKIT K- - linkedin.com/in/ankit-k-dataanalyst https://www.guru.com/freelancers/ankitsoftware-engineer----7-years- Summary Experienced Business Technology Analyst with a demonstrated history of working in the Information Technology Consulting industry. Skilled in Data Quality Assurance, Informatica, SQL ,Reporting & BI. Good experience in Tableau ,SQL Server & Power BI . Currently learning Python , Machine Learning & Big Data Experience Senior Tableau Developer Courier Company Jan 2018 - Jun 2018 6 months 1. Analysed causes , routes causing delay and inefficient delivery patterns for a Courier Company 3. Helped company to identify major issues in delivery strategies make decisions to improve delivery speed by 14 % 4. Revenue and Expense Dashboard helped company to cut the useless cost by 14 % Senior Visualiazation Expert Health Insurance Company Jul 2017 - Dec 2017 6 months Implemented Complex feature used to analyze the health spending and DRG (DISEASE RELATED GROUPS) pattern for people spread across various states 1. Identified the useless health spending pattern by various States 2. Identified the major DRG groups , age groups responsible for high health spending 3. Provided deep insights on the demographics of patients 4. Helped Insurance company to identify right set of individuals for their various policy plans and improve YOY by 7% and reduce cost by 11 % Senior POWER BI Developer Specimen Delivery Analysis Jan 2017 - May 2017 5 months Company was facing issues to identify reasons of delay of their food specimen 1. BI Dashboard helped them understand the key reasons and issues reasons of delay 2. Identified low performing delivery resources 3. Identified high ROI routes to operate in 4. Identified inefficient courier partners and faulty fleet of vehicles POWER BI Expert AUSTRALIAN APPLIANCES RETAIL CHAIN. May 2016 - Dec 2016 PowerBi Retail and Accounting dashboard 1. Helped client to analyze the expenses and income and analyze the consumer buying pattern 2. Provided deep insights on Consumer preferences , promotions and offers and unwanted expenditure 8 months 3. Generated insights on sale trends and stock that led to cost saving and effective inventory management Power Bi Developer FIT BIT DATA ANALYSIS Nov 2015 - Apr 2016 6 months Developed dashboard for FITNESS DEVICE monitoring company . It helped company to create customized dashboards for their customers which is being monitored 1. Sold as product and has gained $50,000+ of revenue from 1000+ customers and rising exponentially 2. Revenue grew exponentially by 7 % YOY Skills Data Analysis • Microsoft Power BI • Tableau • Data Visualization • Database Development • T-SQL • Powershell • MS SQL SERVER • Database Modeling Certifications MCSA : BI Reporting • edX Aug 2017 - Present Tableau Desktop • Tableau Software Nov 2014 - Present Honors & Awards Resource of The Year • US Courier Company • Jul 2018 Got recognized by company as the top resource working to identify causes of delay during deliveries TechViz Dashboard Contest • Jun 2017