Sql Server Data
Resume:
ABHI
Employer Contact : 973-***-****/*****@**********.***
PROFESSIONAL SUMMARY:
● Over 7+ years of IT experience as a MS SQL Server 2008R2/2008/2005/2000 Developer
in various industries like Finance, Insurance, and Health Care.
● Strong knowledge of Data Warehouse concepts and technologies such as ETL processes,
dimensional modeling, Star and Snowflake Schemas, reporting tools and surrogate key
generation.
● Expert in Logical and Physical Database design & development and Data modeling using
the Erwin Data Modeler tool. Also performed consistency checks using DBCC utilities to
ensure the physical consistency of the database and objects.
● Experienced in SharePoint 2010 Development, .NET Development, SharePoint 2010, web
configuration and deployment
● Provided support to SharePoint users and site level administrators
● In-depth knowledge of Transact-SQL (DDL and DML). Proficient in creating Tables,
Indexes, Joins, Triggers, Views, Stored Procedures, User Defined Data Types and
Functions.
● Expertise in performing ETL using SSIS, DTS, Bulk Insert and BCP.
● Developed SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data
warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
● Expertise in upgrading/migrating from DTS to SSIS packages. Experienced in resolving
complex issues and error handling in SSIS.
● Experienced in report generation using Crystal Reports, XML, MS Access and Excel.
● Proficient in creating Chart reports, Drill down and Drill through reports by passing
parameters in SSRS.
● Conversant with all phases of the Software Development Life Cycle (SDLC) involving
business process analysis, requirements gathering and analysis, detailed design,
development, testing and post implementation support.
● Developed and Deployed OLAP cubes, Facts and Dimension tables.
● Used MDX (Multi-dimensional Expressions) queries for calculated members of a cube and
KPIs (Key Performance Indicators).
● Created reports using MDX and SQL.
● Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data
Import/Export and Troubleshooting.
● Expertise in using tools like the Index Tuning Wizard of the Database Engine and SQL
Profiler for performance monitoring and tuning.
● Utilized XML document structures and hierarchical data.
● Expertise in VBA macros and MS-Excel (VLOOKUP and Pivot)
● Knowledge of Asset Management.
● Experienced in developing Web-based Applications with JSP, Java, PHP as front-end and
MySQL and Oracle as backend.
● Upgraded MS SQL Server 2005 databases to 2008 using detach/attach, backup and
recovery and by replication.
● A motivated, highly organized individual and enthusiastic team player with excellent
communication, analytical and problem solving skills.
EDUCATIONAL QUALIFICATIONS:
Masters in Engineering
SKILL SET:
MS SQL Server 2012/2008/2005, DTS, SSIS 2008/2005, SSRS 2008/2005, SSAS 2008/2005, T-
SQL, MS Visual Studio 2010/2008/2005, Erwin Data Modeler r8,r7,4.2, MS Access 2007/2003,
Index Tuning Wizard, MS SQL Profiler, Windows Server 2008/2003/2000, Crystal Reports
11/10/9/8.5, SharePoint 2007, VB.NET, UNIX, HTML, XML, JavaScript, JSP, Java, Oracle 10g.
PROJECT SUMMARY:
Bank of America Addison, TX 08/2012– Present
MS SQL/SSIS/SSRS Developer
Bank of America Corporation is an American multinational banking and financial
services corporation .It is the second largest bank holding company in the United States by
assets. It is the fifth-largest company in the United States by total revenue. The main task of this
project was to create and implement packages to extract data from OLTP systems to the Staging
Database and loading into Enterprise Data Warehouse and to Generate Reports according to user
Responsibilities:
● Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from
multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL
2008, and SQL 2008R2).
● Transformed data into Staging Server named as PStaging Server for historical data and
TStaging Server for load increment.
● Performed historical or full load and incremental load data into Enterprise Data
Warehouse.
● Created configurations to make package portable and event handlers for handling
package error.
● Developed Custom Logging so user can know when a row is inserted in custom logging
table by every SSIS package that executes, if SSIS packages extract row from DB2 to
CDC DB, or any insert, update or delete rows in dimension or fact tables in DW.
● Extracted data from OLTP System which was DB2 to two different DB named
HISTORICAL DB and CDC (Change Data Capture) DB.
● Filtered data from Transient Stage to EDW by using Complex T-SQL statements in
Execute SQL Query Task and in Transformations and implemented various Constraints
and Triggers for data consistency and to preserve data integrity.
● Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute
SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
● Created SSIS packages to Extract, Transform and Load data using different
transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot
Transformation, and Slowly Changing Dimension, Merge Join and Union all.
● Created and modified various Stored Procedures used in the application using T-SQL.
● Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent
in SSMS.
● Utilized VLOOKUP and Pivot tables to perform detailed analysis
● Created Macros utilizing VBA to optimize data mining.
● Developed complex Stored Procedures to generate various Drill-through reports,
Parameterized reports, Tabular reports, Matrix reports and Linked reports using SSRS.
● Wrote complex Expressions and Calculations for SSRS reports with Conditional
Formatting.
● Created Project Expense Statements in all Data Marts and other Financial Reports using
SSRS. Developed quarterly company expense reports.
● Responsible for Deployment of the report using SSRS and used Report subscription (Data
Driven and Email) to publish reports.
● Tuning SQL query for better performance using SQL Profiler.
Tools & Technologies:
MS SQL Server 2008R2, SSIS 2008R2, SSRS 2008R2, T-SQL, Windows 2008 Server, SSMS,
SQL Profiler, Visual Studio 2010.
TriZetto Corp Union, NJ 07/2011 - 07/2012
MS SQL/SSIS/SSRS/SSAS Developer
TriZetto delivers world-class information solutions that enable healthcare organizations to work
more efficiently and collaboratively to deliver better health. TriZetto solutions help health plans and
TPAs increase administrative efficiency, improve the cost and quality of care, and succeed in the
retail healthcare market. The project involved gathering data from different sources, developing
and monitoring ETL operations, generating reports.
Responsibilities:
● Created and deployed new SSIS packages to Extract, Transform and Load data using
different transformations such as Aggregate, Conditional Split, Derived Columns, Pivot
Transformation, Slowly Changing Dimension, Merge Join and UNION ALL.
● Worked with the Control Flow components of SSIS such as For-Each Loop Container,
Sequence Container, Script Task, Execute SQL Task, Package Execution Task, FTP Task,
Send Mail Task, Expressions and Variables to achieve business needs.
● Integrated and Analyzed data from multiple homogeneous and heterogeneous sources
such as SQL 2008, SQL 2005, DB2, Excel, CSV and FTP Server.
● Performed multiple transformations such as Lookup, Derived Columns, Conditional Split,
Slowly Changing Dimension, Merge and Union All to load data into the Data Warehouse
for further data analysis.
● Modified existing SSIS packages and also added more alerts and audits in case of
package failure.
● Defined the partition function and created schema for table partitioning.
● Designed, Developed and Deployed Tabular Reports, Matrix Reports, Drill-through
Reports and Parameterized Reports using SSRS-2008.
● Developed quarterly company reports.
● Deployed reports using SSRS. Used Report Subscription(Data driven and Email) to
publish reports.
● Used SQL Profiler for Performance Tuning by tracing the slow running queries and the
server activity in general.
● Involved in designing and deploying cubes in SSAS using Star Schema.
● Designed and deployed cubes with around 45 dimensions, about 25 measures and 30
calculated members, design dimensions and using MDX expressions for the various
calculated members, actions and KPIs.
● Created Documentation on Tables, Stored Procedures, Views and User Defined
Functions.
● Implemented Constraints and Triggers for Data Consistency and to preserve Data
Integrity.
● Scheduled and maintained packages on a daily, weekly and monthly basis using SQL
Server Agent using SSMS.
● Created and modified various Stored Procedures and Functions.
Tools & Technologies:
MS SQL Server 2008, T-SQL, SSIS, SSRS, SQL Server Agent, MS SharePoint 2010, Visual
Studio 2008, Windows 2008
DentaQuest, Boston, MA 09/2010 - 06/2011
MS SQL/SSIS/SSRS/SSAS Developer
DentaQuest is one of the nation's largest consumer dental health organizations. Specialty
operations include behavioral dental and providing innovative dental benefits programs, improving
the efficiency and effectiveness of care, and working with communities and others to change the
perception of oral. The project involved user training, installation of SQL Server 2008, generating
reports based on requirements and development of a Database application.
Responsibilities:
● Designed a Database and a Data Warehouse for the system using Star Schema.
● Implemented SSIS package to perform ETL on data from OLTP systems such as Oracle,
Flat Files, CSV, SQL 2008 and loading into the Staging Database using Lookup, Fuzzy
Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot
Transformation, and Slowly Changing Dimension.
● Created and managed schema objects such as Tables, Views, Indexes, Stored
Procedures and Triggers.
● Developed Stored Procedures and Triggers to handle complex business rules, data
conversion, historical data, and audit analysis.
● Scheduled Stored Procedures and SSIS packages every mid-night and every week by
creating SQL Server Agent jobs in SQL Server Management Studio (SSMS).
● Designed and Deployed Cubes in SSAS 2008. Created Fact and Dimension tables.
● Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key
Performance Indicators).
● Created Sub-reports, Drill-down reports, Matrix reports and Summary reports in SSRS
2008.
● Utilized VB.net in Script Task to check existing file in SSIS package
● Created various Parameterized Reports, Drill through Reports using SSRS 2008.
● Generated ad-hoc reports using MS Reporting services.
● Utilized Package Configurations and Event Handlers in SSIS to make a package more
portable and to handle errors in the packages.
● Handled errors in Stored Procedures using @@error and with Try/catch.
● Worked with XML document structures and hierarchical data.
● Used SQL Profiler and Execution Plan for Performance Tuning.
Tools & Technologies:
MS SQL Server 2008, SSIS 2008, SSRS 2008, SSAS 2008, T-SQL, SSMS
CIGNA, Philadelphia, PA 01/2010 – 08/2010
MS SQL Server Developer
Cigna is an insurance company specializes on Disability, Life and Accident products that focus on
low cost and consistent, excellent delivery of the service basics. These products are offered to
employees and association members through their employers, associations and other affinity
groups. The scope of the project was creating a database schema to perform analysis on the
company performance for the past 2 years using SSAS. The project requires creating, designing
and modifying reports.
Responsibilities:
● Upgraded MS SQL Server 2005 databases to 2008 using detach/attach, backup and
recovery and by replication.
● Incorporated the DTS packages into SSIS 2008 by using package migration wizard and
executed DTS 2000 Package task.
● Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled
jobs to call the packages and Stored Procedures.
● Performed transformations using various SSIS tasks such as conditional split, derived
column, that performed data scrubbing, including data validation checks during staging,
before loading the data into the data warehouse.
● Used ETL to implement the slowly changing transformation to maintain historical data in
data warehouse.
● Created Views to reduce database complexities for the end users.
● Designed and implemented stored procedures and triggers for automating tasks.
● Created Sub-reports, Drill-down reports, Summary reports, and Parameterized reports in
SSRS.
● Performed T-SQL tuning and optimization of queries for reports that take longer execution
time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL
Server 2008.
● Created alerts for successful or unsuccessful completion of scheduled jobs.
● Involved in documentation for all kinds of reports, DTS and SSIS packages.
Tools & Technologies:
MS SQL Server 2008, T-SQL, SSIS 2008, SSRS 2008, MS SQL Profiler, SQL Query Analyzer,
Index Tuning Wizard, MS Access, Crystal Reports 10/9, Visual Studio 2008, MS Office 2007.
Blue Cross Blue Shield, Newark, NJ 10/2007 - 12/2009
MS SQL Server Developer
BCBS is a health care company which provides different health insurance solutions from health
management, monitoring to diagnosis. It also provides many health care products which treat
infections, disorders and provide remedy for chronic and solutions to clinical care. The project
involved in upgradation and migration from SQL server 2005 to SQL Server 2008 and also to
transfer data from OLTP (Online Transaction Processing) to OLAP (Online Analytical Processing).
Responsibilities:
● Designed SSIS packages to transfer data between servers, load data into database,
archive data file from different DBMS’s using SSMS on SQL Server 2005 environment,
and deploy the data; Scheduled the jobs to do these tasks periodically;
● Optimized schema, performance, and capacity planning of various data transformation
processes related to the reports.
● Made sure that standards and best practices in database development were followed and
maintained.
● Scheduled and monitored all maintenance activities of SQL Server 2008 including
database consistency checks and index defragmentation.
● Set up database backup and recovery strategies.
● Designed and Implemented the Stored Procedures and Triggers for automating tasks.
● Maintained all records of project status and followed changes as per control procedures.
● Provided technical support to internal developers and external clients.
● Generated test data and tested database to meet the functionalities/deliverables in the
project documentation and specifications.
Tools & Technologies:
MS SQL Server 2008/2005, Windows Server, Windows NT, Visual studio 2005
Mastek, India 09/2005 – 07/2007
MS SQL Server /ETL Developer
Work on delivering business value and enhanced business capabilities to clients through a
combination of world class enterprise grade products, implementation services and specialized IT
services.The project was mainly on migrating data from the database sources like Excel, MS
Access, flat file into MS SQL and creating and modifying database.
Responsibilities:
● Interacted with business users and analysts and gathered and documented the technical
and business metadata.
● Enhanced PMS data model to incorporate new reporting on wealth management system
requirements.
● Build mapping document to map all the data elements from wealth management system to
PMS.
● Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into
database objects.
● Designed database, tables and views structure for the new data mart.
● Successfully transferred old data from various sources like flat files, MS Access, and Excel
into MS SQL Server 2000 using DTS Packages.
● Build packages for data reconciliation between wealth management system and PMS and
logging them for auditing purposes.
● Tuned SQL statements Using Indexes and stored procedures.
● Developed data access queries/programs using SQL Query to run in production on a
regular basis and assists end users with development of complex Ad Hoc queries.
● Involved in implementation and maintenance of disaster recovery solutions such
as replication and log shipping.
● Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL
Profiler, index tuning wizard.
Tools & Technologies:
MS SQL Server 2005 Enterprise Edition, MS Access 2003, Erwin v4.0, T-SQL, MS-Excel, MS-
Access, SQL Query Analyzer, MS SQL Profiler.
Contact this candidate