SUMMARY:

Business and accounting systems professional with ten years’ experience in corporate accounting, programming accounting schedules and reports. Confidential 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. Confidential 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.

ERPS AND ACCOUNTING APPLICATIONS:

Oracle Applications 11i ERP: Version 11.5.6 to 11.5.10 running on a Sun Solaris platform. External data interfacing conducted from Intel/NT platforms. Configuration consists of an Oracle Server 9i back end with a Java/SQL front - end browser based client.

Ross Systems ERP: Versions 3b to 5.2 on an HP/Compaq using Windows NT and UNIX platforms respectively with Win95-2000 clients. External data interfacing conducted from Intel/NT platforms. Client/Server configuration consists of an Oracle database back end with an IRen Desktop front-end client.

On-Line Analytical Processing (OLAP): Hyperion/Essbase/HFM - All system and some database administrator functions. Client/Server configuration consists of the Essbase Server back end with Microsoft Excel, Lotus 123, and custom VB front ends. Oracle Application 11i, Solomon Accounting, Carillon Accounting, Peachtree, Dynamics Great Plains, Bolo System - Complete package knowledge of these personal computer based accounting systems.

SYSTEMS AND SOFTWARE:

DATABASES PROGRAMMING LANGAGES: Oracle - Versions 7.3.4 to 10g VB.net Frameworks; Visual BasicMicrosoft 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 shellMicrosoft 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:

Confidential, Houston, Texas

Developer/SQL DBA

Responsibilities:

• 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 Confidential data sourcing, migration, quality, design, and implementation.
• 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.
• 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:

• Used Tibco 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/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:

• 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.
• 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 Confidential well Confidential 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:

• Process data from SQL databases and other data sources, analyzing source data 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.
• 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.
• 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 Confidential 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/Script Writing

Responsibilities:

• 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.
• 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 /Business Analyst

Responsibilities:

• 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.
• 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 Confidential 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 Confidential 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. (.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:

• 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-user’s requirements.
• Automate the roll forward schedules and analysis reports using VBA code and linking these Excel spreadsheets to MS Access table links.
• 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.
• 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