SUMMARY

• 9+ 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.
• Around 2 years of onsite experience.
• Expertise in Webi and Universe (UDT and IDT) creation and development.
• Experience in various BI tools like Tableau Desktop 8.1, 9.0, Informatica, SAP Business Objects3.0 and 4.0, 4.1 and 4.2, Dashboards 4.0 (formerly Xcelsius), IDT, UDT and SAP Business Objects Web Intelligence.
• Over 3+ years of good working experience in agile methodology.
• Worked as part of BO Admin work in 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.
• Expertise in designing Universes for Performance Management and Reporting needs.
• Expertise in dimensional data modeling, Star Schema Modeling, fact and dimensional table design, physical and logical data modeling.
• Experience in preparing the Dashboard specification Documents.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Develop reports, dashboards using Tableau for quick reviews to be presented to Business and IT users.
• Good experience in Oracle and SQL
• Experience includes technical support, troubleshooting, report design
• In - depth knowledge on Tableau Desktop and Tableau Server
• Created and developed Parameterized, Drill Down and AD Hoc Reports using Webi
• Good Experience on creating Webi Reports and IDT in BOBI4.2
• Worked in third Party Tools PL/SQL Developer, TOAD
• Making the changes in development based on business requirement
• Defined security models with row level data security, role based security etc. in Business Objects Universes and Central Management Console (CMC)
• 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: Tableau8.0,9.0, BO 3.1,BI4.0,4.1,4.2.

Languages/Utilities: SQL, PL/SQL

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

ETL Tools: SAP BI 7.0 and Informatica

Operating Systems: Windows2000/2003.

PROFESSIONAL EXPERIENCE

Confidential

BI Lead and onsite coordinator

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

Responsibilities:

• Responsible for developing reports on Business Objects 4.1 and 4.2
• Created several patients reports to track their records.
• Supporting on existing reports.
• Working on Agile methodology
• 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
• 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.
• 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.

Confidential

BI Lead and onsite coordinator

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

Responsibilities:

• Responsible for developing reports on Business Objects 4.1 and 4.2
• Responsible for creating a Dealer facing report 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 Nissan north America side for kind of support and clarification on report side
• Created a different report 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) report 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.

Confidential

SAP BO 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.

Confidential

Tableau 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.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
• Experience in analyzing the client Requirements.
• Experience in preparing the Dashboard specification Documents.
• Involved in conceptual design of the dashboard.
• Experience in Data connectivity to the data bases.
• Conducted Unit Testing of the dashboard.
• Experience in Designing of the Dashboard according to color guide given by client.
• Involved in Change Requests of the Existing Dashboards.
• Accountable to deliver the files at on time.
• Scheduling the reports in Server
• Involved in Data connectivity to the data bases.