Sap Hana Architect Resume
SUMMARY:
- Over 18 years of IT experience in consulting in large corporations and management consulting firms.
- I have 7 years SAP Project Management experience in FICO area.
- Over 12 years’ experience on SAP R/3 4.6/ 4.7, NetWeaver, BW and SEM BCS/BPS, BPC outlooksoft ver. 5.1 and 7.0, 7.5, EPM 10 and HANA
- Experienced in developing data models in HANA 1.0 SP5/6/7 and data provisioning using SAP BO Data Services.
- Expertise in implementing Disclosure Management, Notes Management and Profitability and Cost Management of SAP EPM solutions.
- Experienced in 8 full life cycle implementations in SAP BI/BPC and 5 end to end SAP FICO implementation.
- Excellent experience in implementing and configuring FI/CO and integrating with SD/MM and Workflow, as a SAP Solutions Architect and Project Manager.
- Lead Consultant and Configurator in FI which includes GL/AP/AR/AA in CO Confidential, PCA, COPA and CO - PC as well as configuration of FSCM in Credit Management, Collection Management and Dispute Management.
- Industry specific SAP experience around Master Data/Unicode Conversions, ECC 6.0 Upgrade/Cutover Planning SAP BPS/BCS/BPC/SSM (Planning, Budgeting, Forecasting, Reporting/Analysis, Consolidations), Travel and Expense Management, Finance, Material Master (MM), Customer Master, Vendor Master, SAP Migration/Cutover Planning
- Lead Consultant in configuration of Project Systems (PS) and Internal Orders (IO) integrating with Asset Accounting (AA) for capex and opex reporting.
- Experience managing technical and functional resources. Expert on SDLC processes and procedures.
- An organized professional with excellent communication and interpersonal skills.
- Implementation and Upgrade experience from 3.1H/4.5B/4.6C to ECC5 and ECC6.
- Hands on experience in implementing the New GL (Leading and non Leading Ledgers) as well as data migration from classic GL to New GL.
- Experience working on legacy system like AS400/RPG(Cobol)/DB2/OS390
- Excellent Knowledge on SAP BPC HANA (ver10.1) and Simple Finance with integrated business planning powered by SAP HANA.
- Around 8+ years of experience mainly focused in design, development and implementation of SAP BI Net weaver 7.0/ BW (3.5, 3.1C), SAP ECC 6.0 & R/3 (4.7, 4.6C), SAP BO XI 3.X,SAP BO 4.0 and SAP HANA Modeler.
- Implemented 3 full life cycle implementations for different modules in SAP BI/BW which involves Development, Testing, Documentation, Requirement analysis, End user documentation, and Data extraction, Data modeling, Data loading, Reporting and Production Support. Involved in building reports using SAP BO 4.0 and integrating BO with BI and HANA.
- Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe, Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards).
- Experience working on EPM tools like Hyperion Essbase, TM1/Cognos, Anaplan knowledge in industry leading BI practices, tools, and standards;
- Strong knowledge of data warehousing, data architecture and BI principles, practices and methodologies;
- Practical development experience with a variety Business Intelligence front end reporting and analysis tools is essential like SAP Business Objects, SAP BW, SAS Visual Analytics, Tableau, Cognos, etc.
- Developed reports on the MultiProviders, InfoProviders and InfoCubes using Restricted key Figures, Calculated Key Figures, Structures, Characteristic Variables, Text variables, Formula Variables, Cell Editors, Exceptions, conditions, RRI, Jump queries etc.
- Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
- Developed data flows and work flows using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation.
- Extracted the data from ECC 6.0 and loaded into BW 7.3/7.4 using Data Services XI 3.2 SP1 as an ETL tool for Data Quality.
- Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
- Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
- Experienced in loading data from tables in HANA Database to BW data marts.
EXPERIENCE:
Confidential
SAP HANA Architect
Responsibilities:
- Implemented two projects on SAP HANA .
- Involved in business and Architecture discussions.
- Worked closely with SAP Technical team on implementing the First Customer's project on HANA.
- Involved in installation of SAP HANA 1.0.17 in two environments.
- Involved in installation and configuration of SAP Business Objects Data Services 4.0 .
- Used SAP BW/SAP CRM/Oracle as source and HANA as target with SAP Data Services as the Integrator.
- Developed Jobs in SAP Business Objects Data services which do the ETL between BW/CRM/Oracle and HANA.
- Worked closely with WEBI, BI Explorer and Lumira Reporting.
- Created Attribute, Analytical and Calculated views as per the requirement needs.
- Created procedures in HANA Database and extensively worked on Native HANA, SLT and HANA Studio
- Involved in Support and Monitoring activities after go-live.
- Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA.
Confidential
Sr. Consultant
Responsibilities:
- Conducting the meetings with the Managers and stakeholders in drafting the Blueprint document. Conduct workshop and Blueprinting on the information gathered.
- Documented the project Plan and the deliverables of the to-be system.
- Was instrumental in drafting the projects budget proposal and estimates in terms of efforts in customizing of the requirements.
- Planned the headcount and man hours involved in the project.
- Knowledge transfer of Hyperion reporting for Management and Legal Consolidation.
- Assist the team in performing fit-gap analysis on Hyperion process and BPC process
- Do a fit-gap analysis of Confidential chart of accounts for operational and consolidation chart of accounts.
- Analyze the Confidential and Confidential hierarchies and create additional hierarchies to load the GLPCT data in BPC.
- Perform necessary configuration setting to setup partner function for customer and vendor master (AP,AR,FI)
- Developed various reports using Confidential functions and input schedules for planning and Budgeting application.
- Train the team members and user on the application.
- Do analysis on the historical data migration.
Confidential, LA
FICO Team Lead
Responsibilities:
- Organizing workshops for various teams understanding the business process for Embarq and Confidential . This also involved the blueprinting for scenario based migration for merging the ledgers.
- Strategically managed data across the enterprise and ensured a high level of data quality and availability.
- Managed and developed overall Cutover Plan/Strategy for SAP Archiving needed for the project.
- Done initial estimation of effort and project plan bring Embarq legacy data to Confidential ’s SAP ECC50.
- Managed overall integrations of Confidential objects as part of the migration.
Confidential, MA
FICO Project Manager
Responsibilities:
- I was involved in initial discussions and selling of the SAP project and being the Team Lead for the migration of Classic GL to New GL.
- Involved in the initial documenting phase of as-is and to-be the new ECC60 system.
- Successfully implemented ASAP methodology managing a team of over 20 consultants.
- Created/validated the Business Process for the client and configured changes and testing it.
- Initiated and guided team in doing fit-gap analysis from 3.1h to ECC60 to technical and functional team.
- Reviewed technical specs and verified the ABAP program as to where all the changes needed to be done.
- As part of New GL implementation configured segment reporting and document splitting.
- Leading the BPP with sessions and walkthrough for the migration of classic to New GL.
- Analyzing the classic GL and the use of various ledgers and how they can migrate to New GL
- Migrated 3 ledgers from classic to New GL there by reducing the reconciliation and month-end process.
- Involved in Migration of data from 200+ company codes in Classic GL to New GL through different phases of migration cockpit.
- Involved in phased migration of open items and non open items based accounts as well as balance carry forward.
- Instrumental in reducing the number of reports from 1000+ that were running for all 3 ledgers to 200+ the number in New GL
- Analyzed the volume of open items prior to migration (approx. 2m plus) and advised to reduce to considerable number.
- Liaised with the finance department to get the data validation in number for iterations.
- Configured parallel ledger concept for the purpose of maintaining different ledgers for GAAP/IFRS, Tax.
- Worked with the client in preparing and loading GL and AP Master Data when the system is migrated from classic GL to NEW GL.
- Worked closely with Technical team on Conversion and Interface programs. Developed functional specifications for new interfaces and conversions.
- Design, configure, test and deploy New GL functionality including full document splitting with zero-balancing by profit center and of CO-FI real-time integration.
- Maintained migration Issue Log and periodic meetings with team members and client on resolutions.
Confidential, WY
FICO Team Lead
Responsibilities:
- Involved in verifying the client’s existing business process and building the blueprint phase with consultant team for implementing GL, AP, AR, FA, SD and MM.
- Managed a team of over 12 consultants from FI, CO and BW team in US and Australia.
- Managed and got approval from client for deliverable plan to implement the solution.
- Created client/company specific Config changes and completed UAT and integration testing scripts and documents.
- Also verified the technical specs for ABAP program for migration of legacy data. Instrumental in CO-PA configuration, which included building, the operating concern, developing value fields and characteristics, configuring summarization levels for reporting and assessments, cost center assessments to segments, CO-PA reporting, PA settlement, and integration issues with Sales and Distribution.
- Helped the client in identifying tasks and works for Design & configure of PS module for capital investment functionality including WBS elements, commitments/purchasing, planning, budgeting, integration with AA and IM modules.
- Documenting process design, application configuration, test plans. Leading the team responsible for technical data conversion and interface analysis, design and development at a client engagement
- As part of the dedicated pre-sales team focusing on BPC I was involved in demonstrating to the client the benefits of implementing BPC 5.1
- Demonstrated the solution package for specific industry, roles and business processes.
- Coordinated in understanding the scope and requirement of consolidation, planning and budgeting and writing functional spec and technical specs for BPC outlooksoft application and dimentions for consolidation and Budgeting / planning.
- Designed and developed application for Legal and management consolidation and created various dimensions. Developed the logic in scripts for currency translation and various elimination.
- Developed various reports and input schedules for the planning and budgeting application.
Confidential, NE
FICO Team Lead
Responsibilities:
- Responsible for creating detailed project plan for New GL migration.
- Primarily involved in verifying client copy from CAG to SFD instance for analysis and validation of scenario as well as testing for GL migration.
- Leading the Blue printing phase for the ECC configuration and subsequent migration of classic to New GL.
- Validated with CFO as well as various finance users about data from multiple ledgers to group into single New GL.
- Migrated 3 ledgers from classic to New GL there by reducing the reconciliation and month-end process.
- Involved in Migration of data from Classic GL to New GL using migration cockpit.
- Involved in phased migration of open items and non open items based accounts as well as balance carry forward.
- Analyzed the reporting requirement and reduced to considerable number of reports in New GL.
- Worked closely with Technical team on Conversion and Interface programs. Developed functional specifications for new interfaces and conversions.
Confidential, WI
FICO Business Analyst
Responsibilities:
- Performed system upgrade from SAP 4.7 to ECC 6.0 concentrating on FICO, SPL and MM modules with a BPP on migration strategy from classic GL to New GL.
- Performed Analysis on the specifics of mapping configuration and data migration to ECC6.0 data tables.
- Assisted in development of changes of 4.7 BPP and ECC 6.0 BPP.
- The client also used Hyperion 3.3.2 version mainly used for management consolidation, planning, budgeting and forecasting. As part of the R/3 upgrade I was involved in analysis of changes to data feeds and testing for consolidation.
- Designed Essbase cubes for budgeting and forecasting and used MDX calculations and reports.
Confidential, MN
FICO Team Lead
Responsibilities:
- Responsible for project plan and deliverables for the upgrade project.
- Performed system upgrade from SAP 3.1H to ECC 5.0 concentrating on FICO module with fit/gap analysis between classic General Ledger and New GL.
- Consulted the client’s development group on the specifics of the ECC 5.0 upgrade and data migration.
- Reviewed team requirements for program and configuration changes as per plan.
- Assisted in development of changes and modifications of 3.1H BBP and ECC 5.0 BBP, configuration, and support activities.
- Documented technical program and configuration settings as required by SOX.
- Conducted unit testing of all changed programs and configuration by executing the associated business processes.
- Carried out integration testing of defined business processes.
- I was also involved in the upgradation of Hyperion Planning 3.0 to 4.0 version. I was also coordinating in the development and testing of Hyperion reports as part of the Financial reporting application.
Environment: SAP R/3 3.1H / ECC 5.0 (FI, CO)
Confidential, NJ
Senior SAP FI/CO Team Lead
Responsibilities:
- Coordinated development of detailed data conversion scripts including approach, steps, reconciliation, and approval process.
- Configured segment reporting and document splitting for New GL.
- Leading the functional and technical team for migration of classic to New GL.
- Designed the migration to New GL from classic multi ledger that was used in previous SAP system.
- Migrated multi ledgers from classic to New GL there by reducing the reconciliation and month-end process.
- Involved in Migration of company codes in Classic GL to New GL that had different fiscal year.
- Involved in phased migration of open items and non open items based accounts as well as balance carry forward.
- Instrumental in reducing the number of reports from 1000+ that were running for all 3 ledgers to 200+ the number in New GL
- Analyzed the volume of open items prior to migration (approx. 2m plus) and advised to reduce to considerable number.
- Liaised with the finance department to get the data validation in number fo iterations.
- Configured parallel ledger concept for the purpose of maintaining different ledgers.
- Worked closely with Technical team on Confidential objects and developed functional specifications for new interfaces and conversions.
Confidential, CA
Senior SAP FI/AR Business Analyst
Responsibilities:
- Served as a Senior SAP AR/SD Consultant, Business Analyst, and as a Strategic Interface to assist the various teams in understanding the business processes and requirements of the users.
- Configured FI-AR and integration with SD module.
- Configured all SD processing including sales areas, account assignments, doc types, and partner functions.
- Worked on configuration and maintenance of materials.
- Configured and maintained all invoice forms and related logos, and remit to info.
- Analyzed all Billing related errors and issues.
- Configured and maintained lockbox processes.
- Responsible for testing and changes or enhancements related to billover.
- Maintained and developed interfaces to middleware and business partner systems using Business Connector, BAPI’s, RFC’s, and IDocs.
Environment: SAP (FI, CO, AR, SD, Billing, COPA, PCA, Credit Mgmt)
Confidential
Senior SAP FI/CO Functional Analyst
Responsibilities:
- Implemented SAP FI/CO, COPA, AP, FA, AM, TR, PS, and HR modules and Business Information Warehouse (BW) as a global rollout using a template approach.
- Used Business Objects (BO), Cognos, Informatica PowerMart and PowerCenter, and scheduling tools such as Tivoli and AutoSys.
- Carried out functional analysis for business scenarios, integration scripts, and training documentation.
- Set up the integration tests and provided end users support.
- Worked with salient points that included mapping of foreign currency loan requirements, dealing slip functionality, and accounting for foreign exchange deals.
- Implemented TR-cash position, liquidity forecasting, securities, derivatives, and Market Risk Management modules.
- Configured FI - Asset Management, including leased assets.
- Set up asset class for leased asset.
- Carried out SAP BW performance and tuning.
- Developed ETLs for data extraction, data mapping, and data conversion using Informatica PowerMart and PowerCenter 5.0.
- Designed data marts and developed an ETL process to transform Essbase outline line files and hierarchy to database.
- Analyzed and transformed business model into dimensional and physical model.
- Designed automated ETL procedures to transform non-relational sources to relational data structures.
- Architected an online data repository for Accounts Receivable unit and launched a successful ETL and reporting application using Informatica.
- Developed ETL processes for converting legacy data structures and mapping them to SAP table structures.
- Designed and developed interfaces between SAP and legacy Mainframe application.
- Performed configuration to create 4 new manual rollups, 2 related data and consolidations monitors, and the related actual and plan versions, to move the PCA actual and plan data from PCA to SPL and BCS.
- Created new consolidated plan and actual P&L’s in BCS by profit center wherein previously, the PCA data for actual and plan went into SPL only, and so consolidated P&L’s for plan and actual were not available primarily because currency translation could not be performed in PCA and there was no automated means to eliminate inter-company transactions in PCA.
- Worked on this new requirement that was based on the joint venture.
- Tested this configuration outside the original scope of this project, but was done using the same budget since they were requirements of the new global legal entity.
- Modified the BCS hierarchy and created a new tax hierarchy to reflect new legal corporate organizational structure, and corporate tax structure to include many domestic entities and global entities.
Environment: SAP R/3 (FI, CO, COPA, GL, AA, AP, AR, MM, FA, AM, TR, HR, PS, MRM, Confidential, PCA, SPL), SAP BW, Informatica 5.0 (PowerMart, PowerCenter), Business Objects, Cognos, Tivoli, AutoSys
Confidential
Senior SAP FI/CO and TR Analyst
Responsibilities:
- Mapped current processes with a view to identifying gaps and streamlining the processes for SAP R/3 4.6 implementation.
- Identified benefits and consequences of adopting a new chart of accounts.
- Developed common definitions for chart of accounts components.
- Identified and evaluated alternative chart of accounts structures that could meet user needs.
- Recommended a new chart of accounts design that met user needs and that had the ability to adapt to changing business conditions.
- Worked on financial accounting and Controlling data conversion project between from 4.0B to 4.6C.
- Supported the client in system design for data migration, transfer, and SAP organization structuring.
- Configured account assignment in IS-CD sub ledger in collection and disbursements (FS-CD).
- Served as a Team Lead for Basis and security team for planning and implementing security roles.
- Assisted team in creation of functional specifications, technical specifications, development standards, and documentation of the same.
- Implemented cash position, loans, and Treasury Management functionality including money markets, and foreign exchange modules.
- Mapped foreign currency loan requirements and accounting for foreign exchange deals.
- Implemented TR-cash position, liquidity forecasting, securities, derivatives, and Market Risk Management modules.
Confidential
Senior SAP FI/CO and TR Analyst
Responsibilities:
- Mapped current processes with a view to identifying gaps and streamlining the processes for SAP R/3 4.6 implementation.
- Identified benefits and consequences of adopting a new chart of accounts.
- Recommended a new chart of accounts that will meet the financial accountability, decision support, and GAAP reporting needs.
- Developed common definitions for chart of accounts components.
- Identified and evaluate alternative chart of accounts structures that could meet user needs.
- Recommended a new chart of accounts design that meets user needs and that has the ability to adapt to changing business conditions.
- Supported the client in system design for data migration, transfer, and SAP organization structuring.
- Served as a Team Lead for Oracle and middleware Brokat system.
- Assisted team in creation of functional specifications, technical specifications, development standards, and documentation of the same.
- Mapped foreign currency loan requirements and accounting for foreign exchange deals.
- Implemented liquidity forecasting, securities, derivatives, and Market Risk Management modules.
