Pavan Kumar M

• PROJECT DETAILS :
  Client: American Express
  Duration: May 2022 - Present
  Location: Hyderabad
  Team: IDN & GRT Support
  Company: Cognizant Technology Solution Pvt Ltd
  About Client:
  SDM IDN referred, to as Service Delivery Management Information Delivery Network is a system that handles the Data loading process from Mainframes files to Database tables. The ETL process is being monitored via Engines (a scheduler), wherein every phase of the process is denoted as a Feed/Node. The ETL process starts with Extracting the file from the Upstream, its transformation as per the format at the Downstream at various phases and
  loading it into target tables.
  About Team:
  GRT referred to as Global Risk Technology is a system that handles the extracted data from a centralized repository called Cornerstone to load into Database tables through ingestions. It enables Batch/API services to customers to use loaded tables from HBASE.
  

Roles and Responsibilities

• Identified and resolved complex issues by applying advanced analytical and troubleshooting strategies.
• Improved customer satisfaction by quickly and effectively addressing inquiries and complaints.
• Assigned tasks to lower-level personnel based on qualifications and skill set.
• Defined work plans in alignment with stakeholder requirements.
• Worked varied hours to meet seasonal and business needs.
• Greeted customers and offered assistance for increased customer satisfaction.
• Prioritized tasks to meet tight deadlines, pitching in to assist others with project duties.
• Troubleshoot minor issues with equipment and tools.

Project Description: We create a digital ecosystem of technologies that deliver adaptive solutions for financial institutions at high velocity and scale, driving business growth, streamlined operations, risk-adjusted insights, and regulatory compliance.

Responsibilities:
1)Interacting with clients to know methods are following to implement.
2)Involved in design and development of (Procedures, Functions, and Packages).
3)Creating, managing, and modifying database storage structures table data files.
4)Experience in using Export / Import utilities / Data pump
5)DDL, DML’s creation like indexes, tables, synonyms, views etc.
6)Deploying using tools such as Jenkins creates binds pipelines.
7)Creating daily reports in express tools.

8)Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.

9)Built databases and table structures for web applications

10)Communicated new or updated data requirements to global team.

11)Involves in Planned and installed upgrades of database management system software to enhance database performance as per the business needs.

Project Description: UBS AG (Banking):

Wealth management of Americas services are designed for high-net-worth

And affluent individuals around world, whether investing internationally or in their home country. It provides tailored, unbiased advice and investment services—ranging from Asset management to estate planning and from corporate finance to home financing by Financial Advisor.

Responsibilities:

●Interacting with onsite coordinator for business logic's/requirements and their implementation.

●Coordinated with front-end design team to provide them with necessary stored procedures and packages and necessary insight into data.

●Creating estimation sheet based on design created.

●Involved in continuous enhancements and fixing of production problems.

●Creating Technical design documents, Unit Test cases, and Active Review checklist

●Creating and altering tables, views, stored procedures, functions in packages and complex

Queries based on requirements provided by front

End team for Service Audit Application.

●Code Review for coding one by other team members.

●Coordinating with onshore for understanding of Business Process Flow.

●Involved in automating reports in project.

●Procedures, Packages, and Unix Shell scripts.

●Developing automated reports from requests for requirements stated by clients.

●Investigate data-related issues.

●Development & Operations Support and Process monitoring.

●Involved in debugging of job failures in different environments in runtime.

●Interacting with CTB Support People for any help and assistance and making them

Understand issue of particular policy or Customer.

●Creating Scripts update/Delete/Insert data.

●Creating Rollback scripts.

●Solving tickets raised by L1support.

●Modifying Packages, Procedures, and Functions.

●Loading data through Scheme Loader.

●Analyzing and discussing issues with Onsite team and finding best solution.

●Peer review and giving KT to upcoming team members.

Created engineering documentation for manufacturing processes, equipment specifications and change notices

Project: NNNOW.com E-commerce Website Production Support
Roles And Responsibilities:
●First point of contact from business for any issues related to application.
●Providing functional knowledge to CRM/Business people about features of Product.
●Resolving Issues and finding bugs in application within SLA.
●Creating Coupons, Updating, Patching based on requirement.
●Handling Front End issues up to Support Level.
●Interacting with Testing, Dev Teams If any Deployments going on for new Features.
●Informing business regarding Deployments, Changes in Applications Features.
●Handling Payment Gateway issue and resolving within stipulated time.
●Adding constraints to pre-defined data in database.
●Effectively use of Rest Api's which had got from Codebase Based on Requirements.
●Writing queries for businesses to populate Dashboards based on filters, aggregate functions.
●Resolving queries raised by CRM, Customers, Business Leads.
●Updating SOPs on daily basis
●Creating KDB articles for repetitive issues in application.
●Based on issue find out least information to debug issue.
●Writing Manual Test Cases for any updates changed for constraints in code.
●Take care of Entire application for smooth run for business.
●Creating tasks, tickets, and closing once it resolves.
●Working with Different Modules and going through code based on new requirement/Issue Raised.

• 1) Taking Care of Batches, Operations, Environments in application.
• 2) Creating workbooks based on requirement which we had received from Clients.
• 3) Initializing Cab Cal (Bridge Calls) based on issues raised.
• 4) Proactively Finding issues and forming to stack holders.
• 5) Resolving tickets within SLA raised by CR MorL1Support.
• 6) Involving with Developing teams to gain knowledge about new features or Modules in Project.
• 7) Preparing Shift Roasters As per Resource Allocation.
• 8) Involved in debugging of job failures in different environments in runtime