SUMMARY:

• Around 16 years of overall IT experience in Analysis, design, development, Architecture, Administration and management of software applications and Business Intelligence projects in different capacities.
• Experience in Architecture, Administration of data warehouse reporting systems, Installation and Deployment of Business Objects (BO) suite of products.
• Team lead experience and full life cycle implementations.
• Experience in Client/Server Technologies, RDBMS (Oracle, SQL Server, My SQL, Teradata, DB2).
• 15 years of experience providing solutions in Advanced Reporting and analytics using SAP Business Objects/BW/BI/Crystal Reports/Webi (Web intelligence), BO Universes, Xcelsius, Supervisor, CMC, personal data files, stored procedures and free hand SQL methods, data cubes and OLAP services.
• Hands on experience in SAP and Non SAP Data Warehouse projects using Business Objects and other reporting tools as Front End BI applications along with SAP BW, SAP ECC, CRM.
• Experienced in analytical tools such as Design Studio, Lumira, and Office for analytics, Explorer, Webintelligence, and Dashboard Design, Cognos, Tableau and Qlikview
• At least 2 years of SAP experience implementing SAP HANA Analytics plus S/4HANA
• Experience in writing SQL scripts and stored procedures, function calls, designing tables, data loads, and building, modifying, and integrating into HANA views
• Experience in Erwin/Toad Data Modeling. Several years of Experience in ETL (Informatica, Data Integrator/SAP BO Data Services). Programming experience in Unix Shell scripting, embedded PL/SQL procedures, Visual Basic, Business Objects SDK, VB Script, Java Script, JSP, ASP, Cold Fusion, SQL Server Reporting Services 2005, optimization of SQL queries. Working Experience on IIS, Web logic, Apache, Tomcat servers.
• Strong communication and client management skills.

TECHNICAL SKILLS:

Operating Systems: IBM PC (DOS & Windows), UNIX, Linux, AIX and IBM Mainframe ES9000 Series

Microsoft Windows: 95, 98, NT, 7, 2000/2003/2008 Professional, XP, Word, Access, Excel, Power Point, Visio, MS Project

Data Warehousing/BI/Analytics: SAP BW, S4/HANA, Data Mart / Multi - Dimensional Data Warehouse (Star and Snowflake Schema)Business Objects Reporting (4x, 5x, 6x, XI R2/R3/BOBJ 3.1 4.0, 4.1 Deski), Business Objects Universe Designer, Information Design Tool, Broadcast Agent Console (BCA), Business Objects CMC (XI, 4.x), Business Objects Supervisor (5/6x), WEBI (Web Intelligence), Crystal Reports 2008, 2013, Xcelsius 2008, Voyager, Microstrategy, Cognos, Informatica (Designer, Workflow Manager, Workflow Monitor, Repository Manager), Data Services, Erwin, Toad data modeler.

Databases: SAP BW, Oracle, DB2, Sybase, Teradata, MS SQL Server, My SQL, ODBC, Greenplum

Languages: Visual Basic, VBA Scripting of Business objects with the Business Objects SDKCOBOL, C, UNIX, SQL, PL/SQL

Development Tools: SQL Server Enterprise Manager, TOAD for Oracle, SQL Navigator

Version Software: MKS Source Integrity, PVCS Version Control, Clear case

Industries: Government, Federal, Army, NAVY, IT Consulting, Health Care, Pharmaceuticals, Tele Communications, Retail, Manufacturing, Marketing, Financial, Hospitality, Public Utilities, State Welfare, Food and Beverage.

Leadership: Training, Mentoring, Team leadership skills

PROFESSIONAL EXPERIENCE:

Confidential

SAP Business Objects Specialist/SME

Environment: SAP Business Objects 4.1/4.2, IDT, Webi, SAP Lumira, Design Studio, Crystal Reports, Dashboard Design, CMC, 360View, Infosol Infoburst Enterprise, Tableau, Remedy, S4 HANA, Teradata, Oracle, Informatica, Unix, Linux, Windows 2013, Remedy Issue Tracking.

• Perform all user account management activities for the Business Objects application to include adding, modifying and deleting users, and assigning rights and privileges to users and objects through effective use of the Business Objects security policies in accordance with approved Confidential policies.
• Used Information Design Tool IDT to create connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to Repository and accessed HANA data with BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence.
• Act as the subject matter expert in the use and functions of the Business Objects Central Management Console (CMC), Central Configuration Manager (CCM), Life Cycle Manager (LCM) and other software tools for maintaining and supporting the enterprise application modules.
• Proactively monitor the Business Objects applications and web servers for meeting and ensuring customer expectations.
• Proactively monitor and manage system and BO application audit logs. Report unusual activities and/or issues to Confidential management in a timely manner.
• Provide support and assistance to the Desktop Group for the installation and configuration of Business Objects full client software, Java components and Oracle and/or Teradata drivers as necessary.
• Automate BO administration processes when possible to improve efficiency through scripting and scheduled tasks.
• Act as first and second tier production support addressing high-priority issues and/or problems opened for Business Objects applications. Work with SAP support personnel to resolve problems and issues. Research, manage, and coordinate resolution of complex issues through completion.
• Provide effective communications with internal customers from business organizations and Confidential management for resolution of day to day issues in BO applications.
• Coordinate maintenance and scheduled BO downtime with affected users. Provide remote/onsite application support for infrastructure tests and issues. Notify users using effective communication.
• Monitor SAP support web site for application hot fixes, patches and new releases. Download required patches, updates and license keys as needed
• Proactively monitor BO system hardware and coordinate replacement of defective components.
• Ensure all relevant BO application data and configuration settings are backed up regularly.
• Maintain awareness and comply with all DoD and Confidential security policies and procedures. Monitor last login user activity to ensure compliance with Information Assurance requirements.
• Apply software patches and upgrades or provide mitigation plans as required to mitigate security vulnerabilities identified by DoD and Confidential Information Assurance.
• Provide assistance and support for cross-departmental team members (Security, Network Services, Enterprise Data Warehouse, BI Development, IT Operations, Server Group, Project leads, Help Desk) related to the Business Objects environment.
• Maintain key processes and documentation including user log and access lists required to obtain necessary DIACAP certification & accreditation as well as comply with any agency audits.
• Other IT related tasks as directed by Confidential management.
• Effectively used 3rd party tools such as Infoburst and 360 Suite to support and add additional functionality to SAP Business Objects Suite.

Confidential

Managing Consultant

• As a Managing Consultant, I was responsible for offering a comprehensive portfolio of BI services include these areas of focus:
• Business insight — combine analysis and tools from our Centre for Business Optimization along with IBM Research to deliver solutions to some of today’s most-complex problems.
• BI strategy and road-map development — define your client’s enterprise-wide vision and road map using a common BI framework, accelerators, templates and methods.
• BI governance design and implementation — implement specific approaches and facilitation techniques to ensure efficiency, effectiveness and control across the client organization.
• Business performance management solutions — use proven methods, training and a catalog of key performance metrics that span industries and functional areas to drive performance.
• Integrated analytical solutions — apply experience-based solutions to specific business problems including customer.

Confidential, Mechanicsburg, PA

SAP Business Objects/BI Application Architect

Environment: SAP BW 7.3, Bex Query Designer, SAP Business Objects 4.1, IDT, Webi, Lumira, Design Studio, Crystal Reports, CMC, HANA, Tableau, Qlikview, Cognos, HPQC, ECC, Net weaver, Oracle.

• Was involved in designing and building of SAP BW/Business Objects suite reporting functionality. This was achieved by conducting meetings with users, gathering functional/business requirements, data analysis at different hierarchy levels, documenting the requirements and providing the solution.
• Did work on maintenance of reporting environment, including batch job monitoring, applying patches, clean up traces, system log maintenance, reboots, upgrades, etc. as well as documentation of BW configuration, design and implementation of reporting elements.
• BW and Business Objects user security was implemented at different levels such as folders, application and group levels. Also single sign on was implemented via NetWeaver portal for end user access.
• SAP authentication was implemented for accessing BO applications.
• Information design tool was used to create connections to data sources for reporting.
• BW Modeling, ABAP routines and Bex queries were implemented to get the BW data into Web Intelligence reports and Dashboards for analysis of supply chain metrics such as Carcass Returns, Survival rate movements at summary and detail levels.

Confidential, Fairfax, VA

SAP Business Objects/BI Sustainment Support

Environment: SAP BW 7.3, Bex Query Designer, ECC, SAP Business Objects 4.0, IDT, Web Intelligence, Crystal Reports, Dashboard Design, Windows, MS SQL Server, Oracle, MS Office 2007.

• Enhancements to reporting functionality
• New reporting design and development using SAP Data Services, Business Objects, IDT, Web Intelligence, Crystal Reports, and Dashboard design...
• Heavily worked on BOBJ system performance
• Worked on SAP BW mappings, data loading, monitoring, execute process chains, checking for data, uploading and downloading extract files on day to day basis.
• Validation of data all across the BI components

Confidential, Huntsville, AL

SAP Business Objects SME

Environment: SAP BW 7.3, ECC, SAP Business Objects 3.1 and 4.0, Web Intelligence, Crystal Reports, Xcelsius Dashboards, JAMA, Windows, MS SQL Server, Oracle, MS Office 2007.

• Coordinating with AMC Customer and Confidential Project Manager to ensure synchronization of requirements and development efforts utilizing agile methodology.
• Serve as the requirement liaison between government and contract team members in the development of
• Created (BW BEx) Queries against the LMP Data Marts.
• Participated in discussions with the AESIP Team to determine documents required to support the migration of code through the Development, Test and Production Environments.
• Responsible for developing requirements, data mapping, and facilitate meetings to discuss functional and technical topics with the government customers.
• Helped develop project schedules and develop briefings, meetings notes, and other documentation (technical specification).

Confidential, Atlanta, GA

SAP BOBJ Admin/Architect

Environment: SAP BW 7, ECC, CRM 4.0, SAP Business Objects XI 3.1, 4.0, Web Intelligence, Crystal Reports, BO Client products, Xcelsius Dashboards, SharePoint, HP QC, Solaris, Windows, MS SQL Server, Oracle, MS Office 2010.

• Review Federal government 'stig' checklists to make sure security requirements are met in configuration of servers; responsible for mitigating any discrepancies. Setting up of security at various levels like User, Group, Folder, Universe level and across functional groups.
• Installed and maintained BOBJ repository CMC and Audit databases and their monitoring and analysis Implemented and Configured SAP BW as source system for BOBJ reporting that had BEX queries, info cubes etc. Integrating SAP BO 4.0 with SAP BW 7.3 with respect to SSO Setup.
• Setup Business Objects 4.0 client tools. BO 4.0 application development support. Migrating objects using LCM and establishing connection with BW.
• Install, upgrade BO patches, service packs, feature packs and performance tuning and Setting up of Auditing in BO 4.0
• Validate the results of the queries and the reports to validate the data integrity and accuracy between the applications such as SAP BW and SAP BO reporting solution. I was heavily involved in Universe design, report creation using Webi, Crystal and Xcelsius for different business groups using BICS connectivity, scheduling of the reports, testing and validation of the reports. I did document the reporting requirements, tech specs and testing results.

Confidential, Durham, NC

SAP BI/BOBJ Senior Consultant

Environment: SAP BW 7, ECC, CRM 4.0, SAP Business Objects 4.0, Web Intelligence, Crystal Reports, BO Client products, BO Xcelsius (Dashboard Design), EzBI, SharePoint, HP QC, MS SQL Server, Oracle, MS Office 2010, Linux and Windows servers.

• Work closely with business users and management to gather the requirements and translating them to business scenarios and Requirement documents for further design develop and implementation of the BI project. To provide the solution that best fits their needs. I did work closely with development team to implement the solution.
• Used EzBI for SAP, which allows customers to quickly implement a business intelligence solution against their SAP ERP data by utilizing Xcelsius dashboards (Dashboard design) and Webi reports built on the SAP Business Objects BI 4.0 platform. Several Dashboards were designed and used to drill to down to Webi reports for further level of granularity using Opendocument functionality.
• Worked on BW platform to create extract structures, Data loads, Delta loads via Info packages, Process chains, Jobs scheduling, Monitoring and Data validation. Created BI data model with InfoObjects (characteristics, key figures) and an InfoCube for storing data in the BI system. Map the source structure of the data in the BI system and define the transformation of the data from the source structure to the target format.
• Defined query that is used as the basis for a Web application and allows for an ad-hoc analysis of the data in the Web.
• Gathered requirements for different modules like Financial spend analysis, Sales orders and Distribution and Material Management systems. Establish connections to the BW sources, Activate the standard Business Content, Enable the standard InfoCubes and Queries, Enhance the InfoCubes as required by the BW Data Architect, Enhance the Queries as required by the BW Data Access Consultant, Define authorization profiles and access, Evaluate statistical performance and make recommendations to Basis team, generating Cubes and queries for BOBJ reporting.
• Documenting reporting requirements, Identifying Key metrics and indicators for dash boarding and Data Analysis, ETL, BOBJ Installations, Designing of Universe, Report Development, Row level security, Object level security, CMC Administration, Promotion management, Jobs scheduling, Report bursting via Publishing, UAT Validations to Go-Live.

Confidential, Atlanta, GA

SAP BO Administrator

Environment: Business Objects XI 3.1, Designer, Crystal reports, Web intelligence, Desktop Intelligence, Business Query, Live Office, Xcelsius, Oracle 10g, Java, ODBC, Informatica, Visio, Excel, VBA, Linux, Unix, Windows, Outlook, Clear case, SharePoint.

• Provided with SAP BOBJ administration, monitoring, and troubleshooting of all the components of CE and BOE 3.1 Administration tasks performed in different environments i.e. DEV, QA, UA and Production on a regular basis include:
• Troubleshoot issues, monitoring and auditing different metrics. Creating User Security, Groups, users and folders and setting up their security. Assign access rights and privileges to enterprise resources.
• Installation of products, configuring web, app servers, installing fix packs, patches, Universe enhancements and maintenance. Creation of database connections and migration of objects. Reports creation, enhancements and maintenance.
• Authentication using windows AD, LDAP and Enterprise. Clear case version controlling. Metadata extraction using SDK.
• Provided Confidential with a complete reporting environment including reports, dashboards, excel tools, etc...
• Participated in the gathering of requirements from users in the design through implementation phases of data integration through the development life cycle. The role included working closely with the data architects, application users and DBA’s from analysis through implementation. I assisted in set-up of global standards and controls for the BIS team.

Confidential, Alpharetta, GA

Senior SAP Business Objects Consultant

Environment: Business Objects Enterprise XI3.1, SAP BI/BW, ECC 6.0, SAP CRM, HP Neoview, Oracle 10g, Informatica, Designer, Web Intelligence, Crystal Reports 2008, Xcelsius, Live Office, Web Sphere, AIX, Windows XP/2003, Outlook, MS office

• As a part Business Intelligence team I did work on couple of projects i.e. BESX (Blackberry Enterprise Server Express) and BBM (Blackberry Messenger) in full scope which are completed successfully. Supported and validated reports of projects (MARS), which used Universe on top of BEx queries, Xcelsius dashboards, Webi and Crystal reports. I did work on SAP BI/BW integration. BESX project had set of reports that were created in Webi and crystal reports which display the data about Net new BB users, active users, migrated users from other services, traffic activity and provisioning activity.
• I did work on BBM project that mainly reports on the metrics such as New BBM users, active BBM users, Total relay users, penetration percentage, BBM traffic and message sizes. The reports are created in Webi using Universe as a semantic layer. For this I had to heavily interact with business users, business analyst to gather the requirements and understand the process logic and implement that functionality in universe for reports and users ability to create their own ad-hoc reports.
• Worked on Universe, which had multiple fact tables. Resolved loops by aliases and contexts. I trained end users on how to use BO tools. Did data analysis, ran queries against the source data system to validate the reports. Also worked closely with Data architects to optimize the Universe thus improve the performance of the reports. I worked on CMC to help administrator with daily tasks.

Confidential, Jackson, MS

Senior SAP Business Objects Consultant

Environment: Business Objects Enterprise XI3.1, Oracle 10g, Data integrator, Designer, Web Intelligence, Crystal Reports 2008, Xcelsius, Live Office, Windows XP/2003, Outlook, MS office, TOAD.

• The project’s purpose is to support the management team to make appropriate decisions based on the information provided by the Business Intelligence team in the areas of Sales, Promotions, Rebates, Inventory and so on. The reporting system mainly constituted by the product suite of market leader SAP Business Objects.
• Played a lead role and worked with Business Analysts to get the requirements for creating a project plan and estimation times for data integration, Universe design, complex reports in Webi and Crystal, QAAWS, Xcelsius dashboards design.
• Also I was part of migration and conversion of the reports. Did audit and data validation of the reports.

Confidential, Duluth, GA

Senior SAP Business Objects Consultant

Environment: Business Objects XIR2/R3/3.0/3.1, MS SQL Server 2005, MS SQL Server 2005, Teradata, Oracle, Teamsite, Bug tracker, Outlook, MS office, ASP.NET, Accordion Panel, Dream weaver, Visual Studio 2005

• Make sure the reports are providing the ability for Buyers and Planners to review the assortment plans at summarized hierarchy and detail levels. Users will have the ability to select the attributes and time frame.
• Work with several Groups such as: Business Process Group, Thought Leaders, Divisional Representatives, Operating Division Management, Buyer and Planners resulted in arriving at requirements (BFRs and SFRs) needed for decision support system.
• Play a significant role in architecture of the BO reporting, understanding scope and requirements analysis of Business Objects Application. Help in providing the estimation and project planning of reporting development efforts.
• Install the BO R2/R3 software and deployed the objects. Worked on the universe design, report creation in web intelligence and assisted team members with technical issues in coding. I was a part of the server side ASP/ dot Net programming in creating the User Interface for the Business Objects reporting environment to provide the dynamic nature to the Business Objects pages.
• Work on QAAWS and distributed the reports over intranet and Internet. Provided techno-functional solutions with Data Analysis, Universe and report design areas.
• Work on Webi/Crystal Reports, Crystal Xcelsius dashboards and performance management analytics.
• Document design documents and reporting Best Practices.

Confidential, Atlanta, GA

Business Objects Architect

Environment: Erwin, Toad Data Modeler, Oracle 9i/10g, Business Objects XI, Java SDK, Visual Basic 6.0 SDK for Business Objects, Informatica, UNIX

• Designing conceptual and logical Data models for the reporting database. Technically assisting universe designers and report developers at different stages of SDLC. Hardware recommendation for supporting new BO reporting requirements
• Installed and deployed suite of Business Objects products. Trained users on BO.
• Designing the architectural and development methodologies for business objects implementations
• Capacity planning and sizing of the environment. Migration and Conversion work from classic BO to XIR2

Confidential, Atlanta, GA

BO Architect

Environment: Business Objects 6.5, XI R2, Crystal Reports, Tomcat, Apache, Oracle 9.2, SQL, PL/SQL, Windows 2003, UNIX, Toad, MS project, MS Office.

• Did analysis and feasibility of the project and prepared a project plan. Gave Architectural suggestions in implementing the Business Objects environment setup. Recommended the hardware and software components for the implementation and provided security model. Installed and deployed both the Development and Production environments.
• Installation included setting up of database connectivity, Apache/Tomcat servers, Configuration of BO Server products, client products, repository creation, Importing of Users and Groups. Measures were taken care of load balancing and fail over of the BO servers.
• Supported around 300 users, 400 reports (full client/Deski and Webi). Worked on migration of the reports and other BO objects to new XIR2 using import wizard
• Did train users, knowledge transfer and documentation of the tasks completed. Worked on performance management dashboards and analytics. Reports were created and maintained to give analytical insight to key metrics: company's performance, through its financials and charts to evaluate the company growth trends. Major industry players. This information is important for estimating business strategies. Company, sales and product ratio, revenue and income trend, stock performances for the most recently ended quarter, financial year across businesses, and product/service categories. Supplemented with graphs and tabular information on the key industry players, overall financial and market performances, list of products and services, and company's share performances.

Confidential, Atlanta, GA

Business Objects Administrator

Environment: Business Objects 6.5, XI R2, Tomcat, Apache, Oracle 9.2, Teradata, SQL, PL/SQL, UNIX, Java, Web logic, Toad, Documentum, Erwin, MS Office and JIRA (Bug tracking tool).

• Worked on Supervisor (Currently known as CMC), Designer, Business Objects full client/ Desktop intelligence. Infoview, Performance Management, which included creating several dashboards, analytics, scorecards and some other key features of business objects to create and analyze the business metrics thus helping the management achieve their tasks by analysis of dashboard reports and scorecards. Helped troubleshooting various day-to-day issues in production environment.
• Maintained Security, Universe and Document domains in Business Objects. Created several Groups and Users for different projects. Worked on providing group/user level security and access privileges to the Business Objects resources.
• Created Universes using Designer module and written several reports in Business Objects.
• Involved in production support. Trained users in using the web intelligence/Infoview and create ad-hoc reports.
• Helped in tuning the Business Objects environment. Worked on several modules of business objects and recent release XI to develop, maintain and support the business objects application helped different teams with the business objects.

Confidential, Marietta, GA

Business Objects Team Lead

Environment: Business objects 5.1.7/6.1, UNIX, Informatica 6, Toad, Erwin 3.5.2, Oracle Apps, Oracle 9i/SQL Server, Webi 2.6, Windows 2000, SQL, PL/SQL, Excel, oracle reports developer

• Designed FRMT (Field Resource Management System) Universe. FRMT is a tool used by GI &FS Organization. The development team developed several reports. Mostly parameter driven. Tables, views, aliases, contexts, aggregate aware functions, Procedures, Functions have been used in universe and reports development. Extensively worked on Decode statements, and some Designer functions like @Aggregate Aware (), @Prompt, select etc.
• Report scheduling by Broadcast Agent Publisher, which enabled us to distribute information via email using an easy-to-use, subscription-based mechanism. Used BO full client and Webi.
• Creation of Gantt charts.
• Testing of the business objects reports and mappings in Informatica across the Business objects front end with the back end results using the same SQL and compared both in the excel sheet.