SUMMARY

• Professional Summary Business Intelligence Professional and strong Business and Information Technology background with over Seven years of quantifiable
• SAP Business Objects XIR2 Certified Professional (BOCP)
• Experience in designing, building and maintaining Universes; resolving issues including but not limited to loops & traps, designing complex objects using @prompt, @aggaware functions
• Experience with data analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration and data creation
• Expertise in creating canned /Ad Hoc Reports using Business Objects, Web Intelligence, Crystal Reports and Crystal Xcelsius tools.
• Extensive experience interacting with business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.
• Worked on multiple migrations (6.X to XIR2 platform) as well as upgrade (XIR2 to XI 3.1)
• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating Complex and Ad - Hoc Reports using Business Objects.
• Involved in testing universes and reports for correct mapping of the objects and data correctness.
• Efficient team player with excellent communication skills, ability to work in groups as well as independently

TECHNICAL SKILLS

• SBI Tools: SAP Business Objects 6.5, XIR2, XI 3.1, 4.0, Designer, Desktop/Web Intelligence, Cognos 8.4,10, Xcelsius 2008, Crystal Reports XI, Import Wizard CMC, CCM, Report Studio, Framework Manager, SSRS,
• Database: MS SQL Server 2000, 2005, 2008 R2, Oracle 9i/10g/11g,Teradata, MS Access,
• Operating Systems: MS Windows 2000/NT/98/XP/Vista/7, UNIX, & LINUX,
• Programming: SQL, PL/SQL, C, HTML,
• Software: MS Office, MS Visio,
• Web Tools: Macromedia 6 (Flash, Fireworks, Dream weaver),
• Other Tools and Utilities: MS Office Suite, TOAD, MS DTS, SQL Server Query Analyzer,

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA,

Responsibilities:

• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Develops/Modify BI reports using Cognos Report Studio, Cognos Query Studio, Cognos Analysis Studio, and Microsoft Reporting Services.
• Design and develop metadata model in Cognos Framework Manager
• Gather/Design report requirements and build sophisticated reports/dashboards/scorecards, analysis and queries
• Provide security, control report access
• Design, develop and test new queries with end users
• Publish universes and reports to the repository and made them available to the appropriate user groups.
• Developed and maintained standard and ad hoc reports based on business and technical requirements.
• Used Designer to build universes and detected problems such as traps and loops in universes and resolved problems like aliases, contexts.
• Worked with customers to gather/develop requirements, interacted with the users to analyze the changes for improvement they need in existing reports and develop the reports to satisfy their needs and requirements.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Designed, developed, tested and successfully delivered 18 reports previously developed in Actuate e.Report Designer Professional to SAP BO XI 3.1 Web Intelligence documents.

Environment: BusinessObjects XIR3.1 (Reporter, Designer), BusinessObjects XI 3.1, MS Excel, MS PowerPoint MS Word Window XP InfoView, CMC, CCM, Web Intelligence, Xcelsius2008, Oracle 10g, MS Server 2005

JPMorgan Chase,

Responsibilities:

• Created universes and reports in Business Objects XIR2 and XIR3.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Created the joins strategies while designing the universes.
• Designed and developed executive dashboards using Crystal Xcelsius using LiveOffice.
• Created complex reports using user-defined functions, condition objects and aggregate awareness functions for PL/SQL enhancement.
• Connectivity tier with Web Intelligence reports as the source.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Involved in Unit, functional and Integration Testing
• Created different types of reports, like Master/Detail, Cross Tab and Chart for Trend analysis. Used filters, conditions, calculations, etc.

Environment: BusinessObjects XIR2/XIR3 (Reporter, Designer, Supervisor), Crystal Reports, MS Excel, Dashboard Manager, Infoview, MS Project, Windows XP Professional, Web Intelligence XIR2, Oracle 10, SQL Server for CMC.

Confidential, Fort Lauderdale, FL,

Responsibilities:

• Senior Business Intelligence specialist for the Global Technology Center assisting over a dozen clients with complex BusinessObjects issues including but not limited to administration, development and deployment. Serve as liaison between clients and SAP BusinessObjects technical support. Also serve as a liaison between clients and offshore specialists. Underwent steep learning curve with respect to industry verticals. Worked on all major database platforms including but not limited to MS SQL Server, Oracle, IBM DB2 and Sybase. Limited Teradata work.
• Used Designer Module to design Universes, joining the tables, creating prompts and queries and applied Contexts and Aliases to remove loops.
• Created universe classes and objects taking the information from the database. Also created measure objects, checked the Cardinalities, Contexts, Joins and Aliases for resolving Loops and Integrity of the Universes
• Migrate universes from test to production environment
• Upgrade from BusinessObjects 6.2 architecture to Business Objects XI 3.1
• Created, modified and enhanced Universes using BusinessObjects Designer for every user requirements including specific dimensions and measures.

Environment: BO XIR2/6.5, SQL Server 2005/2000, Windows NT, CMC, Desktop Intelligence, WebI 6.5, UNIX, InfoView, MS PowerPoint.

Confidential,Tampa, FL

Responsibilities:

• Performed requirements gathering for new reports to be created using Web Intelligence
• Converted all Desktop Intelligence reports to Web Intelligence. Where this caused errors, reports would have to be recreated using Web Intelligence.
• Performed analysis on accounting related activities that included disbursements, receipts, fair value accounting, government claims and loans.
• Trained hospital staff on how to use InfoView; particularly how to schedule reports for different time periods.
• Created reports using multiple data providers such as Sales Revenue VS. Location to analyze loss in revenue in particular geographical location. Also Created drill down reports with several hierarchical slices
• Assisted team with detailed documentation
• Part of team tasked with migrating existing reporting applications from 6.5 to XIR1 and XIR2.
• Worked with external clients to identify additional report requirements and document client requirements.
• Used Designer Module to design Universes, joining the tables, creating prompts and queries and applied Contexts and Aliases to remove loops.

Environment: Business Objects 6.X (Reporter, Designer, Supervisor), Crystal Reports, SQL Server 2000, MS Excel, MS Project, Windows 2000 Professional, Web Intelligence 6.1.3, Oracle.