Data Analyst / Tableau Developer

PRIYANKA CHHIKARA

Email: ************@*****.*** Phone: 682-***-**** LinkedIn: https://www.linkedin.com/in/priyanka-chhikara EDUCATION:

• Master’s in Management Information Systems, University of Texas at Arlington Jan 2017 - May 2018

• Bachelor’s in Information Technology, India Aug 2008 - May 2012 SKILLS:

• Business Intelligence Tools: Tableau, Salesforce, ServiceNow, Google Analytics, Weka

• Programming Languages: SQL (MySQL, Microsoft SQL Server Management Studio), Python, Java, R

• MS Office: Excel (Vlookup, Pivot), Flow, Project, Access, Word, Outlook, Visio

• Business Applications: JIRA, Confluence, SharePoint, Bitbucket, Blueprint, Version 1

• Process Management: Software Development Life Cycle (SDLC), Agile (Scrum, Kanban), Waterfall

• Certification: Advanced MS Excel, SQL for Data & Business Analytics, Tableau, Google Analytics EXPERIENCE:

Equifax Business Data Analyst Nov 2019 – Present

• Develop SQL scripts & procedures to migrate data & configuration setup from legacy servers to IBM Sterling File Gateway (SFG) while maintaining the referential integrity and optimizing query performance.

• Create, maintain & publish story telling Tableau dashboards to analyze financial, operating & billing processes.

• Identify & interpret trends or patterns in credit reporting dataset to find anomalies & provide data-driven key insights.

• Analyze statistical business KPIs by creating Tableau dashboards with drill down capabilities using filters, parameters, actions, trend lines and forecast feature.

• Automate monthly excel reports into Tableau Workbooks and Dashboards using various advanced table calculations.

• Collaborate with internal & external business partners & stakeholders to gather requirements and write user stories.

• Work with business users and corporate quality teams to develop test plans and procedures for QA testing.

• Document key processes, gap analysis and architecture of new solutions on Confluence. DealerSocket Data Analyst/Tableau Developer July 2018 – Oct 2019

• Extracted data from multiple sources & managed end-to-end complex data migration using SQL scripts & procedures.

• Preprocessed, cleaned the data, and monitored data quality to work with right set of data.

• Collaborated with Business Clients, Product Owners & Data Scientists to gather data visualization & analytical needs.

• Designed Tableau reports and interactive dashboards using data blending, joins, parameters, context filters, calculated fields, table calculations, actions, LOD functions and containers.

• Created statistical and drilled down sales & performance KPIs in Tableau for internal and external customers. Also forecasted the future trends.

• Analyzed the customer conversion rate and sale data to measure campaign effectiveness.

• Restrict data for particular users using Row level security and User filter.

• Refreshed the data source (.hyper file) periodically to update latest data on Tableau server.

• Create custom and ad-hoc SQL queries to validate results and as per requirements from senior executives. University of Texas at Arlington Graduate Research Assistant June 2017 – May 2018

• Increased sale by 12% by analyzing the data for daily sales transaction and performing gap analysis on it.

• Prepared segmentation & interactive reports and dashboard using Excel & Tableau to monitor all sources of revenue.

• Created reports in Tableau using joins, parameters, filters, calculated fields and table calculations.

• Identified and interpreted trends or patterns in the dataset to increase business profit.

• Extracted students’ records using SQL and visualized the data using Tableau.

• Improved class enrolment by 17% by developing an extension model using Machine Learning Algorithms & Python. Tata Consultancy Services Business Data Analyst India Sept 2015 – Dec 2016

• Extracted, transformed & loaded data to and from different environments/sources using SSIS packages.

• Improved efficiency of banking transactions by 9% using advanced and custom SQL queries.

• Created ER diagrams & RDBMS schemas/tables in SQL while maintaining the referential integrity.

• Analyzed credit card usage data using MS Excel & Tableau to identify patterns in it.

• Developed ad hoc reports and customized interactive dashboards using performance analytics in ServiceNow for senior leadership.

• Accelerated team performance by 23% by identifying bottlenecks and doing gap analysis on the existing processes. Tata Consultancy Services Business Analyst India July 2014 – Aug 2015

• Simplified and digitized Citi’s global consumer banking system as part of Customer Management Systems (CMS) team.

• Served as a liaison between business clients and technical teams during project SDLC phases using Agile approach.

• Facilitated walkthroughs (JAD/JRP/interviews) with end users & stakeholders covering 100% business requirements.

• Analyzed and documented the business requirements into detailed user stories, use cases and activity diagrams.

• Documented test cases and supported business during system integration & user acceptance testing.

• Analyzed business requirement documents to determine functional change requirements including process analysis for deficiencies and inefficiencies.

• Worked closely with end clients and stakeholders to fix business understanding, SQL & Java related production defects.

• Deployed the defect fixes to SIT, UAT & Production environment and created reports & dashboards using ServiceNow.

Contact this candidate