Madhavi Khairnar

SQL Server Developer

Contact no: 609-***-****

Email: tdap9l@r.postjobfree.com

PROFILE:

• 5+ Years of Total IT Experience

• 5 Years on SQL Server Experience

• Strong Experience on SSIS and SSRS.

SUMMARY:

• Overall 5+ Years of experience in Information Technology with proven skills in software development, 5 years of development experience in Database Design and Development in SQL Server 2008/2005/2000 system in OLTP environment.

• Expertise on MS SQL Server 2005/2008/2008 R2.

• Highly proficient with SQL Server tools such as Management Studio, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Agent, DTS, SSIS and SSRS.

• Strong understanding of RDBMS concepts and expert level skills in Data Modeling, Data Mapping, Database Normalization, Optimization and Tuning.

• Expert level skills in Objects creation such as Tables and Views, Stored Procedures, User-Defined Functions, Indexes and appropriate Triggers to facilitate efficient data manipulation and consistency.

• Expertise in query optimization and performance tuning. Used performance tools such as Index tuning wizard, SQL Profiler.

• Experience with SSIS (SQL Server Integration Services) for data extraction, Transformation and loading. Experience using SSIS tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

• Data migration using across different databases like oracle, MS SQL, flat files, Excel etc.

• Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.

• Expertise in creating SQL Server Reports using SSRS.

• Highly experienced with SQL Server 2005/2008 installing and configuration, integrating with SSIS and SSRS.

• Interaction with the Users and Business Analysts for better understanding of the reporting requirements.

• Knowledge of Logical and Physical Database design & development, Normalization and Data modeling using UML data model.

• Knowledge of Data Warehousing concepts in SQL Server Analysis Services (SSAS) such as MDX, Cubes, Dimensional Models.

• SQL tuning for the SQL queries to improve the performance.

• Experience in scheduling and executing jobs through scheduler such as Autosys and SQL Server Agent.

• Experience in query optimization & performance tuning.

• Multiple views were created to reduce the complexity of writing procedures and increase database performance.

• Worked in Agile Iteration based and Waterfall model projects.

• Extensively worked on file transfer process such as FTP .

• Expert in business process engineering and software development life cycle, including analysis, design, development, testing and implementation of software applications.

EDUCATION:

. Bachelor’s in Management studies.

TECHNICAL SKILLS:

Relational Databases: MS SQL Server 2000/2005/2008/R2, SQL Server Management Studio (SSMS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Sybase, MS Access.

Tools and Packages: SQL, SQL Server Management studio, Query Analyzer, Enterprise Manager, Profiler, SSIS, SSRS, BIDS, MS Excel

Languages: T-SQL, SQL, C

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, UNIX

Web Technologies: HTML, XML.

ETL Tools: Data Transformation Services (DTS), SQL Server Integration services (SSIS)

Other Tools: MS Office

PROFESSIONAL EXPERIENCE:

Diversified Search, PA July’11-Present

Senior SQL Server Developer

Diversified Search is one of the top ten executive search firms in the United States. With experienced consultants, proven track record and global reach, uniquely qualified to give organization the leaders necessary to meet the challenges in your ever-changing market. In this project the clients look out was to develop a website, SQL Server 2008 was used in the back end development and support process to the database.

Responsibilities:

• Involved in gathering Requirements for Reporting Database, Scheduling Status review meetings, Document and Code reviews.

• Coordinating with offshore team for on time delivery of the products and query resolution activities

• Code Walkthroughs with Client, Resolving offshore queries and issues.

• Worked on T-SQL programming and SSIS package creation.

• Worked in developing and maintaining stored procedures and User defined functions for the data flows from OLTP Interfaces.

• Worked on SQL Server tools such as Management Studio, Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Agent, SSIS and SSRS.

• Worked on BCP, SSIS packages for MS SQL Server databases.

• Perform testing of jobs using Autosys scheduling system.

• Implemented full/bulk database export using IMPORT/EXPORT wizard and SQL Server Integration Services (SSIS).

• Worked in Database design, Data migration and transformation for the application.

• Worked on various Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions and database links in distributed database environment.

• Closely works with Business to help them in analyzing the data and providing an expertise in designing the requests to make the system more efficient.

• Build the SSIS package to move the data from different database servers.

• Worked on Pivots tables to balance the data.

• Support the maintenance request for the front end application.

• Handles the production support for the applications.

• Perform Import and Export of data from different sources such as Flat Files, Spreadsheets etc to MS SQL Server 2008.

• Performs System testing for all the modules and helps business in User Acceptance Testing.

Environment: MSSQL Server 2008, SQL Queries, T-SQL, SQL Server Management Studio, Business Intelligence Development Studio.

Bank Atlantic, Miami FL Apr’10-Mar’11 SQL Developer /SSIS, SSRS

Bank Atlantic is one of the oldest and largest South Florida based community bank. As a part of the project was to work on logical and physical design of database, work with other IT associates to design implement test, enhance stored procedures and other applications necessary to support systems and fileprocessing.

Responsibilities:

• Migration of database from SQL server 2005 to SQL server 2008

• Responsible for quick response of SQL statement and connectivity from front application to the database servers.

• Created Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.

• Created SSIS packages to load data from oracle to sql using various data transformations.

• Creation of checkpoints in SSIS package.

• Used SQL Server Agent for creating, maintaining and scheduling Jobs.

• Involved in the performance tuning and DB optimization of T-SQL queries.

• Created stored procedures, views, triggers, functions to incorporate the flow of business.

• Created tables, views, indexes, functions for databases.

• Created and maintained Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity.

• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS using BIDS.

Environment: Windows NT/2000, MS SQL Server 2008/2005, ETL, SSIS, SSRS, T-SQL, MS Excel, MS Access, MS Word.

Affirmative Insurance, Addison TX Sep’09-Mar’10

SQL Server Developer/SSIS, SSRS

Affirmative Insurance Services, Inc. handles the marketing, policy administration, claim and actuarial functions for certain insurance carriers. The objective of the project was to develop an application that helps the field agents of the company to enter prospective customer’s data. The application was also required to calculate the amount of Premium required cash value and benefit amount for the years in consideration.

Responsibilities:

• Developed Stored Procedures, and Views & Triggers to enforce the business rules.

• Created Indexes (Clustered & Non Clustered) to reduce data retrieval time.

• Fine tuned SQL queries to improve query performance and to reduce runtime.

• Automated backup (Full & script) processes for disaster management.

• Created and maintained Backups and recovery strategies and set up jobs/creating job schedules.

• Optimized long running Stored Procedures & queries for effective data retrieval.

• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files etc.

• Creation of check point in SSIS package at task level to enforce business rule/requirement

• Created reports, drilldown reports according to requirement and for day to day analysis purpose by creating store procedure and views and deployed them on SSRS server.

• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job task by using Scheduled Jobs and Alerts using SQL Server Agent.

• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).

• Created Report model for each report in Report Server for each report to help front end user to modify the report as per requirement.

• Generated several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).

• Built ad-hoc reports using SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008, Query Analyzer, Enterprise Manager, Index Tuning Wizard, SQL

(SSIS, SSRS), SQL Server Business Intelligence Development Studio, ETL, Windows XP, MS Excel, MS Access, MS Word.

Blue stone consultancy Ltd, INDIA Jun’07-Aug’09

MS SQL Server Developer

This system helps in calculating the contribution of the current sale and generates the costing Sheet of the Material based on the parameters feed in the MRP system. This system is integrated with other modules like (invoicing, stores, and production, Accounts, Payroll etc) to calculate the Parameter of the Budgeting Module. Costing contribution & Budgeting System helps MIS department to generate the budget for the next year.

Responsibilities:

• Co-ordinate with DBA’S for creating Users and Roles, and managed security and permission of database.

• Worked with business analyst to gather requirements for system enhancement.

• Developed stored procedures, functions, views and triggers.

• Actively participated in gathering of User Requirement and System Specification.

• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database.

• Create joins and sub-queries for complex queries involving multiple tables.

• Worked with business analyst to gather requirements for system enhancement.

• Involves in various performance tuning activities.

Environment: MS SQL server 2000, Enterprise Manager, Query Analyzer, Windows server 2000, SQL server Profiler, T- SQL,MS Access.

Contact this candidate