Oracle certified intenet application developer(OCP/MCSD)/ .NET
ADVANCE oracle FORMS DEVELOPER
E N O C K
Cell: 5 1 2 9 2 9 6 9 1 2
2 0 3 7 6 7 1 3 6 1
kumo70 AT yahoo DOT com
Over Ten years of experience in database design, development, implementation and maintenance of various Client-Server/robust Web database and Data Warehousing applications. Excellent communication and problem-solving skills and an effective team player.
I am a highly innovative and skilled professional with more than a year as a Project Leader developing and implementing online Library System for a University.
I am currently a senior consultant/Business Analyst responsible for Database migration, system re-engineering and integration Current title: Database engineer.
My Business analysis expertise involves Enterprise analysis, Requirements planning and management, Requirements elicitation, Requirements analysis, and Solution assessment and validation.
Professional Certifications Include:
? OCP: oracle Certified Internet Applications Developer(Application Servers)
1. 1Z0-001 SQL & PL/SQL
2. 1Z0-101 DEVELOPER PL/SQL PROGRAM UNITS
3. 1Z0-131 BUILD INTERNET APPLICATIONS I
4. 1Z0-132 BUILD INTERNET APPLICATIONS II
? MCP: Microsoft Certified Professional (Visual Basic .NET)
? MCP: Microsoft Certified Professional (Visual Basic 6-distributed)
? MCP: Microsoft Certified Professional (Windows NT W/S)
? MCP: Microsoft Certified Professional (Windows NT Server)
? MCP: Microsoft Certified Professional (Visual Basic-desktop)
? Expertise in Analysis, Design and implement of Client Server/Data warehousing applications using oracle 9i/10g Forms 9i (webforms)/Reports9i, JDeveloper3/9i, and Project Rave/Sun Java Creator 7(Java Web Tool).
? Extensively worked with database development writing stored procedures, functions, packages, and database triggers using SQL, PL/SQL. oracle 8i/9i Spatial and Locator: To store and retrieve multi-dimensional data in oracle. I used Spatial for Geographical Information Systems to implement geo-reference.
? Extending oracle Warehouse Builder(OWB) to enhance industry-leading extraction, transformation, and load (ETL) tools, by making it easy to connect to virtually any information system using standard and Enterprise capabilities. Incorporating mainframes, UNIX systems, and some packaged applications.
? Cognos 8 Business Intelligence and enterprise planning solution.
? Exposure to performance tuning, creating de normalized tables, using indexes, PL/SQL collections, native dynamic SQL, function based indexes and bulk binding.
? Expertise in technical training: oracle8i/9i Application server, oracle Financials.
? Experience in designing Framework for various applications and its development with oracle Developer/2000.
? Rapid Application Development with Visual Basic 6/. NET with Crystal Reports 8.0.5, MS SQL server2000.
? Advanced administration techniques in Windows NT server.
? Good understanding of business processes and mapping them onto real world solutions.
? Java Developer (Swing, AWT, Database connectivity-JDBC).
ACADEMIC AND TRAINING DETAILS:
Double Post Graduation : MS in Computer Applications (M.C.A.) /MS-Computer Science
Graduation : Bachelor of Science
Training : Networking with Novell Netware-Megabytes Technologies, Calcutta India
Operating System : Unix, Windows 9X/ME/NT 4.0/2000/XP
ETL Tools : oracle Warehouse Builder 9i/10g, WorkFlow, oracle Designer, MS SQL2000 DTS
RDBMS : oracle 7.3/8.0/8i/9i, MS Access, MS SQL Server 7/2000
RDBMS Tools : Toad 8.6/8.0, Query Builder, PLSQL Developer, PL/SQL, SQL*PLUS, SQL LOADER, Procedure Builder, Pro* C, SQLPlus Worksheet
Versioning Tools Appworx 6.1/6, PVCS/EXCEED.
oracle Front-End : Developer2000: Forms/Reports 6i/9i, oracle8i/9i Spatial/Locator, JDeveloper
: Project Builder, Schema Builder
Front End Tools : Microsoft Visual Basic 6.0/. NET, Crystal Reports8.5
Web Server : IIS 4.0/5.0, Apache Tomcat
MS-Office Suite : Ms-word, ms-Access, ms-Excel Macros PowerPoint, Excel
Senior oracle Applications Developer
Omaha, Nebraska Feb. 2006-Mar. 2008
I am currently engaged in re-engineering oracle Financial Applications for an International Financial company. This involves intensive analysis, design, documentation and implementation of advanced oracle PL/SQL. Advanced code generation with oracle Developer Suite Forms 6i/Reports, oracle Pro*C, Unix/KornShell/Bash Shell Scripting, Perl and Python-CGI Scripting with Apache Server, FTP Utilities, PACKMULE and oracle Financials, Lotus Notes Mail; Migration process from Forms 4.5 to oracle Forms 6i; Database Migration from oracle 8i to oracle 10gR2. oracle Concurrent Manager, PVCS and APPWORX 6 Scheduling Manager.
I did intensive system modeling (1)Logical modeling by gathering information about business processes, business entities (categories of data), and organizational units, (2)Physical modeling that involves the actual design of a database and Front-End modules according to the requirements that were established during logical modeling.
I thoroughly used oracle Application Express (oracle HTML DB) as a component of the Reporting Tools for graphical data analysis, to quickly create secure and scalable web applications that we instantly deployed to the Company Intranet.
Successfully completed training in Cognos 8 Business Intelligence and enterprise planning solution.
Software Engineer/Senior Database Developer
City Hall, City of Newark New jersey [Dec 2003-Feb. 2006]
I worked on the new version of the Code Inspection System for a large Company, conducting detailed comparative analysis with the current Mobile system. For the last Five (5) years the CERTS System used by the Organization was based on Visual Basic 6.0 with oracle8i/9i PL/SQL as back-end. This involves intensive analysis and implementation of advanced oracle PL/SQL. My work as the Developer/Analyst is to thoroughly analyze this current system then migrate it to Microsoft Visual Studio.NET 2003 Framework with MS SQL Server2000 as back-end. The new release is more robust, engineered by oracle10g Database server (for mobile component), oracle Forms/Reports 9i (Developer Suite components), together with oracle Business Intelligence Discoverer 10g for integrating reports and analysis. I used oracle10g Warehouse Builder in current project together with MS SQL Server Warehouse Tools. Crystal Reports8.0.5/IX for delivery reports for extreme administrative insight (client/server architecture) with Visual Basic.NET 2003 user-interface. Final phase of this assignment involve the Database Migration from oracle 9i Lite (mobile/PDA) to MS SQL 2000 Server. This project involves Database migration from oracle9i to MS-SQL 2000.
During my tenure as a project leader, I was actively involved in the following phases of system development paradigms.
? Problem definition [PD]: At this stage we determined the needs and constraints of the finance department by analyzing the requirements and interfacing with the administration [Time Frame: 3 weeks]
? Solution analysis: By considering PD as the input, we were concerned with the set of possible ways to satisfy the requirements and constraints, studies and analyze the possible solutions, and select the optimum one. This was based on a couple of logical Tools such as ERD, Flow of Data, and UML [Time Frame: 2 weeks]
? Process planning: This phase brought us to the actual tasks to be done, the size and effort to develop the software solution, the precedence between tasks, and the potential risks to the project. To understand the new system better, we still used some of the above logical Tools [Time Frame: 3 weeks]
? Process control: Only three people engineered this phase, the task is to determine the methods for controlling the project and the process, measures progress, reviews intermediate products, and takes corrective action when necessary [4 weeks]
? Product evaluation: Determines the quality and quantity of the delivered product through evaluation planning, testing, demonstration, analysis, examination, and inspection. We started by installing the system prototype on wide variety of hardware configuration running different versions of Windows operating systems [4 weeks]
oracle DEVELOPER/DATABASE ANALYST
SOFTWARE ENGINEERING SECTION,
KENYATTA UNIVERSITY [April 2001 ?Aug 2003]
Software: SQL-Loader, oracle Procedure Builder, SQL, PL/SQL, UNIX Shell Scripting, Developer/2000 Forms6i/9i, Reports 6i/9i & Forms/Reports migration to oracle10g environment, Data modeling, advanced documentation skills.
O/S platform: Windows NT/2000/XP/9x, UNIX
? Designing and creating database structure and table schemas layout.
? Training of University Staff: oracle/Visual Applications, oracle HRM.
? Loading data from Flat Files (rtf/txt/doc), MS Access Database, and MS Excel to oracle9i tables using Database Links.
? Developing System Logical Models, Transformations and debugging using oracle Schema Builder.
? Generating the University payroll Reports using Reports6i Release and providing technical assistance to finance office.
? Data conversion from Ms-Access, Ms-Excel to oracle9i objects, and generating Financial Reports.
? Administering and maintaining university Bulk database on oracle server8i using SQL, PL/SQL, views, packages and stored procedures.
? Intensive usage and maintain of oracle Pro*C Applications: Embedded SQL statements, WHENEVER statements, SQLCA, Dynamic SQL, ARRAYS, Host variables, Preprocessor Directives
? Using collections, FORALL and bulk bindings to improve performance.
? Developed debug module and log each and every error so that processing is not stopped even if any error is encountered.
? Integrating packages and stored procedures to migrating data to reporting table schemas.
? Creating and using database links and synonyms.
? Automate the report generation process and scheduling/rescheduling of reports and creating log files automatically on a daily basis for each batch run.
? Created indexes, performance tuning for faster retrieval of data.
? Managing the University oracle server8i by carrying out weekly Backup, and system Recovery process.
oracle CERTIFIED TRAINER (Part-Timer)
SOFTWARE TECHNOLOGIES, NAIROBI [Jan 2003 ? Aug 2003]
Comprehensive oracle certification programs, including oracle9i Certified Professional Database Administrator - OCP DBA, oracle 8i/9i Certified Associate ? OCA, and oracle Developer Forms/Reports9i.
? RDB01:Introduction to oracle
? RDB02:oracle 3GL Programming
? RDB03:oracle for the Database Administrator
? RDB04:oracle Performance and Tuning
? RDB05:oracle Internals
? oracle 9i Spatial and Locator: for Geographic data processing
? RDB06:oracle for the Database Designer
? WEB320: Java - Core Language
? NT01: Microsoft Windows NT4 Express
? NT03: Microsoft Windows NT4 Enterprise Technologies
? NT02: Microsoft Windows NT4 Workstation & Server Administration
? Gathering new reporting requirements from the client, generating reporting specifications, resolving any issues/conflicts and getting signoff on the requirements.
? Loading Data to Data Warehousing using Java extractor and loader programs.
? Generating reports using SQL, PL/SQL, views, packages and stored procedures.
? Using collections, FORALL and bulk bindings to improve performance.
? Creating trigger files automatically on a daily basis. Automate the report generation process and scheduling/rescheduling of reports generation.
? Applying business intelligence to data using oracle Discoverer.
? Created indexes, performance tuning for faster retrieval of data.
? Loading log files (from Java program output) to oracle tables using External Tables.
? Supporting business users with ad-hoc queries using Discoverer.
? Successfully developed and deployed WROCS 1.1 release to PRODUCTION.
? Technical trainer: Microsoft Visual C++ 6/. NET-Microsoft Certification credentials.
oracle / DataStage developer
AMARCO TECHNOLOGY, NAIROBI [Aug 2000 ? March 2001]
Software: Windows NT4.5/2000, oracle 9i Enterprise server, Developer/2000(Schema, Forms & Reports 6i/9i). Extending Ascential DataStage to enhance industry-leading extraction, transformation, and load (ETL) tools, by making it easy to connect to virtually any information system using standard DataStage capabilities. UNIX systems and some packaged applications.
DESIGN AND IMPLEMENTATION OF BUSINESS SOLUTION
? Design and development of complex packages, stored procedures and functions to implement business functional requirements into Database transactions, advanced control structures, writing flexible code, Form ?level validation.
? Designing Web-Form/Form canvases, implementing Run-Form Messages and Alerts, Creating LOVs and Editors
? Writing Explicit Cursors, Controlling user access, administering oracle data dictionary and maintaining log files.
? Making modifications to the existing oracle code to improve performance by creating denormalized tables, creating triggers and views on existing tables to populate the de-normalized tables.
? Provide Technical Assistance to the development team for PL/SQL.
? Administering Tablespaces and clustering in oracle server. Managing Disk Quotas, Segments and Extents with USER_SEGMENTS/EXTENTS
? Tuning SQL queries and code using EXPLAIN PLAN, SQL_Trace/TKPROF utility, DBMS_PROFILER.
? Creating performance release installation scripts and loading data using SQL Loader/Database Links to remote Database engine.
? Writing Database triggers to avoid mutating table error, using function based indexes, bulk binding, native dynamic SQL and collections.
? Administering Database packages: DBMS_OLAP, DBMS_CATALOG, DBMS_LOB, DBMS_SQL, DBA_TRIGGERS, DBMS_REDEFINITION etc.
? Debug the existing code and modify the code for performance enhancement.
? Interaction with clients to improve the application and maintenance of CRM.
? Administering versioning and Check-in, Check-out (CICO). Working with oracle Forms services (oracle9iAS)
? Designing and implementing User-Interfaces with Visual Basic6/. NET Framework 1.1
? Generating Reports with Developer/2000 Reports 6i and Crystal Reports 9.0
? Packaging Application online Documentation and Testing Techniques (.chm files)
? Packaging/Debugging and Deploying Business solution.
? Maintaining customer Business Applications.
? Archive redo-log files and hot backups. Configure and use multithreaded server (MTS) and connection manager.
KENYA TELECOM CORP,
NAIROBI [Jan 1998 ? Jul 2000]
Software: Windows NT4.0/2000 servers, oracle 8i/9i Advanced Enterprise server, PL/SQL Builder, Forms/Reports 6i. DataFlow scheduling with oracle Scheduler: Increases system control, ease of use, and production capacity, Extends scope of centralized workload management, Reduces the need for workload management skills at remote locations, provides a significant contribution toward unattended operations
? Involved in requirement study, design and development of DATABASE.
? Created FTP Session to download data files on a regular basis.
? Sort data files using Unix Shell scripting.
? Requirement analysis, database design and related coding for transactions like insert, update and delete.
? Created ActiveX Module to send quotation via Email using WinSock Control.
? SQL Server 7.0 and 2000, ASP, oracle Designer 2000, oracle Developer 2000, oracle Forms6i, oracle
? Designing PL\SQL scripts to create temporary tables for daily Databases transactions, schemas modeling.
? Created Informatica Mappings and Sessions to load data files to Data Warehouse.
? Created expression, lookup and router transformations to check customer information and add customers those are not present already.
? Sending Post-Session Email once data is loaded.
? Load data files to Data Warehouse on a daily basis.
? Extensive use of PL/SQL for database related functionality. Created package and stored procedures for. Applying business rules to produce the required results.
? Data validation with care that no duplicate data is inserted Fetching uploaded invoice data for Invoice testing (Done via web pages - ASP.Net/IIS 5.0)
? Generated Log module that saves each and every error/action of applying business rules.
? Created test scripts for the developed code.
? Created complex view of invoice and product data for reporting.
? Telneting, FTP-ing and taking backup of the generated results on a regular basis to/from Unix Server.
? Creating and making modifications to the Packages/Stored Procedures with Developer/2000 Procedure Builder.
? Involved in User requirement study, designing of the Database Schema Objects, and Development.
? Developed Web pages using JSP (Beans, Servlets, and ODBC-JDBC Bridge) and HTML as Front-end for login module, insert, update, view, data persistence, page navigation and parameter sharing.
? Developed electronic signature functionality that is used from front end.
? Sending formatted e-mail about user activity/action to administrator using Java Mail services.
? Monitor activity on each CAPA and send reminders via e-mails to responsible users.
? A data mart-ing a segment of a data warehouse to provide data for reporting and analyzing the departments/operation in the company. Sometimes handling individual data warehouses which are smaller than the corporate data warehouse.
? Intensive use of Online Analytical Processing (OLTP)
? Using Aggregations on numeric data by calculating and storing the results to a query before users ask for it. Expertise in fast query performance in OLAP.
CENTURION COMPUTERS LTD, NAIROBI [July 1997 ? Dec 1997]
? Repairing Computers: Network servers, Desktops, and Laptops
? Assembling and installation of software on Computers
? Identify Local Area Network configurations
? Discuss LAN protocols with the management
? Troubleshoot LANs
? Use common Internet features like e-mail and browsers
? Implementing LAN topologies and configurations
? Recommend Ethernet specifications
? Configure NetBEUI and IPX/SPX
Work Desired: Contract/Direct/OTHERS
Rate/Hr: 1099 @ $67/hr OR W2 OR others
Willing To Relocate: Yes
Security Status Employment Authorization Document(EAD)/Greencard