Surendra Mehra
Quincy,MA
Summary
Professional Summary:
- Over 19+ Years of Project Management, Software development/maintenance experience in client/server and web application using Oracle, Data Warehouse and MS .Net technology.
- 5+ Years of experience as techno-manager. (Offshore/Onsite).
- Certification in Introduction to Oracle 9i: SQL (1Z0-007).
- Extensive experience in Applications support, design, development, analysis, construction and testing of distributed applications in client-server and web environments.
- Played a key role in implementing Preventive, Adaptive, Proactive and perfective maintenance in all applications.
- Good experience of working at multiple Client locations (UK, Europe & USA), interacting and dealing with clients and end users.
- Possess an analytical mindset, fast-learning ability, independent problem-solving skills, troubleshooting expertise and versatility to resolve multifaceted issues despite the challenges of changing priorities.
- Excellent communication skills with demonstrated ability to interface with all levels across organization, including leading and facilitating meetings, preparing and making presentation to both technical and non-technical audience.
- Experience of working in Production Support and Development environments.
- Well versed with ITIL process like Incident, change and problem Management.
- Extensively worked on Back-End Programming using PL/SQL, Stored Procedures, Functions, and Packages, Database triggers for Oracle 9i/8i/10 g and SQL queries/reports and scripts.
- Good knowledge in front-end programming using Oracle Forms.
- Knowledge of core programming languages Pro C.
- Working level knowledge of UNIX operating system.
- Experience in Oracle Forms Migration from Oracle forms 3.0 to Oracle forms 10g.
Overview
19
19
years of professional experience
Work History
Associate Consultant
TCS
07.2023 - Current
- Playing role of a technical consultant, Managing and Organizing applications across Data Warehouse and Information delivery platforms for State Street Client
- Managed and motivated project teams to promote collaboration and keep members on-task and productive
- Serve as Data Warehousing & Business Intelligence Consultant for ESP application, a State Street proprietary software product
- Support End to End data life cycle, right from data acquisition till data presentation/consumption
- Provide Level-4 application support for ESP application across several platforms and technologies
- Data flow monitoring to the persistent data marts for each individual instance (Business Units) spread across several servers in the multi thread mart refresh processing
- Monitor Service Level Agreements (SLA) on daily basis for the escalated issues form Level-1, Level-2 & Level-3 Support teams
- Participate in regular Agile Scrum meetings to discuss issues in the environment, performance issues and SLA misses
- Improve resiliency of the ESP application by identifying the bottlenecks in the current design and minimize the SLA misses
- Providing support and consulting for development team on system configuration during developing and testing and supporting business team queries on data issues
- Planning and execution of Client on-boarding activities in testing and production environments
- Analysis, Estimation, Design and Planning for enhancing the existing modules and bug fixes using distributed agile project development methodology
- Automation of manual activities to manage potential risks
- Provide Weekly status reports, Monthly status reports, SLA metrics to the customer.
Lead Engineer
Wipro Technologies Ltd
07.2012 - 07.2023
- Played role of a technical consultant, Managing and Organizing applications across Data Warehouse and Information delivery platforms for State Street Client.
- Managed and motivated project teams to promote collaboration and keep members on-task and productive
- Serve as Data Warehousing & Business Intelligence Consultant for ESP application, a State Street proprietary software product
- Support End to End data life cycle, right from data acquisition till data presentation/consumption
- Provide Level-4 application support for ESP application across several platforms and technologies
- Data flow monitoring to the persistent data marts for each individual instance (Business Units) spread across several servers in the multi thread mart refresh processing
- Monitor Service Level Agreements (SLA) on daily basis for the escalated issues form Level-1, Level-2 & Level-3 Support teams
- Participate in regular Agile Scrum meetings to discuss issues in the environment, performance issues and SLA misses
- Improve resiliency of the ESP application by identifying the bottlenecks in the current design and minimize the SLA misses
- Providing support and consulting for development team on system configuration during developing and testing and supporting business team queries on data issues
- Planning and execution of Client on-boarding activities in testing and production environments
- Analysis, Estimation, Design and Planning for enhancing the existing modules and bug fixes using distributed agile project development methodology
- Automation of manual activities to manage potential risks
- Provide Weekly status reports, Monthly status reports, SLA metrics to the customer.
- Responsible for 24 by 7 operations and 1st point of escalation for application related issues
- Responsible for keeping weekly KPI Dashboard Green
- Responsible for Incident Management, Problem Management, Knowledge Management, Capacity Management
- Responsible for resolving the incidents/service request within OLA
- Rectifying the problem with a solution within SLA
- Debugging procedures, packages and forms
- Mentoring team members on technical and functional area of the application
- Involved in providing root cause analysis and solution of repetitive issues
- Involved in Code and QA document review
- Involved in Testing like Functional testing and Unit testing.
Technical Specialist
PHILIPS Electronics India
06.2011 - 07.2012
- Responsible for 24 by 7 operations and 1st point of escalation for application related issues
- Responsible for keeping weekly KPI Dashboard Green
- Responsible for Incident Management, Problem Management, Knowledge Management, Capacity Management
- Responsible for resolving the incidents/service request within OLA
- Rectifying the problem with a solution within SLA
- Debugging procedures, packages and forms
- Mentoring team members on technical and functional area of the application
- Involved in providing root cause analysis and solution of repetitive issues
- Involved in Code and QA document review
- Involved in Testing like Functional testing and Unit testing.
Senior Software Engineer
CGI Information Systems and Management Consultants Pvt. LTD
01.2006 - 06.2011
- Worked at client location for around 2 months (CGI UK)
- Leading a team of 4 members
- Mentoring team members on technical and functional area of the application
- Responsible for providing 24x7 on-call production support
- Responsible for creating Design Document
- Responsible for review of Design Document
- Responsible for attending review meetings with End customers
- Analyzing the issue
- Rectifying the problem with a solution within SLA
- Creating SCR and doing code changes
- Involved in Performance Improvement of the application
- Involved in performance tuning of the SQL queries
- Involved in Testing like Functional testing and Unit testing
- Involved in Code and QA document review
- Debugging procedures, packages and forms.
Programmer
Prosoft Automation & Education
05.2005 - 12.2005
- Involved in direct end user interaction
- Involved in writing stored procedures, queries
- Involved in creating new GUI using Oracle Forms
- Involved in developing generating new reports using Oracle reports.
Education
Bachelor of Engineering - Computer Science & Engineering
Maulana Azad National Institute of Technology
Bhopal, India2003
Skills
Operating System:
Windows, UNIX, Linux
Programming Languages & Middleware:
Flex - UI, Data Hub Inbound/Outbound (Web services, MQ, SFTP) & Data Service Layer (Physical & Logical Data Marts), Shell Script, SQL, PL/SQL, HTML, Pro C
Databases:
Oracle 9i/10g/11g/Exadata, Sybase
Other Utilities:
Service now, Dynatrace, Autosys, Putty, Toad, Squirrel, Microsoft Office suite tools, ISM
Data Warehousing:
Data Acquisition, Transformation, Extraction
Front End Tools:
Oracle Developer 2000, Oracle Forms 9i/10g
Reporting Tools:
Oracle Reports 9i/10g, SQL Reports
Timeline
Associate Consultant
TCS
07.2023 - Current
Lead Engineer
Wipro Technologies Ltd
07.2012 - 07.2023
Technical Specialist
PHILIPS Electronics India
06.2011 - 07.2012
Senior Software Engineer
CGI Information Systems and Management Consultants Pvt. LTD
01.2006 - 06.2011
Programmer
Prosoft Automation & Education
05.2005 - 12.2005
Bachelor of Engineering - Computer Science & Engineering
Maulana Azad National Institute of Technology