| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Sr. SAC Consultant | Email: EMAIL AVAILABLE | Ph: PHONE NUMBER AVAILABLEExperience Synopsis:Highly skilled and results-driven SAP Consultant with over 14 years of experience managing the full software development life cycle. Proficient in requirement gathering, project planning, Implementations, testing, cutover strategies, and proof of concepts. Extensive expertise in Hyper-support, FP&A support, production support, enhancements, migrations, change requests and performance tuning. Demonstrated success across diverse industries including Retail, Pharma, Manufacturing, Banking, Finance, IT, Utilities, Media, and Transportation in implementing Financial Planning, Budgeting, Forecasting, and Consolidation solutions. Profile Highlights: 4+ years of experience in SAP Analytics Cloud - Planning. 5+ years of experience in CDS Views. 14+ years of experience in SAP BI/BW. 14+ years of experience in SAP BPC NW &MS - Planning & Consolidations. 12+ years of experience in FP&A Support. 10+ years of experience in SAP ECC. 5+ years of experience in SLT (SAP Landscape Transformation). 4+ years of experience in SAP BOBJ. 10+ years of experience in Analytics. 6+ years of experience in SAP BW4/HANA. 5+ years of experience in SAP S/4 HANA. 8+ years of experience in Native HANA. 10+ years of experience in MS SQL.Certifications: SAP Certified Application Associate - SAP Analytics Cloud. SAP Certified Application Associate - SAP Business Planning & Consolidation. SAP Certified Application Associate - SAP Business Warehouse. SAP Certified Application Associate - SAP HANA. SAP Certification of Achievement - SAP Datasphere, BW4/HANA, S4/HANA and Native HANA.Education Qualification: Bachelor of Technology in Information Technology- 2009 from JNTU, Andhra Pradesh, INDIA.Technical Skills:SAP BW, BPC NW&MS, SAC, Datasphere, SLT, BEx, AO (Analysis for Office), ECC, FI, HANA, BO, BODS, ABAP (BADI s), BW/4 HANA, S/4 HANA, SQL, MDX, FOX Scripting, AMDP s, VB Script, JavaScript for SAC, Lumera, WEBI, Crystal reports and dashboards.
Experience Summary:PetSmart. Pheonix, AZ | Sr. SAC Consultant | Feb 24 Present.SAP Analytics Cloud Executed end-to-end solution delivery, including integration, data modeling, Planning, Budgeting, Forecasting reporting, and Reporting techniques. Developed SAP Analytics Cloud (SAC) connections with various on-premise and cloud data sources, utilizing extensive experience with Cloud Connector and Cloud Agent. Delivered solutions to challenging business requirements for project initiatives that involves SAP BI solutions such as SAC. Developed Analytic & Planning models, Dimensions, Stories, Data actions, multi-actions and currency Conversion. Created SAP Analytics Cloud (SAC) stories across various functional areas based on business requirements. Developed summarized dashboards and detailed reports using Canvas, Responsive, and Grid pages. Created visualizations with column, line, time series, and waterfall charts.
Implemented story and widget input controls, cross calculations, data blending, geo maps, and explorer views. Developed analytic applications using widgets, popups, and custom JavaScript scripting and integrated stories into analytic applications to enhance functionality and user experience. Created Smart Discovery on Sales Projections Model to find top Influencers and Simulation of measure. Developed Smart Assist features like Time series Forecast & enabled smart Insight on different widgets. Developed Planning Models and worked on Version management, Data locking, Data distribution, Predictive and rolling Forecast, Planning and budgeting. Developed stories and dashboards in SAC using Datasphere analytical models. Developed CDS views to load the data from HANA Views & BW/4 objects to SAC using Connections and data mappings. Proficient in loading data from BW to SAC using BW Bridge connection. Developed advanced planning features in SAP Analytics Cloud, including allocations, value driver trees, data actions, and automation of data actions/multi-actions using the Planning Calendar. Created Smart Predict models like HR Flight risk classification predictive model & Sales Projection regression Predictive model using ML Algorithms. Transported SAC Objects across landscape from Dev to Prod using Import & Export, Publishing stories to Analytics hub and Fiori Portals.SAP BW, BPC & HANA Proficient in SAP BW modelling, Reporting and extraction. Extensively worked with SAP BW Data Sources, Info provider, Mult provider, DSO (Direct and classic), ADSO, DTP, APD, OHD, Transformation, Info package, Process chains, Data Source, Info source, Info Area, Source Systems, Bex, Routines, Info set, Composite Providers, Virtual Provider, Hybrid Provider, Info object, Info Object Catalogues, Hierarchies, Aggregations, Characteristics, Key figures, Time Dependent Hierarchies, Transports, Query Designer, aggregates, Filters, planning functions, planning sequences and authorization setting for Queries. Extensively worked on query development and formatting techniques in both BEx and Web Application Designer (WAD) of key BW reports and created Web Templates. Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies in developing complex queries by using Conditions, Exceptions, Variables, Structures, Restricted Key Figure, Calculated Key Figure, Formulas RRI Jump Queries, Ad-Hoc Queries. Proficient in HANA Modelling, Schemas, Packages, Attribute View, Analytical View, Calculation View, Attribute mapping, creation of calculated measures, Calculated attributes, Input parameters, Variables, Restricted measures, Constant columns, Currency Unit conversion, stored procedures and maintaining analytical privileges Data Provisioning using SLT and Smart Data Access Involved in Export/Import data and validations. Gathered business requirements for enhancements in BW and BPC, and developed processes to integrate data from various source systems. Created Data Manager packages and package links to load master and transactional data from SAP, non-SAP systems, and flat files, automating processes for daily, weekly, and monthly loads. Established data extraction procedures for master data and transactional data from ECC to BW and from BW to BPC. Configured BW Extractors to retrieve FI-GL, AR, and AP data from ECC to BW cubes. Created transformation and conversion files to import data into BPC from BW and flat files. Developed macros and VBA scripts for validating, refreshing, sending, and integrating data manager package functionalities such as clear, copy, export, and load in reports and input forms. Managed BW and BPC transport activities, including the transport of objects from DEV to QA to PROD environments. Configured user roles, teams, task profiles, and data access profiles, and provided user access according to roles. Created reconciliation reports for data consistency between BPC and BI, including InfoCubes, BEx reports, and EPM reports. Expertise in developing ABAP Routines, BADI s, ABAP Program/Scripts, logic Scripts, SQL, MDX scripts, Function Module, Dialogue Programming, SAP Scripts, Smart Forms, Data Dictionary objects, Function Groups, User Exits, Enhancement Framework and CDS Views in ADT for data mapping and Business calculations. Developed CDS views to replicate tables and views from HANA to Datasphere using replication flows for data modelling.Amtrak. Washington, DC | Sr. SAC Consultant | Jun 21 Feb 24.SAP Analytics cloud. Configured chart of accounts, account groups, field status groups, and posting keys, assigned these variants to company codes, created GL Master records, reconciliation accounts for sub-ledgers, document types, number ranges, invoices and payments, tolerance groups, automatic account assignments, GL display (line-item layouts, special fields, sort variants, totals variants) for P&L and income statements. Developed Models (Planning and analytics) and dimensions (Public and Private), Properties, Hierarchies, smart transformations, Versions, input templates, Planning Scenarios, Member formulas, Advance Formulas, Data actions, Multi actions, stories, Dashboards, input controls, allocation/calendarizations, role-based security and calculations in SAC. Developed data imports to load and map master and transaction data from SAP and non-SAP sources, including BPC, BW, S/4HANA, HANA, Datasphere, flat files, and other non-SAP systems into SAP Analytics Cloud (SAC). Created CDS views with input parameters, calculated columns, filters, variables, and restricted columns. Created aggregation levels and filters on Composite Providers. Developed planning enabled ADSO and used them in Composite Provider. Developed various dashboards and stories in SAP Analytics Cloud (SAC) featuring versions such as actuals, budgets, planning, forecasts, and rolling forecasts. Represented KPIs related to revenue and OPEX using variances, time series, bar charts, geo-special charts, and other visualizations. Utilized story canvases, responsive and grid layouts, formulas, cross calculations, input controls, linked analysis, filters, maps, and tables to create comprehensive and interactive business reports. Created connections to load the data from ECC DataSources to SAC using OData Services. Developed stories for various forecasting scenarios in SAP Analytics Cloud (SAC), including rolling forecasts and predictive forecasts such as automatic forecasting, linear regression, and triple exponential smoothing. Developed predictive scenarios such as classifications, Regression and Time series forecast. Developed custom widgets, Dashboards, Linked analysis and JavaScript s in Analytics Applications. Developed data actions for allocations, copy and Advance formulas for cross model copy, business calculations to calculate revenue and expenses. Proficient in publishing BO universe to HANA and created calculation views in HANA to map with different tables and loaded the data from HANA Views to SAC models using connections and CDS Views.SAP BW, BPC & HANA. Identified GL data and master data for various dimensions, and developed a process to load actuals and master data from ECC to BW and BPC. Scheduled the process for daily updates. Copied environment from environment shell and developed models and dimensions and loaded data transaction data/master data (Attributes, texts and Hierarchies) from BW and flat files. Developed Logic Scripts, BADI s like Write-back BADI, Custom Logic BADI, Routines, ABAP Program/Scripts, Business Rules, Transformation and conversion files, data manager packages and package links, work status, member formulas, business process flows, EPM reports and input forms, VB script, Macros in BPC. Configured intercompany elimination rules, carry forward and account transformation rules for consolidation process.
Created EPM reports and input forms using EPM functions, Excel formulas and Developed VBA to perform the functionalities like refresh, input enable cells, copy the data from multiple reports within the report, Save, Refresh and Expand, dynamic selection and several functionalities for multiple sheets for reports and Input forms within the workbook. Developed Info objects, DSO s, Info Cubes, Multi Providers, Transformations/Update Rules with ABAP routines, Data sources/Info sources, Info sets, Open Hubs, APDs, Process Chains, DTP s, Info packages, BEx Queries, Composite Providers, ADSO in BW. Developed HANA Modeling, Schemas, Packages, Attribute Views, Analytical Views, Calculation Views, Attribute mapping, creation of calculated measures, Calculated attributes, Input parameters, Variables, Restricted measures, Constant columns, Currency Unit conversion, stored procedures and maintaining analytical privileges Data Provisioning using SLT and BODS meta data import. Involved in Export/Import of models, validations. Developed CDS views for data modelling to load the tables from various sources like HANA & S/4 HANANovartis. DFW, TX| Sr. SAC & BPC Consultant| Oct 18 May 21.SAP Analytics Cloud Gathered and documented business requirements through meetings with key users and the FP&A team. Drafted business process documentation to identify necessary components for driving planning data models and versions, such as actuals, budgets, planning, forecasts, and rolling forecasts, for implementation during month-end and year-end processes. Created dimensions and models in SAP Analytics Cloud (SAC) and configured data connections to load and map master and transaction data from SAP and non-SAP sources using transformations. Implemented dashboards and stories with versions such as actuals, budgets, planning, forecasts, and rolling forecasts. Created visualizations, including charts, tables, maps, and filters, in storyboards to provide clear insights into sales, income, and expense data. Developed data actions for copy, allocations, currency conversions, and advanced formulas. Created multi-actions by adding data actions and import steps, and scheduled them for daily execution. Developed predictive forecast stories for automatic forecast, Lenier Regression and triple exponential smoothing stories and input templates to load the data to templates configured by the version cutoff date using look ahead and look back options. Developed Account based models and Key figured based models as per the business use case to populate the data in the stories and dashboards for analysis. Developed data actions for allocations, Cross model copy, currency conversions and Advance formulas for business calculations.SAP BW & BPC Copied environment, Models and set the Global parameters, Model parameters and environment parameters in SPRO. Created models and dimensions, defined properties and members, and developed member formulas in SAP BPC. Designed and implemented processes to load master and transaction data from SAP and non-SAP source systems using Data Manager packages, package links, advanced scripts, and prompts. Created transformation files and conversion files to loaded master data and Transaction data to models through BW Info Cube, flat file and from other non-SAP source systems and developed Logic Scripts, Routines, Write-Back BADI s and Custom Logic BADI S for data loads and Business calculations. Developed Income Statement, Balance Sheet report, Audit Report and Intercom any matching & elimination, Cash Flow report, Consolidated Summary of Operations and Consolidated Balance sheet by Company code using variance calculation, Conditional formatting using EPM functions, Excel formulas, VB script and Macros. Worked on SAP BW modeling, Reporting and extraction. Extensively worked with SAP BW Data Sources, DSOs, Info Cubes, Multi Providers, Info Objects, Info Sets & APDs and ECC standard/Custom extractors, Strong expertise on Business explorer query design, and authorization setting for Queries. Developed BW/4 modeling objects like composite provides, ODS and ADSO s. Extensively worked on query development and formatting techniques in both BEx and Web Application Designer (WAD) of key BW reports and created Web Templates. Designed Info Sources, activated Pre/Post transformation rules, scripted extraction routines for master data, texts and hierarchies in developing complex queries by using Conditions, Exceptions, Variables, Structures, Restricted Key Figure, Calculated Key Figure, Formulas RRI Jump Queries, Ad-Hoc Queries.Zimmer Biomet. Warsaw, IN | Sr. SAP BW & BPC Consultant| Sept 17 Oct 18. Collaborated with key business users to understand current processes, gathered requirements, and performed gap analysis to identify relevant sales data, including historical sales, customer information, product details, pricing, and sales for BPC implementation. Developed the BPC environment by copying from a pre-delivery shell, created models and dimensions, and set up model and environment parameters in SPRO. Created transformation and conversion files, and Data Manager Packages/Package Links for loading master and transaction data into BPC from BW Info Providers and external files using advanced scripts and prompts. Developed data extraction procedures using routines and BADIs (Write Back and Custom Logic) for data from various SAP and non-SAP systems. Configured BPC security, drill-through, logic scripts, work status, transports, backup and restore, package/package link schedules, and Business Process Flows (BPFs). Developed custom logic BADIs to retract data from BPC to BW DSO and created calculation views in HANA. Published these views to Tableau for dashboards and WEBI for reporting. Designed BW/4HANA modeling objects including Composite Providers, virtual providers, ADSOs, and open ODS views. Developed Info Cubes, DSOs, transformations, routines, Info Packages, data sources, process chains, APD, OHD, and DTPs for standard BW modeling. Created EPM reports and input forms using EPM functions and Excel formulas. Developed VBA macros to enhance functionalities such as refresh, cell input enablement, data copying, saving, dynamic selections, and multi-sheet operations. Developed Composite Providers and ADSOs in BW/4HANA to integrate HANA views, mapped fields from source to target, and extracted data using BEx queries, variables, restricted variables, filters, and prompts for Analysis for Office (AO). Created reports in Analysis for Office based on calculation views and Composite Provider data. Conducted training sessions for business users, assisted with user acceptance testing (UAT), and supported the deployment to production. Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.
Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis.
Developed HANA Modeling, Schemas, Packages, Attribute Views, Analytical Views, Calculation Views, Attribute mapping, creation of calculated measures, Calculated attributes, Input parameters, Variables, Restricted measures, Constant columns, Currency Unit conversion, stored procedures and maintaining analytical privileges Data Provisioning using SLT and BODS meta data import. Involved in Export/Import of models, validations. Created composite providers and ADSO s in BW/4 Modelling in HANA to add the HANA view (data from other source systems) in the composite provider and mapped the required fields from source to target (BPC Fields) to extract the data from HANA View to Composite Provider and reports using BEx queries, variables, restricted variables, filter and prompt in the query to have the user selections in AO (Analysis for office). Proficient in configuring source and target connection in SLT and replicating tables from ECC to HANA using real-time replication.Associated Bank. Green Bay, WI | Sr. SAP BW & BPC Consultant| Feb 17 Aug 17. Collaborated with project owners and the FP&A team to understand business processes and gather requirements based on the existing Hyperion design. Developed design documents for integrating with SAP and non-SAP systems, ensuring alignment with current design and requirements. Duplicated environments and created models and dimensions, including maintenance of dimension members, hierarchies, and dimension properties. Extracted data from the source system R/3 for actuals to BPC using process chains in BW and Data Manager packages in BPC. Mapped the chart of accounts from the source system ECC to BW and BPC using transformations in BW and Transformation/conversion files in BPC. Developed logic scripts, routines, and BADIs (custom logic and write-back BADIs) to perform calculations and map data for loading into BPC. Developed Reports and input forms using EPM functions, excel formulas, VB script and macros. Created Management Book reports and published them using Book Publications. Generated PDFs for top-level business reporting and reconciliation purposes. Configured consolidation processes for intercompany matching, elimination, balance carry forward, and account transformation rules. Posted journal adjustments for intercompany eliminations to reconcile net amounts, balance sheet liabilities, and income statement expenses. Configured SAP modules including FI-GL, FI-AR, FI-AP, FI-BA, FI-AA, Cost Center Accounting, and Profit Center Accounting during implementation. Created cost center groups within the standard hierarchy, established cost centers including collection and allocation cost centers, and developed secondary cost elements. Set control parameters for actual postings, defined allocation characteristics for sender/receiver costs, and configured assessment, distribution, and reposting processes. Configured House Banks, Bank Accounts, GL Structure, and Posting Rules for automatic assignments
Developed Infoobjects, DSO s, InfoCubes, MultiProviders, Transformations/Update Rules with ABAP routines, Data sources/Infosources, Infosets, OpenHubs, APDs, Process Chains, DTP s, Infopackages, BEx Queries Developed HANA Modelling Schemas, Packages, Attribute Views, Analytical Views, Calculation Views with BPC retracted data and developed dashboards in Lumera. Proficient in developing SAP BO universe in UDT using data foundation, business layer, parameters, filters, Context, cardinalities, Aliases, joins, projections, conditions and published universe to repository for reporting in WebI, crystal reports and dashboards, and published universe to HANA to map with other tables in calculation view and develop reports, Dashboards, visualizations and analytics in Lumera using universe and HANA views. Familiarized the team with customer needs, specifications, design targets, development processes, design standards, techniques, and tools to support business requirements.Deloitte(DAS). Lake Mary, FL | Sr. SAP BW & BPC Consultant| Aug'16-Feb 17. Utilized Agile methodology to deliver sprints for enhancements and change requests within committed timelines. Performed requirement gathering, design, and development of reports and input templates using EPM functions, Excel formulas, VBScript, and macros. Conducted unit testing and created technical and functional documentation for new integrations and EPM templates as part of change requests. Loaded transaction and master data (including text, hierarchies, and attributes) from SAP and non-SAP systems (e.g., ECC, BW, BODS, FTP, HC) using transformation and conversion files in BPC. Created and scheduled process chains, Data Manager packages, and package links for daily data loads. Designed queries in BEx Query Designer with filters, variables, navigational attributes, and structures for detailed drill-down analysis. Developed and debugged default logic, BADIs, and routines using EPM templates and Data Manager packages in BPC. Maintained customer master records and configured systems for daily accounting transactions, including post-value adjustments and balance carry-forward in Accounts Receivable (A/R). Loaded data to HANA from Oracle DB by creating universes in BO UDT, exporting them to HANA, and developing attribute, analytical, and calculation views. Developed InfoObjects, DSOs, InfoCubes, MultiProviders, transformations/update rules with ABAP routines, data sources/info sources, InfoSets, Open Hubs, APDs, process chains, DTPs, InfoPackages, and BEx Queries. Created OSS messages for product issues with SAP and implemented suggested solutions. Collaborated with the QC team to design test cases and perform functional and regression testing. Performed maintenance and housekeeping activities to enhance system performance.Citrix. Fort Lauderdale, FL | Sr. SAP BW & BPC Consultant| Jan'15-July 16. Performed requirement gathering and developed design documents to enhance planning functionality within the current business processes. Copied environments, created models and dimensions, and maintained properties, members, and hierarchies. Developed various data extraction procedures for master data attributes, texts, hierarchies, and transactional data using transformation and conversion files to map data from BW to BPC. Extensively worked on SAP BW data extraction from multiple SAP and non-SAP (legacy) systems, including BI Content Extractions (LO - SD, PP, PM), FI/CO, SEM, flat files, and generic extractions. Managed backup and restore operations for master and transactional data, ensuring successful restoration in development, QA, and production environments as needed. Developed complex logic scripts, routines, and BADIs (write-back and custom logic) for data loads and business calculations. Configured security and work status to maintain user roles and facilitate data submission as part of the planning process. Created Infoproviders, DSOs, DTPs, routines, and transformations in BW to load actual data from ECC using the FI_GL_12 extractor, and developed process chains for data loading. Designed queries in BEx Query Designer using filters, variables, navigational attributes, and structures to support detailed drill-down analysis. Developed reconciliation reports to validate data transfers from BW to BPC, comparing InfoCubes, BEx reports, and EPM reports. Managed managerial and legal consolidations, including consolidation monitors, ownership management, intercompany eliminations, matching, balance carry-forward rules, account transformations, currency conversions, and compliance with GAAP and IFRS standards. Created complex reports and input forms such as P&L statements, balance sheets, and cash flows in BPC using EPM functions, Excel formulas, and VBA scripts. Configured currency conversion and reporting currencies, including local currencies (LC), USD, and group currencies. Utilized HP ALM to track requirements in both development and testing environments. Collaborated with COE teams, end-users, and support teams to address issues related to data loads, reports, business processes, performance, enhancements, and break fixes.Lexmark. Lexington, KY | Sr. SAP BW & BPC Developer| Oct'12 Dec'14. Developed cutover documents for migrating from BPC 7.5 to 10.0, coordinating with functional and technical teams to execute activities during the cutover period. Created EPM reports and input forms, and migrated EVDRE reports and templates using EPM/EVDRE functions, Excel formulas, VBScript, and macros. Performed backup and restore operations and applied optimization techniques as part of weekly maintenance activities. Oversaw migration from BPC 7.5 to 10.0 on HANA, including post-Go-Live activities and ongoing support. Participated in User Acceptance Testing (UAT) in the QA system and trained end-users on defect tracking. Developed process chains, APD routines, InfoCubes, MultiProviders, DSOs, DTPs, transformations, and BW queries for extracting data from ECC and non-SAP systems into BPC. Configured work statuses, Business Process Flows (BPFs), Data Manager packages, and package links. Created transformation and conversion files to map and import data from BW to BPC using routines, BADIs, and logic scripts for both SAP and non-SAP sources. Generated reconciliation reports to validate data transfers between BPC and BI, comparing InfoCubes, BEx reports, and EPM reports.British Petroleum UK | SAP BW & BPC Developer| Jan'10- Sep 12. Developed and maintained BPC applications, dimensions, and data manager packages, including logic scripts and member formulas. Created and supported InfoProviders, transformations, routines, BADIs, process chains, DSOs, and InfoObjects in BW. Designed and managed data manager packages, process chains, and default logics, scheduling them for daily loads. Developed and maintained reports and input schedules utilizing EVDRE functions, Excel formulas, VBScript, and macros. Established data extraction procedures for master data (attributes, texts, hierarchies) and transactional data from SAP and non-SAP sources. Developed, debugged, and maintained ABAP routines for start/end routines and BADIs in BW. Created and supported reconciliation reports for data loads from BW to BPC. Configured work statuses, security, and Business Process Flows (BPFs) in BPC. Participated in the migration of BPC from version 7.0NW to 7.5NW. Handled backup and restore processes as part of migration and month-end close activities. Managed transport of BPC and BW objects across development, QA, and production environments. Oversaw data validation with business users, addressing issues during UAT, QA testing, Go-Live, and Hyper-Care support. Diagnosed complex issues, performed analysis, and proposed solutions, workarounds, and recommendations. Collaborated with SAP to resolve product issues and problems encountered during upgrades and redevelopment. |
