TECHNICAL SKILLS:

Specialty Skills: UML, Object - oriented analysis and design, Python development using Django framework. ORACLE Data Guard, ETL Design and Coding skills. Informatica tools

Products: C#, VB.NET, JAVA, SQL Server, T-SQL, MS ACCESS, MS Excel, VBScript, Java script

Operating Systems: Windows 10, Windows XP, UNIX, Linux

Oracle Products: ORACLE 12C, ORACLE 11G, ORACLE 10G, Toad, SQL Plus, RMAN, PL/SQL, Oracle Forms 6i, Oracle Discoverer, Oracle Reports 6i, Jdeveloper, Oracle Data Integrator 12c

Management/Leadership Skills: Project Leader

PROJECT EXPERIENCE:

Confidential

Responsibilities:

• Facilities located across the US. Task was to split up the patient’s information based on the county and load them into corresponding county tables.
• There are several source tables for each facility. The project was developed using Oracle Data Integrator 12c. Created PL/SQL procedures.
• Development of VBA programs for MS Access database to house provider records of the county
• Development of text file parser using Python
• Developed Telecommunications rating system using Oracle PL/SQL
• Query performance tuning using SQL Tuning Advisor and SQL Access Advisor packages

Confidential

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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
• Working with ODBC on Sun Solaris Unix platform, Intersolve ODBC ORACLE driver

Confidential

Team manager

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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.