CAREER SUMMARY:

• Around 8 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.
• 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
• Created and developed Parameters, 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//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 and documentation for 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 .
• 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 and documentation for 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 Confidential directors for taking decision on sales.
• Responsible for all the dealers in Confidential north America 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 Confidential 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 Confidential 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 Confidential 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

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 .
• Preparing the Project Plan and update the status of the project to the client with progress and s.
• 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

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

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

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