Oracle Pl/sql Developer Resume Profile
Omaha, NE
Professional Summary
- C .NET, VB.NET, ASP.NET, AJAX.NET, ADO.NET, VB6.0, ASP, SQL Server, Oracle and Crystal Reports.
- Possess more than 14 years of IT experience in Microsoft Technologies as .NET Architect / Sr. Developer /Tech Lead
- Designed and developed N-Tier architecture and multilingual systems for large Retail and Banking Clients
- Designed, developed and successfully engineered a generic, high secured, robust wrapper framework over .NET Framework
- Expertise in large volume based, rapid transaction based Data Modeling for enterprise wide system architecture
- Have practical hands on experience in leading large teams Peak size 96 in a global sourcing eco system
- Worked in various domains such as Banking, Retail, ERP and Healthcare
Technical Profile
- Have experience in all the phases of SDLC Software Development Life Cycle
- Expert in Analysis, Design Development of Internet Applications/Web Portals and Software Applications
- Extensive experience in JavaScript, HTML, DHTML, CSS, XML, experienced in N-tier Architecture multilingual/ database driven applications
- Extensive experience in SOA Service Oriented Architecture , Object Oriented Design OOD , Software development and Database administration.
- Experienced in creating, consuming and deploying Web Services and Windows Services using WCF.
- Knowledge of Ajax and experience using Ajax.net framework and AJAX Toolkit in.NET Framework 2.0, 3.0, 3.5, 4.0 4.5
- Expert level experience in Visual Basic 6, VBA, COM/DCOM, ActiveX, Crystal Reports 7/8.5/9/10 and Data Reports.
- Experience in Database Performance tuning, Backup and recovery and Data analysis
- Experienced in writing Stored-Procedures, PL/SQL T-SQL programming and writing Queries
- Worked Data Transformation Services DTS and Online Application Processing OLAP tools in SQL Server 7 and 2000
- Involved in Data Model and Database design using UML
- Strong experience in User requirements gathering, analysis, design, prototyping and implementation
- Authored technical design documentation for software and systems using a combination of UML artifacts use case diagrams, sequence diagrams, activity diagrams and other common tools Visio, Word, Excel
- Experienced in development and maintenance of systems across platforms such as VAX/VMS Mainframe ACMS Servers with VB6.0 and .NET.
- Have strong experience in Client/Server Programming and practiced development and implementation of protocols using RPCs Remote Procedure Call
- Involved in team management, system design, development, coding, debugging of various applications, data migration, system integration in various platforms and quality assurance.
- Obtained Brain Bench Certifications on VB.NET, ASP.NET, C .NET ASP.
Technical Summary:
Languages: VB.NET, C , VB6.0, VBA, C, C , AJAX.
Web Technologies: ASP.NET, ASP, AJAX.NET, PHP, WCF, Web Services, XML, XSD, XLT, XSLT, HTML, XHTML, DHTML, Silver Light, VB Script, Java Script, JSP, SOAP, WSDL.
Windows Programming: WPF, ADO.NET, Win 32 API, COM, DCOM, COM and ActiveX.
Design Methodologies: MS Visio, UML
Databases: Oracle 11g, MS SQL Server 2008/2005/2000/7.0, IBM DB2, My SQL MS Access
Version Controls: Visual Source Safe 6.0, WinCVS ClearCase
Operating Systems: Windows NT/2000/XP/Vista, HP-VMS, UNIX, DOS, Novell NetWare 5.1
Reporting Tools: Crystal Reports 7/8.5/9/10, Data Reports
IDE: Visual Studio 2005, Visual Studio 2003, Visual Studio 6, Visual SourceSafe, Visio, Rational Rose.
Other Tools: IIS 5.0, 6.0 7.0 , MS Office, AutoDesk Map Guide 6.0
Work Summary
Oracle PL/SQL Developer
Confidential
Role Application Architect / Sr. Developer Responsibilities:
- Design, Development, Unit Test, Support UAT Implementation
- Production Support as part of the maintenance and support for the application
- Automated the release and implementation using CruiseControl.Net for automatic deployment of the code and code promotion to higher environment
- Implemented enterprise service catalog by publishing business services as part of building ESB enterprise service bus using WSO2 Enterprise Service Bus
- Developed and implemented SOA Architecture and web services using WCF
- Designed and development various WCF Services
- Implemented service integration with multiple platform applications such as JAVA, ETL and UNIX Systems
- Developed tools and reusable components for rapid development in the new architecture
- Requirements Gathering, Prototype design, Impact Interfaces analysis
- Designed and developed customer facing corporate website using PHP, HTML, CSS JQuery utilizing google map apis
- Created many user controls, customer controls and theme based user interface
- Designed developed batch application to perform scheduled tasks
- Created Packages and Stored Procedures in Oracle 11g database also performed data migration
- Created unit test plans, unit test case documents
Environment: .NET 4.0, ASP.NET, VB.NET, C .NET, ADO.NET, AJAX.NET, PHP, MySQL, jQuery, HTML, CSS, CodeIgniter, Oracle 11g, XML, Web Services, WCF, Windows Server 2008 IIS7.0 , SVN Source Version control tool .
Confidential
Role Sr. Developer / System Architect
Responsibilities:
- Proposed, designed developed the architecture of the system in 6 tier architecture
- Developed tools and reusable components for rapid development in the new architecture
- Designed and developed centralized role based access provider framework components to support platform independent applications
- Developed and implemented SOA Architecture and web services using WCF
- Requirements Gathering, Prototype design, Impact Interfaces analysis
- Created a Custom GridView to suite any kind screen to provide custom sorting, paging and top of advanced filter on all the field with multiple criteria which brought me an Appreciation from IT director of INDOT business managers.
- Created many user controls, customer controls and theme based user interface
- Designed developed batch application to perform scheduled tasks
- Created Packages and Stored Procedures in Oracle 11g database also performed data migration
- Created unit test plans, unit test case documents
- Created custom installer package and implemented the application in different environments
Environment: .NET 3.5, ASP.NET, VB.NET, C .NET, ADO.NET, AJAX.NET, Oracle 11g, XML, Web Services, WCF, Crystal Reports 2008, Windows Server 2008 IIS7.0 , SVN Source Version control tool .
Confidential
Role Lead / System Architect
Responsibilities:
- Implemented Framework upgrades Both .NET Frameworks Internal Wrapper Frameworks many supporting components such as Atlas Framework, AEE Authentication Engine for Wachovia Securities Reports Navigator components.
- Performed System Architecture improvements
- Prepared Technical Design Document using Class and Sequence diagram for PMA application based on Business Requirement Document and Functional Requirement Document using Rational Rose.
- Designed and developed applications User Interface, Business Process Component and Data Access Layer using C , ASP.Net, VB.NET WinForms , Oracle 10g IBM DB2
- Used Enterprise Libraries Exception Handling Application Block and Logging Application Block for catching Exceptions and Logging the events
- Data Access Component was developed using Enterprise Libraries Data Access Application Block. All SQL queries were kept in Resource file XML for easy maintenance. Used Transactions for multiple table transactions to maintain data integrity in case of failure
- Used Business Entities to pass data between different layers of the Application
- Used Role Based, Rule Based Access controls based on the functional and organization entitlements.
- Designed User Interface as per Wachovia Standards style guide using CSS for Wisdom and Smart Station
- Implemented AJAX into entire application
- Developed and implemented SOA Architecture and web services using WCF
- Created Web Forms, User Controls Custom Controls for validating their Branch hierarchy, Header Control for switching between the systems and Display Control for displaying exception validation messages
- Developed enhanced the application on agile methodology.
- Participated in documenting the System Architecture document by understanding the Functional Requirement Document
- Performed database design, logical physical model designs, query optimization performance tuning. Performed these DBA activities in both SQL Server DB2
- Involved in Code Review using Dev Partner Unit testing of the applications using nUnit.
- Designed implemented a few pages in silver light for home office applications.
- Worked with different groups of the Project and helped in solving the problems Reportsed by Business Users
Environment: ASP.NET, C .NET, ADO.NET, AJAX.NET, WebForms, WinForms, MVC, XML, WCF, WPF, Web Services, SSIS SQL Server Reporting Services , Enterprise Library 3.1, MSSQL Server2005, Oracle 10g, IBM DB2, UML, Erwin for database modeling , Harvest 9.1 for source and version control , Windows XP Windows 2003 Servers.
Confidential
Role - System Analyst Lead
Responsibilities:
- Requirement Analysis, Impact Interfaces Analysis
- Prepared Technical Design Document using Class and Sequence diagram based on Business Requirement Document and Functional Requirement Document.
- Participated in documenting the System Architecture document by understanding the Functional Requirement Document.
- Performed Share point portal configuration and used for project repository
- Performed database design, logical physical model designs, query optimization performance tuning Performed these DBA activities in SQL Server 2005 .
- Performed System Architecture improvements, database objects mapping using Hibernate
- Worked with different groups of the Project and helped in providing the optimized solutions for the business needs
- System Design Development
Environment: ASP.NET, VB.NET, C .NET, AJAX.NET, WebForms, WinForms, WCF, WPF, MVC, SSIS, ADO.NET, SQL Server 2005, XML, UML, Hibernate, WinCVS Clear Case.