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 in Software Industry. This includes System Study, Analysis, Design, Development, Testing and Deployment of Sophisticated Application/Mobile Software.

TECHNICAL SKILLS:

Language: 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:

• Since these are mid-size projects, I was actively involved in designing, coding, testing and other subsequent critical stages(for instance deployment) as well.
• Some of those responsibilities(for Java EE/Spring Framework projects) include creating JSPs(Acting as Views), 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

Architect

Responsibilities:

• 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

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:

• 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) Developed 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

Confidential, Redwood City, CA

Application Developer

Responsibilities:

• Creating packages, stored procedures and stored functions for implementing database intensive logic as well as for dynamically generating SQL queries. Developed report definition files (RDF) for presenting data in an intelligent way. Namely Matrix, Tabular and Character Mode Reports. Used Model 2 architecture for developing web application using struts controller. Creation of velocity macros for developing web user interfaces for the view part. Assisted in developing servlets acting as a controller to display various types of reports. Developed Java class with static methods as well as singleton class for implementing business logic.
• Assisted in enhancing an ETL process using Java, Perl, Perl DBI, Bourne Shell, SQL PLUS and SQL Loader. This extract program basically takes data from an OLTP environment and populates the DSS at regular intervals. Was involved in database administration activities like creating table spaces, creating tables, creating indexes, creating synonyms and creating views. Developed Ant scripts for automating tasks and for creating makefiles, which are platform independent. Used Perl for automating report generation. Familiar with Oracle Financials(GL AP PO) schema Transferring balances from GL to Spendcap(Financial Analyzer) and adding dimension values in Spendcap. Transferring exchange rates from GL to Spendcap. Transferring currency, hierarchies, calendar and segment values from GL to Spendcap. The frequency of transfers is after each accounting period. Used CVS for version control.

Environment: Oracle 8.1.6, Linux, Windows 2000, Tomcat, Apache, TOAD 6, Reports 6i, Perl 5.6.1, Perl DBI, Oraperl, PL SQL, JDBC, JDK 1.3, J2EE, Servlets, Velocity 1.2, Struts, UML, JavaScript, CVS, ERWIN, Oracle 11i(GL), XML, XSL, JAXP, XSLT and Ant 1.5

Confidential, Maryland

Developer/Architect

Responsibilities:

• Creation of JSPs Web User Interface, creation of servlets acting as a controller, creation of stateless session bean for fetching read only data that is often used by the clients. The architecture used for this web application was MVC. Created stateful session beans for storing the client session related information across method invocations
• Used stateful session beans for verifying the provider data as well as the client data. Created Entity Beans for Persisting Provider Information. Used Entity Beans for Persisting Client Information. Deployed EJBs. Deployed Servlets and JSPs. Creating Packages, Stored Procedures, Stored Functions and Database Triggers for implementing database intensive logic. Involved in preparing Use Cases, Activity Diagrams, Class Diagrams and Sequence Diagrams. Designing the application architecture Used Front Controller, Business Delegate, Service Locator, Session Facade, Singleton, Page - by-Page Iterator, Proxy and Value ObjectPatterns for designing the provider subsystem

Environment: Oracle 8.1.5 Sun Solaris 2.6 UNIX, ERWIN 3.5.2, TOAD 6, PL SQL, JDBC, J2EE, EJB 1.1, Servlets 2.2, JSP 1.1, JavaScript, XML, UltraEdit 1.1, Forms 6i, Reports 3.0, Struts, JRun, Rational Rose 2001A, RUP, Rational Clear Case, Web Logic 6.x and Enterprise Manager

Confidential, San Mateo CA

Analyst Programmer

Responsibilities:

• Populating the database, exporting and importing data, and creation of packages, database triggers, standalone-stored procedures, java stored procedures for implementing the business logic and database intensive logic. And Fundamental DBA tasks. Using korn shell scripts to automate tasks. Creation of screens for administration purpose.
• These screens where created using Java Swing. Used JDeveloper 3.0 for creating JSP as well as servlets and for debugging servlets. Creation of JSPs Web User Interface and creation of Servlets acting as a controller, and developing a transaction server. The architecture used for the web application was MVC. Creation of stateful session beans for verifying the Credit Card Information and for storing the client Session data across method invocations. Creation of Entity Beans for Persisting Credit Card Information and Customer Information. Created stateless session beans for retrieving read only data sets frequently used by clients.
• Used stateless session bean for doing generic tasks. Created stateful Session bean to manage the work-flow of several other enterprise beans. Deployed EJBs. Deployed Servlets and JSPs. Involved with the performance tuning of the database. Used Visual Source Safe for version control. Used XSLT and XSL for transforming XML Documents to HTML

Environment: Oracle 8.1.5 Sun Solaris 2.6 UNIX, Korn Shell Scripting, Perl 4.004, ERWIN 3.5.2, WebLogic 5.1, Designer 2000, TOAD 6, Visual Source Safe, SQL Navigator, iPlanet Web Server 4.1, JDeveloper 3.0,JAD, Dreamweaver 4.0, PL SQL, JDBC, JAVA, Servlets, JSP, JavaScript, XML, XSL, JAXP, XSLT, EJB, CrystalReports, Borland Inprise Server, OAS PL SQL Cartridge, DB2 UDB, MQ Series, Performance Tuning and Enterprise Manager OEM

Confidential, San Francisco, CA

Programmer Analyst

Responsibilities:

• This was a part of ETL Process which I was involved in. Created SQL Loader control files. Used server utility SQL *Loader Direct Load, Parallel Option for populating the temporary tables from the flat files. Created packages as well as stored procedures for further refining the data and for enforcing the business logic. Developed a package for handing errors. Used performance diagnostic tools like tkprof and explain plan for SQL Tuning. Involved with memory tuning and I O tuning Environment: Oracle 8.0.5.1 Win NT 4.0, SQL*Loader, PL SQL, TOAD and Enterprise Manager Embedded Objects, Fremont, CA
• Programmer Analyst Project Real Time Application for Hand Held Devices Designed and developed an Oracle database for a real-time application for Hand Held devices. Linked the front-end Java-based GUI to the database using JDBC - this was done through interfaces: Driver Manager interface, Connection interface, Prepared Statement interface, Statement interface, and ResultSet interface. This application supports DML operations. Created an abstract class in Java to support these DML operations.

Environment: JBuilder 3, Oracle 8i, JDBC API, Pro *C

Confidential, CT

Programmer Analyst

• Created database triggers, stored procedures, stored functions and packages for loading the main tables and the tables present in the tester database with the data from the production database and the staging area. This was part of the ETL Process. Creation of korn shell scripts for automating tasks. I also performed the migration of Warehouse stored procedures and migration of Warehouse procedures using Synonyms. Furthermore, used performance diagnostic tools like tkproff, SQL Trace to accurately assess the efficiency of SQL statements.

Environment: Oracle 7.3.5.5.0 64- bit version, Digital UNIX V4.0D, SQL *Plus, Korn Shell Script, ETL, Impromptu and Oracle Enterprise Manager, ERWIN 3.0 and Designer 2000

Confidential

Programmer Analyst

Responsibilities:

• Generation of MIS and statutory reports using Reports 3.0. Creation of interactive and intelligent screens to facilitate data-entry retrieval, creation of database and storage of data. Created applets to display the current prices of the products. Tested the application. Environment: Forms 5.0, Reports, Oracle 7.3 8.0, Designer 2000, Oracle, Web Server PL SQL Java cartridge, JDK 1.1.5, JDBC Thin, Win NT Project 2:Statistical Process Control Information System (Client: Annapurna Electronics) This software package is developed to cater to the requirements of process control Industry to analyze and evaluate, indicate the process parameters.
• Instrumental in preparation of the Strategy document, SRS, ensuring adherence to the project plan, performing data analysis and system analysis, the above-mentioned task involves defining the major functions, defining the entities, establishing relationship between the entities, function mapping, module categorization, module data usage and module arguments. The data flow diagrams, function hierarchy diagrams and process flow diagrams were prepared. Also, was involved with the data modeling, database design, designing the modules, creation of database roles, assigning the system privileges as well as table privileges to the roles, creation of the menu module, setting the GUI standards, setting coding standards, testing standards, enforcing security through the menu module and above all motivating the team members.

Environment: Dev 2000, Oracle 7.3, Designer 2000, Windows NT Project 3:

Confidential

Electromagnetic Designer

Responsibilities:

• Instrumental in preparing the Strategy document, SRS, data analysis and system analysis. This included defining the functions and entities, function mapping and usage, module categorization and data usage. Developed data flow diagrams, function hierarchy diagrams and process flow diagrams. I was also involved with the database design, data modeling, designing the modules, creation of roles, assigning system privileges as well as table privileges to the roles, creation of the menu module, setting GUI, coding and reporting standards, enforcing testing standards and enforcing security through the menu module.

Environment: Dev 2000, Oracle 7.3, Designer 2000, Windows NT

Confidential

Programmer Analyst

Responsibilities:

• I was part of the entire project life cycle - from analysis to implementation. I was instrumental in preparation of the Strategy document, SRS, data and system analysis. This included defining the entities along with the attributes, relationship between the entities, function mapping and usage, module categorization, and drawing the data flow diagrams and the process flow diagrams.
• I was involved with the designing of the window-style screens and improving the functionality using triggers and preparing the project documentation. This project has been implemented. In addition to this, I was involved with the database design, data modeling, designing the modules, creation of database roles, assigning the system privileges as well as table privileges to the roles, creation of the menu module, setting the GUI standards, setting coding standards, testing standards and enforcing security through the menu module.

Environment: Dev 2000, Designer 2000 and Oracle 7.3, Win95, Sco UNIX, Pro*C, Shell Scripting

Confidential

Programmer Analyst

Responsibilities:

• Work involved defining the data objects along with its attributes, establishing relationships between objects and drawing Entity relationship diagrams. I was instrumental in creating and populating the database, designing the data entry screens and customizing the application through triggers. Project 2: Instruments Information
• System this system keeps track of all the out going instruments, which are serviced, and the incoming instruments, which have to be serviced. Involved in the development of Window-style applications, creating standard menus and toolbars, integrating the project with the existing database and writing the user and system documentation. Introduced the concept of updating the context Information and generating the new values from the sequence generator etc in database triggers previously adopted a process of inserting the context information through coding itself.

Environment: Dev 2000, Designer 2000, Oracle 7.3, Windows NT, Pro*C