Sql Server Data
Resume:
*********@*****.*** JITENDER Phone # 919-***-****
Around 6 years of IT experience in Database/Data Warehouse design, development &
administration using Microsoft SQL Server 2012/2008R2/2008/2005, T-SQL, SQL
Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL
Server Analysis Services (SSAS) in DEV, TEST and PRODUCTION environments with
various domains like Financial, Health Care and Pharmaceutical.
Good experience in Database Design and development of applications with Business
Intelligence using SQL Server 2012 &2008, Integration Services(SSIS), DTS
Packages, Reporting Services 2012 &2008(SSRS), and Implementation of Data
warehousing, SQL Server Analysis Services(SSAS), MDX Queries, OLAP Cubes, Star
Schema and Snow Flake Schema.
Extensive experience with SQL Server and T-SQL in constructing Business logic at
back-end using Stored Procedures, views, indexes.
Experienced in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring
and Troubleshooting of SQL Server SQL Server 2012/R2/2008/2005.
Experience in working with SQL SERVER 2005, 2008/R2, 2012.
Experience in extracting data from heterogeneous sources, transforming and Load
functions from multiple OLTP systems into a single data warehouse using SSIS.
Extensive experience in creating, deploying and monitoring SSIS packages
Good experience on Debugging Data Flow, Control Flow and Packages.
Good Experience on Performance Tuning in SSIS Packages.
Experience in Error Handling and Package Configurations Management.
Experience in Microsoft Visual C# in script component of SSIS.
Excellent report creation skills using Microsoft Reporting Services.
Generated daily, weekly and monthly reports for the managers using SSRS
Created Tabular, Matrix reports with and without parameters using SSRS
Experience working on creation of various Reports using SQL Server Reporting
Services (SSRS).
Experience in developing dashboards reports, Scorecard reports using PPS.
Experience in Customizable dashboard pages, KPI Details reports, sophisticated
scorecards, Time Intelligence, Reusable dashboard items, dashboard filters.
Experience in creating dashboard pages, dashboard filters, and Performance Point
reports by using Dashboard Designer.
Experience in various operational Drill-through, Drill-down, and linked reports using
SSRS.
Experience in developing different kind of reports such a Sub Reports, Chars, Matrix
reports, and Linked reports.
Experience in working with Report Expressions.
Designed, deployed, and maintained of various SSRS Reports in SQL Server.
Created Rich dashboards using Tableau Dashboard and prepared user stories to
create compelling dashboards to deliver actionable insights.
Experience in working with Excel applications to browse the data and create reports -
using pivot table, power pivot & power view.
Excellent OLAP skills and designing cubes, populating data, optimizing cubes using
SSAS.
Expertise skills in Calculating Measures and Calculating Members in SQL Server Analysis Services
(SSAS) using multi-dimensional expression (MDX).
Experience in Back ends database processing, Report generation of CRM application.
Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as
developing, testing, migrating, security management and production supporting on
various platforms like Windows 2003/XP/07.
Excellent perspective on converting the functional specifications into technical design
and development.
Strong troubleshooting, presentation, communication, interpersonal skills; and highly
motivated with an ability to learn new systems and business procedures with
hardworking and result oriented as an individual and in a team.
Created web application using C#.
Developed various interface webpages for incoming files for the Vendor Interfaces
including service invoice, finance and insurance, using C# and job claims with stored
procedures.
Developed the classes using C#, which incorporate N-tier architecture and database
connectivity.
Bachelor of Technology, Anna University
MS SQL Server 2012/2008R2/2008/2005, SQL Server Management Studio (SSMS), T-
SQL, Teradata 13.0, Visual Studio 08/10, MS SQL Server Integration Service (SSIS), MS
SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), Business
Intelligence Development Studio (BIDS), Tableau, SQL Server Profiler, SQL Query
Analyzer, MS SharePoint, PPS, MS Access, MS- Excel, MS Office Suite, MS Visio
2007,Power BI, Windows 7/XP/98, C#,.NET, TFS, QC
Duke Energy, Raleigh, NC
Reports Developer/SSIS /SSRS/SSAS Developer July 2016 – Present
Duke is one of the largest Utility Sector of power & Gas in the United States, supplying and
delivering electricity & Gas to approximately 7.4 million U.S. customers. Duke have
approximately 52,700 megawatts of electric generating capacity in the Carolinas, the Midwest
and Florida – and natural gas distribution services serving more than 1.5 million customers in
Ohio, Kentucky, Tennessee and the Carolinas. Duke commercial and international businesses
own and operate diverse power generation assets in North America and Latin America, including
a portfolio of renewable energy assets. My role as a programmer Analyst involved me to analyze
the large database to prepare various kinds of Gas, Distribution, Transmission reports by
integrating multiple sources Using ETL tools like SSIS, And reporting tools like SSRS.
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.
Involved in writing T-SQL programming to implement Stored Procedures and
Functions for different tasks and created Triggers to enforce data and referential
integrity.
Build packages and handled slowly changing dimensions to maintain the historic
data.
Responsible for optimizing all indexes, SQL queries, stored procedures to improve
the quality of software.
Designed new SSIS Packages and worked on existing various transformations to
transfer data from various sources like Text Files, XML (Extensible Markup Language)
Files, SQL Server, Excel and Access to SQL Server using Business Intelligence
Development Studio.
Worked on Agile Scrum Methodology and designed high level ETL architecture for
overall data transfer from the OLTP to EDW with the help of SSIS.
Worked on various tasks and transformations like Execute Sql task, Execute Package
Task, Conditional split, Script Component, Merge and Lookup while loading the data
into Destination.
Widely used SSIS transformation such as Derived Column, send mail task, fuzzy
lookup, fuzzy grouping, data conversion and aggregate.
Design and Implemented OLAP Cubes, Facts, and Dimensions.
Involved in creating calculated members, Hierarchies, named set, advanced KPI’S,
Partitions for the SSAS cubes.
Developed auto generated system using SQL Server Agent to schedule the packages.
Developed and modified parameterized, drill down, drill through, cascading
parameterized and sub reports in SQL Server Reporting Services and exported them
to Excel format for managers and Quality Analyst team for easy validation.
Developed various Charts and Graphs like bar charts, line charts, pie charts by using
chart experts for Business Intelligence needs in SQL Reporting Services.
Optimized the Views, Queries and Stored Procedures to enhance the complex
reports. Created clustered and non-clustered indexes wherever possible to speed up
the queries which in turn enhance the performance of the Reports.
Integrated MS SSRS with SharePoint Foundation 2010/SharePoint Server 2010 by
configuring a report server to run in SharePoint integrated mode.
Created and modified the existing stored procedures, Functions, views and queries to
have effective reporting. Wrote cte’s in the stored procedures to minimize the logic in
the Reporting Services.
Optimize the query performance by using Query optimizer, execution plan, SQL
Server Profiler and optimizing techniques.
Used various SSRS expressions in reporting properties to enhance the layout up to
the users’ requirements. Deployed reports on the reporting server and share point
server and manage the subscriptions.
Created different kinds of dashboards, Chart reports off of tabular models using
Power BI.
Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft Share point, Microsoft SQL Server
2008, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010,
Microsoft Excel 2010, Power BI.
BB&T, Winston-Salem, NC
Programmer Analyst/ SSIS /SSRS Developer June 2016 – July 2016
BB&T is one of the largest financial services holding companies in the U.S. with billion of
assets Based in Winston-Salem, N.C., the company operates 2,137 financial centers in 15
states and Washington, D.C., and offers a full range of consumer and commercial banking,
securities brokerage, asset management, mortgage and insurance products and services.
The scope of the project was to analyze the incoming data which were at different
frequencies and various sources .Build SSIS Packages to stage data, cleanse and load
them into OLTP and finally into the OLAP Database for analysis and reporting services.
Responsibilities
Good Experience in writing T-SQL programming to implement Stored Procedures and
Functions for different tasks and created Triggers to enforce data and referential
integrity.
Build packages and handled slowly changing dimensions to maintain the historic
data.
Responsible for optimizing all indexes, SQL queries, stored procedures to improve
the quality of software.
Designed new SSIS Packages and worked on existing various transformations to
transfer data from various sources like Text Files, XML (Extensible Markup Language)
Files, SQL Server, Excel and Access to SQL Server using Business Intelligence
Development Studio.
Worked on Agile Scrum Methodology and designed high level ETL architecture for
overall data transfer from the OLTP to EDW with the help of SSIS.
Worked on various tasks and transformations like Execute Sql task, Execute Package
Task, Conditional split, Script Component, Merge and Lookup while loading the data
into Destination.
Widely used SSIS transformation such as Derived Column, send mail task, fuzzy
lookup, fuzzy grouping, data conversion and aggregate.
Developed auto generated system using SQL Server Agent to schedule the packages.
Developed and modified parameterized, drill down, drill through, cascading
parameterized and sub reports in SQL Server Reporting Services and exported them
to Excel format for managers and Quality Analyst team for easy validation.
Developed various Charts and Graphs like bar charts, line charts, pie charts by using
chart experts for Business Intelligence needs in SQL Reporting Services.
Optimized the Views, Queries and Stored Procedures to enhance the complex
reports. Created clustered and non-clustered indexes wherever possible to speed up
the queries which in turn enhance the performance of the Reports.
Integrated MS SSRS with SharePoint Foundation 2010/SharePoint Server 2010 by
configuring a report server to run in SharePoint integrated mode.
Created and modified the existing stored procedures, Functions, views and queries to
have effective reporting. Wrote cte’s in the stored procedures to minimize the logic in
the Reporting Services.
Optimize the query performance by using Query optimizer, execution plan, SQL
Server Profiler and optimizing techniques.
Used various SSRS expressions in reporting properties to enhance the layout up to
the users’ requirements. Deployed reports on the reporting server and share point
server and manage the subscriptions.
Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft Share point, Microsoft SQL Server
2008, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010,
Microsoft Excel 2010.
Residential Credit Solutions, Fort Worth, TX Nov 2014 – Feb 2016
Analytics Consultant/ BI SSIS /SSRS Developer
Residential Credit Solutions, Inc. is engaged in investing, issuing, and servicing mortgages.
The company focuses on servicing and managing performing and nonperforming residential
mortgage loans for homeowners. It provides subservicing of residential mortgage loans in
the United States and Puerto Rico. The company also provides component services, such as
borrower outreach, modification assistance, and loss mitigation services for loan servicers;
and investor and co-investor of mortgage credit, such as residential loans, mortgage
servicing rights, and mezzanine debt. In addition, it offers payment counseling services in
the areas of repayment plan, loan modification, short refinance, short sale/deed in lieu, and
home affordable modification program; and payment services.
Responsibilities:
Gathered user requirements and analyzed and designed software solution and
database.
Designed the Entity Relationship(ER) models.
Extensively worked on full Software Development Life Cycle (SDLC) of the project
from Database Design and Modeling to implementation and maintenance.
Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server
Source Database
Developed ETL packages with different data sources (SQL Server, Flat Files, Excel
source files, etc.) and loaded the data into target tables by performing different kinds
of transformations using SQL Server Integration Services (SSIS
SSIS Components used extensively in the project are Merge join, Derived Columns,
Look UP, Conditional Split and Multicasting.
Designed various packages using various task e.g. For Each Loop, File System Task,
Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.
Experience in performance tuning of SSIS Packages using row transformations.
Performed Index analysis for tables and came up with more efficient solutions to use
Clustered and Non-Clustered Indexes for significant performance boost of the
existing product databases.
Created complex Stored Procedures for validation process & for loading data from
the staging area to the product database in SQL 2008.
Experience in configuring with checkpoints, package logging, error logging and event
handling to redirect error rows and fix the errors in SSIS.
Deployed SSIS packages from Development to Testing Servers
Integrated SQL Server 2008 with CRM using SQL Stored Procedures, Functions,
Triggers, and Importing/Exporting data from legacy data sources using SSIS.
Developed dynamic reports using CRM reporting interface and SSRS SQL 2008 R2
engine.
Worked on all activities related to the development, implementation and Support
Of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
Experience with SSIS performance tuning using counters, error handling, event
handling, re-running of failed SSIS packages using checkpoints and scripting with
Active-X and VB.NET in SSIS.
Experience in SSIS script task, look up transformations and data flow tasks using T-
SQL and Visual Basic (VB) scripts.
Created and developed query for Tabular and Matrix Reports using SQL Server 2008
Reports Services (SSRS)
Created Drill-through reports, parameterized reports and linked reports using SSRS
2005 and 2008.
Worked on Report generation using SQL Server Reporting Services (SSRS) that could
be used to send information to Client.
Excellent report creation skills using Microsoft Reporting Services (SSRS) with
proficiency in using Report Designer as well as Report Builder.
Reports migrations from Actuate to SharePoint/SSRS technology.
Developed custom reports and deployed them on server using SQL Server Reporting
Services (SSRS).
Generated periodic reports based on the statistical analysis of the data using SQL
Server Reporting Services (SSRS).
Promoted Reporting Definition Language (RDL) to Reporting Service Server (SSRS).
Environment: SQL Server 2008, 2008R2, 2012, T-SQL, SQL Server Integration Services
(SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2008/2
Maersk Line, Florham Park, NJ Dec 2013 – Aug 2014
BI Developer (SSIS/ SSRS/SSAS)
Description:
The purpose of UTM application is to develop BI reports which enable Uptake
Managers to set bucket levels to optimize the use of allocated space. Uptake
manager gets a projection of the final cargo level at each port which enables them to
set the bucket levels.
In a scenario:
Uptake Manager makes a decision when provided with options for acceptance of
cargo, based on best yielding cargo. Otherwise it will be always FirstComeFirst
Serve.
The final reports of UTM help uptake managers as:
UTM Manager can allocate cargos to be loaded, by viewing Vessel Status.
UTM Managers can manage cargos at port level by viewing aggregated Port
statuses
UTM managers can view uptake curve (in TEU) for range of dates in a Port to
understand booking statuses and downfalls.
As end result this application helps in minimizing the issues at ports and more
opportunities and hence optimized shipments at each port
Responsibilities:
Experience with all phases of software development life cycle (SDLC) and project
methodologies
Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled
Jobs to call the packages and Stored Procedures.
Created standalone packages for data extraction using SQL Server Integration
Services and also have experience on creating dynamic packages through Script task
components.(VB.NET)
Designed and implemented complex SSIS package to migrate data from multiple
data sources for data analyzing
Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views,
SQL joins and other T-SQL code to implement business rules
Created a CRM Entity Modification tool, functional diagrams, and workflow diagrams
Updated design documents as necessary to reflect changes necessitated by change
requests and implementation issues(MS Dynamics CRM)
Created packages to validate, extract, transform and load data to a centralized SQL
server using OLEDB providers from the existing diversified data sources through ETL
tool
Multi-dimensional cube modeling and reporting using (Data warehouse / data mart
modeling and implementation)
Design and Implemented OLAP Cubes, Facts, and Dimensions for providing
summarized and aggregate views of large sets of data and used Multi-Dimensional
Expression (MDX) to access them.
Using MDX created calculated members for customized calculated measures
Excellent technical and analytical skills with clear understanding of design goals of ER
modeling for OLTP and dimension modeling for OLAP
Generated daily, weekly and monthly reports for the managers using SSRS
Involved in creating calculated members, named set, advanced KPI’S for the SSAS
cubes.
Conducted quantitative analysis of financial data to forecast revenue, identify future
trends, and risk associated with capital expenditures by creating cubes (SSAS)
Utilized pivot tables to provide structure to reports in proper format like months etc.
Generated periodic reports based on the statistical analysis of the data from various
time frame and division using SQL Server Reporting Services (SSRS)
Created reports and scheduled using SSRS to support Financial Planner to deliver
informational sales presentations to potential clients
Developed various operational Drill-through, Drill-down, and linked reports using
SSRS
Use TFS 2010 for Source Control of Project code.
Developed different kind of reports such a Sub Reports, Chars, Matrix reports, and
Linked reports
Designed, deployed, and maintained of various SSRS Reports in SQL Server.
Environment: SQL Server 2012/2008R2, Microsoft Visual Studio, SQL server Integration
Services(SSIS), SQL server Reporting Services(SSRS), SQL server Analysis Services(SSAS),
MS Office 2007/2010,Pivot,Power Pivot,PPS,TFS 2010
Aptuit, Greenwich, CT
BI Developer (SSIS, SSRS) Oct 2008 - Aug 2010
Description: Aptuit is a One of the API’s Industry providing drug discovery, development
and manufacturing support and understanding of the needs of the pharmaceutical and
biotechnological community. The Project was about Supporting Decision Support Sciences
by providing the BI Solutions.
Responsibilities:
Involved in Planning, Defining and Designing data based on business requirements
and provided documentation.
Created effective functions, appropriate Triggers to facilitate efficient data
manipulation and data consistency.
Transformed complex business logic into Database design and maintaining it by
using SQL objects like Stored Procedures, User Defined Functions, and Views.
Successfully implemented indexes on tables for optimum performance.
Extensively used Joins and Sub-queries for complex queries involving multiple tables
from different databases.
Use various SSIS transformations such as Conditional Split, Derived Column etc.,
which did Data Scrubbing, including data validation checks during Staging, before
loading the data into the Data warehouse.
Applied ETL to implement the Slowly Changing Transformation, to maintain Historical
Data in Data warehouse.
Created SSIS script tasks, look up transformations and data flow tasks using T- SQL
and Visual Basic (VB) scripts.
Created ETL packages with different data sources (SQL Server, Flat files, Excel
source files, Oracle) and loaded the data into target tables by performing different
kinds of transformations using SSIS.
Experienced in creating package dynamics by using SSIS expressions and variables.
Created SSIS packages to extract data from OLTP to Data warehouse systems and
scheduled Jobs to call the packages and Stored Procedures.
Performed Documentation for all kind of SSIS packages.
Developed logging for ETL load at the package level and task level to log number of
records processed by each package and each task in a package using SSIS.
Created reports using SSRS based on business requirements.
Developed drill down, drill through, and parameterized reports using SSRS
Created reports and scheduled using SSRS to support Financial Planner to deliver
informational sales presentations to potential clients
Developed various operational Drill-through, Drill-down, and linked reports using
SSRS
Developed different kind of reports such a Sub Reports, Chars, Matrix reports, and
Linked reports
Designed, deployed, and maintained of various SSRS Reports in SQL Server.
Environment: SQL 2008, Visual Studio 2008, SQL server Integration Services(SSIS), SQL
server Reporting Services(SSRS), MS Office 20
Contact this candidate