Experience Summary

• Over 8 years of experience as Oracle DBA, PL/SQL and ETL developer in development and production environments.
• Experience in maintaining Oracle 11g RAC on Linux with ASM
• Experienced in SQL Server/Oracle data migration projects
• Experienced in SSIS ETL software, SSRS and SSAS
• Experienced in COZYROC SSIS plugin software for integrating in Microsoft CRM
• Experienced in Microsoft CRM, Microsoft CRM API's and , Experian QAS
• Ensured Oracle database systems operate efficiently and securely.
• Managed internal databases, from planning and testing stages through implementation and support.
• In-depth understanding of security and backup procedures to ensure database integrity.
• Background in developing backup and disaster recovery.
• Excellent Analytical and problem solving skills.
• Excellent knowledge in SQL Plus, SQL and PL/SQL programming and development.
• Experience with Sun/Solaris, RedHat/Fedora Linux, and Windows XP and Windows 2000 environments.
• Experienced in Informatica PowerCenter 8.1.1, PowerCenter Designer, PowerCenter Repository Manager, PowerCenter Workflow Manager, PowerCenter Workflow Monitor
• Experienced in SQL Server and MS Access databases
• Experienced in Oracle Data Integrator ODI ETL software, Oracle Data Quality
• Knowledge in ER Studio Data Architect software.
• Knowledge in Crystal Reports 2008 reporting software.
• Knowledge in Netezza Data Warehouse

Technical Skills

• Data Modelling Tools
• Job Schedulers
• Reporting Tools
• ETL Tools
• Languages
• Applications/Tools
• Operating Systems
• Databases:
• Below is a list of important hardware, software products, tools and methods that I have worked with.
• Oracle 9i, 10g, 11g, SQL Server 2005/2008 and Microsoft Access
• Windows 2000, Windows NT/XP, UNIX, Linux
• SQL Loader, SQL Plus, Filezilla, Toad for Oracle, ODBC, RMAN, Oracle Enterprise Manager, Oracle Net Configuration Assistant, Oracle Database Configuration Assistant, Migration Tools, Oracle Real Application Clusters RAC , Oracle Streams, Golden Gate Software
• SQL Server Management Studio, SQL Server configuration tools
• SQL, PL/SQL, RMAN Scripts, Windows Batch Scripts, Unix Shell Scripts
• Oracle Data Integrator 11g ODI
• SSIS, COZYROC
• Informatica PowerCenter 8.1.1
• Crystal Reports 2008, SSRS
• Control M, Autosys, Oracle Scheduler and SQL Agent
• ER Studio, Toad Data Modeller, Erwin

Professional Experience

Confidential

As an Oracle Application DBA

• Responsible for Maintaining Oracle 11g, Oracle 10g/9i Production, UAT and DEV data bases.
• Responsible for resolving Service Desk tickets, Work Orders and Change requests related to PROD, UAT and DEV databases using HP Service Manager 7 software.
• Creating and maintaining Oracle Database objects and Data Security
• Creating and maintaining Oracle users/roles
• Creating and maintaining Oracle Cron jobs for back up, restore, gathering statistics, rebuilding indexes and checking invalid Oracle objects.
• Responsible for Tuning SQL queries
• Responsible for monitoring total 250 Oracle PROD/TEST/UAT databases as a part of Oracle DBA group

Technologies:

Oracle 11g/10g/9i, Toad for Oracle, HP Service Manager 7, Oracle Enter Manager OEM Grid Control, SQL, PL/SQL, UNIX Shell Scripts.

Confidential

As an Oracle DBA and Talend ETL Developer

• Responsible for Maintaining Oracle 11g Mapping and Conversion databases
• Responsible for Mapping/Data Conversion database backups and restores
• Creating and maintaining Oracle Database objects and Data Security
• Creating and maintaining Oracle users/roles
• Loading and Refreshing Mapping database structures to make in sync with Source and Target databases
• Responsible for data mapping between NJ Benefits legacy database and Curam NJ-CASS database
• Responsible for Tuning data loading queries
• Proactively monitoring Oracle databases and provide solutions in timely manner for any issues arising

Technologies:

Oracle 11g, Toad for Oracle, SQL Developer, Talend Integration Suit Enterprise Edition, SVN, Curam Version 6.0 Social Enterprise Management, SQL, PL/SQL, UNIX Shell Scripts.

Confidential

As an ODI and SSIS ETL Senior Developer

• Responsible for data mapping between EFS database and ELIS CRM database
• Responsible for development of Oracle Data Integrator ODI interfaces, Packages, creating and maintaining data sources using ODI Topology manager.
• Responsible for creating and maintaining Oracle ODI Repositories for various environments.
• Responsible for writing Oracle Functions and Packages for supporting conversion process
• Responsible for performance improvements and trouble shooting for Oracle Conversion process.
• Responsible for developing SSIS Data Flows, Control Flows and Creating Packages
• Responsible for creating script components using Microsoft CRM API's for inserting records into CRM Entities. Worked on COZYROC SSIS plugin software for integrating Microsoft CRM.
• Responsible for creating script components for invoking Experian QAS address validation API's to validate various source addresses and contact information.
• Responsible for creating error and control reports for data conversion process using Microsoft SSRS.
• Responsible for creating data cleansing SQL scenarios
• Created custom Java Code for comparing data cleansing scenario reports between two different source data loads.
• Responsibilities are creating mapping documents for mapping source and target databases using custom mapping Excel macros. This project is for converting VPK program legacy data. It's about converting around 8 years of data to new ELIS Microsoft CRM system from 40 coalition databases. Responsibilities also include work with DBA's to creating table structures, column constraints, Oracle functions and PL/SQL routines. Also responsible for creating ODI models, interfaces and packages for loading target ELIS database and reporting tables. Apart from ODI responsibilities, I am also responsible for mentoring ODI to other team members.

Confidential

ETL Developer and Oracle DBA

• Responsible for maintaining Oracle 9i, Oracle 10g, 11g development database.
• Responsible for development of Oracle Data Integrator ODI interfaces, Packages, creating and maintaining data sources using ODI Topology manager.
• Responsible for creating and maintaining Oracle ODI Repositories for various environments.
• Responsible for development of SQL Query, PL/SQL package, procedure, function on Oracle 9i database
• Responsible for performance improvements and trouble shooting for Oracle 9i development database.
• Responsible for creating Oracle database users.
• Responsible for backup and restore of Oracle database using Oracle 9i DBCA
• Maintaining Oracle backup and restore RMAN scripts
• Maintaining Oracle Security procedures and methods.
• Implemented 3 node Oracle 11gR2 RAC setup on Linux Servers with ASM TAF.
• Responsibilities are creating ODI models, interfaces and packages for loading reporting data warehouse from various data sources, which includes SQL server and flat files. Implementing data quality operations ODQ like cleansing, formatting and checking various constraints before loading into final reporting warehouse, loading SCD tables.

Confidential

Oracle Database Administrator

• Responsible for Oracle 9i logical and physical database design, implementation and maintenance on Windows XP for Inventory Management and Customer Service applications.
• Responsible for migrating data from SQL Server 2005 to Oracle 9i.
• Created new databases and users: set up backups, export, and other monitoring scripts using RMAN and user managed.
• Implemented database refresh using full export for table level and full database de fragmentation, resulting in improved performance and effective space management.
• Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery
• Identify, recommend, and implement all new database technologies and Oracle license management.

Confidential

Oracle DBA

• Responsible for writing Oracle 9i SQL's and PL/SQL for Patient List, Patient Search, Patient Details application. Also responsible for testing the application.
• Responsible for creating new Oracle databases and maintaining them
• Responsible for RMAN Full/Incremental backup and recovery procedures.
• Responsible for Tuning the Oracle databases.