SUMMARY

• About 8 years of total experience in Information Technology Industry with expertise in Designing and Developing of Business Objects, Crystal Reports, SSRS and Data Warehouse applications.
• Extensive experience Designing and Developing Crystal Reports using Crystal Reports 8.5/9.0/10/11.5.
• Extensive Experience in Business Objects 4.0/XI R3/R2/6.X/5.X (Designer, CMC, Web Intelligence, Desktop Intelligence, Scheduler, Import wizard).
• Extensive experience Designing and Developing Reports using SSRS 2008/2008 R2.
• Experience in SQL Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Reporting services.
• Coding of Database objects like Triggers, Procedures, Functions and Views
• Experience in T - SQL (DDL and DML).
• Experience in migrating from SQL Server 2005 to SQL Server 2008
• Designed and Developed Crystal Reports such as List reports, Parameterized, Mail Label, Cross tab Reports using the base tables, Views, Commands, involving Formulas, Subtotals, Running totals and Sub reports.
• Good Knowledge of Data warehouses and Business Data marts with Star Schemas and Snowflake Schemas.
• Experience in Database Applications with Oracle, SQL Server, MS Access and very efficient in tuning the SQL queries and using several tools & utilities.
• Data replication experience using DB2 Data Replication (DPropR) from DB2 mainframe and DB2 to DB2
• Working experience in Relational Database Management systems (RDBMS), Star Schema and Multidimensional Data Modeling.
• Transform data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting.
• Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS).
• Top quality architecture and development skills using latest technologies including Java, C++, EJB, RMI, JMS, wireless technologies and in-depth knowledge of J2EE.
• Experience in coding using SQL, SQL*Plus, PL/SQL Procedures/Functions, Triggers and Packages. Extensively involved in installation of Oracle database, performance analysis, tuning, and capacity planning.
• Strong experience in single and multi-dimensional data warehousing applications using Business Objects Enterprise and Business Intelligence Products.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Worked on canned reports and Complex Ad-hoc reports using Business Objects and Web Intelligence tools.
• Good Knowledge with Installation of BOXI R2/R3.
• Good communication skills and has ability to implement projects with demanding objective.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, HTML,JAVA,J2EE,.NET

Database: Oracle 8i/9i/10g/11g, SQL Server 2000/05/08, Sybase, DB2, MS Access.

Tools: Crystal Reports2008/XI/10/9, SSRS 2005/08/ 08 R2, Business Objects 4.0/XI R3/R2/6.X/5.X, QaaWS, CMC, Designer, Business View Manager, Info View, Web Intelligence, XCelsius.

DW Methodologies: Data Warehousing Design, Data Modeling, Logical and Physical Design.

Others: ERWIN 4.1.2/4.x/3.x, Visio, Excel, version control, SQL Navigator, SQL Developer, TOAD, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

SQL Server/ Rapid SQL/Crystal Reports Developer/ Business Objects Developer

Responsibilities:

• Involved in project planning, gathering requirements from the users, creating spec and layout of the report.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Extensively shared and global variables across crystal reports.
• Making changes to existing reports and new reports from ICD 9 to ICD 10 codes.
• Used Footprints tickets for version control of the reports to know the status of the report.
• Enhance/modify existing reports by creating new Parameters, Formulas etc,
• Schedule the reports using Info View to run at specific times in a day/week as desired by the Business Users.
• Assist BO administrator in setting up security for various reports on Enterprise
• Responsible for setting up the Database logon info and parameters on Info View for the users to run the reports.
• Interact directly with the business users in gathering requirements.
• Optimize various SQL queries to make the reports run faster.
• Used SQL extensively in command objects of Crystal reports.
• Create test data by creating views/procedures for reporting purpose.
• Create and edit alerts on Reports, as per User request.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Migrate reports from Dev to Production.
• Provide on call support after reports are deployed to production.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
• Use prompts, alerts, drill down analysis as per the end user requirements.
• Create nested, conditional subgroups and formatting features in reports.
• Create Sub reports called from the main report to implement the business logic.
• Create various database objects like Tables, Views and Stored Procedures by using Toad.
• Responsible for defects raised during testing of the reports.
• Work on existing reports to optimize and troubleshoot problems that occurred due to new business requirements.
• Move the reports from Dev to QA and inform the users to start UAT.
• Assist UAT team in testing the reports using SQL queries in TOAD, SQL developer and Win SQL and advise them with necessary changes.

Environment: Crystal Reports XI R2, Crystal Info View XI R2, Oracle 10g/9i, PL/SQL, TOAD, SQL Developer, Win SQL, UNIX, Windows XP.

Confidential, TUCSON, AZ

SQL SERVER Developer/ Crystal Reports Developer/ SSRS Developer

Responsibilities:

• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Involved in Daily Stand-Up meetings with Project manager and development team on reports and their road blocks.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
• Developed Tabular, Drill Down, Parameterized and sub-reports using SSRS.
• Exported Crystal reports into various Formats like PDF, Excel and Word for the Users.
• Performed analysis and collection of claims data involved in scheduling the daily, weekly, monthly Crystal reports Using MS Access.
• Extensively developed user interfaces and tools using MS Access.
• Created various SQL scripts for verification of the required functionality.
• Developed SQL scripting for regular maintenance and production support to load the data in regular intervals.
• Developing complex SQL queries, Stored Procedures and packages using T-SQL.
• Creating database objects like Tables, Indexes, Stored Procedures, and Views.
• Created various Low, medium and complex reports using drill down on various levels, grouping, filters, parameters and sorts.
• Configured SSIS packages using Package configurations wizard to allow package run on different environments.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS 2008 and SSISin Business Intelligence Development Studio (BIDS).
• Experience in PROD issues, creating tickets in footprints, tracking the tickets, viewing, Updating and making them resolved.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Created Standard Reports, Cross-tab Reports, Sub Reports and Drilldown Reports using Crystal Reports 11.5.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
• Developed the reports as well as got them done by team on time for the releases.

Environment: AMS Advantage, Crystal Reports 11.5, MS Access, Business objects XI r2, Web Intelligence, T-SQL,SQL Server 2008 R2/SSIS/SSRS, Footprints, AMS info advantage.

Confidential, RICHMOND, VA

SQL Developer/ Crystal Reports Developer/ Business Objects Developer

Responsibilities:

• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution. Involved in documenting the changes to the universe and reports functionality.
• Designed and developed Crystal Reports such as Parameterized Reports, Cross tab Reports, Mail label, List reports based on base tables, views, involving Formulas, Sub Totals, Running Totals, and Sub Reports.
• Modified existing codes, SQL Packages to perform certain specialized functions and enhancements on SQL SERVER Application.
• Created views to restrict access to data in a table for security
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience working with XML documents.
• Experiences in writing VB scripts for user define functions inSSRS
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Designed and Developed matrix, tabular and parametric Reports using SSRS 2008.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Responsible for report generation using SSRS and Crystal Reports based on business requirements.
• Mortgage Application and customer care & billing (AMDOCS) in the SIT, UAT and Regression Testing.
• Experience in testing and development. Migrating the low, medium, high complex reports from Crystal reports to SSRS
• Deploying and scheduling Reports usingCrystal Reportsto generate all daily, weekly, monthly and quarterly Reports including current status.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users and Free-hand SQL as data provider.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Expert in tuning the performance of SQL queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Environment: SQL server Reporting Services(SSRS), Crystal Reports XI, Business Objects XI r2/65, Web Intelligence, T- SQL, SQL SERVER 2008.

Confidential, Monroe, MI

Crystal Reports/ SSRS Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Involved in documenting the changes to the universe and reports functionality
• Created Crystal Xcelsius Dashboard through the Use of Query as a Web Service.
• Responsible for report generation using SSRS and Crystal Reports based on business requirements.
• Extensively generated applications in MS Access using Crystal Reports
• Visually represented the data using chart wizard and also developed different type of reports using chart wizard like Pie chart, bar chart and column chart.
• Developed the code using C# in Custom Code report (SSRS) property and used the code in expressions to meet the requirements.
• Worked and interacted with Business Analysts working with different aspects of the project and requirements needed for generating Crystal reports and Web Intelligence Reports.
• Extensively used Business Objects Designer module to make changes to existing Universes by editing joins between the table’s, creating pre defined conditions, prompts and applying contexts and Alias to avoid cyclic dependencies.
• Created New Classes and User Objects according to the requirements.
• Validated the data of reports by writing SQL Queries.
• Configure and customize STARLIMS using Crystal Reports XI.
• Expert in tuning the performance of SQL queries.
• Created various simple and complex reports using drill down, filters and alerts.
• Created Standard Reports, Cross-tab Reports, Sub Reports and Drilldown Reports using Web intelligence/Crystal Reports XI.
• Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts for creating Business Objects reports.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Environment: Crystal Reports XI, SSRS 2008, SQL SERVER, T-SQL, Windows XP

Confidential

Crystal Reports Developer

Responsibilities:

• Involved in gathering the requirements to create the reports by conducting user interviews.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
• Exported Crystal reports into various Formats like PDF, HTML, Excel and Word for the Users.
• Created contexts and aliases for resolving loops in the Universes.
• Performed analysis and collection of claims data involved in Scheduling the monthly, weekly Crystal reports Using Crystal Enterprise.
• Use of Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Creation of reports like, reports by product, reports by customer, reports by period and comparative reports.
• Generated multi-dimensional reports using Info View.
• Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Created reports using free hand SQL when the existing universe is not supported the report.
• Remedy Ticket Support for Business Objects and Crystal reports for Production Environment.
• Provided training to the users, developed user guides, training docs, requirement docs etc.
• Written PL/SQL programs on Oracle Database. Performed performance tuning.
• Maintained Supervisor by creating user accounts and assigning privileges.
• Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts for creating Business Objects reports.
• Extensively used Crystal Xcelsius to build Dashboards and Scorecard presentation.
• Created interactive excel dashboards and charts and graphs, created scorecards, metric analytics with Crystal Xcelsius.
• Created users & groups managed users like (resetting password, assigning privileges, enabling their ID's) & managed groups.
• Migration of universes and documents from one domain to another.
• Involved in designing logical and physical data Model designing.

Environment: Crystal Reports XI, Windows NT, Oracle 9i, SQL Server 2000, DB2, SQL, Remedy, MS OFFICE, Business objects XI R2, Toad, VB.Net, HTML, Apache Tomcat, ERWIN, PVCS, Manual Testing.

Confidential

Crystal Reports / Business Objects Developer

Responsibilities:

• Worked with business process owners in collecting Project specifications and their Analysis.
• Designed Crystal Reports using Crystal Reports 10, Formulas, Parameters, Selection Criteria, Sub reports to handle Report Requests
• Extensive experience in creating reports with Charts (Bar Charts, Pie Charts, etc), Cross tabs and Sub reports.
• Analyze Requirements and write technical specifications with the business analysts to develop Reports that conform to the enterprise standards.
• Access multiple different OLAP sources in the same report to get a comprehensive view of the business and the cross-impact that one trend may have on another.
• Use a comprehensive range of business and time calculations.
• Using Xcelsius created Dashboards and provides the ability to create management charts, which are at-a-glance displays that show the status of business metrics.
• Extensively participated in the development of the Universe based on underlying relational (data structures) star schema. Resolved several issues with regards to the contexts, predefined conditions, same prompts handling multiple data sources etc.
• Involved in Training, Quality Analysis and Production Support some of the users in developing the basic reports using Business Objects XI r2.
• Analyzed and created facts and dimension tables.
• Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

Environment: Crystal Reports 10, Business Objects 6.5.2/ XI R2, Xcelsius, Oracle 9i/10g, Web Intelligence, 6.5, Infoview 6.5, SQL Server 2005, Teradata v2r6,DB2, Microsoft Visio, Windows XP, ASP.Net, MS Access 2003, MS Excel 2003, Autosys.