Project Technical
Resume:
SUMMARY
Highly motivated technical consultant with 11 years of experience in development, implementation, and production support, maintenance engagements on various domains like Insurance, Retail, Travel and Hospitality.
Experience in leading and mentoring the technical team for 3 development projects.
Strong technical expertise in Oracle Forms, SQL, PL/SQL, Oracle Reports, UNIX, SQR, Pro*C, Stream Serve Report.
Strong experience in performance tuning of SQL.
Excellent in handling and coordinating with client in the phases of Requirement Gathering, Design, UAT and Production support.
Experience in analyzing existing code base and providing necessary inputs to the business to make the existing system more effective and users friendly.
Thorough experience on software development methodology and quality process. Worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation.
TECHNICAL SKILLS
OLAP Tools
SQLPLUS,TOAD,SQL Navigator,Reports6i/10g, Forms6i/10g,SQL Loader,
Streamserve Reports, SQR Debugger
Programming Languages
SQL, PL/SQL, Shell Script, Pro*C, SQR
BiG Data Hadoop
Ecosystem, HDFS, Map reduce, PIG, HIVE, SPARK, SQOOP, FLUME
CERTIFICATION:
BIGDATA HADOOP certification from Edureka after completing training.
EMPLOYMENT HISTORY
Name of the Company
Designation
From
To
Cognizant Technologies Solutions
Sr -Consultant ERP
Oct 2006
Till Date
EXPERIENCE SUMMARY
PROJECT PROFILE 1
Project Title
Compliance Project [Client: Leading US based Insurance Group]
Domain
Insurance
Technical Skills
ORACLE SQL,PL/SQL, Unix, Autosys, Oracle Reports
Role
Project Lead/Technical Architect
PROJECT DESCRIPTION
Enhancement and maintenance of the system [which is mainly used for quotation and policy maintenance and other administrative activities]. This is forms based system and as part of this project all pending issues need to be resolved.
ROLES AND RESPONSIBILITIES IN THE PROJECT
Understanding the business, preparations & reviews of technical specifications and feasibility analysis and resolving open issues or assets.
Preparing design document as per requirement.
Analysis of existing code base and providing necessary inputs to the business to make the existing system more users friendly.
Implement generic database stored procedures to comply with existing system.
Develop new package, procedure, trigger for business requirement.
Ticket monitoring and assisting team to resolve the same.
Support post production.
PROJECT PROFILE 2
Project Title
RMIS Rewrite Project (Client: Leading US based Insurance Group)
Domain
Insurance
Technical Skills
ORACLE SQL,PL/SQL, Unix, Autosys, Oracle Reports
Role
Project Lead/Technical Architect
PROJECT DESCRIPTION
Enhancement and maintenance of the system which is mainly used for reporting purpose and there are GUI interfaces also. Rewrite of existing system to incorporate functionalities which are currently available in other systems upstream systems, along with that enhancing the existing system functionality.
ROLES AND RESPONSIBILITIES IN THE PROJECT
Understanding the business, preparations & reviews of technical specifications and feasibility analysis and resolving open issues or assets.
Preparing design document as per requirement.
Analysis of existing code base and providing necessary inputs to the business to make the existing system more users friendly.
Implement generic database stored procedures to comply with existing system.
Develop new package, procedure, trigger for business requirement.
Ticket monitoring and assisting team to resolve the same.
Support post production.
PROJECT PROFILE 3
Project Title
Enhancement and Support (Client: Leading US based T&H company)
Domain
Travel & Hospitality
Technical Skills
ORACLE Forms, SQL,PL/SQL, SQR, Unix
Role
Project Lead
PROJECT DESCRIPTION
The CRS is a critical component of this application and is used by the corporate and franchise call centers, to initiate reservations. Cognizant have to provide complete support, maintenance to the entire system along with development. Monitoring issues and to resolve them within pre-defined time based on priority.
ROLES AND RESPONSIBILITIES IN THE PROJECT
Understanding the business, preparations & reviews of technical specifications.
Feasibility analysis and resolving open issues.
Preparing design document as per requirement.
Analysis of existing code base.
Providing necessary inputs to the business to make the existing system more users friendly.
Implement generic database stored procedures to comply with existing system.
Develop new package, procedure, trigger for business requirement.
Enhancement in SQR.
Ticket monitoring and assisting team to resolve the same.
Support post production.
PROJECT PROFILE 4
Project Title
Maintenance and Support (Client: Leasing US based Retail group)
Domain
Retail
Technical Skills
ORACLE SQL,PL/SQL, Unix
Role
Technical Lead
PROJECT DESCRIPTION
Cognizant have to provide complete support, maintenance to the entire system, monitoring issues and resolve them within pre-defined time based on priority.
ROLES AND RESPONSIBILITIES IN THE PROJECT
Providing production support to the existing forms based system.
Involved in, Understanding requirements from business user for enhancement.
Understanding the business needs and conceiving solutions.
Develop new forms and library to support the new component.
Ticket monitoring and assisting team to resolve the same.
PROJECT PROFILE 4
Project Title
SHOM, CERN2, DAM8 (Client: Leading UK based T&H company)
Domain
Travel & Hospitality
Technical Skills
ORACLE Forms, SQL,PL/SQL, Pro*C, Unix, Streamserve Report
Role
Developer
PROJECT DESCRIPTION
Cognizant was supposed to fix existing issues based on priority setup by client, define appropriate resolution and escalation procedures, optimize cost without quality trade-off.
ROLES AND RESPONSIBILITIES IN THE PROJECT
Understanding the business, preparations & reviews of technical specifications.
Preparing design document based on the requirement provided by business.
Providing necessary inputs to the business for the improvement of the existing system.
Analysis of existing defects.
Fix and unit test already analyzed defects.
Prepare enhancement bug fix report [EBR].
Fixing bugs reported by internal system testing team.
Providing post-production support.
Fixing defects and developing Pro*C batch files for nightly batch jobs.
Migrating KSL reports to Streamserve.
Enhancement of billing batch by developing new Pro*C files.
Contact this candidate