SUMMARY

• Over 7.5 years of experience in Information Technology using Business Intelligence Tools - IBM Cognos and SAP Business Objects specializing in IBM Cognos suite of tools - Framework Manager, Report Studio, Analysis Studio, Power Play Studio (Cubes) in versions 8, 10.1 and 10.2; SAP Business Objects suite of tools - Universe Designer, Web Intelligence, Desktop Intelligence, Web Intelligence Rich Client, CMC, Crystal Reports and XCelsius Dashboards in versions XIR2.0, XIR3.1 and 4.0
• Involved in the full life cycle (SDLC) of projects including requirement gathering, development and unit testing, code migrations, system testing and user acceptance testing support and implementation.
• Created Cognos Packages using Cognos Framework Manager using 3 layer approaches, DQM mode following Governor Settings as per project needs.
• Developed multiple canned and un-canned reports using Report Studio using heavy conditional formatting, Charts, graphs, Table of Contents, Bookmarks, Prompts, Report Level filters, Dynamic Columns and more.
• Extensively used Cognos Analysis Studio to understand trends and anomalies in data for business needs; compare data for details to summaries and assess performance based on results.
• Analyze, design and develop Business Objects Universes from scratch and modify existing universes.
• Resolved loops and traps using Contexts and Aliases in universes.
• Worked extensively with @Functions like @Select, @Prompt, @Where and @Aggregrate aware to write flexible SQL queries.
• Used complex OLAP functions in derived tables in the development of universe for better performance, and use context and alias tables to resolve loops in Universe.
• Created complex reports using context calculations, conditional formatting, and multiple data providers and synchronized the data providers by merging common objects.
• Created reports with multi-level scope of analysis for Drill down and Drill up.
• Extensively used Open Doc Functionality, Input Controls, Variables, Filters, Sections, Breaks, Sorting, Ranking, 3D charts and Alerters on WebI reports.
• Created parent-child and cross tab reports with dynamic columns.
• Experienced with Business Objects XI R3 Central Management Console (CMC) including creation of Business Objects folders, documents, reports, user groups, profiles, schedules, publications, and security rights.
• Good knowledge in Dimensional Data Modeling, Star Schema, Snowflake Schema, Type 1 and Type 2 databases and understanding in Logical and Physical Data models.
• Expertise in writing and debugging SQL Queries in IBM DB2 and Oracle.
• Created on-demand reports in Crystal Reports using prompts and customized parameters.
• Design and developed XCelsius dashboards using filtered rows, color schemes and trend analyzers.
• Experienced working with offshore team for converting Business Objects Reports to IBM Cognos Reports.
• Developed packages and reports using Framework Manager and Report Studio in IBM Cognos 10.1 and 10.2
• Experienced in performance tuning for reports using explain plans and indexes.

TECHNICAL SKILLS

Business Intelligence Tools: BI 4.0, Business Objects XI R3.1, Business Objects XI R2 - Central Management Console (CMC), Information Designer Tool (Universe Designer), Desktop Intelligence, Web Intelligence (BI Launchpad), SAP Business Objects Dashboards (XCelsius), Crystal Reports, IBM Cognos 10.2.1 - Framework Manager, Report Studio, Query Studio, Analysis Studio, Power Play Studio.

Databases: IBM DB2, Oracle 10g/9i, SQL Server /2008, MS Access, Transact-SQL

Languages: SQL, PL/SQL, Java Scripts, HTML, XML, C, C++, Perl Scripting.

Other Tools: IBM Data Studio, WinSQL, Toad, MS Visio, SharePoint, HP Service Manager.

PROFESSIONAL EXPERIENCE

Sr Business Intelligence Developer

Confidential, Bloomington, IL

Responsibilities:

• Responsible for developing complex reports using Framework Manager, Cognos Report Studio and Query Studio in Cognos 10.2 as Senior Report Developer.
• Worked with IBM Global Services Team for converting existing Business Objects Reports to IBM Cognos reports using Report Studio and Framework Manager in IBM Cognos 10.2
• Created Cognos Power Cubes using Cognos Analysis Studio to analyze data and Power play Studio to present analytics to Stakeholders.
• Worked on developing and maintaining several Business Objects reports using Universe Design Tool(UDT), Information Design Tool (IDT), BI Launchpad, Web Intelligence Rich Client in Business Objects 4.0 and XIR3.1
• Extensively worked in developing reports in Development and Simulation-Production environments for various releases and worked in many phases of project like requirements gathering, data modeling, report design, development and supporting System and User Acceptance Testing.
• Worked as service analyst in service team providing 24x7 supports to reports in Production environment by handling tickets through HP Service Manager, monitor ETL data flow and raise change requests to implement changes in Production Environment.
• Monitor report runs through Report Bursting, Control-M and report archiving through Control-D.
• Extensively used Auditing Database of Cognos and Business Objects to monitor usage of reports for service related tasks.
• Worked as Technical Lead during staffing changes.
• Experienced working in agile project environment in sprints and running scrum meetings on a daily basis.

Environment: IBM Cognos 10.1/10.2, Report Studio, Framework Manager, Analysis Studio, PowerPlay Studio, Business Objects BI 4.0, Universe Design Tool(UDT), Information Design Tool (IDT), BI Launchpad, Dashboards 4.0, BO XIR3.1, Web Intelligence, WebI Rich Client, Central Management Console (CMC), IBM Cognos 10.2, IBM DB2, IBM Data Studio 3.1.2, Ultra Edit, HP Service Manager, SharePoint, BMC Control-M and Control-D.

Business Objects Developer

Confidential, Dallas, TX

Responsibilities:

• Analyze, develop and gathered requirements for new universe development and maintain the existing universes.
• Created complex reports using Business Objects XIR3.1; Universe Designer and Web Intelligence Rich Client.
• Extensively worked on Star schema and Snowflake schema data models with Data Modelers for designing reports.
• Used complex OLAP functions in derived tables in the development of universe for best performance.
• Create measure objects and export them to production environment to make them available to the users for ad-hoc report needs.
• Worked on Business Objects XI R3.1 Central Management Console (CMC) for setting up security to users and created user groups, profiles, schedules and security rights.
• Provide for end users for generating their own report for adhoc reporting needs.
• Created on-demand reports in Crystal Reports using prompts and customized parameters.
• Worked as a seasoned Business Analyst to gather requirements for Business Objects Reports. Created report requirements artifact packages in IBM Lotus Notes.

Environment: Business Objects XI R3.1, Universe Designer, Desktop Intelligence, Web Intelligence, Web Intelligence Rich Client, Infoview, Supervisor, Crystal Reports, Central Management Console (CMC), Oracle 9i, IBM Lotus Notes, SharePoint, Toad and WinSQL.

Business Objects Developer

Confidential, San Diego, CA

Responsibilities:

• Developed Reports using Business Objects XIR2/XIR3.1
• Involved in Business Objects XIR2 migration and performed testing to ensure the reports are functioning as expected in new version XIR3.1.
• Extensively worked on troubleshooting, customizing, maintaining backups and checking out reports after migration.
• Created adhoc reports for requirements with urgent priority.
• Provide for end users for generating their own report for adhoc reporting needs.
• Create measure objects and export them to production environment to make them available to the users for ad-hoc report needs.
• Created fabricated data for unit testing after development.
• Developed T-SQL Stored Procedures.
• Worked on developing reports and dashboards using SSRS.
• Created Dashboards using SAP Business Objects XCelsius Dashboard and MS Excel.

Environment: Business Objects XI R2/ XI R3.1, Universe Designer, Desktop Intelligence, Web Intelligence Rich Client, Infoview, XCelsius, SQL Server 2008, Transact - SQL, SSRS.