SUMMARY

• Database Development with 10+ Years of experience in ETL/Oracle environment as QA/Programmer Analyst using most of the Oracle related tools under UNIX and Windows environments.
• 7+ Years of extensive experience in the Data Warehousing Environments.
• 7+ Years of experience in Oracle Development.
• Good understanding of database client/server configuration on Oracle 9i/10g, SQL Server 2000/2005 and DB2.
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema for faster and effective Querying for the Metadata Management solutions.
• Extensive and proven experience using Oracle 8i/9i/10g/11g/12C, SQL, PL/SQL, Forms 6i/4.5, Reports 6i/2.5, SQL* Plus, SQL*Loader, Informatica.
• 6+ Years Extensive experience writing Database Triggers, Stored Procedures, Functions and Packages using PL/SQL.
• 2+ Years’ Experience in creating and modifying forms using Oracle Forms 6i for data manipulation purpose and reports using Oracle Reports 6i.
• Experience in Requirement capturing, System analysis, Logical and Physical data modeling, Development and Implementation of software applications.
• Strong PL/SQL programming for data population and table alterations, Oracle Performance tuning/ SQL tuning and query optimization skills.
• Data Migration using SQL *Loader and TOAD Utility.
• Experienced at Data Modeling, Data Architecture, Business and Data Analysis.
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de - normalized and normalized data models.
• 2+ Years’ Experience in using Data warehousing tools like Informatica, Data Stage for ETL process and Business Objects, Crystal Reports, Cognos Report Net, Excel for Reporting purpose.
• 3+ Years’ Experience in working with Unix Shell scripts.
• Experience in other DBA activities like creating Tables, Complex Views, Public Synonyms, and Database Links.
• Implement and Maintain Database Security. Creating / Altering / Dropping Users as and when required and administer their respective quotas. Create and Maintain Roles and assign necessary privileges to users according to business rules.
• Experience in Database Tuning and Performance Monitoring. Recreation of Database, Maintaining and Rebuilding Indexes, Reorganization of Table spaces as and when necessary. Improving Query Performance by rewriting the problematic queries.
• Experience working on Onsite/Offshore Model.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining Test scripts.
• Expertise in Unit Testing, Integration, Functional, System, Performance, Load, Regression Testing and Validation Testing.
• Strong Coding and debugging skills. Self-motivated team player with good communication skills.
• Strong analytical and problem solving skills coupled with excellent written, verbal and inter-personnel communication skills.
• Worked in both OLTP and Data warehouse Environments
• Proficient in preparing Technical Design Documents and Unit Test Documents
• Having Good expertise in all the stages of Full software development life cycle implementation (SDLC)
• Good and Thorough understanding of system development process, from Initial planning through Deployment
• Good working experience in Forms, Reports, PL/SQL, Oracle Databases 8i/9i/10g and RDBMS Concepts
• Extensive experience in developing PL/SQL Procedures, Functions, Packages and Database Triggers and debugging
• Worked in Oracle ERP modules: OM (Order Management), Supply Change Management (SCM).
• Having exposure to Project management & experience with Quality Assurance, Defect Tracking and adhering to SEI CMM (Capability Maturity Model)
• Proficient in Unix shell and AWK scripting
• Has fair understanding on Oracle Applications and Retail Merchandising System
• Provided support all through the System Integration Testing and User Acceptance Testing phases
• Good interpersonal, Analytical and communication skills

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Pro*C, VB, COBOL, Java, Perl.

Databases: Oracle 12C/11g/10g/9i/8.x, SQL Server 2005/2000, DB2, Netezza and MS Access.

Operating Systems: Windows 98/2000/2003/ XP, Windows NT, MS DOS,HP-UNIX, Sun Solaris UNIX, LINUX, MS Office(Excell,Word,PowerPoint,Visio)

BI Tools: Business Objects XI, Cognos Report Net, Crystal Reports XI, SSRS.

ETL Tools: Informatica 8.x/7.x/6.x, Data stage,OWB(Oracle Warehouse Builder)

Web Technologies: HTML, DHTML, XML, Java script, JSP, Servlets.

Tools: & Utilities SQL*LOADER, SQL Navigator, SQL*Plus, TOAD, PowerBuilder, Oracle Forms 6i/4.5, Reports 6i/2.5, Discoverer, Export & Import, SQL developer, Putty, WinSCP, Hummingbird

Data Modeling Tools: Erwin, Visio

Scheduling Tools: Autosys, Control-M.Crontab

Testing Tools: Quality Center, Test Director, Lotus Notes

Versioning Tools: Clear case

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NYC

Sr. ETL LEAD Developer/ Data analyst

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering.
• Created Technical Design for the Back End PL/SQL based on Business Requirement Documents and the Functional System Design.
• Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using oracle tools like PL/SQL Developer.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Built Complex queries using SQL and wrote stored procedures using PL/SQL.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Involved in moving the data from flat files to staging area tables using SQL * Loader.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Get all Design and Coding Reviewed and Approved by the concerned authorities.
• Provide support to Front End and fix defects in various stages of Testing i.e.QA and UAT.
• Perform Technical Validation on production Release day and send a Success/ failure report accordingly.
• Worked closely with Production Support team to Troubleshoot and fix any production issues.
• Involved in developing SQL queries for developing ORACLE 10G Reports.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL) program asynchronously.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Involved in performance tuning of complex queries.
• Implemented change data capture (CDC).
• Responsible for performance tuning of SQL queries involved in the reports, indexes, partitioned tables to improve overall performance of system.
• Design and develop data warehouse functional modules which accommodate multiple refresh methods & design dashboards and custom reports using Jasper Reports as well as Discoverer and Develop and document test cases
• Responsible for designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, SQL server and Oracle) feeds using PL/SQL and Unix Shell scripts
• Involved in creating complex mappings using transformations like Update Strategy, SCD1, SCD2, and SCD3, expression, source qualifier, lookup, aggregator, stored procedure, union, joiner etc.
• Written shell scripts and scheduled jobs using cronjobs.
• Wrote SQL Loader control file for flat file data load and scheduled them in UNIX to load every night in Production Environment.
• Created Sequences using oracle 12C without using triggers.
• Used varchars in oracle 12C instead of LOB datatypes.
• Used RPAD/LPAD/TRIM functions in insert statements in Oracle 12C.
• Used Oracle 12C SQL concept of retrieving data after sorting using FETCH FIRST ROWS.
• Used OFFET clause in Oracle 12C.
• Used Oracle12C moving partition concept using ALTER Table ONLINE clause.
• Used Oracle 12C row pattern matching (MATCH RECOGNIZE) clause in select statements.
• Used Oracle 12C temporary UNDO statements while using update SQL statements (very minimal).
• Used Oracle 12C to created tables with invisible columns.
• Used Oracle 12C to create a functions with in WITH clause.
• Worked on command, file watcher and box jobs.
• Worked on Creation/Modification of JIL Jobs.

Environment: SQL,CDW(PLSQL),EHDW(INFORMATICA), Oracle 10g/12C Ultra edit, Informatica 8.1,ALM, AUTOSYS, TOAD, MS Office,Unix,Windows 7,UNIX

Confidential, Simsbury, CT

Data warehouse Developer/ETL (PLSQL)

Responsibilities:

• Involved in gathering elements from different data marts to consolidate in to single data mart.
• Involved in analysis of data marts to understand feasibility and complexity.
• Developed PLSQL Packages/Procedures/Functions to populate data in to stage tables.
• Developed Informatica mappings to move data from stage to target tables.
• Wrote complex SQL queries on oracle tables to pull data for analysis purpose.
• Experience in Working with fact and dimension tables.
• Worked on dimensional modeling.
• Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL, Informatica).
• Implemented change control concepts.
• Strong Performance Tuning (SQL Tuning, PL/SQL Tuning) Skills.
• Created JIL Scripts to insert/update/delete.
• Created AUTOSYS jobs to job schedule.
• Participated in Design and development of the web interfaces and services for an enterprise system using Java and Webservices.
• Used Object-Oriented Programming (OOPS) Methodology to design Java Front-End.
• Coordinating the efforts of both on and offshore resources throughout the life cycle of a new project. Ensure all aspects of project management are fully executed.
• Created Unix Shell Scripts to schedule and automate the Informatica Mappings and also to automate the batch jobs. FTP the Files from different UNIX/MAINFRAME boxes.
• Involved in full Software Development Lifecycle (SDLC)-Water Fall Model.
• Perform ETL Testing by validating data.
• Created Tables, Complex views, Materialized views, Force views, synonyms, Indexes.
• Created Partition tables by range using date column to increase the performance.
• Created public database links to access the data from remote databases.
• Scheduling Jobs through Crontab.
• Wrote database triggers for automatic updating the tables.
• Worked on SharePoint portals to share documents (check in/check out) Process.
• Used Oracle HINTS to improve performance.
• EXEC explain plans to analyze query performance for best tuning.
• Wrote shell scripts on Linux to grab source data and load in to staging tables.
• Worked on Oracle Analytical Functions(AVG, COUNT, LEAD,MIN,MAX, RANK,ROW NUMBER,SUM)
• Involved in creating complex mappings using transformations like Update Strategy, SCD1, SCD2, and SCD3, expression, source qualifier, lookup, and joiner.

Environment: AADM/ADRC (Source Mainframe system), Informatica-9.0.1, SQL, PLSQL, Business objects, Oracle10g, Toad, Autosys, Exadata 11g, Java, Webservices, Linux.

Confidential, Columbus, OH

Oracle ETL/PLSQL

Responsibilities:

• Responsible for writing PL/SQL Programs stored procedures,packages,functions which accomplish solutions to existing application which served as service/Change request
• Involved in performance tuning of complex queries.
• Implemented change data capture(CDC).
• Responsible for performance tuning of SQL queries involved in the reports, indexes, partitioned tables to improve overall performance of system.
• Design and develop datawarehouse functional modules which accommodate multiple refresh methods & design dashboards and custom reports using Jasper Reports as well as Discoverer and Develop and document test cases
• Responsible for designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Sql server and Oracle) feeds using PL/SQL and Unix Shell scripts
• Involved in creating complex mappings using transformations like Update Strategy, SCD1, SCD2, and SCD3, expression, source qualifier, lookup, aggregator, stored procedure, union, joiner etc.
• Used SQL Loader, IMPORT wizard in TOAD to load the data from MS Access, CSV files, Excel files, Text files etc into Oracle Tables.
• Experience in Working with Top down (Inmon) and Bottom up (Kimboll) Methodologies.
• Experience in working with star and snow flake schemas.
• Experience in Working with fact and dimension tables.
• Responsible for creating Informatica Mappings, Sessions and Workflows for the SRS, Admin Server Projects using Oracle and Teradata as source, target. Worked with almost all types of transformations.
• Extensive Performance Tuning (SQL Tuning, PL/SQL Tuning).
• Worked on Front end Java system forms.
• Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL, Informatica).
• Implemented excellent Informatica development strategies and used Target Load Plan, Constraint based loading, partitioning, performance tuning the existing mappings. Used the Informatica debugger to resolve the errors in the mappings.
• Created and reuse the existing Unix Shell Scripts to schedule and automate the Informatica Mappings and also to automate the batch jobs. FTP the Files from different UNIX boxes.
• Analyze Problem Reports to identify the root cause and recommend and/or implement code changes to correct the defect.
• Coordinating the efforts of both on and offshore resources throughout the life cycle of a new project. Ensure all aspects of project management are fully executed.
• Participated in requirement reviews, design, design reviews, development, system testing, and implementation phases as necessary.
• Lead teams and have the ability to manage complex processes and issues.
• Validated data moving from Jesta to ODS to EDW.
• Work with the DBA and infrastructure team to implement the DDLs, refresh the data, create the DB links and refresh the materialized views, set up the environment and delete the log files in UNIX boxes.
• Performed Unit, functional, integration, regression, UAT, Performance and end to end testing for this project.
• Extensively usedOracle/Teradata to write SQL Queries to verify and validate the Database Updates.
• Prioritized and reported defects usingQuality Centerto present documents and reports in weekly team meetings.
• Executing the SQL statements to extract data from tables and verify the output data with ref to user inputs from browser page.
• Performeddatabasebackend testing by field level validation and stored procedures validation in SQL to verify data integrity and consistency.
• Responsible for reviewing and modifying test scripts after initial iterations of testing phases to in corporate changes in project environment.
• Analyze Problem Reports to identify the root cause and recommend and/or implement code changes to correct the defect.
• Involved in the implementation of Oracle Applications R12 Supply Chain/Order Management Module and wasthe part of Technical development team which was responsible for the development of Forms, Reports, Interfaces and Conversion using Oracle Developer Suite 10g and general utility packages in Oracle 10g.
• After Implementation is over I was looking into the Post Production Support and also Full time support of
• SCM/OM Modules. The tickets were assigned by the users and my job was to resolve thenEfficiently and on time Mostly Technical issues but also got chance to look into process flows and functional issues.
• Developed conversion programs in PL/SQL for Conversion and reconciliation of Legacy Invoices and Payments into Oracle Applications. •
• Designing of Interfaces to automate the uploading process of different business feeds into Oracle SCM and OM with a view to minimizing the need for manual intervention.
• Wrote SQL to retrieve data from Netezza database

Environment: Informatica 9.1, UNIX, Business Objects, JESTA, Oracle10g, SQL Developer, TeraDataS 12, Quality Center9.2,Netezza, Teradata SQL Analyst

Confidential, San Leandro, CA

Oracle DW Developer(SQL, PLSQL, UNIX)

Responsibilities:

• Responsible for loading Data from WDS systems as well as from files to Oracle database through PL/SQL as well as SQL Loader.
• Responsible for writing PL/SQL Programs stored procedures,packages,functions which accomplish solutions to existing application which served as service/Change request
• Develop datawarehouse functional modules which accommodate multiple refresh methods & design dashboards and custom reports using Jasper Reports as well as Discoverer and Develop and document test cases
• Responsible for designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, MS sql server and Oracle) feeds using PL/SQL and Unix Shell scripts.
• Wrote sql scripts to compare results with front end screen and etl data mappings.
• Working on UNIX environment in writing shell scripts to pick data from oracle database.
• Perform ETL Testing by validating data.
• Production Job scheduling Through Autosys.
• Monitoring Application/Reporting Server
• Validating informatica mappings.
• Responsible for performance tuning of SQL queries involved in the Reports, Indexes, partitioned tables to improve overall performance of system.
• Developed procedures to load data from relational and flat file sources into the data warehouse.
• Developed SQL queries and PL/SQL for database programming (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Analyze Problem Reports to identify the root cause and recommend and/or implement code changes to correct the defect
• Involved in full Software Development Lifecycle (SDLC).
• Created various database objects like tables, partitioned tables views, synonyms, table spaces, user roles, database links, indexes, constraints using TOAD.
• Coordination of project schedules and resource assignments based on regular meetings with customers.
• Lead teams and have the ability to manage complex processes and issues.
• Preparing Test cases, Test scripts and Test scope and did ETL Testing in both front end and back end perspective.
• Developed shell scripts to send notifications after the process of data creation is complete.
• Involved in modify Unix scripts which run batch jobs daily
• Monitoring the jobs daily and fix the issues if any.

Environment: Oracle10g-R2, SQL Developer,Toad,Informatica 9.0/8.0, PLSQL, SQL, Windows (XP), WindowsServer03, Autosys 4.5, UNIX (SunOS-5.10), Winscp,Sql Optimizer, MS Visio, Quality Center, Jasper Reporting,Interoscope, Eclipse, Requisite Pro,Putty,Sharepoint,weblogic, Quality Center

Confidential, Albuquerque, NM

Programmer Analyst II

Responsibilities:

• 24x7 Support in maintaining/enhancing standalone Finance applications and databases.
• Team-work experience.
• Provide technical support/maintenance and development for Finance reporting including Finance ETL data refresh processes and Finance reports.
• Provide support of the University's Reporting Redesign Initiative.
• Operational Data Store (ODS) reporting upgrades and customizations.
• Worked on Workflow creation and Implementation to perform loads.
• Created ETL Mappings in OWB (Oracle Warehouse Builder) To Load and Transform data from one system to other systems.
• Wrote Java Scripts to Generate Hyperion Dash Boards.
• Troubleshoot and resolve complex technical and functional problems.
• Developing and delivering complex reports and queries from accounting databases.
• Wrote Complex SQL/PLSQL Procedures and Functions to Load data from Source to target Tables.
• Involved in writing FDD & HD Documents.
• Worked with Hyperion to generate Dashboards and reports for analysis of data.
• Worked with SunGard HE Banner ERP solution, ODS, IA Admin, Appworx batch job scheduling and Oracle Warehouse Builder.
• Developed Oracle Packages, Stored Procedures and Functions to populate data from source systems to Target tables. Used PLSQL to support ETL process.
• Created public database links to access the data from remote databases.
• Created Tables, Complex views, Materialized views, Force views, Synonyms, Public synonyms, Indexes.
• Created Partition tables by range using date column to increase the performance.
• Created Local and Global indexes on the partition tables.
• Responsible of Security Updates written in UNIX languages (shell scripts).
• Used SQL Loader, IMPORT wizard in TOAD to load the data from MS Access, CSV files, Excel files, Text files etc into Oracle Tables.
• Involved in Full Phase of SDLC (Software Development Life Cycle).
• Worked as System/Apps Database Administrator.
• Review and enhance documentation relating to the UNM system on SharePoint.
• Involved in Database Daily Monitoring, Troubleshooting and Tuning.
• Business Intelligence tools and star schemas/snowflake schemas

Environment: Oracle10g/R2, TOAD, Hyperion8.5, Forms&Reports 9i, OWB10.2.0.5, PLSQL, SQL, Windows (XP), WindowsServer03, Appworx, UNIX (SunOS-5.10), Sql Optimizer.

Confidential, Santa Fe, NM

Data warehouse/Oracle SQL Developer

Responsibilities:

• Wrote Complex SQL Queries to Generate Reports.
• Responsible for repairing any damaged or non-functional systems associated with the NMSIIS system.
• Responsible for the development and enhancement of documentation for all the hardware and software that comprise the NMSIIS System.
• Wrote Complex SQL/PLSQL Procedures and Functions to Load data from Source to target Tables.
• Involved in Validating/ Dedublicating data.
• Worked on Nationalized Standards (HL 7 2.3.1/2.5.1 ) and Flat file Formats.
• Involved in writing FDD & HD Documents.
• Worked with Crystal Reports XI to generate standard, cross tab and adhoc reports for analysis of data.
• Database performance tuning using (EXPLAINPLAN, TKPROF, SQL TRACE).
• Developed Oracle Packages, Stored Procedures and Functions to populate data from source systems to Target tables. Used PLSQL to support ETL process.
• Created public database links to access the data from remote databases.
• Created Tables, Complex views, Materialized views, Force views, Synonyms, Public synonyms, Indexes.
• Created Partition tables by range using date column to increase the performance.
• Created Local and Global indexes on the partition tables.
• Wrote Support plan documents and involved in preparing work flow diagrams.
• Used SQL Loader, IMPORT wizard in TOAD to load the data from MS Access, CSV files, Excel files, Text files etc into Oracle Tables.
• Work closely with HP and other vendors and contractors in support of existing NMSIIS and future systems.
• Work with our data analysts and managers to make sure we can accurately report data to state and federal agencies as required.
• Review and enhance documentation relating to the NMSIIS system on SharePoint.
• Modify the version of the HL7 bidirectional system to work with our quality assurance system.
• Involved in Database Daily Monitoring, Troubleshooting and Tuning.
• Worked on Iguana 4.1 to Route and Transform HL7 files from Different Health care Providers in State.

Environment: Oracle 10g,TOAD,CrystalReportsXI,PLSQL,SQL,SQL Loader, Windows XP, Windows Server 2003, Windows Scheduler, UNIX(SunOS-5.10),Smartdraw2010.11,7Edit(HL7 Editor),Iguana 4.1(Integration Engine).

Confidential, Clinton, MS

Datawarehouse/Oracle PLSQL Developer

Responsibilities:

• Involved in 24x7 support.
• Supporting both production and development activities.
• Proficient in preparing HLD and DD Documents.
• Developed Oracle Packages, Stored Procedures and Functions to populate data from source systems to Target tables. Used PLSQL to support ETL process.
• Created public database links to access the data from remote databases.
• Created Tables, Complex views, Materialized views, Synonyms, Public synonyms, Indexes etc.
• Created Partition tables by range using date column to increase the performance.
• Created Local and Global indexes on the partition tables.
• Wrote different SQL Queries (Sub queries, correlated sub queries and Join conditions).
• Increased the performance of Stored Procedures by using cursors and cursor for loops.
• Used SQL Loader, IMPORT wizard in TOAD and SQL NAVIGATOR to load the data from MS Access, CSV files, Excel files, Text files etc into Oracle Tables.
• Created Test, Development and Production databases.
• Export/Import database objects/schemas from Production database to Development and Staging databases.
• Migrated databases from 9i to 10g.
• Created, scheduled and monitoring the batch jobs on daily, weekly and monthly basis.
• Monitoring the Development, Staging and Production databases growth on daily basis, Addition of tablespaces, datafiles and Modification of tablespaces, datafiles and Forecasting database growth.
• Shrinking the Temporary tablespace to original size.
• Allocated tables to Different tablespaces.
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Automated Backup of Production Database.
• Created user accounts and granted privileges on specific tables based on the request.
• Documented the list of servers that has to set up in the near future.
• Worked on allotting servers to the Development database, Production Database, Tomcat servers and Business Objects Application Servers.
• Created UNIX Shell scripts and SQL scripts to generate and deliver data files and csv files to different down stream systems.
• Scheduling Jobs through Crontab and Windows Scheduler.
• Documented the list of feeds in HITS that has to send to different applications.
• Involved in datamodelling using Erwin tool
• Good working experience in PL/SQL, Oracle Databases 8i/9i/10g and RDBMS Concepts
• Extensive experience in developing PL/SQL Procedures, Functions, Packages and Database Triggers and debugging
• Having exposure to Project management & experience with Quality Assurance, Defect Tracking and adhering to SEI CMM (Capability Maturity Model)
• Database performance tuning using (EXPLAINPLAN, TKPROF, SQL TRACE).

Environment: Oracle 10g/9i, TOAD, SQL Navigator, Business Objects XI R2, PLSQL, SQL, SQL Loader, Informatica, Windows XP, Windows Server 2003, Windows Scheduler, UNIX(SunOS-5.10), SQL Server 2005/2000,ERWIN.

Confidential, MN

Oracle programmer

Responsibilities:

• Responsible for designing and developing the data-warehousing project for Health Insurance.
• Participated in analysis, design, coding, troubleshooting, filtering and passing of data, conversion, and specification development validation and coded integrity check.
• Used SQL*LOADER to load the bulk and incremental data for policy and claims.
• Used PL/SQL extensively for coding as the programming language.
• Created the tables, indexes, synonym, packages, stored procedures and triggers to load the data into the data warehousing tables.
• Involved in writing UNIX shell scripts.
• Deployed customized reports in the applications, calling the reports from the back end by using stored procedures and functions.
• Created custom functions, stored procedures and packages to retrieve the data from tables.
• Worked on tuning the code to increase the performance by analyzing the tables, creating indexes and synonyms
• Made changes to production systems in support of improvement and/ or bug fixes.
• Worked effectively in team environment under tight time lines.
• Involved in creating synonyms to reduce the usage of base tables to securing the data.
• Developed UNIX scripts to run batch jobs and schedule cron jobs.
• Written many database triggers for automatic updating the tables.
• Created drill through and drill down reports using Business Objects.

Environment: Oracle 9i, TOAD, PL/SQL, SQL*Plus, SQL*Loader, UNIX, Forms&Reports 6i, Windows NT 4.0/ 95, Windows Scheduler, Business Objects.

Confidential

Database developer

Responsibilities:

• Involved in getting the User Requirements, Data Modeling & Development of the system.
• Creation of E-R diagram and Data Flow diagrams.
• Involved in designing the Primary & Foreign Key for the objects in the schema.
• Creating functional & technical specifications for the Data entry Screens and the Reports.
• Involved in creation of Schemas, database triggers, and stored procedures.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.

Environment: Oracle 8i, Forms 4.5, Reports 2.5, Windows NT, Sql * Loader, T-SQL, sqlserver 2000.

Confidential

Database Developer

Responsibilities:

• Created procedures, functions and packages commonly used for applications.
• Business process mapping and prototyping, gap analysis, solution design, data conversion (PL/SQL).
• Made recommendation on data conversion and customized interfaces.
• Wrote stored procedures and database triggers.
• Used oracle Reports Builder to create various Report Formats including Sub Reports, Cross Tab Reports, Standard Reports and Master/Detail Reports.
• Involved in debugging and testing phase.

Environment: Oracle 8i, SQL, PL/SQL, Developer2000, Forms5.0, Reports3.0, Sun Solaris and WindowsNT/97, sqlserver 2000.