PROFESSIONAL SUMMARY:

• An SAP Certified Associate, Having 12+ years of experience in Data warehouse and Business Intelligence Systems Analysis, Design, Development, Implementation and maintenance.
• Immense work experience in Business Intelligence tool SAP BUSINESS OBJECTS 4.1
• SAP Certified Associate in SAP Business Objects
• Expertise in installation, configuration, deployment and maintenance of SAP Business objects applications usingIDT, UDT, CMC, CCM, Desktop Intelligence, Web Intelligence, Import Wizard, Life Cycle Manager, Query Builder, Live Office, QAAWS and Promotion Management Tool.
• Worked extensively on SAP Lumira, Design Studio and Explorer tools.
• Created dashboards using SAP Dashboards 4.1 and published the dashboards on IPAD using Dashboards SP 05.
• Experience in Leading and executing the Client’s Business Intelligence initiatives, propelling innovative ideas and techniques to save cost and increase user adaptability in BI space.
• Acted as a scrum master and executed complex BI projects within budget and time frame.
• Used BO SDK to develop customized BI solutions to enable users with automated and self - service BI applications. Developed custom infoviews.
• Developed Self-Service tools in BI product portfolio to empower users to understand data better when they visualize it.
• As part of BI COE, Conducted knowledge sharing sessions on weekly basis to share reusable BI solutions and to enhance value as subject matter experts to the business.
• Proficient in all phases of Software Development Life Cycle (SDLC) and Agile methodologies.
• Extensively involved in architecting and implementing Business Intelligence projects across multiple domains.
• Extensive knowledge in Operational and Dimensional Data Modelling techniques.
• Experience in ETL tools like IBM InfoSphere DataStage 9.1 and Informatica.
• Experience in interactive and executive dashboard design using Tableau Desktop 8.X and Tableau Server 8.X
• Implemented and proposed BI best practices with in the projects.
• Sound knowledge of Effort estimation, Resource planning and execution of complex SAP Business Objects, Tableau and other Business Intelligence solutions.
• Established effective and proactive communication with all the stake holders of the project teams.
• 10+ years of experience with Netezza, DB2, Oracle, Teradata and other SQL databases.
• Knowledge in Testing and Support of distributed, Client/Server and web based BI and ETL solutions.
• Collaboratively worked with customer team(s) & project resources to capture test scenarios, scripts and data tests to ensure effective test cycles.
• Worked with Business Objects utilities (COM, .NET and JAVA SDK) in maintenance and development of Business Objects environment. ed with performance s for outstanding contribution to EDW Projects.
• Excellent communication skills, ability to work as a team or individually, ability to learn new technologies quickly.

TECHNICAL SKILLS:

Business Intelligence Tools: SAP BO 4.1/3.X ( Information Design Tool, Dashboards, Designer, Reporter, BO Auditor, Infoview, CMC, CCM, DeskI, WebI, Crystal Reports, Designer, Import Wizard, Report Conversion Tool, Life Cycle Manager, Explorer, Query Builder, Dashboards and Live Office), SAP LUMIRA, DESIGN STUDIO and EXPLORER.

Scheduling and Admin: Info Burst

ETL Tools: Informatica and IBM Data StageDash boarding and Visualization Tools: BO Dashboards, Tableau Desktop 8.X and Tableau Server 8.X

Databases: Netezza, DB2, Oracle, SQL Server 2008, Teradata and SAP HANA.

Test Management and Defect Tracking Tools: Manual Testing, TOAD, SQL Developer, HPQC, Confidential Pipeline, CQSR.

Versioning Tools: Borland Star Team, PVCS and Ebiexperts Version Manager

Methodologies: Waterfall, Agile Methodology, N-Tier architecture, OOP Concepts, Complete SDLC

Industries: Banking, Retail, Finance and Insurance

Operating Systems: Windows 95/98/XP, windows NT/2000 and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

BI Architect

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• As a BI lead role, Implemented Migration process for Business Objects XI 3.1 to 4.1 such as readiness assessment and deployment plan, Migration and system Upgrades, Co-Existence Planning, Deployment services and delivery.
• Developed Self-Service BI application Infolite to give ownership of the data back to the users, increased adoption of analytics and access the dashboards on their mobile devices.
• Lead Business Intelligence COE with focus on common solution design and effective asset management.
• Leveraged best practices in BI implementation to efficiently use infrastructure and to produce successful project results.
• Involved in fixing the issues caused in the conversion to 4.1 and created documentation for best practices to be followed prior conversion and post conversion and also the issues that may rise in the conversion.
• Providing technical solutions, resolving issues with deliverables, performing technical reviews and guiding the team.
• Handling Production Implementations and Support of BO solutions, Administration of BI (Business Objects).
• Worked on creating new WebI reports by creating a universe using oracle data source and then creating WebI reports which has lot of complex functionalities like Hide/Unhide, Input Controls and sub queries.
• Worked on the SQL tuning and optimization of the Business Objects reports.
• Worked on Promotion Management tool for creating the jobs for moving the universe and reports from one environment to other.
• Worked on designing executive level Dashboard that shows high level metrics. Dashboard included customers detail drilldowns, threshold gauges, alerting mechanisms a pop report.
• White boarded closely with the business in order to map out the most valuable visualization elements on the dashboard.
• Customized few metrics dashboard in such a way that the dashboard is supported in IPAD using the components that supports in IPAD as all the components available in Xcelsius are not supported on IPAD.
• Developed Complex Universes by linking different data sources.
• Installed Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
• Designing and developing Tableau Reports, Documents and Dashboards as per specified requirements and timelines and presenting them in a variety of formats to users.
• Used Tableau Desktop 9.0 to analyze and obtain insights into large data sets.
• Worked Tableau Server 9.0 to publish the dashboards and setup the security for interactive dashboards.
• Interacting with Business Sponsors, Business Analysts from Business to understand and gather requirements for new projects and enhancements.
• Creation of Project Deliverables and assigning the work tasks to the team.
• Presentation of Project status to PM and DM on regular basis (WSR).
• Contributed and Anchored KM, CM and DP activities within the Project.

Environment: SAP Business Objects 4.X/XI3.1, Desktop Intelligence, WEBI, Designer, Oracle 10g, Informatica, Tableau.

Confidential, Wilmington, DE

BI Architect

Responsibilities:

• Worked closely with the data architects in ensuring the data cohesiveness and ensured appropriate performance tuning is in place
• Configured and enabled the SSO using the Windows AD Authentication.
• Worked extensively with the project teams in implementing BI best practices, which saved project cost and time.
• Developed Complex Universes by linking different data sources.
• Provided Installation road map for Business Objects Enterprise and Published reports on Business Objects Enterprise Server and got involved in Business Objects Enterprise Administration.
• Used Tableau Desktop 8.X to analyze and obtain insights into large data sets.
• Worked Tableau Server 8.X to publish the dashboards and setup the security for interactive dashboards.
• Representing BI Operations team at Business Change and Technical forums.
• Interacting with Business Sponsors, Business Analysts from Business to understand and gather requirements for new projects and enhancements.
• Responsible for the execution of the work requests and ensure the on time delivery to Validation and Production environments.
• Updating the project status to stake holders on regular basis as per the project plan. Giving BO team updates in monthly project review meetings.
• Creation of Project Deliverables and assigning the work tasks to the team.
• Preparation of MSR (Monthly) and MTR (Quarterly) reports and submitting them to SQA review.
• Creation of Projects and allocation of Budget and Staffing in Project Management portal.

Environment: SAP Business Objects 4.X/XI3.1, Desktop Intelligence, WEBI, Designer, Oracle 10g, Informatica, Tableau.

Confidential

Technology Lead

Responsibilities:

• Managing BI Operations and Development team with total strength of 8 resources.
• Analyzed, designed, developed and deployed a Global wide reporting solution using Business Objects and Gathered business requirements, developed Functional Specification Documents, Technical Specification Documents for Universes and reports.
• Implemented global BO Migration strategy for Business Objects XI R2 to XI 3.1 such as readiness assessment and deployment plan, Migration and system Upgrades.
• Installed and configured BOE XI 3.1 Environment across clustered and stand-alone servers.
• Implemented 3rd party security authentication (WINDOWS AD) in BO apart from Enterprise Authentication.
• Configured and enabled the SSO using the Windows AD Authentication and Kerberos.
• Handling Production Implementations and Support of BO solutions, Administration of BI (Business Objects).
• Worked extensively with (@select, @aggregate aware, @where and @prompt to overcome the problems with database when integrating with Business Objects.
• Developed Complex Universes by linking different data sources.
• Created various reports with functionalities like Cross tab, Embedded Summary, Calculate member of, Charts, Graphs, and sub reports.
• Worked with several features like Query Stripping, Input Controls, Sub Query, Scope of Analysis and Drill functionality.
• Create Aliases and Contextsfor resolving Loops and check the Integrityof theUniverse.
• Developed the highly summarized dash boards using XCelsius and created the real time dash boards using QAAWS and BI Widgets.
• Worked with different teams for developing BO reports in IOS and ANDRIOD Devices.
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Created complex formulas to support various business functionalities using Webi and Deski reports.
• Based on the Business Requirements granted rights on Public folders, Universe folders and Universe connections.
• Scheduled and maintained the reports to various users across the world using Info view and CMC.
• Created various Linked and Unlinked Sub Reports and managed the parameters accordingly.
• Generated various reports with the Features like Drill down, Alerts, Data Suppressing and Change Highlighting.
• Extensively worked on migration reports using Import Wizard and Life Cycle Manager (LCM) and transporting objects between BW system environments using Transporters.
• Created the Test cases, Test Strategies and executed the Unit Testing and the UAT for the Entire environment.
• Worked on troubleshooting of different database connectivity issues, user issues and report performance issues and trained the End Users regarding the Tool and the reports.
• Identified the KPI’s in the business to build the dashboards and Interacted with Risk Managers and analysts for Universe and reporting requirements.
• Representing BI Operations team at Business Change and Technical forums.
• Understanding and prioritizing for the BOXI work request, Issues and Enhancements. Complete ownership for smooth delivery of client deliverables.
• Interacting with Business Sponsors, Business Analysts from Business to understand and gather requirements for new projects and enhancements.
• Updating the project status to onsite team and offshore managers on weekly basis as per the project plan. Giving BO team updates in monthly project review meetings.
• Implementation of Advanced Performance tuning features in Business Objects using Universe, Report, Database and Server level optimization techniques.
• Worked with Business Objects utilities (COM) in maintenance and development of Business Objects XIR2 and 3.1 environments.
• Used Tableau Desktop 8.X to analyze and obtain insights into large data sets.
• Designed and produced meaningful, effective data visualizations using relational and aggregate data sources.
• Created visually compelling and actionable interactive reports and dashboards.
• Monitored SSIS and SSRS development and maintenance activities.
• Responsible for the execution of the work requests and ensure the on time delivery to UAT environments after a thorough review of the developed codes and UTRs.
• Responsible for fixing the post shipment defects and monitoring the status till the defect got closed.

Environment: Business Objects XI3.1, WEBI, Designer, SQL Server 2008 R2, DataStage, MSBI, Tableau 8.X.

Confidential, Blue Bell, PA

BO Team Lead

Responsibilities:

• Responsible for understanding the Client/User requirements (For DB, ETL and BO) from the SME(s) and planning for execution related to the assigned modules.
• Providing technical solutions, resolving issues with deliverables, performing technical reviews and guiding the team.
• Understanding and planning for the BOXI related Service Requests (SRs), Issues and Enhancements. Complete ownership for smooth delivery of client deliverables.
• Successfully delivered more than 100 SRs without any QA Counters and Failures.
• Guiding the team in preparing technical documents like AD, TDD, UTP, UTR and IS. Review the same to ensure the defect free deliverables.
• Updating the project status to onsite team and offshore managers on weekly basis. Giving BO team updates in monthly project review meetings.
• Given BOXI and presentations for onsite, offshore teams and new trainees.
• Implementation of Advanced Performance tuning features in Business Objects using Universe, Report, Database and Server level optimization techniques.
• Creation of Universes using Business Objects XI R2/3.1 and Desk I/WEBI reports for the client reporting requirements.
• Implemented New Security Model, Security features, Custom access Levels in Business Objects XI 3.1 SP3.
• Implemented Configuring Business Objects Enterprise XI 3.1 SP3 with Active Directory Single Sign-on Using Kerberos approach.
• Have Implemented Dynamic Report Bursting (Dynamic Publication) in Business Objects XIR2.
• Worked with Business Objects utilities (COM, .NET and JAVA SDK) in maintenance and development of Business Objects XIR2 and 3.1 environments.
• Worked on SAP BO Mobile implementation.
• Worked on Conversion of VB Reports to Business Objects reports.
• Worked on Event based Scheduling through windows batch files and programming to achieve accurate scheduling after completion of Informatica loads.
• Responsible for the execution of the deliverables and ensure the on time delivery to UAT environments after a thorough review of the developed codes and UTRs.
• Responsible for fixing the post shipment defects and monitoring the status till the defect got closed.
• Analyzed the Business Requirements through the analysis of BRD, FRD and TDS.
• Involved in the development of BRD, TDS and Data Traceability Documents.
• Developed and implemented Universes by defining Joins, Cardinality between tables and applied Contexts and Alias tables to remove cyclic dependencies.
• Designed Web Intelligence XI3.1, Ad-hoc Deski reports using Universe as the main data provider with various functionalities in Business Objects.
• Good Understanding of the ETL tool Informatica consisting of mapping designer, workflow manager and workflow monitor.
• Monitored the ETL process while loading data in to DWH and designed simple mappings as per requirements by using mapping designer.
• Created User Prompts, Filters in the reports and designed the reports using combined quires and customized the SQL of the reports to meet requirements
• Performed post production check-outs to the all BO reports by logging into the (GUI) Client interface and done performance benchmarking.
• Designed test case documents and performed unit testing, SIT on the reports and universe before move them to UAT.

Environment: Business Objects XI3.1, Desktop Intelligence, WEBI, Designer, PL/SQL, Oracle 10g, Informatica.

Confidential, New York

Senior Software Engineer

Responsibilities:

• Analyzed the Business Requirements through the analysis of Basic Requirements Document, Functional Requirement Document and Technical Design Specification.
• Involved in the development of BRD, TDS and Data Traceability Documents.
• Created Business Objects Universe and reports as per specifications by understanding technical and functional requirements.
• Developed and implemented Universes by defining Joins, Cardinality between tables and applied Contexts and Alias tables to remove cyclic dependencies.
• Created reports using Business Objects using functionalities like slice and dice, drill down, @functions, cross tab, master/detail tables, formulas and etc.
• Designed Web Intelligence XI3.1, Ad-hoc Deski reports using Universe as the main data provider with various functionalities in Business Objects.
• Good Understanding of the ETL tool informatica consisting of mapping designer, workflow manager and workflow monitor.
• Monitored the ETL process while loading data in to DWH and designed simple mappings as per requirements by using mapping designer.
• Created User Prompts, Filters in the reports and designed the reports using combined quires and customized the SQL of the reports to meet requirements
• Worked with WEBI XI3.1 and Desktop reports and worked with summery detail reports and extensively created formulas, variables and user prompts.
• Performed post production check-outs to the all BO reports by logging into the (GUI) Client interface and done performance benchmarking.
• Designed test case documents and performed unit testing, SIT on the reports and universe before move them to UAT.

Environment: Business Objects XI3.1, Deski, Webi, Designer, Rapid SQL, Oracle and Informatica.

Confidential

Senior Software Engineer

Responsibilities:

• Created and modified the universes according to the client requirements.
• Created objects in the universe for report linking purpose. This resulted in excellent report performance.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Use of designer module to implement universes, linkages between tables, prompts and queries, parsing the universes, applying contexts and alias tables to remove cyclic dependencies.
• Created the reports using Web intelligence XIR2 using prompts, filters and drill filters.
• Extensively used open document for report linking.
• Implemented the Software development life cycle methodology for creating reports.
• Prepared and maintained documentation for understanding universes and reports.
• Created several new objects in the Universe based on the report creation requirements.
• Developed Hierarchies to support drill down reports.
• Prepared test cases for the created BO reports that in corporate application.
• Involved in testing of reports.
• Worked with different types of customized Infoview.

Environment: Business Objects XI Release2, Web Intelligence XIR2, Teradata, SQL Server, Windows.

Confidential

Senior Software Engineer

Responsibilities:

• Develop enterprise wide financial reporting in expense, purchase to pay, record to report, and order to cash, based on the Business Objects XI R2 suite.
• Report requirement and business logic was understood through the onsite study.
• Reports were created using Web Intelligence XIR2 module of Business Objects.
• Documentation of design, operational and migration details followed.
• Delivering financial reports developed in BO XI R2 (Web-I reports).
• Gaps in universe (Semantic layer) were identified and resolved the issues.
• Optimum utilization of the PeopleSoft application for the reporting purpose. The solution resulted in cost savings and made reporting portfolio manageable.
• Created reports using Business Objects using functionalities like slice and dice, drill down, @functions, cross tab, master/detail tables, formulas and etc.

Environment: Business Objects XI Release2, Web Intelligence XIR2, Designer, SQL Server.