PIYUSH KUMAR

Contact No: +91-821*******

Mail ID: adbmy2@r.postjobfree.com

CAREER OBJECTIVE:

To keep myself updated with the latest advents in the field of Information Technology through the work assigned to me and to make myself valuable to the organization I would be associated with.

EXPERIENCE SUMMARY:

Having 3 years of experience in Microsoft Business Intelligence (T-SQL, SSIS, SSRS, SAP Crystal Report) Development using SQL Server 2012.

Having experience on creating Database and tables.

Experience in store procedures, indexes, joins, views, constraints.

Working experience on creating various SSIS packages.

Working exp. On all ssis task

Working exp. On all SSIS CONTAINERS .

SSIS Configuration and deployments .

Working experience on various transformations such as Aggregate, Conditional Split, Copy Column, Derived Column, Data conversion, Lookup, Multicast, Merge, Sort, Row count, Union all etc.

Tasks such as Control Flow Task, Dataflow Task, Execute SQL Task, Execute Package Task etc. in Integration services development.

Involved in Creating the Reports like Tabular Report, Matrix Report, Chart Report, Drill Down Report,group Report, sub Report and Drill Through Report based on client requirements.

Created Parameterized Reports and Cascading Reports.

Also Created Single Valued and Multi Valued Parameterized Reports in SSRS.

Having experience in Deployment and Email Subscription of SSRS Report.

DASH Board ssrs report with dynamic columns

SSRS Report with dynamic color depending on risk or sale

Reporting service configuration manger,set up of ssrs report server.

Bulk upload of ssrs report on server and bulk download ssrs report.

Experience in SAP Crystal Report .

PROFESSIONAL EXPERIENCE:

Company : Processware system Pvt.Ltd

Designation : Report Developer.

Duration : October 2018 – Till date

TECHNICAL SKILLS:

·Technologies : Microsoft Business Intelligence Tools(MSBI)

·Databases : SQL Server 2012, SQL Server 2016

·ETL Tools : SQL Server Integration Services 2012

·Reporting Tools : 1. SQL Server Reporting Services 2012

2. SAP Crystal Report

3. ssis

·Operating Systems : Win 7, win 8, Win 10.

EDUCATIONAL QUALIFICATION:

Bachelor of Technology from Kalasalingam University, Tamilnadu.

PROJECT PROFILE:

PROJECT TITLE : BankSoft

CLIENT : CO-operative bank of India

DURATION : October 2018 to till date.

ENVIRONMENT : SQL server 2012,SSRS, Report Builder,SAP Crystal Report.

Description:

BankSoft – Core Banking Solution is a comprehensive solution aimed at meeting the requirements of the financial institutions. Built on latest technology platform, the solution offers unparalleled scalability and security to banks. Mobile banking solution is completely integrated into BankSoft Core Banking Solution. The user will be able to view all their accounts and perform necessary transactions on the mobile. The application can be downloaded on to the mobile device and then used to access the details of their bank accounts. Banksoft has designed and developed a comprehensive Internet Banking application to enable users to carry out financial transactions using the browser. The solution has been developed using secured protocols to ensure the safety of information flowing through the browser.

Roles & Responsibilities:

Worked on report server configuration manager for configuring the FTP report and scheduling it.

Creating share data source and share scheduling time on report server configuration manager.

As per requirements developed the reports in the form of Table, Matrix and Chart using SQL Server Reporting Services.

Creating and modifying report using crystal report.

Also Involved in Report Enhancements and Bugs resolving in Created Report.

Generated the Daily, Weekly, and Monthly basis Reports as per the client requirements.

Involved in Deployment and Email Subscription of SSRS Report.

Creating new SP and modification of old SP.

Company : Medhaj Tecno Concept

Designation : Project Engineer.

Duration : March 2017 – September 2018

PROJECT TITLE : MMVSNY

CLIENT : NBPDCL

DURATION : March 2017 to Oct2018.

ENVIRONMENT : SQL server 2012,SSRS, Report Builder,SSIS.

Description:

The objective of this project was for electrification in Bihar. To achieve this Mukya mantra Vidut Sambhand Nishay Yojana has been launch in the state in two Discoms (NBPDCL And SBPDCL). Total 2.4 Crore household survey and electrification has to be done .For this android based Mobile application has been developed . Application has been installed in surveyor phone and TKC employees. surveyor collect data of consumer by using mobile apps. Many reports like total application, rejected application, approve application,pending for approval bill of a customer was available for proper business and use.

Roles & Responsibilities:

Extensively working in Data Extraction, Transformation and Loading from Source to Target system using SQL Server Integration Services.

Creating SSIS Packages using Control Flow and Data Flow Components.

Used transformations like Conditional Split, Aggregate, Derived Column, Copy Column, Lookup, Sort, Merge, Data Conversion etc.

Also worked on Execute SQL Task and Execute Package Task.

As per requirements developed the reports in the form of Table, Matrix and Chart using SQL Server Reporting Services.

Designed Parameterized Reports. And cascading reports

Also Involved in Report Enhancements and Bugs resolving in Created Report.

Generated the Daily, Weekly, and Monthly basis Reports as per the client requirements.

Involved in Deployment and Email Subscription of SSRS Report.

Bangalore Piyush Kumar

Contact this candidate