We provide IT Staff Augmentation Services!

Sap Sr. Business Objects Developer And Data Architect Resume

Chicago, IL

PROFESSIONAL SUMMARY:

  • Around 16 Years of total IT experience in all phases of Software Development Life Cycle (SDLC).
  • 14 years of experience in Design, Development, Implementation, Administration and Maintenance of SAP Business Intelligence (SAP Business Objects and Data Services) Solutions.
  • Requirements Gathering, Create Technical Specifications. Develop End Users Notes.
  • Administration and Development of Business Objects Enterprise XIR2/3.1/4.1 and Legacy/Classic Business Objects versions.
  • Experience in Web Intelligence, InfoView, Desktop Intelligence, Designer/IDT (Semantic Layer), CMC (Central Management Console), Supervisor, CCM (Central Configuration Manager), Import Wizard, Report Conversion Tool, Security Viewer, Crystal Xcelsius, Dashboards (EPM), SAP Data Integrator 11.7.0.1, Data Services 3.2.
  • Security, Authentication, Authorizations, Folders, Groups, Users, and Services setup.
  • Design and Development of Universes/Web Intelligence Reports. Unit Testing and Verify Data.
  • Conversion and Migration from Cognos to Business Objects and vice versa. Upgrading of Business Objects 6.5 to Business Objects Confidential R2, R3.1, 4.1. 4.2
  • Cognos 11 Administration, Setup up user accounts/permissions.
  • Schedule, Distribution and Bursting Cognos Reports through Schedule Management. Develop Custom Portal Tabs.
  • Experience in Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis.
  • Exposure to Import View, Business View and Star schema grouping Dimensional Views in Framework Manager.
  • Experience in lists, crosstab, multi - query, multi-page reports utilizing the master-detail relationship, conditional blocks, conditional formatting, unions, etc.
  • Experience in Data Services Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Admin Console.
  • Create Jobs and Objects using Data Integrator Designer and Load Data into Warehouse tables. Join Data from Multiple Sources, Map Columns, Perform Transformations and Functions on Data.
  • Design and Development of Complex ETL Mappings and Scripts using Data Services.
  • Experience in Data modeling, Data mart building and Data Extraction and data migration.
  • Performance Tuning of Source, Target, Mappings, Transformations and Sessions.
  • SQL Server Development, Oracle, MS Access Data base Create tables and Load the Data. Design the Tables.
  • Design and Development DTS Packages. Microsoft SSIS Load Data (Source and Destination and dc transformations) from Source files. Updating the tables and Insert the data.
  • Software Quality Assurance, Testing Methodology, Develop Test Plans, Test Procedures, Test Case Design and Execution.
  • Experience in Dimensional Data Modeling using Star Join Schema/Snowflake Modeling, Fact & Dimensions Tables etc.,
  • Experience in SalesForce.com CRM (Manage the Vendors and contractors and manufacturers, resellers information) and maintain the Salesforce nightly updates.
  • Extensively worked on various release of ERP: ECC 6.0, SAPR/3 4.7, and S/4 HANA
  • Assign Tasks to Technical Team members, Manage Timelines, Resolving Issues, Train Users, and Maintain Communication with Customers and Management.
  • Good Communication and Interpersonal skills. Capable of working as a Team Member or Individually with minimum Supervision.

TECHNICAL SKILLS:

Data ware housing/OLAP/ETL/ Data Integrator11.7 and Data Services, Business objects: Business Intelligence Platform, BusinessObjects 4.1/5/5.1/6/6.1 A/6.1B/6.51/ Confidential R2/ Confidential 3.1,4.1,4.2 - CMC, CCM, Auditor, Universe Designer (IDT), InfoView, BI LaunchPad, Web Intelligence 2/2.5/2.6/2.7 , Webi Rich Client, Interactive Analysis, Enterprise Performance Manager, Dashboard Manager, SAP BusinessObjects Dashboard Design, Lumira,Design Studio,Import Wizard, Report Conversion Tool, Life Cycle Manager, Query Builder, Crystal Xcelsius, QWAAS (Query as Web Service), Live Office, Publishing Wizard, Crystal Reports 6.0/7.0/8.0/8.5/ Confidential, 2008, Integration KIT for Microsoft SharePoint portal, BusinessObjects Data Integrator 6.1/ Confidential R2, Data Service s3.2, Cognos 11, Microsoft SSRS and Data Stage 7.

Testing Tools: Win Runner 4.0/5.0/6.0, Star Team, Load Runner 6.0, Test Director 6.0,8.0, Silk 5.0 and Web on line

RDBMS: SQL Server 6.5/7/8/2000/2005/2008 , DTS Packages, Oracle 7/8/9/10g,11g, DB2, Tandem Nonstop ODBC 7.2, MS Access 97/2000,DB27/8/9, Remedy 7.6.04, CDI 9.NetPlus 6.

Programming: SQL, Transact SQL,HTML 4, DHTML

WEB/GUI: Apache, Tomcat and IIS 4/5

Others: iMIS 20.2, Visual SourceSafe, PVCS, Test Director, Microsoft Excel 2000/2013, TOAD 9.1.0, Novell E Directory, Salesforce.com and Net plus 6

O/S: Windows 95/98/NT/2000/2003XP, Unix Linux and DOS

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SAP Sr. Business Objects Developer and Data Architect

Responsibilities:

  • Strong Business Objects Report Design (Web Intelligence Reports) development skills, troubleshooting complex reports with multiple queries, prompts, filters, crosstabs, charts, and merge queries.
  • Experienced in End-User Interaction Incident/Problem/Release Management Project Life cycle.
  • Experienced with Business Objects Universe Design, Scheduler, Data Integrator, and report development
  • Experienced with upgrade projects from BO 3.2 to BO 4.2
  • Understanding the data models for Oracle ERP modules (Accounts Payables, Accounts Receivables, General Ledger, Purchasing, Grants, Human Resource and Payroll) is a significant plus
  • Experienced translate business requirements into technical specifications to ensure the end product meets the user’s expectation.
  • Strong written and verbal communication and listening skills
  • Ability to work effectively with minimal direction
  • Designed complex SAP Data Services job flows to extract from/load to SAP systems such as SAP ECC, BW, HANA as well as non-SAP systems such as Oracle, MS SQL Server
  • Design (modeling) and construction of SAP HANA tables, functions, procedures, and views using a combination of Data Services, Power Designer, and HANA Studio.
  • Designed several dashboards leveraging various visualization components (Gauges, Interactive Charts, Alerts, and Scorecard etc.
  • Outstanding experience in Central Management Console (CMC) and CCM(Central Configuration Manager) in BO Confidential R2/3.1/BI4 /BI4.1/BI 4.2
  • Experienced in working with integrating SAP BOBJ BI tools with SAP BW and SAP HANA.
  • Extensive experience with dashboard design with focus on UI and UX.
  • Interacted with business users for the requirements of management reports & dashboards.
  • Created dashboards with interactivity with Crystal Reports and Web Intelligence for detailed level data.
  • Experienced with SAP Design studio 1.5/1.4, Business Objects 4.2
  • Created Attribute views, Analytical views, Calculation views Graphical.
  • Created restricted measures, calculated measures, variables, input parameters in Analytical Views.
  • Experienced in Creating Universes with relational database.
  • Using Oracle database querying using database developer tools: toad, sql developer etc.
  • Converted Desktop Intelligence reports to SAP BI4 Interactive Analysis Reports.
  • Server performance tracked at Monitoring tool and created Alerts top monitor to the server status.
  • Coordinate with SAP support team for maintenance and support.
  • Maintenance of Dashboard Builder and Performance Management tool.
  • Created Dashboards with Dashboard design tool with .UNX universe and BEX source Interactive Analysis reports.
  • Conversed .UNV universes to .UNX universes.
  • Maintained security and rights for the Users and distributed to reports to user inboxes.
  • Testing the Client Applications and servers before and after upgrader and fixing the issues.
  • Highly experienced in creating complex queries in BEx Designer/ Analyzer using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables, Structures, and RRI.
  • Actively involved in supporting the various issues addressed by the Users from the client side and providing them with required solutions.
  • Interacted with business users and performed Gap Analysis of Client requirements.
  • Involved in reviewing business requirement and analyzing data sources form Excel/Oracle, SQL Server for design.

Environment: (SAP Business Objects Business Intelligence Platform Confidential 4.2 (SP 3), Web Intelligence, Central Management Console, Central Configuration manger, IDT/UDT,Design Studio,16.0.5,SAP Lumira 1.17, SAP Hana and Dashboard Design 4.1/Data Quality, Oracle 11/Linux

Confidential, Austin Texas

Business Intelligence Architect

Responsibilities:

  • Documents requirements and specifications for system implementation, enhancements, develops consensus for those enhancements.
  • Participate in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
  • Design, write, test, debugs, and maintains Universe, Reports, and Mappings etc. that meet technical and functional requirements.
  • Design security model for Business Objects. Create security settings. Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor. Used CMC (Central Management Console) to Administer BO Confidential R3.1, 4.1.2.
  • Analyzing the Client Requirements and preparing the Dashboard specification document.
  • Worked on Conducted Unit Testing of the Dashboard.
  • Worked on Change Request of the existing Dashboards.
  • Developed dashboards and Lumira rollout framework. And created WEBI and Design studio.
  • Developed and modify Business Objects universe as per need. Convert DESKI reports to WEBI.
  • Used Universe & Crystal Reports and Webi Reports as a Data source of Xcelsius to build the dashboards thru Use live office & QAAWS to getting the live data.
  • Used Xcelsius Visualization of dashboards to pull the data from the required reports to Excel sheet by using Universe as data source. QAAWS & Web services, Live Office as a middle ware using Data feeding to Excel sheet. And analyzing, Designing and developing dashboards.
  • Creation of Dashboards Converting Business Data requirements into Conceptual and logical data models. Commonly used excel functions (" Index, Match and Conditional statements") Microsoft excel as a data source.
  • Exported Dashboards to BOE Server Exported visualization contents to various file formats (pdf, ppt,)
  • Re-Developed an existing dashboard completely in Design Studio and mabe compatible for IPAD and Iphone.
  • Developed web applications for both mobile and Ipads using Design studio 1.2 and SDK
  • Worked on creating Universe using IDT on Hyperion DB as a source for one of the dashboard designed on Design Studio.
  • Trained the business users in using Lumira for self-service way reporting.
  • Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
  • Worked as a QlikView Technical Consultant for a wide variety of business applications.
  • Enthusiast and Experienced QlikView developer- the pioneered in-memory Dash boarding tool.
  • This QlikView Project is for Finance Department, which includes Bookings, Revenue, Cost and Gross Margin.
  • Business Intelligence BI tool evaluation for Project Portfolio data management project prototyping/modeling project data and dashboards in Tableau, QlikSense and SiSense and others for Executive Leadership use. Data Analysis/modeling/preparation and prototyping in BI tools.
  • Implement 3rd party security authentication (Windows AD) in BO apart from Enterprise Authentication.
  • Work with Import Wizard. Created Daily and Weekly BIAR Files. Import and Export One Environment to Other Environment. (Groups/Users List/ Universes/Reports/ Dashboards)
  • Used Admin to create security settings. Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor. Used CMC (Central Management Console) to Administer BO Confidential 4.1.Maintains user roles, security, profiles, and workflow rules. Trains new end users on the Business Objects business intelligence tool. Develops roles and security model for Business Objects.
  • Worked closely with the project leadership team to document schedules, resource requirements, business requirements, test strategy, and plans for data migration, Involved in migration of reports from BO 6.5 to BO XIR3, Migrated universes, reports and security domain from 6.5 to BO XIR3 Using Import Wizard, Resolved several issues with installation, designing, reporting and migration.
  • Migrate and Maintain Universes and Reports to multiple Environments (Development, Test and Production) with Upgrade management tool.
  • Design new Universes using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes. Develop new Reporting and Adhoc, Metric Universe Creating the Pre-defined conditions and using aggregate tables with star schema and snow flake data model.
  • Create and Format the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions to analyze the data.
  • Involve in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes, Testing the Reports and Data validation in Test Director
  • Create standard and canned reports, Cross tabs reports, Ad-hoc reports using the features like Slice and Dice, Drill down, Ranking, Sorting, and @functions to analyze the data. Used Web Intelligence to create Reports.
  • Involve in customizing the look and feel of Web Intelligence Interface. Use to schedule, refresh and monitor Reports.
  • Deploy Cognos 11 on development, test production servers. Setup user accounts and permissions. Troubleshoot and Provide support on production/test/development environments.
  • Upgraded Framework Manager Models, Transformer Cubes and reports from Cognos 11. Built Framework Manager Models (Relational, DMR) for Standard Reporting and Adhoc Analysis.
  • Create Star schema groupings in Framework Manager Models to meet the reporting requirements, Created Import View, Business View and Star schema grouping Dimensional Views in Framework Manager.
  • Design and develop numerous lists, crosstab, multi-query, multi-page reports utilizing the master-detail relationship, conditional blocks, conditional formatting, unions, etc.
  • Schedule and Distribute Reports through Schedule Management in Cognos Connection and Bursting reports to different user groups
  • Develop Custom Portal Tabs and Custom User Interfaces for Reports based on UAT Feedback. Participate in various UAT sessions.
  • Work with SQL Server. Created tables and Loading data. Connections, Worked with Servers Dev and Model and Prod. Database back up files
  • Stays abreast of Business Objects best practices applicable to TAC needs. Should be able to develop recommendations and/or work plan to management for upgrades or enhances to said system.
  • Participate in cross-functional teams that address strategic business issues involving Business Objects Confidential 4.1 and SSRS
  • Involve in Design and develop the architecture for all data warehousing components e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation, information and analytics delivery and data quality strategy
  • Identify ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Participated and lead research and development efforts (proofs of concept, prototypes), as subject matter experts, with new technologies.
  • Having expertise in migration of ECC 6 from Oracle DB to SAP HANA SOH.
  • Involved in SAP S4 HANA road map meeting with SAP.
  • Implement ETL standards and Best Practices while naming Maps and processes.
  • Coordinate and communicate the overall project execution status with Project Manager and Technical Delivery Manager
  • Develop complex maps to extract data according to the Transformation Business Rules and User requirements.

Confidential, Austin, Texas

Systems Analyst, Administrator and Developer

Responsibilities:

  • Documents requirements and specifications for system implementation, enhancements, develops consensus for those enhancements.
  • Participate in the entire requirements engineering process right from requirements elicitation phase to the phase involving documenting of the requirements.
  • Design, write, test, debugs, and maintains Universe, Reports, and Mappings etc. that meet technical and functional requirements.
  • Stays abreast of Business Objects best practices applicable to agency needs. User training and Business Objects best practices. Trains new end users on the Business Objects business intelligence tool
  • Participates in cross-functional teams that address strategic business issues involving Business Objects Confidential and DS.
  • Help agency-wide implementation of the Business Objects business intelligence tool.
  • Create and Maintains user roles, security, profiles, and workflow rules.
  • Design security model for Business Objects. Create security settings. Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor. Used CMC (Central Management Console) to Administer BO Confidential R3.1, 4.1.
  • Implemented 3rd party security authentication (Windows AD) in BO apart from Enterprise Authentication.
  • Work with Import Wizard. Created Daily and Weekly BIAR Files. Import and Export One Environment to Other Environment. (Groups/Users List/ Universes/Reports/ Dashboards)
  • Design Dashboards and Score boards using features like IMT, New Analytics, and pie charts. Creating Metric Universe for Performance Management Dashboards.
  • Create Metrics, deploying Dashboards and create custom calendars.
  • Create Speedometers, Stop Lights. Worked with Corporate and Personnel Dashboards. Maintains the functional areas of data management, semantic structures, dashboards, and reports.
  • Develop the Business Objects Auditing Environment (Design the Auditing Universe and reports.
  • Migrate and Maintaining Universes and Reports to multiple Environments (Development, Test and Production) with Import wizard
  • Design new Universes using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
  • Create and Format standard and canned reports, Cross tabs reports, Ad-hoc reports as per the Users Requirements using the features in Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down.
  • Provide a Root Cause Analysis (RCA) for Bi application issues and outages etc.
  • Work with Data Integration, Data services administration ( Creating the users and servers, repository )
  • Work with Oracle & SQL Server. Create tables and loading data.
  • Create Crystal reports Confidential, Sub reports and functions, sorting, data expert and functions
  • Manage and participate in Data Loads and Data Quality efforts.
  • Write, maintain, documents scripts to automate routine work, backups etc.
  • Identify ETL specification based on Business Requirements/Mapping Document. Formulating and documenting ETL process design. Implement ETL standards and Best Practices while naming Maps and processes.
  • Develop complex maps to extract data according to the Transformation Business Rules and User requirements.
  • Modify several of the existing maps and create several new maps based on the user requirement.
  • Create workflows and use various tasks like Email, Control, Decision, and Session in the workflow manager.
  • Work with Data Services client tools like Source Analyzer, Warehouse Designer and Mapping designer.
  • Troubleshoot and resolve operational issues with the Business Objects and DS environments.
  • Data validation for Quality assurances web testing Texas.gov, Communications Technology (CTS), and Co-op Contracts. Support sourcing, supply chain operations.
  • Telecommunication’s Call detail process from vendors ATT, TXS, MEGA, and QST operated through Unix
  • Validate Telecom vendor file submissions for formatting within 3 business days of the submission and communicate with vendors and internal DIR Contract Administrators about any quality or timeliness issues.

Confidential, Austin, Texas

Business Intelligence - Systems Analyst, Administrator and Developer

Responsibilities:

  • Designing New Legislative and EIS Dashboards and Score boards Using features like IMT, New Analytics, and pie charts. Creating Metric Universe for Performance Management Dashboards. Experience in creating Metrics, Deploying Dashboard and creating custom calendars. Created Speedometers, Stop Lights.
  • Designing new Metric Universe Creating the Pre defined conditions and using aggregate tables with star schema data model.
  • Used Supervisor to create security settings. Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor. Used CMC (Central Management Console) to Administer BO Confidential rel2.
  • Migrating and Maintaining Universes and Reports to multiple Environments (Development, Test and Production Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
  • Designing new Universes using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
  • Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions to analyze the data. Creating and distributing Report Templates to Users. Web-Enabling the Reports using Web Intelligence.
  • Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes, Testing the Reports and Data validation in Test Director
  • Migrating and Maintaining Universes and Reports to multiple Environments (Development, Test and Production). Involved in Users training of BO XI2 and Dash boards
  • Creating Standard reports, Cross tabs reports, Ad-hoc reports using the features like Slice and Dice, Drill down, Ranking, Sorting, and @functions to analyze the data. Used Web Intelligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface. Used Broad Cast Agent to schedule, refresh and monitor Reports.
  • I have used grouping, sorting, totaling, running totals, charts etc., I have exported my reports into various formats like PDF, txt, xml, tab.
  • Worked on SQL Server. Created tables and Loading data. Created and Designed the DTS Packages. Loaded Data (Source and Destination and transformations) From Source files. Creating Databases, Creating Connections, Updating tables and Inserting Data.
  • Used Test Director for testing the reports, Loading the requirements and fixing the bugs fix the bugs. Worked on Crystal Reports Confidential .
  • Production Support. Used Tandem to create volumes/sub volumes, create the Jobs, release the Jobs, Run the job Scripts, Involved in On Call Production Support. Taking calls, fixing jobs and Interaction with Users.

Confidential, Clewiston, Florida

Business Objects Analyst, Administrator and Developer

Responsibilities:

  • Installing and configuring BO Confidential in a 2 tier environment. Configuration Business Objects Servers using Apache and Tomcat 4.1. Creating Repository (Security, Universe and Document Domains). Used both Business Objects 6.51 and Confidential Release 2 Versions.
  • Used Supervisor to create security settings. Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor. Used CMC (Central Management Console) to Administer BO Confidential rel2.
  • Designing new Universes using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes. Resolving Fan and Chasm traps.
  • Creating Metric Universe for Application Foundation Confidential Sugar Dashboards. Experience in creating Metrics, Deploying Dashboard and creating custom calendars. Created Speedometers, Stop Lights.
  • Migrating and Maintaining Universes and Reports to multiple Environments (Development, Test and Production).
  • Creating Standard reports, Cross tabs reports, Ad-hoc reports using the features like Slice and Dice, Drill down, Ranking, Sorting, and @functions to analyze the data. Used Web Intelligence to create Reports. Involved in customizing the look and feel of Web Intelligence Interface.
  • Used Broad Cast Agent to schedule, refresh and monitor Reports.
  • Creating Report using Crystal Reports. I have developed reports like blank reports, cross tab reports, sub reports and mailing labels.
  • I have used grouping, sorting, totaling, running totals, charts etc., I have exported my reports into various formats like PDF, txt, xml, tab.
  • Involved in Problem Solving, Trouble shooting and developing End User Notes. Interacting with End Users document the Requirements. Users training sections.
  • Manually performed System Testing, Regression Testing and Functional Testing. Generated Test data for identifying valid data, Invalid data, Partial data, and Bad data using SQL in SQL Server.
  • Developed mappings in Informatica Power Center Designer using aggregate, Expression, Filter, Sequence Generator, Update Strategy, Lookup, Joiner, Stored procedure transformations to Extract, Transform and Load (ETL) data from source system.

Confidential, Sacramento, CA

Business Objects Developer

Responsibilities:

  • Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
  • Designing new Universes using features like Check Integrity, Aliases, Loops, Contexts, Joins and finally creating the Objects (Dimensions, Measures and Details), which are grouped into Classes.
  • Maintaining Universes and Reports using Business Objects Best Practices in multiple Environments (Development, Test and Production).
  • Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions to analyze the data. Creating and distributing Report Templates to Users. Web-Enabling the Reports using Web Intelligence.
  • Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End User Notes.
  • Installing the Business Objects and Creating Repository (Security, Universe and Document Domains).
  • Managing security by Adding, Enabling, Disabling and Deleting of Users/Groups and the granting of privileges using Supervisor.
  • Manually performed System Testing, Regression Testing and Functional Testing.

Hire Now