SUMMARY

• Over 7 years of experience in designing and developing wide range of reporting systems using Business Objects XI R2/3.1, Crystal Reports 8.5/2008/2011 , Crystal Enterprise 10.0/9.0, SSRS, Oracle 10g, OBIEE 10g, MS Access 2007/2010
• Possess strong domain experience in Banking, Insurance, Health Care, Tele Communications, Production, Consumer Goods, SaaS Solutions.
• Around 5 years of hands - on experience of all SAP Business Object components, including but not limited to, Designer, Web Intelligence / Rich Client, Crystal reports 2008, Desktop Intelligence, Xcelsius 2008 / 4.5, Metadata Manager, QaaWS, Dashboard Manager, Import Wizard,CMC (Administration Console) etc.
• Expertise in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence (OBIEE/OBIA) in Marketing, Sales, Procurement modules
• Strong experience in Design, Development, Deployment, and Testing of Universes using Business Objects Designer against SAP BW, Oracle and SQL Server.
• Proficient in all phases of the Software Development Lifecycle, including Requirements gathering, Analysis, Data Modeling, Design, Development, System Implementation, Testing and Production Support.
• Hands-on experience in data analysis, data modeling, development,query optimization,performance tuningand trouble shooting.
• Deployed the reports on Crystal Reports Server 2008 and Scheduled Reports for the use of end users and customers.
• Good Knowledge of designing reports on Crystal Reports 2008 and Distributing through Business Objects Enterprise XI and Crystal Reports Server 2008.
• Extensive knowledge of creating Mockup Reports, User Permission Matrix, SSDS and SSRS.
• Converted Crystal Reports older versions to version XI and Converted Crystal Reports to SSRS.
• Major responsibilities include getting requirements from the business user and developing Crystal Reports. Maintaining proper documentation for all the work that has been done for future reference
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services
• Experience with multiple RDBMS including Oracle 10g, Microsoft SQL Server 2000/2005/2008 and Microsoft Access 2003/2007/2010.
• Extensive working experience in PL/SQL, packages, stored procedures.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel
• Developed custom Crystal Reports often with parameters, shared variables, sub reports, complex formulas, and conditional formatting.

TECHNICAL SKILLS

Reporting Tools: Crystal Reports XI/2008, Business Objects XI R2/3.1(Designer, CMC, Web Intelligence, WebI Rich Client and Desktop Intelligence), Crystal Enterprise 10.0/9.0, MS Reporting Services 2005/2008 and Xcelcious 2008

GUI: Visual Basic 6.0,VB.NET

Databases: MS SQL Server 2000/2005/2008 , DB2, Oracle10g/11g, MS-Access 2003/2007/2010.

Operating Systems: Windows 7 Professional/XP/2000/98,Unix

Languages: VBScript, JavaScript, C, C++, T-SQL, PL/SQL.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Crystal Reports Analyst

Responsibilities:

• Responsible for developing reports for ACH, ACH operations, Commercial Lending, Content Management System, workout, loan servicing, loan initiation and financial reports using Crystal Reports 2008,Crystal Reports 2012.
• Responsible for creating Mockup Reports, User permission matrix, SSDS, SSRS.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Installed and configure SAP Business Objects Enterprise 3.1 on prod environment and created Reports (PoC) for senior management and sales executives.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the Universes.
• Created hierarchy and conditions in the Universes.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects 3.1
• Used Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Functions and Master Detail
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the business requirements using WEBI.
• Create different report formats like Report Template, sub reports, cross-tab and standard reports.
• Developed reports with different and multiple parameter fields and multiple grouping for different
• Developed formatted and complex reusable formula reports, and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports.
• Used conditional formatting formula in parameters for color-flagging data that met client requirements.
• Involved in tuning of Crystal Reports for better performance and worked with Oracle 10g.

Environment: Business Objects 3.1, SAP Crystal Reports 2008,Crystal Reports 2012, SAP, Oracle 10g, Portico and Windows XP Professional

Confidential, NY

Qlikview Developer

Responsibilities:

• Involved in Requirements study, interact with the end users and responsible for gathering requirements
• Designed and developed dashboards and Score cards for senior management and sales executives using Qlikview 11
• Responsible for developing reports for Senior management using Crystal Reports 2011 using Salesforce.com data through ODBC connector.
• Initiated meetings with users to document report requirements and analyzed report requirements to identify opportunities for consolidation of similar report requests
• Installed Qlikview 11 on test environment
• Developed new reports and provided technical support for the report development team in all reporting tools
• Developed custom hierarchies to support drill down reports
• Tuned SQL for trouble shooting of reports for data accuracy and reports for better performance using SQL Explain plan
• Created documents like Business Requirements Specification, Technical Requirement Specification, Universe Design Document, and Report Maintenance Document
• Involved in Unit Testing, Integration Testing and Performance Testing of reports and dashboards
• Provided the highest level support for Qlikview Dashboards
• Work on requirement specifications for the strategic KPI\'s that drive performance and profitability in the division. Waterfall methodologies were followed during course of the project.
• Performed analysis, documentation for calculation for various attributes.
• Developed and conducted training programs for Qlikview user groups and administrators.
• Worked as a technical consultant for Qlikview. Was a part of the implementation life cycle.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities.
• Dashboards were served to track inventory and sales as well as to monitor various KPIs. Dashboards included customer detail drilldowns, threshold gauges and alerting mechanisms.
• Performed time over time analysis of sales and performance related data.

Environment: Qlikview 11, Qlikview server,Salesforce,Crystal Reports 2011,SQL Server 2008/20005 and Windows 7 Professional

Confidential, NJ

Sr. Reporting Analyst/Support Associate II

Responsibilities:

• Developed new reports on top of CPR+ data .
• Responsible for developing day to day billing operations and A/R reports using Crystal Reports 2011.
• Responsible for creating Mockup Reports, User permission matrix, SSDS, SSRS.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Installed and configure SAP Business Objects Enterprise 3.1 on prod environment and created Reports (PoC) for senior management and sales executives.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the Universes.
• Created hierarchy and conditions in the Universes.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects 3.1
• Involve in configuring Central Management Console
• Used Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Functions and Master Detail
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the business requirements using WEBI.
• Create different report formats like Report Template, sub reports, cross-tab and standard reports.
• Developed reports with different and multiple parameter fields and multiple grouping for different hierarchy levels and published them using the Crystal Reports Server 2011.
• Developed formatted and complex reusable formula reports, and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports.
• Used conditional formatting formula in parameters for color-flagging data that met client requirements.
• Involved in tuning of Crystal Reports for better performance and worked with SQL Server 2008.

Environment: Business Objects 3.1, SAP Crystal Reports 2011, SAP Crystal Reports Server 2011,SQL Server 2008, Mckesson, CPR+ and Windows 7 Professional

Confidential, NY

Sr. Crystal Reports Developer

Responsibilities:

• Provided Business Objects Universe design changes to address performance, usability, and data reliability issues.
• Create cross-tab and tabular reports and publish report templates using BIRT Studio iServer Edition.
• Use functions and computed columns in Birt Studio IServer edition.
• Designed and developed Xcelsius dashboards from Universe / Web Intelligence reports via QaaWS and Live Office.
• Developed new reports and provided technical support for the report development team in all reporting tools.
• Perform unit testing of reports and universe and logging all the defects and solution in Quality Center using JIRA.
• Provided the highest level support for Web Intelligence reports and Universe issues for the company.
• Created Reports using universe, stored procedures, and freehand SQL as Data providers and writing the complex queries including Sub Queries and Unions.
• Responsible for transitioning old reports into Crystal Reports 2008 and publish to Crystal Reports Server 2008.
• Responsible for developing day to day billing operations and contract reports using Crystal Reports 2008.
• Responsible for creating Mockup Reports, User permission matrix, SSDS, SSRS.
• Involved in Business User training
• 24/7 production support
• Initiated meetings with users to document report requirements and analyzed report requirements to identify opportunities for consolidation of similar report requests.
• Installed Xcelsius 2008, LiveOffice, QaaWS on test environment and created Xcelsius dash boards (PoC) for senior management and sales executives.
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the business requirements.
• Create different report formats like Report Template, sub reports, cross-tab and standard reports.
• Developed reports with different and multiple parameter fields and multiple grouping for different hierarchy levels and published them using the Crystal Reports Server 2008.
• Developed formatted and complex reusable formula reports, and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports.
• Used conditional formatting formula in parameters for color-flagging data that met client requirements.
• Involved in tuning of Crystal Reports for better performance and worked with Oracle 10g.

Environment: SAP Crystal Reports 2011,SAP Crystal Reports 2008, Birt 2.5,SAP Crystal Reports Server 2008, OBIEE 10g, Business Objects xi 3.1,Oracle 10g, Oracle SQL Developer 3.0.04 and Windows 7 Professional

Confidential, NJ

Sr. Crystal Reports Developer

Responsibilities:

• Responsible for development of standard reports in Crystal Reports 2008 and production support for the project.
• Responsible for developing currency transaction and wire exchange reports using Crystal Reports 2008.
• Responsible for creating Mockup Reports, User permission matrix, SSDS, SSRS.
• Involved in Business User training
• Merged, inserted, and moved section with section expert command.
• Create different report formats like Report Template, sub reports, cross-tab and standard reports.
• Created multiple sub reports with existing report and with report wizard.
• Developed reports with different and multiple parameter fields and multiple grouping for different hierarchy levels and published them using the Crystal Reports Server 2008.
• Developed formatted and complex reusable formula reports, and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports.
• Used conditional formatting formula in parameters for color-flagging data that met client requirements.
• Involved in tuning of Crystal Reports for better performance and worked with Oracle 10g.

Environment: Crystal Reports 2008, TOAD for Oracle 8.6.0.38, SQL Tools 1.5, Oracle 10g, and Windows XP

Confidential, Brooklyn NY

Database/Crystal Reports Developer

Responsibilities:

• Responsible for development of standard reports in Crystal Reports 2008 and production support for the project.
• Responsible for developing accounting, claim processing and supply chain reports using CR X1 R2.
• Merged, inserted, and moved section with section expert command.
• Various report formats developed include sub reports, cross-tab and standard reports.
• Created multiple sub reports with existing report and with report wizard.
• Developed reports with different and multiple parameter fields and multiple grouping for different hierarchy levels and published them using the Crystal Enterprise x1.
• Developed formatted and complex reusable formula reports, and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports.
• Used conditional formatting formula in parameters for color-flagging data that met client requirements.
• Inserted charts to display summary fields in 2-D and 3-D pie charts.
• Involved in tuning of Crystal Reports for better performance and worked with SQL Server 2008.
• Scheduled monthly and Weekly reports using Crystal Enterprise.
• Exported reports into various formats like PDF, HTML, EXCEL, and WORD for users.

Environment: Crystal Reports XI, SQL Tools 1.5, SQL Server 2008, and Windows XP.