| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Sap Basis Senior Consultant Somerset, NJ S4 Hana Sap Abap Iselin, NJ Sap Fico Consultant Business Edison, NJ SAP Consultant Inwood, NY SAP HCM consultant, Core HR functions, people analytics, project East Windsor, NJ SAP HCM Payroll Consultant Bronx, NY Accounts Receivable Sap Hana Monroe, NY |
|
Click here or scroll down to respond to this candidateCandidate's Name John Panicker [pic]SAP BW Consultant (HANA)EMAIL AVAILABLE PHONE NUMBER AVAILABLESummary . Over ELEVEN years of experience in IT industry as SAP Consultant with over FOUR years of SAP Business Warehousing/Business Objects, including TWO years in BW HANA. . Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology. . Worked on Data Modelling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0 . Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges. . Excellent knowledge on: HANA Optimized Info Cubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA . . Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and Info Cubes. . Experience in Importing BW models Info Cube, DSO in HANA as Analytical view. . Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA. . Experience in Data-Provisioning techniques suing SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS. . Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis Business Objects Explorer MS Excel. . Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, trouble shooting and performance tuning. . BI Design - Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB. Proficient in Data modelling using MDM and BW extended star schema models. . Strong experience in reporting with SAP BW info providers such as Info objects, Cubes, Queries. Expertise in reporting with Cognos 8 tools on different SAP R/3 functional areas combining data from different R/3 function modules (SD, FICO, MM) in BW. . Implemented SAP BW core business rules (Security (roles), Calculated Key figures, Restricted Key figures, Query variables) in Cognos tools. Integrated Cognos Reporting with BW functional areas for detailed reporting. . Configured Cognos Connection (portal) and performed Metadata modelling in Framework Manager. Created models and published packages with Framework Manager and combined data from SAP BW and Non SAP BW data sources for reporting. Exceptional ability to quickly master new concepts and technologies. . Currently working in SAP BI 7.3 and knowledge of HANA modelling. Capable of working in a group as well as independently with excellent communication skills. Strong production support experience, good at trouble shooting with quick turnaround in fixing the issues.BW Skills: . BEx Worked Extensively in BEx Analyser in building Queries, saving it in Workbooks (Excel work Sheets). BW Expertise in SAP BW components like Info Cubes, Multi providers, Info Source, Info Objects, Update Rules and Transfer Rules, Which Includes Data Modelling. . Reporting Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, Conditions, RRI, and Jump queries. . Web Reporting Developed Web reports, Web items, customized Web templates using Web application designer (WAD) and query designer. . Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, partitioning. . Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data. . Experience in the technical and functional system upgrade from BW 3.1C to BI 7.0 (NW2004s). Business Area: FI-CO, SD, MM, PP. . BI operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports. . ABAP - Reporting, User Exits, Customer modifications. Proven success in performing all reporting features, OLTP Extraction from SAP R/3 into BW using different extraction structures. Functional expertise in SD, MM and FI/CO. In-depth knowledge of reporting flow from R/3 to SAP BW.Production Support: . ABAP - Reporting, User Exits, Customer modifications. Specifications for Documented functional and technical production support and project enhancements. . Worked with the project team and multiple end-users to resolve accounting issues and identify opportunities for business process improvements. Provided production support in BW reporting. . Participated in identifying and implementing continuous business process improvements in planning, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities. . Assisted in ongoing communication to SAP and BW end-users on business process and systems changes, and issues resolutions.Education . Master of Computer Application, Anna University, India. . Bachelor of Science (Computer Science), Kerala University, India.Domain Expertise . Retail Domain - Successfully working on projects for COACH . Pharma Domain - Successfully completed projects for ALLERGAN . Manufacturing domain- Successfully completed projects for Schneider and Stanley Works . Finance Domain - Successfully completed projects for World BankKey Strengths . Consulted clients from different industries such as Financial Services, Retail, Pharma and different geographies. . Performed gap analysis to optimize business process while working as a Subject Matter Expert as a part of a solutions team. . Designed business requirements and technical design documents, provided solution that resulted in cost saving for client. . Identified and tested SAP business process controls in collaboration with FI, CO, and MM consultantsKey Software Skills/Tools:|Tools ||Programming Languages: ABAP & SQL ||ERP : SAP ECC 6.0, ECC 5.0, SAP R/3 4.7 ||ETL Tools: SAP BW 7.3, Informatica ||Data Modelling: HANA Studio ||Databases: Oracle 9i/8i, SQL Server and MS-Access. ||SAP Functional Areas : FI , SD , MM ||Operating System : Microsoft Windows 98/NT/2000/XP/7, Unix |Professional EXPERIENCE:Working as SAP BW/BO Consultant in COACH, New York from January 2016 totill date.Worked as SAP BI Consultant in Allergan, California from January 2015 toDecember 2015.Worked as SAP BI Consultant in MMG, Melbourne from January 2013 to December2014Worked as SAP Technical Consultant in Schneider, Bangalore from November2010 to December 2012Worked as SAP Technical Consultant in World Bank, Kochi from July 2009 toOctober 2010Worked as SAP Technical Consultant in Stanley Works, Bangalore from August2006 to June 2010|COACH ||January 2016- Till date |Coach is a New York-based luxury fashion company. Coach is known foraccessories and gifts forwomen and men, including Handbags, men's bags, women's and men's smallleather goods, footwear,outerwear, ready-to wear, Watches, travel accessories, scarves, sun wear,fragrance, jewellery, and otheraccessories.The project involves implementation on SAP BW on HANA. Also there wererequirements for building multiple BOBJ Executive Dashboards and Reportsusing the latest BOBJ tool (Design Studio).SAP BW HANA Consultant - Responsibilities: . HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements. . Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions. . Developed data flows and work flow using BODS. Worked on RDS to implement ETL Replication. Used Rapid Marts for SAP Road Map. Developed ETL transformation. . Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication. . Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart. . Created Universes on top of HANA calculation views and developed the Web reports and dashboards using IDT Information design tool. . Develop SQL scripts and functions for complex reusable scenarios in HANA. . Consumption of HANA information Models in BW by creating Composite and Transient Providers. . Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI. . Designed Web Reports Using Be Queries BICS Connection. . Designed developed cross tab reports, reports with sub reports linked unlinked and charts using Crystal Reports. . Had created reports using SAP BO Analysis Office 1.3 and 1.4 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel. . Reports Developed in this Project: Headcount Change in Staffing Level, Human Capital Management Monitor, Leaving Rate, Percentage Distribution of Leavers, Vendor spend analysis . Worked with LCM Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA and Prod . Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression testing, User Acceptance Testing UAT and documentation. . Architecting reporting requirements into technical design and development. Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards. . Created Info objects, DSO's, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean- up activities for the pre migration of BW on HANA implementation. Optimized BW cubes for HANA purpose. . Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA. Interacted with the Finance Business Analysts on a daily basis for their KPI & report requirements. Managed, Configured and Performed Transports between multiple BW environments. . Used Real Tech Transport Manager to perform transports. Maintained Z tables in BW to load Master data. Performed BW Master and transaction data loads on required basis. Created and scheduled Process chain for daily Delta loads. . Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production. |ALLERGAN ||January 2015 - December 2015 |Allergan is an American worldwide pharmaceutical company, focusing onophthalmic pharmaceuticals, Dermatology, neuroscience and cosmetics.Allergan manufactures markets and distributes more than 55 drugs in US.SAP BI /BW HANA Consultant - Responsibilities: . Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Proof of Concept POC. . Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, User stories, business rules for finance, sales and marketing domains. . Worked on conducting workshops to go over the new tasks with the system administrators and SAP Basis Consultants and also created an application by application migration approach from SAP BW to HANA system. . Using Import selective Meta data for SAP BODS 4.1 imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server SLT. . Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle into HANA database. . Developed jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions. . Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications. . Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data. . Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table data foundation to modelled dimensions attribute views , selected attributes and measures. . Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views. . Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO . Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository. . Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio. . Extensive working experience with different components of Designer Studio like Charts, Selectors, Text, Maps and Containers. . Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting. . Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider. . Enabled Business Objects Explorer to search data present in HANA. . Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence Webi , BO Analysis.|MMG ||January 2013 - December,2014 |MMG Ltd is a mid-tier global Resources Company which explores, develops andmines base metal deposits around the world and head quartered in Melbourne.SAP BI Consultant - Responsibilities: . Interacted with Business stake holders to know their business needs and effectively develop and modify Universes and Reports. . Defined row level security at universe level as per user entitlements, this enabled IT to create one report and make it available to global users based on their rights. . Integrated SAP BW with Business Objects and extracted data from SAP Data sources. . Provide reporting solutions using 2 OLAP Universes using BOE XI 3.1 - Universe Designer on top of SAP BEx queries, enabled OLE DB for OLAP and Info Cubes / Multi Providers, created/modified classes, objects, dimensions, measures and details. . The development of a total of 6 reports using Web Intelligence, according to functional specification and write the technical specification for each development. . Provide complex reports solutions in Web Intelligence using advanced functionality like report level prompts, scope of analysis and ranking data source from DB2. . Architect and developed a Campaign Marketing Dashboard that measures leads and contacts for different marketing channels. Implemented end to end solution, starting from the Universe, to the Web Intelligence dataset layer, to the Xcelsius Dashboard. . Follow the company procedures to migrate from the development environment to QA quality assurance all the universes and reports until the production server. . Provide training to the final users about the correct use of the new business Intelligence elements. . Involved in Realization, Final Preparation, Go-Live and Post Implementation, developed production support plan and resolved production support issues. . Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering, analysis and creation of best practice architecture. . Enabled Single Sign-On SSO feature, imported SAP BI roles into Business Objects, enabled automatic imports of SAP BI users, managed users and groups in Central Management Console CMC. . Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file data sources. . Created 5 Universes using Universe Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts using SAP BEx queries. . Involved in data extraction from SAP R/3 system, Cognos and Non-SAP systems and scheduled Full Loads / Delta Loads using Process Chains. . Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager. . Worked with SAP BASIS team in regards to moving Transport Requests and worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles. . Worked with SAP Basis and BI teams and involved in upgrading the SAP BI support package to SP21, installed Business Objects Enterprise XI 3.1 Integration for SAP Solutions Fix Pack 1.x. . Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression testing, User Acceptance Testing UAT and documentation. . Worked with Network Administrators and setup .Net framework on VMware with Windows 2003/2008 Server, creation of SQL server 2008 databases, ODBC connections and Java Run-time Environment for Business Objects installation.|Schneider Electric Systems ||November 2010 - December 2012 |Schneider Electric has transformed itself into the global specialist inenergy management, moved into electricity and automation management.Schneider Electric has become today the solution provider that will makethe most of your energy.
SAP Technical Consultant - Responsibilities: . Providing application support for SAP ECC 6.0(SD, MM, PM, PP, FI & CO) . Defining requirements and converting functional specifications into technical requirements
. Assisting SD, PP,PM, FI-COPA consultants on application issues . Performance tuning and quality control of developed objects as per the defined guidelines . Issue and Resource management . Outbound Interface for feeding Finance data to PI System, Outbound/Inbound interface for Vendor Account Reconciliation.
. Managing release cycles, categorizing issues, designing and defining support strategy and documentation templates, designing and defining naming conventions, quality control and development guidelines. . Designing, Defining and Validating the mechanism for transporting objects from Development into Quality and Production environments
. Designing, Developing and Enhancing Interfaces, Reports, Smart forms, BAPIs, IDOCS, Modules Pool, BADIs, User Exits . Analysis of change requests, Review of functional specification and code, mentoring individual team members.|WORLD BANK ||July 2009- October 2010 |The World Bank is a United Nations international financial institution thatprovides loans to developing countries for capital programs. The World Bankis a component of the World Bank Group, and a member of the United NationsDevelopment Group.SAP Technical Consultant - Responsibilities:CFP is designed to provide concessional and grant financing for World Bankin support of country and global environment efforts. The CFP applicationconsists of certain custom developed modules which are integrated with SAPFI module.
Responsibilities involved understanding business requirements fromfunctional consultants and/or business users, converting businessrequirements from functional specifications into technical specifications,testing programs developed by ABAP team members. I was also responsible fordesigning and developing the customized module pool programs and ALVreports, for the custom module related to FI that deals with Installments,Receipts allocations, commitment and Disbursement of funds.
|Stanley Works ||August 2006- June 2010 |The Stanley Works, is a Fortune500 American manufacturer ofindustrial tools and marketer of tools, hardware and specialty hardwareproducts for home improvement, consumer, industrial and professional use.Stanley is a global manufacturer, with production facilities in 17 U.S.states and 14 foreign countries, and is one of the world leaders in handtools.
SAP Technical Consultant - Responsibilities:This project is an implementation project which includes writing technicalspecification (TS) for the respective functional specification (FS),development of object with respect to TS, providing Unit Test Cases (UTC).
As a development consultant, I am responsible for developing andmaintaining Enhancements, Conversions, Forms, Reports, User Exits, andBADI's and interfaces in SD, PP, MM, WM, QM, FICO modules. Myresponsibilities also include, understanding business requirements fromfunctional consultants and/or business users, converting businessrequirements from functional specifications into technical specifications,testing programs developed by ABAP team members. Performance Tuning andoptimization of code, Code Inspector and Extended program check are alsodone as part of development.[pic] |
