Profile

An experienced IT professional with database & Unix administration skills. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. Currently working in a demanding product implementation and production support environment managing large volumes of business critical data. A committed team player, self motivated with the ability to communicate at all levels.

• Oracle Utilities Customer Care and Billing (CC&B), WAM, MDM, BI-Publisher and OUBI Administrator and CC&B Data Migration specialist.
• Successfully completed one full life cycle of CC&B implementation, upgrade and support.
• Core expertise in implementation, installation, CCB Data migration, designing, maintenance and support of large mission critical apps with multiple versions of Oracle database 10g, 11gR1 & 11gR2 database system.
• Responsible for installation of applications and Oracle database, upgrades, patches, packages, single fixes cloning , Weblogic administration, Oc4j administration, Database performance & tuning, cloning Oracle Apps and Database SYSADMIN functions, batch configuration , threadpoolworker configuration , micro focus license installation , users creation, database creation, SQL statement tuning, backup/recovery, general troubleshooting.
• Specialized knowledge and expertise on Unix-Sun Solaris, HP-UX and Oracle Platforms.
• Widely contributed to the success of Indian and global customers like UP-RAPDRP, Haya Water, Sprint, HP and others across USA, UK and Middle East.
• Acquainted with the nitty-gritty involved in working in global offshore support scenarios

AREAS OF EXPERTISE

• Project management
• Production support
• Hardware(H/W) and Software(S/W) sizing
• Due Diligence
• Application and Database administration
• Team Management
• CCB Data migration

Work Experience:

Confidential-Senior Consultant-Aug 2010 – Till date
Confidential-Senior Software Engineer-June 2007 – July 2010
Confidential-Technical Support Engineer-Feb 2005 – June 2007
Confidential-Technical Support Executive-March 2004 – Feb 2005
Confidential-Service Engineer-Nov 2002 – Feb 2004
Confidential-Project Trainee-Jan 2002 – July 2002

• Master of Science in Information Technology from Confidential, Tamil Nadu.
• Bachelor in Computer Applications from Confidential, Hyderabad.

Certifications

Sun Certified System Administrator (SCSA) for Solaris 10.0 version
A+ Certification
ITIL V3 version

Technical skills

ERP: Oracle CC&B, Work Asset and Management, BI-Publisher, OUBI & MDM 2.0.1 Administration and Data Migration of CC&B
Operating Systems: Oracle Solaris, HP-UX, Linux, Windows 2003 & 2008
Languages: SQL, PL/SQL, Unix Shell Scripting
DBA Tools: TOAD & SQL-Developer
RDBMS: Oracle 10G and 11g R1/R2
Publishing: MS Office
Job Scheduler Tool: Control-M
Other Technologies: Hardware (Desktop/Laptops) & Networking

Company Confidential
Tenure Aug 2010-Till date
Designation Senior Consultant
Clients UP-RAPDRP, India; Haya Water, Middle East; NDMC, India.
Brief Role Oracle Utilities Customer Care and Billing (CC&B), WAM, MDM, BI-Publisher and OUBI Administrator and CC&B Data Migration specialist. Playing a key role in H/W and S/W sizing for the new business proposals. Responsible for training new and existing employees.

Project: Confidential, India Feb 2011-Till date
Oracle CC&B 2.3.1 Implementation Project.

This project aims to customize Oracle Utilities Customer Care & Billing 2.3.1 application for customer service and billing process of the Electric Utility Company.

Responsibilities:

• Oracle CC&B, WAM, MDM and BI-Publisher Administration.
• Set up the Development and Production Environments.
• Performed Environment management and Release deployment activities.
• Setup the Config Lab in T&D environment.
• Setup the migration environment to test and perform the data migration.
• Setup the production in a clustered environment and tuned the parameters for the CCB, XAI and Batch instances.
• Performance tuning of the Data Migration Batch jobs.
• Post production go-live support.
• Worked on the estimation of H/W and S/W sizing for the applications.

Project: Confidential, Middle East Aug 2010-Till date
Oracle CC&B 2.3.1 Implementation Project

This project aims to customize Oracle Utilities Customer Care & Billing 2.3.1 application for customer service of the Waste Water Utility Company.

Responsibilities:

• Oracle CC&B and BI-Publisher Administration of Haya Water.
• Set up the Development and Production Environments.
• Involved in Environment management and Release Deployment activities.
• Setup the migration environment to test and perform the data migration.
• Involved in overall CC&B end-to-end data migration design, planning, development, monitoring resources and go live implementation.
• Post production support.
• Trained the client resources on CC&B Administration and Data migration. Responsible for preparing training manual for the new and existing employees in the team.

Project: Confidential - Due Diligence for NDMC Feb 2012-Mar 2012
Oracle CC&B & MDM 2.3.1 Due Diligence

This project aims to investigate the existing setup of CC&B and MDM at NDMC (New Delhi Municipal Corporation) and provide the gap analysis to complete implementation of CC&B and MDM.

Responsibilities:

• Studied the existing H/W sizing of CCB, BI-Publisher and MDM with the information on the number of customers and concurrent users and provided the gap analysis.
• Studied the existing data migration procedure of CC&B and the migration setup to move the legacy data into the production and provided the gap analysis.

Company Confidential
Tenure June 2007 – July 2010
Designation Senior Software Engineer
Client Sprint, USA
Brief Role Provided operational support for a major US telecom company\\\'s production Oracle data warehouse. Managed six members team, monitoring the database jobs on Unix productions servers and ensure that the jobs are up.

Responsibilities:

• Monitor the database jobs using the Control-M, Autosys, TOAD & Putty tools and ensure that the jobs are running as per schedule.
• Monitor alert log files and kill unwanted user sessions or processes.
• Do the root cause analysis for the failed database jobs.
• Writing SQL queries to monitor the jobs from TOAD and to check the data.
• Analyzed and understood the PL/SQL code written in KSH files and resolved the issues accordingly
• Check the log files of the SLA/Critical jobs periodically and ensure that the jobs are up.
• Attended bridge calls with the Users, Developers, SA’s and DBA’s to support planned maintenance or backup of database or to resolve any priority1/priority2 issues.
• Co-ordinate with the developer’s for modifying the code in KSH files.
• Running the queries for modifying, updating, deleting or inserting data into the table.
• Create Work orders for the maintenance using the HP open view tool.
• Analyze/Validate the data and eliminate the duplicate records if any.
• Managed a team of six people. And taken care of scheduling them in different shifts, conducting weekly team meetings and providing the team with process updates and also taken care of their appraisals every year

Company Confidential
Tenure Feb 2005 - June 2007
Designation Technical Support Engineer
Client HP Global
Brief Role Supporting HP commercial customers on Desktop, Thin Client, Laptop hardware, Operating system (Windows flavors & Linux) and Networking.

Responsibilities

• Intensive research on customer issues related to hardware, network and operating systems and providing the appropriate solution for the issues through e-mails, instant support and telephone support.
• Maintain interactions with the customer using Clarify tool and also use to dispatch parts and set up an on-site service to the customers.
• Mentoring the new hires.
• Providing the floor support, owning the escalation issues and resolves it on the basis of First Time Fix.
• Reviewing the dispatches done by the front line engineers.
• Part of NA-EMEA integration project dry run. SPOC for the PSG group JDPA certification.
• Developed a portal for the process as a repository for the known issues with a team size of two. Integrating all the tools used by the frontline engineers and introduced auto case creation process and logging cases on the portal.
• Following up escalations by calling up customers and resolving the issues over call.
• Performed as MOD (Manager On Duty) to ensure that the SLA of the process is me

Company Confidential
Tenure March 2004-Feb 2005
Designation Technical Support Executive
Client VSNL, India
Brief Role Supporting VSNL ISP customers on technical issues.

Responsibilities:

• Troubleshooting and resolving the internet connectivity issues.
• Providing the floor support and handling the escalation calls.
• Specialized in troubleshooting, VOIP related issues.
• Providing technical information to the customers on features of VOIP and other VSNL related products.
• Within six months, selected into the Core Technical Team and taken training sessions on Technical and Logical troubleshooting, product and proces

Company Confidential
Tenure Nov 2002-Feb 2004
Designation Service Engineer
Client SIPTEL, USA & India
Brief Role Providing VOIP solutions to the corporate and home users.

Responsibilities:

• Providing support on VOIP products like Dial-UP and LAN enabled VOIP phones.
• Analyzing and providing corporate solutions on VOIP, according to their requirement.
• Providing demonstrations on various VOIP products like FXS, FXO and LAN enabled phones to the corporate customers.
• Within six months became Senior Service Engineer and headed four district franchisees and also team of three Service Engineers.

Company Confidential
Tenure Jan 2002-July 2002
Designation Project Trainee
Client Confidential, India
Brief Role Developed a Project-Material Purchase Requisition (MPR) which generates a unique MPR NO

Responsibilities:

• Developed a project called Material Purchase Requisition.
• Worked on UNIX platform, oracle 6i, SQL Forms, SQL Reports and Pro*c.
• Written PL/SQL procedures and created a front end application using SQL Forms.
• Generated reports using the Pro*c and SQL Reports