SUMMARY:

• Over 11 years of IT experience as a MS SQL Server Lead/Developer 2000/2005/2008 R2/2012 in various Industry verticals like Finance, Insurance and Retail.
• Have good knowledge of Business Requirement Documents (BRD), Functional Specification Documents (FSD), Use Case Specifications, and Requirements Traceability Matrix across the project Deliverables using Agile, and Unified Modeling Language (UML) methodology using OOAD process and modeling tools.
• Proficient in developing Use Cases, Sequence Diagrams, Collaboration Diagrams, State Diagrams, and Activity Diagrams based on UML Methodology using tools like MS Visio, MS Word and MS Excel.
• Experienced in facilitating Joint Requirement Planning (JRP), Joint Application Development (JAD) with Business User Groups, Subject Matter Experts, and IT to limit the change process and develop the design.
• Experience with Gap Analysis to check the compatibility of existing systems with new business requirements.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Expert level configuration skills in BMC Remedy ITSM Suite - Asset Management, Change Management, Configuration Management Database and Helpdesk modules.
• Strong knowledge of best practice standards including ITIL and Microsoft Operations & Solutions Framework (MOF & MSF).
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experienced in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs
• Extensive experience in MS SQL Server 2000/2005/2008 R2/2012, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase and MS Access.
• Strong experience in Source Systems Analysis, designing Packages with Source-Target Mappings.
• Expertise in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and AdHoc reports using SQL Server Reporting Services (SSRS).
• Expert in Creating and Deploying SSRS Reports and report models on the report manager for user accessibility.
• Extensive experience in SQL and ETL tools particularly the RDBMS, design and architecture, optimization and maintenance
• Experienced in writing Parameterized Queries for generating reports, Formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008R2/2012.
• Hand on experience in developing & deploying cubes using SQL Server Analysis Services involving multidimensional data.
• Experienced in designing and developing large amounts of enterprise reports (SSRS/Business Objects) using the data from ETL Loads and various heterogeneous data sources.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Expert in using tools like MS SQL Profiler, Query execution plan, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Ability to code and implement complex business rules in T- SQL using Functions, Triggers and Stored Procedures.
• Hands-on experience in Performance tuning, Query Optimization and Indexing of database using SQL Profiler and Query Analyzer.
• Team player and self-starter with excellent communication and documentation skills, ability to work independently or as part of a team and capable of picking up new skills quickly.

TECHNICAL SKILLS:

MS SQL Server 2000/2005/2008, SQL Server Integration Services (SSIS), SQL Server DTS, Data Stage, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Rational Rose, Oracle 9i, VB6, Microsoft Products MS Word, MS Excel, VSS, C#.Net, VB.NET, ASP.NET, MS Access, MS Power Point, T-SQL, PL-SQL, HTML, XML, C++, JavaScript, ODBC, MS Visio 2008.,Erwin,Oracle 10g,Oracle 11g.

PROFESSIONAL EXPERIENCE:

Confidential - NJ

Senior MS SQL Server/Architect Software Asset Management

Responsibilities:

• Requirements gathering, Analyzing and design of all the client requirements.
• Performed Business Requirement Analysis, Data Analysis and Modeling.
• Daily routines involved planning, examining and execution of daily tasks. designing databases, analyzing data, and modeling and migrating data
• Wrote complex stored procedures, Functions in SQL server.
• Developed TSQL Scripts to get data for Migrating Data from live ticketing system(ServiceNow) to Flexera ERP systems for streamlining of many things using SQL. These scripts are automated to load Live data on weekly thrice a day.
• Worked in releasing Flexera workflow changes while adhering to Enterprise Release cycle guidelines.
• Designed and developed outbound and inbound target pattern for interoperability with ServiceNow, leveraging technology advantages with their optimal mix.
• Designed and implemented Flexera based Asset Management System by reverse engineering Flexera native attributes
• Lead development effort on a ETL project prioritized appropriately.
• Senior Advisor for applications that connect to this database. There are some 45 applications, and they run the gamut of interactive screen based applications, web based java applications, ETLs and traditional reporting.
• Performed upgrades, maintenance, day-to-day operation, optimization and tuning of about 70 SQL Server Stored Procedures, Triggers, Functions.
• Developed 100s of TSQL Stored Procedures, Functions, Views.
• Completed Complex Reporting Projects using SSRS.

Confidential - PA

Senior MS SQL Server/Architect SQL Developer

Responsibilities:

• Requirements gathering, Analyzing and design of all the client requirements.
• Daily routines involved planning, examining and execution of daily tasks.
• Wrote complex stored procedures, Functions in SQL server.
• Developed TSQL Scripts to get data for Migrating Data from Legacy system (CVISION) to ORACLE ERP systems for research using SQL. This script is loaded on monthly run basis.
• Created a SSIS package which loads data from Excel Source to stage database and then move data into sandbox and finally move this data into Production database.
• Doing PPV of the data loaded into Dev, Stage, UAT, and Production databases.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to SQL server.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created views to restrict access to data in a table for security.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Created and maintained database objects.
• Used SSIS to load data from various files (Flat Files, Excel Files, Text Files and XML files).
• Implemented SSIS package to load data from multi sheet excel files from a network folder and then move the files to archive folder and rename that file with date extensions. Used Delay Validation inside this package.
• Implemented Purge technique to delete old files by using SSIS package.
• Moved Files from one folder to another using date part.
• Implemented Data modifications using Derived column transformations in SSIS.
• Provided good naming conventions to SSIS package objects for better debugging purpose for errors in Logging of SSIS packages.
• Implemented Script task to delete top N rows from a excel file and load remaining records into tables by using C# coding in script task.
• Implemented WMI event watcher task in ssis to look for a particular file and notify particular users for appearance of this file.
• Implemented some of the best practices for testing of the SSIS packages.
• Coordinated with system engineers in releasing the workflow changes while adhering to Enterprise Release cycle guidelines.
• Designed and developed outbound and inbound target pattern for interoperability.
• Designed and implemented workflow of some complex processes by reverse engineering.
• Lead development effort on various workflows.
• Responsible for report performance and interacted with the DBAs to advise on table partitioning, data imports from DB2 databases and other issues.
• Responsible for smooth transition during upgrades of DW objects like stored procedure, tables, packages etc.
• Designed and developed a database to house data from various data sources for all reporting needs.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Created parameterized, drill-down and drill-through reports.
• Deployed reports to Reporting Services.

Environment: SQL Server 2012, SQL BI Suite (SSIS), Visual Studio 2013, SQL Profiler, MS Office, T-SQL, SVN.

Confidential - PA

Lead MS SQL Server/Senior Remedy Developer

Responsibilities:

• Requirements gathering, Analyzing and design of all the client requirements.
• Daily routines involved planning, examining and execution of daily tasks.
• Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Installation of Sql Server 2014 tools, Visual studio 2013.
• Wrote complex stored procedures in SQL server.
• Created Script to Load Health based Risk tables based on base tables and Look up tables for research using sql server agent and this is loaded on monthly run basis.
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Created a SSIS package which loads data from Excel Source of multiple sheets into stage database and then move data into sandbox and finally move this data into Production database.
• Used C# coding in the SSIS package to eliminate Locking of resources
• Control flow components used in the SSIS package are two for each loop containers, 2 script tasks, a data flow task.
• Various Data flow transformations used in the SSIS package are Data conversion task, Derived column transformation, Conditional split transformations.
• Having Code reviews with Lead and Director on weekly basis.
• Doing PPV of the data loaded into Dev, Stage, UAT, and Production databases.
• Designed Views within SQL Server 2012 to support Micro strategy reporting and dashboards.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Enforced the Business Rules to filtered bad data from system by using Complex T-SQL Statement, and implemented various Constraints and Triggers for Data Consistency.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Responsible for providing active Remedy Operations Support for 9 DOT modes.
• Coordinated with various process managers in an attempt to either enhance existing ITIL driven process or establish new processes that are in alignment with ITIL framework.
• Presented various Demos on Remedy IT Service Management Applications for interested business units and attracted various potential stakeholders under Common Operating Environment (COE).

Environment: SQL Server 2014, SQL BI Suite (SSIS), Visual Studio 2013, VB.Net, SQL Profiler, T-SQL, MS Office, SVN.

Confidential

Lead MS SQL Server Developer (T-SQL/SSRS/SSIS/SSAS) & Sr Remedy Developer

Responsibilities:

• Requirements gathering, Analyzing and design of all the client requirements.
• Involved in the complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with data analyst and data modeler to design the complete warehouse Schema using Erwin with proper relationships defined.
• Daily routines involved planning, examining and execution of daily tasks.
• Wrote complex stored procedures in SQL server, Oracle 11g.
• Wrote VB.NET code for generating Custom Score Reports.
• Worked with VB.Net components in Visual Studio 2010 for loading data from Text files into SQL server database.
• SSRS applications were built by following the SDLC process.
• Generated Score Reports and Roster Reports of Unicode data using Sub reports as a part of main report and writing custom code for features which are not available in SSRS.
• Created Parameterized reports, Radar chart, Bubble chart and Bar-graph as a part of score reports build.
• Deploying reports into Report Manager. Creating Data sources, giving Connections to the datasets of the RDLs by identifying the corresponding data sources.
• Designed reports from integration of 3 systems.
• Created SSIS package to load data from XML file, Excel files into SQL server.
• Worked on ETL documentation for the packages.
• Used SQL server Import and Export Wizard to import and export data to Excel.
• Created Test Harness for the SSRS application to replicate the web service call using VB.NET.
• Took part in Business & Design meetings with Lead and Director of ENSR application.
• Following the deployment process by raising DSO before doing deployments which are not in schedule.
• Designing Tables for the report requirements.
• Involved to write complex T-SQL queries and Stored Procedures for generating reports.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Extensively used Joins and sub queries to simplify complex queries using involving multiple tables.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Involved in meetings with other teams for Integration of Systems.
• Debugging the SSRS reports by looking at the report server execution logs.
• Deployment of Reports into Report Manager and executing the SQL scripts into SQL server.
• Development process involved keeping version control of the Report RDLs by moving the RDLs into Tortoise SVN.
• Well organized to maintain the Ad-hoc requirements related documents in separate files.
• Built 42 Reports.
• Identifying various risks in the Report build and timely intimating Lead and Director about it and then fixing the issues in unit testing phase.
• Attended functional testing and user acceptance sessions and worked on the feedback provided by them.
• Extensively worked on C#.Net web forms in Visual Studio 2013
• Used AJAX to retrieve back end data based on user selections and displaying asynchronously on the web pages
• Fixed several bugs and issues in the application
• Worked on many aspx web pages to enhance the user-friendliness of the interfaces using HTML, JavaScript, JQuery to meet the client’s requirements
• Wrote and integrated web service methods to handle to new features
• Using OOP concepts of abstraction, inheritance and encapsulation in implementing the back end functionality.
• Rigorous unit testing and validation to ensure the functionality of the newly developed features within the application.
• Involved in successfully upgrading from ARS 6.01, ITSM 5.6 to ARS 6.03, ITSM 6.0 Suite, by playing a pivotal role in various stages of the Project life cycle.
• Augmented the current Remedy Team (TGSIREMEDY) and accelerated Remedy 6.3, ITSM 6.0 Suite Upgrade Project at Fund in order to pave way for ITIL arrival.
• Responsible for providing administration support for various in-house Remedy applications to approx. 500 remedy users and also maintained a technical relationship with BMC Remedy with regards to requesting enhancements, license management, reporting and tracking bugs, and planning upgrades.

Environment: SQL Server 2008R2, SQL BI Suite (SSIS, SSRS), VB.Net, SQL Profiler, MS Office, T-SQL, SVN

Confidential, NJ

Lead SQL Server Developer (T-SQL/SSRS/SSIS) & Remedy Developer

Responsibilities:

• Worked as a ETL/SSRS lead and was mostly leading a development team of two in offshore.
• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with the Data modeler in designing the Schema using Erwin with proper relationships defined.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Worked with Data mapping, High level design and Detailed design documents.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc to migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Used complex transactions and Validations to make sure that the data is correctly loaded into the warehouse.
• Helped offshore team on daily calls to design SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Used Log providers to log error into the table and send the report to the concerned department.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Made various report parameters and query parameters to create parameterized reports using SSRS 2008, SSRS 2008R2.
• Created Flattened Report using CTE to capture Level Changes in the organization.
• Implemented caching of reports and managed the report history in the Report Manager.
• Deployed and Scheduled Reports into SharePoint for Weekly, Monthly basis.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Took part in testing, bug fixing and documentation for the project.
• Used Document Mapping Feature in SSRS to help Business Users to Navigate through the Report.
• Designed and developed Scorecards, Dash-Boards, Key Performance Indicators, Auditing Reports
• Extensively Written CTE’s, Pivot and Un-pivot, Roll-Up, Views, Stored Proc’s for Reports.
• Wrote complex T-SQL queries and Stored Procedures in the process of achieving business requirements for reports.
• Wrote custom VB.NET Code to tilt the string in SSRS 2008 for 270 degrees.
• Built 45 Reports in Past 1 year.
• Created Test Plans from Business Logic for giving Guidance to offshore to code.
• Took part in Business Meetings for Report Requirements and Report Design meeting with BA constantly and Other Developers.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.
• Involved in requirements collection and SOW preparation for Remedy - Apropos integration for Motive Replacement project and eCBS archiving project.
• Created workflow for Remedy HelpDesk integration with ATG (formerly known as primus) to meet end user requirements.
• Coordinated with Apropos team to configure API’s for integration between Remedy and Apropos for Chat, Callback and exceptional handling procedure.
• Developed test scripts for regression testing, user acceptance testing, pilot testing, shakeout testing, unit testing and production readiness testing for development, acceptance and production environments.
• Use of OLE Automation for launching IE in front end and use of Perl script to get back data from the web server to Remedy are some of notable achievements in this project.

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), VB.Net, SQL Profiler, MS Office, T-SQL, Erwin

Confidential, SFO, CA

T-SQL/SSRS/SSIS/SSAS Developer

Responsibilities:

• Worked as a database developer on databases like MS SQL Server 2008R2 using T-SQL, stored procedures and views to get data from Data warehouse.
• Involved in Business Analysis and Requirements collection.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Went through the process ETL in implementing Datawarehouse.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Made Master Child package using variables and Execute package task in SSIS.
• Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.
• Wrote VB.NET code to improve the efficiency of the package by creating a Loop through of the Excel files to determine whether to process the excel file.
• Deployed, Tested and Scheduled SSIS packages.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Maintained report models for ad hoc reports and deployed on report server.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Developed incremental loading using MERGE statement in SQL server 2008R2.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created .Net windows application to display all the data from different tables in grid view based on the search.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Creating Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Created partitions for large measure groups.
• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models Snow Flake Schema for developing cubes using MDX.
• Identified data sources to build data source views.
• Designed slowly changing dimension transformations (SCD) of type 2, type 1 using slowly changing dimension wizard.
• Performed Installation of Oracle 10g and 11g.
• Back-up and Recovery of Oracle database using recovery manager(RMAN)
• Developed Database Triggers and Stored Procedures for populating and updating data into different tables on ORACLE 8i Database Management Systems.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Environment: Windows Server 2003, SQL Server 2008R2, SQL Profiler, SSIS, SSRS,T-SQL, VB.Net, SSAS, Oracle 10g, Oracle 11g.

Confidential, NY

MS SQL T-SQL/SSIS/SSRS Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the client requirements.
• Used business requirements and functional specifications to generate logical data models .
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to sql server.
• Worked on complete SDLC from Extraction, Transformation and Loading of data.
• Successfully accomplished ETL process in creating datawarehouse
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc to migrate the old Bills information, Customer Information, Contracts Information and other important data.
• Developed a package with custom c# code for each loop container to loop through this task for various Excel files based on the Create Date.
• Wrote C# Code to send HTML Based Mail for success and Failure of the package.
• Used SSIS to upload amortization schedules sent by the client in .CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.
• Managed Alerts for successful or unsuccessful completion of scheduled Jobs.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Took part in testing, bug fixing and documentation for the project.

Environment: SQL Server 2008, SQL BI Suite (SSIS, SSRS), SQL Profiler, MS Office, T-SQL,Erwin, Windows Server 2003.

Confidential, MI

SQL Server/BI Developer (T-SQL/SSIS/SSRS/SSAS)

Responsibilities:

• Gathered requirements about the project which was used to create the SSIS 2008 packages.
• Involved in complete software development life cycle (SDLC) i.e. Requirement Analysis & Specification, technical design and Implementation.
• Documented Low Level and High level Design Specifications.
• Created Data Model using Embarcadero ER/Studio.
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Orchestrated, developed and deployed the SSIS packages using SSIS 2008 as the ETL tool.
• Used Package configurations, Variables and Expressions while creating the SSIS packages.
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Used SQL server agent to automate the SSIS package execution.
• Responsible to create test cases and performed system testing for the SSIS packages using SSIS 2008.
• Made various report parameters and query parameters to create parameterized reports using SSRS 2008.
• Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.
• Implemented caching of reports and managed the report history in the Report Manager.
• Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.
• Created stylish reports and implemented conditional formatting using SSRS 2008.
• Deployed and managed the reports in the Report Manager using SSRS 2008.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, Windows NT.

Confidential, IL

SQL Server Developer (T-SQL/DBA)

Responsibilities:

• Migrated the DTS packages into SSIS and created new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Removed the DTS package references from stored procedures and created as SSIS packages and embedded those procedures in the SSIS package to retain the load functionality of the system.
• Performed regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.
• Designed and developed tables, and stored procedures and performed data imports and restores for successful migration.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Configured linked servers in SQL Server 2000 and modified them to work in SQL server 2005.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) and Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created and monitored all SQL tasks (SSIS Packages) and scheduled daily jobs using Agent Scheduler through SQL Server Management Studio. Includes, implementation of necessary batch processes for periodic updates.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Scheduled full and transactional log database backups in the production environment using the database maintenance plan wizard.
• Setup database maintenance plans and used index tuning wizard to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.

Environment: Windows XP Professional (SP 2), SQL Server 2005, SQL Profiler, SSIS, SSRS, T-SQL.