OBJ E CT I V E

To advance my career with a leading organization that will utilize my extensive data analysis and data visualization knowledge while also allowing me to develop further as a professional PROFESSIONAL EXPERIENCE

2901 Indiana Blvd, #377

Dallas, TX 75226

m: 469-***-****

adbfq7@r.postjobfree.com

Proven talent for aligning business strategy and objectives with established information technology paradigms to achieve maximum operational impacts with minimum resource expenditures. Efficiency-focused thought leader with expertise spanning data analysis, predictive analytics, SQL development, cross-functional team leadership, complex problem-solving, client relationship management, and project management. Exceptionally dedicated professional with keen interpersonal, communication, and organizational skills. AMAZON.COM, Dallas,Texas May 2019 – Present

Business Analyst

Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed to track and improve the customer supports KPIs.

Created parameterized reports and adhoc reports using SQL and MS Excel.

Built and maintained SQL scripts and complex queries for data analysis and extraction for various projects.

Provided executives with analytics and decision-support tools used as the basis for reorganization, consolidation and relocation strategies.

AMAZON, NORTH AMERICAN FULFILLMENT, THORNTON, CO, July 2018 – May 2019 Data and Reporting Analyst

Created SQL queries, Excel VBA macros and Tableau Visualizations to setup daily reporting dashboards to enable leadership to track important metrics.

Engineered a messenger bot that scrapes data from an internal website and sends it on the internal messenger which improved a metric by 75% is currently being used in 6 Amazon facilities in North America.

Built hourly metric tracking software using Ruby and Amazon RDS to enable the leadership to track important metrics during the peak season.

Developed ad-hoc reports using Amazon Redshift, Excel VBA and Tableau to facilitate daily operations.

OMNICURE HOME HEALTH, PLANO, TX, June 2017 – August 2017 DATA ANALYST INTERN

Analyzed healthcare and financial data using SAS Enterprise Miner to make important decisions about long-term investments; optimized profits by 12%.

Designed database schema, stored procedures, reports, and data input interfaces using SQL.

Managed the claim submission and claim tracking processes for all patients with Omnicure Home Health using the healthcare data management tool HEAT 4.0; decreased claim denial rate by 95%.

Generated business reports using Tableau and QlikView to help management develop management strategies for the company among hospitals and potential clients.

Engineered ad hoc analysis of business situations, systems, issues, and problems to facilitate daily operations.

AVIK KOHLI

EDUCATION AND CREDENTIALS

ACADEMIC PROJECTS

TECHNICAL SKILLS

ADDITIONAL INFORMATION

CERTIFCATIONS

ACCENTURE, PUNE, INDIA, July 2014 – May 2016

SOFTWARE ENGINEERING ANALYST – DATA QUALITY ANALYST

Performed data quality analysis on a Big Data based analytics project hosted on AWS cloud to optimize data collection procedures by 80%.

Designed important dashboards in Tableau and QlikView for data reporting.

Built and maintained SQL scripts and complex SQL queries for data extraction and analysis to ensure data integrity between the Hadoop data and the application database.

Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.

Analyzed the data outputs and then generated reports on a weekly and monthly basis. MASTER OF SCIENCE (M.SC.) IN INFORMATION TECHNOLOGY AND MANAGEMENT, 2018 University of Texas at Dallas

Dean’s Excellence Scholarship; GPA: 3.501

BACHELOR OF TECHNOLOGY (B.TECH) IN COMPUTER SCIENCE, 2014 Narsee Monjee University – Mukesh Patel School of Technology Management and Engineering

SAS-UTD Graduate Certificate in Data Mining and Business Intelligence (December 2017)

• Amazon vs. Barnes and Noble (August 2017 – December 2017) Analyzed the consumer purchase dataset using Poisson Regression and NBD Regression to analyze how consumer demographics affect purchasing patterns.

• Credit Card Reader (August 2017 – December 2017) Designed a credit card reader machine in JAVA to verify the validity of the credit card number and display the credit card.

• Access Control Management, Data Management (August 2016 – December 2016) Designed and created an Access Control Management Database in MS Access and executed complex SQL queries on the database to test its functionality. Analysis Tools: SAS Enterprise Miner, Tableau, Advanced MS Excel, RapidMiner, OpenRefine, MS Sharepoint, MS Office Suite

Databases: MS Access, MySQL, Amazon Redshift, Amazon RDS, Amazon S3 Languages: SQL, Ruby, VBA, Java, HTML, Command Line Interface Key Strengths: Data Analysis, Development in Ruby, Regression Analysis, Hypothesis Testing, Predictive Analytics, Data Preprocessing, Data Modeling, Ensemble Analytics Methods, Customer Analytics, Sentiment Analysis, HDFS

Operating Systems: MAC OS, Windows OS, Linux

Languages: English, Hindi

Hobbies: Squash, Weight lifting, Amateur movie critic

Contact this candidate