[pic]

PRASHANT

Senior SQL Server BI Developer

201-***-****

abg1bo@r.postjobfree.com

. Highly Skilled Professional with around 8 years of experience in Software

Design, Development, Analysis, Testing, Data Warehouse and Business

Intelligence tools.

. Proficient in ETL (Extract - Transform - Load) using DTS (Data

Transformation Services), SQL Server Integration Services 2008 (SSIS),

SQL Server Integration Services 2012 (SSIS) and Informatica Power Center

tool.

. Exceptional background in analysis, design, development, customization,

and implementation and testing of software applications and products

. Experienced in various RDMS concepts such as Normalization, Managing

RDB's, Performance tuning, T-SQL programming.

. Analyzing, writing, developing and coding software applications for

Disease Management Identification System in conjure with APS's Healthcare

Specialists.

. Experience in High Level Design of ETL Packages for integrating large

scale data using OLE DB connection from heterogeneous sources (Excel,

CSV, Oracle, flat file, Text Format Data) by using multiple

transformations.

. Adept at SSIS (Integration Service) and Object Oriented Development(C#)

for design, constructing, and deployment.

. Proficient in Data migration between homogeneous/heterogeneous systems

and SQL Server using Integration Service (SSIS), BULK INSERT, DTS

Import/Export utility, and Bulk Copy Program (BCP).

. Specialized in creating several reports such as drill down reports,

parameterized reports, linked reports, sub reports, Matrix Reports,

Charts using SQL Server Reporting Services.

. Created email subscriptions for data driven reports by using Report

Manager.

. Used Report Manager to assign roles, permissions and to create report

schedules.

. Experience with Ad-Hoc reporting using Report Builder in SSRS for daily

reports.

. Experience in using variables, expressions and functions for the reports.

. Experienced in managing Alerts, Operators and Jobs using Active Batch

Enterprise Scheduler.

. Experience in writing complex SQL queries involving multiple table inner

and outer joins, temporary tables, table variables.

. Defined Indexes on Tables to boost the performance for DML tasks.

. Strong technical knowledge in Troubleshooting and Performance tuning.

. Experience in creating complex stored procedures, useful functions to

facilitate efficient data manipulation and consistent data storage.

. Using Power Pivot, we created our own data model from various data

sources, modeled and structured precisely to fit client needs.

. Experience with formatting and filtering data, creating calculated

fields, defining key performance indicators (KPIs) to use in PivotTables

and creating user-defined hierarchies to use throughout a workbook using

Power BI Microsoft and Power View Visualization tools.

. Experience with writing calculations by creating advanced formulas that

use the Data Analysis Expressions (DAX) expression language using Power

BI and Power View Microsoft Visualization tools.

. Experience in managing data model and creating relationships using drag

and drop in the Diagram View in Power BI and Power View Microsoft

Visualization tools.

. Experience of working with huge databases (size>5 M rows).

. Assisted in testing and validating SQL queries and SSIS packages in

development and QA environment for several ETL design teams.

. Handled high level escalates of issues and assessed the risks.

. Excellent communication and analytical skills, good knowledge of business

requirements in various domains.

. Experience working with remote teams and conducting web-meetings.

EDUCATION

Bachelor of Technology in Electronics and Instrumentation

CERTIFICATIONS

. Microsoft Certified Technology Specialist in SQL Server 2008.

. Microsoft SQL Server 2008, Business Intelligence Development and

Maintenance.

TECHNICAL SKILLS

Hardware: Dell Servers, HP Servers

Database: SQL Server 2000/2005/2008, MS Access

2003/2007, Oracle 9i

Operating Systems: Windows XP/2000/2003/Win 7

Programming Languages: T-SQL, HTML, C#, VB.Net

BI Suite: SSRS

ETL TOOLS: SSIS, DTS

Database Tools: SSMS, MS Visual Studio, Toad for SQL Server

4.6

Modeling Tools: Erwin (4x, 7x)

IT Experience

Washington State Department of Labor and Industries, Tumwater, WA

Oct 2014 - Present

SQL Server/SSIS BI Developer

The Washington State Department of Labor and Industries handles all the

Claims related to a worker being injured and even handles the Pensions for

retired and disabled workers. The Electronic Benefit Payments Project we

worked on was to introduce an additional option for workers in which they

could receive money electronically. This required building a separate

database and based on the requirement which could handle both the new claim

files and the previously existing claims. It involved a huge number of data

comparison, data conversion and

Responsibilities:

. Responsible for ETL Operation which extracts and transforms the data

to Data Warehouse using SQL Server Integration Services (SSIS)

. Developed Dynamic packages using SSIS (dynamic Package Configuration

of type SQL Server table) and Implemented Incremental Data Loading.

. Uploaded Element classes for the company Rochade - Dictionary.

. Responsible for updating Team Foundation Server source control.

. Setting up aliases with SQL Configuration Manager for team members and

managing Production server permissions accordingly.

. Worked with User Interface (UI) Java developers for data sorting, row

counting and data view layouts.

. Developed Query for generating Drill Down and Drill Through Reports in

SSRS 2008(R2).

. Involved in Optimization and performance reviewing of queries and

stored procedures using SQL execution plan.

. Proactively monitoring the performance of SQL Server databases,

troubleshooting system issues and monitored scheduled jobs.

. Implemented Error Logging using Event Handlers and also implemented

logging in SSIS Packages

. Collaborated with Business, gathered requirements and built reporting

solutions such as relational database reports, dashboards, and

scorecards.

. Constructed T-SQL Queries, Stored Procedures, Indexes, Functions and,

Views to support efficient data storage and manipulation.

. Created appropriate Triggers to assist efficient data manipulation and

data consistency

. Migrated DTS Packages of SQL Server 2008 to SQL Server 2012 as per

business requirement

. Generated various Report models on Views (due to security issues) and

deployed them on to the production reporting server and generated

various Report models and ad-hoc reports.

Environment: SQL Server 2012/2008 R2, Microsoft Visual Studio, MS BIDS,

SSRS, SSIS, Management Studio 2005/2008, Active Directory and Windows XP

platform, DOT NET 2.0/3.5 Framework, MS Office 2007.

APS Healthcare Bethesda Inc, Brookfield, WI

Apr 2013 - Sept 2014 SQL Server BI Consultant

As a care management company, APS' livelihood depends on collecting and

assimilating complex, detailed healthcare data from numerous clients, all

with disparate data systems, procedures and protocols. Our challenge is to

weigh real time data needs (identifying current eligible individuals in

need of healthcare intervention for example) with keeping extensive

historic data for retrospective analyses to accurately measure program

outcomes .I am part of the group that is responsible for data collection,

mapping, transformation and aggregation to allow the analytics and

operations teams to draw reliable and meaningful information from it.

Responsibilities:

. Create complex technical solutions and design utilizing ETL

tools(SSIS/Informatica) and other technologies(MS-DTS,VB,C#)

. Provide technical guidance and direction for each ETL(Extract,

Transform, and Load) project design and development team and ensure

documentation is produced using defined methodologies.

. Created technical solutions and designs utilizing ETL tool (SSIS,

Informatica) and other technologies.

. Worked on ETL (Extract, Transform, and Load) project design and

development of DMID and TGA automations.

. Prepared documentation as per APS Health Care standards.

. Developed/Monitored ETL packages with different data sources (SQL

Server, Flat Files, Excel files, etc) and loaded the data into target

tables by performing different kinds of transformations using SQL

Server Integration Services (SSIS).

. Developed Scheduled Jobs to automate the Disease Management

Identification (DMID) and Treatment Gap Analysis (TGA) Process using

SSIS Packages.

. Implemented Event Handlers and Error Handling in SSIS packages to

notify process results to various user communities.

. Defined an Error handling system in the SSIS package to identify data

issues with member claims.

. Expertise in building SSRS reports from various heterogeneous sources

like SQL Server, Oracle.

. Experience in creating Tablix Reports, Parameterized Reports, Drill

down, Sub-reports using SQL Server Reporting Services 2008.

. Experience in creating Ad hoc reports Using Report Builder

. Created temporary tables and table variables while creating complex

queries in SQL Server 2005/2008.

. Defined Indexes, Views, Constraints and Triggers to implement business

rules.

. Wrote complex SQL queries using table joins (inner and outer),

temporary tables, and table variables.

. Using Power Pivot, we created our own data model from various data

sources, modeled and structured precisely to fit client needs.

. Experience with formatting and filtering data, creating calculated

fields, defining key performance indicators (KPIs) to use in

PivotTables and creating user-defined hierarchies to use throughout a

workbook using Power BI.

. Experience with writing calculations by creating advanced formulas

that use the Data Analysis Expressions (DAX) expression language using

Power BI.

. Experience in managing data model and creating relationships using

drag and drop in the Diagram View in Power BI.

. Monitoring execution plans to enhance the performance of the queries.

. Developed indexed views, complex stored procedures to facilitate

efficient data manipulation and consistent data storage.

Environment: SQL Server 2000/2005/2008 Enterprise Edition,

BIDS,SSMS,SSIS,SSRS, T-SQL, Active Batch V7.0, Windows Server 2003, C#,

Power View.

Cisco Systems, Inc. Lawrenceville, GA Aug

2012 - Apr 2013

MS SQL Server /SSIS/SSRS/BI Consultant

Cisco Systems, Inc. is an American multinational corporation headquartered

in San Jose, California, that designs, manufactures, and sells networking

equipment. The scope of project was to design and develop data warehouse

and migrate Customer reviews and requirement data from different sources

and load into data warehouse using SSIS and using SSRS for reports.

Responsibilities:

. Worked with application developers and production teams across

functional units to identify business needs and discuss solution

options.

. Successfully installed and configured MS SQL Server2008R2 on the

development server.

. Automated the migration of data from Flat file to MS SQL Server 2008R2

DB using Microsoft SQL Server Migration Assistant (SSMA).

. Generated assessment reports to analyze the scope and complexity of

the migration projects.

. Designed a new schema design for the data warehouse using dimensional

modeling and developed it using the Erwin tool.

. Migrated the entire schema as well as data into MS SQL Server 2008R2

and also validated the migration process to ensure that it has been

successfully migrated.

. Created SSIS packages to load data from the OLTP system to a Data mart

for analyzing data.

. Performed various transformations like conditional split, sorting and

included data about the environment using the audit transformation.

. Provided documentation for all kinds of reports and SSIS packages.

. Scheduled and maintained nightly and weekly loads of data by creating

the corresponding job tasks.

. Generated parameterized reports, sub reports, tabular reports using

SSRS 2008.

. Created SQL Server Drill down, Drill through, Crystal reports with

SAP, Adhoc, Cross tab report using SSRS to fit business requirements.

. Created interactive data exploration, visualization, and presentation

experience using Power View visualization tool encourages intuitive ad-

hoc reporting.

. Designed and created Report templates, bar graphs and pie charts based

on the financial data.

. Generated reports using SSRS which were send to different Primary

Vendors, Clients, and managers.

Environment: MS SQL Server 2008R2, SSIS 2008R2, Legacy Modernization

Services, IBM I Series, SSAS 2008R2, T-SQL, Oracle, MS Access 2007, Windows

Server 2008, Power BI, Erwin v7.1.

Horizon Blue Cross Blue Shield, Newark, New Jersey

July 2011- Aug 2012

SQL Server /SSIS/SSRS Consultant

The company is providing health insurance coverage to over 3.2 million

people throughout all of North, Central, and South Jersey. The project was

to migrate data from various heterogeneous data sources such as oracle, MS

Access, MS Excel and flat files into SQL Server 2005 and maintain database

for the Facility search and Provider searches.

Responsibilities:

. Gathered business requirements, definition and design of the data

sourcing and data flows, data quality analysis, working in conjunction

with the data warehouse architect used (Kimball's approach)on the

development of logical data models.

. Installed and configured MS SQL Server 2005 along with Visual Studio

on a network domain system.

. Created logical and physical data models using Erwin for new

requirements after discussion with technical team and application

users.

. Designed and implemented complex SSIS package to migrate data from

multiple data sources (Teradata) for data analyzing, deploying and

dynamic configuring of SSIS packages.

. Designed high level ETL architecture for overall data transfer from

the OLTP to CDW with the help of SSIS.

. Developed and maintained a combined data store for reporting purposes.

. Generated reports using Global Variables, Expressions and Functions

using MS SQL Server Reporting Services 2005.

. Identified the database tables for defining the queries and defined

datasets for report generation.

. Defined report layouts including report parameters and wrote queries

for drill down reports using SSRS 2005.

. Created parameterized, drill down and aggregation reports in MS SQL

environment using SSRS 2005.

. Generated daily, weekly and monthly reports for the managers.

. Administered interface to organize reports and data sources, schedule

report execution and delivery, and track reporting history using SSRS

2005.

. Extensively used performance monitor/SQL profiler to solve dead

locks/long running queries.

. Used Data visualization tools to unlock the stories within the data,

enabling the client to present it in a way that is useful for making

business decisions.

. Using data visualization design concepts to store and display data.

. Created various classes of visualizations, their uses, and the

appropriate tools for each department.

. Provided guidance to junior developers on practical implementations

and of various visualizations and best practices for using them.

. Tested the reports and fixed bugs in the stored procedures.

. Responsible for the Performance tuning of the SQL Commands and the

troubleshooting of the technical problems in MS SQL Server 2005 with

the use of the Query Analyzer and Database Engine Tuning Wizard.

. Established backup and recovery of MS SQL server 2005 by using SQL

Server Agent Jobs for periodic Backups with backup devices, database

maintenance plans and recovery.

. Used Visual Source Safe (VSS) for version control.

Environment: MS SQL server 2005, MS Server Integration services, SSIS, DTS,

SSRS, Visual Studio Crystal Reporting, Profiler and Windows Server 2003,

Oracle, Power BI, Power View.

Deutche Bank, New York, NY

Oct 2010 - July 2011

SQL Server /SSIS/SSRS/BI Developer

Deutche Bank is a German bank organized as a Frankfurt trust company

specializing in services to German global banking and financial services

company with mutual funds and their advisers, collective investment funds,

corporate and public pension funds, insurance companies, operating

companies and non-profit organizations.

Responsibilities:

. Translated business needs into data analysis, business intelligence

data sources and reporting solutions for different types of

information consumers and created documentation for the same.

. Involved in Planning, Defining and Designing data base using Erwin on

business requirement and provided documentation.

. Developed complex T-SQL code such as Stored Procedures, functions,

triggers, Indexes and views for the application.

. Used Joins, correlated and non-correlated sub-queries for complex

business queries involving multiple tables & calculations from

different databases.

. Used advanced features of T-SQL in order to design and tune T-SQL to

interface the database and other applications in most efficient

manner.

. Created many complex Stored Procedures/Functions and used them in

Reports directly to generate reports on the fly.

. Created SSIS package to load data from XML Files and SQL Server 2005

to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns,

Condition Split, Term Extraction, Aggregate, Pivot Transformation, and

Slowly Changing Dimension.

. Used SSIS to create ETL packages to Validate, Extract, Transform and

Load data to Data Warehouse and Data Mart Databases.

. Developed Unit Test Plans for SSIS packages for checking the

functionality of each component.

. Modified the existing SSIS packages to meet the changes specified by

the users.

. Scheduled Jobs for executing the stored SSIS packages which were

developed to update the database on Daily basis using SQL Server

Agent.

. Designed, Developed and Deployed reports in MS SQL Server environment

using SSRS-2008.

. Generated Sub-Reports, Cross-tab, Conditional, Crystal reports, Drill

down reports, Drill through reports and Parameterized reports using

SSRS 2008.

. Created reports to retrieve data using Stored Procedures that accept

parameters.

. Scheduled the monthly/weekly/daily reports to run automatically onto

the Dashboard.

. Responsible for Monitoring, Tuning Report performance and Building

tools in Legacy Mainframes.

. Created various database objects like stored procedures, functions,

tables, views.

. Configured the report viewing security for various users at various

levels using Report Manager.

Environment: MS SQL Server 2012, T-SQL, SSIS 2008, MySQL, T-SQL, SSRS

2008, Core Java, T-SQL Advanced Server, SSMS, ERwin v7.2, ASP.Net, C#,

SharePoint

INDCON Engineering Consultants, Mumbai, India

July 2006 - Sep 2010

Borivali-East, Mumbai 400066, INDIA

Intern: SQL ETL Programmer

INDCON provides Design and Project Management for the IT Projects in

Oil/Gas, Petrochemicals, Refinery, Fertilizers and Steel sectors

. Worked on various domains such as electronic security, communications,

healthcare, networking and e-governance with database size exceeding 1

million rows.

. Interacted with business analysts to understand the business

requirements.

. Designed and developed ETL Packages for integrating large scale data

using OLE DB connection from heterogeneous sources (Excel, CSV,

Oracle, flat file) by using multiple transformations using SSIS(SQL

Server Integration Services)

. Created logical and physical database design using Erwin.

. Wrote complex T-SQL queries for data extraction.

. Migration of data from text files to SQL Server 2000 using BCP and DTS

packages.

. Created T-SQL triggers and Stored procedures encompassing business

rules.

. Wrote DTS packages to move data between production, staging and QA

environment.

. Programmed SQL Server 2000 Reporting Services using Microsoft Visual

Studio 2003.

. Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server

2005.

. Created database objects for improving the performance.

. Fine-tuned Procedures, Functions and Triggers for optimum performance.

. Involved in creating SQL reports.

. Involved in the SQL Query Performance Tuning.

Project: Design and Development of SQL Server Database System for

Healthcare sector

The project is credited as part of course work based on Database systems.

We worked on creating a database resembling that of Healthcare industry,

populating and running queries to load member claim files using SQL Server

2005.We used SQL Server Integration Services to do Extract, Transform and

Load (ETL) of data. The key purpose of the project is to determine the

feasibility and applicability of SQL Server for today's business

applications. The project was divided into 3 phases:

. Phase 1 involved figuring out the needs of a healthcare industry and

creating a comprehensive list of needs and prioritize them.

. Phase 2 involved creating the reference tables, stored procedures,

variables, etc that are going to be used for ETL(SSIS package)

. Phase 3 involved loading Rx, Med claims in various formats like CSV,

flat files, to SQL Server database using SSIS Package (ETL).

. Developed, designing and deploying of various reports such as Drill

down, Tabular reports, Parameterized, Pie charts MS Reporting Services.

. Developed SQL queries involving table inner and outer joins, temporary

tables, table variables.

. Created indexes to pull up patient contact information and get the

related insurance information for the patient

. Billing patients insurance and other third party carriers for charges

per company/division usual and customary charge or special approved

contract or Letter of Agreement pricing.

. Monitoring/tracking/correcting billing errors and ensures corrected

invoices are processed to ensure correct billing and collections.

. Maintaining and monitoring follow-up on accounts receivable status and

identifies/pursues collection of past due accounts. Provided management

with information on the status of accounts on a monthly and/or as needed

basis. Responded to billing\invoice inquiries from branch offices,

insurance companies and patients. This is Oracle based financial data.

. Analyzed each payor, patients and/or client's outstanding accounts

receivable and processes claims to obtain maximum reimbursement.

. Clearing payment variances, resolving differences, and initiating

corrective action.

Environment: SQL Server 2000/2005, Windows NT, Excel 2000, Access 2000,

Query Analyzer, Oracle, Enterprise Manager, Legacy Mainframe Software,

Erwin, Data Transformation Services (DTS).

Contact this candidate