SUMMARY

• Over 14+ years of experience as a Senior Reports Developer / Business Objects Consultant with rich experience in designing and developing, testing and providing support for the effective implementation of applications, to suit the business needs of corporations
• Experience in Designing and Documenting Universe Requirements definition templates, Security strategies and Migration strategies (Designed almost 50+ universes)
• Expertise in Designing and Documenting Reports Requirements definition templates, Security strategies, Distribution strategies and Migrating strategies. (Created almost 80+ Reports)
• Strong experience in creating universes, designing and maintaining various reports using Business Objects 5.x, 6.5 and XI R2/XI R3
• Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly changing dimensions (SCDs) using ERWIN
• Experience in building Universes vs BW Cubes, retrieving data using Universes and Personal Data Files, Stored Procedures and Free Hand SQL methods and creating Ad - Hoc reports using Business Objects & Web Intelligence Tools
• Expertise in analyzing, architecting, designing and modeling data warehouses and star schema data marts for various business verticals like Financial, Insurance and Pharmaceuticals
• Experience working as a Reports Developer on a large scale strategic platform Implementation for a State Government Agency
• Good Knowledge in extraction, transformation and loading (ETL) process. Full Life cycle experience on enterprise-scale data warehousing/mining
• Performed gathering, analyzing and documenting business requirements, both functional requirements and technical data specifications for Business Objects Universe and Reports
• Experience in Oracle RDBMS and its tools SQL, PL/SQL, SQL Loader, SQL PLUS, ERWIN, Rational Rose and TOAD

TECHNICAL SKILLS

BI Tools: SAP Business Objects XI 4.0,XI 4.1, XIR3,XI R 2/6.5/6.1/5.1/4.3 (Supervisor, Designer, Business Objects), BCA, Auditor, InfoView, Live Office, QwaaS, Deski, Central Management Console, WEBI 2.x/6.x /Xir2/3.1 Webi Rich Client, Performance Management, Crystal Reports 2008/XI/Enterprise10, Xcelsius 2008, SAP BO Voyager, Lumira, Design Studio, Hyperion Interactive Reporting, SQL Server Reporting Services (SSRS)

ETL Tools: Informatica Power Center 8.6/ 8.2/ 7.1.1 , Data Stage, Data Integrator

SEM Framework: Curam 5.2

RDBMS: Oracle 11i/10g/9i/8i/7, Teradata 12/ 8.2/7.2,DB2, SQL Server 2000/2005

Operating Systems: Windows 9x/NT/XP/2000/2003

Languages: Java, C, COBOL, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

Associate

Responsibilities:

• Established cross-functional relationships and directed all requirements gathering, data analysis and documentation for enterprise projects to centralize data into one multi function data ware house system with advance reporting processes.
• Overall accountability for the planning, development and implementation of pertinent and performing reports and dashboards.
• Ensured the creation of solutions will address quality, performance, availability, scalability, and integrity.
• Promoted the overall effectiveness of the organization by performing tasks and sharing responsibilities of other members of the Department during peak periods or when there is an overload of duties.
• Extensively worked on near real time (Intraday) & End of Day PnL, MIS, Performance monitoring & Product control reporting for departments Finance, Equities, Fixed Income, Operations, Regulatory and Treasury.
• Level 1, 2 Production support on user requests on daily basis.
• Maintained Basel and RRI Universes and reports in SAP BO.

Skills Used: SAP Business Objects BI Platform 4.1/4.0/ XIR3.1, Info view, Information Design Tool (IDT), Universe Design Tool, Upgrade Management tool, Dashboard Designer 4.0, BI Launch pad, Webi Rich Client, CMC, Info view, Web Services, Web Intelligence, Oracle 11/10g, Teradata 13/12,TOAD, Teradata SQL Developer, JIRA 14, Unix.

Confidential

ERP Functional Specialist

Responsibilities:

• Interacted with Project manager in architecting reporting solutions by understanding the requirements and writing universe, report and Dashboard specifications.
• Created documentation and presentations on best SAP practices for developing universes and security specific to Gulfstream.
• Expert in using Business Intelligence tools like Business Objects XI4.0 to build complex universes and Reports, Charts on Multiple databases (Data Providers) and experience in development, testing and implementation.
• Worked on Proof of concepts to compare various scenarios of building single and multi-source universes on DSOs.
• Created Webi reports and Dashboard reports using SAP BO XI 4.1.
• Created Webi reports with appropriate filters and prompts for user inputs..
• Gave presentations to the business on advantages of BO 4.1 and need to upgrade by analyzing the current environment.
• Trained the in-house developers to work with all the SAP BI BOBJ toolset.
• Worked on CMC to create User-groups and worked on security rights.

Skills Used:, SAP BOBJ Enterprise BI 4.1, Business Explorer (BEx), Crystal Reports Enterprise, Information Design Tool, Webi, Dashboard Designer, Cognos V11,Lumira, Design Studio.

Confidential

Sr. Business Objects Lead

Responsibilities:

• Implement several projects in different capacities (BO technical architect, administrator, report developer and universe designer) for the Global Wealth Management Division of Confidential
• Collected user requirements and specifications for project development
• Coordinated with end-users and business analysts to understand the scope of business requirements, user expectations, and ensured the accuracy of reporting specifications
• Experience in Creating Universe using of Information Design Tool ( IDT)
• Involved in all phases of migration from XI 4.0 to XI 4.1
• Created Complex Reports by using multiple data providers to combine 3 reports as a single Report in WebI and Crystal Reports
• Experienced in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems
• Evaluated the possible use of aggregated tables and worked with DBA to create aggregated tables

Skills Used: SAP Business Objects BI Platform 4.1/4.0/ XIR3.1, Info view, Information Design Tool (IDT), Universe Design Tool, Upgrade Management tool, Dashboard Designer 4.0, BI Launch pad, Webi Rich Client, CMC, Info view, Web Services, Web Intelligence, Oracle 11/10g, Teradata 13/12,TOAD, Teradata SQL Assistant, HP Quality Center 10.0, Remedy, Windows

Confidential

Sr. Business Objects Reports Lead

Responsibilities:

• Implementing Business Objects Best Practices. And provided technical leadership for Business Intelligence (BI) roadmap and the direction of application projects from data capture through application design & implementation
• Build Universe (metadata layer) and a reporting framework to address scheduled reports and ad-hoc querying capabilities that meets the business requirements
• Involved in all phases of migration from XI R2 to XI R3
• Involved in support of all migration and performance issues and designed R3 upgrade plan and timelines
• Modified the existing universes to develop the new set of reports
• Involved in interacting with users, gathering and analyzing requirements, logical and physical design of the reporting system
• Designed new Universes and modified the existing Universes based on the business requirements
• Involved in creation of Developing Dimension and Fact jobs data warehouse
• Involved in performance tuning and Data Quality of Crystal and WEBI reports
• Created Crystal Reports using Crystal reports Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views
• Provided Creation of ad-hoc queries and reports based on UAM (User Access Management) mode

Skills Used: Business Objects XI 4.0,XI 3.1,XI R2 Crystal Reports 10 / 2008,, VBA Macros, Data Services, Live Office, Qaaws, Crystal Xcelsius 2008, SQL-Server 2005/2008, SDK, Macros Excel 2007, OLAP Cubes, Adobe Acrobat 8.1, Oracle 10g, Lotus Notes, SAP integration Kit, PICASSO-Oracle Application, Sql Server,DB2,AD Groups, OLTP Cubes.