Sql Server

Madhav Hospet

***– ***– ****

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

PROFESSIONAL SUMMARY

• Having 7+ years of Experience as Database Developer in the areas of Database and application software

development. Maintenance in the Oracle environment using Client Server and Web Architecture.

• Experience in full cycle software development including system study, analysis & design, development, Test,

Implementation and maintenance. Well-understood database management including data, data structure and

its relationships.

• Working knowledge in developing and designing the ETL process. Used PL/SQL to develop ETL process.

• Hands on experience at Requirement Gathering & Analysis – talking to users & analyzing data Converting

Business Requirements into Software Specifications.

• Responsible for all activities related to the development, implementation, administration and support of

databases.

• Proficiency in PL/SQL, Procedures/Functions, Triggers, ETL Process, Oracle forms, Oracle reports, UNIX and

Perl shell scripts and windows batch programming.

• Proficient in UNIX Shell Scripting.

• Good understanding of Oracle database architecture and design and have performed few development DBA

duties (export, import, data pump, SQL performance and tuning).

• Experience with Large Database Query Optimizations.

• Analyzing and optimizing of SQL statements for efficient data retrieval.

• Written Complex SQL statements using nested queries and correlated sub queries.

• Proficient in tuning of SQL queries using Explain plan and TK-Prof utilities.

• Experience in writing SQL statements using Oracle 9i features like Merge, Multi-table Inserts, and Partitions.

• knowledge of high availability SQL Server solutions, including replication and SQL Server clustering.

• Experience in code migration, database change cursors, Error handling and materialized views. Management

and data management through the various stages of the development life cycle.

• Extensively worked with third party database tools like TOAD & PL/SQL Developer.

• Proficient in loading data to target databases using SQL*Loader.

• Knowledge on using the PowerBuilder object: the Data Window control.

• Excellent technical skills in developing Conversions, Interfaces, Reports and Forms in the domain of Oracle.

• Extensive experience in database development by creating Pl/Sql functions, procedures, Triggers, Packages,

Cursors, Error handling and materialized views.

• Excellent documentation and testing skills.

• Strong analytical and problem solving skills.

TECHNICAL SKILLS

Databases: Oracle 10g/9i/8i/8/7.x, MS Access, MS SQL Server 6.5/7.0/2000, MY SQL.

SQL Utilities: TKPROF, SQL*Loader, Export, Import, Data pump.

GUI Tools: Oracle Forms and Reports, Visual Basic 6.0/5.0

Languages: SQL, PL/SQL, C, Pro*C, C++, Java, EJB 2.0, J2EE 1.1, XML, VBA, Shell,

Programming (Korn and Bash), HTML.

Version Control Tools: PVCS, Visual Source Safe, Clear Case and Clear Quest.

IDE: SQL Navigator, TOAD, ERWIN and INFOMAN.

Platform: W indows 98, 2000, XP/NT, Redhat Linux 2.1/3.0/4.0, UNIX (Sun OS 5.7,

HP-UX),

Data Modeling Tool: Erwin 4.1, Visio 2000.

WORK EXPERIENCE

Client: Wells Fargo, SFO, CA Jul 08 – Till Date

Role: Sr. Oracle Developer

Description: W ells Fargo is one of the nation’s financial institutes. As a developer I was into development of the

project to convert large amount of data from legacy system to new oracle system.

Responsibilities:

• Participated in client meetings and discussions to analyze and understand the legacy system.

• Written SQL scripts to create staging Tables and developed SQL*Loader Control Files to load the Data files

into the staging tables.

• Involved in designing the data flow architecture. This architecture includes identifying different business data

sources, pulling the data, data visibility discoverer, Mapping to staging tables, pushing the data from staging

to target database.

• Developed and modified Existing Packages, Stored Procedures, Stored Functions and Cursors.

• Responsible for doing data mapping between source and target tables.

• Written conversion derivation programs which extracts data from source database and loads them into the

development databases.

• Implemented Security Features of Business Objects like row level, object level and report level to make the

data secure.

• Created stored procedures for maintaining SQL server.

• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server

Management Studio, SQL Server Profiler.

• Written Complex SQL statements using nested queries and correlated sub queries.

• Extensively written Shell Script for loading Data files in Database and automated the loading procedure.

• Developed various data exception/suspect field reports and submitted to the client for data clean up.

• Developed various Complex Queries, Views for generating Oracle reports in 6i/9i.

• Created UNIX Shell scripts to support and automate the conversion process.

• Wrote Database interfaces using Perl. Developed UNIX shell scripts.

• Extensively worked in ETL (Extraction, Transformation and Loading) process by extracting the data from

different heterogeneous systems into staging area by using PL/SQL.

• Maintaining the Conversion Design Document for the conversion methodology.

• Created Temporary Tables in procedure to achieve performance issues.

• Used Hints, Explain Plan and TK-Prof utility to achieve the program performance.

• Used Toad, PL/SQL Developer tools for faster application design and developments.

• Prepared checklist, final design documents and general instruction to follow during development.

• Tested the Application to ensure proper Functionality, data accuracy, and that Modifications have no adverse

impact on integrated system environment.

• Performed Unit testing and automated testing.

Environment: Oracle 9.2.0.2/10.2.0.1, SQL, PLSQL, SQL Server 2005, Oracle Reports 9i, ETL, XML, Perl,

SQL*Loader, Redhat Linux 3.0/4.1

Client: AT&T, Atlanta, GA Dec 07 – Jul 08

Role: Sr. Oracle Developer

Description: AT&T Corporation is a telecommunications company, based in Atlanta, Georgia. Migration from

SQL Server 2005 to Oracle 10g and development.

Responsibilities:

• Gathered business data requirements from the client and created functional and technical documents to meet

the client’s strategic and tactical business needs.

• Involved in developing ER-Diagrams and Dataflow diagrams using Designer.

• Extensively worked in the database design and re-structuring of the database.

• Created DB objects like tables, synonyms, sequences, views etc in the target oracle database.

• Involved in replicating the ETL functionality of MS Data Transformation Services (DTS) using Stored

Procedures, External Tables.

• Writing complex stored procedures, triggers and functions using PL/SQL and optimized for maximum

performance.

• Written batch programs using Pl/Sql that has to be run on daily, Weekly and Monthly basis.

• Involved in production support and bug fixing in existing reports using Reports 6i.

• Used Autonomous transactions, Anonymous blocks, Bulk binding and Bulk collect concepts inside stored

procedures.

• Involved in database tuning like Index management, SQL tuning, Explain Plan, Hints and Tk-Prof.

• Perform programming, testing, and debugging of applications based on business requirements.

• Writing help manuals for user for the application developed.

• Modified the existing UNIX and Perl Shell scripts to support conversion process.

• Design documents were prepared detailing transformation of business logic into Perl, Oracle database

manipulation.

• Code quality improvements and automated checking via Perl.

• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.

• Optimized the performance using PL/SQL by restructuring the extraction and summarization routines.

• Coordinated with the Quality Assurance/Testing team members to perform system, integration

and unit testing.

• Coordinated with the DBA for migrations of new/updated objects.

Environment: Oracle 9.2.0.1/10.2.0.1, ETL, SQL, PL/SQL, Oracle Reports 6i, SQL*Loader, Perl, EXPORT,

IMPORT, TOAD, UNIX Sun Solaris (5.7/5.8), Windows 2000/xp.

Client: Bank of America, Charlotte, NC. May 07 – Dec 07

Role: Sr. Oracle Developer

Description: Bank of America is one of the nation’s leading Financial Institutes. The project was aimed at

customizing the existing forms, reports and migrating them to other version. As an Oracle developer I was

involved in customizing existing reports and developing some Pl/SQL procedures, functions and packages.

Responsibilities:

• Developed various Complex Queries, Views for Generating Reports and Forms in 6i.

• Written Complex SQL Queries for Year, Quarterly, Monthly, Weekly reports.

• Designed and developed new Oracle Reports. Converted Oracle Reports to Web Reports.

• Created Temporary Tables in procedure to achieve performance issues.

• Tuned SQL Queries and Stored Procedures improved the performance of the reports.

• Used Oralce9i new features such as materialized views for daily and weekly reports.

• Written PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into

the application.

• Used Hints to Achieve the Performance.

• Written Shell Scripts to load data into oracle tables.

• Created Summary tables and load from Master and detail tables by using Procedures.

• Written and Tested applications for loading inventory data into database tables.

• Responsible for data validations, feeding of live data and user acceptance for each module.

• Written SQL scripts for implementation at the client's place and mentored the end users.

• Prepared checklist, final design documents and general instruction to follow during

Development.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, TOAD, UNIX (Sun Solaris 5.8/5.9), EXPORT, IMPORT,

W indows NT.

Client: NBC Universal, CA Jan 05 – May 07

Role: Sr. Oracle Developer

Description: NBC Universal is one of the leading media and entertainment companies in the world working in

the development, production and marketing of entertainment, news and information to a global audience. Worked

in the development of 2005 enhancements to global sales commission compensation system. Sales data are

taken from various sources and consolidated for assignment of sales credits to pre-defined territories based on

business meta-rules and computation of corresponding sales commissions. This project showed my ability to

study existing system and contribute to the project right away.

Responsibilities:

• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration

and backup of Oracle data.

• Extensively worked in database development by creating TSQL, Oracle PL/SQL Functions, Procedures,

Triggers, Packages, Records and Collections.

• Generated various reports using Oracle Reports 9i/6i.

• Used Unix Shell Scripts and developed PL/SQL procedures and functions to extract and load data for

month-end batch processing.

• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when

application runs. For best results, I used these tools with EXPLAIN PLAN.

• Analyzing requirement of client, generating and designing reports using Reports 6i as well as adhoc reports

with Oracle Discoverer.

• Creating Data Structures. i.e., Tables & views and applying the referential integrity.

• Developed ad hoc reports, created business area, new custom folders, complex folders, summary folder,

hierarchies and item classes and list of values using Discoverer 10g/4i.

• Developed field-level and form-level validation code.

Environment: Oracle 10.2.0.1/9.2.0.1, SQL*Loader, SQL, PLSQL, Oracle Reports 9i/6i, TOAD, MS Excel, UNIX

(Sun Solaris 5.8/5.9), MS SQL Server 2000.

Client: Merrill Lynch, NY Jul 03 – Dec 04

Role: Sr. Oracle Developer

Description: The ACE system basically provides an interface to the customer service representative to service

TTS’L prepaid customers. The ACE systems provide customer information during handling calls or during

customer walk-ins. The system allows raise/view complaints, capture and store customer’s interactions and

generating reports. ACE will provide the customer information and maintain data information.

Responsibilities:

• Create New Forms and reports.

• Maintenance of objects libraries, packages.

• Created/Modified PL/SQL Triggers, Procedures, Functions and Packages.

• Extensively worked in coding, testing the application.

• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.

• Designed Database Triggers for audit and validation purpose.

• Created Function Hierarchy diagrams for different modules using Designer/2000.

• Created ER diagrams using Designer/2000.

• Designed Staging tables.

• Used SQL Loader to load the data.

• Screens are developed on one common template that contains the object library, Calendar, Property Classes,

Program Units, Visual Attributes, etc.

Environment: Oracle Developer 2000, Windows 2k, Oracle 9i, Forms 6i, Reports 6i & TOAD, SQL*Loader,

UNIX.

Client : Savant Technologies Ltd, Chennai, India Mar 02 – Jun 03

Role: Oracle Programmer/ Analyst.

Description: This Customer Support and Billing (CSB) were developed in Oracle 8i, PL/SQL, UNIX and

Developer 2000 to facilitate routine activities. CSB is the customer-based billing engine.

Responsibilities:

• The ability to store more detailed information about customers and their accounts.

• The ability to positively identify each person on an account when more that one person is listed.

• The ability to bill for non-energy products and services.

• Custom pricing abilities.

• Bills are mailed to valid addresses.

• Extensively used of PL/SQL Stored Procedures, Functions, Form Triggers and Packages.

• Developed web based front-end screens using Forms 6.0

• Creating SQL, PL/SQL database objects.

• Written the Interface Stored Procedures for Data Transformation.

• Used TOAD, PL/SQL developer tools for faster application design and developments.

• Developed procedures using Dynamic SQL, UTL_FILE.

• Extensively worked in Testing (Both Unit and Integration Level) and Implementation.

• Tested the entire application in testing environment and exported to Production.

• Done the documentation and provided on-site production support.

Environment: Oracle 8.0.5. /8.1.5/8.1.7, Oracle Forms 6i, PL/SQL, SQL Plus, Windows 2000 and UNIX (HP-UX)

EDUCATION

• Bachelor of Engineering from GIT, Karnataka, INDIA

• Master’s of Engineering from GIT, Karnataka, INDIA

Contact this candidate