SUMMARY

• Around 8 years of experience as SAP BOBJ Consultant with extensive experience in designing, coding, testing, and supporting next - generation database solutions including SAP BOBJ Web Intelligence reporting functionality.
• Proficient in an assortment of technologies, including SAP HANA, SAP BW, Oracle 12c, Postgre SQL, Access, MS SQL Server 2016, JDBC, Visio, Apache HTTP Server, BOBJ Master Detailed, Dynamic Filter, Slice and Dice, Drilling methodology.
• Experience with Design and Installation of large-scale Business Objects Enterprise onSAP BO 4.0/XI 3.1/ 3.0/R2.
• Expertise in SAP BI tools like CMC, CMS, BO SDK, IDT, Lumira, Dashboard, Design Studio and Crystal Reports.
• Expertise in Business Objects Security Model and experience with Business Objects Security Implementation in SAP BI 4x, XI 3.1/ 3.0/R2.
• Extensive experience with Oracle RAC, PL/SQL performance tuning, backup, and recovery, migrating databases across databases, Logical design, Unix Scripting, SAP BOBJ to SAP BW and SAP HANA SLT, SAP ECC, non-SAP and File systems.
• Experience in ETL integrating HANA with SAP and non-SAP data sources such as SAP ERP, SAP BW, SAP PI, and ecommerce applications.
• Experience with HANA SQL script.
• Experience in data migration using SAP HANA, Oracle/MS SQL/Access.
• Experience in supporting SAP BW DTP’s and process chains.
• Experience in developing interactive dashboards, reports using Tableau Desktop.
• Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
• Big Data - Hive, Impala, Kudu, Sqoop, HBase, HDFS, Hadoop, Kafka, Flume, Spark.
• Administered in the architecture, installation of BOBJ, migration and provided technical support.
• Integrated SAP ERP system with web application for real time processing of the sales orders for various users.
• Successfully Integrated BO4.x with Liferay and java application.
• Successfully migrated BO xir2 to 3.1, BO 3.1 to 4.2 involving complex security model with thousands of users and groups. Customized thebusinessintelligence platform using java SDK to meet the requirements.
• Designed, developed, maintained complex BOBJ universes, Web Intelligence reports, Crystal Reports, Dashboards, and Analytic Applications with quality control and consistency of reporting across multiple business area.
• SAP HANA configuration, architecture, reporting/visualization, predictive analytics, and data/solution modelling.
• Conducted performance tuning, testing of Business objects related activities and capacity management.
• Involved in all phases of project from Blueprinting, Upgrade, Configuration, Development, Integration Testing, Cutover, and Training to Go Live
• Manage internal databases, from planning and testing stages through implementation and support.
• Self-driven strong SAP Techno-functional person and has good understanding of different SAP modules
• Good noledge on building HANA views using SDI/SDA and ETL process using Data Services.
• Provided support as required to ensure the availability and performance of developed reports and dashboards.
• Superior communication, presentation, analytical and problem-solving skill. Work well with all levels of business.
• Adept at analyzing high-level data.
• Logical Thinker; transforms code into logical patterns.
• Problem Solver: articulates potential concerns and creates solutions before they become problems.
• Meticulous; approaches database administration keeping in mind minute attention to detail.
• Manages and oversees troubleshooting, identification and tracking software and hardware issues and resolves them to keep systems operational.
• Team player and self-starter with excellent interpersonal and communication skills.
• Excellent communication, interpersonal and presentation skills, with demonstrated experience in customer interaction. Most importantly, self-motivated, quick learner and excellent team player.
• Quick learner and stronger desire to master in new Technologies.

TECHNICAL SKILLS

Languages/Technologies: SQL, Core Java, Linux, C, C++, HTML, XML, JavaScript, CSS

Design/Development methodologies: Agile (Scrum Methodology), Waterfall

Integration/Data Migration Tools: SAP SLT, SAP BODS, Informatica

Data Migration Skills: Data Loader, Data Migration

Test Automation and Build Tool: Ant, Maven, and Selenium

BI Tools/ ETL Tools: Business Objects (4.1, 4.2), Tableau Desktop (10.4, 10.5, 2020), Qlik Sense, Data Services

Reporting: Analysis for Office, Analysis for OLAP, Dashboard, Explorer, SAP Lumira, Crystal Reports for Enterprise, Web Intelligence Report, Design Studio

Database: Oracle (10, 11, 12), SQL Server, MySQL, PL-SQL, Postgre SQL (9.4, 9.5, 9.6), SAP HANA, SAP BW, S/4 HANA

Project Management/ MS Office: Microsoft Project, MS Visio / MS Word, Excel, Power Point, Outlook

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. SAP Business objects /HANA Consultant

Responsibilities:

• Designed, developed, maintained complex BOBJ universes, Web Intelligence reports, Crystal Reports, Dashboards, and Analytic Applications with quality control and consistency of reporting across multiple business area.
• Provided support for BOBJ web Intelligence reporting functionality such as Master Detailed, Dynamic Filter, Slice and Dice, Drilling methodology, Ranking Sections, Input Controls, Graphs, Breaks, and highly formatted reports with cross tabs tables.
• Designed and Analyzed complex queries and financial dashboards in BW 7.5and BOBJ 4.2
• Provided Support forSAPBusinessObjects4.2 Upgrade issues.
• Involved in the development of SAP BO 4.2 Web Intelligence (WEBi), Dashboard Designer, Analysis for OLAP OR Design Studios reports.
• Worked ETL and IT developers to design a data architecture dat ensures optimal performance and reporting flexibility while maintaining data warehouse quality standards.
• Experience with writing functional and technical specifications, testing and training.
• Performed testing of Business Objects support packages and patches.
• Provided support for changes in server configurations and troubleshooting of Business Objects SDLC environment.
• Provided Support forSAPBusinessObjects4.2 Upgrade issues.
• Day-to-day Business Objects administration task conduct performance tuning and capacity management.
• Used SAP BO CMC (Central Management Console) for creating BO promotion jobs and promote them to QA and production environment
• Project experience in Advanced modeling concepts including Analytic Views, Attribute Views, Hierarchies, Creating Restricted & Calculated Columns, Filter Operations, Variables, Creating Calculation Views, SAP HANA SQL, SQL Script and Procedures, Currency Conversion, Turning Business Rules into Decision Tables.
• Experience with Integration technologies, such as Smart Data Access, SLT; virtual data modeling, HANA Studio, Hana Live / Core Data Services; Lumira visualization tool; Smart Business Modeler KPI configuration through SAP Fiori.
• Experience with Analytics Cloud Reporting.
• SAP HANA configuration, architecture, reporting/visualization, predictive analytics and data/solution modelling.
• Experience with HANA SQL script.
• Good understanding of HANA Life-Cycle Management, importing and exporting HANA models within schemas, performance tuning
• Experience with SAP Best Practices deployments, SLT/SDI Data Replication Experience and Reconciliation process.
• Experience in BW Extraction, BW loading, building BW cubes, DSO, Multi-providers and building BEx reports.
• Create Generic data sources and enhance Business content data sources as needed for SAP ECC module.
• Experience with custom data extraction from SAP ECC using generic data extractors
• Experience enhancing business content extractors, transformations and OLAP variables using ABAP routines.
• Develop and implement BW Data Models (Info cubes, DSO, Multi Providers, Info sets)
• Create Transformations and DTPs to load and update data into Data Targets to achieve required results.
• Support Non-Ticketing activity in BW area
• Designed, developed compelling Tableau dashboards and reports using Tableau Desktop.
• Developed interactive visualizations utilizing various reporting components from multiple data sources.
• Published Tableau reports to servers and provided support as needed.
• Administration, architecture, migration, maintenance and technical support.
• Worked with IT and business users to resolve support and technical issues in production environment.
• Worked off-hours and weekend support in an on-call rotation.
• Provided system support when issues occur for assigned systems as well as systems in the SAP landscape.
• Support from Operating systems through points of integration.
• Experience in data migration using the best practices in SAP HANA, BW.
• Knowledge of data warehouse, ETL and software development methodologies to contribute to the overall planning by recommending approaches, identifying resources and developing timelines.
• Worked on Enhancements/Change requests/defects.
• Independently analyze, solve and correct issues in real time, providing problem resolution end-to-end.
• Refined and automate regular processes, track issues, and document changes.
• Assist developers with complex query, tuning and schema refinement.
• Provided 24x7 supports for critical production systems.
• General technical trouble shooting and give consultation to development teams.
• Provided standard operation support, validating backup/restore, performance monitoring, system availability, and evaluating logs.
• Performed schedule maintenance and support release development activities after hours.
• Excellent written, verbal communication and Flexible, team player, “get-it-done” personality.
• Ability to organize and plan work independently and to work in a rapidly changing environment.
• Ability to multi-task and context-switch TEMPeffectively between different activities and teams.

Confidential, TX

Sr. SAP Business Objects Consultant

Responsibilities:

• Provided support for BOBJ web Intelligence reporting functionality such as Master Detailed, Dynamic Filter, Slice and Dice, Drilling methodology, Ranking Sections, Input Controls, Graphs, Breaks, and highly formatted reports with cross tabs tables.
• Worked closely with ETL and IT developers to design a data architecture dat ensures optimal performance and reporting flexibility while maintaining data warehouse quality standards.
• Designed, developed, maintained complex BOBJ universes, Web Intelligence reports, Crystal Reports, Dashboards, and Analytic Applications with quality control and consistency of reporting across multiple business area.
• Performed testing of Business Objects support packages and patches.
• Involved in the development of SAP BO Web Intelligence, Dashboard Designer, Analysis for OLAP OR Design Studios reports
• Provided support for changes in server configurations and troubleshooting of Business Objects SDLC environment.
• Provided Support forSAPBusinessObjects4.2 Upgrade issues.
• Day-to-day Business Objects administration task conduct performance tuning and capacity management.
• Designed OLAP/Relational BO Universes using Universe Designer Tool as well as Information
• Designed BO Universes using Universe Designer Tool as well as Information Design Tool based on non-SAP RDBMS data sources
• Designed, developed compelling Tableau dashboards and reports using Tableau Desktop.
• Developed interactive visualizations utilizing various reporting components from multiple data sources.
• Published Tableau reports to servers and provided support as needed.
• Administration, architecture, migration, maintenance and technical support.
• Worked with IT and business users to resolve support and technical issues in production environment.
• Worked off-hours and weekend support in an on-call rotation.
• Provided system support when issues occur for assigned systems as well as systems in the SAP landscape.
• Support from Operating systems through points of integration.
• Experience in data migration using the best practices in SAP HANA, BW.
• Knowledge of data warehouse, ETL and software development methodologies to contribute to the overall planning by recommending approaches, identifying resources and developing timelines.
• Worked on Enhancements/Change requests/defects.
• Independently analyze, solve and correct issues in real time, providing problem resolution end-to-end.
• Refined and automate regular processes, track issues, and document changes.
• Assist developers with complex query, tuning and schema refinement.
• Provided 24x7 supports for critical production systems.
• General technical trouble shooting and give consultation to development teams.
• Provided standard operation support, validating backup/restore, performance monitoring, system availability, and evaluating logs.
• Performed schedule maintenance and support release development activities after hours.
• Excellent written, verbal communication and Flexible, team player, “get-it-done” personality.
• Ability to organize and plan work independently and to work in a rapidly changing environment.
• Ability to multi-task and context-switch TEMPeffectively between different activities and teams.

Confidential, TX

SAP Business Objects consultant

Responsibilities:

• Design, develop, implement, and maintain business intelligence semantic layers and reporting solutions in an enterprise environment.
• Be a leader in partnering with business users, senior management, and various IT functions to plan, build and support business intelligence solutions.
• Developed HANA views to support current SAP BO environment to enable future SAP reporting on HANA (pilot project)
• Changed existing Business Objects report development to meet any functional requirements
• Provided Support forSAPBusinessObjects4.2 Upgrade issues.
• Resolved production problems for Business Objects reports and within the SAP Business Warehouse
• Unit tested business object reports in the development system with supporting unit test documentation
• Assist with developing accurate project and task estimates.
• Provided support to end-user training of our business intelligence and reporting solutions.
• Implementing SAP BW on HANA specific modelling like using LSA++, Composite Providers and exposing BW objects in HANA Views, Operational Data Provisioning, ADSO etc.
• Participated in SAP BW Data Modeling, Reporting and Data Loading.
• Extracted Data from Total Retail Module, Enhanced and uploaded to flat files.
• Built SAP BW Objects: BEx Queries, MultiCubes, InfoCubes, InfoSources, InfoPackages, Transfer Rules and Update Rules.
• Strong troubleshooting and performance tuning skills - should be able to identify and resolve performance issues involving complex SQL code.
• Customer service focused with internal and external clients with ability to develop TEMPeffective partnerships across the organization.
• Advanced noledge of SQL coding across different database types (Oracle, SQL Server, DB2, PostgreSQL)
• Expertise to organize, plan, and carry out multiple concurrent objectives or activities, and TEMPeffectively make judgments in prioritizing and time allocation in a high-pressure environment.
• Strong work ethics, analytical skills and ability to commit and deliver on deadlines.
• Excellent communication skills (written & verbal) and be equally TEMPeffective interacting with both business and IT professional.

Confidential, IL

SAP Business objects /HANA Consultant

Responsibilities:

• Business no-how, especially in the areas accounting, controlling, planning
• May independently own a work stream, reviewing, and potentially directing the work of more junior staff
• Responsible for supporting and independently completing project tasks
• SAP Native Hana Data Modeler Developer to utilize HANA Data Modeling for custom Revenue Accounting solution
• Extensive and thorough IT no-how regarding web technologies and solutions
• Proven success in contributing to a team-oriented environment
• Creation and enhancement of SAP HANA Web-based applications with emphasis on data modeling
• Providing technical expertise on SAP architecture and making recommendations to improve performance
• Conduct work effort estimation and develop work plans
• Create, enforce, and adhere to HANA development standards
• Working with large data volumes including structured and unstructured data
• Developing SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access)
• Provide technology and architectural leadership, strategic direction and long-term vision for the SAP investment; inspire creative solutions for maximizing the value contribution of dat investment
• Providing technical leadership on upgrades and maintenance planning for SAP applications

Cigniti Technologies, Hyderabad, India

SAP Business Objects Administrator

Responsibilities:

• Information Modeling and Report generation for Sales and Distribution in module to present the Business analysis.
• Created SAP HANA data modeling using Attribute View, Analytical View and Calculation View.
• Hands-on experience with HANA landscape using functionalities like data provisioning, Modeling and Administration, and Information Composer.
• Well versed with replication methods like SAP Landscape Transformation and Business Objects Data Services.
• Created users, roles and schemas as a part of HANA Security and Development involved in Information Design Tool - Creation of Data Foundation, Universe for HANA reporting.
• Prepared detailed reports concerning project specifications and activities.
• Researched, designed and implemented scalable applications for information identification, extraction, analysis, retrieval and indexing.
• Worked TEMPeffectively with design teams to ensure software solutions elevated client-side experience.
• Worked closely with other team members to plan, design and develop robust solutions in a timely manner.
• Interfaced with business analysts, developers and technical support to determine the best requirement specifications.
• Implemented designs, including experimentation and multiple iterations.
• Consulted regularly with customers on project status, proposals and technical issues.

Confidential

SAP BI/BOBJ Developer

Responsibilities:

• Involved in all phases of project from Blueprinting, Upgrade, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
• Analyze, design, develop, build, implement, maintain, and support extractors, process chains, cubes, transformations, and queries to provide analytics data using SAP BW
• Monitor process chains in SAP BW system using RSPCM, ST13 & RSPC
• Provide technical information to the business team to assist in the creation of the BI/BW Design Review and presentations.
• Developed/Customized process chains, OHD, Portal for to Loan Management, Deposit management, Business partner Master Data and Transport requests.
• Perform Advance Programming Business Application and Programs (ABAP) development required for data source customization, transformations, start and end routines.
• Involved in development and configuration activities including building Data flows, Info objects, Transformations, process chains, SAP BEX and WEB application designer queries.
• Involved in the development of SAP Portal, Business Objects Dashboard Designer (Xcelsius) OR Design Studios reports.
• Develop and update training documentation for BI/BW toolsets.
• Design and develop solutions for optimizing existing BI/BW system/objects to improve performance.
• Design, develop, build, and support solutions to support advanced Data Integration and Data Quality requirements.
• Analyze, document, and apply SAP Service Marketplace Support Portal notes in support of problem and change analysis.
• Provide noledge transfer to Departmental personnel and business users on an on-going basis.
• Developed OHDs for Canadian Deposit Insurance Cooperation to extract flat files using PI.
• Gathered requirements and developed functional and technical specifications.
• Provided end to end solution to develop COGNOS reports using Open Hub Destinations.
• Worked extensively with the SAP BW Extraction, Transformation and Loading tools i.e. DB connect, Business Application Programming Interface (BAPI) and XML.
• Worked with SAP functional consultants/ business users to gather information related to Collateral Management Systems (CMS) and Collateral Management Loans (CML).
• Worked to fix the issues or implement the new changes by following the company's procedures on priority along with developers.
• Conducted project reviews with internal customers to determine scope and need for project prioritization.
• Performed and participated in the analysis, design and implementation of business systems following appropriate standards and requirement gathering.