We provide IT Staff Augmentation Services!

Sr. Business Analytics Consultant Resume

CaliforniA

SUMMARY

  • 8 years in ERP Application Development, business analysis and Implementation
  • 18 years in Data Warehouse business development, business analysis, technical data analysis, data model, architecture and implementation

TECHNICAL SKILLS

Applications: Sales Order & Distribution, Shipments, Product & Pricing, Financials, Logistics (Purchasing & Inventory), Manufacturing, Supply Chain, Install Base and Warranty Management, Liquidity and Asset Management

Languages: Microsoft Transact SQL, PL - SQL

DBMS: Microsoft SQL Server, SYBASE, ORACLE and Teradata

OLAP Software: Computer Associate’s DecisionSuite, Business Objects (6.5, XI R2 and XI R3), Business Objects Data Services XI, Informatica PowerCenter, Hyperion Business Intelligence, Microsoft SSIS and OLAP, Oracle’s OBIEE

PROFESSIONAL EXPERIENCE

Confidential, California

Sr. Business Analytics Consultant

Responsibilities:

  • Validated the business requirements and analysis documents for developing analytical applications (Corporate Finanace, Asset and Liquidity Management including Investments and CARD) in order to complete the functional scope for data quality and governance procedures
  • Evaluated and defined the business scope for addressing the reporting requirements and worked with technology team to recommend a set of suitable platforms/tools needed for implementation
  • Identified the scope of these above mentioned project initiatives and addressed the gaps for data source acquisition and availability as well
  • Prepared the functional scope and developed a business architecture plan

Confidential, California

Business Data Architect-Consultant

Responsibilities:

  • Prepared and reviewed the business requirements for developing a business framework to address the needs and product features for analytical applications such as product, customer and vendor performance domains
  • Evaluated the reporting requirements and recommended a set of suitable platforms/tools
  • Identified the scope of these above mentioned applications including data source availability
  • Reviewed an execution plan with appropriate teams to complete the business planning and strategy activities.

Confidential, Dublin, California

Business Data Architect-Consultant

Responsibilities:

  • Translated the business requirements into conceptual, logical, and physical data models for the financial management applications and worked with DBA(s) to execute the physical data model tasks
  • Reviewed data model change requests (DMR) for the existing Confidential ’s investment and tax applications, modified the data models for both logical/physical and eventually implemented the physical database changes in various environments such as Development, QA, and Staging
  • Converted both logical and physical data models from Power Designer 15.1 to 16; Synchronized and/or reverse engineered all the existing physical data models (total count is 26) with production environment and organized it appropriately in the data model repository of Power Designer 16.
  • Name of the software applications and tools used for these project(s)
  • Databases: Oracle 10g, Oracle 11g, Microsoft SQL Server; Design Tools: Sybase Power Designer 15.1 and 16

Confidential, Sunnyvale, California

Senior Enterprise Data Architect

Responsibilities:

  • Participated in gathering business requirements and performed data analysis for various data subjects such as Order Management/Inventory/Install Base applications
  • Translated these business requirements into conceptual, logical, and physical data models
  • Guided the technical team for implementing the data warehouse architecture
  • Supervised the data solutions team to design and execute both logical and physical data model tasks
  • Co-ordinated the data conversion track and user acceptance testing for the final validation of these DW applications.
  • Name of the software applications and tools used for these project(s): For the above-mentioned data warehouse applications, the source data was extracted from the following ERP
  • Applications: Oracle EBS R12 - Sales Orders, Shipments, and Inventory; SAP CRM application

Confidential, Emeryville, California

Senior Data Warehouse Architect

Responsibilities:

  • Primarily introduced the EDW architecture/framework at Confidential 
  • Estimated the hardware capacity and storage
  • Evaluated and recommended the suitable products
  • Identified the scope of EDW applications and data source availability
  • Prepared the EDW project scope and developed a technical architecture plan
  • Participated in gathering business requirements and performed data analysis for various data subjects such as Order Management/Inventory/Shipping/Work Order applications
  • Translated these business requirements into ODS (Operational Data Store) and Star Schema data models and provided technical guidelines to the DW technical team for implementing the data warehouse architecture
  • Executed both logical and physical data model preparation tasks
  • Name of the software applications and tools used for these project(s)
  • For the above-mentioned data warehouse applications, the source data was extracted from the following ERP

Confidential, San Jose, California

Senior Business Data Architect-Consultant

Responsibilities:

  • Validated the business requirements and analysis documents for various data subjects such as Engineering/Manufacturing tracks/applications
  • Translated these business requirements into ODS, Star Schema and Teradata (3NF) data models and provided technical guidelines to the DW technical team for implementing the data warehouse/data mart soluton
  • Worked closely with an ETL designer/team while designing, migrating, and preparing the technical implementation documents for ETL (Extract, Transform & Load) architecture using Informatica PowerCenter
  • Name of the software applications and tools used for these project(s)
  • Following software was used for implementing the above-mentioned project(s): Windows XP, Oracle 9i, Oracle 10g, Teradata and Informatica Power Center v7.1.2 & v81.1

Confidential, Sunnyvale, California

Business Data Architect-Consultant

Responsibilities:

  • Validated the business requirements and analysis documents for various data subjects such as Sales Orders, Shipment, Fulfillment, Licensing, Contract Data Management, Manufacturing, Products and Pricing and the consolidated Renewals, File Connect/Software download tracking application, Global Sales Online, Global Contact Database and Marketing applications;
  • Translated these business requirements into ODS & Star Schema data model and provided technical guidelines to the DW technical team for implementing the data warehouse/data mart architecture
  • Executed both logical and physical data model preparation tasks
  • Name of the software applications and tools used for these project(s): For the above-mentioned data warehouse applications, the source data was extracted from the following ERP applications: Oracle ERP 11i - Sales Orders and Shipments, Fulfillment, Licensing, Contract Data Management, File Connect/Software download tracking application, Global Sales Online, Global Contact Database and Marketing applications.
  • The following software was used for implementing the above-mentioned project(s): Windows XP, Oracle 9i, Business Objects 6.5, Business Objects XI and All Fusion ERWin Data Modeler 4.1.4

Confidential, Cupertino, California

Senior Data Analyst-Consultant

Responsibilities:

  • Effectively facilitated the business requirements analysis for Supply Chain, Sales & Product Data Management and Warranty applications, provided functional specifications including data warehouse/data mart architecture design specifications for both logical and physical data model and designing and technical implementation of ETL (Extract, Transform & Load) architecture using Informatica Powercenter.
  • For the above-mentioned data warehouse applications, the source data was extracted from the following ERP applications: SAP APO (Supply Chain) System, Sales Orders and Shipments System, Oracle Financials, and Forecast and planning system.
  • The following software was used for implementing the above-mentioned projects: Oracle, Microsoft SQL Server, Microsoft OLAP Services, Business Objects, Hyperion Business Intelligence (Brio), Hyperion Essbase, Hyperion Analyzer and ER-Win.

Hire Now