PROFESSIONAL SUMMARY:

• Highly Committed, Self - motivated and goal-oriented BI/DW/SAPBOBJ Consultant having 13 Years of work experience in Analysis, Design, Development and Testing of Data Warehousing Applications
• Experienced BI Professional, versatile skill set ranging from BO 6.5/XIR2/BOXI3.1/BI4.1/BI4.2, Tableau9/10, Crystal Report 2011/Enterprise, HANA
• Well versed with various SDLC methods such as Agile/Kanban/Waterfall
• Certified SAP HANA1.0 SP5 Associate
• 2 years of experience in developing dash boards using Power BI 2.73 Desktop and Power BI Service.
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling
• Extensive experience in solving performance issues due to large volumes of data, complexity in data models, migration to new technologies
• Multi-industry exposure coming from financial, communications and service industries.
• Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries)
• Experience in building, retrieving data using Universes and used functionalities like Combined Queries, Slice and Dice, Drill, Crosstab and Master Detail Reports
• Worked on BO Designer Functionalities like Derived Tables, Linked Universes, Contexts, Aliases, complex joins, Customized LOV’s and Aggregate Awareness for the Optimization and Performance tuning of Database
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Good experience in creating Sub Reports, Linked Reports, Cross Tab Reports and Graphical Reports. Expert in using shared and global variables across the Crystal reports
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures written in SQL
• Provided production support to various business unit users on resolving report level data discrepancies and formatting issues

PROFESSIONAL EXPERIENCE:

SAP BI, Programmer Analyst

Confidential, Houston, Texas

Responsibilities:

• As a multi-national company Confidential was providing services in EMEA/North America/APAC, the project involved gathering the data that has been received as feedback from both internal/external Confidential employees
• The existing reports were developed using Bex and Legacy home grown Confidential applications, my role was to analyze all of the existing reports, reverse engineer them, document the requirements and proceed to development
• The reports were mainly developed using SAP BI4.2 and there was also some extent of Power BI
• As part of report development I created complex variables that had nested If statements and other standard formula SAP BI4.2 has to offer
• For fields that are not readily available at the DB layer or the universe layer, I implemented them first on the reports and then moved on working with ETL/DB resources to coordinate the development of fields at DB level so that there is an improvement in report execution time
• I also assisted the middle ware team by providing the syntax for openDoc and other URL required to integrate all of the reports into external reporting portal that uses Java Stack
• As part of universe development I analyzed the tables/universe objects to determine the gap and create additional objects/classes/folders as they call it when using IDT
• Within universe development I resolved any traps/errors by correctly introducing aliases/contexts
• I made sure whenever a new table join is introduced it is present in all the contexts so that regression testing became very successful
• Created derived tables at IDT/UDT level for complex SQL that is not readily available in Database(DB)
• Some sample reports I created are Certification report, User data change report, LO Catalog report, attendance report etc.
• In addition to creating these reports I worked with Admins in creating new schedules/publications so that reports are delivered to end users via emails/shared drives
• The environment was Windows 2016 servers/Tomcat8 on Linux/SAP BI4.2 SP5 and IE11/Chrome browsers. The data bases I worked with are Oracle12 /SQL server2016

BOBJ/BI Reporting Senior Developer

Confidential, Houston, Texas

Responsibilities:

• Responsible for the creation of BI reports end to end, analysis of tables, Universe design, report development and data reconciliation
• Developed both columnar and summary reports that are useful both for high end visualization and publishing over company portal
• Extensively used launch pad including applications such as WebI, to create user friendly reports with help of combined queries, multiple data providers while retaining the user friendly features of report such as drill down and drill across
• Designed, developed and enhanced various reports such daily activity summary report, gross margin factor (GMF) report using universe
• Responsible for unit testing and data reconciliation before reports are promoted to higher environments
• Month end reconciliation report design and development is carried out by me that finance users use to close the books
• Extensively used various features of IDT/UDT such as @prompts, Contexts, Alias to resolve fan and chasm traps and ensure data integrity
• Participated in design and development of Leasing Info Data-mart /Financials data-mart along with ETL team and implemented the universe design and development
• Designed and developed WebI reports and dash boards that were used to summarize data presentations to executive management
• Participated in daily scrum meetings as part of Agile development to gather requirements and update business stake holders on progress
• Worked with DBA(s) in fine tuning the SQL generated by universe/report and define indexes on required columns there by improving the execution time of reports
• Configured BI4.1 on Development, Stage and supported configuration of Production servers
• Used report conversion tool and upgrade management tool to convert 3.1 content to 4.1 and manually resolved errors that were not fixed during upgrade
• Designed and developed universes both UNX and UNV against Oracle/SQL server for the client
• Responsible for maintaining the CMC/CMS for the entire BI deployment that had 300 users in stage and production
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard.
• Defined best practices for Tableau report development. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives
• Using Tableau developed dash boards for executive display of vacancy/occupancy
• Installed and configured BI4.1 and migrated BOBJ3.1 to BI 4.1 using upgrade Management tool
• Used Promotion Management tool to migrate the objects from Dev to QA to Production
• Responsible for the migration of the entire Business Objects Content from XIR3.1 to R4 from the old environment to the new
• Provided production support during various time zones for business users in resolving data discrepancy and formatting issues
• Resolved user tickets in a timely fashion and supported business by creating new users and managing user rights of existing users

Environment: Windows 2008, SQL Server 2015, Informatica 10.1, Business Objects XIR3, BI 4.1, WebI, Crystal Reports, Tomcat7, Tableau9.3

Confidential, Los Angeles, CA

Business Objects Developer/BI Developer

Responsibilities:

• Translate Business Requirements into Universes for different functionalities and create both canned & ad-hoc reports and Templates using: queries, cross tab, master detail, formulas and assist in analysis of them.
• Supervise the development and design of Reports, Metrics, and Dash board for the Finance Group.
• Create the Universes with Default & Custom Hierarchies for multidimensional analysis and create reports with Multi-Level Scope of Analysis using drill down, drill across, drill up and slice and dice.
• Define Conceptual Data model and derived Logical and Physical data models for Enterprise-wide Data model and Design Star Schemas and Snow Flake Schemas. Used Erwin tool.
• Creates groups/users/folders in CMC, registered and managed servers in CCM.
• Creates Hierarchies, complex objects using various functions, aliases, contexts, Aggregate objects in the universe.
• Implemented custom hierarchies for using them in drill down, drill across slice and dice for WebI reports
• Installed the Application and Web server (Tomcat 5.1) with XI SP3 for UAT.
• Responsible for the Documentation of the whole Life cycle of the report development.
• Responsible for creating and developing the Logical and Physical database for Leasing Finance project.
• Development and Deployment of Complex Reports. Used multiple data providers, Union, Sub Queries, Intersection, minus and Master/Detail, cross tab, Charts.
• Schedule the reports using Scheduler to various formats including EXCEL/PDF.
• Involved in Full life cycle design and development of Business Objects reporting Applications.

Environment: Business Objects XI R1/R2 (Designer, Reporter, CMC, and CCM), SQL Server 2005/2000, BO SDK (JAVA), Crystal Reports XI R1, R2, Windows 2003/2000/XP, Business Objects Data Integrator.

Confidential, Jersey City, NJ

BOBJ Developer/BI Analyst

Responsibilities:

• Migrated repositories from BO 5.1.7 to BO 6.5.
• Was responsible for the creation maintenance of users and security Profiles.
• Installed and configured Broadcast Agent Server, Auditor & Publisher on AIX 5.1.
• Assisted in installing and configuring Business Objects Full client on users systems also distributed the BOMain key.
• Customized Business Objects Universes for Sales modules.
• Involved in performance tuning of Business Objects reports by tuning the SQL.
• Use of BO Designer Module to implement Universes, Joins between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies(Traps).
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Created graphical representation of reports such as Bar charts, Pie charts as per the End user requirements.
• Used Broadcast agent server to schedule and monitor reports. Documented process and flow procedures.

Environment: Business Objects 6.5.2/5.1.7 , Designer, Supervisor, Web Intelligence 6.5, Oracle 9i, SQL, PL/SQL, Windows 2003 Server, IIS 5.0, Siebel CRM, Siebel Analytics 7.11.