Crystal Reports Developer Resume
Omaha, NE
SUMMARY
- Accomplished IT professional with around 15 Years experience in software development.
- Over 8 years experience and exposure with all modules in Business Objects, Business Objects XIR3/XIR2/6.5,SAP BO4.1, (Infoview, Web Intelligence, Desktop Intelligence, Central Management Console (CMC)), Crystal Reports XI/ Crystal Reports 2011/2008, BI Datawarehouse
- Created Ad - hoc reports and Canned Reports.
- 2 years of experience in SAP Business Intelligence with BO and Crystal XCelsius 2008, Live Office & QAAWS.
- Experience in designing and developing standard and custom Info cube, DSO objects, info object catalogs, Infoobjects, Transformation, Info package, DTP, Data source, Characteristics and Key figures, Multiproviders, Business content.
- Experience with Data Warehouse Concepts, Methodologies and SDLC.
- Strong Knowledge with Star Schema and Snow Flake Schema Data Models.
- Good experience in developing data source SQL queries for Oracle and SQL Server databases for data analysis, report development requirements and ETL procedures.
- Experience in Reporting using SQL SSRS.
- Skilled in Relational Databases like Oracle, MS SQL Server and MS-Access.
- Experience using Oracle, SQL, PL/SQL Developer, TOAD and Teradata.
- Created reports using stored procedures and views in Oracle database
- Extensive experience in Performance tuning the Queries for report performance
- Experience in creating Universes with Aliases, Contexts, and Linked Universes
- Created Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart Reports, Styles and GUI’s. Prompt using Crystal Reports XI/2008.
- Created the dashboards using Xcelsius 2008
- Experience performing Unit Testing and Performance Testing for the reports.
- Experience using Microsoft Excel, Microsoft word, PowerPoint, PDF’s interaction with Business Objects
- Excellent analytical, communication and interpersonal skills.
- Capable of working in a team and/or individually, self-motivated.
- Analyzed, designed, developed and performed self-QA on applications while working directly with end-users and technical members of the teams
TECHNICAL SKILLS
OLAP Tools: Business Objects XI R3/R2/ 6.5, SAP BO 4.1, Crystal Reports 2011/2008/XI/9, Crystal Xcelsius 2008, Web Intelligence, Info view, LDAP, ETL (Data Integrator), SAP integration with BI/BO, BI Datawarehouse.
Database: Oracle 11g/10g/9i/8i, SQL Server Reporting Services (SSRS), MS SQL Server 7.0/2000/2005/2008 , DB2, Teradata, Informix, Microsoft office, MS Access, MS Excel, Word, PowerPoint and MS SharePoint.
Languages: Oracle Developer 2000 Forms/Reports, SQL, PL/SQL, HTML, XML, SQR, JavaScript, VBScript, Visio (Flowcharting).
Technologies: Servlets, Java AWT, JDBC/ODBC, .Net, ASP.NET 2.0/3.0
Operation Systems: Windows 7, 9x, NT, 2000, XP, UNIX and Sun Solaris, AIX
Tools: PVCS, Tivoli, Peregrine
PROFESSIONAL EXPERIENCE
Confidential, Omaha, NE
Crystal Reports Developer
Responsibilities:
- Created the Reports, Using Crystal Reports 2011 and MS SQL Server 2008, Oracle Database and BI Datawarehouse.
- Developed the Reports for Fanatics: Agent Logins, All Messages, First Response, and Conversion Lengths.
- Confidential Report created for insurance scrub Report. Reports created using Stored Procedures, parameters, formulas, filters and group by etc.
- Created different types of reports, Cross-tab, Sub reports, On-Demand Sub Reports, Conditional, Drill down, Summary.
- Scheduled the Reports using CMC.
- Tested the Reports and Checked into SVN, Created Code Publication Document.
Environment: BI Datawarehouse, MS SQL Server 2008, Oracle 11g. Crystal Reports 2011, SAP BO 4.1, Informix, Windows 7.
Confidential, Southfield MI
Reporting/Analyst
Responsibilities:
- Created Functional Design documents for creating reports and involved with user meetings.
- Involved with Medical management meetings.
- Created the Crystal Reports, Using Crystal Reports 11 and Oracle 11g.
- Developed different types of reports, Top 10 Diagnosis, Inpatient Tracking, HCC Network etc.
- Extensively used Toad to understand the data.
- Tested the reports by cross checking and verified data against the reports generated from the Crystal Reports v9 and the legacy system.
- Created the group by reports using formulas, filters, Summary and with parameters etc.
- Designed Reports according to the Company standard requirements.
Environment: Oracle 11g, Crystal Reports 11, SAP BO 4.1, Windows 7, and AIX
Confidential, Omaha, NE
Crystal Reports/B.O. Developer
Responsibilities:
- Created the Reports, Using Crystal Reports 2008 and MS SQL Server 2008, Oracle Database and BI Datawarehouse.
- Developed the Reports for Deferent Clients PCH, CVS, T-Mobile, Direct TV, AMEX, AT&T, Confidential and Comcast etc. Reports created using Stored Procedures, parameters, formulas, filters and group by etc.
- Created different types of reports, Cross-tab, Sub reports, On-Demand Sub Reports, Conditional, Drill down, Summary.
- Scheduled the Reports using CMC.
- Tested the Reports and Checked into SVN, Created Code Publication Document.
Environment: BI Datawarehouse, MS SQL Server 2008, Oracle 10g. Crystal Reports 2008, Business Objects XIR3.1, Informix, Windows 7.
Confidential, Las Vegas NV
Crystal Reports Developer
Responsibilities:
- Created the Reports, Using Crystal Reports 2008 and MS SQL Server 2008.
- Developed the Para Transit and Fixed Transit Reports using parameters, formulas, filters and group by etc.
- Created different types of reports, Cross-tab, Sub reports, On-Demand Sub Reports, Conditional, Drill down, Summary and Tested the Reports.
- Created New Reports and modified existing Reports.
- Created Ad-hoc reports and Canned Reports.
- Scheduled the Reports using Infoview.
Environment: MS SQL Server 2008, Crystal Reports 2008, Business Objects XIR3.1Windows 7.
Confidential, Toledo, OH
BI Reports Developer
Responsibilities:
- Created Web intelligence reports for Sales, Rebate, Price Impact Volume Impact Funding and Incremental price Impact, Incremental Volume Impact and using all the functionalities
- Developed Business Views on top of universes
- Deployed the reports to CMC for the users to able to see the reports in Info View and run, schedule and view the reports in different formats (PDF, Excel)
Environment: Oracle 10g, Business Objects XIR3.1, Excel, SAP BW, Windows Vista Enterprise.
Confidential, Concord CA
Crystal Reports Developer
Responsibilities:
- Created the Crystal Reports, Using Crystal Reports XI and Oracle 10g.
- Tested the reports by cross checking and verified data against the reports generated from the Crystal Reports v9 and the legacy system.
- Created the group by reports using formulas, filters and with and without parameters etc.
- Created different types of reports using Crystal Report XI: Sub reports, On-Demand Sub Reports, Conditional, Drill down, Summary and Parameter prompts.
- Created Ad-hoc reports and Canned Reports for nontechnical end-users.
- Designed Report Template according to the Company standard requirements.
- Scheduled the Reports using Infoview.
- Extensively used Toad to understand the data.
Environment: Oracle 10g, MS SQL Server 2008, Crystal Report XI, Business Objects XIR3, Windows Vista Enterprise.
Confidential, Columbus OH
Crystal Reports/BO Developer
Responsibilities:
- Created the Scorecard automation report using Crystal Report 2008 including Standard, Grouping, and Conditional.
- Created Sub-Reports for YTD Impacted View, YTD Accountable View, Current Month Accountable View.
- Developed and Tested the Reports
- Prompts for Filter
- Drill-down capability
- Summarization
- Formula based conditional parameters.
- Published Reports to CMC (Central Management Console) and involved in Scheduling and exporting the reports in different Formats.
- Environment: Crystal Reports 2008, Business Objects XIR3, Oracle 10g, SQL Server Reporting Services (SSRS), MS SQL Server 2008, Windows XP.
Confidential, Milwaukee WI
Crystal Reports/BO Developer
Responsibilities:
- Created Production monitoring reports using Crystal Report 2008 including Standard, Grouping, and Conditional.
- Created the Post Assembly Report for Production Monitoring.
- Created Sub-Reports for Crate Goal totals, Top 10 Repairs, Roll Test Acceptance, Repairs by Mechanic.
- Developed and Tested the Reports
- Prompts for Filter
- Drill-down capability
- Summarization
- Formula based conditional parameters.
- Scheduled the Reports using InfoView
Environment: Crystal Reports 2008, Business Objects XIR3, Oracle 10g, SAP BW, MS SQL Server, SQL Server Reporting Services (SSRS), Windows XP.
Confidential
Responsibilities:
- Designed SAP BO Universes both in OLTP Data warehouse and OLAP environments.
- Used Designer to create universe (set universe parameters, link tables, create classes, classified objects into classes based on business logic, create contexts and aliases to avoid traps, create derived tables, create hierarchies).
- Created Financial Management Reports Using BO WEB Intelligence Rich Client
- Created reports using Business Objects functionality like queries, slice and dice, drill down, crosstab, master detail reports, formulas, etc.
- Environment: Business Objects XIR3, Crystal Reports 2008, Oracle 10g, SAP BW, MS SQL Server, Windows XP, InfoView, WEBI
Confidential, Troy MI
Crystal Reports/BO Developer
Responsibilities:
- Created different types of reports using Crystal Report 2008 including Standard, Grouping, and Conditional.
- Created reports for Current General Ledger Account Balances.
- Created reports for G/L Reconcilement, Sub- Application Balance systems and Matched G/L Items.
- Drill-down capability
- Summarization
- Formula based conditional parameters.
- Published the Reports using InfoView Daily, Weekly, Monthly.
Environment: Business Objects XIR3, Crystal Reports 2008, Oracle 10g, MS SQL Server, Windows XP, InfoVIew, WEBI, Frontier, and Desktop Intelligence.
Confidential, Des Moines IA
Crystal Reports/BO Developer
Responsibilities:
- Crated trending reports using BO XI R3 Web intelligence rich client.
- Developed production/operation reports using Crystal Report XI.
- Created the dashboards using Xcelsius 2008.
- Creating complex report using graphs, pie charts for daily,weekly, monthly and quarterly basis.
- Created different types of reports including: standard, cross-tab, conditional, dynamic, and integrated sub-reports.
- Drill-down capability
- Summarization
- Formula based running totals Complex conditional parameters
- Label Reports, Chart Reports, Styles and GUI’s.
- Developed reporting from a highly normalized database schema.
- Scheduled the Reports using InfoView Daily, Weekly, Monthly.
Environment: Oracle 10g, Data warehousing, Crystal Reports XI/2008, Crystal Xcelsius 2008, Business Objects XI R3, Windows XP, Info view, WEBI, Desktop Intelligence, SAP/BO.
Confidential, Alexandria VA
Crystal Report / Business Objects Developer
Responsibilities:
- Responsible Publishing the reports and scheduled them as needed for the users, using Business Object Enterprise.
- Involved in managing users, groups, folders in CMC and security setting give (access permissions) to production folders and reports
- Created the Crystal reports using Oracle tables and tested the reports by cross checking and verified data against the reports generated from the legacy system.
- Worked on generating group by reports using formulas, filters and with and without parameters etc.
- Created different types of reports using Crystal Report XI: Standard, Cross-tab, Sub reports, On-Demand Sub Reports, Conditional, Drill down, Summary and Parameter prompts.
- Wrote formulas to calculate the age group summaries based on the group levels.
- Designed Report Template according to the Company standard requirements.
- Extensively used Toad to understand the data.
Environment: Oracle 9i, DB2, Crystal Reports XI/BOXI R2, Windows XP, UNIX, Info view, WEBI, Desktop Intelligence
Confidential, Ann Arbor Michigan
BO/Crystal Report Developer
Responsibilities:
- Designed and maintained Universes using different schemas in the Oracle Database.
- Migrated and converted BO content from 6.5 repositories to the XI R2 environment.
- Created user groups, users ID’s folder level security by using Central Management Console (XI).
- Created new Universes, Reports and modified existing Universes and reports.
- Took care of production issues
- Detected cardinalities, loops, and checked the Integrity of Universes.
- Created custom hierarchy in Universe using BO Designer.
- Created classes, subclasses and objects including complex measure objects according to the business requirements from the Universe schemas and database tables.
- Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context.
- Used Crystal Report XI Enterprise to design the front-end reports.
- Trained people to use and create reports.
- Published and Migrated reports in Development/Test to Production Domains.
- Worked on the Master, Kernel and Component approach during the linking of universes.
- Analyzed, designed, developed and tested reports while working directly with end-users and technical members of the team.
Environment: Oracle 10g, MS SQL Server, Data warehousing, Business Objects Enterprise XI R2/6.5, and Info view, WEBI, Desktop Intelligence, Crystal Reports XI.
Confidential
Responsibilities:
- Worked as a part of the team to make the MUPIT Data warehouse and its supporting application's adhere to the standards and guidelines as required by the Confidential Company Standards.
- Analyzed Involved in gathering of business requirements by close interaction with the team leaders and Region managers, Account Executives.
- Worked in a Data warehouse Project and used Star Schema.
- Created new Universes and modified the existing Universes as per the Production Environment
- Involved in End User Training and System documentation
- Used Filters and Alerts for better representation of data in Reports
- Created new reports and modified existing reports.
- Documented different application architecture's and dataflow across different applications and platforms.
- Perform scheduled migration of universes and reports.
- Created user ID's and Categories by using Supervisor tool.
- Participated in Annual review of control procedures to identify and close gaps in security and other control procedures used for the application.
Environment: Oracle 9i, MS Access, Data warehouse, Business objects 6.5 and WEBI.
Confidential
Responsibilities:
- Analyzed business requirements, identified acceptable solutions and then developed designs for new applications and modifications to existing applications.
- Created queries and reports using Business Objects tools for Region managers, Account Executives, correspondents, Programs, Loans, Rates locks and IT.
- Determined best methods for extracting data from databases and interacted extensively with users to summarize requirements.
- Worked as a Report Developer with expertise in Designer, Supervisor, and Reporting tools.
- Involved in generating and monitoring daily, weekly, monthly, and yearly reports including some critical reports like Year End report, summary report, and Rate Locks Report for management review.
- Created user ID's and Categories by using Supervisor tool.
- Created complicated stored procedures and trained co-workers on Business Objects.
Environment: Oracle 9i, Data warehouse, Business objects 6.5 and WEBI.
Confidential
Application Support Developer
Responsibilities:
- Involved in the design review of the projects assigned as a support lead and made sure the projects were designed and developed in compliance with the audit check list and turn over to support document is fulfilled.
- Followed and completed Root Cause analysis and action items on all the problem management tickets assigned.
- All of the Sev1, Sev2, Sev3, and Sev4 tickets are closed and none of them are past the SLA. Maintained SLA more than 99% all the time.
- Based on the action items in problem management for applications supported, the Sev1 and Sev2 tickets have reduced significantly.
- Reviewing the ASG audit checklist on existing application's to proactively identify any potential audit deficiencies.
- Developed GUI using Oracle Forms
- Developed Reports using Oracle Reports
- Developed Batch Reports using SQR
- Developed Unix Scripts and CRON jobs
- Developed Database objects using PL/SQL
- Production Support for Loan Origination Applications viz. MUPIT & MOAI
- Quality Assurance/Broker Restriction: Allowing Quality Assurance group to get reports/data to perform quality assurance process. Facilitate to restrict broker for selected states and/or products.
- Automated Note Review: Automated Note Review by integrating with OCR application (third party software).
Environment: Oracle 8.1.74 / 9i, Oracle Developer (Forms 6i, Reports 6i), PL/SQL, SQL, UNIX, SUN Solaris, Windows, Oracle Application Server, Java, JDK 1.4.x