Sql Server Project

Ramesh Earla

Sr. Developer

Professional Summary:

> An IT consultant with over Nine years of experience in the field of

information technology as an application developer with experience in the

Software development life cycle. Experience in Billing, Sales, Pricing,

Marketing, Logistics and Management in the Telecommunication and Utility

Industry.

> Over Nine years of programming proficiency - application development

expertise using Visual Basic, HTML, ASP, VB Script, Java Script, Crystal

Reports, Crystal Enterprise, Business Objects, Seagate Info. Experienced

working with MS Access, SQL Server, Oracle databases.

> Extensive experience on Business analysis and Enterprise Reporting

solutions delivery using Crystal Reports, Crystal Enterprise/Seagate

Info.

> Expert in designing reports with sub reports, complex formulas, SQL

fields, Parameters, Variables, Cross Tabs, Drill down, Top N/Bottom M,

Grouping, Alerts, Conditional Formatting, Charts, Graphs. Running totals,

multiple Tables, Stored Procedures, Views, Functions and Command Objects.

> Good RDBMS concepts and experience using database Tables, Views, Stored

Procedures, Functions, Packages, Triggers ODBC, SQL, Trans SQL, PL/SQL,

etc.

> Thorough understanding of Business Objects and Crystal Products including

Xcelsius and provided knowledge transfer to other team members on core

reporting functionality.

> Cross-functional collaboration - ability to facilitate communications

between technical and non-technical personnel and among customers,

vendors, management, and other partners.

> Experienced in conducting design sessions to evolve system specifications

and test plans with the ability to handle training sessions and

documentation.

Technical skills:

Operating System Windows Visa/XP/NT/'00/'98/'95, UNIX

Languages HTML, DHTML, VBScript, JavaScript, XML, ASP, SQL, PL/SQL,

T-SQL. SQR

GUI's Visual Basic 6.0/5.0, VB.Net

RDBMS Oracle 10.g/9i/8.i, MS SQL Server 2005/2000/7.0, MS Access

2000/1997

Reporting and Crystal Reports 2008/XI/10.0/9.0/8.5/8.0/7.0/6.0, Crystal

Analysis Tools Enterprise XI/10.0/9.0/8.5/8.0, Business Objects 6.0,

Crystal Web Component, Seagate Info 7.0, SQL Designer,

Crystal Dictionaries, MS Access, MS Excel

Others ERWIN 4.0/3.x, SQL Loader, TOAD, Visual Interdev 6.0,

Visual Source Safe 6.0, SVN,MS Office, MS visual studio

2005, MS FrontPage,LDAP.

Professional Experience:

Client: Hess Corporation, NJ Jan '09

to Present

Project: PeopleSoft to SAP Transition

Programmer/Analyst

Description: Hess Corporation is a leading global independent energy

company, engaged in the exploration and production of crude oil and natural

gas, as well as in refining and in marketing refined petroleum products,

natural gas, and electricity. Hess has 13K+ employees. Hess Corporation's

core HR system is transitioned from PeopleSoft Enterprise version 3 to SAP.

This project is responsible for assisting in the conversion of Data from

legacy system to new SAP system. Hess Corporation uses Authoria's

Performance Management product for its Talent Management. This project is

also responsible for redeveloping the authoria reports compatible with new

SAP structure.

Role & Responsibilities:

. Worked with customers to extract data from multiple data sources which

includes Oracle 10g and SQL Server databases.

. Created templates for data conversion from legacy system to new SAP

system.

. Participated in field mapping and functional specification workshops

leveraging work stream resources for deep functional knowledge.

. Planned conversion test for a set of data objects.

. Executed conversion testing and detailed conversion steps for a set of

data objects.

. Assisted with data validation and defect resolution.

. Supported data pre-cleansing (including

harmonization/standardization).

. Ensured developed programs fulfill conversion requirements.

. Gathered reporting requirements and shared report options with the

client for the New SAP structure.

. Created Detailed Design Document (DDD) for the report requirements.

. Created mock-up reports for review

. Prepared time estimates for all reports developed.

. Gather requirements from the end user to create Xcelsius dashboards

and Webi reports.

. Design and develop dashboards in Crystal Xcelsius 2008 Enterprise.

. Linked Xcelsius to XML Data sources.

. Modified the existing Crystal Reports to make them compatible with the

SAP organization structure.

. Designed and developed Crystal Reports using version Xcelsius

with Complex Formulas, Custom Functions, SQL fields, formulas,

grouping, parameters, multiple tables, stored procedures, views and

command objects.

. Created various complex reports including: Cross-tab, Conditional,

Drill-down, Top N, Summary, Form and Sub reports.

. Created Stored Procedures, Package, Functions for Crystal Reports

using complex SQL, PL/SQL, T-SQL.

. Created test scripts for the reporting requirements. Performed Unit

test in pre-production environment.

. Assisted and/or coordinated user testing and training, ensuring issues

are resolved in pragmatic and an appropriate manner.

. Coordinated the migration of reports from development to Test and to

Production.

. Effectively participated in technical discussions in weekly meetings

with internal teams.

Environment: Crystal Reports 2008, Crystal Xcelsius Enterprise 2008 Oracle

10g, SQL Server 2000, SQL Server 2005 MS-Access, SQL, PL/SQL, T-SQL, SQL

Loader, TOAD, Visual Source Safe 6.0, HTML, CSS, XML, ASP, MS visual

studio 2005 etc

Client: Hess Corporation, NJ Sep '07 to

Dec '08

Project: Business Reporting System

Programmer/Analyst

Description: Hess Corporation is a leading global independent energy

company, engaged in the exploration and production of crude oil and natural

gas, as well as in refining and in marketing refined petroleum products,

natural gas, and electricity. Hess has 13K+ employees. Hess Corporation

uses Authoria's Performance Management product for its Talent Management.

This project was responsible to develop and maintain the reports related to

Authoria.

Role & Responsibilities:

. Gathered reporting requirements and shared report options with the

client.

. Created detailed design document for the report requirements.

. Created mock-up reports for review.

. Prepared time estimates for all reports developed.

. Developed complex/sophisticated crystal reports which include multiple

tables, multiple parameters, subtotals, formulas, SQL command, stored

procedures, images etc.

. Created views and stored procedures for Reports using complex SQL,

PL/SQL, T-SQL in SQL Server and Oracle Databases.

. Created various complex reports including: Cross-tab, Conditional,

Drill-down, Top N, Summary, Form and Sub reports.

. Used extensively Format Editor for formatting and interactivity

options to empower end-users with business information

. Created test scripts for the reporting requirements. Performed Unit

test in pre-production environment.

. Assisted and/or coordinated user testing and training, ensuring issues

are resolved in pragmatic and an appropriate manner.

. Coordinated the migration of reports from development to Test and to

Production.

. Production, trouble shooting, report and dashboard debugging and

testing, post-implementation review. of new/changed reports and

dashboard's maintenance of a custom reporting solution used for client

reporting.

. Effectively participated in technical discussions in weekly meetings

with internal teams.

Environment: Crystal Reports 10.0/9.0, Oracle 10g, SQL Server 2000, SQL

Server 2005 MS-Access, SQL, PL/SQL, T-SQL, SQL Loader, TOAD, Visual Source

Safe 6.0, HTML, CSS, XML, ASP, MS visual studio 2005 etc

Client: Authoria Inc, TX Jan '06 to Aug '07

Project: Business Reporting System

Programmer/Analyst

Description: Authoria provides talent management solutions that help

companies recruit, develop, compensate, retain and engage high quality

employees. The recruiting product helps companies recruit and its reporting

system is based on crystal report 8.5. The compensation and performance

advisor helps companies improve the communication between managers and

employees and its reporting system is based on crystal reports 9, 10. This

position was responsible to develop and maintain the reporting system for

different products of the company.

Role & Responsibilities:

. Worked with wide variety of customers on report development projects

involving crystal reports 8.5, 9 and 10.

. Worked on multiple projects while performing requirements gathering,

solution design, unit test plans and user acceptance testing.

. Worked closely with functional consultants to define reporting

requirements and documenting the requirements in order to design,

develop and maintain Crystal reports

. Assisted in defining the scope of a project, or phase of a project,

utilizing qualitative criteria, technical and business specifications.

. Under the direction of a Project Manager or Practice Director,

demonstrated the ability to plan, run, and managed meetings with

internal and external clients as well as run with and complete

important project initiatives.

. Demonstrated thorough understanding of Business Objects and Crystal

products and provided knowledge transfer to other team members on core

reporting functionality.

. Responsible for major deliverables on a project which may include

reports in the crystal product suite and Crystal business view design

and development

. Created detailed design documentation and program logic documentation

for all the reporting projects.

. Performed unit testing which includes building and executing test

harnesses.

. Worked closely with QA Technical Test Analysts on unit and functional

testing.

. Administered crystal enterprise 8.5. This included system functions,

user administration, scheduling and applying patches, user support,

audit reporting, and user security.

. Effectively participated and leads technical discussions with internal

teams

. Independently performed complex troubleshooting, root cause analysis,

solution development, and implementation of reporting systems

. Analyzed and estimated the level of effort for conversion and

migration of existing reports from crystal reports 8.5 environment to

Business Objects XI

. Maintain and supports existing crystal reports 8.5 documents.

. Used SQL, T-SQL to develop Views, Stored Procedures and Functions.

. Designed, developed and supported ad-hoc reporting system.

. Did modeling on customer sites as per their requirements.

. Created and developed Business Objects Universes and Web Intelligence

reports.

. Using Business View Manager to create List of Values

Environment: Crystal Reports XI R2/10.0/9.0/8.5, Business Objects

Enterprise XI/Crystal Reports Enterprise 8.5, Oracle 10g/8.i, SQL Server

2000, MS-Access, SQL, PL/SQL, T-SQL, SQL Loader, TOAD, Visual Source Safe

6.0, SVN, HTML, CSS VBScript, JavaScript, XML, ASP, MS visual studio 2005,

MS FrontPage, LDAP etc

Client: El paso Electric Company, NM Apr '05 to

Dec '05

Project: Business Reporting System Programmer/Analyst

Description: The project was to develop a single reporting system from

different data sources at various locations of EE. This Reporting System

would help EE's Marketing and Sales department in the decision making

process, tracking the progress, and taking corrective actions.

Role & Responsibilities:

. Working with the higher management in Marketing, Sales and Finance

departments to gather requirements for their reporting needs.

. Creating and documenting logical data models that would consolidate

the different data sources like Oracle, SQL Server and Access

. Created Crystal Reports, which would facilitate decision-making. The

Crystal Reports designed were complex and used formulas, parameters,

selection criteria, sub reports etc.

. Created views and stored procedures for Reports using complex SQL,

PL/SQL, T-SQL.

. Published Crystal Reports in web based environment using Crystal

Enterprise.

. Handled administrative tasks via Crystal Enterprise for reports

publication, scheduling, user security.

. Create Daily Tracking and Energy consumption by Customers, to drag

down active customers not billing, inactive customers billing,

customers without order number and the amounts due.

Environment: Business Objects XI/Crystal reports 10.0, Crystal Enterprise

XI/10.0, Oracle 8.i, SQL Server 2000, MS-Access, SQL, PL/SQL, T-SQL, etc

Client: El Paso Electric Company, NM Oct '04 to

Mar '05

Project: Employee Benefit System Programmer/Analyst

Description: This system was developed for the employees to tack the

benefits.

Role & Responsibilities:

. Develop requirements and detailed documentation to produce reports.

Communicated effectively for requirements and reports testing with the

end users and programmers to integrate reports in applications.

. Designed Crystal Reports using version 10.0 with Crystal reports

formulas, Grouping, Parameters, Selection criteria to handle the

report requests. The reports were from Tables, Stored Procedures,

Views and Command Objects.

. Used SQL, T-SQL to develop Views, Stored Procedures and Functions.

. Integrated the interface into the ASP intranet for accessing the

reports.

. Also communicated with the Database team and other programmers to

guide them with the reports integration to implement Crystal reports

in web based applications.

. Used VBA for MS Excel

Environment: Windows 2000, Crystal Reports 10.0, Crystal Enterprise 10.0,

SQL Server 2000, SQL, T-SQL, ASP, VB script, Java Script, XML, CSS, etc

Client: Maryland State Department of Education,MD Oct '03 to

Sept '04

Project: Schools Enrollment Data, School Funding System

Programmer/Analyst.

Description: The Maryland State Department of Education is required to

obtain records of all students enrolled in Maryland public schools. BCPSS

submit a detailed electronic file of students who were in membership on

September 30. This file is to contain all students enrolled in regular day

school, evening high school, and part time programs. The project involves

developing web based application for school funding system. The system

collects the data from school districts and based on legislative rules,

calculates and processes the payments each school district is entitled to.

Role & Responsibilities:

. Study and understanding the business Scenarios of the existing

systems, understanding the data and validating the data by applying

the current business rules.

. Responsible for designing the centralized repository database for data

from the existing databases.

. Responsible for scheduling the meetings with the existing application

owners to discuss about the data and draw data extracting scenarios

for the centralized repository.

. Responsible for creating the complex Crystal reports (On demand, AdHoc

Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down,

dynamic grouping, Cross-Tab, graphical, aging reports etc)

. Using Seagate Crystal Reports developed complex reports detailed and

summary informations for Data Cleaning, Students Enrollment,

Transportation, Attendance, curriculum assessment test scores, Address

Validation, Homeroom average, disaggregated school reports, district

reports etc.

. Published the reports in crystal enterprise and scheduled the reports

depending on the users request to receive in different formats (Email,

Public folder etc)

1. Troubleshooting, Optimizing, and fine-tuning the SQL Queries for

efficiency.

. Developed web reports using crystal reports and migrated the existing

reporting system to higher version and published them using crystal

enterprise.

. Responsible for extracting the data from the existing systems and load

into the repository using SQL Loader from Text files.

. Handled end user training and presentations.

. Setup and handled crystal enterprise administrative tasks.

. Written Stored Procedures for complex calculations for arriving at the

funding numbers for schools.

. Integrated the interface in the intranet for accessing the reports.

. Designed, developed and administered BO Universes

Environment: Windows 2000, ASP, Java Script, VB Script, CSP, SQL Server

2000, Crystal Reports 9.0, Crystal Enterprise 9.0, Busines Objects 6.0,

SQL, PL/SQL, etc.

Client: Rashtriya Ispat Nigam Ltd., India. Oct '01 -

Sept '03

Project: Commercial Warehouse Programmer/Analyst

Description: Worked on warehouse's Enterprise reporting team, which is

responsible for maintaining the centralized database, reports generation,

schedule and distribution.

Role & Responsibilities:

. Assessed business needs to create and produced requirements and

project scope document.

. Involved in user meetings to gather and analyze the report

requirements.

. Generating all the reports required for other groups and clients and

posting the reports on Seagate desktop, which enables the users to

access, those reports.

. Scheduling the reports to run on daily/weekly/monthly basis and email

the results to the users in the required format.

. Generated reports using various databases (Order Tracking, Sales and

Product catalog using Adhoc queries.

. Involved in migration of the reports with the application /database

upgrades.

. Involved in testing the reports with test database, and giving the

possible test cases to the testing team.

. Involved in creating the summary/detailed reports with drill down, sub

reports, cross tabs, grouping etc as and when needed to higher

management.

. Scheduling reports for the required exporting formats, marinating

instances.

. Performed necessary upgrades to data warehouse by creating new

extraction procedures for data staging. Schema modifications included

new data fields, indexing schemes and population rules.

. Updated data flow diagrams, data model, population procedures, and

scripts. Designed and developed new inventory population module.

. Created testing plans, executed plans, documented system changes, and

implemented improvements.

Environment: Windows 2000, Visual Basic, ASP, VB script, Java Script,

Oracle 8.0.5, SQL, PL/SQL, Crystal Reports 7.0, Seagate Info 7.0, MS

Access, MS Office, Erwin 3.x, etc.

Client: Rashtriya Ispat Nigam Ltd., India. Jun '00- Sep

'01

Project: Order Entry and Invoice Management System Programmer/Analyst

Description: The project involves development of web application of

work orders and invoice management system.

Role & Responsibilities:

. Involved in the design phase of the project based on requirements.

. Involved in database design.

. Development of the application.

. Writing test cases and test plans.

. Basic documentation for user help and developer documentation.

Environment: Windows NT, Visual Basic 6.0, ASP, VB script, Java Script,

Oracle 8.0.5, Crystal Reports 7.0, SQL, PL/SQL, etc.

Education & Certifications:

. BS in Electrical Engineering, India. (2000)

Contact this candidate