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)