SUMMARY

• Over all 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.
• Worked in OLTP & OLAP environments that include QA, Production and development, implemented and maintained database schema and Entity relationship diagrams from business requirements.
• Experienced on Performance monitoring using SQLProfiler scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.
• Managed all database servers in development, staging, test and production environments.
• Worked with internal enterprise architects and consultants, assisting in the development of current and target state enterprise data architectures.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and also worked in a technically challenging environment.

TECHNICAL SKILLS

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, NH

SQL Server SSRS/SSIS Developer

Responsibilities:

• 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
• 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).
• Provided support to Employees and Students on over 40 different programs and applications from installation and 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, Oracle 10g, SSIS, SSRS, XML, T-SQL, Stored Procedures.

Confidential, Boston, MA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Design/develop database using SQL SERVER 2000/2005.
• 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 2005 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 2005, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Windows XP

Confidential, Fort Worth, TX

SQL BI Developer

Responsibilities:

• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Involved in modifying DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files.
• Supported the team in resolving in DTS and T-SQL related issues.
• Experience in Automate process 9 which executes the sql jobs daily/weekly/monthly.
• Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Developed SSIS using different ETL transformations like Derived Column, Data Conversion, Lookup, Merge, Slowly Changing Dimension, Union All and Conditional Split.
• Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.
• Using Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Modification of database object such as addition of Triggers, modification of tables, stored procedure to meet customer requirements on SQL server Management Studio (SSMS).
• Monitoring Execution Plans to enhance the performance of the queries.
• Involved in creating Adhoc reports and data driven subscription reports by using Report Builder in SSRS.
• Modified existing Reports and sql Stored procedures in SSRS 2012.

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

Confidential, Houston, TX

SQL Server Developer SSIS/SSRS

Responsibilities:

• Involved in Data Source layer, data transformation layer, data storage and retrieval layer, analytical layer and presentation layer of business intelligence solution
• Used Linked servers to connect to remote OLEDB source and joined the data present in OLEDB source with local data (referred the oledb source more than once)
• Used open row set function for one time access of the other OLEDB source data
• Data from sources MS SQL Server, Oracle, text files, Microsoft access are extracted, transformed and loaded into a data warehouse.
• Involved in the design of star and snow flake schemas for the data warehouse
• Handled inferred and slowly changing dimensions while loading fact and dimension tables respectively
• Involved in package migration from DTS to SSIS, running upgrade advisor tool against DTS packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in loading the fact and dimension tables
• Identified and defined fact and dimension relationships
• Involved in the ETL process, used SSIS tasks and transformations to accomplish the ETL process
• Deployed reports on to the report manager and presented them to the users creating custom vb.net applications and asp.net pages
• Created data source views from data sources SQL Server, Oracle
• Included computed columns using named calculations and removed unwanted columns using named queries
• Designed time and geography dimensions including hierarchies
• Created different drill down and parameterized reports depending on the requirements and developed data driven subscriptions for those reports using SSRS and report manager.

Environment: MS SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005, DTS, T-SQL, VSS, Window Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer.