PROFILE SUMMARY

• SAP Certified SAP Netweaver BI7.0 consultant with more than 13 years of experience in the fields of Business Intelligence and Data Architecture which includes 12 years of experience working with BI and EIM tools from SAP
• Business and system integration professional with proven track records of analyzing, designing and/or developing best practice business changes through technology solutions
• Proven experience architecting Global Business Intelligence/Analytics capabilities that advance large global corporations toward fact - based decision making organizations, including: Master Data Management, Information Management, Data Governance, Global Platform Technical Architect and ETL
• Excellent experience in analyzing and designing analytics solutions and associated business processes enabled by SAP HANA Suite and Analytics
• Multiple lifecycle deployment in SAP in traditional DB and in SAP HANA and demonstrated ability to lead and develop teams
• Experienced in gathering reporting and data definition requirements and leading/directing/managing resources to achieve these objectives and delivering solutions with reporting technologies to meet client requirements
• Expertise in SAP BW in traditional DB and SAP BW on HANA which includes extraction, modeling, reporting, security and life cycle management
• Expertise in driving innovation and development efforts for SAP BW on HANA; data modeling with LSA++ architecture using ADSO, composite providers, logical models, process models and enterprise models
• Expertise in BW on HANA hybrid scenarios
• Ability to translate client business requirements and convert into blueprint for designing HANA models
• Expert knowledge of data warehousing and business intelligence design principles
• Expertise in designing, defining and optimizing HANA information models for data provisioning
• Very strong experience with SQL Script, PL/SQL, Stored Procedures, Function Calls, Designing tables, data loads, Building HANA Views (Attribute, Analytical & Calc Views)
• Expertise in performance tuning the HANA environment
• Experience in data provisioning using SAP SLT system
• Experience in HANA LCM including managing transports of objects in HANA using export/import, delivery units
• Experience in executing DR, backup and recovery tasks with the help of infrastructure team
• Experience in HANA security model
• Experience in day to day HANA administration activities
• Expertise in SAP Data Services overseeing the mapping of data sources, data movement, interfaces, and analytics, ensuring data quality
• Expertise in SAP Business Objects BI suite(IDT, Webi, Analysis Office, Lumira, Xcelsius, Design Studio) with knowledge on admin responsibilities
• Strong hands on experience in designing, developing and supporting interactive Tableau reports/dashboards
• Strong hands on experience in Tableau server administration including security configuration
• Ability to demonstrate end to end process knowledge for core SAP modules like SD, MM, FICO, COPA, APO
• Familiarity with SAP S/4 HANA
• Proficiency in ASAP and ACTIVATE methodologies of implementing SAP projects
• Strong project management experience managing large software applications, gathering internal and external client requirements for the management of those applications in implementation and production settings, and turning those requirements into client-specific, compliant, cost competitive solutions
• Strong experience various aspects of project management such as project planning, scope management, time management, cost management, quality management, resource management, risk management, communications management, stake holder management
• Project lifecycle delivery skills, project management support, methodology, documentation, testing and post-production support experience
• Proven leadership qualities by leading multiple projects of varying scope and size in capacities such as Project Manager, BW Architect, BW Analyst, BW Lead, Onsite Coordinator etc.
• Effective verbal and written communication skills and have demonstrated ability to interact with and advise clients at senior levels within both business and IT settings
• Strong Technical, Analytical and Communication Skills and a very good team player with excellent leadership qualities.

TECHNICAL SKILLS

Key SAP Skills: HANA, BW, BW on HANA, ECC, APO, IBP

Key BOBJ Skills: IDT, Webi, Lumira, Analysis Office, Design Studio, Xcelsius, Cloud for Analytics, Predictive Analytics

Key ETL Skills: Data Services, SDA, SDI/SDQ, SLT, HCI

Key Tableau Skills: Tableau Desktop, Tableau Server

Key DW Skills: SAP BW, SAP HANA, SQL Server

Programming Language: ABAP, SQL, PL/SQL, T-SQL

Functional Area: SD, MM, PP, FICO, COPA, CRM, SRM, HR, Retail, APO(DP, SNP, GATP), IBP, S&OP

Industry Experience: Retail, Manufacturing, Pharmaceuticals, Semiconductor and Apparel/Footwear

BI Skills: Familiarity with Big Data, Hadoop, Spark, Python, Predictive Analytics, Machine Learning

PROFESSIONAL EXPERIENCE

Confidential

Sr. Solutions Architect/Sr. Business Analyst

Responsibilities:

• Prepare the scope of the integration project
• Create architecture of the data integration project and create a comprehensive data mapping document
• Understand the data related business process on Microchip side and align Atmel data along with it
• Use SAP BODS to create multiple batch jobs to migrate data from Atmel systems to Microchip systems. BODS was used to migrate data from various sources like SAP, Model N, Oracle, SQLServer to the EDW of Microchip
• Use SAP BODS to cleanse and transform the data as per the requirement of the target system
• Work on schedule management, escalation management, issue resolution
• Manage resources at the various phases of the project with the help of resource leveling
• Prepare dashboards for reporting to the PMO
• Understand the potential risks at the appropriate time and take steps to mitigate
• Prepare the plan of cutover and go-live
• Monitor the systems post go-live for any issues and take necessary steps to resolve the issues

Confidential

Sr. Solutions Architect/Sr. Business Analyst

Responsibilities:

• Leading and managing multiple analytics projects using SAP BW 7.4, HANA 1.x, Tableau 9.x and Business Objects 4.x
• Managing and enhancing enterprise data warehouse which receives data from a variety of systems such as Salesforce.com, Service Now, ModelN, ECC, BPM etc
• Developing and establishing governance for overall enterprise reporting architecture, processes, procedures and standards
• Solutioning and designing all the reporting and dashboarding projects using available tools which could be very diverse in terms of combining data form multiple sources
• Coordinating with business community at various stages of the project delivery lifecycle
• Supporting the existing installations and resolving the issues in a timely manner
• Working on analyzing, blueprinting, developing, testing and delivering various change requests from different business groups
• Looking for opportunities where processes can be automated using SAP BI and working with business executives to create projects out of it
• Supporting reports/dashboards which get published to senior leadership every week/month/quarter
• Supporting business in monthly/quarterly closing
• Educating and demonstrating various BI capabilities to business time to time
• Organizing and conducting user trainings upon request
• Reviewing existing BI offerings and finding out ways to improve them
• Supporting business relationships with various vendors and building upon the BI capabilities
• Evaluating various offerings from vendors in helping the CIO in the selection process
• Working with multi-cultural team spread across the globe
• Working on the integration after a successful merger of Atmel with Microchip

Confidential

BI Lead/Onsite Coordinator

Responsibilities:

• Lead a 20 member team located at onsite and offshore
• Responsible for delivery of all the interfaces and reports
• Responsible for requirement gathering, blueprinting and solutioning
• Responsible for the architecture and design of the end to end solution
• Responsible for managing the project in terms of deliverables, timelines, efforts and commercials
• Responsible for coordination between onshore and offshore teams
• Responsible for managing client expectations and issue resolutions
• Responsible for utilizing BW 7.4 on HANA expertise for solution designing and client education
• Responsible for solution designing for reports using BO 4.1 tool sets and based on requirements
• Playing the roles of SME, POC between multi-vendor and cross functional teams
• Experience in working on the latest version of BW(BW 7.4 on HANA) and BOBJ(BO 4.1)
• Actively involved in client engagement and account mining
• Actively involved in other sales pursuits and business developments

Confidential

Architect/Manager - BI Track

Responsibilities:

• Lead a 20 member team located at onsite and offshore
• Responsible for project management, resource management of the BI track
• Involved in overall program management, budgeting, resource planning, scheduling, risk management
• Involved in setting client expectations and managing escalations
• Responsible for the design of the overall architecture of the implementation
• Performed the role of a solution architect for the client to layout the roadmap to achieve the short-term and long term objectives
• Conducted the requirement gathering and blueprinting sessions with the business users from various streams
• Designed the complete technical architecture for 100 BW reports.
• Involved in hands on activities in implementing and troubleshooting during the implementation phase.
• Guided the team to overcome various roadblocks in the development phase.
• Responsible for the coordination between onsite and offshore team and completion of the development phase by delivering all the reports on time for testing
• Responsible for the successful completion of various testing phases with closure of BW defects
• Responsible for cutover planning and go-live for BW in accordance with ECC, APO and CRM
• Instrumental in pre-sales, pursuit and win of the AMS contract with the client

Confidential

Senior Consultant - SAP BW/BOBJ

Responsibilities:

• Help the customer in preparing functional specifications by making them aware of the product features and limitations in terms of conducting workshops and presentations.
• Design the overall architecture and create design documents and technical specifications out of the functional specifications provided by the users.
• Lead the BI track in parallel to other functional and technical tracks and drive the team to complete the design and implement the solution end to end.
• Performed a lot of customizations along with the standard BW contents. Various customizations required ABAP coding in terms of datasource enhancements and transformation routines.
• Coordinate between the customer and the development team.
• Deliver the project in an onsite-offshore model and ensure seamless communication and transition between the onsite and offshore teams.
• Coordinate between different tracks of development and take care of the dependencies.
• Analyze the existing legacy system and recommend the customer on possible improvements.
• Prepare the system towards going live and leading post go-live support.
• Oversee the daily data loading and monitoring activities and recommend steps for performance improvement.
• Look after the customer tickets and incidents and provide a solution within the timeframe as per the SLAs.
• Educate the end users on the newly implemented solution and improve the usage.
• Handover and knowledge transfer to the application support team.

Confidential

Senior Consultant – SAP BW/BOBJ

Responsibilities:

• Functional requirement gathering from the business users.
• Creating technical specification out of functional specifications.
• Aligning report elements from the functional spec to actual technical data elements in the landscape and creating DAT (Data Alignment Tool).
• Understanding the BW landscape and accurate mapping of master data elements.
• Sourcing OTC, FICO and RTC data from BW by leveraging SD, COPA, MM data objects.
• Creating Business Objects Universe, with the help of Information Design Tool (BI 4.0), on top of Teradata semantic views.
• Working on complex universe scenarios such as aggregate awareness, index awareness, detecting aliases and contexts, working on parameters and list of values.
• Exposure to multisource universe and OLAP universe built on Bex queries and BW info providers.
• Creating webi reports using Interactive Analysis Desktop (BI 4.0).
• Working on complex webi scenarios such as drill down, complex ranking, reports with multiple data providers, creating report templates, applying authorization and security.
• Interacting with the business users for effective realization of the requirements in the reports.
• Conducting unit testing, functional acceptance testing, system integration testing, and user acceptance testing.
• Involvement in end user training and post go-live support.

Confidential

Senior Consultant

Responsibilities:

• Managing existing landscape consisting of BW and BOBJ systems. Also managing existing dashboards which include looking after the existing Bex reports and data loads in BW system as well as the crystal reports and xcelsius dashboards in BOBJ system.
• Requirement gathering for new dashboard requests from different clients and preparing a scope and effort estimation. Creating blueprint and design document for the new requirements. And then implementation and development of the dashboards.
• The implementation includes creating a BW data flow, creating bex reports, creating crystal reports out of bex reports and then using crystal reports to create xcelsius dashboards with the help of Live Office.
• BW Implementation normally includes creation of generic data sources, modeling the data flow by creating various BW objects and then creating bex queries on top of the newly created infoprovider as per the requirement.
• Establishing automated data load by creating process chains.
• Administration and transportation of objects in both BW and BOBJ landscape.
• Assigning authorization to different users and user groups.
• Involving end users in testing of the final product.
• Publishing xcelsius dashboards to the central portal for Managed Services.
• Frequent communication with team members and stake holders scattered across the globe.

Confidential

Senior Consultant

Responsibilities:

• Involved in the presales for this project and did a presentation on SAP BW features and functionalities to Oracle and how we can support them in enhancing their product.
• Role of an onsite coordinator position at the customer’s location.
• Understanding the customer’s requirement and passing on to the offshore team.
• Stabilizing the existing BW support via XMLA by trying out all possible BW functionalities with OBIEE.
• Supporting Oracle with their customer issues and resolving them.
• Understanding the OLAP interface and MDX support for SAP BW.
• Developing the BW adapter using the OLAP BAPIs and the RFC SDK provided by SAP.
• Developing advanced BW functionalities support such as currency conversion, time dependent masterdata support, reporting variable support etc.
• Creating test cases for the new product enhancements for OBIEE.
• Creating white papers on various BW-OBIEE supports which will be used by Oracle in their customer engagements.
• Working in the onsite-offshore model and handling the deliverables from the customer and delegating tasks between onsite and offshore.

Confidential

Senior Consultant - BI

Responsibilities:

• Part of the team carrying out the integration process.
• Implementing TVAS(Teradata Virtual Access Solution) in the project
• Identifying the functional area in the client’s business to be covered.
• Designing and creating the required BW virtual cubes.
• Including the new virtual cubes in the existing Multiproviders.
• Designing the semantic views (with Star Schema of Snow Flake Schema) on top of the Teradata data warehouse.
• Implementing business logic in the semantic views.
• Mapping the cube fields to the semantic view fields using TVAS GUI.
• Establishing the joins between different views in TVAS GUI.
• Doing Unit Test and Integration Test before transporting to production environment.
• Working with the customer to validate the existing BW queries.
• Working on the production issues after the go-live.

Confidential

Senior Consultant - BI

Responsibilities:

• Leading the SAP BW portion of the project.
• Creating an architectural design for the BW data model and how it should fit into the product.
• Working closely with the solution managers of SAP to understand the requirement and including those in the design.
• Understanding and making use of SAP Retail framework, BW business content of the Retail industry and their behavior.
• Understanding the concept of and working on POS Data Management (POSDM), the Task Framework and its use to populate Retail BW datasources.
• Designing new datasources in the line of existing SAP Retail data sources with PUSH mechanism.
• Identifying existing Business Content objects to be used in the model and designing new BW objects as well.
• Designing the entire data model from datasources to queries.
• Designing BW queries to replicate the behavior of the existing Fraudwatch application.
• Designing web templates to be created in WAD.
• Preparing design and architectural document for each module of the project.
• Educating the team to carry out the development process.

Confidential

Senior Consultant - BI.

Responsibilities:

• Leading the three member team carrying out the integration task.
• Bridge between the EDW and BI team.
• Worked predominantly on Financials and SD extractors.
• Enhanced the SD extractors (2LIS *) and Financials extractor (0FI GL 4), as per the customer requirements, to include new fields.
• Transformed the FI extractor in order to enable it for a minute based delta extraction rather than the standard daily one delta extraction capabilities.
• Replicated the New GL extraction with the creation of generic datasources and the standard New GL datasource (0FI GL 14) was not available in with the support pack used by the customer. Created generic extractors on the FI tables FAGLFLEXA, FAGLFLEXP.
• Created generic CO-PA extractors on tables COEP and CE4XXXX in order to make the COPA data available.
• Worked on BI7.0 Infosources, Transformations and Infopackages to pull data from ECC. Activated business content for the data flow and created new data flow as well.
• Worked on delivering data to Teradata-EDW by creating Openhub Destinations and Data Transfer Processes. The data was delivered via IBM Information Server as a third party destination for the open hub destinations.
• Worked with the EDW team to make them implement the Delta functionalities to leverage on the delta capabilities of each extractor.
• Work extensively on creating design documents containing the mapping details and the dataflow.
• Worked on TVAS (Teradata Virtual Access Solution). TVAS helps in creating BI queries on top of the data which lies in Teradata EDW. The process involves configuring the SAP Web Application Server, creating virtual cube in BI, mapping the virtual cube fields to the EDW data elements in TVAS GUI and creating queries in BI Query Designer.
• Worked on Report Report Interface (RRI) to create jump queries.
• Coordinating with the customer on each milestone to confirm that the project is on track and the deliverables match with the requirements.

Confidential .

Senior Consultant.

Responsibilities:

• Upgrading the existing customers to the latest CoD version.
• Setting up new systems for prospective customers.
• Supporting the existing customers by handling customer messages.
• Taking care of customer requests (Value Added Services – VAS) which were not delivered as part of the standard product.
• VAS activities include realizing the customer requirements, business blueprinting, effort estimation, getting customer sign off, VAS implementation, testing and delivery.
• Has successfully delivered 5 VAS projects till date and worked on proposals for few more.
• Worked with customers like Centrica, Goodrich, Fujitsu Aus, Australia Post, Panasonic, and Philips with direct interaction on a daily basis.
• Modeling Analytics applications in Visual Composer for different scenarios.
• Integrated Planning Real-time Data Acquisition
• Connecting BI system with Non-SAP system with using UD Connect
• Information Broadcasting with Exception Broadcasting with Alerts
• Integration of EP with BI.

Confidential

Development Specialist

Responsibilities:

• Getting the requirement from the Solution Management team, understanding the requirements and communicating to the team.
• Modeling and creating BI Objects like Info Objects, DSO, Infocubes, Multiproviders, and Infosets.
• Creating and managing dataflow using DTPs, Transformations and Infopackages.
• Creating Process Chains and Realtime Daemons to automate the data flow and to avail real time data.
• Preparing the historical data and uploading to the infoproviders.
• Creation of queries on top of the Info Providers using query designer.
• Creating Excel Based reports using Bex Analyzer.
• Creating Web Templates using Web Application Designer to show reports in portal.
• Displaying Reports on the web using Visual Composer.
• Communicating and reviewing the tasks with the SM and AP team.
• Troubleshooting the model if required.
• Creating SRM applications using Visual Composer in the area of Purchase Order Management, Invoicing and Purchasing Contract.
• Develop the functionalities using C language on Unix platform.
• Carry out unit testing, integration testing, and user acceptance testing.
• Support the live application and solve customer issues.
• Interact with the end-users to get new requirements.
• Mentor new team members.