SUMMARY

• Over 7 years of strong technical experience in the field of Software Design, 熟练使用Oracle进行开发与实现, SQL, PL / SQL and Unix Shell Scripting that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• 有较强的程序编写经验, 包, 游标, 功能, 使用SQL和PL / SQL的触发器和其他数据库对象.
• 精通复杂SQL语句的编写和调优.
• Extensive experience in using Oracle utility tools like SQL *加载程序 on UNIX platforms.
• 具有编写UNIX shell脚本的丰富经验.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data which is store at the OS level.
• 数据库性能调优方面的专业知识, 性能监控和优化使用Oracle提示, 解释计划和表分区
• 精通业务对象等技术, 业务对象仪表板, Informatica, 和COGNOS
• 编写收集统计数据的脚本, 重组表和索引, 创建索引以提高数据访问的性能.
• 具有从Business Objects universe中检索数据的经验, 个人资料档案, 和存储过程.
• Experience in creating SQL *加载程序 scripts to load data into temporary staging tables.
• Experience in ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter.
• Extensive experience in creating new reports and customization of existing 报告, Oracle应用程序中的表单和PL / SQL过程.
• Involved in designing Oracle Forms 6i/10g and 报告 6i/10g by interacting directly with End Users and Business Analyst.
• 具有设计和开发界面程序的专业知识.
• Knowledge of SDLC life cycle, concepts and worked on different stages of the life cycle.

技术技能

数据库: Oracle 8i/9i/10g/11g, MS - SQL Server, DB2, MS Access, MySQL

脚本: UNIX Shell Script, SQL, PL / SQL, UNIX DB2, T-SQL

语言: Sql, pl / Sql, c, c++， html, XML

GUI工具: 报告6i/10g，表格6i/10g

ETL工具: Informatica PowerCenter

报表工具: 业务对象、水晶报表、Cognos

其他工具: SQL * +, SQL*loader, SQL Developer, 蟾蜍, Clear Quest

操作系统: UNIX, Linux, Windows Vista/2000/NT/XP

专业经验

机密，麦克莱恩，弗吉尼亚州

Oracle开发人员

职责:

• 广泛使用Oracle SQL, PL / SQL, SQL * +, SQL *加载程序, 查询性能调优, 创建DDL脚本, 创建了数据库对象，如表, 视图索引, 同义词和序列.
• 使用SQL*loader从平面文件读取数据到oracle表.
• Tuning of SQL Queries, 程序, 功能 and 包 using EXPLAIN PLAN and TKPROF.
• Depending on the requirements, designed and developed Web-enabled Oracle Forms & 报告. 包括基于存储过程的表单.
• Used 蟾蜍, SQL developer, Rapid SQL tools for faster application design and developments.
• Prepared all designs and code for various Cognos reporting objects and ensure compliance to all best business practices in industry.
• 开发PL / SQL包, 程序 和功能 accordance with Business Requirements for loading data into database tables.
• 创建SQL *加载程序脚本，将数据加载到临时staging表中.
• Involved in developing ETL Process to Load the Data from different sources.
• 通过创建Oracle PL / SQL包参与数据库开发, 程序, 和功能, Ref游标, 错误处理和触发器.
• Developed Shell Scripts to automate the process of transmission of files between the Oracle Applications and External system.
• 创建 control files for SQL *加载程序 and DDL/DML scripts for user/role management and data loading.
• 协助DBA完成表的创建和管理, 索引, 表空间, 触发器, 数据库链接和权限.
• Interaction with development team in fine tuning the SQL and PL / SQL code by creating 索引, 重新编写查询和分析表的数据以更新统计数据

环境: Oracle 11 g, PL / SQL, SQL *加载程序, PL / SQL开发人员, Oracle表格9i/10g和报告9i/10g, UNIX, Windows 2003, 蟾蜍.

机密，莱斯顿，弗吉尼亚州

Oracle开发人员

职责:

• Used Oracle as back-end database and SQL to validate the data in the output 表/ Flat files are correctly populated.
• Involved in exporting data from SQL Server into Oracle by generating flat files and then loading data into Oracle database using SQL*loader.
• 通过创建Oracle PL / SQL包参与数据库开发, 程序, 和功能, Ref游标, 错误处理和触发器.
• 编写过程来解析XML数据并将其存储在数据库表中.
• 使用SQL *加载程序加载平面文件到数据库表.
• 参与提取, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 10g database.
• Involved in developing UNIX shell scripts required for maintaining the data Models and processing job.
• 在Oracle企业管理器上工作，研究性能问题.
• 与业务用户交互并收集需求.
• Involved in validating the database privileges, developed complex SQL statements reports.
• Loaded data from different Sources into Temp data backup environment using UTL FILE.
• 开发各种复杂的查询，视图，用于生成SQL报表.
• Involved in customizing some reports with the user specifications using Oracle 报告.
• Using SQL trace utility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. 为了获得最佳效果，请将这些工具与EXPLAIN PLAN一起使用.

环境: Oracle 9 i / 10 g, SQL *加载程序, Oracle报告, MS Excel, UNIX, MS SQL Server 2000, UNIX, 解释计划, 蟾蜍

机密，北威尔士，宾夕法尼亚州

PLSQL开发人员

职责:

• 开发PL / SQL包, 程序 和功能 accordance with Business Requirements for loading data into database tables.
• 减少SQL查询的处理时间, 通过检查PL / SQL代码来处理夜间批处理作业, 修改数据库参数.
• Developed validation programs to validate the data before importing into the sales table.
• 监视数据库和系统备份, 开发Oracle存储过程, 功能, 包, 以及为报告提取数据的触发器.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in tuning SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• 参与开发用于加载数据库表的UNIX shell脚本.
• 使用SQL* Loader将数据从平面文件加载到数据库表中.
• 编写数据暂存、加载和清理过程的脚本.
• Used Unix Shell Scripts and developed PL / SQL procedures and 功能 to extract and load data for month-end batch processing.
• 参与新程序的开发, 功能, and 触发器 and also updating the old ones based on the change requests.
• 调优查询, structure of the code and performed refinement of the database design leading to significant improvement in system response time.
• Extensively used cursors, cursor for loops to fetch the data from different tables.
• Loading data into the intermediate tables using UTL FILE and SQL *加载程序.
• Used SQL *加载程序 to load the large volumes of data into the central database.
• 在应用程序开发期间使用了诸如蟾蜍之类的工具.

环境: Oracle 10 g / 9我, 发展商9i(表格9i, 报告9我), PL / SQL, SQL *加载程序, SQL导航器, 蟾蜍, Windows NT / 2000, UNIX (Sun Solaris).

保密

PLSQL开发人员

职责:

• 参与编写Oracle PL / SQL存储过程和Oracle包.
• 创建 database objects like tables, views, synonyms, 索引, and sequences
• 创建, 调试和修改存储过程, 功能, 包, 触发器, 表, 视图和用户定义函数等.
• 设计和开发新的表格和报告. 自定义现有的表单和报表.
• Coordinate with the front end design team to provide them with the necessary stored procedures and 包 and the necessary insight into the data.
• Developed and executed various scripts which are useful in the Data Conversion.
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.
• 积极收集业务用户的需求.
• 参与应用程序的维护和改进.
• 创建 Master Screens using Oracle Forms for customer information system.
• 使用shell脚本来更改和修改数据.
• Wrote Oracle Stored 程序, Database 触发器 for automated data updates.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance
• 编写Unix Shell脚本自动导出, import and loading requirements for Data Transfer between Different Systems.
• Early stages involved working as part of a team to analyze data from customer and providing documentation and reports.

环境: SQL, PL / SQL, Oracle8i, SQL Loader, MS-Word, MS-Excel, SQL Developer, Net Term,.

保密

PLSQL开发人员

职责:

• Involved in SQL Tuning by creation of 索引, rebuilding 索引, and clusters.
• 使用PL / SQL开发包和存储过程.
• 使用表单和报表设计和开发表单和报表.
• 创建 database objects like tables, views, synonyms, 索引, and sequences.
• 使用SQL Loader从各种资源加载数据.
• 使用shell脚本来更改和修改数据.
• 在应用程序开发过程中使用了SQL Developer等工具.
• 用测试用例进行单元测试和系统测试.
• Early stages involved working as part of a team to analyze data from customer and providing documentation and reports.

环境: SQL, PL / SQL, Oracle8i, SQL Loader, MS-Word, MS-Excel, SQL Developer, Net Term, WS-FTP.