SKILL

• Skills Highlight: 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 8.1, 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

• ETL Project Customer Management in Medical Facilities. 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

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