CAREER OBJECTIVE

A career position where I can effectively utilize my OLTP, EDW, Dimensional data modeling, database and IT project design and management experience to contribute to the financial success of a company.

PROFESSIONAL EXPERIENCE

confidential

Senior Data Modeler as a contractor

• Reversed engineered multiple health care source databases
• Generated all data profiling queries from Erwin
• Data profiled sources data
• Created Logical and Physical EDW models
• Generated DDL for Exadata
• Created all Exadata objects in Development platform
• Created source to target documents for Informatica team on shore and off shore
• Modeled data marts for QlikView access of clinical and operational functions
• Assisted development team with Exadata performance
• Worked with QlikView developers
• Followed Agile development

confidential

Senior Data Modeler as a contractor

• Reverse engineering and redesign OLAP financial database from MySQL to implement into Netezza database and Hadoop platform.
• Performs Dimensional modeling of Human Resources and Money Movement
• Designed data mart for financial products dashboard. Product deepening and breath analysis dashboards for C-level
• Designed EDW and data marts for Netezza platform.
• Agile development methodology used on all projects
• Participated in RAC Requirements Acceleration Center sessions with SME, APO, and business users

confidential

Senior Data Modeler as a contractor

• The project was the complete rewrite of the retail application used by all 7-11 throughout the US with total overall redesign of Logical and Physical data models as part of total business process reengineering.
• Responsible for the logical data modeling of a large conversion database project over 1300 entities .
• Developed data architecture standards
• Data model to support sales, inventory, forecasting, purchasing, and performance management.
• Logical modeling of the existing database using SQL Database Data Modeler and Erwin
• Data Modeling integrations of several applications POS, Payroll, Inventory, hand held terminal
• Recommended business process improvements
• Recommended new logical data model to streamline operations and cut development and maintenance costs by 30 by providing data model that minimizes impact of future changes
• Communicated, coordinated, and developed collaborative working relationships with all members of the on shore and off shore development team located in India.
• Part of team of 150 IT professionals
• Presented data model changes and associated benefits to upper management
• Worked with application team on optimization of the application design and all SQL optimization.
• Generated Oracle database schema
• Created script for data migration between SQL Server and Oracle
• Performed data standardization
• Performed data cleansing
• Developed logical/physical change management process
• Developed database change management process
• All documents sharing via SharePoint
• Performed database optimization
• Dimensional Modeling of ODS and Data Marts
• Created Master Data Management initiative and data governance

confidential

Senior Data Modeler as a contractor

• Data modeling and database design of customized application project at a growing and dynamic company.
• OLTP and DW modeling
• Responsible for logical and physical data models using Erwin.
• Performed extensive data analysis to identify opportunities for gross profit improvement, increase revenue and customer satisfaction.
• Dimension modeling using star schema and snowflake schema.
• Conformed dimensions
• MDM
• Enterprise data warehouse bus matrix.
• Modeled Enterprise Data Warehouse to support business intelligence, digital dashboard, and data analysis at strategic, tactical and operational levels using Kimball methodology
• Modeled Data marts to support departmental BI
• Performed data mining using cluster analysis, anomaly detection, and association rule mining.
• Created source-to-target documents
• Designed and created ETL scripts to load data warehouse
• Designed and implemented business intelligence to support sales and operations functions to increase customer satisfaction and retention and improve overall net profit by 17 and on time performance.
• Presented data analysis findings to executive team.

confidential

Senior Data Modeler / Partner

• My main responsibility was the logical and physical data modeling of a customized Transport Management, Financial, Accounting, and CRM System database and all Business Intelligence modeling and ETL activities at a start -up company
• Logical/Physical data modeling of EDW Enterprise data warehouse using Kimball methodology.
• Logical/Physical data modeling to support all aspects of transportation, accounting, and sales support using Erwin
• Logical/Physical data modeling for integrated mobile solution to support sales, operation, customer, and management functions
• Logical/Physical modeling to support business activity monitoring and provide actionable information
• Fact and Dimension modeling
• Developed data architecture and standards

confidential

IT Manager/Senior Data modeler

• Contributed to strategic decisions regarding all aspects of the company data strategy
• Designed business intelligence and digital dashboards
• Performed data analysis and reports findings to executive and all levels of management team
• Data modeling of all projects including operational, data warehouse and business intelligence
• Performed all ETL functions.
• Mentor other junior data modelers
• Responsible for all data modeling and database design using ERwin
• Designed customer-centric transportation management system TMS database to provide strategic advantage in the market place.
• Developed and integrated data models for Web and e-commerce solutions with brick and mortar operations
• Data modeling for integration between TMS and enterprise accounting software to reduce staffing requirement by 19
• Data modeling for integration with WMS warehouse management system
• Modeled Enterprise Data Warehouse to support business intelligence, BAM Business Activity Monitoring and dashboards of support real time business analysis and reporting and compress the time to action
• Dimension modeling
• Modeled freight routing function automation to support better overall routing decisions, which contributes to better on time performance and increased gross profit while lowering staffing requirements. GP improvement from 33 to 38 and 20 reduction in staffing
• Created budget
• Performed team member performance reviews

confidential

• Recommended and managed the migration to an enterprise relational database infrastructure from a flat file environment to support sales and ordering functions.
• Evaluated and selected database management software
• Developed data implementation strategy
• Developed project development methodology in data centric environment
• Implemented data modeling/database design methodology
• Responsible for Logical data modeling.
• Responsible for physical database design
• Designed decision support database for executive sales analysis
• Managed and developed team members

confidential

• Designed and implemented a worldwide distributed database to assist the order processing, sales commissions, and customer support functions.
• Developed data modeling project plans
• Modeled data requirements for multilingual database project so support multiple countries
• Integrated multiple logical data models into a single data model
• Designed database for support worldwide application
• Implemented data-centric project methodology
• Coached and supervised other data modelers

confidential

• Designed, implemented and tuned large ORACLE databases
• Transformed logical data models into physical database designs
• Prototyped databases
• Coordinated projects with application programmers and end users
• Created database schemas
• Tuned SQL statements and transactions
• Created triggers and stored procedures

confidential

• Modeled several large projects to support the information requirements of different business areas that include human resources management, marketing, fuel inventory management, capacity planning, yield management, and sales analysis
• Scoped project to identify high level ERD data requirements
• Developed project plans
• Managed all phases of modeling projects
• Modeled high-level corporate ERDs and fully attributed data models using IDEF1X methodology through SAE subject area expert interviews and leveraging off existing models
• Normalized data models
• Model a comprehensive repository data dictionary and the data required by modeling and data management tools.
• Integrated data models
• DATA MODELING SOFTWARE: ERWin and SQL Developer Data Modeler
• DBMS: ORACLE 10G and 11G, Netezza, Exadata