SUMMARY:

• Around 20 years of experience in various cutting edge technologies, as a Very Senior Software Professional.
• A Highly Qualified Senior Software Engineer with a significant record of achievement in Software Industry. This includes System Study, Analysis, Design, Development, Testing and Deployment of Sophisticated Application/Mobile Software.

TECHNICAL SKILLS:

Skills: Java EE 6/7, ASP.NET 4.x, ASP.NET MVC 4.0,C# 4.x/5.x, PHP 5.3.x, JDK 1.6.x/1.7.x/1.8.x, Objective - C, Swift, Spring Framework MVC 4.x, Spring Boot Micro Services, Hibernate 4.x, React, Angular 4.x/2.x, NPM, NodeJS, Gulp, Grunt, WebPack, BootStrap 3.x, jQuery 3.x, Redux, Scala, Groovy, Maven 3.x, Gradle 1.9, Clojure, Cocoa, Android SDK, Ant 1.5, C++, VB, Velocity, Perl 5.6.1, Perl 5.8.7, Ruby, Python, PL/SQL, TSQL, Shell Scripting(Korn/Bash) and Perl DBI

RDBMS: Oracle 7.x, Oracle 8.0, Oracle 8.1.x, Oracle 9.x, Oracle 10g, Oracle 11g, MSSQL Server, 2005/2008 and MySQL 5.x, PostgreSQL 9.x, MongoDB 2.4.x, Redis and Informix Dynamic Server

IDE: Eclipse 4.3.x, STS 3.4.x, GGTS 3.x, NetBeans 6.x/7.x, Visual Studio 2012, XCode 5.x/6.x and JDeveloper 3.1

Operating Systems: Windows 2008R2, Windows NT 4.0, Windows 95, SCO UNIX V 5.0.2, Sun Solaris 2.7, Linux 2.4.6, Linux Mint, Debian 6.x, Digital Unix 4.0, Windows Vista, Windows XP, Mavericks and MS-DOS

Web Servers: Apache 2.x

Software Configuration Tools: SubVersion, Git, Visual Source Safe and CVS

Application Server: IIS 7.x, Tomcat 6.x /7.x/8.x, Jetty 8.x/9.x, Glass Fish 3.x/4.x, Wild Fly 8.x/9/x/10.x, JBoss 7.x, Web Logic Server 6.x/12c and Oracle 9iAS

Data Modeling Tools: ERWIN, Oracle Designer 10.x

PROFESSIONAL EXPERIENCE:

Confidential

Primary Architect

Responsibilities:

• Creating JSF Views(xhtml), AJAXifying JSF Pages, Managed Beans(Various Scopes, Request, Session, Conversation Scope and Application Scope), Custom Components, Custom Annotations, Custom Validators, Custom Converters, Custom Renderers, Servlets(Controllers), Using MVC JavaScript Framework(Controller, Services, Model) for more Responsive GUI(Separate UI from Server), Web Controllers, REST Controllers, Web Service Components, Service Components, Repository Components, Web Socket Controllers, Enterprise Java Beans(Stateful, Stateless and Singleton), Message Driven POJOs, P2P Messaging, Publish/Subscribe Messaging, Message Driven Beans, Spring WebFlow components, pure Java Configuration Classes(Some Mixed), Chart Components, Custom Annotations, POJOs, Aspects, Domain Objects(Entity Models), Spring Security Components and bunch of other keystone utility packages.
• Some of these Webapps(Java EE/Spring Framework), were deployed on the cloud(PaaS), for faster scaling, wide choice of services for the developers, and inherent performance benefits, for the end users.
• Usage of Patterns(Gang of four), J2EE Patterns(Front Controller and others), CDI, AOP, JPA, JTA, JSF, JMS, IOC and DI, Auto-wiring, Injecting, TDD, layering and re-factoring for writing elegant code(Eliminating redundancy, Restructuring, Re-layering, Modularizing, Maintaining Strict Coding Standards, reducing the clutter, removing bad code smells, and reducing errors).
• The architecture used for all these Modern Web applications, was MVC. Working Knowledge of Enterprise Integration Patterns.
• Created several mobile(IOS and Android) apps(Hybrid as well as Native) . Some of these IOS Mobile Apps were sold.
• Since I am working on Multiple Projects, using other competing(peer) technologies, like ASP.NET and PHP/MYSQL(ASP.NET 4.x, ASP.NET MVC 4.x and LAMP) projects, was part of my job.

Environment: Java EE 6/7, UML, Java EE Patterns, GOF, Spring Framework MVC 4.0, Spring Security, Spring WebFlow, Spring Mobile, Spring-WS, Spring-Hateoas, Spring Data JPA, Grails, Groovy, Scala, Kotlin, JAX-RS 2.0, JAX-WS, Objective-C, Swift, Cordova 3.4.x, Cocoa, ROR, Python, Ruby, Flask, Sinatra, Bottle, Spring Integration, RESTful Web Services, CloudFoundry, Heroku, CloudBees, AWS, JSF 2.2.x, JSF Component Library, Prime Faces 6.0, Join Faces, Butter Faces, JSP 2.x, EJB 3.x, Servlets 2.5.x/3.1.x, JPA, IOC, DI, AOP, SOAP, SOA, REST, JSTL, JSON, JMS, Apache CXF, Apache-ActiveMQ, Apache-Camel, jQuery, jQuery UI, Angular JS 4.x/2.x, React/Redux, React-Native, Clojure, ClojureScript, Lein, Boot, Backbone JS, ExtJS, BootStrap 3.x, HTML5, CSS3, ThymeLeaf, Tiles, Hibernate 4.x,Maven 3.x, Gradle 2.x, NPM, NodeJS, Grunt, Gulp, Android SDK, GWT, Vaadin, Eclipse 4.3.x, STS 3.4.x, GGTS 3.x, JUnit, MockMvc, LAMP, Visual Studio 11.x,, IIS 7.x, SQL Server 2008, Debian 6.x, Windows Server 2008R2, IIS 7.x, PHP 5.3.x, C# 4.0/5/0, ASP.NET 4.x, Tomcat 6.x/7.x/8/x, OpenRedShift, Apache Http Server, Jetty 8.x, JBoss 7.x, Glass Fish 3.x/4.x, Wild Fly 8.x, Oracle Web Logic Server 10.x/12c, Oracle 10g/11.x, PostGreSQL 9.x, MongoDB 2.4.x, Redis and MySQL 5.x.

Confidential

Sole Architect

Responsibilities:

• I visualized several mid scale solutions, and brought them into fruition.
• Some of the developmental responsibilities(for Java EE projects), include creating JSPs(Acting as Views), servlets(As Controllers), beans(Acting as Models), components and bunch of utility packages.
• I was also involved with designing and developing them(ASP.NET 4.x, ASP.NET MVC 4.0, J2EE 5.x, Spring MVC and LAMP).

Environment: Java EE 5.0, IIS 6.x, Linux, Debian, Tomcat 5.x, Ubuntu, SQL Server 2005, Apache, MYSQL, Windows Server 2003, Oracle 9.x, PHP 5.x, ASP.NET 3.5, MYSQL 5.0 and C# 3.0

Confidential, Berkeley

Oracle DBA

Responsibilities:

• I was primarily involved with Installing, Upgrading and adding Patches to Oracle 10g and 9i Databases.
• Installing Enterprise Manager Grid Control and adding targets in the form of hosts and database instances (Manually) running on various hosts.
• Installing the Management Agents on hosts(which have database instances running on them) Creating RMAN Catalog and registering various databases to the catalog.
• Using RMAN for base and incremental backups(level 1 and level 2) and going over various scenarios of recovery using control file or the recovery catalog.
• Demonstrating Disaster Recovery and Creating a Physical Standby (data Guard Real Time or With a Lag) for high availability (Fail Over).
• Using FlashBack for Synching up the Database Instances(Standby and Primary). Creating several RMAN scripts for backups.

Environment: Oracle 10g (10.2.0.3), Oracle 9i (9.2.0.7) IBM AIX(64 bit) 5.3, Enterprise Grid Control 10.2.0.3 and RMAN.

Confidential, San Francisco

Sr. Database Developer

Responsibilities:

• I was primarily involved with Managing tables (Standard and Raw), indexes (Tree and Functional), constraints, views sequences, synonyms and stored program units.
• Creating Stored Program Units in the Functions, Triggers and procedures for implementing complex database intensive business rules as well as for BI extracts.
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• Heavily involved with the Physical Design of the Database.
• Performance Tuning of the Database(Informix), in the form of SQL Tuning, SPL Tuning, Memory Tuning and I O tuning Created DDL scripts and Stored Program Units for migrating the current product from version 1.x to 2.x Prototyped a solution for Migrating from IDS to Oracle.

Environment: Informix IDS 9.4.0 UC3 and FC5, SPL, Oracle 10g (10.2.0), Solaris 5.8, PL SQL, SQL Developer, DBAccess, AquaStudio, Bourne and Bash Shell Scripting and OEM.

Confidential

Sr. DataModeler Developer DBA

Responsibilities:

• I was primarily involved with Managing tables (HEAP, IOT and GTT), indexes (Btree and Functional), constraints, views and sequences.
• Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
• Enhancing the existing Stored Program Units to boost their performance ten fold using array processing and bulk binds. Created Bourne Shell scripts for automating tasks.
• Developed Perl scripts to simplify deployment of database scripts.
• Heavily involved with the Physical Design of the Database.
• Performance Tuning of the Database(Oracle 10g, 9i and 8i), in the form of SQL Tuning, PL SQL Tuning, Memory Tuning and I O tuning Using TKPROF, Explain Plan, Optimizer Hints, ADDM, AWR, DBMS Profiler and Stats Pack.

Environment: Oracle 10g (10.2.0), Oracle 9i (9.2.0.7), Oracle 8i, Red Hat Linux Kernel 2.4.8.1, Solaris, PL SQL, TOAD, Perl 5.8, Bourne Shell Scripting and OEM.

Confidential

Sr. DataModeler Developer DBA

Responsibilities:

• I was primarily involved with Logical and Physical Design of Claims Management System Managing tables, indexes, constraints, views and sequences.
• Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
• Created Bourne Shell scripts for automating tasks.
• Performance Tuning of the Database, in the form of SQL Tuning, Memory Tuning and I O tuning Using TKPROF, Explain Plan, Optimizer Hints, ADDM, AWR and Stats Pack. Performed Backups and Recoveries. Performed Installations and Upgrades.

Environment: Oracle 10g(10.1.3), Red Hat Linux Kernel 2.4.8.1, Oracle Designer 10g, PL SQL, JDeveloper 10g, RMAN, Bourne Shell Scripting and OEM.

Confidential, South San Francisco, CA

Sr. Data Modeler/Developer DBA

Responsibilities:

• I was primarily involved with Logical and Physical Design of Subscription Management System using ERD, DDT, Design Editor and RON.
• Administration of Oracle Designer using RAU. Managing tables, indexes, constraints, views and sequences.
• Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
• Created Bourne Shell scripts for automating tasks.
• Performance Tuning of the Database, in the form of SQL Tuning, Memory Tuning and IO tuning Using TKPROF, Explain Plan, Optimizer Hints, ADDM, AWR and Stats Pack.

Environment: Oracle 10g(10.1.3), Red Hat Linux Kernel 2.4.8.1, Oracle Designer 10g, PL SQL, JDeveloper 10g, Bourne Shell Scripting and OEM.

Confidential, South San Francisco CA

Sr. Database Engineer

Responsibilities:

• I was primarily involved with Managing tables, indexes, constraints, types, views, synonyms and sequences.
• Creating Aggregate Materialized Views for speeding up the response of SQL queries.
• Creating Stored Program Units in the Form of Packages, Functions, Triggers and procedures for implementing the complex database intensive business rules.
• Used DBMS OLAP, DBMS MVIEW for estimating the size of the Aggregate Materialized Views, determining the Capabilities of the Materialized Views and for Fast Refreshing the Aggregate Materialized Views. Created Bourne Shell scripts for automating tasks.
• Performance Tuning of the Database, in the form of SQL Tuning and Memory Tuning Using TKPROF, Explain Plan, Optimizer Hints and Stats Pack. Creating Perl Scripts using DBI for refreshing the aggregates materialized views and for generating Tab Delimited files.

Environment: Oracle 9i (9.2.0.6), Red Hat Linux Kernel 2.4.8.1, PL SQL, TOAD, Bourne Shell Scripting, Perl 5.8.7 and DBI.

Confidential, Irvine, CA

Oracle DBA/Developer

Responsibilities:

• I was primarily involved with Managing tables, indexes, constraints, types, views, object views, synonyms, sequences, locally managed tablespaces, datafiles, temp files, redo logs, archived redo logs, users, roles, assigning system and object privileges to roles and in turn assigning roles to the users and thereby securing the database.
• Creating Stored Program Units in the Form of Packages, Functions, Triggers and Procedures for implementing the database intensive business rules.
• Performing DBA Maintenance tasks in the form of adding datafiles to tablespaces, resizing the datafiles, increasing the size of redo log files, segregating the data, lob and the index tablespaces.
• Creating Backups (Compressed, Image Copy) using RMAN full and incremental, performing disaster recovery.
• Performing Tablespace, Datafile and Database Recoveries.
• Maintenance of Backups Using RMAN, namely deleting the expired and obsolete backups.
• Using the Scheduler for Automatic Tasks (Analyzing tables and the Data Dictionary).
• Created Korn Shell scripts for automating tasks. Performance Tuning the Database namely memory tuning, I O tuning and SQL Tuning. Using SQL Loader for populating static tables and fact tables from CSV Files. Dynamically generating SQL scripts(Merge) Creating the Database using DBCA. Cloning the Database.
• Performing table-level, user-level exports using Data Pump. Used Designer for generating the DDL Scripts, for creating the schemas.

Environment: Oracle 10g (10.1.0.4), Red Hat Linux Kernel 2.4.8.1, PL SQL, TOAD, Designer, SQL*Loader, Enterprise Manager

Confidential, Minneapolis

Sr. Oracle Developer

Responsibilities:

• I was primarily involved with Creating stored programs in the form of PL SQL Packages, Procedures and Functions returning record sets, which in turn, are used for developing HTML reports using ASP. Creating Stored Packages for moving the data from the staging area tables to the Fact and the dimension tables.
• Creating Nested Aggregate Materialized Views (Three Levels). Utilizing Built in Oracle Packages like (UTL FILE, DBMS PIPE) for better debugging.
• Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables. Creating Korn Shell Scripts which act as a wrapper for various tasks like - for executing the SQL*Loader command lines, for refreshing the materialized views and for updating the Fact and the dimension tables with the data from the Staging Area Tables.
• Tuning the SQL Queries for better performance (The size of database was 10 Terabytes). Partitioning the Fact Tables and aggregate materialized views for enhanced Performance.
• Tuning various database instance parameters for improving the performance of this DSS.

Environment: Oracle 9.2.0.4, Solaris 5.6, PL SQL, JDeveloper, SQL*Loader, Korn Shell Scripting and ERWIN

Confidential, Falls Church, VA

Sr. Developer

Responsibilities:

• Developed Packaged Stored Procedures for Testing the Transferred Bulk Load Data Using Set Operators and Bulk Collections.
• Developed Packaged Stored Procedures for Transferring the Difference of Static Table Data from the Independent Databases at Various Sites to the Consolidated Database in a Efficient Manner. Developed Packaged Stored Procedures for Transferring the CLOB data from various sites to the Consolidated Database.
• Performed SQL Query Tuning using TKProf and SQL Trace to improve performance. Streamlined and tuned the Consolidated Integrated Database for a better throughput.
• Created Functional indexes, BitMapped Indexes, Domain Indexes and BTree Indexes to improve performance.
• Developed Complex Reports(Master-Detail, Matrix and Columnar) using Reports 9i for Presenting the Data.
• Developed Complex Forms, Customized Forms for Data Collection using Forms 9i.
• Created Simple, Join and Aggregated Materialized Views in DSS for Replicating an OLTP and using the concept of Query Rewrite to get better response time of Aggregate Queries Created Packaged Procedures for Refreshing the Materialized Views and for setting up Cron Jobs using DBMS JOB and DMBS MVIEW Used Optmizer Hints to Control the Execution Plan of SQL Queries Used Discoverer to Create Business Areas for Business Intelligence Reports Developed DAO using Java and JDBC for transferring Data from Large Static Tables from Databases at various Sites to the Consolidated Database in an Efficient Manner. Used concept of external tables for migrating data from non-Oracle Databases to an Oracle Database through flat files(Fixed Record Length as well as CSV).
• Developed Tests to Validate the Data in External Table using UTL FILE Developed TestCases Using JUnit and DBUnit to test the above mentioned task. Developed a Servlet Filter.
• Demonstrated the use of Java stored procedures, for implementing database intensive logic, allowing portability across several database vendors.
• Demonstrated the Use of SQLJ as a standard way of embedding static SQL statements in Java programs, similar to how Pro*C allows you to embed static SQL statements in C.
• Assisted in Implementing Business Intelligence Using Oracle Financials. Familiar with the AP and GL Schemas in Oracle Financial Apps.

Environment: Oracle 9i Release 2(9.2.0.4), Windows 2000, TOAD 6, PL SQL, Oracle Developer 9i, Oracle 11i, JUnit, DBUnit, Eclipse 2.1, J2EE, Oracle9iAs, Ant 1.5.1, SQLJ

Confidential, Fremont

Sr. Developer

Responsibilities:

• I was primarily involved with visualizing its architecture, as well as designing and developing the product. Developed Servlets, JSPs and EJBs(Stateless and Stateful Session Beans)
• Servlets which act as Controllers. Developed Data Access Objects for abstracting Data Base Access
• Developed JSPs which act as the view. Used heirarchial Menus(Tree) for ease of navigation and presentation Developed EJBs which act as a Model
• Developed Packaged Stored Procedures for Database Migration Used XML Based Messaging to communicate between different tiers.
• Used JFreeChart for developing various kinds of Charts for Benchmarking, Correlation and Time trend These above mentioned charts were used for Statistical Analysis.
• Developed Scatter Plots using JFreeChart

Environment: J2EE, Java, Javascript, WebLogic 5.1, Oracle 9i, Linux, Windows 2000, TOAD 6, PL SQL and JFreeChart 0.98

Confidential, NJ

Sr. Developer

Responsibilities:

• Created Korn Shell scripts and AWK scripts for validating the data files (namely customer accounts, Plans, vehicles, Trip History, Transaction History and Toll) as well as the control files (which basically have totals and count of records in the data file). Created Korn Shell scripts for compressing and encrypting the image files.
• Created Perl Program for encrypting the Log files using PGP.
• Assisted in creating Perl scripts for generating data files (Fixed Record Length) from the database using Perl DBI and Oraperl.
• Modified Stored Procedures and Stored Packaged Procedures.
• Developed Java Classes to execute a stored Procedures in Database using JDBC.
• The data parameters, which are passed to the stored procedures, were read from a data file.
• Designed and developed Price Yield and Analytics calculators for a fixed income securities trading system for banks.
• Used Perl Scripts for parsing invoice text files and creating files with fixed length records and validating the information in the invoices against the Database.
• Used Perl Scripts to generate MIS reports from the Database. Modified C++ programs which access database (for performing DML) using OTL (Oracle Template Library) OCI Libraries.

Environment: J2EE, JDBC, Java, C++, Oracle 9i, Sun Solaris 2.6, Digital Unix, Windows 2000, TOAD 6, PGP, PL SQL, Pro*C C++, OTL, Perl 5.6.1, Fixed Income Securities, JRun, Perl DBI,Oraperl, CVS, Korn Shell, AWK and sed