SUMMARY:

• Six+ years of extensive experience in Report Design, Development, Analysis, testing and implementation of various multi complex secure reports from multiple database environments using Crystal Reports, Excel, SQL Server Reporting Services, Oracle,DB2.
• More than 7 Years of experience with Crystal enterprise 9.0/10,XI, BOXI R2,R3.
• Extensive experience in creating reports with Charts (bar chart, Pie Chart, chart…etc), Cross-tabs and Subreports and Drill down Reports.
• Experience in Creating Summary and Detail Reports.
• Extensive Experience in Creating Dashboard Reports and Trending Reports for Executive Level data.
• Experience in retrieving data from Business Objects Universe, Personal Data Files, and Stored Procedures.
• Report development using Crystal Reports XI/10.0/9.0,SSRS,SSIS, Oracle, MS T-SQL and Stored Procedures.
• Experience in working with Reports where data has been shared across Subreports.
• Extensively worked on Oracle 10g/9i/8i, SQL Server 2005 database tuning, triggers, stored procedures, data migration.
• Excellent experience in writing and implementation of the Packages, Triggers, Stored Procedures, Functions, Views, Indexes at Database level and Form level using PL/SQL T-SQL.
• Excellent Experience inSQL/PL SQL Query Optimization
• Extensive Experience in Unix Shell Scripting
• Experience in Scheduling Reports on Crystal Enterprise
• Experience in Crystal Enterprise Administration which includes security based on User Groups,Creating User Groups ,Data Sources and managing Folders.
• Experience in Creating, Deploying and Scheduling SSIS Packages.
• Very Good Experience writing queries for Ad-hoc Report Requirements.
• Ability to understand and write SQL and Stored Procedures in Oracle and SQL Server
• Extensive Experience in gathering Requirements from Business Users and Convert those into Technical Specs for Report Design and Development.
• Experience in Documenting Report Specs and Business specs.
• Experience working as an Analyst at times Analysing requirements and translating those requirements between Business Users and report Developers.
• Excellent logical programming skills with a good understanding of business process and software development conceptual life cycle methodologies.
• Ability to Handle Multiple Projects,work independently and also in a team Environment to meet Project Goals and Objectives.

TECHNICAL SKILLS:

RDBMS : Oracle 10g/9i/8i,SQL Server 2005,MS Access.
Reporting Tools : Crystal Reports (XI/10/9.0),Crystal Enterprise (XI/10/9.0),BOXI, Microsoft Visual Studio ,Report Builder and MS Office 2000,Business Intelligence Developer Studio.
Languages : SQL and PL/SQL, T-SQL, JQuery.
Operating Systems : Windows XP/2000/NT 4.0/98, UNIX. 
Version control tools : PVCS, Visual Source Safe, Clear Case.
Advanced Skills : HTML/DHTML, Java Script,
Other tools : MySQL 4.1, Rapid SQL 7.2, TOAD, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential,Herndon,VA Sep’09-Current
Sr Reports Developer

• As part of the Metrics and Reporting Team,Supported Order Management System Enterprise(OMSE) Application Reporting For Digital Phone Business.
• Designed and Developed Daily BAU Reports,Weekly Reports,Monthly Performance Scorecards and Audits for Order Flow,Process Compliance,TN Admin,TN Management Groups and Individual Divisions.
• Interacted With Business Users and Subject Matter Experts to Gather Business Requirements and Write Technical Specification Documents.
• Wrote PL SQL Packages using Stored Procedures and Cursors to pull the data and perform various logics to accommodate Complex Report Requests.
• Created Oracle Views and Functions For Various Business Needs.
• Worked with DBA Team to Develop a Process For Production data push in to Reporting data Base on a Daily Basis.
• Created an Automated Data Load Process for Billing data using Shell Scripts, SQL scripts,Control file and Crontab Jobs.
• Executed Explain plans to get the Cost of the Queries and created Indexes on tables to improve the performance of the SQL Queries by eliminating Hash joins and full table scans.
• Performed a Monthly TN Reconciliation Audit to Identify Fallouts Between TWC Billing ,Switch and Sprint Systems using SQL Scripts and Access.
• Created Monthly Service Delivery Metrics Scorecard Dash Board for TWC Performance Center Reflecting Key KPIs to Gauge the Divisions Order Flow Performance.
• Created Daily and Weekly TPV Reports For Third Party Verification By Comparing TPV Data from 3PV vendor and OMSE Orders by using SQL and Shell Scripting in Crontab.
• Performed a Quarterly E911 ALI DBMS Audit for 911 Address Reconciliation Between TWC and Sprint and FTPed the files to Sprint.
• Supported the GIA Reporting As part of the GO IT ALONE Project(GO IT ALONE PROJECT is a Number Migration Project to Migrate All the SPRINT Related Telephone Numbers to TWC as TWC is Now it self a CLEC and Nuestar as its Vendor).
• Created Daily GIA BAU Reports Using Crystal Reports XI and integrated them On MARS Reporting Web Site.
• Created Crystal Reports using Subreports,Crosstabs and Charts to Show Monthly Summaries and Trends.
• Created Parameters to pull the data into a Report based on User selection Criteria.
• Maintained User Groups,Folders and Administered Crystal management Console and Crystal Enterprise XI.
• Wrote Shell Scripts and Scheduled Jobs in Crontab to Automate Daily Reports.
• Created Dashboard Reports using Pure Share Dashboard Application By Creating Active Metrics and Widgets.
• Handled Multiple Projects and Assignments Simultaniously (Ex ..GIA and TWC BAU) and Independently.

Environment:Oracle 10g,SQL/PL SQL,Crystal Reports XI R2,Crystal Enterprise XI R2,Unix,JQuery,XML,CSS,MS EXCEL,MS ACCESS,TOAD,Putty.

Confidential,Pittsburgh,PA Apr’09 – Jul’09
Reports Developer

• As a Part of the Crystal to SSRS Migration team Analysed 200+ Crystal Reports in 8.5 and XI for migration.
• Designed and Developed Reports in SSRS 2005 replicating all 200+ Reports in Crystal Reports for different Business Units like Billing,Finance,Information Management,Legal,Marketing,Portfolio Management,Retail and Sales.
• Optimized Stored Procedures in SQL Server 2005.
• Created Report Templates for Different Business Groups to enable the Same Report for PDF and Excel Exports.
• Developed and Deployed Reports on to the Reporting Server.
• Involved in the Analysis of the Report Data.
• Did Unit Testing of the Deployed Reports.
• Created database objects like tables,stored procedures and views.
• Documented Business Requirements and Technical Specs for the Report.

Environment: Crystal Reports 8.5/XI,Crystal Enterprise XI, windows 2000,SQL Server 2005,Business Intelligence Developer Studio,SQL Server Management Studio.

Confidential, Hartford, CT Nov’07 – Dec’08
Crystal Reports Developer

• As a Reports Developer for Application Technical Services Team,Supported ‘REMEDY’ Application which is a Ticket tracking tool.
• Interacted with Business Users to gather the Business Requirements and Converted those into Technical Specs for Report Development.
• Wrote Oracle Stored Procedures and Packages to Extract Data on a Daily Basis from application Database to Reporting data base.
• Tuned SQL/PL SQL Queries to improve the performance using Explain plan and creating indexes.
• Created User Interactive Drill Down Reports
• Created Cross tab reports For Monthly summary of Incident Tickets.
• Published Crystal Reports to a web server called Crystal Enterprise on Crystal Server.
• Managed and Scheduled Published Reports Using Crystal Managemt Console.
• Enhanced all the Reports for REMEDY from version 4 to Version 7.
• Consolidated 20 odd Reports to 10 by implementing Report Export functionality for Excel and PDF in a single Report.
• Wrote UNIX Shell scripts to Schedule all the SQL and Pl/SQL scripts for the Report database in Crontab.
• Maintained the Reporting database.
• Analysis of the Report data to meet the Business Requirements.
• Involved in Migration Of the Reporting Environment from Crstal reports XI to SQL Server 2005 Reporting(SSRS) which includes the following
• Setting Up the new SQL Server 2005 environment.
• Creating a Reporting Database in SQL Server 2005 which replicates the previous one in Oracle/Crystal Environment.
• Collected and analyses business requirements, documented the Technical Specifications.
• Analyze the existing database and entities using Visio.
• Logical data modeling and schema designing to fulfill business requirements.
• Involved in creating ER-diagrams, normalization and mapping the data into database objects
• Created numerous complex tables, functions, views, procedures and triggers
• Maintain database integrity, update database statistics and re-indexing
• Performance Tuning using SQL Profiler, Database Engine Tuning Advisor
• Mapped various entities between the existing database with the newly created one
• Build table relationships and wrote stored procedures to clean the existing data
• Design SQL Server Integration Services (SSIS) package to extract data from Remedy 4 & Remedy 7 and load data in different segment tables in Reporting database.
• Checked data consistency by creating SSIS package
• Worked with SSIS to integrate heterogeneous data into centralized system.
• Designed and implemented numerous Stored Procedures for data staging and data manipulation
• Regular responsibilities for updating staging and dimensional databases in SSAS
• Implemented multidimensional cubes with MDX in SSAS to support high speed and flexible analytics
• Developed Weekly reports for Incident Management, Change Management, Release Management, Problem Management and Known Errors areas of the application in PDF and Excel formats using SSRS.
• Created and deployed ad hoc reports using SSRS and delivered to users.
• Involved in design user applications in .NET with C#
• Documented database objects for further use or upgrades
• Deploying Reports to Reporting web site.
• Building Custom Views and integrating with Web Applications to give users self Report designing functionally using Report Builder.

Environment: Crystal Reports XI/Crystal Reports 2008,Crystal Enterprise XI,Microsoft Windows Server 2003 standard edition,Unix,SQL,PL/SQL,Oracle 9i,EXCEL,SQL Loader,TOAD for Oracle 9i,
SQL Server 2005,SSRS 2005,SSIS,SSAS,Mcrosoft Visual Studio 2005,.NET,Business Intelligence Developer Studio,Shrepoint.

Confidential, Herndon, VA Oct’06 - Oct\'07
Crystal Reports Developer

• As a Reports Developer for Operations Analysis and Reporting Team, Supported Digital Phone Services
• Supported Digital Phone Order Management (DPOM) System by developing Reports for individual Divisions which are actually implementing the application.
• Supported Order Management System enterprise (OMSe) which is a replacement of DPOM system by developing daily reports for the data integrity.
• Involved in Creating Data Mart in Reporting Server which basically pulls data from OMSe, DPOM, DPOM Lite, TN Inventory and Billing (ICOMS, CSG) systems and integrate them by usingPL/SQL and UNIX scripts.
• Have used SQL Loader to load data from Billing and other systems data feed into oracle tables.
• Wrote complex SQL Queries and PL/SQL to pull data from DPOM and OMSE Systems into Report database.
• Wrote UNIX Shell scripts to Schedule all the SQL and PL/SQL scripts for the Report database in Crontab.
• Wrote complex Stored Procedures, Packages and Functions for special Reporting data needs.
• Developed common functions (like GetBusinessDays, GetStatusDate, IsHoliday, GetLatestOrderstatus …) in oracle which are used across all the procedures and SQL queries.
• Involved in Maintaining the Report database which includes creating Tables, Indexes,
• Triggers and analyzing the tables.
• Involved in creating reports and data pull for “WILD CAT Migration” project. The Wild cat Migration Project is basically migrating all the verizon native telephone numbers associated with the Digital phone customers to Sprint.
• Involved in E911 Audit, DL Audit, PL Audit and provided analysis reports on regular basis.
• Involved in Design and Development of Various Organization level Complex Dashboard Reports
• Created and maintained daily ,weekly and Monthly Business as Usual reports for different Functional units within the Organization like Compliance Group, Order Flow management(OFO) Group, Network Planning Group,TN Management Group
• Created monthly dashboard Reports for Residential and Commercial Digital Phone Orders
• Created weekly Forecasting Reports for both Residential and Commercial Digital Phone Orders.
• Designed and Developed Service Level Agreement (SLA) reports for the Carrier Relations group for cost recovery from Sprint.
• Developed Monthly Residential Trending reports , commercial Trending reports and Compliance trending reports
• Maintained Crystal management Console by creating different user groups, granting permissions and creating different folders for saving various reports for groups.
• Scheduled the reports in Crystal Management Console (CMC).
• Published all the crystal reports on Crystal enterprise for remote client access.
• Involved in data analysis and testing of the reports.

Environment: Crystal Reports 10,crystal Enterprise 10, Unix,SQL,PL/SQL,Oracle 9i,EXCEL,SQL Loader,SQL Developer,TOAD for Oracle 9i

Confidential,Naperville,IL Mar’05 – Sep’06

• As a Crystal Reports Developer ,supported the Customer Care Service
• Involved in Gathering business requirements and developing various types of reports according to the business requirements with Oracle 9i as backend.
• Involved in Repointing reports from legacy to Oracle 9i
• Involved in Redesigning existing reports.
• Developed various reports included sub-reports, cross-tabs, standard reports.
• Involved in writing the stored procedures and improving the performance of some procedures to make the reports run faster.
• Wrote SQL queries to pull the data for ad hoc reports.
• Involved in Populating reporting tables with the data from text files on daily basis using SQL Loader
• Wrote Packages and functions for custom data for different user groups.
• Involved in Performance tuning of the existing SQL and Pl/SQL Queries
• Developed Parameterized Reports which has to take certain condition value for the data extraction.
• Developed reports with formulas and running totals for weekly and monthly utilities collections.
• Developed Liheap reports which give all the account Numbers that have excessive credit and the type of payoffs.
• Developed Reports for the disconnected connections depending on service Agreement status and Utilities.
• Created design for running multi flavor reports like – Date, Weekly and monthly as well.
• Created various reports like the Combined Queries, Drill Down and Master Detail for easy analysis of reports.
• Added new report sections and applied suppression logic to print and not to print based on the conditions.
• Have done Report Validation for the generated reports to test and sent it to the production.
• Used PVCS to extract the reports to modify (check-in and check-out process).
• Involved in Migration Of the Developed reports to the Crystal Enterprise .

Environment: Crystal Reports 10.0 , Crystal Enterprise 10.0, Oracle 9i,legacy ,Rapid SQL 7.2.0,PVCS, SQL,PL/SQL,HTML,SQl Loader.

Reports Developer

• Involved in developing complex reports with SQL-Server 2000 as backend programming according to the business requirements.
• Wrote store procedures and developed reports based on the requirements.
• Was involved in Hot-Que application changing the store procedures,Table columns, adding new columns to the reports according to the requirements.
• Worked on various reports which involved developing and exporting reports to PDF, EXCEL and HTML format based on the end user requirements.
• Developed various reports included sub reports, cross-tabs, standard reports.
• Have written formulas and created parameter fields depending upon the selection criteria.
• Used cursors and temp table to hold the result set and loop within the store procedure.
• Have developed the physical design document based on the logical design according to the business requirements.
• Have developed test cases and test plans according to the business requirements.
• Have done unit testing for the generated reports to test and sent it to the production.
• Created parameterized Crystal Reports using sub-reports, Running Totals, Cross-Tab reports.
• Involved in modifying old reports.
• Used clear case to extract the reports to modify (check-in and check-out process).
• Developed tax form reports based on Quarter ended and year-ended.
• Added new report sections and applied suppression logic to print and not to print based on the conditions.

Environment: Crystal Reports 10, Crystal Enterprise 10.0, MS-Access, SQL-Server2000, PL/SQL, HTML, and Java Script