SUMMARY

• Around 10 years of IT experience in Data warehousing and Business intelligence with emphasis on Business Requirement Analysis, Application Design, Development, Testing, Implementation and maintenance using Business Objects BI 4.2/4.1/4.0, XI 3.1/XI 3.0/XI R2 (Information Design Tool, Universe Designer, CMC, Web Intelligence Rich Client, Report Bursting, Import Wizard, Info view), Dashboard designer, Xcelsius 2008, Crystal Reports 2008/2013/Enterprise.
• Designed and developed Universes and created Canned/Ad - hoc Reports to support User requirements.
• Created Classes, Sub Classes, Dimension Objects, Measure objects in multiple universes, checked the Integrity of the Universes and exported the Universes to Repository to make them available to users.
• Expertise in Creating Web Intelligence Reports using Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Scheduled and published reports using CMC and Info view.
• Expertise in creating Dashboards 4.1 and Scorecards for enterprise summary level reporting using Dashboard Designer, XCelsius connecting to QAAWS, BICS, and Live Office (integration).
• Knowledge in architecture design of Extraction, Transformation & Loading environment (ETL).
• Excellent understanding of Dimensional Data modeling-Star Schema and Snowflake schema.
• Substantial development experience in SQL, PL/SQL, Stored Procedures, Packages, Triggers, Functions with ORACLE 11g/10g/9i/8i, SQL Server 2000/2005/2008 , Tera Data.
• Proficient in Performance tuning of Database, BO Reports, ETL mappings in Production environment.
• Involved in Migration from Business Objects 3.1 to 4.0/41./4.2.
• Good knowledge of Universe Design Techniques, working knowledge of Linked Universes.
• Involved working on transport process using SOLAMN, Life cycle manager, and BW, HANA Transports.
• Extensive knowledge in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Developed solutions to complex technical problems by challenging traditional technical assumptions.
• Architecturally consulted and supported large, complex, cross-functional projects.
• Have experience working in High Tech, Financial, Insurance, and Retail and Mining industries.
• Implemented and provided training in using Business Objects Suite of products and generated a report for end users within a few hours to a day with minimal instructions.
• Excellent analytical and problem solving skills. Quick learning capacity and positive attitude towards new challenges.
• Coordinated with QA teams for data validation of the reports.

TECHNICAL SKILLS

Business Intelligence: Business Objects XI 4.2/4.1/4.0/3.1/3.0/ R2 (Information Design Tool, Universe Designer, Web Intelligence, Info View, Webi Rich client, Deski, CMC,CCM, Broadcast Agent Server), Crystal Reports 2008/XI, Xcelsius 2008, Info Burst, 360 suite, Version Manager.

O/S: Windows Server 2000, 2003, 2008, XP, Unix, Linux

Database: Oracle 11g/10g/9i/8i, SQL Server 2005/2008, MS Access, DB2,TeraData, SAP BW 3.5/7.0/7.4, SAP HANA SP5/SP9/SP11, EPIC 2010/2013/2015

Programming: SQL, PL/SQL, HTML, C, C++, Java

Web Servers: IIS, Apache, Tomcat

ETL: BODI XIR2, BODS 4.0( Data Integrator and Data Quality)

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Business Objects EPIC Administrator/Developer

Responsibilities:

• Responsible for all phases of report development from specification gathering, research, code development, data validation, user acceptance review, publication and distribution of final reports. Use a variety of tools to create code, with a primary focus on complex SQL code writing and use of Webi Reports.
• Resolved complex join issues on the universe level involving trim functions on the bridge table and worked with DBA to optimize the join using indexing.
• Worked with ETL team on the various data changes to implement those changes on the universe and resolved complex chart issues on the WEBI reports.
• Installed and configured Business Objects 4.2 in distributed environment and configured web servers, processing servers, and load balancer as per standard SAP practices and split APS services, Auditing, and Monitoring Probes, Alerts.
• Performed Business Objects Administrator/Project Lead for EPIC BO deployment. Handle all security for our BO platform.
• Develop Business Objects universes for a number of departments to allow Web Intelligence access for super users. Train end-users on WebI and JAVA Launchpad portal
• Used Remedy Action Request System to generate various AIRs for different report and universe promotions from DEV to QA and QA to PROD.
• Worked on creating multiple data sources Universe in Information Design Tool (IDT).
• Created Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes against the custom universe of extended STAR database.
• Involved in the regression testing on the reporting side after hundreds of new fields were mapped by the ETL team.
• Created various restrictions at the universe level e.g. object level restrictions, filters, table level restrictions etc.
• Created complex reports by linking data from multiple data providers using merged dimensions. Also used functionalities such as combined queries.

Environment: Business Objects BI 4.2 Web Intelligence, Information design Tool (IDT), Universe Design Tool (UDT), and EPIC 2015, SQL Server 2014(Teradata SQL Assistant), Oracle 10g(TOAD for Oracle), Windows 2012 R2.

Confidential, Pittsburg, PA

Business Objects / EPIC Developer

Responsibilities:

• Responsible for all phases of report development from specification gathering, research, code development, data validation, user acceptance review, publication and distribution of final reports.
• Use a variety of tools to create code, with a primary focus on complex SQL code writing and use of Crystal Reports.
• Create reports for a variety of Epic modules, including Inpatient, Ambulatory, HIM, ADT, Transplant, OpTime and Pharmacy.
• Resolved complex join issues on the universe level involving trim functions on the bridge table and worked with DBA to optimize the join using indexing.
• Worked on various Java sdk scripts to configure authentications, SSO, and web servers for SAP BW7.3, BODS4.0 and BOBJ 4.0
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model.
• Created web services for querying database from external end user report portal using real time jobs in data services 4.0 designers.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Worked with ETL team on the various data changes to implement those changes on the universe and resolved complex chart issues on the WEBI reports.
• Build the upgrade plan including all phases of migration and testing and upgraded the BOBJ 4.1 to 4.2 versions and applied all customization required for Launchpad, User preferences and integrations with SharePoint and Hyperspace portal.
• Installed and configured Business Objects 4.2 in distributed environment and configured web servers, processing servers, and load balancer as per standard SAP practices and split APS services, Auditing, and Monitoring Probes, Alerts.

Environment: BOBJ 4.1/4.2 Web Intelligence, Information design Tool (IDT), Crystal Reports 2013, and EPIC 2015, SQL Server 2014, Oracle 10g, Windows 2012 R2.

Confidential, NYC, New York

Sr. Business Objects/HANA consultant (Administration and development)

Responsibilities:

• Extensively Involved in Business requirements gathering and analysis of the source data.
• Completed documentation in relation to detailed work plans, Change requests (CR) and Business Requirement Documents (BRD).
• Installed, and configured SAP Business Objects XI 4.1 environment for Dev, Qa and Prod and integrated it with HAN SP5 and SAP BW7.4 instances.
• Integrated Business Objects with SAP and Windows AD authentication.
• Extensively worked on all aspects of administration of business objects including securities, access rights, folders, Groups, users, restrictions, custom access levels, row level restrictions for the different groups, universes and applications, Events, calendars, Categories, Profiles, Servers, Connections, Universes, schedules, sessions, SMTP settings, license keys, Personal folders and inboxes etc.
• Created/Configured Attribute views, Analytic views, Calculation views, Analytic privileges, Ownership privileges, GRANT & REVOKE privileges, Global Authorizations, Decision Tables, Mapping tables, User defined Schemas, Packages and sub-packages in SAP HANA Studio.
• Developed Webi reports using BICS against SAP BW queries as Data sources and used SOLMAN for tracking tickets, uploading tests scripts and transport process.
• Worked on the Info cubes, DSO, and process chain monitoring for the queries build against SAP SD,MM,HCM, and FICO tables
• Extensively used SQL developer tool for validating various queries and checking the source data to match the results on the report against relation Universes.
• Used multiple data providers in the reports and created complex derived tables on the universe to pull the data from multiple tables for the various modules e.g Incident, Change Management, CMDB etc.
• Created various date time objects on the universe YTD, Month to Date and Custom Week definitions.
• Worked on Open Docs functionality for the reports to link the reports to BMC Remedy application.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities on the Universe.
• Created complex reports and objects like Hierarchies dimension objects and measure objects by using @aggregate aware functions to create summarized to detail reports.

Environment: Business Objects 4.0 Web Intelligence, IDT, Dashboard Designer 4.0, SAP HANA SP5, Crystal Reports 2013, Oracle 11g, SAP BW7.4, Suse Linux 11, java BI Launch pad,SOLMAN,ECC6.0.

Confidential, Montpelier, Vermont

Lead Business Objects Migration Consultant

Responsibilities:

• Interacted with the client to identify and develop business requirements and consulted Database team to find out the underlying sources associated with the business requirement.
• Involved in the installation of SAP BO in the clustered environment.
• Enabled SAP authentication using CMC and implemented SSO.
• Designed Maintained and Modified Universes using BO Designer by identifying required tables from Data Marts and exported Universes to CMS Repository.
• Created Users, Provided various accesses, Published reports, universes using Version Manager Tool to Various repositories.
• Developed universes using Teradata as DATA SOURCE and developed WEBI reports against these universe.
• Configured, re-catalogued Info burst reports for scheduled reporting to the top management using Info-Burst tool.
• Extensively worked on sap BW 7.0, build reports and Bex Query Designer.
• Configured various ODBC connections in the Data Source Administrator.
• Build Universe and reports by extracting data from SAP BEX query and SAP BW Cubes.
• Administrated and maintained day to day maintenance of Business Objects Servers.
• Created users and user groups using Central Management Console (CMC) for both Windows AD and LDAP authentications, and assigned Privileges to the users.
• Created folder structure in CMC and applied various securities, created BIAR files for the backups.
• Performed indexing in SQL, optimized performance, used SQL profiler to track performance, used sub-queries as specified by client.
• Created Joins, Contexts, and Aliases for resolving Loops and checked the Integrity, Cardinalities of the Universe.
• Used Teradata SQL assistant for creating views and validating various queries.
• Developed universes using Information design tool. Created Hierarchies for Multi-Dimensional Analysis and also created various Classes and Objects (Measure, Dimension and Detail).
• Formatted various reports using Business Objects functionalities like Sub-Queries, Filters (Custom and predefined)Slice and Dice, Drill Down, Functions, Cross Tab, Formula's, Charts, Master Detail Breaks, Sorting, Ranking, Alerts.
• Created Crystal Reports using Business Views and Universes as Data providers.
• Expertise in creating Metrics, Goal and Analytics to create Dashboards 4.0 for better decision using Xcelsius 2008.
• Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal Xcelsius.
• Created different Categories in the repository and published full client reports, corporate documents to their respective categories.
• Build complex reports based on data from multiple data provider.
• Worked on creating mapping and workflows using BODS transforms and data stores to extract data from source to target repositories.
• Promoted, supported, and developed the principles and standards of the enterprise architecture.
• Worked with new SAP extractors, Text data processing in BODS 4.0
• Migrated XI3.1 application and user contents to XI4.0 using Upgrade Wizard.
• Migrated Business Objects Universes, Users and user groups, and reports from Version XI 3.1 to XI 4.0 using the Upgrade Wizard

Environment: Business Objects XI 3.1, 4.0 Web Intelligence, Info view, Universe Designer, Xcelsius 2008, SAP BW 7.0, Crystal Reports 2008, SQL SERVER 2008, Windows 2007, Windows Server 2003, java BI Launch pad, Teradata 13.0, Infoburst IB9,Version Manager

Confidential, Charlotte, NC

Lead Business Objects Consultant

Responsibilities:

• Interacted with end-users and Business analysts to identify and develop business requirements and transform them into technical requirements and Developed complex reports with SAP BOBJ
• Designed, Maintained and Modified Universes using Universe Designer by identifying required tables from Data Marts and exported Universes to CMS Repository.
• Developed Bex queries Created Structures, Selections, Restricted Key figures, Calculated Key figures, formulae and if-else conditions according to the requirements.
• Installed and configured the Business Objects environments for both development and production.
• Installed and configured BOBJ with sap and enterprise aliases.
• Developed universes using Information designer. Created Hierarchies for Multi-Dimensional Analysis and also created various Classes and Objects (Measure, Dimension and Detail)
• Created Custom and Cascading List of Values (LOVs) for better understanding of Prompts by the end users.
• Created Crystal Reports using Business Views and Universes as Data providers.
• Scheduled recurring daily, weekly and monthly reports (WebI, DeskI and Crystal Reports) in Info View and used Calendar based scheduling.
• Expertise in creating Metrics, Goal and Analytics to create Dashboards for better decision using Xcelsius 2008.
• Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal Xcelsius.
• Build Interactive Dashboards using Live Office and also various connections such as QWAAS, BICS.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Created different Categories in the repository and published full client reports corporate documents to their respective categories.
• Experience on working with Management components like Publishing Wizard, Query Builder and Report Conversion Tool.
• Responsible for customizing and tuning SQL queries for better performance of reports.
• Involved in planning of migration and created the checklists for migration for business contents and personal contents.
• After the migration, ran the check integrity utility for all the universes and reports and fixed divergences.
• Documenting the entire effort generating Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.
• Created a database connection with Oracle 11g database, imported oracle tables in the Information design tool, created universe using those tables, and generated a url from that universe file using Qaaws.
• Implement sub-reports, crosstab and dynamic cascading parameters in Crystal reports.
• Report Data Validations and testing the reports as per the specifications and movement to production using LCM.
• Development of Webi reports for Warehouse Transfers, Warehouse replenishment reports and OC Reports
• Used Business Objects functionalities like Drill Down, Cross Tab, Functions and Master Detail

Environment: Business Objects XI 3.1, 4.0 Web Intelligence, Infoview, Desktop intelligence, Designer, Xcelsius 2008, Crystal Reports 2008, Oracle 11g, Windows 2007, Informatica 8.6., Information designer, java BI Launch pad.

Confidential, IL

EPIC Business Objects Lead

Responsibilities:

• Involved in the designing and Building of Universes, and Clarity reports in a variety of Epic modules including Inpatient, Ambulatory, ADT, HIM, Hospital Billing and Pharmacy, tested objects in the universe, to ensure the correct mapping of the objects for EDW objects of EPIC STAR database.
• Enabled SSO along with AD authentications and configured EPIC Integration Kit and Bat files.
• Extensively involved in requirement gathering and documenting of new report specifications
• Configured JAVA SDK scripts like web XML, and Secwindows AD for tomcat deployment and enabling windows AD aliases.
• Extensively used Web Intelligence through Info View interface to generate reports and published through EPIC Hyperspace Portal.
• Worked on canned reports which involved lot of complexity including hyper-linking, drill down, optional prompts and Alerters.
• Designed Criteria to handle the customer’s request from Tables, Stored procedures, Views and Command objects using Crystal Reports.
• Used Crystal Xcelsius to create Dashboards to Visualize and enhance the data presentation by developing dynamic charts and graphics and woked on KPI’s of Meaningful Views.
• Created Users/Groups and defined their roles and set privileges using the CMC.
• Support functions include troubleshooting problems with existing reports, modifying EPIC existing universes of Stork, Home health, Ambulatory, Hospital Billing, and ER.
• Responsible for migration of universes & reports into Production environment.
• Coordinating with DBA Team, Warehouse Team and BO Administrator for resolving technical issues and migration of objects in EPIC using DATA Courier.
• Trained how to create Webi reports using Info view (Java Report Panel) and also trained the users on using the Alerter, Prompts, etc.

Environment: Business Objects XI 3.0/, Universe Designer, EPIC 2010,Oracle 10g,Import Wizard, Web Intelligence, Crystal Reports, BO SDK.

Confidential

Business Objects Developer

Responsibilities:

• Directly coordinated with user to gather the new requirements and working with existing issues.
• Involved in the Designing and Building of Universes, Classes and objects.
• Created DB2 Aliases through configuration tool and ODBC connections for Universe development.
• Created Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Used @ functions and Aggregate Awareness in the Universe design.
• Used Business Objects (Web Intelligence, Desktop Intelligence) for creating various Adhoc Reports to business users on a daily basis.
• Created the complex Reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Prompt, Cross Tab, Master Detail.
• Created Drill-Through, Drill up/Drill down Reports to provide users with more detailed information and query linking.
• Automated document Scheduling, Publishing and Distribution for WebI and Info view clients, using info view.
• Designed, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
• Created Complex Reports Based on the Revenue Data like Revenue by Region, Interest Rates, and Promotion Adjustments.
• Also involved in Creating Repository, Creating Users and User Groups and assigned different privileges to them depending on their profile.
• Worked with different sources like Oracle, Ms-Access and Excel.
• Migrating and Maintaining Universes and Reports to multiple Environments.
• Migrated BO reports and universe from BO 6.5.1 both full client and thin client to BO XI R2.

Environment: Business Objects XIR2, Designer, Reporter, Webi, Oracle 9i, MS-Access, Windows 2000 Server, Confidential DB2.

Confidential

Trainee Programmer

Responsibilities:

• Involved in writing Queries, Stored Procedures, functions, and packages to implement business requirements.
• Created Triggers to automatically populate the reference tables and generate an error message to fulfill various business needs.
• Involved in Loading data from flat files into the database tables using SQL*Loader.
• Audit programs in PL/SQL for Pre-QA check & validation.
• Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.
• Constant monitoring and performance tuning of Oracle database and checking the most expensive queries.
• Documented the whole process flow, PL/SQL packages, log files, locations, descriptions, log tables, possible error messages and process codes.

Environment: SQL, PL/SQL, SQL*Loader, SQL*Plus, UNIX, Windows XP, Oracle 8i.