Data Customer Service

Objective Seeking a challenging new opportunity to utilize previous analytics experience with complex data mining, large data set analysis, application development, and data management with a willingness to relocate.

Software Networking: WebEx, Remote Desktop

Operating Systems: Windows XP, 2000, 2003, 7, SAP, Unix

Miscellaneous Tools: SAS PC/Unix, MS Office, ServiceNow, Hummingbird FTP, Merak Peep, Fekete Harmony, Spotfire, Tableau, Python, Access, Oracle, PL/SQL, TOAD, SQL Server 2008/2010, SSIS, SSRS, COGNOS, PowerPivot, VBScript, HTML and XML.

Applications: SAP CCS - Billing, Customer Service, Bill Print, Marketing, SAP BW/BI, Visio

Technical Skills

Develop PL/SQL triggers and master tables for automatic creation of primary keys.

Create PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Create indexes on the tables for faster retrieval of the data to enhance database performance.

Load data using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate flat files.

Create database objects such as tables, views, materialized views, procedures and packages using TOAD for Oracle, PL/SQL Developer and SQL* Plus.

Manage all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines

Develop Client-Server applications using Oracle 11g/10g/9i/8i, PL/SQL, SQL* Plus, TOAD for Oracle and SQL*Loader

Create reports in BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries

5+ Years of SAP BW/BI experience, which includes Data-Modelling, Data Extraction, Data Loading, Scheduling, Monitoring, Reporting and Performance Tuning

Develop ad hoc analyses to address critical issues using a combination of MS Access, PL/SQL, TOAD for Oracle, SAS, SSRS, BW

Expertise in Data archival and Data migration, ad-hoc reporting and code utilizing SAS on UNIX and Windows Environments.

Experience in extracting, manipulating data, and creating Data Sets from various sources like Excel, flat files, Oracle database, Access database using PROC IMPORT techniques and SQL pass through facility.

Experience in Analysis, Design, Development and Validation of applications.

Strong experience on Base SAS, SAS/Access, SAS/Macros, SAS/ODS and SAS/SQL in Windows Environment.

Optimize performance using Data Validation and Data cleansing on data using Statistical procedures like PROC FREQ, PROC MEANS, and PROC UNIVARIATE.

Experience in Business Intelligence (SSIS, SSAS and SSRS), Data Warehousing and Dashboards. Develop and deliver dynamic reporting solutions using SQL Server Reporting Services (SSRS).

Experience in developing Custom Report and different types of Tabular Reports, Ad hoc reports, and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS).

Work Experience Occidental Petroleum, Houston, TX November 2014 - Current

Engineering Specialist

Provide data and tools to Worldwide Operations Production Engineering staff

Create value from data by recognizing variations, deviations, and additional opportunities

Review data to understand, demonstrate, and measure completion and stimulation performance

Review and understand stimulation post treatment reports and populating information into database

Design automated scorecard reports in Spotfire to track KPI for well downtime efficiency across South Texas group

Automate existing reports combining information from several data sources, reducing report runtime by 90%

Maintain, QC, extract, manipulate and analyze data to create reports in Spotfire and Tableau

Reliant Energy, Houston, TX January 2008 – November 2014

Reporting Analyst

Designed and implemented new business processes to reduce SAP system exceptions and improve existing enrollment and billing processes

Generated metrics reports utilizing various tools such as MS Access, Excel, SSRS, BW, and Toad for Oracle

Provided analysis for customer population attrition characteristics using Excel, Toad for Oracle, and SAS to drive decision making

Developed statistical reports using SAS to identify trends with financial and energy usage data

Generated automated monthly scorecard report to track customer enrollment and attrition numbers for effective corporate messaging to external, board and internal stakeholders

Assisted in maintenance, support and reporting of the Residential Management System (RMS).

Reliant Energy, Houston, TX June 2005 – January 2008

Business Analyst – SAP CCS – Billing, Bill Print, Marketing

Aided project managers with gathering functional requirements and defining the technical needs of various projects

Developed and maintained databases for error tracking used by multiple groups across the organization (bill print, operations, marketing)

Created reports to monitor various system metrics (enrollments, billing issues, complaints)

Researched and performed root-cause analyses on customer issues and system/business process errors

Education University of Houston – Downtown, Houston, TX (2005 – 2010)

BBA in Accounting

Contact this candidate