SUMMARY

• Over 8+ years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2014/2012,/2008R 2/2008/2005/2000 in Banking, Finance, Insurance, and Health Care Domains.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Good Experience in working with APIs to access specific database features.
• Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
• Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS).
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Proficiency in data Extraction, Transformation and Loading (ETL) by using SSIS, DTS, Bulk Insert and Bulk Copy Program utility.
• In depth understanding of SQL Server Migrations and problem management
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Responsible to maintain the efficiency of all the software and applications that run on UNIX system
• Intensively working for graphic design Database backend programming in C# for dynamically generating components in front Database.
• Having excellent communication skills, analytical skills, understanding of business requirements in various domains.

TECHNICAL SKILLS

Languages: T-SQL, XML, HTML, C#.Net, ASP .Net.

Data Application Software: SQL Server 2000/2005/2008 R2/2012, 2014 MS Access (2000/2003) and UML.

Database Modeling: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas.

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

BI Tools: SSIS/SSRS/SSAS, SSBI Development Studio, Crystal Reports.

Reporting Tools: MS Access, Excel, and MS SQL Server Reporting Services 2000/2005/2008 R2/2012/2014 SSIS, SSAS and Share Point. Tableau

Operating Systems: Windows 7/Vista/XP/NT/ 2000/2003/2008.

Version control tools: Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)

Others: ER-Win, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Wallingford, CT

SQL Server/SSRS Developer

Responsibilities:

• Responsible writing Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012
• Experienced in writing Views, Cursors, Joins, Constraints, DDL, DML
• User Defined Functions to implement the business logic and also created clustered and non-clustered indexes
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Involved in code review, writing Unit test case, creating a platform to run the samples and validate these Test cases.
• Responsible for automation of maintenance jobs, locks and indexes configurations
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL.Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports
• Developed Charts, Matrix reports, Linked report
• Formatted the reports using the Global variables and expressions.
• Worked various operational Drill-through and Drill-down reports using SSRS
• Developed Reports for business end users using Report Builder with updating Statistics
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports
• Worked to resolve the issues during the deployment
• Involved in code review, writing Unit test case, creating a platform to run the samples and validate these Test cases
• Work with the standards and regulations of sampling methodologies
• Thoroughly documents operating procedures for sampling executions
• Worked on the SQL server databases to pull the data for testing requested by Control functions

Confidential, Wayne, PA

SQL SSIS Developer/SSRS Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Designed transformation rules and processes to derive the correct data from the extracted data and transforminto the required format and structure to support the business requirements.
• Loading the transformed data into the target database and the associated metadata into the enterprise metadata repository.
• Designed various schemas which are used for Landing the data, staging for transforming the data and PROD in MS SQL SERVER 2014
• Involved in project planning, scheduling for database module with project managers.
• Created the reports based on the requirements using SSRS 2014/Crystal Reports XI.
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL.Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help End user Analyze Financial statements by showing demographic information based on various parameters.
• Authored performance based reports for the End user.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Created packages in SSIS with error handling.
• Used C# scripts to run custom scripts in package flow
• Worked with different methods of logging in SSIS.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Environment: MS SQL Server 2014/2012, DTS, Windows 7, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), Crystal reports XI, Business Objects XI,SQL Server Query Analyzer, Erwin, SSRS, TFS, FTP Communication, MS-Visual Studio 2010, MS Access, XML,XSLT, ADO.Net.

Confidential, Englewood Cliffs, NJ

SQL Server/ETL/SSIS Developer/SSRS developer

Responsibilities:

• Installed and Upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
• Migrating Databases from SQL Server 2008 to SQL Server 2012.
• Planned, defined and designed data based on the business requirement.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Designed logical/physical data models using Erwin tool 8.0.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Worked with different methods of logging in SSIS
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created packages in SSIS with error handling
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles .
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Environment: MS SQL Server 2012/2008, Enterprise Edition, MS SSRS 2012, MS SSIS 2012, T-SQL, VB Script, Windows Server 2007, Erwin 8.0

Confidential, Washington, DC

MS BI Developer

Responsibilities:

• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server R2 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSASenvironment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated

Environment: SQL server 2008R2, Windows XP/2007. BIDS 2008R2, SSIS, SSRS, ETL, MDX, OLAP, Data warehouse, Windows 2000 Advanced Server

Confidential, Philadelphia, PA

MS SQL Server BI Developer

Responsibilities:

• Worked as a SSRS Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
• Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SSIS package for Market Value Process feed.
• Used C# scripts in SSIS script task to run custom scripts in package flow.
• Created command files to execute the SQL Server Integration packages using Execute Package Utility and passed connection and variable values to the packages.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
• Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
• Developed database triggers and stored procedures using SQL tables.
• Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.

Environment: Microsoft SQL Server 2008, Visual Studio 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Confidential, Boston, MA

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Actively participated in interaction with users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.
• Performed Migration of data from SQL Server .
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
• Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
• Deployed reports in to Report Manager. Created Ad-Hoc reports using Report Builder.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Developed Multi-dimensional Objects Cubes, Dimensions using SSAS.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2008/2005, SSIS 2008, SSRS 2008, SSAS 2008, Visual Studio 2008, T- SQL, Visual Source Safe 2008 (VSS), XML, ADO.NET, ERWIN 7.1, PL/SQL, MS-Access, MS-Excel

Confidential, Irving, TX

SQL Server /ETL/SSIS Developer /SSRS Developer

Responsibilities:

• Involved in gathering the report specifications by interacting with the business users
• Responsible for Data Modeling based on the client requirements, data analysis loading data from Data feed to Data Warehouse tables.
• Redesigning the ETL/SSIS process from the existing legacy DTS packages into SSIS Packages.
• The SSIS Packages include, a Master Package which executes a number of Child Packages.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Modified stored procedures to meet current design and used them in SQL Server.
• Created various Database Objects - Tables, Indexes, Views, and Roles, complex Stored Procedures, Datasets, Object Data Sources, and SQL Data Sources.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables
• Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.

Environment: s: MS SQL Server 2005/2000, Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005,T-SQL, VB Script, Windows Server 2003, Erwin 4.1.