SUMMARY:

• Highly qualified, innovative IT professional with extensive experience in the Software Application Analysis, Design and Development, Implementation and Maintenance. Well versed with the technologies such as SQL Server 2008 R2/2008/2000/7, Oracle, Crystal Reports 8/8.5/9.0/XI/2008/2011, Business Objects XI, SSRS 2008 /2005, Visual Basic 6, .NET Technology, Sybase and MS Access.
• Proficient in Analysis, Design, Development, Testing, Implementation and Maintenance of Business Application Software in Client/Server environments.
• Major responsibilities include getting requirements from the user and developing Crystal Reports, Testing and Maintaining technical documentation of the reports for future reference.
• Provided technical and analytical expertise in responding to Complex, Specialized Report requests requiring higher - level Data Analyses and Management services.
• Understanding and hands on experience of Software Development Life Cycle (SDLC), Software Architecture and writing of technical specifications and documentation as per user requirements.
• Experience in conversion of older version of Crystal Report to Crystal Reports XI.
• Worked with SQL, writing stored procedures and various versions of Crystal Reports and SSRS.
• Created report templates and their underlying queries to generate the required business reports.
• Develop various SQL reports using SSRS.
• Experience with multiple RDBMS including Oracle 9i/8/7.x, MS SQL Server 2008 R2/2005/2000/7, MS Access and Sybase 9.0.2
• Experience in Data Analysis, Business Intelligence, Data warehousing using Microsoft SQL Server Integration Services as ETL, SSRS as Reporting Services.
• Good knowledge in Visual SourceSafe.
• Guided, trained, instructed and assisted the team on technical issues.
• Analyzed and solved technical & performance problems which involved Database and application related issues relative to the performance of the application.
• Ability to Design, Code, Debug, Document and Support efficient computer applications and Reporting Service consistent with established specifications and business requirements.
• Databases used are SQL server2005, 2008, 2008 R2, SQL Server 2012, Data Quality Services, Data Explorer, Oracle 10g/11, My SQL 5.0.
• Good interpersonal skills with strong verbal and written communications to maintain effective work relationships with all levels of personnel. Capability to learn fast the latest trends and technologies.
• Commitment and conformance to delivering quality applications adhering to deadlines and hardworking, enthusiastic and highly committed to the growth and success of the organization.
• Team player with strong work ethic.

TECHNICAL SKILLS:

Front End Tools: VB.NET, ASP.NET, Visual Basic 6, Developer 2000

RDBMS: Oracle9i, Oracle 8, Oracle 7.3, SQL Server 2008R2/2008/2005/2000/7, Sybase, MS Access 2007

BI Tool: Business Objects XI 3.0, Business Objects BI4.0

Reporting Tool: Crystal Report 8/8.5/9/10/XI/2008/2011, SSRS 2008R2/2008/2005

Languages: SQL, T-SQL, PL/SQL, VB 6.0, C#, Tally Definition Language (OOPS Based Definition Language)

Presentation/Utility Tools: MS-Office

Operating System: Windows 7, Windows XP, Windows 2000, Windows NT, Windows 95/98, Novell Netware 6.5

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Senior Reports Developer

Responsibilities:

• Extensively worked along with the business users and provided various reports analysis and design.
• Develop complex SQL queries, stored procedures/functions to support reporting requirements and verified data accuracy.
• Design and develop various EMD reports like Incident Report, Activity Minutes Report, Food Facility Without Business Recycling Code, Body Art Lookup Report etc.
• Configuration of Inspection Check List on EnvisionConnect.
• Responsible for asserting data needs, data analysis, data extraction, report design and maintenance.
• Actively involved in technical discussions with the team that led to the improved design of the existing Reporting System.
• Assist developers in writing SQL queries and with report design.
• Designed and developed Cross Tab reports, reports with Sub-Reports based on a command object, Summary Reports, Drill-Down Reports, and Parameterized Reports. Used Crystal Report 2011 and complex SQL queries to accomplish this task.
• Extensively worked on SSRS reports that contained several Static and Dynamic prompts.
• Deployed and managed SSRS reports using Central Management Console.
• Responsible for giving User Access and setting restrictions to view the reports from Envision.
• Worked with the project manager and business users to gather requirements.
• Converted Access reports to Crystal Reports 2011 version.
• Extensively involved in using of Formula Fields, Parameter Fields, Running Total, Group Selection and Record Selection in Crystal Reports.
• Create Report template with header, footer and organization logo using Crystal Report.
• Responsible for communicating with Envision core team to enhance the reporting features in on their system.

Environment: SSRS 2008 R2, SQL Server 2008 R2, SQL, T-SQL, Crystal Report 2011, Visual Studio 2010, MS Access 2010

Confidential, Rocklin, CA

Senior Reports Developer

Responsibilities:

• Responsible for active involvement during the requirements gathering, analyzing and designing of the reporting system.
• Interact with the end users in identifying the requirements and develop design document.
• Develop and optimize Stored Procedures, Views, User-Defined Functions and SQL queries for the reporting requirements across various data source.
• Analyzing, designing, building and testing of HRA data using Crystal Reports.
• Integrate and deploy the Crystal Reports on CMC.
• Create Parameterized Reports, Charts, Cross-Tab and Sub-Reports.
• Troubleshoot data issues and validates result sets.
• Develop various operational Drill-through and Drill-down reports using SSRS.
• Design Cascaded Parameter report using different Data Sets.
• Responsible for financial data evaluation and testing to make sure that the data migration is up-to-date.
• Error handling and modification of existing reports as per the changing business process.
• Develop complex SQL queries efficiently as per the requirements for reporting needs.

Environment: SSRS 2008 R2, Oracle 11G, SQL, PL/SQL, Crystal Report 2011, Business Objects Enterprise BI4.0, Visual Studio 2010, TFS 2010, Excel 2010

Confidential, Nashville, TN

Senior Reports Developer

Responsibilities:

• Analyze and develop application reporting solutions involving combinations of platforms, networks, and database technologies.
• Proactive participation in the improvement and evolution of the organizations reporting capabilities.
• Responsible for developing the customized reports using Crystal Repot 2008 and SSRS 2008.
• Interface with the other teams and departments to understand business processes and challenges to help define requirements for reporting applications.
• Responsible for conversion of existing Crystal Report to SSRS Report for cost effectiveness.
• Schedule and Deploy reports to Business Objects Server the reports to be received in different formats for automation.
• Create complex reports which included sub-reports, Add Command, parameters, charts, multiple grouping & sorting, Functions, Cross-Tabs.
• Create the Joins, SQL queries, Functions and Stored procedures to pull data for reporting.
• Involve in resolving the issues and the various change request as requested by the user.
• Develop Parameterized Reports.
• Develop SQL queries to extract, manipulate the data for Performance Reporting.
• Involve in trouble shooting support and provide technical assistance by responding to user queries regarding errors, problems.
• Responsible for uploading and distributing Crash Data in SFTP site for various clients.
• Modify and enhance the existing reports to match changes in business process.
• Test all the reports and provide hand-over documentation of completed report.

Environment: Crystal Repot 2008, SSRS 2008 R2, Oracle 10G, DB2, Business Objects Enterprise XI 4.0, Excel 2007, Remedy ITSM

Confidential, Philadelphia, PA

Senior Reports Developer

Responsibilities:

• Performed an initial study of the current reporting application to finalize the data elements required for reporting.
• Responsible for generating the customized reports using Crystal Repot 2008 and SSRS 2008 reporting tool.
• Writing and debugging database Stored Procedures.
• Create the Views, Joins, SQL queries, Functions and Stored procedures using SQL Server 2008 to pull data for the report.
• Create complex reports which included Sub-Reports, Parameters, Graphs, Drill downs, Multiple grouping & Sorting, Dynamic headings.
• Developed Parameterized Reports with Dynamic and Cascading Prompts.
• Develop SQL queries to extract, manipulate and calculate information to fulfill data and reporting requirements.
• Created customized Reports using Formula Fields, Parameter Fields, Sub-Reports, Group Selection and Record Selection, formulas and conditional formatting in Crystal Reports 2008.
• Actively work on design, development and documentation of SSRS 2008 Report on Data Warehousing.
• Deployed reports to production.
• Trained the user and created Design Document for reporting.
• Provided technical assistance by responding to user queries regarding errors, problems and technical questions.

Environment: SQL Server 2008 R2, SQL, T-SQL, Crystal Repot 2008, SSRS 2008 R2, Excel 2007, Citrix ZenApp, TortoiseSVN 1.6.11

Confidential, Erlanger, KY

Senior Reports Developer

Responsibilities:

• Gather business requirements and analyze for enhancements needed for the current reporting system to perform their job more efficiently.
• Actively worked on System Design, documentation and creation of Functional Specification.
• Developed Parameterized Reports with Dynamic and Cascading Prompts.
• Develop SQL queries to extract, manipulate and calculate information to fulfill data and reporting requirements.
• Systematically identified and defined problems, evaluated alternatives and implemented effective solutions.
• Responsible for generating the customized reports using Crystal Repot XI reporting tool.
• Create the Views, Joins, SQL queries, Functions and Stored procedures using SQL Server 2008 to pull data for the report.
• Create complex reports which included sub-reports, parameters, graphs, drill downs, multiple grouping & sorting, dynamic headings.

Environment: SQL Server 2008, T-SQL, Crystal Repot XI, Visio 2003, Excel 2003, Windows NT

Confidential, Iowa City, IA

Senior SQL Server Reports Developer

Responsibilities:

• Responsible for generating the reports from the requirement specification using SSRS reporting tool.
• Gather business requirements and analyze for enhancements needed for the current reporting system to perform their job more efficiently.
• Systematically identified and defined problems, evaluated alternatives and implemented effective solutions.
• Writing and debugging database stored procedures.
• Create the Views, Joins, SQL queries, Functions and Stored procedures using SQL Server 2008 to pull data for the report.
• Create complex reports which included sub-reports, parameters, graphs, drill downs, multiple grouping, dynamic sorting, dynamic headings etc.
• Developed Parameterized Reports with Dynamic and Cascading Prompts.
• Develop SQL queries to extract, manipulate and calculate information to fulfill data and reporting requirements.
• Actively work on design, development and documentation of SSRS Report.
• Create customized Reports using Expressions, Parameters, Sub-Reports.
• Design the report using SSRS 2008 and host it enterprise solution.
• Integrate the reports to Blackbaud CRM.
• Create reports using multiple queries and involve in tuning the reports in order to increase the accessing speed.
• Involve in writing SQL Conditions for the Filtering at various levels based on the specifications.
• Export reports into various formats like Excel and Word as per user request.
• Helped the team for various technical issues related to report development.

Environment: SQL Server 2008, T-SQL, SQL, SSRS 2008, Visual SourceSafe, Windows NT

Confidential, MI

Senior Reports Developer

Responsibilities:

• Gathered business requirements and analyzed for enhancements needed for the current reporting system to perform their job more efficiently.
• Performed an initial study of the current reporting application to finalize the data elements required for reporting.
• Responsible for generating the reports from the requirement specification sheet, using Crystal Reports XI.
• Created complex reports which included sub-reports, parameters, graphs, formulas, drill downs, functions, multiple grouping & sorting, shared variables & dynamic headings.
• Created the Views, Joins, SQL queries, Functions and Stored procedures using SQL Server 2005 to pull data for the report and generated customized reports using SSRS tool as per the user request.
• Actively worked on design, development and documentation of Crystal Report.
• Created customized Reports using Formula Fields, Parameter Fields, Sub-Reports, Group Selection and Record Selection in Crystal Reports XI.
• Developed SQL queries to extract, manipulate and calculate information to fulfill data and reporting requirements.
• Modified and enhanced already existing reports as per the requirement.
• Integrated the crystal reports to Avatar System.
• Created Linked Server in SQL Server 2005 pointing to Cache database.
• Built the reports using SSRS 2005 and hosted them in the portal.
• Created reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
• Involved in writing SQL Conditions for the Filtering at various levels based on the specifications.
• Involved in scheduling the reports to be received in different formats (Email, PDF, Public folder etc).
• Provided technical assistance by responding to user queries regarding errors, problems and technical questions.

Environment: SQL Server 2005, Crystal Reports XI, SSRS 2005, Excel 2003, Cache 5.2, Numara Track-it 8, Windows XP.

Confidential

Software Engineer

Responsibilities:

• Research & Development in functional aspect of the application & Database Design.
• Gathered business requirements, prepared technical specifications & documentations, Maintained and enhanced production reports.
• Designing the Process diagram and Table Relationship diagram ofApplication.
• Lead role in ensuring that the team follows the process while executing the change request of the application, coordinating and setting up the meetings with offshore team.
• Extensively involved in writing Stored Procedures, Queries, Views and Joins in SQL Server 2000 database.
• Designed and Developed the UI screens using VB.NET.
• Created numerous complex Reports, Sub-Reports and Cross-Tab Reports using Crystal Report.
• Tuned the report generation and distribution process to continue to work effectively as the database grows.

Environment: SQL Server 2000, Crystal Reports 9, VB.NET, Visual Source Safe, and Windows NT/2000

Confidential

Application Developer

Responsibilities:

• Consulted with client management regarding technical and business requirements. Wrote and prepared specifications, documentations and system flow charts.
• Developed technical design and created table structures.
• Designed and developed the Front End in Visual Basic 6.0.
• Mapped data between source systems. Designed and developed system’s proto-type. Presented system demo to users.
• Analyzed the system and designed the Database.
• Analysis, design, report generation, testing and deployment of Crystal Reports.

Environment: Oracle 9i, SQL, Pl/SQL, Crystal Reports 9, Visual Basic 6.0, Visual SourceSafe, Windows NT/2000

Confidential

Application Developer

Responsibilities:

• Involved in development of application using Oracle database as backend environment, Visual Basic 6.0 as front end and Crystal Reports as Reporting tool.
• Used SQL/PLSQL for writing stored procedures and SQL Queries for efficient reporting.
• Lead role in project execution and implementation.
• Developed customized software.
• Involved in testing the application and maintaining Test case document.
• Provided technical support to the clients and trained end users.

Environment: Oracle 9i, Pl/SQL, Crystal Reports 8, Visual Basic 6.0, Windows NT/2000

Confidential

Oracle Developer

Responsibilities:

• Extensively involved in writing Stored Procedures, Queries, Views, and Joins.
• Designed the Process diagram and Table Relationship diagram of the application.
• Designed and developed User Interface like data entry screens using Developer 2000 and Oracle Reports for reporting screens.
• Provided technical support to the clients and trained end users, documented the user manual.

Environment: Oracle 8, Pl/SQL, Developer 2000 (Forms 6, Reports 6), Windows NT

Confidential

Oracle Developer

Responsibilities:

• Involved in Design, Coding, Testing and Implementation of the system.
• Developed the Front-end User Interface and Customized Reports using Developer 2000.
• Strongly involved in coding, debugging and testing PL/SQL script.
• Prepared the technical Documentation and user manual of the software for the end user.

Environment: Oracle 7.3, Pl/SQL, Developer 2000(Forms 4.5, Reports 4.5), Windows 98