Summary
Overview
Work History
Education
Skills
Certifications
Core Competencies
Affiliations
Certification
ADDITIONAL RESPONSIBILITIES:
Timeline
AssistantManager

Priyadarshini Kotagi

Summary

Oracle 11g Oracle Certified Associate. ITIL V3 certified. Experience in Oracle Database Administration. Experience in Oracle Pl/Sql coding and Crystal reporting. Have been to Onshore – Singapore for transition of Credit Risk applications. Hands-on with SQL, PL/SQL, UNIX Shell Scripting.

Experienced with team leadership, operational management, and customer service excellence. Utilizes strategic planning and problem-solving skills to enhance team productivity and service quality. Track record of fostering a collaborative and adaptable workplace.

Experienced with team leadership, operational management, and customer service excellence. Utilizes strategic planning and problem-solving skills to enhance team productivity and service quality. Track record of fostering collaborative and adaptable workplace.

Management professional with track record of effective team leadership and operational oversight. Consistently achieves goals through collaborative efforts and adaptability to changing demands. Skilled in conflict resolution, process improvement, and fostering positive work environment.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Assistant Manager

VISPL(Vodafone India Shared Services Private Ltd)
10.2017 - Current
  • Due to migration of postpaid customers from old systems to new stack there are several rating issues occurs in billing. To avoid overcharging usages are checked day before billing. Identify overcharging and provide correct credit to customers.
  • Development of PL/SQL and UNIX scripts for credit analysis process
  • Creating ad-hoc database Objects like tables, Stored Procedures, functions, Packages, Cursors, Functions as per the Business requirements.
  • Credit Management: Analyzing bills of customer and correction of charges depending on different bundles and products.
  • Checking Customer related Information in Siebel and sending Siebel check report.
  • Performance tuning using Index on table.
  • Automating credit report jobs using Shell Scripting ,which is EOD activity
  • Involvement in generating the reconciled PDF reports from the QlikView dashboard, analyzing the misalignments in customers data, analyzing the data quality issues and sending them to the intended stakeholders with highlights of the major issues.
  • Involvement in preparing and maintaining the prepay and post pay reconciliation trending report and graphs which is presented to the business.
  • Participation in weekly QlikView Business Meetings and to present the analysis for major hikes or dips in the graphs generated from the reconciliation reports
  • Project: Pre - Bill Credit management
  • Client: Vodafone UK
  • Hardware: Unix
  • Software: Oracle, QlikView and Abinitio

Application support Analyst

Dell Inc.
01.2017 - 09.2017
  • Continuity & Availability Management along with Client & Vendor management. Playing decision making challenges in Demand, Capacity & Resource planning.
  • Acted as Application Guardian. Responsible for 24/7 uptime for entire system.
  • Working on Oracle, Sybase based databases and UNIX environment on day to day basis.
  • Good with Shell Scripting, Job Scheduling – Autosys (R11) & Crontab.
  • Interacting with third party application owners (Vendors) and negotiating on Application Architecture considering bank feasibility, external support etc.
  • Liaison between the business and the delivery (CTB) team to understand business dynamics and identify questions that can be addressed.
  • Provide feedback on critical success factors with regards to the success of the release and consistently deliver high-quality and error free releases, reports to the business.
  • Communicate expectations and establishes deadlines in agreement with CTB and Support Team.
  • Delivering well organized data analysis through reporting, dashboards, modeling and trend analysis
  • Managing assignments with minimal intervention support.
  • Managing self and support the team in learning and execution of the projects/releases especially during extended hours.
  • Root cause / trend analysis , pro-actively review changes that have adversely impacted production environment and take action to ensure that this is not repeated
  • Pro-actively seek ways to provide a better service (e.g. automation of repetitive tasks, new products or enhancements, maximization of service availability)
  • Involvement in specification, testing and implementation of new applications from Support Prospective
  • Act as a point of escalation and/or reference for the L1/L2 Support team in order to minimize the impact of incidents and problems and maximize service availability. Use technical and analytical expertise and knowledge of systems to resolve problems internally or through external parties that cannot be resolved by GSD Support team within specified service levels and which are escalated for further investigation
  • Liaison between the business and the delivery (CTB) team to understand business dynamics and identify questions that can be addressed
  • Enclosed with fully upstream (order management tools) to downstream flow (accounting and posting).
  • Delivering well organized data analysis through reporting, dashboards, modeling and trend analysis. Create / maintain overall project release documentation including issue trackers / delivery trackers / resource utilization.
  • Work across time zones.
  • Project: Prime Brokerage (PB)
  • Client: UBS Bank (client Location)
  • Technology used: UNIX, SQL, Autosys
  • Software: UNIX, Windows XP, Oracle9i, Oracle 10g

Application support analyst

Dell Inc.
11.2015 - 12.2016
  • Project mainly deals with the trading by the internal traders and bank RCO's (Risk Credit officers). Also, involves authorized officers to analyze the market data/statics of different counterparties.
  • CREDIT RISK IT applications involve checking the pre-deals before the actual trading. Booking the pre-deal and confirm before the actual trading is done and to rate the various counterparties according to the company performance and based on the ratings of various clients/companies/counterparties trades perform trading.
  • Involving in high priority issues raised during the trading period and help users to resolve the issue and to get the trading back in track.
  • Accountable Resource management and having day to day meetings with the team for proper progression of work.
  • Accept and analyze faults logged for application and also Develop workflows for production major issues and enhancements.
  • Autosys Job Monitoring and resolving for proper batch processing with in SLA.
  • User Problem Management: User interactions through mind align, Group channels, phone and mail to get more details for a fault.
  • Liaise with Design/development and test team for issue resolution and new requirement as a part of releases and new changes.
  • Develop and provide the work-around for the issues developed in the application work-around which helps to fix the issue meanwhile provides bandwidth to Dev team to permanently fix the issue. This in turn keeps the business running uninterrupted.
  • Project: Credit Risk IT
  • Client: UBS Bank (Singapore & Pune)
  • Environment used O/s: UNIX, SQL, Autosys
  • Software: UNIX, Windows XP, Oracle9i, Oracle 10g

Oracle Database Developer

Dell Inc.
02.2014 - 10.2015
  • This project involved creating crystal reports, queries, functions and performance tuning. The project involves creating reports for healthcare client.
  • Developing PL/SQL scripts for various modules involved in the application according to client requirement.
  • Create simple and complex queries for crystal reports.
  • Query tuning and performance tuning.
  • Creating crystal report based on business requirements.
  • Oracle Database Creation.
  • User/Schema Management (Creating and managing users, profiles, privileges and roles)
  • Configuring Listeners, TNS names and SQL
  • Net
  • Working on data ware house for creating queries.
  • Project: CHPW
  • Client: XCELYS-IKA
  • Environment used O/s: Windows
  • Software: Oracle 10g Database Server, Oracle 11g Database Server.

Database Administrator

Dell Inc.
07.2011 - 01.2014
  • Enterprise Rent-A-Car (ERAC) is one of the major car rental companies in the USA. ERAC has partnered with PSC to enhance their existing car rental application ECARS 2.0 to suit their business requirements by adding new functionalities.
  • Creating, dropping, upgrading various databases on RAC and non-RAC hardware.
  • Oracle 11g installation on various OS.
  • Refreshing Development and Test databases from Production.
  • Applying latest PSU, One off patches.
  • Allocating system storage and planning future storage requirements for the database system
  • Maintain backups of databases using RMAN
  • Have been responsible to troubleshoot and monitor all the database activities and have successfully provided solutions in the minimum possible time.
  • Responsible for Design & Write package, procedures, functions etc.
  • Developing PL/SQL scripts for various modules involved in the application.
  • Interaction with onshore team for requirement gathering and solving their technical problems.
  • Project: RENTAL FINANCIAL SYSTEM
  • Client: Enterprise Rent-A-Car
  • Hardware: Intel Pentium O/s: Aix, Linux 6.2
  • Software: Oracle 11g Database Server.

Education

SSC -

CBSE

HSC - undefined

Karnataka board

B.E - E&C

VTU

Skills

  • Agile Project Management Tools: Jira, Confluence, Rally, Azure DevOps (ADO), VersionOne, Planview, Trello, Smartsheet, Miro, Mondaycom
  • Collaboration Tools: Slack, Microsoft Teams, Zoom, Mural
  • Metrics & Reporting: Power BI, Excel Dashboards, Burndown/Burnup Charts, Cumulative Flow Diagrams
  • CI/CD & DevOps Tools: Jenkins, Git/GitHub/Bitbucket, Kubernetes
  • Testing Tools: Selenium, Postman, TestNG, Cucumber BDD
  • Databases: SQL, MySQL, PostgreSQL, MongoDB
  • Cloud Platforms: AWS, Azure, GCP
  • Other: MS Office Suite, SharePoint

Certifications

  • Scrum & Agile
  • Certified Scrum Master (CSM)
  • Professional Scrum Master I/II (PSM I/II – Scrum.org)
  • SAFe® 6.0 Scrum Master (Scaled Agile)
  • SAFe® Agilist / SAFe® Advanced Scrum Master (SASM)
  • LeSS Practitioner (Large-Scale Scrum) (if applicable)
  • Kanban Practitioner Certification
  • Project Management
  • Project Management Professional (PMP – PMI)
  • PMI-ACP (Agile Certified Practitioner) (good-to-have)
  • Testing & Quality
  • ISTQB – Foundation Level
  • Lean Six Sigma Green Belt
  • Technical (Optional / Bonus)
  • Salesforce Admin/Developer (Internal/Org Cert)
  • Automation Testing / Java Internal Certifications

Core Competencies

  • Agile & Scrum Methodologies (Scrum, SAFe, LeSS, Kanban, XP)
  • Servant Leadership & Agile Coaching
  • PI Planning, Release Planning, Sprint & Program Increment Management
  • Scrum Ceremonies Facilitation (Planning, Daily Standups, Reviews, Retrospectives, Demos)
  • Stakeholder Management & Client Engagement
  • Backlog Grooming, Prioritization & Story Writing
  • Scaled Agile Transformation & Organizational Change Management
  • Conflict Resolution & Impediment Removal
  • Agile Metrics & Reporting (Velocity, Burndown, Burnup, Cumulative Flow, Cycle Time)
  • Continuous Improvement, Retrospective Action Tracking
  • Risk Management & Dependency Management
  • Cross-functional Team Leadership & Collaboration
  • Coaching Product Owners, Developers, and Junior Scrum Masters
  • Delivery Management (Budget, Scope, Schedule)
  • Business Value Delivery & Customer-Centric Mindset

Affiliations

  • Project Management Institute

Certification

  • Technical Certification
  • ORACLE: Oracle Database 11g Administrator Certified Associate (OCA)
  • Oracle PL/SQL Developer Certified Associate
  • ITIL: V3 Certified Professional

ADDITIONAL RESPONSIBILITIES:

Playing key roles in Vendor Management, Release Management, Yearly Release Planning, DR Implementation plans (Operational Efficiency Program).

Timeline

Assistant Manager

VISPL(Vodafone India Shared Services Private Ltd)
10.2017 - Current

Application support Analyst

Dell Inc.
01.2017 - 09.2017

Application support analyst

Dell Inc.
11.2015 - 12.2016

Oracle Database Developer

Dell Inc.
02.2014 - 10.2015

Database Administrator

Dell Inc.
07.2011 - 01.2014

HSC - undefined

Karnataka board

B.E - E&C

VTU

SSC -

CBSE

Similar Profiles

CREATE PROFILE
Priyadarshini Kotagi