SUMMARY

• 20+ years of IT experience involving requirements gathering, analysis, design, 发展, 测试及实施资讯科技应用.
• 开发人员的专业知识, Analyst, 模块领导, 项目领导, Onsite Coordinator and involved in Project Management activities.
• Over 9+ years of experience in designing and developing applications using Oracle Technologies performing role of Oracle Senior PL/SQL Developer.
• 精通数据建模(关系) & 维度)使用ERWIN
• Experience in developing ETL jobs using leading ETL tools like Informatica, Talend and Pentaho
• 丰富的PL/SQL经验, 编写存储过程, packages, 触发器和其他数据库对象, 导入/导出, SQL Loader, 使用像DBMS JOBS这样的标准包, DBMS输出, DBMS SQL和UTL文件实用程序.
• 熟悉复杂的存储过程, triggers, 视图和其他数据库对象, 通过文件批量加载, queuing, 导出/导入, 基于XML的数据加载和, Jr. DBA activities like creating indexes and granting privileges.
• 丰富的开发经验 & 生产支持环境及其职责.
• 优秀的分析, technical, and interpersonal and communication skills coupled with an intense customer - centric attitude.
• Extensively involved in Unit, Integration, system testing and UAT of applications.

技术技能

RDBMS: Oracle 11 g / 10 g / 9我/ 7 / 8.x/6.x

OS: HP Unix 10.2 /Red Hat Linux/Windows 2000

软件工具: 开发者/2000,Informatica.5、天才.2、Pentaho的用法和样例.x, TOAD, SQL Developer

语言: PL/SQL, C, Python.7, Pro*C

Hardware: HP 9000/T520 server, DEC ALPHA server, Sun servers, Compaq servers

专业经验

保密

Oracle高级开发人员

职责:

• 业务需求分析.
• 理解遗留系统, 进行需求研究, 系统规范, 系统设计, coding, testing.
• 设计表格结构, 表的规范化, 实体关系图, 定义完整性约束
• Bug fixing and implementation of enhancements for new requirements
• Analyzing the impact of any new business requirement that come in through BRD
• Prepare design documents - Prepare HLD and DLD after BRD freeze
• 与客户端的高级交互
• 丰富的Oracle PL/SQL经验, 单元测试, 逻辑和物理数据库设计, 数据库维护.
• Preparing the business requirement documents in the agreed format
• Developing complex functions, stored procedures and packages, Triggers by using PL/SQL.
• Single point of contact for the quality assurance compliance and issue solving with respect to the team members
• Performing Coding / Development, Unit Testing and Peer Code Reviews

环境: Oracle 11.. x、PL/SQL、TOAD

保密

团队领导/高级ETL开发人员

职责:

• 作为团队领导, 我负责与客户的所有高层互动, presented monthly metrics and ensured my team worked efficiently towards the resolution of all issues.
• I mentored team members and motivated them to be proactive and take up higher responsibilities.
• Developed ETL jobs for converting data from legacy system to a new application using Java/Oracle technologies
• Involved in coordinating with offshore team for 发展 of ETL jobs
• 进行审计 & ETL作业的控制机制
• Developed PL/SQL stored procedures to enhance the capabilities of ETL jobs.
• Tuned PL/SQL stored procedures and achieved 500% improvement in performance.
• 参与使用ERWIN的数据建模活动.
• Developed complex functions, stored procedures and packages, Triggers by using PL/SQL.
• Single point of contact for the quality assurance compliance and issue solving with respect to the team members
• Performing Coding / Development, Unit Testing and Peer Code Reviews

环境: Oracle 11.x, Pentaho 5.Linux, PL/SQL, SQL Developer

保密

高级数据库开发人员

职责:

• Designed Dimensional Model for Texas Driver License Verification Program Data Warehouse
• 使用Talend和Python开发ETL作业
• Designed the architecture and implemented a new service to 保密 ’s biggest client which involved a weekly processing of nearly a 100 million records
• 团队协调员和状态报告经理, 进度报告, 资源分配和规划, organizing project related trainings and holding team meetings.
• Translating the business requirements into technical requirements.

环境: MS SqlServer 2012, Talend 5.2、Python 2.7, MySql

保密

领导-数据管理

职责:

• Administered Oracle Databases for four 发展 projects
• Responsible for database design (Relational model) for four 发展 projects
• Developed stored procedures, functions and packages for four 发展 projects.
• Tuned the applications for superior performance for four 发展 projects.
• Prepared Project Proposals (from database perspective) in response to RFP’s (Request for Proposals).
• Led a five member Data Migration Team for SAP implementation at Oman Gas Company, 重要的采购申请单 & 采购订单模块.

环境: Oracle 11g, SQL, PL/SQL

保密

甲骨文公司领导 & 高级培训师

职责:

• Conducted training for 200 students on Cognos 8, Oracle 10g DBA and Oracle PL/SQL programming
• Designed a new and comprehensive course structure for Oracle 10g DBA/PLSQL training and Cognos 8 training
• 作为顾问, provided support to 保密 ’s corporate clients for designing their database (Relational Modeling)
• 作为顾问, provided support to 保密 ’s corporate clients for tuning their applications for superior performance.
• Responsible for preparing Project Proposals (from database perspective) in response to RFP’s (Request for Proposals).

环境: Oracle 10g, SQL, PL/SQL, HP UNIX, Cognos 8

保密

主要顾问

职责:

• 作为数据建模认证项目的负责人, conducted Data Modeling training to 20 软件工程师s of Satyam, 为五个应用程序准备和审查数据模型, 编写了详细的索引指南, 数据仓库分区.
• 在Cognos 8中进行培训 &Informatica 8.萨蒂扬200名软件工程师1名.

环境: Oracle 10g, Cognos 8, Informatica 8.1, Erwin

保密

主要顾问

职责:

• Lead a team of 9 Oracle DBAs and 1 SQL server DBA and managed DBA activities in all the projects across the company
• Prepared standards for PL/SQL programming (Stored procedures, functions and packages)

环境: Oracle 9i/10g, SQL, PL/SQL

保密

Tech Lead

职责:

• Extracted, Transformed and Loaded data from legacy systems to new application
• 指导一组Informatica专家和一名Oracle DBA

环境: Oracle 9i, InformaticaPowermart 5.0、sql, pl / sql

保密

高级顾问

职责:

• Provided technical support for Flexcube (a leading core banking solution) for clients in Middle East, Europe & Africa, managed End Of Day operations for 保密 (a leading bank in India), prepared and executed test plans for 3 major releases of Flexcube

环境: Oracle 9i, Developer/2000、sql, pl / sql, UNIX

保密

高级顾问

职责:

• Helped to migrate from their old applications in Sybase to new application in Oracle
• 为这家保险公司在波兰的业务编写报告 & 巴西的业务

环境: Oracle 8.SQL, PL/SQL, Developer 2000 (Forms . SQL & 报告)，信息，电源4.5

保密

顾问

职责:

• 实现的旗帜, 一个应用程序, 通过提取, transforming and loading data from legacy systems to Banner.
• 金融 & Resource Management, tuned queries and reduced execution time from 30% to 70%

环境: Oracle 7.x, Developer 2000 (Forms) & 报表)，UNIX, SQL, PL/SQL

保密

高级软件工程师

职责:

• Analysis, design, 发展 and implementation of two applications for regulating air and sea shipments of Singapore

环境: Oracle 7.SQL, PL/SQL, Developer 2000, Pro*C, Digital UNIX

保密

高级软件工程师

职责:

• Analysis, design, 发展 and implementation of 一个应用程序s for automating the export functions of a leading bicycle manufacturing company in India.

环境: Oracle 7.SQL, PL/SQL, Developer 2000, Pro*C, HP- UNIX

保密

软件工程师

职责:

• Developed purchase and stores modules for a steel manufacturing company

环境: Oracle 6.SQL, PL/SQL, Forms.0、报告1.1、sco Unix