- Over three years of professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2012/2008R2/2008/2005.
- Ability to deliver comprehensive Business Intelligence through integration of BI suite of products SSIS SSRS including MS solutions like MS EXCEL 2007/2010 Microsoft Office.
- Strong Experience in various Extracting Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
- Excellent in writing T-SQL working on DTS SSIS SSRS also created Indexed Views complex Stored Procedures Triggers and effective functions.
- Highly Proficient in T-SQL DDL/DML perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
- Experience in report writing using SQL Server Reporting Services SSRS and creating various types of reports like table matrix and chart report web reporting by customizing URL Access.
- In depth understanding of SQL Server Migrations and problem management.
- Good experience in using tools such as SQL Profiler Index tuning Windows Performance for monitoring and tuning MS SQL Server performance.
- Having excellent communication skills analytical skills and understanding of business requirements in various domains.
TECHNICAL EXPERTISE MSSQLServer2012/2008R2/2008/2005 SSRS SSIS MS-Access 2000 MS Excel Erwin Crystal Report Oracle T-SQL PL/SQL HTML XML VB Script C Windows NT/ 2000 Server/XP
SQL Server Developer
- Worked with business application developers production teams and across functional units to identify business needs and discuss solution options.
- Participates actively in all phases of system development including planning and analysis design development and testing.
- Deliver Business Model logical and physical data models using Erwin and also responsible for Forward Engineering in Data Modeling design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
- Generated Database Objects like Stored Procedures Triggers Functions Indexes Views and Constraints by using T-SQL environment to create complex scripts and batches.
- Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
- Pushed all the created store procedures and functions to the development training and production servers.
- Maintains application performance and scalability with a focus on performance tuning SQL queries table design indexing query plan analysis.
- Created trace in SQL Profiler and used Database Engine Tuning Advisor DTA for Performance tuning on stored procedures and Scripts.
- Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
- Migrated data from different sources text based files Excel spreadsheets and Access to SQL Server databases using SQL Server Integration Services SSIS .
- Worked with Tabular reports Matrix reports Parameterized reports Sub reports Drill down reports according to business requirements in time restricted environment using SQL server reporting services SSRS 2008.
- Provide support to BA/SA/QA teams to verify data and provide data profiling related analysis.
- Work with the QA team to create SQL based queries to validate data and provide support.
- Communicate effectively both in writing and verbally.
Environment MS SQL Server 2008 MS SSRS 2008 MS SSIS 2008 T-SQL Windows Server 2007 Erwin 8.0
SQL Server Developer/.NET Developer
- Developed the functional specifications from the business requirements.
- Analysis and design of databases and user interfaces.
- Designed the front-end navigation and user authorization system.
- Designed the GUI using .NET.
- Developed complex T-SQL code for the application.
- Designed and implemented processes for deploying upgrading managing and extracting data for reporting.
- Tested to optimize the Stored Procedures and Triggers to be used.
- Monitored performance and optimized SQL queries for maximum efficiency.
- Developed ADO.NET code to access the database for different SQL queries views and procedure.
- Developed daily reports using Crystal Report
- Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
- Planned Backup strategy based on projects requirements.
Environment ASP.NET VB.NET Web Forms PL/SQL ADO.NET IIS XML XSLT
Visual Studio 2003 2008 SQL SERVER 2005 Windows 2000 HTML.