SUMMARY

• Over 14 years of professional experience in Information Technology.
• Over 9 Years of Experience in Business Objects Universe 4.1/4.0, XI R3.1 / R2 / 6.5.
• Expertise in the Tableau 9.3/8.2
• Over 13 years of experience in Crystal Reports 2013/2011, 2008/XI R 2/10/9/ 8.5/8 /7.5/7.0
• Expertise in designing Web Intelligence Reports, Desk Intelligence Reports, Tableau, Dashboard using Business Objects Enterprise 4.0 / 4.1, XI R2 / XI R3.
• Good experience in designing Business Objects Universes designer.
• Expertise in Business Objects Enterprise XI R2/ R3 / Crystal Enterprise 10/9/8.5, RAS, e Portfolio, CMC, CMS and Info View.
• Experience in Data warehouse environment.
• Expertise designing Web Intelligence Reports, Desk Intelligence Reports, Dashboard, using Business Objects Enterprise XI R2 / XI R3.
• Expertise in Oracle 11g, 10g / 9i, MS SQL Server 2000, and Access 2000.
• Good experience in System Analysis Design, Development, Testing and Implementation in Business Intelligence.
• Expertise in designing reports with complex sub reports, Cross Tabs, drill down, OLAP reports, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, conditional hiding/formatting.
• Expertise in Business Objects XI R2 Server Administration.
• Good experience in Rational Clear Case / Rational Clear Quest 2003.
• Full life cycle experience including requirement analysis, design, development, testing, implementation and documentation.
• Good communication, team and Interpersonal Skills.

TECHNICAL SKILLS

Operating Systems: Windows /XP Pro. /2000/NT, UNIX and MS - DOS

Reporting Tools: Business Objects 4.2/4.1/4.0/, XI R3.1/R2/6.5, Crystal Reports 2013/2011/2008 / XI R 2/10/9/8.5/8.0 and Web Intelligence Rich Client & Desk Intelligence, Tableau.

Development Tools: VB 6.0, Visual InterDev 6.0, VB.NET, ASP.NET, ADO.NET

Databases: Oracle 11g /10g/9i / 8i, MS - SQL Server 2000, Access ‘2000

Web Technology: ASP, HTML, DHTML, XML, VB Script, Java Script

Databases Access: ADO, ADO.Net ODBC, OLE - DB, DAO, ADO and XML

Other Tools: Toad, MS-Project, Adobe Acrobat, MS Office 2007/XP, Rational Clear Case 2003, Clear Quest 2003, Tortoise Sub Version, MS-Outlook & DOORS 8.1.

PROFESSIONAL EXPERIENCE

Sr. Business Object Developer

Role & Responsibilities:

• Designed and developed Web Intelligence and Crystal Reports using different Data Sources.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Also, created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Tableau visualizations and dashboards using Tableau Desktop. Also, developed Tableau workbooks from multiple data sources using Data Blending.
• Designed reports with conditional hiding, formatting and suppressing the section and groups and conditional sorting the report columns based on the parameter.
• Extensive knowledge in pre-defined functions like string, date, numeric, conversion and null functions of Crystal. Expert in writing complex formulae at the summary level and group level to implement the business logic. Optimized various SQL queries to make the reports run faster.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Designed Webi reports with multiple sections and breaks using hierarchies conditional formatting drills down capability with prompts. Also, developed reports with Ranking and Filters.
• Created Bar charts, donut Charts, trend charts, funnel charts; waterfall charts, Control charts in tableau. Restricted data for users using Row level security and User filters.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Develop, build and deployed executive dashboard.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets.
• Provide support for the development of new BO reports and quality control, enhancements on existing reports – Crystal and Web Intelligence Reports.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields.
• Write/maintain PL/SQL stored procedures and complex SQLs.
• Responsible to support QA and Production team resolve the defects and deficiencies.
• Responsible to review high-level and detailed designs for accuracy and completeness.
• Gathered user requirements, designed report specifications and detail design documentations and responsible for peer code reviews. Responsible for Server Administration and administrative tasks like managing the Reports, Scheduling the Reports, User’s management, Crystal Repository, folders, groups, events, roles, printers and servers.

Environment: Business Objects XI 4.2/R3.1, Tableau, Web Intelligence Rich Client, Crystal Reports 2013/2008, Oracle 11g, PL/SQL Developer, TOAD, Rational Clear Case/Clear Quest 2003, Tortoise Sub Version, JIRA Agile on Windows XP.

S r. Business Object Developer

Role & Responsibilities:

• Designed Webi reports with multiple sections and breaks.
• Designed reports using hierarchies conditional formatting drills down capability with prompts. Also, developed reports with Ranking and Filters.
• Designed financial Reports with formulas, custom functions, parameter, alerts and Running Totals. Designed reports with Parameter and Cascading Parameters.
• Designed sub reports with Linked and Unlinked sub report and used different Custom Functions and used with various financial functions. Designed Cross Tab Reports.
• Designed Report with sub reports and sharing values between main report and sub report.
• Designed reports with different types of Charts with Drill Down capability.
• Designed various types of Dashboard Reports using Graphs and designed Report Templates.
• Designed reports with conditional hiding, formatting and suppressing the section and groups and conditional sorting the report columns based on the parameter.
• Built full client and WebI reports with multiple section and breaks. Provided OLAP functionality and worked extensively with data warehousing.
• Designed Report with sub reports and sharing values between main report and sub report.
• Managing Universes – working with multiples designers, users, logins and Restrictions.
• Imported/Exported universes to Repository in order to make resources available to the users.
• Designed and modified new and existing Universe as per the requirement.
• Implemented various @Functions like @Prompt (for user defined queries), @Where for creating conditional filters and @Select function.
• Used Derived Tables to create universe for best performance. Exported the Universe to the repository to make resources available to the users for ad-hoc report needs.
• Have used advanced features such as Row Level Security, optimized Web intelligence reports, cascading prompts, multiple queries, dynamic and hyperlinked reports, utilization of business views and used multiple data sources.

Environment: Business Objects XI R3.1, Crystal Reports 2011/2008, Web Intelligence Rich Client, Oracle 11i, SQL-Server 2005, MS-Access 2005, TOAD, Rational Clear Case/Clear Quest 2003 on Windows XP.

S r. Business Objects Developer

Role & Responsibilities:

• Designed Financial Reports with complex formulas, custom functions, parameter, alerts and Running Totals.
• Designed Report with sub reports and sharing values between main report and sub report. Designed reports with Parameter and Cascading Parameters.
• Designed reports with different types of Charts with Drill Down feature. And designed various types of Dashboard Reports. Designed Report Templates.
• Designed reports with conditional hiding, formatting and suppressing the section and groups and conditional sorting the report columns based on the parameter.
• Designed report with multiple Groups, Group by intervals, Groups selection, Hierarchical Grouping, Summary Group and hyper linked reports.
• Designed and modified new and existing Universe as per the requirement.
• Resolving Join problems – Loops, Chasm & Fan Traps using Contest, Aliases and used Aggregation Awareness function.
• Designed complex Web Intelligence reports using Business Objects Enterprise XI R3.
• Designed Reports based on the Business Objects Universe, Tables, Business Views, Stored Procedures and Views. Also, done Report Optimizations and performance tuning.
• Wrote Custom functions and SQL Expressions and managed in the Crystal Repository. Responsible for System Test/UAT/Production support by 24/7.
• Responsible for Server Administration and administrative tasks like managing the Reports, Scheduling the Reports, User’s management, Crystal Repository, folders, groups, events, roles, printers and servers using Business Objects Enterprise XI R3.
• Wrote SQL Statements, Stored Procedures, Triggers and Views using Oracle 11i.

Environment: Crystal Reports 2008/XI R2, Business Objects XI R3.1, Business Objects Enterprise XI R3, Web Intelligence Rich Client, Oracle 11i, TOAD, Rational Clear Case/Clear Quest 2003 and Tele logic DOORS 8.1 on Windows XP.

Business Objects / Crystal Report Developer

Role & Responsibilities:

• Designed over 100 reports with parameters, formulas, custom functions and alerts and designed multilevel groupings and Drill Down Reports.
• Designed reports with multiple Sub-Reports and integrated the report with hyperlink to the application and designed with all types of Charts and Maps.
• Designed report with Group, Group by intervals, Groups selection and Hierarchical Grouping and Summary Group reports. Also, designed Report Templates.
• Designed Reports based on Views, Tables, SQL Expressions (Commands) and Business Views.
• Designed report with conditional messages while printing and designed Geographic Mapping Report for County, State and Region. Designed Cross Tab and OLAP reports.
• Created and maintained the repository for commonly used objects add configured the connection for other users.
• Handled all administrative tasks like managing the Crystal Repository, user, folders, groups, events, roles, printers and servers using Crystal Enterprise XI
• Performed integration testing of the reports and individually tested the report by populating the data and running the reports and ensured the formulas, formatting and functions.

Environment: Crystal Reports XI, Crystal Enterprise XI, SQL Server 2000 and SQL Analysis Service 2000, JSP on Windows XP.

Report Developer

Role & Responsibilities:

• Designed all the reports in this application using Crystal Reports 9.0. In addition, designed the reports with 10 levels of groupings with Charts and Maps.
• Used complex formulas in all reports to calculate mathematical figure in reports.
• Creating various types of reports with parameters, advanced formulas, cross-tabs, Drill Down and sub reports.
• Designed multiple Sub Reports, drill down Report and multiple sections, grouping reports and integrated the reports to Web and customized the rights to user.
• Designed report with conditional messages while printing and designed Geographic Mapping Report for County, State and Region.
• Designed Scheduled reports based on conditions and designed report with Alerts.
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management.
• Used Crystal Enterprise 9.0 to publish all the reports and did all administrative tasks like Manage Users, Folders, Groups and other administrative tasks.

Environment: Crystal Reports.Net, Crystal Reports 9.0, Crystal Enterprise 9.0, VB.Net, ADO.Net, SQL Server 2000, visual source safe on Windows XP.