Sr Reports & Database Developer

Athmaram Pabbathi

(***) *** – ****

***.********@*******.***

Summary

• Over 7.5 years of diversified experience in designing & developing reports by blending the business knowledge of the client with the available technical know-how, using SQL Server Reporting Services 2000/2005(SSRS), Crystal Reports 8/9/10/XI and Business Objects XI.

• Strong knowledge of analysis, design, development, production, testing and implementation of applications in the Client/Server architecture using MS SQL Server and Oracle.

• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding and implementing business applications.

• Proficient experience with using MS Reporting Services Report Manager and Crystal Enterprise components like Business View Manager, Crystal Management Console, Crystal Repository and Crystal Publishing Wizard for publishing reports on the company’s Intranet.

• Excellent experience in Scheduling Reports using Reporting Services, Report Manager and Crystal Management Console.

• Involved in various activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, migration strategy, PL/SQL programs scripts, related report and form, unit level and User Acceptance Testing (UAT).

• Extensive experience with SQL Server Enterprise Manager, Database design (physical and logical), Query Analyzer, Data Transformation Services and SQL Profiler.

• Experience in writing Complex Queries, Views, Stored Procedures and Triggers using Cursor Processing in T-SQL/PLSQL.

• Experience in exporting and importing data from different databases and files to SQL Server using DTS.

• Experience in working with different complicated DTS tasks involving ActiveX Scripting and Send Mail.

• Experience in Database Programming and Development using SQL Server, Oracle and MS Access.

• Experienced in the database design and development for Healthcare, Pharmaceutical, Retail Banking, Mortgage and Financial companies.

• Proficiency in PL/SQL & T-SQL performance tuning and developing new Stored Procedures / Functions, Packages and Database triggers.

• Possesses excellent analytical and troubleshooting skills.

• Excellent ability in writing specifications and gathering requirements from the user and maintaining proper documentation for future reference.

• Ability in preparing the Mock Up based on the specifications using MS Visio.

• Strong interpersonal skills, with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

• Capable of working as an individual as well as a part of team.

Technical Skills

RDBMS: SQL Server 2000/2005, Oracle 8i/9i/10g & MS Access 2003

Reporting Tools: SQL Reporting Services 2000/2005, Crystal Reports/Crystal Enterprise 8/9/10/XI, Crystal Xcelsius, Business Objects XI, WebI

Languages/scripts: SQL, PL/SQL, T-SQL, VB6.0, Visual Studio 2008/2005, XML, Java,

JDBC, C, C++

Operating systems: Windows NT/2000/XP, Linux

Utilities: SQL Navigator, TOAD, SQL Server DTS, MS Report Manager,

Crystal Management Console, Publishing Wizard, Business View

Manager, MS Visio, Visual Source Safe, Query Analyzer

Indiana Child Welfare Information System (ICWIS),

State of Indiana, IN Jun ’08-Till Date

Responsibilities

• Involved with Client BA’s and designed the layouts and standards for reporting.

• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports as per standards.

• Developed reports using cross-tab, formulae, running totals, grouping and conditional formatting reports.

• Created various database objects like queries, views, custom functions and stored procedures for reports distribution.

• Developed various kinds of reports which will be viewed by the Judge and help him to make descisions.

• Installed the Database Drivers for Crystal Reports to connect with Oracle 10g.

• Developed various PL/SQL scripts for reports distribution.

• Used tools like TOAD to develop PL/SQL scripts for reports distribution.

• Involved in the deployment and integration of the reports with the application.

• Involved in creation of winforms for integrating reports with ICWIS application and developing the filter screens for reports generation.

• Involved in troubleshooting, modification and performance tuning of existing SQL scripts.

• Developed and reviewed the design documentation of reports.

• Involved in the unit testing of the reports and document the results for various test cases.

Environment: Crystal Reports, Visual Studio .Net 2008, Oracle 10g, PL/SQL, TOAD and Windows XP

Eli Lilly, Indianapolis, IN Aug ’07- Jun ‘08

Responsibilities

• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports as per Lilly standards.

• Developed crystal reports using cross-tab, formulae, running totals, grouping and conditional formatting reports.

• Created reports using SSRS features like Table Format, Matrix Format, Graphs, Cascading Parameters, Sub Reports and Customized Text Formats.

• Migrated and recreated reports from Business Objects to Sql Server Reporting Services.

• Verified the reports with existing BO reports after migrating to SSRS.

• Created various database objects like queries, views, custom functions and stored procedures for reports distribution.

• Involved in creation of various complicated reports for generating the details of Case PR’s and Complaint PR’s.

• Developed various complicated reports for Trackwise application. For example: created a report for generating the Complaint Record Details used 24 subreports and 100’s of formulae and running totals with various grouping and selection expert filters.

• Involved in the creation of various dashboards and graphs using Crystal Xcelsius.

• Involved in development of PL/SQL scripts for reports distribution.

• Used tools like SQL Navigator and TOAD to develop PL/SQL scripts for reports distribution.

• Involved in the deployment and integration of the reports with the application.

• Involved in troubleshooting, modification and performance tuning of existing reports.

• Developed and reviewed the design documentation of reports.

• And involved in the unit testing of the reports and document the results for various test cases.

• Went thru the training program conducted by Eli Lilly.

Environment: Crystal Reports XI, Crystal Xcelsius XI, SSRS 2005, SSAS, Business Objects, Oracle 10g, PL/SQL, SQL Navigator, TOAD, Track Wise and Windows XP

Option One Mortgage Corporation, Irvine, CA Jun ‘06-Jul ‘07

Responsibilities

• Interacted with end-users and business analysts to understand Business Requirements and transform them into Technical Specification Documents.

• Designed and developed the database design for reporting.

• Developed various Service Management Reports using SSRS, sub-reports, charts, parameterized reports, conditional and dynamic reports.

• Using Charts, Formulas, Grouping, Table Reports, Matrix Reports, List Format, Charts, Sub Reports and Navigation reports.

• Developed reports using SSRS which are generated against OLAP cubes created by SSAS.

• Created reports using conditional formatting.

• Worked on different tools like SQL Server Management Studio, SQL Server Enterprise Manager, Data Transformation Services, SQL Profiler, and Query Analyzer.

• Developed various database objects like Tables, Views and Stored Procedures by using T-SQL in SQL Server 2000/2005.

• Developed the complex queries and used T-SQL cursors for reports data.

• Managed all indexing, debugging, optimization and performance tuning.

• Involved in development of Crystal Reports for H&R Block DW module.

• Also responsible for creating Web User Controls using Visual Studio.NET

• Modified/troubleshooting existing database objects and reports.

Environment: SQL Server 2000/2005, SQL Server Reporting Services 2000/2005 (SSRS), Crystal Reports, T-SQL, DTS (SSIS), SSAS, MS Visio, Visual Studio.Net, Visual Source Safe and Windows 2000

Countrywide Financial Corporation, Calabasas, CA Jun’05-May ‘06

Responsibilities

• Developed SQL Server 2000 database to keep track of the entire inventory for the client.

• Involved in Creating Reports using SSRS 2000.

• Created reports using various components like sub reports, formulae, table/matrix/list and charts.

• Deployed reports on Reports Server. Provided access, scheduling reports using Report Manager.

• Developed various reports using OLAP cubes generated by SSAS 2000.

• Build and perform user acceptance testing (UAT) on new and modified reports.

• Writing complex stored procedures to return the requested data on the reports. Work involves coding, creating tables, indexes, stored procedures, triggers and documentation.

• Used DTS to extract data from Excel to SQL Server 2000.

• Creating indexes on the tables to get the results of the T-SQL queries faster thereby increasing performance.

• Created batch programs using T-SQL and scheduled them as jobs in order to run the reports more efficiently.

Environment: SSRS 2000, Visual Studio .NET, VSS, SSAS, Windows2000/XP, SQL Server 2000, DTS.

Iflex Solutions (Canara Bank) Bangalore, India Apr ’03-May ‘05

Responsibilities

• Designed and developed various reports using Crystal Reports.

• Created reports using various features of crystal reports like sub reports, cross tabs, formulae, running totals and groups.

• Developed various database objects like stored procedures, views and functions for reports distribution.

• Integrated reports to the FlexCube application.

• Performed performance tuning of PL/SQL queries for reports.

• Dropped and recreated the indexes on tables for performance improvements.

Environment: Oracle 9i, Crystal Reports, XML, Visual Source Safe and Windows 2000

Iflex Solutions (Syndicate Bank) Bangalore, India Aug ’02-Mar ‘03

Responsibilities

• Interaction with the clients to determine the requirements.

• Used Crystal Reports for generating various kinds of statements and balance sheets for the bank.

• Developed various kinds of reports for savings, current, loans and fixed deposit modules.

• Worked with both functional and technical personnel to develop detailed requirements and implement those requirements into the technical architecture.

• Provided support to the development team for designing and modeling databases.

• Involved as a team member and a data architect on the Software Configuration and Change Management strategy implementation.

Environment: Oracle, Crystal Reports, XML, Visual Source Safe and Windows 2000

Venky’s India Ltd, Bangalore, India Jun ’01-Jul ‘02

Responsibilities

• Interacting with users and gathering the requirements for reports development.

• Developing the front end screens using VB6, MS SQL Server and integrating the reports with it.

• Developed queries, views, stored procedures and custom functions for application and reports development.

• Designed and developed various Reports, sub-reports, charts, Drill Down and Cross Tab reports.

• Created online order application using ASP, Visual Basic 6.0, and JavaScript.

• Providing the support to the users on ERP and troubleshooting was done.

Environment: MS SQL Server, Crystal Reports, ASP, VB6.0 and Windows2000

Contact this candidate