SUDHANSHU

***** ********* **, *** *, Tampa, FL - 33613

ac0xar@r.postjobfree.com 813-***-**** LinkedIn

OBJECTIVE: To secure a full time position in the field of Data/Business Analyst and utilize Analytics and Business Analysis expertise to help create business value for the establishment.

EDUCATION

Master of Science in Management Information Systems (GPA – 3.78/4.00) Dec 2016

University of South Florida (USF), Muma College of Business, Tampa, FL

Courses: Systems Analysis and Design (SDLC, Agile, Scrum), Data Warehousing, Advanced Database Management

Bachelor of Technology (Information Technology) (GPA – 3.5/4.00) July 2010

Uttar Pradesh Technical University, Lucknow, India

WORK EXPERIENCE

Infosys Ltd, Hyderabad, India (Senior Systems Analyst) Oct 2012 – May 2015

Worked on database as a part of Business Intelligence and was involved in development, design, visualization and analysis of reports using large datasets (using tools like Toad, PL/SQL developer, Crystal Reports, Tableau)

Involved in requirements gathering, making Business Requirement Documents, Technical Specification Documents

Engaged with the functional team and the technical team for requirements analysis and mapping

Developed SQL queries and designed reports layout using Crystal Reports to generate reports as per requirements

Developed data mapping and data flow for business processes into IFS applications for efficient data analysis

Designed interactive and insightful visualizations and dashboards using Tableau to perform data analysis

Created database objects like Tables, Stored Procedures, Functions, Views and Triggers to generate reports

Developed test plans and tests cases, executed test cases, validated the test results and documented them

Performed Tuning and Query Optimization to reduce query runtime and hence improve efficiency

Engaged in problem solving and root cause analysis of issues in the SQL code and provided resolution

Worked on MS Excel using formulas, pivot tables, functions and vlookups to manipulate large datasets

Infosys Ltd, Hyderabad, India (Systems Engineer) Nov 2010 – Oct 2012

Worked to provide application and production level support using SQL server management studio based on SQL Server and IT service management for information management

Created Tables, Views, Stored Procedures and correlated sub queries using SQL,T-SQL in Microsoft SQL Server

Used SSIS to develop ETL packages to extract, transform and load data into target Database/Data Warehouse (BI)

Extracted data from different sources and performed several transformations (Aggregate, Conditional Split, Join, Sort) and error handling to conduct data analysis to gain useful insights in data

Developed and designed Tabular Reports, Drill Down Reports, Ad-hoc reports, Bars and Charts using SQL Server Reporting Services (SSRS) to visualize data and bring meaning to the data and solve complex business problems

ACADEMIC PROJECTS

Cohort Analysis of Customer Sales in SQL Data Analytics

Performed analysis of customer sales data to observe customer trends using SQL and Tableau

Web Scraping using Python (Statistical Data Mining)

Performed statistical analysis and visualization of the data extracted from a website using Python, R and Tableau

SOFTWARE SKILLS

Languages: SQL, PL/SQL, T-SQL, VBA, C, HTML, R programming, Python

DBMS/RDBMS: Microsoft SQL Server, Oracle 11g, SSIS, SSRS, MS Access, Visual Studio

Tools: SQL Server Management Studio, PL/SQL Developer, Toad, Crystal Reports, MS Excel

Tableau, R Studio, Argo UML, MS Visio, MS Word, MS PowerPoint

CERTIFICATIONS

Joint SAS/USF certificate in ‘Analytics and Business Intelligence’

‘SQL : Master class for SQL data analytics’ certificate from Udemy

‘Business Analysis Fundamentals : Become a Business Analyst’ certificate from Udemy

‘Fundamentals of Visualization with Tableau’ certificate from Coursera

‘Visual Analytics with Tableau’ certificate from Coursera

Contact this candidate