Jai Rajora

Summary:

> Hands on experience in working of MS BI stack of SQL Server (SSIS,

SSAS, SSRS) versions 2012, 2008 R2 and 2005 (BIDS).

> Expertise in gathering of information pertaining to data requirements

and transformations in order to initialize a solid implementable and

repeatable process.

> Proficient in data Extraction, Transforming and Loading (ETL) using

SQL Server Integration Services (SSIS) tool. Extracting data from one

or many data systems, applying a series of rules or functions on the

extracted data to derive it in the end target and finally loading the

data in the end target or destination.

> Following through the ETL life cycle starting from the process of

initiating the cycle, building reference data, Extracting (from

sources), Validating, Transforming (cleaning, applying business rules,

checking for data integrity, create aggregates or disaggregates),

Stage (load into staging tables, if used), Audit reports, publishing

(to the target tables), and finally to archiving and cleaning up.

> Active role in designing, development and deploying of SSIS Packages

for building high performance data integration solutions.

> Expertise in writing of T-SQL queries (DDL and DML) which is utilized

in construction of tables and normalization techniques on database

tables.

> Expertise in creation of Entity Relationship Diagrams (ERD) using

Microsoft Visual Studio 2010 to the proposed database, explaining and

linking the tables concisely while maintaining referential integrity,

data integrity and column integrity.

> Experienced in creation of databases and database objects such as

tables, views, complex stored procedures, triggers, indexes and

breakpoints.

> Expert in defining of relations of attributes between tables by

identifying and defining primary keys in addition to relational

foreign keys during the creation of tables in order to maintain

thorough uniqueness.

> Experienced in development of content and visually rich reports in SQL

Server Reporting Services (SSRS) like tabular, matrix, list, chart,

gauge, and map.

> Experienced in using creation of advanced analytics dashboards,

datasheets using Tableau desktop. Connecting one or more data sources

to a report as required.

> Designing, creating, and managing multidimensional cubes that contain

data gathered from other data sources (relational databases) and

Online Analytical Processing (OLAP) by using SQL Server Analysis

Services (SSAS).

> Experienced in defining data sources, data source views, dimensions,

attributes, attribute relationships, hierarchies, and cubes in

Analysis Services project within SQL Server Data Tools. In addition to

usage of run time error handling and event handling.

> Experienced in usage of Microsoft BI tools like Power View, Power

Pivot, Power Query, Power Map which are utilized to retrieve, analyze,

and to finally display the data in a well-defined visual form.

> Excellent analytical, professional written and verbal communication

skills and interpersonal skills.

> Ability to work independently or as part of a team to fulfill critical

business objectives.

Education: Bachelor of Science (B.Sc.)

Skill Set:

MS SQL Server 20012, 2008 R2 SQL Server Integration Services (SSIS), SQL

Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS),

AS/400 - formally renamed the IBM iSeries, MS Visual Studio 2010, Tableau

Desktop 8.0, 8.1, and 8.3. Tableau Server, Tableau Reader, Tableau Public.

Projects Summary:

Sapient Global Markets-Houston, Texas 07/2014-

Present

ETL Developer and Reporter

Sapient Global Markets is a marketing and consulting company that provides

business, marketing, and technology services to clients. It is considered

as the leading provider in the world to offer integrated advisory, program

management, analytics, technology and operations services exclusively to

capital and commodity market participants and regulators.

Responsibilities:

> Extensively worked with SSIS tool suite, designing and creating

mappings using various SSIS transformations like OLEDB command,

conditional split, lookup, aggregator, and multicast and derived

column.

> Expertise in using various kinds of joins (Inner Join, Outer Join,

Left Outer Join etc.) and sub-queries to simplify complex queries

involving multiple tables.

> Created Database Objects - Schemas, Tables, Indexes, Views, User

defined functions, Cursors, Triggers, Stored Procedure, Constraints

and Roles.

> Extracted data from various sources like SQL Server 2008/2012, .CSV,

Excel and Text file sources, alongside from various other servers,

creating a centralized data warehouse structure in their headquarters.

> Involved in Creation, Development and Deployment of SSIS packages in

SQL Server 2012 and SQL Server 2008 R2.

> Created logging for ETL process at package level and task level to log

the number of records processed by each package and each task in a

package using SSIS

> Performed and fine-tuned stored procedures and SQL queries and User

Defined Functions (UDF).

> Wrote SQL queries using Joins and Sub queries and Functions to

retrieve data from data sources.

> Familiar with OLAP cubes and fact table, star and snowflake schemas,

building multi-dimensional cubes and KPIs for decision makers using

SQL Server Analysis services (SSAS).

> Developed different types of Tabular, Matrix (Cross Tab or Pivot)

Reports, Chart and Graphs, reports that aggregate data, reports that

contain parameters and group, reports containing totals and subtotals,

drill-down reports and ad-hoc reports using SQL Server Reporting

Services (SSRS) and Tableau in certain instances.

Environment: MS SQL Server 2012, 2008 R2, SQL Server Integration Services

(SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services

(SSAS), Microsoft Visual Studio 2010, Tableau Desktop 8.3, Tableau Public.

Deloitte- Philadelphia, Pennsylvania

03/2013- 07/2014

BI Developer

Deloitte is the brand under which tens of thousands of dedicated

professionals in independent firms throughout the world collaborate to

provide audit, consulting, financial advisory, risk management, tax and

related services to select clients. In Deloitte I was involved in their

risk management team handling a set of Fortune 500 companies which thereby

involved integrating their data in Deloitte's local data warehouse,

creating a structured database and analyzing data further and creating

reports on findings in order to reduce their risk in the markets they were

involved in.

Responsibilities:

> Designed and developed SSIS packages to import data from various

sources such as Excel, Flat Files, ODBC and OLE DB sources.

> Developed ETL specifications, source to target mappings and other

documentations that were developed for the ETL development.

> Implemented various transformations using Audit, Fuzzy Look-up, Multi-

Cast, Column Conversion and Term Look-up etc. to enhance the whole ETL

process.

> Usage of event handlers, error handling, coding, troubleshooting and

performance tuning SSIS packages that were developed.

> Involved in development and design of OLAP cubes, fact tables,

dimensional tables and KPI efficiently using SQL Server Analysis

Services (SSAS).

> Worked in developing of complex Stored Procedures, Functions, User

Defined Functions, Triggers, Views and TSQL statements.

> Experience in designing Logical and Physical Modeling using ERWIN and

ER Studio.

> Developed complex reports such as Tabular, Matrix, Sub Reports,

Charts, Drill Down reports etc. to depict the necessary analysis

required, with various functions such as parameters, filters, row

count, document mapping etc. using SQL Server Reporting Services

(SSRS).

> Developed visually rich reports using Tableau 8.1 focussing on market

trends, customer sales and forecasting alongside showing

country/state/region wise sale analysis and growth analysis and

finally comprising them in a dashboard.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS), Tableau 8.3, Tableau Reader, Tableau

Server.

Wells Fargo, Washington, DC

02/2012- 03/2013

Role: ETL Developer and Reporter

Responsibilities

> Deep involvement in usage of T-SQL Statements (DDL and DML) for

altering tables, inserting new columns, creating temporary tables,

joins and writing stored procedures in SSIS packages for improving

overall performance.

> Created Logging, Break Points, Check Points, and used Error Handler in

SSIS and automating the ETL process.

> Created cubes for Dimension and fact tables for future and current

reporting using SQL server Analysis Services (SSAS).

> Built MDX queries for Analysis Services & Reporting Services.

> Worked as a developer in creating complex Stored Procedures,

Functions, Triggers, Views and complex SQL statements for applications

> Developed Custom Functions, Manual Running Totals and Complex Formulas

for reports and further used calculations, sorts, filters and sections

to enhance data presentation in reports.

> Used Tableau Desktop for visual analytics, creation of KPI's for top

management and preparing dashboards using calculations and parameters

in Tableau.

> Created datasheets, dashboards and stories for all the functional

areas including Finance, Change Management, Order Management,

Pricing, Purchasing, HR, Demand Planning and Sales/Marketing

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS, Tableau 8.1 and 8.3, Tableau Public,

Tableau Server.

KPMG- New Jersey 08/2010-

02/2012 ETL Developer and Reporter

KPMG is one of the leading companies amongst the Big Fours (Deloitte, PWC

and Ernst and Young being the other three). Its operations are divided into

three major areas of Audit, Tax and Advisory. I worked in the Risk and

Compliance team, under the main head of Advisory. My project in KPMG was

mainly focused upon data integration and report generation for use within

the organization and for their various clients.

Responsibilities:

> Was part of a team working on their ETL and complex reporting needs to

support their client requirements and catering to the forensic

services.

> Assisted seniors and managers in the analysis of the collected data

and interpreting them in conformity to client specifications in order

to derive correct and best possible outcomes.

> Direct involvement in requirements gathering, analysis, design,

development, change management, deployment and final stage of

reporting to the required clients.

> Developed SSIS packages, bringing data from various sources such as

Excel, SQL server, flat files, for the daily load in order to generate

and maintain a centralized data warehouse.

> Used various data transformations like conditional splitting, fuzzy

lookup, multi cast, column conversion, fuzzy grouping etc. to meet

specified needs and requirements.

> Extensively used joins and sub-queries to simplify complex queries

involving multiple tables and to merge data of multiple tables to

create a concise form of database.

> Analyzed the specific needs and requirements as provided by the

clients and gathered the necessary requirements for design and

development completion.

> Used Data Definition Language (DDL) and Data Manipulation Language

(DML) for writing triggers, break points and check points.

> Error/event handling and performance tuning of SSIS packages for a

more optimized running environment.

> Making of breakpoints to review the status of the data and to

configure and fix the error upon notification.

> Created matrix, chart and tabular forms of reports using SQL Server

Reporting Services 2012/2008R2.

> Designed and deployed reports with drill down, drill through and drop

down menu options and parameterized and linked reports.

> Used Tableau for certain clients to make comprehensive dashboards

consisting of multiple sheets of comparison and detail.

> Scheduled and deployed reports using SSRS to generate weekly, monthly

and quarterly reports including current status if required by the

client or the management meeting strict deadlines.

Environment: MS SQL Server 2012, 2008 R2, SQL Server Integration Services

(SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual Studio 2010,

Tableau, K-Check (KPMG's screening tool to identify key risks and

improvement areas).

VERTEX India PVT. LTD- Gurgaon-India

04/2009- 08/2010

Business Intelligence Unit Reporter

Vertex is one of the leading company in the BPO, Customer Management

Outsourcing and IT Services industry. Serving over 200 clients worldwide

across many sectors, providing a broad range of outsourced solutions in the

UK, USA, Canada and India that help deliver exceptional customer

experience.

Responsibilities:

> Worked closely with my manager in analysis of business markets, new

sectors, and existing clients to create a concise database for upper

management to overlook.

> Generated matrix, tabular, and chart reports consisting of current

market trends and analysis in UK wherein the company could venture and

expand its services to.

> Involved in gathering, extracting and loading data on local database

warehouse and ensuring creation of a solid structure in order to have

a smooth transition till the last stage of the process.

> Used SQL Server Integration Services (SSIS) to load data largely

predominantly from excel files to local database and added

transformations over it to meet the requirements.

> Incorporated various functions and specifications on reports such as

adding parameters, filters on reports.

Environment: MS SQL Server, 2008 R2, SQL Server Integration Services

(SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual Studio 2008.

Contact this candidate