SUMMARY

• Highly skilled Business Intelligence Developer/Data Analyst with over 6 plus years of Data ware housing/BI Reporting experience, possessing superior analytical skills and the ability to meet deadlines. Enjoys, sharing technical expertise and coordinating projects with team members. Professional skills and competencies include the following but not limited to.
• Experience in Analysis, Design, Development, Implementation, Testing and support for various data warehousing applications in Business Objects.
• Experience in Business Objects administration to support end user security and tracking using cmc.
• Strong development skills including the ability to work through the entire SDLC from gathering requirements through implementation.
• Extensive experience in migrating/upgrading the Business Objects universes and reports from one version to another.
• Good experience in Business Objects Administration.
• Excellent experience with Data Warehouse Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables. Experience includes designing, implementing and integrating various Data warehouse, Data models and Data Marts.
• Worked extensively with Business Objects functionality like Breaks, Alerts, Filters, Sorts and Query Prompts.
• Good knowledge in BI 4.0 enterprise suite(BI Launchpad, BI Work Spaces, Upgrade Management Tool and Universe Builder)
• Proficient in gathering the user requirements to before creating the reports.
• Excellent experience on dimensional modeling and various data ware houses like Health care, Pharmaceutical, and financial.
• Extensively worked on relational databases like Oracle and Sql server for dimensional modeling of data marts on subject area.
• Well versed in Data analysis and creating KPI’s on Business Intelligence platform using reporting tools like Business Objects, Crystal.
• Extensive experience in operational and adhoc reports on various domains like healthcare, financial and clinical research.
• Proficient in multi - dimensional analysis using Drill Mode, Slice and Dice etc in Business Objects.
• Exceptional experience in dealing with various databases like Oracle, SQL Server, MS Access, and Flat files.
• Strong experience in writing complex Sql queries.
• Experience in developing Crystal reports using Crystal reports 2008
• Excellent experience in writing Sql statements using Oracle 10g /9i /8i/7.3, SQL, PL/SQL, TOAD.
• Very strong communication and interpersonal skills with people of all levels and roles.

TECHNICAL SKILLS

Data ware housing: Dimension modeling, Star Schema, Snowflake Schema, OLAP cubes.

Business Intelligence Reporting: Business Objects 6.5,XI R2 and XI 3.1

Business Objects Enterprise: Designer, Desktop Intelligence, Info View, Web Intelligence, Import Wizard, Crystal reports 2008,Xcelsius 2008

Database: Oracle 7.3,9i / 10g,Sql and Pl/Sql

Web Application Servers: Apache Tomcat 4.0

Operating systems: Windows NT 4.0/2000/XP,UNIX

PROFESSIONAL EXPERIENCE

Confidential, MA

BO Developer

Responsibilities:

• Worked on Supply Chain POC Project.
• Designed the Universe in BI 4.1 for supply chain metrics.
• Created cross Tab and drill down reports on supply chain measures for multi-dimensional analysis
• Created the Variables on webi report to customize the data.
• Worked on merging the dimensions on webi to combine different subject area’s data with respect to common dimensions.
• Extensively worked on Conditional formatting to highlight the metrics data as per business standards.
• Customized the list of values in the universe on specific dimensions as per business rules.
• Developed user prompts in universe and reports for adhoc reporting.
• Extensively worked on Sql to validate the report’s data.

Environment: Business Objects 4.1, Oracle 11g, TOAD, Windows 2000, MS Excel.

Confidential, Billerica, MA

Analyst/Report Developer

Responsibilities:

• Worked with users to gather the reporting requirements before designing of Business Intelligence reports.
• Extensively worked on Clinical and financial data ware house to develop operational reports and key metrics using Business Objects.
• Pulled the data from multiple databases/domains and merged at the report level to show cross functional data together.
• Created users/groups in cmc and assigned the security for them to designated folders.
• Assisted the researchers by providing the data using adhoc reports and Sql queries.
• Worked with other BI team members and Application staff to define reporting requirements to support Business Analytics applications and reports.
• Designed the universes on specific subject areas of data warehouse for end user adhoc reporting and Operational reports.
• Developed various types of reports in Web Intelligence 3.1/4.0 to facilitate the business needs.
• Extensively worked on multi-dimensional reports and graphs in Business Objects based on various dimensions like Physician, location, Drug etc.
• Extensively worked on variables, objects, breaks, alerters and functions of Business Objects XI 3.1 and 4.0 while report development.
• Implemented the row level security on operational reports when different business groups access them.
• Created standard metrics of BI analytics to support self-service Business Intelligence platform.
• Worked on our clinical research dimensional modeling to implement best practices of BI analytics.
• Developed master detail and cross tab reports in Business Objects/Crystal reports based on various dimensions.
• Developed the key metrics and hierarchies in the BO universe for multi-dimensional analysis.
• Developed standards and guidelines for the use of metadata describing data elements and how they are used.
• Extensively worked on Sql queries to debug the report’s data.
• Actively involved in technical support of department users during UAT and production.
• Scheduled the reports in infoview/cmc to distribute to the various Departments.
• Worked on publications in infoview/cmc to burst the report based on Physician and company.

Environment: Business Objects XI 3.1(Web intelligence, Desktop Intelligence, Designer, Info view,cmc,CCM),Crystal reports 2008,BI 4.0(Upgrade Management tool, Universe Designer, BI Launch pad)Windows XP,2000,Oracle 11g,Sql,MS Excel. TOAD.

Confidential, Framingham, MA

BO/BI Developer and BO Administrator

Responsibilities:

• Analyzed the metrics and their standards in data ware house development perspective.
• Gathered the business requirements for adhoc, operational reports and translated them to universe design.
• Extensively worked with business users, technical application and ETL team to understand the data flow from application to data ware house.
• Created simple and complex metrics using Sql queries on data ware house and translated them to BO reports.
• Worked as a BO Administrator to make the reporting platform available 24/7 including security model, patching, scheduling etc.
• Worked on cmc to define the security model as Business standards.
• Converted all Deski reports to Webi before migrate them to BI 4.0.
• Worked on Upgrade management tool 4.0 to upgrade the reports from 3.1 to BI 4.0.
• Extensively used BI Launchpad to run, analyze and schedule the reports of BI 4.0.
• Developed Universes (.UNX) using Information Design tool 4.0 to cater the enterprise reporting needs of Confidential systems.
• Created derived tables in the universe by embedding complex sql to reduce the complexity at report development.
• Extensively worked on migrating/upgrading the Business objects content from version to version and across the environments.
• Extensively written Sql queries to develop one time use reports.
• Extensively worked on financial data ware house to develop operational reports and key metrics in web intelligence XI 3.1.
• Developed the prompts in the universe and reports on various dimensions for end user analysis.
• Developed multi-dimensional reports in Web intelligence using the key metrics designed in the universe.
• Worked on dimensional model to update it with new tables and fields in Universe designer.
• Worked as BO support person to resolve the technical and data issues when the reports are in production.
• Extensively written Sql queries for quality testing of reports and for data validation.

Environment: Business Objects XI R2/3.0 (Designer, Web Intelligence, Desktop Intelligence, Crystal Reports, Central Management Server, Central Configuration manager, Import wizard, Report Conversion Tool),Oracle 9i, PL/SQL, SQL * Loader, UNIX, Windows NT, TOAD.

Confidential, MN

Report Developer/BI Analyst

Responsibilities:

• Analyzed the data requirements for the report to design the universe.
• Extensively worked with users to identify the reporting requirements.
• Developed the data mart on mortgage data ware house using dimensional modeling.
• Extensively worked on Sql to create views, derived tables while dimensional modeling of Universe.
• Developed Xcelsius Dashboards using the Data providers developed by QAWS.
• Designed the universes on star and snowflake schema using Business Objects XI 3.1 Designer.
• Designed the linked universes across the subject areas like General Ledger and Asset Detail.
• Designed the hierarchies in the universe for multi dimensional analysis.
• Extensively worked with business users to customize the objects in the universe.
• Developed derived tables in the universe to avoid the complexity of report development.
• Analyzed the reporting requirements before start developing the reports.
• Developed the General Ledger/Asset detail reports in cross tab format in Business Objects XI 3.1.
• Extensively formatted the reports in Web intelligence.
• Developed user prompts in universe and reports based on user requirements.
• Created alerters on reports for conditional formatting.
• Developed Drill down and cross tab reports for general ledger, asset detail and variance using Business Objects XI 3.1.
• Converted Crystal, Cognos reports to Business Objects XI 3.1.
• Developed multi dimensional reports on Asset Detail and General ledger for end user analysis.
• Developed prompts on date, locations and reporting units on webi reports using @prompt functions.
• Distributed the reports to end users using info view.
• Published the reports in web by using Web intelligence.
• Converted some of Crystal reports to Business Objects.
• Created alerts on Crystal reports for user notification.
• Created variables on reports to customize the data and facilitate report’s requirements.
• Developed master detail reports in Web intelligence based on various dimensions.
• Extensively used slice and dice functionality for multi dimensional reports.
• Developed Sql queries for UAT of Business Objects reports.
• Extensively used TOAD to create and execute Sql queries while report and data validation.
• Developed views using complex Sql queries to simplify universe design.
• Extensively written Sql queries to analyze and testing the reports.

Environment: Business Objects XI 3.1(Web intelligcne,Desktop Intelligence, Designer, Info view),Windows XP,2000,Crystal Reports 2008,Oracle 11g,Sql,MS Excel. TOAD.