Prasad Kshirsagar

Project description : IWatch is a Western Union proprietary case management application that provides compliance officers, investigators, and analysts the ability to create and/or review information about a subject or group of subjects for the purpose of investigation, assessment, and intelligence maintenance

IWatch application was created in response to requirements from the Global Compliance organization and is intended to serve as a single “source of truth” for compliance activities globally including those compliance user groups

An iWatch case can be for any subject such as an Agent, a consumer, geography, or a group/network of Agents and/or Consumers

Skills: Data Modelling, Data Analysis, Data integration, Data governance, Data Validation, Query Optimization & Tuning, Data Warehousing, Automated DB deployments

Tools: IBM DB2 11.1, PostgreSQL, Snowflake, AWS S3, RunDeck, TFS, Git Hub, Liquibase, Ansible, Unix Shell scripting, Putty, WinSCP, DynaTrace, IBM Data Server Monitoring, JIRA, LucidChart

Responsibilities:

• Serving as a DB Technical SME for database-centric development & DB Design of Moderate-to-high complexity
• Leading key business critical projects in the capacity of a Data Architect and Advisor
• Drive and collaborate with vendor teams for data management, Data Strategy initiatives & data clean-up activities
• Provide Solution designing, Technical architectural design for implementation of new business requirements
• Work on the POCs to migrate the on-prim data to Snowflake & AWS Cloud DB as a part of application modernization
• Proactively identify performance critical DB operations and optimize them
• Implemented the Tool for DB performance monitoring and setup up a mail alert mechanism for Server Health Check, Long running sessions, CPU & Disk Utilization, which proves to be extremely useful for proactive & automated monitoring of DB servers
• L2 level design & code reviewing as a part of Architecture Review Board (ARB)
• Carry out the Production DB Code Deployment as a part of CI/CD
• Troubleshooting and resolving the deployment issues in QA, UAT & PROD releases
• Review business requirements and technical design documents to develop effective data and database solutions
• Mentoring & providing technical guidance to the junior associates
• Publishing the Knowledge articles in TFS Wiki for all team members to refer
• Conducted the sessions to brief automated DB deployment process for entire compliance engineering team
• Troubleshoot issues and coordinate issue resolution with operations, functional, technical & DBA teams.

Project Description: The objective of LCDB Upgrade (Legal & Compliance Database) project is to decommission the legacy environment by completing the infrastructure migration to a new platform to align with the strategic direction set by business & IT Central architecture

Scope of the LCDB platform project also includes Database migration, Performance tuning & Testing for LCDB Database, which includes activities like

• Oracle Upgrade approach for huge DB of 24 TB and 49 schemas
• Preparation of Database performance testinng plan
• Database & Data Validations post DB migration
• Database performance testing

Tools : Oracle 10g & 11g, PL/SQL Developer, Informatica 9.5.1, Control M, JIRA, HP ALM Explorer

• Tectia Client, Putty

Responsibilities:

• Work with stake holders in gathering business requirements for Database migration needs
• Assist in designing, planning & managing the data migration process
• Actively involved in database performance testing planning & implementation
• Address & fine tune multiple areas/processes where DB performance is poor
• Facilitate appropriate documentation for performing testing & necessary steps to be taken in order to enhance the DB & application performance
• Manage assigned risks & monitor potential impact as a part of data migration plan
• Develop & follow best practices, processes & standards to effectively carry out the data migration activities
• Perform migration and validation of Static & transactional data
• Keep track and consolidate the changes done on all environments to apply during production release
• Co-ordinate with different stake holders with multiple upstream and downstream during testing
• Co-ordinate with CS DBA for all environments setup and help them for DB parameter setup & DB validation
• Provide extensive technical support to all Testing cycles from Dev till UAT

Project description: This project includes continuous improvement of UBS applications through analysis, optimization, and automation.

This project includes continuous improvement of UBS applications through analysis, optimization, and automation.

Under this project, Wipro provides Business Analysis, Application Development, and Level 2 & 3 Application Support Services, as described to UBS WM&SB IT, Analytical Processing, and Data Warehouse for the applications in scope of the APR Managed Service.

In this project, over 120 applications are in scope, single sourcing of analytical data and reporting, providing management information for financial and risk control, operations, and sales support, and a competence center for analytical/business intelligence tools and tool engineering.

Skills: Data warehouse development, Database Migration, Oracle PL/SQL, Shell scripting, Cognos query writing , Performance management, Providing automation solutions, Providing L2 & L3 support, Managing new demands, Managing & Co-ordinating Production releases with different teams located at different locations, Resource Handling & capacity planning, Project management, Maintaining client relationship

Tools : Toad, SQL Developer, Tortoise SVN, OLU (Open LAN Unix) Packaging, ASIMON, QVT Term, ServieNow (SNOW), JIRA, Redwood monitoring tool, Reflection workspace, UltraEdit

Responsibilities:

• Working on big demands to set-up the entire new application from scratch for UBS Wealth Management
• Translating business requirements into technical specifications
• Designing, documenting, implementing and deploying changes in the Oracle database
• Offering suggestions for improvements to the database landscape; providing support in resolving production incident; developing database enhancements using SQL and PL/SQL (tables, views, packages) for various systems in a multi-instance Oracle environment
• Serving as a Technical Lead for database-centric software development requirement of Moderate-to-high complexity, Involved in ETL processes, DWH development, maintenance & support activities
• Providing conceptual solution design; understanding and tuning complex SQL queries to address performance issues
• Keeping technical & functional track of the project
• Resolving production incidents & tickets by coordinating with Business Analyst & End User

Project Description : Compliance Risk Assessment was a tool to improve the current annual Compliance Risk Assessment process and enhance current Compliance Risk Assessment system

The CRA was the Bank’s formal, proactive annual process, which provided the framework for Compliance Coverage Officers to formally assess the overall compliance and regulatory risks associated with a particular desk, business, legal framework or other applicable area

The CRA was undertaken by Compliance globally, and it was one of several tools used by compliance to identify potential areas of compliance risk in the business, which assisted compliance management in planning the compliance objectives for the coming year.

Skills : Oracle, Pl-SQL, SQL, Data Modelling

Tools : PL/SQL Developer, Toad, SVN, HP Quality Center.

Responsibilities:

• Mapping development releases and production support of Credit Suisse DB
• Worked on implementing the new requirements and reaching the goal on time.
• Interacted with the client to get the business requirement and to prepare the impact analysis document for the same
• Led database design for the new enhancement; creation of Packages, Stored Procedures, Functions for the newly developed application as well as fixing of defects and enhancements in the whole application
• Facilitated the implementation of project through appropriate documentation; reviewed database design for the whole project
• Managed release scripts for smooth Prod releases; maintained the version control of the source code and tracked the changes made
• Developed numerous Stored Procedures and scripts for Data extraction and manipulation
• Prepared the SAD document & data model from the existing Physical database
• Received client appreciation CS client partner for CRA 3.8 release

Project description : The purpose of this project was to extract the finance & telecom billing data (prepaid & post-paid) through various Interfaces

Once the data extraction was done, process the data to pass a consolidated entry into the SAP system.

Monitored the databases for all India 23 telecom circles & ensured that the data posting was in time into SAP system.

Skills : Oracle 10g, Pl-SQL, UNIX Shell Scripting, Sap Net weaver, Performance Optimization

Tools: PL/SQL Developer, Toad, SQL*Loader, SQL Developer, SAP Portal, SSH FTP Client, Putty, SAP Redwood monitoring tool, BSCS telecom system, BMC Remedy IT Service Management Suite

Responsibilities:

• Development of Oracle SQL, PL/SQL code to apply all the necessary checks/validations on the order and to interact with different Interfacing components.
• Creating the telecom billing interface by understanding and implementing business logic involved in the order. (E.g. BSCS, ePOS, iPOS, Hyperion)
• Performance tuning of the code to enhance the telecom interface performance.
• Support the Oracle Hyperion database for Financial Consolidation and Budgeting process as a part of month-end closure activity.
• Extraction of finance & billing data through Interface & passing it to SAP XI.
• To work on New or Existing technical module to cater new requirement coming as form of CR
• Provide support for various testing phases and Level 2 & 3 support.
• Created a new interface for HR module which takes care of all the claims submitted by employees & post the consolidated entry into SAP system.
• Enhancement of current code base so as to increase the performance and maintainability of project.

Project Description: The purpose of this project was to transition the Public Records data loading/reformatting process from Onsite personnel to Offshore Development Centre (ODC) personnel with Onsite personnel as Leads. The project would focus on the ODC to assist onsite Leads in populating the Public Records database based on changes made by the data providers.

Tools : PL/SQL Developer (5.1.4), VPN Web Portal, Smart FTP Client, QVT Term 5.1, HP Quality Center, FileZilla, Visual FoxPro.

Responsibilities :

• Achieved cost-savings by developing functional solutions to problems.
• Created an automated process to download and upload raw data to the database at a defined time.
• Prepared several PL/SQL processes to check the database health and email the status.
• Worked at the client location onsite on the production database, successfully releasing a new business report tool for CT Lien Solutions.
• Created users, schemas, tablespaces, tables, indexes, views, sequences, synonyms, database links, system, and object security, and privileges.
• Performed hot and cold backups on Oracle databases.
• Documented all database configurations, interfaces, scheduled jobs, issues, resolutions, and procedures for all assigned projects/applications.
• Worked on SQL Loader to load raw data by converting into txt file UNIX macro altered and executed to complete entire data loading process