Professional Summary

• 7 years of Information Technology Industry experience in creating and implementing effective strategies/solutions for developing Business Intelligence / Data Warehousing BI/DW tools of Business Objects, Crystal reports and Dashboards, analytical strength, successfully working through problems and implementing solutions in Financial, Banking, Insurance and Health care.
• Extensive experience in all phases of the Software Development Life Cycle SDLC such as Requirements Gathering, Analysis, Design, Implementation, Maintenance and also involved in the Production Support.
• Experience in developing, designing and Modifying Business Objects Universes and Reports
• Experience in Identification of Business and Data requirements and converting them into conceptual data models.
• Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake, FACT and Dimensions tables, slowly changing dimensions SCDs
• Extensive experience in dealing with various data sources environment SAP Non Sap like SAP BW, BEx, Teradata, Oracle 10g/9i/8i, DB2, Teradata, 2005 MS SQL Server, MS Access and HANA layer, Curam.
• Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Experience in designing Universes, writing LOVs, and good exposure with Slowly Changing Dimensions SCD .
• Immense experience in solving loops and traps using Contexts and Alias, setting up Custom Hierarchies, Derived Tables, and Aggregate Awareness to enhance the performance of SQL
• Experience in creating users and user groups, restricted access of the users as needed using Central Management Console CMC . Involved in managing users, groups, folders and published reports using Central Management Console.
• Well capable in creating Multifaceted Canned/Ad-Hoc reports using Business Objects, Web I
• Created Highly Complex Custom Line Graphs, Bar Charts with shared data of main and sub reports data using Crystal Reports
• Experience in creating interactive dashboards to visualize complex data quickly
• Experience in creating several reports in WebI with Business Objects functionalities like Breaks, Alerts, Filters, Variables, Formulas, Ranking, Query Prompts and Drill filters.
• Developed effective and Complex Reports using Drilldown reports, Sub-Reports, cross tab reports, Parameterized Reports and Formula Reports.
• Expert in tuning the performance of SQL queries and ETL process.
• Experience in Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Development, QA and Production.
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures and free hand SQL.
• Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end-users and managers and Experience in requirement gathering and Training End-users.
• An enthusiastic, project-oriented team player with leadership skills and with an ability to develop creative solutions for challenging client needs.

SKILL SETS

Professional Experience

Confidential

Business Objects Developer

• Closely worked with BA to clarify the report requirements and updated specifications in the report clarification log.
• Analyzed reports and scheduled them to check efficient run time and tuned the queries in database, checked format and report level details in Test, Dev and UAT environment.
• Worked closely with ETL team to analyze the data that is unavailable in the Repmart.
• Worked on defects assigned and crossed check the data in the NJ CASS applications.
• Created complex date objects and filter conditions on BOBJ universe using DATE and CASE functions.
• Created Dash boards, KPI scorecards using Crystal Xcelsius and BO XI R3.
• Created a consolidated summary level reports using Slice and Dice, Drill down reports on BO thick client
• Used the formatting options like cross tab representation, section, breaks, data sort options, calculations, font, colors, generation of charts etc.
• Various ad hoc reports were created by resolving issues like, Chasm Trap and Fan Trap using Contexts and Aliases, simple reports and complex reports using cascading prompts
• Migrated reports from Microsoft Reporting Services to Business Objects Web Intelligence using stored procedures and free hand SQL.
• Defined various row and column level security for the Business Objects Users.
• Business Objects Universes BOBJ for various data marts as per the requirements.
• Created various classes, objects and also tested them to ensure correct mapping of data.
• Used aggregate aware functions to improve the queries performance.
• Analyzed the data needs for the customized reports, mapped the data requirements developing Stored Procedures, Functions and Triggers and Performance tuning of Oracle Databases and User applications.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Environment: Business Objects XIR3.1, Universe Designer, Central Management Console, Web Intelligence, SAP Crystal Presentation Design 2011, Import Wizard, Oracle 11g, SQL Server 2008, Curam.

Confidential

Business Objects Developer

• Participated in all phases of Software Development Life Cycle Requirement analysis, Design, Development, Testing and Documentation ---worked with the BA understanding the business requirements and also the DBA
• Converted a few Desktop Intelligence reports to Web Intelligence reports using Report Conversion tool Report migration from XI 3.x to BI 4.x
• Customizing the adhoc Webi reports as per the user requirements by using the Formulas, Drill Downs, Master/Detail and Cross Tabs.
• Created new classes with dimension objects and customized hierarchies. Specified joins, checked cardinalities and resolved loops in the existing system by using alias or contexts.
• Created User groups, Users, Database connections, Managed user privileges, Import/export of universes in production environment
• Designed and maintained universes The Universe is a semantic layer that contains metadata data about data Translates the complexities of the database into business-friendly terms for end-users. with BOBJ designer and implemented row level restrictions
• SAP BusinessObjects recommends no more than 500 objects per universe , although others recommend even smaller number of around 200 objects.
• Maintenance of universe:
• Developed dashboards, KPI and scorecards for detailed analysis, also created Dashboard Manager using Application Foundation and Web Intelligence.
• Optimize Universes using functions and Aggregate Awareness Functionality.
• 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.
• Deployed the reports to CMC for the users also used reports bursting and distribution to ensure reports delivery by email
• Implemented dynamic cascading prompts Cascading Prompt is an additional feature in BO reports where user wants to input the values from higher level to Granular level which they are not aware. To help them, cascading prompt will provides the facility to Input the values from Hierarchical way crate a list of vales and associating with the objects by adding a prompt and defined business views
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily
• Solid knowledge of basic SQL, relational database and advanced SQL queries
• Implemented static/dynamic date parameters to multiple sub-reports in crystal
• Tweaked various cosmetic changes summary info, section expert, guideline, rulers, grid and align to make all the sub reports were consistently crystal pixel perfect reports
• Experience in hard coding the crystal commands of Date parameters ISNULL , lastfullmonth, monthtodate etc. , CSTR, Date and String conversions
• Experience on shared variables numerical/dynamic arrays to communicate through the main-report and to display statistical values mean, median and aggregate averages .

Environment: Business Objects 4.0, Designer, Web Intelligence, Info View, CMC, SAP Crystal Presentation Design 2011, Query as a Web Services QaaWS , Live Office, Informatica 8.1, Oracle 11g, MS SQL Server 2008, TOAD, Windows 2008.

Confidential

Business Objects Developer

• Closely worked with managers to gather information and user input for canned crystal reports canned reports are used by business users for refresh/and print purposes only. users are not suppose to modify them.
• Scanned reports are created by IT developers and published/distributed for users to use and in universe objects naming and definitions.
• Created complex date objects and filter conditions on BOBJ universe using DATE and CASE functions.
• Created Dash boards, KPI scorecards using Crystal Xcelsius and BO XI R3.
• Created a consolidated summary level reports using Slice and Dice, Drill down reports on BO thick client
• Used the formatting options like cross tab representation, section, breaks, data sort options, calculations, font, colors, generation of charts etc.
• Various ad hoc reports were created by resolving issues like, Chasm Trap and Fan Trap using Contexts and Aliases, simple reports and complex reports using cascading prompts
• Migrated reports from Microsoft Reporting Services to Business Objects Web Intelligence using stored procedures and free hand SQL.
• Defined various row and column level security for the Business Objects Users.
• Created Business Objects Universes BOBJ for various data marts as per the requirements.
• Created various classes, objects and also tested them to ensure correct mapping of data.
• Used aggregate aware functions to improve the queries performance.
• Developed stored procedures to extract the data from different sources and load it into data warehouse, involved in Logical Physical Database Layout Design.
• Analyzed the data needs for the customized reports, mapped the data requirements developing Stored Procedures, Functions and Triggers and Performance tuning of Oracle Databases and User applications.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Environment: Business Objects 4.0/XIR3.1, Universe Designer, Central Management Console, Web Intelligence, SAP Crystal Presentation Design 2011, Import Wizard, Oracle 10g, SQL Server 2008, TOAD, SQL Loader, Windows 2008, UNIX.

Confidential

Business Objects Developer

• Gathered requirements from Business Users.
• Involved in creation of universes, Classes, Objects and Hierarchies for multi dimensional analysis of database using Business Objects for technical and sales marketing departments.
• Created complex reports using user defined functions, condition objects and aggregate awareness functions for SQL enhancement
• Exported universes to the repository for making resources available to users
• Created master detail reports using drill up and drill down functionalities.
• Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV's, Combined Queries, Free Hand SQL and Semantically dynamic calculations using context method.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerters. Scheduled reports on daily/weekly/monthly basis using CMC.
• Used SQL against the database to check retrieved data integrity.
• Was actively involved in planning, documentation. Developed Ad Hoc reports.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
• Developed weekly and monthly Company Turnover Reports as per the requirements.
• Setup Application Foundation operational metrics and analytics for marketing decision analysts.

Environment: Business Objects XI R3.0, CMC, Designer, Infoview, Xcelsius, Toad, SQL, PL/SQL, Oracle 9i,SAAS,WebLogic 10.3g, SQL Server, Windows NT.

Confidential

Business Objects Developer

• Conducted meetings and interacted with business users to understand the business needs, modified Universe and gather report specifications.
• Designed multiple Universes from multiple data sources to create several reports with additional variables and report level filters.
• Created various user-defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Created and modified existing Hierarchies in the Universes to meet Drill Analysis.
• Involved in performance tuning optimization of BO Universe Design by creating Aggregate tables.
• Tested aggregate awareness to ensure the query returns correct level of aggregation.
• Defined Alias and Contexts to resolve loops, traps and also tested them to ensure retrieval of correct results.
• Created User Defined Functions and Materialized Views.
• Updated Universes reports continuously to rolling user requirements data sources in an agile environment.
• Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables, joins etc.
• Created several types of Crystal Reports using sub-reports, Cross-Tab Reports, Graphs, Complex Formulas, and Conditional Formatting and Developed dashboards using Crystal Xcelsius.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Conducted info-sessions with end users on recurring basis to educate and communicate all existing and new functionalities of Business Objects.

Environment: Business Object XIR3.1/XIR2, Xcelsius 2008, Designer, Web Intelligence, Info View, CMC, Informatica 8.1, Teradata V2R7, SQL, PL/SQL, SQL Server 2008, SQL Assistant,Windows 2003.