Developer Sql

Title:Kevin Cheesebrough

abpxxy@r.postjobfree.com

Document

Source below

Name: Kevin Cheesebrough

Address: **** ***** ******** **.

City: Dayton

State: OH

Zip/Postal Code: 45417

Country:

E-mail: abpxxy@r.postjobfree.com

Primary Phone: 937-***-****

Background

Most Recent Job Title: Product Engineer

Most Recent Employer: Steelcraft

Career Level: Associate/Experienced (Non-Manager)

Availability or Timeframe: Immediately

Authorized to work in the US: Yes

Security Clearance: O

Do you have transportation: Yes

Over 18: Yes

Education: Bachelors

Languages Spoken: English

Job Preferences

Desired Salary: Open

Willing to Relocate: No

Desired Job Titles: Product Engineeer

Product Designer

ProEngineer Designer

Desired Job Types: Employee

Work Status: Full Time

Desired Shifts: 1st Shift, 2nd Shift, 3rd Shift

Desired Travel: 25%

Category: Engineering and Research, Manufacturing/Industrial, Other

Company Size:

Company Type:

Industry: Engineering, Manufacturing / Production

View Emails To Candidate close

Email Status close

close

Forward Candidate(s) Status close

Saving close

Save To:

Note:

Resume Reserve and LeadLink data may only be used for contact directly related to

employment. Use of these free online services is subject to the Terms of Use. Resume

Reserve and LeadLink Terms of Use prohibit automated extraction of data, marketing, or

fees of any kind. Resume Reserve data is private and may only be used by authorized

individuals. Access codes for resume viewing and job lead posting are issued and owned by

LHH and will be revoked if misused.

Send questions to: abpxxy@r.postjobfree.com

To review the Terms of Use, click here.

Copyright c 1997- Lee Hecht Harrison, Inc.

KASI RAMACHANDRAN

PROFESSIONAL SUMMARY

* Seven plus years of IT experience in software development as an

Oracle Developer, involving analysis, design, development,

implementation and maintenance of applications in the Client/Server

environment.

* Experienced in working with Oracle 11g/10g/9i/8i database in both

data warehouse and production environments.

* Developed user interfaces that utilized Oracle Forms 10g/9i/6i and

Reports 10g/9i/6i.

* Extensively worked with Oracle development using Developer

(Client/Server and web forms, Reports), SQL, PL/SQL, Stored

Procedures, Events, Triggers, Ref, Cursors, Functions, Packages,

Collections, Views, Indexes, Autonomous Transactions, Oracle

Objects, etc.

* Expertise in creating and maintaining database objects like Tables,

Materialized views, Indexes, Constraints, Sequence, Synonyms and

Database Link.

* Hands-on Experience with client server environment tools like Oracle

SQL*Loader, PL/SQL Developer, Toad and SQL Navigator.

* Proficient in performance tuning of code using EXPLAIN PLAN and SQL

TRACE.

* Involved in installations and configuration of hardware/OS, oracle

databases and tools.

* Over Two years of experience in developing strategies for

Extraction, Transformation and Loading (ETL) using Informatica Power

Center 7.x, 8.x. (Designer, Work flow Manager, Work flow monitor)

* Good understanding of Software Development Life Cycle (SDLC) and

Project Life Cycle.

* Well-versed in all activities related to development,

implementation, administration and support of ETL processes for

large-scale data warehouses using PowerCenter and PowerMart.

* Practical understanding of the Data Modeling (Dimensional &

Relational) and Data Warehousing concepts like Star Schema Modeling,

Snowflake Modeling, Fact and Dimension table modeling at all the

three levels: View, Logical & Physical.

* Worked with Informatica transformations such as multi join of

heterogeneous flat files, connected/unconnected lookups/procedures,

routers, etc.

* Sound knowledge of database architecture for OLTP and OLAP

applications, Data Analysis, ETL Process in developing Data marts

and Enterprise Data Warehouse.

* Hands on experience in tuning mappings, identifying and resolving

performance bottlenecks in various levels like sources, targets,

mappings and sessions.

* Proficient in creating sessions and batches using Informatica server

manager to run with the logic embedded in the mappings.

* Designed and developed error handling methods, Implemented them

throughout the mappings.

* Extensively used MS Word, Excel, PowerPoint and Visio to produce and

represent documentation.

* Recognized team player with the ability to perform well in a group

or individual, with the ability to cope well in a high intensity

work environment.

Excellent communication and interpersonal skills with a strong

aptitude towards learning new tools, concepts and environments.

TECHNICAL SKILLS

Operating System : UNIX, Linux, MS-DOS, Windows. (Vista, XP, 2003,

2000, NT, 9x)

Database : Oracle 11g / 10g / 9i / 8i, SQL Server 2008/2005,

Sybase, MS Access 2002/2000/1997.

ETL Tools : Informatica Power Center 8.1/8.0/6.2, Power Mart

6.2/5.1.1.

Languages : SQL, PL/SQL, Unix Shell Scripts, Perl Scripts, C, Java.

Oracle Tools : TOAD, SQL Developer 2000, SQL*Plus, SQL*Loader, SQL

Navigator, Oracle Designer, Oracle Enterprise Manager.

Reporting Tools : Oracle Reports 10g/9i, Crystal Reports 11.

Application Tools : MS-Office, Adobe Pagemaker, Adobe Photoshop,UML,

Oracle Forms 10g/9i.

Web Technologies : HTML, XML Publisher.

CERTIFICATION

* Oracle 9i PL/SQL Developer Certified Associate (OCA).

* Oracle PL/SQL Fundamentals Certification from BRAIN BENCH.

PROFESSIONAL EXPERIENCE

Client :

WellCare Health Plans Inc

., Tampa, FL

Jan'09

- Till Date

Title : Sr. Oracle Developer

Project : Membership Reconciliation and Transaction Reply Report

Description

WellCare Health Plans, Inc. provides managed care services exclusively

for government-sponsored healthcare programs, focusing on Medicaid and

Medicare. Headquartered in Tampa, Florida, WellCare offers a variety of

health plans for families, children, aged, blind and disabled and

prescription drug plans. Membership Reconciliation is a monthly

reconciliation that provides the data compatibility and consistency

between Well Care Group (WCG) database and Center for Medicare and

Medicaid Services (CMS) database. Transaction Reply Report (TRR) is the

report received from CMS every Weekend. It has transaction reply codes

(TRC's) and based on these TRC's, WCG system database is updated and

appropriate correspondence is sent out to customer.

Responsibilities

* Actively involved in specifications, requirements and technical

review meetings.

* Developed process to insert/update membership records into database

from different channels using Triggers and Stored Procedures.

* Developed PL/SQL procedure with a file watcher to insert the records

into database tables.

* Developed a process to identify and triage the incoming faxes

received into appropriate mailbox.

* Maintained the database for correspondence sent out by WellCare

Group with the responses received from print vendor.

* Developed UNIX Shell Scripts and PLSQL procedures to extract and

load data for weekend batch processing

* Involved in design of Star Schema with Fact and Dimension Tables.

* Involved in analysis, design and development of the reports using

Oracle reports 10g.

* Used SQL*Loader scripts to read complex data from Flat Files.

* Developed and customized various Forms and Reports for new

memberships added daily using Oracle Developer.

* Developed UNIX Shell scripts to automate repetitive database

processes.

* Involved in creating Procedures, Packages and Advanced PL/SQL

features to handle BULK collects.

* Optimized and Tuned SQL queries and PL/SQL blocks to eliminate full

table scans to reduce Disk I/O and Sorts.

* Handled PL/SQL Compile-Time and Runtime Errors.

* Debugged stored procedures for Business Logic Modification, Granting

and Revoking Schema Object Privileges and Roles.

* Participated in weekly status meeting, Coordinated with the

developers and testers to resolve the defects.

Environment:

Oracle 11g, PL/SQL, SQL*Plus 10g, Forms 10g, Reports 10g, SQL*Loader

10.2, Windows XP, Toad 9.6, Unix Shell Scripting.

Client :

DealerTrack Inc

., Lake Success, NY

Jul'08

- Dec'08

Title : Oracle Developer

Project : Curomax Consolidation

Description

DealerTrack is a leading provider of on-demand software and data

solutions for the automotive retail industry in the United States.

Curomax Consolidation is a web based credit application management tool

that aggregates multiple finance sources into a single access point for

automobile dealers. It facilitates the automobile dealer to search

financing programs for their customers integrated with other products to

submit a credit application and store the details in systems to be

accessed by other DealerTrack suite of products.

Responsibilities

* Gathered necessary requirements coordinating with Business Analyst

and developed functional specification.

* Understood and analyzed design patterns given in UML methodology.

* Performed the technical feasibility analysis and tested various

approaches in consolidating the source product data to target

product.

* Extensively used XML Database packages in PL/SQL to load the data

from xml files to relational tables.

* Developed scripts to bulk load a very large set of data using

SQL*Loader to improve the performance.

* Worked on data migration using SQL*Loader from flat files into

database tables.

* Used web-services in PL/SQL to get the right mappings and performed

the load into the relational tables.

* Developed packages that leveraged reusability of code and

object-oriented features, taking the scalability and performance

requirements into account.

* Performed SQL and PL/SQL tuning using TKPROF to reduce the hard

parses using existing indexes which lead to reduction in sorting and

redo/undo regeneration.

* Designed and developed various reports using oracle reports 9i.

* Created Shell Scripts for automating production tasks in UNIX using

Cron tab jobs.

* Performed schema design and data modeling using MS Visio and Oracle

Designer respectively.

* Involved in Production Support and Error Handling.

* Involved in troubleshooting, knowledge sharing and coding assistance

to various staff in client environment.

Environment:

Oracle 10g, SQL*Loader 10.2, SQL Server 2005, vi editor, PL/SQL Developer

7.0, Oracle reports 9i, XML 1.0, UML, MS Office 2003, Oracle Designer

10.1.2.3, Linux 2.6.9, Unix Shell Scripting.

Client :

Union Pacific Rail Road, Omaha, NE

Dec'07

- Jun'08

Title : PL/SQL Developer

Project : Total Car Management (TCM)

Description

Union Pacific Corporation is one of America's leading transportation

companies. Its principal operating company, Union Pacific Railroad, is

North America's premier railroad franchise, covering 23 states across the

western two-thirds of the United States. Total Car Management (TCM) is

primary tool used for maintaining data with regard to different types of

cars used in Union Pacific Rail Road. TCM is used for day to day

management of the customer demand, fleet utilization and exception

management.

Responsibilities

* Actively involved in gathering requirements from end users, involved

in modifying various technical & functional specifications in the

development.

* As a member of data warehouse design team, assisted in creating fact

and dimension tables based on requirement of the project.

* Created Mappings, Mapplets, Sessions and Workflows using Informatica

8.1.1.

* Developed and maintained complex ETL (Extract, Transform, and Load)

and back end processing programs using PL/SQL Stored Procedures and

Packages.

* Used PL/SQL procedures to load huge data using Bulk Insert and Bulk

Collect.

* Used PL/SQL caching techniques to improve the performance of data

retrieval.

* Reviewed data transformation rules and provided technical

suggestions in data transformation logic and pseudo code. (PL/SQL)

* Analyzed source system data and designed the star schema for the

data warehouse to be developed.

* Used complex PL/SQL procedures to calculate various aggregated

measures.

* Developed complex SQL queries and fine-tuned the SQL queries for

performance.

* Created materialized views to pre-compute joins and store aggregated

data.

* Interacted with DBA in resolving numerous production problems,

performance tuning using EXPLAIN PLAN and TKPROF.

Environment:

Oracle 10g, SQL*Plus 10g, PL/SQL Developer 6.0, TOAD 9.0, Pro*C,

Informatica Power Center 8.1, Power Mart 6.2, vi editor, RedHat

Linux 7.

Client :

Health Net Inc

., Sacramento, CA

Feb'07

- Nov'07

Title : Oracle Developer/Analyst

Project : Membership Unity System

Description

Health Net Inc. is among the United States of America's largest publicly

traded managed health care companies. The company's HMO, POS, insured PPO

and government contracts subsidiaries provide health benefits to

approximately 6.6 million individuals in all 50 states and the District

of Columbia through group, individual, Medicare, Medicaid and TRICARE and

Veterans Affairs programs. Membership unity system is a management tool

which maintains data of prospective, existing and withheld insurance

holders.

Responsibilities

* Involved in creating tables and data transfer from various tables,

coding using PL/SQL, packages, stored procedures and triggers.

* Worked with DBA in creating and managing tables, indexes, database

links and privileges.

* Developed back end interfaces using PL/SQL stored packages,

procedures, functions, Collections, Object types and Triggers.

* Developed screens and reports using Oracle Forms/Reports 6i/9i and

PL/SQL.

* Sound knowledge of database architecture for OLTP and OLAP

applications, Data Analysis, ETL processes in developing data marts

and Enterprise Data Warehouse.

* Utilized SQL*Loader to load flat files database tables.

* Utilized PL/SQL developer tool in developing all back end database

interfaces.

* Extensively performed code reviews.

* Developed user documentation for all the application modules.

* Performance tuned Stored Procedures & long running queries by

looking at query plans.

Environment:

Oracle 9i/10g, SQL Server 2005, vi editor, RedHat Linux 7, PL/SQL,

SQL*Plus 9i, Forms 6i, Reports 6i, SQL, TOAD 9.0, C, SQL*Loader.

Client :

Commerzbank, New York City, NY

Aug'06

- Jan'07

Title : Informatica Developer/ Analyst

Project : Portfolio Level Booking

Description

Commerzbank is one of the leading German banks in Europe with major

businesses in Corporate Banking, Retail Banking, Real Estate and

Financial Institutions. Commerzbank in North America deals in wholesale

banking for corporate and institutional customers as well as banks.

Portfolio Level Booking Project is a Commerzbank Data Warehouse

Architecture project to accommodate Loan IQ recommended booking of

secondary investments at the portfolio level in the LIQ application.

Responsibilities

* Involved in Business Analysis and Collection of requirements.

* Created Mappings, Mapplets, Sessions and Workflows using Informatica

8.1.1.

* Created new Dimensions for special attributes such as Portfolio,

Expense Code, Relationship Manager and Part share as part of the

Normalization process.

* Developed various mappings by using reusable transformations.

* Improved the mapping performance using SQL overrides.

* Worked extensively with Dimensional modeling, Data migration, Data

cleansing, ETL Processes for data warehouses.

* Created Mapplets and used them in different mappings.

* Tuned Informatica Mappings and Sessions for optimum performance.

* Used various transformations for data Manipulation.

* Documented the purpose of modules (transformations, mapplets,

mappings, sessions and batches) so as to facilitate the personnel to

understand the process and incorporate the changes as when

necessary.

* Worked on PL/SQL Stored procedures for processing business logic in

the database.

* Tuned SQL queries for better performance.

* Used SQL*Loader utility to load the data from flat files to Oracle

tables.

* Created Bitmap and B-tree indexes and worked on PL/SQL Cursors and

Triggers.

Environment:

Informatica Power Center 8.1.1 (Mapping Designer, Workflow Designer,

Workflow Monitor, Mapplet Designer),Oracle 9i, MS Access 2003, HP UX 11i

v2, Oracle PL/SQL, TOAD 8.5.

Client : Sogefi Filter Division,

Dearborn, MI

Sep'05

- July'06

Title : PL/SQL Developer/Analyst

Project : Decision Maker

Description

SOGEFI Filter Division is one of the major manufacturers of automotive

filters and filter systems and is a recognized development partner and

supplier of the worldwide OEMs. For the past fifty years, the company has

been developing oil, fuel, engine air and cabin air filters for passenger

cars, light-duty and heavy-duty vehicles with constant products and

process innovations. The project "Decision Maker" is an overall strategy

for building decision support system and a knowledge-based application

architecture and environment that supports both everyday tactical

decision making and long-term business strategizing.

Responsibilities

* Worked on KORN Shell Scripts to call SQL*Loader scripts, PL/SQL

Codes and SQL queries

* Experienced in Code Optimization and Performance tuning of the

application.

* Created Stored Procedures, Functions and Packages in Oracle 9i.

* Performed the uploading and downloading flat files from UNIX server

using FTP.

* Involved in debugging and Tuning the PL/SQL code, SQL queries for

the Oracle database.

* Extensively worked on Performance tuning by using Explain plans and

various hints.

* Worked on table partitioning (Range and List) and deploying local

indexing on portioned tables.

* Used UNIX Shell scripts (KORN) for Extracting and Parsing data from

the files.

* Ensured that weekend data loads, end-of-month & end-of-quarter

processing ran successfully and made sure that process was

completely transparent to user community.

* Reviewed data transformation rules and provided technical

suggestions in data transformation logic and pseudo code. (PL/SQL)

* Wrote Constraints to maintain data integrity.

* Provided data infrastructure and data architect support to business

analysts, developers and users.

* Tuned SQL queries using EXPLAIN Plan generated by TKPROF, TOAD and

SQL*Plus.

* Developed flowcharts using Microsoft Visio 2003.

* Attended meetings and reviews to discuss current issues and

processes to tackle issues.

* Analyzed with Business Analysts and client representatives and

solved client specific data issues.

Environment:

Oracle 9i, SQL*PLUS 9i, SQL*Loader 9.1, KORN Shell, Windows XP, TOAD

8.5.

Client :

Reliance Infocomm Ltd

., Mumbai, India

Mar'04

- Jul'05

Title : System Engineer

Project : Wireless Operational Support System (OSS)

Description

Reliance Infocomm Limited provides telecom services in India. The company

offers mobile and fixed line telephony services including broadband,

national and international long distance services, data services,

Internet services and a range of value added services and applications.

The Wireless operational support system (OSS) is used as a platform to

provide Voice, CMS, SMS, Data and other supplementary services on the

network for Postpaid/Prepaid/FWT/FWP/PCO subscribers under different

product plans offered by Reliance. The OSS takes a service plan and

decomposes orders based on the features provided under the plan or takes

individual service orders according to defined business rules.

Responsibilities

* Created database schema, Roles, Tablespaces and Rollback Segments

for OSS.

* Created database Objects for different modules in OSS. (Tables,

Synonyms, Views, Packages, Procedures, Functions, Triggers etc.)

* Created forms for user interface in Developer 2000 and generated

Reports in Oracle Reports 6i.

* Created Workflow Process and Integrity Constraints.

* Performance tuned SQL queries based on the data provided by

different business groups.

* Migrated data from different Sources to Oracle database using

SQL*Loader and from oracle database to warehouse using Informatica

power center.

* Worked on creating distributed database for prepaid activation using

materialized views for maintaining the consistency of application

data

* Monitored database using Oracle Enterprise Manager or TOAD

(Tablespace, Data files, Jobs, Users, sessions, Processes)

* Involved in running loads to load data in stage area for loading

into data warehouse to meet reporting requirements.

Environment:

Informatica Power Center 6.2 (Mapping Designer, Workflow Designer,

Workflow Monitor, Mapplet Designer) TOAD 7.6, Oracle 8i, SQL*Loader,

Oracle Enterprise Manager, C, C++, SOLARIS UNIX 8.0.

Client :

Voltas Limited, Hyderabad, India

Jun'02

- Nov'03

Title : Oracle Programmer/Analyst

Project : Customer Service and Billing System (CSB)

Description

Voltas Limited, together with its subsidiaries, engages in the

manufacture, marketing, and servicing of engineering products in India

and internationally. It operates in three segments: Electro-Mechanical

Projects and Services, Engineering Products and Services and Unitary

Cooling Products for comfort and commercial use. Customer Service and

Billing (CSB) system maintains the information for all the customers and

sites on which they reside. It keeps track of all services taken by the

customer on a particular site & generates a billing statement for each

service according to their usage & current rates.

Responsibilities

* Generated designs using Oracle designer and power designer.

* Implemented the scripts on test, system and production

environments.

* Involved in designing user interfaces and programming using SQL,

PL/SQL.

* Retrieved the data from the database, manipulated and modified the

data using various DML, DCL and DDL commands.

* Created views and triggers based upon the required functionality.

* Created extra table spaces and fine tuned the codes.

* Worked on DCL to grant privileges and revoke them from the listed

users.

* Handled requests sent by other departments and created appropriate

views for them to access database.

* Worked as UNIX programmer for implementing data in production

environment through batch cycles.

* Automated the cycles of production environment and tracked daily

event log reports.

* Managed project development starting from design aspects, testing

and providing programming skills related to oracle application

modification and implementation of code.

Environment:

Oracle 8i, SQL*PLUS 8i, Oracle Developer 2000, Oracle PL/SQL, TOAD 7.2,

HP UX 11i.

EDUCATION

Bachelor of Technology

in Electronics and Instrumentation Engineering.

*** Basic Profile for Resume Posted: 2/5/2010

7:28:22 AM ***

Location: Columbus, OH 43085

Max Commute Miles: 0

Max Travel: Negligible

Highest Degree: 4 Year Degree

Recent Salary:

Employer History -- Title -- Dates:

WellCare Health Plans Inc

-- Sr. Oracle Developer -- 01/01/2009 - Present

DealerTrack Inc

-- Oracle Developer -- 07/01/2008 - 12/01/2008

Union Pacific Rail Road

-- PL/SQL Developer -- 12/01/2007 - 06/01/2008

Health Net Inc

-- Oracle Developer/Analyst -- 02/01/2007 - 11/01/2007

Commerzbank -- Informatica Developer/ Analyst

-- 08/01/2006 - 01/01/2007

Sogefi Filter Division --

PL/SQL Developer/Analyst

-- 09/01/2005 - 07/01/2006

Reliance Infocomm Ltd

-- System Engineer -- 03/01/2004 - 07/01/2005

Voltas Limited

-- Oracle Programmer/Analyst -- 06/01/2002 - 11/01/2003

Contact this candidate