SUMMARY

• Around 10 years of experience in as a Analytics role BI (SAP BO) and Data Visualization (Tableau) tools/techniques experience by solving business problems & providing analytical solutions to clients.
• Working with enterprise wide business and IT senior management to understand reporting and data analysis needs.
• As an Architect working closely with Business Analyst and customers in the gathering of requirements for reports and dashboards. Have extensive experience working with BO WebI tool.
• Be principally responsible for designing BO universe layer for business intelligence solutions
• SAP BO Universe Designer/ Architecture, schema design, modeling, development, trouble shooting.
• Requirements gathering from Business and create the specs for development of Universe Design.
• Hands - on experience in all phases of Software Development Lifecycle (SDLC) using Iterative, Agile and other internal SDLCs and technology delivery frameworks.
• Expertise in SAP Business Objects Development, QA and production support and Administration.
• Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Modeling.
• Installation and setup of servers, administration and support of Business Objects (BO 4.0, 3.1 and XI) development provide application support.
• Perform Row level securities, Universe and Reports Migrations, Authentications, Scheduling, and Universe Backup and Tuning Reports and Universe get better performance.
• Interact with users to document and analyze business requirements and deliver results appropriately.
• Development and Support environment & Admin, Audit Reporting based on business needs, to resolve defects as per agreed SLA and working on ServiceNow Tickets on priority.
• Experience inBusiness Objects XI 4.2, 4.1 and 3.1, R2, IDT, Universe Designer, Desktop Intelligence, BI Launch pad, Web Intelligence/Info view and Publishing Wizard, CMC, SDK.
• Crystal Reports 2008/XI/10/9.0, Tableau 8.3/9.0/9.1 Desktop,Server in various versions.
• ETL Tools: Oracle NSI Scheduler, Informatica 8.5/7.1, BO Data Services XI 3.2, BO Data Integrator 11.5
• RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005, Teradata V12, Sybase, SQL Server
• Programming Languages:SQL, PL/SQL
• Front End Tools:DBArtisian, ERwin 4.1, TOAD and SQL Developer
• Operating Systems:WIN XP/2003/2000, UNIX
• ERP:SAP R3, SAP BW/BI 7.0
• Expertise in various DB Databases skills like, SQL & PL SQL, SQL Server, Oracle, Teradata and Sybase.
• Experience of playing various key roles such as Module Lead, Quality Analyst, Developer, tester etc. from offshore and onshore working with various clients.
• Proficiency with SQL and other database tools to store, organize, retrieve, and manage data for Data analysis. SQL tuning and Performance tuning techniques.
• Excellent interpersonal communication skills and influencing skills. Demonstrate strong consultative and engaging presentation skills Self-motivated and strong team player.
• Experience in Oil & Confidential, Telecom-Media &Entertainment, Health Care/Life Insurance, Insurance and Banking/ Financial Services Domain.
• Software development background, with expertise in Scrum, Waterfall, and hybrid methodologies.
• Extensive knowledge in creating BRD, FRD and RFP documents.
• Provides Estimates for Planning, Budgeting, Development execution of automated test cases.
• Experience of playing various key roles such as Module Lead, Quality Analyst, Developer, tester etc. from Onshore and Offshore working with various clients.

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

SAP BI BO Tech Lead

Responsibilities:

• Working as Tech Lead (12 team size) for the Development and Production Support project for the ETL Tableau and SAP Business Objects Technologies responsible for New Development and production support of Customer Requirements coordination with technical team.
• Responsible for developing reports on Business Objects 4.2 and 4.1
• Providing support on existing reports.
• Working on Agile methodology and Certified Scrum master.
• Working with BA’s and Data Architects regarding the nature of the information processing needs.
• Developed and executed unit test cases for code development includes performance & load testing.
• 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.
• Having experience on handling various customers, understand their requirements and involving in full product life cycle of the project.
• Involved in Development, Production Support, Migrations and BO Server Administration (CMC).
• Generating Sub Reports, Hyperlinks and Graph Reports by using chart expert of SAP BO Reports and developed 100+ reports.
• Creating Users, Groups and Access Levels for Security by using Central Management Console (CMC).
• Creating Publications and publish all the reports developed from BO Reports to the end user.
• Extensively used Data validation SQL to verify if the data pulled by the report is correct and compared to the database data and to verify if the joins used in query are correct.
• Created a backup of BO Reports and universe in BIAR format by using Import Wizard
• Utilized all Tableau products including Tableau Desktop, Tableau Server, Tableau Reader and Public.
• Experience in end to end development of a new set of reports, dashboards & KPI Scorecards.
• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters and parameter, drill-up and Drop-down menu option and Parameterized and Linked reports using Tableau.
• Experience in creating aggregates, hierarchies, filters, quick filters, calculated measures.
• Expertise with creating solution driven views and dashboards by developing different chart types including Line Charts, Bar Charts, Pie Charts, Histograms, Waterfall Charts, Gantt Charts, Donut Charts.
• Using Service Now tool for the tickets as incidents, change request and RITMs based on the User's demand. Investigate new/existing issues in Customer Requirements.
• Clearly document all findings in the issue tracking system as SharePoint.
• Maintaining issue tracking system (SharePoint) daily. Provide feedback to the clients and Onsite managers (IM Owners).
• Generate routine and ad-hoc reporting and analysis to assist in evaluating production performance and resolving issues
• On call support for Enhancements and Issues for the Existence reports.
• Generates the Reports based on the Data loading in tables JOB SET dependencies.
• Preparing documentation as per the work stages. Like DOU (Document of Understanding), FRD (Functional Requirement Document) and Unit test cases.

Environment: Business Objects XI 4.2, 4.1 & 3.1, R2, UDT & IDT Universe, Desktop Intelligence, BI Launch pad, Web Intelligence/Info view and Publishing Wizard, CMC, Informatica, Oracle NSI Scheduler.

Confidential, New York City, NY

SAP BI 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)

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

Confidential

Sr. Software Engineer

Responsibilities:

• Interacting with Customers, understanding their requirements and involving in full development life cycle of the Account.
• Creating a Project plan and responsible for smooth delivery without any hassles.
• Reports migration from Actuate to Crystal using Monaco DB.
• Expertise in gathering, analyzing and documenting Business Requirements, Functional Requirements, System Test Cases and Use Cases, Performance Testing Requirements, and Data Specifications for Business Objects Universes and Reports.
• Expert in creating complexWebIReports(Ad-hocReports, FrequencyReports, Summary Reports, Drill Down, Dynamic Grouping, Graphical, agingReports)
• Handling all the performance issues by tweaking the reports or queries where required.
• Coordinating with team and getting the work done from them. Helping them if required
• Tuning at DB Query level or at Report level based on the situation.
• Responsible of 2 Months post Production support after the customer Go Live.

Environment: Business Objects BOXIR3.1, Crystal reports 2008, InfoView, Teradata, Oracle and Toad.

Confidential

Consultant

Responsibilities:

• Interacted with Acquisition Deal Team, Investment Controllers and Asset Managers for requirement gathering and defining business processes/workflow diagrams.
• Extensively involved in setting a new BO 3.1 Environment.
• Having experience on handling various customers, Understand their requirements and involving in full product life cycle of the project.
• Interacting with the team and getting the work done from them.
• Involved in Development, Production Support, Migrations and BO Server Administration (CMC).
• Generating Sub Reports, Hyperlinks and Graph Reports by using chart expert of SAP BO Reports and developed 100+ reports.
• Creating Users, Groups and Access Levels for Security by using Central Management Console (CMC).
• Creating Publications and publish all the reports developed from BO Reports to the end user.
• Extensively used Toad to verify if the data pulled by the report is correct and compared to the database data and also to verify if the joins used in query are correct.
• Developed Crystal Reports by using Stored Procedures etc.
• Created a backup of BO Reports in BIAR format by using Import Wizard.
• Requirement Collection, Documentation & high-level design.
• ConfiguredWebIreports2008 to developreportsusing Custom Coded functions.
• Updated and maintained Universes to meet new reporting requirements.

Environment: Business Objects XI 3.1, Crystal reports 2008, InfoView, Oracle, Sybase and Toad.