SUMMARY:

• I will bring 9+ years of significant experience in Design, Development, and Implementation of complex canned & ad - hoc reports and Business Intelligence solutions using Crystal version v9 thru v2013 and Business Objects v XIR2 thru SAP BO v4.1 platform.
• Extensive experience in all phases of project life cycle including requirements gathering, developing prototypes, functional specification, design, implementation, debugging, testing, and documentation specifically defining traceable, understandable reporting requirements.
• Hands on experience with development of multiple reports in Web Intelligence, Desktop Intelligence, Dashboards and Crystal Reports.
• Extensively used the Business Objects Reports Designer to develop new reports, modify the existing reports and migration of old reports from versions XIR2 to 3.1 and 4.1 and migrating Crystal reports from version 10 to XIR2 to 2008.
• Experience on working with Business Objects Info View for publishing and scheduling the Deski, Webi and Crystal reports.
• Expertise in Star Schema Modeling, Snow Flake Modeling, fact and dimension table design, physical and logical data modeling. Knowledge in dimensional data modeling.
• Experience in query optimization for fine tuning the report performance by 4 to 5 times.
• Excellent development knowledge of Business Objects tools such as Universe Designer, Desktop Intelligence and Web Intelligence documents.
• Developed Webi documents with Drill down, Slice and Dice, charts and Alerts.
• Created various complex reports using the multiple data providers, multiple prompts and synchronized the data providers to create the common report for different users.
• Have developed so far 300+ new Crystal reports as well as enhancing old reports.
• Have developed crystal reports using features such as graph, cross-tab, sub-reports, dynamic cascading, alerts, running total, conditional formatting by using databases like Oracle and MS-SQL Server as well as universes as data source.
• Excellent authority on developing the reports in Crystal Designer using connections for Business View Manager, Commands, Views, Stored Procedures, Base Tables and BOBJ Universe.
• Have worked with very large size of terabytes of dataset for efficient data retrieval.
• Extensively used the Crystal Reports Designer Templates to develop a Template reports for enterprise wide report standardization.
• Worked in implementing ETL process in the team to maintain and enhance the reporting needs in large sized data warehouses.
• Worked closely in creating test cases, performing UAT and testing reports and universes to ensure quality delivery.
• Possess excellent communication, self-starter and a team player. Capable of working independently as well as motivating a team of professionals, decision-making, problem solving, analytical, and interpersonal skills, and quick learner with result oriented dedication towards goals.

TECHNICAL SKILLS:

Reporting Tools: Crystal Reports 2013/ 2011/ 2008, XIR2, XI, 10, 9Business Objects 4.x/3.1/XIr2, Infoview, Webi R2, XcelsiusCrystal Enterprise XI/ 10/ 9, Oracle Report Builder, Cognos, MS Excel

Databases: Oracle 11g / 10g/ 9i/ 8i, MS SQL 2005, 2000, Teradata 11, DB2 9, MS-Access

Data-Warehouse: Star Schema, Snowflake Schema, Data-marts

Operating Systems: Windows 8/7/XP/2000, UNIX, Windows Server 2008 R2/2005/NT/ 2000/ Adv Server

Scripting Languages: Visual Basic, HTML, XML, SQL, PL/SQL, T-SQL

Misc. Tools / Technologies: Toad, SQL Navigator, MS Office, Visio, MS IIS, HP Quality Center, MS Visual Source Safe

WORK EXPERIENCE:

Sr. Crystal Reports Developer / BO Developer

Confidential, NYC

Responsibilities:

• Worked with Business Analysts and all level of End-Users from various departments in finalizing the report requirements, developing report specification
• Involved in all phases of design and Development of Business Objects, Crystal Reports Applications.
• Worked on Business Objects using Universe designer, Web-I, Crystal Reports and Dashboard reporting
• Created several reports using Cross tabs, Complex Views, SQL Command Object, System Functions and Stored Procedures applying also Universes in Business Objects XI R3/Crystal Reports 2008/2013.
• Created new universes and also involved in updating existing universe.
• Designed Complex Crystal reports using Summaries, Parameters, Hyperlinks, Custom functions, and Formula fields, .conditional formatting, TOP N, sub reports linked with main and sub-reports, Dynamic cascading prompts for parameter passage, cross tabs
• Extensively used Shared variables between Main and Sub report.
• Created reports by Grouping, Filtering, Sorting, and Summarizing Data in crystal reports.
• Developed several Complex Reports using many features such as multiple groupings, drilldowns, parameter fields, formulas and conditional formatting) using BO Webi and Desktop Intelligence.
• Working in Data warehouse with DBA for creating and modifying stored procedures using PL/SQL.
• Involved with DBAs for recommending new Indexes on tables for performance boosts.
• Worked with all types of Data warehouse schemas including Star schema, Snowflake schema and Summary tables.
• Responsible for production troubleshooting, Optimizing, and fine-tuning the SQL Queries Reports.
• Published reports in development and UAT environments for business analysts and testing team to test these reports in Enterprise with heavy data for performance tests.
• Involved in scheduling and publishing reports using InfoView for distributing by email for users as well as helping to schedule monthly, quarterly and yearly-closing report.
• Involved in Tuning and improving the performance of reports
• Involved in creating Dashboards using Xcelsius 2008 and exported to Flash files to use in crystal Reports
• Involved in enhancing Data Models with DBAs specifically for reporting requirements.
• Responsible for creating test plans in Test and Prod-Ready environments to test reports before moving to LIVE.
• Involved in upgrade evaluation team (for BO v3.1 TO v4.1) for assessing impact of reports upgrade.
• Documenting all users manuals, technical documents such as Report Requirement & Specification.

Environment: Crystal Reports 2008/2013, Business Objects Enterprise XI R3, Xcelsius 2008, Oracle 11g, Oracle SQL Developer, Toad, HP Quality Center, Windows XP/7

Sr. Crystal Reports / BI Developer

Confidential, NY

Responsibilities:

• Worked in Full Life Cycle Design and Development processes of Business Objects and Crystal Reports Applications.
• Interviewing users to gather the requirements and document.
• Designed reports in Crystal reports against Oracle database containing tables and views
• Involved in documenting the Report Specifications, interacted with Business Users and gathered technical/functional requirements to develop standard and ad-hoc reports.
• Extensively used advance features of Business Objects Enterprise like Passing Parameters to other reports and to call one report from other
• Created Dynamic prompts using Business View Manager
• Developed several Complex Reports (various features included multiple groupings, drilldowns, parameter fields, formulae and conditional formatting) using Crystal Reports.
• Also used the Date Time, Ranges and String functions
• Worked with Dynamic Cascading prompts to get the most recent and specific data for the parameters selected
• Worked with all types of schemas including Star schema, Snowflake schema and Aggregate tables.
• Worked with Select Expert, Section Expert, Group Expert, Template Expert and Record Sort Expert in Crystal Reports.
• Also shared the Custom functions created with other developers using Repository and Enterprise Explorer.
• Created Dashboards using Xcelsius data interactively.
• Involved in creating Views and Store Procedures, which is use as a data source for designing reports.
• Involved in migrating Cognos reports to Crystal Reports.
• Provided the post-production support as needed to overcome the issues faced during the migration of reports from Development to Production

Environment: Crystal Reports XI R2/2008, Xcelsius 2008, Business Objects XI R2/R3, Oracle 10/11g, DB2, Cognos, SQL Navigator, Windows XP/7

BI Consultant (Business Objects / Crystal Reports)

Confidential, Hartford, CT

Responsibilities:

• Interacted with Users and worked with Business Analysts to gather requirements for the Reports and creating templates and finalizing the requirements to create standard requirements documents. Mostly involved in making Changes to the existing and creating new reports as per documents.
• Designed, developed and maintained various Complex reports like sub-reports with links, Report templates, Master/Detail Reports, Summary, Parameterized and Cross-tab reports.
• Involved in administering Crystal Report Enterprise
• Responsible to update template Text Objects, Logos, Commands in the Crystal Repository for other developers to share them
• Based on Requirement Created complex crystal report using the data from SQL Server and Oracle server database.
• Responsible for improving report processing performance.
• Designed few Universes for database-underlying complexity and hidden from users.
• Involved with DBA to design Disaster recovery plan, Resolving the database connectivity issues
• Worked with database developers in mapping the fields in the requirements to actual tables in Oracle and created the SRS documents
• Responsible for Creating Views in SQL to protect some of the columns of a table from other users, to hide complexity of a query and to hide complexity of calculations.
• Performance tune and do the formatting fixes on the existing reports. Also involved in writing Stored Procedures for better performance.
• Published reports in different development and UAT environments for business analysts to test these reports in Enterprise and sign off
• Scheduled Reports from Crystal Enterprise enabled Email notification on failure reports.
• Documentation to describe Program Development, Logic, Coding, Testing, changes and corrections
• Responsible to support the issues with reports on the crystal enterprise environments

Environment: Windows XP, Crystal Reports XIR2, Business Objects Enterprise XIR2, Teradata 11

Crystal Reports Developer

Confidential, Portland, OR

Responsibilities:

• Worked with all level of users and Business Analysts to gather requirements for the Reports and creating standardization as well as finalizing the requirements to create standard requirements documents.
• Developed several reports in Crystal reports 9 and 10 with features like Sub Reports, Detail Reports and Parameterized Reports.
• Creating reports include formatting options such as Charting, Mapping, Grouping, Sorting, Field highlighting, Drill-down, Parameter prompts.
• Created customized existing reports using sub-reports and charts to present information.
• Exported Reports into PDF from Enterprise and resolved formatting issues.
• Developed strategy to standardize the common objects for reports such as Text Objects, Logos, views and SQL Expression for other team members share. Also used Configuration Manager to configure the server settings and to start/stop the services.
• Based on Requirement Created complex crystal report using the data from SQL Server and Oracle server database.
• Responsible for improving report processing performance.
• Worked with database developers in mapping the fields in the requirements to actual tables in Oracle.
• Responsible for Creating Views in SQL to protect some of the columns of a table from other users, to hide complexity of a query and to hide complexity of calculations.
• Working with old reports for Performance tuning on the existing reports.
• Documentation to describe Program Development, Logic, Coding, Testing, changes and corrections.
• Responsible to support the production issues with reports on the crystal enterprise environments
• Modified Remedy interface in Visual Basic.
• Created several complex Stored Procedures, Views and integrated them with Reports.
• Worked closely with the DBA team to identify, resolve bugs and issues related to the Crystal Reports and Stored Procedures.

Environment: Crystal Reports 9.0/10, Crystal Enterprise 10, Oracle 8i and Windows XP, Windows Server 2003 Enterprise, Visual Basic 6, MS-Access