Process-oriented Data Analyst with more than 5 years of experience in interpreting and analysing data for driving business solutions as well as organizational growth. Ability to present complex data and analytics to non-analytical audience using journalistic and analytical approach.
Databases: MySQL, SQL Server, Teradata, Oracle
Statistics: Hypothesis Testing, Time-Series Analysis, A/B Testing
Data Science Tools: R, Python (NumPy, Pandas, Seaborn, Scikit-learn, SciPy)
Data Visualization: Tableau, Power BI, Qlik Sense
Other Skills: ETL, Reporting & Analysis, Stakeholder Management, Client/Customer Relationship Management, Requirement Gathering & Analysis
Medtron Solutions Inc (Cedar Park, TX) Jul 2020 - Present
Generated advanced Tableau dashboards that allowed us to track and improve customer units KPI by 12% within a month
Worked closely with DevOps and management team to design Tableau dashboard and other BI Reports/visualizations; attended feedback sessions to improve systems.
Drafted prompts, calculated fields, customized calculations, conditions, and filter (local & group) for reports & dashboards.
Automated reports and data ingestion process for 5 main Business reports using SQL, Excel VBA, and Python tools.
Developed and modified interactive dashboards and created guided navigation links within the dashboards.
Built tools to store data effectively within the organization and maintained data analytics platform for data mining.
Developed Tableau workbooks from multiple data sources using Data Blending
Supported the development and medication of Tableau views in Tableau Desktop, while preparing documentation and training for users from respective units.
CVS Health (Woonsocket, RI) Sep 2019 – Jun 2020
Recommended analytic solutions for Extracare Card program, that enable a comprehensive understanding of customer behaviour within or across market segments.
Produced customized customer-centric reporting by pulling data from Teradata database. Assessed the request for information and developed the reporting to provide the data.
By means of complex SQL queries, performed ETL on large datasets, apply data hygiene, reconciled matched tables, performing data auditing and validation.
Using Python & SQL, developed code for sourcing data from multiple sources and then organizing and transforming large, multi-terabyte, data sets.
Unearthed the raw data by doing the Explanatory Data Analysis.
Perform exploratory data analysis and statistical modelling in support of ongoing lines of research and fulfil ad hoc requests from other functional teams.
As a part of Customer Research & Marketing Analytics team, evaluated business needs, derived actionable insights from customer POS & E-commerce data to help business teams take informed decisions.
Worked collaboratively with multiple internal teams like Sales & Operations, Retail and Marketing, to identify critical business requirements for reporting, and conducted regular ad-hoc data analysis.
Analysed program performance trends to identify opportunities for operational or measurement enhancements.
MRM-McCann (New Delhi, India) Apr 2015 – Jul 2016
Recommended improvements to client on the ongoing program by deriving insights from customer data; helped expand their member-base and increase engagement.
Collaborated with internal Creative and Operations team to fulfil project requirements at client end, in a synchronized manner and a dedicated common timeline.
Extracted data from one or more source files and Databases and interacted with Marketing and Finance teams for obtaining the data and data quality.
Accomplished multiple tasks from collecting data to organizing data and interpreting statistical information.
Created different joins, sub-queries and nested query in SQL query to pull data from program database.
Analysed key performance metrics to prepare and present reports to client, using data visualizations.
Analysed all campaign data captured into one place, like E-commerce, POS, digital marketing; and drilled down into details to understand performance.
Newgen Software Technologies Ltd. (New Delhi, India) Jun 2013 – Apr 2015
Business Data Analyst
Fetched new opportunities for Business team by churning data from prospective companies’ databases.
Developed and deployed quality SQL codes, stored procedures, views, functions, triggers and jobs.
Accessed SQL databases to fetch data, create procedures, and create ad-hoc reports.
Worked in close association with USA Sales team to analyse market trends and develop overall strategy to reach out prospective executives.
Conducted market analysis using Advanced Excel and prepared regular reports, which gave insights to senior management in their Sales strategy. ______________________________ACADEMIC PROJECTS_____________________________
Predicting the next best store location for L.L. Bean (MySQL, R, Tableau) Dec 2018
Employed Predictive Modelling techniques and validation approaches to find the next best location to open another retail store in the U.S.; Made recommendations to company using Tableau dashboard
Created source to target mappings and ETL design for integration of modified data streams into the data warehouse.
Built and maintained SQL scripts, indexes, and complex queries for demographic data analysis and extraction.
Analysis of Student Performance for Watertown Public Schools(MySQL, Python, Tableau) Jan 2019
Developed granular Tableau dashboard which summarizes the student data for Watertown public school and compares it with other similar districts.
Evaluated data file submissions and developed/maintained SSIS packages for ETL processes.
Conducted correlation analysis & data regression in Python to identify factors influencing student performance. Real-time Audit Status for Vertex Pharmaceuticals (MySQL, Tableau) Jun 2018
Designed a real-time Tableau visualization where the overall status of supplier audits across the US, can be tracked and monitored by their Quality Assurance team.
Created data packages and modelling data integration flows with SSIS from various data sources.
By spotting likely audit delays in advance, the department was able to avoid high risks and enhance performance.
Northeastern University Boston, MA
Master of Professional Studies (Analytics) Apr 2019
Relevant courses: Data warehousing & SQL, Data Mining Applications, Decision Support & Business Intelligence
Panjab University Chandigarh, India
Master’s in Business Administration (Marketing) May 2013
Bachelor of Engineering (Information Technology) May 2012
Relevant Courses: Database Management Systems, Data Mining & Warehousing, Research Methodology