Skills Highlight Specialty Skills MVC UML Object-oriented analysis and design CASE Tool Visual Paradigm Python development using Django framework. Apache installation and configuration ORACLE Data Guard ETL Design Concepts and ETL Coding skills. Extensively used Informatica tools - Designer Source Analyzer Warehouse designer Mapping designer Mapplet Designer Transformation Developer and Repository Manager. Scheduling ETL jobs. Informatica Power Center Life Cycle design Design Requirements Data Modeling ER Modeling Database Design Application Development Database Administration Advanced Replication Oracle Forms hot and cold Backup and Recovery for a number of recovery scenarios Performance Tuning Virtual Box Products C C VB.NET VBA JAVA ERwin PERL 5 CRYSTAL REPORTS FORTRAN COBOL PASCAL MySQL SQL Server T-SQL MS ACCESS MS Excel VISUAL INTERDEV JCL DCL ASP HTML XML Dreamweaver Photoshop Flash 5 Apache VBScript Java script DBI DBD ORACLE DBD ODBC Operating Systems Windows XP Windows 2000 Windows NT UNIX Linux VAX/VMS Oracle Products ORACLE Portal 3.0 installation and development 9iAS ORACLE 11G ORACLE 10G ORACLE 9i ORACLE 8i ORACLE 7 Toad SQL Navigator SQL Plus RMAN Enterprise Manager PL/SQL Net8 Advanced Replication Oracle Forms 6i Oracle Designer 6i Oracle Discoverer Oracle Reports 6i Java Oracle Jdeveloper 2.0 Oracle DBA Studio htp htf packages Materialized views Management/Leadership Skills Project Leader Communications SQLNet Net8 Project Experience

confidential

Development of VBA programs for MS Access database to house provider

records of the county

Development of text file parser using Python

confidential

Developed Telecommunications rating system using Oracle PL/SQL

Query performance tuning using SQL Tuning Advisor and SQL Access Advisor packages confidential Linux Ubuntu ORACLE installation. Data Guard. Created physical and logical standby databases Conducted switchover in which the primary database exchanges roles with one of the standby databases. Successfully tested failover scenario simulating failure of primary database when preassigned to be a FastStartFailoverTarget standby database accepts a role of primary database With Data Guard Broker created and enabled Data Guard configurations monitored Data Guard configurations added standby databases to an existing Data Guard configuration. Arranged real-time apply for Redo Transport Services. Performed cold and hot backups of ORACLE database using RMAN. Used the DUPLICATE command to create duplicate databases and standby databases. Recovery from corrupted or missing datafiles Recovery from corrupted or missing online redo logs. Recovery from corrupted or missing control files. Disaster Recovery Worked on Informatica Created mapplets Created ETL mappings using Informatica Power center to move Data from multiple sources like Oracle SQL server Flat files into target area ORACLE Data Warehouse Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier Lookup Filter Expression Router Joiner Update Strategy Sequence generator Stored Procedure Sorter Aggregator Worked on technical design and development using Oracle 9i/10g including writing SQL queries stored PL/SQL and Java procedures packages basic data modeling performance tuning and technical documentation. confidential Creating data models in ORACLE database Performed Disaster Recovery using RMAN Performed Backup and Recovery using Recovery Manager RMAN Installation of ORACLE Portal 3.0 Creating of portal using ORACLE Portal 3.0 and ORACLE PDK Installation of Discoverer 3 Created reports using Discoverer 3 Creation and managing End User Layers. Creating new users. Built New Business Areas. Moved Business Areas Across EULs Created Item Classes and Lists of Values. Managed Summaries. Created custom PL/SQL functions to meet users requirements. Produced reports using Table Layout and Crosstab Layout Created and edited Totals Definitions. Created and Edited Conditions Was teaching client to use ORACLE Discoverer Database design using ORACLE Designer 6i Created ORACLE Forms and Reports Creating and debugging stored procedures using QUEST SQL Navigator Creating stored procedures generating HTML pages using HTP and HTF packages Creating Visual Basic and VBA codes for dynamic configuring of ODBC DataSource for linking it with newly created source files Building a trigger-like mechanism in VB to check for new MS Access files and synchronize dynamic ODBC DataSource configuring with processing of data from current datasource in Java application. Creating PL/SQL packages for internal ORACLE project in Headquarters confidential ORACLE DBA Installation of ORACLE 8i Enterprise Edition on Sun Solaris UNIX System Installation of ORACLE 8i Enterprise Edition on MS Windows NT. Database design Creating of Microsoft Access applications with ORACLE database in the background Writing of SQL scripts Maintenance of existing payroll system in COBOL. Creating and debugging stored procedures using QUEST SQL Navigator Migration from SQL Server 7.0 to ORACLE 8i using ORACLE Migration Workbench Creating datamodels in ORACLE database Working with triggers and sequences in ORACLE Used X windows working from NT workstation with Sun Solaris Installed and worked with F-Secure SSH Installation and working with Perl using DBI and DBD ORACLE and DBD ODBC Working with ODBC on Sun Solaris Unix platform Intersolve ODBC ORACLE driver SQL Loader Chili ASP on Sun Solaris VB programming VBScript with ORACLE through ODBC ASP HTML confidential Team manager. Managed two programmers developing reports using Crystal Reports. Created ORACLE PL/SQL stored procedures in ORACLE 8i with Faust SQL programmer on MS Windows NT for data processing for reports on daily basis. Operated with database objects using SQL Plus and ORACLE Enterprise Manager tools. Developed statistical algorithm to establish a relationship between tables populated independently using similar but not exactly the same terminology Implemented this algorithm creating ORACLE PL/SQL stored procedures in ORACLE 8i. Installed client ORACLE tools including ORACLE 8i Enterprise Manager Installed Faust SQL Programmer Installed Crystal Reports. confidential Extensive DBA work Installation of ORACLE 8.0.4 and ORACLE 8.0.5 Enterprise Edition on MS Windows NT. Installation of ORACLE 8.0.5 Enterprise Edition on Sun Solaris UNIX System Migration from old ORACLE version to 8.0.5 Enterprise Edition Trained people to work with ORACLE 7.3.2 and ORACLE 8.0.5 Migration from ACCESS to ORACLE Worked with ORACLE Enterprise Manager tools Performed Backup and Recovery using Recovery Manager RMAN and Enterprise Manager Backup Manager Advanced Replication Created reports using Reports 3.0 Installation of Discoverer 3 Created reports using Discoverer 3 Created applications using Oracle Forms 5 Analyzed VB codes looking for bugs and debugged customer s programs Conducted research concerning insert of long fields to tables in ORACLE database and implemented stored procedures for this Helped customer to arrange database import from different databases to ORACLE using VB codes confidential Installed Oracle RDBMS V8 V7 on MS Windows NT. Gathered business requirements. Performed analysis design and coding of front end application for medical Call Center in Visual Basic 5.0. Performed Backup and Recovery. Created configuration files for SQLNet. Wrote SQL scripts PL/SQL programs. Used stored procedures and triggers within client/server environments. Used MS Access to deliver data from customers to Oracle database using ODBC. Used Crystal Reports. Administered the database. Performance testing and tuning. confidential Developed software for Emergency Medical System in VISUAL BASIC and MS ACCESS in Windows 3.11 Windows 95 and Windows NT. Created reports using Crystal Reports. Was involved in customer phone support. Performed integration of product on customer site. confidential Developed software for sales analysis for wholesale business in MS ACCESS and VISUAL BASIC. Created reports using Crystal Reports. confidential Developed business software with GUI for hospitals and doctor s offices. These systems are based on IBM PC and AST. Operating systems MS DOS and PenPoint MS Windows. Programming in C MS ACCESS and VISUAL BASIC confidential Developed software for the real time systems for the automated material handling on VAX . Programming was performed in C and FORTRAN in VAX/VMS environment with ORACLE DBMS using Pro C and Pro Fortran. Control systems give the ability to automate material handling operations real time reporting of inventory availability inventory management ORACLE Corporation class course Oracle Database Administration Administering Microsoft Windows - based network class ORACLE Corporation class course Oracle Performance Tuning ORACLE Corporation class course Oracle Developer Forms Python development using Django framework