OBJECTIVE:

• Creative, dedicated HANA,BO,BW Developer seeking a challenging position with advancement opportunity within a company which will utilize and further enhance my knowledge in IT.

SUMMARY:

• Some seasoned IT Professional around 6.7 years of experience.
• Extensive experience in full software project lifecycle implementations including the Requirements gathering, Design, Development, Testing, Performance Tuning, Implementation, Support, and, Developing Standards; Data Migration, Data Conversion, Data Quality, Basis Support, and Administration phases.
• Extensively Worked in Manufacturing, Supply chain, Energy& Utilities, Finance and Health Care domains.
• Has the ability to understand and transform complex business requirements into software ensuring applications are delivered on time, to specification, are scalable, performance optimized and maintainable. Ability to interact with End Users in Understanding the Business Requirements and also provide to end - users.
• A highly motivated individual who is always learning, able to work to tight deadlines, and who can communicate effectively with technical peers as well as business users.
• Excellent communication skills, can work independently and also as part of diverse teams, and can deliver under all circumstances.
• Experience of working in Agile Methodology from the last 4 Years.
• Over 6.5+ years of experience in Analysis, Design, Development and Migration of SAP Business Objects.
• Extensive experience in Business objects BO 4.2. Hands on experience of universe designing, BICS Connectivity, Business Objects Web Intelligence, Info view/Launchpad and CMC and Life Cycle Management.Experience in designing BO Webi Reports.
• Built all different types of reports like Details, Summary,CrossTab,Hyperlinks,Document Linking,Dashboards & extensive use of available functionality in Webi.
• Expertise in BO Report administration like organizing, publishing and scheduling using Center Management Console.
• Experience in Migration of reports using Import Wizard (In BO 3.1) and LCM jobs.
• Designing and maintaining Web Intelligence (WEBI) and Crystal reports.
• Designing and maintaining Universes using Information Design Tool (IDT).
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Web Intelligence Ad-hoc and canned reports.
• Created Universes using complex and advanced features from various Database sources including Oracle, HANA
• Efficiently mapped business requirements and processes to technical solutions.
• Expertise in designing Universes for Performance Management and Reporting needs.
• Experienced in developing Web Intelligence and Crystal Reports using different Data Sources.
• Expertise in dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.
• Expertise in developing dashboard using Xcelsius, Dashboard Designer using Live Office and QAAWS.
• Expertise in developing visualizations using SAP Lumira,Design Studio, Analytics on Cloud.
• Over 3.5+ years of experience in Design, Development and analysis of SAP HANA databases, Information models and security with 5 full sidecar implementations of SAP HANA.
• Good understanding of HANA, HANA live and HANA 2 Architecture.
• Data provisioning into HANA using SAP BODS, Flat files, SLT, SDA and SDI.
• Designing database Schemas, SQL Views, Stored Procedures and Tables (both column store and row store).
• Designing, validating, and activating Information Models - Attribute, Analytical and Calculation models using both Graphical and SQL scripts both on Native and BW on HANA.
• Designing Calculated Attributes, Variables, and Input parameters.
• Providing security and authorization on HANA objects by creating Users, Roles.
• Providing row level security by creating Analytical privileges.
• Designing Decision Tables with Update Values and Return Values.
• Partitioning tables with more than 2 billion records using Range/Hash/Round robin partitioning methods.
• Connecting to various databases such as Oracle 12C and SQL and creating Virtual tables using HANA Smart Data Access (SDA), Smart Data Integrator (SDI) and building models on top of virtual tables.
• Generating Auto Documentation of HANA models.
• Integration with BOBJ, Analytics on Cloud and SAP Lumira.
• Over 3+ years of experience in Analysis, Design, Development and Migration of SAP Business Warehouse.
• Responsible for creation and maintenance of standard and custom Info Sources, Info Objects, Info Cubes, and DSO Objects.
• Created Process chains and Meta chains for daily loads and Monthly loads of Transaction Data.
• Created various queries and extensively worked on Query Builder objects viz. Filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants.
• Created BEx reports where Formulas, selections, structures, exceptions, conditions, Currency translation, calculated key figures, restricted key figures and variables with user entry/default value customer exit and Replacement path.
• Support the on boarding and of BW Power Users. This includes providing technical of key BW toolsets such as BEx web analyzers, query designers, Business Objects and UAT on the developments done.
• Resource Planning
• SME of the knowledge management tools for the tower.
• Involved in daily activities status reporting to the operations manager and higher management.
• Played a vital role in productivity improvement initiative for tower and worked on POC’s for gaining new business.

TECHNICAL SKILLS:

Tools: SAP BO XI R3.1,BO 4.0, BO 4.1,BO 4.2, SAP HANA,SAP BW, Dashboard Designer, Analytics on Cloud, Crystal Reports, SAP LUMIRA, Tableau, QlikView, Hadoop.

Programming Languages: SQL, PLSQL, Java

Databases & Tools: Oracle 10g, SAP HANA

Operating System: Windows 2003/XP, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Technology: SAP Business Objects 4.1 &4.2, SAP Crystal Reports, SAP HANA, Oracle Db.

Senior Business Objects Developer/Programmer Analyst

Responsibilities:

• Develop new Reporting Functionality in BO WebI and Crystal Reports
• Defect fixing
• Reporting Expansion & Enhancements
• Create Analytics Structure for Adhoc Analysis
• Perform Research and Analysis for Ops and Strategy/P&E
• Production Reporting Monitoring
• Implement Best Practices for BI environment
• Provide support for BI Environment
• Power User & Report ; development of and deployment of
• Dashboard Development/enhancement

Confidential

Technology: SAP HANA, SAP BODS & Business Objects XI B4.1 & 4.2

PROGRAMMER ANALYST

Responsibilities:

• As part of CISCO Ready project my Roles and Responsibilities are to engage with the Business on daily bases and provide them the data.
• Based on the business needs need to get the data from different sources related to Sales as per day to day requirements.
• All the requests need to be addressed in 2hrs span of time from the time request has been received.
• Working on continuously on UAT system for accurate data and comparing with Production system for data accuracy.
• Designed ETL Jobs to load data from Oracle/Teradata system to HANA UAT and designed the same for HANA Production system to Business/UAT system.

Confidential

Technology: SAP BO 4.1, BO 4.2, SAP HANA, Hadoop, Oracle, Angular JS, SOLR,SQOOP

Senior Project Engineer /Technical Lead

Responsibilities:

• Management of all CMC content and tasks
• Reports and universes backup
• Developed the Universe objects
• Reviewed the Functional Specifications developed by BA’s and provided the Sign Off based on the technical feasibilities.
• Responsible for preparing Technical specifications and get the required approvals from Business
• Created 45 BO Webi reports based on the HANA Views as per the business requirement.
• Provided very detail level of Interactivity for the user to drill down the data which gives clear idea of analysis of the data that is available.
• Provided Hyperlinking to the tables in the report to navigate from one view to another view.
• Developed SAP HANA Data Model as per the Business Requirements and wrote the required PLSQL procedures for Reporting puprose and querying puprose wherever HANA direct Views are not possible.
• Gave user rich experience for UI from Standard JAVA Reporting Tool.
• Developed required HANA Views for SAP BW Model an BO reports.
• Responsible for Unit Testing, Product Testing, UAT and Production Go Live Support
• Have Strong Hands on experience on IDT for creating Universe based on HANA views
• Have Strong Coding Experience in IDT with which I have achieved more complex functionalities in a easier way.
• Coordinated with all the teams involved in product development and updated the Business on daily basis.
• Provided option to export Dashboard to Excel, PDF, etc
• Created user prompts, conditions and filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Developed reports with business objects functionalities like slice and dice, drilling operations.
• Hands on experience in Data Provisioning and replicating data from source system to HANA Database Using SLT and Business Objects Data Services.
• Experience inHANA data modeling with different views like calculation view, analytical view, attribute view.
• Ability to work on Decision tables, Analytical privileges.
• Created Variables and applied them as filters and also worked on various input parameters.
• Ability to work on currency conversion in Information models
• Creating tables, DB views, triggers, sequences and partitioning of tables.
• Have a good knowledge on column store, compression and delta merge.

Confidential

Technology: SAP BO, SAP BW and Dashboard Designer.

Senior Project Engineer

Responsibilities:

• Reviewed the Funcational Specifications developed by BA’s and provided the Sign Off based on the technical feasibilties.
• Responsible for preparing Technical specifications and get the required approvals from Business
• Created 30 BO Webi reports based on the Bex Queries as per the business requirement.
• Provided very detail level of Interactivity for the user to drill down the data which gives clear idea of analysis of the data that is available .
• Provided Hyperlinking to the tables in the report to navigate from one view to another view.
• Developed 4 very Complex Dashboards clubbing up 30 reports in 4 Dashboards for easier analysis of data and getting all the info in a Single shot.
• All the dashboards are based on real time data and data gets updated for every 30 sec’s which was not easy based on the available functionalities but I have given that approach by coming up with alternatives.
• Provided POP - UP functionality in Dashboards which is newly introduced to Business from my End.
• Developed BW Data Model as per the Business Requirements and wrote the required ABAP routines for Reporting puprose and querying puprose.
• Gave user rich experience for UI from Standard Reporting Tool.
• Developed required Bex Queries for SAP BW Model and BO reports.
• Resposible for Unit Testing, Product Testing, UAT and Production Go Live Support
• Coordinated with all the teams involved in product development and updated the Business on daily basis.
• Provided option to export Dashboard to Excel, PDF, etc

Confidential

Technology: SAP BW, Bex Designer, SAP BO, Xcelsius, Dashboard Designer

Project Engineer

Responsibilities:

• Created 10 BO Webi reports based on the Bex Queries as per the business requirement.
• Provided very detail level of Interactivity for the user to drill down the data which gives clear idea of analysis of the data that is available .
• Provided Hyperlinking to the tables in the report to navigate from one view to another view.
• Developed BW Data Model to tune the performance of the system and enhanced the system as per requirements.
• Gave user rich experience for UI from Standard Reporting Tool.
• Developed required Bex Queries for SAP BW Model and BO reports.
• Resposible for Unit Testing, Product Testing, UAT and Production Go Live Support
• Coordinated with all the teams involved in product development and updated the Business on daily basis.
• Provided option to export Dashboard to Excel, PDF, etc

Confidential

Technology: SAP BW, Bex Designer, SAP BO

Project Engineer

Responsibilities:

• Created 15 BO Webi reports based on the Bex Queries as per the business requirement.
• Provided very detail level of Interactivity for the user to drill down the data which gives clear idea of analysis of the data that is available .
• Provided Hyperlinking to the tables in the report to navigate from one view to another view.
• Developed BW Data Model to tune the performance of the system and enhanced the system as per requirements.
• Gave user rich experience for UI from Standard Reporting Tool.
• Developed required Bex Queries for SAP BW Model and BO reports.
• Resposible for Unit Testing, Product Testing, UAT and Production Go Live Support
• Coordinated with all the teams involved in product development and updated the Business on daily basis.
• Provided option to export Dashboard to Excel, PDF, etc.

Confidential

Technology: SAP BW, Bex Designer, SAP BO and Xcelsius 2008,Dashboard Designer

Project Engineer

Responsibilities:

• Created 10 BO Webi reports based on the Bex Queries as per the business requirement.
• Developed 5 Dashboards with 30 KPI’s for each Dashboard based on the Webi reports created.
• Provided very detail level of Interactivity for the user to drill down the data to nearly 5 levels which gives clear idea of analysis of the data that is available in Graphical Format instead of going to reports and verifying line by line out of huge data.
• Developed BW Data Model to tune the performance of the system
• Gave user rich experience for UI from Standard Reporting Tool.
• Developed required Bex Queries for SAP BW Model and BO reports.
• Provided option to export Dashboard to Excel, PDF, etc.

Confidential

Technology: SAP BW, Bex Designer, SAP BO and Xcelsius 2008,Dashboard Designer

Project Engineer

Responsibilities:

• Created 7 BO Webi reports based on the Bex Queries as per the business requirement.
• Developed 5 Dashboards with 30 KPI’s for each Dashboard based on the Webi reports created.
• Provided very detail level of Interactivity for the user to drill down the data to nearly 5 levels which gives clear idea of analysis of the data that is available in Graphical Format instead of going to reports and verifying line by line out of huge data.
• Provided option to export Dashboard to Excel, PDF, etc.

Confidential

Technology: SAP BW, Bex Designer, SAP BO and Xcelsius 2008

Project Engineer

Responsibilities:

• Created two BO Webi reports based on the Bex Queries as per the business requirement.
• Developed two Dashboards with 35 KPI’s based on the Webi reports created.
• Provided high level of Interactivity for the user to drill down the data
• Provided option to export Dashboard to Excel, PDF, etc.