PROFESSIONAL SUMMARY:

• Understanding of Business Intelligence (BI) and Data Warehousing (DW) concepts
• Expertise in designing/creating/configuring and maintaining Data models (Info Objects, DSO’s, Info Cubes, Info Sets, Multi Providers, Virtual Providers)
• Strong understanding of Data warehousing concepts such as Confidential, Confidential Confidential, Confidential Confidential
• Experience in Designing Data Flow from SAP and Non - SAP source systems
• Experience in creating transformations in SAP BW (Start routine, end routine, transformation by Rule Type, transformation by Rule Group, Return Table)
• Experience in creating BEX reports (exceptions, conditions, report to report interface)
• Good Experience in Data Migration
• Very good knowledge in SAP In-Memory database SAP HANA 1.0
• Experience in integrating BODS with SAP and Non-SAP Data Sources
• Sound knowledge in SLT technology to load the data into the HANA database
• Experience in developing and designing Information Models
• Strong experience in creating the Attribute views, Analytical views and Calculation views to satisfy the reporting requirements
• Experience in SQL: Stored Procedures, CE Functions, SQL Scripts
• Experience in SAP Business Objects BI 4.0
• Experience in Crystal Report for Enterprise with HANA
• Experience with Security Authorization (creating users, roles, privileges)
• Ability to achieve targets and deliver results in a fast paced environment
• Good proactive and analytical problem solving skills with strong leadership and excellent interpersonal abilities
• Strong communication, presentation and client interaction skills
• Quick learner with good systematic approach towards work and a strong work ethic
• An excellent team member with an ability to quickly adapt to different project environments and accomplish difficult tasks independently within time frame
• Energetic and goal oriented with a well-rounded background in supporting a progressive organization in optimizing performance and growth
• Perform well under pressure

TECHNICAL SKILLS:

Programming Languages: C++, Matlab, SQL, C#, LabVIEW, Python, Java

Databases: SAP HANA 1.0, Microsoft SQL Server

Reporting Tools: BEX Query Designer, BO 4.0

IDE: Visual Studio, Eclipse, NetBeans

Microsoft Office: Word, Excel, Power Point

SDLC: Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential, Woodland Hills, CA

Responsibilities:

• Worked on creating Data Models: InfoObjects, DataSource, InfoPackage, DTP, Transformations, DSO, Infocubes, Multi providers etc.
• Maintained aggregates and indices to improve the performance
• Activated Data Transfer Process (DTPs) and loaded transactional data to data targets through persistent staging area (PSA) from source systems
• Extracted SAP BW content into SAP BW on HANA
• Involved in monitoring the data loads into HANA (Flat File, SAP Landscape Transformation for SAP & Non-SAP source systems, Data Services, Direct Extractor Connections)
• Improved the performance and reduced the coding by learning and implementing CE functions
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Designed and formatted reports and web reports using crystal report Designer and Crystal Enterprise
• Migrated HANA content from development, testing environment to Production environment using delivery units
• Involved in postproduction support, which required end users and writing the technical document

Confidential

Responsibilities:

• Worked on gathering user requirements and transformed them into a data model with the concept of Confidential Confidential
• Designed Info Providers
• Developed custom DSO, InfoCubes, Multi-providers for the reporting needs for SAP and Non SAP data
• Implemented various performance tuning activities to increase the performance of Queries by creating Secondary indexes, Aggregates, Line Item Dimensions
• Interacted with the manager to understand the business requirements and implemented the business rules to redesign and enhance the existing dataflow
• Worked with ABAP programmers and developed ABAP codes for Transformation routines
• Developed queries to include restricted key figures, calculated key figures, hierarchy level displays, and navigational attributes, filters and free characteristic options, formula variables, text variables as part of query building in BEX Analyzer
• BW on HANA fresh installation and moving only the required, data models & content, in the process optimize and cleanup the BW system
• Worked on SAP HANA 1.0: Data modeling and data provisioning using ETL tools
• Performed Real time replication using SLT
• Involved in data loading using BODS to SAP HANA Database
• Used different transforms such as Query, Table Comparison, Key Generation, Merge, Date Generation, Pivot transforms and functions
• Created Multiple analytical, and attributes views based on requirements
• Reviewed Stored Procedures and SQL Scripts for performance tuning purposes
• Created User Prompts, Conditions and Filters to improve the quality of report generation
• Created trend reports by combining imported SAP BW data models (InfoCubes) with historical data and real-time data from HANA models

Confidential

Responsibilities:

• Designed and developed custom Data Sources, Info Sources, Extractors, Info Cubes and DSO'S to fulfill user requirements
• Developed custom cubes and pre-delivered cubes which are activated as a part of Global Deployment
• Created Info Sources, InfoCubes, aggregates, DSO objects for incoming sales orders according to sales organization, distribution channels and divisions
• Created aggregates for info cubes to handle performance tuning
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Designed the different stages of the data flow
• Performed Master data and Transaction data extractions from SAP/Non-SAP source systems and automated the data loads using process chains
• Used Open Hub Service to extract data out of BW system in to flat files
• Customized reports using BEX Analyzer and BEX Query Designer
• Designed and tested BEX queries using hierarchies, hierarchy node variables, structures, exceptions, restricted key figures and calculated key figures using BEX designer and BEX Analyzer
• Created process chains for master data and transaction data loads for various areas
• Provided documentation on all the developed cubes in all the modules and also the changes made to the custom delivered cubes to satisfy the business reporting in the specific site