SUMMARY:

• Certified SAP Business Intelligence Application Associate with Over 10 years of real - time experience in multiple Business Intelligence and Data Warehousing technologies.
• Experienced SAP BI / BO Architect with over six full production platform implementations and integrations with multiple complex environments.
• Managed onsite and offshore teams for Production Support activities as well as for development projects.
• Worked in top media, financial, utilities, consumer service and products industries with vast knowledge of business models and data flow
• Hands on experience with content development in SAP BI, IBM Cognos, Micro Strategy, MS BI.
• Highly experienced in Installation, Maintenance and Configuration on both UNIX and Windows Systems
• Administered Business Objects 6.5, XIR 2, XIR 3 - 3.1, BI 4.0 and BI 4.1 environments.
• Strong knowledge and hands on experience in installation, sizing, securities, setup and maintenance of production, quality assurance and development servers.
• Project Management skills with exceptional Planning, Organizing, Budgeting and Coordinating efforts.
• Proficiency in SQL language utilized for development of reports and universes.
• Strong knowledge of Data Modeling Concepts, snow flake schemas, multi star schemas, extended star schemas.
• Managed Projects and Production Support, 24/7 on L2, L3, L4 levels .
• Experienced in customer interactions for requirement gathering, working closely with clients and gathering business level information to be utilized to create universes, reports for ad-hoc and canned reporting usage.
• Experienced in training Power users, Business Users and developers for SAP Business Objects.
• Worked closely in creating test cases, performing UAT and testing reports and universes to ensure quality delivery.
• Assisted in creating ETL Jobs for Informatica, SAP BODS and Data Stage tools to capture ideal data for reporting and archiving purposes.
• Worked on multiple database systems including Oracle, Teradata, MS SQL Server, IBM Db2.
• Being a key project player, observed multiple full Life Cycle for projects, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
• Good analytical and documentation skills with ability to communicate at all levels.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003/2005/2008, Red Hat Linux, Unix (AIX), Solaris

Business Intelligence Tools: Business Objects 6.5, XIR 2, XIR 3.1, BI 4.0, 4.1, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, InfoView, Broadcast Agent, CMC, Performance Management, Report Conversion tool and Import Wizard. Crystal Reports XIR2/2008, Xcelsius 4.5 -- Xcelsius 2008. BW Query Designer, Bex Analyzer, Informatica 9.x, SAP BODS

Database Systems: SQL Server 2000/2005/2008, Oracle 9i/10g/11g, DB2 9.7/9.8, MS-Access

Languages: SQL, PL/SQL, T-SQL, C++

ETL Tools: IBM DataStage, Informatica, SAP BODS

Other Tools: HPSM, QC, Remedy, Lotus Notes, Ms-Office Package, Outlook, Visio, Toad, SQL Developer, Sql Assistant, Service Now

PROFESSIONAL EXPERIENCE:

Confidential, CA

Business Intelligence Architect

Responsibilities:

• Designed a brand new, SAP BI 4.1 landscape and performed implementation for the new BI setup.
• Managing a 40 people team, based in multiple global destinations.
• Monitoring a medium scale environment with over 1500 users .
• Lead Offshore and Onsite teams for coordinated development and Production Support activities.
• Heavily involved in content migration from XIR 3.1 to XIR 4.1.
• Recreated entire security architecture for xir 4.1, implementing Windows AD and Enterprise Authentications.
• Deployed and configured Business Objects on IBM WebSphere Application Server (web server).
• Redefined a new and more optimized reports and universes folder structure.
• Re-Created more efficient report publications, scheduling and report busting for all scheduled reports.
• Worked with LCM (life cycle manager) and Import wizard for migration of content between environments.
• Created a DR (Disaster Recovery) method for BI servers using Live DR .
• Involved in User Training and Developer training for SAP BI 4.0 and 4.1 .
• Redefined business processes for Projects and Production support activities
• Worked heavily for implementation of Service-NOW, Cloud based ticketing system replacing HPSM .
• Heavily involved in multiple RPF for new technologies, testing, demos and vendor evaluation .
• Worked with Database and ETL teams - Leading efforts from BI services for DB and ETL upgrades.
• Involved in Data-Analysis, Data-Digging for resolving / answering data level issues to the end-clients.
• Worked closely with BI Architects to in corporate server level changes.
• Involved in Testing SAP BI 4.0 Upgrade, Testing client end tools, including Launch Pad, IDT, Designer and Xcelsius 2011.
• Leading efforts for Development and day to day administration and production support activities.

Environment: Business Objects 4.0-4.1, XIR 3.1 with Infoview, Oracle 11g,, MS-SQL Server 2005 / 2008, MS-Office 2010, IBM WebSphere, Windows 7 .

Confidential, NY

Business Intelligence SME

Responsibilities:

• Maintain multiple ODS Data inputs from various sources and load into EDW, for outbound high visibility SOX compliant data.
• Manage Informatics ETL process flows and jobs.
• Working with Control M Scheduling, and maintaining scheduling and triggering events.
• Working with BI Platform team for pre-upgrade assessment and testing for SAP BI 4.0 Upgrade.
• Member of Business Intelligence Platform/Production Support team.
• Clustering SAP Business Objects environment with multiple servers in processing and application tier.
• Configuring multiple application servers with load balancer and IIS to enable Single Sign-on (SSO) and Windows AD.
• Resolve all issues related to Business Objects (including all server, network, database, SSO and client applications) functionality - coordinate troubleshooting activities with Business Objects Technical Support and required resources - all break/fix issues.
• Tech Lead for Onsite and Offshore teams, coordinating efforts for fifteen member team.
• Extensive data digging and data analysis, to ensure perfect data delivery required for reporting statistics to Wall Street.

Environment: Business Object XI R3.1/ 4.0, Oracle 11g, Teradata 12, Informatica PC 9.1,IBM DB2, Windows 7 / Server 2008 / Unix AIX, Solaris .

Confidential, NY

BI-Lead/ Architect

Responsibilities:

• Performing comprehensive data analysis for various business processes, across and sub processes which involves maintains/processing for multiple banking line of business.
• Extensively generate ad hoc reports and pull dataset for each RND, used PL/SQL, MS Access, VBA, MS Excel pivot table and functions. and performed comprehensive data analysis
• Reverse Engineering numerous reports to be converted and rebuilt from Web Intelligence to Java and HTML5.
• Generate historical reports for excessive RND and environment optimization.
• Made and performed presentations to the higher management for each analysis. Highlight risks, problems, areas of improvements, losses and rework. Suggest solutions, endorse resolutions and pursue implementations in addition also present what if analysis.
• Performed extensive research and prototyped multiple Business Objects Functionalities to clients for more efficient usage of BO .
• Extensively involved in client communication, exploring further options to optimize and use multiple tools and technologies to their maximum capabilities.

Environment: Business Object XI R3.1, Business Objects 4.0, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, Oracle, Red Hat Enterprise Linux.

Confidential, WI

BI-Lead / Architect

Responsibilities:

• Lead BI Development for internal Access Management Reporting.
• Successfully managed and co-ordinate onsite and Offshore teams.
• Defined reporting structure for SAP BO reports for Integration with Internal Certification System.
• Responsible for Call Center support reporting.
• Enhanced and refined daily job processing reports and created new reports.
• Worked on test cases for testing newly developed reports.
• Worked with different Database systems for Operational and Analytical reporting (Teradata 12, Oracle 11g, DB2, SQL Server 2008).
• Performed extensive data analysis and provided possible reporting solutions for DSS.
• Lead two projects for full deployment life cycle.
• Provided oversight for all Production activities.
• Converted Actuate based reports to Business Objects for internal business application reporting.
• Created various types of WEBI reports (Standard reports, Cross Tab, Mail tab, use of Filters, Conditions, Calculations).
• Defined and lead Development team for new projects.
• Created linked and unlinked Sub Reports to create applicants experience/Qualifications reports and reports to Troubleshoot performance issues.
• Worked with ETL Teams to enhance data flow process and data flow.
• Created reports for logging purposes of different business applications.

Environment: Business Object XI 4.0, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, SQL Server 2005, UDB, DB2, Actuate BIRT.

Confidential, Va

Technical Lead- BI Architect

Responsibilities:

• Redefined the entire process for Bank Defects and Enhancements for Business Intelligence.
• Successfully managed and co-ordinate onsite and Offshore teams.
• Developed a new and enhanced customer complain process for reporting defects and enhancements.
• Responsible for managing Business Objects XI 3.1 Development and QA servers.
• Deployed LCM on all Business Object environments.
• Worked on implementation of Quality Assurance procedures for Pre Production testing.
• Worked with different Database systems for Operational and Analytical reporting (Teradata 12, Oracle 11g, DB2, SQL Server 2008).
• Worked on data masking techniques for security of Non Public Information.
• Deployed new folder based security structure for the environment.
• Provided oversight for all Production activities.
• Created reports using formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in complex Crystal reports for different Business groups (Mortgage, Finance, Card, Loans).
• Migrated and maintained Business Objects reports during Data warehouse up gradation from Fork lifted data model to 3nF.
• Created various types of WEBI reports (Standard reports, Cross Tab, Mail tab, use of Filters, Conditions, Calculations)
• Defined and lead Development team for new projects.
• Created linked and unlinked Sub Reports to create applicants experience/Qualifications reports and reports to Troubleshoot performance issues.
• Worked on Proof of Concept for Mobile Based Web Intelligence and Xcelcius Reports using live data for higher management.
• Created report templates for the standardization of reports.
• Promoted repository objects (Universes, Reports, folders) from one environment to another.

Environment: Business Object XI R3.1,SAP BI 4.0, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, SQL Server 2005, Oracle 11g, DB2 .

Confidential, NJ

Business Objects Consultant

Responsibilities:

• Extensively worked with the client and the infrastructure to analyze available resources.
• Requested hardware resources for new Business Objects XI 3.1 Server build.
• Deployed Business Objects XI 3.1 server in three tier mode with vertical and horizontal scaling server clusters.
• Configured windows active directory with SSO.
• Customized Infoview and CMC portals according to the clients needs (customized messages boxes, color layout, hyperlinks, logos, push buttons)
• Migrated Business Objects 6.5 repository to Business Objects XI 3.1.
• Deployed new folder based security structure for the environment.
• Designed and developed Complex reports using Crystal Reports XIR2/2008.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection, and Crystal syntax in Crystal reports.
• Designed, built and maintained complex Crystal Reports for different business groups.
• Migrated legacy reporting system to Business Objects by developing new universes and reports for it.
• Created different types of reports, such as: Standard reports, Cross Tab, Mail tab, use of Filters, Conditions, Calculations, etc.
• Created Drill down Reports, On Demand Sub Reports, Sub Reports for the Business needs.
• Created linked and unlinked Sub Reports to create applicants experience/Qualifications reports. Troubleshoot Reports performance issues.
• Developed WEBI reports for the mass generation of customer's utility billing.
• Wrote Crystal Syntax Formulas to calculate the Percentages and Summaries based on the group levels. Developed ad-hoc reports for end users.
• Formatted reports accordingly the specs given.
• Created report templates for the standardization of reports.
• Deployed service patches for Business Objects server and client tools (Sp1, Sp2, 2.6 fix pack).
• Promoted repository objects (Universes, Reports, folders) from one environment to another.

Environment: Business Object XI R3.1, INFOVIEW, Web Intelligence, MS-Excel, MS- Word, SQL Server 2005.

Confidential, NJ

Business Object Developer/Admin

Responsibilities:

• Involved in migration reports from 6. 5 to BOXI R2
• Created new security structure for Business Objects and implemented folder based security.
• Migrated Universe data restrictions from supervisor to Universe Designer.
• Created backup procedures for the environment through SAN replications and Weekly BIAR file backups.
• Responsible for moving content from one environment to another for full life cycle of new development.
• Clustered Business Objects server with DR Business Objects server to leverage failover.
• Used publications with report bursting to leverage daily mass report generation requirement.
• Designed report templates for the report company standards.
• Developed reports for given business requirement and received user sign-off.
• Design and developed reports using Crystal Reports 10.
• Created different types of reports, such as; Master/Detail, Cross Tab and Chart
• Scheduled Crystal Reports and Implemented dynamic cascading prompts
• Created Dashboards Score Cards and UI's using Xcelsius.
• Used various data sources for live data feed for Xcelsius such as Qaaws, Live Office, XML, Flash Variable, Excel XML maps.
• Created jump off reports functionality for WEBI from Xcelsius using opendoc function to leverage detailed to granular level drill down.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports. Created various formulas for the calculations for pricing in the reports.
• Created Static and Dynamic Parameter fields for the filtering of the data.
• Wrote procedures for the complex reports and list of values for the parameters
• Used Crystal Report XI Enterprise to design the front end reports
• Created Business Objects Web Intelligence reports and published in the INFOVIEW.
• Used Drill down Group Levels, Conditional formatting, Alerter, Alternate row shading futures and created Label reports for Providers and Subscribers.
• Published report to Enterprise server, to get the report access from INFOVIEW.

Environment: Business Object XI R2, Crystal Reports XI/10, INFOVIEW, Web Intelligence, Oracle 10g.

Confidential, NY

Business Object Developer/Administrator

Responsibilities:

• Deployed BOE XI Enterprise Server.
• Migrated BO 6.5 to BO XIR2.
• Created Users/Groups/Sub-Groups & assigned profiles there by restricting un-authenticated access to resources.
• Implemented Row & Object level security for different user group requirements.
• Gathered Business requirements from users, interpreted Business rules and translated these rules into developing the reports.
• Provided inputs for report development and enhancement in team meetings; aided in developing and executing plans for the reporting team to achieve targets mutually agreed among user and Development team.
• Involved in Installing and configuring Business Objects XIR2.
• Created templates for standardizing reports using company logo, header and footer settings, color coding, fonts and maintained consistency in viewing cross-tabs, blocks in report.
• Created user defined objects to manipulate the data by using database specific functions to fulfil the reporting requirements.
• Created WEBI reports using data from multiple data providers using merged dimensions functionality.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Suggested modifications in Universe in existing objects or by creating new objects.
• Used Free-Hand SQL to leverage report requirement to bypass a change in a universe.
• Created Joins complex multicolumn joins with conditions, Context and Aliases for Resolving Loops and Checked the Integrity of the Universes.
• Involved in Resolving Problems like 'Chasm Trap' and 'Fan Trap'.
• Checked the integrity of the universe schema for any errors in objects, joins, conditions, loops and cardinalities of the universe.
• Linked summary reports and passed prompt values to open document to obtain more detail information.
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Attended to user requests in enhancing reports and fixing bugs, providing solutions for existing bugs and redefining newer concepts for better features.
• Implemented reports in Production from Integration after user approval in test area.
• Developed migration checklist to validate reports which are migrated from Integration to Production.
• Used @Functions such as @Prompt- to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Helped document all software, hardware and infrastructure process.
• Conducted an analysis on the matching criteria for regional mapping of data from other systems based applications. Optimization of Queries used in Business Object and Web Intelligence.

Environment: Business Objects XI R2, BO Performance Manager, Crystal Report 10, Webi, Oracle, Stored Procedures, Windows XP

Confidential, TX

Crystal Report/Business Object Developer

Responsibilities:

• Created Complex reports with SQL views in Crystal Report.
• Connected universes through network which data comes from Mainframe system.
• Converted existing reports in Actuate to Crystal Reports
• Understood SQL views and accordingly generated reports.
• Wrote SQL queries in PL/SQL Developer to extract the data from database
• Extensively used Toad to understand the data.
• Defined Business Objects and database structure based on the functional specifications and user requirements, and utilized Business Objects Designer to create and maintain the universes, linking Universes. Setting up aggregate awareness in a universe.
• Connected Oracle data base to generate the reports.
• Created prompts, calculations, conditions, measure objects on reporter
• Used special fields like Dates and Query prompts, Page numbers in the reports.
• Worked as a BA to documented users requirement into functional specification.
• Provided support and maintenance to users, universe and Reports.
• Ensured that deadlines are met and manage the activities and deliverables.
• Developed, tested and deployed Business Objects report and Universes.
• Involved in performance tuning of universes by creating alternate views and indexes.
• Administrated Business Objects servers, users, access, reports and universes.
• Performed presentation to managers and decision makers about different ways and options available for them to Improve their Business (Dashboards, Drill Down Reports, Jump off reports)
• Worked with database administrators to define database requirements and load procedures to successful Business Objects reporting.
• Responsible for 24/7 production support of Business Objects.
• Created a UI using Xcelsius to call jump off reports using opendoc and sent prompt parameters to the reports.
• Involved in the migration of the existing legacy reporting system to Business Objects by building new Universe and reports for it.
• Involved in the data warehousing project and provided them with requirements for the reporting database for Business Objects Universe.

Environment: Business Objects XI R2, Crystal Reports XI, 6.5.1, Web Intelligence, INFOVIEW, MS-Excel, Oracle 9i, and DB2.

Confidential, IL

Report Developer

Responsibilities:

• Defined Business Objects and database structure based on the functional specifications and user requirements, and utilized BO Designer to create and maintain the universes, linking Universes. Setting up aggregate awareness in a universe.
• Created Reuters performance reports and send them across the globe.
• Created universes based on Oracle 9i and SQL Server2000 Databases
• Analyzed Erwin Data Model to identify the relationship.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts.
• Exposed to Supervisor Module how to or Managing user groups and users.
• Created DESKI reports with multi data provider with linked dimensions to use them in the same report block.
• Created complex reports with multiple folded breaks and on variables concatenating multiple dimension objects to fulfill formatting requirement of a report.
• Created reports with hidden columns and macro's.
• Created reports on store procedures and local data providers
• Web Intelligence with Info view, Scheduling with BCA.
• Wrote VBA macro's for daily, weekly, monthly, quarterly scheduling rep

Environment: Business Objects 5i/6i, INFOVIEW, Crystal Reports, MS-Excel, MS-Access, Oracle 9i, Performance Testing, Windows XP.