We provide IT Staff Augmentation Services!

Business Analyst / Oracle Data Testing And Validation Resume

SUMMARY:

Obtain a contract position with a company that will allow me to make use of my ETL, data modeling, database design and build, OBIEE Administration and data warehousing skills, in a team environment or on my own. My specific skills and references are listed below.

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst / Oracle Data Testing and Validation

Responsibilities:

  • Working at Bank of the West in San Ramon, CA on the Federally mandated program CapPR/CCAR, performing validation and testing of the transformation of source historical data to the required file structure which is submitted to the Federal Government
  • Writing SQL scripts based upon Business Analysts data mapping documentation to validate and test the accuracy of data being pulled from multiple source system data, some of which are no longer in use, to provide accurate reporting to the Federal Government
  • Writing of ad - hoc SQL queries which are used by financial analysts to retrieve data which is then exported into Excel and used for manual validation of the data compared to various general ledger documentation

Confidential

OBIEE / ODI / ETL Datawarehouse Developer

Responsibilities:

  • Data Warehouse Design and build, including source to target data mapping, transformation logic and detailed specifications, logical and physical database design build.
  • Installation and Configuration of Oracle Data Integrator 11g
  • Utilize Oracle Data Integrator to design and develop ELT Interfaces and Load Plans to populate Oracle 11g data warehouse
  • Responsible for Data Quality at the Naval Surface Warfare Center in Norco California and for making recommendations to enhance and improve data sourcing and structure.
  • Administrative set up of Oracle Business Intelligence Enterprise Edition 11g including Physical Layer, Business Models and Subject Areas based upon user specifications
  • Trouble-shoot and resolve OBIEE performance and reporting issues
  • All of the above were managed using Agile methodology for which I was an active participant in the Sprint Planning, include task scheduling and issue resolution, and daily scrums.

Confidential

Contractor

Responsibilities:

  • Hired to create an Enterprise wide data repository, documenting all databases, including subject matter, in order to justify moving forward with a major Strategic Data Planning initiative.
  • Create and implement an Enterprise wide Data Governance and Data Stewardship policy.
  • Develop Datawarehouse ETL strategies for Oracle Business Intelligence Enterprise Edition, (OBIEE), implementation. Maintain up-to-date knowledge of Oracle Warehouse Builder 11g via Internet blogs, membership in Linkedin Datawarehousing Professional’s Group, Oracle’s OTN discussion groups, etc. in anticipation of future use at NDOT.
  • Review PL/SQL Packages, Procedures and Functions and provide recommendations for performance improvement and quality control.
  • Identify data cleanup opportunities and make recommendations for IT standards implementation.

Confidential, Albuquerque, NM

Systems Analyst V / ETL Datawarehouse Developer

Responsibilities:

  • Primary responsibilities include Health Plan’s Data Warehouse design and development using, primarily, Oracle Warehouse Builder 10g, PL/SQL scripts and SQL Loader.
  • Write custom PL/SQL packages, procedures, and functions to assist in the ETL process.
  • Worked with data from “both sides” of the health care business, Claims Processing and Health Care Data.
  • Mentoring of other staff in the use of, and best practices for Oracle Warehouse Builder.

Confidential, Oak Brook, IL

ETL Datawarehouse Contractor

Responsibilities:

  • Hired to provide ETL support for a large project using Oracle Warehouse Builder 10g. Performed tasks ranging from initial mappings through data validation. Reviewed and provided performance improvement as needed using tools such as SQL Developer and TOAD to review PL/SQL code and apply indexing. Designed, developed and implemented process flows.
  • Created and maintained ETL documentation.
  • Created and maintained testing and validation documentation.

Confidential, Sunnyvale, CA

Sub-Contractor

Responsibilities:

  • Hired to convert Access Database queries and reports to Oracle based tools. Oracle Warehouse Builder 10g was used to create mappings which are run weekly to extract and load data into a new, smaller, more efficient Oracle 10g database. Oracle Discoverer 10g was then installed and set up to provide production reports as well as an ad hoc query environment.
  • Write custom PL/SQL packages, procedures, and functions to assist in the ETL process.
  • Provided training on the use of OWB and Discoverer.

Confidential, Naperville, IL

Sub-Contractor

Responsibilities:

  • Worked with database design staff to refine and enhance the Oracle Database Dimensional Data model
  • Oracle Warehouse Builder Developer 10g - Created mappings to extract data from several data sources and load into a single Oracle 10g database.
  • Discoverer Administrator/Developer - Set up of Discoverer EUL as well as creation of Discoverer Reports which were created to replace existing production reports.

Confidential, Novato, CA

Sub-Contractor

Responsibilities:

  • Discoverer Administrator - Hired to assist the Accounting staff understand their existing Discoverer setup. While there, found that they had purchased Noetix Views, (GL, AP, FA, and AR), but had never been given the opportunity to use them. Cleaned up the environment, set up the proper security and provided user training in the use of Discoverer as well as the structure and use of the Noetix Views.
  • Worked with Oracle On Demand and provided assistance in the upgrade of Discoverer from version 4i to 10g.

Confidential, Appleton WI

Sub-Contractor

Responsibilities:

  • Discoverer Administrator - Provide Discoverer Administration for Confidential ’s new implementation of Oracle Application’s EBS system, (Oracle Applications 11.5, GL, AP, AR, OM, etc.), which included creation and maintenance of the Discoverer EUL’s, (Business areas, folders, LOV’s, registering of functions, user security, etc.)
  • Design/Create Database Packages and Procedures using PL/SQL, SQL PLUS and TOAD
  • Discoverer Training - Both Administrator and End User
  • Develop Discoverer Workbooks
  • Sumbit and monitor TARS via Metalink. Work with Oracle on Demand, (OOD), to complete fixes.

Hire Now