Platforms

Windows, Unix, Oracle, SQL Server, Oracle APEX,.Net, J2EE, Web, Microsoft Office

Database

Oracle 11g, SQL Server, MySQL, Microsoft Access

Languages

PL/SQL, SQL, Pro C, SQL Loader, VB6, C/C , JAVA, J2EE, JDBC, T-SQL, Shell Script, SQR, C .Net, VB.Net, HTML 5, JavaScript, PHS, Perl, ASP.Net

Tools

Oracle Apex 4.2, Oracle BI Publisher, Oracle Warehouse Builder, Oracle Forms, Oracle Reports, Oracle Designer, JDeveloper, Rational Rose, SQL Data Modeler, ERWIN

Toad, SQL Developer, PLSQL Developer, Eclipse, NetBeans, Visual Studio.Net

Visual SourceSafe, Team Foundation, QuickTestProfessional QTP

Adobe LiveCycle ES4, Process Designer, Form Designer

Frameworks

MVC, WPF, MVVM, PRISM, NinjaTrader, NinjaScript, MetaTrader, MQL4, IB TWS

Confidential

Database Developer

Skills Used:

Oracle 11g, PL/SQL, SAP-SD.

Accomplishments:

• Analyzed and enhanced Oracle stored procedures for warehouse management and labor management functionalities of a much larger enterprise level systems on Catalyst, SAP and Protracker platforms.
• Modified tables, views, packages to accommodate ongoing enhancement efforts for WMS. Improvised complex PL/SQL programs for functional accuracy and performance.
• Participated in requirement gathering and feasibility analysis.

Accomplishments:

• Analyzed and enhanced Process Management modules of Electronic Lab Notebook Digital Signature process during migration of Adobe LiveCycle infrastructure from ES2 to ES4.
• Used Adobe LiveCycle Workbench, Process Designer, Form Designer, Admin UI to design, develop and configure process models, forms, web services, trigger events.
• Designed and developed Oracle database tables and procedures and Web applications to manage distribution of security codes to ELN users, using PL/SQL, ASP4.Net, C
• Facilitated establishing network share access to user groups, applications and web services. Intensively tested and worked on troubleshooting the new ALC application with architecture team. Monitored ALC processes and resolved issues on daily basis to ensure smooth running of process flow. Analyzed and documented architecture and technical details of a Java application used to analyze biological experiments data conducted using robots.

Confidential

Sr.Software Engineer

Skills Used:

Oracle10g/11g, Oracle APEX 3.2/4.0, PL/SQL, Visual C .Net, AJAX, BI Publisher, LDAP, SQL Server, JAVA, JDBC, Oracle Text, Net Beans IDE, MS Access 2010

Accomplishments:

• Developed several web applications using Oracle Apex 3.2 and 4.0 containing data entry forms, online data processing, user authentication, web services, interactive reports and single page dynamic data presentation.
• Developed C .Net application to interface with Microsoft Outlook to extract contacts and appointments data and populate enterprise database.
• Worked on Office Automation using Microsoft Office Interop library to generate Excel and Word reports from Oracle data using C .Net.
• Worked on MS Access 2010 to generate multiple forms using VBA, for a customized survey application.
• Developed database driven web application in Oracle Apex to calculate infrastructure safety indexes and represent them graphically using Anychart JavaScript library.
• Used AJAX technology and related tools in APEX to develop user friendly web applications.
• Built Oracle PL/SQL packages and standalones to support APEX applications to store and retrieve images. Used advanced APEX features like Collections, Anychart and BI Publisher
• Developing a C application Visual studio and PRISM framework, to package and present multi-media presentation including audio, video, image, panorama, text, slideshow to clients. This involves several techniques for media display, assemble components, compile into package, unpacking and auto-play features.
• Worked JAVA and JDBC to process data files, update database and email reports. Used Net Beans IDE to develop Java classes to process XML data and update database.

Confidential

Sr. Oracle Developer

Skills Used: Oracle 11g, Oracle APEX 4.1, PL/SQL, HTML, jQuery, CSS, AJAX, Microsoft Excel

Accomplishments:

• Developed web application with Oracle Apex 4.1 for Finance Dept. users to upload and process billing detail files and generate summary reports.
• Designed complete relational data model to store and process billing details from several vendors and to transform from several format to unified target structure following standard ETL approach.
• Used BLOB processing routines to parse data elements and load tables, in lieu of external tables due to certain resource constraints.
• Developed an Excel macro utility to cleanup input files before loading into database.
• Coordinated with subject matter experts and end users to gather requirements and UI specifications. Demonstrated application to appropriate personnel. Completed knowledge transfer to appropriate technical support staff. Completed all technical documents for design, implementation and continued support of application.
• Facilitated migration of complete application and database from local environment to server environment.

Confidential

Sr. Databse Developer

Skills Used: Oracle 10g, PL/SQL, Oracle Forms, Pro C, XML, Unix

Accomplishments:

• Developed enhancements to loan processing system in conformation with RESPA mortgage regulations.
• Developed several Forms to implement RESPA reform requirements for 2010 using pl/sql libraries, object libraries and program units
• Developed interfaces in SQL Loader and PL/SQL to load loan, branch and field advisor information from partner business units

Developed utility tools for batch processing of sql scripts and other program modules

Confidential

Data Architect

Skills Used:

Oracle 10g, PL/SQL, OWB, OMB, XML, C .Net, Excel Macro

Accomplishments:

• Developed and maintained ETL process for data conversion and migration using Oracle Warehouse Builder OWB and PL/SQL stored procedures.
• Developed utility tools using OMB Plus scripts to migrate OWB Mappings between database environments.
• Developed database program to generate XML configuration file for Adobe Flex application

Confidential

Sr. Data Analyst

Skills Used: Oracle 10g, SQL, SQL Plus, Toad, PL/SQL, XML

Accomplishments:

• Developed and maintained ETL jobs using Advanced SQL programs
• Generated adhoc reports for research analysts.
• Developed to tools to monitor batch jobs.
• Developed programs to produce XML files for data transfer to other systems

Confidential

System Analyst

Skills Used:

Oracle 9i, Oracle 10g, SQL, PL/SQL, VB6, .Net, Infragistics, QTP, Cognos ReportNet, Microsoft SQL Server 2005, SSIS

Accomplishments:

• Enhanced and migrated MSAccess application to SQL Server 2005.
• Enhanced Clinical Trials management application.
• Evaluated various features of QTP to adapt to needs of automated front-end application test.
• Used SQL Server Integration Services SSIS for data transfer mapping and automation

Confidential

Software Engineer

Skills Used:

Oracle 9i, Oracle 10g, SQL, PL/SQL, VB6, .Net, Infragistics, QTP, Cognos ReportNet, Microsoft SQL Server 2005, SSIS

Accomplishments:

• Developed a billing system for vendor invoice automation using Oracle Forms and Oracle Reports.
• Designed and developed several programs units for implementing email delivery of invoices as enhancement to existing invoice printing system.
• Designed enhancements to invoicing to enable credit card payment

Confidential

Software Engineer

Skills Used:

Oracle 9i, Linux, Shell Scripts, SQL, PL/SQL, JAVA, XML, Rational Rose, Rational Clear Case, Oracle Enterprise Manager, Ant, Junit, SQLUnit

Accomplishments:

• Developed several programs units in PL/SQL with advanced features of session management, dynamic sql, transaction control, event handling, XML file processing and multi-schema objects.
• Designed database objects and process flows accommodating quality, reliability and availability requirements of real time operation.
• Developed regression test scripts for SQLUnit - an opensource framework for automated unit and regression testing for database applications. Used Junit framework to unit test Java components.

Confidential

Data Analyst

Skills Used:

Oracle 8i/9i, Oracle WebDB, Oracle 9iAS, Unix, Shell Scripts, PL/SQL, JAVA, Toad,Visio 2000, Erwin 4, HTML, JavaScript, HTMLDOC

Accomplishments:

• Enhanced a database driven web application to improve usability and performance by reengineering and refactoring. Documented process flow using flow charts in Visio.
• Effectively used advanced new features of Oracle and PL/SQL to implement Large Objects, Reference cursors, Java stored procedures, file handling, directory handling, OS command invocation and job scheduling.
• Designed and implemented a unique set of interactions between PL/SQL procedure, JAVA Stored Procedure, Shell Script and HTMLDOC API, PL/SQL Web Toolkit package.

Confidential

System Analyst

Skills Used:

Oracle 7/8i, PL/SQL, MKS Toolkit, Shell Scripts, SQR, Visual Source Safe, EDI

Accomplishments:

• Enhanced and managed and features in a data mart for Contract Marketing, Sales Administration and Finance departments.
• Performed requirements analysis, work estimation, design, development, implementation and post implementation support
• Completed several data conversion project to integrate with partners database following acquisitions.
• Developed processes to import, process and export data files in EDI formats.

Confidential

System Analyst

Accomplishments:

• Designed and developed several claim activity and summary reports as part of conversion from mainframe to client/server environment using SQR on Sybase RDBMS on Unix operating system
• Developed and supported database applications for Telephone Billing System, Banking System, Credit Card Processing System, Securities Management System
• Developed several tools to simulate structural and thermal behavior of critical components in nuclear power reactor using Fortran and C . Developed 3-D object model to interface with a structural analysis system.