Ramkumar Sundaresan
Team Lead
Bangalore
Summary
Seeking a challenging role as a Project Manager where I can leverage my extensive experience in Oracle Database systems to drive project success. With over 13 years of experience in systems analysis, design, and development, I am adept at leading cross-functional teams and delivering projects on time and within budget.
Overview
15
15
years of professional experience
4
4
years of post-secondary education
1
1
Language
Work History
Associate Consultant
Tata Consultancy Services
Bangalore, Karnataka
01.2025 - Current
- Generated reports detailing findings and recommendations.
- Evaluated customer needs and feedback to drive product and service improvements.
- Conducted regular reviews of operations and identified areas for improvement.
Technical Lead
Accenture
03.2022 - 12.2024
- Involved in resolving Support Tickets
- Assigning Tickets to Team members
- Managing Team and Client calls
- Managing Escalations from Client
- Modifying existing Packages and Procedures related to Enhancement request.
- Mentored junior developers through regular 1-on-1 meetings, providing guidance on best practices, coding standards, and career growth opportunities.
Project Lead
Wipro Technology
03.2020 - 03.2022
- As a PROJECT LEAD involved in co-ordination between developer and product owner
- Involved in Writing new PACKAGES, PROCEDURES for new project enhancement
- Involved in Design and Development of projects.
Project Lead
Wipro Technology
09.2018 - 06.2019
- As a PROJECT LEAD involved in co-ordination between onsite and offshore team
- Been in Qatar for 3 Months for Go-Live activities and environment setup
- Being single point of contact for 150 + team
- Setting up Offshore team in Kochi for Support of the Project
- Involved in Screening/Interview/Onboarding candidate into team
- Involved in Team sizing, Billing, Procurement of servers for Offshore environment.
Project Lead
Wipro Technology
01.2017 - 08.2018
- As a PROJECT LEAD successfully guided team and mentored Junior resources
- Both Java and DB side
- Been single POC for WIPRO MANAGEMENT related to Project
- Worked on Stats Pack report as part of performance tuning
- Monitoring Performance of system during Load Testing which is performed by Application Team
- Working on Complex SQL queries and Tuning existing queries to improve performance
- Used UTL_FILE for downloading file from Server
- Implemented AUDIT_LOG functionality for supporting Application
- Involved in Complex DATA MIGRATION activities with the help of Scripts and DATA PUMP utility
- Involved in Basic DBA health check activities
- Successfully given logic for Parallel run of Application through single DB.
Associate
Cognizant Technology Solutions
03.2014 - 12.2016
- Worked on PREFERENCE module of the Application
- Extensively used AWR Reports for performance tuning
- Used SQL loader for uploading external source data into new system
- Used DBMS_PROFILER to identify the queries which is taking long time and fixed the same
- Used EXPLAIN PLAN and TKPROF utility as part of performance tuning.
Developer
IMS Health India Limited
08.2013 - 02.2014
- Coordinated with On-Shore, Off-shore resources for getting requirements, and handing over the application to the end users
- Generated Reports for comparison of data between source and target systems
- Fixing CR and Documenting same, whenever arises
- Coordinating with UAT, SIT Team for smooth testing and helping them for complex sql queries.
Database Design Consultant/Developer
J Soft Solutions Limited
09.2012 - 08.2013
- Responsible for requirements gathering from Clients and implement the back end changes in product and in designing the database
- Installed and Configured Oracle Database 11G
- Involved in the design of Database for the system
- Done entire Data Modeling for complete project of this product(J Soft Integra ERP)
- Developed logical and physical data models that capture current state/future state data elements and data flows using SQL Data Modeler
- Extensively used Sql data modeler tool in Forward and reverse engineering, following Standards in Naming Conventions, using Conformed dimensions whenever possible
- Created Tables, Views, Constraints, Synonyms, Sequences
- Created and used DB-Links to connect to other local & QA databases
- Developed Independent PL/SQL Debug Package which captures the Un-handled Pl/Sql exception by developers and log the error in ERROR LOG Table
- Developed Overall Inventory Package which is integrated with all modules related to stock and Increases or reduces the stock from On-hand Table
- Been in part of Team to create the Architecture for Custom Workflow process for the product
- Created FGA Audit trial methodology for important tables using Oracle 11G Enterprise Editions
- Created Finance GL Integration Package which takes care of all Debit and Credit amount from various modules and stores the value in database
- Created Auto-Indent program for required items which creates Automatic Indent, based on Min-Max quantity and various other scenarios
- Created GL Balance and Stock valuation program which runs every month and captures opening and closing balance of last month Revenue/Stock respectively
- I analyzed and added new features of Oracle 11g like DBMS_SHEDULER, Data pump, in our J Soft Integra ERP
- Built the QA environment for testing DS application and ensured that all the modules work as expected
- Solved implementation problems in PL/SQL and database related issues
- Involved in client acceptance testing
- Coordinated all departmental activities
- Developed new functionality to the existing application as part of change requests
- Documented the change requests and submitted to change control team
- Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
Technical Consultant
J Soft Solutions Limited
06.2012 - 08.2012
- Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database
- Designed and developed WEB ADI to load data from Source systems
- I.e Bank Statement Import Program
- Identified the tables from Oracle 11i and noted the changes in Oracle R12 and Customized the forms/reports accordingly
- Testing Forms and Reports and assigning bugs in BUGZILLA
- Used EXPLAIN PLAN, TKPROF to tune SQL queries
- Performed some administrative works like creating users, menus, adding forms and functions to menus, assigning responsibilities etc
- OAF personalization done to some pages according to user needs
- Developed custom reports in INV and OM modules
- Customized WORKFLOW during implementation and rectified errors as on when it arises
- Migrated files from UNIX OS to Windows OS
- Involved in documentation for releases.
Techno-functional Consultant
J Soft Solutions Limited
09.2010 - 05.2012
- Developed Packages and customized functions and Triggers based upon the business logics
- Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i
- Involved in Data Model for designing Inventory tables
- Developed Oracle Customized forms for users to make Production and QC inspection using Forms6i
- Tracked as on day stock using Pl/Sql procedure and matched the Excel sheet status and system status
- Prepared MD(50), MD(70), TE(40) documents according to company standard
- Prepared test plans for System and User acceptance test
- Involved in documenting users requirements, technical specifications and Reporting manuals.
Education
B.E -
Anna University
Madurai 09.2005 - 05.2009
Skills
Databases - ORACLE 9i/10g/11g/12c, Netezza 61undefined
Desired Industry
Computer Software/Programming
Desired Job Location
Anywhere, India
Available Date
Within 2 Month
Job Level
Experienced Over 13 years
Willing To Travel
Yes
Highest Degree Attained
Bachelors
Alternate Email Id
Ramkumar.suresh@gmail.com
Alternate Mobile Number
9739466033
Personal Information
- Total Experience: 13 years
- Willing To Relocate: Yes
- Date of Birth: 04/14/88
Notice Period
90 days
Pan No
ASGPR8716E
Address For Communication
413 Manya Hi-Living, 52/3, Doddathoguru, Begur Hobli, Electronic city Phase-1, Bangalore, 560100
Publications
sram88.wordpress.com
Disclaimer
I hereby declare above furnished details are true to my knowledge.
Timeline
Associate Consultant
Tata Consultancy Services
01.2025 - Current
Technical Lead
Accenture
03.2022 - 12.2024
Project Lead
Wipro Technology
03.2020 - 03.2022
Project Lead
Wipro Technology
09.2018 - 06.2019
Project Lead
Wipro Technology
01.2017 - 08.2018
Associate
Cognizant Technology Solutions
03.2014 - 12.2016
Developer
IMS Health India Limited
08.2013 - 02.2014
Database Design Consultant/Developer
J Soft Solutions Limited
09.2012 - 08.2013
Technical Consultant
J Soft Solutions Limited
06.2012 - 08.2012
Techno-functional Consultant
J Soft Solutions Limited
09.2010 - 05.2012
B.E -
Anna University
09.2005 - 05.2009
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Muskan JainMuskan Jain
Associate – Bid Management at Subex Ltd.Associate – Bid Management at Subex Ltd.