Career Summary:

• Expertise in Analysis, Design and implement of Client Server/Data warehousing applications using Oracle 9i/10g Forms/Reports6i/9i/10g, JDeveloper10g/11g. Eclipse, Sub/Versioning Controls, Java/J2EE with XML, Java Swings. JAX-B, JAX-WS, SOAP, Oracle Service Bus.
• Software Development Life Cycle: Feasibility Study, Fact gathering techniques, Analysis, Design, Implementation/Development, Maintenance with Oracle Apex 3.2/4.x.
• Oracle Apex 3.2/4.x developer design and implement end-end Web Application.
• Extensively worked with Oracle database development writingstored procedures, functions, packages, and database triggers usingSQL, PL/SQL.
• Advance UNIX Shell Scripting: AWK, SED; Korn-Shell, Borne Shell, Perl, Pro*C; UNIX package installation and setup.
• Exposure to performance tuning, creating de normalized tables, using indexes, PL/SQL collections, native dynamic SQL, function based indexes and bulk binding.
• Expertise in technical training: Oracle8i/9i Application server, Oracle Financials.
• Experience in designing Framework for various applications and its development with oracle Developer/2000.
• Rapid Application Development with Visual Basic 6/. NET with CSS, ASP/ASP.NET.
• Advanced administration techniques in Windows NT server.
• Good understanding of business processes and mapping them onto real world solutions.
• Java/J2EE Developer (Swing, AWT, Database connectivity-JDBC).

Academic and training details:

MS in Computer Applications (M.C.A.) /MS-Computer Science

Graduation:Bachelor of Science

Training:Networking with Novell Netware-Megabytes Technologies, Calcutta India

SKILLS:

Data Modeling Tools:ERWIN Data Modeler, Oracle Designer 10g, Toad Modeler 9.7

ETL Tools:Oracle Warehouse Builder 9i/10g, Workflow, Oracle Designer, MS SQL2000 DTS

RDBMS:Oracle 7.3/8.0/8i/9i/10g/11gR1: Advance SQL scripting, PL/SQL, Triggers, Functions, procedures and Packages & Database Objects, Batch import/export and SQL data loading techniques, MS Access, MS SQL Server 7/2000/2005

RDBMS Tools:Toad 8.6/8.0, Query Builder, PERL, SQL/PLSQL Developer, PL/SQL, SQL*PLUS, SQL LOADER, Procedure Builder, Pro* C, SQL Plus Worksheet, Object oriented with C++ (Borland).

Versioning Tools:Appworx 6.1/6, PVCS/EXCEED.

Oracle Front-End:Developer2000: Forms/Reports 6i/9i, oracle8i/9i Spatial/Locator, JDeveloper

PROFESSIONAL EXPERIENCE

Oracle Applications Developer.
Confidential,Minnesota Dec. 2010- Current

• Oracle Database migrations 8i, 10g to 11g Rel. 2. Incorporating new Business Requirements, advance SQL/PLSQL Tuning.
• Analyzing, Designing, and Implementing Oracle Applications with Toad 10x, Oracle Data Modeler and SQL Developer.
• TOAD DATA ANALYSER & MODELER tool.
• Creating complex Business Logic with Packages, Procedures, Functions and built-in Oracle packages: UTL_FILE, DBMS_SCHEDULER, UTL_MAIL.
• Creating Oracle ETL INTERFACE process for data extract back-end Business components for the Core Java/Java Swings Applications with Debugging Applets, Multi-Threading, and Servlets.
• Creating Oracle custom Themes with Apex 3.2/4.0, implementing Apex view-port pages and shared component business processes; implementing security objects using access control pages.
• Using migration tools, Data Modeling.
• Oracle Forms and Reports legacy system migration to Oracle Apex 4.0 Development Framework. Design and Implementation of new business requirement using Oracle Apex 4.0; creating advanced Forms and Apex reports integrated with Java Scripts, setting up Data Access Descriptors; Document Object Model; CSS for user-interface standardization; using Plug-ins and Dynamic Actions.
• Data Extraction, Transformation, Load(ETL) using Oracle Apex 4.0
• Batch external Data transformation into Oracle Tables, SQLLOADER.

Oracle ETL Developer.
Confidential,TX Feb. 2010- Dec. 2010

• Advanced, real-time Oracle Development with Oracle 9i/10gR2.
• Analyzing, Designing, and Implementing Oracle Applications with Toad 9.7/SQL Developer.
• Creating complex Business Logic with Packages, Procedures, Functions and built-in Oracle packages: UTL_FILE, DBMS_SCHEDULER.
• Creating back-end Business components for the Core Java/Java Swings ASPEN Applications with Debugging Applets, Multi-Threading, and Servlets.
• Oracle e-Business Suite: Application configuration and setup.
• Using migration tools, Data Modeling, Clear Quest/Clear Case.
• Batch external Data transformation into Oracle Tables.
• UNIX ETL/Batch Data load processes. Unix Scripting, awk, File transfer/FTP.
• Oracle e-Business Suite Setup, Configuration and Development: General Ledger, Account Payable and Receivable. Profitability Manager, Process Management. Flex Fields and Navigations.
• Data Analysis with Toad Data Modeler: SQL Modeler, Code Road Map, ER Diagrams, Reports, Schema Doc Generator, Session Browser, Java Utilities.
• Creating Oracle Batch Execution Scripts; Oracle Automation processes with Oracle 10g/11g scheduler
• Advanced HTML and Cascade Style Sheets (CSS). Data Modeling Concepts: TOAD DATA MODELER, SCHEMA MANAGER.
• Oracle Data migration from genesis system and Oracle 8i to Oracle 11g.
• Completed training on advance features of Oracle APEX 4.0.

Oracle Web Applications Developer
Confidential,Jan. 2009-Jan 2010

• Develop data-centric web applications for the Oracle environment using APEX 3.2. Involved in full development cycle of an APEX application, reviewing and applying best practices the major APEX principles and building blocks. Design and implement tailor-made forms and reports, using APEX APIs, AJAX. Performance and Scalability Production Issues.
• Incorporated Conditions and Authorization Schemes; Data Security; Navigation and Layout; Reports and Charts; Ajax and JavaScript; Reporting and Printing. Authentication and User Management; Themes and Templates.
• Using APEX to develop efficient and optimized data-centric native web applications, for the Oracle environment
• Oracle Administration responsibility: Recovery Manager (RMan) tools, installation and Configuration, writing ETL data load SQL Scripts. Built-in Oracle Views.
• Employing Model View Controller (MVC) architecture Oracle ADF and Java Server Faces, and Session Façade Design Patterns. Build Web Application with JDeveloper 11g Using EJB, JPA, and Java Server Faces; Working with Bounded Task Flows, Regions and Routers in JDeveloper 11g.
• Add content, Design, and implement Enterprise Portal based on Oracle Application Server Portal (OracleAS Portal) to provide Applications integrated environment.
• Configuring Oracle Web Logic Server 10gR3 Managed Instances; Using the Web Logic Server 10gR3 Administration Console.
• Data Access Descriptor (DAD) configuration.
• Deploy APEX Web Applications to the application server.
• Oracle 10gR2/ 11g PL/SQL Development: Advanced SQL coding, Functions and Procedures, Packages, Oracle web Mod_PLSQL Toolkits (DB HTML developments).
• Oracle Application Server 10g setup with Database Administration.
• ERWIN Data Modeler, Toad Application Development Tool, TOAD Schema manager.
• Javascripts: creating functions, javascript Objects, Document Object Model (DOM), incorporating AJAX component and Objects. Mapping Javascript Functions to Web Pages through Oracle MOD PL/SQL.
• Creating Perl Batch Execution Scripts; Oracle Automation processes with Oracle 10g/11g scheduler
• Advanced HTML and Cascade Style Sheets (CSS). Data Modeling Concepts: TOAD DATA MODELER, SCHEMA MANAGER, Erwin Data Modeler.
• Oracle Data migration from genesis system and Oracle 8i to Oracle 11g.

Senior Oracle/.NET Applications Developer
Confidential, Jan. 2008-Jan. 2009

• Intensive system migration from Oracle 9i, and Form/Reports6i to Oracle 10gR2. Implementation and deployment with Application Server 10g, HTTP/Apache Tomcat server and Enterprise Manager10g. Oracle Designer 10g for system analysis and modeling. Oracle Warehouse Builder10g. Oracle Data Mining 10g.
• Implementing APEX-related technologies like HTML and the DOM, CSS, and JavaScript, which will help you to develop better, richer, and more efficient APEX applications.
• Oracle Application Express 3.0 for intensive Database development: SQL, PL/SQL, functions, packages, stored procedures, Triggers, Oracle Type Objects etc.
• Creating and incorporating Java Beans services, java struts in Oracle Forms 10g Applications.
• Visual Basic 6.0 and Classic ASP migration to Visual Basic/C# .NET 2005 and ASP.NET with AJAX, VBScript and JavaScript, PVCS versioning. Hands-on experience on .NET 2008 with IIS7.
• Migrating Oracle Forms 6i to 10g; Converting Oracle reports 6i to Oracle10g Application Express (APEX).
• System analysis and documentation(Test Cases and High-Level Documents).
• Data Modeling withERWIN Data Modeler & Oracle Designer 10g.

Senior Oracle Applications Developer
Confidential,Omaha, Nebraska Feb. 2006-Jan. 2008

• I was engaged in intensive analysis, design, documentation and implementation of advanced Oracle PL/SQL, FUNCTIONS, PROCEDURE, PACKAGES. Query optimization, tuning, and RAD with TOAD 9.5. Advanced code development/migration with Oracle Developer Suite Forms 6i/Reports, Oracle Pro*C, awk and sed, Unix Korn Shell/Bash Shell Scripting, Perl Scripting with Apache Server, FTP Utilities, PACKMULE Scheduler and some Oracle Financials, Lotus Notes Mail; Migration process from Forms 6i to Oracle Forms 10gR2; Database Migration from Oracle 8i to Oracle 10gR2. Oracle Concurrent Manager (Business Suite), Oracle Workflow Builder, PVCS and APPWORX 6 Automation Scheduling Manager. ERWIN Data Modeler and Oracle Designer 10g.
• Oracle 10gR2 with JDeveloper 10gR3/WebLogic server 1ogR3: Integration, Implementation and Deployment. Migration from Oracle Forms/Reports 6i to JDeveloper10gR2 with WebLogic Server 10gR3. I did intensive system modeling (1)Logical modeling by gathering information about business processes, business entities (categories of data), and organizational units, (2)Physical modeling that involves the actual design of a database and Front-End modules according to the requirements that were established during logical modeling.
• I thoroughly used Oracle Application Express (Oracle APEX) as a component of the Reporting Tools for graphical data analysis, to quickly create secure and scalable web applications that we instantly deployed to the Company Intranet.
• Successfully completed training in Cognos 8 Business Intelligence and enterprise planning solution.

Software Engineer/Senior Database Developer
Confidential, [Dec 2004-Feb. 2006]
I worked on the new version of the Code Inspection System for a large Company, conducting detailedcomparative analysis with the current Mobile system. For the last Five (5) years the CERTS System used by the Organization was based on Visual Basic 6.0 with Oracle8i/9i PL/SQL as back-end. This involves intensive analysis and implementation of advanced Oracle PL/SQL. My work as the Developer/Analyst is to thoroughly analyze this current system then migrate it to Microsoft Visual Studio.NET(VB.NET/C#) 2003 .NET Framework with MS SQL Server2000 as back-end. The new release is more robust, engineered by Oracle10g Database server (for mobile component), Oracle Forms/Reports 9i (Developer Suite components), together with Oracle Business Intelligence Discoverer 10g for integrating reports and analysis. I used Oracle10g Warehouse Builder in current project together with MS SQL Server Data Transformation Services. Crystal Reports8.0.5/IX for delivery reports for extreme administrative insight (client/server architecture) with Visual Basic.NET 2003 user-interface. Final phase of this assignment involve the Database Migration from Oracle 9i Lite (mobile/PDA) to MS SQL 2000 Server. This project involves Database migration from Oracle9i to MS-SQL 2000.

• Problem definition [PD]: At this stage we determined the needs and constraints of the finance department by analyzing the requirements and interfacing with the administration [Time Frame: 3 weeks]
• Solution analysis: By considering PD as the input, we were concerned with the set of possible ways to satisfy the requirements and constraints, studies and analyze the possible solutions, and select the optimum one. This was based on a couple of logical Tools such as ERD, Flow of Data, and UML [Time Frame: 2 weeks]
• Process planning: This phase brought us to the actual tasks to be done, the size and effort to develop the software solution, the precedence between tasks, and the potential risks to the project. To understand the new system better, we still used some of the above logical Tools [Time Frame: 3 weeks]
• Process control: Only three people engineered this phase, the task is to determine the methods for controlling the project and the process, measures progress, reviews intermediate products, and takes corrective action when necessary [4 weeks]
• Product evaluation: Determines the quality and quantity of the delivered product through evaluation planning, testing, demonstration, analysis, examination, and inspection. We started by installing the system prototype on wide variety of hardware configuration running different versions of Windows operating systems [4 weeks].
• Advanced Object Oriented Approach/Methodology.