We provide IT Staff Augmentation Services!

Sr./lead Business Architect Resume Profile

3.00/5 (Submit Your Rating)

TX

SUMMARY:

  • Over 13 Years' experience in Technology Industry in full software development life cycle SDLC .
  • 10 Years of expertise in report development using SAP BW, SAP BI, Business Objects BI 4.0/ XI R3, Crystal Reports 2011/2008/XI, Cognos 8.2 and 8.3, Crystal Enterprise 8.5/9.0/10, Business Objects Enterprise XI R3, BI Enterprise 4.0, Business Explorer, Access Reports, and Visual Basic 6.0, ASP 3.0, Visual Studio .Net, Java 2.0, J2EE, JSP.
  • Business Objects Certified Professional - Crystal Reports XI
  • Working experience and Excellent Knowledge on SAP HANA Modeling, Attribute View, Analytic Views, Calculation Views and Data Services 4.0.
  • Extensive experience in writing Views using Oracle and MS SQLServer.
  • Extensive experience on Xcelsius Dashboards and Visual interactive presentation.
  • Extensive experience on working with OLAP tools like SAP BI/BW, Business Explorer.
  • Proficiency designing reports against OLAP Cubes.
  • Experience Creating Universes on OLAP SAP BW/BI Oracle, SQL Server
  • Extensive experience of share the data between sub-reports and using shared data in graphs and charts.
  • Published reports via. Publishing Wizard and Management Console.
  • Assisted with project planning, workflow analysis and documentation, including methods, processes, tasks and schedules.
  • Experience with integrating reports in VB, .Net and Java using RDC Report Designer Component , RAS Report Application Server , and JRC Java Reporting Component .

Summary

  • Extensive experience on Crystal Reports 2011/2008 and Business Objects Enterprise 4.0/XI R3
  • Installed and configured Crystal Enterprise XI 3.1/ R2/R2/10/9.0
  • Developed heavy complex reports using various features like Custom Functions, multiple grouping, drill down, Cross Tab, parameterized fields, formulas, conditional formatting and Shared variables using Crystal Reports 2008.
  • Experienced in designing and fine tuning Complex Universes in Data warehousing and OLAP environments.
  • Create complex reports using Desktop Intelligence and Web Intelligence XI 3.0.
  • Developed complex reports like drill down, Slice and Dice, master/detail for analysis in Web Intelligence.
  • A big number of DESKI reports have been converted in to WEBI / Crystal.
  • Led couple of projects with offshore team and experienced in working with different kind of Off shore models.
  • Designing dashboards using Crystal Reports content and Xcelsius 2008 and Web Intelligence documents.
  • Developed reports against SAP BW/BI Cubes OLAP , ODS, SAP BI, SQL Server, and Oracle and Access database.
  • Migration of the Universes, Web Intelligence Reports and Crystal Reports from SAP BW 3.0 to SQP BI 7.
  • Good command on Data warehousing concepts and implementing Slowly changing dimensions SCD
  • Strong interpersonal skills with demonstrable verbal and written communication to maintain effective work relationships with all levels of personnel.
  • Ability to design, code, debug, document and support efficient computer applications and tools consistent with established specifications and business requirements.
  • Proven analytical and technical background.

TECHNICAL SKILLS:

ERP

SAP BW 3x, SAP BI 7.2/7.0. SAP HANA

RDBMS

Oracle 9i, MS SQL Server 2005/2000/7.0/6.5, MS Access 2003

GUI

Visual Basic 6.0/5.0

Business Intelligence Tools

SAP BI, Business Objects 4.0/XI 3.1/R2/R1 XI, Crystal Enterprise XI/9.0, 8.5, Cognos, BODS Business Objects Data Services

Reporting Tools

Crystal Reports, Web Intelligence, Desktop Intelligence, Cognos, SSRS SQL Server Reporting Services .

Utilities

SQL Loader, TOAD, Visual Source Safe, LiteSpeed, Spotlight

ETL

DTS Data Transformation Services SSIS SQL Server Integration Services , DATA Services 4.0

Operating Systems

Windows.

PROFESSIONAL EXPERIENCE:

Confidential

Sr./Lead Business Architect

Responsibilities:

  • Design and Implementation of Security in BO 4.0.
  • Performed SAP Integration and enabled single sign-on. Implement the security with SAP Roles with Corporate Folders.
  • Optimize and performance tuning of Business Object Platform
  • Performance tuning of universes and reports.
  • Define and create XML files for Advanced Analysis for Office installation package.
  • Install and configure SAP Business Objects Explorer on Windows platform.
  • Design Universe Using IDT Information Design Tool and build information spaces for Explorer.
  • Creating report mock-ups and providing best solutions by different reporting options BI 4.0 tools like WEBI against Universe, WEBI against BEx, Crystal Reports 2011, and Crystal Reports for Enterprise 4.0, Universe Designer, and Information Designer Tool.
  • Design Complex Dashboards against BEx queries and UNX Universes.
  • Working with BW Developers on implementing security using SAP User Exit and SAP Customer Exits to reduce query results and using Analysis Authorization Objects.
  • Design Complex Universe using IDT against Multiple data sources Demand Planning, Supply Planning and ECC.
  • Configure Data Federation Connection Configuration for better performance.
  • Created new and modified existing SAP BI Queries with Restricted Key figures and Calculated Key Figures.
  • Create LCM Jobs to promote Universe/Reports/Users/Roles to UAT.

Environment: SAP ECC 6.0, SAP BW 7.4, BEX Analyzer, BEX Report Designer, and Business Object 4.1 SP3, WebFocus, Oracle, Windows 2008 Server

Confidential

Sr./Lead Business Objects Architect

Responsibilities:

  • Install and Design Studio Add-on Plug-in.
  • Gathering requirements, prepare functional and technical specifications.
  • Design the architecture of visualizations.
  • Design Analytical and Calculation Views on HANA
  • Design dashboards against HANA Models.
  • Design and implement security strategy.
  • Integrate Business objects with NW portal.
  • Lead and distribute the assignment between the team members.
  • Co-ordinate with off-shore team.
  • Distributed the services on multiple nodes.
  • Define and implement migration strategy using Promotion Management Tool LCM .
  • Configure SAP Business Objects Mobile configuration MOBI on Windows Platform.

Environment: SAP ECC 6.0, SAP BW 7.4, HANA, BEX Analyzer, BEX Report Designer, and Business Object 4.1 SP3, Design Studio 1.3, Windows 2008 Server

Confidential

Sr. Business Objects Administrator/Architect Upgrade

Responsibilities:

  • Installing the Business Objects Platform 4.1 SP3 Enterprise .
  • Deploying Apache Tomcat Server and Configuring Windows AD SSO.
  • Install and configure SAP Business Objects Explorer.
  • Install and Design Studio Add-on Plug-in.
  • Install and Design Analysis Office Add-on Plug-in.
  • Design and Implementation of Security in BO 4.1.SP3.
  • Clustering Business Objects into multiple nodes on all three environments.
  • Distributed the services on multiple nodes.
  • Performed SAP Integration and enabled single sign-on. Implement the security with SAP Roles with Corporate Folders.
  • Define Publications and provide best practices on designing Crystal Reports, Web Intelligence and Dash boards.
  • Optimization and performance tuning the Business Objects Platform and reports.
  • Define and implement migration strategy using Promotion Management Tool LCM .
  • Migrate SAP Business Objects 4.0 SP4 to SAP Business Objects 4.1 SP3 and resolved the issues with security and migration problems.
  • Configure SAP Business Objects Mobile configuration MOBI on Windows Platform.
  • Define and create XML files for Advanced Analysis for Office installation package.
  • Design Universe Using IDT Information Design Tool and build information spaces for Explorer.
  • Configure Data Federation Connection Configuration for better performance.

Environment: SAP ECC 6.0, SAP BW 7.3, DB2, BEX Analyzer, BEX Report Designer, and Business Object XI 4.1 SP3, Crystal Reports 2013, Crystal Reports for Enterprise 4.1 SP3, and Business Objects Platform 4.0 SP4, Dashboard Designer, Business Objects Explorer, Windows 2008 Server.

Confidential

Sr. Business Objects BI 4.0 Architect Implementation

Responsibilities:

  • Installing the Business Objects Platform 4.0 SP13 Enterprise , Deploying Apache Tomcat Server and Configuring SSO Windows.
  • Design and Implementation of Security in BO 4.0.
  • Performed SAP Integration and enabled single sign-on. Implement the security with SAP Roles with Corporate Folders.
  • Optimize and performance tuning of Business Object Platform
  • Performance tuning of universes and reports.
  • Define and implement migration strategy using Promotion Management Tool LCM .
  • Installing Service packs and Patches on BO 4.0.
  • Migrate SAP Business Objects 4.0 SP4 to SAP Business Objects 4.1 SP2 and resolved the issues with security and migration problems.
  • Design Analytical Views and Calculation views on HANA Design studio.
  • Design Universe against HANA views.
  • Configure SAP Business Objects Mobile configuration MOBI on Windows Platform.
  • Define and create XML files for Advanced Analysis for Office installation package.
  • Install and configure SAP Business Objects Explorer on Windows platform.
  • Design Universe Using IDT Information Design Tool and build information spaces for Explorer.
  • Creating report mock-ups and providing best solutions by different reporting options BI 4.0 tools like WEBI against Universe, WEBI against BEx, Crystal Reports 2011, and Crystal Reports for Enterprise 4.0, Universe Designer, and Information Designer Tool.
  • Design Complex Dashboards against BEx queries and UNX Universes.
  • Working with BW Developers on implementing security using SAP User Exit and SAP Customer Exits to reduce query results and using Analysis Authorization Objects.
  • Design Complex Universe using IDT against Multiple data sources Demand Planning, Supply Planning and ECC.
  • Configure Data Federation Connection Configuration for better performance.
  • Created new and modified existing SAP BI Queries with Restricted Key figures and Calculated Key Figures.
  • Create LCM Jobs to promote Universe/Reports/Users/Roles to UAT.

Environment: SAP ECC 6.0, SAP BI 7.3, SAP BW on HANA, BEX Analyzer, BEX Report Designer, and Business Object XI 4.0 SP4, Crystal Reports 2011, Crystal Reports for Enterprise 4.0 SP5, and Business Objects Platform 4.0 SP5, Dashboard Designer, Business Objects Explorer, Windows 2008 Server, Oracle 11g.

Confidential

Sr. Business Objects BI 4.0 Architect Implementation

Responsibilities:

  • Installing the Business Objects Platform 4.0 SP4 and SP5 Enterprise , Deploying Apache Tomcat Server and Configuring SSO Windows.
  • Working with SAP BASIS team on Installing the Business Objects Platform 4.0 SP4 and SP5 Enterprise , Deploying Apache Tomcat Server and Configuring SSO on Linux.
  • Design and Implementation of Security in BO 4.0.
  • Performed SAP Integration and enabled single sign-on. Implement the security with SAP Roles with Corporate Folders.
  • Define and implement migration strategy using Promotion Management Tool LCM .
  • Installing Service packs and Patches on BO 4.0.
  • Configure SAP Business Objects Mobile configuration MOBI on Windows Platform.
  • Define and create XML files for Advanced Analysis for Office installation package.
  • Install and configure SAP Business Objects Explorer on Windows platform.
  • Design Universe Using IDT Information Design Tool and build information spaces for Explorer.
  • Creating report mock-ups and providing best solutions by different reporting options BI 4.0 tools like WEBI against Universe, WEBI against BEx, Crystal Reports 2011, and Crystal Reports for Enterprise 4.0, Universe Designer, and Information Designer Tool.
  • Define complex dashboard using BEx Queries, Flash Variables and Design dashboard home page custom user groups.
  • Working with BW Developers on implementing security using SAP User Exit and SAP Customer Exits to reduce query results and using Analysis Authorization Objects.
  • Working with BW Developers and MAP Merchandise Assortment Planning on implementing ETL and Designing BEx Queries for best performance.
  • Created new and modified existing SAP BI Queries with Restricted Key figures and Calculated Key Figures.
  • Create LCM Jobs to promote Universe/Reports/Users/Roles to UAT.

Environment: SAP ECC 6.0, SAP BI 7.0, BEX Analyzer, BEX Report Designer, and Business Object XI 4.0 SP4/SP5, Crystal Reports 2011, Crystal Reports for Enterprise 4.0 SP5, and Business Objects Platform 4.0 SP5, Dashboard Designer, Business Objects Explorer, Windows 2008 Server and Linux, Oracle 11g.

Confidential

Sr. Business Objects /Architect Implementation

Responsibilities:

  • Working with BW Developers implementing ETL and Designing BEx Queries for best performance.
  • Working with SAP BASIS team on Installing the Business Objects Platform 4.0 Enterprise and Deploying web apps on Apache Tomcat server and Configuring SSO.
  • Design and Implementation of Security in BO 4.0 SP 04.
  • Performed SAP Integration and enabled single sign-on. Implement the security with SAP Roles with Corporate Folders.
  • Install Business Objects 4.0 SP04 on sand box, perform pre-migration testing.
  • Migrate BO systems from SP02 to SP04. Import Security, Folders, Reports, and User Groups to New server.
  • Creating report mock-ups and providing best solutions by different reporting options BI 4.0 tools like WEBI against Universe, WEBI against BEx, Crystal Reports 2011, and Crystal Reports for Enterprise 4.0 SP04, Universe Designer, and Information Designer Tool.
  • Create LCM Jobs to promote Universe/Reports/Users/Roles to UAT.

Environment: SAP ECC 6.0, SAP BI 7.0, BEX Analyzer, BEX Report Designer, and Business Object XI 4.0 SP 04, Crystal Reports 2011, Crystal Reports for Enterprise 4.0 SP04, and Business Objects Platform 4.0 SP 04.

Confidential

Sr. Business Objects BI 4.0 Architect Implementation

Responsibilities:

  • Gathering requirements from users and performing analysis.
  • Working with SAP BASIS team on Installing the Business Objects Platform 4.0 Enterprise , Deploying Apache Tomcat Server and Configuring SSO.
  • Design and Implementation of Security in BO 4.0.
  • Performed SAP Integration and enabled single sign-on. Implement the security with SAP Roles with Corporate Folders.
  • Creating report mock-ups and providing best solutions by different reporting options BI 4.0 tools like WEBI against Universe, WEBI against BEx, Crystal Reports 2011, and Crystal Reports for Enterprise 4.0, Universe Designer, and Information Designer Tool.
  • Creation of Restricted key Figures, Calculated key figures, Filters, Variables, Selections and Formulas in BW Queries.
  • Working with BW Developers on implementing security using SAP User Exit and SAP Customer Exits to reduce query results and using Analysis Authorization Objects.
  • Created highly complex interactive Web Intelligence Reports such as Column hiding, dynamic tables with Input Controls, Reports filter, Element Linking and Hyperlinks for User Analysis.
  • Create Universe using Universe Designer against SAP BI/BW BEx Queries.
  • Working with BW Developers and Integrated Planning Developers on implementing ETL and Designing BEx Queries for best performance.
  • Created new and modified existing SAP BI Queries with Restricted Key figures and Calculated Key Figures.
  • Design complex dashboards using Dashboard Designer XCelsius against Query as Web Service, Live Office and Crystal Reports as Data source.
  • Validating of report data with the back end data, by running queries over the cubes and by running the BW Queries in RSRT
  • Validating report data in ECC by functional transaction codes.
  • Create LCM Jobs to promote Universe/Reports/Users/Roles to UAT.

Environment: SAP ECC 6.0, SAP BI 7.0, BEX Analyzer, BEX Report Designer, and Business Object XI 4.0 SP2, Crystal Reports 2011, Crystal Reports for Enterprise 4.0 SP2, and Business Objects Platform 4.0 SP2.

Confidential

Lead Business Objects BI Developer

Responsibilities:

  • Gathering requirements from users and performing analysis on ECC 6.0.
  • Created complex Web Intelligence reports containing combination charts and tables with multiple providers of SAP and SQL Server.
  • Created complex Web Intelligence Reports with Input Controls and Reports filters for User Analysis.
  • Create Universe using Universe Designer against SAP BI/BW Cubes.
  • Create complex reports against SAP ECC 6.0 Tables and ABAP Function modules using Crystal Reports.
  • Performed SAP Integration and enabled single sign-on. Implement the security with SAP Roles with Corporate Folders.
  • Design complex dashboards using Dashboard Designer XCelsius against Query as Web Service, Live Office and Crystal Reports as Data source.
  • Scheduling the reports with .Net SDK using JAMS application.
  • Create and Manage Information Spaces in Business Objects Explorer.
  • Created new and modified existing SAP BI Queries.
  • Create Users, Groups, Folders and Categories and provided securities.
  • Create LCM Jobs to promote Universe/Reports/Users/Roles to UAT and Production

Environment: SAP ECC 6.0, SAP BI 7.0, BEX Analyzer, BEX Report Designer, Business Object XI 3.1 SP3, Crystal Reports 2008, and Business Objects Enterprise XI 3.1 SP3.

Confidential

Senior/Lead Business Objects BI Developer Implementation

Responsibilities:

  • Created complex Interactive Analysis Web Intelligence reports containing combination charts and tables with multiple providers of SAP and SQL Server.
  • Create Users, Groups, Folders and Categories and provided securities.
  • Create Universe using Universe Design Tool Universe Designer against SAP BI/BW Cubes.
  • Created complex master details reports in Interactive Analysis.
  • Developed reports against SAP BI Cubes OLAP , Multi provider and ODS.
  • Create complex reports against SAP ECC 6.0 Tables and ABAP Function modules and tables.
  • Developed heavy complex reports using various features like Custom formulas Interactive Analysis..
  • Created Highly Complex, Custom Line Graphs, Bar Charts with shared data of main and sub reports data using Crystal Reports 2011 and Crystal Reports for Enterprise BI4.0.
  • Extensively used shared variables between sub report and main report.
  • Created complex dashboard using Business Objects Dashboard Design tool.
  • Create complex dashboards against Qaaws, BEx Queries, and Universes using Dashboard Designer.
  • Created new and modified existing SAP BI Queries.
  • Design Dashboard using BEx Queries.
  • Create LCM Jobs to promote Universe/Reports/Users/Roles to UAT and Production

Environment: SAP ECC 6.0, SAP BI 7.0, BEX Analyzer, BEX Report Designer, Business Object BI 4.0, Crystal Reports 2011, Crystal Reports for Enterprise BI4.0, and Business Objects Enterprise BI 4.0, Information Designer, Interactive Analysis and Dashboard Designer.

Confidential

Senior/Lead Business Objects Developer

Responsibilities:

  • Wrote queries in SAP BI Queries for reporting using BEX Query Designer.
  • Created complex Web Intelligence reports containing combination charts and tables with multiple providers of SAP and SQL Server for Finance.
  • Create Universe against SAP BI/BW Queries.
  • Created complex master details reports in Web Intelligence XI R3.1.
  • Developed reports against SAP BI Cubes OLAP , Multi provider and ODS.
  • Developed heavy complex reports using various features like Custom formulas, multiple grouping, drill down, Cross Tab, Alerts using Web Intelligence.
  • Created Highly Complex Crystal Reports 2008.
  • Created complex dashboard using XCelcius 2008
  • Created new and modified existing SAP BI Queries.

Environment: SAP BI 7.0, BEX Analyzer, BEX Report Designer, Web Application Designer, and Business Object XI 3.1 SP3, Crystal Reports 2008, and Business Objects Enterprise XI R 3.1

Confidential

Lead. Business Objects Developer Migration and Implementation

Responsibilities:

  • Actively worked with End Users in gathering user requirements and Converting Business Requirements into Functional Requirements.
  • Create complex Web Intelligence Reports XI 3.1 against multiple data providers.
  • Created complex reports by providing dynamic prompts and enhanced visualization and Interactive sorting using Crystal Reports 2008.
  • Design and develop Business Objects Universe in Designer 3.1
  • Designing dashboards using Crystal Reports content and XCelsius.
  • Migrate Full client reports, universes from BO 6.5 to Business Objects XI 3.1 using Import wizard.
  • Converting Desktop Intelligence Full Client reports to Web Intelligence XI 3.1 Using Report Conversion Tool.
  • Identify the user groups, categories, securities on BO 6.5 and Created User Groups, Users, Categories and Access Levels.
  • Manage securities on Universe level by Row, User level and user groups.
  • Identifying the issue with the migration, report conversion and perform modifications to the reports.
  • Create complex reports using Web Intelligence XI 3.1.
  • Developed complex reports using Local, Global, and Shared Variables and shared the data between main and sub reports.
  • Developed heavy complex reports using various features like Custom Functions, multiple grouping, drill down, Cross Tab, parameterized fields, formulas, conditional formatting and Shared variables using Crystal Reports 2008.
  • Create LCM Jobs to promote Universe/Reports to UAT and Production.
  • Prepare technical documents and user guide.
  • Performed Unit test the reports to verify the numbers and analyzing the performance.

Environment: Business Objects XI 3.1, Crystal Reports 2008, Business Objects Enterprise XI 3.1, Oracle 10g, Sub version, Solaris, Life Cycle Manager.

Confidential

Sr. Data Analyst/ Business Objects/Crystal Reports Developer

Responsibilities:

  • Actively worked with End Users in gathering user requirements and Converting Business Requirements into Functional Requirements.
  • Created complex stored procedures and data base views in SQL Server 2005.
  • Create complex Web Intelligence Reports against multiple data providers.
  • Created complex reports by providing dynamic prompts and enhanced visualization and Interactive sorting using Crystal Reports 2008.
  • Design and develop Business Objects Universe in Designer 3.1
  • Designing dashboards using Crystal Reports content and XCelsius.
  • Create complex reports using Desktop Intelligence and Web Intelligence
  • Developed complex reports using Local, Global, and Shared Variables and shared the data between main and sub reports.
  • Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe
  • Developed heavy complex reports using various features like Custom Functions, multiple grouping, drill down, Cross Tab, parameterized fields, formulas, conditional formatting and Shared variables using Crystal Reports XI R2 and 2008.
  • Integrated the reports into Visual Basic.Net applications using SDK.
  • Created workflow documents using Visio.
  • Prepare technical documents and user guide.
  • Performed Unit test the reports to verify the numbers and analyzing the performance.

Environment: Crystal Reports 2008, Business Objects 3.1,Business Objects Enterprise 3.1, SQL Server 2005, Clear Case, MS Access 2003, Visual Basic.NET, SSIS, DTS, Microsoft Visio, XCelsius 2008, Mercator, Plexis and Atlantis.

Confidential

Lead Crystal Reports Developer / Business Objects Administrator

Responsibilities:

  • Created complex reports by providing dynamic prompts and enhanced visualization and Interactive sorting using Crystal Reports 2008.
  • Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
  • Created complex Web Intelligence reports using the multiple data providers and synchronized the data providers by linking the common dimensions to create the common report.
  • Installation and set-up of Business Objects Enterprise 3.0.
  • Installed and configured Crystal Enterprise 9.0.
  • Create complex reports using Desktop Intelligence and Web Intelligence XI 3.0.
  • Developed complex reports like drill down, Slice and Dice, master/detail for analysis in Web Intelligence.
  • Designing dashboards using Crystal Reports content and Xcelsius 2008 and Web Intelligence documents.
  • Developed complex reports using Local, Global, and Shared Variables and shared the data between main and sub reports.
  • Developed heavy complex reports using various features like Custom Functions, multiple grouping, drill down, Cross Tab, parameterized fields, formulas, conditional formatting and Shared variables using Crystal Reports XI R2 and 2008.
  • Migrate and Imports Universes, Web Intelligence Reports, Crystal Reports and Desktop Intelligence Reports from XIR2 to 3.0 using Import wizard.
  • Migrated users, groups and securities from Business Objects Enterprise XIR2 to Business Objects Enterprise 3.0.
  • Resolved the issues with Business Objects Enterprise Configuration.
  • Actively involved in database migration from SQL Server 2000 to SQL Server 2005.
  • Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
  • Design, Develop and Implementation of Window Applications using Visual Basic .net
  • Worked on MS Access and VBA applications.
  • Designed reporting structure and implement using SQL Server, Visual Basic.Net and Crystal Reports for distribute over 1000 of reports to users.
  • Created complex stored procedures and data base views in SQL Server 2005.
  • Created and maintained complex DTS Packages to load data from FTP locations.
  • Migrated tables, views, procedures and DTS packages.
  • Created and maintained complex SSIS Packages.
  • Configured the user setting for LDAP Users.
  • Created user groups, users and provide securities.
  • Prepare technical documents and user guide.
  • Performed Unit test the reports to verify the numbers and analyzing the performance.

Environment: Crystal Reports 2008, Crystal Reports 9/XI R 2, Business Objects Xi R2/3.0, Business Objects Enterprise XI R2/3.1, SQL Server 2005, J2EE, HTML, and JSP, PVCS, Clear Case, MS Access 2003, Visual Basic.Net, SSIS, DTS, Microsoft Visio, XCelsius, Websphere 6.1.

Confidential

Senior Business Objects/Crystal Reports Developer

Responsibilities:

  • Actively worked with Business Analyst and End Users in gathering user requirements.
  • Worked closely with the users.
  • Wrote queries in SAP BI Queries for reporting using Business Explorer Query Designer.
  • Created complex stored procedures and data base views in SQL Server 2000.
  • Created complex Web Intelligence reports containing combination charts and tables with multiple providers of SAP and SQL Server product supply and supply chain inventory details trending for multiple years.
  • Created complex master details reports in Web Intelligence XI R2.
  • Developed reports against SAP BW/BI Cubes OLAP , ODS, SAP BI, SQL Server, and Oracle and Access database.
  • Migration of the Universes, Web Intelligence Reports and Crystal Reports from SAP BW 3.0 to SQP BI 7.
  • Experience working with SAP Administrator Workbench.
  • Developed complex reports using Local, Global, and Shared Variables and shared the data between main and sub reports in Crystal Reports XI R2.
  • Developed heavy complex reports using various features like Custom formulas, multiple grouping, drill down, Cross Tab, Alerts using Web Intelligence.
  • Created Highly Complex, Custom Line Graphs, Bar Charts with shared data of main and sub reports data using Crystal Reports XI R2 for Analysis.
  • Created new and modified existing SAP BI Queries.
  • Performed Unit test the reports to verify the numbers and analyzing the performance.

Environment: SAP BW 3.0, SAP BI 7.0, BEx Analyzer, BEx Report Designer, Web Application Designer. Crystal Reports 10/XI, Crystal Enterprise 10, Business Objects Enterprise XI R2, SQL Server 2000, Access 2000, Oracle 9i.

Confidential

Senior Crystal Reports Developer

Responsibilities:

  • Actively involved in gathering user Requirements, User/System Documentation, user training and testing developed reports for final deployment.
  • Worked under minimal directions.
  • Wrote the script to create Tables and Views for reporting database while installation of the product.
  • Wrote complex stored procedures in SQL Server 2000/2005 for Data Mining into report tables from a large database.
  • Maintained data mining data for trending analysis.
  • Worked with Rational Clear Quest, Clear Case and UCM Unified Change Management .
  • Designed and developed over 40 complex reports using Crystal Reports XI R2.
  • Developed reports using JDBC Driver to integrate into Java UI.
  • Wrote Java classes using JRC Java Reporting Component to export the reports in to specific formats based on Scheduler.
  • Developed several complex reports using various features like multiple grouping, drill down, parameterized fields, formulas and conditional formatting using Crystal Reports XI.
  • Created Complex Charts, Graphs using Crystal Reports XI R2 for Trending Reports.
  • Created complex views and wrote queries for Graphical Analysis Reports with Bar Charts that shows the index of life cycle of the domains for Dashboard.
  • Wrote SQL queries that can use by QA team to provide queries to evaluate report results.
  • Worked closely with QA team to test the Quality Analysis and Performance Analysis.
  • Prepared documentation to support deployment and document program and system functions.
  • Prepared the trouble-shooting guide for tech-support.
  • Trained other developers for production support.

Environment: Crystal Reports XI R2, SQL Server 2000/2005, Java 2, and Documentum, Clear Case, Clear Quest, UCM Unified Change Management .

Confidential

BO/Crystal Reports Developer

Responsibilities:

  • Actively involved in gathering end user Requirements, User/System Documentation, user training and testing developed reports for final deployment.
  • Created Complex Charts Graphs using Crystal Reports v10 and XI.
  • Created Complex reports by sharing data between sub-reports and designing graphs using shared data.
  • Scheduled the creation of reports using Crystal Enterprise v10, Business Objects Enterprise XI.
  • Wrote complex queries, functions, and procedures in SQL Server 2000.
  • Developed several complex reports using various features like multiple grouping, drill down, parameterized fields, formulas and conditional formatting using Crystal Reports XI and 10.
  • Troubleshoot/research stated issues with reports currently in the production environment
  • Ongoing maintenance reports in the production environment
  • Develop ad hoc reports in Crystal Reports v10 and XI
  • Create data extracts on Crystal Reports XI and 10 and Business Objects Enterprise, for internal Research and Development and Weight Management use.
  • Published reports to Business Objects Enterprise XI.
  • Actively involved in migrating reports, users, user groups, events from Crystal Enterprise 10 to Business Objects Enterprise XI
  • Imported Windows users and user groups Using LDAP.
  • Created events and scheduled reports based on events.
  • Installation and set-up of Business Objects Enterprise XI in development environment
  • Create Business Object Universes and developed reports against the universe.
  • Created Web Intelligence reports in Business Objects Enterprise XI for Business Managers.
  • Trained end users on Business Objects Enterprise XI.

Environment: Crystal Reports XI/10, Business Objects Enterprise XI, Crystal Enterprise v10, SQL Server 2000.

Confidential

Reports Developer

Responsibilities:

  • Creating complex reports using Crystal Reports v10.
  • Created Charts, graphs in Crystal Reports v10.
  • Wrote complex stored procedures, functions in Oracle 9.
  • Actively involved in gathering end user Requirements, User/System Documentation, user training and testing developed reports for final deployment.
  • Developed User Interface using VB.Net.
  • Integrated reports into .Net Application.
  • Deployed the .Net Application from development environment to testing and production environment.
  • Trained the users on Crystal Reports v10 and .Net Application.

Environment: Crystal Reports 10, Visual Basic.Net, Oracle 9i, Windows 2003 Server.

Confidential

Crystal Reports Developer

Responsibilities:

  • Analyzed the requirements
  • Actively involved in gathering end user Requirements, User/System Documentation, user training and testing developed reports for final deployment.
  • Created reports using Crystal Reports Version 10.
  • Created Views and Developed reports with the combination of over 20 tables.
  • Developed Sub Reports, on demand sub reports by using Crystal Reports 10.
  • Wrote stored procedures and developed reports using procedures.
  • Worked with Datasets and Data Adapters in VB.Net for data retrieval.
  • Created Queries, Sub-Queries for retrieval of Data.
  • Handled validations through the Events in VB .Net.
  • Used drop down, combo boxes, and lists in the Forms.

Environment: Crystal Reports 10, SQL Server, MS Access 2000, VB .Net, CVS Concurrent Versions System , Windows NT.

Confidential

Programmer/Analyst

Responsibilities:

  • Analyzed the business requirements and created Business Model
  • Developed several complex reports using various features like multiple grouping, drill down, parameterized fields, formulas and conditional formatting using Crystal Report 9.
  • Implemented charts and graphs like Bar Charts, Pie Charts, Line graphs for financial reports using Crystal Experts of Crystal Report 9/8.5

Environment: Crystal Reports 9/8.5, Crystal Analysis Seagate Info 7.0, SQL Server, ASP, VBA, MS Access 2000, Windows 2000.

Confidential

Programmer/Analyst

Responsibilities

  • Created ASP pages to generate parameterized reports.
  • Deployed reports on the web using Crystal Publishing Wizard and scheduled reports using ePortfolio and Management Console.
  • Involved in the administration of Management Console for implementation of security at Report level, Folder level. Created Users, user groups, roles.
  • Wrote stored procedures in PL/SQL.

Environment: Crystal Enterprise 8.5, Crystal Reports 8, Oracle 8i, ASP, Visual SourceSafe, VBScript, JavaScript and Windows NT/2000/XP.

Confidential

Programmer/Analyst

Responsibilities Developed big and complex reports, sub reports by creating complex Formulas, Charts and Cross Tab.

  • Created Reports using Crystal reports 8.5 with Grouping, Sorting, Formula fields, Parameter fields, Linked and Unlinked Sub-reports.

Environment: Crystal Enterprise 8.5, Crystal Report 8.5, ASP, MS Access 2000, SQL Server, VBScript, JavaScript, Window NT.

Confidential

Programmer/Analyst

Environment: Java Servlets, JDBC, HTML, DHTML, Oracle 7, Windows 'NT, Crystal Reports 7, JavaScript.

Confidential

Programmer/Analyst

Responsibilities:

  • Designed Several GUI Forms using VB6.0 for the end user.
  • Implemented Client to work like a standalone Application with VB 5.0.

Environment: Visual Basic 5.0, Active Server Pages, Crystal Reports 7, Windows NT, MS Access and Oracle 8.

We'd love your feedback!