Career Objective:

To work in a challenging environment which would help me apply and grow my functional, technical and analytical skills in different areas of business along with adding value to the organization to achieve its objectives and goals.

Career Profile:

• Oracle Utilities Meter Data Management Consultant, Oracle PL/SQL expert.
• Senior Software Analyst for Development and Application Maintenance projects in the Utilities domain. Provide functional technical for Oracle Utilities. Majorly includes performing development/enhancements design, code, build, test, Deploy as well as UAT support for new/existing requirements. Client interaction to understand their requirements and expectations.
• Enhancement profile includes requirement gathering, functional, technical designs as well as performing impact analysis. Providing SME assistance on the project.
• Extensive hands-on experience on Oracle SQL PL/SQL Procedures, Functions, Packages and so on , SQL Performance Tuning etc.
• Also, have configuration, technical and functional expertise on concepts of VEE.
• Oracle Meter Data Management: Extensive hands-on experience on MDM OOB modules as well as Lodestar modules like Rate Schedule, LTMH Adapters, and Web Services etc.
• For AO Maintenance projects, streamline the business processes handle production issues, Root Cause Analysis as well as providing quick solutions and workarounds.
• Oracle Lodestar 1.5 Billing Component : Extensive hands-on experience on Rate Schedule, LTMH Adapters, and Batch jobs etc.

Programming Lang: Oracle MDM Rules Language, Oracle SQL PL/SQL

Database: Oracle

Tools: Oracle SQL Developer, TOAD, Oracle Lodestar 1.5/1.6 CCS, Data Manager Etc.

Soft Skills:

• Good Team Player
• Excellent communication skills fast learner
• Proficient troubleshooting skills
• Proficient multi-tasking skills

Career Projects

Confidential

Oracle PL/SQL Developer, Oracle MDM

Role: Oracle Utilities MDM Consultant

Team Size: 6

Brief: Client is a major Confidential company in Southern Pennsylvania. Their system currently consists of Oracle MDM Billing as well as Validation/Editing/Estimation.

Project Role Description:

• Oracle MDM Consultant, Developer, Application Maintenance Troubleshooter
• Majorly involved in:
• Enhancements
• Bug fixing
• Performance tuning
• Application Maintenance activities like troubleshooting, batch monitoring etc.
• Worked extensively on :
• Oracle MDM concepts of VEE Validation/Editing/Estimation
• Oracle MDM Billing
• Market transactions:
• Meter Add
• Meter Exchange
• Meter Connect
• Meter Disconnect
• Read Cancel
• Read Updates and so on
• Performance Tuning using Oracle PL/SQL
• Batch monitoring, troubleshooting production issues and streamlining AO processes
• Extensively worked on Oracle MDM Rules Language, LTMH Adapters, and Web Services etc. , Oracle PL/SQL, SQL Performance Tuning etc.
• Worked on projects:
• AMI Meter implementation
• GAS AMI meter implementation
• Complex Meter Billing

Tools Used

• Oracle SQL Developer
• Oracle Lodestar EIP
• Oracle Lodestar Data Manager
• Lodestar LTMH Adapter
• SVN Migration Release

Technologies Used: Oracle PL/SQL Developer

Role: Offshore Integration Team Lead

Team Size: 6

Brief: Client is a US based Confidential company in the de-regulated market. We have provided Customer Care as well as Billing solution to the client. Oracle Lodestar has been used for Billing. The system has integration between Seibel and Lodestar. I was leading the AO Integration team from Offshore.

Project Role Description:

• Oracle PLSQL/Lodestar Consultant , Solution Designer, Developer
• Leading the Integration team from Offshore
• Integration was between below systems:
• Siebel CRM Oracle Utilities Lodestar
• Oracle Utilities Lodestar 3rd Party vendors
• Siebel 3rd Party Vendors
• Providing solutions to existing defects and enhancements
• System and Performance Enhancements
• Bug fixes
• Provide support to client's daily business operations
• Real-time Production Issues
• Batch Jobs
• Daily Business Process monitoring and fixes
• Daily Client Business Reporting
• Change Release management
• Extensively worked on Oracle PL/SQL Procedures, Functions, and Packages etc. , SQL Performance Tuning, Lodestar Rate Schedules, LTMH Adapters etc.
• Extensively worked on
• Market Transactions TDSP/LDC EDI transactions
• 814 Customer Maintenance
• 650 Service Order
• 867 Usage
• 810 Invoice
• 820 Remittance
• External Interfaces
• Payment Real-time File based
• Credit Check functionality
• Bill Print Vendors
• Self Service Portal
• Third Party Vendors
• Internal Interfaces between Siebel and Lodestar
• Functional understanding of Billing Collection Modules
• Techno - functional knowledge of Siebel CRM
• Project Training to new team members:
• Functional training w.r.t current system, processes and functionality
• Technical training included SQL, Oracle PL/SQL, and Lodestar Tools: CCS, Data Manager Etc.

Tools Used

• Oracle SQL Developer
• Oracle Lodestar CCS
• Oracle Lodestar Data Manager
• Lodestar LTMH Adapter
• Siebel CRM
• Eclipse
• VSS Migration Release

Confidential

Role: Software Engineer

Team Size: 16

Brief: Client is one of the biggest Confidential. I was part of the Datafix team. Our domain includes fixing data issues occurring w.r.t individual or multiple policies. It also includes doing technical analysis and fixing the data.

Project Role Description:

• Analyzing and understanding the requirements from the client team to create Oracle PL/SQL scripts.
• Development of Oracle PL/SQL scripts Creation of Technical Analysis Document for Client team reference.
• Creation of generalized/dynamic scripts which can be customized for different purposes.
• Responsible for building the code, testing the scripts and creating the complete deliverable to be sent to the client.
• Perform Peer Review.

Tools Used:

• Oracle TOAD for SQL, PL/SQL
• IBM Rational ClearQuest
• Certified Level 2 in Italian Language

Confidential

Technologies Used: Oracle SQL Developer

Role: Associate Software Engineer

Team Size: 14

Biggest Consumer Electronics goods Retailer in Confidential with more than 19 market accountability. I was part of the Customer Relationship Management Team. Our domain included handling issues occurring with Customer data management/Application Management with the client. We have to deal with live production issues. We are working as per the Onshore-Offshore model.

Project Role Description:

• Handling any critical issues or breakdowns that might occur in the system.
• Resolving tickets due to job/process failures. It also included resolving functional tickets
• Documentation of Handbook to resolve job failures.
• Monitoring of critical UNIX processed and SLA critical batch jobs.
• Created weekly and monthly reports to be presented to the business as well as Metrics for the clients.
• Handled Database and Server Outages.
• Process Improvements
• It included identifying bugs and fixing the same in production after testing in Dev and Testing environments.
• Performing RCA Root Cause Analysis
• Worked extensively on UNIX, Oracle PL/SQL, and SQL Performance Tuning.

Tools Used:

• Oracle PL/SQL
• UNIX