Experienced IT Professional: Boasting over 15 years of broad experience in various banking domains.
Technical Proficiency: Expertise in Oracle SQL/PLSQL, BCM Testing, Python programming, and Oracle Performance Tuning. Skilled in Bash Shell scripting and comfortable working in Windows/Linux environments.
Quick Learner: Demonstrated ability to quickly explore and master new technologies and concepts.
Problem Solver: Proven track record in analyzing and resolving complex technical problems.
Monitoring Tools: Experienced in integrating AppDynamics and proficient as a Splunk power user.
Change and Incident Management: Successful in identifying, analyzing, and resolving complex technical issues, demonstrating proficiency in Change, Incident, and Problem Management.
Leadership: Proven leadership skills with the ability to manage teams, delegate tasks, and foster collaboration.
Business Application Support: Experienced in gathering business requirements and translating them into effective IT solutions.
Efficiency Improvement: Proven success in implementing automation strategies to reduce toil and enhance efficiency.
Strategic Thinker: Known for a strategic and analytical approach, coupled with a commitment to continuous improvement.
Framework Knowledge: Proficient in Agile, DevOps, and ITIL frameworks.
Business Alignment: Recognized for aligning technology initiatives with business goals, delivering measurable outcomes, and contributing to the overall success of the organization
Overview
16
16
years of professional experience
7
7
Certifications
Work History
Associate Director
UBS LLC
10.2018 - Current
Collaboration: Fostered strong relationships with development groups and business operations teams, ensuring software production is efficient, reliable, and scalable to deliver valuable data to clients.
Regulatory Compliance: Reviewed and analyzed proposed regulatory changes, assessing their potential impacts on business operations and implementing necessary adjustments.
Task Management: Effectively prioritized tasks and allocated resources, maintaining team focus and productivity.
Risk Management: Identified and assessed risks associated with team activities, implementing strategic procedures and automation solutions to mitigate potential issues.
Performance Enhancement: Boosted employee performance through targeted training programs and regular feedback, leading to increased productivity levels.
User Interface Development: Developed intuitive user interfaces, simplifying navigation within complex applications for non-technical users.
Efficiency Improvement: Enhanced organizational efficiency by automating repetitive tasks using advanced scripting techniques across various applications.
System Maintenance: Reduced system downtime by proactively identifying potential issues and implementing preventive measures.
Resource Optimization: Optimized resource allocation by thoroughly assessing project requirements, prioritizing tasks, and assigning appropriate personnel, ensuring timely completion of deliverables.
Release Management: Established a structured release management process, increasing predictability and reducing the risk of failure.
Stakeholder Engagement: Boosted stakeholder satisfaction by actively engaging in change management projects and ensuring their needs were met.
Incident Analysis: Gathered and analyzed data from resolved incidents to prevent future occurrences.
Performance Tracking: Tracked Key Performance Indicators (KPIs) and developed continuous improvement plans to enhance operational efficiency.
Software Dev. Advisor
NTT DATA Formerly Dell Services
05.2014 - 09.2018
Optimizing SQL Queries: Proactively tuning complex SQL queries to enhance system performance and prevent potential issues.
Collaboration: Collaborating closely with Middle Office and Trade Support teams to gather open client mapping requests.
Batch Monitoring: Diligently monitoring EOD and SOD batches to ensure timely completion and prevent business impact.
Incident Management: Effectively handling business-impacting incidents and preparing comprehensive Root Cause Analysis reports.
Client Onboarding: Working on new client onboarding requests, including testing the locate flow as part of the pre-locate process.
On-Call Support: Providing reliable weekend on-call support to address any EOD batch failures.
Teamwork: Working in tandem with Product Development Groups to implement new requirements requested by the business stakeholders.
Report Generation: Generating detailed reports for approved & rejected locate requests from various sources based on client/desk requirements.
Feed Transfers: Setting up feed transfers to external client locations using Tumbleweed.
Issue Resolution: Responsibly handling all business queries/issues reported by the trading desk, ensuring swift and effective resolution.
Senior Application Developer
APAR Technology
09.2013 - 03.2014
Change Oversight: Collaborated with the change oversight team to identify and vet changes in aligned applications and infrastructure, ensuring optimal performance and stability.
Design Reviews: Conducted comprehensive design reviews for new projects, providing detailed design documents to guide development.
Coding Implementation: Implemented coding solutions by writing stored procedures, functions, packages, and various database objects as per project requirements.
Testing & Documentation: Authored test cases, performed unit testing, and maintained technical documents to ensure software quality and maintainability.
Automation: Developed shell scripts to automate long-running tasks, enhancing efficiency for level 1/2 teams.
SQL Optimization: Tuned complex SQL queries to optimize performance and prevent potential issues.
Data Parsing: Utilized DBMS_XMLDOM & DBMS__XMLPARSER packages to parse XML data into database objects based on various business conditions and validations.
Database Management: Worked closely with system DBAs for database sizing, storage, and backup management, ensuring data integrity and availability.
Data Loading & Validation: Loaded flat file data into staging tables using SQL Loader and performed validations to ensure data accuracy.
Technical Leadership: Acted as an escalated technical resource, providing application and technical knowledge, and leading calls as appropriate.
Incident Management: Engaged in high-impact or complicated events, providing technical leadership to facilitate faster resolution.
Troubleshooting: Performed troubleshooting on reported issues, implementing fixes to prevent major outages and ensure system reliability.
Process Leadership: Provided technical and process leadership to ensure the Problem Management process identifies the true root causes of incidents.
CAR Ownership: Took ownership of Corrective Action Requests (CARs) to close critical process and technology gaps for Technology Infrastructure (TI) related issues.
Root Cause Analysis: Ensured true root cause is identified for aligned applications and recurring or problem areas are addressed.
Data Quality: Ensured data quality and accuracy for problem records owned by the POD, including impact capture and CAR assignment.
Coordination: Coordinated with multiple interface teams to successfully migrate application changes and technical upgrades within time and budget constraints.
Solution Evaluation: Evaluated proposed solutions, identified any limitations in the existing system, and suggested workaround procedures and methods to overcome deficiencies as corrective, perfective, preventive, and adaptive measures.
Senior Software Analyst
Dell Perot Systems & Cognizant Technology Solution
06.2009 - 09.2013
Change Requests: Implemented Change Requests (CRs) in adherence to Software Development Life Cycle (SDLC) methodologies, ensuring seamless software modifications.
SQL Queries: Authored and optimized complex SQL queries to extract deployment history data from the database, enhancing data accessibility.
Data Loading: Loaded Single File Distribution (SFD) setups into the database using SQL Loader, streamlining data management processes.
Database Maintenance: Conducted daily/weekly database maintenance activities, including purging six-month-old data from the Production Database and verifying/resetting table/index statistics using the DBMS_STATS package in the SRL infrastructure.
Deployment Support: Assisted deployment teams in preparing Make files and resolving issues with ANT scripts, facilitating smooth user builds.
Release Management: Supported the release management team in resolving issues during manual production deployments, ensuring successful software releases.
On-Call Support: Provided weekend on-call support for major/critical production release activities, ensuring system stability and user satisfaction.
Configuration Management: Managed Repository configurations, including setting up Subversion and IBM Rational Clearcase in both UNIX and Windows environments.
Scripting: Authored and implemented hook scripts (shell scripts) for pre-commit/post-commit actions for Subversion repositories in line with UBS policies.
Triggers: Developed and implemented triggers for Pre-Checkout/Post-Checkin actions for Clearcase vobs, enhancing version control.
Repository Migrations: Handled SVN repository migrations between regions in response to infrastructure space issues, ensuring data integrity.
Repo Management: Created Subversion repo dumps and loaded them into destination repos along with history, preserving important data.
Clearcase Vobs: Created Clearcase vobs based on user requirements, tailoring version control to project needs.
Vob Archival: Performed Clearcase vob archival and broke replica relationships, managing data lifecycle.
Vob Restoration/Migration: Executed restoration/migration of Clearcase vobs based on user requests, ensuring data availability.
Incident Reports: Conducted Root Cause Analysis (RCA) and prepared incident reports for any business impact issues, promoting continuous improvement.
Autosys Jobs: Managed and monitored Autosys jobs via Autosys commands, ensuring task automation and efficiency.
Software Engineer
CES India Pvt Ltd
09.2008 - 06.2009
Development Process: Led the development process for the Case Fill Rate (CFR) Application, ensuring successful implementation within the stipulated deadline.
Debugging: Actively involved in debugging shell scripts and PL/SQL procedures in the new CDW environment, ensuring optimal system performance.
Stored Procedures: Authored stored procedures to validate data in the new database location, enhancing data integrity.
Package Modification: Modified existing package bodies in line with the new data available in Production, ensuring system relevance and efficiency.
Migration: Managed the migration of Express instances from the CDW environment to the ADW environment, ensuring seamless transition and minimal downtime.
Excel Macro: Prepared an Excel Macro for uploading Meta Data in AWM, streamlining data management processes.
Environment Migration: Participated in the migration from the CDW environment to ADW, including the creation of necessary OLAP Cubes, OSA Cubes, Tracker Reports (Standard Tracker), and Web OSA Reports.
Job Scheduling: Prepared the CMFast file for job scheduling in ControlM, optimizing task management and efficiency.
Migration List: Prepared the Migration list for transitioning from Development to QA, ensuring smooth progression through the development lifecycle.
Education
Bachelor of Science - Mathematics
Andhra University
Visakhapatnam, India
Skills
Operating Systems: Windows 10/11, Linux RHEL6/7/8, Mainframes
undefined
Certification
Azure Fundamentals (Az-900)
Timeline
Associate Director
UBS LLC
10.2018 - Current
Software Dev. Advisor
NTT DATA Formerly Dell Services
05.2014 - 09.2018
Senior Application Developer
APAR Technology
09.2013 - 03.2014
Senior Software Analyst
Dell Perot Systems & Cognizant Technology Solution