PROFESSIONAL SUMMARY:

• Over 13 years of IT experience in Analysis, Design, Development, Production Deployment, project coordination and creating complex reports using Business Objects Universe Designer Tool (Designer), IDT, Web Intelligence
• Desktop Intelligence, Xcelsius, SAP Dashboards, Crystal Reports, Data Architecture, SAP Mobile BI, Info View, BI Launchpad, infoburst, Central Management Console (CMC), Business Objects Data Services.
• Hands on experience working in database design, analysis and implementation
• Trained by SAP on Business Objects XI and Crystal Reports XI
• Experienced in various components of Business Objects 5.x/6.x/XI R2/XI R3, BO BI 4.0
• Experienced in Crystal Reports XI R2
• Hands on experience working with the cloud migration team for migrating BO 4.1 into cloud and testing the reports compared to 3.1
• Expertise at Universe Designing, Developing, Maintaining and Resolving loops, Chasm traps, Fan traps using Alias, Context. And also creating classes & objects (Dimensional, Detail, and Measure), defining Joins & Cardinalities and testing with Check Integrity.
• Proficient in creating canned/adhoc reports from different data sources utilizing Business Objects Web Intelligence and Crystal Reports.
• Worked using various data providers like Universes, Personal Data Files, Stored Procedures and Freehand SQL to generate reports.
• Generated complex reports by linking data from multiple sources using functionalities such as Combined Queries, Master Detailed, Slice and Dice, Drilling methodology, Scope of Analysis, Merge, Filters, Ranking, Sections, Graphs and Breaks.
• Built multiple dashboards for the projects and Engineering team using Xcelsius 2008 and SAP Dashboards with Live Data connectivity using Query as a Web Service (QaaWS), Live Office.
• Created SAP Business Objects documents to effectively view and work on an iOS device (iPhone or iPad) using the SAP BI Mobile app.
• Hands - on experience in migrating Business Objects applications from Business Objects 5.x/6.x to XIR2 and 3.1 to 4.1.
• Experience working with multiple relational databases like Teradata, Oracle and SQL Server.
• Expertise in developing complex queries and programs utilizing SQL and PL/SQL and strong experience in writing Stored Procedures and Triggers.
• Experience in data architecture and have Good knowledge in implementation of Relational Database (OLTP) and Data warehousing systems (OLAP), Data Marts and Data Warehouse concepts Star Schema, Snowflake Schema.
• Extracting data from multiple sources using Business Objects Data services and loading the data into multiple target databases.
• Extensive experience on conducting JAD sessions for interacting with business users and business owners for requirements gathering, analysis of business processes, report enhancements etc. and ability to multi-task in a fast-paced technical environment.
• Trained users in report development and running ad-hoc queries in Business Objects.
• Excellent Oral communication and presentation skills.
• Excellent team player at all levels with ability to perform independently with exceptional analytical, presentation and problem solving skills.
• Well versed with CMMI level documentation
• Experienced in project management activities such as team building, knowledge management, effort estimation, scheduling project, planning deliverable, handling clients, conducting stakeholder etc.
• Experienced working with business system analysts in requirements gathering phase and co-ordinating with functional and technical teams to provide best possible solution to end users
• Passionate about analytics and business intelligence
• Experienced in identifying and providing business insights to enable senior management in making best business decisions
• Self-driven individual with an ability to work independently as well as in diverse teams

TECHNICAL SKILLS:

BI Tools: BO 4.1/3.1(R3.1)/R2/R1/6.x/5.x(Universe Designer Tool (Designer), IDT, Web Intelligence, Desktop Intelligence, Xcelsius, Tableau 9.x Info View/Launch Pad, SAP Dashboards, SAP Mobile BI, Import Wizard, Info View, BI Launch Pad), Crystal Reports 2008/XI/10/9, Version Manager, Business Objects Data Services 4.2/12.2.2, infoburst, Autosys, Redwood

Languages: SQL, PL/SQL, Unix Shell Scripting (Korn/C/Bourne), Pro*C, Java, J2EE, C, C++

Databases: Teradata 12/13/14, Oracle 11g/10g/9i, SQL Server 2005/2008/2012, Progress OpenEdge 2009

Operating System: UNIX, LINUX, Windows NT/XP/Vista/98/95, Red Hat (RH5 to RHEL 6), MS DOS, IBM AIX, Sun Solaris

Reporting Tools: Business Objects Developer Suite 5.1, Business Objects XI/XIR2/XIR3.1, COGNOS Suite, COGNOS Report Net, Crystal Reports, Oracle Reports 10g/9i/6i

Oracle Utilities: SQL*Plus, SQL*Loader, SQL Developer, TOAD

Other Tools: Informatica 9.1.6/8/6/1/8.5.1 (Power Center), Erwin 8.1/7.3, Visio 2007, Oracle Forms and Reports, APEX, Golden Gate, Autosys, Subversion, Revision Control System, BMC Control-M

WORK EXPERIENCE:

Confidential, NC

Sr. Business Objects Consultant & Lead

Environment: Business Objects XI 3.1/4.1, Information Design Tool (IDT), BI Launch Pad, Infoview, CMC, Import Wizard, BO Designer, Web Intelligence, Desktop Intelligence, Oracle 11g, Windows XP/2007, Unix, Control-M

Responsibilities:

• Worked as a lead in the current position and involved in Design and development of reports to cater to the regulatory requirements
• Performed the role of a Business Analyst and created functional specification documents
• Lead the team onsite and offshore in different phases of the project like Requirements gathering from Business users, participated in project sessions with the Project core Team, EDW Schema Design, EDW schema Test, Universe Design, ETL design, System testing of Universe and the Reports, Performance testing, Universe and Reports maintenance etc.
• Expertise at Universe Designing, Developing, Maintaining and Resolving loops, Chasm traps, Fan traps using Alias, Context. And also creating classes & objects (Dimensional, Detail, and Measure), defining Joins & Cardinalities and testing with Check Integrity.
• Experience in conducting various JAD sessions with end users and project team to collect the requirement and ensure the report output is as expected by the users.
• Proficient in creating canned/adhoc reports from different data sources utilizing Business Objects Web Intelligence and Crystal Reports.
• Hands on experience working with the migration team for migrating BO 4.1 and data services
• And tested the reports to make sure it was matching the exact same results from our BO 3.1 environment.
• Solved all the issues we were facing with the reports in the new environment.
• Trained the users with the new BO 4.1 environment by directly accessing it from their PC’s, IPads and IPhones.
• Was the data architect for all my projects and also involved in the universe design of regulatory reports
• Strong Hands on Experience with macros and store procedures on Teradata and oracle.
• Developed some complex views and also worked on SQL tuning and query performance improvements on Teradata and Oracle.
• Followed the best practices on data warehousing and have strong knowledge on data warehousing concepts.
• Analysis of data requirements and translation of these requirements into dimensional data models using Extended Star Schema data modelling techniques.
• Strong Knowledge on ETL by Extracting Data from different sources, Transforming and loading them into the Enterprise Data Warehouse databases using SAP Business Objects Data Services.
• Used to schedule all the batch jobs using Autosys and redwood. Had management console access to do so.
• Created and maintained Views, Operational Data Stores, Workflow, Data flow, Data sources, Transform objects, Transfer rules and Update rules for Data targets in the Enterprise Data Warehouse.
• Prepared design documents and showcased the solutions using UML diagrams
• Reviewed/prepared technical specifications, test and review logs for the universes & reports
• Developed .unx file using IDT tool
• Created Secured (.cnx) connection and designed Data Foundation (.dfx) using multiple data sources using IDT
• Customized Business layer by assigning row level and column level security using security editor
• Implemented Aggregate awareness and hierarchy functionalities are developed in Business Layer(.blx)
• Created the Classes, objects, detail objects, measures and filters in universe by using Universe Design Tool (UDT).
• Designed snowflake, star and multiple star schemas in universe
• Developed & Tested complex webi reports
• Enhanced the universes using derived tables, alias tables and contexts.
• Converted the reports from DESKI to WEBI using the report conversion tool.
• Used the different data sources Universes, Custom SQL and Excel.

Confidential

Management Account Analyst

Environment: Business Objects XI 3.1, Infoview, CMC, Import Wizard, BO Designer, Web Intelligence, Desktop Intelligence, Oracle 10g, Windows XP/2007, Unix, Control-M, SVN.

Responsibilities:

• Engaged with business end users and engineering teams to understand requirements
• Lead the Business Objects team to ensure that tasks have been assigned appropriately and were delivered on time adhering to quality standards
• Performed code reviews and mentored Business Objects team to adhere to quality standards
• Designed and implemented complex approval reports which were used by local controllers to validate the monthly performance of various teams.
• Designed and implemented reports to identify largest and smallest clients based on the Net New Assets brought in on a monthly basis
• Worked on the Progress OpenEdge and SQL server database to create the reports.
• Preparation of critical, Master Detail, Sub Reports, Cross Tab and Summary reports using BOXI R/3 and Crystal Reports.
• Expertise at Universe Designing, Developing, Maintaining and Resolving loops, Chasm traps, Fan traps using Alias, Context. And also creating classes & objects (Dimensional, Detail, and Measure), defining Joins & Cardinalities and testing with Check Integrity.
• Worked with the financial team to create a Daily Production Report for each plant.
• Scheduled jobs with crystal reports and SQL server.
• Published and Participated in UAT testing and then to production after getting approval from Users.
• Performed data analysis to resolve data issues in data warehouse.
• Had to mentor few developers with advanced reporting techniques.
• Worked as an administrator in creating users and folders and managed access privileges in windows
• Performed Admin tasks like monitoring DB services, monitoring BO server running with optimal performance.
• Some daily admin tasks included verification BO user logins and security checks testing availability of all universe connections, Monitoring day to day scheduled jobs.
• Designed and developed Universe and Report as per the requirements.
• Tuned Universes & Reports to improve performance.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Dashboard.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Dashboard 4.0.
• Used Xcelsius for presenting dashboards to End users.

Confidential

Operational Reporting Analyst

Environment: Business Objects XI 3.1, Infoview, CMC, Import Wizard, BO Designer, Web Intelligence, Desktop Intelligence, Oracle 10g, Windows XP/2007, Unix, Control-M, SVN.

Responsibilities:

• Gathered requirements and developed functional specifications
• Designed scalable reporting solutions
• Involved in 3rd level production support activities
• Planned and executed production deployments (Raised/Implemented RFC requests)
• Conducted s to business users
• Developed Universes & Reports for teams across APAC/UK/US
• Created UI Documents as supporting documents for the Business Requirements Documents.
• Developed Excel formulas for testing and verification of functional requirements.
• Involved in building and designing Universes and resolved Loops and Traps using Contexts and Aliases.
• Created Aggregate awareness functions on multiple summary tables to improve the query performance.
• Updated Universes as per the changes of the Database table structure and notified the users about changes made to the Universe.
• Set up Universe level conditions to restrict data based on report requirements.
• Created reports using Business Objects functionality’s like slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Used Import Wizard to migrate reports from one environment to another environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Configured Local, Central and profile repositories and repositories are associated to the Job server.
• Created Users in Data services management console and assigned roles based on the requirement.
• Supported Production environment and fixing the issues raised by the jobs while running in production.

Confidential

Business Objects Analyst

Responsibilities:

• Involved in design discussions and in gathering requirements from the business users to build the reporting application.
• Performed admin role responsible for creating users and groups, and responsible for creating row level and objects level securities using Central Management Console
• Managed and configured Servers, used the import wizard to migrate between different environments
• Created universes from various data sources
• Created reports using Business Objects WebI (Web Intelligence), DeskI, and Crystal Reports
• Implemented localization at both Universe Level and Reports Level
• The Sales Analysis and Billing reporting solution: Customers want full access to all the information and functionality they need to serve themselves. This system is a complete application for business intelligence that gives users the tools they need to analyze sales, marketing and other corporate data.
• Performed in depth analysis and data & prepared weekly, biweekly, monthly reports by using Business Objects.
• Set up hierarchies in the Universe for providing drill down options in the reporting environment.
• Utilized Aggregate Awareness concept in the creation of objects.
• Created reports using Business Objects functionalities like Queries, Sections, Group values, Breaks, Filters, Conditions, Alerters, Ranking, slice & Dice, Drill functions, Sorting, Formulas, etc.
• Maintained and Modified existing reports according to needs of users.
• Created report templates to maintain a uniform standard across all the reports.
• Created charts and graphs to produce the net profit or gain for the marketing department.
• Designed & developed various departmental reports by using Business Objects.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Managing the report deliverables and the project timeline.
• Gathering the functional specifications for the financial reports needed for the business.
• Scheduled Documents on daily, weekly, and monthly bases.
• Developed Business Objects reports with multiple currency conversions to enable global deployment of the reports.
• Involved in developing PL/SQL scripts in case bad data is loaded into the Oracle Tables.
• Understood basic business analysis concepts for logical data modeling data flow processing and database design. Utilized skills for problem solving.
• Assisted in the analysis, design, coding and development of building a new schema (staging tables, views, SQL files).
• Created and configured Data Connection, Dynamic Data Connections, and Business Elements
• Created cascading list of values using Business Views
• Developed technical and user documentation
• Developed document from development environment to production system
• Performed user on ad-hoc reporting

Confidential

Business Objects and Oracle Developer

Responsibilities:

• Designed Business Objects Universes and Reports (Full Client and WebI) for various clients of Business Objects all around the world
• Worked on troubleshooting Business Objects Universes and Reports (Full Client and WebI)
• Engaged with users to understand their specific requirements and business needs
• Involved in troubleshooting users’ reports & universes
• Developed and maintained various user groups and user groups security using Business Objects Supervisor
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Used Oracle 9i features such as merge for various transformations.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Performed uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Creating Test scripts for the generated final Reports.
• Involved in data migration from SQL Server to Oracle 9i.
• Good working knowledge of PL/SQL and UNIX in Production Support.
• Attended meetings and review to discuss current issues and processes to tackle issues.
• Helped users in creating& troubleshooting Universes based on different databases such as Oracle, SQLServer based on the requirement
• Developed customized reports such as drill down, slice and dice, filter change displays and charts
• Developed enhancements to the existing reports in Full Client, ZABO and WebI
• Mentored junior engineers in Business Objects components
• Achieved highest client satisfaction score of 96%