SUMMARY:

• Over 18 years of IT Experience. Experience in analysis & design, systems architectural design, presentation, process interfaces design, process data flow design, and system impact analysis, Gap analysis, Feasibility analysis and design documentation and presentation.
• Experience in Financial, Pharmaceutical, Telecommunications, Manufacturing, and Non - Profit Industries.
• Oracle Database Administration, Installation and Upgrade of Database, Performance Tuning, Logical and Physical Design, Disk Space Management, Database Tuning, Security Management, Backup and Recovery Activities, managing the Object and System Privileges, implementation of OLTP/OLAP applications.
• Substantial Experience in automating the process through Shell scripting in UNIX (SUN SOLARIS /HP/Linux).
• Strong Database knowledge in Oracle 8i/9i/10g/11g, 12c, DB2, SQL Server, MySQL 5.7, MS-Access.
• Technical expertise in ETL tools Informatica, PL/SQL, SQL Loader
• Expertise in working with Star Schema, SnowFlake Schema, Cognos Impromptu, PowerPlay, Business Objects, PL/SQL, OLAP, Toad, Erwin and Shell Scripts.
• Expertise in Data warehouse/Datamart implementations including requirements gathering, dimensional modeling, Star Schema design and snowflake.
• Development experience in using HTML, XML, XSL, XSLT, DTD, XML Schema and related technologies.
• Worked in Development, Conversion, and Production support projects.
• Expertise in application development with full lifecycle experience of implementing large client/server Applications.
• Good problem solving ability in diverse software environment.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: UNIX (SUN SOLARIS / HP), Red Hat Linux 5/6, Windows NT, 2000, 2008, Windows 7, Windows 10

Hardware: IBM, HP- UNIX, SUN SPARC, Pentium PCs, Dell SAN

RDBMS: ORACLE 12c/11g/10g/ 9i / 8i, DB2, Informix 9.2, MySQL 5.7, SQL Server, MS-Access

ETL Tools: Informatica 9.6, 6.2, SQL Loader

Languages: C, Pro *C, Java, C++, Visual C++, Shell Scripts (Korn, Bourne), SQL, PL/SQLTransact SQL, Cobol, Pro *COBOL, JCL

Software Skills: UML, XML, XSL, XSLT, DTD, HTML, JavaScript, VB Script, Python

GUI: Forms 6i/4.5, Reports 6i/2.5, Teradata SQL Assistant, XML Spy

Tools: Erwin 3.5.2/4.0, Microsoft Visio, Toad 6.2, SQL Navigator, Crystal Reports, SQL Plus, SQL Loader, Cognos Impromptu, Cognos PowerPlay, Cognos IWR, Business Objects, Visual Interdev, Visual Source Safe 6.0, CVS, PVCS, Excelon Stylus 2.0, MS Visual Studio, FrontPage 2000.

PROFESSIONAL EXPERIENCE:

Confidential, DC

Oracle DBA/Analyst

Responsibilities:

• Migrated our Production/test/Development databases from Oracle 9i to Oracle 11g
• Migrated our SAS Oracle database from Oracle 10g to Oracle 11g
• Proactive monitoring of multiple database instances in WWF
• Involved in Database management, monitoring, performance tuning, backup and recovery of production database.
• Involved in setting up of standby databases for our Production databases in Disaster Recovery site.
• Involved in UNIX/Linux system admin activities like mounting new LUNS from SAN, creating new users, groups
• Created and Managed users, objects, roles and granted appropriate roles & privileges to different database users.
• Written complex SQL queries and PL/SQL procedures/packages to extract and process data from various source tables.
• Extensively used Unix shell scripting (KSH) to automate daily activities such as loading files into database using SQL loader, ftp files to or from remote servers, compression and decompression of files, executing SQL scripts, executing PL/SQL procedures, running jobs in parallel, job scheduling, spooling CSV files.
• Loaded fixed length and delimited flat files into database using SQL Loader.
• Created bit map indexes and b-tree indexes for fast retrieval of data.
• Analyzed time consuming SQL queries and tuned them to run in less time using Cost based optimizer hints, Explain plan.
• Pull data from SQL server tables and load into SAS Oracle database.
• Responsible for capacity planning for Production/Non-production databases.

Environment: ORACLE 9i/10g/11g/12c, MS SQL Server 2010, MS SQL Server 2014, MySQL 5.7, HPE-Vertica, Dell Compellent SAN, SQL PLUS, PL/SQL, SQL Loader, JAMS scheduler, DataPump, UNIX SHELL Scripting, Python, PL/SQL Developer, TOAD, SUN-Solaris 10, Red Hat Linux 5/6

Confidential, Virginia

Oracle DBA/ ETL Developer

Responsibilities:

• Involved in Database management, monitoring, performance tuning, backup and recovery of production database.
• Created and Managed users, objects, roles and granted appropriate roles & privileges to different database users.
• Written complex SQL queries and PL/SQL procedures/packages to extract and process data from various source tables of data warehouse.
• Extensively used Unix shell scripting (KSH) to automate daily activities such as loading files into database using SQL loader, ftp files to or from remote servers, compression and decompression of files, executing SQL scripts, executing PL/SQL procedures, running jobs in parallel, job scheduling, spooling CSV files.
• Extensively used analytic functions to calculate aggregations/averages of sales/revenue by region/submarket/price plan/accessories etc.
• Responsible for design of physical model of the data mart and created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Loaded fixed length and delimited flat files into database using SQL Loader.
• Created bit map indexes and b-tree indexes for fast retrieval of data.
• Analyzed time consuming SQL queries and tuned them to run in less time using Cost based optimizer hints, Explain plan.
• Developed procedures to load XML data into XDW Data warehouse Tables
• Written PL/SQL procedures to generate XML data file from Oracle Tables
• Created Materialized views and Materialized view Groups for the source tables

Environment: ORACLE 9i/10g, ORACLE XMLDB, XMLSPY, XML, XSLT, XSD, SQL PLUS, PL/SQL, SQL Loader, UNIX SHELL Scripting, TOAD, Erwin 4, HP 11.11, SUN-Solaris 8, Business Objects XI

Confidential, New York city

Oracle DBA / Sr. Oracle Developer

Responsibilities:

• Involved in Database management, monitoring, performance tuning, backup and recovery of production database.
• Created and Managed users, objects, roles and granted appropriate roles & privileges to different database users.
• Analysis, requirement gathering, documentation, business requirements, functional requirements, development, deploying and testing.
• Extensively used Unix shell scripting (KSH) to automate daily activities such as loading files into database using SQL loader, ftp files to or from remote servers, compression and decompression of files, executing SQL scripts, executing PL/SQL procedures.
• Used Informatica ETL to extract data from different Sources SQL Server, Oracle, and Flat Files into Oracle Global Repository Database.
• Used Informatica for complete ETL processes, static and non-static data were collected from Flat Files and processed / transformed in data staging area and moved to the Data warehouse.
• Designed and Developed Informatica mapping with various strategies.
• Designed and implemented the automation of monthly update processes for look-up/reference files using Oracle Packages.
• Developed the Oracle PL/SQL Stored Procedures, functions, Packages using XMLDB Packages and Procedures.
• Worked extensively on XMLDOM, XMLPARSER, XMLGEN, and XMLQUERY Packages.
• Developed Oracle JOBS for executing the Stored Packages, Java Stored Procedures.
• Created Tables, Views, Synonyms for ACROSTUDY, Developed Oracle database Triggers.
• Used XMLSPY for XML/XSL Validation, transformation of XML using XSL files.

Environment: Windows 2000 Server, UNIX Sun Solaris, IIS 5.0, Oracle 9i, Informatica 6.2, PowerCenter (Designer, Server Manager, Workflow Manager, Workflow Monitor, Repository Manager), XMLSPY 5, Microsoft VISIO, Microsoft Visual Source Safe, SQL Navigator 4.0, TOAD 7.4

Confidential, Chicago

ETL Developer

Responsibilities:

• Scheduling Informatica batch and stand alone session files for Mapping.
• Tuned the Transformations and Mapping in Informatica
• Wrote shell scripts for executing the PL/SQL Procedures and Functions and SQL Scripts.
• Wrote SQL LOADER Scripts to load the data from data files into the ODS staging Tables
• Involved in Developing the Tables, Views and Indexes
• Created views, which are used to load the data into Permanent Tables.
• Tuning of SQL Scripts, Analyzing the Tables
• Unit Test and Stress Test of the Converted Stored procedures and Scripts

Environment: HP/UX-11, Oracle 8.1.6, Oracle 8i, Informix 9.2, SQL Server 6.x, Informatica 4.7, PowerCenter, PowerMart, Toad 5.x, Erwin 3.5

Confidential, New York City

ETL Developer

Responsibilities:

• Wrote PL/SQL Stored Procedures and Functions.
• Core Informatica ETL developer for loading the Historical and Incremental Data into Dimension / Fact tables for 3 subject areas namely CASE, RMA, and DDTS
• Implemented an Operational Data Store (ODS) for generating web based reports. Data extraction was being done on an incremental basis.
• Wrote PL/SQL Stored Procedures and Functions.
• Wrote shell scripts for replicating the AMA database.
• Played a Major Role in automating backups by writing the UNIX (KORN) Shell Scripts and scheduling them.
• Coordination with oracle DBA for changes in Database objects such as Tables, Views and System performance.
• Scheduling of jobs through CA 7 Scheduler.

Environment: UNIX (Sun Solaris), Oracle 8i(SQL, PL/SQL), Shell Scripts (Korn), Cognos, Informatica ETL Tool, PowerMart 4.7, PowerCenter 4.7, CA-7 SCHEDULER, Toad 5.x

Confidential, Louisville, KY

Responsibilities:

• Written and modified CGI scripts in C, COBOL for populating the data in JSP and HTML pages.
• Involved in designing the database, database mining.
• Wrote PL/SQL Stored Procedures and Packages.
• Coordinated with Oracle DBA in designing the database, creating stored procedures and Packages.
• Written UNIX Shell scripts for automating backups.
• Wrote shell scripts for loading the database.
• Scheduling of jobs through Confidential Scheduler.

Environment: UNIX, C, Java, Oracle8.05 (SQL, PL/SQL), Oracle 8i, Shell Scripts (Korn), Confidential SCHEDULER

Confidential, Louisville, KY

Responsibilities:

• Changed COBOL Programs to meet client needs and to reduce the processing time.
• Written part of the module in Pro *C which had reduced the Processing time drastically.
• Written SQL and PL/SQL scripts for loading data into the DW tables.
• Written Confidential Schedules for running the Programs periodically.
• Written Shell scripts for executing the programs and for file maintenance.

Environment: UNIX, C, Oracle 8.0.5, SQL, PL/SQL, Pro *C, COBOL, Shell Scripts (Korn), Confidential Scheduler