SUMMARY

• Around 18+ years of total IT experience in complete software life cycle - Analysis, Design, Development, Testing, Defect Fixes, and Deploying business solutions using Oracle Technologies in Banking, Finance, Health, Airlines, Manufacturing, Production and Educational sectors.
• 10+yrs of Project Management experience in the areas of Project Management, System Engineering, Systems Architecture, Information Security, Business Intelligence (BI), Financial Data, and the full life cycle support of advanced IT systems.
• 12+ yrs of experience in Application Development and Maintenance (ADM) in different database environments.
• 8+ yrs of experience in system analysis and business intelligence modules.
• Extensive experience in developing applications using tools like Oracle Forms 11g/10g, Oracle Reports 11g/10g and Oracle database 11g/10g on Windows/ UNIX / Linux environment.
• Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL, Pro*C.
• Proficient in developing UNIX Shell Scripts, Database Procedures, Triggers, Packages, Functions, creating table partitions / sub partitions and indexing.
• Vast experience in data transformations, conversion and interface, data loading, database modeling and performance tuning.
• Expertise in developing Complex SQL queries, Oracle Performance Tuning and handling massive volume of data.
• Well experienced in working using Analytical Functions, PL/SQL tables, Bulk Collect, built-in Oracle packages and Oracle Reports.
• Experience in Extract, Transform and Load (ETL) Process and Oracle Data Integrator (ODI) and OBIEE Admin Tool.
• Hands on experience of Oracle Real Application Clusters (RAC)/parallel servers.
• Proficient in tuning of application using Explain Plan and TKPROF for performance enhancements.
• Proficient in Technical Data Analysis, Data Clean up and Data auditing.
• Experience with database backup, restore, and disaster recovery procedures.
• Experience in logical and Physical database design and working in client / server & multi-tier architecture with knowledge in distributed system.
• Developed E-Business Suite interfacing programs for interfacing data between In-house accounting system and oracle financials (GL, AR, AP).
• Strong problem solving, analytical skills and ability to learn and adapt to new technologies.
• Keen focus on performance tuning, testing, and quality assurance.
• Collaborate well with project management, business analysts, and department management teams.
• Strong project management skills and ability to effectively manage several large projects concurrently and cross functional.

TECHNICAL SKILLS

OS: Win 7/Vista/XP/2000/NT 4.0/win 98/Unix/Linux.

Languages: COBOL, Clipper, C, C++, UNIX Shell Scripts, VBScript.

Database: FoxPro 2.5, Visual FoxPro 3.0

RDBMS: Oracle 8i, 9i, 10g, 11g and MS-Access 2000.

RDBMS TOOLS: Oracle 8, 9i, 10g, 11g Oracle Case, SQL * Loader, SQL * Net, SQL * plus, Pro * C, Server Manager, Enterprise Manager, RMAN, HTTP Server, Oracle Web Server, Net Easy Configuration, Oracle Financials (GL, AP, AR, Payroll and PO), Oracle Jdeveloper.

BI Tools: Crystal Reports, Business Objects XI, OBIEE 10g/11g, Oracle Discoverer 10g

ETL Tools: Oracle Data Integrator (ODI), Informatica.

Internet Technologies: HTML, Java Script, JSP, XML, Servlets, CGI in C & Perl, CFML, DHTML

GUI: VB 6.0, Developer 2000 (Forms/Reports 10g/11g)

Packages: MS-Office-XP, 2000, 2003.

Multimedia: Adobe Photoshop 6, Macromedia Flash 5.0.

Others: PL/SQL Developer, TOAD, Harvest, iplan, HP-ALM.

PROFESSIONAL EXPERIENCE

Lead System Analyst/BI Technical Lead

Confidential

Environment: SQL,TSQL, PL/SQL, Oracle 11g/10g, OBIEE, Oracle BI publisher 5.6.2, Oracle Forms and Reports 11g/10g, Pl/Sql Developer, Toad, SQL * Plus, SQL * Loader, PRO*C,Crystal Reports XI, Business objects XI, ODI, Putty, Windows XP, Linux.

Responsibilities:

• Provide technical leadership including project planning and management, systems analysis and design including requirements definition, user support activities, testing and documentation.
• Understanding Functional Requirements and creation of High Level Design and Application Design document.
• Extensively involved in client relationship management and was responsible for entire BI project implementation.
• Managed the migration of legacy Rails database to enterprise data warehouse (EDW) and successfully implemented entire OBIEE system (Oracle Business Intelligence Enterprise solution)
• Managed and develop the entire ODI interfaces to migrate OLTP database to data warehouse using different interfaces,
• Created technical design document and OBIEE BI Publisher report templates to implement OBIEE Reporting and creation of multiple subject areas.
• Provide OBIEE Administration support and automated RPD migration process from dev to test and implemented SDLC process for OBIEE and ODI development.
• Mentored the development team on OBIEE development and assisted is developing OBIEE dashboards and creating physical and logical tables mapping in OBIEE Admin Tool.
• Implemented entire ODI tool at enterprise level which includes installation, infrastructure planning and automation of migration of interfaces across different environments.
• Assisted database administrators in managing BI Server enterprise manager and BI web logic console.
• Developed Data Flow / Process Flow diagram and ER diagram using Microsoft Visio. Also, used for reverse engineering.
• Extensively involved in developing complex data entry forms using forms 10g/11g.
• Developed many scripts to export data from SQL Server to Oracle using SQL Server Business Intelligence Suite (SSIS).
• Developed many accounting reports using BO and uploaded on Business objects CMC and scheduled to run on particular time
• Application back-end development using Oracle 11g,10g SQL, PL/SQL Procedures, Packages, Functions, Triggers, Views for different modules
• Effectively Partitioned / Sub Partitioned tables based on the data access, distribution and ease for archival
• Assisted in performance tuning from DHW to OBIEE queries.
• Effectively used PL/SQL tables during loading and allocation processes
• Involved in Performance Tuning using various tools provided byOraclelike SQL Trace and Explain Plan.
• Developed scripts for loading data from various systems using UNIX Shell,Oracle, PLSQL, SQL*Loader.
• Code Review for other modules and functional / unit testing of components developed
• Involved in Performance tuning and reduce the runtime of processes, to meet SLA and make increase system availability
• Usage of advanced Oracle functions / Analytical functions to meet the specific allocation requirement and having millions of rows processed in quick fashion
• Initial Scheduling and jobs run using CRON, later replaced with AppWorx scheduler
• Performed Technical Data Analysis and Data Auditing to identify root cause if mismatch detected between 2 systems
• Involved in complete project life cycle - Analysis, Design, Development, Testing, Defect Fixes, Deployment, Red Hat Support and Enhancements
• Co-ordinate with testing team, Project Manager, Business Analyst, Data Base Administrator team
• Identifying root cause and fixing defects identified during testing phase within stipulated time defined based on defect severity. Defect tracking is done thru Clear Quest, Alteris
• Compare code changes between different versions using Compare IT and the code base is maintained in HP ALM

Sr. Software Engineer

Confidential

Environment: SQL, PL/SQL, Unix Shell Scripting, XML, Oracle 10g/9i, Oracle Discoverer 10g, Oracle BI/XML publisher 5.6.2, Oracle Forms 10g/9i, Oracle Reports 10g/9i, Pl/Sql Developer, OBIEE,Toad, SQL * Plus, SQL * Loader, PRO*C,Putty, Oracle E-business Suite 11i, Windows XP, Linux.

Responsibilities:

• Responsible for successfully managing and enhancing Outstation Accounting System (COMET) that resulted in a 40% increase in accounting feasibility across multi-business agents across the world.
• Delivered quality solutions with minimal rework by adhering to coding standards and maintaining all quality measurement documents (QMS) during entire SDLC.
• Responsible for meeting with end user, collecting requirements (User Requirement Specifications) and converting into technical specification documents (Solution Definition Specifications, Technical Design Document) and statement of work (SOW) document.
• Actively involved in creating Unit Test Cases, User Acceptance Test Cases and providing post-implementation support.
• Successfully accomplished complex business logic by developing well tuned, reusable PL/SQL blocks (Stored Procedures, Functions & Packages).
• Created advanced user friendly data entry Forms using oracle Forms 10g, 9i, 6i for entering data related to stock, revenue, under collection, GL, AP, AR, Bank etc modules.
• Created and customized analytical, decision making reports for different modules in existing system using Reports 10g, 9i, 6i.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, triggers, C, Pro*C, K-Shell scripts.
• Achieved 10% increase in application performance by tuning SQL queries written in procedures/functions at the back end which are called from the front end forms.
• Responsible for creating, implementing and maintaining data synchronizing scripts used for synchronizing data between remote databases and central database at scheduled time.
• Optimize database performance by analyzing objects, generating statistics, creating indexes and views.
• Created UNIX Shell script for sending email to alert users for erroneous records.
• Created SQL*Loader scripts to load data from external system to oracle & created discoverer report based on this.
• Use Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• Created programming code using advanced concepts of Records, Collections, and dynamic SQL.
• Created Job schedulers using DBMS job schedule for synchronization of oracle financials data with in-house ERP system using web services at defined intervals.
• Extensively used XML procedures to read data from oracle financials and insert the same into In-house ERP system.
• Used UTL HTTP package to implement HTTP Communication from within the Oracle Database
• Increased the performance of data retrieval queries by building well managed Materialized Views as part of Summary Management.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Actively used Configuration Management Tool HARVEST for version controlling of source code.
• Used Oracle Jdeveloper to develop integration modules between oracle financials and COMET using Java, XML, Web Services and SQL.
• Actively involved in implementing Fine Grain Access Control (FGAC).
• Performed DBA activities like: Creation of schema, table spaces, tables, views, materialized views, Indexes, database links, tuning complex SQL Queries, Creation of Users and defining roles and privileges.
• Responsible for taking Offline and online backup of databases using RMAN, Oracle Enterprise Manager and customized scripts.
• Planned and implemented Oracle software installations, upgrades, and patches along with DBA’s.
• Actively involved in adding new nodes to RAC 10g Cluster to distribute the load and maintain 100% uptime.

Sr. Software Engineer/Analyst

Confidential

Environment: SQL, PL/SQL, Unix Shell Scripting, Oracle 10g/9i, Oracle Designer 10g/9i, Oracle Forms 10g/9i, Oracle Reports 10g/9i, Pl/SQL Developer, Toad, SQL * Plus, SQL * Loader, PRO*C, Putty, Oracle E-business Suite 11i, Windows XP, Linux.

Responsibilities:

• Developed and documented business and business use case, technical requirements for various modules including customizations
• Migration of data from SQL Server to Oracle: All sales data collected on hand held devices was downloaded to SQL server and later through complex T-SQL queries, Batch commands and SSMA inserted into oracle database to interface with financial module
• Migration data from Oracle to SQL server: Entire Customer balances, Supplier updates, Opening stock details from financials system was interfaced into hand held devices using ODBC, OLEDB connections, complex SQL queries and SSMA.
• Created test scripts to test the product functionality and developed various scenarios for data validation and heavily involved with testing and QA
• Worked closely with
• Technical team - on technical implementation: (data mapping, user data synchronization, training migration), data validation/testing, technical issues and resolution
• Business team - to gather requirements, review issues/concerns/needs, knowledge transfer, and tasks
• Sr. Management - to keep them informed with project progress
• Designed, developed and customized forms by using Oracle Forms 9i, 6i and Reports 9i, 6i for different branches of Organization like Production Control, Stock Management, Inventory, Sales, Raw Material Management, Banking Module, Cash Management, Asset Management, GL,AP,AR, etc.
• Involved in migrating warehouse database from Oracle 9i to 10g database.
• Developed Packages and customized functions and Triggers based upon the business logics.
• 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.
• Usage of UTL FILE, TEXT IO package to load the data from external files that is exported from Server.
• Created complex analytical reports using inline view, lexical parameters with Oracle Report 9i.
• Troubleshooting and analyzing PL/SQL code to look for optimizations possible.
• Team Lead in developing an integration module used to migrate data from VAN SALES SYSTEM to New Financials Systems which involves:
• Maintained New Financials with various repositories for security, Managing Objects, Server and Audits.
• Extensively involved in tuning all database scripts.
• Monitoring database capacity and performance metrics.
• Managed the Import and Export of the database from local to remote machines.
• Created XML/BI reports using XML/BI Publisher.
• Worked extensively to formalize the logical design using ERWIN and physical creation of database objects like tables, view, sequences, function, packages, procedures etc.
• Implementation of MTX Module for Barcode Scanning at Al-Hasa Supermarket and Al-Hasa Cold Storage. The system has a Speech Application Programming Interface (SAPI) through which machines can be controlled by voice
• Responsible for creating, tuning, sizing, maintaining all test and development databases and servers. Support development and business groups in implementing new applications.
• Managed the Import and Export of the database from local to remote machines.
• Software maintenance for client's legacy iFast (financial system) based on Oracle 7, Oracle Forms 3, Pro*C, PL/SQL on Novell Network.