SUMMARY

• Worked experience spread in Manufacturing, Non - Profit Organization, Aerospace, Financial Institutions, Utilities and Pharmaceutical Domains Strong interpersonal and communication skills, Ability to work independently and a proactive team member, comfortable interacting with customers and technical teams, Strong analytical & problem-solving skills, Followed many SDLC Methodologies including agile and Scrum on different projects.

TECHNICAL SKILLS

HANA: HANA and HANA 2 Platform. Developed content by creating Attribute views, Analytical Views, Calculation Views and Decision table, Table Function, Procedure and Analytical Privilege. Data Provisioning used SLT, DXC and Data Services. Responsible for requirement gathering, translating Functional Specifications into Technical Specifications and Business KPIs into HANA Models & Define the Reports/Dashboard Layouts.SUM & DMO, Optimization, Backup, Data Recovery strategies

Business Objects (BOBJ): Business Objects Enterprise XI R2/ XI 3.1, Business Intelligence Platform 4.1,4.2, Business Object Edge Solution, Universes IDT and UDT, Qwaas, Query Developer, BEX Query Designer, BICS, Xcelsius 2008, Dashboards and Analytics XI 3.1, Dashboards and Presentation Design 4.0/4.1/4.2 Crystal Report 2008/2011/2013 Crystal Enterprise 4.0/4.1/4.2, Crystal Server, Explorer 4.0,4.1, Lumira 1.25,1.28, Design Studio 1.0 to 1.5, Web Intelligence WEBI XI3/4.0/4.1/4.2, Analysis Edition of Microsoft office and OLAP 1.4,2.0, BOBJ SDK, Designed and developed complex reports in SAP BI 7.3/7.0, Mobil UI, Launch pad, Upgrade Management tool, BICS, CMS, CMC, LCM, Authorization and Authentication, Installation, Version upgrade, Patches and Integration.

SQL: Extensive experience with SAP SQL/Script, Oracle PL/SQL, SQL* PLUS, SQL Navigator, SQL Developer, CA ERwin Data Modeler 7/8/9, ANSI/ISO 92, T-SQL, IBM DB2, MY SQL, TeraData 13/14 Stored Procedures, Functions (UDF), Views.

BODS: Business object data Services BODS 4.0/4.1Web Admin/Management Console, Queries in Data Services, MYSQL Frontend MySQL Server, ETL, Data Integration, Data Profiling, Data Modeling, Data Warehouse, Data Conversion, Check-ins, Check-out objects with Central Repository, Work Flow, Conditionals, Data Flow, Query, Transforms, Lookups, Variables, Functions and custom Functions, Data mapping functions and conversions

Data Warehouse: SAP BW/ BI 7.0 / 7.3 /7.4 BWonHANA, BW/4HANA InfoObjects, ADSO, DSO, Multi Provider, Virtual Provider. Transient Provider, Data modeling Dimensional & Relational concepts includingStar-schema modeling, Snowflakes modeling, Extending Star Schema in SAP BW. Fact and dimension tables and followed Kimball and Inmon Models EDW concepts. Big Data Integration with HANA SPARK and Vora

Software: JavaScript, BIAL, UI5, HTML, CSS, XML, JQUERY, 3Djs, R, MS CMD, Unix Bash, Web Services, WSDL

PROFESSIONAL EXPERIENCE

Confidential, NY

Responsibilities:

• Participate in Data Mapping workshops and follow-up meetings with the client business
• Created custom templates and custom lookups and shell jobs and used them in various business needs.
• Fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Build universes on top of HANA information models for Webi/Dashboard reports.
• Working extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
• Working with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Using Data Integrator and Platform Transforms extensively.
• Build HANA Information models (Attribute Views, Analytical Views, Calculation Views, Column/Row based tables) in HANA design studio for efficient data integration.
• Designed single source of truth system of Financial Data Warehouse containing R/3, Teradata, BPC, Marketing Expense Management data.
• Designed Automatic Reconciliation Tool that compares data across different SAP landscapes and versions, Non-SAP landscapes like Teradata and aggregated as well as summarized level of data.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Using HANA CDS views for reporting
• Worked for SAP HANA Transient Provider by connecting with SAP IDT tool
• Integrating Tableau with HANA Database
• Using Design Studio, WEBI and Tableau for Reporting

Environments: BODS 4.2, BOBJ 4.1, SQL, S/4 HANA, Design Studio, Lumira, WEBI, CDS view

Confidential

Consultant

Responsibilities:

• Worked directly with Business for defining and analyzing gaps between business requirement and technical requirement.
• Used Oracle 11g Stored Procedure to extract data and save them into the Materialized view
• Developed SAP BO 4.1 semantic universes using IDT tool.
• Delivered reports covering WEBI, Dashboard and Design Studio.
• Performed user training sessions for SAP HANA Information Models.
• Worked with Tech Mahindra team to Model Design and deliver Commercial SCM and Military SCM reports for Spirit.
• Worked with the development and test teams to build, test, and implement the solution.
• Develop architecture / implementation plan for BI projects.
• Design, maintain and enhance all BI components and optimize for reporting efficiency and scale.
• Designed and developed ETL routines in BODS, modified or created new
• Data Services to meet Project Requirements.
• Analyze user needs and create cardinalities, contexts, joins and aliases.
• Work with business users and define dimensions and measures.
• Establish, maintain and administer reporting environment, including scheduling, distribution, user permissions, and updating reports and dashboards
• Optimized the queries performance
• Implemented ABAP data flow processing using Data services for Extract data from multiple tables from ECC6.0
• Scheduling the jobs by client requirement by using Business objects data services Management Console.
• Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options; as well as additional flexibility in terms of report data selection.
• Created project actuals and planning reports based on HANA models.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Created reports with cascading prompts.
• Batches generate PDF Reports using Subscriptions.
• Involved in enhancements of Data Services Jobs, and applying Patches on HANA.
• Involved in testing the newly developed reports vs the pre-migration Reports.
• Involved in Testing and Test Plan Preparation, Process Improvement for the ETL developments.
• Evaluated Report Performance upon completion of the reports and validated output data.
• worked with end user and finalize the UAT
• Responsible for Created user-groups in CMC and implemented the security model on the groups created.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections)
• worked with end user and finalize the UAT

Environments: BOBJ 4.1, Oracle 11g, EEC 6, HANA, Lumira, Design Studio, Crystal Report 13, Crystal Report Enterprise

Confidential

Consultant

Responsibilities:

• Act asliaisonbetween SAP and CAS to implement, integrate and modeling HANA Cloud platform for CAS environments
• Responsible for ETL process and used SAP BODS 4.0
• Collected business requirements for developing reports on SAP BOBJ BI 4.1
• Used IDT to converge various source data into ROLAP for Reporting purposes
• Developed LUMIRA Enterprise for Dashboard, Story Building and Infographic
• Used CMC, CMS, and Launch pad to make sure system follow SAP Best Practice for user Security as well as Application Optimization.

Environments: BOBJ 4.1, Lumira, HANA Cloud, BODS 4.1, SQL Server 2010, Oracle 11gACCENTURE APRIL 2011- December 2014

Confidential

BOBJ Architect/Developer

Responsibilities:

• Developed complex Financial ad hoc reports in WEBI
• Worked with Business Backend team, functional consultant and ETL team to gather and
• developed BEx Queries
• Created multi provider complex Universe through IDT
• Created linked WEBI to Dashboards through WEB Services
• Created Tableau based Dashboard and Stories
• Created SAP HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Product Test execution and script writing to test
• Importing the BW Models in to HANA using HANA Studio
• Design, develop, and configure software systems to meet market and client requirements end-to-end from analysis, design, implementation,
• quality assurance including testing, to delivery and maintenance of the software product Apply knowledge of technologies, applications, methodologies, processes, Best practices and tools to support a client
• Worked with five developers off shore India base team for day to day progress and keep them sync with ongoing project deliverables.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Experienced in database design process and data modeling process.
• Designed and developed ETL routines in BODS, modified or created new
• Data Services to meet Project Requirements.
• Designed Dimensional Data Model to implement the consolidated view of Members and Claims using data modeler.
• Designed a high level architectural model for the ETL implementation of Insurance Claims, Membership Coverage and Status Tracking for the developers.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Documented and Maintained Data Dictionaries with the updated Data Model Enhancements.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Involved in Performance tuning.
• Created / scheduled SQL server jobs and maintenance activities of Database.
• Developed queries for data analysis and analysis on the defects raised by end-users and fixing the defects.
• Managed and coordinated all user acceptance testing.
• Created customized report including, filter options, page break options, output options as well as additional flexibility in terms of report data selection.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Assisted users in troubleshooting their queries.
• Created repository and security domain with user groups and security implementation multilevel hierarchies are set up enabling the drill down functionality and created Derived Tables.
• In a multi-server environment, implemented load balancing efficiently across multiple machines greatly enhances scalability and end-user response time. Scheduling and publishing reports onto WEBI to different destinations
• Migrated Universes, Reports, Securities from the Development to Production environment after UAT
• Product Test execution and script writing to test
• Responsible for Created user-groups in CMC and implemented the security model on the groups created.
• Design, develop, and configure software systems to meet market and client requirements end-to-end from analysis, design, implementation,

Environments: BOBJ 4.0, BW 7.3, HANA, BODS 4.0, DB2, SQL 2012, Oracle 11g, SQL 2008, ECC 6.0, Crystal Report 11, Informatics power center, Lumira, Design Studio

Confidential

Functional Design Lead

Responsibilities:

• Developed complex BEx Queries by creating various variables, exceptions and filters including user exits variables to generate financial Reports based on BEx tools including Work Books /Web Application Designer.
• Work extensively with Reporting team to beat challenging deliverable time limit using BOBJ 4.0 and BI

Environments: BOBJ 4.0, BW 7.3, BODS 4.0, SQL 2012, DB2, SQL 2008, ECC 6.0Client/Company: Confidential HOLDINGS, INC. (Wichita, Kansas)

Business Continuity Architect & User Experience Architect

Confidential

Responsibilities:

• with the client functional SME and the business to refine and develop the use case and descriptive analytics requirements
• Responsible to Develop Dashboards and WEBI with complex drill down object
• Finished documenting requirements and working with the application development team to ensure they are understood and deliverable.
• This is a key role across 4 pilots using the newest HANA 1.0 and Business Objects technology BOBJ BI 4.0.

Environments: BOBJ 4.1, Oracle 11g, EEC 6, HANA

Confidential

Software Developer

Responsibilities:

• Create BO Universes in IDT
• Used SAP HANA to create required Data Marts
• Used Data Services for ETL
• Created Lumira based Dashboard and Stories
• Web Intelligence WEBI Reports and Dashboards using BOBJ 4.0.
• Created complex dashboards in limited short period of time targets.
• Used TeraData 13 as a backend data source.

Environments: BOBJ 4.0, BW 7.0, BODS 4.0, SQL 2012, DB2, SQL 2008, ECC 6.0, Crystal Report 11,TeraData 13, Lumira

Confidential

Software Developer

Responsibilities:

• Designed, developed, and configured reports using BO Enterprise XI3.0
• Developed complex WEBI and Xcelsius Dashboards,
• Developed Crystal Reports 2011 and sub reports
• and to meet client requirements either end-to-end from analysis, design, implementation, quality assurance (including testing), to delivery and maintenance of the software product or system or for a specific phase of the lifecycle.
• Used experienced and knowledge on technologies, applications, methodologies, processes and tools to support a client, project or entity.
• Used SAP BODS to migrate data from Oracle to SAP/R3 system and used as cleansing data.
• Involved in gathering business requirements from business users.
• Developed and supported the Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources including EDW.
• Analyzed the source data, cleansed, standardized source data and provided cleansed data to ETL.
• Integrated different source feeds and extracts from systems across enterprise.
• Designed High-level design documents and ETL mapping specifications.
• Effectively worked with Data Modeler to develop Logical and Physical Dimensional Model for Data Marts.
• Designed and developed Job Sequence for the ETL jobs.
• Map the source and target databases by studying the specifications and analyzing the required transforms.
• Used PL/SQL to populate the data marts.
• Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options; as well as additional flexibility in terms of report data selection.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Created reports with cascading prompts.
• Graphical presentations like pie chart, bar charts, line charts were created for analysis and statistical information.
• Involved in testing the newly developed reports vs the pre-migration reports.
• Assisted users in troubleshooting their reports.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Deployed packages, Reports from a development environment to test environment.
• Developed, managed, and coordinated all user acceptance testing.

Environments: BOBJ 4.0, BW 7.0, BODS 4.0, SQL 2012, DB2, SQL 2008, Crystal Report 11, ECC 6.0, Tableau 8, TeraData 13