Hana Solution Architect Resume
4.00/5 (Submit Your Rating)
SUMMARY:
- 14 years IT experience with 10 years as SAP HANA/BO/BI Architect/Modeler
- Implemented 9 full - life cycles using ASAP methodology
- Experienced Business Objects 4.1 Architect and Developer
- HANA modeling for Data Provisioning, HANA Architecting, HANA Live, BWonHANA, BW4HANA & S4 HANA
- Extensive knowledge of Business Objects Suite and BO Analysis for Office and report development and analysis.
- Experience in BPC (Business Consolidation and Planning)
- Thorough experience in system analysis and design methodologies using QA analytical procedures
- Strong problem solving and analytical skills in the evaluation of complex BW on Hana technical and functional problems. Strong communication skills and a demonstrated ability to work as a team player in dynamic environments
- Extensive familiarity with migrations system installations and system copying
- Clear understanding of the SAP NetWeaver Basis experience and how to utilize it to client advantage
- Skilled with safety measures record maintenance etc.
- Good communications skills for interacting with coworkers and clients
- Unsurpassed support in SAP development
TECHNICAL SKILLS:
- BI, BO & HANA Suite
- SAP Native HANA, SAP HANA Cloud Platform Analytics, SAP BusinessObjects 4.1 / Cloud, Webi, Dashboards 4, Crystal Reports Enterpise., Lumira, Tableau, BO Design Studio, BW 7.5, SAP SLT, HANA Predictive Analytics Engine, HANA Live, Native HANA, HANA Enterprise, SAP HANA Architecture, CDS, BODS, SDA, SQL Script Procedures, BW, ECC EH7, SAP NetWeaver Basis, Oracle 11i, Confidential Analyzer, Confidential Query Designer, Office of Analysis, BPC, HPQC/ALM, Project Portfolio Management, Fiori and Solution Manager. HANA Sizing (Scale Out and Scale up approach), PMP, A+, N+, CCNP, Solution Manager, CTS Plus
- HANA, SAP ECC, Oracle, Infor, Teradata and SQL Server Gen X Database.
- MM, FTS, RTR, EWM, SD, PP, SCM/APO, TM, SRM, BW, WM, HR, FICO, EHS & CRM
PROFESSIONAL EXPERIENCE:
Confidential
HANA SOLUTION ARCHITECT
Responsibilities:
- Meeting with key stake holders and a one week workshop on a BW4HANA POC
Confidential
HANA/ Confidential SOLUTION ARCHITECT
Responsibilities:
- Review the Blueprint and refer whenever required in case of FS clarifications
- I lead the Business requirement gathering and review the Functional specifications
- I ensured the quality and consistency of design deliverables
- I was responsible for the high level technical solution design
- I was responsible in documenting the test scenarios for each solution
- I guided and reviewed the test cases for UAT and Integration test cases prepared
- I review the Transport Objects list or Sequence
- I designing, building, testing and deploying Integration Flows via SAP BW on HANA, Native HANA, Confidential Suite and BODS.
- I determine solutions and make logical recommendations
- I expressed difficult and complex concepts clearly and concisely both orally and in writing
- I Initiate system analysis, lead the definition of user requirements and assesses impacts.
- I determine alternate solutions with risk analysis and identify opportunities to use technology to improve availability and advance business initiatives.
- I coordinate development activities, evaluate and report performance of project
- I provide technical analysis and solutions to issues and technical direction.
- I utilize technical expertise to manage multiple assignments, including large and critical projects to assure timely and cost-effect objectives delivery
- I assign the objects to individual developers based on the object distribution planning with the help of Project Lead
- I communicated the overall solution with the client in the relevant technology. Monitor the progress of objects status at each phase and update Project Lead on daily basis
- Lead Offshore team and keep them updated with the deployment milestones/ deadlines in advance
- I took ownership on the quality of the solution by assuring zero defect tolerance
- I presented risk and impact analysis on BW on HANA, Native HANA, Confidential and business planning and consolidation.
- I deploying business intelligence (BI) on SAP HANA, leveraging it both as a data source and as a platform.
- I designed and executed Confidential (suite) and HANA related reports/views in Studio, IDT and 4.1. Troubleshooting issues as they arise
- Created customized Views (Private Views, Reuse Views, and Query Views) via BWonHANA
- Used HANA Time Table to resolve many issues with data coming from BW as empty values
- Performance tuning of Confidential reports and dashboards along with HANA Views
- Hands on experience with HANA landscape using functionalities like data provisioning, Modelling and Administration, and Information Composer.
- Well versed with replication methods like SAP Landscape transformation, System administration, NetWeaver Basis and Business Objects suite and Data services.
- Completed various SAP courses and participate on various HANA open houses and webinars to keep unto date on technology.
- Comprehensive modelling experience in creating various views like Attribute, Analytic and Calculation views.
- I have hands-on experience using SQL scripts to execute and analyse queries in HANA working functionalities.
Confidential
HANA/ Confidential ARCHITECT
Responsibilities:
- Lead blueprint and design sessions, review options, assess potential impact and provide recommendations while communicating estimated effort, benefits, risks, and constraints to the business stakeholders.
- Worked closely with the business users and IT to successfully architect, design, model, implement, integrate, test and maintain BI/ Confidential and related applications.
- Lead the design, development, and maintenance of ongoing metrics, reports, analysis and dashboards, identifying KPIs to drive key business decisions
- Propose and implement BI security models that follow industry best practices.
- Work closely with the executive team to establish the vision and goals in the BI area and to present, discuss and support proposed projects to implement.
- Lead and was responsible for the success of the 6 MAJOR Releases BI/ Confidential Solution and Implementation for N and N+1 environment.
- Leverage the use of HPQC throughout UAT and SIT cycles
- Successfully provided training to team members/users/ client’s solution designers on new tools of Confidential reporting and analysis
- Expertise in BOPBJ-HANA trouble shooting using SQL queries
- Used HANA Time Table to resolve many issues with data coming from BW as empty values
- Performance tuning of Confidential reports and dashboards along with HANA Views
- Usage of Smart measures (delegated Sums) in IDT for various requirements
- Installation of the SAP Confidential tools sets
- I created interactive maps by leveraging the automatic tools in tableau and its built-in postal codes.
- I created a compelling narrative that empowers for the client for analyses interactive visualizations with fresh data.
- Due to our use of huge volume data sets in HANA, I used tableau to extract massive data for exploration in seconds.
- Used Version Management to back up the versions of reports/universes/connections during development
- Trained other team members on the use of FFID and PPMs
- Developed Functional and Technical specifications, developed WebI reports in Business Objects 4.0 against SAP 7.4 Confidential queries, used in scheduling and as Dashboard KPI reports through SAP portal.
- Presented risk and impact analysis on BW on HANA
- Deploying business intelligence (BI) on SAP HANA, leveraging it both as a data source and as a platform.
- Experienced BusinessObjects BI 4.1’s optimization on SAP HANA
Confidential
BO/BW Architect
Responsibilities:
- Worked in collaboration with the team to model out the design for the implementation. Working with already developed functional specs and translating it into technical specs for the modeling.
- Based on both functional and technical specs I installed Business Contents for the design model and cloned them into the Z Objects according to the documented naming conventions.
- Built different objects as related to the project needs from Cubes, DSO’s Technical and Business Master Data to Multi Providers.
- Designed Confidential Queries and using it as the Datasource for multiple Confidential Webi reports.
- Commencement of required reports and assigning responsibilities for the same.
- Worked in collaborative manner with HCL Functional Team to obtain Unit Test Signoff for Confidential Reports and final sign off’s from the client.
- Mentor rest of the team members on BO technical aspects (time allowing) as needed
- Liaising with client network Admin and reporting team to ensure Service packs level and patches have been correctly installed.
Confidential
HANA Developer
Responsibilities:
- Worked with SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
- Worked with Data Extraction Transfer Loading (ETL) using SAP Confidential Data Services 4.0
- Worked with SAP ECC table data model and analysis
- Worked with SAP HANA data modeling using Attribute View, Analytic View, and Calculation View,
- Worked with SAP HANA Administration including managing schemas, data model objects, import/export content
- Worked with SAP HANA Security including User Management, Roles, and Privileges
Confidential
Confidential Architect
Responsibilities:
- Most recent experience Includes experience with Design and Installation of Business Objects Enterprise and resolving multiple issues with Confidential CMC and CMS server. I worked with Basis Confidential Admin in reinstallation of server and the application of Service pack with new update and patches.
- Worked extensively in developing and implementing Crystal report development on top of SAP Confidential queries and created over multiple Confidential queries. These reports include GAAP and STAT reports.
- Extensively worked with Business Users on integration testing the Monthly/Quarterly Reports and resolving the errors/issues and getting them fixed on tight deadlines.
- Developing and transport BW objects (Info Objects, DSO, and Cubes) in DEV, and Transporting to QA and PROD.
- Regularly synchronized reports between the three environments DEV, QA and PROD
- Ensuring and monitoring and scheduling process chains to automate the initialization and delta updating of all data from ECC into BW and making them available for reporting
- Post Production support of BW implementation and numerous functional reports
- BW error fixing due to Trial balance report not reconciling between BW and ECC
Confidential, Miami, FL
BI/BO Techno/Functional Team Lead
Responsibilities:
- Translated Functional Specifications into Technical Specifications and performed full life cycle implementation of SAP BW using ASAP methodology
- Extensively used prominent functionalities of BI 7.0 - DTP, Transformations, and DSO
- Successfully installed and activated the appropriate business content for FI/CO and SD
- Leveraged query designer in handling various reporting requirements
- Responsible for testing extractors, data loads and reports before transport into production
- Effectively monitored the Data Transfer from Source Systems into BW using the PSA
- Enhanced extract structures with the user/function exits in CMOD
- Performed Delta Management processes
- Created and maintained process chains for automation of data loads - transaction data, master data, and currency exchange rate tables
- Designed and developed several Custom Cubes, DSO, Infosets and Multiproviders. Performed enhancements on Accounts Receivables (AR) cube 0FIAR CO2
- Modeled Data targets to suit the reporting requirements presented
- Optimized system performance by leveraging Transfer Structures, Communication Structures, Update Rules and Start Routines
- Developed various analysis reports (such as Customer Sales Trend, Days overdue, Current Period, Incoming Orders and Product Profitability in SD, Actual Contribution margin in Sales)
- Worked with translation keys to do Currency conversions
- BW to External Systems using the SAP Open Hub service
- Provided comprehensive end user training and knowledge transfer to permanent staff
Confidential, Miami, FL
BI Consultant
Responsibilities:
- Gathered business requirements to define technical requirement for Business Blue Print
- Compiled BI blueprint documentation to define future state for the BI system
- Facilitated workshops to present to functional and technical team with new SAP BI functionality
- Defined required DSO/ODS Objects, InfoCubes, and InfoObjects for blueprinting documentation
- Installed Business Content for Standard InfoObjects, InfoSources, InfoCubes related to Sales & Distribution, Material Management and Finance
- Used the Business Content Sales Overview InfoCube 0SD CO3, for overall Sales Analysis
- Analyzed business operations pertaining to the configuration, development and implementation of HR system
- Absences and attendances valuation processes review and mapping, design and customizing
- Worked on 0HR PA CM 1 and 2 and 8 activating Datasource and replicating in BW, load into the target cube and executing a report
- Worked on several MM InfoProviders 0CAT CO1, 0CAT CO3, 0CAT O02, 0CAT O01
- Developed Routines in Update and Transfer Rules for key figures of InfoCube Purchase Data (0CAT CO1) to analyze Materials, Material groups and Vendors
- Created a variety of reports (Cash, Balance Sheet, P&L,Gross Margin, Open and Back Orders, Overdue, Daily and Monthly Sales Reports, Payment History) using structures, formulas and cell definitions
- Developed reports for Inventory management, Invoice verification, Purchasing and other submodules of Material Management
Confidential, Miami, FL
BW Consultant
Responsibilities:
- Fresh SAP implementation with ECC 6, CRM 2007 and BI 7 including new dimension products; third party Point of Sale (POS) system was integrated with ECC 6.0 and BI 7 for reporting and analysis
- Designed BI data architecture for CRM and ECC integration
- Built several queries (internal earning statements, external earning statements, balanced sheet, profit and loss) based on new FIGL Datasources
- Designed and recommended BI architecture and integration with SAP and non-SAP systems
- Migrated data from BW 3.5 to BI 7.0
- Provided support and made recommendations for issues affecting BI system performance
Confidential
SAP BW Developer
Responsibilities:
- Performed unit testing for all objects in Sandbox and development system
- Activated several datasources in RSA5 and checked extractors in RSA6 and RSA3
- Built and customized Info Objects, InfoCubes, ODSs, Infosets and MultiProviders based on the functional specifications
- Created Infopackages in the Development system and performed new InfoObjects data load tests
- Identified and Documented faulty extractors and short dumps in the system
- Installed Business Content for Standard InfoObjects, InfoSources, Info Cubes associated with Finance, Sales & Distribution and Material Management
- Monitored data extraction and created queries according to requirement of client
- Frequently checked PSA for errors associated with invalid characters in data
- Added functionality to Transactional DataSources through Enhancements
- Created Queries by defining rows, columns and free characteristics and provided drill down functionality for user reports
- Configured Confidential Queries for Free Characteristics, Key Figures (Calculated and Restricted), Filters, Variables and Exceptions
- Generated reports with Confidential Analyzer and embedded them into Workbooks
- Thoroughly worked with cell definitions, formulas and structures to generate reports such as Daily Sales, Monthly Sales, Gross Margin, Balance Sheet, P&L, Cash, Open Orders, Back Orders, Payment History, Overdue etc. using structures, formulas and Cell definitions
- Took relevant screen shots and properly documented all requirements for unit testing
- Liaised with SAP Basis Team for several BW Transport requests
- Worked extensively on Administrative Workbench, creating customized Info objects, Info sources, Data sources, Info Packages, Update Rules, Transfer Rules, ODS, Info Cubes, MultiCubes and Info Sets
- Prepared detail design, code review, resolved technical and design issues and tested units independently
- Identified project risks and came up with solution strategies
- Built queries requiring the use of BW Reporting Variables, Navigational attributes, filters, Calculated and Restricted Key Figures, Structures, Exceptions and Conditions, RRIs
- Generated reports using Confidential Analyzer
