Uploaded File
Shivam
garg.shiv01@gmail.com
813-203-9932
Tampa, FL 33601
Business Systems Analyst / Data Analyst
11 years experience W2
0
Recommendations
Average rating
124
Profile views
Summary

  • Competent and Intellectual experienced professional with more than 5 years of IT experience and Masters Degree in MIS.
  • Seeking career growth opportunity in BI Analytics domain by utilizing my technical skills.
  • Deft at mapping the requirements and designing custom solutions, processed ad-hoc reports per client’s request
  • Implemented project plans within the deadlines, defined best practices for project support and documentation
  • Performed data loading and reporting through various analytical tools.
  • Analyzed data trends and created stories based on the data analysis through various Business Intelligence tools.
  • Have in depth understanding of ETL processes along with relational databases.
  • Conducted data visualization, monitored data and analyzed the KPI performances in Marketing Analytics
  • Joint SAS/USF Certificate in Analytics and BI with extensive hands on experience in data mining & statistical techniques

Analytics Tools: SAS E M, Weka, Tableau 9.3/8.3/7.0, R-Studio, Google Analytics, Ethority (Equifax Analytics), GRETL, SSIS

Databases: Oracle 11g, SQL Server 2008, SSIS(ETL)/SSRS (Reporting)

Programming: Core Java, SQL

Testing: HP QC, SOAP UI, Functional & Regression Testing , Test plan & cases Creation, RTM, Jmeter, JUNIT, UAT

Others: MS Office (extensively worked on Excel Macros, Pivot Tables), Workfront (Workforce Analytics), SQL Server Management Studio , SQL developer, Toad, MS Visio, Tortoise SVN, Argo UML , Agile & SDLC concepts, Scrum Methodology

Platform: Windows, Unix

Experience
Data Analyst/Business Analyst
Information Technology
Aug 2015 - Mar 2016
  • Efficiently configure the ACAMP ETL engine Ethority to transform data into a shape that is acceptable for IRS processing.
  • Primary responsibilities include Data extraction and Data analysis for the application Affordable care Act (ACA) Product.
  • Extracting data from multiple operational sources, transforming, cleansing, and filtering the data, and finally loading the data from the staging holding tables into one or more target clusters of databases.
  • Process individual client configurations in web based application to track employee hours and pay records so as to determine benefits eligibility, and alert client to potential compliance risks and penalties under the ACA Loading master and reference data, and transaction data into normalized tables in SSMS.
  • Monitoring batch processes through Scheduler and running queries as expected from the business.
  • Lead telemetry data capture & feedback project, identify KPIs, write SQL queries, built 4+ Tableau dashboards
  • Processing T-SQL scripts and loading data from staging to final holding tables into various database clusters.
  • Conducted final SME reviews for the complete configurations before sending it to production support.
  • Performed data cleansing for the bad files sent by client to prevent the delay in activation and smoothen the process.
  • Design and develop the logical regression cases to find out the bugs which can bypass the ACAMP process.
  • Documentation of all the Business logic and conducting code reviews for ensuring maintenance is easy for the Peers.
  • Peer review the configurations set up for different clients of Equifax by the Data Architects.
  • Involved in Data mapping, Column mapping and maintain data dictionaries and Data models.
  • Partner with other architects to identify 12+ KPIs and to create incident, change management dashboards.
  • Advanced creation of complex SQL queries, and stored procedures in order to validate data imports & diagnose issues.
  • Document configuration and custom modifications for client reference.
  • Lead Data Discovery discussions with the Project Managers to effectively communicate the requirements for data gathering.
Business Analysis Analysis Data Analysis Tableau ETL SQL Agile Methodology Waterfall SDLC System Analysis Compliance Data Cleansing Data Mapping Stored Procedure T-SQL Data Dictionary Production Support
Remove Skill
Systems Analyst Intern
Information Technology
Jun 2015 - Jul 2015
  • Involved in data analysis based on the ad hoc reports to identify the key performing indexes which can affect the system. Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Bubble Charts, funnel charts.
  • Reviewed SQL queries and edited inner, left and right joins in Tableau Desktop by connecting dynamic and static datasets
  • Extracting data from different sources and created dashboard using parameters, sets and calculations in Tableau Desktop
Analysis Data Analysis Tableau SQL Tableau Desktop System Analysis
Remove Skill
Practice Center Intern
Education
Jan 2015 - May 2015
  • Analyzing web traffic and customer data by performing data mining and web-analytics and predicting the behavior of customer with the help of Google Analytics, Heat Map and other tools Performed User, A/B and Multivariate testing to test different scenarios using statistical methodology for product launch.
  • Translate product data into insightful and actionable recommendations for business & market strategy analysis.
  • Helped in devising successful marketing strategy by analyzing effecting ROI and cost benefit analysis.
  • Explored complex datasets, analyzed buying behavior and created pivot analytics blueprint along with traceable metrics.
  • Conducted Pre and Post analysis of hypothesis to evaluate and optimize the acquisition process, development and retention
  • Created customer segmentation dashboards in Tableau 8.3 to create business stories depicting strength & weaknesses.
  • Developed metrics, filters, reports and also created advanced chart types and complex calculations to manipulate the data.
  • Used several objects-Vertical, Horizontal, Blank, Floating, Text, Image for creating efficient dashboard using tableau desktop.
Analysis Tableau Tableau Desktop Data Mining
Remove Skill
Data Analyst
Jan 2015 - May 2015
Performed analysis on eBay auction data using different sampling methods like stratified and systematic sampling. Compared different sampling methods for different sample sizes for price changes in auctions across various locations in US. Computed 95% confidence interval for price for varying sample sizes like 10, 100 and 1000.
Analysis Data Analysis
Remove Skill
Data Analyst
Jan 2015 - May 2015
Worked on Nielsen data to build a designated market area for the United States. Used Tableau 8.1 as a visualization tool to identify which program is rank first in each designated market area. Identifying and comparing effect of sandy on east cost versus west coast which are demographically equal with different modeling techniques like classification, linear regression modeling. Identifying important variables by AIC methods and analyzing them with ANOVA table.
Data Analysis Tableau Linear Regression
Remove Skill
Data Analyst
Information Technology
Sep 2014 - Nov 2014
Conducted predictive and statistical analysis using neural networks, naïve Bayes and decision trees in SAS and Weka. Various attributes were considered in designing the model, prime factors were Age, Income and Education behind adopting internet plans. Data Mining & predictive analysis is done on the data, provided by telecom companies.
Analysis Data Analysis SAS Weka Data Mining Statistical Analysis
Remove Skill
Database Analyst
Information Technology
Sep 2014 - Nov 2014
Enhancement done in existing movie database by indexing and tuning with usability and performance as the prime focus. Indexing and query performance tuning techniques were used for data optimization. Extended logical and physical design and created master data to support the database.
Data Analysis Performance Tuning Database Design
Remove Skill
Senior Systems Engineer
Information Technology
Jan 2010 - Jun 2014
  • British Telecom Responsible for VPN provisioning for the customer and network maintenance by performing data cleansing.
  • POC for data collection, data analysis, ensuring the correct persistence of network configuration data in the database.
  • Executed 50+ SQL queries, conducted ad hoc analysis to identify gaps, built 4 dashboards to visualize 10+ metrics.
  • Involved in Analysis and testing of all AT&T Customer Notification Management Systems - Operational Data Store (ODS).
  • Presented data charts with the help of Tableau 7 and coded variables from original data, conducted statistical analysis.
  • Involved in OLAP, Extraction and Loading of data directly from different source systems like flat files through SSIS.
  • Leveraged Tableau to establish a framework for analytics reporting annual man-hour cost reduced by $25K+.
  • Writing T-SQL scripts to manipulate data for data loads and extracts and query optimization using EXPLAIN PLAN
  • Ensured all types of defects are identified, captured and resolved using CQ and HP QC on a regular basis.
  • Facilitated change management across entire process from project conceptualization to testing through delivery.
Analysis Statistical Analysis Systems Engineering Business Analysis SQL T-SQL Tableau HP QC Data Analysis Agile Methodology SDLC Waterfall System Analysis VPN
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Management Information Systems
MUMA College of Business University of South Florida 2015
Information Technology
Data Mining 2009
Information Systems
Uttar Pradesh Technical University
Projects in
Uttar Pradesh Technical University
Skills
Agile Methodology
2016
5
Analysis
2016
5
Business Analysis
2016
5
Data Analysis
2016
5
SDLC
2016
5
SQL
2016
5
System Analysis
2016
5
T-SQL
2016
5
Tableau
2016
5
Waterfall
2016
5
HP QC
2014
4
Statistical Analysis
2014
4
Systems Engineering
2014
4
VPN
2014
4
Compliance
2016
1
Data Cleansing
2016
1
Data Dictionary
2016
1
Data Mapping
2016
1
Production Support
2016
1
Stored Procedure
2016
1
Analytics
2016
1
Big Data
2014
1
BSA
0
1
Business Intelligence
0
1
Business Requirements
2015
1
Data Architecture
2016
1
Data Mining
2015
1
Data Visualization
0
1
Database Design
2014
1
ETL
2016
1
Java
0
1
jQuery
2013
1
Linear Regression
2015
1
Microsoft Excel
0
1
MySQL
0
1
Oracle
0
1
Performance Tuning
2014
1
Project Management
0
1
Quality Assurance
2013
1
SAS
2014
1
Scrum
0
1
SOAP
0
1
SQL Developer
0
1
SQL Server
0
1
SSIS
2013
1
SSRS
0
1
SVN
0
1
Tableau Desktop
2015
1
TOAD
0
1
UML
0
1
UNIX
0
1
Weka
2014
1
Windows
0
1
Awards
Received 'Infosys Bravo' 'MVP' & 'Star Performer' awards for out, 0