Chandni Dhandia

actizu@r.postjobfree.com +1-979-***-**** 1909 Edgebrook Circle, Apt 207, Sanford, FL - 32771 https://www.linkedin.com/in/chandnidhandia

EDUCATION

MASTEROF SCIE CE

MANAGEMENT INFO. SYSTEMS

TEXAS A & M UNIVERSITY

December 2014 College Station

Cum. GPA: 4.00

BAC ELOROF E GI EERI G

INFORMATION TECHNOLOGY

UNIVERSITY OF PUNE

May 2009 Pune, India

First Class with Distinction

SKILLS

LANGUAGES & TECHNOLOGIES

Advanced

SQL

Microsoft SSRS

Microsoft SSIS

Microsoft Excel

Microsoft Visio

Informatica PowerCenter

Intermediate

Microsoft SSAS

Tableau

Beginner

R

QlikView

Crystal Reports

OPERATING SYSTEMS

Windows

Unix

CERTIFICATIONS

ORACLE

Oracle Database g : SQL Developer

AWARDS

DELOITTE CONSULTING LLP

Applause Award - OutstandingWork

INFOSYS LIMITED

TeamPlayer Award

EXPERTISE

Databases

Data Analysis

DataWarehousing

Business Reporting

SUMMARY

Business Intelligence professional with years of experience; specializing in Data Warehousing, ETL, and Business Reporting.

WORK EXPERIENCE

SOLUTION ENGINEER DELOITTE CONSULTING LLP

January 2015 - Present Lake Mary, FL

Designing and developing business reports inMicrosoft SSRS for the State of Connecticut’s Integrated Eligibility application.

Creating SQL scripts to populate business reports fromDB database. Optimizing the SQL queries to reduce rendering time for SSRS reports, and thereby improving performance.

Individually designed and developed ETL components for performing error checks, preparing data for the Deloitte’s IT financial services quality dashboard. Coached new recruits on Informatica, ETL and data warehousing concepts. Member of the Center of Excellence team, responsible for developing reusable components across projects.

SOLUTIONS ENGINEERING INTERN NATIONWIDE INSURANCE May 2014 - August 2014 Columbus, Ohio

Designed and developed a employee database to assist managers in performing workforce planning.

Created SharePoint site to improve navigation between team sites under infrastructure engineering department.

Optimized process of work request submission by the business teams to the solutions engineering team, reducing effort by %.

SENIOR SYSTEMS ENGINEER INFOSYS LIMITED

August 2009 - June 2013 Pune, India

Optimized the batch processing time by %, by removing the duplicate and obsolete Insurance data.

Diagnosed system failures and provided solutions to fix issues with the client’s back-end systems.

Earned client appreciation for migration of disability insurance policies to external insurance agent system.

PROJECTS

HEALTHCARE DATA ANALYTICS

October 2014 XL Miner, Microsoft SSAS

Performed statistical analysis of health care data using XLMiner. Examined the performance of Classification algorithms (Logistic Regression, K Nearest Neighbors, andNaive Bayes classification) usingMicrosoft’s SSAS. BI REPORTING FOR RETAIL STORE

April 2014 Microsoft SSIS, Microsoft SQL Server

Designed and developed datamarts for GB of operational data using star dimensional modeling.

Developed ETLmappings usingMicrosoft SSIS to transformoperational data into analytic data.

JOB PORTAL DATABASE APPLICATION

December 2013 Oracle 11g

Developed a candidate recommendation system for employers by quantifying an applicants educational/professional skills for the job’s requirements.

Contact this candidate