Pankaj Kumar
Business Analyst & Finance System Support
Gurgaon
Summary
PROFESSIONAL SUMMARY
An overall experience of 8+ years’ Experience (Production Support+ Data Analysis) benefited from a diverse range of perspectives to create Value and Drive results for clients. Create end to end mapping for flow of data between different upstream and downstream systems. Perform Back end Testing using SQL queries, generate reports to ensure data integrity and validation Expertise in creating and executing test plan to address Unit, Functional, System, Integration, Regression and User Acceptance Testing (UAT). Experience in Data Analysis, Release & Change Management, Service Delivery, and Incident management. Experience on support in Production environment, Give on-call support in production environment on project related issues during the Month End Submission and Quarter End.
Overview
9
9
years of professional experience
5
5
years of post-secondary education
Work History
Business Data Analyst
Virtusa Technology
Thane
01.2022 - Current
- Currently Multi- heterogeneous product processors feed to Optima .The Business Requirement is to move from multi source to single source of allData By Means of the GENESIS Data Warehouse System.The Goal of the GENESIS Data Warehouse System is to define and Build a common pool of contracts, positions, customer account balances and associated reference data . it is based on a common data model and agreed.Data standards , for consumption by all Citi systems across Finance , Risk& Compliance and any other unit Requiring such data. it will simplify the overall Data processing by replacing intermediate data stores and enabling more straight-through processing .
- Role and Responsibilities:
- Developed, wrote and communicated business requirements and functional specifications for implementation of business solutions, Gathering and Analyzing Business requirements of project and transmitting of same to development team
- Providing Analytical Support to Regulatory programs by interpreting regulatory guidelines and translating them to arrange for Data required for reporting Resolving business queries as part of Business as Usual (BAU) support And works with Business Users for Sign off Assisted with business case development by conducting research and collecting data
Assistant Manager
HSBC
Gurgaon
09.2018 - 01.2022
- Engaged in Regulatory Reporting, Preparing Reconciliation for Regulatory Users
- Ensure ongoing reporting and analysis support for seamless service delivery of FED
- Regulatory Reporting requirements to various onshore partners as per agreed service levels
- Involved in compliance audit and prepared the audit data as per requirements
- Collaborating with various teams to ensure smooth monthly/ quarterly end close
- Preparation and updating of SOPs and maintained the monthly issues log for management
- Preparation of Operational Timelines for Monthly basis to avoid the Delay
- Coordinating with the IT team to help them to remove the bugs and failure throughout the submission
Software Engineer
HCL Technologies
Mumbai
01.2016 - 09.2018
- I worked with Nomura as Consultant and Support Engineer at Nomura
- I have received appreciation multiple times from Users for developing Solving problems in less time spam (Appreciated many times for less Turnaround), I have garnered experience of dealing directly with clients to capture requirements and to ensure that the proposed solutions.
- Roles and Responsibilities:
- Managing 23 UNIX base applications on Nine environments (Middle office, Settlement System and Accounting System) across 3 continents
- Monitoring/Debugging/Updating Autosys overnight batches and Jobs
- Working on Autosys jobs that are required for all the Services of UAT environments
- Did feasibility studies and made reports on the working of services that suits the project requirement
- Releasing all the deployment to the next level of UAT as per the requirement from the user
- Creating Monthly and Weekly matrix for Environment Management.
System Engineer
Polaris Financial Technologies Ltd
Thane
12.2014 - 01.2016
- Projects (LRR- London Regulatory Report AND FINHUB)
- This is a Production support project, this project includes Batch Monitoring in Autosys and solving User queries related to the reports generated with the batch processing
- Roles and Responsibilities:
- Thoroughly involved in the feasibility studies and implementation of several business components and all the testing related Services
- Level 2 Support, development and maintenance of existing job scripts
- Automating the support process by writing Shell scripts
- Debugging the shell scripts and Database Procedures
- Autosys JIL development
- Interacting with Client on a daily basis
- Keep a close watch on Post-Production issues
- Platform: Putty, Sybase Central.
Education
Btech - Computer Science And Programming
Shri Krishan Institute of Education And Technology
Kurukshetra 08.2009 - 09.2013
Diploma In Advance Computing - Computer Engineering
Sunbeam Institute
Pune 02.2024 - 08.2024
Skills
SCM Tools : Service now, JIRA
Environment : Autosys
SQL and databases - oracle,sybase
Data analysis ,Data Validation ,Data visualisation
Tools- SQL Devloper Tool,Power Bi, Power Query,GitHub,Git,Docker
Job Functions : Release Management, Data Analysis & Quality and Batch Monitoring, Proficient in analyzing huge data sets and explaining patterns, breaks and data compliance Hands on with writing SQL queries and using Spreadsheet functions to Extract, Analyze and Synthesize the data
Timeline
Diploma In Advance Computing - Computer Engineering
Sunbeam Institute
02.2024 - 08.2024
Business Data Analyst
Virtusa Technology
01.2022 - Current
Assistant Manager
HSBC
09.2018 - 01.2022
Software Engineer
HCL Technologies
01.2016 - 09.2018
System Engineer
Polaris Financial Technologies Ltd
12.2014 - 01.2016
Btech - Computer Science And Programming
Shri Krishan Institute of Education And Technology
08.2009 - 09.2013