SUMMARY

• Over 9 years of IT experience in Sr.SQL Server Developer/Team Lead, Design, Development, System Analysis and Support of MSSQL Server 2008 R2, 2005, 2000, 7.0, MS - Access in Development, Test, Production and Replication & Cluster environments.
• Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).
• SQL Server Reporting Services (SSRS).
• Knowledge of Relational Database Management systems and Data Modeling.
• Worked on configuring Service Broker for message Queuing system.
• Experience in Database Backup, Logshipping, Replication Recovery and Disaster Recovery procedures.
• Experience with Data Transformation Services, Batch processes, Import/Export and Backup/Restore.
• Experience in Performance Tuning, Query Optimization, Client/ ServerConnectivity, Database Consistency Checks using DBCC Utilities.
• Hands on experience in Troubleshooting database issues.
• Experience in writing and debugging Stored Procedures, Views, triggers, Functions using T-SQL Scripts
• Extensive experience in creating business, functional and technical documentation.
• Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server 6.5, 7.0,2000, 2005 and 2008, 2008 R2, MS Access 2000/97and Oracle.

Programming: C, C#, C++, Java, Java Script, COBOL, ASP, HTML and Visual Basic

Operating Systems: Windows 2000, Workstation, Windows NT/XP/95/98, MS DOS, UNIX

Applications: MS Office, MS Visio, Dream Weaver

Tools: Erwin, NetIQ, Clustering, Remedy, NT Performance monitor/System monitor, TSQL, SQL Profiler, SQL Query Analyzer, OSQL

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia

Sr SQL Server Developer

Responsibilities:

• Involved inGatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in Designing Dimensional Modelling specially Star Scheme.
• Involved in creating Cubes and Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic reports from cubes using Expressions.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in creating strategies for Backup and Restore of Prod databases.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving the server performance
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in production support for all kind of technical issues.

Confidential, Seattle

Sr SQL Server Developer

Responsibilities:

• Involved inGatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in creating package for icremental loading of data from source to destination tables.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in BCP in and out of data from one environment to another environment.
• Involved in creating Dynamic and parameterized reports using expression and mdx query from cube.
• Involved in improving the performance of cubes by creating aggrgations, partition of cube.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in production support for all kind of technical issues.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created the backup schedule for production, test and development servers.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving the server performance
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.

Confidential, Dayton, OH

Sr SQL Server Developer

Responsibilities:

• Involved in Gathering Business Requirements, Impact Analysis and Technical Specification Documentation.
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in writing package for incremental load to the datawarehouse.
• Involved in creating and development of cubesand hierarchies between there attributes.
• Involved in improving the performance of cubes by parition and creating aggreation of cubes.
• Involved in creating paramertized and Dyanamic reports using expressions from cube.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in creating Table Partitioning for large tables by Partition Schemas and Partition Functions
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in creating indexes (Clustered and Non Clustered) for improving the server performance
• Involved in creating strategies for Backup and Restore of Prod databases.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in production support for all kind of technical issues.

Confidential, Columbus, OH

SQL Server Developer

Responsibilities:

• Involved in migration of 2000 Databases to 2005 Databases. Migration include the migrating the SQL 2000 DTS packages to SQL server 2005 SSIS packages
• Created Packages for synchronization of Production Databases to UAT, SIT, DEV Databases, Tables comparison, Row-by-Row comparison.
• Involved in Tuning Store Procedures and query optimization for SQL server 2005
• Involved in Creating and Altering Tables, Triggers, Views, Stored Procedures, Functions and Indexes.
• Involved in creating Table Partitioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non Clustered) for improving the server performance
• Involved in Database tuning by using DTA (Database Tuning Advisor) and other third party tools
• Involved in creating designing parameterized reports using datasets and expressions.
• Involved in creating reports both Custom and Matrix by SSRS.
• Involved in deployment of code in all the environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Involved in creating strategies for Backup and Restore of Prod databases.
• Experience in improving SQL Server performance by using Index tuning wizards, performance Tuning methods, execution plans and profilers.
• Experienced with creating database maintenance plans for efficient operations.
• Involved in Mirroring of Production Server to UAT server for transactional updates.

Confidential, Seattle, WA

SQL Server Developer

Responsibilities:

• Gathering business requirements from users and doing impact analysis and delivering it to the offshore team for development
• Reviewed code and deployment guide prior to release to testing team.
• Involved in deployment of code in all the environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Involved in production support for all kind of technical issues.
• Involved in migration of existing Application from 32 bits to 64 bits environment including installation of Performance Point Server 2007 (PPS).
• Created dimensions and Hierarchies in Performance point server for user interface and loading the data at SQL server Backend through SSIS packages.
• Involved in Designing Dimensional Modelling specially Star Scheme.
• Involved in creating Cubes and Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic reports from cubes using Expressions.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Resolved bugs during testing cycle of application.
• Involved in development of features like optimization, security, and audit log in existing application.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Created a POC and given presentation on Master data management (MDM) to business users as a future implementation for the current Performance Point (PPS) application.
• Worked on SQL Server Integration Services Packages(SSIS) and PPS for loading the data into the SQL Server databases.
• Monitored and created tasks and bugs in MS visual studio Team Foundation Server (TFS, also VSTF) and assigned to proper authorities (offshore development team, test team, etc).
• Involved in analysis the data to be loaded to the PPS through PPS commands.
• Involved in smoke testing in UAT (User Acceptance Testing) for final sign off
• Performed impact analysis during design changes in upstream and downstream systems.
• Design the application context diagram using MS-Visio tool Installed, configured and maintained

Confidential, MO

SQL Server Development Lead/Developer

Responsibilities:

• Involved in Gathering Business Requirements, Impact Analysis and Technical Specification Documentation.
• Involved in creating SSIS packages forloadingdata from data source (oracle or sql database) to Staging database followed bymigrating the data to ODS (operation data source) and finally to PDS (productiondata source)
• Create database objects in SQL Server 2005 including Tables, Triggers, Views, Stored Procedures, Functions and Indexes.
• Involved in deployment of code in all the environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Involved in production support for all kind of technical issues.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Experienced with SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.
• Experienced with creating database maintenance plans for efficient operations.
• Created the backup schedule for production, test and development servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Resolved bugs during testing cycle of application.

Confidential, NC

SQL Server Developer

Responsibilities:

• Involved in gathering business requirement and impact analysis.
• Created and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Involved in Designing Dimensional Modelling specially Star Scheme.
• Involved in creating Cubes and Hiearchies between different attributes and Dimension.
• Involved in Creating paramerterized as dyanamic reports from cubes using Expressions.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in production support for all kind of technical issues.
• Involved in upgrading from SQL Server 2000 to SQL Servers 2005 and test the application after the upgrade, make sure everything is working fine.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Involved in creating SSIS packages for loading incremental loading to full Loading.
• Created the DTS packages to import the data from MS Access and Oracle server to SQL Servers. .
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the backup schedule for production, test and development servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.
• Involved in creating backup strategy production, test and development servers.
• Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Document server and database policies and procedures.
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.

Confidential, OH

SQL Developer/DBA

Responsibilities:

• Involved in gathering the client requirements, Technical documentation and impact Analysis.
• Created Store Procedures, Triggers, Functions, and Indexes as per the requirement.
• Involved with testers during the deployment of code in all phases (SIT, UAT, and PROD) of environments.
• Involved in production support for all types of technical issues.
• Involved in creating Deployment guide for deploying code.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Experienced with SSIS packages, SSRA and SSAS features in SQL Server 2005 servers.
• Experience in upgrading from SQL Server 7.0 to SQL Server 2000 servers and SQL Server 2000 to SQL Server 2005.
• Created the DTS packages to import the data from MS Access and Oracle server to SQL Servers.
• Experienced with creating logical and physical database design for development projects.
• Involved in securing the SQL Server environment and involved in setting up the user permissions.
• Experienced with creating database maintenance plans for efficient operations.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Experienced with SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio..
• Worked with the database schema changes and database restore requests.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced with creating change management tickets for production and test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Confidential

MS SQL Developer

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2000/7.0
• Performed all aspects of database administration, including data modeling, backups andrecovery. Performance Tuning and monitoring.
• Expertise in Security Issues such as creation and granting permissions on various Objects
• Responsible for MS SQL Server 2000, configuration, tuning and provide 24 X 7 dedicated support to all 95 Production, development and clustered servers
• Additionally, designed and implemented a disaster recovery system.
• Designing and Optimizing all the DTS packages
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created the logical and physical data modeling using Erwin tool.
• Configured Log shipping from one production server to the reporting server.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Upgraded from SQL 6.5, 7.0 to SQL 2000.
• Assist with DBA to optimize the SQL queries and stored procedures.
• Used different environment included Development, Staging, Testing, and Training & Productions for Implementations

Confidential

SQL Developer/DBA

Responsibilities:

• Involved in gathering the client requirements, Technical documentation and impact Analysis
• Involved in Production support for all types of technical issues.
• Created Logical & Physical Database Design, Data Modeling using Erwin tool.
• Created database maintenance plan for SQL Server backups, optimization, integrity check and transaction log backups.
• Responsible to execute SQL Server DBAs team, Capacity planning, sizing, monitoring Disk I/O, Server Rebuild & migration.
• Experienced with SQL Server performance improvement and optimize the databases. Involved in performance tuning and index tuning.
• Work with business team to implement the business rules and developed logical and physical database design.
• Created the Standards for SQL Server environment.
• Created the backup and restore strategy for production, development and test environments.
• Monitored production server’s activity, scheduled jobs, SQL Server Error Log, space usage.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Responsible to convert MS Access 2000/97 databases into MS SQL Server 2000 databases.
• Installed SQL Server Analysis Services and developed the OLAP cubes.

Confidential

SQL Server Developer

Responsibilities:

• Involved in gathering the users requirement and technical documentation
• Created Logical and physical data modeling for databases using Erwin.
• Installed and configured the transactional replication for 2 environments.
• Installed, configured SQL Server 7.0 and 2000 on windows 2000 server platform.
• Upgraded the MS SQL Server 6.5 to SQL 2000.
• Responsible for User administration and granting permission to application users.
• Involved in creating tables, indexes, stored procedures and triggers.
• Optimized the database to improve the performance, helped the SQL Server developers to tune the Queries.
• Involved in database backup and restore operations.
• Imported the data to MS SQL Servers using DTS Packages.
• Used DBCC commands to check the consistency of the databases.
• Created the documentation for production server changes.