PROFESSIONAL SUMMARY:

• Over 7+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MS SQL 2012/2008/2005/2000 .
• Expertise in all phases of Software Development Lifecycle (SDLC) involving Software Analysis, Design, Development, Testing, Implementation, Production Deployment and Maintenance of Oracle/MS SQL database in Client/Server and Web based environments.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD’s).
• Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de-normalization.
• Extensive experience with T-SQL, Functions, Views. Created complicated SQL procedures to meet the requirements of the systems being developed.
• Experienced in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Expertise in designing Data Flow task, Work Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column.
• Excellent in High Level Design of ETLDTS Packages &SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and unionall.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Managed Error handling, logging using Event Handlers in SSIS.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Experience in writing Expressions in SSRS and Expert in fine tuning the reports.
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Hands-on experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Knowledge of SQL Server solutions including Log shipping, database mirroring, Replication and clustering.

TECHNICAL SKILLS:

Languages: T: SQL, SQL, Dynamic SQL, .NET Framework, C, C++, C#, ASP.NET, VBScript, XML, HTML, DHTML, HTTP.

RDBMS: SQL Server 2014/ 2012/2008/2005/2000 , Oracle 11g/10g/9i/8i and MS Access 2003/2000/97 , DB2, Teradata, Sybase.

DWH / BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio.

Tools: & Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Web Services, SOAP.

Operating Systems: Unix, Windows NT/XP/ 2007/2003/2000 , Windows 9x and MS-DOS

RDBMS: SQL Server 2012/2008/2005/2000 , Oracle 11g/10g/9i/8i and MS Access 2003/2000/97

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

SQL Server Database Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Re-engineered key applications and stored procedures to strengthen response times in order to provide timely delivery with improved reliability and reduced costs across the University.
• Migrated the DTS packages into SSIS.
• Extracted the data from SQL Server to CSV files using SSIS as ETL tool.
• Involved in creating Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS)
• Automated existing SQL Reports via Report Subscriptions and Data Driven Subscription a using SSRS 2008.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Modified existing Reports and sql Stored procedures in SSRS 2012.
• Provided support to Employees and Students on over 40 different programs and applications from installation and training to problem resolution.
• Worked on Performance Tuning, Capacity Planning based on user needs, and SQL optimization.
• Created complex Stored Procedures and Views to pull data into reporting services from the Databases.
• Worked on removing duplicates while migrate the data using joins and Row number by partition clause.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for dataload and transformation, and data extraction.
• Created various SSIS packages for data migration which processes multiple flat files coming from utility server and loads into different database tables.
• Used various transformations in SSIS packages to modify the data from the source.
• Involved in extracting the data from flat files in the development server and loading the clean data into the production server using SSIS
• Created database maintenanceplanner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
• Generated database SQL scripts and deployed databases including installation and configuration.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Transformation of data from one server to other servers using Bulk Copy Program (BCP) and Data Transformation Services (DTS) tools.
• Generated Daily, Weekly and Monthly reports for the query analysis of managers and end users.

Environment: MS SQL Server 2008/2012, SSIS,SSRS,SSAS, DTS, XML, HTML, BIDS, TFS, T-SQL, BCP, Oracle, UAT, MS Excel, Windows XP, Visual Studio 2010.

Confidential, Portsmouth, NH

ETL/SQL Server Reports Developer

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL Server 2008 Integration Services.
• Developed SSIS Packages using xml, OLEDB, file system and Look up tasks.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2008.
• Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Scheduled Complex Stored Procedures using SQL Server Agent.
• Monitored and modified Performance using execution plans and Index tuning.
• Optimized Database Performance and Performed Maintenance duties such as tuning, backup and restoration.

Environment: MS SQL Server Management Studio 2008/2008 R2, SSRS, SSIS, SSAS, TFS, T-SQL, XML, OLAP, OLTP, DTS, BCP, Query Analyzer, SQL Profiler, Index Tuning Wizard, Windows XP.

Confidential, Boston, MA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, and Implementation.
• Writing complex SQL Queries, Triggers, Cursors and User Defined Functions to implement the business logic.
• Created Indexes on selective columns to speed up queries in SQL Server Management Studio.
• Used Team Foundation Server (TFS) for version control.
• Created new stored procedures and modified existing procedures depending upon the business requirement.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loading the data into target data sources by performing different kinds of Transformations using SSIS.
• Responsible for coding SSIS processes to import data into DataWarehouse from Excel spreadsheets, Flat files and OLEDB sources (AS400).
• Worked on various Tasks and Transformations like Execute SQL Task, Execute package Task and conditional split, Script component, Merge and Lookup while loading the data into Destination.
• Scheduled SQL Server Agent jobs to run the packages on daily and hourly basis.
• Experienced in developing Custom Report and different types of Chart Reports, Tabular Reports, Matrix Reports, Drill down, Drill Through, Detailed, Summarized, List reports in multiple formats using SQL Server 2008 R2/2012 Reporting Services (SSRS).
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Troubleshoot the performance of SSRS Reports and subscription issues in it.
• Responsible for designing data warehouse structures and ETL requirements.
• Created a new data mart for Data warehouse and loaded the Dimension and Fact Tables from the Source tables.
• Maintained enterprise Reporting based on specifications and business needs and modified existing reports as needed.

Environment: MS SQL Server 2008/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Visual Studio 2010.

Confidential, Carrollton, TX

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, and Implementation.
• Writing complex SQL Queries, Triggers, Cursors and User Defined Functions to implement the business logic.
• Created new stored procedures and modified existing procedures depending upon the business requirement.
• Created Indexes on selective columns to speed up queries 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.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transform and Load) strategy to populate the data from various source feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loading the data into target data sources by performing different kinds of Transformations using SSIS.
• Responsible for coding SSIS processes to import data into DataWarehouse from Excel spreadsheets, Flat files and OLEDB sources (AS400).
• Scheduled SQL Server Agent jobs to run the packages on daily and hourly basis.
• Used Team Foundation Server (TFS) for version control.
• Responsible for designing data warehouse structures and ETL requirements.
• Worked on various Tasks and Transformations like Execute SQL Task, Execute package Task and conditional split, Script component, Merge and Lookup while loading the data into Destination.
• Experienced in developing Custom Report and different types of Chart Reports, Tabular Reports, Matrix Reports, Drill down, Drill Through, Detailed, Summarized, List reports in multiple formats using SQL Server 2008 R2/2012 Reporting Services (SSRS).
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Troubleshoot the performance of SSRS Reports and subscription issues in it.
• Created a new data mart for Data warehouse and loaded the Dimension and Fact Tables from the Source tables.
• Maintained enterprise Reporting based on specifications and business needs and modified existing reports as needed.

Environment: MS SQL Server 2008/2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Visual Studio 2010.

Confidential, Atlanta, GA

SQL Server Database Developer

Responsibilities:

• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Reports as per user requirements using MS Reporting Services 2000/2005.
• Created different types of reports such as Cross-Tab, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them using both SSRS 2000/2005 and using Multi-dimensional objects, Cursors.
• Developed reports against Data Warehouse Schemas like Star Schema and Snow-Flake Schema.
• Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Involved in the conversion of legacy reports to SSRS reports.
• Converted Actuate Reports to the reports in SQL Server Reporting Services and established Reporting Framework.
• Designed and implemented Parameterizedand cascading reports using SSRS 2005.
• Deployed Reports onto the Report Server.
• Used SSIS packages to do file operation, to apply business rules.
• Created several SSIS jobs and packages and executed those tasks.
• Created various dynamic reports using SSRS and Crystal reports.
• Generated Reports in Pro Clarity tool using MDX queries, by connecting through Analysis services.
• Worked on Implementing BI solutions using Sharepoint.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 11g to SQL Server 2005 by using SSIS 2005.
• Migrated data from MS Access 2000 to SQL Server 2005 using SSIS 2005.
• Logical and Physical design of database for projects on basis of user requirements using ERWIN.

Environment: MS SQL Server 2000/2005, Visual Studio 2005, COM/COM+, Windows 2000, Windows XP, T-SQL, MDX, SharePoint, Visual SourceSafe, XML, ER Studio, Crystal Reports, SSRS, SSIS, ERWIN.