SAGAR KAMSAGARA NAGESHAPPA

Phone: 217-***-**** • Email: ac2rgz@r.postjobfree.com

Business Intelligence – Data Warehouse – SQL Developer – Data Analyst

Analytical IT professional capable of improving and streamlining processes, directing cross–functional project teams, and developing business intelligence architecture that supports fact–based decisions and ad hoc analysis. Proven ability to engage effectively with end users to discern needs and strengthen data management and delivery.

CORE COMPETENCIES

Programming: T–SQL, SQL, MDX, PostgreSQL, PL/SQL, HTML5, CSS3.

Databases: Oracle 10g/11g, Microsoft SQL Server 2012, Greenplum, Microsoft Access and Excel.

Operating systems: Windows 98/XP/7/8/10, Mac OS X.

Business Intelligence Tools: SAS E–Miner 13, Tableau, SSIS, SSAS, SSRS.

Tools used: SAP ERP, Axpert ERP, TOAD, SQL Developer, SQL Server Management Studio, PG Admin, Microsoft Word, PowerPoint, Visual Studio, JIRA, SharePoint.

PROFESSIONAL EXPERIENCE

HEALTHGRADES Present

Associate Data Analyst

Perform extensive GAP Analysis, designed and developed reports and visualizations using Tableau for complex analytical data sets to track the Key Performance Indicators (KPIs) for Sales.

Build SQL scripts to create new tables, views, queries, for data analysis and extraction.

Coordinating and tracking projects for seamless releases using Agile methodologies, Project Management System JIRA and Document Management System SharePoint.

ILLINOIS DEPARTMENT OF PUBLIC HEALTH 08/2015 – 12/2016

Business Intelligence (Paid Internship)

Demonstrated expertise in ETL operations by extracting data from heterogeneous sources (websites, Access, flat files), transforming per IQuery (Web based data query system) requirement and loading data.

Developed analytical data sets and dashboards using Tableau, Microsoft Excel to recognize trends in application performance.

Remarkably reduced technical support cost by 20% while improving health information accessibility and training 50+ corporate end-users on application functionality.

Wrote complex SQL queries using inner and outer joins, grouping and nested subqueries.

UNIVERSITY OF ILLINOIS AT SPRINGFIELD, IL 03/2015 – 08/2015

Data Analyst

Maintained confidential data via Banner ERP. Identified trends, compared details and reported on progress toward institutional goals.

Built online surveys, analyzed the response patterns using Tableau, derived insights and areas of improvement and made significant suggestions for courseware development.

UNIVERSITY OF ILLINOIS AT SPRINGFIELD, IL (DATA PRACTICUM)

Healthcare Data Analysis 08/2016 – 12/2016

Gathered, cleaned, and accurately transformed data from Behavioral Risk Factor Surveillance System (BRFSS).

Analyzed the quality of life in the U.S by developing predictive models such as Decision Tree and Regression using SAS Studio and SAS Enterprise Miner.

Provided recommendations, generated reports and visualization using SQL, MS Excel, Tableau, and SAS Enterprise Miner.

Predictive Modeling 01/2016 – 05/2016

Integrated multiple data set in Oracle 11g using SQL Developer and exported to SAS Enterprise Miner.

Analyzed QVC’s sales performance. Established predictors, best data mining methodologies, including MLR, MBR, and Decision Tree.

Provided visualization of findings using SAS E-miner and Tableau through development of interactive dashboards and reports.

SAGAR KAMSAGARA NAGESHAPPA 217–761–5682 PAGE 2

Data Migration; ETL and Web Reports 01/2015 – 05/2015

Utilized expertise with SSIS to extract data from Microsoft SQL Server 2012, clean / transform data, and upload on to Oracle 11g Database.

Utilized Visio to create ER diagram and Project Flow Chart.

Enabled interactive display of web–based ad hoc reports showcasing data migration process through successful website design using HTML, CSS, PHP, and Bootstrap framework.

SUTURES INDIA PVT. LTD., India 02/2014 – 01/2015

Officer IT – Business Intelligence & PL/SQL Developer

Excellent knowledge in Data Analysis, Validation, Cleansing, Verification and identifying data mismatch.

Experience with creating Tables, Views, Constraints, Data flow diagrams, Database normalization, Entity relation modeling and design techniques.

Profound understanding of database skills such as writing advanced SQL queries (group by, having clause, union, inner and outer joins) for extraction and ad-hoc analysis.

Used SQL Server for creating views, reports and generated dashboards to track sales KPIs.

Proficient in Data Warehousing concepts including Data Mining, Data Modeling, Extract, Transform and Load (ETL).

Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Experience with Oracle Supplied Packages such as UTL_SMTP, UTL_TCP, DBMS_SQL, DBMS_JOB, UTL_JOB and UTL_FILE.

Experience in creating and updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Worked extensively on Ref Cursor, External Tables, Bulk Collections and Exception Handling.

Pioneered “Trusmart” concept, a GPS–based reporting system for sales representatives working in collaboration with development team. Saved company $120K by enabling sales personnel to manage hours.

Gathered requirements, built ERP Modules and analyzed the transactional data to accurately forecast the company’s inventory.

I.R. TECHNOLOGY SERVICES Pvt. Ltd., India 09/2013 – 01/2014

Service Engineer, Analytics and Reporting

Designed and developed ETL (SSIS) packages. Created OLAP cubes (SSAS) using snowflake schema for analytical data warehouse and generated reports using SSRS.

Provided recommendations for calculating new KPIs to be used for tracking sales and service performance.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

NIIT, India 07/2012 – 06/2013

Intern

Worked with SSIS to load data files to SQL Server. Performed database development by writing PL/SQL procedures, triggers, scheduler, maintained data, database backups and scheduled backups.

Wrote complex SQL queries (DML, DDL and DCL) to join tables, create reports and temporary tables.

EDUCATION

UNIVERSITY OF ILLINOIS AT SPRINGFIELD

Master of Science, Management Information Systems, 2016

VISVESVARAYA TECHNOLOGICAL UNIVERSITY, BELGAUM, Bangalore, India

Bachelor of Engineering, Electronics and Communication, 2012

Contact this candidate