SUMMARY

• Having 17 years of development and leading experience in Business Objects Universe, WebI reports of which 3+ Years with State Clients.
• 1 Year with The State of Florida and currently working for State of North Carolina for last 2+ years.
• Exceeded client expectations and delivered projects on time and within budget. Always thrive to meet customer needs.
• Can provide deep subject matter/functional expertise to recommend architecture and integration solutions related to Business Objects Enterprise products within a solution environment for my clients to achieve their goals.
• Experience in Full Life Cycle implementations for 6 SAP BO projects involving Requirement Gathering, Analysis, Planning, Design, Development, Implementation, Testing, User Training and Production Support using BO.
• Extensive experience in SAP Analytics Cloud and designed key stories for top executives of the organization.
• Worked in Department of State, HR, Banking, Healthcare, Manufacturing, Finance, Retail, Utilities and Law domains.
• Worked as a Business Objects Data Architect and Dimensional modeler as well.
• Expertise in SAP BO BI 4.x suite of products and completed trainings through SAP Partnership programs.
• Good experience in leading, design, development, effective planning & delivery of BO projects on time and costs.
• Interacted and captured user requirements in person with end users to provide reporting solutions for new projects, change requests and minor enhancements and convert them into High Level Design document for signoff.
• Designed & developed quality BO reports using client’s standards, defined templates, and ensured consistency across report deliverables. Experienced in onshore/offshore model and lead a team of 6 members for two and half years.
• Extensively worked as a Universe Designer and WebI Reports developer for Data Warehousing projects using Business objects product suite with Oracle and SQL Server backend databases.
• Expert in creating dashboards using Design Studio 1.6 and display data using scorecards, pie charts, info charts.
• Addressed complex issues during design & development of SAP BO projects and ensure to meet deliverables.
• Expertise in migrating objects between various environments from Dev to Test and from Test to Production implementations. Delivered KPI Dashboards, Stories, Budgeting and Forecasting for Planning using SAC.
• Experience in training Business Objects End Users. Conducted 75+ sessions for Beginners/Intermediate/Expert users.
• Have good technical knowledge and understanding of Oracle database versions 10g/11g/12c.
• Experience in production support, capable of solving issues raised in Production and addressing the ad hoc reporting needs of the customer. Implemented row level security for BO reports at report level, data level.
• Good understanding of dimensional data modelling and star schema.
• Through understanding of the capabilities of SAP Business Objects Toolset. Member of SAP BO Center of Excellence (CoE) team in Tata Consultancy Services (TCS) for more than 6+ years and addressed POC for various TCS clients.
• Have the experience in prioritizing Change Requests with Clients and manage work stacks with onshore/offshore team.
• Capable of working as an individual and as a team to accomplish project deliverables on time.
• Quick learner of business applications with ability to meet deadlines and work under pressure.
• Solution oriented, possess strong analytical and problem - solving skills, attention to detail along with good oral and written communication skills. Ability to work on multiple enhancements, change requests, new development to meet the deliverables on time by shuffling the priorities.

TECHNICAL SKILLS

Enterprise Business Intelligence Solutions: SAP Business Objects Business Intelligence Platform 4.3 / 4.2 / 3.1

BO Reporting Tools: Web Intelligence XI 3.0 / 4.2 / 4.3, Web Intelligence 4.2, SAP Analytics Cloud (SAC), Crystal Reports.

BO Designing Tools: Information Design Tool (IDT), Universe Designer UDT XI 3.1

BO Administration Tools: Central Management Console (CMC), Fiori/BI Launch Pad

Databases / Data Warehouse: SAP BW, HANA, Oracle 9i/10g/11g / SQL Server 2005/2008/2012

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Software Developer

Responsibilities:

• Responsible for query and report development across SAP modules (FICO; MM; PS; PM; FM; SD; HR; CRM) from underlying BW data source and from other systems.
• Responsible for report development using various reporting technologies Business Objects WebI, Lumira, SAP Analytics Cloud and Analysis for Office.
• Responsible for system testing during upgrades, business function activation, or installs of new warehouse content.
• Responsible for working with business users and clients to gather and document business requirements and develop solutions to satisfy business needs.
• Responsible for supporting and training functional team members in report development and design.
• Responsible for developing all documentation related to system changes per Confidential change control policies and procedures.
• Created reports in reconciliation of Financial and lane transaction for finance departments.
• Key resource to create new WebI reports and modify existing WebI reports for enhancements and modifications.
• Convert existing Crystal reports to WebI reports which are not producing clean excel outputs during report schedules.
• Work along with SAP Functional team members and design & develop WebI reports as per customer requirements.
• Validate the new reports for consistent data and suggest the customers and design the reports for optimal performance.
• Created reports for North Carolina Turnpike Authority (NCTA) like Turnpike Awards and Expenditures for Projects and by Vendors. Build various reports for Public Transportation Division (PTD) and various Transit divisional reports.
• Responsible for creating new universes using SAP Information Design Tool (IDT), enhance existing universe using IDT as per Confidential reporting requirements for building SAC Dashboards.
• Design and Build SAC Dashboards to highlight KPI, highlight performance for past months, quarters.
• Using SAC Planning, done a high-level planning and simulated the forecasts. Created Budgets, plans and forecasts and monitored the cash flow demand as per finance team requests.
• Imported data into planning and analytic models on a periodic basis. Created planning and analytic models to support KPI Dashboards and reporting and prepare it for analysis.
• Edit the data in the SAC models, defined categories and set hierarchical relationships and created custom formulas to support the business needs in SAC reporting.
• Responsible for querying and report development across SAP modules like FICO, MM, PS, PM, FM, SD, HR & CRM using BEx tools & WebI by consuming BEx Cubes or Info Providers.
• Act as a reporting lead to address their business reporting needs and drive them in the right path to success of the organization.
• Enforce security and provide access to web intelligence reports within the company to designated team members and employees who is intended and targeted users.
• Specialized in Dimensional Modelling, OLAP Cubes, Top/Down or Bottom/Up Approaches, RDBMS concepts, Data warehousing technologies.
• Being a reporting expert, work closely with team and understand their Business, Process and leverage the reporting functionalities.
• Responsible for writing functional and technical specifications, testing reports and training team members.
• Discuss with clients and team members on issues, defects and requests and resolve them by suggesting the right reporting SAP Business Objects reporting tool.
• Specialized & responsible for query and report development for Business Warehouse (BW) data sourced from other systems.

Environment: SAP Business Objects 4.2 SP7, Information Design Tool (IDT), WebI Reports, SAP Crystal Reports 2016, SAP HANA Studio, SAP Lumira Discovery, SAP Crystal Reports for Enterprise, Oracle, SAP Analytics Cloud (SAC), SAP ECC, SAP BW, BI Launch Pad, BEx Query Designer, SQL, BO Central Management Console (CMC), Windows, Microsoft Office Tool Set, Web Intelligence Rich Client and Analysis for Office (AO).

Confidential, Jacksonville, FL

Software Developer

Responsibilities:

• Design and developed 6 major Universes to address all companywide BO reporting needs. Budget Universe, HR Universe, Payroll Universe, Leave Universe, Benefits Universe and Adhoc Universe.
• Educate NGA client team in best practices of Universe Design and development in WebI reports.
• Worked with DBA team to create new tables for Business objects and Materialized Views to address reporting needs.
• These universes were created to address current reporting needs as well any adhoc future reporting needs as well.
• Prepared universe Report Technical Design Documents (TDD’s)
• Worked with Business to get signoff for Functional Design Documents (FDD’s).
• Created highly formatted WebI reports for printing via PDF and excel version for analysis purpose.
• Key person to implement security at report level and at data level.
• Perform validation for WebI reports and work with QA team to fix HP ALM defects.
• Based on the User running the WebI report and his/her role enabled access to run the report for all agencies or to his/her home agency, used cascading prompts, optional prompts.
• Used derived tables to replicate complex business reports and implemented row level security via free hand SQL prompts in the data foundation.
• Assigning reports to other team members once universe development is complete for WebI reports and help them in addressing their WebI reporting needs and overlook their developed reports and request for corrections in design.
• Provide technical direction and support for systems development, requirements analysis, component specifications, business and technical procedures, component and system testing, system implementation, documentation and training in WebI report development.

Environment: SAP BO 4.2 SP5, Information Design Tool, WebI Reports, Crystal Reports, Oracle 12c, Apex Reports, BO CMC.

Confidential, Los Angeles, CA

Business Objects IT Senior Business Analyst & Architect

Responsibilities:

• Design and develop pending WebI reports for Supply Chain and Logistics users.
• Educate team in best practices and development in WebI reports.
• Perform data validation for WebI reports and work with IT team to fix HANA views.
• Work closely with Supply Chain Business Analysts and users to capture report requirements and convert them into FRD documents.
• Make changes / modifications to existing WebI reports as per user requests.
• Provide technical direction and support for systems development, requirements analysis, component specifications, business and technical procedures, component and system testing, system implementation, documentation and training in WebI report development.
• Major responsibility will be supporting SMAR project, application development, data modeling, system testing and administration.
• Develop, implement and execute system test plans, documents results.
• Develops and maintains BOBJ report procedures, etc.

Environment: SAP BO 4.1, IDT, SAP Lumira, WebI Reports, Crystal Reports, HANA, SQL Server, SAP ECM, SAP BW.

Confidential, Los Angeles, CA

Business Objects Technical Lead & Architect

Responsibilities:

• Made enhancements to existing BO Universes.
• Created various GL reports, Accounts Payable, Accounts Receivables, Income and Expense statements for various departments, Personal Accounts Statements, Billable Hours, Classifications of expenses into various GL accounts.
• Grouping of various expenses into Custom accounts.
• Created Story boards using SAP Lumira 1.30.
• Prepared, Visualized, Composed and Shared Dashboards using SAP Lumira 1.30.
• Created Infographic Dashboards and shared the same for Desktop (IE) and Mobile Users.
• Created and presented various chart options for SAP Lumira Users.
• Educate 6 team members in WebI report development and universe designing.
• Defined daily backup and user security of BO reports and universes.
• Created publications & schedules and educated the team for the same.
• Designed different time variant prompts and predefined filters in BO Universes.
• Created Free Hand SQL WebI reports to report Real Time Data from 3E application database.
• Educated team members in scheduling reports, formatting them, publish report content as attachments and emails contents. Helped them in resolving issues during report and universe design and development.
• Created new folders and reports under Public folders and granted access to appropriate user groups.
• Involved in Month End Close data validation between application database and Data Warehouse for key measures.
• Leveraging Universe, reports and folder security for all BO users along with maintenance of user accounts.
• Discussed with DBA’s and converted heavily used views into tables to enhance report performance.
• Educated the team on BO reporting requirements gathering from various end users.
• Managing BO Licenses, shifting users from concurrent to Named users and expanded the landscape with more users and licenses.
• Created custom calendars and scheduled reports based on them. Maintaining universe and user security via CMC.
• Created new users and groups and grant them access to appropriate universe and reports. Created New Relational Universe Connections.
• Scheduled weekly time monitor reports and share notifications to attorneys to release their time entries for prior week. Created various publications and educated the team on dynamic filter of data based on recipient’s data content on reports.
• Acted as a Single Point of Contact for all BO requirements. Raised tickets with SAP, generated logs and resolved issues in a timely fashion.
• Installed BO 4.2 and configured BO DEV server. Defined backup and restore strategies in DEV BO server from Prod
• Configured SSO using Windows AD for BO Users in Prod & Dev environments.
• Provide emphasis on validating key measures in Data Warehouse with respect to 3E after each month end closing.

Environment: SAP BO 4.2 SP2, IDT, SAP Lumira 1.30, WebI Reports, Crystal Reports, GL Accounts, SQL Server, Thomson Reuters Elite/3E.

Confidential

Business Objects Technical Lead

Responsibilities:

• Created various GL reports for many GL users (3000 users) within the bank.
• Created Monthly account statements for expenses incurred in various GL accounts.
• Created Storyboards using SAP Lumira 1.28 from different sources like Excel, Universes and Free Hand SQL.
• Deployed Lumira Dashboards / Storyboards for Desktop, Tablet and Mobile users.
• Classification of expenses in to various GL reports and reported the same to Business Managers, departmental heads, account managers.
• Responsible for managing SOX Audit Reports for Monthly & Quarterly balances and other SOX audit reports.
• Created Accounts Payable, Cash in, Cash Out reports, Accounts Receivables, Cost account information.
• Created various charts on Income and Expenditures from various sources.
• Created various GL reports as requested by different users for their departments, GL Hierarchy reports, Maintained GL account data specific to account managers, drill down into detailed expense and income statements by month, department, divisions.
• Created GL Year to Date, Month to Date reports. Compared the same against Actuals Vs Budget.
• Created Applications/Dashboards using Design Studio 1.6 as part of SAP BI 4.1 upgrade.
• Developed Bank User Login Dashboards via Design Studio 1.6 and several other dashboards as per user requirement.
• Created Dashboards with Hierarchy, Scorecards, custom measures, top N clients, crosstabs, Global Filters.
• Created 2 applications and linked them via Report-to-Report Interface (RRI) and Jumped from division to department slice of data. Responsible for design and development of all Design Studio applications.
• Created applications and dashboards in Design Studio 1.6 using UNX universe as a data source.
• Responsible for enhancing existing universe and new reports for Privacy Reporting.
• Responsible for ACBS Non-Operation Reports development.
• Responsible for Universe, WebI report enhancements within 38 Subject Areas owned by our BO team.
• Responsible for converting DeskI to WebI reports in a phased manner in order to migrate to BO 4.1
• Responsible for BO 3.1 to 4.2 migration/upgrade activities.
• Responsible for migrating objects within various DEV, TEST and PROD environments.
• Involved in sizing of BO landscape and troubleshoot user issues.
• Install patches, configured BO servers and upgraded/migrated contents from 3.1 to 4.2.
• Responsible for BO on call as primary and secondary during the supporting weeks.
• Responsible for conducting monthly BO service center level training for clients.
• Responsible for designing reports in BO 4.1 for POC purpose in the view of migrating into BO 4.1 environments.
• Created Multi Source universe in IDT supporting 4.1 WebI reporting solution.
• Responsible for implementing CM’s in PROD for BO changes assigned.
• Responsible for implementing universe security, report access within environments for clients.
• Created Publications and schedules for BO reports in PROD.
• Responsible for assigning tasks to offshore team, peer review of their changes.
• Involved in peer review for universe and report enhancements made by the team.
• Providing universe enhancement estimate, existing or new report enhancements to client manager.
• Worked on multiple enhancements at the same time and shuffled priorities to make them available in PROD on time.
• Involved in Disaster recovery activities of DEV, TEST and PROD servers.
• Responsible for implementing BO User Access Requests (UAR’s) in PROD within the subject areas owned by our team.
• Responsible for creating various ETL reports from Informatica repository to monitor the daily loads in PROD.
• Responsible for addressing BO incidents raised by the clients during on call support.
• Coordinating work with offshore team, assigning work to team, monitoring/valuation the status for the same.
• Demonstrate the capabilities of the Business Objects platform to groups of people. Clearly articulate the functionality and advantages of the platform.

Environment: SAP BO XI 3.1, BO 4.1, Universe Designer, IDT, DeskI, WebI Reports, Crystal Reports, GL Accounts, Design Studio 1.6, SAP Lumira 1.28, Oracle 10g, Oracle 11g, SQL Server, TOAD Oracle SQL Editor.

Confidential, North Carolina, NC

Technical Lead for Data Cleansing

Responsibilities:

• Extract data from Smart Team Production system using BO DeskI reports into excel spreadsheets.
• Provide it to business for data validation and cleansing.
• Loads cleansed data into oracle tables and validate data translation rules.
• Send erroneous data to business for cleansing.
• Provide cleansed data from oracle tables into excel spreadsheets to migrate data into Smart Plant Foundation.

Environment: SAP BO XI 3.1, Universe and WebI Reports, Oracle 9i, Microsoft Excel Spreadsheets, TOAD Oracle SQL Editor.

Confidential

SAP BO Consultant

Responsibilities:

• Completed 2 CR’s on SAGE during this period.
• Acted as a SPOC for enabling access to SAGE BO reports for business managers and their team members.
• Involved in SAGE Phase III Payer project scope & development.

Environment: SAP BO XI 3.1, Universe and WebI & Crystal Reports, Teradata, Teradata Administrator and Teradata SQL Editor

Confidential

BO Consultant

Responsibilities:

• Solely responsible for development of a Single Universe that is designed from a complex OLTP environment which comprised of more than 350 database tables.
• Designed the security model for BO implementation and data restriction within the reports based on report users.
• Responsible for entire report developments in this project.
• Involved in performance tuning of the universe. Designed complex measure objects using Analytic functions in Oracle 11g. Implemented the complex business process involved in clinical trials within the BO Universe.
• Designed performance tuned complex reports with less report fresh timings.
• Developed a unique documentation for the complex universe in an excel format.

Environment: Trident Admin & EUS modules, SAP BO XI 3.1, Universe and WebI Reports, Oracle 11g, PL/SQL Developer.

Confidential

Project Leader

Responsibilities:

• Single POC for requirement gathering, design and development of the data warehouse for this project.
• Designed & developed one universe as per project requirement.
• Developed 40+ DeskI reports for end users.
• Acted as a coordinator between business end users, RSS application production team and ETL team.
• Designed the dimensional modelling for this project along with ETL team.
• Identify the problem areas and timely resolution of defects raised in UAT.
• Translating the business requirements into design document and technical requirement document.
• Ensured timely escalation of issues to responsible groups and followed through to the resolution and closure for on time closure of issues.

Environment: RSS Application, Informatica 8.x, BO Universe, DeskI Reports, Oracle 10g, PL/SQL Developer, SQL Developer.

Confidential

Dimensional Modeler, Senior BO Universe Designer and Reports Developer

Responsibilities:

• Confidential CISP Project was selected as the best project in UK ERU domain.
• Single POC for all reporting requirement in this project.
• Responsible for providing technical recommendations to the client and the team.
• Providing development task estimates for business objects to development manager.
• Involved in timely resolution of bugs raised during the testing phase.
• Created 82+ WebI reports in total for business users and 5 adhoc reports as per user request.
• Designed & developed ten universes as per project requirement during the two phases in the project.
• Creating and maintaining Users, Groups, and document access to end users in Development, Testing and Live Environments for WebI reports.
• Involved in migrating Universe and reports from Dev to Test and from Test to Production environments.
• Involved in giving handover to the production support team during the warranty period.
• Providing Support to real business end users until they are familiar with the reports.
• Providing development progress via meetings and weekly status report to customer.

Environment: Primavera, Informatica 8.x, WebI Reports, BO Universe, Oracle 10g, PL/SQL Developer, SQL Developer