OBJECTIVE:

Seeking a position that involves designing and creating a Integrated Enterprise Data Model that merges data from various disparate sources and systems. I believe a well - designed Integration Data Model is key to providing timely dashboard, compliance reports, and valuable scorecards to decision-makers. For the last decade, I have been creating Integrated Data Models and reporting structure in an organization wherein every critical decision is based on retrievable and analyzed data. It has been my objective to introduce these reporting structures in a functional delivery system such as scorecards, dashboards, alerts, spreadsheets and various distributions.

EXECUTIVE SUMMARY:

• I'm an IT Professional with more than 25 years of experience in Enterprise Data Modeling, Data Analytics, Data Profiling and SQL coding. I believe that an intelligent use of historical and operational data can provide crucial competitive and strategic advantage for a company.
• I’m currently working as the Senior Data Modeler for the Confidential 's Information Management Department.
• The UW data are stored in various systems including antiquated mainframe systems, on-premise databases, more than 500 shadows systems and multiple data silo-ed in various departments.
• I created the Data Warehouse architecture to integrate these disparate data and design a presentation layer for our power users and BI Team to create reports, cubes and visualization stories.
• This Presentation Layer platform is used by at least 5,000 UW employees who directly query our SQL query as well as our Business Intelligence team show creates dashboards, cubes and visualization reports using Tableau.
• I design the information content and high-level architecture of the Enterprise Data Warehouse (EDW), including a unifying UW conceptual model and a data integration plan for the stakeholders, logical and physical data models of DW layers and specialized data marts for the ETL team to develop, and fficial documentation and metadata artifacts.

AREAS:

• Data Modeling
• Data Warehouse Design
• Data Vault
• Business Intelligence
• Business Process Modeling
• Data Mining
• Business Analysis
• Business Integration
• SQL

TECHNICAL SKILLS:

• SQL Server
• Oracle
• DB2
• Peoplesoft
• Data Modeling
• Data Vault Design
• Multi-Dimensional modeling
• Normalization
• Tableau
• Power BI
• Hyperion
• Oracle EPMS 11
• Oracle BI EE
• Microstrategy
• Business Objects
• Cognos
• Oracle HR Analytics
• Siebel CRM
• CMS Avaya
• SQL
• MySQL
• PL/SQL
• VB
• C, C++, C#
• HTML/XHTML
• XML
• ER/Studio
• Wherescape
• ERwin
• Oracle Designer
• MS Visio

EXPERIENCE:

Sr. Data Modeler / Data Architect

Confidential, Seattle, WA

Responsibilities:

• Defined architecture standards and guidelines for implementation of integration and presentation layer.
• Designed the UW Integration Layer using the Data Vault Methodology and the Presentation layer in Star/Snowflake Model.
• Produced integrated conceptual models and diagrams that map UW business areas and inform EDW expansion plans.
• Collaborated with business analysts and data modelers on project deliverables in all areas of data design
• Provided guidance in implementation of technical solutions based on overall architecture plans
• Participated in Master Data Management (MDM) planning and activities.
• Scoped, documented and produced conceptual and logical model designs for cross-subject enterprise data warehouse of the Confidential system.
• Created source-to-target mapping specifications.
• Created the Business Dimension Models (BDM), product overview documents and functional specifications
• Analyzed and document business requirements, define project plans and produce specifications for data warehouse development and information delivery projects
• Empower units across campus to effectively use data warehouse and business intelligence resources and tools through documentation and training
• Design, develop and distribute reports and analytics in response to internal and external customer requests, using BI technologies such as Microsoft Reporting and Analysis Services.

Sr. Business Analyst (BI)

Confidential, Bellevue, WA

Responsibilities:

• Designed and created the information delivery and analytics solution to the Confidential Commission system.
• Identified key performance metrics to be used for commission performance analytics.
• Created data model design schema for Confidential ’s new Sales Commission Management System (SCMS) migration to Varicent.
• Defined the business requirements of key stakeholders as they relate to information reporting, analysis and distribution.

AVP - Business Intelligence Analyst

Confidential, Indianapolis, IN

Responsibilities:

• Lead the Business Intelligence Competency Center (BICC) of JPM Chase Auto and Student Finance reporting team. Tasks included planning and development of the LOB’s reporting and analytics needs as well as data ownership and data governance.
• Perform reporting and data analysis functions in support of the various functional areas of Chase Student Loans (Risk, Finance, Collections, Marketing, Sales, Operations, Servicing, Pricing and Operational analytics).
• Works in a complex data environment and partner with the business to find solutions to business problems.
• Analyzed, pulled and aggregated data from CRM systems such as CMS Avaya and Siebel-CRM.
• Participate in reporting and analysis activities for the business, including daily/weekly/monthly/quarterly production reporting
• Develop management reporting using Hyperion System 9 and Oracle EPM System 11
• Develop automated processes to produce reports (daily, weekly and monthly) in data warehouse environment
• Creates Dashboards and Scorecards for the various business functional areas in the CSL LOB.
• Proactively generate ideas for improvement in reporting as well as new ways of looking at information
• Detailed analysis of information with the goal of developing a robust conclusion and recommendation
• Fulfill ad hoc data requests as necessary
• Work with requestors to determine needs and develop effective and efficient process to obtain information
• Work with Data Warehouse IT teams to source new data
• Work with employees from other departments to develop and implement data structures and tools that optimize reporting automation
• Manage business customer/Data Warehouse relationships

Senior Business Intelligence Developer

Confidential, Seattle, WA

Responsibilities:

• Worked as a Data Architect for the Reporting and Analytics team of the HR department.
• Designed and created the data model for the Consolidated Incentive Reporting Schema. This system provided the data mart structure for digital dashboards, benchmarking, and self-service ad-hoc reporting for the bank’s executives.
• Created internal reporting processes and analytical reports intended to improve information resources available and make appropriate recommendations to top management.
• Performed complex data analysis to advice management on data interpretation on incentive plan performance; conducting hypothesis testing and the formulation of new or revised components within and incentive plan.
• Report Lead for the Varicent project, the new Incentive Administration system replacing the outdated legacy incentive system. Created reports and pay statements using the Varicent software.
• Worked with business intelligence reporting tools to design and deliver self-service report to end-users.
• Partnered with business users and technical teams to develop critical reporting and analysis applications. Work on the synthesis of business requirements, acquisition and delivery of data to business users by working through all the phases of development including data modeling, Extract-Transform-Load (ETL), data cleansing and data validation.
• Routinely engaged in data analysis and use creative-problem solving to deliver actionable output.
• Technically savvy to work directly with databases for designing data structures; developing ETL routines to load data structures; and develop SQL’s and reports to extract information from the data structures.
• Wrote and maintained documentation of reports and datamart projects

Program Director

Confidential, Seattle, WA

Responsibilities:

• Worked as the program director for the Computer Systems program of the School of Management, Northwest’s largest private university and campuses in 7 countries.
• Managed over 70 industry-practitioner adjuncts teaching various IT courses.
• Worked as user requirement lead for the Peoplesoft implementation team for City University’s ERP migration.
• Created various reports and queries for strategic data for analysis. Used MS SQL Server, Reporting Services and SSAS.
• Lead the designing of City University’s data mart.
• Created courses in Business Intelligence, Database Management, MIS, Data Warehousing, and various Information system courses.
• Facilitated various student groups doing case studies in Business Integration, Data Warehousing, CRM, ERP and different Decision Support Resources using various tools such as Terrradata, Informatica, Siebel, JD Edwards, and Cognos.
• Managed the CS Database program, MBA Information Systems Program, CS Management Technology track, and all database courses in the CS department.
• Reviewed, created and upgraded syllabi, academic program plans and emphasis tracks in the CS department.
• Responsible for CS Teaching Faculty recruitment. Reviews applicant resumes. Setup and conducts interview and teaching demonstration for teaching applicants. Organize and distribute new CS Teaching Faculty materials.

Sr. Data Management Specialist

Confidential, Seattle, WA

Responsibilities:

• Developed application systems in health insurance, healthcare, and accounting clients for Confidential using Oracle Forms and Reports Developer 2000.
• Analyzed module designs for application systems and used the appropriate tools to employ the design for client-server and web implementation.
• Developed and used Java classes which embedded in Oracle PL/SQL stored procedures.

Project Team Lead Consultant

Confidential

Responsibilities:

• Developed two and three-tiered application for banking system with Oracle 7 Visual Basic C and Pro*C on UNIX and Windows NT environments.
• Provided consulting services by defining and implementing technical direction for the company’s clients specifically in banking loan accounts systems.
• Project lead for various applications development projects such as call centers, manufacturing, pre-need, and banking.

Assistant Professor / Systems Analyst

Confidential

Responsibilities:

• Taught courses in Assembly Language Programming Database Systems Computer Architecture Data Communications Digital Design Network Protocols and Web Page authoring and development.
• Involved in project management and systems analysis and design for the Intellect Consultancy Center of the University.
• Performed the function of Windows NT Network Administrator of the university’s consultancy center.

Mainframe Operator / COBOL Programmer

Confidential

Responsibilities:

• Worked as a mainframe operator. Responsible for start-up and shutdown of the bank’s central mainframe.
• Monitored and performed load balancing for the mainframe’s operating partitions.
• Created various COBOL ad-hoc reports for various clients and department heads.
• Managed of a team of two programmer/analysts and four consultants. Completed performance/merit reviews.