SUMMARY:

• 5 Years of Professional experience in the IT industry as a MS SQL Server Developer using in various domains including 4 years in health care and insurance industry as well as 2 years in the service industry.
• Implemented various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS and Data warehousing tools, Data Mapping, Data Cleansing, Error handling, Unit Testing, Migration, Conversions, and Process Documentation.
• 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, Dynamic SQL scripts, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Handled large datasets from various sources and effectively transformed the data meeting the requirements in the ETL flow.
• Knowledge of best practices for greater performance in SSIS as well as T-SQL queries.
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Subreports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Operated on parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008r2,2008 and 2005.
• Built SSAS cubes and views on existing SSRS reports.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.
• Experienced in Conceptual, Logical and Physical Database design and development, Normalization and Data modeling using Erwin and MS Visio.
• 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.
• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Maintained MS SQL Server performance using diagnose tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• In-depth understanding of SQL Server Migrations and problem management
• Experience in performing daily deployment along with quarterly production deployments.
• 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. Additionally, Working knowledge with HTML.
• Understanding of software development (SDLC) methodologies such as Agile or RAD and technical documentation.
• Experience in collaborating with the offshore teams.
• Excellent communication skills, analytical skills, understanding of business requirements in various domains.

EXPERIENCE:

SQL Server Developer

Confidential, Twinsburg, OH

Responsibilities:

• Gathered requirements, prepared Technical design and Business Requirement Documents.
• Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Served as primary resource for building ETL process to transfer data from various data sources (Flat files, Excel and ODATA) to SQL server databases and for data validations.
• Designed and developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File, ODATA to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Extensively used SSMS to pull data from source tables to target tables using T-SQL.
• Developed complex queries to analyze and extract the required data for building dashboards in Tableau.
• Experience in writing complex stored procedures.
• Scheduled jobs using both SQL server agent and Windows Scheduler.
• Actively interacted with Business to understand data and business rules to effectively perform ETL tasks.
• Extensively worked on data cleaning and mining along with quality control issues.
• Developed and designed solutions to maximize analytical output.
• Worked closely with DBAs, Data Architects and Tableau Developers.
• Good learning experience in Tableau.
• Analyzed Tableau reports and performed data validation.

Environment: SQL Server - 2015, Microsoft Integration Services - 2015, 2017, Visual Studio - 2015, ODATA, Excel- 2016.

MSBI Developer

Confidential, Baltimore, MD

Responsibilities:

• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors using SQL Server Management Studio.
• Created User Defined Functions, Views to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Wrote the complex queries using joins, Sub-queries, common table expressions (CTE) in T-SQL.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Developed SSAS Tabular models including measures using DAX that accommodate the business requirements and use as a source in Power BI reports.
• Extensively used data visualizations calculations using DAX using power BI. Also configured Power BI related Gateways.
• Developed power bi reports using various types of charts, KPIs and slicers and configuring these visualizations according to the user's requirements.
• Configured Integration Runtime (IR) in order to move the data from on premise to cloud.
• Worked on PowerShell scripts to automate the creation of resource's and resource group.
• Work directly with the business users to gather requirements and understand their usage of the data in depth.
• Hands-on experience through involvement with member subscription and policy details.
• Substantial experience in configuring TFS builds and release for day-to-day deployments.
• Documented the mappings used in ETL processes including the Unit testing and Technical document (TSD) of the mappings for future .
• Regularly create and update the reports on status of agreed performance indicators to the Coordinator / Team Leader / Department Head
• Worked on Azure Data Lake Gen 2, in order to write the data from Source to Raw bucket
• Designed developed the SSIS packages to extract, transform, load the data into Target and generate outbound files for various vendor by using SSIS.
• Experience with SharePoint Designer.
• Built customized dashboards to allow user tracking and logging information.
• Worked with Business Analysts and Users for gathering requirements and implemented logical Design into Physical Design.
• Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Used complex transactions and Validations to make sure the data is correctly loaded into the warehouse
• Used Configuration files to deploy and install a package from one environment to another.
• Used SSIS features like event handlers, property expressions, package configurations, transaction option and protection levels in the packages.
• Developed Script Task with C# script language to extract, transform and load data in Database. Generated and load data into various output file (XML, TXT, etc.) using Script Task.

Database Developer

Confidential, Burlington, NJ

Responsibilities:

• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Design and tune ETL process.
• Creating large number of stored procedures and created parameterized SSIS Packages to move data from different sources to target.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• 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.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• 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.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Environment: MS SQL Server 2008/2012, Red Gate tools, PowerPivot, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, Power BI, MS Visio, Agile/SCRUM SharePoint 2013 Thank you.