Data Warehouse Business Analyst

Business oriented Data Analyst/Architect with experience in business process, data analysis, and design of systems in Financial Systems; Customer/Marketing/Revenue Analysis; Pharmaceutical Clinical Trials/Regulatory Submissions, and Healthcare Outcomes Analysis. Conducted detailed JAD sessions for line business requirements and senior executive strategic data initiative analysis and translated to System Requirements documents, logical data mapping and dimensional model designs. Skilled in use of JAD techniques to determine and confirm capability of logical models to support business goals. ••••• Excellent writing and communication skills: presented at worldwide technical symposiums; regular presenter at board and executive level. Independent vendor contract negotiations and ongoing relationship management as both vendor and user representative.


EXPERIENCE:

GMAC RESIDENTIAL MORTGAGE INFORMATION TECHNOLOGY (6/•••••/•••••)••••• ENTERPRISE DATA ARCHITECT (6/•••••/•••••)••••••••••Developed enterprise information architecture by leading/conducting interviews and design sessions at LOB and senior levels
Gained executive approval for $•••••MM capital project and led resulting HW/SW purchases, infrastructure design, services contracting, hiring, and budget planning monitoring. Set up continuing vendor relationships. Built team of GMAC, EDS, and external personnel. Promoted to Manager of group.
Designed data integration strategies for newly generated financial transactional data and multiple legacy systems into single dimensional target to support analysis and reporting on client/correspondent activities, credit risk/scoring/prediction, loan details and analysis. Led efforts to test new functions/calculations proposed for the datamart and its quality control.
Planned integration of corporate-wide credit risk analysis into common EJB transaction switch using real-time data warehouse access that would support credit lookup, history capture, risk analysis, and detailed customer information.
Led successful completion of combining multiple legacy financial data sources into unified data mart.
Integrated new technologies into existing change management/support structure by close contact with business users and IT infrastructure establishing new service level standards, support roles, versioning of ETL modules, and began ongoing production monitoring of report run times and overnight ETL processing parameters.
Delivered financial dimensional reporting system using BusinessObjects web and client tools and Ascential Data Stage ETL tools to support Warehouse Banking division.
Delivered assessment of dependencies for integration of new financial servicing system and product origination system.
Analyzed business needs for common data architecture; wrote and presented on common data solutions for implementation at GMACR. Interviewing and analysis of business concerns, research on business trends, and assessment of technical solutions.••••• MCGRAW-HILL COMPANIES - CONSTRUCTION INFORMATION GROUP (•••••/•••••/•••••)
•••••
DATA WAREHOUSE LEAD, ENTERPRISE CONTENT MANAGEMENT (•••••/••••• 4/•••••)••••• Maintained interface between various publishing user groups and the technology group.
Successfully delivered companys first business-unit level reporting system to identify top customers, compare revenue between unit divisions, and forecast areas for sales penetration. Solved major customer data problem of no common customer identification by introducing the Dun & Bradstreet numbering scheme.
Saved business unit $•••••,•••••/year by combining internal legacy customer database with Dun & Bradstreet MARKET SPECTRUM system to offer desktop sales penetration analysis to marketing staff. Lauded by CEO Terry McGraw as something not seen anywhere in the Company.
Represented business unit as Technical Architect during planning and design process to collapse various web systems into a single consumer-focused model providing web authentication and fulfillment control. Attended management committee meetings as technology representative; documented user requirements, business issues.
Delivered to senior management and technical staff a researched Data Architecture strategy to combine customer, operational/financial, and fulfillment data into logically combined data stores.


CARE SCIENCE CORPORATION (2/••••• TO •••••/•••••) ••••• ASSOCIATE DIRECTOR, DATA ARCHITECTURE••••• Reduced operational costs in time and staffing by designing a unique system for automating a manual data validation/transformation process into a comprehensive Data Warehousing system. Using ETL tools, data load times were reduced from three to four days to a single day. Encompassed inclusion of massive existing PERL arrays into the ETL flow.
Customer contact and liaison for major customer performance issues through leading team research/analysis with DBAs and developers on web issues surrounding performance in a multi-server environment.
Provided data architecture and design to support a growing Internet-based outcomes analysis and pharmaceutical marketing information system. Daily supervision of four DBAs responsible for ORACLE environment on NT and HP-UX; over ••••• Instances on •••••+ machines.•••••INDEPENDENT CONSULTANT; (•••••/••••• to •••••/•••••); Various Pharmaceutical Clients••••• Completed functional analysis/logical design for an electronic publishing system for regulatory affairs. Designed complex document publishing process model.
Complete rollout of Documentum/Oracle SOP system, including final Y2K testing. Wrote test scripts, coordinated testing to regulatory standards. Design and Project Management of Documentum/Oracle systems for electronic publishing of submissions and SOPs.
Analyzed requirements and alternatives for a Clinical Phase Four marketing data analysis system. Coordinated cross-functional team to collect requirements and document. Created Conceptual and Physical Models using Oracle Designer.
Provided clinical data warehouse five-year strategic plan covering data warehouse, infrastructure, Decision Support, and applications. Conducted JAD sessions with financial, marketing, and clinical users.
•••••

SOUTHERN OCEAN COUNTY HOSPITAL (4/••••• TO 9/•••••)

DIRECTOR, Information Systems
Supported growth from Hospital to Health System by providing emerging market reporting and managed care contract analysis by integrating data from clinical operations, finance, and third party systems.
Led business through comparison of Oracle Financials and PeopleSoft, leading to PeopleSoft acquisition and installation.
Designed and implemented corporate data warehouse to support care continuum marketing and clinical operations in order to provide required patient and cost management reports. Integrated flat file, ORACLE, SQLServer data to provide online reporting.
Designed and project managed a Patient Care System using ORACLE •••••X for in-room data collection saving the hospital $•••••,••••• over vendor purchase. Conducted RAD sessions, completed logical/physical data model (ORACLE DESIGNER), prototypes initial physical design.


LEDERLE LABORATORIES AMERICAN CYANAMID CORPORATION (7/••••• TO 4/•••••)

INDEPENDENT CONTRIBUTOR (Technical Staff)
Lead role for the delivery of an Electronic Publishing/Document Management system for the Regulatory Affairs submission process, using ORACLE, DOCUMENTUM, and INTERLEAF in a PC/MAC/UNIX/LAN client-server environment. Led business user team to determine design, documented and presented prototype to President for project approval. Project managed and coordinated IS/User team supervised consultants, technical design. Delivered status to senior management. Budget creation/maintenance responsibility
Successfully project managed the analysis, prototype, design, delivery and training of a client-server ORACLE/OMNIS••••• application spanning global Phase III and IV results, plus off-label use tracking. Extensive contact with Clinical Research management, development group contact, DBA coordination, problem solving, and vendor/consultant contact.


ORACLE CORPORATION PHARMACEUTICAL GROUP

CONSULTING MANAGER (••••• to •••••)
ACCOUNT EXECUTIVE (••••• to •••••)
Design, Project Management, Implementation of several major pharmaceutical data base systems. Expertise in Clinical Phase II and III systems design and project management. Part of team designing initial Oracle Clinical System offering. Participated in global data modeling effort to map European clinical trial needs into US system design.
Direct customer relationship responsibility as both Consulting Manager and Account Executive to major accounts.•••••KPMG/PEAT MARWICK (••••• TO •••••)••••• SENIOR CONSULTANT (•••••) Banking IT/Audit Practice
MANAGER (•••••) East Coast Airlines Consulting Practice

Analyzed business requirements for retail banking applications and assisted in system selections.
Executed numerous audits of retail banking applications including Demand Deposit, IVR, Customer File, and Platform Automation.
Carried-out full third-party bank application data center audits down to personnel, backup strategies, and hardware capability.
Performed technical analysis prior to installation of ATM networks; design and capacity projections for network usage.
Evaluated regulated processes for compliance to applicable Code of Federal Regulations.
Provided design of an integrated flight management and control system for a major airline.
Pioneered airlines segment financial analysis concepts to replace pre-non-regulated average seat mile analysis.
••••• EDUCATION:•••••MASTER OF BUSINESS ADMINISTRATION DEGREE IN INFORMATION SYSTEMS
•••••Fairleigh Dickinson University. Graduated •••••

•••••BACHELOR OF ARTS DEGREE IN HUMAN COMMUNICATIONS
•••••Cook College, Rutgers University. Graduated •••••

Using Enterprise Modeling for Organizational Systems Design, DIA CDM Proceedings, March •••••

Presented: Organizational and Systems Design Issues for Document Management, IIR; Washington, DC; November •••••

Attended several ABA national conventions as IT consulting rep for Peat Marwick (now KPMG).

•••••RELATED SOFTWARE EXPERIENCE: •••••ORACLE •••••, 9ias and 9iad, 8i series (•••••X, •••••X), DESIGNER, DEVELOPER, ORACLE ENTERPRISE MANAGER;
ORACLE TUNING/PERFORMANCE PACK; SQL SERVER; TOAD; •••••BUSINESS OBJECTS/WEB INTELLIGENCE, DESIGNER, SUPERVISOR; ORACLE DISCOVERER; MS ACCESS •••••ASCENTIAL DATASTAGE, METASTAGE; INFORMATICA ETL; DATAJUNCTION ETL; ORACLE WAREHOUSE
BUILDER ETL