SUMMARY

• Having 8+ years of IT experience in Database Design, Data Modeling, Requirements Analysis, Application Development, and Testing, Implementation and Deployments using SQL Server 2005/2008/2008 R2 /2012and some DB2 experience.
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements.
• Experience in migration of data using Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in developing, configuring and deploying the SSIS packages and providing securityfor the packages.
• Good experience in working with SSAS in creating cubes, named queries, data source views, dimensions and deploying of analysis services projects.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas
• Experience in creating different kinds of reports like Drill down, Drill through, Sub Reports, Parameterized reports and Charts
• Experience in developing various kind of complex reports includingCascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experience in implementing different types of Replicationmodelslike Snapshot, Transactional and Merge Replication.
• Good experience in creating and maintaining Documents for future needs.
• Hands on experience with Load Testing, Integration Testing and User Acceptance Testing (UAT).
• Having good knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), and Bug Life Cycle (BLC)/Defect Life Cycle.
• Extensive experience in performing different types of Functional test activities like System testing, Regression Testing, Smoke Testing and Adhoc Testing
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
• Experience as a QA Test Engineer, coordinating and managing teams across 2 locations, e.g. teams of 8-10 people. Excellent understanding of QA processes, methodology and Testing Concepts.

TECHNICAL SKILLS

Databases: SQL Server2012/2008R 2/ 2008/2005/2000 , DB2, MS-Access

Database Tools: Management Studio, Enterprise Manager, SSIS, SSRS

Data Modeling Tools: Erwin, Microsoft Visual Studio 2008/2005, VISIO

Languages: C, T-SQL, PL-SQL, VB.net

Operating System: Windows 2008/2003 Server (32/64 bit), Windows 2000 DatacenterWindows XP, Vista,Windows Server 2003/2008

Architecture: Relational DBMS, Client-Server Architecture and OLTP

Management tool: Quality Center, JIRA, CVS, MS TFS

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL developer/SSIS/SSRS

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created SSIS packages to load data from one database to another database, from excel to SQL Server DB.
• Developed SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Strong SQL Server 2008/2005/2000 Developer Skills including writing stored procedures, user defined functions, views, triggers, CTE (Common Table Expressions).
• Performed tuning on Stored Procedures, Triggers and Functions over performance issues
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Writing Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Fixed Data related issues to resolve front end errors.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Installed and Configured SQL Server Reporting Services (SSRS).
• Developed and Managed Report in SSRS (SQL Server Reporting Services).
• Created and Managed Securities for Reports.
• Developed Reports for different purposes like DBA Reports, Health plans, Renewalplans, Factorsresponsible forplans, user reports using SSRS.
• Strong experience on user management, assigning permissions & roles and scheduling reports.

Environment: DB2 (Version 10), DB2 (Version 10.1), SQL Server 2008 R2, SQL Server 2012, VB Script, Windows 2003/2008, SSRS

Confidential, VA

SQL developer/SSIS/SSRS

Responsibilities:

• Involved in Requirements Gathering to define data requirements for reporting warehouse.
• Coded the SQL Server stored procedures for the enhancements.
• Tuning and optimization of the stored procedures.
• Involved in the full life cycle of this enhancement (Analysis, Development, Implementation and Testing).
• Created databases, tables, relationships, constraints. Wrote SQL Queries, views, Stored Procedures for the interaction of transferring data to and from screens to the backend, at optimum performance.
• Enhancement involved implementation of SQL Server with the usage of Stored Procedures, SQL Execution Statistics / Plans and Optimizer for back end.
• Maintained the client's policies and customer databases.
• Worked with all database objects, including tables, clusters, indexes, views, and procedures.
• Developed and implemented the SQL Server Integration Services (SSIS) packages to
• Populate the data into the Enterprise Data Warehouse from various sources like Flat File Source, Excel Source into OLEDB Destination (SQL Server).
• Troubleshoot problems concerned with the databases, applications, and development tools.
• Created complicated reports like Parameter based Reports, Graphical Reports, Well-Formatted Reports, Drill-Down Reports, Matrix Reports, Chart and Tabular using SSRS 2005.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report
• Published the Reports using Report Manager.
• Created design specification documents for the new reports developed through SSRS
• Published ad-hoc reports through Report Manager
• Creation of logins and user ids and setting up privileges and procedures for protection of data.

Environment: Windows XP, Windows 7, Professional, SQL Server 2008 R2 /2012, VB Script,HTML, MS Visio.

Confidential, TX

Senior SQL developer/DB2

Responsibilities:

• Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation.
• Involved in mapping of the tables and columns used in the legacy AS400 Database.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Developed Stored Procedures, User-defined Functions, Views, CTE (Common Table Expressions), Global Temp Tables, adding/changing tables for data extraction, data load and transformations .
• Converted AS400, MYSQL existing Stored Procedures to DB2 Stored Procedures.
• Performing DBA functions, Installing, configuring and supporting database systems.
• Created complex SQL queries with Inner Join, Outer Join, Co-related sub-query with String function, Aggregate function, Date and Time function.
• Created indexes on selective columns to speed up queries.
• Using all kinds of SQL Constraints (Primary Keys, Foreign Keys, Default, Unique etc.).
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors, temporary tables, Joins etc. wherever possible.
• Helped in maintenanceof the Database and was involved in Analysis Phase and Testingphase.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with AdhocReports, drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports.

Environment: DB2 (Version 10),DB2 (Version 10.1), SQL Server 2008 R2,SQL Server 2012, VB Script, Windows 2003/2008, SSRS

Confidential, TX

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions) for ever changing complex business requirements.
• Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• I have extensively used SSMS for creating partitions in tables, ranking tables, writing nested queries, creating indexes, and cursors.
• Performance-tuned existing stored procedures with severe efficiency issues, making them more user friendly and run smother.
• Create new SSIS package to extract date from legacy Database to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Designed and implemented Data Integration and ETL processes with SSIS packages to make data available in Data Warehouse for reporting purpose.
• Developed, monitored and deployed SSIS packages.
• Involved in creating Data mappings and data models using ERWIN tool.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server

Environment: MSSQL Server 2008 R2 Enterprise Edition 2012, SQL Server 2005, T-SQL, SSIS Packages,Wind0ws 2003/2008,SSRS, SQL profiler, SQLServer Query Analyzer.

Confidential, Memphis, TN

Mssqlserver/SSIS/SSRS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Designed and created use case, class and sequence diagrams using UML.
• Expertise in all the installation and configuration issues of Microsoft SQL Server and Integrating Services and Reporting Services.
• Expertise in Server Management issues like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach.
• Performed data conversion from flat file into a normalized database structure.
• Extracted data from various data sources like Access, Excel, CSV and Oracle etc.
• Developed SSIS packages and scheduled them in SQL Server agent to run as per the request
• Data migration (import & export - BCP) from Text Files to SQL server.
• Prepared and documented Backup & Restore Plans.
• Supported Application Development team with any database issues, updates or new releases.
• Good Experience in deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Migrated data from text files and Excel spreadsheets toSQLServerdatabases using Integration Services (SSIS).
• Writing Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Experience in managing Alerts, notifications and Jobs through SQL Server Agent.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Experience in creation of logins, users and configuring permissions and assigning roles to users.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.

Environment: SQL Server 2008 R2/2008/2005, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net.

Confidential, Houston, TX

MS SQL Server/SSAS/SSRS/SSIS Developer

Responsibilities:

• Created reports on SSRS 2005.
• Built reports through Report Builder and Report Designer.
• Created reports using Report Model and applying row level security filters.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Studied the existing OLTP system(s) and created Facts, Dimensions and star schema representation for the data martusing SQL Server Analysis Services.
• Designed and developed OLAP Cubes in SSAS.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS).
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Used T-SQL for creating stored procedures, indexes, cursors and function.

Environment: MS SQL Server 2000/2005/2008 , T-SQL, DTS, SQLServer Enterprise Manager, SQLServer Query Analyzer, SQL Profiler, SSIS,SSAS,SSRS

Confidential

SQL Developer

Responsibilities:

• Provided database design support for new system development and set SQL standards for object names and usage.
• Developed physical data models and created DDL scripts to create database schema and database objects.
• Worked on Visual source safe to manage project version and source code changes.
• Involved in unit testing of complex T-SQL code to validate the code.
• Created DDL, DMLscripts, stored procedures and triggers according to the requirement and designed ad hoc queries on the database tables.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• Wrote T-SQLstatements to ensure data consistency by filtering corrupt data and implemented variousconstrainsandtriggersto preserve data integrity.
• Developed effectivestoredprocedures, functionsto implement business logic.
• UsedBCPto move in or out data from different sources.
• UsedBulk Inserttocopy large amount of data into database.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Performed data conversion from flat file into a normalized database structure.
• Done High Level Design of ETL using transformations in SSIS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat files, Text Format Data).
• Migrated data from text files and Excel spreadsheets toSQLServerdatabases using Integration Services (SSIS).
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Provided technical guidance and support to end-users by developing documentations required.
• Documented all database changes, followed and enforced change and release management processes.

Environment: Mssqlserver2005, SQL Server 2008, Windows XP, T-SQL, SSIS, VisualStudio and VB Script.

Confidential

Quality Analyst

Responsibilities:

• Involved in Test case preparation and Bug reporting.
• Performed System testing and documented the Test procedures.
• Involved in Regression testing and retesting of the Application.
• Participated in Review meetings.
• Developed test cases on for the new server apps
• Knowledge transfer for new joiners.
• Logged good number of regression bugs in PS (Bug logging tool like QC).
• Participated in reviewing the test results using SQL Server on backend.
• Actively participated in Package analysis.
• Worked as a component owner for SHIM.
• Worked as a component owner for WMP.
• Preparing weekly reports of the team by collecting and analyzing data trends using the SSRS
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Used T-SQL for creating stored procedures, indexes, cursors and function

Environment: Windows XP, Windows 2000Professional, Vista, Windows Server 2003, Mssqlserver 2005.