SUMMARY:

• SQL BI Developer for around 8 years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2008/2012/2014/2016/2017 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance. A Smart working, Motivated, Detail - Oriented team player with excellent communication, interpersonal and problem-solving skills.
• Experience in database designing skills and experience in installing, configuring, managing, upgrading, and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2012/2014/2016/2017.
• Expert in writing T-SQL, working on DTS, SSIS, Data Cleansing and Data Migration.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Excellent T-SQL (DDL & DML) development skills to write complex queries involving multiple tables, great ability to develop and maintain Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval/query optimization.
• Facilitate the transformation of volumes of data into end-user excel workbooks and reports.
• Design, develop and maintain T-SQL database objects including table schemas, stored procedures, views, and triggers for OLTP environment.
• Experienced in extracting transforming and loading (ETL) data, from different Heterogeneous Data sources like MS Access, Flat File, Excel and Oracle, to MS SQL Server using various tools such as SQL Server Integration Services ( SSIS ), DTS, Bulk Insert and Bulk Copy Program utility.
• Expertise in designing SSIS packages to Import and Transform Data between Databases and External Data Sources. Migrated Organization, Orders, Adjustments, Objectives and Callide data in various formats like text-based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services ( SSIS ) to overcome the transformation constraints.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Experienced in configuring and maintaining Report Manager, Report Server, and Report Builder for SQL Server Reporting Services ( SSRS ). Created Power BI Visualizations and Dashboards as per the requirements.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Experienced in configuring and maintaining Report Manager, Report Server, and Report Builder for SQL Server Reporting Services ( SSRS ).
• Well versed with diverse types of reports such as Drill down, Snapshot, Cached, Drill through, Parameterized, cascaded parameterized, Linked, Chart, and Sub-reports using SSRS .
• Experience in implementing business logic using DAX and M Language.
• Experience in Dimensional Data Modeling and Cube development in SQL Server Analysis Services ( SSAS ).
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX , developing reports using MDX and T- SQL .
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Experienced in Agile development mythology like SCRUM.
• Hands on experience in Azure Development, worked on Azure web application, App services, Azure storage, Azure SQL Database , Virtual machines, Fabric controller, Azure AD , Azure search, and notification hub.
• Designed, configured and deployed Microsoft Azure for a multitude of applications utilizing the Azure stack (Including Compute, Web & Mobile, Blobs, Resource Groups, Azure SQL, Cloud Services, and ARM), focusing on high - availability, fault tolerance, and auto-scaling.

TECHNICAL SKILLS:

Database Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), Databases Maintenance Plan Wizard, Bulk Insert and BCP, ODBC, Kingsway

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage. Cache using Pipeline and SSIS, infrastructure-as-a-Service (IaaS), Software-as-a-Service (SaaS), Data Migration Service (DMS), Azure SQL Data.

T: SQL, PL/SQL, XML, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML.

Operating Systems: Windows 98/2000/2003/ XP/VISTA, Windows 7,8,10, Linux

MS: SQL Server 2008 / 2008 R 2 / 2012/2014/2016, 2017, MS Access, MySQL, DB2, ORACLE 11g

Reporting/ Analysis tools: Microsoft Excel, SSRS, SSAS, Microsoft Power BI

Application Software: Visual Studio, Visual Source Safe, MS Office, Team Foundation Server, Sub-Version, TOAD for ORACLE, EXCEL Macros

ETL Tools: DTS, SSIS, Bulk Copy Program (BCP), Control M-7, 8.00.01, 8.00.02.8.00.03

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr.BI Developer

Roles and Responsibilities:

• Designed logical and physical models for staging database and data warehouse using Erwin database modeling tool.
• Design and enhance Star Schema/Dimensional data models for Data warehouse/OLAP environments.
• Involving in database design, application development of health benefits functionality and developed mission-critical benefits eligibility exception report.
• Created SSIS packages to import data from Access , Excel, XML, OLE DB Source and Flat Files .
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion , File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Lookup, Sort, Lookup, Derived Column, Multicast, Union All, Conditional Split .
• Created alerts and mail confirmation of all packages and cube processes in SQL server Agent to get event messages such as success/failure of package, procedure.
• Deployed SSIS packages to the production server using XML and SQL server configurations.
• Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS .
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Configure and maintain using report manager and report server for SSRS , deployed and scheduled the reports in Report manager.
• Designed Power BI data visualization using Density charts, Maps, Cross tabs, Scatted plots, Pie and bar.
• Developed Power BI reports and dashboards from multiple data sources using data blending and published.
• Developer KPI Dashboards, Skill include project management, requirements, gathering KPI’s in Power BI.
• Developed Power BI model used for Patient reporting.
• Designed and Developed ETL pipelines that will read data from various sources like CRM, ADP (HR and Pay role) and JDE(Operational) and loaded into Azure SQL Datawarehouse .
• Designed Developed various objects like External Tables (HDFS format on any Azure cloud storage), Relational Tables, Views.
• Define cloud architecture, design and implementation plans for hosting complex application workloads on MS Azure.
• Experience working with Azure Data warehouse , created TSQL code to use polybase external tables to load data from ADL to ADW.
• Create user defined functions, Watermarks, Expressions in Azure Data Factory .
• Administration of Visual SVN repositories and support tortoise users.
• Integration of Tempo Time Tracking Tools in JIRA.

Confidential, Addison, TX

Sr. BI Developer

Roles and Responsibilities:

• Created complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database. Created SSIS packages to import the data into SQL server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• 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, Lookup, Merge, Derived Column and Data Conversion Transformations .
• Developed and supported SSRS reports for various business units and Optimization of Program Metrics.
• Performs Integrated Master Schedule development, maintenance, and implementation on a global program. Generation, development, and implementation of Microsoft Project scheduling processes and procedures for multiple disciplines. Management of scheduling expectations and development of templates for common efforts.
• Reports project statuses, resource availability and schedule management to program managers.
• Created reports utilizing SSRS , Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Expertise in writing complex DAX functions in Power BI and Power Pivot report , Statistical Reports and Demographics reports.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Knowledge on DAX Measures and Calculations.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
• Implemented high availability with Azure Classic and Azure Resource Manager deployment models.

Confidential, Hartford, CT

Sr. SQLBI developer

Roles and Responsibilities:

• Migrated Data from Access Database and gathering requirements and Loaded in SQL Server.
• Analyzing, modified, Data Cleansing on SQL Database and wrote complex TSQL statements and Migrated data into Excel files.
• Performed unit level testing based on unit test case documents prepared from requirements.
• Perform data analysis on source system data to understand gaps, inconsistencies, and other quality issues, and develop data quality improvement solutions
• Debugged the processes, triggers, views, monitored the system and SQL server job schedule and recorded any errors.
• Knowledge on maintaining Production Servers which are in remote location.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database. Created SSIS packages to import the data into SQL server.
• Migrating data into Microsoft Dynamics CRM Environments using SSIS Kingsway .
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Developed unit test plans for SSIS packages.
• Created Packages for Transaction processing using containers as For-Each Loop, Sequence controlling flow of data using tasks as Script, Data Flow, File System, and Execute Package.
• Created Error and Performance reports on SSIS Packages , Jobs, Stored procedures, and Triggers.
• Created a SQL reporting services ( SSRS ) and SSIS infrastructure that pulls data from data sources and provides a sample to use reporting environment.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Developed numerous ad-hoc reports using SSRS for day to day reporting.
• Expert in creating Star schema cubes using SSAS .
• Created OLAP cubes using SSAS and star schema techniques.
• Extensively worked on SSAS cube performance optimization.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Expertise in writing complex DAX functions in Power BI and Power Pivot .
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Leading the internal data visualization revolution with the creation of well-designed Power BI reports and dashboards, including automating Excel, and other reports to save staff time and reduce data errors.
• Create custom production level Power BI Reports and Dashboards that replicate in-production Tableau dashboards for their client portal.

Confidential, New York City, NY

SQLBI Developer

Roles and Responsibilities

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services ( SSIS ) Modified existing SSIS packages to meet current business needs.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups.
• Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Created Systems for capturing data in flat file destination, sending the error data in flat file attached to the corresponding mail ids using send mail task and correcting error data.
• Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Generated various reports with drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS.
• Design and develop stored procedures, queries, and views necessary to support SSRS reports.
• Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, creating reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and Datasets, calculating subtotals and grand totals for the reports using SSRS .

Confidential, New York city, NY

SQL BI Developer

Roles and Responsibilities

• Good experience in creating SQL Server database objects like tables, views, procedures, functions, and triggers for a project.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generate various reports using complex stored procedures.
• Involved in all phases of the project (Documentation, Designing, Unit testing and Defect fixing).
• Experience in developing, monitoring, extracting, and transforming data using DTS/SSIS , Import Export Wizard, and Bulk Insert.
• Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database. Created SSIS packages to import the data into SQL server.
• Create source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts.
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Experience in report writing using SQL Server Reporting Services ( SSRS ) and creating various types of reports like table, matrix, and chart report, Graphs.
• Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Provide usability and visual enhancements to the City agencies data as examples of what sets Power BI apart from other data visualization tools.
• Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using Power BI Desktop.
• Created ad-hoc reports to users in Power BI Desktop by connecting various data sources, multiple views, and associated reports.

Confidential

Database Developer

Roles and Responsibilities

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Installed and Maintained MS SQL Server 2008/2012.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts
• Created permanent tables, temporary tables, and table variables.
• Designed the entire ETL process involving the access, manipulation, analysis, interpretation, and presentation of information from both internal and secondary data sources to the business.
• Created complex ETL (SSIS) packages to pull data from DB2/Oracle, load monthly data from Excel to SQL server.
• Used master child SSIS packages for better design and ease of maintenance.
• Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution.
• Experience in data mining and analysis, design and construction of data marts, data views.
• Used Performance point service to integrate SSRS reports.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs .
• Generated various reports with drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS .

Confidential

Database Developer

Responsibilities:

• Actively participated in gathering of User Requirement and system specification.
• Developed stored procedures, views and User Defined Functions using T-SQL statements.
• Installed and Maintained MS SQL Server 2008.
• Participated in all phases of SDLC starting from Analysis to Delivery of the application development projects and supported enhancements and maintenance of existing applications.
• Involved in creating clustered and Non-Clustered Indexes to improve the database transactions performance.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Involved in Designing, Developing and Testing of the ETL ( Extract, Transformation and Load ) strategy to populate the data from various source systems feeds using SSIS .
• Designed ETL packages dealing with different data sources ( SQL Server, Flat Files ) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services ( SSIS ).
• Ability to work independently as well as work with teams having varying backgrounds on complex issues and have strong verbal and communication skills.