SUMMARY

• Over 7 years of experience in database design, development, testing, integration and implementation of custom solutions in Client/Server Applications using Oracle database.
• Worked extensively on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Study, high level design, low-level design, Coding, Testing, Quality assurance Documentation and Implementation.
• Expertise in reports development using Crystal reports, SSRS and Oracle reports.
• Highly competent skills ETL, Oracle Import and Export Utilities, converting legacy data into Oracle database using Informatica, Bulk Inserts, BCP, SQL loader.
• Expertise in creating database objects like stored procedures, packages, tables, indexes and views.
• Good understanding of operating systems, client-server and datawarehouse architectures, RDBMS concepts, Data Modeling and Normalization Techniques in databases.
• Good experience in creating VB Scripts and UNIX Shell scripts.
• Proven ability to complete projects with minimum direction and working directly with the end users.

TECHNICAL SKILLS
Databases: Oracle 10g/9i/8i, MS Access, Sybase, MS SQL Server
Languages: SQL, PL/SQL, C, T-SQL, VBA, VB Script
Operating System: UNIX, LINUX, Windows XP
Database Tools: SQL*PLUS, SQL*Loader, TOAD, Embarcadero RAPID for SQL
ETL Tools: Informatica Power Center.
Other tools: Filezilla, Version management (PVCS, Source Safe, Subversion, CVS), Rational Req-pro
Reporting tools: Crystal reports, SSRS, Developer 2000/6i, Discoverer
Data modeling: ERWIN, DB-Artisan, Embarcadero
ERP: Oracle applications 11i/11.x/10.x.

EDUCATION
Bachelor of Engineering


PROFESSIONAL EXPERIENCE
Confidential,Dallas, TX Oct 06-Present
Working as a Sr.Software Consultant with expertise in Oracle database. Current project is with Confidential,Buffalo (NY).

Confidential,Buffalo, NY (Current project)
October 07 – Present
Sr.Programmer Analyst
Description:
Confidential,is a nonprofit health plan serving more than 200,000 members across the eight counties of Western New York.

Responsibilities:

• Working on Maintenance of Business to support new requirements and fix problems encountered by users working around applications including Reporting, Data loads and Extracts.
• Implementing end to end reporting solutions using Crystal reports, SSRS, and MS-Access with direct interaction with the end users.
• Create DDL scripts using ER Studio and source to target mappings using Informatica to bringdata from different sources into the reporting database.
• Creating stored procedure, packages, tables, indexes, views and other database objects.
• Creating extracts for the datawarehouse in PL/SQL and scheduling them through unix scripts.
• Providing on-call support with pager rotation among team members. Conducting and taking part in code reviews.
• Used Rational tool ReqPro to upload Technical and Functional Specifications to follow the release management process.
• Working with users and business analysts on creating test scenarios and testing them.
• Proven ability of working in fast paced of agile environment.

Environment:
Oracle 10g, Erwin, MS SQL Server 2008/2005, MS Access, Embarcadero, Crystal reports, SSRS, UNIX, Informatica Power Center 7.1, SQL Loader, FACETS, MS VSS, VB, PL/SQL, T-SQL, VB Script, Agile.

Confidential,Lancaster, PA
Oracle Developer

Description:
Confidential,is a global leader in the design and manufacture of floors, ceilings and cabinets.

Responsibilities:

• Worked on a migration project to move data from Sybase to Oracle 10g
• Modified existing UNIX shell scripts and procedures as required for upgrade.
• Written Shell scripts for automating the process of data loading.
• Created/updated the necessary documentation including functional and technical specifications, test cases and user guides.

Environment:
Oracle 10g, PL/SQL, SQL*PLUS, TOAD, SQL Developer, Erwin, Subversion, SQL Loader, UNIX.

Confidential,Pittsburgh, PA
Oracle Developer

Description:
Confidential,is a leading retailer that designs, markets and sells its own brand of clothing targeting 15 to 25 year-olds.

Responsibilities:

• Worked on a conversion project as part of a 5 member team for ‘Merchandise Conversion Project’
• Participated in the full software life cycle.
• Participation in weekly design reviews and walkthroughs with project manager and development team.
• Worked on database design with the team.
• Writing PL/SQL code using the technical and functional specifications
• Documented business rules, functional and technical designs, test cases, and user guides.
• Fine tuned existing SQL queries for maximum efficiency and performance.
• Provided on-call support during and after the new application went live.

Environment:
Oracle 9i, PL/SQL, SQL*PLUS, TOAD, Embarcadero, UNIX.

Confidential,Mumbai, INDIA
May02- Nov 05
Executive

Description:
Confidential,is a Public Limited Company listed on BSE, one of the most technically advanced and the first new-age private sector Bank

Responsibilities:

• Gathering users’ requirements, Analysis, Design, Development, Testing and then user training.
• Interacting with Manager as a Business Analyst to translate the requirements, business rules into technical requirements.
• Participated in code reviews as well as in meetings to discuss software solutions and development issues.
• Running ad-hoc SQL queries to pull data for users.
• Worked on upgrade of Finacle application from version 8 to 9.
• Modified exiting procedures and oracle forms and reports as required for the upgrade.
• Involved in documenting the business process by identifying the requirements and also involved in finding the system requirements.
• Worked on the KYC module of the Finacle application.

Environment:
Oracle 8i, PL/SQL, SQL*PLUS, SQL*Loader, UNIX, TOAD, Oracle developer suite (Reports and Forms), Visual Basic, Finacle