SUMMARY:

• 9 years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2012/2008R 2/ 2008/2005/2000 system in OLTP and OLAP environment.
• Experience in the entire phase of Software Development Life Cycle (SDLC) that includes Analyzing, Designing, Developing and Testing of data.
• Experience with design and implementation of Star Schema and Snowflake Schema Dimensional models.
• Experience in Data modeling like Logical data modeling and Physical data modeling.
• Extensive experience developing and implementing Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS) and Microsoft SQL Server Reporting Services (SSRS) for data warehouse and data mart solutions.
• Extensive experience in writing and debugging complex Store Procedures, Cursors, Triggers, Inner Joins & Outer Joins, Views and User - defined functions (UDF) and Optimizing complex Transact-SQL queries.
• Experience in Migration of DTS packages to SSIS and Executing DTS packages from SSIS.
• Experience in creating packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files and OLEDB source systems.
• Experience in implementing SQL Server OLAP services (SSAS) for building the data cubes.
• Experience in creating new reports and ad-hoc reporting in SQL Server Reporting Services (SSRS).
• Good knowledge with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Excellent communication skills that have been put in use to understand client business requirements and converting the same into system fulfilling business needs.
• Experience Working with Development and Production 24/7 Environments including scheduled emergency night and weekend work.
• Troubleshoot and minimize production down issues.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008/2005 /2000, Oracle 10g/9i/8i, DB2, TeradataMS Access, Sybase

Languages: T-SQL, PL/SQL, C, C#, UNIX shell scripts, XML, HTML

ETL Tools: DTS, SSIS, Informatica V8

Reporting Tools: MS Reporting Services, Crystal Reports XI, Business Objects XI r2, Cognos

Database Tools: PL/SQL Developer, TOAD, SQL-Navigator, SQL*Plus, Test Director, Win Runner

Data Modeling Tools: Physical and Logical Data Modeling using ERWIN and MS Visio

Operating Systems: Windows NT, Windows 2000, XP, UNIX

.NET Framework: MS VISUAL STUDIO 2005/2010/2012 , C#.NET, ADO.NET

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

Application Developer

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Identifying the Change Data Capture mechanisms and statistically validating for the truthful synchronization of changed data using time based changed data identification.
• Extensively involved in creating and maintaining database objects such as Indexes, Views, Triggers, Stored Procedures and User Defined Functions in T-SQL and debugged them.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, Excels to and from SQL Server 2008/2012 with high volume data.
• Created SSIS Packages for daily Data Cleansing and Load Process. Imported data from Text Files, Excel Spreadsheets and OLEDB sources into SQL Server 2005 databases using SSIS.
• Migration of data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
• Identified the Data Integrity validation mechanisms and synchronization validation mechanisms.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Scheduled the SSIS package for migration of data from an old system to MS SQL 2008/2012.
• Worked Extensively with SSIS to Import, Export and Transform the data between the servers.
• Involved in Query Optimizations and Performance Tuning for the Stored Procedures.
• Configure SSIS Package for run time Parameters and Configuration file.
• Worked in creating the consolidated script for reporting schema creation, table relationships establishment and indexing for performance improvements.
• Analyzed database performance with SQL Profiler and DTA to optimize existing stored procedures and did performance-tuning of indexes to enhance performance of scripts and stored procedures.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Environment: MS SQL Server 2012/2008/2005, SQL Server Integration Services (SSIS), SSRS, T-SQL, ASP.NET, XML, Windows 2002, Team Foundation Server.

Confidential, Herndon, VA

SSIS Developer/DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Working with development and systems teams to perform application and database tuning.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Extensively involved in creating and maintaining database objects such as Indexes, Views, Triggers, Stored Procedures and User Defined Functions in T-SQL and debugged them.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Monitored and modified Performance using execution plans and Index tuning.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Expert with ETL tools along Informatica. Worked on huge applications on Informatica.
• Good experience in data modeling and metadata services.
• Worked Extensively with SSIS to Import, Export and Transform the data between the servers.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, Excels to and from SQL Server 2008 with high volume data.
• Created SSIS Packages for daily Data Cleansing Process. Imported data from Text Files, Excel Spreadsheets and OLEDB sources into SQL Server 2005 databases using SSIS.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS and also used BCP and Bulk Insert.
• Involved in Query Optimizations and Performance Tuning for the Stored Procedures.
• Worked in creating the consolidated script for reporting schema creation, table relationships establishment and indexing for performance improvements.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).

Environment: MS SQL Server 2012/2008/2005, SQL Server Data Tools, SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL, OLAP Services, Share point 2007, Oracle 10g, ASP.NET, XML, Team Foundation Server.

Confidential, West Chester, PA

SQL Developer/SSIS Developer

Responsibilities:

• Test programs or databases, correct errors and make necessary modifications.
• Work as part of a project team to coordinate database development and determine project scope and limitations.
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases.
• Designed store procedures using dynamic SQL.
• Designed SSIS packages to be Table driven, so that any further enhancements were done, it would be an update in a table level rather than being in package level.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, and Triggers to implementing the business rules and transformations.
• Responsible for the design, development and implementation of mappings /transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions.
• Migration of existing current FOXPRO systems to SQL to generate report files for the business.
• Create new ETL applications to automate the process of generating report files for the business.
• Support existing ETL applications in a complex database environment.
• Design and create batch programs in SSIS ETL for file transfer, and data movement across databases.

Environment: MS SQL Server 2008R2/2008/2005, SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL, OLAP Services, Oracle 10g, Active X, ASP.NET, XML, Windows 2002, Team Foundation Server.

Confidential, Windsor, CT

SQL Developer/SSIS Developer/DBA

Responsibilities:

• Installation of SQL Server 2005 and 2008 Configuration and Maintenance
• Defined various Check Constraints based on the applied Business Rules.
• Involved in Migration and support of application database from SQL Server 2000 to 2008.
• Created Views, Parameterized Views, Partitioned Views and Indexed Views.
• Created Clustered and Non Clustered Indexes on tables, views, and columns.
• Involved in Data modeling, designing and building relational databases.
• Verify, maintain & troubleshoot database backups, integrity checks and scheduled jobs.
• Creating and managing schema objects such as tables, views, index, and procedures.
• Installation of Replication Server, Configuration and Monitoring the replication, implemented Transactional Replication, Merge and Snapshot, writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
• Successfully Upgrading of SQL Server 2000 to SQL Server 2008 on Development, Testing and Production Environment.
• Upgraded DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
• Development of system maintenance tasks such as Database Backup & Recovery, replication and apply in Dev and Testing Environment.
• Assign permission to user(s), roles), and object. Administrate security for server logins (Windows and SQL Accounts).
• Daily monitoring of the database performance, SQL jobs, Dead lock and network issues.
• Identifying the bottlenecks and troubleshooting it for optimal performance.
• Supported developer to write and debug SSIS packages.
• Developed mappings and transformations based on business logic then scheduled and tested them.

Confidential, Columbia, MD

SQL SERVER DEVELOPER, SSIS DEVELOPER

Responsibilities:

• Designed the migration strategy, test plans and scripts to verify data and migrated databases from SQL Server 2000 to SQL Server 2005-2008.
• Installed & configured database software, associated database tools and performance monitoring software.
• Planned, designed and implemented application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Conducted data profiling and data reporting in support of the IT's data filtering project. Design, develop, unit test, and support ETL mappings and scripts for data marts using PL and SQL in Windows environment.
• Extensively involved in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
• Assisting the systems analysts in source data analysis and in creation of the functional specification documents.
• Responsible for the design, development and implementation of mappings /transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions.
• Development of system maintenance tasks such as Database Backup & Recovery, replication and apply in Dev background and Testing Environment.
• Developed mappings and transformations based on business logic then scheduled and tested them.
• Designed complex packages for ETL to transfer data from various sources like Text Files, SQL Server, OLE DB, Excel and Access to SQL Server 2005-2008.
• Created SSIS packages that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks
• Implemented error handling and roll back process in ETL load
• Used check points in SSIS for huge data loads
• Used expressions and variables in SSIS to make load dynamic
• Involved in Enterprise level Data Warehouse design by analyzing business requirements
• Written Views, functions and stored procedures for the UI.
• Designed table structure’s, stored procedures such that saving and retrieving the data to support Excel UI for the future planning.
• Written complex stored procedures, DML After and Instead of Triggers, User defined functions and optimizing the code to the best extent.
• Extensive testing on the performance and execution plan of the Complex Stored Procedures for better performance in inserting and deleting the rows from Tables.
• Captured and saved the shipment data from different sources of shipment types using SSIS.
• Provided 24 X 7 supports to all production, development, staging and clustered servers.
• Worked extensively in tuning SQL and Stored procedures, identifying and resolving performance tuning issues.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: ASP.NET, ADO.NET, XML, VBA, T-SQL, SQL Server 2005, SQL Server 2008, SSIS, SSRS, SSAS, SSCM, Agile, SFDC.

Confidential, Dover, DE

SQL SERVER DEVELOPER, SSIS DEVELOPER

Responsibilities:

• As a member of BI/Database team, Involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Written complex stored procedures, DML After and Instead of Triggers, User defined functions and optimizing the code to the best extent.
• Extensive testing on the performance and execution plan of the Complex Stored Procedures for better performance in inserting and deleting the rows from Tables.
• Involved in usage of various SSIS components like for loop, Foreachloop, FuzzyLookup, FTP, Variables, Error Handling etc.
• Experience in Writing Complex SSIS Process across heterogeneous sources like Oracle, SQL, DB2,FlatFile, Excel
• Used SSIS packages to move logins and jobs from one server to another server.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Transformed and manipulated the data by using SSIS transformations and tasks.
• Responsible for downloading files from FTP trading sites using SSIS FTP task and load into database tables.
• Created trace in SQL profiler and used Data base engine tuning advisor for Performance tuning on store procedures and scripts.
• Excel in creating in complex SSIS packages.
• Created summarize reports using SSRS Report Designer.
• Created Tabular and Matrix reports using SSRS.
• Assisted in the conversion / migration of SQL Databases / creating Data Cubes/ Reporting / ETL / OLAP (for sales force & financial team).
• Experience in manufacturing/Distribution and / or financial applications.

Environment: MS SQL Server 2008/2005/2000, MS- Visual Studio 2005, T-SQL DTS, SQL Server Integration Services (SSIS), Performance Point Server, Agile, SFDC, BIDS, ProClarity, Erwin, Asp.net, C#.net, ADO.net.

Confidential, Irving, TX.

SQL Server Developer

Responsibilities:

• Designed and created Databases, Tables, Views, Stored Procedures and Triggers.
• Worked closely with Business Analyst for better understanding business requirements.
• Highly used T-SQL for developing complex Stored Procedures, Triggers and User Defined Functions.
• Created new Stored Procedures to implement business logic.
• Setting up database backup and recovery procedures for development.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Transformed and manipulated the data by using SSIS transformations and tasks.
• Created summarize reports using SSRS Report Designer.
• Created Tabular and Matrix reports using SSRS.
• Created cubes when necessary to extract some related data quickly by using SSAS.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Involved in tuning the SQL queries using SQL Profiler.
• Optimized Stored Procedures and long running queries using query-optimization techniques.
• Coordinated with .Net programmers in writing stored procedures.
• Used DTS Migration Wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Migrating SQL Server 2000 DTS Packages to SSIS Packages for uploading various formats of files and data from the legacy databases and SQL Server 2000 to MS SQL Server 2005 Data warehouse using SQL Server Integration Services (SSIS).
• Responsible for keeping system and databases up-to-date by making necessary changes.
• Involved in Server & DB Monitoring and tuning efforts using various tools like Performance, SQL Server profiler, Index Tuning.

Environment: Windows 2003 Server, Agile, MS SQL Server 2005/2008, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker

Confidential

Programmer Analyst

Responsibilities:

• Involved in installation and configuration of SQL server 2000 on Servers.
• Applied patches and service packs to keep the database at current patch level.
• Design/Build Extract Transform Load procedures in SQL Server 2000 to import/export data feeds to/from data warehouse, Flat Files and Excel source files.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database and implemented stored procedures and Cursors according to the requirement.
• Implemented database standards and naming convention for the database objects.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Going through the clients' requirements and coming up with database design and application architecture.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Involved in resolving Dead Lock issues and Performance Issues.
• Experience in using dynamic management views (DMV) and dynamic management functions (DMF) for finding out long running queries.
• Integrated SQL traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Expert in implementing the snapshot isolation and DDL triggers.
• Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Querying of source and target database for unit testing.
• Involved in optimizing code and improving efficiency in databases including assigning proper index Re-indexing, Recompiling stored procedures and performing other maintenance tasks
• Generated reports using Crystal reports.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.
• Maintaining User account administration for Different domains.

Environment: SQL Server 2000, DTS, T-SQL, Crystal reports7, Windows 2000 Server, VSS 4.0.