PROFILE SUMMARY:

• Overall 8+ years of technical and functional expertise on Oracle Utilities applications - MTM/CCB/MWM, MDM, Billing Expert, Lodestar.
• Currently working as a MTM/CCB/MWM designer and developer for Confidential and involved in defect fixes, change requests and solution for enhancements.
• Worked on various utilities tools and aspect including MDM-SGG, Lodestar, Oracle PL/SQL, MTM/CCB, Stream serve, etc.
• During this career of 8 year I got chance to work on multiple life cycle phases of various projects.
• I have been part of go-live process for 3 clients, have seen deployment of multiple releases, and have worked in long term support for two projects, worked on development/design phase of 2 clients.
• Have worked/resolved issues on Upgrade of MDM SP3. Apart from functional and technical aspect have helped design/develop processes to accomplish various task like deployment, day to day validation, etc.

TECHNICAL SKILLS:

Technical Aspects Covered: Worked on BO, Algorithm, Scripts, X-path and Java in Oracle MDM 2.0, MTM/CCB, and Integration between various Utilities products. Proficient & extensive experience in Oracle PL/SQL, SQL Performance Tuning, Oracle - Lodestar (Web services, Rate Schedules, Adapters.) Microsoft products like Excel, Word, power point, Excel Macro, VB Script, and Batch Script. Other skills like Java, J2EE, XML, html, java script.

Functional Aspects Covered: Read Load and Validation, Read Estimation, Billing, Payment, collection, Letters, Smart Metering/Smart Grid, Auto payment, payment plan. Supplier transaction 814, 867,810, 820, 568, 824 and 248, Rate Ready, Bill ready and Dual Bill solution.

SKILL:

Oracle SQL/PL-SQL

Oracle Lodestar

Oracle Lodestar Billing

Java (J2EE)

Oracle Meter Data Management (MDM)

Smart Grid gateway (SGG)

Oracle MTM/CCB (Customer care and billing)

Oracle Master Transaction Management(MTM)

Oracle Mobile Workforce Management (MWM)

PROFESSIONAL EXPERIENCE:

Confidential

Application Designer/ Developer Specialist

Responsibilities:

• Working as Onshore lead and Onshore coordinator.
• Working closely with Business team to support daily activity and enhancement as per PUC standard.
• Working on designer/developer for MTM/CCB related Java codes, Script or configuration for Performance Tuning and fixing logic.
• Working with Enhancement teams for various releases like Bill Ready solution, On-cycle supplier switches, Seamless Move, Instant Connect, etc.
• Solution architect for MTM enhancement related to several functionalities.
• Point of contact for all Batch and Deployment related activities.
• Working on designer/developer for Oracle tool MWM as well.

Tools: used: HPQC. Oracle MTM/CCB (Master Transaction Management) Oracle MDM SP3 (Meter Data Management) Oracle MWM (Mobile Workforce Management) Jenkins Eclipse for Java code changes

Confidential

Software Developer / Designer

Responsibilities:

• Working closely with Business team to support daily activity and enhancement as per PUC standard.
• Working on designer/developer for MTM/CCB related Java codes, Script or configuration for Performance Tuning and fixing logic.
• Working with Enhancement teams for various releases like Bill Ready solution, On-cycle supplier switches, Seamless Move, Instant Connect, etc.
• Solution architect for MTM enhancement related to several functionalities. Point of contact for all Batch and Deployment related activities.

Tools: used: HPQC. Oracle MTM/CCB Oracle MDM SP3 Jenkins Eclipse for Java code changes

Confidential

Software Developer / Designer

Responsibilities:

• Monitoring Batches and providing long term and short term remediation for the MDM Issues.
• Helping Business folks related to technical Issues faced while daily operations.
• Creating/ Monitoring reports needed for daily operations like read expected Vs actual read load, Device tamper, etc.
• Identifying/analyzing defects and deciding the severity of Issues.
• Prioritizing the issues and helping business to streamline the process.
• Analyzing Issue and Designing solution for the Issues/Enhancements and working with offshore team to fix the Issue.
• Supporting/ Developing solution in case of major issues on spot and getting them fixed readily like DST related issues etc.
• Addressing additional business requirement as change request and identifying impact of that on current system .
• Helping other enhancement team to come to the better solution and identifying impact of enhancement. Providing work around for non-major Issues and developing process to handle exceptional scenarios. Clarifying and creating service request from Oracle support team.
• Worked closely with MTM and CCB technical Leads to resolve MDM related Issues.
• Understanding process and floe of system and Suggest/Designing process and program improvements in MTM/CCB.
• Supporting Testing and deployment support for release and enhancement.
• Doing supplier Testing for Quarterly of suppliers for all transactions.
• Helping Business to analyze the severity of issues and prioritize Issues.
• Coordinating with Offshore team regarding fix and verifying the changes done.

Confidential

Application Developer / Designer

Responsibilities:

• Designing solution for the Issues/ Enhancements and working with offshore team to fix the Issue. Worked on coding and configuration part of MDM to fix defects in case of urgent Issues and critical defects.
• Customized Business Objects according to business requirements.
• Customized Algorithm and Scripts to get relevant values.
• Worked on MDM related Java codes for Performance Tuning and fixing logic.
• Used XAI Submission to unit test the changes.
• Independently developed java codes to improve performance of Interface Batches.
• Updated technical design and Transition documents for Support Team.
• Helped the testing support team. Part of migration process from MDM and MDM-CCB Sync process. Lead designer/ on point person for all MDM migration Issues. Part of multiple go-live mock and dress rehearsal. Main go to person for all Batch and MDM Issues before and after system went live.

Tools: HPQC, Oracle MDM 2.0, SGG along with MDM, Eclipse for Java code changes

Confidential

Software Developer

Responsibilities:

• Worked on coding and configuration of MDM to fix defects.
• Customized Business Objects according to business requirements.
• Customized Algorithm and Scripts to get relevant values.
• Worked on MDM related Java codes for Performance Tuning and fixing logic.
• Used XAI Submission to unit test the changes.
• Independently developed java codes to improve performance of Interface Batches.
• Updated technical design and Transition documents for AO Team.

Tools: HPQC, Clear Case, MDM 2.0, Eclipse for Java code changes

Confidential

Software Developer

Responsibilities:

• Resolve Defects
• Analyzing Defects
• 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

Tools: Stream serve Design Center, Stream serve Control Center, Clear Case., X Path 1.0 is used in Stream serve.

Confidential

Software Developer

Responsibilities:

• Extensive hands on experience on Lodestar Rate Schedules, LTMH Adapters etc.
• Extensively worked on Oracle PL/SQL(Procedures, Functions, Packages etc.), SQL Performance Tuning.
• Worked in Java, .Net, VB Script, Batch Script, etc to accomplish business requirements.
• Providing solutions to existing defects and enhancements