PROFESSIONAL SUMMARY

• 10+ Yrs experience in different tools of SAP BOBJ with Relational & SAP data sources. Worked in 5 full life cycle implementation projects, 2 End to End projects and a BO Performance Optimization project based on recommendations approved by SAP   
• End to End experience in development and enhancement projects on various domains like Retail, Oil & Gas, Automobile, Media & Broadcasting, Financial, Pharmaceutical, Medical, Education & Employment, Manufacturing  
• Command on BOXI R2, R3 & BO 4.X product suites, Architectures and Data flow. Experience in installing BOXI R3 & SAP BOBI 4.x Enterprise SUITE with BO server clustering, Client tools, Integration Kit and other tools like Crystal Reports & Dashboard Design
• Experience in gathering Requirements, Analysis, Design, Development, Deployment, Testing and Support of rich Interactive Dashboards and Workbooks using Tableau Desktop   
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of Dashboard Action, Data Source and Context Filters according to the end user requirement  
• Expertise in designing and creating various analytical reports like Performance Dashboards, Score cards and Metrics to help users to identify critical KPIs and facilitate strategic planning in all functional areas including Order Management, Finance and Planning, Process Management and Sales/ Marketing
• Designed and Developed QlikView dashboards using Chart Box (Drill Down, drill up & Cyclic Grouping), List, Input Field, Table Box, and Calendar & Date Island meeting the business requirements  
• Strong understanding of relational and in-memory databases like Oracle, Teradata, SQL Provided production support to the existing Qlikview applications and Involved in performance tuning to optimize the functionality of dashboards
• Experience in developing dynamic, operational & executive dashboards using Xcelsius via the web service connectors like QAAWS, Live Office and XML   
• Developed Xcelsius dashboards using hyperlinked detail level drill-down Web Intelligence reports   
• Extensive experience in creating SAP Lumira dashboards using multiple data sets   
• Extensive experience in creating reports on Query and Analysis tools like Web Intelligence, Desktop Intelligence and Rich Client using advanced features like Content Linking, Element Linking, Folding
• Experience in SAP BO server configuration, user management, folder security, user rights, promotion management, CMC audit reports, Import wizard and Publishing wizard   
• Experience in creating and modifying Universes on Relational data sources and SAP sources using Designer (3.X) and IDT (4.X)   
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modelling principles in Data Design, and used expert knowledge of data warehousing concepts  
• Being a Senior Developer was responsible for analysis, design, and development of SAP BW backend components and front end reports and dashboards
• Extensively worked in Crystal Reports for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, drilling, analysis and data reports
• Proficient in creating Crystal reports on various data sources Oracle, legacy data and OLTP sources 
• Extensive knowledge on database administration for  Oracle  8i, 9i, 10g & 11g with experience within very large scale database environment and mission critical OLTP and OLAP systems. 
• Excellent experience in migrating the Databases and Worked on Software like My SQL and TOAD. 
• Having hands on experience on working with Large OLTP databases, fulfilled DBA daily activities including user management (creating users, privileges, roles, quotas, table, index, sequence etc.), space management and monitoring 
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Had experience in data modelling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica
• Experience in testing the Business Intelligence applications developed in Qlikview.
• Experienced at creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Good understanding of Business Requirements and Process Management added with my proficiency over DWH concepts and reporting tools, helped me translate end user needs into perfect software solutions.  

TECHNICAL EXPERTISE

Reporting Tools: SAP BOBJ XI, 4.x, Xcelsius, WebI, Rich Client, InfoView, BI Launch Pad, UDT, IDT, Explorer, Design Studio 1.x, SAP Lumira 1.x, Crystal Reports, BI Widgets, CCM & CMC management, Import Wizard, LCM, DeskI, Publishing Wizard, Report Conversion tool, SAP BW, Tableau, Qlikview, Informatica

Database:   Oracle 8i, 9i, 10g, 11g, MS SQL Server 2008 R2, DB2, Teradata  

GUI Tools:   Crystal Reports, SQL Plus  

PROFESSIONAL EXPERIENCE

SAP BO/BIDeveloper  

Roles & Responsibilities :  

• Gathering, reviewing and discussing reporting requirements with subject matter experts and business users then prepare consumption documents. 
• Created universe, classes, objects, complex measure objects, prompts, pre-defined conditions.   
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.   
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.   
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.   
• Developed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins.
• As part of 6 sigma project, optimized around 30 reports to 10 reports and contributed for the decrease in OF-BOBj usage cost
• Involved in publishing, migrating of the reports and universes from (DEV-QA-PRE-PROD-PROD)
• Assist in determining the root cause and troubleshoot the report and query issues across Dev, Testing and Production environments.   
• Worked extensively with the major functionality of BO like Breaks, Sections, Sorts, Calculations and Ranking
• Analyze, design, develop and unit test complex reports and visualization dashboards using SAP Business Objects Suite of tools alongside QlikView and Tableau reporting tools.   
• Developed QlikView Dashboards with interactive views, trends and drill downs along with user level security and Quick/context/global filters, parameters and calculated fields were implemented using QlikView and Tableau for analysis
• Detailed level reporting has been provided using Webi and Summary level information including charts and visualization dashboards were provided using QlikView and Tableau reporting tools.
• Created Rich dashboards using  Tableau  Desktop and prepared user stories to create compelling dashboards to deliver actionable insights
• Performed data refresh on  Tableau  Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.
•  Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameterized using  Tableau . 
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, Symbol Maps, Pareto charting, mapping, calculations, demographics and geographic fields according to deliverable specifications using Tableau.
• Built dashboards with forecast, trend line, reference lines, MTD, YTD, QTD type of analysis to track events.   
• Responsible to work with Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant, writing custom SQL queries to limit the data sourced into tableau thus improving Tableau performance
• Ability to write, validate and optimize SQL code from multi database platforms and fine tune the SQL queries from new and existing reports and improve the report performance.   
• Participate in maintenance, performance tune and enhancing the BO universes for individual projects to facilitate the ongoing projects.   
• Involved in performing system to system migration and biar file migration of reports and content using CMC.   
• Involved in sprint planning sessions and sizing the user stories in AGILE environment.   
• Performed admin tasks such as security implementation at report level, folder level and user and content management across all platforms.   

Environment : SAP Business Objects product suite 4.1 SP6, Teradata 14.01, DB2, Universe Design Tool, Web Intelligence, Dashboards 4.1,Crystal reports, SAP Lumira, Tableau 9.2.5, QlikView 11.20 and Windows 7.  

Software Developer

Roles & Responsibilities :  

• Involved in planning sessions with VP and Managers to analyze requirements and outline the functional reporting solution.   
• Developed data model to accommodate both Real time and standard data transfer process.   
• Modified custom code in start routines and end routines based on data transformation needs   
• Customized the basic cube with custom Characteristics and Key Figures for reporting.   
• Performed BO upgrades/migrations ~ BO 4.0 to 4.1 and BO 4.1 to 4.2, and BW BEx Reports to Webi.   
• Involved in regression testing post application of BO Service Packs and Patches as required.   
• Ensured compliance to all business objects licenses and best practices.   
• Created various Test Scripts and Test Cases.   
• Performed extensively Unit Tests, System and Integration, UAT, Performance and Regression Testing Manually.   
• Developed Reports using WEBI against SAP (Universe & OLAP connection) and non-SAP data sources.   
• Evaluated and Developed Reports using Tableau and SAP Lumira.   
• Developed Analysis for Office and OLAP Analysis Reports against OLAP Connections.   
• Created Publications and published various reports in HTML format, with PDF and Excel attachments, to Email and File System (Remote Location).   
• Scheduled Publications and Reports for Daily, Weekly, Hourly, Bi-Monthly and Custom Calendars.   
• Created Events, Folders, Connections, Custom Calendars, Users and Groups in CMC.   
• Performed Promotion of reports across landscapes using Promotion Management.   
• Performing troubleshooting and issue resolution, and assisting other developers and Business Users.   
• Post-Go Live/Support ~ handling Incidents, Access requests, Maintenance & Enhancement Tickets.  

Environment :   SAP Business objects 3.1, Import Wizard, Report Conversion Tool, Windows Enterprise Server, Xcelsius, Crystal Reports,Oracle, SQL Server

Software Engineer

Roles & Responsibilities:  

• Designed the Universe using Business Objects Designer. Defined Classes and Objects appropriately in the Universe   
• Created Joins, Aliases and Contexts for solving the chasm traps and fan trap problems in the universe   
• Created Hierarchies, predefined filter conditions and prompts in the universe   
• Created custom objects using functions like @prompt, @select, @where, @variable   
• Worked extensively on advanced Deski reporting features like Drill Down, Slice and Dice, Alerts for creating Business Objects reports   
• Organized data in the reports by using Variables, Filters, Sorting, and Ranking in the canned reports   
• Created custom hierarchies and defined scope of analysis for allowing drill options in the reports for detailed analysis at various levels of data   
• Created alerters using Business objects to highlight columns based on business criteria   
• Tuned the performance of the reports by defining the indexes on the correct columns   
• Deployed and scheduled reports via Broadcast Agent   
• Inserted drill filters in the Web Intelligence reports, which help the end users to run a report based on multiple selection criteria.  
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.

Environment : Business Objects XI R2, Desktop Intelligence, Web Intelligence, Oracle 8.1.6, Informatica