SUMMARY:

• I am a Senior Software Developer and Analyst with total of 7.11 Years’ experience in IT industry.
• I have excellent end to end domain knowledge of Energy and Gas Utilities.
• I have extensive experience in all phase of a software development such as Analyze, Design, Build, Unit Test, System Test, Defect Analysis and Fixing, Deployment and Warranty.
• I am highly experienced in System Analysis, Functional and Technical Solution Designing and Development.
• I have extensive experience in Production Support of an enterprise large system.
• I have leaded technical team at onsite and offshore for the Billing and Interface module and monitored the progress of deliverables through deliverable tracking tool.
• I have worked on Oracle CC&B and Oracle Lodestar implementation for Energy Retail Company and Gas Utility Company. Experience with OUAF architecture.
• I have worked on Oracle CC&B modules such as MTM, Confidential, Billing, Payment Processing and Financial Transactions.
• I have written algorithms/plug - in scripts to accommodate business requirements such as Usage, Invoice and Payment transaction generation in Oracle CCB MTM Module.
• I have worked on the various entities such as Premise, Service Point, Meter and Items that are involved in Meter management.
• I have worked on Oracle Lodestar (Oracle Utility Billing) modules for non-enterprise billing application.
• I am expert in creating SQL Queries, PL/SQL Packages, and Function, stored procedures, triggers and Views. Expertise in data extracting technique.
• I have worked on user interface applications for data entry into oracle database through C# ASP.NET web development environment.
• I have effective verbal and written Communication Skill and excellent client facing experience.
• I have experience working with Texas Electric Confidential Market Transactions and NJ Gas Confidential Market Transactions.
• I have extensive and strong coding skills of Oracle Lodestar Rules Language, Java and Hibeation.
• I have worked with Retail clients Confidential and NRG in Texas and leading energy company in North Carolina - Confidential .
• I have worked with Gas and Electric utility companies such as South Jersey Gas and Confidential (San Diego Gas and Electric)
• I have worked in challenging and deadline driven environment with appreciation from Client and Project Management team for excellent technical and communication skills

TECHNOLOGY:

• Oracle Utilities CCB 2.4
• Object Oriented Programming - Java, C++ and C#
• Oracle PL/SQL, SQL
• LODESTAR® Data Manager - Rules Language (Oracle Utility Billing)
• Oracle Lodestar EIP (CCS- Customer Care Suite)
• Oracle 12c,11g, 10g, 9i, 8i
• Visual Studio 2010
• Web Development Technology - ASP.NET, XML, HTML
• Window 7, XP
• TOAD 10.6, SQL Developer
• Unix and Perl Scripting
• Version Control Tools - Dimensions, Visual Source Safe and MKS
• Altova XML Editor
• Oracle MDM 2.0
• Eclipse /Hibernation
• MS Access, Excel, Power Point, Visio
• FileZilla, Putty
• Defect Logging and Monitoring Tool -HPQC and HPALM

PROFESSIONA EXPERINCE:

Sr. Software DevelopeR

Confidential, Folsom, NJ

Responsibilities:

• Work on Oracle CCB MTM (Market Transaction Module) to handle market transactions and Confidential interfaces.
• Leading the MTM and Confidential module from onsite as a technical and functional point of contact for any issues related to Market Transaction and Confidential occurring in production.
• Work on CCB configuration to handle various custom business scenarios.
• Creating Plug-in scripts, service scripts, BPA scripts to process inbound transactions
• Creating and modifying existing XAI Web Service as per defect and working with business object schema
• Work on Zone, Fields, Lookup, UI Map, Data area to handle business validations
• Create and modify programs in Java/Hibernation to handle custom batch processing using Eclipse and artifact generation concepts.
• Analyzing the root causes of issues rose in production by users and propose solutions to business.
• Track the defects and tickets raised for production issues through HPALM tool and keep them up-to date.
• Prepare Business Requirement documents for new requirements/enhancements and send it to client for approval.
• Update existing requirements and get approval for solution implementation.
• Develop solution by coding in Oracle CCB using algorithm and scripting language and debugging the issue occurred in production.
• Create new Java programs using hibernation and modify existing Java programs for bug fixing.
• Work on XAI Interfaces to establish web interfaces between CCB application and ESG third party.
• Perform Unit testing, Alpha testing, Integration testing in various environment and help business with UAT testing.
• Understanding the business requirement in areas such as Confidential market transactions, Billing and Collections and translating them to technical aspect.
• Coordinating with offshore team of 3 resources for defects delivery and providing updates to client.
• Addressing technical and functional queries from offshore team and proving resolutions over email and through telephonic meetings.
• Coordinating Interface/MTM changes with Onsite Billing Functional team members for impact analysis and regression testing.
• Preparing training documents for application users whenever a new change goes into production.
• Coordinating deployment process of defects/changes going in production and establishing the channel between development team and deployment/environment team for error free deployment.

Confidential

Sr. Oracle Developer and Production Support

Responsibilities:

• Production support role of maintaining Confidential (Centralized Calculation Engine) application which is used for pricing and estimation of rate change before those change are made in production.
• Prepared knowledge transfer schedule from third party vendor to Confidential for application support activity and enhancement projects.
• Worked on Rate Configuration, Rate Analysis of Confidential residential and commercial rates.
• Worked on Rate Schedule and Rider coding to design and build new Confidential residential and commercial rates.
• Worked on Interface adapter and resolved any issue encountered in interval meter data or pricing data load.
• Worked on JSP and UNIX scripting to develop program for automating the process of error file monitoring and mechanism to send alert emails.
• Conducted knowledge transfer from onsite to offshore for understanding the application and working on defects/bugs.
• Worked on Pricing and Quotation Management Product.
• Performing enhancement and addressing user queries related to application in production environment though tickets.
• Worked with QA team to test end to end functionality of fixes/changes going in various environments.
• Preparing unit testing script and UAT testing script for business user for training.
• Providing estimation to client and business users for a proposed solution and following agile methodology to deliver.
• Worked with Onsite Program Manager and Offshore Project Manager for resource planning and estimation for new changes and project releases.

Sr. Software System Analyst

Confidential, Charlotte, NC

Responsibilities:

• Requirement gathering and analysis to provide estimate in the form of RICEF(Reports, Interface, Configuration, Extraction and Forms) for Transmission, Wholesale and Joint Owner Non-retail Billing of Confidential Carolina, Confidential Florida and Confidential Progress.
• Provide deliverable in Analyze phase such as process flow mapping and process walkthrough documents.
• Leading the Application Team of 6 members (4 onshore and 2 offshore).
• Involved in Designing of Data Model, Design Specifications and to analyze Dependencies.
• Working with functional team to gather requirement and documenting them into technical template for development.
• I work closely with functional team to Unit test and system test application modules through various mock testing.
• Developed and debugged the Application Screens and Reports using Developer suite tools.
• Design and build components (Rate schedule and Rider) in Oracle Utilities - Billing (OUB-Lodestar) in Rules Language.
• Worked on Oracle Lodestar Billing Expert and Oracle Lodestar FME (Finance Management Extension).
• Worked on Interval Data processing, error and exception handling in Lodestar. This involves developing riders using complex interval data functions.
• Worked on creating Rate Forms which calls BIP report instance from Rider/rate Schedule and generating reports on a file share location for printing and delivery to customer.
• Configuration and setting LodestarRS Reports and BIP reports.
• Analyze existing Dynamic Form to handle OUB Forms (manual data entry), debugging and making enhancements.
• Created database objects such as tables, views, indexes, sequences, functions, stored procedures, packages as per business requirements.
• Experience with modifying and deploying database objects - tables, views, stored procedures, triggers, packages, and functions in development environment.
• Performance tuning by writing complex stored procedures in PL/SQL.
• Worked on SQL Loader Control File to load files to data base.
• I have used UNIX commands for transfer of files. Merging and deleting files from server.
• Created XSDs for running reports from front end (EIP/CCS).
• Worked on C# .Net to design and build Web application for User Entry Form.
• Debugged existing C# and ASP.Net code using Visual Studio.
• Unit test the build components and make ready for User Acceptance Testing.
• Defect fix and migration during testing phase.
• Performed dress rehearsals and mock deployment for multi-pass testing phase.
• Created batch processes in ESP to execute in test and production environment.
• Created Service Introduction Overview documents for Production Support.

Confidential

Sr. Software Analyst

Responsibilities:

• Conversion project to convert Lodestar/Siebel data to SAP platform between client Green Mountain Energy in Austin TX and NRG Company in Houston TX.
• Creating Conversion documents to map data from Lodestar entity to SAP entity.
• Creating extractors to fetch data from tables in Oracle Lodestar to create Import files.
• Worked on analyzing the legacy data to be moved to data warehouse.
• Worked on PARTITION BY and RANKING logic to analyze the data in all dimensions.
• Invoice PDF Metadata XML generation process to transfer the legacy PDFs to new system.
• Created Control Point Reconciliation Reports. These reports were the mechanism to capture the exceptions raised due to control points i.e. business validation injected for non-actionable/converted accounts.

Confidential, Austin, TX

Oracle App Designer, Developer and Production Application Support

Responsibilities:

• Providing support, impact analysis and enhancement to the current business processes related to Interfaces such as Payments, Market Transactions, Web Interfaces and Billing/Customer Care.
• These interfaces are external as well as internal Interfaces developed in Lodestar and Siebel application.
• Estimate effort and finalize solution approach for new enhancement requested by client for Interface.
• Worked on batch scheduling through Windows Scheduler and worked with BSS team in scheduling/maintaining Production Batches.
• Solving Production Ticket/Incident/SIRs created for application by debugging existing functionalities.
• Extensive development and debugging on Lodestar Rules Language, Adapter, Customer Choice Suite (CCs), Web services.
• Worked on LSRate reports and debugging.
• Worked on Lodestar CCS Clips creation and modifying existing clips.
• Worked on code optimization techniques and extensive experience on code optimization.
• Worked on Batch Job Scripting, Complex Stored Procedures and PL/SQLs.
• Worked on Adapter Configuration validations (Java Scripting).
• Performance tuning of business processes in Lodestar such as Billing, Payments, Replication and Contracts. Used stored procedure (PL/SQL), RunRS and profiling features to examine and tune the performance of real-time interfaces.
• Developed PL/SQL packages, procedures, functions, Indexes, sql scripts for the implementation of the very complex business requirements on Oracle 10g environment.
• Worked on technical designs for customized report/clips on Lodestar CCS as part of TX4.0 implementation.
• Published testing bed for change management and help do regression testing whenever a change is implemented.
• Extensively worked on Texas Market Transactions and worked with ATMS ( Confidential Transaction Management System) for Confidential market transaction.
• Extensively worked on file based as well as web based interfaces with Oracle Lodestar.
• Created a new hourly monitoring job to track if the real-time payments received from Bill Matrix are below a certain threshold value. This pre-empted any issues related to Bill Matrix payments.
• This reduced critical tickets to be raised, which were 2 every month. It has also helped GMEC to know the reason for low payments due to Bill Matrix outage, thus helping GMEC Customer care to better communicate with customer in case of outages in vendor’s system.
• Automated the monitoring of unprocessed Checkfree payment files. The automated process helped Finance team in capturing unprocessed customer payments and apply them manually to account. This has significantly reduced the complaints on unapplied payment and late fee issues on customer invoices.
• Received Client and Confidential leadership appreciation for deliverables, application support and conversion project activities.
• Oracle Customer Care and Billing Experience
• I have worked on below modules:
• Customer Information- Navigation using Admin Menu, use of Control Center, Application Viewer for Entity Relationship Diagram.
• Plug-Ins and Algorithm - I have written algorithms/plug-in scripts to accommodate business requirements such as budget plan, adjustments.
• Meter Management and Device Configuration - I have worked on the various entities such as Premise, Service Point, Meter and Items that are involved in Meter management.
• Billing- Bill Cycle and Meter read cycle concept and implementation. Bill Segment Generation using meter read and rate on Service Agreement for a service.

Confidential, Austin, TX

Oracle Customer Care and Billing Designer and Developer

Responsibilities:

• Solution Designer and Developer, Analyst. My Job was mainly to analyze, design and build the Lodestar Interfaces, Java Interfaces. Extensively involved in system and business requirement gathering from Client and involved as Lodestar Consultant in Client business processes.
• Developed Function and Technical Designs for Interfaces.
• External Interfaces - such as Bill print vendor ( Confidential ), Payment vendors (Checkfree, Metavante, Chase, Fiserv (online payment) and CSI(Third Party Collection)), CCH (Tax managing organization). Transmission Distribution System Provider and Local distribution Company related interfaces ( Confidential Transactions) - 810 Invoice, 867 Usage, 820 Payment, 650 Service Order, 824 Application Advice and 997 IFA. Internal Interfaces - Integrating Siebel and Lodestar to replicate customer information from Siebel to Lodestar. Siebel Interfaces - Web interfaces to capture data from a web page and load into Oracle Database.
• Worked on deliverable like Build Components, Unit Test Pack (UTP) and data transformation sheet from Confidential to XML.
• Worked on Requirement Traceability Matrix and extensive client interaction on requirement gathering and analysis.
• Extensive development on Lodestar Adapter, Customer Choice Suite(CCs), Web services as integration tool for Build components.
• Done Peer review of designs and code and have good knowledge of code optimization techniques and extensive experience on code optimization.
• Worked on Rules language Programming, Billing, Batch job, Complex Stored Procedures and PL/SQLs.
• Worked on Adapter Configuration validations(Java Scripting).
• Developed Interfaces using Java, XML converters, .NET. I have knowledge and debugging skill on .NET.
• Worked on Web Services and POC on JMS queue.
• Worked on SOAP UI testing tool, Neo load for performance testing.
• Worked on defect fixes and tracking.
• Done impact analysis for modules such as Usage Processing, Payment Interface and Bill Print Vendor Interface.