We provide IT Staff Augmentation Services!

Sr.bi/crystal Reports Developer Resume

Santa Clara, CA

TECHNICAL SKILLS:

Crystal Reports XI: PL/SQLOracle 11g DatabaseVisual Studio Team Foundation Developer's SuiteMicrosoft .NET 3.0ASP.NETC#VB.NET

Business Objects platform: Business Intelligence (Cloud Base)Ability to engage with clientQuality Assurance

Project Management Skills: 1 - Basic

Mobile Technologies: 1 - Basic

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

Sr.BI/Crystal Reports Developer

Responsibilities:

  • Involved in full life cycle development and implementation of SAP BI 4.0. Worked in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Customer and Training to Go Live.
  • Assist SAP BASIS team in the up gradation of BO XI 3.1 to BI 4.0 and Installation of Crystal Reports 2011.
  • Lead an Offshore team of 4, assign tasks on bi-weekly basis and review their work regularly.
  • Created complicated reports including Sub-reports, Parameters, Graphical reports, Drill-down, Formula-based and well formatted reports using Crystal Reports XI for Enterprise and Crystal Reports 2011.
  • Created various PL/SQL Stored Procedures, views, Functions and temporary tables for data input into crystal reports.
  • Created Cross Tab Reports, Pie and Bar Charts, and Parameter Reports, Running totals, Sub Totals and embedded linked and unlinked sub-reports to separate and organize key information and to promote reusability in data reporting.
  • Coordinated with the report users on Periodic basis about the scheduled reports for Data Validation.
  • Deployed reports on the web using Crystal publishing wizard and schedule reports using Crystal Management console.
  • Automated reports for weekly, monthly and yearly schedule using Crystal Reports and delivered via Adobe PDF format. Exported reports to various formats like PDF, Excel, and HTML.
  • Designed, Developed and Maintained Universes by defining Joins, Cardinalities between tables applying Contexts and Alias tables to remove cyclic dependencies.
  • Created Business layer using Data Foundation with defined Functions including Aggregate Awareness, Prompts, Where and Select in creating the Dimensions and Measures and Conditions.
  • Created Universes on top of Calculation views in SAP HANA and developed WebI reports and Dashboards using Information Design Tool (IDT).
  • Developed Complex WebI reports using combined queries, merging dimensions, complex functions and applying filters at the report level to meet the end user requirement.
  • Perform the integrity test of the universes and exported to the repository to make the universes available to the users and groups, and created Ad hoc reports by accessing the universe.
  • Created Row level, Report level and Object level security in the universe as a part of Business Objects Security and Development.
  • Had experience on dealing with client and Project Management Skills.
  • Created complex reports by using Master-details, Cross-tabs, Slice and Dice, Drill mode as per the Business requirements.
  • Designed Dashboards using Query as a Web Service (QaaWS) and live office.
  • Created graphical representation of reports such as Line charts, Bar charts, Pie charts, Column, stacked column charts, and Bubble charts using Xcelsius 2008.
  • Published the reports to Central Management Console (CMC) and involved in scheduling and exporting the reports in different formats (CSV, Excel, PDF and XML) as per the client requirement.
  • Setup guidelines and standards for development of Reports to improve quality assurance and consistency of the reports across various environments.
  • Moved the developed Universes, WebI reports, Dashboards between Development, Quality and Production environments using Promotion management.
  • Created various WebI documents to display in Spark line charts, trend charts, and Crystal reports and make them accessible in SAP BO Mobile 4.1 and Ipad 4.1.
  • Developed testing scripts and Involved in Unit testing and UAT testing for the universes, reports and security management.
  • Involved in the end-user training/support over the newly developed WebI reports by creating the documentation for the end user reference.

Environment: SAP Business Objects 4.0 SP2/SP4/SP6 (IDT, UDT, WEBI, Business Intelligence, Dashboards, Xcelsius, Crystal Reports) SAP HANA 1.0 SP6, SAP ECC 6.0, SAP BW 7.3, TFS, Visual Studio, .Net 3.0 Framework, ASP.NET, C#, VB.NET, and Oracle 11g.

Confidential, Houston, TX

Role: SAP Crystal Report Developer

Responsibilities:

  • Analyzed users need, design and develop various decision support reports and applications for optimum performance.
  • Involved in the requirements gathering, design and development of PVM (Price Volume Mix) Customer Profitability projects.
  • Designed and developed the DSOs (Write-Optimized and Standard), Cubes and Multi-providers for Pricing, Billing and COPA data.
  • Designed Cross-tab reports with Sub-reports and Chart reports. Reports were based on command objects and wrote SQL queries as per the business requirement.
  • Created complex reports using Crystal Reports Formulae, Grouping, Selection criteria, Running totals and Sub-totals.
  • Developed various Charts and Graphs like Bar Chart (stacked, side-by-side), Line Graphs by using Chart expert in Crystal Reports XI.
  • Developed Crystal reports for Sales and Sub-sales reports for Daily, Weekly, MTD and YTD.
  • Designed around 30 Crystal Reports with complex Formulae, Parameters and sub-reports involved.
  • Worked extensively with the major Business object functionalities like Breaks, Group values, Sorts, List of Values, Predefined conditions, calculations and ranking using WebI 4.0
  • Involved in Performance Tuning and Optimization of Business objects Universes by creating aggregate tables.
  • Setup guidelines and standards for development of Reports to improve quality assurance and consistency of the reports across various environments.
  • Worked with SAP Basis team in upgrade activities from BO 3.1 to 4.0.
  • Had experience on dealing with client and Project Management Skills.
  • Created Web Intelligence, Crystal reports and Xcelsius reports for various data sources.
  • Migrated Web Intelligence reports from SAP Business Objects 3.1 to 4.0.
  • Create authorization objects/roles to distribute the WebI, Xcelsius and Crystal reports.
  • Used Central Management Console for deploying and managing the reports.
  • Created complex SQL scripts, procedures and Cursors.
  • Updated flexible queries to report liabilities and receivables at Branch, Branch/Company, and product and Payment Method level.
  • Extensively used Reporting Agent and Information Broadcasting in Scheduling reports and in data validation process chains.
  • Involved in Transportation of all BI Objects like: Info objects, Transformations, DTPs, Info Cubes, DSO objects, and process chains into receiving system and fixed transport bugs.
  • Working as Production support in resolving tickets and tasks such as load monitoring issues, user issues and enhancements of existing objects.
  • Prepared Go-Live Cut over tasks and provided end user training.

Environment: Business Objects 3.1/4.0 SP2, WebI, Business Intelligence, Crystal Reports, Xcelsius 2008, SAP BODS 4.0, TFS, Visual Studio, .Net 3.0 Framework, ASP.NET, C#, VB.NET, Oracle 11g, SQL Server 2008, Pl/SQL.

Confidential

Sr. BI/BOBJ developer

Responsibilities:

  • This is a full life cycle SAP BI implementation project and was involved in Business Blue Print preparation, Business requirements gatherings, functional design documents & technical design documents preparation.
  • Extensively worked in End-user’s requirements, Business Data Requirements, Studied and analyzed them.
  • Involved in enhancing the existing BW object like DSO, Infocubes, Multiproviders for spend and purchasing reports.
  • Identified data modeling techniques, and designed Info Cubes and ODS an object, as well as different aspects of time-dependant and non-time-dependant master data attributes.
  • Production support for the nightly batch jobs to meet the SLA's.
  • Had experience on dealing with client and Project Management Skills.
  • Worked on change requests in the existing design of SAP BW in the areas of Purchasing, Shopping carts and Account payables.
  • This includes enhancing the existing BW objects, creating new BW. Involved in requirement gathering and data analysis for reporting from business users.
  • Created High-level and Detail-level documentation of the project.
  • Designed various Universes on various Relational & OLAP Data sources using Universe Design Tool (UDT) to build Symantec Layers for the ease of use in Reporting.
  • Designed and published various reports using Crystal Reports XI Enterprise Server (Master/Detail, Cross Tab and Drill Down reports) based on client’s requirements to display the data such as verified claims by Distributor, By Dealer with Core Logic Results.
  • Designed Dashboards using Query as a Web Service (QaaWS).
  • Setup guidelines and standards for development of Reports to improve quality assurance and consistency of the reports across various environments.
  • Engaged in design discussions for all Business Intelligence and Database initiatives.
  • Tracking of data using data tracking options during report development.
  • Worked on OLAP Universes with SAP BW Query and SAP BW Info Cube as Data source.
  • Build the new universes as per the user requirements on top of SAP BEX queries by defining the universe connections and pointing the objects to universe.
  • Worked on Crystal/Webi reports which leveraged data from R/3 and SAP BI.
  • Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, reports schedule for different file based / schedule based events, distribute in email, PDF and HTML format.
  • Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.
  • Performed extensive unit testing for new and existing reports including Data Validation, Data Integration before deployments of reports to Production.
  • Created hierarchy for Drill down/up reports and applied grouping for analysis of the report data for end users.

Environment: SAP Business Objects 3.1/4.0, Business Intelligence, Crystal Reports Enterprise, Webi, Dashboards, IDT, BODS, Dashboards, BO Explorer, SAP BW 3.5, TFS, Visual Studio, .Net 3.0 Framework, ASP.NET, C#, VB.NET, Pl/SQL, Oracle 11g/10g and SQL server 2008

Confidential, Rochester, NY

BI/BOBJ Reports Developer

Responsibilities:

  • Identifying Data problems of conversion Data and giving cause of analysis (Reconciliation).
  • Worked on OLAP Universes with SAP BW Query and SAP BW Info Cube as Data source.
  • Build the new universes as per the user requirements on top of SAP BEX queries by defining the universe connections and pointing the objects to universe.
  • Worked on Crystal/Webi reports which leveraged data from R/3 and SAP BI.
  • Created Linked, Unlinked, Parameterized and On-demand sub reports for various business needs, reports schedule for different file based / schedule based events, distribute in email, PDF and HTML format.
  • Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.
  • Created hierarchy for Drill down/up reports and applied grouping for analysis of the report data for end users.
  • Involved in Unit testing, System testing and User Acceptance Testing of reports throughout the migration process.
  • Format the raw data retrieved from Universe Objects in Xcelsius spreadsheet using VLOOKUP, IF, AND, OR, CONCATENATE and many other excel formulae/functions that are supported in Xcelsius.
  • Designed Universes for various business needs and resolved Chasm trap, Fan traps using Contexts & Aliases.
  • Created Cardinalities, Joins, Contexts and Aliases for resolving Loops, Traps and checked the Integrity of the Universe. Analyze all tables and created various indexes to enhance query performance.
  • Worked extensively with the BA teams to resolve the issues and plan and execute the releases.
  • Involved in five UAT parallel and Two Mini parallel testing of Reports, Universes, Modules and performed validation and testing of the Daily data and Month End Closure data.
  • Maintained BOE servers day to day and troubleshoot server issues.
  • Wrote PL/SQL code using the technical and functional specifications.
  • Performed numerous data pulling requests involving SQL scripts, UNIX, TOAD
  • Analyzing the bugs reported by users, fixing and migrating code to production and documenting the changes made to original code.

Environment: Business Objects Enterprise XI3.1, Business Intelligence, Web Intelligence XI3.1, BO Dashboard Manager, Crystal Reports XI/2008, PeopleSoft 9.1, TFS, Visual Studio, .Net 3.0 Framework, ASP.NET, C#, VB.NET, Oracle 10G, Windows NT, MS Office 2007, SQL, PL/SQL, Toad 8.6.1

Confidential, Los Angeles, CA

BO/Crystal Reports Developer

Responsibilities:

  • Involved in requirement gathering and data analysis for reporting from business users.
  • Created High-level and Detail-level documentation of the project.
  • Involved in the upgrade of Crystal Reports Enterprise to Business Objects Enterprise XI3.
  • Migrated folders, sub-folders and objects using the import wizard from Crystal Reports 10 to Business objects XI3
  • Setup users and groups in CMC and created user profiles
  • Modify reports from Crystal Reports 10 to Business Objects XI3
  • Created reports using Universe, Free-Hand SQL, and Stored Procedures and Data providers.
  • Designed, developed and tested complex stored procedures for crystal reports XI distribution
  • Built and performed user acceptance testing (UAT) on modified reports.
  • Maintained and managed all the maintenance of the DEV, QA and PROD BOE servers
  • Loading Data into Multiple Database environments using PL/SQL Packages
  • Developed PL/SQL triggers and program units within these forms,
  • Used SQL, PL/SQL, Packages, Functions/Procedures, Database Triggers, and Advanced Queues as Oracle Back-end.
  • Customized the PL/SQL script to automate pricing Setups without manual intervention.
  • Performed numerous data pulling requests involving SQL scripts, UNIX, TOAD.
  • Involved in the analysis, and did modifications for existing test plans and test cases.
  • Writing PL/SQL code using the technical and functional specifications.

Environment: Crystal Enterprise 10, Business Objects Enterprise XI3.1, Oracle 9i, DataStage 7.5, Windows 2000, MS Office 2003, SQL, PL/SQL, UNIX, Toad 8.6x, PVCS Version Control Manager and Lotus Notes.

Confidential, MI

BO Reports Consultant

Responsibilities:

  • Working in the Home and Office Delivery Division as Business Objects Enterprise Administrator and Reports Specialist.
  • Meet with Business users to understand and analyze business requirements.
  • Installation & Configuration of Business Objects XIR2 Enterprise Suite of Products for Production Environment.
  • Responsible for Business Objects Servers maintenance using CMC, CMS.
  • Defined Complex Security set up for end users, groups using CMC and configured rights.
  • Designed universes and Sales Marketing reports, standard and adhoc reports, and organizational charts on top of those universes.
  • Designed, developed and tested complex stored procedures for crystal reports XI distribution.
  • Developing, creating, and testing the universes for running the queries against the database.
  • Extensively used calculations, variables, breaking slicing and dicing for creating business objects reports.
  • Worked on Hierarchy levels and developed hierarchies to support drill down reports.
  • Created different type of reports such as Master/detail, Cross-tab and chart depending on the business requirement.
  • Created formulas using Crystal syntax and basic syntax.
  • Created live office reports from existing crystal reports.
  • Involved in complete software development life cycle from Requirement analysis to UAT and Maintenance.
  • Worked with the ETL team in solving issues using SQL Server Integration Services (SSIS).
  • Converted functional specifications to technical documents, prepared Unit Test Cases and Unit test results.
  • Used APOS - Info Scheduler and Instance Manager to Schedule, Refresh and Distribute Reports & maintaining Instances of financial reports for at least 90 days.

Environment: Business Objects XIr2, Crystal Enterprise 10/XIr2, Crystal Analysis Services 10, SQL Server 2000/2005, SSIS, SSRS, OLAP Cubes, Windows 2000, APOS - Info Scheduler, APOS-Instance Manager, SQL, PL/SQL.

Hire Now