Data Analyst Sales

Summary

Sooraj Holla

**** ***** ***, *********, ** - 94086 - +1-312-***-**** - ***********@*****.*** - Solutions-driven business data analyst with 2 years of combined experience in insurance, healthcare, marketing and IT industries, leading cross-functional teams in the development, documentation and delivery of data-driven business goals. Skills

Requirement Gathering, Data Gathering, Agile Methodologies, Data Analysis, Business Intelligence, Solution Implementation, User, Acceptance Testing, Risk Management, Project Management. Software: MySQL, SQL Server Studio, Java, Python (NumPy, Pandas, Advanced MS Excel, JIRA, Visio, Balsamiq, R, Tableau, Power BI, RapidMiner, MS Office, MS PowerPoint, Amazon Glue, RedShift, Google Data Flow, SSIS, SSRS. Education

Degree: MS Management Information System from University of Illinois at Chicago GPA: 3.52/4.00 May’18 Major: Computer Systems Analyst

Courses: Data Mining, Statistics, Supply Chain Management, Data Visualization, Finance, Marketing, Business Strategy and Policy, Advanced Database Management. Degree: Bachelor of Engineering, Information Technology from University of Mumbai, India. Jun’14 Courses: Database Management, Business Intelligence, Business Communications, Usability Testing. Experience

Business Analyst - CodersData LLC, Chicago Jul’20 - Dec’20

• Determined the optimal strategy to target specific demographics, calculated using statistical analysis on customer data and website traffic data using Python (Pandas, NumPy), MS Excel by uncovering the correlation between key metrics.

• Collaborated with marketing team stakeholders to gather requirements and prioritize goals, and made recommendations for campaign optimization leading to 7% increase in membership for the quarter.

• Used the analyzed customer data to prepare multiple ad-hoc and weekly Business Intelligence dashboard reports using PowerBI, identifying patterns and forwarding them to key stakeholders for further action. Business Analyst - Genivity LLC, Chicago Jan’20 - May’20

• Performed Requirement Gathering through interviews and JADs. Created Wireframes, Tableau dashboards, Test Scripts, Test Cases and User Stories to provide client with an understanding of the health insurance recommendation engine.

• Employed ETL techniques to consolidate a health insurance database of more than 10,000 rows using MySQL. Successfully cleaned, analyzed the same for further tasks in the project.

• Performed Usability Acceptance Testing, Integration Testing, Unit Testing, A/B Testing at client-side for developed application. Created dashboards, ERDs, Data Flow Diagrams, Use Case Diagrams, Process Flow Diagrams and Activity Diagrams to facilitate better understanding of the system and data. Business Data Analyst - CAMS-EXACT, Mumbai Jun’19 - Jul’19

• Ensured alignment between development teams by compiling and providing the necessary business requirement documents, SRS, technical and functional requirements, and collaboratively worked to define scope and milestones.

• Collected and analyzed data on existing and potential vendors, distributors, customers and competitors, and created comparison analysis reports which were presented to senior executives to decide on further action.

• Successfully consolidated company’s historic data and developed KPIs from the dataset to identify and exploit new methods for targeting potential customers.

Data Analyst - Contech Instruments LTD, Mumbai Jun’17 - Jul’18

• Employed historical sales data to focus on sales goals, completion rate and pipeline coverage metrics. Used MS Excel Pivot Tables to analyze and sales data, interpreted and presented the same via Tableau dashboards to senior members of the sales team, which helped forecasting team to decide on future targets.

• Used Excel analytical techniques on sales data to identify regions and products to target for improvement, created dashboards and forwarded the same to the sales department.

• Managed in-season business by analyzing sales data in order to identify opportunities to increase sales and improve margins, resulting in increasing overall sales by 5% for the holiday quarter.

Contact this candidate