We provide IT Staff Augmentation Services!

Solution Architect Resume

5.00/5 (Submit Your Rating)

Teaneck, US

Executive Summary

  • Co-Founder Member of SAP BPC Practice in Confidential Technology Solutions (NASDAQ: CTSH)
  • Solution architect with 13 years of total experience in Financials, Planning, Reporting and Consolidation Area.
  • Expertise on SAP BPC (Business Objects Planning and Consolidations-EPM 10.0, 7.5 NW &MS, 5.1), FI/CO- 4.7 EE, ECC 6.0, BI 7.3
  • Solution Architect for one of the largest Implementations on SAP BPC (2000+ Users)
  • Integration with Crystal and Xcelsius Dashboards
  • Expertise in strategic planning with extensive qualifications managing design, development and delivery of cost-effective, business solutions to meet challenging business demands
  • Strong ability to translate business concepts and processes into functional and technical requirements that improves understanding at all levels of the organization
  • Involved in 5 Life cycle Implementation in BPC so far.
  • Chartered Accountant by Qualification, a qualification equivalent to Certified Public Accountant in United States of America.
  • Have performed various roles in the past starting from a Software Developer to Solution Architect

Key Skills

  • Expertise in SAP BPC 5.1 through 10.0 NW (EPM 10 Suite)
  • Invloved in Product  devlopment with SAP (Sales Planning Accelearator) on SAP BPC 7.5 NW
  • Master in EVdre and building Templates with VBA Code
  • Experienced in SAP R/3 FICO 4.7 EE, through ECC 6.0
  • Expert in COPA, Cost Center Accounting and Profit Center Accounting
  • Working skills in SAP BI and ABAP
  • Experience in Planning, Forecasting and Consolidations 
  • Expert in project analysis, scoping, planning, scheduling, testing, change management, risk management, resource management
  • Experience in managing Functional, Technical, Consultants through all phases of SAP projects
  • Expert in Requitrement gathering and trandforming them into a Solution

SAP Experience: Confidential,06/10-Present,Solution ArchitectConfidential,02/08-06/10,Team Lead/Solution ArchitectConfidential,07/05-02/08,Senior Software Engineer

Non SAP Experience (Financial Accounting) Confidential, 03/02- 06/05, Finance ControllerConfidential,02/99-02/02,Articled Clerk

EDUCATION MASTER DEGREE,Confidential Institute XII,Confidential InstituteX,Confidential Institute

Project Profile 1

Project Title :Retail Accelerator Client Name :ConfidentialDuration:Jan 2012- Till DateLocation:Teaneck, USProgramming Languages:SAP BPC 10.0 NW, SAP BI 7.3Project Description:
A Retail Planning accelerator has been developed for targeting retail industry using SAP BPC Application 10.0 NW. 

Scenarios Configured:

  • Store Planning
  • Merchandise Financial Planning
  • Opex Planning
  • Assortment Planning

Responsibilities:

  • Setting up the infrastructure
  • Assisting in BPC Installation 10.0 NW
  • Actively involved in Requirements gathering
  • Configured and Designed:
      • Environments
      • Models
      • Dimensions
      • Business Process Flows
      • Reports
      • Templates
      • Assisting the team in building Script Logics and ABAP Routines
      • Teams
      • Data Access Profiles
      • Task Profiles
      • Foreign Currency Translation
      • Master Data Load (SAP BI 7.3)
      • Transaction Data Load(SAP BI 7.3)
  • Designed and configured Complex Scenarios
      • Calenderization of weeks
      • Comp Store Identification

PROJECT PROFILE # 2

Project Title:Confidential Budgeting System Client Name :ConfidentialDuration:July 2010- Jan 2012Location:Teaneck, USProgramming Languages:SAP BPC 7.5 MS

PROJECT DESCRIPTION:Client- Confidential Budgeting System
Confidential was carrying out the Budgeting system centrally maintained excel sheets and was manually feeding Insight Compass system. This project is to streamline the entire Budgeting Process using SAP BPC Application and have robust methods to determine the impact of Currency fluctuations and Wage inflation to Annual Budgets.
The project involves 2 phases, June 2010 to Dec 2010 and phase 2 from Jan 2011 to Jan 2012. This is one of the largest Implementations on SAP BPC so far (2000+ Users)

CLIENT DESCRIPTION: 
Confidential (NASDAQ: CTSH) is a global provider of information technology, consulting and business process outsourcing services headquartered in Teaneck, N.J. Confidential was founded in 1994 as an IT development and maintenance services arm of The Dun & Bradstreet Corporation. The company was spunoff as an independent organization two years later. Since 1996, Confidential has worked closely with large organizations to help them build stronger, more efficient, and more agile businesses

Role: Solution ArchitectScenarios Implemented

  • Complete Migration from Manual Planning to BPC
  • Configured Revenue Planning
  • Designed and Implemented Cost Center Planning
  • Implemented Capex Planning
  • Designed and Implemented What-IF Analysis (Different FX Rates and Wage Inflation)
  • Management Consolidations
  • Pre-Target Scenarios

Designed and Configured the following:

  • Application Set
  • Applications
  • Dimensions
  • Attributes
  • Dimension Members
  • Automation of Master data Load
  • Input Schedules
  • Reports
  • Business Process Flows
  • Member access Profiles
  • Task Profiles
  • Teams
  • Transaction Data Load
  • Integration to BOBJ
  • Data Manager Packages
  • Unit Testing
  • Integration Testing
  • System Testing
  • UAT Sign off

Complex Scenarios Configured

  • WHAT IF ANALYSIS (Impact on the profitability when FX rates and Wage inflation changes)
  • Configured and Designed Security set up (2000+ Member Access Profiles, 2000+ Teams)
  • Automation Security Set Up

Project Profile # 3

Project Title: Sales Planning Accelerator Client Name :ConfidentialDuration:Jan 2010- June 2010Programming Languages:SAP BPC 7.5 NW, SAP BIDURATION OF THE PROJECT:  6 Months Role: Solution Architect 
Project 1: SAP LABS- Product Development- SPA Project Description:
A new Application Set is being developed to cater the needs of Sales Planning for Retail Industries. This Appset in turn is integrated real time with SAP CRM-TPM system. New additional functionalities that are not available with the original Appset are developed and bundled with the new Appset. Functionalities delivered as part of the new Appset:-

  • Application Set
  • Applications
  • Dimensions
  • Attributes
  • Dimension Members
  • Loading Master data from the Backend (Through SAP BI)
  • Loading Transaction Data from SAP BI Cubes
  • Integration with TPM system
  • Adding Dimension members from the front end and sending it to TPM System
  • Storing dates
  • Template Generators
  • Input Schedules
  • Reports
  • Business Process Flows
  • Work Status
  • Member access Profiles
  • Task Profiles
  • Teams
  • Integration with Crystal Reports
  • Integration with Xcelsius Dashboards

Project Profile # 4

Project Title:492 Project Clarity Client Name :ConfidentialDuration:April 2010- Dec 2010Programming Languages:SAP BPC 7.5 MSDURATION OF THE PROJECT: 9 MonthsDescription: This Project delivered significant process, data quality, and cycle time benefits to the Corporate Accounting Consolidations team and the Corporate Financial Planning and Analysis team. Their processes had a single source of data for most processes, reduce the amount of manual data entry and loading activities, and increase the amount of time available for analysis and stronger reporting capabilities. The Go live date was Jan 2010.Role:- Team LeadResponsibilities:

  • Initiate - Requirements Gathering
  • Developed Questionnaire for FP&A and Consolidations team
  • Involved in active discussions with FP&A and Consolidation teams Managers
  • Analyzed the As -Is system landscape
  • Design
  • Prepared Fit Gap Analysis for FP&A and Consolidation teams
  • Solution Design briefing the mapping of Requirements with the features available in BPC
  • Functional Design (Feature Brief)Designing the each Feature in the new system with enhancements
  • Appset to cater both Planning and Consolidations
  • Mapped the functional areas to 7 Applications
  • Designed 26 Dimensions and assignment to Applications
  • Dimension members
  • Transformation files
  • Designed 20 Report templates including SEC Reports
  • 34 Forms (Input schedules) covering Revenue Planning, Headcount and COGS Planning, Spend Planning
  • Security Teams, Tasks Profiles, Member Access Profiles
  • Data Loading through Inbound Interfaces.
  • Foreign Currency Translations
  • Management Consolidations
  • Setup of Legal Consolidation
  • Work Status
  • Tune:
  • Close liaison with Business heads for Application Tuning
  • Go Live Validations
  • Validating the expectations on Performance
  • Deploy
    • Training the core users
    • Feature Testing
    • Regression testing
    • System testing with different Security Teams
    • Coordinating User Acceptance testing

Project Profile # 5 

Client : Confidential
System : SAP BPC 7.0 NW
Role : Assistant Project Manager
Description: Developing dashboards for marketing departments of the client using SAP BPC 7 NW version and Xcelsius. The source data is housed in SAP BI and then getting pulled into SAP BPC 7 NW in required format. 14 reports are developed as feed to Xcelcius dashboards. Many of these reports runs into more than 20K rows with multiple dimensions in rows and columns. 
Responsibilities:

  • Initiate - Requirements Gathering
  • Developed questionnaires
  • Conducted interviews with Marketing Team
  • Analyzed the AS –IS System
  • Design & Plan:
  • Developed Blue print for the proposed solution
  • Developed mapping between source data and BPC master data
  • Detail Design of the following:

1. Appset
2. Dimensions and its properties
3. Dimension members
4. Data Manager Packages, Transformation Files
5. 14 reports to be used as input for the XCelcius Dashboards

  • Configure:
  • Configured one application with 11 dimensions
  • Configured dimension properties to get the dynamic market share calculations
  • Setup BPFs
  • Setup of Data Loading through Data Manager Packages
  • Developed Reports using EVdre
  • Developed Input Schedules using EVdre
  • Configured Foreign Currency Translations
  • Tune:
  • Close liaison with client marketing Team
  • Deploy
  • Co coordinating User Acceptance testing
  • System testing with different Security Teams

NON SAP-Related Experience

Confidential (March 2002- June 2005)Finance Controller – Areas Focused:

  • Monitoring and maintenance of various books of accounts as per the statutory requirements
  • Dealing with Banks/Financial Institutions for working capital & term loan assistance.
  • Maintaining Receivables
  • Assessing Working Capital requirements
  • Maintain Job wise cost details
  • Preparation of Monthly Budgets (Ex: Cash, Sales, expenditure etc.,)
  • Maintaining Stock Records
  • Preparations of funds flow statement, cash flow statements
  • Finalizations of budgets, comparison of budgets with actual

Confidential, Co - Articled Clerk (February 1999 to February 2002)

  • Maintaining Cash Book including Petty cash book.
  • Maintaining Books of Accounts.
  • Maintaining Debtors and Creditors Register.
  • Preparation of Bank Reconciliation Statements

We'd love your feedback!