SUMMARY:

• Seasoned IT professional with 14 Years of experience in Analysis, Design and Implementation of SAP Business Intelligence and other large enterprise projects.
• Independently executed complex projects or program deliverables and developed enterprise - wide solutions roadmaps, made proposals to align business processes and IT architecture to fit the customer’s strategy with Industry standards.
• Excellent strategic communication skills including the ability to build relationships and effectively communicate and influence across all management and organizational levels both internally and externally.
• Extensive experience in Business Analyst, SAP BODS 4.x, SQL Server, SAP BW and SAP Business Objects
• Develop solution Blueprint using business requirements such as scope, processes, alternatives, and risks.
• Analyze and distill client’s business requirements through business processes analysis, interviews, workshops, and workflow and gap analysis.
• Translate stakeholder requirements into different tangible deliverables such as functional and technical specifications, use cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Create and manage comprehensive project plans and hold regular stakeholder and steering committee meetings to keep all interested parties updated on project status and progress.
• Expert in providing product and business related expertise to support customer demos, proof of concept building, product testing and validation activities.
• Proven track record of successful implementation of all project life cycle stages from Architecture planning, requirements gathering through implementation and enhancements.
• Involved in Full Life Cycle implementation Projects, which includes GAP Analysis, Requirements Gathering, Development, Testing, Reporting, Go Live & Support .
• Excellent knowledge of Integrating Front end tools with SQL, SAP BW and SAP HANA.
• Worked on both Agile and Waterfall Methodology based projects.
• Microsoft Office and Visio expertise.
• Manage offshore teams, delegate and assign tasks and ensure quality of work.
• Involved in development and Production support projects that includes Data-Modeling, Data Extraction and Report generation.
• Strong technical, communication, time management and interpersonal skills.
• Confident, independent, leadership skills, good decision-maker.
• Certified In SAP BO 4.0 Administration as SAP Certified Application Associate - SAP Business Objects Business Intelligence platform 4.0

TECHNICAL SKILLS:

SAP ETL Tools: SAP Business Objects Data Services 4.x.

Cloud Technology: Microsoft Azure.

Databases: SQL Server 2008 and 2012, HANA, MS Access.

Enterprise Tools: SAP BW.

Business Objects: Webi Reports, Crystal Reports, Xcelcius.

ERP Packages: SAP R/3. SAP Rapid Mart.

Reporting Tools: Query Designer, BEx Analyzer and WAD.

ERP Languages: ABAP/4.

SAP Planning Tools: SAP BPC 7.5

Web Technologies: ASP.Net, Java Script, HTML, XML, CSS, Web Service, AJAX.

Languages: C, C#.Net,VB.NET, ADO.NET, VBA.

Diagram Tools: Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential, MI

Sr. Integration Analyst

Responsibilities:

• Lead Confidential Team including Offshore Team.
• Introduce and Led a Confidential Audit process project to save millions of dollars.
• Led Confidential data load integration Project to make system stable and avoid daily escalations.
• Prepared Project charter and Project estimation for the Confidential Audit project.
• Hoisting a weekly team meeting for the SAP Finance, SAP CRM and Confidential Team.
• Led financial Period close process for all the regions.
• Managed offshore deliverables and follow up with them.
• Displays a strong work ethic that effectively motivates team members to excel.
• Builds company morale and cooperation through effective group facilitation.
• Effectively communicates expectations.
• Promotes a culture of learning and understand that team members respond well
• Closely worked with the Confidential Vendor for the Product bug and performance issues.
• Worked very closely with the other teams SAP, BODS, B2Bi, Confidential Hub and Model for all the Production support issues, performance issues.
• Resolved End to End Data integration/reconciling issues (SAP, BODS, B2Bi, Confidential Hub and Model).
• Daily Confidential data load Support,
• Period Close Confidential Data loads support.
• Resolved Priority Tickets within SLA.
• Updated Confidential production support deck and statistics
• Confidential Administration.

Environment: SAP BODS, SQL Server, SAP BW, SAP ECC.

Confidential, MI

Sr. BODS Analyst

Responsibilities:

• Participate in business user meetings to gather requirements by analyzing the business processes and understanding the business challenges and needs.
• Conducting workshops with Business teams to get the KPI with their definition and calculations to derive them.
• Aligning and Validating mapping documents, mapping field, field description & logics from business users.
• Let a development team and worked with them.
• Building Interfaces from SQL for third party systems using SAP BODS.
• Use of script to define the variables used throughout the project, also to execute stored procedure.
• Developing the stored procedure within SQL Database and calling them using BODS script, such stored procedure were:
• Development of Master data job to load Master data from SAP ECC and SAP BW tables into SQL tables
• Development of Transaction Job to extract data from SAP ECC transaction tables into SQL
• Building logic for the archiving of data into history tables
• Extensive use of Data integrator and Platform transforms such as Key Generation, Table Comparison, Case, Merge, Validation, SQL, Query for transformation.
• Use of Try -Catch and while - loop transforms during splitting records in multiple files.
• Use of conditional clauses such as Where, Group By, Order By while restricting records.
• Extensive use of functions such as Aggregate, Conversion, Date, Miscellaneous, String, System and Validation function throughout the transformation.
• Provide the data extract to the business users for validation for the UAT 1.
• Based on UAT feedback from business users, fixing the defects.
• Preparing final load file to be loaded into business environment after UAT 2..
• With the final sign - off on data quality statistics from the business leads make the program ready for the Go-Live preparation.

Environment: SAP BODS, SQL Server, SAP BW, SAP ECC.

Confidential, MI

Business Analyst / BW Analyst

Responsibilities:

• Engaged client to gather software requirements/business rules, and ensure alignment with development teams.
• Developed business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyzed client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Translate stakeholder requirements into different tangible deliverables such as functional specifications, use cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Implemented a comprehensive management plan for each project and hold regular stakeholder meetings to keep all interested parties updated in project progress
• Conducting workshops with Business teams to get the KPI with their definition and calculations to derive them.
• Drafted and maintained the BRD (Business Requirement Document) and translated requirements to functional and technical specifications.
• Developed comprehensive E2E test cases at the application and multi-application levels
• Conducted 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Identified and reconciled errors in client data to ensure accurate business requirements.
• Facilitate monthly meetings with clients to document requirements and explore potential solutions.

Environment: MS Office, MS Visio, SAP BW, SAP ECC, SAP BO Data Services, SQL, .Net C#, Tableau.

Confidential, TX

BI Analyst / Onsite Lead

Responsibilities:

• Led the BES project and Providing high quality production support and enhancement as per the SLA.
• Managing offshore team, assigning Task and getting quality work from them.
• Responsible for administration and maintenance of Business Objects Enterprise environments including production support.
• Participates in the design, development, testing, implementation and documentation of the solution
• Assists in estimating tasks and the preparation of project plans.
• Recommends methods for improved work processes, detailing the process’s strengths and answering clients’ questions to gain group consensus
• Responsible for Tickets management system and Resolving Business Tickets with in the SLA
• Engages with team of external partners and internal analyst for overall solution delivery
• Fixing all the BODS Data load issue with in SLA
• Worked with security team for BOBJ user security issues
• Created complex SQL queries to update production data as per the business requirement.
• Develops business functional test cases at each stage of the SDLC
• Engages with team of external partners and internal analyst for overall solution delivery
• Mentors/Trains offshore team and business user on BI tools.

Environment: SAP Business Objects, SAP BO Data Services, SQL, SAP Rapid Mart, SAP ABAP, SAP ECC

Confidential, IL

BI / BOBJ Analyst

Responsibilities:

• Involved in business user meetings to gather requirements for the development.
• Developed Sales Audit Webi report to compare sales data on all four data source (SQL, ECC and BW).
• Created Universe on ECC function by using Information design tool.
• Created Universe on RM data base (SQL) by using Universe design tool.
• Created Inventory Master Daily and Inventory Master Weekly Analysis for OLAP report
• Worked on the BI server performance issues
• Developed dashboard for Store Operation sales dashboard.
• Worked on BOBJ Production support issues.

Environment: SAP BO 4.1, Webi, BI Launchpad, SQL Server, SAP ECC.