We provide IT Staff Augmentation Services!

Computer Systems Architect/business Objects Architect Resume

Brooklyn, NY

SUMMARY

  • 12+ years of Extensive experience in building Date Warehouse and Business Intelligence (BI) Applications using SAP Business Objects Suite as an Administrator and a Developer.
  • Experience in Designing Universes and development of reports both in Full client as well as in Web Intelligence. Also gained a lot of work experience in the Classic Architecture and modules like Reporting, Designer, Supervisor, Web Intelligence, Info View and Broadcast Agent on both UNIX and Windows platforms.
  • Extensively worked on Business Objects Ad - hoc Reporting by accessing data using Universes, Personal data files and stored procedures.
  • Experience on Xcelsius 2008 in creating Dashboards, Score cards, graphs, charts, inserting maps and complex analytics reports.
  • Good Knowledge of Data Modeling using Entity-Relationship Model, Dimensional Data Modeling using Star schema and snow flake schema.
  • Extensively worked with SQL Queries, and capable of handling Oracle, SQL Server, MS Access databases and also have good experience in database tuning and performance techniques.
  • Used Import wizard to migrate the universes, Corporate Documents, users and groups from BO 6.5 to BO XI R2, BO XI R2 to BO XI R3 and BI 4.x.
  • Experience in using BusinessObjects Data Services tool for Implementation of ETL methodologies in Data Extraction, Transforming and Loading.
  • Knowledge of installation, upgrades, maintenance, clustering, and administrating the complete suite of SAP Business Objects tools in shared environment.
  • Maintenance of repository, connections, Report Publishing, Scheduling, Monitoring, Users and Groups.
  • Excellent Analytic skills with the ability to recognize and translate business problems into technology-based solutions.
  • Strong experience with client interactions, understanding business applications, business data flow and data relations.
  • Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities and flexible in work schedules.
  • Good Interpersonal and communication skills, technically competent and enthusiastic team player.
  • Extensive experience in leading, training, mentoring and coordinating activities with development teams.
  • Experience working with onsite and offshore models of project development.
  • Excellent perceptive, analytical and problem-solving skills well suited for complex software applications.
  • Highly motivated and organized leader with excellent client relationship, listening, communication, and delivery skills.
  • Expertise in issue resolution and user handling.
  • Great communication skills, problem solving ability, planning and analytical thinking required for successful project management.

TECHNICAL SKILLS:

Operating Systems: MS-DOS, Linux, UNIX, Windows.

Distributed Technologies: RMI, EJB, Web Services, SOA.

Internet Applications: J2EE, SDK, JDK1.2.2/1.3, Servlets, AWT, Swing, Beans, JDBC, JSP.

Web/Application Servers: Weblogic 6.0, Tomcat, IIS 4.0.

IDE: JBuilder 6.0

Methodologies: OOP, OOD/OOA, SAD (Structured Analysis and Design), SDLC, RUP, UML, Waterfall, Agile.

Languages: C, Java, Java Script, VB Script, PERL.

Markup languages: HTML, DHTML and XML.

Database applications: Oracle, MS-SQL Server and MS Access.

Documentation tools: MS Visio, Rational suite.

Defect Tracking tools: Rational Clear Quest.

Protocols: TCP/IP, HTTP, HTTPS, FTP.

OLAP Tools: SAP Business Objects, Crystal Reports, Business Objects BI4.0/XI R3/R2/6.5 (Supervisor, Designer and Reporter), WEBI XI R3/R2, WEBI Rich client, DESKI R3, Crystal Reports, Crystal Xcelsius, Live Office, Broadcast Agent Server (scheduler & publisher), Dashboard Manager, Business Objects 6.5 (Supervisor, Designer, Reports), WEBI 2.6/2.7/6.x/6.5, Auditor 6.5/XI R2

ETL Tools: Business Objects Data Integrator (Data Services) XI 3.2.

Industries: Biotechnology (Research), Manufacturing, Healthcare, Logistics, Mining, Banking, Government.

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn, NY

Computer Systems Architect/Business Objects Architect

Responsibilities:

  • As an Architect (BO Administrator), configured and managed installations of Business Objects servers installations in the organization. The installation comprising of 1 development server, 1 SIT server, 1 QA server, 2 UAT servers and 2 production servers.
  • Worked on planning and sizing of new installs as per the business requirement.
  • Migrated from Solaris to Linux servers. Completely designed the new environment and did the installation, configuration and migration.
  • Implemented SSO user authentication using OIM.
  • Deployed Universes, Documents, Users in repository and established connection with database.
  • Importing/Exporting the Universes to repository to make it available to the users.
  • Involved in the user management activities, maintained users and groups, created and assigned proper access levels using Central Management Console.
  • Worked on deployment of Business Objects on Web Logic application server.
  • Experienced in planning and implementing disaster recovery procedures.
  • Knowledge of SAP message creation and noledge base searching for quick issue resolution.
  • Conversion of .unv universes to .unx universes and creation of new .unx universes.
  • Did the P.O.C. for BI4.2 migration from the existing 3.1 SP6/SP7 environment.
  • Completed migration from SAP Business Objects 3.1SP7 to SBOP 4.2 SP6

Technology used: SAP BO 3.1SP6/SP7, BI4.2SP6, SDK, Webservices for dashboards, Dashboards, Oracle 11i, Windows 7, RHEL 5.9, Promotion Management, Web Logic 10.3.6, Tomcat, SVN Version Management, JIRA, SSO, Information Design Tool, Universe Design Tool, HP LoadRunner 12.0.1.

Confidential, Tallahassee, FL

Senior Business Objects Consultant/Administrator

Responsibilities:

  • Thorough noledge of the installation, configuration and maintenance of Business Objects on Windows and Unix servers.
  • As an Architect(BO Administrator), configured and managed installations of Business Objects servers installations in the organization. The installation comprising of 1 development server, 1 system test server, 2 UAT servers and 2 production servers.
  • Ability to quickly build and deliver new Business Objects environments. Have done multiple Business Objects builds across SDLC starting from development to test to production and disaster recovery servers.
  • Good noledge working on File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server and security setup.
  • Implemented user authentication using LDAP, user group setup using custom access levels and security.
  • Deployed Universes, Documents, Users in repository and established connection with database.
  • Importing/Exporting the Universes to repository to make it available to the users.
  • Involved in the user management activities, maintained users and groups, created and assigned proper access levels using Central Management Console.
  • As an architect, worked on planning and sizing of new installs as per the business requirement.
  • Worked on deployment of Business Objects on Tomcat web application server.
  • Experienced in planning and implementing disaster recovery procedures.
  • Knowledge of SAP message creation and noledge base searching for quick issue resolution.
  • Prepare the data warehouse, design universes and develop reports.
  • Conversion of .unv universes to .unx universes and creation of new .unx universes.
  • Business Objects SDK for administration

Technology used: BI4SP6, Live Office, SDK, Webservices for dashboards, Dashboards, Oracle 11i, Windows 7, RHEL 5.9, Promotion Management, Web Sphere 8, Tomcat, SVN Version Management, ClearCase, LDAP, Information Design Tool, Universe Design Tool, HP LoadRunner 12.0.1.

Confidential, Tampa, FL

Senior Business Objects Administrator

Responsibilities:

  • Managed teams both on-site and off-shore.
  • Thorough noledge of the installation, configuration and maintenance of Business Objects on Windows and Unix servers.
  • As an Architect and Project Manager (BO Administrator), configured and managed 26 individual installations of Business Objects servers out of 67 installations in the organization. Each installation comprising of 2 development servers, 2 test servers, 2 production servers and 2 disaster recovery servers. So, handled a total of more TEMPthan 200 Business Objects instances.
  • Ability to quickly build and deliver new Business Objects environments. Have done multiple Business Objects builds across SDLC starting from development to test to production and disaster recovery servers.
  • Good noledge working on File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server and security setup.
  • Implemented user authentication using LDAP, user group setup using custom access levels and security.
  • Deployed Universes, Documents, Users in repository and established connection with database.
  • Importing/Exporting the Universes to repository to make it available to the users.
  • Involved in the user management activities, maintained users and groups, created and assigned proper access levels using Central Management Console.
  • As an architect, worked on planning and sizing of new installs as per the business requirement.
  • Worked on deployment of Business Objects and customized programs including SDK on different web application servers like Web Sphere, Web Logic and Tomcat.
  • Experienced in planning and implementing disaster recovery procedures.
  • Knowledge of SAP message creation and noledge base searching for quick issue resolution.

Technology used: SAP Business Objects XI 3.1, Live Office, QaaWS, Xcelsius 2008, Oracle 10g/11i, Windows 7, Windows 2008 Server, Unix AIX 5.3/6.1.0.0, LCM, BI 4.0, Web Sphere, Web Logic, Tomcat.

Confidential, Phoenix, AZ

Project Manager for Business Intelligence Team/Administrator

Responsibilities:

  • Managed teams both on-site and off-shore.
  • As a lead (Administrator and developer), configured and managed servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server) and security setup.
  • Implemented user authentication using LDAP.
  • Deployed Universes, Documents, Users in repository and established connection with database.
  • Importing/Exporting the Universes to repository to make it available to the users.
  • Used InfoBurst tool for Report Bursting.
  • Extensively used Ebiexperts Version Manager for publishing the universes and reports to the different environments of Business Objects.
  • Involved in the user management activities, maintained users and groups, created and assigned proper access levels using Central Management Console.
  • Worked with DBA’s and ETL specialists to help check loads by generating WebI Rich Client reports from development. Used SQL TEMPeffectively to increase the performance.
  • As an architect, developed new universes using star schema as per the requirement document.
  • Defined Derived Tables, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins.
  • Resolved Loops using Aliases and Contexts and verifying integrity of the universes.
  • Designed aggregate tables on the most frequently queried data for quicker query response.
  • Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
  • Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.
  • As a developer created complex WebI Rich Client reports using the multiple data providers and synchronized the data providers by linking the common objects using merge dimensions, force merge, calculation contexts to create the reports.
  • Used Track Data for tracking and monitoring changes in data through InfoView.
  • Handled Quality Assurance issues while conducting Unit testing.
  • Scheduled the reports to be emailed to end users as per schedule in WebI, PDF and XLS formats using InfoBurst.
  • Mentored developers and trained the users in viewing/developing the reports using the Info view.

Technology used: SAP Business Objects XI 3.2 (CMC, Designer) Web Intelligence XI 3.2 (Info view), Live Office, QaaWS, Xcelsius 2008, Teradata 13.10, MS Excel 2007, Windows XP, Windows 2003 Server, InfoBurst, Ebiexperts Version Manager for Business Objects, Ellipse, Star LIMS.

Confidential, Syracuse, NY

Business Objects Lead Consultant/Administrator

Responsibilities:

  • Gatheird Requirements and Business logics from Business Users and prepared technical documents.
  • As a lead consultant, was responsible for administration including configuring and managing servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server) and security setup.
  • Implemented user authentication using Windows Active Directory.
  • Installed Business Objects XI 3.2 on Windows 2003 Server, configured Tomcat settings.
  • Deployed Universes, Documents, Users in repository and established connection with database.
  • As an architect, developed new universes using star schema as per the requirement document.
  • Defined Derived Tables, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins.
  • Resolved Loops using Aliases and Contexts and verifying integrity of the universes.
  • Designed aggregate tables on the most frequently queried data for quicker query response.
  • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
  • Importing/Exporting the Universes to repository to make it available to the users.
  • Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.
  • Created complex WebI Rich Client reports using the multiple data providers and synchronized the data providers by linking the common objects using merge dimensions, force merge, calculation contexts to create the reports.
  • Used Track Data for tracking and monitoring changes in data through InfoView.
  • Developed KPI Dashboards for upper level management using Xcelsius 2008 using multiple data sources like QaaWS, Live Office and MS Excel.
  • Used Profiles and Publication feature in XI 3.2 for Report Bursting.
  • Involved in the user management activities, maintained users and groups, created and assigned proper access levels using Central Management Console.
  • Handled Quality Assurance issues while conducting Unit testing.
  • Worked with DBA’s and ETL specialists to help check loads by generating WebI Rich Client reports from development. Used SQL TEMPeffectively to increase the performance.
  • Scheduled the reports to be emailed to end users as per schedule in PDF and XLS formats from Info view.
  • Mentored developers and trained the users in viewing/scheduling the reports using the Info view.

Technology used: SAP Business Objects XI 3.2 (CMC, Designer) Web Intelligence XI 3.2 (Info view), Live Office, QaaWS, Xcelsius 2008, Oracle 10g, SQR, MS Excel 2007, Windows XP, Windows 2003 Server, EPIC, HBI.

Confidential

Business Objects Lead Consultant/Administrator

Responsibilities:

  • Gatheird Requirements and Business logics from Business Users and prepared technical documents.
  • As an administrator, configured and managed servers (File Repository Server, Report Application Server, Web Intelligence Server, Destination Job Server, Program Job Server, Event Server) and security setup.
  • As an architect, responsible for capacity planning and Universe designing.
  • Installed Business Objects XI R2 on Windows 2003 Server, configured IIS settings.
  • Deployed Universes, Documents, Users in repository and established connection with database.
  • Maintained existing universes and developed new universes using star schema as per the requirement document.
  • Defined Derived Tables, Classes, Objects, Dimensions, Measures, Details, Conditions, Joins.
  • Resolved Loops using Aliases and Contexts and verifying integrity of the universes.
  • Designed aggregate tables on the most frequently queried data to fasten the query response.
  • Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
  • Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
  • Importing/Exporting the Universes to repository to make it available to the users.
  • Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.
  • Created and maintained all the Targets related to partners in a Master Configuration file using Excel 2007.
  • Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the reports.
  • Used Data Services for ETL to get data from SQL Server 2008 and Oracle 10g databases.
  • Developed Dashboards for each GEO for upper level management using Crystal Xcelsius and posted onto Finance Portal.
  • Migrated Business Objects Enterprise XI R2 SP3 to XI 3.1
  • Used Profiles and Publication feature in XI 3.1 for Report Bursting.
  • Involved in the user management activities, maintained users and groups, created and assigned proper access levels using Central Management Console.
  • Handled Quality Assurance issues while conducting Unit testing.
  • Worked with DBA’s and ETL specialists to help check loads by generating DeskI reports from development, especially during Annual Process pre-runs. Used SQL TEMPeffectively to increase the performance.
  • Scheduled the reports to be emailed to end users daily in PDF and XLS formats from Info view.
  • Trained the users in viewing/scheduling the reports using the Info view.

Technology used: SAP Business Objects XI R2 (CMC, Designer, DeskI), Web Intelligence XI R3 (Info view), Business Objects Data Services XI 3.2, Live Office, QAAWS, Crystal Xcelsius 2008, Hibernate, Oracle 10g, SQL Server 2008, MS Excel 2007, Windows XP, Windows 2003 Server.

Confidential, Atlanta, GA

Sr. Business Objects Consultant

Responsibilities:

  • Interacted with Business Users to gather, analyze and record requirements / specifications.
  • Responsible for installing and configuring BO, WEBI, Info View on Windows NT server.
  • Row level security is implemented in the supervisor to restrict the data to the respective divisions.
  • Involved in resolving table-linking problems like Chasm Traps and Fan Traps using Alias and Context.
  • Created different types of reports like Cross Tab, Charts and Master Detail using multi data sources.
  • Created the complex WEBI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
  • Tested and deployed universes and documents across testing/production repositories
  • Created complex reports using Business Objects functionality like Slice and Dice, Drill Down, Drill Up and Ranking were used in reports.
  • Designed Parameterized reports to filter the data and for dynamic changes of the report look and feel.
  • Bug fixing and enhancing existing reports. Making changes to the reports dat are created in earlier versions.
  • Aggregate awareness functions of Business Objects are used to route the query objects through most appropriate path while selecting from multiple contexts. 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.
  • Migrating existing Reports, Universes and WID files in Business Objects 6.5 version to XIR2 using Import wizard and enabled auditing feature of Business Objects XI R2.
  • Involved in Importing/Exporting the Universes to repository to make it available to the users.
  • Used Slice and Dice, Drill Down, Filters, Master Details, Cross-Tabs and developed Hierarchies to support drill down reports.
  • Setting up and administering the Broadcast Agent. Worked with BCA to schedule reports on monthly and weekly basis.

Technology used: Business Objects 6.5/XI R2 (Designer, supervisor, Full Client), Crystal Reports 9.0, SQL Server 2005, Windows 2000, UNIX.

Confidential

Senior Business Objects Consultant

Responsibilities:

  • Analyzed the existing data warehouse and implemented changes to design, develop reports in the new format as per escalating user requirements.
  • Developed technical and functional specification for new universe and reports.
  • Build universes, reports to keep track of the metrics on the Business Objects usage scheduled job statistics for the management.
  • Scheduling of Data Integrator jobs using Data Integrator comprising error handling and email notifications.
  • Using Preload option, deleted the data from target tables before populating data.
  • Created Complex reports using Cascading Prompts, Multiple data providers etc.
  • Applied breaks on reports and used ranking and alerters to get appropriate results and created cross tabs.
  • Extensive use of advanced functions in universes, reports eg. Hierarchies, @promts, conditional hiding, sorting etc.,
  • Perform ad-hoc analysis and reporting for existing and potential hedge fund strategies.
  • Maintaining different cycles of data loads and test the reports periodically and save the .pdf and .xls version of the Reports.
  • Maintaining the existing Universe and to create the targeted Reports.
  • BOXIR2: Testing of BOXI Release2 products installation on Test servers(Win2K) with IIS5 as web server
  • Involved in Migrating Business Objects from 6.5 to XI R2 Test Repository using Import Wizard and Report Conversion Tool.
  • Migrated connections, categories, universes and documents.
  • Resolved security issues after migration.
  • Performed role as an administrator (supervisor) - creating users and maintenance of groups with different privileges.

Technology used: Business Objects 6.5.1/ XIR2, Informatica 7.x/8.0, BCA, ZABO, WebI 6.5/XI R2, Oracle 9i/10g, Windows-NT.

Confidential

Business Objects Developer.

Responsibilities:

  • Involved in the design of a completely new data warehouse.
  • Involved in the design and development of reports.
  • Developed technical and functional specification for new universe and reports.
  • Prepared report templates.
  • Conducted brain-storming sessions with user for requirements gathering.
  • Performed the role of a coordinator for the project.
  • Universes were designed for individual clients/laboratories.
  • Migration plan for BO 6.5 to XI R2 was proposed for the complete data warehouse.
  • Involved in Migrating Business Objects from 6.5 to XI R2 using Import Wizard and Report Conversion Tool.

Technology used: Java, XML, XSLT, JSP, CSS, Business Objects XI R2/6.5.1, Data Integrator, Informatica 7.x, WebI, Oracle 9i/10g, Windows-NT.

Hire Now