Default profile banner
Pankaj BatraPB

Pankaj Batra

@pankajbatra

Software Engineer Senior Analyst at Accenture Pvt Ltd.

East Delhi - 110051

Accenture Pvt Ltd.GGSIPU

Pankaj Kumar Batra is an IT professional with over 4 years of experience in the Analysis, Design, Development, Testing, and Implementation of ETL and Business Intelligence solutions. He specializes in using Database, SQL Server, MSBI, and Power BI. His expertise includes working with SSRS, SSIS, and SSAS, and implementing automation using tools like UIPath. He possesses excellent knowledge of SDLC methodologies including Agile, Scrum, and Waterfall.

Experience

Software Engineer Senior Analyst ( SSRS/ DB Administrator)

Accenture Pvt Ltd.

Nov 2020 - Present

Gather Report requirements and determining the best solution to provide the result in Reporting Service Report. Involved in complete SSRS life cycle in creating SSRS Report, building, deploying and executing the package in both the environments (Development and Production). Responsible for task estimation, review of requirements specification and development of low/high level technical design. Key Member of the Support Team which involved direct contacts with the Client for the requirements and function of the core team to help them migrate from On-Premise environments to Azure Cloud Environment. Hands-on experience on MS SQL Server 2016/2012, SSIS,SSRS and SSAS while working as MS SQL Server Developer on enterprise and performance-critical applications. Experienced with Automation Tools like UIPath and Advanced Excel and automated numerous Tasks to enhance project quality and performance.

Application Development Analyst Project - AON H&B AMS ( Cloud Solution / L2 Support)

Accenture Pvt Ltd.

Jan 2018 - Nov 2020

Create detailed design and implementation specification for complex products/application/solutions. Help client identify workloads migrating to Microsoft Azure. Supporting Finance Team in managing their provisional, annual budget and reporting per service / application. Implemented Critical Audits and Leavers Process performed weekly/monthly with the Client. Automated the same using UI Path / Advanced Excel which enhanced efficiency along with 0% Error. Practice of Documenting every new process, recording Demo and build runs on SharePoint (For KT and Audit Purpose). Responsible for identifying Used Cases and creating structure to automate using various tools and technologies for Optimum Utilization and Cost Control.

Education

GGSIPU

B-Tech

CBSE

Jan 2012

Senior Secondary

CBSE

Jan 2010

Higher Secondary

Licenses & Certifications

Microsoft Certified Trainer

Issued: Jan 2021Expires: Jan 2022

Skills

Database Administrator
SSRS
Power BI
Microsoft SQL Server
RPA (UI Path)
Team Management (L2 Support)
Reporting
Data Analyst
Microsoft Certified Trainer
SSIS
SSAS
Advanced Excel
Agile
Scrum
UML
Waterfall