SUMMARY:

• 9 Years of data warehousing experience as a Business Intelligence Consultant primarily using SAP Business Objects, Information Design Tool, Universe Designer, Web Intelligence with expert level skills in Data Visualization, Data Analysis, Business Intelligence, ETL, Client/Server Systems, full life cycle implementations.
• Experience in full software development life cycle implementations as a BI Consultant using SAP BO Business Intelligence 4.1/4.0, Business Objects XIR3/XIR2/XIR1, Crystal Reports and Xcelsius.
• Expertise in connecting to Oracle 11g/10g, Teradata, SQLServer 2012/2010/2008/2005, IBM DB2, and MySQL as data sources using SAP Business Objects.
• Excellent experience in Information Design Tool, Universe Design Tool, Web Intelligence, BI Launchpad, Import Wizard, Info View, Universe Designer, Central Management Console, QAAWS, Live Office.
• Strong Experience in creating Universes from scratch for Adhoc reporting and canned reporting.
• Experience in creating folder structures, setting up users/user groups in Central Management Console.
• Experience in installation and configuring Business Objects, creation of repositories and security domain with user groups and security implementation.
• Implemented Row Level Security, Folder Level security, Index Awareness, Hierarchies in Universes.
• Expertise integrating Web Intelligence reports in web portals using opendoc for highly interactive reports.
• Migrated reporting applications from Business Objects to Cognos and from Business Objects R3 to Version 4.1.
• Mentored teams of onsite and offshore resources in best coding practices, technologies at various clients.
• Performance tuned Universes & Web Intelligence reports to reduce the run time of reporting applications.
• Strong ability to partner and work collaboratively with BA(s), Architects and ETL developers.
• Efficient in all phases of the software development lifecycle (SDLC), coherent with Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing (UAT).
• Experience in analyzing Star Schema/Snowflake Schema, Dimensional Data Modeling, Logical and Physical Data Modeling using Toad Data Modeler, SQL Developer.
• Strong knowledge and hands - on experience in Data Vault.
• Experience in performance tuning SQL queries and ETL process.
• Excellent Knowledge in Ralph Kimball & Bill Inmon Methodologies for designing data warehouse.
• Knowledge in implementation of OLTP, OLAP systems and Data Marts.
• Diversified experience using Business Objects reporting in Financial, Healthcare and Pharmaceuticals sectors.
• Knowledge on Extraction, Transformation and Loading (ETL) using IBM InfoSphere Information Server 9.1/8.5/8.1, IBM InfoSphere Change Data Capture 10.2/6.5.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, Teradata, SQLServer 2012/2010/2008/2005, IBM DB2, MySQL

Reporting Tools: SAP BusinessObjects Business Intelligence 4.1/4.0, Business Objects XIR3/XIR2/XIR1, Information Design tool, Universe Design Tool, Web Intelligence, BI Launchpad, Crystal Reports, Xcelsius, Central Management Console, Tableau Desktop, Tableau Server, Cognos Report Studio

ETL Tools: IBM Information Server Suite 9.1/8.5/8.0, IBM InfoSphere Change Data Capture 10.2/6.5

Programming Languages: PL/SQL, T-SQL, Shell Scripting, C/C++

Operating Systems: Windows 7/XP, Linux, Unix, AIX 5.2/4.3, Mac

Data Modeling: Star Schema, Snow-Flake Schema, Dimensions & Fact Tables, Physical and Logical Data Modeling, SAP Power Designer, Erwin

Scheduling Tools: Tivoli, Autosys, ASG-Zena

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Senior Business Objects Developer

Responsibilities:

• Integrated crystal reports and Webi reports in online portal of Confidential .
• Worked on Account Management, Integrated Payments and Payment reports
• Developed several complex solutions and reports using Web Intelligence, Crystal Reports, Explorer, Dashboards, and Universes.
• Worked on Database Expert, Section Expert, and Select Expert to develop the reports and used the Sub reports and used various customized formulae to create critical reports using Crystal Reports.
• Prepared Functional Design Specification documents for the newly built crystal reports.
• Worked on the enhancements in the crystal reports as per user needs and business requirements.
• Designed Universes using Information Design Tool to support adhoc reporting.
• Worked on resolving Fan Traps and Chasm Traps in the Universe.
• Worked on Webi reports with multiple data providers.

Environment: BI Launch pad 4.1, Information Design Tool, Business Objects 4.1, Web Intelligence Rich Client, Crystal Reports 2013, Tableau Desktop, IBM Information Server 9.1/8.5, IBM Change Data Capture 10.2/6.5, Unix- AIX, Oracle 11g, DB2, SQL Server 2012/2008, IBM DataStudio, Toad for Oracle, SQL Developer, Tivoli

Confidential, Northbrook, IL

Senior Business Objects Lead

Responsibilities:

• Collected Requirements from the business for Special Projects and managing them thru development, delivery and support.
• Worked on creating Universes for Sales, Quotes & financials functional areas for Agent Side reporting.
• Worked on Onsite-Offshore Model. Lead of a team, which comprises of 3 onsite and 5 offshore resources.
• Worked on designing Proof of Concepts for business before the actual implementation of a requirement.
• Developed several complex solutions and reports using Web Intelligence, Crystal Reports, Explorer, Dashboards, and Universes.
• Worked on creating technical design documents.
• Designed User Security for DASH Reporting Application.
• Designed Data Security & Business security profiles for restricting access.
• Performance tuned Business Objects universe for faster report turnaround time.
• Ensure discussions and decisions lead toward closure.
• Conducted code reviews and made sure quality solutions are built and best Practices/standards have been followed.
• Created index awareness to improve the performance of the Universe.
• Researched and evaluated alternative solutions and made recommendations.
• Participated in design reviews and provided alternatives.

Environment: BI Launch pad 4.1, Information Design Tool, Business Objects 4.1, Web Intelligence Rich Client, Crystal Reports 2011, Oracle 11g

Confidential, Phoenix, AZ

Senior Business Objects Developer

Responsibilities:

• Worked on enhancing and maintaining One Schwab Information Universe based on work requests created by the business community at Schwab.
• Used linked Universes to give users a rich experience by creating a single universe for all the information needs.
• Created objects using different Business Objects functionalities like @ prompt, @select, @where, @Aggregate Aware.
• Resolved issues in the design of the Universe and worked on debugging and fixing any Web intelligence report issues.
• Created Cascading List of Values and custom List of Values as per the user requirements.
• Used Aliases and Contexts to resolve loops in the Universe design.
• Used Derived tables to create custom SQL views according to the user requirements.
• Executed unit and integrated system testing on design changes to ensure accuracy by creating test cases and carrying out peer review.
• Effectively communicated with team members to exchange information and ideas.
• Assisted in Maintaining Business Intelligence Best practices document at Confidential .

Environment: BI Launch pad 4.0, Information Design Tool, Business Objects 4.0/XI 3.4/3.1, Explorer, Designer XI, Web Intelligence XI, Desktop Intelligence, Crystal Reports, Teradata 13.11/13.10, Oracle 11g / 10g, Power Designer

Confidential, Auburn Hills, MI

Senior Business Objects Developer/ Analyst

Responsibilities:

• Maintained and enhanced all Business Objects Universes and optimized them for reporting efficiency.
• Assisted in the design of dimensional schemas to optimally capture data to support user analysis and reporting needs.
• Analyzed user needs and created cardinalities, contexts, joins and aliases in the Universe accordingly.
• Worked with business users and Data Architects to define all the dimensions and measures required for reporting.
• Maintained the reporting environment, including scheduling, distribution, user permissions, and updating reports.
• Interacted with all departments to define metrics and deliver canned reports to speed their decision-making.
• Worked extensively with the major functionalities of BO like Breaks, Sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Actively engaged with end users through training and support of Business Objects.
• Prepared system documentation and metadata, as needed in compliance with project development lifecycle and internal data management standards.

Environment: Business Objects XI 3.4/3.1, Designer XI, Web Intelligence XI, Desktop Intelligence, Crystal Reports XI, SQL Server 2008/2005, DB2, Power Designer, Qlikview 11.0, Cognos