senior MS BI developer

Rikin Gandhi

**** **** **, ******* ****, IL ***** Phone 630-***-**** E Mail: ******@*****.***

SUMMARY

■ Over 13+ years of Data warehouse, ETL and application development experience in IT industry

■ Strong understanding of computer technology (Windows, SQL, Data warehouse concepts, SSIS, Crystal reporting, storage)

■ Experience in Data architecture, design, analysis and developing solutions.

■ Innovative problem solver, able to see the business and technical sides of a problem. Proven leadership, negotiation and problem resolution abilities.

■ Strong analytical and logical problem solving skills

■ Strong work ethic; set appropriate priorities and customer expectations

■ Self motivated to learn new concepts

■ Exceptional communication skills, both oral and written

■ Independent thinker, self starter, quick learner, team player, strong interpersonal skills.

OBJECTIVE Result oriented Data warehouse, ETL and application developer with 13+ years of experience. Expertise in MS SQL Reporting and various programming languages.

EDUCATION Bachelor in Computer Science, DeVry University, Addison, IL

EXPERIENCE Interactive health INC June 2011 Present Senior Data warehouse/ETL/Reporting developer

Created and managed entire company’s data warehouse using SQL Server 2012 SSIS and reporting using Cognos.

● Conducted Code reviews and managed BI team in process improvements before production deployment .

● Helped company understand how members are registering and using our services, which services need improvements for better customer retention and satisfactions by creating analytical reports to show wait time and response time.

● Created Complex ETL process to generate data exports to Clients disease management services

● Designed a complex process to load different client’s eligibility file using scripts to validate file data that has different schema and loaded it into data warehouse and transaction system

● Created different reports in Cognos (Drill through and multi sub report) for business user to understand outcomes and improvements were needed.

● Mentored and helped web developers in writing optimized complex SQL to improve website response time.

.

SallieMae, Corporation November 2007 – June 2011 ETL Developer

Data warehousing for Cohort Year system

● Identified key measures and Fact Data buy analyzing Legacy system and talking to users

● Developed Staging and Data Cleansing process to load External client data

● Developed process to generate text files to load external client data into Legacy system

servers

● Loaded External Client data in Data warehouse from Legacy system server

● Developed Data mart for Reporting and Billing external clients

● Developed various Crystal reports for business analyst and External client

Data Warehouse Developer

● Worked with a team of ETL Developer to gather data from various sources and using SQL Server 2005 Integration Services to create the ETL Process to load data into SQL Server 2005 data base

● Created objects in Data Warehouse based on the warehouse architected by Project Manager using Star Schema

● Developed Analysis Cubes using Microsoft SQL Server 2005 Analysis Service

● Integrated data cubes with Microsoft Excel and Crystal Report XI front ends

● Created SSIS Packages to assist with ETL process

Migration to SQL Server 2005

● Rewrote existing DTS Packages into SQL Server 2005 SSIS Packages by working with Users and Analysts to streamline and optimize ETL Process and clean up data Warehouse

● Archive Aggregate tables for faster retrieval and also modify the existing Crystal report to accommodate Archive tables

SQL Database Performance Tuning

● Rewrote stored procedures with longer execution times to run more efficiently and faster with lesser table scans and locks based on Execution Plans and SQL Performance Monitor

● Recreated/Removed indexes from problematic tables based on findings from Index Tuning Wizard

Preferred Meal Systems, Inc June 2005 – November 2007 Senior Developer

Customer Invoicing System,

● Developed required stored procedures for Microsoft SQL Server 2000

● Developed reports using Crystal reports 9 and later upgraded to Crystal Report XI

● Worked with team of developers, analysts and testers through the development, install and support phase of the project life cycle

● Responsible for writing interface to Integrate the system with Accounting module of the ERP system that resulted in availability of up to the moment information regarding Cash Flow and General Ledger which in turn provided accurate up to date information about company’s financial status to Chief Executives, Board as well as the Banks

Legacy System Upgrade and ERP Integration

● Working with a team of 6 developers, upgraded existing Microsoft Access applications to Microsoft Visual Basic 6 through the development phase of the project

● Developed Microsoft SQL 2000 backend as part of the upgrade

● Upgraded Logistics application of the system that included Delivery Ticket and Routing system

● Assisted the support team with application support

Ameriking Corporation March 2000 – April 2005 Systems Developer

File Processing and Staging

● Processed Text and Excel files to load into SQL Server for reporting and Data warehouse load

● Generate Excel report using Excel data connections to SQL server data warehouse

● Create Stored procedures to be used on Crystal reports

● Support daily OLAP Cube processes

● Create OLAP Cubes using Star schema to process data for reporting

● Train users to use Pivot tables reports in excel

Electronic Data Transfer Automation (EDTA),

● Developed SQL Data Transformation Services to import data from various data sources (Text, MS Excel, MS Access, Unibol, XML) in to MS SQL Server 2000

Contact this candidate