NITI SRIVASTAVA

Contact: 312-***-**** Email: adg28j@r.postjobfree.com LinkedIn

(AVAILABLE IMMEDIATELY)

EDUCATION

Master of Science in Management Information Systems – Analytics, Northern Illinois University, Dekalb, IL, USA Jan 2018 - Dec 2019

Bachelor of Engineering, Dayananda Sagar College of Engineering, Bangalore, INDIA Aug 2010 - June 2014

SKILLS

Programming Languages/ Tools

SQL, Adv. MS Excel, Python

Databases

MYSQL, SQL Server, MS Access, Oracle 10g/11g/9i

Reporting Tool

Tableau, Power BI, OBI, SSRS, Splunk, Cognos

Other Tools

C, MS Excel, MS Access, HTML, PHP, UNIX

Skill sets

Regression Analysis, Statistical Data Modelling, Data Acquisition, Predictive Analysis, A/B Testing, Data Mining, Modelling, Segmentation, Reporting,

WORK EXPERIENCE

Business Analyst, Amazon, Seattle, WA Apr 2020 – Present

To provide reports on effectiveness of the launch or fix by performing statistical techniques.

Built reports using Euclid (OBIEE) to visualize raw data to support sellers and vendors business requirements.

Maintained and fine-tuned Euclid reporting (OBIEE) dashboards to improve the performance.

Wrote ETL queries (Datanet) using data net to extract data from source systems to be used for reports.

Performed data analysis to identify root cause of results and explore different areas of opportunity using pre-post techniques.

Used statistical techniques such as linear regression, logistic regression and time series analysis to analyze data and produce insights.

Data Analyst, IIRC – Report Cards, Dekalb, IL May 2018 – Mar 2020

Experience in Data Extraction, Transformation and Loading using Python, SQL, Informatica.

Good experience in Data Modelling to allow web applications to be integrated.

Good experience in providing BI solutions using Tableau, Power BI, SSRS, Excel.

Experience in acquiring data from semi structured, unstructured source systems and integration of various source systems.

Implemented RESTful API using SSIS to acquire data from source system (ETL process) and loaded into Target system.

Used Tableau visuals to report business related issues, analysis and to provide business solutions.

Mined dimensional data from over 300 institutions to give insights into institutional metrics and KPIs.

Worked with web developers to develop meaningful metrics and determine granularity level of data.

Intern, Research Assistant, IIRC – Reports Cards, Dekalb, IL

Developed data model for Illinois Post-Secondary Profile (www.illinoispostsecondaryprofiles.com ) from scratch to allow web applications to be integrated.

Developed stored procedures to retrieve, merge, compile and transform data from source (www.nces.ed.gov ) to destination.

Assisted graduate students with data modelling, designing, development and implementation using SQL, Python.

Led data staging and loading task for www.illinoisreportcard.com with SQL and SSIS.

Completed data transformation from source file using python scripts.

Identified KPIs and metrics, designed OLAP cubes and dashboards.

Data Engineer - Database / ETL / BI Developer, Accenture – Bangalore, India Mar 2015 – Dec 2017

Integrated data from various heterogeneous sources such as Oracle, Sybase, and MS Access with the help of ETL tool Informatica.

Developed OBI and Tableau dashboards to display meaningful results from data warehouse for reporting and business analysis.

Good experience in analyzing and interpreting to identify fraud activities, unexpected payments, and user creations.

Managed performance and tuned SQL queries, and fixed slow running queries in production with utilities like Explain, Indexes, Trace, and Stored Outline.

Used data analysis techniques to enhance business performance which helped in reducing number of requests by user.

Created interactive Splunk dashboard to monitor health of servers and their response time under heavy load which in turn helped in analyzing the performance of hardware.

ACADEMIC PROJECTS & WORKSHOPS

Online Karaoke, SQL Server, HTML, PHP, CSS Northern Illinois University (Jan 2018- Dec 2019)

Developed and managed database using SQL SERVER; developed web-based form using HTML and PHP.

Involved in creating Database objects like

Worldwide Importers, POWER BI, MS Excel Northern Illinois University (Jan 2018- Dec 2019)

Designed Power BI dashboards to analyze sales, customer, tax generated by region.

Visualized and formulated complete DAX queries in POWER BI.

Determined profit generation by using measures and dimension data from Excel data.

Inventory Management - Tableau, SQL Server Northern Illinois University (Jan 2018 – Dec 2019)

Designed, developed Tableau data visualization using Crosstab, Scatter Plots, Density Charts and Whisker charts based on project requirement.

Created rich visualization with Drill down and drop-down menu with various Parameters using Tableau.

Automated Salary System, MYSQL, PHP, HTML, CSS DSCE, Bangalore, INDIA (2010 - 2014)

Web-based system capable of calculating employee’s monthly/hourly salaries, allowances/deductions based on certain parameters.

Contact this candidate