We provide IT Staff Augmentation Services!

Senior Consultant - Bi Analytics Resume

SUMMARY:

  • Industrious 10.3 years of Business Intelligence experience in Analytics space in developing and preparing BI processes and strategies.
  • Adept at analyzing project requirements and developing appropriate strategist. Committed to ensuring adherence to data standards while utilizing business resources.
  • Implementation of design and plans including scope of work, objectives, quality of deliverables and activities for BI projects.
  • Develop and maintain a product roadmap for reports and analytics, and manage a product pipeline of new reports and analytics based on business priorities
  • Communicating with senior management and BI team members to manage expectations, align directives, and identify gaps
  • Develop analysis and methodologies in response to business needs; prepare and present recommendations to senior management.
  • Developing and maintaining strong relationships and collaborate with multiple stakeholders
  • Providing technical and functional expertise in the design & development of BI solutions architecture - data warehousing and reporting.
  • Create Dashboards, KPIs and other Operational Reporting in Tableau, QlikView, through SAP Reporting Services and maintain a stable data warehousing environment.
  • Create OLTP environment that is used as a central repository which pulls data from multiple databases used by key departments of the organization to ensure a single point of reporting access.
  • Connect with Business Stakeholders to gain insight on reporting needs and translating those needs into business specific metrics and other reports.
  • Project lead on the successful launch of SAP S/4 HANA in BW environment.
  • Built a synchronized Data Warehouse and Reporting environment to support Confidential .
  • Managed full Project life cycle implementations involving design, development and testing of SAP BI/BW.
  • Performed POC on SAP Lumira 2.0, worked on Design Studio.
  • Developed multiple reports that are consumed through SAP Business objects, SAP HANA, SAP BEX, Tableau, QlikView, Lumira Reporting environment.
  • Tremendous ability to develop and maintain production databases
  • Worked on Migration of dataflow and data extraction from SAP and non-SAP data sources.
  • ETL Data modeling using power BI, SAP BW NetWeaver, SAP HANA, SAP BODS, SAP SLT related to Supply chain, Finance, Costing, Sales operational planning
  • Ability to prepare technical and functional documentation
  • Excellent communicator and ability to understand complex logic

WORK EXPERIENCE:

Confidential

Senior Consultant - BI Analytics

Responsibilities:

  • Requirement gathering: To interact with the business to understand the business logic and the importance KPI’s for report creation.
  • Extract the information from the Clarity database using the SAP BODS (data service). Using SAP BODS, different project workflow was created and the jobs were scheduled which can extract data from source on daily basis and put schema in SAP HANA studio.
  • Create different Calculative views in SAP HANA in a star schema architecture which is used to join master data tables and transaction data table.
  • Used Qlikview as Business Intelligence Reporting tool to build analytics which was used to derive the health care information of a company.
  • Work with Project Manager and manage the sprints of the Project.
  • Worked on Creation of Document on the development of Project flow.

Confidential

Business Data Analyst

Responsibilities:

  • Requirement gathering: To interact with the business to understand the business logic and the importance KPI’s for report creation.
  • Build the ETL Model which can extract the data from flat files provided by business and build it in Tableau
  • Used Business Intelligence Reporting Tool (Tableau) to create KPIs and Scorecards to improve corporate supply chain information.
  • Coordinated with business unit teams developing further enhancements of the performance management processes and tools.
  • Trained various business unit teams on the effective use of processes, tools, and resources.
  • Created effective materials, conducted one-on-one, and WebEx .

Confidential

Senior Technical Analyst

Responsibilities:

  • Requirement gathering: To interact with the business to understand the business logic and the importance KPI’s for report creation.
  • Researched, tracked and analyzed credit information for Colgate their competitors identifying market trends and growth opportunities.
  • Build the ETL Model which can extract the data from SAP and also includes scheduling delta loads.
  • Used Business Intelligence Reporting Tool (BEX, Business Object, Tableau) to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis
  • Coordinated with business unit teams developing further enhancements of the performance management processes and tools.
  • Trained various business unit teams on the effective use of processes, tools, and resources.
  • Created effective materials on Confluence, and created tickets on Jira conducted one-on-one, and WebEx .

Confidential

Senior Technical Analyst

Responsibilities:

  • Coordinated with the project management team in establishing business analytics systems that ensured timely and orderly completion of reports
  • Collaborated with power users and IT management teams to streamline business reports and identify all end users
  • Brainstormed with company’s senior management to establish new methods of increasing ETL performance.
  • Implemented real-time billing, delivery and inventory reports which streamlined key operations processes
  • Co-ordinated for SAP S/4 HANA database installation.
  • SLT system preparation, installation and setup for the replication of data from different sources (SAP, non-SAP)
  • Managing HANA disaster recovery
  • HANA system monitoring, applying HANA licenses, alerts monitoring.
  • HANA Database Monitoring/ Performance Tuning.
  • Create and delete roles and assign roles to users
  • Coordinates with different departments such as Accounting, Supply Chain Services, Security, Finance, SD and Operations
  • Data provisioning from SAP and non-SAP systems.
  • DB monitoring and performance tuning to ensure optimal system performance.
  • Continues support for S/4 HANA landscape.

Confidential

Senior Technical Analyst

Responsibilities:

  • Coordinated with business unit teams in planning strategies to improve the performance of management processes and system tools
  • Reformatted the Customer Service KPI Dashboard on the Business Intelligence system which provided the status of on time delivery KPI.
  • Compliance to account Service Level Agreements and IT Service Management processes
  • Incident Management ticket creation, dispatch and resolution
  • Takes responsibility as team/project lead and supports people development tasks
  • Has successfully handled escalation projects
  • Support for system optimization
  • Detailed planning of IT- implementation
  • Developed and implemented BI procedures
  • Enhanced the performance of supply chain reports by eliminating unnecessary BI objects etc. Provided technical support for database maintenance issues. Analyzed current database operations and recommended updates.

Confidential

Senior Technical Analyst

Responsibilities:

  • Modelling, Data Extraction, Transaction and Master data Loading, Scheduling, Monitoring, and Reporting (Bex Query designer), Delta Management, User interaction, BI validation with R/3.
  • Worked on LO cockpit. Maintaining extract structure, Activating Data Sources, Filling up Setup tables of orders and delivery.
  • Developed Info Objects, Info Cubes, Data Store Objects, Data Sources, Update Rules, Transfer Rules, Transformation, Info Packages, DTP, Process chains.
  • Also worked on developing the reports into BEX and developing the dashboard into QlikView using QVD and QVW for rolling 24 months.
  • In QlikView, I have worked on joining two or more tables and create different charts which can be used for data visualization in QlikView dashboard.

Confidential

Senior Technical Analyst

Responsibilities:

  • Worked on Inventory management application
  • Worked on Demand planning and forecast reports
  • Worked with different departments within organization like demand, supply chain, APO, Finance, Demand to resolve the issue within sla.
  • Handling day to day activities for SAP BI incidents, did analysis and provided solution through charm ticketing system.
  • Analysis and solving tickets raised by user within SLA.
  • Development of BEX reports using RKF, CKF, filters and cell definition.
  • Worked on performance improvement of process chain and bex queries.
  • Worked in virtual providers, APD
  • Broadcasting of reports
  • Writing abap code in routine

Confidential

Technical Analyst

Responsibilities:

  • Studying the standard data source 2LIS 02 VCITM and its tables and fields used in LBWE extract structure.
  • Enhancing the standard extractor by adding few fields from.
  • Scheduling R/3 job using Job control in LBWE, initializing delta in RSA7 delta queues.
  • Creating the dataflow in EDW layer and BI involving ODS and cubes, DTP.
  • Creating process chain and monitoring the load.
  • Testing the dataflow and successfully implementing it in production.

Confidential

Technical Analyst

Responsibilities:

  • Creation of info providers: Info Cube, DSO, Multiproviders and Infosets and as per the report requirement and design the transformation and data transfer process as per the business logic.
  • Creation of process chains depending upon the modeling structure and timely scheduling the same.
  • Creation of queries in Query designer. Creation of restricted and calculated key figures, structures, customer exit variables, user entry variables as per the report structure.
  • Data load process is monitored every day to check for errors and corrective action is taken as one occurs.
  • Developed report on Design Studio and also in Webi Business Objects.

Confidential

Technical Analyst

Environment: SAP BW 3.5, SAP R/3, MS Excel 2010, Macros VB Script.

Responsibilities:

  • Working with a team of ABAP programmers in order to setup extract tables in the SAP R/3 systems to fetch data from the standard tables in FI/CO, SD and to setup jobs to fill these tables. Testing their implementation in the test systems and providing confirmation for their movement to the production systems.
  • Using the Remote Call Function feature in SAP Business Explorer to call a function module that fetches a table from all the R/3 instances as an output and the code written in Macros in VB Script pastes this table output in MS Excel. This table has the number of records in the extract tables used to reconcile with the number of records coming in BW Infocubes/
  • Data modeling: Creation of info provider Info Cube, mapping these with existing Multiprovder and Info sets as per the report requirement and design the transformation and data transfer process as per the business logic.
  • Process Chain creation: Creation of process chains depending upon the modeling structure and timely scheduling the same on autosys.
  • Report Creation: Creation of queries in Query designer. Creation of restricted and calculated key figures, structures, customer exit variables, user entry variables as per the report structure.
  • Creation of Web Template: Creation of customized Web Templates with Web Application Designer.
  • Created and Monitored Transport Request for Transport of Objects from Development to Test Systems and from Test to Production Systems.
  • Completion of documentation of the new validation process and providing on the same.
  • Daily data load monitoring: Data load process is monitored every day and corrective action is taken if error occurs.

Confidential

Technical Analyst

Responsibilities:

  • Mapping all the history Infoproviders to the Multiproviders and Infosets to which the original Infoproviders were mapped.
  • Creation of update rules, communication structures and infopackages to copy all the history data to the history Infoproviders.
  • Copying all the history data from the live cubes and live ODS to their respective copy cubes and ODS.

Hire Now