Sign in

Data Analyst

Jacksonville, Florida, United States
April 15, 2018

Contact this candidate


Siddhartha Gorthy

Ph. 248-***-**** Email:

Professional Summary:

• Over 3 years of experience in Data Visualization, Data Management, Data Integration using Tableau and Alteryx.

• Over 3 years of experience with Business Analysis, Project Management, System analysis and gathering user requirements.

• Data Driven and highly analytical with working knowledge and statistical model approaches and methodologies like Clustering, Regression analysis, Hypothesis testing, Decision trees, Machine learning.

• Experience with Risk Assessment and Third-Party Management in banking sector.

• Experience in Statistical Software such as Python, SPSS Modeler, SAS

• Experienced with packages such as NumPy, SciPy, pandas, Scikit-learn.

• Extensive experience in all phases of BI development life cycle from business analysis to data warehouse and ETL environment.

• Strong experience in SAS/BASE, SAS/STAT, SAS/MACRO, SAS/ACCESS, SAS/SQL in Windows Environment.

• Experience in Project Management, Change/Incident Management, metrics, complex BI Reports and dashboards

• Experience of query, modifying and manipulating data, deleting duplicates, applying formats and labels with PROC SQL

• Strong understanding of various SDLC methodologies such as Waterfall, Agile and Scrum with hands on experience.

• Proficiency in Excel, Entity Relationship Diagrams, Dimensional Data Models, Data Mapping, Use Case Diagrams, Workflows and GAP analysis.


BI/Statistical Analytical Tools: Tableau, Alteryx, SAS, Power BI, IBM SPSS Modeler, Informatica, Excel Scripting Languages: Python, R,VBA

Databases: MySQL 2008 R2, Oracle 10G, Oracle VM Server, Sybase. SDLC methodologies: Waterfall Methodology, Agile, Scrum. Operating Systems: Windows, Linux (Ubuntu)

Web Technologies: HTML

APIs: Amazon Web Services (AWS), SOAP, REST



University of Michigan-Dearborn, Dearborn, Michigan, Aug 2016 Master of Science in Information Systems

Vellore Institute of Technology (VIT), India, Aug 2014 Master of Business Administration

Vellore Institute of Technology (VIT), India May 2013 Bachelors of Business Administration


Citi Bank Nov 2017- Present

Sr. Business Data Analyst

• Conducted variety of data analyses comprising both structured and unstructured (free text) data types using SPSS Modeler.

• Combined the output of the text analytics (concept and category models) with the available structured fields and explored different predictive models with the objective of taking multiple input fields to predict certain risk measures or applicable controls related to Citi’s supplier relationships.

• Constructed predictive model, Bayesian Network, Regression, K means Algorithm and Neural Net with SPSS Modeler.

• Created Word cloud using R for text mining.

• Gathered Business and functional requirements and designed work flows.

• Liaised between development team and business team

• Actively involved in UAT testing.

• Assessed risk assessment with text mining techniques using Modeler and python.

• Used various Python packages for analysing data, visualization, manipulation and peak corrections.

• Performed various analysis like Jacard Index, Confusion Matrix, Neural nets using python libraries NumPy, SciPy and Scikit.

• Performed QC testing before going into live.

• Measured similarity and calculated Precision and recall using Fuzzy lookup and powerups in excel.

• Developed multiple tableau dashboards that enhance delivery of analytical results and daily reporting.

• Documented work flows in Visio.

Environment: SPSS Modeler, Python Tableau, Excel, Fuzzy lookup, PowerUps, SQL, MS Access, MS Visio. Johnson & Johnson, FL Aug 2017 – October 2017

Data Architect/ Data Analyst II

• Monthly Score Card Global and Regional by Product YTD & MTD (NTS$, MAPE, BIAS, GP, Inventory) Phase 1 Automated and Phase 2 integrated in Tableau.

• Tableau Visualization of Demand Handover to include NPI, kits and pipe for automated flat file creation.

• Support Weekly Forecast attainment report transition into Tableau.

• Developed and automated SAS programs to validate the import data from raw files that meets all the data standards.

• Support Weekly Forecast attainment report transition into Tableau.

• Used SAS for data manipulation and generated weekly and monthly reports employing various SAS Procedures.

• Created /Validated of forecast value add metric.

• Performed logistic regression with PROC LOGISTIC and out the regression equation to find out the potential customers.

• Supported Tableau visualization of metrics and dashboard for planning excellence.

• Integrated data from different sources and Data mapping using Alteryx and Tableau.

• Provided day-to-day support to business users developing BI applications

• Ad-hoc Requests: Additional support as needed.

Environment: SAS, Tableau, Alteryx, Excel, MS Access, SAP, JDA


Covisint, MI May 2016 – Nov 2016

Business Analyst Intern (DevOps)

• Developed reports that provide clear visualizations of industry-specific KPIs and metrics using parameters and Level- of-Detail (LOD) expressions.

• Worked in Agile/Scrum which mainly dealt with Incident Management to provide support to the customers.

• Developed documentation of service map diagrams to illustrate end user applications and supporting sub-components of the architecture.

• Supported high priority incidents for Automotive and DBA Operations team.

• Correlation analysis was performed between service time availability and downtime

• Developed SQL scripts which identified messages and null status, gather information about the status messaging after software release.

• Supported Operations team in developing and documenting processes by creating weekly and monthly burn down charts using MS Excel and Tableau.

• Tasks associated with data center migration project to include:

• Validation of application processes and activity on virtual machines

• Tracking and validation of virtual machines through the decommissioning process o Updates to status reporting as needed.

• Tasks associated to database RAC migration project to include:

• Reporting on database OVM and OVS utilization.

• Migration to AWS environment.

Environment: IoT, AWS, DevOps, Oracle VM Server, LINUX, BASH, SQL, Tableau, Excel, HTML, Agile, Scrum, Nagios, Apigee, EDIFACT.

GSN Technologies, India Aug 2012 – Jul 2014

BI Data Analyst II

• Designed, developed, tested, and maintained Tableau functional reports and dashboards based on requirements gathered from the client.

• Involved in creation of metrics, attributes, filters, reports, and dashboards using Tableau.

• Built and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters and Level-of-Detail (LOD) expressions

• Designed and tested the data models in SPSS Modeler.

• Performed data standardization on raw data for cleansing.

• Applied linear regression, logistic regression, and robust regression to research data using SPPS modeler.

• Achieved best model in terms of error and hypothesis testing for data analysis.

• Assisted other data analysts and constructed ARIMA model, McNemar test, Fisher’s exact test and chi square test analysis

• Visualized and summarized the final results in SPSS modeler before going live.

• Identified, addressed and removed missing data.

• Created advanced chart types, visualizations and complex calculations to manipulate the data.

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

• Used excel sheet, flat files, CSV files to generate Tableau ad-hoc reports.

• Provided day-to-day support to business users developing BI applications

• Assisted in creating of Business Requirement Document (BRD) and Functional Requirement Document (FRD).

• Provided technical support on the application problem, diagnostic, troubleshooting and rectification to the reported problems.

• Understand data maps and relationships of respective client programs and BPM Techniques, UI Requirements.

• Prepared technical documentation includes Flow charts, Use Case diagrams, user guides, scorecards, data mapping and GAP analysis.

• Worked closely with client to ensure data requirements identified in the business analysis are accurately captured.

• Assisted in final review design documents.

• Actively involved in UAT testing and product support.

• Liaised between developing team and clients.

Coca Cola Beverages, India May 2012 – Jul 2012

Operations Intern

• Worked with the RTM (Route to Market) Department and gained knowledge on various activities involved with distribution of pallets to distributors and retailers

• Identified problems in the process and assisted in Turn Around Time (TAT) calculations

• Processed planned and unplanned shipments.

Academic Projects:

Project on Data visualization (Tableau) Spring 2016 Objective: To create different dashboards showing earthquake analysis and finally consolidated into single dashboard.

• Analyzed large data sets and creation of dashboard using parameters in calculations and filters.

• Performed various data analysis on more than 8000 observations.

• Implemented trend analysis to create forecasting of occurrences of earthquakes. Project on Data Modelling Spring 2016

Objective: To identify best model fit to uncover the insights causing the brain drain in Michigan.

• Cleansed and Clustered data set into four groups, used various data mining (machine learning) techniques like regression analysis, hypothesis testing, clustering and came up with a best model fit to uncover the insights causing the brain drain in Michigan using Logistic Regression and Correlation Analysis with SAS, Excel and Minitab Project on Predictive modelling Spring 2016

Objective: To create a predictive model to identify the commercial soybean varieties and optimized the experimental process by eliminating the type 1 errors (underperforming varieties).

• Predicted commercial seed varieties for class of 2014. Forecasted the sales of commercial varieties using trends in historic data by correlating the success of variety to the number of bags bought by farmers using Neural Nets, Logistic Regression and ARIMA Model with Excel, Minitab, Tableau and SAS. For data manipulation SQL, Alteryx are used. Database Design (MS Access) Fall 2015

Objective: To create a database for Indian Graduate Student association at University of Michigan using MS Access.

• Identified current problems and gathered requirements for creating the database.

• Conducted a survey to form a questionnaire.

• Created Entity relationship diagram and formed normalized set of data to create relationships.

• Created queries for retrieval of desired information out of database. SAP modules for GBI Company Spring 2016

Objective: To perform various SAP modules SD, MM, PP, FI, CO, HCM, WM, PS of SAP software to create purchase orders using bill of material data for GBI Company.

• Worked on real-time data provided by University instructor for implementation of SAP modules.

• Gained hands on experience with SAP by working on various modules.

• Generated data sets for business transaction while execution. Security Analytics in Big Data Fall 2015

Objective: To identify, analyze and predict a trend in the field of networking.

• Worked individually at changing security analytics by providing new tools and opportunities for leveraging large quantities of structured and unstructured data and evolution, technical and managerial implications and near future of big data security analytics.

Project on Restaurant Modelling Fall 2015

Objective: To improve the processing and service utilization of Indian based restaurant kitchen.

• Responsible for data collection for restaurant modelling using Simio simulation software

• Identified key factors for the existing systems which are causing problems.

• Created a process in the model to match the order quantity and order number of the processed items with customer receipt to accommodate the entire flow process

Contact this candidate