SUMMARY

• Over 7+ years of IT Industry experience which includes Business Objects, Business analysis, Business Intelligence, Business Architecture and Data Warehousing including Data Analysis and Data Mapping, Web Intelligence, Xcelsius, Crystal Report.
• Experience in Analysis, Design, Development and Implementation of Business Intelligence tools like Business Objects XIR3.1/XIR2/6.x/5.x Designer, various types of Reports and Charts using Web Intelligence, Desktop Intelligence, Crystal Reports 2008, Central Management Console.
• Created complex and sophisticated Reports using Web Intelligence and Desktop Intelligence. Experience in gathering business data requirements, documentation for reporting requirements and presentation, educating, supporting end - user reporting needs using Business Objects.
• Extensively used Business Objects reporting functionalities and implemented Business Objects security features
• Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Capability to prioritize, integrate, coordinate project activities and tasks, interact with business users to analyze the business process and requirements, transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Good problem solving and decision making skills. Ability to work effectively in a team as well as independently with excellent communication, leadership and interpersonal skills. Capability to develop creative solutions for challenging client needs. Flexible & Quick learner, who can adapt and execute in any fast paced Environment.

TECHNICAL SKILLS

Business Intelligence: Business Objects 4.0 /XI 3.1/XI R2 - CMC, Import & Export wizard, Data Integrator XI, Desktop intelligence, Xcelsius, Web Intelligence, Crystal Reports XI/2008, Crystal Xcelsius 4.5/2008, MicroStrategy 8.0, Lifecycle Manager

ETL Tools: Informatica, Power Center 7.1

Data Modeling Tool: ERwin and Visio 2010

RDBMS: SQL Server 2008/2005/2000 , DB2, MS Access

Database: Oracle 10G/9i/8i, Teradata, DB2, MS SQL Server 2000/2005, Excel.

Operating Systems: Windows XP, Windows 2000

Programming: SQL, PL/SQL, HTML 5, XML,TOAD

Project Planning Tools: HP Quality Center, MS-Visio, Microsoft Project and Microsoft PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Virginia

BI Analyst

Responsibilities:

• Analyzed user problems, including automated and manual business processes, and identified, researched, investigated, defined and documented business processes.
• Co-authored business requirements documents with the business users. Extracted, discussed, and refined business requirements from business users and team members. Coordinated activities between business unit and technical staff, developed new methods, policies, and procedures to meet the business needs, as well as acted as primary trainer in educating the business units, related to business applications.
• Created Universes using Designer by retrieving the data from database, defining the connections necessary. Checked Universes for Integrity and exported to repository to make it available for user groups.
• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans.
• Generated Business Objects reports by writing complex queries including Sub queries and Unions. Responsible for Creating Business Objects Groups and Users and managed user profiles using Supervisor.
• Involved in creating dynamic Web intelligence reports.
• Responsible for building of Classes and Objects. Defined Cardinalities, resolved Loops by creating Aliases and Contexts to remove the cyclic dependencies. Created User Objects including Dimensions, Details and Measures.
• Reports were formatted according to the user requirements using Business Objects functionalities like Queries, Slice and Dice, Drill Down and formulas.
• Created template to customize style and structure of the canned reports to maintain company standards. Managed and formatted standard, master/detail and cross tab reports using Report Manager.
• Automated refresh of reports per desired schedule (hourly, daily, monthly, quarterly, etc.)

Confidential, New York

Senior Business Intelligence Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and other team’s members to analyze business requirements and outline the proposed resolution.
• Responsible for designing reports for distribution to senior managers
• Performed data testing, functionality testing, performance testing, load testing of Universes and reports.
• Created reports and extracted data from relational databases using SQL queries. Optimized, debugged and tested SQL.Authored reports to define and elaborate Universe design procedures and protocols followed for future by end users.
• Implemented Business Objects security features like row level, object level and report level security.
• Built new Universes per user requirements by identifying information required from corresponding tables located in data marts via defined Universe connections. Analyzed the existing database schema, retrieved the Fact and Dimension tables and created Joins as identified in the Universe design.
• Exported Universes to Repository for resources availability to other users for ad-hoc report generation.
• Utilized a variety of reporting tools such as SQL and ACCESS for querying underlying database tables and resolved data issues.
• Performed in-depth data analysis upon multiple EDW environments.
• Expertise in creating Customized Objects, Cascading List of Values, Dashboards, Metrics, Rules, Alerts and Goals using Xcelsius for user analysis based on user requirement, Testing, Technical Troubleshooting and application version enhancements using quality driven methods. Involved in creating features like drill down, slice and dice, defined hierarchies, cascading list of values, derived tables, self-restricting joins and row-level security utilized in Universe design.
• Conducted seminars for end users.

Confidential, New Jersey

Business Objects Developer

Responsibilities:

• Gathered system requirements from Business Owners, Business Users and worked closely with Functional Architect, DBA and Analysts.
• Performed data testing, functionality testing, performance testing, load testing of Universes and reports.
• Gathered report requirements from Business users and prepared the Technical specifications and Mockup Reports.
• Utilized BO Designer to develop and create Universe, Classes with different types of Objects, Defined Cardinalities, Applied Contexts and Alias to resolve join problems like Loops, Fan Traps and Chasm Traps. Created Classes, Sub classes, Objects, Conditional Objects, Cascaded Prompts, Cascaded LOV, Custom Hierarchies for Business Analysis and Report Generation.
• Applied Slice-and-Dice, Drill-Up and Drill-Down Techniques in Master Detail Reports for Multi-Dimensional Analysis of Retrieved Data.
• Scheduled Reports on a Daily, Weekly, Monthly and Quarterly.
• Created Different Types of Reports like Master/Detail, Cross Tab and Charts

Confidential

Business Objects Developer

Responsibilities:

• Participated in upgrading the Business Objects version and Web Intelligence at the organisation.
• Migrated Universes, Connections, Web intelligence Reports from the existing version 6.5 to XIR2 using Import Wizard
• Extensively worked on CMC (Central Management Console) in maintaining objects, Universes, Connections, Resources, Users, User Groups and Categories in Business Objects XI.
• Worked in Data Modeling to design Data cubes.
• Documented the Universe design and Reports development.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae.
• Created Sub Reports and custom prompts in crystal Reports and generated various standard, ad-hoc/canned reports
• Created Crystal reports using Business Views and Universes as data providers.
• Converted full client report to Web Intelligence using Report Conversion Tool.
• Participated in the unit testing, assembly testing and execution of the trial and actual conversions.