Senior Principal Consultant Resume
Charlotte, NC
SUMMARY:
To secure a challenging position in Information Technology where I can contribute, grow and learn in a team environment.
SKILL:
- ASP.NET
- C#
- Development Environment Support
- Development Life Cycle
- Development Tools
- HTML
- IIS
- Issue Identification Analysis and Solving
- JAVA
- Java Script
- Microsoft Access
- Microsoft Active Directory
- Microsoft Excel
- Microsoft PowerPoint
- Microsoft Visio
- Microsoft SQL Server
- Microsoft Visual Studio
- Microsoft Windows 2008 R2 Server
- Microsoft Windows 2003 Server
- Microsoft Windows 10
- Microsoft Windows 7
- Microsoft Windows XP
- Microsoft Windows Vista
- Microsoft Word
- Migration Processes
- Migration Strategy and Planning
- ODBC
- Client 10gR2/11gR2
- Utilities Adapter
- Utilities Rules Language
- UtilitiesTechnical Architecture
- PL/SQL
- SQL
- Quality Central Test Scripts Execution
- Team Foundation Server
- Teamwork and Collaboration
- TOAD
- UNIX - IBM AIX
- Visual Source Safe
- Visual Basic
- Visual Basic Script
EXPERIENCE:
Confidential, Charlotte, NC
Senior Principal Consultant
Responsibilities:
- Managed configuration enhancements to existing implementation of Transmission and Wholesale Billing
- Worked with Business to understand requirements and resolve Agile stories efficiently and on schedule.
- Configured enhancements using Confidential Utilities and BI Publisher with Confidential Database.
- Helped prioritize stories, assigned story points based on issue complexity, recommended efficiencies to production support team for existing implementation issues and testing strategy.
- Documented resolution of stories in appropriate architecture documentation.
Confidential, St. Louis, MO
Senior Principal Consultant
Responsibilities:
- Managed Analysis, Mapping and Implementation services for Conversion of Revenue Manager to Confidential Utilities Lodestar Billing.
- Conversion included Customers, Account, Contracts, Usage, Invoices and Payments data.
- Conversion involved Municipal Aggregation, Mass Market, Residential Direct Contracts and Accounts with Rate Ready and Dual Billing.
- Helped in documentation and resolution of conversion issues.
Confidential, Baltimore, MD
Senior Principal Consultant
Responsibilities:
- Managed impact analysis and update of Existing and Shadow Rate Ready Billing appropriately.
- Analysis involved Enrollment to Bill Print.
- Ensured integrity of Billing reports i.e. Usage, Billed, Taxes, Charges, Revenue, etc.
- Analyzed impacts on Siebel, Pricing and Data Warehouse interfaces to C&I Billing.
- Reviewed and recommended tuning of existing Adapter configuration.
- Communicated with client regarding future roadmap of software.
Confidential, St. Louis, MO
Principal Consultant
Responsibilities:
- Managed upgrade of Confidential ’s Electric Settlement System, which involved database patches, software and custom screens.
- Configured Settlement software to process Historical Itron MV90 Electric data.
- Worked with Software Support to resolve post upgrade issues.
- Created and Maintained Upgrade documentation.
- Gathered Requirements and configured Max Daily Quantities for Confidential ’s Gas Settlement System using software and web tools (C#, ASP.NET and JavaScript) with PL/SQL.
- Configured integration of screen interface to load Pipeline Interval Data, customized existing OOB Java components.
- Configured tools, updated existing C# components, for Migration and System Test of all Pipeline interfaces (including Confidential ) and Forecasts.
- Pipeline interfaces involved File, Database, FTP and Web Services.
- Supported and documented System Test Results and Issues.
Confidential, Austin, TX
Principal Consultant
Responsibilities:
- Coordinated Discussions, Requirements and provided consulting services to Confidential ’s project.
- Created Technical Architecture documentation on various interfaces.
Confidential, Lakeland, FL
Senior Architect
Responsibilities:
- Currently supporting Critical Production issues.
- Provided consulting services to City of Lakeland’s Smart Grid Initiative for Meter Data Management (MDM).
- Gathered Requirements and configured MDM Web Services to get interval data for the requested period via Enterprise Service Bus (used Confidential WebLogic).
- Gathered Requirements and created customized reports using software tools and PL/SQL.
- Trained Lakeland IT (Production Support) in regards to MDM.
Confidential, Houston, TX
Principal Consultant
Responsibilities:
- Provided Developer/Support services for Mass Market Residential Billing, Accounting and Collections team in regards to Rate Ready, Utility, Dual, Consolidated, Aggregated and Budget Billing.
- Worked with Business to gather Requirements and develop Enhancements via software tools and PL/SQL for New Market Entry, Enrollment, Service Plan Configuration, etc.
- Ensured processing integrity of Autobill, Cancel, Cancel/Rebill and batch Billing, including reports.
- Architected CCH Tax configuration for Mass Market Residential Accounts with Zip + 4 using software tools and PL/SQL.
- Coordinated and lead application and database data center move from Houston to Baltimore. Mitigated risks to applications by careful attention to detail and positive communication across various teams. Ensured integrity of financial data and reports.
- Upgraded, Installed and Configured software (Web and Application tiers) with database on Windows 2008 R2 64 Bit.
- Contributed knowledge and recommendations to software architecture and high availability via cross data center stacks.
Confidential, Lakeland, FL
Senior Architect
Responsibilities:
- Provided consulting services to City of Lakeland’s Smart Grid Initiative for Meter Data Management (MDM)
- Installed and Configured software (Web and Application tiers) with database on Windows 2008 R2 64 Bit.
- Gathered Requirements and Configured Confidential WebLogic and JMS Queue.
- Configured Crystal 2008 with solution.
- Gathered Requirements and Configured Out of the Box MDM Adapter services for various Meter Usage (Interval, Scalar, TOU and Itron MVRS), Logical and Physical Meter Events.
- Gathered Requirements and Configured Custom MDM Adapter Integration for CIS entity model and Historical Itron MVRS data, customized existing OOB Java components.
- Gathered Requirements, Designed and Configured CIS integration for Billing Determinants.
- Gathered Requirements and Created customized reports using PL/SQL for Analytics team.
- Optimized performance of data import to achieve high throughput, using PL/SQL for monitoring transactions.
- Major Proponent in Analysis of Project Mitigation and Risks.
- Coordinated thorough analysis of scenarios between CIS, Weblogic and MDM in regards to Snowbirds, Meter Exchanges, etc.
- Received Excellence from General Manager of Confidential .
Confidential, Baltimore, MD
Senior Software Admin/Consultant
Responsibilities:
- Provided support to entire Billing, Pricing and MDM architecture i.e. Web, Application, Adapter and Confidential Database.
- Provided support for Pricing, Billing, MDM and Forecasting issues.
- Maintained IIS web garden and server farms for the above mentioned products.
- Gathered Requirements and created customized reports using PL/SQL.
- Configured and Maintained complex batch jobs via a custom in - house scheduler on UNIX.
- Gathered Requirements and Built/Enhanced scripts, created new and updated existing C#, VB.NET and VB components, to monitor web services and send email notification for errors.
Confidential, Houston, TX
Senior Software Consultant
Responsibilities:
- At Confidential project upgraded software and database client.
- Helped support client to modify existing and create new Java interface components.
- Analyzed systems that integrate into Pricing application.
- Gathered Requirements, designed and built several old interface processes into using latest software tools.
- Provided Consulting services to streamline entire Pricing process.
Confidential, Kennett Square, PA
Senior Software Consultant
Responsibilities:
- At Confidential project configured Pricing solution.
- Helped configure and develop solution in regards to Contract Qualification, Generation, Revisions, Quotations, Product Terms, Reporting, etc.
- Helped lead Crystal, Utilities and Web (C# and ASP.NET) team to coordinate screen UI for Business.
- Helped configure and develop Contract and Quotation Approval process.
- Resolved HP Quality Manager defects in regards to various Pricing scenarios.
- Helped resolve defects on various scenarios of Billing implementation.
Confidential, Carneys Point, NJ
Senior Software Consultant
Responsibilities:
- At PHI project used Itron Enterprise Edition ( Confidential ) software to configure Billing and Meter Data Management solution.
- Gathered Requirements and used PL/SQL for data conversion from Confidential DPL and Pepco’s CIS systems.
- Gathered Requirements from Confidential DPL and Pepco systems and created Billing Determinants CIS file, per SOX regulations, exported from Confidential .
- Gathered Requirements and created scripts to generate xmls from querying database to import data into database of both Confidential DPL and Pepco systems.
- Gathered Requirements and created audit tables/spreadsheets of all conversion xmls that were imported into Meter Data Management using PL/SQL.
Confidential, Pittsburgh, PA
Senior Software Consultant
Responsibilities:
- Analyzed entire process flow of project.
- Helped with Requirements and configured processes for Contract Generation, Classification, Revisions, Product Terms and Reports using software tools and PL/SQL.
- Helped with Requirements and configured Work Queues with approval process.
- Served as integration architect to configure DLL access via software to pull Price Quotations.
- Designed and built Validations, Estimations and Editing ( Confidential ).
- At Duke Project configured Meter Data Management solution.
- Configured meter usage validations.
- Configured PL/SQL processes and adapter to poll table records to execute software programs.
- At Kansas City Power & Light project configured Meter Data Management solution.
- Configured out of the box and custom meter validations.
- Configured solution using software tools, Stored Procedures, Tables, Constraints, Foreign Keys, Indexes, Triggers and Windows Script.
- Created XSD files for batch validations.
- Supported client DBAs in configuring table partitions to maintain high data volume of daily meter data.
- Worked with client business to help test and understand solution.
- Gathered requirements for gaps.
- Maintained Functional Requirements Document.
- Created Metadata requests, Technical Design document and Client Compliance Test document.
- Configured Menus and Report screens in software.
- Maintained Gantt, reviewed and approved expense invoices of team.
Confidential, St. Petersburg, FL
Senior Programmer Analyst
Responsibilities:
- Developed, Maintained and Optimized C#, Visual Basic GUI and batch (Windows and UNIX) programs that accessed database, Microsoft Active Directory and Siebel Server Manager to execute Settlement activities on demand.
- Created/Maintained database Schemas, Tables, Constraints, Triggers, Views and Synonyms.
- Responsible for creating and maintaining Batch Scheduler.
- Managed and Maintained Interval Data Database.
- Communicated with Client to make sure all project tasks are completed.
- Created Requirements and Detail Designs for Build and Unit Test.
- Involved as Tech Arch to coordinate Filer upgrade/maintenance and Application Server maintenance.
- Maintained internal corporate web site using Microsoft Content Management Server and also project web tools using ASP, VB Script, Java Script, SQL and HTML.
- Member of US ATS Initiative Committee and helped in establishing US ATS Rewards and Recognition Committee.
- ATS Site Lead for Tampa, Florida.
- Received Appreciation .
