Professional Summary:

• 7 years of technical experience with high proficiency in MS SQL Server Development and various Business Intelligence tools BI like SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS and SQL Server Analysis Services SSAS . Production Support, implementation using Microsoft SQL Server SQL Server 7.0, 2000/2005/2008.
• Proven experience of Sql server database interaction with windows and web based application using ADO.Net, C and ASP.NET. Database Development and maintenance.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer
• Comprehensive knowledge of data base testing, rational data base concepts, and application interface testing
• In - depth knowledge of techniques and procedures of data validity and integrity testing
• Well versed in data integrity types, component testing, stress testing, and functional testing
• Test scripts developing on SQL queries with performance, developing bench mark queries
• Testing DB performance while loading the data and advising clients with necessary memory parameters changing to address the performance issues.
• Experience in architecting objected oriented application design using design tools such as MS Visio.
• Expertise in MS SQL Server installation, configuration, Development, T-SQL, client/server connectivity, building servers, troubleshooting, Query optimization.
• Worked in migrating databases in SQL Server 7.0 to that includes conversion of many DTS packages to SSIS.
• Database design, Entity Normalization, Experience with Master Data Management.
• Hands on designing report with complex sub reports, Cached Reports, Drill down, Drill through, Linked Reports, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, conditional hiding/formatting, mailing label, standard etc. using SQL Server Reporting Services SSRS .
• Migrating OLAP database from SQL Server 2000 Analysis Services to 2005 SSAS using the migration wizard.
• Good experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2000/2005/2008.
• Experienced Implemented and documented proactive monitoring scripts for production databases.
• Interact with 3rd party vendors, Data Warehouse Architects and project teams to trouble shoot production issues.
• enterprise best practices and objectives
• Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands in managing indexes and locks and troubleshooting deadlocks.
• Expertise in creating database maintenance plans and monitoring the jobs and generating alerts to be sent to the operators via email cell notifications using SQL Server Agent.
• Proven record of task achievement, ability to effectively multitask, meet deadlines, quickly adapt to different project environments and ability to work.
• Excellent verbal, writing and presentation skills and the ability to conceptualize and effectively document.

Technical Skills:

Operating Systems: Windows 95/98/NT/2000, UNIX, DOS, Windows Server 2003

SQL Server Tools: Management Studio, Enterprise Manager, SQL Profiler, Query Analyzer, Export Import, DTS, Replication, SSIS, SSRS, SSAS.

SQL Server DBA: Performance tuning, Stored Procedures, Capacity Planning

ETL Tools: Data Transformation Services DTS, MS SQL Server Integration Services SSIS, Export/Import

Database: MS SQL Server 2008, 2005, MS-Access97/2000/2003/2007, Oracle 10g, MySQL

Data Modeling Tools: Microsoft Visual Studio 2003/2005, Erwin 7.2/7.0, Microsoft Visio, DB Artisan

Programming: .NET, VisualBasic6.0, VBScript, T-SQL, HTML, UML

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Professional Experience:

Confidential

SSIS DeveloperAnalyst

• Kenexa has different clients and we deploy the product with enhancements made according the client requirements.
• A Kenexa technology is a solution provider for employee research, recruitment process automation, employee performance management and provides integrated business solutions for Human Resources. The company also provides recruitment enhanced process outsourcing and performance management solutions.
• Install and configure SQL Server 2008 2005 with Service Packs and Hot Fixes as per the Business Requirements in Production, Development Testing environments
• Work with different clients for building surveys as per client requirements and provide 24/7 support
• Performance tuning the SQL queries, creating indexes and updating statistics
• Using SQL/TSQL and Kenexa products for building survey and reports for different clients as per the requirements and internal team suggestions.
• Generating Reports, data subscriptions physical designs and designing complex reports using SQL Server Reporting Services SSRS .
• Create SSIS packages, design and monitor them, performance tune the packages.
• Test Data validation data types, procedure arguments, trigger validations,
• Troubleshooting Performance bottlenecks and deadlocks.
• Worked with various sources and target like relational files, flat files, excel and xml
• Created SSIS Packages to extract data from the DTR file format using ActiveX Script Task
• Run performance monitor, SQL profiler and other tools to monitor and report on database performance
• Worked with various sources and target like relational files, flat files, excel and xml
• Convert the DTS packages to SSIS and Migrate to the SQL Server 2008.
• Created users, application development and maintained the database, controlling user access right and managing data security
• Make the enhancements in the tools and provide the reports to clients.
• Troubleshoot the product deployment issues for the clients
• Develop benchmark queries for client using SQL/TSQL
• Data migration support from MS-ACCESS to MS-SQL Server 2008
• Document the procedure of deployment and train the end user/clients
• Actively participated in gathering User Requirements
• Routine tasks but not limited to: Proof of concepts, monitoring, performance tuning, building packages, Responding to users and developer issues

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, MS Access 2007, SQL Profiler, Diagnostic Manager, Windows Enterprises 2003 servers, Windows XP, Index Tuning Wizard, MS SQL Server performance dashboard, SQL ProgrammerDatabase Maintenance Plan Wizard, T-SQL, Excel, SQL Server Integration Services SSIS, DTS, Transact-SQL, IBM Fast T 700 Storage Area Network SAN .

Confidential

SQL BI Developer

• Install and configure SQL Server 2005 2008 with Service Packs and Hot Fixes as per the Business Requirements in Production, Development Testing environments
• Migrated all the database successfully to SQL Server 2005
• Developed packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services SSIS .
• Analyzed SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor
• Controlled user access rights and managing data security, Created users, application development and maintained the database
• Performed acceptance testing to verify that database changes perform without adverse consequences
• Creating, maintaining the users, roles and granting privileges
• Created new SSIS packages for transformation of data according to business
• Designing Reporting services SSRS reports or implementing data subscriptions physical designs and designing complex reports using SQL Server Reporting Services SSRS .
• Increased query performance, necessary for statistical reporting by more than 25 after using Execution plan, Performance Monitor, Profiler, and Index tuning wizard.
• Developed executed scripted changes requests in accordance with change control procedures.
• Managed security by defining roles and rights.
• Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
• Involved in performance tuning, code optimization, development using Visual Basic 6.0, ASP and COM
• Performed all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc.
• Migrated data from various sources such as MS Access, flat files etc.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes

Environment: SQL server 2005/2008, T-SQL, Enterprise Manager, MS-ACCESS, SSIS, SSRS, SSAS servers,, Cognos, Database Maintenance Plan Wizard, SQL Profiler, Performance Monitor,.Net Framework, ASP.NET, ADO, Windows NT, Windows-XP, MS-Office, PDF creatorConfidential

Software engineer

• Designed report with complex sub reports, Cross Tabs, Drill down, formulas, functions, parameters, scheduled reports, alerts, multiple grouping, running totals, Charts, graphs, mapping, multiple sections, conditional hiding/formatting, mailing label, standard etc. using Crystal reports
• Got trained in web technologies SQL Server 2005, SSIS, SSRS, DB maintenance, SQL Profiler, ADO,.Net framework, ASP.Net Ms-Visual Studio, Ms-Visual Source Safe, Crystal reports, and Involved in different maintenance projects/products.
• Involved in system requirements and the upgrade matrix for SQL Server 2005.
• Data modeling using MS Visio.
• Designed a Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.
• Installed SQL Server 2005 in Development Testing environments and applied service packs and patches successfully
• Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
• Create functional and technical specifications for project
• Migrated DTS packages to SSIS and modified using DTS editor wizard
• Created sophisticated SQL Server database to responsively handle complex queries T-SQL, DTS, triggers, stored procedures, functions, optimization and .NET data access components
• Performed business and system analysis, designed application and database structure, converted existing data into SQL Server using Data Transformation Services DTS and VBScript
• Developed packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services SSIS .
• Develop reports in SQL Server Reporting Services.
• Used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions CTEs and Triggers to facilitate efficient data manipulation and data consistency
• Configured Internet Information Services

Environment: MS-SQL Server 2005,, T-SQL, Enterprise Manager, SQL, T-SQL, SSIS,SSRS,.Net Framework, C, ASP.NET, ADO, IIS, Windows NT, Windows-XP, MS-Office,PDF, crystal reports 10, Ms-Visual studio, Ms-Visual source safe,