PANKAJ BANKEY

E-mail id : acgewe@r.postjobfree.com

Mobile : +91-741*******

S UMMARY

• 2 + years of IT experience in Microsoft Business Intelligence tools like SSIS, SSRS.

• Good working Knowledge on ETL Process using SQL Server Integration Services (SSIS),

SQL Server Reporting Services (SSRS).

• Proficiency at Data Transformations, Tasks, Containers, Sources and Destinations like

Derived Column, Conditional Split, Sort and Merge Join and ROW COUNT Transformations

and Execute SQL Task to load data into OLEDB Destinations.

• Good understanding of RDBMS concepts and experience in writing Complex Queries,

Sub queries, Derived tables, Co-related Sub query, CTE, Views.

• Experience in providing Error Logging and Event handling for SSIS Packages using

SMTP Configuration and Execute Sql task.

• Having good knowledge on creation and scheduling of SQL server agent jobs to run daily

ETL’s.

• Experienced in Configuring on creation and scheduling of SQL server agent jobs to run

daily ETL loads.

• Worked with parameterized reports, Drill-Through reports, sub reports, matrix SSRS

2005/2008.

• Ability to rapidly learn new concepts and technology together with excellent interpersonal skills.

TEC H N ICAL SKI LLS

Technologies : Microsoft Business Intelligence Tools (MSBI)

Operating Systems : Windows XP/Windows7.

Databases : SQL Server 2005/2008/2012.

ETL Tools : SQL Server Integration Services

Reporting Tools : SQL Server Reporting Services

Other tools : TFS/STFS/SVN/MANTIS/SharePoint/Spotlight

WORK EXPER IENCE

Currently Working as Software Engineer in MARLABS, Bangalore from September

2012– Till date.

EDUCAT ION

Bachelor of Engineering (Computer Science) from Rajiv Gandhi Technical

University Bhopal, Madhya Pradesh, India.

C ERT IF ICAT ION & TRAI N I NG

• Professional training 4 months (September 2012 to December 2012) In Marlabs

All BI CONCEPTS, DATABASE SQL SERVER, SQL SERVER INTEGRATION SERVICES (SSIS),

SQL SERVER REPORTING SEVICES (SSRS).

• OCJP (ORACLE CERTIFIED JAVA 1.6 PROFESSIONAL).

• Certification of Merit by HCL k2 academy on ‘C ’ & JAVA Technology, Database.

• Advance Diploma in Computer Application with “A+” grade.

PROJECTS

Project #1

Laureate BI, Laureate Migration 2012

Project :

Client : Laureate International University, USA.

Role : BI Developer.

Environment : SSIS, SQL, SEVER 2008,SQL SERVER 2012.

Duration : January 2014 to till date

Description

Laureate is a group of universities spread across the globe. ETL process is a complicated

system that is scheduled to runs over the night so that the Reports are available for the business in

the morning. We support the team from off-shore during the ETL run and also develop and test

the ETL packages.

I was the part of Laureate Migration team. And we migrated SSIS Packages from version 2008

into 2012

Roles and Responsibilities:

• Involved in ETL processes to load Fact and Dimensions tables.

• Involved in ETL testing for various data files.

• Involved in package configuration and job scheduling.

• Involved in daily ETL support process.

• Developed SSIS package to load the data from various source files to staging data warehouse.

• Involved in various procedure testing to load the data from staging data warehouse to development Data

Project #2

Project : Endurance BI

Client : Endurance, USA.

Role : BI Developer

Environment : SSRS, SSIS, SQL SERVER 2005/2008

Duration : August 2013 to December 2013

Description:

Endurance is Insurance and Reinsurance client and it is to provide the

underwriting business with improved operational reports that have been

standardized as much as possible across all Professional Liability Lines of Business.

Endurance build loyalty through responsive and consistently high-quality

underwriting, actuarial, legal and claims services through Professional Liability

Business Unit and delivery mechanisms as well. Standardized data definitions

across the various Professional Liability lines of business will additionally increase

the comparability of underwriting reporting overall.

Roles and Responsibilities:

• Developed various claim reports for insurance and reinsurance.

• Involved in report testing with different parameter.

• Created SSRS parameterized reports in different format pdf format and Excel format in which we

are giving different parameter and generating Reports.

• Developed different sections of reports on summary level and detail level.

Project #3

Project : Ad Council BI

Client : Ad Council Cross Media Analytics Solution, USA.

Role : BI Developer.

Environment : SSIS, SQL SERVER 2012.

Duration : January 2013 to July 2013.

Description:

The Ad Council is a private, non-profit organization that marshals volunteer talent

from the advertising and communications industries, the facilities of the media, and

the resources of the business and non-profit communities to deliver critical

messages to the American public. The Ad Council produces, distributes and

promotes public service campaigns on behalf of non-profit organizations and

government agencies in issue areas such as improving the quality of life for

children, preventive health, education, community wellbeing and strengthening

families.

Roles and Responsibilities:

• Involved in ETL processes to load Fact and Dimensions tables.

• Involved in ETL testing for various data files.

• Involved in package configuration and job scheduling.

• Involved in Error Analysis for tracking error files records and for analyze the data.

• Can identify bugs and fix them quickly.

• Created SSIS package and load the data from varies source files to staging data warehouse.

• Created procedure to load the data from staging data warehouse to development Data warehouse.

EXTRA CURR ICULAR ACTIV I T IES

Member of Newsletter and cultural event organizers committee in current organization.

PERSONAL I N FORMAT ION

Date of Birth : 20 February 1988

Father’s Name : Mr. Hariom Bankey

Linguistic Abilities : Hindi, English

Permanent Address : 120, Kasarni, Th-Rahatagaon Dist-harda (M.P.) India.

Hobbies:

Playing chess, Pool, Table Tennis, drawing.

Achievements:

Certified with OCJP (ORACLE CERTIFIED JAVA 1.6 PROFESSIONAL).

Declaration:

All the above information provided above is true.

Place: Bangalore (Pankaj Bankey)

Contact this candidate