Sign in

Sql Server, SSIS, SSAS, SSRS

Glenolden, Pennsylvania, United States
January 20, 2017

Contact this candidate


Mobile : +*-*** -*******


Visa Status : H1-B

99E Glenolden Ave,

Flat No: B305


Professional Summary

10+ Years of diverse experience in Information Technology with focus on Data base development and Business Intelligence.

10+ years’ experience in database development using SQL server.

Good programming experience in Transact SQL and writing Stored Procedures, Triggers, Functions

5+ years of experience in developing End-to-End implementation of data warehouse using dimension data modeling

Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling. Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS, creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities. Experience in working Tabular Models.

Experience in developing reports using Power BI and SSRS and Cognos Reports.

Experience in implementing Team Foundation Server (TFS) based version control for database projects and SSIS packages.

Good exposure in relational database design principles and preparation of database design documents.

Implemented Coding Standards for the development team for the SSIS packages as well as database objects/scripts.

A detail-oriented System Analyst with knowledge of different Software Development Life Cycle (SDLC) methodologies encompassing requirement capture, analysis, design, development, and implementation.

Experience in various domains such as Healthcare, Information Services, Banking and Financial etc.

Proactive team player with a positive attitude combined with excellent communication, interpersonal and analytical skills coupled with the ability to work effectively in a team as well as an individual.



SQL Server 2014, 2012, 2008, 2005



Analytics Tool

SSAS, Power Pivot

Reporting Tools

Power BI, SQL Server Reporting Service (SSRS), Cognos Report Studio


T-SQL,,C#, VB.NET, Visual Basic 6.0,

Version Management

Team Foundation Server

Other Tools

MS Visio, Actuate Reports, Crystal Reports, VBA.

Roles and Responsibilities

Client: Ameri Health Administrators (AHA), Philadelphia, Pennsylvania

AHA offer clients a full spectrum of business process outsourcing (BPO) and self-funded health plan administration services.

Role: Business Intelligence Lead. Duration: March 2016 – Till Date

Technical Lead for database/data warehouse projects for AHA.

Designed, implemented and supported ETL solutions.

Performed various roles such as data modeler, database developer and ETL and SSAS developer.

Designed dashboard reports using SSRS Reports

Created database projects for deploying to various environments to DEV, QA and UAT regions.

Closely worked with business team and solution architects to design the optimum database solution for the project.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Developed and deployed data transfers packages to the appropriate destinations using SSIS.

Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.

Defined the report layout and identified Datasets for the report generation.

Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.

Conducted database management, performance measurement and performance tuning for new and existing databases by using SQL Profiler, Database engine Tuning Advisor and execution plan.

Worked with the front end application developers with their queries.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.

Designed both logical and physical data models.

Environment: SQL SERVER 2012/2014, SSIS, SSAS, SSRS

Client: Independence Blue Cross, Philadelphia, Pennsylvania

Independence Blue Cross (IBC) is a health insurer based in Philadelphia, Pennsylvania in the United States. IBC is the largest health insurer in the Philadelphia area, serving more than two million people in the region and seven million nationwide.

Role: Technical Lead Duration: April 2013 – Jan 2016

Team Lead for Billing and Finance support projects.

Performed data modelling for the projects. Prepared Solution design documents, Database Design documents, SSIS package mapping documents etc.

Defined coding standards for database objects and SSIS packages.

Designed the SSAS Tabular Model for the project based on the requirements.

Prepared the database design document and data flow documents for the packages.

Supported existing Billing application based on service now tickets

Created various SQL scripts for maintenance of the application.

Created and supported stored procedures on demand.

Environment: SQL SERVER 2012, SSIS, SSAS, Power BI

Client: UST Global Inc - Internal Project –Data warehousing project.

BIZI is the UST Global Business Intelligence platform for Enterprise Data ware house which is used for various Reporting needs including corporate dashboards. The project involved integrating systems from various departments across the organization such as Human Resource, Finance and Facilities Management. ETL activities were done through SSIS and reports were developed using Cognos Reports and SSRS. Project involved populating various dimension tables and FACT tables for various departments and populating various reports using SSRS and Cognos.

Role: Senior System Analyst Duration: April 2011 – March 2013

Performed as a Team Lead/Technical Lead in various Data warehousing projects

Performed data modelling for various projects. Prepared Solution design documents, Database Design documents, SSIS package mapping documents etc.

Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.

Defined coding standards for database objects and SSIS packages.

Designed the SSAS cubes required in various projects based on the requirements.

Prepared the database design document and data flow documents for the packages.

Designed the Operation Data store and Enterprise Data ware house databases.

Involved in defining templates and standards for the SSIS package development.

Implemented Logging and SQL server based configuration with proper naming conventions

Lead the team to develop more than 100 SSIS packages with pre-defined coding conventions and standards.

Developed Stored Procedures for various projects.

Implemented job scheduling of each packages using SQL server job scheduling.

Proactively helped the team in solving the issues they faced during the development and implementations

Prepared the SSIS packages design document, deployment document etc.

Implementation of project modules in different phases.

Experience on Healthcare domain.

Environment: SQL SERVER 2012, Cognos, SSIS, SSAS.

Client: Wheels Inc. (, USA

Role: Senior Software Developer Duration: December 2010 – March 2011

Involved in the design and development and implementation of various .NET projects for the client.

Proactively worked with team to achieve the desired goals

Coordinated with various on-shore and offshore teams.

Worked with SSIS Packages development.

Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.

Involved in writing T-SQL stored procedures,complex joins, new SQL2008 T-SQL features like Merge, Except commands

Support Batch and Online processes involving development, enhancement and support of T- SQL procedures, views, triggers and query tuning

Environment: SQL SERVER 2012, VB.NET, Visual Basic 6.0

Client: British Telecom, United Kingdom (

Role: Senior Software Developer Duration: January 2010 – November 2010

Involved with development of reporting project for the client.

Designed the reporting architecture and the process flow.

Prepared the database scripts and stored procedures required for the projects.

Worked with on-shore team and coordinated various projects.

Migrated access objects to SQL Server 2005.

Configured and monitored database applications.

Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using SQL Server Reporting services and Actuate Reports

Designed and implemented several complex reports and administration modules.

Defined stored procedures for module integrity and application.

Prepared database triggers in T-SQL to check the referential integrity of the database.

Designed VB forms using the forms and crystal reports were made for business reporting purpose.

Involved in performance tuning of the database and T-SQL queries.

Environment: SQL SERVER 2008, Actuate Reports, SSRS

Organization: BK Gulf LLC, Dubai, United Arab Emirates

Role: Senior Software Developer Duration: October 2008 – December 2009

Worked as senior programmer in the applications for different internal applications such as Payroll and Inventory.

Created User Interfaces using VB.NET.

Performed database designing and SQL scripts required for the project.

Involved in creating Dynamic Stored Procedures and views.

Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

Involved in performance tuning of queries for query efficiency.

Took part in the normalization and de-normalization of database.

Responsible for creating datasets using T-SQL and Stored Procedures and also involved in Data visualization.

Responsible for rebuilding the indexes and tables as part of performance tuning

Used SQL Server Agent for scheduling jobs and alerts

Performed Query optimization & Performance Tuning

Optimized queries using SQL Profiler and Database engine tuning advisor

Environment: SQL SERVER 2008, VB.NET, Crystal Reports

Organization: Dutco Balfour Beatty LLC, Dubai, United Arab Emirates

Role: Senior Software Developer Duration: August 2004 – September 2008

Application development using Visual Basic.

Logical and Physical Data Modeling to fit business requirement.

Implemented Triggers for checking complex business conditions, providing security for the tables.

Physical Implementation of database into SQL Server 2000 using T-SQL.

Lead developer for Visual Basic based application development for construction management software and other internal applications.

Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.

Generated reports using MS-Excel and Crystal Reports.





Master in Computer Applications (MCA)

Indira Gandhi National Open University,

New Delhi



Microsoft Certified Solution Expert in Business Intelligence (MCSE).(Valid Till 04/08/2017)

Contact this candidate