SUMMARY

• Over 9 years of experience in IT, Designing, Developing, Implementing and Testing of Business Object Applications.
• Expertise in Business Objects Reporting tools: CMC, Desktop Intelligence, Web Intelligence, Import Wizard, LCM Jobs, Report Conversion Tool, Crystal Reports and Xcelsius
• Sound Knowledge of Business Intelligence and Data warehousing concepts.
• Data modeling experience using Dimensional Data modeling, Relational Data Modeling, Physical & logical data modeling.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables. Experience includes designing, implementing and integrating various Data warehouse and Data Marts using Oracle and SQL Server databases.
• Experience in building universes, developing reports, and analyzing OLAP data.
• Trained users in producing documents and running queries.
• Worked with many types of team members for different tasks. Tested reports for validating and verifying data.
• Expertise in Business Objects suites: Installation, configuration and integration of systems, design, development and production rollout of Business Objects reporting Application.
• Expertise in creating highly formatted canned reports and well versed with universe designing, ad - hoc report writing.
• Created complex reports in Web Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
• Expertise in Integrating and Extracting data into Business Objects environment from the SAP BW database system.
• Proficient in SQL, PL/SQL and extensively used PL/SQL in writing Views and Stored Procedures.
• Expertise in BO administration activities like creating and managing repositories, user/group security, Folders, Servers Monitoring etc...
• Capable of improving the Business Process, have shown signs of Entrepreneurship, & Strategic project management. Exceptional technical, liaison, and interpersonal skills have helped me taste success throughout my career.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T-SQL, C#

Databases: ORACLE 11g/10g, SQL Server 2005/2008, SAP BW

Tools: BI 4.0/ BO XIR3/XIR2, Crystal Reports 2011/2008/XI/X, Xcelsius, Dashboard Manager, TOAD, SSRS, SQL Developer, Oracle Warehouse Builder 10G/11G

ASP.NET Technologies: .NET Framework 4.0, C#, Web Services, Framework 4.0, C#, Web Services

PROFESSIONAL EXPERIENCE

Confidential

Learning Systems Reports Developer

Responsibilities:

• Gathered client requirements on development of new reports and enhancement of existing reports. Prepared Fit-Gap Analysis and Functional Specification documents on the basis of this.
• Worked on creating new SQL queries and procedures to load the required report data into relevant tables.
• Created data flows and scheduled their execution to automate the loading of tables which would contain report related data.
• Designed new generic dimensions and measures that would be useful for number of reports.
• Set up user and data security at Universe level.
• Designed queries and layout for adhoc reports as well as canned reports as per user requirements.
• Successfully implemented the concept of master-detail reports using Drill functionality.
• Created Complex Cross tab reports and formatted the reports based on user’s mockup.
• Used the Business Objects Central Management Console to set up user/Group/Folder security.
• Set up daily, weekly and monthly schedules for reports with output to various formats and destinations.

Confidential

Senior Reports Developer

Responsibilities:

• Gathered requirement analysis, data modeling, extraction, reporting and technical implementation. Conducted extensive requirement gathering workshops with the end users.
• Created Universes for ad-hoc and canned reports based on relational data model
• Create Active Directory groups for various folders and add users to them.
• Responsible for Planning, Installation, Administration and Maintain Business Objects in Dev, Test & Prod Environments.
• Performed troubleshooting / tuning CMS and server tuning parameters for Business Objects XI R2 environments.
• Implemented potential refinements and improvements in the Business Intelligence architecture.
• Involved in converting SSRS reports into Crystal and WEBI Reports.
• Created crystal reports with pixel-level detailing of the layout as per user requirements.
• Used multidimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints

Confidential, Burbank, CA

Senior Reports Developer

Responsibilities:

• Coordination of security requirements and user administration, rights and user groups supporting various organization views.
• Created complex Web Intelligence reports using multiple data providers, Drill Down, Graphs, complex filters, prompts, sub queries and free hand SQL.
• Created various 3D pie charts, Pie charts, Bar Charts, Line Charts.
• Drill down the Analytics to the detail level data by a Web Intelligence Report.
• Utilized Calculation contexts for several Web Intelligence reports.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Involved in optimizing the universe developing time and SQL Tuning to increase the query performance using Aggregate Aware function for faster data retrieval.
• Developed User Training Manual and Trained the users to build ad-hoc reports and scheduling reports.

Confidential

Data Base Developer

Responsibilities:

• Participated in security aspects, development of user interfaces using oracle forms, reports and testing.
• Involved in all phases of software development including gathering requirements, creating specifications, prototype development, and development of database, developing code and validating programs.
• Created PL/SQL Procedures, Functions & Triggers for business rules.
• Developing and maintaining ETL mappings in Oracle Warehouse Builder.
• Tuning the PL/SQL code for performance enhancement.
• Managing the rollback segments, table space, user objects and user privileges.

Confidential

Technical Consultant

Responsibilities:

• PL/SQL Stored procedures and packages to implement business logics.
• Creation of Functions, Triggers and many other database objects