Resume

Sign in

Data Sql Server

Location:
Spring, Texas, 77373, United States
Posted:
May 20, 2017
Email:
ac0elc@r.postjobfree.com

Contact this candidate

AVERY R. BYERS

*** ***** *** *****

Houston, Texas 77073

Phone: (713) ***-****

Email: ac0elc@r.postjobfree.com

SUMMARY

Business and accounting systems professional with ten years experience in corporate accounting, programming accounting schedules and reports. As a programmer analyst, I have developed Excel, ASP application, and relational databases for the corporate accounting and manufacturing area that interface with an Oracle 11i ERP system. As a part of the Oracle 11i/SAP PM data conversion and implementation team, I have assisted in both technical/Data Architecture and functional application support for the users to become more proficient in the use of Oracle 11i/Oracle P2ES. I have proven management skills with excellent interpersonal and communications ability emphasizing teamwork and goal attainment.

SYSTEMS AND SOFTWARE

DATABASES PROGRAMMING LANGAGES Oracle – Versions 7.3.4 to 10g VB.net Frameworks; Visual Basic

Microsoft SQL Server – Versions 7 to 2008 VBScript; VBA; JavaScript; ASP/ASP.net

BRIO/Essbase – Version 5.2/Hyperion 9.2.1 T-SQL; PL/SQL Programming; scripting shell

Microsoft Access; Paradox Exposure to Java; MDAC 2.8; XML; Unix

APPLICATIONS TOOLS/REPORT DEVELOPER TOOLS

Toad/Oracle SQL Plus Oracle Reports 6i/Discoverer 4i

Rapid SQL/SQL Server Analyzer Crystal Reports/FRx Report Writer

Power BI/SAP BI MS Visual InterDev; Dream Weaver

PROFESSIONAL EXPERIENCE

Distribution International - (Houston, Texas) 2016 – Present

BI Developer/SQL DBA - (05/2016 – Present)

Develops and implements information management strategies. Coordinates and manages information management solutions. Scopes, plan, and prioritizes multiple projects. Manages all aspects of the data warehousesf such as data sourcing, migration, quality, design, and implementation.

Data Analysis: Examined datasets in order to draw conclusions about the information end users contain, increasingly with the aid of Phocas BI Software Dashboards.

Identify and remove irrelevant, obsolete, duplicate, corrupted documents and verify document attributes are consistency with metadata.

Re-design new OLAP cub (SSAS) and ETL for the Phocas BI software system. Created new and corrected Dashboards for identified Key Performance Indicators (KPIs) and Power BI.

Maintained SQL Server 2012 Enterprise production installation, including replication and performance monitoring and troubleshooting.

Developed and maintained stored procedures and triggers in T-SQL and SSIS packages.

Data Cleansing: Used MS Excel Identify and remove irrelevant, obsolete, duplicate, corrupted documents and verify document attributes are consistency with metadata using advanced functions and Marcos.

Data Validation: Validated new business rules for Sales, Purchasing, and GL data pulled correctly from the legacy source system into new data warehouse. Used ETL to extract data from proprietary databases and loading into a centralize data warehouse for reporting. Maintained the user group with ad-hoc SQL queries, scripts, and Hyperion Interactive Reporting Studio (BRIO) and SSRS reports during their closing process until the new environment was up and running correctly.

Baker Hughes - (Houston, Texas) 2015 – 2016

Data Analyst/SQL Developer - (6/2015 – 5/2016)

Data Analysis: Used Spotfire to examine large amounts of data to draw to uncover hidden patterns, correlations and other insights. Developed warehouse data from several different sources to develop dashboards and reports.

Creating visual basic forms and SSRS reports for the operators to input Rig Data in the backend tables

Writing VB and VBA code/functions in MS Excel and MS Access to insert data into SQL Server 2012 using ETL to extract data from proprietary databases and loading into a centralize data warehouse(SSAS) for reporting.

Develop SSIS packages to transferring of the content files for final validation before loading into the SQL Server 2012. Setup Spotfire for data abstraction into excel spreadsheets.

Support the operators in data discrepancies from field dataset to data stored in SAP and troubleshooting system error and/or inaccuracies in code SSRS reporting data.

Data validation added to macros so that all required fields will prompt the end-user. Other data analysis based upon rig data using v-lookups on historical data dumps from SQL Server. Transact-SQL was used to identify data cleansing and missing validation area in the database. Created documentation on the new form based process for the end-users.

Praxair/Superior Group (Contractor) - (Houston, Texas) 2014 – 2015

VBA Developer - (10/2014 – 06/2015)

Creating visual basic forms and report for the Refinery and Crude Oil Tracking System.

Writing VBA code and other complex functions in MS Excel and MS Access/SQL Server 2008 to the conversion template and transferring of the content files for final validation before loading to template into the (MS Access Database test environment)/SQL Server 2008 production environment.

Supported Product Management area with the month the consolidation and financial reporting development and ability to research and investigate data discrepancies, provide data validation reports and understand system processes.

Support the end-users local/International and troubleshooting system error and/or inaccuracies in code/reporting data.

Updated existing macros to except additional locations and regions by providing visual basic forms for a visual affect. Added new v-lookup based upon additional data location and regions. Validated new pricing structure against new VBA/Marcos code. Created documentation on the new form based process for the end-users.

RPSEA/HPP (Contractor) - (Houston, Texas) 2010 – Present

Developer/SQL DBA - (02/2010 – Present/Part-Time)

Re-design MS Access database tables on the SharePoint Corporate site that interfaces with visual basic forms. Data migration/Data Modelling plan by writing of migrating documents related to Invoice data and Project data and other documents that will enable user to access data without locking out MS Access database. Created and migrated data from MS Access to cloud based SQL Server 2008.

Data Analysis: Processed data by inspecting, cleaning, transforming, and data modeling data with the goals of discovering useful information, suggesting conclusions, and decision-making from multiple sources like MS Access database and spreadsheets company wide.

Architected and developed a data warehouse in MS SQL Server 2008 to centralize the company’s business data that includes invoice data and financial data giving them the ability to capability to report customer performance as well as a consolidated reporting.

Data Cleansing: Identify and remove irrelevant, obsolete, duplicate, corrupted documents and verify document attributes are consistency with metadata.

Writing visual basic forms and report for the Invoice and Project Tracking System. Writing VB/VBA code in MS Excel and MS Access/SQL Server 2008 to the conversion template and transferring of the content files for final validation before loading to template into the MS Access Database/SQL Server 2008.

Supported the Accounting area with the month the consolidation and financial reporting development and ability to research and investigate data discrepancies, provide data validation Crystal report writer and SSRS reports and understand system processes. Support the end-users local/International and troubleshooting system error and/or inaccuracies in code/reporting data. Developed Excel based automated Reconciliation system that pulled from QuickBooks into Visual Basic Application.

Installed and maintained SQL Server databases for core applications for extracting data from the systems. Daily responsible were maintaining, updating, and retrieving data from database using Power Pivot Add-in and data mapping. Documents internal and external process and procedures for custom applications must be in Sox compliance with in/outside auditors.

Girl Scouts of San Jacinto/Insight Global (Contractor) - (Houston, Texas) 2014 –2014

SQL Developer/DBA - (05/2014 – 10/2014)

Process data from SQL databases and other data sources, analyzing source data (The Borg) and enhance access to reference data using ad hoc Tableau BI reporting, extract, and translate while loading high volume of Meta data sets with low latency using SSIS packages and web services. Develop SSIS packages to gather data from multiple sources and develop Dashboards using Tableau.

Developed an application that captures customer data that builds predictive models basis on location and purchases using Crystal report writer.

Translate business requirements to implement projects in a timely manner for applications development using design patterns and best practices.

VBA forms using macros were developed to make data quality and data entry a faster process this helped validation into the database. After validations the flat files were added to SSIS package folders.

Hermann Memorial/Insight Global (Contractor) - (Houston, Texas) 2014 – 2014

VBA Developer/Business Analyst - (02/2014 – 04/2014)

Created MS Access infection control database for the Director Clinical Management System area.

Developed user friendly forms front-end that will interface in a network MS Access database for the backend tables using ADO DB.

Assisted in development of the ADO DB from infection Control Database to Midas that will interface with the MS Access Infection Control Database on customer data.

Glenture Group - (Chicago, Illinois) 2011 – 2012

Developer/Business Analyst - (06/2011 – 03/2012)

Developing SAP-BPC Outlooksoft Business Intelligence reports and input schedules. Creating cubes dimensions, rules, and scripting. Identifying, extracting, and analyzing business data using MS SQL Server Analysis services.

Writing advanced VBA (Marcos) code within Excel for report and input schedules in order to design a user friendly tool set for the end-user. Automate v-lookups and other functions.

Created/Updated the metadata structure and Security including accounts, entities, scenarios, and custom dimensions in SAP-BPC version 7.0, 7.5, and 10.0.

Gathered requirements and analysis from business logic into SAP Outlook business rules calculations in order to developed complex reports. Training the user with report development and report design. Data account mapping to the validation to legacy accounting system reports. Responsible for writing code and Calculations scripts.

Used the SAP OLAP spreadsheet Excel Add-In, Outlook Soft Reports, analyzed, designed, and developed new reports as required using SAP Outlook Soft Financial Reports. Provided technical assistance to resolve end user inquiries on SAP Outlook Soft Financial Reports design and Input Schedules drill down setups. Ensured accuracy of reporting data that is provided to all levels of staff and senior management.

Shell Oil/HPP (Contractor) - (Houston, Texas) 2009 – 2011

Data Analyst/Script Writing - (04/2009 – 06/2011)

Refinery data migration plan by writing of migrating documents related to SAP PM functional location hierarchy that will enable AIM to search and access to engineering drawings, plant equipment, and other related documents.

Data Cleansing: Identify and remove irrelevant, obsolete, duplicate, corrupted documents and verify document attributes are consistency with metadata.

Writing the T-SQL scripts that will execute data extraction based upon conversion rules from the legacy system.

Writing advance VBA(Marcos) code in MS Excel and MS Access to the conversion template and transferring of the content files for final validation before loading to template into the SAP staging area.

Verified and record the data volume against data loaded into SAP PM Module tables. Record and document results and issues for the next batches. Performed Data analysis of the SAP PM (AIM add-on) to legacy system data. Updating loading mass loads of content files in the SAP tables. (SAP Data Loader)

Shell Trading – Application Support/Development- (12/2012 – 06/2013)

Developed a visual basic application that tracks the vessel movements to make money-making decisions for trading department. OCR Software development for scanned documentation to excel.

Automated the collection of important information related to the oil assets basis upon temperature to determine data was collected correctly using predictive model.

Helix Energy Solutions - (Houston, Texas) 2006 – 2009

System Analyst II/Business Analyst - (07/2006 – 02/2009)

Hyperion administrator developed the rules in visual basic script reporting system and providing Functional/Production support and managed Hyperion upgrades from 9.2.0 to 9.2.1. As a part of Oracle Functional/Technical, I supported the global Oracle 11i implementation of corporate data. Oracle Application set up, Global deployment and Support (for GL/AR/AP/CM/PA/ PO/ INV, Internet Procurement modules) - This is a global rollout of Oracle Application, consolidating six different systems (Forefront, Bolo, Sage etc) into a single global Oracle instance, involving multiple SOB, currencies for six countries. Also developed and maintained SQL Server databases (DBA functions) for sub-systems applications for extracting data from the legacy systems. Daily responsible were maintaining, updating, and retrieving data from database system and data mapping. Documents internal and external process and procedures for custom applications must be in Sox compliance with in/outside auditors.

ERP Oracle Applications EBS 11i: Responsibilities included system administration, data conversion International conversion and domestic, data extraction from legacy systems; placing coded data into production environment and providing support with the basic Project Management Methodologies.

Oracle P2ES: Tracked AFE balances among all business managers while transfer funds other projects if over stated. Setup new AFE with assigned GL account code and user maintenance and report development. Developed additional functionality to the AFE system that interface with the legacy systems budget module.

Lead Oracle ERP Implementation for Finance, Procurement and Project modules. Complied user test scripts in Finance and Procurement module. Supported financial applications Accounts Payable, Accounts Receivable, General Ledger, and Capital Project Modules.

Developed Oracle 6i reports and debugs PL/SQL issues in the modified reports. Prepared the status reports daily and weekly. Tracking of Functional Setups. Helped onsite functional consultant in resolution of issues through testing the business scenarios. 24/7 Production support with local and International end-users. Support included post GO LIVE production support.

Configured and setup for Post GO LIVE activities to in sure an error free implementation of legacy data in the Oracle Production environment.

Worked with business users to gather requirements and executed system test plans to be used for deploying in the Oracle Production environment and technical specifications for small enhancement projects for implementations using the corporate Sharepoint site.

Prepared configuration document for the new operating unit and business test cases and documented test results. Developed an Oracle ADI interface to legacy system General Ledger for running parallel until GO LIVE.

Resolved and track escalated Oracle support calls both Functional and Technical issues. Responsible for the maintenance and support of the Oracle e-Business Suite ERP and responsible for monitoring and managing the Oracle production support queue and resolving Oracle production support tickets, while also working with in analysis and development of maintenance and enhancement projects.

Resolved performance issues with Concurrent Manager and Wrote shell scripts to email and alert Production team of server status.

Cross-Trained and other Oracle Functional Area: System Administrator/Discoverer Administrator setups and configure profiles. VB.net project to integrate ABS NS5 requisition into Oracle and send back Oracle PO to NS5, implemented this integration in seven Helix vessels.

Internal Controls: Ensured accuracy and completeness of it accounting data, produce reliable and timely financial and management information, and ensure adherence to it policies and plan with internal/external auditors. Systematically queries data for such reviews, checks and balances for SOX compliance.

Hyperion Administrator 9.2.1/Developer: Provided test scripts for the end-user for training and provided production support for HFM, Upstream Application, and Reporting by validating legacy data against Hyperion data. Supported the Accounting area with the month the consolidation and financial reporting development and ability to research and investigate data discrepancies, provide data validation reports and understand system processes. Support the end-users local/International and troubleshooting system error or inaccuracies in reporting data.

Uploaded data into Upstream interface process validation to confirm system outputs are correct and ensure data integrity. Created a new front-end interface to Upstream using Excel programming language (VBA).

Setup security including users, groups, security classes, and user access to documents, data, roles and categories. Created/Updated the metadata structure and Security including accounts, entities, scenarios, and custom dimensions. Enhanced functionality of web based data entry forms.

Gathered requirements and analysis from business logic into Hyperion business rules calculations in order to developed complex reports. Training the user with report development and report design. Data account mapping to the validation to legacy accounting system reports. Responsible for running Consolidations and Calculations.

Maintained Data Grids and data validation from Upstream Application reports back to the legacy system reports.

Power user with hands-on experience in Hyperion OLAP spreadsheet Excel Add-In, Hyperion Reports, and/or Hyperion Analyzer. Analyzed, designed, and developed new reports as required using Hyperion Financial Reports. Provided technical assistance to resolve end user inquiries on Hyperion Financial Reports design and SmartViews drill down setups. Ensured accuracy of reporting data that is provided to all levels of staff and senior management. Maintenance of Starting/Stopping of Services of Apache/TomCat Server.

.Net Framework and Development: Develop technical design and architecture specifications based on user requirements for Bill Of Lading. Writing ad-hoc SQL in order gather data to validate for developing end user report that interface with MS Excel or MS Access. Perform unit testing and that integration testing of applications.

Responsible for obtaining raw data and producing VBA front-end as well VB.net/ASP.net application to generate production reports from database backend tables.

Development, development of SQL Server tables, support and maintenance for a custom developed business applications. (VB.net Framework 3.0) Total saving on business application projects $11,000. (.net FRx reports, SSRS Reporting and Crystal Report Writer version 10)

Responsible for Visual Basic .net application change management, code management (includes VB & PL/SQL). Participate in the analysis, design, build, test, and migration of system enhancements and fixes, including reports, forms, and processes using Developer tools.

Established Finance/IT process to be compiled with SOX (Sarbanes-Oxley) Act and audit.

Review, analyzes, design, programs, modifies, develops and implements the customization to fulfill business requirements.

Sub-System Support: Microsoft Dynamics SL 6.5, Navision, AX systems, BOLO system, and Forefront data analysis for implementation of data to Hyperion System 9. Working with the Business Users to implement, configure, support changes and upgrades, and manage systems. Developed Window Application interface from the Legacy systems to Hyperion FDM and other VB.net interfaces. Additional data analysis for DTS and to provide SQL Server Reporting Service on non-Hyperion reports.

GRANT PRIDECO/AS (Contract) - (Houston, Texas) 2006 – 2006

Senior Financial Accountant/Business Analyst - (03/2006 – 07/2006)

Automate the Fixed Asset roll forward schedules and analysis reports using Cognos Script Language (V-Lookup coding & VBA(Marcos) using MS Excel and MS Access) and providing of documentation and testing of source code.

Created a front-end interface that downloads currency rate to analysis report based upon parameters giving for the Investment Accounting area.

Writing ad-hoc SQL in order gather data to validate for developing end user report that interface with MS Excel or MS Access.

Developed and enhanced Cognos scripts to function correctly to end-users requirements.

GE Energy/Adecco (Contract) - (Houston, Texas) 2006 – 2006

Business Analyst/Programmer - (02/2006 – 03/2006)

Automate the roll forward schedules and analysis reports using VBA code and linking these Excel spreadsheets to MS Access table links.

CORE LABORATORIES/RHI (Contract) - (Houston, Texas) 2005 - 2006

Senior Accountant/Programmer - (07/2005 -02/ 2006)

Essential duties are review and journalize the U.S. payroll transmitted through Oracle Payroll to General Ledger.

Prepared monthly accruals for payroll elements for salaries and wages; journalize the vacation accrual, re-classes related to payroll and profit sharing.

Automate the roll forward schedules and analysis reports using VBA coding, while using Discoverer 4i/Ad-Hoc Query Analysis to develop the element data files. Writing ad-hoc SQL in order gather data to validate for developing end user report that interface with MS Excel or MS Access.

SOX reviewing, process mapping, and providing of documentation required for testing. Functional Area: Financial Modules

HYDROCHEMICALS INDUSTRIAL SERVICES - (Houston, Texas) 2003 - 2005

Fixed Asset Manager/Oracle Power User - (10/2003 – 06/2005)

Primary duties are tracking Capital Expenditures, deprecation expense, asset transfers, asset disposals, and reconciling asset-clearing accounts. Reconcile accounts between General Ledger, Accounts Payable, and Purchase Order. Created a Visual Basic front-end for Capital Projects add-in that interface with Fixed Asset Module.

Developed and maintained Rapid SQL queries that pull data directly into Excel spreadsheets in order to develop VBA custom reports and/or Ad-Hoc reports. Resolve application errors and implementation of tests scripts necessary to ensure that an application meets performance requirements.

Provide support for any issues to the core applications or customizations of can Oracle report (Modifying PL/SQL). Functional Area: Financial and Fixed Asset Modules

TEXAS PETROCHEMICALS, LP - (Houston, Texas) 2001 - 2003

Programmer Analyst - (01/2001 – 02/2003)

Responsible for creation of test scripts; executed and documentation the tests necessary to ensure that an application or technical environment meets performance requirements (technical, functional and user interface) resulting in an increase in annual sales of 1.5 million with a 10% reduction in operational costs.

ERP Oracle Applications 11i: Responsibility included system administration, data conversion/International conversion, data extraction from legacy system; placing coded data into production and providing support; using Toad for Oracle PL/SQL; Oracle 6i reports and SSRS reporting. Lead Oracle ERP Implementation for Finance, Procurement and eAM modules. Worked with supply chain, information systems, field service, and accounting personnel designing optimal replenishment strategies, parts and labor tracking, asset tracking, intranet based query tools, and other system processes.

Finance, Procurement, and eAM Business Area:

Business: Gather process redesign requirements, coordinate and participate in development activities, and support the testing and implementation of package-based application software. Strategized and managed eAM communications and program improvements. Development task 40% Oracle reports using Oracle 6i and Discoverer tools in each of the modules, while providing 60% functional and training for the user and test scripts. Manage business relationships with users regarding eAM improvements.

Developed and executed the deployment of the reports and modified profiles into production. Worked with the database administrator to correct issues in the functioning the application.

Evaluated user proficiency and define training requirements to raise the level of proficiency for the users. Trained users on the use of the business application during go live in the following modules Finance, Procurement, and eAM.

Business: Build expertise in interface and data conversion requirements, capabilities and limitations, and setup and configuration issues associated with product modules in your specialty area(s).

Duties include but not limited to Creation and modification of data entry form. Create and modify PL/SQL and T-SQL packages, procedures, functions and Libraries. Create and modify Tables, indexes, triggers and constraints.

Worked in conjunction with the DBA to resolved performance issues with custom code PL/SQL (Reports, Forms, and Workflow).

Worked with supply chain, information systems, field service, and accounting personnel designing optimal replenishment strategies, parts and labor tracking, asset tracking, intranet based query tools, and other system processes. (Toad and Rapid SQL)

Setup or configure business application to support business requirements. Resolved and track escalated support calls.

Application Support/Development: Maintained and repaired VB and ASP Classic/ASP.net applications to keep them performing in accordance with technical and functional specifications that facilitated cost control by reduction in downtime by 75%.

Developed a ASP Employer’s Quarterly Reports that interface with Oracle Applications, while modifying PL/SQL programming in order to allowed the payroll department to file Employer’s Quarterly Reports over the Internet via FTP (file transfer protocol), which saved $3,000 per quarterly.

Developed and implemented of new coding and Application system programs (American Express and E-Cast), and supplying support of existing systems, as well as, web application and maintenance, which lowered costs by 20%.

Responsible for web application change management, code management (includes VB, ASP & PL/SQL), and production support knowledge and web site analytics that increased industries present. http://www.txpetrochem.com Participate in the analysis, design, build, test, and migration of system enhancements and fixes, including reports and Oracle reports & eAM reports, forms, and processes using Oracle Developer tools.

Coordinate Oracle Support via the Technical Assistance Request (TAR) process.

Assist in project implementations and new functionality rollouts.

Created a web base reporting delivery system using ASP for user reports that was created using Oracle 6i reports, and/or Crystal reports.

Discoverer Ad-Hoc Query & Analysis setup for the end-user that increased productivity, generated an annual saving of $60,000 per year.

Gathered technical and function specifications from the end-user in order to develop a business application interfaces using VB and/or reports using ASP and/or Crystal reports using SQL Server and Oracle back-end tables for the Accounting and Human Resource department resulting in a 65% reduction in hourly wages.

Provided help desk coverage and training; troubleshoot PC, printer, and network problems.

Database Design: Responsible for collecting, converting and transfer data from existing SQL Server environment to the Oracle database environment.

Analyzed data structure and relationship on for application upgrades in base upon new business rules.

Clone and refresh databases and schemas for different business and testing purposes.

BANK UNITED - (Houston, Texas) 1993 - 2001

Business Analyst/Programmer - (07/1998 – 01/2001)

Responsible for formulated a system that collected and analyzed account information in Solomon, reconciled financial discrepancies, resulting in the reduction of research time by nearly 70%.

Worked closely with the end-user to ensure proper utilization of current and future financial system and provide documentation of processing enhancements, form customization, conversions of Lotus Arbor Essbase cube to Excel with drill down functionality and FoxPro and/or Paradox to MS Access programming language.

Developed a front end ASP program that interface with Solomon back in tables that be used to maintained cash-flow projections and procedures to accumulate cash-flow forecasts reduced the time required to maintain these records using Sybase database while working with administrator to manage users, security, and accounts.

Developed and Instituted a VBA application integration links to external corporate journal entries system that interfaces with the general ledger, which eliminated over 85 hours of data entry per month and saved over $25,000 per year.

Implement an automated Reconciliation system that pulled Solomon data using Access with Visual Basics re-enforcements to the Cash Disbursement Account and the Funding Suspense Account by reducing 95% in overtime.

Utilized Macros and Visual Basics to automate repetitive tasks and streamline complex procedures in reporting documentation using



Contact this candidate