We provide IT Staff Augmentation Services!

Senior Data Warehouse Reporting Lead Resume

SUMMARY:

  • I have 20+ years extensive knowledge of Data Warehouse operations, team development, financial reporting, analysis and systems architecture. I have worked in both the private and public sector but most of my experience has been working with financial reporting systems. The majority of the projects I have worked on have been large Oracle databases, but have also worked with Sybase and Informatica. All of the projects that I have worked on have been in direct daily contact with both end users and the application owners.

TECHNICAL SKILLS:

Oracle Database versions 7: 12c and Exadata, Oracle Developer Tools Suite(Forms 4.5 - 10g, Reports 3 - 10g), SQL, PL/SQL, Oracle Enterprise Management Tools, Oracle SQL loader, SQL plus, Oracle Express, Oracle Designer, Oracle Application Server, Oracle Discoverer, MySQL, Informatica

Applications: Tableau, Informatica, Autosys, SAS, Office Suite, Microsoft Dynamics GP

Languages: SQL, PL/SQL, Unix, Javascript, PHP, HTML

Operating Systems: Windows, UNIX

Business: Multiple large scale SDLC implementations, Business Analysis, Data flow analysis and design, Healthcare IT, Agile Development, Git

Financial: Credit Risk, FX, GL, Derivatives, Commodities, Capital Markets, VMaster, Advantage, Sierra, Summit

PROFESSIONAL EXPERIENCE:

Confidential

Lead

Responsibilities:

  • Responsible for design, development and operation of Oracle Exadata database that processes approximately 400 million transactions per month for gross revenue of $33 million per month
  • Design, create, tune database structures including Tables, Packages, Sequences for maximum efficiency; manage dedicated schema for Invoicing processes
  • Create and maintain data architecture for database schema used for invoice and accounting processes
  • Manage Database processes for 15 differing Healthcare product types; each having differing business logic to apply; Understanding workflow of all product types so that business logic can be applied accurately and consistently
  • System applies business logic from internal tables to determine billable status and apply billing rates
  • Standard reports are distributed via Sql Server Reporting (SSRS) and Tableau and submitted to accounting to enter into the General Ledger
  • Work with all levels of Finance and Accounting Organization to design and build Ad Hoc reports, analyze P&L impact and create new reports
  • Liaison between technical/database teams and Finance/Accounting and Product Teams
  • Recently converted the entire invoice process from SQL Server to Oracle Exadata. In the process, reengineered the process to take advantage of Exadata advantages which have cut processing time by 80%
  • Responsible for creating requirements for new and modified accounting functions
  • Responsible for insuring new contract and customer data is accurately applied to invoice data

Confidential

Senior Data Warehouse Reporting Lead

Responsibilities:

  • Data warehouse supports the reporting requirements for the General Ledger for all Confidential Divisions
  • Loading data into Oracle data warehouse using Autosys and Oracle 11g
  • Designing / creating new reports, Oracle procedures, Unix scripts and Autosys jobs
  • Monitoring and modifying existing warehouse infrastructure
  • Tuned database queries
  • Adding / modifying table structure and indexes where needed
  • Designing new tables to maximize report return time
  • Creating design documents and release documents
  • Managing the movement of database structures from development through production

Confidential

Senior Data Warehouse Reporting Lead

  • Developed reporting system with Middle Office and Traders for analyzing changes in marked to market values based on changes in credit market
  • Reports were used to by traders to monitor hedging strategy effectiveness
  • Middle Office used them to reconcile GL and meet SEC reporting standards
  • Communicated between the multiple Middle Offices, Traders, Quantitative Analysts and Technical Team to make sure that all requirements were met
  • Reporting system was built on an Oracle 10g database
  • Data was pulled in from multiple Sybase and Oracle databases from both Merril Lynch and Confidential via Infomatica and Java processes
  • Worked primarily as a Data Warehouse lead, but because of my background with finance and management, I interviewed potential new team members, onboarded new hires and trained them on the aspects of our team including an understanding of derivatives trading, reporting needs, the various calculations used in the group and the technology needs
  • Led a group of developers
  • Met with traders and front office on a daily basis to create ad hoc reports
  • Mapped process flow and created logical and physical database diagrams
  • Created Informatica workflows; Unix scripts; PL/SQL scripts, Packages, Procedures and Functions
  • Responsible for implementing and maintaining data retention policies

Confidential

Data Warehouse Manager

  • Developed and Managed Data Warehouse built with an Oracle 10g backend that utilized Discoverer and Flex for the front end
  • During design and initial build of the system, managed a team of developers
  • Responsible for Administration of the warehouse including maintenance, data loading, training users and documenting new processes
  • Worked with users to identify necessary modifications and additions to the data sources
  • Added / Modified PL/SQL procedures, functions and packages as needed
  • Mapped data flow from the source systems through to the Datamarts
  • The ETL process was composed of approximately one hundred procedures and functions over 14 marts
  • Was in daily contact with both end users and the client
  • Held weekly meetings with the client to assure all project deliverables were being met

Confidential

Senior Datawarehouse Reporting Lead

  • Contractor for DOT Federal Highway Administration payment processing system
  • Responsible for maintaining day to day operations and adding / modifying enhancements to the existing system utilizing PL/SQL
  • Designed, scripted and tested new enhancements to the application using Oracle forms 10g and made appropriate changes to the underlying Oracle 10g database
  • Wrote documentaion for enhancements / additions is in accordance with the Capability Maturity Model level II.

Confidential

Senior Datawarehouse Reporting Lead

  • Member of team that developed and supported a large financial system
  • Loaded data files daily using SQL loader, PL/SQL packages and UNIX
  • Performed source to target mapping
  • Wrote several packages and stored procedures for the ETL process and moved the data from the staging relational database to the star schema that was used for reporting purposes
  • Dimensional modeling expert to the VHA CBO project team and offered expert guidance and support to the application design team
  • Helped the team analyze requirements, source data file layouts and proposed changes to the logical dimensional models
  • Proposed enhancements to the star schema for the reporting system using Oracle Designer
  • Created materialized views to summarize data for Oracle Express cubes
  • Wrote Unix Shell scripts to schedule jobs
  • Maximized efficiency in data loading and retrieval by repartitioning large tables
  • Created adhoc reports using Oracle Discoverer and Oracle Express
  • Significant time in client facing

Confidential

Lead architect

  • Responsible for design, build and implementation of a system used to track various pieces of data for the
  • Worked with high level staff members to gather requirements and produce business rules, logical design and an improved ERD
  • Built tables and structures in Oracle 8
  • Reengineered front end utilizing Coldfusion MX and javascript and interfaced with Oracle database
  • Prior to redesign, staff had shelved application and opted for manual construction of one pagers, after redesign/rebuild, website was widely used throughout department and greatly reduced labor hours

Confidential

Senior Oracle PL/SQL Lead

  • Re-engineered the original order processing/fulfillment system and created new PL/SQL (Oracle8i) procedures and functions to make the system more efficient
  • Wrote Unix scripts to call PL/SQL procedures
  • Removed and redesigned redundant processes that were inefficient and broke nightly After rewriting the procedures and building more efficient packages and functions, the downtime for processes was close to zero

Confidential

Senior Application Developer

  • Client/Server application development for electric cooperatives using Oracle database versions 7 through 8 and Oracle development tool sets (Forms 4.5 - 2000, Reports 3 - 2000)
  • Extensive use of PL/SQL, Oracle forms, reports and discoverer
  • Involvement in the full development cycle including process mapping, system design, implementation and deployment
  • Designed user interfaces and supporting code
  • Work performed both in teams and with very limited guidance
  • Responsible for debugging and maintaining code and making appropriate corrections to fit database constraints and business rules
  • Assisted in coordination of software releases
  • Designed and maintained internal web used to facilitate sharing of information by development team
  • Designed, coded and maintained external web site for company

Confidential

Internship

  • Worked directly with sales representative to created and maintain database of contacts
  • Arranged demonstrations of software for potential customers through cold calls
  • Assembled computers that were used at client sites

Hire Now