SUMMARY

• Over 8 years of experience in Information Technology with strong work experience as Business Objects Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise in Business Object senterprise Products(Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM)and its deployment.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logicaldata models.
• Experience in creating Adhoc reporting ready universes usingBusiness Objects Universe Designer.
• Expert SAP Business Object Consultant working with Web Intelligence, BI Launch Pad, Rich Client and Crystal Reports.
• Over 5 Full Projects Lifecycle implementations using SAP Business Objects 4.1 sp6 and Enterprise Data Warehouse (i.e. requirements gathering, design, development, test.
• Experiencing using MSSQL Developer, TOAD and Rapid SQL, Strong Knowledge in Database.
• Develop new standard reports and enhance existing Standard & Proto type Reports.
• Worked in developing in new universe and maintain current Universes.
• Experience in interaction with the Business Analysts, identifying the needs & the requirements of the system.
• Expertise in gathering the business requirement and building Universes in the Designer, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex ad - hoc Reports using data access and report design using Web Intelligence modules mapping of the objects and data correctness
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Being a key project player, observed multiple full Life Cycle for projects, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
• Good analytical and documentation skills with ability to communicate at all levels.
• Proactive person with good teamwork and collaboration capabilities, with strong interpersonal skills to ensure maximum performance and maintaining a good work environment.
• BI Tools: Business Objects R3.0/R3.1/R4.0/4.1/4.2 (Designer, Reporter, Unit Tester)
• Web Intelligence/ BI Launch Pad, Broadcast Agent, Auditor, Webi, BO SDK, SAP BW, Crystal Reports.

TECHNICAL SKILLS

BI Tools: Business Objects 4.2,4.1, 4.0,3.1 UDT,IDT Universe Designer, Web Intelligence, InfoView, BI Launch Pad, Crystal Reports, CMC, CCM, Import Wizard, LCM, Migration Wizard, Report conversion Tool, Tableau

ETL Tools: Informatica, BODS

Operating systems: MS Windows NT/2000/2003/XP/7/10

Compliance tools: Section 508 Government Compliance

Databases: SQL Server 2005/2008/2012 , DB2, My SQL, Oracle 9i/10g/12C, Teradata, DB2

Supporting Modules: SAP Hana

PROFESSIONAL EXPERIENCE

Confidential, New Brunswick, NJ

Senior Business Objects Developer

Responsibilities:

• Involved in all phases of development including requirements gathering, analysis, designing Business Intelligence platform, coding, testing, implementing and maintaining the universe and reports until the warranty period.
• Created report mockups through end-user meetings and analysis of system requirement documents.
• Extensively worked with end-users, business analyst and data architects to come up with an optimized data model, which is report-centric.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables and created classes, sub-classes and objects as per the organization standard
• Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
• Used Index awareness, aggregate aware and aggregate tables for optimized query performance.
• Applied Row level, Object level security in the universe to make the sensitive data secure.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality.
• Used functions like select, where and prompt function to create prompts, which helps the user to select the values dynamically.
• Created complex Web intelligence reports by merging objects from different data providers using Merge Dimension Option.
• Extensively used Variables, Sub-queries, merged dimension, Input Controls, Context Operators (In, For Each and For All), and Drill down, folding/unfolding, Breaks, Sections, Ranks and Alerters in the creation of reports.
• Used BI Launch Pad/InfoView for scheduling different reports and developing Web Intelligence documents.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per business requirements.
• Written user training documents for basic implementation Design and create User guide and Training Guides.
• Post- Go live issues were fixed, new post - production requests and change requests (CR’s) were implemented.
• Extensively worked with Teradata SQL Assistant to perform Unit testing and data analysis during report development and cross check the data accuracy, validation and the performance of the reports in development, system test and Production.
• Involved in user training sessions and assisted in UAT (User Acceptance Testing).
• Developed dashboards that used Open doc functionality to link a dashboard to a Webi reports.
• Created reports using Crystal Reports with Standard, Summary, and Cross Tabs and Grouping.
• Used conditional formatting as per user requirements in crystal reports.
• Resolved tickets to support production environment, Modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.

Confidential, New York, NY

Sr. Business Objects Developer

Responsibilities:

• Involved in 4 Full Development life cycles of universes from understanding the scope of the projects to deploy and support the universes.
• Provided on-site Business Objects XI Release 4 (4x) universe and Web Intelligence (Webi) report development services. Responsibilities with lead role in support of the Business Intelligence deployment.
• Developed Test Cases matching requirements with help from business analysts.
• Created various Cross-tab, Master-detail, tabular and Summary reports.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.
• Involved in analyzing, developing and testing various Business Objects Reports based on grouping, drill downs, charts and custom formulas etc.
• Converted P1 reports from desktop Intelligence to web intelligence using Report conversion tool and manual conversion method.
• Applied calculations and used formatting using different colors and functionalities i.e. alerter, sorting, and ranking and formulae in the report.
• Wrote a full functional specification document for the security to be implemented in Business Objects.
• Involved in dimensional modeling - Star Schema customization.
• Developed reports in Webi and worked extensively with (functions select, prompt, where) in designer, created optional prompts, also created objects using complex case functions.
• Developed reports in 4.0 in web intelligence.
• Enhanced and modified the Sales Commissions full-client and web intelligence report issues.
• Analyzed specs and database model to generate the reports for the sign-off specs.
• Created Business Objects Web Intelligence reports and published on the InfoView.
• Wrote SQL queries to extract the data from Sales Force database.
• Wrote Formulas to calculate the Percentages and Summaries based on the group levels.

Confidential, Baltimore, MD

Sr. Business Objects Developer

Responsibilities:

• Gathered business requirements and performed detailed analysis.
• Defined contexts, aliases and used multi parse SQL in the universes to address loops, chasm traps and fan traps, which support Ad-hoc and canned reports.
• Used Index awareness, aggregate aware and aggregate tables for optimized query performance.
• Created universe on top of views build in composite coming from multiple data sources.
• Worked extensively with functions (select, prompt, where) in designer, created optional prompts, also created objects using complex case functions.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality.
• Wrote functional specification documents for the project scope to be created in security to be implemented in Business Objects XI R 3.1
• Extensively involved in developing Web Intelligence reports' publications, scheduling and monitor publications.
• Created Xcelsius Dashboard using Query as a Web services and Live Office as a source.
• Developed dashboard using Xcelsius, involved in POC and user training on Xcelsius and live office
• Implemented Row level restriction for managers profiles using designer.
• Resolved tickets to support production environment, modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF.
• Used aggregate aware function and Aggregate tables for optimized query performance.
• Used prompts to create predefined conditions and prompts to filter the data and dynamic user selection.
• Worked with Crystal Report 2008/XI for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports and analysis reports.
• Used conditional formatting as per user requirements in crystal reports.
• Worked as Dashboard/Performance Manager to analyze the Variance in Sales and have used Dynamic Visibility, Drill Down, Push Button, Toggle Option, Content Linking, What-if analysis and Alerts..
• Extensively worked with SQL Developer running on Oracle 9i client to cross check the data accuracy, validation and the performance of the reports.
• Developed Graphic Reports, Pie charts for the statistical representation of the data.
• Tested the Web Intelligence reports in System Integration and Testing (SIT) environment and Performance Testing (Staging) environment to validate performance of all the reports, which helped in analyzing its performance before moving into production environment.
• Extensively used Variables, Sub-queries, Input Controls, Context Operators (In, For Each and For All), Drill down, folding/unfolding, Breaks, Sections, Ranks and Alerters in the creation of reports.
• Created complex reports using Free Hand SQL (Custom SQL) feature of Business Objects Web Intelligence.
• Developed various WEBI reports and dashboards using OLAP (Sap BW as a data source) Universe.
• Involved in user training, trained users on InfoView and Xcelsius Applications, and provided technical guidance to users.
• Written user training documents for basic implementation Design and create User guide and Training Guides.

Confidential, New York, NY

Business Objects Developer

Responsibilities:

• Developed full client and Webi reports using Business Objects.
• Gathering user-requirements/feedback, implementing them in reporting applications, testing, QA and delivery.
• Designing, Creating and Maintaining Universes.
• Ongoing maintenance of developed applications, and handling the change requests.
• Train power users to take advantage of the Business Objects environment for ad hoc query and report development.

Confidential, Tampa FL

Business Objects/Crystal Report Developer

Responsibilities:

• Involved in user requirement gathering for the project, interacted with the Business users to better understand the requirement and to propose solutions.
• Involved in development of universes and reports, also involved in production support, solving user tickets and issues on daily basis.
• Developed universes for sales and marketing department, using star schemas and snowflakes as source for these universes.
• Worked extensively with (select, aggregate aware, where, and prompt) to overcome the problems with database when integrating with Business Objects
• Created templates for standardizing the Structure of our Corporate Documents.
• Worked extensively with the major functionality of Business Objects like Breaks, Alerters, Filters, Sorts, Query Prompt and Drill filters.
• Provided post production Business Objects universes and reports support and maintenance.
• Optimized report performance by modifying the SQL generated by Business Objects, used combined queries and sub query options to bring complex result set in the report.
• Used Crystal Report XI Enterprise to design the front end reports.
• Used Team Track to track the status of the report by developer, state and comments.
• Scheduled various reports on a weekly or monthly and sent the output to users.
• Responsible for improving the query performance by 80% by tuning the Queries and creating business views.
• Created User Ids and implemented security features.
• Managed categories that were created and assigned to documents by users.
• Worked with Crystal Report for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports and analysis reports.
• Used conditional formatting as per user requirements in crystal reports.
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Provided complete documentation and presentation at the end of the contract to help users in developing various reports using different functionalities and methods used in creation of reports.