PROFESSIONAL SUMMARY:

• Around 6 years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, System Analysis, Database Architecture and Design, Development, Testing and Deployment of business applications.
• Strong Database Development Experience and web Development in Health Insurance, Finance, Retail sectors.
• Strong Knowledge in Conceptual, Logical and Physical Design and Development of Operational and Data Modeling experience for Relational databases.
• Strong Experience in Business intelligence applications, Data Mining, Ad - Hoc Reporting using SQL, PLSQL, Crystal Reports.
• Strong Experience in Front End development using C#, ASP.Net, VB.Net.
• Extensive experience using oracle 8i, 9i, 10g, 11g, versions in ETL development using stored procedures, Functions, Packages, Triggers and DB Utilities like SQL* Loader, UTL file, Data Pump, Import, Export, and oracle supplied packages and types.
• Good experience in DBA activities like process monitoring and scheduling.
• Good experience in ETL Jobs, data conversions, data migrations.
• Good experience in the development of Shell-Scripting using UNIX shell scripts, UNIX, and Batch Processing, Meta Data Management, Scheduling jobs using Cron job, Autosys and DBMS job scheduler.
• Extensively worked in Performance Tuning of Data base applications and Query Optimization and Tuning using Bulk collections, Hints, Explain Plan, TKPROF.
• 24/7 Production support and involved in implementation of coding standards security, attending audits at various levels by using coded security module, database change requests.
• Versatile team player with Good communication, programming and problem analysis with strong Subject skills proven under high-pressure environments.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows NT/ 2000/98/2003/2007, UX-HP, AIX, UNIX, and Linux

DATA MODELING: Oracle Designer 6i, UML.

DATABASE: Oracle 11g,10g, 9i, 8.1, 7.0, MS SQL Server, DB2/UDB 8.1,MS Access

LANGUAGES: SQL, PL/SQL, C#, ASP.Net, VB.Net, ADO.Net, Java, Unix Shell

WEB TECHNOLOGIES: HTML, XML, XSLT, ASP, JSP, Win Form

TOOLS: TOAD, SQL Navigator, PL/SQL Developer, Rational Clear Case, TIDAL, Mercury data quality center, Bugzilla, PVCS

PROFESSIONAL EXPERIENCE:

Confidential

Software Programmer

Responsibilities:

• Worked closely with cross functional teams, Business users to gather the functional specifications and preparing technical specifications, and involved in conceptual, Logical, Physical designs of the Database, review and validate software design documents using UML.
• Responsible for Creating Data Mapping between old legacy systems to the new UCM systems.
• Responsible for creation of source, stage, target database objects using Database utilities like IMPORT, EXPORT and created database objects like Tables, Views, Sequences, synonyms, indexes, Database links, Roles, Profiles, Procedural objects like Procedures, Packages, Functions and Triggers.
• Developed SQL * Loader scripts to cleanse, profiling and staging the source data like Legacy systems, SQL server.
• Developed Packages, Procedures, and functions to load the stage data into the target systems by following conversion rules.
• Developed UNIX shell scripts to automate the conversion code through CRON tabs, Tidal.
• Involved in the development of Front end Screens using ASP.Net, C#.
• Involved in the conversion data systems from SQL Server.
• Responsible for maintaining the code versions using source control systems.
• Responsible for performance tuning of database objects and procedural objects using Indexes, Partitioning, Parallel Execution and Query optimization using Bulk Loads, Hints, Object types, Collection types.
• Involved in the trouble shooting, developing test plans to conduct the Unit and Integration testing for data validations.
• Developed technical documentation and end user manuals, and conducting user trainings about the application.

Environment: Oracle 11g, 10g, SQL, PL/SQL, ASP.Net, C#, SQL Server, UT PL/SQL(unit testing), HP-AIX, Unix Scripting, Clear Case Tidal, PL/SQL Developer, Erwin, Visio, Agile methodology

Confidential

Software Programmer

Responsibilities:

• Worked closely with cross functional teams, Business users to gather the functional specifications and preparing technical specifications, and involved in conceptual, Logical, Physical designs of the Database, review and validate software design documents using UML.
• Responsible for creation of source, stage, target database objects using Database utilities like SQL * Loader and created database objects like Tables, Views, Sequences, synonyms, indexes, Database links, Roles, Profiles, Procedural objects like Procedures, Packages, Functions and Triggers.
• Developed SQL * Loader scripts to cleanse, profiling and staging the source data like IDMS.
• Developed Packages, Procedures, and functions to load the stage data into the target systems by following conversion rules.
• Developed UNIX shell scripts to automate the conversion code through CRON tabs, Tidal.
• Involved in the development of Front end Screens using ASP.Net, C#.
• Involved in the conversion data systems from SQL Server.
• Responsible for maintaining the code versions using source control systems .
• Responsible for performance tuning of database objects and procedural objects using Indexes, Partitioning, Parallel Execution and Query optimization using Bulk Loads, Hints, Object types, Collection types.
• Involved in the trouble shooting, developing test plans to conduct the Unit and Integration testing for data validations.
• Developed technical documentation and end user manuals, and conducting user trainings about the application.

Environment: Oracle 10g, SQL, PL/SQL, ASP.Net, C#, SQL Server, UT PL/SQL(unit testing), HP-AIX, Unix Scripting, Clear Case Tidal, PL/SQL Developer, Erwin, Visio, Agile methodology

Confidential

Oracle Developer

Responsibilities:

• Responsible for Requirements gathering from the business users, preparing the Functional, Technical specifications, and involved in conceptual, logical, physical designs of the Database.
• Involved in creation of database objects like Views, Synonyms, Object Types, Collection Types, Sequences, Oracle Directories, Indexes, Materialized Views, Database Links, Roles, Profiles and the Relational Integrity.
• Responsible for Creating, Maintaining, and Automation of ETL jobs using procedural objects like Procedures, Functions, Packages and Triggers, using utilities like SQL*Loader, UTL FILE, External tables, for data conversions, data migrations, data cleansing, data staging, data loading into the target Tables from the legacy systems like SQL server and XML files, Flat files, Spread Sheets.
• Responsible for creating, modifying and maintaining Materialized views from the Fact tables, Time based Hierarchies for Ad-Hoc Reporting.
• Responsible for performance tuning of database objects and procedural objects using Indexes, Partitioning, Parallel Execution and Query optimization using Bulk Loads, Hints, Object types, Collection types.
• Responsible for ad-hoc reporting and Business Intelligence. And pretty much involved in Collecting report requirements from the cross-functional teams and providing and performing analysis of the reports and presenting to the managerial staff and Involved in creating, changing and Maintaining various reports using SQL Plus, Crystal reports.
• Involved in the trouble shooting, developing test plans to conduct the Unit and Integration testing for data validations.
• Developed technical documentation and end user manuals, and conducting user trainings about the application.

Environment: Oracle 10g, SQL, PL/SQL, Crystal Reports, UNIX Scripts, PERL Scripts, XML, SQL*Navigator, VSS, HP-UX, and Windows XP.

Confidential

Software Engineer

Responsibilities:

• Gathered user requirements, reviewed processes and attended client meetings.
• Development of Detailed design and Data model. Prepared the E-R diagrams for the model.
• Designed and Developed sub system using C# and ASP.NET.
• Client side components were written using C# class libraries
• Used extensively Data Grid controls for displaying data.
• Designed and developed the front-end screens using AJAX (HTML, XML, CSS, and Java Script), DHTML and developed Class Files for these screens.
• Configured the application in the Web. Config file and implemented forms authentication, storing user and password details in the user table of the application Database.
• Responsible for creating database interaction using ADO.NET using SQL queries.
• Responsible for creation of source, stage, target database objects using Database utilities like SQL * Loader and created database objects like Tables, Views, Sequences, synonyms, indexes, Database links, Roles, Profiles, Procedural objects like Procedures, Packages, Functions and Triggers.
• Used flash player to add graphical feature to the website.
• Used fireworks to create photo gallery.
• Performed Unit Testing.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, SQL Server, VB.Net, ASP.Net, C#, ADO.Net, Crystal Reports, UNIX.