Sign in

Data Analyst Executive

Maryland Heights, MO
May 17, 2020

Contact this candidate


SHWETA KULKARNI +1-475-***-****!/vizhome/Resume_237/Dashboard1?publish=yes


Analyst with experience in deriving meaningful insights from large complex datasets. Well versed in data mining, visualization and reporting tools.


Pace University, Seidenberg School of Computer Science and Information System New York City, NY

Master of Science in Information Systems Jan 2016-May 2017

University of Pune Pune, India

Bachelor of Engineering in Information Technology Aug 2010-June 2014


Languages: Java, Python (Pandas, NumPy), R tools (R Shiny, ggplot)

Web Technologies: XML, JavaScript, PHP, Google Analytics (Web Analytics Service)

Tools/ Software: Tableau, Qlik Sense, RapidMiner, ArcGIS, Visio, Microsoft Excel, VBA, Macros

MSBI Stack (SSIS, SSAS, SSRS), SPSS, Working knowledge of Hadoop

Version Control: GIT, SourceTree

Database: SQL, PL/SQL, MySQL Server 5.7, MS Access


Royal Canin, St. Charles, MO, USA

Digital Business Analyst May 2019-Present

• Analyze current processes and reports to determine future needs for the business

• Determine business reporting needs and data requirements through meetings, consultations and document analysis

• Create reporting mock ups and high-level conceptual data mapping

• Articulate user stories for developing and integrating components involved in building a D2C platform for pet food with an existing B2B portal

• Translate business needs/wants into new functionality on applications

• Actively manage the reporting and analytical roadmap and other reporting applications

• Evaluate the information gathered and distinguish between individual wants and business needs prioritizing accordingly

• Prioritize stories for developers using the Agile methodology

• Analyze and prioritize future phases of applications for value proposition and enhancement

• Communicate with Senior Management on long term goals and analyze what can be done to provide them what they need from a data and application standpoint

ISquare Info, NJ, USA Mar 2018-Apr 2019

Data Analyst

•Responsible for gathering high level requirements from business and marketing team, developed analytics design and implementation documents.

•Worked on end-to-end adobe analytics solution design, development, support, testing and data analysis.

•Developed Traffic Reports (Site, Visitor, Segmentation), Path Reports (Page reports, Entries and exits) and Conversion reports (Purchases, Custom events, Campaigns reports etc.) using Report Builder

•Designed and implemented data layer in Dynamic Tag Manager to simplify and manage tags sending data to in structure way to Web Analytics, Double Click, Test & Target tools.

•Generated Metrics on Bounce Rate, Visit Duration, Click Through Rate (CTR), Average Organic Page Ranking and demonstrated to executive team on opportunities for improvement

•Built executive dashboards for the leadership team with the conversion KPI's & also involved in building/ scheduling of dashboards for the middle-management to provide them a snapshot of the business.

•Performed A/B testing and page optimization based on target segments using Adobe Test & Target; increasing conversion rates and maximizing user experience

Designed and developed ETL process for integration of data from various sources (scheduled daily).

Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.

Designed SSIS packages to transfer data from various sources like Oracle, text files, XML Files, SQL Server, Excel and Access to SQL Server.

Shutterstock, NY, USA Oct 2017-Feb 2018

Data Analyst/Data Steward

•Calculated metrics and analysis as well as condensed multiple points of interest and large amounts of data into concise targeted information summaries and reports for management

•Leveraged clients existing IT framework/CRM system for better data visibility and system integration.

•Conducted QA of new CRM software, reported bugs and verified features and functionality

•Managed data quality in SFDC be validating sources of truth.

•Filtered and cleaned salesforce data by reviewing workday requirements to locate and correct discrepancies.

●Involved in defining the source to target data mappings, business rules and data definitions.

●Responsible for defining the key identifiers for each mapping/interface.

•Reviewed data issue reports, and escalated data issues to appropriate internal partners.

•Performed checks on datasets to ensure planned consistency in sensitive data.

•Assisted in data migration for importing legacy data into Salesforce.

•Developed tests, reports, and procedures around data quality improvements.

•Assisted with automation of manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.


Predicting traffic collisions using R programming

•Derived exploratory and predictive results on NYPD collision data sets after cleaning it and predicted the neighborhoods, timings, kind of vehicles that are prone to collisions in New York City through predictive modeling.


Machine Learning using WEKA

•Acquired ten weeks of cafeteria sales data and converted it to ARFF format; implemented K-Means, Zero-R, Prune Model to detect patterns in the quantitative data and then studied the fluctuations in sales by the different days of week and changing daily temperature.


Presidential Election Poll analysis and mapping

•Mapped a range of maps using ArcMap 10.4 showing the distribution of votes cast to the two major political parties in the U.S.

•Used range of features of ArcMap 10.4 like color-coding maps, selection by attribute and buffer feature and explored spatial data analysis

Predictive analysis for Citi Bikes biking data

•Determined age group riding specific time frame of a day using R programming.

•Concluded that the group that uses the bikes the most are 30-39-year-old males between to 11 a.m

•Predicted the quantitative results of all the factors on the revenue of citibikes by d statistical analysis ata in R


Contact this candidate