Resume

Sign in

Sql Server Data

Location:
Cary, North Carolina, United States
Salary:
60/HR
Posted:
January 26, 2018

Contact this candidate

Resume:

ac37bw@r.postjobfree.com 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