SUMMARY:

• SAP Professional Certified Consultant with Over 11 Years of experience in Information Technology Industry. Have extensive working knowledge of all stages of Business Intelligence development in Property and casualty insurance, Health insurance, finance retail, manufacturing, and healthcare Industries. An effective communicator with clients and team members.
• Expertise in SAP Business Objects BOBJ 3.x/4.2 Tools - Web Intelligence (WEBI), Crystal Reports Enterprise, SAP Lumira/Design Studio, Lumira Designer, SAP Analytic Cloud (SAC) Crystal Reports 2008/2011/2013 , Information Design Tool (IDT), Explorer, Office Analysis, and Advance Analysis for OLAP.
• Experience in Implementation, configuration, administration, trouble shooting, migrations and supporting of Business Objects Enterprise 4.2/4.1/ XI R3.1/3.0/R2 and Crystal Enterprise.
• Substantial experience in SAP Business Objects Migration (XI3.1 to BI 4.2 sp5).
• Effectively administered and supervised the Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Proficient in use of Microsoft Office Applications and strongly comfortable in Microsoft SQL Server, Access, and Oracle SQL Developer, writing the Queries, Stored procedures, Views, design database, tuning the queries and Universe.
• Experience in Training & Supporting end-user reporting needs using Business Objects.
• Hands on Experience in developing Tableau dashboards and stories.
• Expert in implementing aggregates, linked universes, drill-through and dynamic modules.
• Strong business, analytic and problem-solving skills
• Expertise evaluating the performance of SQL statements and PL/SQL modules.
• Good knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas.
• Experience in performance tuning, identify and resolve performance bottlenecks at various levels like source, target, mappings, and session.
• Experience in writing system documents, technical documents, and user documentation and writing training materials helpful for end users.
• Strong communication skills with an ability to interface successfully with technical and business teams, collaborating with stakeholders at all levels of management.
• Agile and Waterfall experience in full life cycle execution (SDLC) on large projects.

TECHNICAL SKILLS:

Business Intelligence/Data Warehouse: SAP Business Objects BI 4.X/XI R3.1, R2, 6.x, Desktop Intelligence, Import Wizard, SAP Analytic Cloud CMC, Design Studio, Crystal Reports 2008/XI R2/10/9, Web Intelligence, Lumira Designer, UMTReport Conversion Tool, Xcelsius 2008/4.5, IDT, UDT Data Integrator, AB initio, Data stage

RDBMS/Databases: Oracle 12g/10g/9i/8i, SQL Server 2005/2008SAP HANA SPS1-SPS9, DB2 UDB 9.X Sybase, MS Access, TeradataV2R5/V2R4/V2R6

Data Modeling: Erwin 3.5.5/ 3.5.2 , Star Schema ModelingSnowflakes Modeling, FACT & Dimensions, ER Studio

Operating Systems & Networking: Sun Solaris, SUSE Linux Enterprise Server 11, UNIXWindows NT, Windows 98/XP/2000/2003. Red hat

PROFESSIONAL EXPERIENCE:

Confidential, Erie, PA

SAP Business Objects/ consultant

Responsibilities:

• Created incidents with SAP and coordinated with SAP for complex issues.
• Primary Point of Contact for Business Users to answer SAP Business Objects questions and fix any prod issues within reports/universes.
• Created new universes from scratch using Information design tool (IDT) and converted 5 UDT (.UNV) universes.
• Leveraged Universe (IDT) performance increases by using Index awareness, Aggregation Navigation, shortcut joins, tune the database connection and avoided derived tables or views that are not materialized.
• Migrated 46,000 web intelligence reports, 30 universes and user’s favorite folders from Linux operating system to new windows operating system.
• Worked with server team in updating SAP business Objects 4.1 to SAP business Objects 4.2 SP5.
• Responsible for maintaining 6 universes for Claims, Personal lines and commercial line of business.
• Accountable for providing high-end solutions to Business Objects customers and troubleshooting all issues related to development and administration.
• Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Granted Users access to specific report folders within Business Objects CMC (Central Management Console).
• Worked with ETL Team creating SSIS packages/DataStage jobs for loading the data from Enterprise Claim center (ECC) to Claim center Data store.
• Advised and consulted power users in building web intelligence to follow report building best practices to achieve the performance optimization. Like utilizing prompts, minimizing complex variables and data providers, utilizing query filters and few more.
• Well versed in BOE architecture, Services process flows, content, security, scheduling and publishing.
• Worked on POC to convert existing reports/dashboards to Qlik sense.
• Performed migration and testing of BOBJ XI3.1 content to BI 4.0 environment and update to BO 4.0 to 4.2.
• Performed show and tell the user community on the Business Objects Web Intelligence reports.
• Worked on creating proper universe and object description documentation as an effort to work towards organizations self-service BI goal. Trained several users on self-service BI concepts
• Participated in Creating HLA with SAP team to upgrade the SAP BI license.

Confidential, Chapel Hill, NC

SAP BusinessObjects Consultant

Responsibilities:

• Build the new universes as per the user requirements by identifying the required tables from Data mart and by adopting industry best practices.
• Built web intelligence reports using opendoc, document linking, merged dimension, alerter on multiple conditions, ranking cumulative sum, synchronized data providers, cascading prompts, dynamic report bursting, custom formula functions, dynamic filters, query stripping and track data change.
• Created complex executive dashboards in design studio by following best practices in design principles and visualization techniques.
• Participated extensively on enterprise initiatives to meet the business partner’s analytic needs and acted as liaison between users and project team implementing the solution in our EDW.
• Involved in translation of high-level requirements to analytic solutions utilizing the blueprint which fits into our organization information ecosystem.
• Involved in an ETL program to implement “change data capture” associated to identify the whole data lineage as well as point in time information through which business can make effective decisions.
• Participated closely in retirement of previous warehouse (CDW) and implementation of next generation warehouse (EDW).
• Converted over 200+ deski, crystal and SQL reports to EDW environment which covers different value stream of the organization like subscriber, claim, revenue, provider, and network management.
• Performed migration and testing of BOBJ XI3.1 content (one department) to BI 4.0 environment.
• Defined and executed consolidation strategy for duplicate BusinessObjects universes in production repository with customers and reduced number of active universes by 57% for the Data Warehouse conversion project.
• Implemented standard naming convention across universes.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Developed a training material to capture the high-level overview of new structures developed in the project to improve awareness and enabling them to gain insight.

Environment: Business Objects 4.2/XI 3.1, Designer, CMC, Web Intelligence, Crystal Reports 2013, BI Launchpad, Information Design, Xcelsius 2008, QAAWS, Teradata, Oracle, DB2, SQL, Ab Initio Metadata Portal.

Confidential, Richmond, VA

SAP BOBJ Developer

Responsibilities:

• Interacted with users and gathered business requirements and involved in analysis & documentation.
• Built complex canned crystal reports for senior management decision making process.
• Involved in migration and deployment of the universes and reports across different environments.
• Installed Business Objects software in both development and production environments.
• Configured logical servers for the size of the current environment.
• Involved in the setup of storage structure and establish security policies.
• Migrated pilot group of reports from BO 6.5 to BO XI R3.1 and unit test the migrated reports.
• Setup the report pilot group for BO XI R3.1 automated delivery.
• Run test cycles on pilot automated reports delivery and stress test for automated report pilot group.
• Converted reports from Desktop Intelligence to Web Intelligence using Report Conversion tool.
• Modified the existing universes by adding tables created cardinalities, contexts, joins and aliases for resolving loops and checked the integrity of the universes.
• Exposed the newly added columns for business objects ad-hoc reporting purpose.
• Created new objects (measure, dimension & detail) classes and sub classes to meet the needs of end user requirements.
• Exported the universes to the repository to make resources available to the users.
• Involved in testing the developed universes and reports for final deployment.
• Created reports for various portfolios using the universes as the main data provider.
• Created reports containing multiple data providers and complex charts to present the end users with a better graphical representation of the data.
• Developed canned reports/ad hoc reports which run on weekly and monthly basis/user defined reports respectively.
• Extensively used slice and dice, drill down, filters, conditions, cross tab, master detail, and formulas etc. and developed Hierarchies to support drill down reports.
• Trained the end user in basic and advanced ad-hoc reporting as well as create queries format results and share them with others within the enterprise and beyond using Web Intelligence.
• Developed all kinds of reports such as detail reports cross-tab reports sub reports and reports with charts.
• Used crystal enterprise services for web publishing and scheduling.
• Participated in integration of business objects to SAP ECC 6.0 and interacted with SAP team for understanding of modules like SAP FICO, SAP MM and SAP SD.

Environment: SAP Business Object 6.5/XIR3.1, Designer, Desktop Intelligence, SAPECC6.0 Web Intelligence, SAP BW, Business object data integrator, Info View, Xcelsius 2008, Crystal Reports 2008, .NET, Windows Server 2003, Java, .NET, WebSphere, UNIX, DB2, SQL Server 2005.

Confidential, Harrisburg, PA

SAP Business Objects Developer

Responsibilities:

• Interacted with business users and gathered business requirements and involved in analysis & documentation.
• Modified the existing universes by adding tables created cardinalities, contexts, joins and aliases for resolving loops and checked the integrity of the universes.
• Exposed the newly added columns for business objects ad-hoc reporting purpose.
• Created new objects (measure, dimension & detail) classes and sub classes to meet the needs of end user requirements.
• Involved in testing the developed universes and reports for final deployment.
• Assisted UAT in maximum level to solve the issues encountered in post-production.
• Interacted with end users and gave production support.
• Created reports for various portfolios using the universes as the main data provider.
• Created BO reports containing multiple data providers and complex charts to present the end users with a better graphical representation of the data.
• Developed canned reports/ad hoc reports which run on weekly and monthly basis/user defined reports respectively.
• Extensively used slice and dice, drill down, filters, conditions, cross tab, master detail, and formulas etc. and developed Hierarchies to support drill down reports.
• Trained the end user in basic and advanced ad-hoc reporting as well as create queries format results and share them with others within the enterprise and beyond using Web Intelligence.
• Developed complex crystal report formula shared variables used for main report and sub report.
• Designed and Developed Xcelsius dashboards/analytics and exported to several formats.
• Involved in migration and deployment of the universes and reports across different environments.
• Experience in migration of reports universes user domains and groups from version XIR2 to XIR3.0 using Import Wizard.
• Thoroughly tested all the reports after migration as the calculation engine has few changes. All the contexts used in the reports were evaluated again after migration.
• Converted reports from Desktop Intelligence to Web Intelligence using Report Conversion tool.
• With the new features, available in WEBI, most of the reports got converted 100%. The reports that couldn't get converted or got partially converted were re-written or manually changed later.
• Resolved the issues in reports related to the user requirements

Environment: SAP Business Object XI R2/R3.1, Designer, Reporter, ETL (business objects data integrator) Web Intelligence, Info View, Performance Management, Crystal Reports 2008, Informatica, Xcelsius 2008, Windows Server 2003, Java, WebSphere Oracle 10g, DB2 UDB, UNIX, SQL Server 2005.

Confidential, Chicago, IL

SAP BO Developer

Responsibilities:

• Created and tested classes and objects to organize the universe.
• Detected cardinalities, loops, chasm, and fan traps and checked the Integrity of Universes.
• Resolved loops by creating aliases and contexts.
• Linked the Universes to share the common components between the universes.
• Created canned and ad-hoc reports from multiple data sources and from personal files.
• Designed, developed, and tested the reports.
• Limited the report to display records from the first data provider using a formula and global filters.
• Interacted with Business Owners to know their Business Views and modified reports accordingly.
• Created alerter using Business objects to highlight columns based on business criteria.
• Created complex reports using various charts.
• Used various chart templates and various chart formatting options.
• As part of dashboard developer, identified key performance indicator metrics.
• Designed and tested the dashboard for the presentation to the business stakeholders.
• Integrated business process to make dashboard actionable for the users.
• Trained the users in using the newly developed universe, universe connections and reports.
• Regular production moves after the project got the UAT sign-off involving universes and reports.
• Ensuring the security model after the production move and performance tuning of reports.

Environment: Business Objects XI R2, Crystal Reports XI R2, Web Intelligence, Desktop Intelligence, Info view, Designer, CMC, Crystal Xcelsius, TeradataV2R5, SQL Server 2005, Java, Oracle 10g, UNIX.