Project Data
Resume:
Guru Raghavendra Prasad Padmanabhan
adlo42@r.postjobfree.com
EXPERIENCE SUMMARY
Over 13+ years of experience in the Information Technology industry primarily in the Application Development and Migration type of engagements.
Worked for more than 8+ years in Banking industry.
Worked on DB upgrade projects to the higher versions for the applications.
Worked on data security setup in Oracle DB.
Expertise in requirement gathering, Analysis, Design, Development, Testing and Implementation of databases
Strong back-end programming experience in developing applications using SQL and PL/SQL programming
Good exposure in Oracle database design, development, and performance tuning and query optimization for OLTP applications.
Worked on Data purging, data archival and data encryption and decryption projects.
Worked on BI reports using Tablau desktop.
Experience in UNIX shell scripting, includes file monitoring scripts, data manipulation scripts and data load scripts. Extensively used VI editor.
Worked on Unix to Lunix servers migration projects.
Have strong experience in designing tables, indexes, table partitioning, query optimization.
Involved in preparing implementation plan and master scripts for smooth implementation.
Worked on data replication projects using CDC and datastage.
Engaged with change management team for code deployment.
Lead the offshore team deliverables.
Coordinated with different team across globe for the end to end project deliverables
Work collaboratively with business users and various other business partners to identify and understand key business processes, gather business requirements and convert those into tangible data requirements.
Experienced in End to End development planning and execution towards Release cycle.
Willingness to learn new concepts and ability to articulate alternative solutions and reasoning behind the alternatives.
SKILLS SUMMARY
Oracle 9i,10g, 11g and 12c
Performance Tuning
Database Design
Unix Shell Scripting
Control-M schedulers.
PL/SQL programming
Resource Management
Crystal reports.
Basic python
Tableau
TECHNICAL SKILLS
Operating System
UNIX SUNOS, AIX, Linux, Windows
Database Technologies
Oracle 12c,11g,10g,9i
Third Party Tools
PL-SQL developer, Toad, Tableau desktop,SQL Developer,SQL navigator,Datastage,BOE crystal reports,Pentaho SVN and TFS.
Other Programming Languages
Unix Shell Scripting and basic python.
EMPLOYMENT HISTORY
Name of the Company
Designation
From
To
Cognizant Technologies Solutions
Senior Associate
Jun 2012
Till Date
Mphasis an HP Company
Delivery software engineer
May 2011
May 2012
Tech Mahindra
Technical Associate
Jun 2007
May 2011
EDUCATION
Degree
College/University
Duration
Bachelor of Engineering – Mechanical
Sri Sairam Engineering college, Anna university, India
4 Years
CERTIFICATIONS:
No
Certification
1
Oracle certified Associate – Cloud service operations.
2
Oracle Certified Professional (OCP) – plsql developer.
3
Tabeau certified Associate
4
Oracle Certified Associate (OCA) – plsql developer.
EXPERIENCE DETAILS
PROJECT PROFILE 1:
Project Title
EMEA TA DEVELOPMENT
Client
Northern Trust Bank
Duration
Mar 2017 – Till date
Technology/ Tools
Oracle 12c, PLSQL,Unix shell scripting,CDC,Datastage,BOE CMC,Crystal reports,control-m
PROJECT DESCRIPTION:
GFP(Global Funds Portal) is the suite of application that supports wide variety of transfer agency business functions. Application provides account services,fund service,agent service,document service and portfolio service. It replicates the data from different sources and transfer it into business defined logic under global funds. As it maintains funds across global customer/clients/agents can view this portal as single view account information.
ROLES AND RESPONSIBILITIES
Understanding the requirement document and shape up the System Approach and technical specification document.
Involved in creating DB objects like Procedures, Packages,Functions,Views and complex SQL queries with respect to project requirement.
Oracle Upgrade :
Collect and analyze the DB components, checking code compatibility and solution for
depreciated features.
Prepare detailed design, impact analysis and solution design docs.
Analyze on Roles and grants for all objects and establish DB link connectivity.
Retrofit current production changes, modify code for compatibility and new features
Designed and developed data security, data encryption and decryption projects.
Co-ordinate with other team (infra, application team, change management, DBAs..)
Replaced the Oracle streams by developing the data replication job to process the changes from the CDC file using datastage.
Build the crystal reports and schedule it in BOE-CMC.
Design log table to log the steps that are run in the procedures.
Implemented partitioning for large tables.
Implemented data archival process.
Designed job work flow and implemented them by creating wrapper shell scripts and scheduled using Control-M scheduler tool
Created test cases and executed them in UAT.
Streamline the UAT data refresh process.
Prepared activity check list for moving complete code from DEV to UAT, and UAT to PROD.
Co ordinate with different teams.
PROJECT PROFILE 2:
Project Title
CAF UDBA Build
Client
JPMorgan Chase
Duration
Feb 2013 – Feb 2017
Technology/ Tools
Oracle 11g, PLSQL,Unix shell scripting,Pentaho,SVN,Autosys
PROJECT DESCRIPTION:
Auto Finance comes under the umbrella of lending segment, which is one of the several offerings of banking industry. Lending segments in banking industry is always subjected to credit risks, CAF UDBA Build & Support project comes under the Auto Finance LOB and it maintains customer’s credit risk related information. This project tracks & monitors the behavioral aspects of customers across delinquency buckets and reports the details to the business team. Project owns several credit risk related reports that needs to be delivered to business team on daily, weekly, monthly and quarterly basis.
ROLES AND RESPONSIBILITIES
Understanding the requirement document and shape up the System Approach and technical specification document.
Prepared Low Level database design document.
Involved in creating DB objects like Procedures, Packages,Functions,Triggers,Views and complex SQL queries with respect to project requirement.
Analyze the cost of queries and fine tune for better performance and unit testing.
Used Oracle profiler tool to identify top 10 costliest queries in a package.
Implemented partitioning for large tables.
Prepare migration scripts, testing scripts, do system and performance testing.
Prepared Unit test case document and capture the screenshot of the test case results and the tested scenarios.
Developed SQL Loader automation.
Developed Unix shell script to schedule the jobs.
Preparing Unit Test Case Document. Review code changes, test procedure, test plans and other deliverables.
Was responsible for creating data for Onsite Governance/ Status call with client manager on the status of the project.
Involved in designing AUTOSYS scheduler.
Was involved in the review of all major technical deliveries from offshore.
Was responsible for QA, UAT and Production implementation support and Mentoring and training entry level trainees.
Involved in daily/weekly client discussions.
PROJECT PROFILE 3:
Project Title
HSA – Prepaid Technologies
Client
JPMorgan Chase
Duration
Jun 2012 – Jan 2013
Technology/ Tools
Oracle 11g, PL/SQL
PROJECT DESCRIPTION:
H SA or Health Savings Account is a prepaid financial services product that aims at providing online account for managing health related expenditures and availing tax savings for corporate customers. The product provides employers with option for bulk funding their employees and additional option for customer maintenance. Additional features like account to account transfers, ACH, wire transfers, monthly statements, bill payments etc. are also available.
ROLES AND RESPONSIBILITIES
Discussion with Bussiness Analyst for requirement details.
Was responsible for all technical design related to Database objects.
Impact Assessment
Prepared Low Level database design document.
Involved in creating DB objects like Procedures, Packages,Functions,Triggers and views with respect to project requirement.
Analyze the cost of queries and fine tune for better performance and unit testing.
Used Analytical functions when necessary.
Prepare test cases and test scripts for unit testing.
Code review and Test case review.
Exploring and sharing new functionalities with the team members.
Involved in daily/weekly client discussions.
PROJECT PROFILE 3:
Project Title
The Customer Management & Billing System (CMBS)
Client
JPMC
Duration
May 2011 – May 2012
Technology/ Tools
Oracle 11g, PL/SQL, Unix Shell scripting
PROJECT DESCRIPTION:
The Customer Management & Billing System (CMBS) is the central application supporting order activity and billing of products delivered across the Optus Hybrid Fibre/Co-axial cable (HFC) network. Optus currently has three such products LAT(LAT- Local Access Telephony provides a customer with access to a set of analogue voice services including standard telephony, fax and dial-up internet), ONC ( OptusNet Cable is a broadband internet product providing download speeds of up to 100 times that of dial-up), DTV ( Optus net Television is an analogue PayTV service which rebroadcasts Foxtel analogue channels plus has several Optus specific foreign language channels). CMBS is based around a package application called Intelecable or ITC. This package was originally designed to specifically handle the order management, service provisioning.
ROLES AND RESPONSIBILITIES
Understanding the requirement document and shape up the System Approach and technical specification document.
Prepare the design document for Stored Procedures.
Involved in writing PL/SQL Procedures, Functions, and Packages.
Preparing Unit Test Case Document for the packages. Review code changes, test procedure, test plans and other deliverables.
Analyze the cost of queries and fine tune for better performance and unit testing.
Used Oracle profiler tool to identify top 10 costliest query in a package.
Involved in daily/weekly client discussions.
PROJECT PROFILE 4:
Project Title
FLOW SYSTEM
Client
British Telecom
Duration
Oct 2007 – May 2012
Location
Tech Mahindra Limited, Pune, India (Nov 2007 – May 2012)
London, United Kingdom (6 months in Onsite)
Technology/ Tools
Oracle, Unix.
Project Description:
FLOW as a business workflow application, supports various Line of Business (LoB) like Wholesale, LLU, WLR, WBC, FTTC, ISDN etc. The system titled FLOW is developed for BT (British Telecom). The objective of the system is to progress the numerous orders placed by many Communication Providers across the UK on the BT Network, owned by Open Reach, a BT Line of Business. The system has to communicate with many other systems to achieve the same.
FLOW system plays the major role in entire the order journey. Before accepting the order from the upstream system, it performs various validations like feasibility of providing the line, existence of the products in the current line etc on CSS. In all cases, FLOW decision is final as it directly interacts with CSS, hence it is considered as heart of the entire system.
Roles and Responsibilities in the Project:
Received KT from other vendor for project transition.
Lead the team of 4 members from offshore.
Lead the production Support team to deliver on all L3 support issues.
Lead the offshore Enhancement team in Enhancements, Break fix and Emergency releases.
Performance tuning of existing applications and batch jobs.
Anayse on the failure cases and comeup with the solution.
Taken the Customer Experience role at onsite(London) and given solution to major on going issues and improvement related to process and design with the customers.
Involved in daily/weekly client discussions.
Contact this candidate