SUMMARY:

• Around 7+ Years of IT experience in Database Design and Development on Microsoft SQL Server, T - SQL, SSIS package configuration, SSRS and Data-warehousing.
• Proficiency in creating Database and Data marts with good understanding on Features, Structure, Attributes, Hierarchies.
• Good working experience on Data Modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Fact and Dimension tables.
• Expert in creating Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Expert in Data Extraction and Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) in MS SQL Server to import/export data, Bulk insert and BCP.
• Well versed in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Hands on experience in SSIS package design, development and deployment.
• Extensive experience in administration tasks such as data loading, batch jobs, configuring IIS, backup & recovery, Database mirroring, creating database partitioning.
• Proficient in usage of SSIS Control Flow items and Data Flow items.
• Implemented various SSIS Transformations and tasks such as Slowly Changing Dimension, Data Conversion, Lookup, Fuzzy Group and FTP, Data Profiling, for-each loop, execute package, custom script task and data mining task.
• Experience in providing Logging, Error handling by using Event Handler, Query Optimization and Performance tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Good experience in Microsoft Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Hands on experience in creating various types of reports like Parameterized, Cascading, Crystal Reports, drill down, drill through, Conditional, Table, Matrix, Chart, Sub Reports, Adhoc reports.
• Experience in working with Agile, Scrum Process in software development.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server BIDS.

Languages: T: SQL.

Servers: Windows 2008/2012/2014/2016.

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS) 2016/2014/2012/2008 R2/2008.

Reporting Tools: SQL Server Reporting Services 2016/2014/2012/2008 R2/2008Report Builder.

OLAP Tools: SQL Server Analysis Services 2012/2008R2/2008.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

SQL/SSIS/SSRS Developer

Responsibilities:

• Worked extensively with the end users team in understanding the business rules and writing technical specifications and mapping documents from staging to data mart, cubes and reporting needs.
• Wrote T-SQL Queries, Dynamic Queries, Sub-Queries and complex joins for generating complex stored procedures, user-defined functions, views and cursors.
• Performance Tuning Database Queries, Stored Procedures, Views to improve performance and scalability.
• Designed processes for Extract, Transform and Load (ETL) of data from legacy system to SQL Server using SSIS.
• Importing Flat file (with different delimiters like comma, tab etc.) into the SQL Server Database tables using BIDS.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, Data Validation Checks during staging, before loading the data into the data warehouse.
• Developed SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task. Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.
• Experience in using SSIS tools like Import and Export wizard, package installation and SSIS package designer. Transformed data from one server to another server using Bulk Copy Program (BCP), and SQL Server Integration Service (SSIS) 2016.
• Proficient and efficient with the Visual Studio 2017 team Foundation Server Tool (TFS).
• Detected bottlenecks, trouble shooting and tuning of mappings, queries, sessions for better performance and efficiency.
• Perform Unit tests, Integration testing and validated results with Functional lead and providing technical guidance to ETL team.
• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages using Microsoft .NET framework.
• Designed SSAS cube for different business segment and created Calculated Measures using MDX and Tuned Cubes for better performance by deleting unused Aggregations by using Usage Based Optimization tool in SSAS.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Excellent experience in developing Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.

Environment: Windows Server 2012, SQL Server 2014/16, T-SQL, Visual Studio 2017, SSIS, SSRS, SSAS.

Confidential, CA

SQL/SSIS/SSRS Developer

Responsibilities:

• Experience in SQL Server Stored Procedure Development and T-SQL.
• Supported efficient Data Insertion, Manipulation, and Retrieval using various Joins, Indexed Views, Stored Procedures and Functions.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Responsible for creating database objects like tables, views, Stored Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS packages to capture the Incremental changes for Data Warehouse.
• Developed SSIS packages using for each loop in Control Flow to process all flat files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
• Experience in Developing, testing, deploying and maintained new and existing ETL processes.
• Maintained Data Quality and consistency using various types of Constraints, Triggers and defaults.
• Designed generic web template and developed various periodic and ad-hoc reports.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio BIDS as per the client requirements.

Environment: MS SQL Server Management Studio 2012/2014, SQL Profiler, MS SQL Server Integration Services (SSIS), ETL, SSRS, Windows Server 2012, Microsoft Visual Studio 2015/2017.

Confidential, NY

SQL/SSIS/SSRS Developer

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment and user of Analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Performed Documentation for all kinds of reports and SSIS packages.
• Used various ETL tools like SSIS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.
• Used Lookup Transformation to get the data from data sets.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports. Created and managed subscriptions for the reports.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.

Environment: MS SQL Server Management Studio 2012/2014, SQL Profiler, MS SQL Server Integration Services (SSIS), ETL, SSRS, Windows Server 2012, Microsoft Visual Studio 2015.

Confidential, FL

SQL/SSIS/SSRS Developer

Responsibilities:

• Designed and created SSIS packages to extract, transform and load data from Excel files and Text files to SQL Server destination using various transformations like conditional split, look up, derived column, data conversion and slowly changing dimensions.
• Worked with T-SQL to create tables, views, stored procedures, triggers and user defined functions for complex business logic.
• Used SQL Server Profiler and Database Tuning Wizard for Performance tuning and query optimization.
• Created indexes on selective columns for the fast retrieval of data in SQL Server Management Studio.
• Used Event handlers to capture the run time error messages by using send mail tasks in the background upon success or failure of a package in SSIS, carried out scheduling and administering of SSIS packages.
• Involved in error handling, creating package configuration and log details using SSIS logging.
• Generated and consolidated monthly reports to drive forecast production plan with SQL report services (SSRS) .
• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio BIDS as per the client requirements.
• Scheduled reports using SSRS to generate daily, weekly, monthly and quarterly reports.

Environment: MS SQL Server Management Studio 2012, SQL Profiler, SSIS, ETL, SSRS, Visual Studio 2015.

Confidential, CA

SQL Server Developer

Responsibilities:

• Code Development as per the client requirements.
• Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Resolved production issues by modifying backend code as and when required.
• Used different joins, sub queries and nested query in SQL query.
• Involved in creation of sequences for automatic generation of Product ID.
• Part of team for analyzing and implementing the physical design for database.
• Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, Functions, Cursors, Ref Cursor, and Triggers.
• Testing of code functionality using testing environment.
• Writing complex Stored Procedures to meet the business requirements.

Environment: Microsoft SQL Server 2012, BIDS, Team Foundation Server (TFS), Windows server 2008.

Confidential

SQL Server Developer

Responsibilities:

• Extensively used T-SQL in constructing user defined functions, views, indexes, constraints, and relational database models and data integrity.
• Worked as a developer in creating stored procedures, tables, views, Data migration scripts and other SQL joins and statements for other applications.
• Worked on modifying the existing Procedures, Views and functions.
• Ability to handle performance tuning of procedures, views and queries.
• Write database unit testing to test the Stored Procedures in SQL Server Data Tools.
• Created packages in SSIS with error handling
• Experienced in creating complex SSIS packages using proper control and data flow elements

Environment: MS SQL Server 2008, SSIS, T-SQL, Windows 2005 Server.