BHARGAVI KESHANAGARI

Email: ac4ly7@r.postjobfree.com 1055 Spiros Court, Unit 10 Mobile: 815-***-**** Dekalb, Illinois 60115

Professional Summary:

Around 3 years of experience in Data Analysis and Business Intelligence i.e. Data Extraction, Cleaning, Analyzing and Interactive Visualization using SAS, SQL, ACL, R programming, Excel, Tableau, PowerBI, SAP Business Objects Analysis; Data Warehousing and ETL processing using SSIS, Multidimensional & Tabular solutions using SSAS, data reporting using SSRS.

System Experience:

Programming/Development: C, HTML, ASP.Net

Management: Financial Accounting Principles, Six Sigma methodology, SDLC methodology

Data Analysis & Reporting/Visualization: SAS, R programming, Python, ACL, SQL, Excel, Tableau, Power BI (Desktop), SAP BI-Business Objects Analysis: Crystal Reports, SAP BW (Business Warehouse), and Google Analytics

SQL Data Tools (BI): SQL Server, T-SQL, SSIS, SSAS, SSRS

Database/Utilities: SQL Server, Access, MySQL, Oracle

Operating Systems: Windows 97, XP, 7, 8, 10

Other Applications: MS-Office including project (Strong Excel Skills: Pivots, V-Look Up’s, Dashboards, Power Pivot)

Interests:

Through independent studies, academic courses & work experience, I gained understanding of SQL concepts which includes:

Data base designing and Data Warehouse concepts (OLTP vs OLAP): ERD Modeling, Normalization, De-Normalization,

Dimension modeling (Star Schema and Snow Flake Schema).

Writing SQL queries and stored procedures, query performance tuning, T-SQL Programming.

ETL Processing using SSIS (Control Flow: tasks, containers, precedence constraints and Data Flow: Transformation and incremental loading).

Multidimensional - Cube and tabular solutions (DAX, MDX, Time Intelligence functions) in SSAS, reporting using SSRS.

Professional Experience:

Northern Illinois University Graduate Studies, Teaching Assistant August 2016 – December 2017

Assisted Chair Person of OMIS department, Dr. Chang Liu in the course work of Business Intelligence Applications and Tools and helped students in learning the BI Tools.

Generated database design, data warehouse modeling and created processes through SQL Server and Data Tools (SSIS,SSAS,SSRS) to develop a data warehouse for academic lab.

Loaded data from flat files into SQL server through ETL process using SSIS & data warehousing using SAP BW. Implemented dimension/fact tables and analyzed the data using SQL server.

Built cubes, tabular solutions and data mining models, using SSAS and built reports using SSRS

Lead independent projects in data manupulation, analysis, mining and visualization using SAS, R, Python, Excel, Power BI Desktop (DAX, Time intelligence functions), Tableau. Also, used BI tools to create KPI’s in order to analyze metrics of sales data.

Deloitte. Advisory Analyst July 2015 – July 2016

Experience as an Advisory Risk Analytic professional assisting audit team/clients in identification of data quality related issues by reconciling, reporting financial data and finding potential fraud in client financial statement as per Statement on Auditing Standards (SAS) No. 99, consideration of Fraud in a Financial Statement Audit guidelines using SAS programming.

Technology-driven, Data Analytic professional focused in the areas of financial analytics, data extraction, cleansing, analysis, reporting, visualization, quality, validation, profiling with deep exposure in data and statistical analytics using SAS, SQL, R, Excel and ACL.

ETL processing using SSIS to load data into SQL server and then analyzing/modifying the data by writing queries and stored procedures in SQL Server and SSAS

Created dashboards to analyze variations in financial data using Excel, Power BI (Desktop) and Tableau.

Experience in Journal entry analytics to identify anomalies in support of the financial reporting, close process and the associated risk of management override (including data reconciliations).

Promoted as Associate Solution Adviser in just one year of joining the firm as a campus hire.

Deloitte. Business Technology Analyst December 2014 – May 2015

Internship at Deloitte in Financial Statement & Internal Control Audit and Financial Data Analysis (Data Reconciliation).

Responsible in stream-lining the process of audit support analytics using methodologies to improve operational efficiency by analyzing and reporting results of financial data using SAS, SQL, R, Tableau, ACL, Excel, and Power BI.

Applied data analysis techniques for increasing efficiency, enhancing productivity, and improving the accuracy of the data the company relies upon for key decision making and reporting.

Industries served:

Consumer and Industrial Products (USA-Canada).

Banking, Financial Services Industry.

Certifications:

EMC Academic Associate, Data Science and Big Data Analytics.

SAP Certified Associate – Business Foundation & Integration with SAP ERP 6.07.

Rewards and Recognition:

Dr. Denise Schoenbachler Leadership Award from OMIS department, NIU.

Applause award for the Year end 2015-2016 at Deloitte.

Spot award for the Year end 2015-2016 at Deloitte.

Busy Season award for the interim 2015-2016 at Deloitte.

Education:

Northern Illinois University, DeKalb, IL, USA August 2016– December 2017 GPA: 3.8/4

Masters in Management Information Systems

JNTU, Hyderabad, India August 2011 – May 2015 GPA: 3.7/4

Bachelors of Technology

Academic Projects:

Digi World (SQL Server Management Studio, SQL querying):

Designed, developed, and maintained database for an Indian electronic retail store.

Business Intelligence tools and applications (SSAS, SSRS):

Built multidimensional cubes with star schema and snow flake using SQL Server Analysis Services(SSAS).

Analyzed cubes using pivot tables by performing slicing and dicing functions on the data.

Developed SQL queries to extract, manipulate data and reporting requirements including identifying the

tables and columns from which data is extracted.

Big Data Analytics: Predictive Analysis of getting a loan

Developed a data model that can predict the loan probability of a customer given the personal details. The approach to the given project is as below:

Applied algorithms decision tree, regression analysis to observe the gain of all the variables and understand important fields (Data Analysis using SAS & R)

Generated two loan predictor models in R (Predictive Analysis using SAS enterprise miner & R)

Cake Walk (C#, SQL & Google Analytics):

Designed a user friendly online cake delivery website using ASP.Net framework and also integrated the site with google analytics to check the traffic to the site.

Management Information Systems Technology:

Identified a problem in a business process and came up a solution with opportunities and alternatives.

Identified project’s MOV and created risk management plan which includes risk analysis, fish bone analysis, SWOT analysis

and quality management plan which includes metrics to monitor quality and verification of activities.

Contact this candidate