SUMMARY

• A team - oriented Sr Data Conversion/Techno-Functional Architect/Hands-on Developer with over 19 years of experience in System analysis, Design and Development of Databases, Data warehouses, Datamarts and Business Intelligence using SQL, PL/SQL, Oracle 11g/10g/9i/8i, SQL Server, SSIS, SSAS, SSRS, Business Objects XIR2, Universe Development, Web Intelligence, Desktop Intelligence, OWB, Oracle CC&B, Informatica, DB2, MySQL and SQL*Loader.
• Extensive experience in Logical and Physical Data Modeling using ERWin and Visio, practical hands on experience in designing and developing ETL processes, star schemas and transformations.
• Strong database skills, enhanced with multiple language programming capabilities. Thorough knowledge of many applications and debugging tools, Solid understanding of Kimball & Inmon Architecture and Design concepts.
• Highly motivated individual with a clear understanding of Banking and Financial, Insurance Property/Auto, Policy and Claims, Retail-Supply Chain Management, Logistics, Manufacturing, Market/Media Research, Energy and Utilities (Oracle CC&B 2.2/2.3 Customer Care and Billing, CIS System) industry requirements.
• Expertise in creating Oracle Tables, Table Partitions, Views and Materialized Views applying referential integrity constraints. Highly Proficient in OWB, Export, Import, SQL*Loader and Job Scheduler Utilities.
• Expertise in developing PL/SQL Packages, Stored Procedures, Functions and Triggers. Developed various applications using Oracle built-in packages such as DBMS SQL, UTL FILE, UTL MAIL and DBMS XML.
• Expertise in Performance Tuning and Query optimization using Explain Plan and Tkprof utilities.
• Highly proficient in MS SQL Server 7.0/ 2000/2005/2008 tools like Enterprise Manager, Management Studio, DTS, SSIS, SSAS, SSRS and SQL Query Analyzer, experienced in developing Stored Procedures, Functions and Triggers in Transact SQL (T-SQL).
• Thorough knowledge of multiple operating systems like Linux, Unix-AIX, HP-UX, Sun Solaris and Windows.
• Experienced in administration and use of Visual Sourcesafe (VSS) and Perforce code repository.
• Solid experience with various ERP Systems like i2, SAP, expertise in setting up Data warehouse’s for Curam.
• Oracle Utilities, Oracle CC&B 2.2/2.3 (Customer Care and Billing, CIS Systems), PeopleSoft CIS, Advanced Metering Infrastructure AMI/AMR, MDM-Meter Data Management, Oracle RICE components

TECHNICAL SKILLS

Languages: Oracle 11g/10g/9i/8i, SQL Server, DB2, MySQL, PL/SQL, SQL*PLUS, Shell ScriptingTransact-SQL (T-SQL), Pro C, Visual Basic 6.0/5.0, Visual Basic.Net, C, C++, Java, J2EE, C#, HTML, UML

Databases: Oracle 12c/11g/10g/9i/8i, SQL Server 2000/2005/2008 , IBM DB2 UDB, MySQL, MS Access.

ETL Tools: SQL Server Integration Services-SSIS/DTS, Informatica, Business Objects DS/DQ/DI Data Services, Data Quality, Data Integrator, Oracle Warehouse Builder-OWB.

Analysis Tools: SQL Server Analysis Services-SSAS, MDX, Business Objects XIR2, Universe Development, Xcelsius, Dashboard Design, Infoview.

Reporting Tools: SQL Server Reporting Services - SSRS, Crystal Reports 9/10/XI, Web Intelligence, Desktop Intelligence, Oracle Reports, Tableau Desktop, Worksheets and Dashboards.

Operating Systems: Linux, Unix- AIX, HP-UX, Sun Solaris, Windows 95/98/2000/NT/XP and MS-DOS.

Applications and Tools: ERWin 3.0/4.0, Visio, TOAD 9.0, Oracle Forms/Reports 6i/9i, DTS, SSIS, SSAS, SSRS, OOAD, OOP, ODBC, SAP, i2, COTS, Curam 5.0/5.2, Oracle Utilities, Oracle CC&B 2.2/2.3, OWB, OEM, Informatica, SharePoint, Performance Point, XML, XST, Visual Studio.NET, UC4 Job Scheduling.

PROFESSIONAL EXPERIENCE

Confidential

Sr Technical Consultant

Responsibilities:

• Analyzed and understood the Payment Industry business related to Merchants, Dealers, Developers, Products, Boarding, Pricing, Hierarchies, Billing and Commissions.
• Designed and developed a new Normalized Data Model for Mercury Payment Systems to integrate Element Payment Systems data.
• Analyzed the T2Business de-normalized table to break it down into individual entities, Wrote SQL Server SQL queries and T-SQL Stored Procedures to perform Dependency Search on objects related to T2Business.
• Designed and Developed code to query SYS objects in SQL Server to find dependent Views, Synonyms, Stored Procedures, Functions and Triggers.
• Used SharePoint as a Document Repository and RedGate SQL Source Control as a code repository.

Environment: Oracle Revenue Management and Billing, ORMB 2.2/2.3, SQL Server 2012, Salesforce, SQL, T-SQL, SQL Server Management Studio, SSIS 2012/2014, ETL-Extract Transform Load, Data Modelling, Data Architecture, Data Conversion, Data Integration, Data Migration, Erwin/Visio, SharePoint, RedGate.

Confidential, San Francisco, CA

Sr Oracle CC&B/MDM/Data Integration Techno-Functional Consultant

Responsibilities:

• Analyzed and understood Confidential &E’s CC&B 2.3.1 implementation in terms of Configurations and Customizations.
• Analyzed the Oracle CC&B to Salesforce data sourcing requirements and worked on Integration Design documents to map the data from Source to Target, designed the integration solution ETL- Extract, Transform and Load to integrate data from Oracle CC&B to Salesforce.
• Designed and developed Oracle Views using SQL and PL/SQL which constitute the CC&B V objects (Person, Account, Service Agreement, Service Point, Premise and Meter) to be used for validating the incoming source data.
• Analyzed the data coming from Confidential and Confidential MDMS Meter Data Management System for the VEE-Validation Editing and Estimation Exceptions for High Gas Usage and Electric Smart meters, designed the integration solution to Extract, Transform and Load - ETL MDM data to Salesforce.
• Defined Functional and Technical requirements for California CAISO Rule 24 which allows Third Party Demand Response Providers to bid on behalf of Confidential &E customers, the deliverable involved enhancements to SmartRate for Residential customers and Peak Day Pricing for C&I accounts which involved working with Oracle CC&B Maintenance Objects, Business Objects, Business Services, Service Scripts, BPA Scripts, UI Maps, Portals and Zones.
• Worked with the Business and Billing Operations team to analyze the various sources of exceptions, defined priorities and developed solutions in Oracle SQL and PL/SQL which helped achieve the end-result of billing the customer for the Meter-to-Cash project.
• Used SharePoint as a Document Repository and JIRA as the Defect and Enhancement tracking system.

Environment: Oracle CC&B 2.3.1, Advanced Metering Infrastructure AMI/AMR, Confidential & Confidential MDMS-Meter Data Management System, Customer Care and Billing/CIS Customer Information System, Oracle 11g, Salesforce, SQL, PL/SQL, SQL*Plus, ETL-Extract Transform Load, Data Conversion, Data Integration, Data Migration, TOAD, JIRA, SharePoint, SQL Developer, UC4 Job Scheduling.

Confidential

Sr Oracle CC&B/MDM Data Conversion/Techno-Functional Consultant

Responsibilities:

• Analyzed and understood Duquesne Light’s legacy Customer Information System in DB2 to Map legacy data, define Mappings, Transformations and conversion strategy to load Oracle CCB/MDM staging tables.
• Developed Data Conversion/ETL routines to load legacy data related to the V (Persons, Accounts, Service Agreements, SPs, Premise and Meters) into Oracle CCB/MDM Staging tables using SQL, PL/SQL & ODI.
• Wrote SQL, PL/SQL extract routines to load 13 months of Financial History related to Bills, Payments and Adjustments, performed Tidy Balancing of Financial Transactions to match balances from legacy.
• Used SQL, PL/SQL and ODI Packages, Interfaces and Procedures to load data from CCB/MDM staging tables to PROD tables, used KEYGEN Key Generation batch jobs to assign unique keys to production data, performed thorough Object Validations and Foreign Key Validations to validate and resolve legacy data.
• Analyzed and understood the Meter Data Management MDM 2.0 Architecture related to (Contacts, Devices, Device Configs, Service Points, Measuring Components, Usage, VEE (Validation Editing and Estimation) Rules and VEE Groups to perform Initial SYNC and Ongoing SYNC.
• Wrote SQL, PL/SQL stored procedures and functions to load 13 months Meter Read history which comprised of high volume data 50+ million records for Estimation and Usage to MDM 2.0
• Utilized the CC&B Conversion Toolkit to execute Validation, Key Generation and Insert to Production batch jobs.
• Participated in several 24/7 MOCK runs to load and validate data, helped performance tune slow performing SQL queries and PL/SQL routines.
• Used SharePoint as a Document Repository and SVN as the Code repository

Environment: Oracle CC&B 2.3.1, Advanced Metering Infrastructure AMI/AMR, MDM-Meter Data Management 2.0 Customer Care and Billing/CIS Customer Information System, Oracle 11g, Oracle RICE components, SQL, PL/SQL, SQL*Plus, ETL-Extract Transform Load, Data Conversion, Data Integration, Data Migration, TOAD, Business Objects BOXI, Crystal Reports, SharePoint, SQL Developer, PL/SQL Debugger.