PROFESSIONAL SUMMARY:

• 7+ years of experience in software industry dealing wif Development, Component Design, Performance enhancement, Testing and Support of Enterprise applications using Oracle, Asp.Net and JavaScript.
• 5+ years of experience in systems Analysis, design and development of complex software application in analytics domain.
• 5+ years of experience in Design, Development, Enhancement and Maintaining applications in Oracle 9i/10g/11i using SQL, PL/SQL. Detailed Knowledge of Oracle Architecture.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Extensive experience in database query tuning, performance tuning of reports and troubleshooting oracle application issues on OLTP and DSS systems.
• Very good analytical skills to solve issues wif optimal solution and debug.
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers using Oracle PL/SQL tool.
• Extensive experience in RDBMS including Conceptual, Logical & Physical Database and Model using Oracle 8/9i/10g, PL/SQL programming, SQL Query Analyzer, SQL and Packages, Stored procedures, Triggers, Cursors and Complex Queries, Query Tuning.
• Good experience wif Toad development tools, used to speed up teh development process.
• Extensively used HTML, XML, MXML, DHTML, JavaScript, Adobe Flex, CSS and ASP.Net.
• Strong understanding and working knowledge of MVC framework.
• Good Experience in EXTJS and Asp.Net
• Well versed experience in providing production support to teh Mission Critical applications
• Involved in complete Software Development Life Cycle of teh projects (SDLC).
• Excellent team player and proven track record working in various team sizes performing cross - functional roles.
• Self-motivated, quick learner, able to work well under tight deadlines and rapidly changing priorities.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, My SQL, SQL, MS Access

Web Technologies: Asp.Net, HTML, CSS, Java Script, Action Script

Application Servers: Apache HTTP Server (IIS 7.0), Java Web Server 2.0.

Development Tools: Dreamweaver, MS SQL server, Oracle Developer, Visual Studio

Source Control: SVN, Git, Visual SourceSafe

Web ServersI: BM Web Sphere 3.5/4.x/5.x/6.x, BEA Web Logic 8.x/9.x, Apache Tomcat 3.0/4.0/5.x/6.x,JBOSS:

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle /PL/SQL Developer

Responsibilities:

• Involved in teh development of custom stored procedures, functions, Sequence, Synonyms, packages, triggers, views, sub queries and PL/SQL scripts.
• Involved in teh maintenance & support of teh oracle 9i/10g/11i database.
• Involved in data modeling and requirement gathering.
• Developed reports, charts and forms depending upon teh requirement.
• Migrate teh data from Excel Sheets into teh respective Oracle Database tables using SQL* Loader scripts.
• Create Database Links, Materialized views and refresh teh MV’s on daily basis.
• Schedule jobs using teh oracle scheduler.
• Perform database tuning and performance monitoring.
• Create application tablespaces, tables & indexes.
• Perform daily data refresh activities on development, UAT & production environments.
• Develop dynamic queries and Ad hoc reports.
• Manage User privileges and Roles.
• Import data into Oracle tables from MS- Access database.
• Monitor teh data on daily basis and performs tuning if required.
• Interact wif teh downstream users to resolve any database related issues
• Assisting developers wif database related activities.

Environment: Oracle 9i/10g/11i, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, PL/SQL, SQL Server 2000, T-SQL, Enterprise Manager, Query Analyzer, MS Access, Windows 2000, UNIX(Sun Solaris),TOAD

Confidential, Edwardsville, IL

Oracle Developer

Responsibilities:

• Responsibility includes developing Oracle PL/SQL procedures and functions, scheduled using oracle scheduler to interact wif interfacing applications both upstream and downstream to maintain data integrity across teh interfaces.
• Tuned SQL queries and PL/SQL blocks, Analyzed and computed statistics to improve response time for queries to ensure successful completion of teh Jobs in teh stipulated time and to make reports available daily.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database from various sources as flat files and data pull.
• Used Bulk Collect feature to improve performance.
• Used partitioning and sub partitioning of tables to improve performance.
• Create Database Links, Materialized views and refresh teh MV’s.
• Worked as Team lead, and led a team of developers, responsible for requirements gathering, status reporting, creating various metrics, project deliverables.
• Improved stored procedure efficiency by restructuring queries, removing temp tables and tuning indices.

Environment: Oracle 10g, Git, IBM-Websphere 6.0, SQL*Loader, SQL*Plus, PL/SQL, SQL Server 2000, T-SQL, Enterprise Manager, Query Analyzer, Windows 2000, UNIX(Sun Solaris),TOAD.

Confidential

Responsibilities:

• Gathering requirements from finance.
• Developing GUI wif HTML, Java Script, CSS and .Net Frame work.
• Coding in .Net & SQL Server
• Developed New Components & written Sql scripts.
• Familiarity wif teh Access Database.
• Expert wif teh Dreamweaver & Visual Studio.
• Wrote teh Stored procedures and functions
• Unit test and documented teh code

Environment: HTML, DHTML, XML, SQL Server 2000, Dreamweaver, JavaScript, CSS, Asp.Net, MS Access and Visual Studio.

Confidential

Online Bill Payment System

Responsibilities:

• Participation in teh development team.
• Handling validations and taken care of error handling.
• Involved in teh coding of servlet programs.
• Involved in teh development of web-content using HTML, CSS and JS.
• Acquired user requirements for system study.
• Preparation of low level and high-level design documents.
• Designed and coded teh pages using Asp.Net.
• Assisted in database design in Oracle, schema planning.
• Prepared Test Plans and Test review Forms.

Environment: Asp.Net, HTML, JavaScript, CSS, Oracle 8i, Tomcat 4.x, Visual Studio, Oracle 10g, Git, IBM-Websphere 6.0, SQL*Loader, SQL*Plus, PL/SQL, SQL Server 200