SUMMARY

• Professional experience on design, development and maintenance of database using tools of MSSQL Server 2008R 2/2008/2005/2000.
• Experienced in installing,upgrading and configuring the MS SQL Server 2008R .
• Extensive experience and in - depth working knowledge in various SQL Server tools and IDE to work with database, reporting and business intelligence based applications like SQL Server Management Studio,SQL Server Profiler,SQL Server Business Intelligence Development Studio,Visual Studio, and Query Analyzer.
• Experience in creating and maintaining SQL database, optimization, backup, restore, security and disaster recovery.
• Experience in performance tuning, query optimization, client/server connectivity and database consistency checks using DBCC Utilities, backup and recovery.
• Experience with T-SQL (DDL, DML, DCL) in implementing & developing user profiles, relational database models, creating & updating tables and checking the database consistency by executing DBCC Commands.
• Strong Understanding of installing, upgrading, troubleshooting and configuration of MS SQL Server 2008R 2 /2008/2005/2000 database.
• Excellent knowledge inRDBMSconcepts and constructs along with objects creation such asdatabase, tables using normalization concepts, UDF, user defined data type, indexes, SPROC, views, cursors and triggers.
• Expertise in creating and using stored procedures, views, and user defined functions.
• Expertise in creating sub-queries and joins for complex queries involving multiple tables, error handling and exception handlers.
• Experience in creating indexes, indexed views and observing Business Rules and creating effective functions and appropriate triggers to assist efficient data manipulation and data consistency.
• Experience in developing and monitoringSQL Server Integration Services (SSIS),Microsoft SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)projects.
• Comprehensively involved in DataExtraction and Transforming and Loading (ETL)usingDTS package in MS SQL Server 2000andSQL Server Integration Services (SSIS)in MS SQL Server 2005 with .NET, Import/Export data, Bulk insert and BCP.
• Hands on experience in developing Drill through and Drill down reports using SQLServer Reporting Services (SSRS).
• Experiencein developing user reports and management reports using MS SQL Server Reporting Services (SSRS).
• Experienced with Star and Snow-flake schema dimensional data modeling.
• Good experience in SQLdatabase design, architectureand datamodeling using Erwin.
• Experience in data warehouse modeling with SQL Server Analysis Service (SSAS).
• Experience in creation and deployment of cubes on SSAS and SSRS reports with cube as a source to the reports.
• Experience with Microsoft Team Foundation Server for source code control
• Organized professional withexcellent oral and written communication skills, fastlearner and also adapts quickly to new technology with ability to take on new roles in minimum time and little training.
• Ability to adapt and learn quickly, work individually as well as in a team withexcellent problem solving and trouble- shooting capabilities.

TECHNICAL SKILLS

Operating Systems: Windows 2000 Server, Windows 2003 Server, Windows NT, Windows XP, Windows Vista, Windows 7, MS SQL Server 2005

Components/Environment: SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Languages: SQL, T-SQL, VB. NET, C#. NET, C, C++, Windows Scripting

RDBMS: SQL server 2008/2005, Oracle, MS Access.

Application: MS Visio, Visual Studio, Team Foundation Server

Systems Familiarity: OLTP, OLAP.

Data Design/Modeling: ERWIN, MSVISIO.

Other Tools: Photoshop CS, Dreamweaver

PROFESSIONAL EXPERIENCE

Confidential, Carson City, NV

SQL Server Developer

Responsibilities:

• Worked on creating Data Warehouse as a part of the Strategic Prevention Expansion grant to the State of Nevada.
• Created Multi-dimensional star schema for strategic reporting and analysis requirements.
• Used Data Warehouse generator spreadsheets to automate the generation of data model and DDL scripts.
• Acted as a liaison between the development team and the business data team gathering requirements and demonstrating deliverables.
• Performed data analysis and profiling using multiple joins statements.
• Developed and deployed complex SSRS reports consisting of multiple parameters, data regions and drill down/through reports.
• Created reports for Nevada SAPTA dashboard to measure performance of the health service providers.
• Made enhancements and modifications to existing reports.
• Scripted complex T-SQL views and stored procedures for the reports.
• Created basic websites in ASP.net and embedded SSRS report in web-pages using ASP.net Report Viewer Control.
• Created Data models of the NHIPPS data systems using DB Wrench.
• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Performed maintenance tasks on SQL procedures, queries, tables on backend DB for the NHIPPS (Nevada Health Information Provider Performance System) application.
• Setup db replication from the production db server to operational data store (ODS) to reduce reporting load on the primary server.
• ETL: Extracted data from NHIPPS ODS and loaded the data into the Data Warehouse by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Implemented Bridge tables to facilitate many-to-many fact to dimension relationships.
• Used parameter driven C# scripting framework to automate the creation of SSIS packages which are similar eliminating repetition and saving time.
• Involved in performance tuning of queries, SSRS Reports and SSIS packages.
• Managed installation of SQL Server 2008 R2 in development and testing environments.
• Assisted the DBA in managing the production SQL server with missing indexes, keys and creating views.
• Helped create in-house Scrum project tracking system (based on SQL Server and SSRS) to track development team’s progress.
• Managed security access to SSRS reports.
• Used Team Foundation Server for source control.
• Used Continuous Integration with automated unit tests written through the practices oftest-driven development.
• Created robust Build Test harness (windows scripting) used for testing and software quality assurance.
• Fixed data consistency issues. Performed quality assurance and testing of SQL server environment.
• Wrote extensive explicit and in-line documentation for all design, development and deployment processes using MS Word, PowerPoint and Excel.
• Implemented effective knowledge transfer through frequent code reviews, demonstrations and presentations to the client.

Environment: MS SQL Server 2008 R2/2005, MS Business Intelligence Development Studio 2008 R2, SSRS, SSIS, SSAS, T-SQL, Team Foundation Server 2010, Visual Studio 2010, ASP. NET, C#, WindowsServer2008R2, Windows 7, MS Office 2007.

Confidential, Plantation, FL

SQL Developer

Responsibilities:

• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Performed maintenance tasks on SQL procedures, queries, tables on backend DB for the CRM application.
• Troubleshot existing code and wrote new queries and procedures as needed.
• Used multiple join statements to retrieve data from multiple tables.
• Fixed data consistency issues. Performed quality assurance and testing of SQL server environment.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed and deployed SSIS packages to migrate data between tables and flat files.
• Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
• Reviewed and fixed existing front end application forms and created new forms.
• Created and performed maintenance on data connections between frontend via SQL tables, SP’s and views.
• Involved in performance tuning of queries and SSIS packages, which increases the performance and runs faster.
• Involved in testing of Galaxy CRM front end application forms.

Environment: MS SQL Server 2008 R2, SSIS 2008, T-SQL, Galaxy CRM, Windows Server 2008, Windows XP Professional, MS Office 2007.

Confidential, Marysville, OH

SQL/BI Developer

Responsibilities:

• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
• Developed, monitored and deployed SSIS packages.
• Created and modified SSIS packages to load data from one server to another server as well as from one table to another table within the same server.
• Scheduled jobs to run the SSIS Packages on timely manner using SQL Server agent.
• Monitored SQL server LOGS, Application logs and analyzing the logs.
• Developed excel reports to pull data from SSIS packages.
• Extensively worked in sorting the data, defining subtotals for the reports.
• Documented all naming conventions for tables, store procedures, jobs, configuration variables and tasks. Also documented all SSIS Packages.
• Involved in migration from SQL 2005 to SQL 2008.
• Assisted new and existing clients with integration and data conversion activities.
• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: MS SQL Server 2008, MS SQL Reporting Services 2008, SQL Server Integration Services 2008,T-SQL, Windows Server 2008, Windows XP Professional, MS Office 2007, Team Foundation Server.

Confidential, Louisville, KY

MS SQL Developer/SSIS/SSAS/SSRS Developer

Responsibilities:

• Developed complex queries in T-SQL, stored procedures, and views with best execution plan.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Developed SQL scripts for pre-calculated aggregates, summaries, and user specific calculations.
• Created logs on basis of requirement by using different Event Handlers where ever required.
• Used the SSIS to migrate databases such as Oracle and Access database, flat files to SQL server 2005.
• Wrote different SSIS transformations and data flow tasks and created logics which pull the data faster and in an easier methodology.
• Developed SQL Server stored procedures and SSIS packages to extract data from database.
• Implemented constraints on tables using some basic requirement.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Extensively used variables, passing parameter to each and every individual task.
• Worked on Different ETL tool Data Junction having good understanding of the tool.
• Developed end user SSRS reports which are interactive and informative.

Environment: MS SQL Server 2005, SSIS, Data Junction(ETL tool), T-SQL, Visual Studio 2005, MS Office, SQL Profiler, SQL Job Agent, Windows 2000/2003, SQL Tuning, Oracle 8i, Pl/SQL Developer.

Confidential, NY

SQL Developer

Responsibilities:

• Created various requirement specification (SRS) documents.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and Other T-SQL code to implement business rules.
• Created databases objects like tables, views, indexes and stored procedures.
• Created triggers for cascading update and delete operations to maintain data integrity.
• Involved in database design, relational integrity constraints, Normalization, De-Normalization techniques for both OLTP and OLAP systems.
• Optimized queries and tuned and monitored server performance.
• Created parameterized reports and ad hoc reports using Report builder for the clients.
• Formatted the report layout to the requirement of the end users and deployed the developed reports on to the server for the end users.
• Performed System Acceptance Testing (SAT) and User Acceptance Testing (UAT) for databases.
• Performed unit testing and path testing for application.
• Performed continuous support for application developers and database users.

Environment: MS SQL Server 2005, Windows 2003 Server, Oracle 8i, T-SQL, XML, XSL, HTML 4.0, MS Access, BCP, SQL Profiler.

Confidential, St. Louis, MO

SQL/BI Developer

Responsibilities:

• Developed complex programs in T-SQL, wrote stored procedures, triggers and queries with best execution plan.
• Created user defined functions to encapsulate frequently and commonly used business logic, making the system more modular, secure and extensible.
• Optimized stored procedures and long running queries using indexing strategies and query optimization techniques.
• Conducted database management and performance tuning for new databases and existing databases by using SQL Profiler, Data Engine Tuning Advisor and Index Tuning Wizard.
• Used theSSISImport/Export and dataflow tasks to migrate the heterogeneous source systems such as Oracle, Access and flat files to SQL server 2005.
• Responsible for developing, monitoring and deployingSSISpackages.
• Created complex drill-down, cross tab and sub-reports using the report designer and deployed onto the Report Manager.
• Created queries for generating drill down reports inSSRS2005. Formatted the reports using the global variables, expressions and functions.

Environment: MS SQL Server 2005, MS Analysis Services 2005, MS SQL Reporting Services, T- SQL, Windows XP, Query analyzer, MS Excel

Confidential

SQL Developer

Responsibilities:

• Installed SQL Server on Windows 2000 Advance Server.
• Involved in entire life cycle including database Design, Development, Testing, Optimizing, deploying development and production servers.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures, Clusters, Triggers and maintaining referential integrity.
• Responsible for creating users and roles and assigning permissions to access database objects.
• Involved in Setup, configure and administer snapshot and transactional replication on MS SQL Server.
• Responsible for monitoring and managing SQL Server Agent jobs to ensure successful completion.
• Monitored overall database standards and procedures. Responsible for General Database Administration, Query Performance tuning.
• Took database full backup, transaction log backup & differential backup on a daily routine.
• Worked with DTS packages to load massaged data into data warehousing system.
• Tuned the SQL queries using SQL profiler and involved in tuning the database.
• Trouble shooting problems by using SQL server profiler.

Environment: MS SQL Server 2000/6.5/7.0 , DTS, SQL Server Enterprise Manager, SQL Server

Confidential

SQL Developer

Responsibilities:

• Created new database objects like Procedures, checked the coding standards followed by peers of the team.
• Responsible for designing Schema and finalization of naming and coding standards throughout the project life cycle.
• Created Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Involved in data migration and data integration.
• Involved in Extraction, Transformation and Loading of the data using DTS packages.
• Developed stored procedures, triggers and functions and added/changed tables for data Extraction, Transformation and loading.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stores procedures, checked deadlocks and created scheduled jobs
• Prepared test reports and bug logs for the testing done.

Environment: Windows Server 2000, SQL Server 2000, HTML, T-SQL.