Skills

Employment History:

Confidential

Sr. CRYSTAL REPORT DEVELOPER

Responsibilities:

• Responsibilities include interacting with Implementation team to understand the requirements of the customer and develop new reports or modify existing ones in an efficient and productive way. Publish reports for customer access via Web Synapse and schedule reports as well.
• Worked on complex reports that require running totals, sub-totals, sub-reports, multiple groups and conditional display of groups, fields and messages.
• Developed SQL Queries to fetch complex data from database and use it as Add Command in the report.
• Published the reports in business objects enterprise for customer access via Web Synapse and scheduled the reports to deliver them in excel format via email.
• Work on Cherwell tickets to resolve reporting issues through interaction with the users and IT service desk.
• Scheduled meeting with Implementation team regarding changes or improvement they need in existing reports and modified the reports to meet their needs and requirements.
• Responsible to Check-In the reports to Production and schedule them as per requirement.
• Created reports with prompts to facilitate end users to enter filter values at runtime.
• Created various reports using Sub reports, Drill down and dynamic formatting.
• Troubleshooting, Optimizing, and fine-tuning the SQL Queries for efficiency.
• Created shipping Labels using Loftware software.
• Had Knowledge on Mobile Technologies.
• Created various reports like BOL, MBOL, Packing List, Activity Reports, Invoices, Inventory reports, Shipped orders, Received Orders, Inventory adjustment reports.

Environment: Business Objects Enterprise 4.0/XIR2, Crystal Reports XIR2/2011, Oracle 11g, Pl/SQL, SQL Developer, SQL PLUS, Loftware, Cherwell, Windows 2002

Confidential

CRYSTAL REPORTS ADMINISTRATOR

Responsibilities:

• Include providing IT Analyst services, performing Crystal Reports development and Business Objects Enterprise administration duties in Business Intelligence team.
• Review SQL code to simply the back end calls and solve performance issues.
• Create reports and publish them in business objects enterprise.
• Provide necessary information in different formats for Ad hoc requests.
• Administration and maintenance of business objects enterprise.
• Review or Create move forms when the code moving from DEV to TEST and TEST to PROD with approvals from PRB and Business Leader and IT Process Leader.
• Onsite-Offshore model is practiced and offshore team is fully managed from Onsite.
• Migration of reports from old version BOE XI R2 to the updated new version BOE 3.1.
• Provide support for the reports deployed and running in the production environment.
• Had Knowledge on Mobile Technologies.
• Involves using tools like Toad, Clarity, Crystal Reports 2008, Business Objects Enterprise 3.1 suite.

Environment: Business Objects Enterprise 3.1, Crystal Reports XI/2008, Oracle 11g/10g, Pl/SQL, SQL, SQL PLUS, TOAD, Clarity, Quality Assurance, Windows 2005

Confidential

Sr. CRYSTAL REPORTS DEVELOPER

Responsibilities:

• Establishing functional specifications and translating them to design specifications.
• Develop database views and stored procedures using the tool Oracle SQL Developer.
• Redesign the Retail Annuity Book of Business reports developed using WebI or Desktop Intelligence reports in Crystal Reports Developer through Business Objects.
• Coordination with data ware house team to understand the ETL process and the elements in BOB Data mart.
• Use of tools including Universe Designer, Desktop Intelligence, Web Intelligence Rich Client, Crystal Reports 2008.
• Responsible for functional, unit and system testing of the report.
• Create and use crystal reports SQL commands.
• Create reports using SQL stored procedures and create stored procedure parameters.
• Developed On - Demand Sub Reports, Parameter Reports and Drilldown Sub Reports.
• Created running totals and summaries for calculated fields within Crystal Reports.
• Met with end/business/power users to determine functionality both via in-person and conference calls.
• Migrate reports and store procedures from development to test and then to production.
• Responsible for unit, system and performance testing.
• Using SQL Expression Fields Creating SQL Expressions Grouping on the Database Server Enabling Server-Based Grouping What's Required to Use Server-Based Grouping Effects of Drill-Down
• Bug Fixing, Enhancing existing reports.
• Optimizing existing Crystal Reports to make them run faster. Changed formulas and added WHERE clauses to SQL to significantly improve run times.

Environment: Oracle SQL Developer, Business Objects Enterprise 3.1, Crystal Reports XI, 2008, Oracle 11g/10g, Oracle 9.2, PL/SQL, SQL, SQL PLUS, TOAD, Windows 2005, Quality Assurance, Quality Center.

Confidential

Sr. CRYSTAL REPORTS DEVELOPER

Responsibilities:

• Involved in gathering business requirements, establishing functional specifications FSD , translating them to design specifications.
• Interacted with the users for changes or improvement they need in existing reports and modified the reports to satisfy their needs and requirements. Making changes to the reports that are created in earlier versions.
• Motivated self-starter with exceptional team building, leadership Project Management and interpersonal skills.
• Interact with users to put together the standards of the Crystal Reports and make a standard template.
• Upgrade and Migrate reports from Crystal Reports XI to CR 2008 version.
• Accommodate Database changes and field mapping by recognizing database changes and mapping old fields to new names.
• Created Complex Reports using Sub reports, Drill down and dynamic formatting. Changed complex reports to easier by using Stored Procedures and Views.
• Worked with Shared and Global Variables to share the data between main and sub reports.
• Designed Parameterized Reports to filter the data and for dynamic changes of the report look and field.
• Use Business view manager to create and maintain the LOV for parameters.
• Manage users, groups and add, modify, and delete user accounts. Place users in groups.
• Manage folders, crystal reports and third-party objects. Manage public folders, subfolders, personal folders. Add program objects and hyperlinks.
• Control access using folder and object rights. Set access rights for CMC Functions and define custom access levels.
• View, print and export reports. Supply database credentials and parameters and schedule objects. Schedule reports containing alerts, reschedule existing instances.
• Automate reports to generate statistical reports daily, weekly, monthly, and quarterly.
• Define output destinations of scheduled objects or reports, create calendars, create and manage events, create alerts and configure success/failure/alert notifications.
• Perform general administrative tasks like adding additional licenses, setting instance limits, specify default Infoview settings and use instance manager.
• Modified report content and distributed reports in multiple formats such as Excel, word, RTF, HTML PDF in CMC.

Environment:

Business Objects 3.1, Crystal Reports XI/2008, Business View Manager, Oracle 11g/10g, Oracle SQL Developer, Pl/SQL, SQL PLUS, TOAD, Visual Studio, MicroSoft .net 3.0, C .Net, ASP.NET, VB.Net, Subversion, TFS, Teamtrack, Windows 2005

ENTERGY COR, BEAUMONT, TX April 2007 May 2008

Confidential

BI DEVELOPER

• Studied Business Requirement documents BRD and Function Specification documents FSD for the development of various web based applications hosted.
• Interacted with the users for changes or improvement they need in existing reports and modified the reports to satisfy their needs and requirements. Making changes to the reports that are created in earlier versions.
• Migrated Crystal reports from Crystal Reports 9.0 to Crystal Reports XI. Deploying the reports to Crystal Enterprise.
• Developed reports using Business objects XI R2, Info View, Web Intelligence and ZABO.
• Designed and developed WebI and BOXI Reports for various user groups.
• Generated and Published web reports in Info View using Web Intelligence.
• Created reports with Prompts to facilitate end users to enter filter values at runtime.
• Created various reports using Sub reports, Drill down and dynamic formatting. Changed complex reports to easier by using Stored Procedures and Views.
• Developing various types of Reports like Standard Reports, Group Reports, Cross-tab Reports, Graphical Reports, Sub Reports, Parameter Reports using Crystal Reports 9 and XI
• Created several sub reports using Suppression Logic to display sections with data based on different conditions.
• Created the reports using the Universes as the main Data providers.
• Involved in Trouble Shooting all the issues within Enterprise and Reports. Developed various Charts and Graphs like Bar Chart, Pie Charts, Line Graphs, and Scattered Chart.
• Responsible to Check In the reports to Development and Test environments to Production.
• Used Generalized Formulas using both Crystal and Basic Syntax. Used Crystal repository for reusability of formulas. Created User Defined Functions for sharing the formulas across multiple reports.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD by using Crystal Reports XI for user.
• Publishing and Scheduling Crystal Reports and Webi Reports in web based environment using BOE.

Environment: Business Objects XI R2. Crystal Enterprise 9/10/XI, MicroSoft .Net 3.0, Oracle 8i/9i, Pl/SQL, SQL, SQL PLUS, TOAD, Quality Assurance, Windows

Confidential

Crystal Reports Consultant

Responsibilities:

• Study and understanding the business Scenarios of the existing systems, understanding data and validating the data by applying the current business rules.
• Responsible for designing the centralized repository database for data from the existing databases.
• Responsible for scheduling the meetings with the existing application owners to discuss about the data and draw data extracting scenarios for the centralized repository.
• Responsible for creating the Complex Crystal reports On demand, Ad-Hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc.
• Created Report templates and their underlying queries to generate the required management reports.
• Development of reports for financial needs of the business using Crystal Reports. Possess excellent analytical skills.
• Made up nested and conditional groups and formatting features in reports.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tab, multiple groups and conditional display of groups, fields and messages.
• Created various reports using Sub-Queries, Drill Down and Master Detail for easy analysis of reports.
• Developed Stored Procedures, Functions to input data into Crystal Reports.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Published the reports in crystal enterprise and scheduled the reports depending on the users request to receive in different formats Email, Public folder etc .
• Troubleshooting, Optimizing, and fine-tuning the SQL Queries for efficiency.
• Developed web reports using crystal reports XI, migrated the existing reporting system to higher version and published them using crystal enterprise.
• Responsible for extracting the data from the existing systems and load into the repository using SQL Loader from Text files.
• Handled end user training and presentations.
• Setup and handled crystal enterprise administrative tasks.

Environment: Windows 2000, MicroSoft .Net 3.0, ASP.Net, Java Script, VB Script, VB.Net, CSP, Oracle8i/9i, SQL Plus, TOAD, SQL Server 2000, Crystal Reports 10/9.0, Crystal Enterprise 10/9.0, SQL, PL/SQL, etc.

Confidential

Crystal Report Developer

Responsibilities:

• Developed and Deployed reports for different modules based on accounts, purchase, Inventory, Supply chain.
• Wrote formulas, parameters and conditions depending upon selection criteria.
• Exported the Reports into the required formats like PDF, HTML, EXCEL, and WORD by using Crystal Reports XI for user.
• Generated complicated reports using sub reports.
• Generated reports by using stored procedures and generated parameterized, drill down reports.
• Developed different levels of reports including sub-reports, cross-tabs and charts.
• Used SQL Statements and Stored Procedures in SQL Server for faster reports output.
• Designed Annual, Monthly, Weekly reports.
• Designed work schedule, wages, invoice and performance appraisal reports using Sub reports.
• Designed parameterized reports for frequent use.

Environment: Crystal Reports 8.5, PL/SQL, SQL Server 2000 and Crystal Enterprise 8.5