SUMMARY

• Over 7+ years of extensive experience in Database design, development and administration of applications with MS SQL Server versions 2014/2012/2008 R 2/ 2008/2005/2000 using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) in diverse industries.
• Involved in all the stages of Software Development Life Cycle including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user profiles, relational database models and data integrity, SQL joins and query writing
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2008/2005/2000
• Experience with Fragmentation and Query analyzer for SQL Server 2005/2008/2012/2014 and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
• In depth knowledge in T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in Database Backup, Recovery and Disaster Recovery procedure
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Experience in creating Reports from Web Services and used MDX on Cubes to create reports in SSRS.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Reporting, Designing logical/physical databases and Troubleshooting.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Experience in Integrating SQL Server Reporting Services (SSRS) with Microsoft Office Share Point Server (MOSS 2007)
• Good understanding in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Involved in Database Design, Data Modeling (Relational and Dimensional) using Erwin and Microsoft Visio for logical and physical data models
• Good team player with strong analytical skills.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, CSS, ASP.NET, VB, C#

RDBMSMS: SQL Server 2014/2 /2000, MS Access.

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables.SQL Query Analyzer, SQL Enterprise Manager, Solution Explorer, Analysis Manager, and Reporting Server.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2010/2013

Operating Systems: UNIX, LINUX, Windows7 Vista/XP/2003/2000, NT & Windows 9x and MS-DOS

Systems familiarity: OLTP, DSS, OLAP

Tools: and Utilities SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, Carlisle, PA

SQL BI Developer

Responsibilities:

• Worked with development team and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Involved in Database design & Data modeling various databases.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Created and maintaining SSIS Package (ETL) to Extract and Transform data from, Flat File or CSV, and to load into Staging Database.
• Effectively using various control flow and data flow tasks provided by SSIS such as Data Conversion, Lookup, Conditional Split, Slowly Changing Dimension, Merge and Union all.
• Scheduled and maintained various daily, weekly and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• Created new database objects like Tables, Procedures, Functions, Triggers, and Views using T-SQL
• Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Reports.
• Prepared technical documents like High Level Design
• Involved in Business Analysis & Requirement collection.
• Understanding Customer requirement via interaction and writing functional specification.
• Wrote complex stored procedures and cursors to implement various business logics as per the client requirements
• Optimizing existing queries and fixing query performance issues.
• Actively interacted with end user to gather business requirement, system specification and enhancement.
• Involved in writing Transact SQL utilities to generate table insert and update statements.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Experience working in agile environment and supported iterative testing methodology.
• Worked in on site/ off shore/ off site environment; coordinated my activities by proactively communicating with my counterparts in the other teams.

Environment: MS SQL Server 2014/2012, SQL Server Integration Services, SQL Server Reporting Services, Oracle 9 i/ 10 g; DB2, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005, Windows XP, C#, ASP.NET, BizTalk Server, JavaScript, XML, Erwin v4.1, MS Office 2013

Confidential, PITTSBURGH, PA

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Performed server installation and configuration using SQL server2012.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and server efficiency SSAS and SSIS.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS.
• Created automated stored procedures for day end operations using SQL server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using server Profiler and Index Tuning Wizard in SSAS and SSIS.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base
• Extensively worked in ETL and data integration in developing ETL mappings and scripts usingSSIS, Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• Created Packages that Transfers Databases from OneSQL Serverinstance to Another Instance and Scheduled the SSIS packagefor migration of data from old system to MS SQL 2012
• UsingSSIS, loaded XML data to the Database tables and Extracting Data usingSSISinto Excel Files for Marketing purpose
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, and 2000.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Managed and monitored the use of disk space.
• Planned Backup strategy based on projects requirements.
• Worked with DTS packages and MS OLAP Services.
• Maintained the consistency of the client’s Database using DBCC.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.

Environment: SQL Server 2008 R2/2012, SSIS, SSAS, SSRS, Erwin, .Net Frame Work, XML, MS Access, Excel, C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server.

Confidential, Miami Lakes, FL

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse.
• Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, SSIS and VBScript
• Loaded data from heterogeneous sources to databases using various tasks and transformations using SSIS
• Migrate the data from an Access database to SQL Server 2008.
• Developed web application for reporting portal using .NET, ASP.NET, C#, VSS
• Used VB.Net Code to create embedded functions in SSRS.
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy, and maintain various SSRS Reports in SQL Server 2008.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using SSRS.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008,Visual Studio 2008, VB.Net, C#, MS SQL Server Management Studio, SSIS, SSRS, Report Builder, SSIS-2005, Team Foundation Server (TFS), Office, Excel.

Confidential

SQL Server Developer

Responsibilities:

• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Generated and formatted Reports using Global Variables and Expressions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2000/2005, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).