PROFESSIONAL SUMMARY

• Highly motivated SQL server and PL/SQL Developer with 9 Years 3 months of IT Experience in Database and Business Intelligence Technologies with expertise on query optimization - performance tuning and ETL process in various domain like Finance, Market research.
• Extensive involvement in all the stages of System Development Life Cycles SDLC including Requirements analysis, Design, Development, Implementation and Support.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Expert in query optimization-performance tuning by using SQL Profiler, Execution plan and Performance monitor.
• Having experience in using recursive CTEs, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Having experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Having experience to transform data from one server to other servers using tools like Bulk Copy Program BCP , and SQL Server Integration Services SSIS .
• Experience in Developing PL/SQL Packages, Procedures, Functions, Cursors, Event Handlers, SQL Scripts and Database Triggers to populate the data applying business logic in Oracle 11g.
• Experienced in Tuning the application using Explain plan and SQL Trace for optimizing the cost and higher efficiency in Oracle 11g.
• Expert in optimizing Indexes, Queries, Performance Tuning, Normalization and Database Integrity in Oracle 11g.
• Extensively used Cubes Rollups for making cross tabular reports.
• Having good experience in report designing using Crystal report 11.0
• Having knowledge in creating configuration files to deploy the SSIS packages across all environments.
• Having 1 years of experience in data migration from Oracle to SQL server.
• Having 3 years of experience in Ramco ERP suite in finance domain Book keeping, accounts receivables and payables, Fixed asset
• Hands on experience with replication Snapshot, Transactional and Merge.
• Hands on experience with Database backup and restore.
• Having knowledge in SQL Server Reporting Services.
• Worked with technical writer to create new/improve existing technical documentation.
• Hands on experience with source control system like Visual Source Safe 6.0, Tortoise SVN
• Working experience in Agile Methodologies project and involved in Sprint Planning Meeting and Daily Scrum meeting.

TECHNICAL SKILLS

• Databases : SQL Server 2012/2008R2/2005 and Oracle 10G PL/SQL
• Database Tools : Management Studio, Profiler, DTS, Query Analyzer, SSIS
• ETL Tools : Data Transformation Services DTS , SQL Server Integration Services SSIS
• Reporting Tools : Crystal Reports 11.0, SSRS
• Programming Language : VB 6.0 and ASP 3.0
• Third Party Tools : Lite speed
• Domain competencies : ERP Finance module

PROFESSIONAL EXPERIENCES

Confidential

Role : Technical Lead

Environment : Oracle 11g, .Net 2005, SOSS Scale Out State Server , Windows 2008

Roles responsibilities

• Involved in SDLC which included requirements gathering, analysis, design, and development.
• Working in fast paced AGILE environment attended daily scrum meeting.
• Involved in database and application analysis to upgrade the WebQA to meet the performance requirements for high speed retrieval of Data Items.
• Extensively used Explain Plan and SQL Trace to optimize queries, stored procedures and enhance the performance of databases.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the intermediary database to the main database.
• Created database objects like Tables, Indexes, Views, constraints and Synonyms.
• Implemented database standards and naming convention for the database objects.
• Interacting with client on daily basis for status reporting purposes.
• Maintaining databases of QA development environment.
• Hands on experience with source control system like Tortoise SVN.
• Monitoring DB servers, schedules and observing long running SQL queries for query tuning.
• Worked in agile methodologies and involved in Daily Scrum meeting.
• Provided 24 x 7 Production support for the database and application issues.

Confidential

Role : Sr. Developer

Environment : SQL server 2005, Ramco virtual works RVW and Crystal Reports 11.0

Roles and responsibilities

• Provided technical support for entire finance module Book keeping, Accounts payables and receivables, Global Tax Solution and Fixed asset
• Migrated 10 years legacy data to existing system from Oracle to SQL server 2005 using DTS/BCP.
• Verification of migrated data with the forward cycles.
• Worked in query optimization performance tuning using SQL profiler, execution plan and query tuning advisor
• Used Crystal Report 11.0 to develop various reports in finance modules like trial balance, balance sheet, income statement, supplier/ customer ledger, etc.,
• Designed and extended the OLTP data architectures.
• Created databases objects including tables, indexes, applied constraints, views, user defined functions, stored procedures and triggers
• Worked in customization of the product and defect fixing.
• Responsible for implementing the Business Logic as per Business Rules BR's
• Wrote many consistency queries to find/correct the data mismatch
• Involved in impact analyzing the requirement specification of the system

Confidential

Role : SQL developer

Environment : SQL Server 2005, Ramco virtual work RVW and Crystal Reports 11.0

Roles and responsibilities

• Provided technical support to implement Ramco ERP solution
• Created databases objects including tables, indexes, applied constraints, views, user defined functions, stored procedures and triggers
• Involved in Query optimization and performance tuning.
• Developed many reports in finance module using Crystal Report 11.0
• Worked in customization of the product and defect fixing.
• Tested the application as per the test cases
• Responsible for implementing the Business Logic as per Business Rules BR's
• Written many consistency queries to find and correct the data mismatch
• Involved in impact analyzing the requirement specification of the system

Confidential

Role : SQL developer

Environment : SQL Server 2000, ASP 3.0, Java Script

• Created databases objects including databases, tables, indexes, applied constraints, views, user defined functions, stored procedures and triggers
• Designed and developed web pages
• Involved in report development
• Worked in customization of the product and defect fixing.
• Tested the application as per the test cases
• Responsible for implementing the Business Logic as per Business Rules BR's
• Involved in impact analyzing the requirement specification of the system