SUMMARY

• Over 7 Years( 5+ yrs in US and 2 yrs in India) of strong experience in Analysis, Design, Development and testing of BI (SAP BOBJ Reporting including Dashboards, BO Universes (IDT/UDT), WebI Reporting, Crystal Reports and SSRS).
• Experience in implementation of BI Reports in Healthcare, Telecom and Entertainment.
• Worked as Business Analyst/System Analyst while creating Facets reports in Business Objects.
• Experience in GAP Analysis, Gathering requirements, facilitate JAD Sessions, getting requirements sign - offs.
• Experience in creating report Mock-ups, functional and technical documentation.
• Experience in field mapping from back end tables to the Data Elements.
• Experience in Translating Business needs into end-user Reports using SAP BI 4.0/3.1/XI R2, SSRS 2008/2005, Crystal Enterprise Suite 2011/2008.
• Good understanding of DW concepts, Star Schema, Snow flake schema concepts.
• Experience working in BI 4.0 Launchpad, WebI, Rich Client, Information Design Tool(IDT), Universe Designer(UDT), Import Wizard, Report Conversion Tool (RCT).
• Experience in Migrating reports from BO 3.1 to BI 4.0, Converting DeskI to WebI, Validating the migrated content(connections, schedules, report data), rewriting the free hand SQL DeskI Reports to WebI reports by creating new Universes.
• Experience in creating interactive dashboards using SAP Dashbaord Designer and Xcelsius 2008.
• Experience in different dashboard connectivities (Add Query, QaaWS, Live office, WSS & XML Data).
• Experience in creating visualizations(Charts, selectors, maps, We connectivity) for KPI’s using Xcelsius Dashbaord Designer.
• Experience in creating What-if Analysis, trend analysis in corporate dashboards.
• Experience in CMC to create user security, folders, creating connections, Updating Database connectivity for Crystal Reports, monitoring schedules.
• Experience in Schedule Manager to change the connectivity information for the scheduled reports.
• Strong exposure to Software Project Development full life cycle (SDLC).
• Experience in gathering requirements, developing complex reports, creating reusable formulas.
• Exposure to Healthcare data model (Facets 5.01, 4.81)
• Experience in writing complex SQL, PL/SQL, SP’s in different RDBMS: Oracle 11i/10g/9i and MS SQL Server 2008.
• Experience in performance tuning SQL queries.
• Experience in BI Unit Testing, Integration testing, User Acceptance Testing (UAT).
• Experience with QC/HP ALM to develop Test plan, test case execution and defect tracking.
• Experience in On call and production support.
• Experience in enhancement and maintaince of BOBJ reports and Universes.
• Experience in Designing and Developing reporting solution using SSRS.
• Experience in writing various types of SSRS reports (Drill-down, parameterized, Cascading, conditional, Table, Matrix, Chart, and Sub reports)
• Hands on experience in Service Request/Defect tracking system.
• Excellent communication, analytical, presentation, inter personal skills, and problem solving skills.
• Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS

BI Reporting Tools: SAP BI 4.0, Business Objects 3.1/XI R2, WebI, DeskI, Crystal Reports 2011/2008, Dashboard Designer, Xcelsius, QaaWS, SSRS 2008/2005

Database: SQL Server 2008/2005, Oracle 11i/10g/9.x, Sybase

Testing: Manual Testing, QC/ HP ALM

PROFESSIONAL EXPERIENCE

Confidential, Corvallis, OR

SAP BOBJ/Crystal Consultant

Responsibilities:

• Worked in Agile environment as a SAP BI Consultant.
• Defining scope of the reports, performing GAP analysis, Facilitate requirements sessions.
• Documenting the business requirements, creating report mockups, responsible for getting business sign-off on the BRD’s and Mockups, created technical docs for Facets data model to create WebI and Crystal Reports.
• Involved in end to end report development life cycle by gathering requirements, build reports, created test strategy, report deployment, QA and post production support.
• Created BO universes using IDT (Information Design Tool)/UDT, Universe Objects, Classes, Contexts, Aliases, Derived Tables, Filters, Conditions, LOV and Cascading Prompts.
• Resolved CHASM traps, FAN traps using Contexts and Aliasis based on situations.
• Designed complex schemas using various @ functions like @Select, @Where, @variable, @prompt and @Aggregate Awareness.
• Created Custom hierarchies in the universe to build reports with Drill-Down, Drill-up and Drill through functionality.
• Created complex derived tables using multiple sub selects and EXISTS conditions.
• Created complex WebI reports by linking data from multiple data providers and merge dimensions.
• Created complex reports using diverse BO functions such as Slice & Dice, Master/Detail, Cross-tab, UserResponse functions, sections, breaks, filters, Alerters and complex variables.
• Created WebI reports using sub-queries, combined queries, using objects from another query in to query filters.
• Created Hyper Linking, linked reports using Opendoc URL functionality.
• Created reports for different Facets modules (Eligibility/Membership/Claims/ Provider and CS).
• Created enterprise Dashboards using BI 4.0 Dashboard Designer.
• Created visualizations, trent analysis, What-if Scenarios for Different KPI’s (Claims processing time, Customer Service Inquiry resolution time, Cash Reserve Analysis for Finance)
• Created complex Crystal Reports using Charts, Grouping, Section Expert, Sub-Reports, Drill down Reports and Sub-Reports parameters linking.
• Created crystal reports using crystal report formulae, Group Expert, Record Expert, Section Expert, Conditional Supressing, Conditional sorting, Conditional paging, Running totals, Group Totals.
• Extensively used SQL to build Crystal reports using command line, local & Global variables to use the variables from one subreport to the other, multiple frequency parameters, Exception handling for Date prameters, optional prompts.
• Worked on Defect fixing for existing Production Reports.
• Worked on RCT to convert the reports from DeskI to WebI before migrating the reports to newer versions of BI 4.0.
• Fixed Hyperlink issues after converting through RCT, fixed Totals issues for multi source reports using ForceMerge().
• Validating the migrated content from 3.1 to 4.0, validating user access, Universe access, validating schedules, connections and report data.
• Converted Freehand SQL DeskI Reprots to WebI by creating new Universes.
• Created test plan, excecuted test cases, creating defects in Defect module using QC/HP ALM.

Environment: SAP BI 4.0, IDT, UDT, WebI, Crystal Reports 2011, SQL Server 2008, SQL, PL/SQL, Facets 5.01/4.81, Windows 2003 Server

Confidential, Kirkland, WA

BI Developer

Responsibilities:

• Worked on multiple BI Projects for end clients.
• Interacted with end users in identifying the requirements and developed a detailed design document including technical specifications.
• Created BO universes, universe objects, classes, contexts, aliases, filters and conditions.
• Designed complex schemas using various @ functions like @Select, @Where, @variable, @prompt and @Aggregate Awareness.
• Extensively created WebI Reports using alerts, rankings, sorts, and drill-down (using custom hierarchies) in reports.
• Created complex WebI reports by linking data from multiple data providers and merge dimensions.
• Created Crystal Reports using Charts, Grouping, Section Expert, Sub-Reports, Drill Down Reports and Sub-Reports parameters linking.
• Extensively used SQL to build Crystal reports using command line, local & Global variables to use the variables from one subreport to the other, multiple frequency parameters, Exception handling for Date prameters, optional prompts.
• Worked on CMC as admin to create Users and their Security, LCM to promote the reports between different environments, and scheduling the reports for different groups.
• Created executive dashboards in Xcelsius using BEX, QaaWS and XML Source.
• Created prompts in the QaaWS universe and linked those in the Xcelsius spread sheet.
• Created complex SSRS reports with multiple Sub Reports and Cascading Prompts.
• Developed different kind of reports such as Sub Reports, Charts, Matrix Reports and Linked Reports.
• Optimized SP’s to improve the SSRS report performances.
• Created Form/Block reports in SSRS based on business requirements.
• Created SSRS reports from Multiple Data Sets and involved with Query optimization to improve the report performance.

Environment: SSRS, SSIS, SAP BI 4.0/3.1, IDT, UDT, WebI, Crystal Reports 2008, Xcelsius using QaaWS, Oracle10g, SQL Server 2008

Confidential, Seattle, WA

MS BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Worked with team foundation server maintaining versions of reports and packages.
• Designed, developed reports using complex formulas and to query the database to generate different type of reports using SSRS.
• Created parameter driven reports using Charts, Cross-Tabs and Sub-Report types.
• Responsible to support the issues with reports on the Enterprise Environments (DEV, QA, UAT and PROD).
• Created reports from multiple data sources and data sets.
• Experience in creating Tabular reports, Matrix Reports, List reports using SSRS.
• Configured and maintained Reprot Manager and report server for SSRS 2008.
• Worked on tuning the stored procedures to improve the running time.
• Created Ad-hoc reports using MS Reporting Services.
• Good understanding of SSRS with Reprot Authoring, Report Management, Reprot Delivery and Reprot Security.
• Worked on Defect fixing for existing Production Reports.

Environment: SQL Server 2008/2005, SSRS, SSIS, BI Studio, SQL Server Management Studio, T-SQL.

Confidential

BO/Crystal Trainee

Responsibilities:

• Designed, developed and maintained Universes for supporting Ad-hoc and cannedReports (using WebI/DeskI/Crysta).
• Resolved join path problems using Contexts and Aliases.
• Worked with different Universe functions @Select, @prompt, @Where and @Aggregate Aware.
• Created Custom Heirarchies in the universe for multi dimensional analysis.
• Created various classes and Measure objects and User objects were created keeping in view of the end-user requirements.
• Created Derived Tables, Dimensions, Measures, Filters and Universe level prompts.
• Created Desk Intelligence, Web Intelligence Reports using multiple Universes.
• Created WebI reports using sub-queries, combined queries, using objects from another query in to query filters.
• Created report variables, report filters, report sorting, ranking, section, breaks and alerters.
• Created Tabular Reports, Matrix Reprots, Charts (Line Chart, Pie Chart, Bar Charts)
• Migrated Objects from one Environment to the other using Import Wizard.
• Created the Stored procedures and functions at the back end.
• Created complex Crystal Reports using Charts, Grouping, Section Expert, Sub-Reports, Drill down Reports and Sub-Reports parameters linking.
• Created crystal reports using crystal report formulae, Group Expert, Record Expert, Section Expert, Conditional Supressing, Conditional sorting, Conditional paging, Running totals, Group Totals.
• Used SQL to build Crystal reports using command line, created variables, multiple frequency parameters, optional prompts.
• Created Drill down reports using Crystal XI.
• Performed Unit testing, intergration testing, regression testing and User Acceptance Testing.

Environment: BO XI R2, Infoview, WebI, DeskI, Oracle 9i, Windows 2003 server, CMC.