Sap Analytics Solution Architect Resume
NC
SUMMARY:
- Solution Architect, Data Analytics, and Information Technology professional with 15+ years of strong technical and leadership experience.
- Customer focus and Enterprise collaborator who has lead global and regional market projects spanning Europe, Asia and North America.
- Exceptional strategist who stays top on innovations; leverage industry’s best practices; define analytics solutions, identify and document analytic use cases; delivering complex product - based solutions.
- Entrepreneur who articulate analytics solutions and devise trends, rendering complex business requirements into feasible technical solutions, architectural planning, resolving simple to complex issues.
- Expert project scoping, support licenses and services sales including demand generation while managing client and customers in fast-paced, customer-facing environment.
- Strong and motivated Project Management skills to implement and deliver projects, while collaborating with executives, managers and technical teams, using SCRUM and ASAP methodologies
- Excellent written, verbal, and interpersonal communication skills; including public speaking presentation.
- Manages regional, global and off-shore teams; works independently; also, expert in Lean Six Sigma.
- Over 10+ years of solid hands-on expertise, that also includes four Full Cycle implementations, spanning:
- SAP BusinessObjects (BOBJ 3.1, 4.x, BOC) - SAP Business Warehouse (BW 3.x, 7.x)
- SAP HANA (Agile DataMart and BWoH) - SAP BW Accelerator (BWA 7.2)
AREAS OF EXPERTISE:
- SAP Lumira, Crystal Reports, Design Studio, Web Intelligence, Universe, Analysis Office, Explorer.
- SAP BusinessObjects enterprise and SAP Analytics Cloud, BW/4HANA (embedded analytics).
- HANA in-memory (Attribute, Analytical and Calculation Views), and SQLScript.
- Strong Data Warehousing, EDW, Extended Star Schema, analytics architecture and modeling skills.
- Data replication and data cleansing using SLT; SDI/SDQ, ETL tools (BO Data Services, Informatica).
- Security setup on SAP BW and BusinessObjects, enabling Single Sign On (SSO).
- BW Live reporting on S/4HANA (embedded analytics), SAP ECC, SAP CRM, Non-SAP.
- Programming ABAP code (programs, function modules, start/end/expert routines).
- BW objects expert - InfoObjects, InfoProviders (CompositeProviders, ADSO), BEx Query Designer.
- Debugging data loads issues, data transfer, data modeling, performance tuning.
- Expert knowledge in SAP ECC, SAP CRM, Non-SAP (SQL Server, DB2, Oracle, ASW, Flat File, etc.).
- Expertise in BW migration on HANA with sidecar and DB migration approaches
- Used BICS and BIWS/QaaWS data connections for reporting on WebI and Dashboard.
- Experience with meta-chain tools (UC4); HP Quality Center, SerivceNow, Solution Manager.
- Experience working in regulated environment; writing GxP and non-GxP standard documents.
- Expert in enabling new or existing SAP BW configurations and strategy.
- Keen to learn newer technology to expand current technical and advisory knowledge.
- Expert knowledge in business process; SIFOT, DIFOT, Order to Cash (OTC), MDM.
- Knowledge of HANA Cloud platform/connector, ATTP, PharmaNet, LIMS, MicroStrategy systems.
TECHNICAL SKILLS:
- SAP HANA 1.0 (BW on HANA
- Enterprise)
- SAP ECC
- S/4Hana
- BW/4Hana
- SAP CRM
- SAP BPC
- C4A
- Digital Boardroom
- SAP BusinessObjects
- WebI
- Dashboard
- Design Studio
- Crystal Reports
- Explorer
- Lumira
- SAP Fiori
- Analysis Office
- Predictive Analysis
- SAP Big Data (SAP HANA Vora)
- Machine learning
- Data Science
- Oracle
- DB2
- MySQL
- MSSQL
- Access
- SSIS
- SSAS
- JAVA
- R
- ABAP
- PHP
- Visual Studio
- Qlikview
- SLT
- HANA Live
- SoH
- CDS Views
- Tableau
- MDG
- Big Data (Hadoop
- Hive)
- Analytics and IoT
- Information Steward
- Sybase IQ NLS
- ODATA
PROFESSIONAL EXPERIENCE:
Confidential, NC
SAP Analytics Solution Architect
Responsibilities/Deliverables:
- Architected BI solution design for a greenfield implementation.
- Defined desired business metrics, KPIs, roadmap and strategies for successful project execution.
- Conducted workshops with business, technical, and non-technical teams for implementation.
- Architected visualization models, customer stories, business KPIs and metrics.
- Defined master data management (MDM) strategies to harmonize business data for ERP and ATTP system.
- Enabled reporting architecture to develop Crystal Reports for reporting to DEA.
- Designed architecture leveraging SAP Gateway, HANA cloud connector, BOBJ Cloud agent.
- Developed “what-if” scenarios and analytics solution as demo.
- Gathered user requirements and business use cases.
- Enable architecture for SAP Gateway, HANA cloud platform, OData.
- Conducted workshop with business to define reporting KPIs and metrics.
- Enable the solution to be deployed over mobile devices.
- Provided technical guidance and best practices to internal and implementation partner’s team.
- Utilized new features for advanced analytics reporting and dashboard.
- Performed risk analysis evaluation for project impacts, usage and benefits.
- Developed project plan and scope with Functional and Business Analyst.
- Enabled reporting on Demand Planning (DP) and SN&P data.
- Developed project plan and scope by gathering user requirements.
- Build architecture and enhanced BW data models for reporting.
- Develops project plan and scope by gathering user requirements for individual products.
- Coordinate architecture and managed deliverable while working with different team members.
Confidential, MD
IT Senior Systems Analyst (SAP BI)
Responsibilities/Deliverables:
- Worked with Business Analyst and functional users to gather the requirements.
- Developed data models on COPC related data sources (0CO PC PCP *) for reporting on WebI via BICS.
- Used 2LIS 05 QE1and 2LIS 05 QE2 for loading data in BW.
- Developed data models on new general ledger (0FI GL 14) and purchasing (2LIS 02 ITM) extractors.
- Created BEx reports to develop reporting solutions on web intelligence (WebI).
Confidential, TX
Lead SAP BW and BI Analytics
Responsibilities/Deliverables:
- Worked closely with functional and technical managers and teams to gathered requirements
- Provided architectural solutions based on SAP IS-U data from SAP ECC and Oracle database.
- Enabled BOBJ reporting using WebI and Analysis Office.
- Trained and mentored the team for SAP best practices for development and architecture.
Confidential, IL
Lead SAP BW and BI Analytics
Responsibilities/Deliverables:
- Gathered user requirements and converted functional specs into technical solutions.
- Provided technical solutions to fix BW 7.3 data loading issues in BWA 7.2
- Provided architectural solutions to enable existing SAP BW 7.3 to migrate on SAP HANA.
Confidential, MN
Lead IT Developer (SAP BW/BI)
Responsibilities/Deliverables:
- Developed project implementation plan using DB migration approach.
- Optimized DSOs/Cubes and adjusted dataflow per LSA++, Start/End routines and query exit.
- Coordinated efforts required to upgrade existing BW 7.01 to BW7.3.
- Updated design flow to use Semantic Partitioning Objects (SPO) for better data loads.
- Used new data flow migration to migrate some old 3.5 data flows in 7.0.
- Provided guidance in setting up the data provisioning using BODS 4.0 and SLT.
- Build analytical dashboard using BO explorer.
- Evaluated BW growth with QuickSizer/RSDDTREX MEMORY ESTIMATE for BWA memory.
- Using various tools such as Standalone TREX version 62 for REORGs and performance tuning.
- Enhanced billing data sources 2LIS 13 VDHDR, 2LIS 13 VDHDR for header and item data.
- Developed various BEx reports and enabled Business Objects.
Confidential, MN
Computer Programmer (SAP BW)
Deliverables/Responsibilities:
- Extracted Sales and Billing data from Contract, General Ledger and Billing cube.
- Created WebI reports with filters to get dynamic report.
- Enabled BW to BO connectivity with CMC and setup end-user BI portal (InfoView).
- Designed simple and complex universes to for OLAP (BW) and non-OLAP data sources.
- Created complex WebI reports for sales/service/billing data scorecards dashboard.
- Customized Sales Data Sources (2LIS 11 VAHDR, 2LIS 11 VAITM) with custom fields.
- Extracted DP data using 2LIS 03 S194, and manufacturing order data using 2LIS 04 ARBPL.
- New EDW 3-tiered architecture was developed with SAP consultants.
- Migrated old BW 3.5 data sources to new BI 7.0.
- Utilized new BI 7.0 transformations and DTPs for all new developments.
Confidential
SAP BW Analyst
Responsibilities/Deliverables:
- Analyzed business needs and strategic information requirements to build billing reports.
- Used billing 2LIS 13 VDHDR, Item (2LIS 13 VDITM), and Conditions (2LIS 13 VDKON).
- Created/modified BEx Queries and worked on InfoSpokes to send info from BW to file system.
- Led the work to upgrade the existing BW 3.5 objects to BW 7.0.
- Translated existing custom code for communication and transfer structure to use BW 7.0 new transformation start/end routines. Created new DTP and adjusted the existing process chains.
Confidential
Analyst/Developer SAP BW
Responsibilities/Deliverables:
- Extensively interacted with user to identify and gather requirements.
- Modeled and developed BW related GL, AP, AR objects.
Senior Software Engineer
Responsibilities/Deliverables:
- Created complex SQL Queries. Optimize and tune SQL queries that were taking longer times.
- Developed user-friendly GUI for both internal (employees’) and external customers.
Confidential
Software Engineer
Responsibilities/Deliverables:
- Designed various intranet based applications using .Net and Java technologies.
- Collaborated with functional experts to scope projects, gather, analyze and define business requirements and translate them into technical specifications.
- Extensive involvement in all stages of application development life cycle including requirements, logical and physical architecture modeling, design, development, implementation, and support.