SUMMARY:

• 15 years of experience in IT with 11 years experience in Data Modeling(LDM,PDM), Database Design, Development and Implementation of Database Systems using Relational Database Systems, Oracle 8i/9i/10g/11g with very good analytic skills. Also I have 6 years of Data Warehouse Experience.
• Have domain experience in Health Care Application for the Medicare/Medicaid Managed Care Industry, Pharmacy Application, Stock Trading Application, Insurance Industry and RFID Tracking.
• Experience in RDBMS, Star and Snowflakes Schema design
• Experience in setting up Golden Gate Database to Database Replication with Change Data Capture.
• Experience in the design of ODS and Datawarehouse tables using Star and Snowflakes methodology.
• Experience in loading CDC records to ODS and also loading to DW from ODS.
• Experience in building tables, writing Stored Procudures using T - SQL in SQL Server 2012
• Experience in writing triggers and procedures/functions using Informix 4GL
• Experience in writing batch programs using and Pro*C
• Experience in writing complex SQLs, triggers and procedures using PL/SQL.
• Design, code and implement database monitoring on Unix Platform using shell scripts.
• Oracle Database expertise involves setup, configuration, performance tuning, upgrading, patching and monitoring of multiple versions of Oracle Database.
• Also experience in Oracle Advanced Replication (Multi-master configuration).
• Database experience with architecture, administration & Production support and Performance.
• Experience in 24/7 on call support for Production Database.
• Implementation of a complete Hot/Cold Backup solution.
• Participate in data sourcing, extract data investigation process, work with teams to develop PL/SQL, code to extract, clean and sort data for flat file generation, code SQL*Loader control files to load data using shell script.
• Oracle Database tuning for long running concurrent jobs using Stats pack, TKPROF, etc.
• Expertise in Space monitoring, Functions, Procedures, Triggers & Packages, and Object Management.
• Experience in Installing Weblogic server and Jrun Server in the development, QA & Production Servers.
• Experience in writing Reports using Jreport, Batch Program using Java/Perl/Unix Shell Scripting to update the data from one application database to another application database and writing the Batch program to send mail-using javamail.
• Extensively worked on documenting and developing technical and function requirements for end-users and developers, by gather requirements.
• Worked on most of the phases of the Software Development Life Cycle which includes preparing BRD, Functional Doc, Technical Doc and UAT sign-off.
• Traveled to Hong Kong, United Kingdom & United States to installing the servers and to assist in the UAT while working in Singapore
• I am a quick learner and have excellent communication and interpersonal skills.

SOFTWARE/HARDWARE:

Oracle 8i/9i/10g, SQL*LOADER, EXPORT/IMPORT utility, OEM, TOAD, Erwin, UNIX (Sun Solaris, HP-UX, Windows (95, 98, NT, 2000, Advanced Server), svrmgrl, SQL*PLUS, PL/SQL, Net 8,STATSPACK, Explain Plan, Pro *C, Teradata, Shell Scripts, Perl 5.6.1, BASIC, Pascal, Fortran, C, Java, J2ee, JSP, Weblogic 5.1, Jrun Server, Informix 5.01, Informix 4GL,ESQL/C, Jreport 5.0, HP-UX, SOLARIS 5.6, SCO UNIX, Informatica 9.1(Course completed), InformaticaCloud(Hands-on), VisualStudio 2012, SQLServer 2008/2012, SSIS,SSAS, SSRS, PowerBI 2.45

EXPERIENCE:

Confidential

Environment: Oracle 12c, pl/sql, Automic(UC4) scheduler.

Database Architect/Developer

Responsibilities:

• Working on developing Church Management Software for Churches.
• Worked on Data Mapping from various sources
• Worked on Data Modeling & Designed tables for the Church Management Software and wrote procedures for .Net application to call and store and manipulate the data in the database.
• Helped Frontend developers with writing SQLs for reports.
• Loading Initial Data using SQL Import Wizard 2016.

Environment: VisualStudio 2012, .Net 4, 4.6, C# & SQL Server 2008/2012

Confidential, Fort Worth, TX

ETL/Oracle Developer

Responsibilities:

• Review Data Mapping Document with Data Analysts
• Involved in the design of ODS and Datawarehouse tables using Star and Snowflakes methodology.
• Design and Implement the ETL process with auto load process of loading CDC using PL/SQL, Shell Scripting.
• My day today work includes coordinating with the offshore team in India and Philippines, reviewing and merging codes.
• Design and Develop BI reports using MicroStrategy.
• Helped to upgrade Server and Reports from Microstrategy 9.2 to Microstrategy 9.3.1
• Developed Customer Datafeed scripts using perl/shell.
• Implemented GoldenGate CDC schedules.
• Extensively used TOAD, ERWin for drawing ER diagrams for database development and maintenance activities.

Environment: Linux,Oracle 11g, PL/SQL, Golden Gate, MicroStrategy 9.2, 9.3.1

Confidential, Campbell, CA

Sr.Database Developer

Responsibilities:

• In Confidential, I was involved in developing automation script to upgrade Oracle database from 10g to 11g. This automation is written using Ant script so that it can be run both in Unix and Windows environment. In this project, I have also written Batch Files and Shell scripts which calls the ant script.
• Done extensive testing of the migration in Win2003/2008,Linux using VMware.
• Also I mapped the data and designed the tables for Array Performance module in Storage Console product.
• In this project I was mainly working with the data collection team and Product Manager to map the performance data of storage arrays to be collected to store in the database for reporting purpose.
• The performance data is collected in a periodic interval and stored in the database as both raw and aggregated format to analyze the performance of the arrays. Complex views and procedures were written with tuned SQLs to present the data in UI reporting.
• Also written Oracle batch jobs to purge the metadata based on the retention period.

Environment: Win2003,Win2008,Linux,Oracle 10g/11g, Apache Tomcat

Confidential, Santa Clara, CA

Senior Database Developer

Responsibilities:

• MMC20/20 has outsourced to IJS to develop the Health Care Application for the Medicare/Medicaid Managed Care Industry.
• The application has several modules which include Enrollment Application, Member Management, Payment Tracking, CMS Submission, Member Letter Generation, Import/Export of Transaction Reply Codes, Reporting etc.
• I work very closely with the Functional Consultants to understand the requirements and enhancing the product. My daily work involves design of database tables, writing pl/sql procedures, packages and triggers and also working with UI developers to make sure the SQLs used are well tuned and converting the complex business logics to package/procedure/trigger.

Environment: Oracle 9i/10g, Oracle JDeveloper, Oracle WebServer, Java

Confidential, San Mateo, CA

Senior ETL Developer

Responsibilities:

• Was working closely with Account Managers to understand the requirements and Setting up the workflows to handle the import files & custom scripts.
• My daily work involves uploading the flat files to the database using SQLLoader/External Table and processes the data to store in the custom tables using PL/SQL, Java, Perl and Shell Scripts and then importing into database using Import Utility developed by Digital Impact.

Environment: Oracle 9i/10g, Java, Perl, Unix, Shell Scripting

Confidential, San Jose, CA

Senior ETL Developer

Responsibilities:

• Was working very closely with the IT Analysts and Business Analysts, to understand the requirements and generate various metrics on Oracle Service Contracts and Oracle Install Base.
• Responsible for writing Reports to generate metrics from Installed Base and Service Agreement.
• Responsible for maintaining, writing reports using PL/SQL to generate different kind of metrics from Installed Base, Service Contracts, Returns Material Authorization and Quoting.
• Lead in performance tuning Installed Base report that scans through more than 200 million records to generate the metrics. Using Perl Script to run the report in multi-threading.
• Participate in data sourcing, extract data investigation process, work with teams to develop PL/SQL, code to extract, clean and sort data for flat file generation, code SQL*Loader control files to load data. Extract data using export utility. Setting up the import data using Oracle import utility and SQL*Loader for the daily/weekly/monthly uploads.
• Applications 11i and Database tuning using HINTS, EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE etc.

Environment: Oracle 11i, Service Contracts, Install Base Oracle 8.1.7, toad, PL/SQL, sql loader, Win XP, HP-UX

Confidential

Development Oracle DBA

Responsibilities:

• Responsible for creating and maintaining development and test Oracle databases servers, WebLogic Servers and Jrun Servers.
• Responsible for setting up the demo servers.
• Responsible for user and privilege management in Oracle.
• Experience in 24/7 on call support for Production Database.
• Responsible for definition and management of schemas and objects and monitoring, tuning and troubleshooting of Oracle databases.
• Extensively used TOAD, ERWin, Visio for schema comparison, drawing ER diagrams for database development and maintenance activities.
• Responsible for coding stored procedures, functions and triggers and other scripts based on functionality of the domain using PL/SQL.
• Create database links between production databases.
• Migrating tables and indexes to different tablespaces.
• Experience in partitioning and clustering.
• Experience in writing Unix shell scripts to automate batch jobs and Oracle Backups.
• Uploading the Uni-Code files to the database using SQLLoader and to process the data to store in the appropriate tables using PL/SQL and Shell Scripts.
• Participate in data sourcing, extract data investigation process, work with teams to develop PL/SQL, code to extract, clean and sort data for flat file generation, code SQL*Loader control files to load data.
• Extract data using export utility.
• Import data using import utility and SQL*Loader.
• Refresh development and test database with data from the production databases.
• Creating and maintaining Oracle Materialized views/snapshots in the production environment using Oracle Advanced Replication.
• Proactively monitor, preempt, diagnose and rectify database-related issues.
• Applications and Database tuning using HINTS, EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE etc.
• Provide a high degree of coordination between users, technical and corporate entities, ensuring effective data management and application implementation.
• Responsible for writing Reports using Jreport, Batch Program using Java to update the data from back-end application database to the front-end application database and writing the Batch program to send mail using java mail.
• Leading developers’ team on development and in testing.
• Configuring RFID readers and handhelds.
• Performing End-to-End testing with developers. I’ve been to Hong Kong and United Kingdom for the Implementation of the product and to give the User training and also to help in the User Acceptance Testing.

Environment: Weblogic Server 5.1, oracle 8.1.7, toad, PL/SQL, Visio, java, J2EE, jsp, sql loader, Win NT, RFID, Jreport 5.0

Confidential

Development Oracle DBA

Responsibilities:

• Responsible for creating and maintaining development and test Oracle and Informix databases in Solaris 5.6 and Win 2000.
• Responsible for setting up the demo servers.
• Experience in 24/7 on call support for Production Database.
• Responsible for user and privilege management in Oracle.
• Responsible for definition and management of schemas and objects in Oracle and Informix.
• Responsible for monitoring, tuning and troubleshooting of databases.
• Extensively used TOAD, ERWin, Visio for schema comparison, drawing ER diagrams for database development and maintenance activities.
• Creating and maintaining Oracle Materialized views/snapshots in the production environment using Oracle Advanced Replication.
• Responsible for coding stored procedures, functions and triggers and other scripts based on functionality of the domain using PL/SQL and Informix 4gl.
• Create database links between production databases.
• Migrate tables and indexes to different table spaces.
• Developed Unix shell scripts to automate batch jobs and Oracle Backups.
• Participate in data sourcing, extract data investigation process, work with teams to develop PL/SQL, code to extract, clean and sort data for flat file generation, code SQL*Loader control files to load data.
• Experience in writing APIs using Proc*C and ESQL-C programs.
• Applications tuning using HINTS, EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE etc.
• Extract data using export utility.
• Import data using import utility and SQL*Loader and Shell script.
• Refresh development and test database with data from the production databases.
• Experience in writing Unix shell scripts to automate batch jobs and Oracle Backups.
• Provide a high degree of coordination between users, technical and corporate entities, ensuring effective data management and application implementation.
• Leading the developer’s team on development and in testing.
• Helping on performing End-to-End testing & on customizations with developers and to give full support while User Acceptance Test.

Environment: Weblogic Server 5.1, oracle 8.1.7, toad, PL/SQL, Visio, java, J2EE, jsp, sql loader, Win NT, C++, C, Solaris 5.6

Confidential

Software Developer

Responsibilities:

• Interacting with end-users to collect requirements and Preparing Functional and Program specifications.
• Writing Informix 4gl programs and Unix shell scripts to automate batch jobs.
• Responsible for coding stored procedures, functions and triggers and other script based on functionality of the domain.
• Preparation of User Manual, Live Run support, testing the customizations and developed programs and bug fixing and getting the user acceptance sign off.

Environment: Solaris 5.6, Informix 5.01, Informix 4gl

Confidential

Software Developer

Responsibilities:

• Writing Informix 4gl programs and reports.
• Responsible for coding stored procedures, functions and triggers and other script based on functionality of the domain in Informix.
• Writing Unix shell scripts to automate batch jobs.
• Live Run support, testing the customizations and developed programs and bug fixing.

Environment: Solaris 5.6, Informix 5.01, Informix 4gl