Business Object/Crystal Report Developer Resume

Title
Business Object/Crystal Report Developer

Primary Skills
Crystal Report, Business Object, SAP BW, .Net, SQL Server, Oracle

Location
US-NY-Buffalo (will consider relocating)

Posted
Apr-05-09


PROFESSIONAL SUMMARY
• Business Object/Crystal Reports/SAP BW Developer with over five years experience in Information Technology industry.
• Expert in handling Crystal, Xcelius, Business Objects, SAP Business Warehouse and SAP ECC development.
• Experience in developing ASP.NET web application with Crystal Report using C# language.
• Two complete cycle of SAP ECC and SAP BW implementation.
• Experience in working with warehouses SAP Business Warehouse 3.5 and 7.0 and Microsoft OLAP Analytical services.
• Experience with Business Objects Enterprise XI tools like Crystal Management Console, Crystal Repository and Business Object Infoview.
• Extensive experience in creating Xcelcius Dashboard from a Crystal Report and automating the data flow using Business Object Live Office.
• Experience in the total life cycle of software development involving Requirements, Analysis, Specification, Design, Development, Testing, Quality, Installations and Maintenance.
• Experience in designing and implementing reports using Crystal Reports, Crystal Enterprise, Business Objects, MS Reporting Service.
• Extensive experience with SAP BW and Business Object Crystal Report like designing reports, automating report and scheduling reports.
• Extensive experience with reporting tool such as BEx Query designer, BEx Analyzer, Crystal Xcelcius and Business Object Live Office.
• Automating Xcelcius Dashboard using Web Service to pull data from SAP ECC, SQL Server, and Oracle database.
• Conversant and confident with languages like JAVA, .NET, C, C++, HTML, XML languages.
• Experience with Relational Databases and experience in creating, maintaining Stored Procedures, Views, Functions, Triggers.
• Extensive programming experience in SQL, T-SQL and multidimensional query using databases Oracle, SQL Server, MS Access, MY SQL.
• Experience in Excel modeling for Xcelcius Dashboard design.
• Excellent ability in writing specifications and gathering requirements from the user to develop Crystal Reports as per the needs of the client and maintain documentation of the reports for future reference.
• Experienced in conducting design sessions to evolve system specifications and test plans with the ability to handle training sessions and documentation.
• Excellent problem resolution skills with ability to work under pressure in a highly visible role.
• Aptitude for analyzing, testing, debugging code, identifying problems and creating solutions.
• Excellent Time Management skills.
• Good Team Player with excellent communication skills.
Combined Skillset:
• C# .NET development with Crystal Report.
• Business Object Xcelcius development with Crystal Report and Web Service.
• Crystal Report development with SAP BW.
• Crystal Report development with SAP ECC.

SKILLS SUMMARY
Tools Experience
Database Oracle, SQL Server, Access 3 Years
Data Warehouse SAP BW 7.0, Microsoft Analysis Service 2 Years
ERP System SAP, PeopleSoft 2 Years
Operating System Windows 98, XP, 2000, 2003 5 Years
Programming Languages C++, C#, Java 2 Years
Reporting Tool Microsoft Report Services, Crystal Report, Crystal Xcelcius, Business Object, BEx Query, BEx Analyzer 3 Years
OLAP Tool Business Object Voyager 1 Year
Other Tools Microsoft Project, Microsoft Visio 1 Year
Web Technologies HTML, XML, ASP.Net 2 Years


EXPERIENCE SUMMARY

New Era, Buffalo, NY Nov 2007 -- Present
Role: Crystal Report Developer/SAP BW Developer
New Era is the leading cap manufacturing company with its presence all over the globe. New Era has a PeopleSoft ERP system which is migrated to SAP. All financial, sales, retail and other reporting needs to be converted from existing PeopleSoft to SAP system. New reports to be created based on the requirements from various departments and SAP standard queries and Standard cubes. The SAP implementation has been done in two phases UK and US.

Responsibilities:
• Worked as a Business Analyst for requirement gathering for business and functional reporting.
• Developed Crystal Reports from SAP BW (Business Warehouse) using BEx Query as the extraction tool.
• Created Xcelcius Dashboard from Crystal Report and BEx query as the data source.
• Automated Xcelcius Dashboard using Business Object Live Office to extract data from Crystal Report stored on Crystal Server.
• Created Business Object Voyager workspace with SAP BW cubes and Microsoft OLAP cubes as the data source.
• Created .NET web application for Crystal Report using C# as the programming language.
• Created Crystal Reports with ole object extracting image file from the database and URL links.
• Created custom formulas to display RGB colors in crystal reports.
• Created reports with dynamic grouping based on parameters.
• Migrated all reports generated from PeopleSoft system to SAP system.
• Validated the Crystal Report by writing queries against the transactional system.
• Customized the formatting of the Crystal Report using formula's at the section level.
• Created formula's for Crystal Report and stored it on the Crystal Repository to be used across the organization.
• Designed logic for Xcelcius Dashboard in Microsoft Excel using Crystal Report.
• Extracted data source for cube from SAP transactional system and flat files.
• Developed BEx query from cubes for reporting and dashboard requirements.
• Setup the SAP Business Warehouse in development, quality and production for BEx analysis and Crystal Report.
• Activated Business Content for standard cubes, infoobjects, transformation, transfer rules, update rules, info package, ODS, data transfer process and other standard objects.
• Created custom COPA cubes for client specific reporting needs.
• Created BEx queries for analysis of data using BEx analyzer as the tool.
• Developed process chain for master data and transactional data automation from SAP R/3 system.
• Created custom info objects for reporting needs.
• Created Structures with formulas in BEx query and stored it on the SAP BW server for uniform use of the structures.
• Resolved incompatibility of Crystal Report XI and SAP BW 7.0 by using workaround in the Crystal and SAP system.
• Created and executed transport from the SAP BW Development system to Quality and to Production.
• Setup of the logistic extractors and data sources in all the three SAP BW system for sales, logistic and planning reporting.
• Tested the development system for the objects created.

Environment: Windows Server 2000/2003/XP, Crystal XI, Oracle 10g, SQL Server 2005, Microsoft Access, Microsoft .net., C#, SAP BW 3.5, 7.0 , BEx Query designer, BEx Analyzer, Business Object Live Office, Business Object Xcelcius and Business Object Voyager.


New Era, Buffalo, NY
Reporting
Role: Crystal Report Developer/Microsoft OLAP Developer
May 2007 -- Oct 2007
This project with New Era involved migrating reporting from the legacy reporting tool Microsoft Excel. Set up the SQL server for Crystal Reporting. Setup the Microsoft OLAP data warehouse with SQL server as the database needed to be done. Collecting requirements from the business and functional user of various departments and creating Crystal Reports from it. Extracting data from the PeopleSoft system and transferring to the SQL server for reporting.
Responsibilities:
• Migrated existing finance, sales, retail and exception report from Microsoft Excel to Crystal Report.
• Collected requirements from business and functional user and transformed into design specification for other developers in the team.
• Team lead for crystal development with responsibilities to set up the Crystal Server, Infoview, reporting structure, role and rights.
• Developed new reports using Crystal Reports XI and Oracle 10g as database.
• Developed reports out of legacy database such as Microsoft Access.
• Created HR training application using Microsoft .NET and C# as programming language.
• Developed reports by joining more than one database such as SQL server, Oracle database involving two or more server.
• Created dynamic and static parameter based report and scheduled it on the Crystal Server.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports XI.
• Created company specific formula and used Crystal repository to store generalized formulas for reusability.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
• Used Stored Procedure and Views to generate reports.
• Created On-Demand Sub reports and Hierarchical Grouping.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Created user interface for viewing the reports on a web page using .NET.
• Passed parameters dynamically to Crystal Report in .net application at runtime.
• Developed Drill Downs report using Graphs in Crystal.
• Trained all the Users of the Reports on using Infoview and exporting reports to various formats.
• Created Views, Queries and tables to create the reports.
• Tested the reports in for quality and end user validation to match the amount and quantities figures against the transactional system.
• Developed cubes using PeopleSoft transactional data and Microsoft OLAP.
• Developed Crystal OLAP reports using Microsoft Analysis service as the Data Warehouse.
• Developed Crystal Reports from Microsoft OLAP cubes.

Environment: Windows Server 2000/2003/XP, Crystal XI, Oracle 10g, SQL Server 2005, Microsoft Access, Microsoft .net., C# and Microsoft OLAP


Nihilent Technologies, Pune India Feb 2006 -- Aug 2006
Role: Analyst/Report Developer
Description:
Nihilent Technologies is one of the pioneer consulting firms in India offering wide variety of In-House Projects for building Web Applications and Data Warehouse for MNC Clients. This project was to deal with building a web based scorecard with reporting for one of the MNC Clients Mobile Telephone Network (MTN).

Responsibilities:
• Designed and implemented a score card web application for employee performance indicator.
• Senior developer in the development of .NET web application using C# as the programming tool.
• Designed the database in SQL, Oracle and My SQL server for the web interface as the front end.
• Designed reports for managers and supervisor to monitor employee performance and appraisal.
• Developed parameter based reports and sub reports with a web interface for easy viewing.
• Developed role based access to the reports using Microsoft .net.
• Developed SQL queries, stored procedures and views for reporting and web application.
• Worked closely with the users to collect requirements, design specification, SRS, FRS, DLD, ER diagram, URS, DFD.
• Created test script for testing the web application.
• Created and tested database connection with MS SQL, Oracle and My SQL database.

Environment: C#, Windows 2000/2003/XP, IIS 5.0, Visual Studio 6.0, Microsoft Reporting Service, MS-SQL 2000, Oracle 9i, My SQL.


Nihilent Technologies, Mumbai India Feb 2005 - Jan 2006
Role: System Analyst
Description:
This project involved building a web application and data warehouse for South African Revenue Service (SARS).

Responsibilities:
• Designed and implemented a web service which extracts data from the SQL Server and MS OLAP warehouse for the web based thin and thick clients.
• Senior developer in the development of .NET web application using C# as the programming tool.
• Designed the cubes in Microsoft OLAP for reporting and developing a Dashboard using .net as the front end.
• Defined KPI for the key performance metrics of the client.
• Developed stored procedures and queries for reporting using Microsoft reporting services.
• Created requirements documents, system specification documents, designed and analyzed the documents to specify functional requirements.
• Designed and developed multi tier architecture for the web application.
• Developed stored procedures for extracting data from the SQL server for the web application.
• Designed fact table and dimensions for reporting and web based Dashboard.

Environment: Windows 2000/2003/XP, IIS 5.0, Visual Studio 6.0, Microsoft Reporting Service, MS-SQL 2000, Microsoft OLAP 2000.


CDAC, India Aug 2004-- Jan 2005
Role: Database Developer/Web Developer
This project involved designing an Online shopping website which would enable capturing orders from customer and sales man using a web interface.

Responsibilities:
• Collected requirements from the end user and created mock application to finalize the requirements.
• Designed a database using MS SQL server for the web application.
• Created stored procedures and complex queries for web application.
• Designed a multi tiered architecture segregating the data from the application layer.
• Generated web based reports for the inventory and sales using C# as the development language.
• Created application to fulfill orders based on the inventory which was pulled dynamically.

Other projects:
Undergrad and college projects have not been mentioned. The projects were based on SQL, Oracle, MS Access database and languages like JAVA, .NET, C, C++, HTML, XML languages.

Other Tools: UML, Microsoft Visio, Microsoft Project, Microsoft Office, Microsoft Visual Source Safe, Toad, Visual Studio .Net, Eclipse.


EDUCATION

M. S. in Management Information System.
B. S. in Information Technology

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Buffalo, NY | Resumes in New York

View other Business Object/Crystal Report Developer resumes, Programmer / Developer resumes