SUMMARY

• Over 20+ years in Information Technology with expertise in Business Analytics, Business Intelligence, Data Warehouse, Data Modeling, Database Design and Development and Application Design.
• Extensive experience in Data Modeling using Kimball Methodologies for Conceptual, Logical, Physical, Dimensional and Star Schema Data Model
• Demonstrated expertise in Oracle Database and Teradata RDBMS Architecture and Utilities with a focus on maintaining tables, views, partitioning and performance tuning for both Oracle and Teradata.
• Gathered and translated requirements from Business Users and Business Analysts into detailed technical specification while performing thorough data integrity checking during analysis.
• Implemented BI best practice and naming standards.
• Good communicator and detail - oriented with solid analytical and problem-solving skills.

TECHNICAL SKILLS

• Data Warehouse Business Intelligence Business Analytics Dimensional & Star Schema Data Modeling
• Application Design Database Design & Development Master Data Management
• OBIEE Hyperion EPM Suite (Essbase, SQR, Interactive Reporting)
• SQL Tuning & Optimization Data Validation & Data Integrity Checking Technical Specs & Documentation
• Erwin Data Modeler R9 Informatica PowerCenter SDLC
• Oracle 11g/12g, Oracle PL/SQL Teradata RDBMS Architecture & Utilities
• Cross - functional Team Leadership

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Data Architect

Responsibilities:

• Designed facts and dimensional star schema data modeling using Erwin Data Modeler r9 in Oracle and Teradata databases for business models such as Manufacturing, Demand Plan, Supply Chain, Sales, Inventory, and Finance.
• Gathered and translated requirements from Business Users and Business Analysts into detailed technical specification that were used by ETL Informatica developers; organized regular meetings with business users and application teams to fully understand project requirements, goals, and objectives.
• Created interface requirements to different systems into and out of the Data Warehouse.
• Performed thorough data validation and data integrity checking during the analysis phase as well as during integration testing to ensure data quality.
• Established Business Intelligence (BI) best practices and naming standards while maintaining data dictionary of physical tables in Data Warehouse.
• Designed and implemented functional and role-based security access to all users in the database.
• Learned Teradata and served as data modeler to upgrade Data Warehouse from Oracle that boosted performance of BI reports in OBIEE by ~300%.
• Tasked to convert all existing objects in Oracle and maintain in new database; analyzed impact to BI reports and implemented table partitioning, primary index, join index and views; did a reverse engineer of all objects from Oracle to Teradata and maintained a detailed plan/script for each object.
• Worked with ETL developers, business analysts and DBA's and completed project on time and without additional downtime, enabling reports to run as expected.

Confidential, Whippany, NJ

Lead Application Designer/Developer

Responsibilities:

• Led various projects and met regularly with team members from development and business sides; provided guidance and work leadership to less experienced developers and new team members.
• Designed and built current Oracle database structure used by Essbase, Interactive Reporting, SQR, Web Applications, and OBIEE.
• Worked closely with consultants in the design and development of HR Analytics using OBIEE.
• Created a star schema data model using facts and dimensions used by Hyperion Executive Dashboard that displayed daily view of Delivery Efficiency, Budget Customer Analysis, Customer Gain Loss, and Vehicle Maintenance Report.
• Designed databases and processes for web applications such as Pre-buy Contracts, Check Reconciliation, Price Standardization, and CSC Scheduler for Call Center; developed backend code to support user interface using PL/SQL.
• Designed and implemented row-level and role-based security that were used across all applications. All web applications, SQR reports, and IR reports were built using this model where users could only view and/or update departments they had access to.
• Maintained Oracle database for development and test environment; this included creation of tables, indexes, constraints, maintaining referential integrity, database, and SQL performance tuning and database security using privileges and roles.
• Created a manual for PL/SQL coding standards which includes naming conventions, error handling, audit logs, table structures, and grants to objects. These standards were strictly enforced to all developers within the department.

Confidential, North Bergen, NJ

Senior Application Designer/Developer

Responsibilities:

• Served as an integral team member to conduct gap analysis before purchasing POS application for company wholesale system.
• Lead analyst and developer for the wholesale system (SEWN) which included Sales Order, Allocations, Shipments, Invoicing, Returns, and Inventory Modules.
• Contributed to continuous monitoring and improvement performance of the system.
• Led design and implementation of globalization of Invoicing and Return Modules; enhancements to these modules included invoice consolidation, VAT Tax implementation, currency conversion, language translation, and creation of Pro-forma invoices for third-party warehouse.
• Designed and developed the backend code to a web application for Returns Merchandising Authority.
• Worked closely with business community in creating requirement document and detailed functional specification for all projects under responsibility.
• Created detailed technical specifications that were implemented by junior and offshore developers.