SUMMARY

• 10 years of experience in Software Development, Implementation and Maintenance of Business Intelligence in Designing, Administration, Analysis, Management in the Business Intelligence, Data warehousing and Database Platforms.
• Over 9 Years of Extensive experience in SAP BO and Data Warehouse Database Analysis.
• Expertise in WebI and Universe (UDT and IDT) creation and development.
• Experienced with all phases of BI Software Development Life Cycle (SDLC) such as developing, testing, migrating, administering, Security Management and production support.
• Worked on multiple BI Products like BO and Tableau
• Extensive experience in BI versions, SAP Business Objects3.0 and 4.0, 4.1 and 4.2, IDT, UDT and SAP Business Objects Web Intelligence.
• Worked as part of BO Admin work in Defined security models with row level data security, object based security etc. in SAP Business Objects Universes and Central Management Console
• Created Scheduling, Publications, users, groups, server groups and setup security architecture.
• Worked on Large enterprise SAP Universe Design which has more than 600 Tables and over 1500 joins.
• Expertise in Data Warehousing Best Practices, dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Experience includes technical support, troubleshooting, report design
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions
• Created and developed Parameterized, Drill Down and AD Hoc Reports using Webi
• Good Experience on creating WebI Reports and IDT in BOBI4.2
• Worked on Tools Structured Query Language (SQL), PL/SQL Developer, TOAD
• Good experience in writing codes and understanding data on Microsoft SQL Server
• Making the changes in development based on business requirement
• Excellent experience in Performance tuning and query optimization.
• Good Knowledge of project management tools such as Clarity and MS Project.
• Strong working knowledge in implementing the Best practices for Business Objects Enterprise.
• Expert in mentoring/training/assisting business users on Business Objects Products
• Excellent communication, decision - making, Problem Solving, Analytical, and Interpersonal skills with result-oriented dedication towards goals.

TECHNICAL SKILLS

Reporting Tools: BO 3.1, BI4.0, 4.1, 4.2, Tableau8.0 and 9.0.

Languages/Utilities: SQL, PL/SQL

Databases: Microsoft SQL Server, Oracle 9i/10g/11g (SQL, PL/SQL)

ETL Tools: SAP BW, BI 7.0 and Informatica

PROFESSIONAL EXPERIENCE

Confidential - Scottsdale - AZ

Business Objects developer (BI Lead)

Responsibilities:

• Responsible for developing reports on Business Objects 4.2 SP3
• Design of Architecture to support to full Lifecycle Development of Universes and Reports.
• Created several Service Provide reports to track their records.
• Cresting and supporting on large universes(250+Tables)
• Created several report for Client specific and Business Specific report to simply the decision making.
• Providing support on existing reports and scheduling the reports as per request.
• Created couple of Invoice reports based on Account payable and Account Receivable reports.
• Working with Clients regarding the nature of the information processing or computation needs.
• Working on creating WebI report and support on existing reports.
• Supporting existing WebI reports and modification as when user requested.
• Developed and executed unit test cases for code development includes performance and load testing as needed
• Used WebI Reports to create Reports to use direct SQL as a data source.
• Frequent interaction with Functional Analysts, Product Owners and Business to review requirements and results.
• Worked on BO Administration on providing access to users and publications and support on server related requirements.
• Participate in creating estimates of cost and effort along with implementation plans to enable timely implementation of process or report enhancements.
• Escalate issues in a timely manner as appropriate to ensure successful completion of process and report enhancements.
• Worked on custom lov’s and parameters as per end user requirement.
• Worked on Hyperlinks and shared elements.
• Working on report performance and best practices.
• Worked with users on BO training and documentation for training materials.
• Working on BO report issues based on priority of the ticket in Zendesk.

Environment: Business Objects, Webi, Universe - IDT, Oracle 11g, TOAD, and SQL Developer.

Confidential - El Segundo-CA

Business Objects developer (BI Technical consultant)

Responsibilities:

• Responsible for developing reports on Business Objects 4.2 and 4.1
• Created several patients reports to track their records.
• Cresting and supporting on large universes(200+Tables)
• Providing support on existing reports.
• Working on Agile methodology
• Working with BA’s and Data Architects regarding the nature of the information processing or computation needs.
• Working on creating WebI report and support on existing reports.
• Supporting existing WebI reports and modification as when user requested.
• Developed and executed unit test cases for code development includes performance and load testing as needed
• Worked on Prompts, Filters, query optimization and performance tunings of the report and queries.
• Frequent interaction with Functional Analysts and Business to review requirements and results.
• Design of Architecture to support to full Lifecycle Development of Universes and Reports.
• Created and modified the crystal reports for various hospitals using universe as a main data source.
• Developed Universe user Documentation guide for the End Users reference.
• Participate in creating estimates of cost and effort along with implementation plans to enable timely implementation of process or report enhancements.
• Escalate issues in a timely manner as appropriate to ensure successful completion of process and report enhancements.
• Worked on custom lov’s and parameters as per end user requirement.
• Working on report performance and best practices.
• Worked with users on BO training and documentation for training materials.
• Working on BO report issues based on priority of the ticket in JIRA.

Environment: BO Administration, WebI, Universe - IDT, Oracle 11g and SQL Developer.

Confidential, Franklin, TN

Business Objects developer (BI Lead)

Responsibilities:

• Responsible for developing reports on Business Objects 4.1 and 4.2
• Responsible for creating a Dealer facing reports to see the sales and orders for infinity/Nissan
• Created reports for dealer’s heads and Nissan directors for taking decision on sales.
• Responsible for all the dealers in Confidential side for kind of support and clarification on report side
• Created a different reports for ICAR and NCAR independently and providing the access to them as requested
• Created RDR reports for the both Nissan and infinity dealer’s and setting up the security access to see their respective dealer info
• Created BO report that has detailed level for the dealers like how many vehicles they sold for the specific month and specific quarter or year for the specific sales consultant.
• Created an opportunity reports for the dealers to identify that how many users are logged into tablet to book a vehicle
• Setting up the custom Hierarchies for proper drill operations etc.
• Created report that are having new vehicle info and as well as old vehicle info so that each dealer can take the decision on vehicle sales for each sales consultant
• Created report for the Nissan IS Director on new vehicle info and as well as old vehicle info in the same report for the specific dealer to analyses why some user are buying the other brand vehicles when they are trending.
• Worked on creating Parts performance database (PPD) reports to see the orders by each supplier.
• Created PPD reports for each Item, EIM, Model, Location, Supplier wise report
• Created reports that are useful to the Nissan director to take a decision on orders based EIM.
• Creates report which is having new item report and which is having new items with NO previous item and their respective price for their respective supplier to see the new item which is having no previous item.
• Created an Activity log report to see the procedure status whether they ran successfully or not.
• Creates Cumulated report by EIM report to see the data for entire financial year
• Creates Cumulated report by Model report to see the data for entire financial year
• Created an Item price variance history report to track the price changes by month by month based on each supplier
• Created Material cost average report to determine the average price that business has spent to complete this vehicle
• Creates unreconciled report that will have the incomplete items which is shipped by supplier but not delivered or not using in any model.

Environment: Business Objects, Webi, Universe - IDT, Oracle 11g, MS Project,, and SQL Developer.

Confidential, Houston, TX

Business Objects developer

Responsibilities:

• Responsible for developing report based on BI 4.1 and 4.2
• Gather and analyze information on existing business processes in order to make recommendations that seek to improve business systems and processes
• Worked with the BA’s and Data Architects regarding the nature of the information processing or computation needs.
• Developed and executed unit test cases for code development; includes performance and load testing as needed
• Define best practices for creating Webi reports by matching requirements to the charts to be chosen, color patterns as per user's needs, standardizing dashboard's size, look and feel etc.
• Developed Ad-hoc reports using Tableau Desktop, Excel.
• Developed @prompt filters based on business requirements
• Responsible for developing BO reports based on SAP source.
• Designed, Developed and Implemented Complex WEBI reports.
• Worked extensively with the major functionality like Breaks, Sections, Pre- defined conditions, Calculations and Ranking, Context Operators (For all, For Each and in).
• Created Custom Calendar’s to satisfy end user needs for Report Scheduling.
• Worked on different Business Change Requests to satisfy user needs.
• Frequent interaction with Functional Analysts and Business to review requirements and results.
• Design of Architecture to support to full Lifecycle Development of Universes and Reports.
• Developed and Created classes with Dimensions, Detail and Measures Objects.
• Developed Universe user Documentation guide for the End Users reference.
• Preparing the Project Plan and update the status of the project to the client with progress and achievements.
• Involved in the entire Software Development Life Cycle of the Project on multiple Enhancements.
• Scheduled the Weekly and Monthly status calls for to discuss the status and Next action Items.

Environment: Business Objects, WebI, Universe - IDT, Oracle 11g, TOAD, and SQL Developer.

Confidential, Houston, TX

BI Consultant

Responsibilities:

• Responsible for developing report based on Tableau Reporting in 8.1 and 9.0
• Ability to connect to different data sources from Tableau, presenting the good Visualization of data, Different way of using the filters and parameters.
• Worked on reporting technical design produced in the design phase.
• Worked on different Database methodologies like joins and SQl statements.
• Developed the standard reports within Tableau by connecting different databases Oracle 10g, MS SQL server.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Migrated some specific reports from lower environment to higher environment.
• New reports were created based on the business requirements in Business objects and crystal reports
• Experience in analyzing the client Requirements.
• Experience in preparing the Dashboard specification Documents.
• Involved in conceptual design of the dashboard.
• Created a drill down at the report level in crystal reports as well as in the web intelligence
• Conducted Unit Testing of the dashboard.
• Responsible for creating the Complex Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports)
• Involved in Change Requests of the Existing Dashboards.
• Met with report request owners to clarify Crystal report requirements
• Assisted business users with UAT testing of reports
• Accountable to deliver the files at on time.
• Scheduling the reports in Server
• Involved in Data connectivity to the databases.

Environment: Business Objects, Reports, Universe - IDT, Oracle 11g, TOAD, Tableau and SQL Developer.

Confidential, Houston, TX

SAP BO Consultant

Responsibilities:

• Analyze and document user requirements for enhancements to business processes and reporting. May involve investigation of third party vendors, procedures or systems.
• Produce clear and unambiguous documentation to detailed proposed solutions/recommendations.
• Lead reviews of requirements and designs with relevant stakeholders to obtain agreement and sign off of proposals.
• Participate in creating estimates of cost and effort along with implementation plans to enable timely implementation of process or report enhancements.
• Escalate issues in a timely manner as appropriate to ensure successful completion of process and report enhancements.
• Gather and analyze information on existing business processes in order to make recommendations that seek to improve business systems and processes.
• Created an Open doc link for the main report for the easy accessibility to End-Users.
• Prompts and web element concepts are used to design/implement the suppression concepts.
• The Sub-reports, Web elements, Dynamic Cascading prompts concepts are used in this project.
• Using Dynamic visibility concept, developed interactive radio buttons, List view, scorecard and charts
• Contexts are used for proving user to have access on historical and reporting date in single shot.
• Synchronization functionality in Drill down implemented for charts as well tables.
• Implemented Navigation Paths, LOV’s, and cascading functionalities using IDT.
• Converted business requirements in business/technical requirement documents.
• Designed web intelligence reports for dimensional hierarchical data
• Involved in unit testing and User acceptance testing.
• Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)

Environment: Business objects, Oracle 8i/9i, Microsoft SQL server and PL/SQL

Confidential, Fortworth, TX

SAP BO Consultant

Responsibilities:

• Created the Webi reports using Business Objects functionalities like combined queries, add queries, drill down, cross tab, formula etc.
• Writing formulas and variables based on requirement and validate the same.
• Created Web Intelligence Reports for SAP Universe. Involved in the Universe Creation process using Business Objects Designer
• Specified the joins and checked the cardinalities. Resolved loops by creating aliases and context.
• Ad-hoc reports were used for used for Business Objects user modules for various portfolios using the universes as the main Data providers.
• Implemented row level security & Object level security based on user requirement.
• Created different reports containing charts showing Rigs and Trucks income by different divisions.
• Involved in deployment process in different Environment like Development.
• Worked extensively on hierarchies for the client specific requirement.
• Created Deski & Webi Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Developed the reports using Web Intelligence and scheduled same in Info view.
• Organized data in reports by using filters, sorting, ranking and highlighted data with Alerted.
• Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Created users, groups, server groups and setup security architecture.
• Implemented Row Level, Object Level security for data restriction at Universe level

Environment: Business objects, Webi, UDT, IDT, Oracle and PL/SQL

Confidential, Houston, TX

SAP BO Consultant

Responsibilities:

• Developed several dashboards using best dashboard design concepts. Led the business from not knowing what they wanted to see, to important information that they could easily visualize on the Dashboard.
• Connected Data using Live Office, Pdf and excel.
• Responsible for creating Query as a Web Service objects to connect data to the dashboard model.
• Created and developed HR dashboards.
• Created and developed HR dashboards like Pay roll Dashboard, compensation dashboard, termination dashboard, attrition analysis dashboard, workforce dashboard.
• Connected data by developing several advanced web intelligence reports
• Created dashboards using differ components, selectors, pie charts, gauges and sliders
• Designed and developed their executive and regional level project performance dashboards.
• Dashboards were used to measure the performance of professional services engagements.
• Involved dashboard layout design and internal data mapping design.
• Experience in creating dynamic visibility.
• Good knowledge on usage of VLOOKUP in excel and drill down functionality in Webi reports.
• Worked step by step with the business in order to produce the correct business requirements.
• Dashboards were developed using Xcelsius 2008 SP3 and 2011.
• Created and Developed PP Dashboard like production Dashboards, Notification Dashboards, Production by region wise, country wise Dashboards.

Environment: Xcelsius Dashboard Design

Confidential, Centennial, CO

SAP BO Consultant

Responsibilities:

• Created Web Intelligence Reports for SAP Universe. Involved in the Universe Creation process using Business Objects Designer
• Specified the joins and checked the cardinalities. Resolved loops by creating aliases and context.
• Worked extensively on hierarchies for the client specific requirement.
• Developed the reports using Web Intelligence and scheduled some in Info view.
• Created the reports using Business Objects functionalities like - Combined queries, add queries, Drill Down, cross tab, formula etc.
• Ad-hoc reports were used for used for Business Objects user modules for various portfolios using the universes as the main Data providers.
• Implemented row level security & Object level security based on user requirement.
• Specified the joins and checked the cardinalities. Resolved loops by creating aliases and context.
• Created different reports containing charts showing revenue and operating income by different divisions.
• Involved in deployment process in different Environment like Development.
• Organized data in reports by using filters, sorting, ranking and highlighted data with Alerted.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Wrote Complex SQL Queries for Data validation purpose.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Collecting report & Visual requirements from users/business owner.
• Enhanced the Performance of the Dashboards by manipulating and using complex formulas on the Universe and Excel.

Environment: Web Intelligence, Universe Design &Xcelsius

Confidential, New York, NY

SAP BO Consultant

Responsibilities:

• Created WebI reports
• Testing the reports and schedule the reports using Info view
• Created Web Intelligence, dashboards &Xcelsius.
• Created dashboards by using live office &Quaaws connection.
• Designed and Developed Web I Reports using the features like Charts, Ranking, Drill Down and Formulae to analyze the data.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and requirements of the end users.
• Created Web Intelligence Reports for SAP Universe.
• Organized data in reports by using filters, sorting, ranking and highlighted data with Alerted.
• Created web I reports by using combined queries, merge dimension & tracking.
• Published the Developed reports in the repository.
• Creating crystal reports on multiple data sources.
• Created crystal reports by using Hyperlink
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelsius.
• Created xcelsius dash boards on Web Intelligence.
• Created dash board with dynamic visibility by using multiple components.
• Created Crystal Reports Templates to support Corporation Report Standards and color scheme.
• Created crystal reports on multiple data sources like URL & universe.
• Created dashboards using differ components, selectors, pie charts, gauges and sliders
• Designed and developed their executive and regional level project performance dashboards.
• Dashboards were used to measure the performance of professional services engagements.

Environment: Web Intelligence, xcelsius & Crystal