We provide IT Staff Augmentation Services!

Senior Business Data Analyst - Dwh Resume

Auburn Hills, MI

SUMMARY:

  • An accomplished Senior Business Analyst/Data Analyst with more than 10 years of experience in Automotive and manufacturing domain.
  • Exposure in various projects spread across value chain of Manufacturing and Automotive industry starting from Product Development, Supply Chain & Logistics, Manufacturing, Sales & Marketing, Aftersales & Service.
  • Extensive Domain expertise in the business functions of Sales and Marketing, Remarketing, CRM and Supply Chain Management, Aftersales, Parts Ecommerce, Profitabiliby by VIN, Orader Management & Distribution.
  • Subject Matter Expert and hands - on experience on IT applications pertaining to Dealer Management, Scheduled Maintenance Contracts Management, Customer Relationship Management and Vehicle Incentive Management, Vehicle Recall Management, SCM, CRM
  • Exposure in dealing with CXO’s and senior management of large conglomerates.
  • Strong understanding of Business Process Management, Business Process Reengineering, Business Process Modelling, Process Mapping, Business Analysis and Data Analysis.
  • Experience in DataLake implementation with Big Data Technologies including HDFS, Spark Cloudera, Hive
  • Deep understanding of all phases of Software Development Life Cycle (SDLC) methodology (such as scoping, planning, requirement gathering, analysis, design, development, testing and deployment).
  • Extensive experience working on all the phases of Waterfall and Agile Project Implementation Methodologies.
  • Conducted workshops and Lead working sessions as well as Joint Requirement Planning (JRP) sessions with the Business Users and SME's for Customer Application Development, COTS, DataWarehouse, Data Migration, MDM, SAP Integration with Third Party Applications projects
  • Conducted End User Trainings on application usage to achieve the end objective. Trained Business Users in leveraging SAP Business Objects to create self service reports.
  • Expert in documenting business and functional requirements using different tools e.g. Jira, Visio, MS Word, Ms Excel
  • Proficient in developing and executing System Test Cases performing functional, usability and stress testing to ensure the product meets the system requirements.
  • Created assets such as Whitepaper, Point of Views (PoV), Business Process Flows, Sales Collaterals for key solutions such as Vehicle Incentives Management, Vehicle Recall Management to support client Managers help in proposing these solutions to different customers.
  • Supported Account Managers and Presales team in responding to key RFPs by providing inputs on Automotive Industry processes and key functional requirements of RFPs.

TECHNICAL SKILLS:

  • MS Office including MS Projects
  • MS Word
  • MS Excel
  • MS PowerPoint
  • MS Visio (process flows)
  • Jira (Requirements
  • User Stories
  • Defects)
  • SAP Business Objects
  • Reports Development
  • Oracle SQL
  • Tableau
  • Cloudera
  • Hive

PROFESSIONAL EXPERIENCE:

Confidential, Auburn Hills, MI

Senior Business Data Analyst - DWH

Responsibilities:

  • Responsible for Data & Reports Requirements Elicitation - Conducted workshops with business users to understand the detailed data requirements to calculate the profitability.
  • Supported Technical Architect in designing Data Lake zones such as Landing, Discovery and Published.
  • Created Complex level mappings from source to target system using HDFS
  • Supported ETL developers in creating mapping and workflows for data migration between DataLake zones.
  • Converted business requirements into detailed Data Mappings for each of the data elements as required in the reports.
  • Worked as an Data SME for all the stakeholders including Sr. Business Users and IT team.
  • Setup Data in development environment to successfully test the ETL Mappings
  • Supported QA team in understanding the business requirements and data model to successfully test the reports in QA environment.

Environment: Windows, MS Office Suite, HDFS, Cloudera, Hive, Informatica Powercenter Big Data Edition

Confidential, Auburn Hills, MI

Senior Business Data Analyst - DWH

Responsibilities:

  • Responsible for Data & Reports Requirements Elicitation - Conducted workshops with business users to understand the detailed reports requirements in Logistics, Scrap, Finance and Customer Care area
  • Supported Data Architect in designing Data Model to support various interfaces and reports.
  • Created Complex level Dashboard for Business and IT Management in SAP BO.
  • Provided insights to business users on Canned Reports published to business users
  • Converted business requirements into detailed Data Mappings for each of the data elements as required in reports.
  • Worked as an Data SME for all the stakeholders including Sr. Business Users and IT team.
  • Provided guidance to junior SAP BO Reports Developer by clarifying business reports requirements and Data Mapping to build canned reports.
  • Setup Data in development environment to successfully unit test the reports
  • Supported QA team in understanding the business requirements and data model to successfully test the reports in QA environment.

Environment: Windows, MS Office Suite, SAP BO, Informatica Powercenter, SQL

Confidential, Auburn Hills, MI

Sr. Business Analyst

Responsibilities:

  • Responsible for Requirements Elicitation/Documentation - Designed and documented detailed business requirements, functional requirements utilizing PMO & Governance approved templates.
  • Conducted Joint applications development (JAD) sessions with the participation of the users and the stakeholders to gather requirements.
  • Created Use Cases, Use Case Diagrams, Activity Diagrams, wireframes, screen mock-ups etc.
  • Created Process flow documents, including detailed requirements and writing user stories and acceptance criteria.
  • Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan.
  • Created standard test case template according to the company requirements and standards.

Environment: Windows, JAVA J2EE, MS Office Suite

Confidential, Franklin, TN

Sr. Business Analyst

Responsibilities:

  • Provided expertise in strategic incentive planning, business process modelling, business process analysis, component-based development, and quality assurance
  • Acted as a liaison between business user and Information System (IS) BA to articulate needs, issues and concerns.
  • Requirements Gathering/Documentation - Designed and documented detailed business requirements, use cases, process flow and functional requirements, system level test cases utilizing PMO & Governance approved templates.
  • Prepared wireframes and UI mock-ups to demonstrate the functional requirements. Used MS-Visio for flow-charting, process model and functional architectural design of the application.
  • Prepared Requirements traceability matrix to detect missing functionality or identify if implemented functionality is not supported by a specific requirement.
  • Dedicated a good portion of time with the QA team in front-end, back-end and Regression testing.

Environment: Windows, JAVA, J2EE, MS Access, MS Office Suite, Cloud CLM

Confidential

Business Analyst

Responsibilities:

  • Functionally lead the key modules of DMS like Pre-Sales(Lead Management), Sales, Spares, Common, Financial Accounting, Portal and CRM.
  • Gathered Business Requirement and prepared Software Requirement Specification (SRS) for the various modules of the application.
  • Worked along with design teams on various aspects of the web application to provide optimized experience to the end-users.
  • Worked with QA team for the defects tracking using Cloud CLM tool.
  • Performed System Integration Testing (SIT) and releasing the developed line items to the customer for User Acceptance Testing (UAT)
  • Facilitated the communication between client and offshore team during development lifecycle. Single point contact for the customer for the above mentioned 7 modules.
  • Facilitated UAT at the customer location and getting customer concurrence for the application correctness and getting it signed off.
  • Training the dealer users & implementing the application at the selected pilot location and getting is signed off.
  • Published a whitepaper on Next Generation Incentive Management System, Vehicle Recall Management
  • Prepared the process assets comprising of Medium and High complex process maps pertaining Sales and Marketing, Supply Chain Management.
  • Provided inputs from domain side on multiple RFPs

Confidential

Engineer - Sales & Proposals

Responsibilities:

  • Preparation of techno commercial proposals of furnaces used in hot rolling mills of steel making plants as per the client’s requirement on turnkey projects basis.
  • Negotiating with clients, both technical as well as commercial.
  • Handled entire life cycle of project acquisition. Preparation of proposal to Project handover to execution department.
  • Constant hunt for various business opportunities in steel making industry.

Hire Now