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.

TECHNICAL SKILLS

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

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

Confidential - Houston, Texas

Developer/SQL DBA

Responsibilities:

• 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.
• Created Database views from various Data sources for Tibco Spotfire Report creation.
• 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.

Confidential - Houston, Texas

Developer/SQL Developer

Responsibilities:

• Creating visual basic forms and SSRS reports for the operators to input Rig Data in the backend tables
• Writing VB/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 Tibco 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.

Confidential - Houston, Texas

Developer

Responsibilities:

• 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-user’s 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.

Confidential - Houston, Texas

Developer/SQL DBA

Responsibilities:

• 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-user’s 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.

Confidential - Houston, Texas

SQL Developer/DBA

Responsibilities:

• 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.

Confidential - Houston, Texas

Developer

Responsibilities:

• 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.

Confidential - Chicago, Illinois

Developer

Responsibilities:

• 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.

Confidential - Houston, Texas

Data Analyst

Responsibilities:

• 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.
• 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.

Confidential - Houston, Texas

System Analyst II/Business Analyst

Responsibilities:

• 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-user’s 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 SmartView’s 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.

Confidential - Houston, Texas

Senior Financial Accountant/Business Analyst

Responsibilities:

• 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-user’s requirements.

Confidential - Houston, Texas

Business Analyst/Programmer

Responsibilities:

• Used Rapid SQL to connect to the backend Oracle tables to provide Ad-Hoc data and/or reports. Provided written documentation of scripts to code change within the VBA code.
• Educated user in proper utilization of current and future financial system and provide documentation of processing enhancements.

Confidential - Houston, Texas

Senior Accountant/Programmer

Responsibilities:

• 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

Confidential - Houston, Texas

Fixed Asset Manager/Oracle Power User

Responsibilities:

• 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

Confidential - Houston, Texas

Programmer Analyst

Responsibilities:

• 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.
• 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.
• 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. 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 existingSQL 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.

Confidential - Houston, Texas

Business Analyst/Programmer

Responsibilities:

• 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 the Solomon tables. Clearing all outstanding reconciling items and preparation of variance analysis.
• Designed a user friendly and more comprehensive record-keeping system for journal entry using advanced Macro’s codes, which reduced hourly wages by 85%. Processed and maintained in-house debit memos and/or reimbursements.
• Reconciled complex cash Recons PI/TI, PI, TI, Scheduled, Scheduled Actual, Bi-Weekly accounts, and Incoming/Outgoing Wires Account (Electronic Funds Transfer).
• Discovered reconciling items saving nearly $1,500 in monthly fees that were performed by the Investor Accounting area and authorized clearance. Cross-Trained in other areas of accounting: Accounts Payable and Accounts Receivable. Prepared and maintained reserves requirements schedule.
• Reconciled deposit verification report to the general ledger, which prevented financial loss. Created a system that will take collected information, prepared balance sheet, profit and loss statement, and other reports by summarizing current financial status.
• Uploaded general journal entries into the ledger accounts and posted accounts payable items into production system. And process accrual entries and end of the month closing entries.
• Conducted extensive research of source documents constructs financial statements for the corporate accounting area that interfaced with the general ledger.