SUMMARY:

• 11+ years of Professional experience on SAP HANA.
• SAP HANA 2 full implementations and Business Objects (Data Services, Universe Designer, Web and Crystal Reports, BO Explorer, Visual Intelligence).
• Good Knowledge of SAP BO and SAP HANA.
• Experience in SAP HANA data modeling using Attribute View, Analytical view and Calculation view
• Experience in SAP HANA Data Provisioning using SAP LT Replication Server (SLT ) and Data services
• Knowledge of SAP HANA security including User Management, Roles and Privileges
• Strong experience as Business Objects Administrator including installation, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Good Knowledge in Direct Extractor Connections.
• Experience in CMC Administration activities like creating and managing repositories, monitoring/granting, permissions and rights to users, user groups through Central Management Server.
• Worked on migration of the Business Objects from lower versions to XI R2, 3.0, 3.1
• Worked on Business Objects with Databases like SQL Server 2000/2005, Oracle, Sybase, flat files, Teradata and DB2.
• Experience in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuates critical business controls.
• Expertise in creating reports with features like Drill down, Slice and Dice, Ranking, Alerts, Section and Grouping.
• Experience in Creation of Bex queries on BI 7.0, 3.5 (Reporting)
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.
• Experience in gathering, documenting user requirements and end - user .

PROFESSIONAL EXPERIENCE:

Professional Experience

SAP HANA Developer & BI Consultant

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support
• Report development on manufacturing modules like COPA, SD,FSCM, SFDC
• Worked in Agile and Water Fall Project management approaches
• Managed Offshore and Onshore team model
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements
• Worked extensively on Data Modeling design like developing HANA Objects
• Created many complex and customized reports for specific business requirements
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture
• Worked with interface team for development of interface from SFDC to HANA using Dell Boomi, mainly involved in identifying source information based on requirement and creating F-spec document to Interface team.
• Involved in the architecture to analyze best use technology to replicate data in HANA and identified transformation rules of SFDC data
• HANA modeling on non - SAP source SFDC data.
• Designed, Developed and Maintained HANA models by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Hierarchies are implemented to support drill down reports
• Created self service HANA Models which satisfies multiple business requirements and can be used on different reporting tools like AFO and Lumira
• 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)
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies
• Monitoring and troubleshooting data loads

Environment: SAP Business Objects 4.0 and 4.2 (WEBI, IDT, Analysis for Office, Lumira), SAP HANA (SPS 6,9.10), ECC (COPA, SD, FSCM), SalesForce - SFDC

Confidential - Chicago, IL

SAP HANA Developer

• Good understanding of various components of SAP HANA
• Created Technical specifications and standard modeling documents for HANA .
• Involved in business and blueprint gathering discussion.
• Developed complex calculation view using SQL and CE-Function.
• Worked on creating Attribute Views, Analytical Views & Calculation Views
• Developed data models for the operations, PP, MM, Quality management tables in HANA .
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
• Developed the security model, Naming conventions and folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports, and dashboards from HANA data sources.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Created Users, Roles, privileges, Packages, schema as part of HANA security and development.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Provided guidance and advise to SAP customers, Pre - sales and Solution Architect resources on the development of HANA Solutions.
• Translated business requirements and high level designs into a suitable technical design using HANA.
• Determine the size and scope of technical developments of HANA Projects.
• Identified the skills, roles and capabilities required to deliver the technical elements of projects and estimated the required effort.
• Leveraged knowledge of data warehouse and software developments technologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Performed UNION & INTERSECTION between views to represent business cases.
• Expert in understanding of the complete Architecture (Database, Data Loading, Data Modeling & Administration).
• Good knowledge of SAP BO Data services & SLT Replication Methods.
• Connected to IMCE from reporting tools through Universe and direct interfaces to generate the reports.
• Created and design Universe for reporting from information models.
• Provided knowledge transfer to IT Staff.
• Developed and foster a collaborative working relationship with clients.
• Worked collaboratively with project managers, SAP Offshore Consultants and partner consultants to develop consulting and project methodology, techniques, tools, and solutions.

Environment: BODS 4.0, BOBJ4.0, HANA 1.0 SP5/SP08, SAP BW 7.3, SAP ECC 6.0, Linux SAP Business Objects 3.1 and 4.0 (Crystal Reports Enterprise, WEBI, Dashboards IDT, BODS, Visual Intelligence), Information design tool and HANA, SAP ECC

Atlanta, GA

Sr. BOBJ/HANA Developer

• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed, Developed and Debugged various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views
• SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting - Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool - Creation of Data Foundation, Universe for HANA reporting.
• Designed and executed migration plan to migrate data from existing SAP ECC and CRM servers to the SAP HANA database. Configured SAP HANA Studio and BOBI reporting engine to prepare a POC for subsequent use in customer projects and engagements.

Environment: SAP Business Objects 3.1 and 4.0 (Crystal Reports Enterprise, WEBI, Dashboards IDT, BODS, Visual Intelligence) and HANA, SAP ECC.

New York, NY

SAP HANA & BO Developer

• Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Created analytical and attribute views and complex model by using SQL script in calculation views
• Created analytical privileges and procedures of modeling
• Design and created universe for reporting from information models
• Working knowledge and understanding of complete architecture (Data Loading, Data Modeling and Reporting)
• Extensively created and maintained complex Business Objects Universes and Reports using Designer and Reporting modules like Crystal Reports XI, Desktop Intelligence and Web intelligence.
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Dimensions
• Strong Integration skills between External Portals with SDK and Xcelsius Dashboards.
• Console and crystal Enterprise Environment.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.

Environment:: HANA Studio, Information Design Tool, Business Objects XIR2 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, Info View, Dashboard Manager, QAAWS, Import Wizard), Business Objects 6.5.1(Supervisor, Designer, Reporter, Web Intelligence), Xcelsius 2008, SQL Server 2000, Sybase, MS Access, TOAD, and Windows 2003 Server

Confidential, MN

SAP BW/ HANA Developer

• Point of contact for all the hana modeling development in MTO module.
• Created reports in OLAP analysis
• Created analytic and complex calculation views using SAP HANA modeler.
• Used currency conversion from local to USD in calculation views.
• Mapping the input parameters to underlying views and pushing filters to foundation tables.
• Created composite providers and analytical privileges.
• Imported analysis authorizations to HANA as analytical privileges.
• Transported development objects to Quality system using developer mode.
• Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables.
• Information Modeling in SAP HANA and Report Generation for Sales and Distribution module towards Comparative Analysis for pricing conditions.
• Worked on SAP HANA transports, Delivery Units and Schema Mapping.

Environment: SAP BW 7.4 on HANA, SAP HANA 97.02, SAP BO

Business Objects 6.5, Universe Designer, Web Intelligence, Desktop ntelligence, Infoview, Import Wizard, Crystal reports, Oracle, PL/SQL, TOAD.

Confidential, Philadelphia, PA

Role: HANA Developer

• Defined Account Groups, Number Ranges, Posting Keys, Document Types, Posting Period, Fiscal Year Variants, and Field Status Groups.
• Interacted with Client to Configure Vendor/Customer Groups, Set up Vendor/Customer Master Records and Assign Reconciliation Accounts in G/L
• Extensively worked on Customer Master Records, Client Specific Payment Terms, Lockbox, Dunning and Payment Methods.
• Worked on Customer Analysis including Days in Arrears, Payment History, Cash Discount Overview and Credit Limit Display.
• Define Tolerance Groups, Tolerances for Employees, Customers and Vendors and Maintained Initial settings for Recurring Entries.
• Configured AP with manual and Automatic Payment Program to do Check, ACH and Wire Payment.
• Configured Credit Management and Defined Credit Control Area, Preliminary Settings, Groups, Risk Categories, Days in Arrears, Line Layout, and Reconciliation Accounts
• Configured House Banks, Bank Accounts, GL Structure, Posting Rules for Automatic Assignment.
• Configured and tested the Lock Box program for Account Receivables in BAI2 Format.
• Configured AR - Dunning process, Interest calculation on Account Balances and Line Items
• In Asset Accounting, defined chart of depreciation, various depreciation areas and depreciation keys, Asset Classes, number ranges, revaluation settings etc. Also, defined transaction types for various business transaction likes acquisition, retirement, transfers and account determination.
• Configured asset master records, chart of depreciation and asset sub ledger.
• Configured controlling area, operating concern and maintained versions.
• Configured Accounts Payable (AP), Defined customer/vendor account groups and created customer /vendor master data

Confidential, Chicago, IL

• Involved in debugging code. Made changes to the existing code in Broad Vision to eliminate bugs The fixed code was thoroughly checked using various methods. The client did the final testing and approval of the code.
• Enhanced code where browser detection took place. If the user's browser was not capable to handle the graphic content of the website it was directed to the appropriate website.
• User was able to download a browser which was capable to handle the content of the website.
• Assisted in implementing and designing of various documentation regarding the project. From gathering client requirements and specifications to creating the Detail Design Solution (DDS) document.
• Developed JSP files using Broad Vision technology. Files performed various e-commerce functions which helped the client's legacy system to integrate with it's current web-based application.
• Managed foreign exchange activities, included hedging of contract exposures and funded of foreign operations
• Assessed the world markets for upcoming trends, analyzed exchange rate trends and forecasted exchange rate movements
• Dealt in foreign exchange with banks and negotiated Forex pricing for Treasury products to Corporate and Financial Institution clients
• Covered large dealing transactions in inter-bank foreign exchange markets to minimize risk and tracking customer orders on the intraday and overnight markets
• Developed & maintained trading relationships with banks of different size
• Worked closely with retail/sales unit to maintain the customers & providing quality services
• Maintained relationship with other exchange houses/banks through better quotes & servicing
• Successfully developed and implemented the Standard Operating Procedures for Treasury Unit
• Introduced forward deal booking concept, order placement for customer on international trade screen to improve customer experience & relationship and enhanced business considerably
• Successfully established the Pak rupees draft business improving the company’s profile besides enhancing revenue by up to USD 30 million on a monthly basis

TECHNICAL SKILLS:

SAP: BI 7.0, SAP HANA

ERP: SAP R/3 FI/CO 4.6, 4.7EE, ECC 5.0, ECC 6.0

Operating systems: UNIX, Linux, Window 95/98/2000/XP, 2000/2003 Server

RDBMS: Oracle, MS-SQL Server 2000/2005, MS Suite

Tools & Utilities: Crystal Reports, Business Objects, WEBI, Dashboards

Reporting Tools Languages: SQL*plus, PL/SQL, VB Script,COBOL,VB .net,ASP .net