Oracle PL/SQL developer Resume
|Desired Industry: Computer Software/Programming
|Desired Job Location: Boston, Massachusetts
||Date Posted: 3/10/2008
|Type of Position: Contractor
||Availability Date: 03/12/2008
|Desired Wage: 80000
||U.S. Work Authorization: Yes
|Job Level: Experienced with over 2 years experience
||Willing to Travel: Yes, 25-50%
|Highest Degree Attained: Bachelors
||Willing to Relocate: Yes
6+ years of experience in systems Analysis, design and development of complex software systems in Banking, Finance, Health, Manufacturing and Educational sectors.
Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
Excellent team player and proven track record working in various team sizes performing cross-functional roles.
Worked as Team lead, and led a team in two assignments and successfully implemented the project before given deadline.
6+ years of experience in Design, Development, and Enhancement and Maintaining applications in Oracle 8i/9i/10g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. Detailed depth Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
2+ years of experience in designed and deployment of UNIX Shell Scripts using K Shell.
Expert knowledge in using data modeling tools like ER-WIN and ER diagrams with Modelmart exposure. Normalization Techniques for designing database with Relational technology on N-Tier Architecture
Having 1yr of strong ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter.
Developed Client-Server applications using front-end tools like Oracle Developer 2000 - Forms 5.0/6i, Oracle Reports 2.5/6i, SQL*Loader, Data Pump and SQL*Navigator.
Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
2+ yrs Extensive experience with Business Intelligence Tools like Oracle Discoverer, Business Objects 6.5 and XI Web Intelligence.
CAMP (Competitive Price and Margin Analyzer) Nov 2007 to Till date
Syntax Solutions Inc, MA
Lead Oracle PL/SQL Developer
CAMP is a strategy-based pricing solution that suggests and assists with pricing decisions, yielding a more predictable and profitable outcome. Evaluate prices within a broad business context with real-time access to competitive and market data, projected sales impact, margin, pricing-based costs, current and projected inventory positions, markdown budgets, and other important price-related information.
Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
Created Platform independent schema structure so that the product data can be implemented in any database.
Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
Environment: Oracle 10g, PL/SQL, ER-WIN, Toad.
FDW (Financial Data Warehouse) System Nov 2006 to Oct 2007
Citibank N.A, NY
Lead Oracle PL/SQL Developer
The Citibank Financial Data Warehouse (FDW) is a reporting system built to support financial analysis and strategic decision-making process. Various reports including custom built management reports and global performance reports are generated from this system.
Worked as Team lead, and led a team of four developers, Responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
Designed and developed Informatica Mappings to load data from Source systems.
Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
Involved in migrating warehouse database from Oracle 9i to 10g database.
Involved in analyzing and adding new features of Oracle 10g like DBMS_SHEDULER, Create Directory, Data pump, CONNECT_BY_ROOT in existing Oracle 9i application.
Tuned Report performance by exploiting the Oracles new built-in functions and rewriting SQL statements.
Extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
Used EXPLAIN PLAN, TKPROF to tune SQL queries.
Developed BO full client Reports, Web intelligence report in 6.5 and XI R2 and universes with context and loops.
Migrated Reports from 6.5 thick client (desktop Intelligence report) to XI r2 Thin Client (Web Intelligence Report) through Report Conversion Tool (RPT) and Import wizard.
Maintained CMS with various repositories for security, Managing Objects, Server and Audits.
Implemented new concept of manage access restriction in universe on the existing application by which 1550 reports are reduced to less than 200 reports.
Environment: HP-Unix, Oracle 9i/10g, Business Objects 6.5/XI R2, Toad, Informatica Power Center 7.0
LRX-EMEA (Longitudinal Prescriptions) Nov 2005 to Nov 2006
International Medical Solutions, CT
Senior Oracle PL/SQL Developer
LRx (Longitudinal Prescriptions) is a repository system that stores Patient, Prescriber and their prescription information and their related transactions. This system was implemented for UK based client of Cognizant Technology solutions. The main objective of the LRx is to produce reports on patients, their prescriptions and transactions over a period of time.
Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
Developed various Business Object 6.5 Reports and Universes. Used Context and loops in many complex Universes.
Used partitioning and sub partitioning of tables to improve performance.
Developed Shell scripts and SQL control files to load data through SQL Loader.
Developed Complex SQL queries using various joins and developed various dynamic SQLs thorough out the projects.
Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
Used Bulk Collect feature to improve performance.
Analyzed and computed statistics to improve response time for queries.
Involved in Performance tuning of complex queries.
Test case/data preparation, execution and verification of the test results.
Environment: HP-Unix, Oracle 10g, Business Objects 6.5, Shell Scripting.
AERS (Adverse Event Reporting system) Apr 2005 to Nov 2005
Valeant Pharmaceuticals, California
Senior Oracle PL/SQL Developer
Oracle Adverse Event Reporting System (AERS) 4.5.1 is a Commercial Off-The Shelf (COTS) product of Oracle Corporation. It is a web-based, 3-Tier architecture application that leverages an Oracle database (on the backend) and Oracle Forms for the end-user user interface.
Developed Packages and customized functions and Triggers based upon the business logics.
Assisted in Installing Application Server, Report Server and Database Server
Involved in performing periodic cold backup of the databases
Designed, developed and customized forms by using Oracle Forms 6i and Reports 6i.
Configured Oracle 9i AS Portal for deploying AERS on Linux and Windows for both production and development environments.
Prepared test plans for System and User acceptance test
Involved in documenting users requirements, technical specifications and Reporting manuals.
Environment: HP-Unix, Oracle 9i, Forms 6i & Reports 6i, Oracle Portal
Bachelors in Engineering Specialized in Electrical and Electronics. Madurai Kamaraj University, India.
Oracle Certified Professional in Introduction to Oracle 9i:SQL
Certified by Brain bench for RDBMS Concepts -- transcript ID number (2615056).
Databases - ORACLE 8/8i/9i/10g
Languages - SQL, Oracle PL/SQL, Oracle developer 2000.
BI and ETL - Business Object 5/6.5/XI R2, Oracle Discoverer, Informatica Power Center 7.0
Data Modeling - Erwin and Visio 2007
Front end Tools - Developer 6i (Oracle Forms, Designer and Reports)
Web - HTML, XML, Macromedia Flash.
Scripting tool - Unix Shell Script
Scheduling Tools -Tivoli (Maestro)
Tools/utilities - SQL*Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL Loader, Oracle Portal 9i AS.
Operating System - DOS, Windows 9x/NT/2000/XP, UNIX, HP-UX
Version Control - VSS 6.0, Clearcase 3.2.
Candidate Contact Information:
|JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.