PROFESSIONAL SUMMARY:

• 10 + years of professional experience as a Software Engineer in Databases, Reporting Tool, Web based applications, Product Development and Data Migration.
• Extensive exposure to work independently.
• Extensive exposure in Databases like Oracle 11G & 10G, SQL Server 2008 and 2005 and Mysql.
• Extensive Experience in Oracle PL/SQL.
• Experience in Data warehouse.
• Experience in UNIX and Shell scripting.
• Experience in OBIEE 11G Analytics tool to creating the Dashboards and Reports.
• Experience in OLTP and OLAP systems.
• Extensive Experience in writing complex SQL queries.
• Extensive Experience in writing Package, Stored Procedures, Functions, Triggers, Views and Materialized views.
• Extensive Experience in writing Joins, Index, Cursors, Sub queries and collections.
• Extensive Exposure for using tools SQL developer and Toad.
• Experience in data base model design.
• Experience in data migration from SQL Server to Oracle 10G.
• Extensive Experience in SQL Queries Performance tuning.
• Extensive Experience in Unit Testing.
• Experience in Import and Export data using the SQL Loader.
• Experience in maintaining the Existing SQL codes and Reports.
• Extensive Exposure in Maintenance, development and production support projects.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Extensive exposure to work in New and Enhancement report preparations.
• Experience in the Document Preparation.
• Extensive Experience in creating Adhoc reports and Dashboards as well as RPD changes.
• Extensive Exposure in defect tracking tools like JIRA and HPSC.
• Executed software projects for Healthcare, Pharmaceutical and Banking and Insurance industries.

TECHNICAL SKILLS:

Primary Skills (RDBMS): Oracle 11G & 10G, SQL Server 2008 and 2005, Mysql 5.0 and MSAccess

Programming Lagunage: Oracle PL/SQL,T - SQL and Core Java

Secondary Skills: Oracle Business Intelligence Enterprise Edition (OBIEE) 11GAnalytical Tool

Operating Systems: Windows XP, Windows 2007, Windows 8.1, Linux 5.2, Unix andShell Scripting

Defect Tracking Tool: JIRA and HPSC

Other Tools: Toad, Oracle Sql Developer, PL/SQL Developer, Sql*PlusSQL Management Studio, Erwin, SQLYog, DBDesignerSSH Tectia Client, WS FTP, SFTP, MyEclipsePutty, Microsoft Visual SourceSafe and WinSCP

PROFESSIONAL EXPERIENCE:

Oracle Pl SQL Senior Developer

Confidential

Responsibilities:

• Discussing the New or Enhancement requirements with the business users.
• Preparing the SQL Scripts, Stored Procedures, Functions and Views to implement the Business logic.
• Working on data fixes to correct the wrong data as per the business user request.
• Preparing the report to find out the corrupted/in valid business data and share with business.
• Writing the Script/Procedure to fix the corrupted/in valid business data in Data base.
• Supporting the production deployment for data fixes scripts on daily basis.
• Meeting with the Business analysts people to discuss the data fix issues on daily basis.
• Analyzing the Existing data model and modify the data model to implement the New/Enhancement business requests.
• Creating the New reports for data analysis using the Business Intelligence tool as well as Oracle database.
• Migrating the Existing data into new Source system.
• Analyzing the gaps between the old source System and new source system and estimate the time frame to complete the gaps.
• Involving the Code review and Unit Testing of the new development.
• Preparing the report data for validation for pre and post deployment process.
• Coordinating with the onsite team members about the New/Enhancement Requirement analysis, Design and Development.
• Supporting the off-shore development team to understand the problem and the fix that is required for the problem.
• Maintenance and support of existing source codes and data.

Technologies and Tools Used: Oracle 11G, PL/SQL, JDK 1.6, Windows 7, JIRA, Erwin, Oracle Sql Developer, Toad and WinSCP.

Oracle Pl Sql Senior Developer

Confidential, TN

Responsibilities:

• Worked in preparing the Stored Procedures, Functions, Triggers, Package, Cursors, Views and Joins.
• Worked in Performance Tuning.
• Worked in data model preparation.
• Worked in Code Review.
• Worked in UAT defect fixing.
• Worked in writing the complex SQL queries.
• Worked in the data warehouse system.
• Created the Dashboards and reports using the OBIEE 11g tools.
• Worked with Clients to get the New and Enhancement report Requirements.
• Maintained the Existing reports and SQL codes and objects.
• Analyze the Enhancement requirement for Analytics and Report requirements.
• Estimate the time frame to develop the Enhancements and New reports.
• Worked in the Document Preparation about the New and Enhancement Requirements.
• Worked in Unit Test case preparation.
• Worked in Unit Testing using the Unit Test Cases.
• Worked with clients to prioritize the current work items.
• Convert the functional requirements to Technical specification.
• Coordination with off-shore team from onsite.
• Ensured the delivery of the New Enhancements and reports to the business in timely manner with Quality.
• Weekly updating the work status with the client.
• Monthly meeting with the client highlighting the achievements and challenges.

Technologies and Tools Used: Oracle 11G & 10G, SQL Server 2008 and 2005, MSAccess, PL/SQL, OBIEE 11G, HPSC, SFTP, Windows XP, Data Warehouse, Data Mart, Oracle SQL Developer, Toad and SQL Management Studio.

Oracle Pl Sql Senior Developer

Confidential

Responsibilities:

• Worked in the client location (Client Location: Confidential, India) twice a week.
• Involved Data Migration from SQL Server to Oracle 10g DB.
• Involved in database design.
• Involved in preparing the Stored Procedures, Functions and Triggers.
• Involved in Unix and Shell scripting.
• Involved in Performance Tuning.
• Involved in Code Review.
• Involved UAT defect fixing.
• Involved Document Preparation about the Migration (Detail of Field Mapping).
• Involved Document Preparation for Report Module.
• Involved in Unit Test case preparation.
• Involved in Unit Testing using the Unit Test Cases.

Technologies and Tools Used: Oracle 10G, SQL server 2000, PL/SQL, JDK 1.5, RVW 2.0, Erwin, Windows XP, SSH Tectia Client, Unix, Shell Scripting, Toad, Sql*Plus and SQL Management Studio.

Senior Developer

Confidential

Responsibilities:

• Worked one year at the client location (Bangalore, India) for requirement gathering.
• Analyzed the specifications provided by the clients.
• Involved Coding for CR and Production Support.
• Involved in coding for Claims Module and enrollment modules. This includes handling end to end claim processing including cashless and cashed claim
• Involved in Writing Stored Procedures and Functions.
• Involved in Performance Tuning.
• Involved in Data Model Preparation.
• Involved in Code Review using the Business Requirements and Coding Standards.
• Involved in Method Specification preparation.
• Involved in Unit Test case preparation.
• Involved in Unit Testing using the Unit Test Cases.

Technologies and Tools Used: Oracle 10G, PL/SQL, JDK 1.5, RVW 3.0, PL/SQL Developer, Microsoft Visual SourceSafe, Erwin and Windows XP

Confidential

AgriMor NetherlandWork

Responsibilities:

• Involved in Writing Stored Procedures and Functions.
• Involved in coding for Cultivation Planning Module.
• Involved in Code Review using the Business Requirements and Coding Standards.
• Involved in Method Specification preparation.
• Involved in Unit Test case preparation.
• Involved in Unit Testing using the Unit Test Cases.
• Involved in Integration testing.
• Involved in Writing Stored Procedures and Functions.
• Involved in coding for Student and Staff Module.
• Involved in Unit Testing using the Unit Test Cases.
• Involved in Integration testing.

Technologies: Oracle 8i, PL/SQL, JDK 1.5, PL/SQL Developer, MyEclipse and Windows XP