OBJECTIVE
To seek a challenging position as a Business Objects/Crystal Reports developer that will utilize my technical skills and professional experience.
SUMMARY OF QUALIFICATIONS
Over 7+ years of experience as a Senior Business Objects/Crystal Report Developer serving a wide variety of industry verticals including – automotive, banking, education, energy, utility, healthcare, insurance, retail. Good exposure to performing administrative tasks using Business Objects Enterprise. Experienced in database modeling using different tools like Erwin, MS Visio, IBM Rational tools. Hands-on experience with using Universe Designer, Web Intelligence, Ad Hoc reporting, System Usage Monitoring, Central Management Console, Configuration Manager, Repository, Migration Wizard, Crystal Publishing Wizard, Info View. Experience working with various versions of Crystal Reports from 8.5 to XI R2, XI R3, 2008. Solid understanding of the Data warehousing and ETL processes and concepts. Experienced in different approaches of accessing ERP System Data for reporting purposes. Good knowledge of other reporting tools like – Micro strategy, COGNOS BI Reporting, MS SQL Server Reporting Services. Experienced in publishing reports and maintaining users using Crystal Enterprise and Business Objects Enterprise. Familiar with Xcelsius tool for Dashboard and Scorecard creation. Comfortable in working with Business Object Universes – modifying the existing universes to meet the complex reporting requirement, designing new Universes. Comfortable in creating formulas, grouping data and conditional formatting formulas. Experienced in Creating Detail, Summary and Sub reports. Knowledge of creating commands to use as a data source. Experience in creating formulas and report criteria using if and loop statements. Made extensive use of record selection formula to limit records in most of the reports designed. Developed complex summary reports using running totals and summaries and provided them the drill- down capability.
Solid requirements gathering and documentation skills. Experience in working with other Business Objects BI tools like – DeskI, WebI. Experienced in generating Sub Reports, On Demand Reports, Linked Reports, Mailing Labels, Cross Tab Reports and Graph Reports. Experienced in linking the Objects residing in the repository into the reports. Expert in using shared and global variables across the crystal reports. Expertise in developing advanced reports with functions, formulae. Developed various reports like parameterized reports, sub reports, summary reports, cross tabs, OLAP reports. Experienced in creating and Managing- folders, users and user groups in Central Management Console (CMC) and Setting-up user and folder access controls. Strong skills in Databases (MS SQL Server, Oracle) and vast experience in working with database models and schemas.
Experienced in working with SQL, T-SQL, PL/SQL and using it in Complex queries, Packages, Stored Procedures, functions, Cursors, Views. Experienced in conducting design sessions to evolve system specifications and test plans with the ability to handle training sessions and documentation. Familiar with Microsoft development environment - Visual Studio, ASP.NET, VB.NET, C#.NET, JAVA – Net Beans. Quick learner, team player and excellent communication skills both written and verbal. Ability to adapt to new technologies very quickly. SKILL SET
Operating System:
Windows, Linux, Unix, Solaris
Languages:
SQL, T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, Java, C, C++
Databases:
MS SQL Server, Oracle, DB2, SyBase
Modeling/Documentation Tools:
MS Visio, ERWin, Rational Rose, ClearCase, Axure
PROFESSIONAL EXPERIENCE
Client Name: Confidential,Atlanta, GA 06/09 – till date
Sr. Crystal Reports Developer/Analyst
Description: Confidential,provides on-line solutions to energy industry across the southern and mid-western United States. One such service is the hosted reporting solution for Load Data Analysis, Utility Rebate Programs. Business Objects XI R3 is the platform being used to deliver the solutions.
Responsibilities:
Reviewed functional specifications and prepared technical specifications based on the requirements of the client. Reports were developed to analyze the load data for various periods of the year and during the peak and off-peak hours of the days to predict the energy demand in order to address the infrastructure planning. Reports generated to support the utility rebate programs included – Payment reports to track the funding, by Rebate Program, by State/Region, by Sector i.e. commercial/residential, by type of equipment installed. Reports to track the incentive payments during a period – week, month, year. Reports to track the status of the incentive applications. Attend meetings with Business Users in finalizing the report enhancements/new report requirements and assist them with any technical questions they ask in terms of reporting. Designed and developed various Crystal reports like Simple, Complex, and Master/Detail, Cross Tab reports, sub-reports, parameterized reports with cascading prompts, and graphs. Extensively used Parameters, Filters, conditions, calculations in Crystal Reports for multi level sorting and prompt. Used free hand SQL and generated reports where universe will not supply the data. Was involved in developing and maintaining the field mapping to move the data contents from various sources to the SQL Server 2008 Data Warehouse. Modified the universes by adding appropriate joins and tables and built customized classes and objects. Created Reports using formulas, Grouping, Parameters, Selection Criteria to handle the customer’s request from Tables, Stored procedures, Views and Add Command. Customization and Troubleshooting of reports after upgrade. In depth analysis of each and every report to identify the missing objects in the central EDW. Re-Engineering all existing reports and developing them in Webi. Gathered the user requirement, reported requirements and prepared the requirement specifications document. This involved interviewing the business users and understanding the current reporting system. Set up Groups and Users in Business Objects Enterprise Environment. Monitored Web intelligence server and Info view to share common reports amongst users. Created Classes, different kinds of Objects as a part of Universe development. Created the reports using crystal reports functionality’s like Queries, Drill Down, Cross Tab, Master Detail and Formulae’s etc. Extensively used Shared variables between Main and Sub-report. Extensively made use of built-in Crystal functions like - Math, Date-Time, String, Date-Range. Used Print State, Evaluation Time, Alerts functions as well to control data reporting Created Dynamic Prompts using Business View Manager. Extensively used advance features of Business Objects Enterprise like OpenDoc for Passing Parameters to other reports and also to call one report from another. Worked with Select Expert, Section Expert, Group Expert, Template Expert and Record Sort Expert. Made use of the BO Repository to store the Custom functions created to use them across multiple reports. Was involved in tuning and improving the performance of the report. Created complex formulae for Time Period Prompt values like Rolling 12 Months, Year-To-Date, Year Ending, Quarter-To-Date, Month Ending and Week Ending. Provided the post production support as needed so as to overcome the issues faced during the migration of reports from Development to Production. Client Name: Confidential,Tucson, AZ 07/08 – 05/09
Crystal Reports Developer
Description: Confidential,) provides opportunities and support structures to artists and community through education and advocacy as well as offering multi-cultural arts engagement connections to the public at large. The database used was Black baud Inc’s, Raiser’s Edge – a database used primarily by not – for – profit organizations in fund raising sector. Business Objects XI R3 was the platform that was being used.
Various custom reports developed included:
Reports to track specific donor information, fund information, grant information, event information, festivals information, volunteer information, membership information etc. Reports to track the progress of interaction with prospects and donors. Reports to analyze fund generation based on fund raising methods. Reports to analyze various donor cultivation processes. Campaign progress reports, comparative reports, appeals and solicitor performance reports, and up-to-the-minute cash and pledge reports. Responsibilities:
Gathered and analyzed information from the end users. Analyzed the requirements and developed the documents to meet the end user specifications. Prepared detailed specifications from which reports were written. Was involved in developing and maintaining the field mapping to move the data contents from various sources to the SQL Server 2008 Data Warehouse. Exported reports into various formats offered by Crystal Reports 2008. Developed Cross Tab reports, linked Sub Reports and graphs using Crystal Reports 2008. Utilized various crystal reports features including Conditional Formatting, use of Multiple Groups and group sorting, parameters and complex formula usage.
Worked closely with users in gathering requirements and trained them in using and scheduling Reports. Conversion of Ad-hoc Crystal reports to Business Objects through the Universe Design/WebI. Interacted with Risk Managers and analysts for Universe and reporting requirements. Designed developed, maintained and tested Universes for supporting Ad hoc reports. Created various classes and objects for Universe. Created Hierarchies for providing drill down options for the end-user to select the right contracts. Developed critical reports like drill down, master/detail for analysis of discounts and special offers. Made the reports user friendly by implementing user prompts, conditions and filters. Developed Complex reports with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the user’s requests.
Created confirmation letter reports that are mailed to the participants. Created Reports that includes Grouping, Sorting, Alerting, Field highlighting, Formula fields. Performed User Administration like managing User Rights and maintained Global Level, Folder Level and Object Level security
Client Name: Confidential,Pittsburgh, PA 01/07 – 06/08
Sr. Crystal Reports Developer
Description: Confidential, is an integrated global health enterprise headquartered in Pittsburgh, Pennsylvania, and one of the leading nonprofit health systems in the United States. MARS Database at the UPMC is used to archive both Clinical and Financial data. The data was being pulled from MARS System into an Oracle database. As a Crystal Reports Developer, was involved in the report development, in support of various programs running at UPMC.
Responsibilities:
Analyzed the requirements and developed the documents to meet the end user specifications. Developed in patient pharmacy utilization reports bases on drug type etc. Financial Reports were generated to Produce charges, costs, and payments by insurer to determine future contract rates.
Report generation to monitor High INR Lab values. Involved in report development for Clinical Research Informatics Service Administrative reports included – quarterly reporting on resource utilization of medical ICU and step- down units.
Prepared detailed specifications from which reports were written. Interacted with end users and top-level management to develop and modify complex reports according to the arising needs.
Involved in Requirement analysis and database design of Reports. Developed various reports that included – Standard, Summary, Summary-of-Summary, Charts, Graphs, Drill-down reports, Labels with formulas, SQL Expressions, Grouping, Sorting, Sub-reports,
Cross-tab reports, complex formulas, conditional formatting and parameters.
Created tables and loaded data using SQL Loader. Involved in SQL Query Performance Analysis and query tuning using SQL Query Analyzer. Designed, developed and maintained Master-Detail, Sub-report, and Cross-Tab Reports. Involved in Gathering requirements and Designing the Reports using Crystal Reports. Created linked and unlinked sub reports (regular and On-demand) along with primary reports. Developed several Complex Reports various features included multiple groupings, drilldowns, parameter fields, formula fields and conditional formatting.
Creating different types of Reports including Cross-Tab, Drill-Down and Bar Chart Reports. Worked with Crystal Enterprise Administrator and assigned rights for authorizing end-users. Involved in migrating the repository from development to testing and production environments. Published Reports in CMC and involved in Scheduling and exporting reports in different Formats. Creating Summarized Reports for calculating the Revenue. Used Business Objects Enterprise and Crystal Reports Enterprise to publish the reports into InfoView. Handled administrative tasks via Crystal Enterprise for reports publication, scheduling, user security. Designed few Universes to address complex reporting requirements. Responsible to update template Text Objects, Logos, Commands in the BO Repository so as to make them, available to everyone in the reporting team.
Was involved in creating extensive documentation to describe the logic, coding, testing, changes and corrections.
Created WebI and made use of features like Alerts, Filters and Breaks in designing reports. Exported reports into PDF and Excel formats. Environment: Oracle 10g, VB.Net, Java, Crystal Reports XI R2, Business Objects Enterprise XI R2, Toad, Oracle SQL Navigator, ASP.Net.
Client Name: Confidential,Chicago, IL. 03/06 – 12/06
Crystal Reports Developer
Description: Confidential,is a major international consulting and accounting firm, deliveringservices through its member firms. The project mainly deals with developing new reports and formatting existing reports. Reports are developed and formatted as per the user requirements. The developed reports include the Customer Sales Reports, Agent Reports and Commission Reports which allows the users for a quick and easy analysis of the previous year and current year sales, commission comparisons between different agents. Reports are developed with formatting that fits PDF and Excel Exports.
Responsibilities:
Gathered and analyzed information from the end users. Analyzed the requirements and developed the documents to meet the end user specifications. Prepared detailed specifications from which reports were written. Exported reports into various formats offered by Crystal Reports XI. Developed Cross Tab reports, linked Sub Reports and graphs using Crystal Reports XI. Utilized various crystal reports features including Conditional Formatting, use of Multiple Groups and group sorting, parameters and complex formula usage.
Used complex formulas for calculating moving averages, short term averages. Created custom List of Values (LOVs) for better understanding of the prompts by the end-users. Worked closely with users in gathering requirements and trained them in using and scheduling Reports. Conversion of Ad-hoc Crystal reports to Business Objects through the Universe Design/WebI. Interacted with Risk Managers and analysts for Universe and reporting requirements. Designed developed, maintained and tested Universes for supporting Ad hoc reports. Created various classes and objects for Universe. Used @functions like @prompt (for user defined queries), @where (for creating conditional filters), and @select (to create duplicate objects), in the process of building the universes.
Created Hierarchies for providing drill down options for the end-user to select the right contracts. Developed critical reports like drill down, master/detail for analysis of discounts and special offers. Made the reports user friendly by implementing user prompts, conditions and filters. Developed Complex reports with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the user’s requests.
Developed several Complex Reports including multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulae, Cross Tabs, Running Totals and conditional suppressing, formatting using Crystal Reports. Made used of various presentation styles like Bar Charts, Pie Charts and Line Graphs to graphically represent data in the reports. Implemented periodical scheduling for the reports to run automatically. Responsible to make sure Email, FTP, and Unmanaged Disk options of scheduling are always up and running. Exported reports into PDF and Excel formats. Used Info View to publish and schedule reports to be delivered to the users via e-mail. Created test data to test the reports during development and in test environment before moving them to the production. Environment: Windows XP, Business Objects XI R2, SQL Server 2000, SQL, and T-SQL
Client Name: Confidential,Fairfax, VA. 02/05 – 04/06
Crystal Reports Developer
Description: The Company provides retail and wholesale financing, retail leasing, vehicle protection plans and certain other financial services to authorized Toyota, Lexus and Scion dealers, as well as Toyota Material Handling. My key responsibility in this project was to create new reports in Crystal reports X1 R2, Re-Engineering the existing reports and migrating them from Crystal Reports 10 to Crystal Reports XI.
Responsibilities:
Worked with the higher management in Marketing, Sales and Finance departments to gather requirements for their reporting needs. Gathered information from the end users, analyzed the requirements and developed the documents to meet the end user specifications Analyzed the data from the user perspective and developed the design specifications for developing the reports Create Crystal Reports, which would facilitate decision-making The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc Created views and stored procedures for Reports using complex SQL, T-SQL Published Crystal Reports in web based environment using Crystal Enterprise Created complicated reports using Crystal Reports for Credit, Sales, Document Funding and application Security teams. These reports used Crystal formulas, Parameters, Selection criteria, sub reports etc Implemented Crystal Reports in web based environment using Crystal Enterprise application. Handled administrative tasks using Crystal Enterprise like reports scheduling, publication and user security Reported application errors while analyzing the data for reports Communicated effectively for requirements and reports testing with the end users. Also communicated with the Database team and other programmers to acquire the database knowledge Published the reports in Crystal Enterprise and scheduled the reports depending on the users request to receive in different formats (Email, Public folder etc) Handled administrative tasks via Crystal Enterprise for reports publication, scheduling, user security. Responsible to make sure Email, FTP, and Unmanaged Disk options of scheduling are always up and running. Environment: Windows 2000, Crystal Reports 10.0, Crystal Enterprise 10/Business Objects XI, SQL Server 2000, SQL, and T-SQL
Client Name: Confidential,St. Paul, MN. 04/04 – 01/05
Crystal Reports Analyst
Description: BearingPoint provides management and technology consulting services in various parts of the world. The project mainly deals with developing new reports and formatting existing reports. Reports are developed on SQL queries in Oracle Data Warehouse Environment and formatted as per the user requirements. The developed reports include the Customer Sales Reports, Agent Reports and Commission Reports which allows the users for a quick and easy analysis of the previous year and current year sales, commission comparisons between different agents. Reports are developed with formatting that fits PDF and Excel Exports.
Responsibilities:
Writing automated test cases that are reusable and data driven in nature also Develop, review and approve agile story documentation. Review Functional specifications and prepare Technical specifications based on the requirements of the client. Interacted with end users and top-level management to develop and modify complex reports according to the arising needs. Customization and Troubleshooting of reports after upgrade. Understanding the current reporting system to make the merging of Warehouses easy. In depth analysis of each and every report to identify the missing objects in the central EDW and create them. Gathering the user requirement, reporting requirements and prepare the requirement specifications document. This involved interviewing the business users and understanding the current reporting system. Created the reports using crystal reports functionality’s like Queries, Drill Down, Cross Tab, Master Detail and Formulae’s etc. Used Adobe Suite extensively in comparing the reports result before and after upgrade. Exported reports into PDF and Excel formats. Developed Complex reports with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the user’s requests.
Developed several Complex Reports including multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulae, Cross Tabs, Running Totals and conditional suppressing, formatting using Crystal Reports. Environment: Crystal Reports 9, Oracle, Toad, Oracle Retail Data Warehouse (RDW) and Windows XP
Client Name: Confidential,Dallas, TX. 02/03 – 03/04
Project: Sales and Order Tracking Reports Developer/Analyst
Description: Worked on sales, orders and tracking information for sale of telephone equipment.
Responsibilities:
Worked with the end users and higher management to gather requirements for reports and data analysis. Designed and developed Crystal Reports, which included standard reports, cross-tab, summary reports according to the requirements. Reports developed contained Crystal Formulae, SQL Expressions, Selection Criteria, and Sub Reports etc. Developed Complex reports with Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the user’s requests.
Developed several Complex Reports including multiple groupings, drilldowns, parameter fields, functions, Type Conversions, formulae, Cross Tabs, Running Totals and conditional suppressing, formatting using Crystal Reports. Used Crystal Management Console/Seagate Info to perform administrative tasks related to user groups, accounts, report publishing, folder management etc. Used ePortfolio to view, schedule, and keep track of published reports. Managed Crystal Enterprise/ Seagate Info reports repository with automatic versioning and scheduled reports accordingly with the data updates. Conducted user training sessions and supported them with their requests for enhancements, modifications and new reports. Used SQL, PL/SQL to maintain the data for reports and validation of the reports. Interacted with all the team members to efficiently incorporate development results Performed impact analysis for new requests. Coordinated the development effort of several developers in the team. Exported reports into PDF and Excel formats. Environment: Windows 2000, Crystal Reports 9.0/8.5, Crystal Enterprise 9.0/8.5, Seagate Info 7.0, Oracle 9.i, SQL, PL/SQL, TOAD 7.0.
EDUCATION
MASTERS IN COMPUTER & INFORMATION SCIENCE
Privacy Policy
