PHANI KRISHNA
IT Application Analyst
Summary
Over 9+ years of experience in the area of Infra and Application Support on Middleware applications like EMX, BPH, CXConnect, eReporting, EAI, IAG, GEB, PIB (personal internet banking), G3 clearing application and core banking by using UNIX, AS400, TIBCO, INFORMATICA, Oracle, SQL, PL/SQL, DB2, INFORMATICA/ETL, My SQL and Core Java in the Corporate & core banking domain comprising Equities and Derivatives
Overview
11
11
years of professional experience
1
1
Certification
2
2
Languages
Work History
Application & INFRA Analyst
BNP Paribas
Singapore
02.2022 - Current
- Performing root cause analysis for issues identified in PROD environment and provide permanent resolution for frequently occurring issues after reproducing issue in staging environment (SIT/UAT)
- Interacting with users and business for production issues and resolving them as per agreed SLA
- Developing and maintaining SQL's and automated shell scripts
- Supporting and maintaining environments for Production and UAT
- Maintaining code, building and releasing into SIT, UAT, and Production
- Regression testing the environment on every new release onto Production
- Maintaining batch jobs using tools Control-M and Autosys in Production Environment as per business requirement
- Monitoring ITSM queue, JIRA, and group mailbox for supporting user incidents on a daily basis within agreed SLA according to priority
- Planning and executing BCP, QMW, and DR Exercise according to organization standards
- Identifying manual tasks and reducing system alerts by deploying automation shell scripts
- Introducing new alerts and implementing periodic housekeeping jobs to improve Production stability
- Deploying code for bug fixes and enhancements into production environment using change management process
- Maintaining Production environment for various applications
- Analyzing complex Scripts flows and their interdependence
- Identifying database changes required for modules.
- Developed new analytical models that improved forecasting accuracy and reduced risk exposure.
- Implemented predictive analytics techniques that enabled proactive adjustments to business strategies based on emerging trends.
- Streamlined reporting procedures by creating user-friendly dashboards for easy access to key performance indicators.
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Spearheaded efforts to migrate existing systems onto cloud-based platforms, resulting in improved accessibility, security, and scalability.
- Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
- Optimized resource allocation by conducting thorough cost-benefit analyses on potential investments.
- Enhanced customer satisfaction rates through detailed analysis of customer feedback data and subsequent improvements in service offerings.
- Increased efficiency by streamlining data analysis processes and implementing automation tools.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
- Conducted rigorous testing of financial models, ensuring their reliability and relevance in real-world applications.
- Assisted in decision-making processes by presenting accurate, data-driven recommendations to stakeholders.
- Validated results and performed quality assurance to assess accuracy of data.
- Performed system analysis, documentation, testing, implementation, and user support for platform transitions.
- Queried databases for information needed for report processing.
- Installed system updates to address vulnerabilities and reduce security issues.
- Identified and resolved problems through root cause analysis and research.
- Identified clear connections between policies and business results to eliminate or reduce confusion and help employees achieve goals.
- Monitored compliance and filing requirements in conjunction with staff and management.
- Performed audits of subsidiaries to protect shareholders and potential investors from fraudulent or unrepresentative financial claims.
- Optimized core processes to improve business performance and operational agility.
- Maintained database systems to track and analyze operational data.
- Educated staff on organizational mission and goals to help employees achieve success.
- Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
- Frequently inspected production area to verify proper equipment operation.
- Generated reports detailing findings and recommendations.
- Collected, arranged, and input information into database system.
- Developed effective improvement plans in alignment with goals and specifications.
Application Developer
UOB (United Overseas Bank)
Singapore
11.2015 - Current
- Performing root cause analysis for issues identified in PROD environment and provide permanent resolution for frequently occurring issues after reproducing issue in staging environment (SIT/UAT)
- Regular interaction with users and business for production issues and resolving them as per agreed SLA
- Developing and maintaining SQL's and automated shell scripts
- Supporting and maintaining environments for Production and UAT
- Maintaining code, building and releasing into SIT, UAT, and Production
- Regression testing the environment on every new release onto Production
- Maintaining batch jobs using tools Control-M and Autosys in Production Environment as per business requirement
- Monitoring ITSM queue, JIRA, and group mailbox for supporting user incidents on a daily basis within agreed SLA according to priority
- Planning and executing BCP, QMW, and DR Exercise according to organization standards
- Identifying manual tasks and reducing system alerts by deploying automation shell scripts
- Introducing new alerts and implementing periodic housekeeping jobs to improve Production stability
- Deploying code for bug fixes and enhancements into production environment using change management process
- Maintaining Production environment for various applications
- Analyzing complex Scripts flows and their interdependence
- Identifying database changes required for modules.
- Implemented user-friendly interfaces, improving overall user experience and satisfaction rates.
- Reduced software bugs by conducting thorough testing and debugging procedures.
- Developed reusable components/libraries streamlining future projects saving both time resources while simultaneously standardizing codebase ensuring consistency across all applicationsproducts.
- Collaborated with cross-functional teams to design and develop high-quality applications for various industries.
- Worked closely with clients throughout the development process to gather feedback, ensuring that final products met their expectations.
- Leveraged cutting-edge technologies like machine learning algorithms or AI tools when designing innovative solutions tailored specifically towards target audiences'' needspreferences.
- Adhered to strict coding standards, ensuring the maintainability and scalability of developed applications over time.
- Participated in regular meetings with stakeholders, presenting progress updates and discussing any roadblocks encountered during development stages.
- Enhanced application functionality by implementing new features and optimizing existing code.
- Optimized application performance through rigorous analysis of system bottlenecks and implementing targeted solutions.
- Updated technical documentation, product specifications, and technical training materials.
- Created software applications in test-driven development environment.
- Resolved system test and validation problems to provide normal program functioning.
- Conducted scheduled system upgrades to maximize performance.
- Explained project technical risks and benefits during project kick-off.
- Tested and deployed scalable and highly available software products.
- Tested functional compliance of company products.
- Analyzed work to generate logic for new systems, procedures and tests.
- Designed and implemented scalable applications for data extraction and analysis.
- Conducted data modeling, performance and integration testing.
- Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
- Coordinated deployments of new software, feature updates and fixes.
- Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.
Production Application Support Analyst
3M Malaysia
03.2015 - 11.2015
- Held responsibility for iSeries (AS/400) production support and troubleshooting for operations, users, developers, and distribution centers
- Troubleshot iSeries (AS/400) production issues originating from system and/or programming problems and general errors
- Fixing defects in the existing application
- Gaining Manufacturing domain Knowledge
- Providing technical guidance to the team
- Fixing defects in UAT
- Involved in reviewing the deliverables and preparation of weekly and monthly status reports
- Offshore team meetings and onsite coordination.
Application Support Analyst
Hexaware Technologies
08.2013 - 03.2015
- Fixing defects in the existing application
- Overview of MQ framework to understand its various components and capabilities
- Guidelines to Application teams to interface their programs with MQ framework
- Creating MQ setup for HOST to HOST applications
- Gaining MQ series, SIBS Banking domain Knowledge
- Fixing defects in the existing application
- Coding the programs as per the Change Request specifications
- Making changes in the Calling program and Called programs
- Preparation of Unit test plans and providing test data
- Attending Peer Reviews
- Fixing the defects raised in UAT
- Analyzing requirements and estimations
- Preparing Low Level Documentation and Access Matrix.
Education
undefined
Skills
UNIX, Linux, Windows, AS400Unix shell scripting, RPGLE, CLLE, SQL, HTML, JAVA, C, C (basics) & INFORMATICA/ETLOracle, MySQL, SQL Developer, DB2
Root Cause Analysis
Root Cause Analysis
Documentation And Reporting
Information Gathering
Audit Support
Workflow Analysis
System Analysis
Process enhancement
Report Preparation
Issue Identification
Process Improvements
Data Integrity Assurance
SQL and Databases
Business Operations Analysis
Continuous Improvement
Data Processing
Account Reconciliation
Analytical Thinking
Incident Reporting
SQL Programming
Task Prioritization
Data Analysis
Problem-solving aptitude
Time management abilities
Teamwork and Collaboration
Attention to Detail
Audit reporting
Team building
Analytical Skills
Issue Research
Process Improvement
Team Collaboration
Problem-Solving
Certification
ITIL 4
Roles And Responsibilities
- Performing root cause analysis for issues identified in PROD environment and provide permanent resolution for frequently occurring issues after reproducing issue in staging environment (SIT/UAT)
- Regular interaction with the users and business for production issues and resolve it as per agreed SLA
- Developing and maintaining SQL’s and automated shell scripts
- Supporting and maintaining the environments for Production and UAT
- Maintaining code, building and releasing into the SIT, UAT and Production
- Regression testing the environment on every new release onto Production
- Maintaining batch jobs using tools Control-M and autosys in Production Environment as per business requirement
- Monitoring the ITSM queue, JIRA and group mail box for supporting user incidents on daily basis within agreed SLA according to priority
- Planning and executing BCP (Business Continuity Planning), QMW (Quarterly Maintenance Window) Drills and DR Exercise according to organization standards
- As part of demand reduction, identified the manual tasks and reduced the system alerts by deploying automation shell scripts
- To improve the Production stability introduced the new alerts and implemented the periodic housekeeping jobs
- Deploying code for bug fixes and enchantments into production environment using change management process
- Maintaining Production environment for various applications
- Involves in analyzing complex Scripts flows and their interdependence
- Also involves identifying database changes required for that module
Projects
CASH MANAGEMENT Applications Support & Maintenance project, BNP PARIBAS BANK, Linux, Unix, WEB SPHERE, JMS, INFORMATICA, JAVA, ORACLE, AS400, DB400, MAINFRAME, CICS, DB2, ServiceNow, Geneos, informatica, BNP PARIBAS Bank Team is responsible for the Application Analyst and Supporting of the CM (CASH MANAGEMENT) multi-application systems for BNP Singapore and APAC countries major Payment applications like BPH, EMX, CXC, CXD, BIP and CPG like 20+ Systems using in MQ Series & TIBCO JMS for SWIFT MT103, PACS008 & PAIN001 online payments, Statement Inquiry’s, and corporate banking. Cash Management platform using SWIFT messages, and oracle in LINUX operating System. Interacting with Informatica and java for inter process communication, message passing through CPG Clearing Systems. PAIN & PACS messages going through EMX (running under TIBCO) administration in LINIX, the transactions pumping tools to support tools is using CFT, MQ, JMS & INFORMATICA, MFT and responsibilities. Involving the production deployments & OS patches actives to restart application services. Overview of MQ framework to understand its various components and capabilities. Guidelines to Application teams to interface their programs with MQ framework. Creating MQ setup for HOST-to-HOST applications. Gaining MQ series, SIBS Banking domain Knowledge. Fixing defects in the existing application. Coding the programs as per the Change Request specifications. Making changes in the Calling program and Called programs. Preparation of Unit test plans & Providing Test data, Attending Peer Reviews. Fixing the defects raised in UAT. Analyzing requirements and estimations. Preparing Low Level Documentation and Access Matrix. Enterprise Application Integration (EAI /IAG) Development & Maintenance project, UOB BANK, AS400, Unix, WEB SPHERE, MQ Series RPG/400, RPG (ILE), CL/400, SQL/400, DB400, MAINFRAME, CICS, DB2, SDA, ACMs, Hawkeye, Control-m, UOB (United Overseas Bank) Team is responsible for the Development, maintenance and Supporting of the MQ (Message queue) systems for UOB Singapore and another 19 countries major Host applications like PIB, GEB, IBR (I BRACH), CRM, REM and TRADE like 150+ Systems using in MQ Series for Interbank fund transfer, online payments, LNS, Statement Inquiry’s, and Retail banking. Development of synchronous and asynchronous financial, fast transactions related to Remittance, Trade and Loans on Oracle Tuxedo platform using C, and oracle 10g in Solaris UNIX operating System. Interacting with Tuxedo API for inter process communication, message passing Gateway. Low latency transactions achieved through MQG programming in Development of programs logics for EAI-channel-host reconciliation process and Payment reversals in Unix C. EAI/IAG MQ support was provided to users from Singapore & another 19 countries. IBM MQ programming in C, MQ administration in UNIX for EAI systems Development of transaction pumping tools to support unit testing, is using MAINFRAME CICS and responsibilities. Fixing defects in the existing application. Overview of MQ framework to understand its various components and capabilities. Guidelines to Application teams to interface their programs with MQ framework. Creating MQ setup for HOST to HOST applications. Gaining MQ series, SIBS Banking domain Knowledge. Fixing defects in the existing application. Coding the programs as per the Change Request specifications. Making changes in the Calling program and Called programs. Preparation of Unit test plans & Providing Test data, Attending Peer Reviews. Fixing the defects raised in UAT. Analyzing requirements and estimations. Preparing Low Level Documentation and Access Matrix. APPLICATION SUPPORT ANALYST, 3M Malaysia SDN BHD, OS/400, RPG/400, CL/400, RLU, FREE ILERPG, OLOPS, BPCS, 3M is a Manufacturer of Electronic, Electrical & Communications, and Health Care and Home & Leisure, Transportation Industry, Safety, Security, and Protection. 3M, a leading supplier of advanced automotive technology, systems and components for all the world's major automakers, operates in 60+ countries. 3M decided to merge their Production control & Sales related systems due to the redundancy of functionalities and Maintainability of the code. These systems were developed using older versions of programming language and were not scalable for the new business processes. Merging of these two systems would help 3M to add new & enhanced features thereby system can be better equipped with new or future business requirements. 3M will draw up the OLOPS and the BPCS are be prepared by Module Leads with the user requirements as a basis. This project involves full fledge Support of application, enhancements and fixing the defects that will be raised by the 3M team and also RFC’s that will be requested on this application. APPLICATION DEVELOPMENT– Bundle Domain: ERP, Gillette Company, Kornberg, AS400, websphere MQ, RPG, RPGILE, CL, SQLRPGILE, Gillette has implemented different applications in various business systems like Customer Relation Management, Global Supply chain management, MAPICS for Manufacturing & Material planning requirements at Braun Plants, SAP based applications to handle Orders, Sales, Customers, Products etc. MAPICS is an ERP used for Material Requirements Planning that stands for Manufacturing, Accounting and Production Information Control System. Gillette had implemented MAPICS production system at sites, Core manufacturing activities are reported into this system apart from sales / distribution & purchasing. However, some of the master data is maintained into SAP systems. Interfaces are implemented to transfer relevant data from SAP to MAPICS as well as from MAPICS to SAP. MAPICS support was provided to users from Mexico and Shanghai. Analyzing Business Requirement Document. Impact Analysis. Preparing Technical Design Document and Preparation of Impact Analysis reports. Coding the programs as per the Change Request specifications. Making changes in the Calling program and Called programs. Preparation of Unit test plans & Providing Test data, Attending Peer Reviews. Technical Guidance to team. Fixing the defects in UAT. Involved in Reviewing the Deliverables & Preparation of weekly, Monthly status reports. Offshore Team meetings & Onsite Co-ordination.
Timeline
Application & INFRA Analyst
BNP Paribas
02.2022 - Current
Application Developer
UOB (United Overseas Bank)
11.2015 - Current
Production Application Support Analyst
3M Malaysia
03.2015 - 11.2015
Application Support Analyst
Hexaware Technologies
08.2013 - 03.2015