We provide IT Staff Augmentation Services!

Sr. Sap Bi/bo Analyst Resume

4.00 Rating

Houston, TX

SUMMARY:

  • Data - driven professional with a strong combination of and experience in driving business results through analytics. Known for a keen ability to draw meaningful insights from data and offer new and innovative solutions to daily challenges in fast-paced and competitive business environments. Proven ability to get consensus from a large cross-functional audience
  • Implemented 6 full life cycles using ASAP methodology
  • SAP Solution Consultant with in-depth experience in implementation; multiple full life-cycle SAP projects involving SAP BI/BW and SAP BO, Tableau
  • Over 8 years of Business and IT experience with 5 years of experience in BI/BW (7.0, 7.3), BOBJ (4.0, 4.1) tools like Designer, InfoView, BI Launch Pad, Web Intelligence, Universe Design Tool, Xcelsius
  • Worked with Xcelsius dashboards involving What If Analysis, Dynamic Visibility, narratives, interactive charts and hierarchies
  • Experienced in technical upgrade: BW upgrade to 7.3 and BO upgrade to 4.1; responsibilities included testing, system refresh and objects transport from Dev to QA and production
  • Expertise in data staging techniques, ETL and metadata tools and knowledge in System Administration, Data Extraction, Data Loading (Full /Delta Up-Load), Table storage maintenance, Security Scheduling, Monitoring and Data Modeling using BW Extended Star Schema
  • Worked extensively with BEx Query Designer/Analyzer for developing reports, analysis and web reporting and an expert in performing routine program modifications, Performance Tuning: Aggregates, Compression, Roll-Up, Indices & Statistics
  • Experienced in and supporting end-user reporting needs using SAP BW and Business Objects
  • Ability to work in groups as well as independently and initiate self-learning of new technologies and tools. Flexible in adapting to changing environments by leveraging strong analytical and interpersonal skills with the ability to handle multiple tasks simultaneously

TECHNICAL SKILLS:

Programming Languages: ABAP, Shell script, C, C++, VC++, VB, Java, ASP.NET, SAS, Assembly Languages

Development Platforms: SAP NetWeaver, Business Objects 3.1 and 4.0, BEx Analyzer, Web Application Designer, Web Intelligence, Universe Designer, Xcelsius, SAP Business Objects Analysis, Design Studio, Tableau, SAP HANA

Databases: Oracle (8i, 9i, 10g), Teradata, SQL Server 2012, MS-Access Big Data Introductory knowledge of big data tools and techniques like Hadoop, MapReduce, Pig, Hive

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. SAP BI/BO Analyst

Responsibilities:

  • Extensively worked on major customizations as the project progressed and the system was mature
  • Solely responsible for architecture of the whole data flow. Deteremined how many streams to use and what the right extractors were
  • Introductory knowledge of SAP HANA. Completed “SAP Business Warehouse powered by SAP HANA ” course offered by Open SAP
  • Successfully completed BI 4.1 upgrade. Liaised with Basis team to test the entire BOBJ suite including Webi Rich Client, Universe Designer, Design Studio and Dashboard Design
  • Worked on POC to build applications in BI 4.1 platform and SAP HANA. Created mockup of Engineering dashboard using Design Studio and validated connectivity for Lumira
  • Used Open Hub service per user requirements to transfer data from Infocubes, ODS and Info Objects to external Data Marts
  • Monitored production data loads to ensure smooth functioning of the system
  • Analyzed and modified process chains to reduce the overall runtimes of data loads
  • Worked on Tableau proof of concept; provided recommendations on how the tool can blend with the existing system landscape
  • Created visualiztions in Tableau to analyze shipping costs by plotting sales and vendor data on the map
  • Created workflows in Knime to import data from variety of sources, cleanse the data and join multiple datasets to get meaningful insights
  • Built Engineering on-time delivery webi report to analyze the performance of sales team, Engineers, Approvers and the division as a whole

Environment: SAP BW 7.3, ECC 6.0 (QM, MM, PP, PM), Basic ABAP knowledge, BEx Analyzer, Web Intelligence, Universe Designer, Dashboard Design, Design Studio, Lumira, HANA, Tableau, Knime

Confidential, Houston, TX

SAP BI/BW/BO Analyst

Responsibilities:

  • Involved in complete life cycle implementation of SAP BW including: project preparation, blue print, realization, go-live and production support using ASAP implementation methodology
  • Solely responsible for developing the whole data flow including datasource, ODS, infoset, cube & multiprovider
  • Trained end users on how to navigate theier way and run the reports
  • Participated in workshops with the power users, business analysts and team members to analyze business requirements that were missed before Go-live
  • Handled series of tests to validate BW data against ECC data
  • Worked on several customizations in BW and ECC to address gaps in critical reports
  • Created process chains to automate data load processes, maintaining BW statistics, rollup of BW aggregates
  • Performance optimization with aggregates&BI accelerator, creating secondary indexes on ODS, improved BEx query performance using query read modes and aggregates. And general load and extraction performance by load balancing ang data packet sizing
  • Conceptualized and built executive level Finance dashboard to provide executive leadership team with deep insights of P&L data in a self-serviced & timely fashion
  • Built universes on BEx queries and developed Webi reports
  • Deep understanding of integration between Business Objects and SAP BW
  • Hands-on experience in Queries, key figures (calculated and restricted), variables, exceptions, conditions, authorizations

Environment: SAP BW 7.3, ECC 6.0 (QM, MM, PP, PM), Basic ABAP knowledge, BEx Analyzer, Web Intelligence, Universe Designer, Dashboard Design, Tableau

Confidential, Houston, TX

SAP BW Analyst

Responsibilities:

  • Met with plant managers and division coordinators to identify user roles and responsibilities
  • Performed role mapping as part of change management, to create a matrix of user responsiblities and security roles. Worked extensively with the SAP security team to identify a consolidated list of security roles
  • Created pivot tables and macros in excel to identify the role mapping changes since project inception
  • Worked with Skillport (3rd party vendor) to generate user reports
  • Created a standdalone deskptop program in ASP.NET to access skillport user reports for managers and individual users
  • Worked directly with functional (process) teams to prioritize, understand, design, plan, manage and deliver reporting solutions for business
  • Had series of meetings with business users and stakeholders to understand requirements and articulate solutions
  • Part of project blueprinting; developed process maps in Nimbus to capture the QM process flow
  • Liaised with business users to define master inspection characteristics

Environment: SAP BW 7.3, ECC 6.0 (QM, MM, PP, PM), Basic ABAP knowledge, Excel, VbScript, ASP.NET

Confidential, Lubbock, TX

Applications Programming Intern

Responsibilities:

  • One of five technical analysts responsible for sustaining and enhancing a business-critical system
  • Liaised between external clients and internal technical team; translated clients’ pain points into prioritized list of limitations and defects for developers to address
  • Responded to trouble tickets and ensured resolution with 98% success in SLAs

Environment: ASP.NET, SQL Server 2005, Crystal Reports

Confidential, Overland Park, KS

Software Engineer

Responsibilities:

  • Designed and developed an ETL process to populate the central data warehouse using UNIX shell script and Oracle
  • Project Lead/Developer on a two-member team that designed, developed & maintained a business-critical web-application actively used by 20,000 users with 95% satisfaction
  • Involved actively in the key lifecycle phases - requirements analysis, system design, development, unit testing, all vendor integration support, and production support
  • Simultaneously drove internal projects and external vendor projects, coordinating across time zones, providing weekly status updates to stakeholders and producing monthly status summaries, exceeding committed specifications and meeting deadlines

Environment: UNIX shell script, Oracle (8i, 9i, 10g), Teradata, Java

We'd love your feedback!