We provide IT Staff Augmentation Services!

Sr. Integration Analyst Resume

MI

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.

Hire Now