SUMMARY:

• Overall 5+ years of technical and functional expertise on Oracle Utilities applications - Confidential /CCB, MDM, Billing Expert, Lodestar.
• Currently working as a Confidential /CCB designer and developer for US Utilities Clients 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, Confidential /CCB, Stream serve, etc.
• During this career of 5 year I got chance to work on multiple life cycle phases of various projects. I have been part of go-live process for 3 client, 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:

• Worked on BO, Algorithm, Scripts, X-path and Java in Oracle MDM 2.0, Confidential /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.
• Oracle SQL/PL-SQL
• Oracle Lodestar
• Oracle Lodestar Billing
• Java (J2EE)
• Oracle Master Data Management (MDM)
• Smart Grid gateway (SGG)
• Oracle Confidential /CCB (Customer care and billing)

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer / Designer

Responsibilities:

• Batch Monitoring and batch support, providing remediation for Issues.
• 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 Confidential /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 Confidential enhancement related to several functionalities.
• Point of contact for all Batch and Deployment related activities.

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

Confidential

Software 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 deigner/ 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: used: HPQC. Oracle MDM 2.0 SGG along with MDM Eclipse for Java code changes

Confidential

EDF Voyager Development

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: used: HPQC. Clear Case. MDM 2.0 Eclipse for Java code changes

Confidential

Software Developr

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: used: 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

Tools: Used: Oracle SQL Developer Oracle Lodestar CCS Oracle Lodestar Data Manager Lodestar LTMH Adapter Siebel CRM Eclipse VSS (Migration & Release) Microsoft Visual Studio.

Confidential

Software Developer

Responsibilities:

• Creating Accounts and Loading data using ccs and Data Manager.
• Writing Rate Schedule for Calculating Bill based on On-Peak and Off-Peak usage.
• Raising work queue for any error. Creating TOU Schedules.
• Generating XML of bill. Using Riders to make entry in Transaction table.
• Calculating the remaining adjustment of bill. Writing xsd for bill payment of a particular customer.
• Learning: - Have Hands-on on 'List'. Have worked on Adapter for Loading Data.
• Have Hands-on on using Rates Schedules and Riders.
• Created XSD file to input data from Report Admin. Used Report Run option to input data.
• Have Hands-on on creating and using TOU Schedule.