Summary
Overview
Work History
Education
Skills
Training
Languages
Timeline
Generic

Pankaj Sharma

SCHOFIELDS (NSW),NSW

Summary

Insightful Technical Business Analyst known for high productivity and efficient task completion. Possess specialized skills in data analysis, process improvement, and requirements gathering that ensure successful project outcomes. Excel in communication, problem-solving, and teamwork, leveraging these soft skills to bridge gaps between technical teams and business stakeholders for streamlined operations.

Overview

17
17
years of professional experience

Work History

Technical Business Analyst

Colonial First State, CFS
07.2023 - Current
  • CFS is Australian wealth management group that provides investment, superannuation and retirement products to individuals and corporate and superannuation fund investors
  • Digital – Carve Out and Foundation
  • Digital foundation initiative’s purpose is to curve out, transform and secure the digital business and bring in modernization in terms of delivery, operations, and technology to enhance the digital user experience
  • In May 2020, CBA announced the sale of 55% of CFS to KKR as part of CBA’s strategy to focus on its core banking business and a simpler and better bank, while allowing CFS to become a more focused standalone business and deliver a wide range of the benefits for members
  • Digital Carve out and foundation is a program that is running in parallel to the Digital BU to carve out all the digital and user facing entities so that the user experience can be given priority
  • Working as a cross BA among separate pillars within foundation (IP foundation & Testing foundation)
  • Roles and Responsibilities:
  • Requirement gathering on gaps in testing discipline that allows the achieve better quality application support for customers
  • Help analyze and stabilize test automation regression pack refinement to achieve its goal for 100% efficient
  • Implementing Universal password requirement which will enable UAT user to reduce their dependency on password reset and will help overall reduce waste of ~40 days of effort per year trying to reset password
  • Creating and running scenarios to understand the behavior of application to help design the solution
  • Creating High level solution design for the requirements
  • Creating detailed solution page to capture the requirement
  • Estimating the build and timeline with the help of developers
  • Support development activates and unit testing
  • Creating implementation plan/ Rollback plan/ Communication plan for a solution
  • Help and coordinate with team during deployment process and perform BVT
  • Working as an SDM and running daily scrum stand-up with team
  • Creating delivery plan and highlighting dependencies
  • Resource management to achieve the deliver plan
  • Creating/ refine user stories in collaboration with Product owner and define the user acceptance criteria.

Lead Engineer

United Nations
03.2012 - Current
  • United Nations High, for Refugees (UNHCR), also known as The UN Refugee Agency is a United Nations agency mandated to protect and support refugees at the request of a government or the UN itself and assists in their voluntary repatriation, local integration or resettlement to a third country
  • Focus application is used to launch a full web based system to monitor the UNHCR plan tracking with relation to operation and bureau
  • Global focus is the reporting tool based on IBM Cognos BI platform to generate the reports for end users
  • Responsibilities:
  • Proactively providing resolution to all the activities under the focus manage services contract, which includes all the daily PL/Sql process incidents, service requests and problem requests
  • All DBA related activities backup issue, Database migration to Oracle 11G
  • LANDesk monitoring and server management handling C-2 level incident and other recurring incidents
  • LANDesk SLA-report creation on SQL-server
  • Involved in 4 critical tracks under UNHCR project
  • Installed and configured Oracle Database on Window Server on Development
  • Involved in performance monitoring and tuning of the database
  • Involved in backup and recovery tasks using RMAN
  • Involved in creation, installation, maintenance and administration of Databases in WINDOWS Platforms
  • Managing the production database for Oracle Server and resize the space of database/Datafiles/Tablespace/Transactional Logs
  • Creating, Updating, Altering Tablespace, Indexes, Tables, Views, Synonyms, Profile, Role, Privileges
  • Creating/Managing users profiles and analyzing their privileges and tablespace quotas
  • Strong experience in administration and database monitoring
  • Good experience in Oracle Migration from 10g to 11g Databases
  • Implemented database backups and disaster recovery strategies using RMAN
  • Developed technical documentation for disaster recovery
  • Work beyond regular hours based on business demands
  • Provided 24x7 on-call production support
  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
  • Worked on SQL
  • Loader to load data from flat files obtained from various facilities every day
  • Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements
  • Involved in the continuous enhancements and fixing of production problems
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD
  • Created indexes on the tables for faster retrieval of the data to enhance database performance
  • Involved in data loading using PL/SQL and SQL
  • Loader calling UNIX scripts to download and manipulate files
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL
  • Plus
  • Partitioned the fact tables and materialized views to enhance the performance
  • Extensively used bulk collection in PL/SQL objects for improving the performing
  • Extensively used the advanced features of PL/SQL like Records, Tables, Object types andDynamic SQL
  • Oracle Web services setup and using the same to communicate with Adobe life cycle
  • Creation of Oracle XML DB and extensively worked for PL/SQL XML generation
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
  • Designed and developed Cognos Framework Manager Models and packages
  • Extensively working on Cognos 8.4 (Query Studio and Report studio) as report developer
  • Defined, Prompt page and maintained in Report studio of the projects
  • Balanced priorities to best meet demands of multiple projects
  • Designed Drill-through reports and Dash board reports
  • Created List reports, Cross-tab reports
  • Create different type of charts like Column charts and Bar charts
  • Have Administration experience in Cognos 8.2/8.4/10.2 and applied data level and user level security for Framework Manager Packages, reports
  • Automated Reports and generated documents using Scheduler
  • Created projects, models and published packages in Framework Manager
  • Involvement in administration of Cognos packages and reports
  • Supported change management controls and validation process
  • Provided continuous ad-hoc customer support in information and reporting services
  • Achievements:
  • Single handed Worked for Implementing Partner project implementation, which include the complete budget and partner information to be provided to external adobe life cycle system from oracle database in the form of generated oracle XML with the help of Oracle 11G webservices
  • Involved in critical Oracle database upgrade activity, which is production database switching to 11G
  • This activity required a high-level design preparation, Deployment documentation and DB scripts for the switch activity
  • Environment creation of Oracle 11G for PIP project
  • Database migration and setup for local database which include the dump from production and restore to local environment
  • Successfully configured the Oracle webservices for the PIP project
  • Configured the Invoking and exposing of web-services from agila through Pl-sql
  • Performed the Patch up gradation for all the Non-prod and Prod environment couple of time
  • Got client appreciation for the high-level design creation
  • Monitoring the DB servers and performing DBA activities
  • Software Used : Oracle 11g, SQL & PL/SQL, Windows, Java, LANDesk, Jenkins, Cognos
  • Oracle 11g, SQL
  • Plus, TOAD, SQL
  • Loader, SQL Developer, UShell Scripts, UNIX, Windows XP Clint : UNHCR, Switzerland
  • Monitored performance metrics to assess the effectiveness of system modifications and upgrades.
  • Analyzed customer feedback data to improve user experience for future product releases.
  • Coordinated testing efforts between multiple teams during product launches.
  • Prepared estimates and budgets.
  • Maintained up-to-date knowledge of industry trends and advancements in technology.
  • Generated engineering documentation and oversaw design projects.
  • Utilized mathematical skills and understanding of engineering principles to design new products.
  • Administered hands-on instruction in basic maintenance, safety and troubleshooting procedures.

Senior Business Analyst

01.2023 - 06.2023
  • Breach Response (Information Security Strategy Portfolio)
  • A spate of recent, high-profile data breaches in Australia has elevated community and government concern about the cybersecurity of large organisations, and the measures they have in place to protect the sensitive information they hold
  • In response, ISG have undertaken work to review the Group’s internet-facing systems and the key systems that hold personally-identifying information (PII)
  • While the Group has invested significantly in improved cybersecurity controls over the last five years, recent events evidence a material increase in stakeholder expectations and external threats, in particular ransomware disruption, large scale data theft and sophisticated, destructive attack
  • Based on the information available to us, we assess that the recent Optus and Medibank breaches saw attackers exfiltrate sensitive data at scale from data stores by exploiting a combination of:
  • An unauthenticated Application Programming Interface (API)
  • Production data accessible in development systems
  • Insufficient control on supplier’ laptops/desktops
  • Insufficient multi-factor authentication control over Remote Access
  • Insufficient control over Privileged Access
  • Roles and responsibilities
  • Sensitive Data Protection – Masking
  • To uplift to data masking compliance (production data in development environments) remediating any remaining unmasked production data including resolving exemptions
  • Identify all systems that store government identifiers & personally identifying information
  • Discovery of Non-Compliant Applications
  • Crowdsourcing, analysis, and consolidating of data points to determine compliance status of highly protected and protected data in non-production environments
  • Engagement with application owners to determine compliance status per application
  • Recording application current compliance response for their masking status
  • Prepare data masking remediation Business Case
  • To provide centralized oversight, reporting, and governance to the application to be compliant with data protection
  • Prepare CIO data masking estimated sizing for application remediation
  • Sensitive Data Monitoring
  • Uplift data monitoring control effectiveness enabling detection and response to anomalous database activities
  • To prepare BRD for IBM Guardium Implementation for sensitive data monitoring
  • Guardium tool current limitation and future requirement feasibility assessment
  • In scope application and sensitive data identification per application
  • Preparing data monitoring alert scope by analysing current challenges for support team.

Business Analyst

Commonwealth Bank CommBiz
05.2022 - 12.2022
  • ESP Migration
  • Batch Management is to consolidate all the multiple scheduling tools within Westpac, across Enterprise Control-M, Treasury and Finance Control-M, SGB ESP and TWS, into a single Batch Operating Model
  • To-date Batch Management is operating on multiple scheduling tools with numerous service partners and operating models
  • These changes are set to achieve consistency, standardization, and cost reduction for batch management operations
  • The current multiple scheduler applications will be converted to an ESP enterprise batch scheduling solution
  • This will establish a single operating model for batch support and execution within Service Management
  • Roles and Responsibilities:
  • Business requirement gathering in relation to batch migration program
  • To Prepare BRD related to the operational requirement of the Enterprise batch program phases
  • Gathering Functional/ Non-Functional requirement
  • Gathering requirement for As-Is run the bank and change the bank processes
  • To gather the differences between As-Is and To-be processes in relation to migration
  • To gather Implementation Requirements in relation to phase release
  • Gathering Reporting Requirements in relation to batch migration program
  • Gathering Integration Requirements
  • Operational Requirements gathering and working as a batch BA for enablement stream to address and enhance current and future scope
  • To gather Access Requirements for multiple application users for each phase of batch migration
  • Carry out all change creation/approval and deployment in prod
  • Document review BRD/DTD/Test Plan by providing feedback comments
  • To create OGATE checklist document
  • SOP documents creation for Batch OPS and Batch Monitoring BAU team., Platform
  • Online business banking with state-of-the-art security features for businesses of all sizes
  • Creating package, procedure to send the customer insight date to Big data platform
  • Migration script preparation for ongoing front end .Net Application
  • Load assurance and data quality check process implementation
  • Error tracking and error logging process implementation
  • Database existing procedures tuning for long running process and job
  • Tuning API’s for dashboard better performance
  • All project related BAU task handling/scheduling jobs, supporting daily data load batches
  • Analyzing and solving all critical P1 and P2 stream issues on daily basis
  • Handling all project related backend support
  • Tools used Oracle SQL developer, MSBI, MS SQL Server 2008, Toad, Atlassian Bitbucket Cloud repository, Git Bash, Source Tree, Microstrategy, Java J2EE, Datastage, Stash, Putty
  • Unix, Control M, Github, Jenkins
  • Environment: IBM Infosphere DataStage 9.1 on Oracle 11g/12c, MS SQL Server 2008/2005, Teradata V15, BigData, Microstrategy, Java, JavaScript, Autosys, UNIX, JIRA, AGILE Scrum, Rally, Git Hub, Atlassian Source tree, Jira, Confluence

Analyst/Tech BA

DECC
08.2021 - 05.2022
  • Digital Early Cycle Collections PowerCurve Experian/ Covid 19 Customer Hardship
  • The program envisions customer assist – DECC (Digital Early Collections) on PCC (Powercurve Collections) will implement and pilot a SMS- triggered- microsite – i.e., SMS-ing late payment customer assistance website, this would allow customers to interact with the Westpac collections team noting payment, requesting more time to pay, requesting payment arrangements or requesting more assistance
  • This website will be available to customers without access to internet banking
  • This initiative would provide newly delinquent customers with a means to interact digitally with the bank, in a consistent manner across several product types
  • This program will provide significant operational saving (reducing outbound call volumes required during early cycle collections) and potentially reduce provisions for bad and doubtful debt through prompt collection of early delinquent accounts
  • Roles and Responsibilities:
  • Monitoring the DECC platform for its day-to-day functioning and to meet customer requirement
  • Performing daily Batch monitoring and data load from different collection source system to PowerCurve collection platform
  • Addressing any load errors/data mismatch/batch failure by analyzing and lysing with underlying support team for timely resolution and root cause identification
  • Solutioning of any data transformation or batch schedule condition change within Big data platform
  • Solutioning of any data load checks within the systems i.e
  • Data load assurance, data reconciliation
  • Solutioning of any automated system notifications for smooth monitoring of data load among various systems
  • Perform discussions with various underlying application for implementing better solutions
  • Production defect analysis with business and Experian SME’s
  • Suggesting solution approach with estimation on build/test/implementation
  • Responsible for timely test cycle to be completed and test evidence walkthrough with Business before any release
  • End to end tracking of Prod defects to the closure
  • Release plans creation for each future .(dot) releases
  • Carry out all change creation/approval and deployment in prod
  • Document review BRD/DTD/Test Plan by providing feedback comments
  • Raising Jira request to engage Big Data/Sterling for any new requirement or request
  • Single point of contact to Experian (PowerCurve Collection) for any defect/change request to provide estimation
  • Work with Experian Support for any P1/P2 or prod defects
  • Tracking all the defects and change request and provide the production delivery estimation to business
  • Operation readiness checklist document creation, handover of project deliveries to support team
  • Supporting covid-19 customer hardship application for daily data extracts and response from PowerCurve
  • Technology Involved:
  • Teradata, Big data, microsite, robotics, control M, Oracle, Confluence, Jira, Java

Engineer - Support Team Lead

BAE systems
05.2021 - 07.2021
  • FCS (Financial Crime System)
  • Detica – NetReveal, The program envisions to have a world- class global financial crime risk management capabilities that enables the Westpac Group to continue grow across the geography while remaining strong and delighted to customers
  • The system is enterprise-wide global financial crime risk management platform having robust policies, guidelines, training and risk assessment tools that follow the best practices
  • The product has capabilities ranging from flexible analytical tools, streamline reporting and automated workflow and processes
  • Role and responsibilities
  • Working as a team lead for L2 managed services
  • Daily health check and stream monitoring
  • Service level tickets analysis and resolution/follow-up with the concerned teams and third-party vendors
  • Product team (BAE) issue logging and weekly meetings on the progress for future resolutions
  • Daily Team meetings on backlog items and problem tickets for the resolutions
  • Involving in server patching and database patching, DR site failover activities and performing post implementation TVT
  • Assisting business with queries related to product and functionality
  • DB query creation for any business ad-hoc data requirement
  • Tools Used: Putty, Citrix, App dynamics, SQL Developer, Citrix, Splunk, Control-M, Jira, Confluence
  • Environment: Unix, Oracle, Java

Development DBA/Tech BA/ Scrum

Commonwealth Bank
10.2016 - 05.2021
  • DailyIQ
  • DailyIQ is an analytical platform for Institutional and Business Banking customers of Commonwealth Bank
  • It provides business insights to CommBiz and NetBank clients about their cash flow, performance, payment mix, industry benchmarking, foreign exchange projections, Local Economic projection and customer loyalty reporting and many more
  • The customers can compare trends and changes in your cash flow balance over time to identify risks and opportunities for your cash to work harder, Compare performance to industry Explore how sales, costs and profit compare to similar industry, Discover more about customers and find out who is most valuable customers are, and how demographics and spending habits change over time
  • Analyse consumer spending explore the economic impact of an event in your local area
  • Key Responsibilities:
  • Dealing with data integration between SAP, BigData, Teradata and Oracle
  • Database capacity planning, database design and modelling, table partition management
  • Writing complex queries for data analysis
  • Creating procedures for aggregating data for the front-end applications
  • Writing write back packages for user preference data received from Micro strategy
  • Managing Non-Prod database environments, User access management, data refresh among environment, data scrambling process for sensitive data
  • API procedure, packages build for new analytical tools to be consumed by front end java application
  • Creating package, procedure to send the customer insight date to Big data platform
  • Migration script preparation for ongoing front end application from Microstategry to Java
  • Load assurance and data quality check process implementation
  • Error tracking and error logging process implementation
  • Database existing procedures tuning for long running process and job
  • Tuning API’s for dashboard better performance
  • All project related BAU task handling/scheduling jobs, supporting daily data load batches
  • Analyzing and solving all critical P1 and P2 stream issues on daily basis
  • Handling all project related backend support
  • Managing source control and deployment on test, Dev, NFT,ST,SIT and production Environment
  • Developing SQL Server Stored Procedures and tuning SQL Queries (using Indexes and Execution Plan)
  • End to end Database migration from 11G to 12C platform
  • Import export data using oracle datapump utility
  • Documenting the releases and change request tracking
  • Creating deployment document manuals, master scripts for prod and staging deployments
  • Daily interaction with ops DBA’s
  • Perform code reviews, support during production developments, system testing, user acceptance testing and warranty support
  • Data analysis and sourcing of new source system data in the data warehouse to build new capabilities within the product
  • Performing technical business analysist role to understand the business requirement and provide the required data/understanding to the product owner, help build other system leveraging the current analytic data and how it can be beneficial for other business needs
  • Scrum Master Role to create Epics and sprints tasks and track the stories till the closure
  • Tools used Oracle SQL developer, MSBI, MS SQL Server 2008, Toad, Atlassian Bitbucket Cloud repository, Git Bash, Source Tree, Microstrategy, Java J2EE, Datastage, Stash, Putty
  • Unix, Control M, Github, Jenkins
  • Environment: IBM Infosphere DataStage 9.1 on Oracle 11g/12c, MS SQL Server 2008/2005, Teradata V15, BigData, Microstrategy, Java, JavaScript, Autosys, UNIX, JIRA, AGILE Scrum, Rally, Git Hub, Atlassian Source tree, Jira, Confluence
  • Achievements
  • Received Daily IQ achiever award for successful implementation of complex ICF(interest cost forecast) and LEI(Local Economic Insight) tools
  • Received A&I Platform nomination for best performing employee for a quarter.

Lead Engineer

HCL Technology
03.2016 - 01.2016

Shinsei bank
02.2011 - 03.2012
  • Team Size : 15 ACOM Financial Solution
  • This project is responsible for entire redesign of existing banking solution interpretation system for the ACOM CO
  • LTD
  • The largest banking solution provider at Japan
  • The system consists of modules like Application Processing System (APS), GUARANTEE, LOAN, COLLECTIONS, ATM, Generic, Interfaces, Infrastructure
  • It is an application for a Non-Core Banking System of a financial institution
  • Customer logs on to ACOM website to apply for LOAN
  • Only Unsecured Loans are provided through mail & Internet
  • The Entire process starts from LOAN Application to LOAN Approval, LOAN Document & AC Card sending process to customer & after that managing LOAN Installment/payment calculations & in case of Defaulter in payment then for COLLECTION from Customer also comes under this Entire Project
  • Responsibilities:
  • Working in the ACM/ATM team for new message development
  • Responsible for ACM (Automatic contract machine interface) messages from which inquiry about customer, card suspension, ATM guard release, pin enquiry operation can be done
  • Creating Functions, Procedures, Triggers, Views, Reviewing of Code
  • Creating XML Queries, Global Temporary Tables, XML Tables
  • Triggers, Stored Procedures for CIF/APS a 3-Tier Technical Architecture solution
  • Report Column Data mapping, Reports Layout Designing & Development
  • Functional study of the core module
  • Providing full support to the onsite team for implement the project and maintaining proper version of the components using IBM Rational clear case tool
  • Software Used : Oracle 10, PL/SQL, UNIX (Putty

Software Engineer

Nucleus Software Exports Ltd
01.2008 - 01.2012
  • PowerCARD Interface system with Shinsei bank(Credit card System)
  • It is a system of Credit card with the collaboration of Nucleus and HighTech Payment Systems (HPS) Morocco
  • The PowerCARD system is built on three tier architecture
  • The Client operates under any workstation using a Java enabled browser, The Data server operates under UNIX and uses Oracle 10g for the database, and The Application server operates under UNIX and uses Oracle Application Server (OAS 10g)
  • Responsibilities:
  • To analyze the Mainframe and Aplus Data to get the implementation logic
  • Share the business logics implemented in Aplus to HPS person and get it implement in PowerCard System
  • To upload the mainframe core data from different sources into PowerCard system (Oracle tables) using tools like SQL-Loader with defined logic and analyze the reasons for mismatches and missing if any found
  • Reconciliation between PowerCard processed data and Mainframe processed data
  • (R2 recon)
  • Based on rules and logic for calculation in Mainframe and Powercard the mismatched balance, payment, transaction is found out
  • Prepare the mismatches sheet and report it to HPS and Shinsei person
  • Send the extraction file as a end product to credit tracking system to track the opening and closing balance of current accounts along with credit worthiness and penalty reports for the defaulter accounts
  • Software, Putty)
  • Client : Shinsei

Shinsei bank
03.2009 - 02.2011
  • Team Size : 22 FinnOne Interface system with
  • It is a system of FinnOne (Lending) implemented in Shinsei Bank Co Japan
  • The Interface system are built based on the specific reports generated by the mainframe system as their end product, same objective is done with interface set up from the FinnOne System
  • Responsibilities: My roles and responsibilities are as follows
  • To Manage a Team as a team lead and interact with client in daily meeting for the project progress
  • To analyze the Mainframe and Aplus Data to get the implementation logic
  • To understand the requirement specification provided by the client for the interface implementation
  • To understand the specification to implement the Generation criteria for the Interface
  • The business logics implemented in the form of Packages, Procedure, Functions
  • To upload the mainframe core data into Interface system and analyze the reasons for mismatches and missing if any
  • Reconciliation between Interface processed data and Mainframe processed data.(R2 recon)
  • Prepare the mismatches sheet and correct the same in the logic in packages, procedure, function used for the development of the interface
  • To report issue related to Product team and client the issue which should be done from Mainframe (TIS)

Team Member

Nucleus Software
Mumbai
01.2008 - 09.2009
  • Team Size : 26 Loans Management System (LMS FinnOne)
  • A complete Loans Management Systems managing the loan right from the Customer acquisition stage to the Loan termination
  • It contains almost every aspect associated with the Loans in the Banking industry
  • An integral part of FinnOne suite
  • Various related modules are (Lending, GL, PDCMS, EOD, ADMIN, etc)
  • Responsibilities:
  • Analyse and prepare IAD, Program specification and Unit test cases on the basis of GAP and BRD
  • Writing code and preparing front screens according to program specification and do the Unit testing
  • Peer Review for codes, sanity testing, and SIT was also the part of responsibility
  • Preparing Understanding Document (UD) to developed understanding of system and train peers about the functionality in order to share knowledge and make the product more effective
  • Reviewed and monitored deliverables to ensure timelines are met
  • Software Used : Oracle Forms and Reports, SQL & PL/SQL, UNIX (Putty, Team Size : 35 BRS (Bank Recon System) Enhancement II Aug 2008
  • Enhancement in the existing BRS system, new report according to the requested need of the client has to be developed, new field in the existing front end screen, new screen according to requirement has been developed, and necessary back end changes
  • Responsibilities:
  • Creating new forms and reports for the new feature, PL SQL coding
  • Performance Tuning and Enhancements
  • Prepare related documents for the enhancements for the team and client
  • Software Used : Oracle Forms and Reports D2K, Oracle 10g, SQL & PL/SQL, UNIX (Putty) Client: Reliance, 6
  • GAAP ENHANCEMENT FOR INTERNAL CLIENT PM Oct 2008
  • Enhancement in the existing GL system to work according to generalized accounting principle, new report according the requested need of the client has to be developed , new field in the existing front end screen , new screen according to requirement has been developed , and necessary back end changes
  • Responsibilities:
  • Creating new forms and reports for the new feature, PL SQL coding
  • Performance Tuning and Enhancements
  • Prepare related documents for the enhancements for the team and client
  • Software Used : Oracle Forms, Reports D2K, Oracle 10g, SQL & PL/SQL, UNIX (Putty)
  • Client: PMG (Product Management Group) BRS (Bank Recon System) Enhancement III Feb2008
  • Enhancement in the existing BRS system new Reconciliation logic developed for the recon process, New reconciliation screen developed and new report according the requested need of the client has to be developed, new field in the existing front end screen and necessary back end changes
  • Responsibilities:
  • Creating/updating new/existing forms and reports for the new feature, PL SQL coding
  • Performance Tuning and Enhancements
  • Prepare related documents for the enhancements for the team and client

Associate Consultant

Westpac Bank Corp AU, TCS Australia PTY LTD

Team Member

Bajaj
Mumbai
  • Responsible for implement the performance benchmarking exercise to the product on a huge volume data
  • Get the ADDM report, Traces generated from oracle and apply tuning concepts wherever needed
  • Responsible for support on the issues from the client, which is marked as a Core Bug in the product
  • Responsible for support to onsite person during UAT and production.

Education

MCA -

Chandigarh Engineering College
Mohali
01.2008

Bsc - Computer Science, Majors

Gauhati University
01.2005

Higher Secondary (10+2) - Science

CBSE
01.2001

Secondary (10) -

CBSE
01.1999

Skills

  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12C
  • J2EE
  • NET
  • Oracle PL-SQL
  • XML Queries
  • SQL
  • SSIS
  • Oracle Forms
  • Reports D2K
  • Java
  • IBM Cognos
  • Bash
  • Windows Batch Scripting
  • Unix
  • Windows
  • System architecture design
  • Business administration
  • Big data technologies
  • Functional specifications
  • SQL proficiency
  • Software development life cycle
  • Business process modeling
  • Best practice development
  • Database design
  • Data analysis
  • Requirements gathering
  • Application programming interface
  • Data warehousing
  • Virtualization technologies
  • User acceptance testing

Training

  • .NET Programming
  • Oracle forms and reports
  • IBM Cognos

Languages

English
First Language

Timeline

Technical Business Analyst

Colonial First State, CFS
07.2023 - Current

Senior Business Analyst

01.2023 - 06.2023

Business Analyst

Commonwealth Bank CommBiz
05.2022 - 12.2022

Analyst/Tech BA

DECC
08.2021 - 05.2022

Engineer - Support Team Lead

BAE systems
05.2021 - 07.2021

Development DBA/Tech BA/ Scrum

Commonwealth Bank
10.2016 - 05.2021

Lead Engineer

HCL Technology
03.2016 - 01.2016

Lead Engineer

United Nations
03.2012 - Current

Shinsei bank
02.2011 - 03.2012

Shinsei bank
03.2009 - 02.2011

Software Engineer

Nucleus Software Exports Ltd
01.2008 - 01.2012

Team Member

Nucleus Software
01.2008 - 09.2009

Associate Consultant

Westpac Bank Corp AU, TCS Australia PTY LTD

Team Member

Bajaj

MCA -

Chandigarh Engineering College

Bsc - Computer Science, Majors

Gauhati University

Higher Secondary (10+2) - Science

CBSE

Secondary (10) -

CBSE
Pankaj Sharma