SUMMARY:

• Senior Data Warehouse Architect/Consultant 15 yrs
• Senior Informatica ETL Administrator/Developer 20+ yrs
• Business Intelligence Expert 15 yrs
• Database Administrator/Developer Oracle, SQL Server, Sybase 20+ yrs

SOFTWARES - PLATFORMS:

Front-End: Microsoft .NET, ASP.NET, VB.NET, Visual Basic (VB), VB-based Macro script (for Microsoft Excel), Powerbuilder 5.0 & 6.0, HTML, FrontPage 2000

Languages: C, Pro-C, Unix Korn Shell, Awk, Sed, SQR (4GL Sybase report writer), Pascal, Lisp, Prolog

Operating Systems: Unix (Sun-Solaris, HP-UX), Exceed (X-Windows emulator), Windows 95/98/NT/2000/XP/7/8, MS-DOS

Other Tools: Autosys, IXP, ACCE, Confidential, MKS, Scopus, MS Project 2000, Visio 2000, Lotus Notes, MS Outlook, VPN corporate remote access, PuTTY, Visual SourceSafe, MoveIt, Agile methodology

WORK HISTORY:

Confidential, Minneapolis, MN

Senior Consultant

Responsibilities:

• The client recently acquired 6 international subsidiaries and needed to bring their Purchase Order, Invoicing and Payment data spread in various source databases (Oracle, Progress, SQL Server) into the client ’s enterprise Data Warehouse.
• Worked in a 5-person team as one of two ETL experts, analyzed the data in all sources (data profiling), wrote ETL specs for each source system table, designed general ETL framework to manage, monitor and control the load thru run metadata, row count logging, error tracking, dynamic parameter file creation.
• Wrote 200 mappings, mapplets, sessions and workflows. Unit and system tested the code, corrected issues (used JIRA to track them), deployed to production, trained Confidential developers and business analysts as system hand over to client.
• INFORMATICA 9.6, ORACLE 10j, ORACLE SQL DEVELOPER, ATLASSIAN JIRA

Confidential, Denver, CO

Senior Consultant

Responsibilities:

• Created daily process to download international Mutual Funds key performance indicators from Morningstar and upload them into Janus ’ Data Warehouse.
• Designed Oracle-based Data Mart for consumption by Web-based online dashboard.
• Wrote 50 mappings, 50 sessions and 5 workflows.
• Generated Autosys jobs to manage scheduled runs of workflows.
• Incorporated custom error tracking, restartability.
• Trained 2 Confidential developers, 2 QA analysts and
• Business Analyst to take over operation, maintenance and future development activity.
• INFORMATICA 9.6, ORACLE 10j, ORACLE SQL DEVELOPER, AUTOSYS/IXP interface, AGILE, ATLASSIAN JIRA

Confidential, Centennial, CO

Senior Consultant

Responsibilities:

• Tracked all sales communications (phone calls, emails, messages) for analytics on sales team activity vs. revenue, calculate incentives and bonuses, increase sales productivity. Staged and integrated the communication data into Enterprise Data Warehouse.
• Created Confidential Frameworks for executive reporting.
• Replaced the process to pull all mutual-fund transaction data from 16 major financial firms and load it into Data Warehouse.
• Optimized performance to process 10 million transactions daily and to aggregate the data for further user aggregation and reporting.
• Presented new process to top management and CIO.
• Worked with Agile team methodology.
• INFORMATICA 9.6, ORACLE 10j, AUTOSYS/IXP interface, TOAD 11, MOVEIT, Confidential, AGILE

Confidential, Greenwood Village, CO

Business Intelligence/Data Warehouse Manager

Responsibilities:

• Managed projects, tasks, progress, status, deadlines. Supervised team of 5 junior Informatica developers, architects and administrators.
• Reported status to upper management.
• Purchased, installed and administered Informatica 9.6.
• Assessed, installed, followed training IBM TM1 ( Corporate Performance Management software for financial forecasting, planning, budgeting).
• Installed Confidential to replace Business Objects. Ran Informatica ETL training for 3 junior developers.
• Developed new functional modules into Data Warehouse for marketing, product usage tracking, customer demographics, invoicing and finance
• Created 30 feeds between Data Warehouse and other various data systems (PeopleSoft, SalesForce, Softrax, Oracle Financials, Oracle, IBM TM1) Maintained and operated existing Data Warehouse used by 60 finance users across organization.
• INFORMATICA 9.5, Oracle 10j, TOAD for Oracle, SalesForce, Oracle Financials, PeopleSoft, Confidential, IBM TM1

Confidential, Greenwood Village, CO

Senior Consultant

Responsibilities:

• Built a Business Intelligence infrastructure with an ETL process that extracts/consolidates healthcare sales transactions, invoices and revenues from 3 billing systems and a CRM into a Data Warehouse and enables an OLAP analytic application to slice and dice metrics such as sales, invoices, revenues, contracts, products, subscriptions, healthcare organizations (hospitals & insurances), accounting periods.
• Designed, modeled and built 3-tier architecture Data Warehouse platform with Staging, Confidential, and Data Mart. Built a Normalized Confidential for data snapshot cleansing, consolidation and integration. Built a Data Mart with 6 multi-dimensional multi-hierarchical Star Schemas with dimensions and fact tables, tuned for metrics reporting, performance-based queries.
• Physical implementation in Oracle 10g. Partitioned Oracle table data and index on large history tables. Partitioned Informatica sessions loading into those tables.
• Designed and built a suite of 100 mappings, 100 sessions, 15 workflows to process the data into the various repositories of the Data Warehouse. Connected to Oracle (PeopleSoft and Oracle Financials) and SQL Server databases and web-based CRM application ( Confidential ) to pull data from. Implemented error tracking, logging, database-stored parameter file generation, automation, job scheduling, version tracking, repository-based development lifecycle migration. Replaced a 5-day manual process that generates 3 legacy reports with a fully automated 3-hr end-to-end ETL process feeding into a Data Mart.
• Wrote VB-based Excel macros with direct connection to the Data Warehouse Meta data for data reconciliation, error reporting.
• Built a layer of Business Objects XI universes based on the OLAP database in the Data Mart. Created 20 Webi reports on top of the universes for analytics on healthcare metrics, dimensional hierarchy slicing and dicing.
• INFORMATICA 8.6 & 9.1, Oracle Designer 6.5, TOAD for Oracle, TOAD for SQL Server, Business Objects XI.

Confidential, Boulder, CO

Senior Consultant

Responsibilities:

• Modified existing Data Warehouse tables (metrics on quality assurance measuring and controlling factory production flow) to host new incoming automobile production-related data.
• Enhanced existing daily load process through stored procedures and views.
• Tuned performance of heavy queries. Set up logging and monitoring process, data error and exception management. Created change control methodology.
• Tracked versions of DB objects (scripted with Script I/O) into source control tool Visual SourceSafe.
• Tracked schema changes with Embarcadero Change Manager 5.0.
• Also used INFORMATICA 8.1 to perform ETL load into various user functional Data Marts, for Accounting, Sales, Inventory and Distribution.
• Implemented backup and recovery procedures. Managed table space and file system storage.
• SQL SERVER MANAGEMENT STUDIO 2005, TOAD, MS VISUAL SOURCESAFE 6.0, EMBARCADERO CHANGE MANAGER 5.0, SCRIPT I/O, INFORMATICA 8.1

Confidential, Denver, CO

Senior Consultant

Responsibilities:

• Upgraded Informatica server, repository, and objects (workflows, sessions, mappings, mapplets) from 7 to 8.1.
• Upgraded Autosys jobsets, Unix Shell scripts, environment variables, configuration lookup files to conform to new Informatica environment and new Unix servers.
• Managed version control in Confidential and used team project management tool TeamTrack.

Confidential, CO

Senior Consultant

Responsibilities:

• As part of a new internet portal to enable investors purchasing securities to analyze the health of their portfolios by evaluating analytics on the underlying mortgage loans, delinquencies and other metrics:
• Designed the logical and physical models of an Operational Data Store ( Confidential ) and a Data Mart (DM) to host the loan metrics, architected and optimized the 500GB Confidential and DM on Oracle platform for optimal reporting. Implemented data historical change tracking with set of keys, sequences, effective dates and “sequence skidding process”.
• Developed and implemented the end-to-end 100-mapping ETL process with INFORMATICA 8.1 from multiple loan tracking systems into the Confidential and Data Mart.
• Tuned the ETL and Oracle objects (Informatica session partitioning, Oracle table partitioning) to increase load and query performance of 12 years worth of historical data.
• INFORMATICA 8.1, ORACLE 10g, SQL SERVER 2003, ERWIN, EMBARCADERO ER STUDIO 7, EMBARCADERO DBARTISAN 8.1.1, TOAD.

Confidential, Centennial, CO

Senior Consultant

Responsibilities:

• Designed the ETL architecture for 2 star schemas in a functional performance-driven data mart starring the entire mutual fund trading transaction history for business intelligence analytics. Loaded an initial 150 million records.
• INFORMATICA 8.1, ORACLE 10g, ORACLE SQL DEVELOPER.

Confidential, Denver, CO

Senior Consultant

Responsibilities:

• Designed and implemented an automated or on-demand data interface platform between Confidential Data Warehouse and its external vendors’ Confidential sites to allow the quick building of data feeds requested by vendors.
• Confidential outsources its various financial plans, programs and services to outside vendors who manage them through those indirect data feeds.
• The data interface platform consists of a set of programs that link SAP, Data Marts on Oracle 9i fed from Janus’ main Data Warehouse, Informatica 7.1 for ETL, Autosys jobs for task scheduling and management, and produce data extracts that move between Confidential and external https-based Confidential sites.
• Created Autosys jobsets, Informatica workflows, Unix Shell scripts, Oracle Stored Procedures, Crystal Reports.
• Managed version control with Confidential and used team project management tool TeamTrack.
• Used PuTTY and Xceed for Unix host.

Confidential, Vancouver, WA

Senior Consultant

Responsibilities:

• Built a three-tiered architectural platform that provides accounting and finance experts business intelligence tools to track, analyze and reconcile the company’s financial activities.
• Designed 3 Data Marts (General Ledger, Accounts Payables, Purchasing Orders). Created daily extraction process from mainframe and 25 ETL mappings to load the data into the Data Mart.
• Created 7 OLAP Cubes for Business Intelligence Analysis and Data Mining, 5 Excel query-based and cube-based Pivot Table reports, 6 Crystal Reports.
• Automated the ETL process with the Informatica scheduler and the cube generation with MS Data Transformation Services.
• Used INFORMATICA 7.1, MICROSOFT SQL SERVER 2000, MICROSOFT OLAP ANALYSIS SERVICES, EXCEL PIVOT TABLES, CRYSTAL ENTERPRISE 10.

Confidential, Seattle, WA

Senior Consultant

Responsibilities:

• Built Data Warehouse to analyze online travel activities (trip bookings, travel-related services, payments, finance, accounting).
• Designed the overall ETL to load from Expedia's online reservation system into the Data Warehouse.
• Created record "skidding" logic (to keep track of data changes/updates in fact and dimension tables of TYPE 2). Implemented error handling process.
• Created a bulk comparison method between incoming source data and existing warehouse records for incremental load.
• Maintained operational metadata tables to keep load information history.
• Performance-tuned mappings to minimize time to process 20 million rows a day.
• Created 60 dimension and 20 fact mappings, 80 sessions and 8 workflows.
• Used INFORMATICA 7.1, IBM DB2 database.

Confidential, CO

Senior Consultant

Responsibilities:

• Designed the Business Intelligence Repository, an architecture for business intelligence on the web logging of Dexonline.com (studying the usage of the web site) and for reporting on certain measure key elements with the purpose of enhancing the users’ experience and benefits of the website. High performance-tuned model to receive over 1 million rows per day, accounting for all website user clicks. Used ORACLE 9i, ORACLE DESIGNER, TOAD.
• Designed logical Data Mart model with metrics to support analytics on national sales of Yellow Pages advertisements. Built physical model into Oracle 9i database, created star schemas, cubes, aggregates. Used ORACLE 9i, ORACLE DESIGNER, TOAD. Designed 25 ETL specifications to load Data Mart from main enterprise Data Warehouse.
• Enhanced and expanded Data Warehouse model to fulfill new requirements, reporting needs, marketing campaign, program launch, data source change.

Confidential, Denver, CO

Senior Consultant

Responsibilities:

• Converted from a mainframe an outage management and reporting system that tracks and reports power outages, causes, and electrical devices for Data Mining purposes, to analyze and understand past outages to predict, minimize and budget future outages.
• Modeled DATA MART in ORACLE 9i, containing 4 fact and 12 dimension tables. Used TOAD and ERWIN.
• Created 35 INFORMATICA 6.2 ETL mappings pulling data from mainframe source files, ORACLE-based and MS SQL Server-based systems to the outage DATA MART.
• Designed the ETL to stage the source tables in a separate stage area to minimize operational impact on source system, then load data into warehouse applying all business rules converted from analysis requirements. Created BUSINESS OBJECT report and universe.
• Built a full electrical, gas and land device asset repository into the DATA WAREHOUSE by integrating 10 different systems used by Confidential in 5 different parts of the country. Integrate all devices between all systems following a logic of matching devices by code, name and feeder originator, and using cross-reference tables to retain native and warehouse keys.
• Designed the database tables in the data warehouse.
• Created 120 INFORMATICA 6.2 ETL mappings to stage the asset collection from the OLTP source systems into a staging area, and another 120 mappings to load the devices into the warehouse. Used TOAD and ERWIN. Implemented an ERROR LOGIC that retains a child record in stage if the parent record is absent and attempts to reload it the next day.
• Implemented a DELTA STRATEGY that figures out changes in the source systems and loads only the changes into the WAREHOUSE, not the entire database snapshot.