SUMMARY

• Around 4+ Years of extensive IT experience as a Microsoft SQL Server 2019/2016/2014 Developer in creating Business Intelligence Solutions like SSIS, SSRS and expertise in designing and implementing Relational Database model as per business needs.
• Extensive abilities in writing T - SQL queries and developing SQL databases.
• Used Sub-Queries and Joins to simplify complex queries involving multiple tables.
• Expert in writing T-SQL queries, complex Stored Procedures, Views, Indexes, Cursors, User Defined Functions (UDF), User Profiles, designing and implementing Database triggers, DDL/DML Triggers, and Relational Database Models and Data Integrity to implement Business Logic and Data Protection.
• Experience in bulk importing CSV, XML and Flat files data using Bulk copy program BCP.
• Experienced in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading.
• Design and implement new ETL processes and adapting current ETL processes to accommodate changes in source systems/new business user requirements SSIS.
• Experience in developing and maintaining SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Tera data, Flat files.
• Experience in designing, configuring, deploying SSIS packages and providing security for packages.
• Implemented Incremental Load for many SSIS packages.
• Performed Logging and Deployment of various packages in SSIS.
• ETL implementation using SQL Server Integration Services SSIS, Reporting Services SSRS.
• Experience on data migration from SQL Server .
• Extensive Visual Studio, SSDT and Microsoft SQL Server 2016 using the complete BI Tool Set
• Deployment and development of Performance Point and SharePoint Server.
• Expert on Microsoft Power BI and Tableau reports, dashboards, and publishing to the end users for executive level Business Decision.
• Expert on maintaining and managing Tableau and Power BI-driven reports and dashboards.
• Develop detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to End user business requirements using SSRS.
• Developing reports on SSRS on SQL Server 2019/2016/2014 .
• Created stored procedure for generating reports using SQL Server Reporting Services SSRS.
• Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools) worked on Azure suite: Azure SQL Database, Azure Data Lake (ADLS), Azure Data Factory (ADF) V2, Azure SQL Data Warehouse, Azure Service Bus, Azure key Vault, Azure Analysis Service (AAS), Azure Blob Storage, Azure Search, Azure App Service, Azure data Platform Services.
• Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.

TECHNICAL SKILLS

Databases: MS SQL Server 2019/2016/2015/2008 R2, MySQL, DB2, Oracle 18c, 19c. MS Access 2003/2000.

Tools: SQL Server Management Studio, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analytical Services, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Tableau, Power BI, ADF, SQL Developer, Toad, Microsoft Office, Excel Power Pivot, SharePoint integration, Excel Data Explorer, Business Intelligence Development Studio (BIDS)

BI Suit: SSIS, SSRS, Tableau, Power BI, SAS.

Reporting: SSRS, Tableau, Power BI, Crystal Report

ETL Tools: c

Programming Skills: T-SQL, C-Sharp, Power Shell, Python .NET, API, HTTP, HTML, JSON, Java, XML

Modeling Tool: Erwin 4.1, ER Studio, MS Visio.

PROFESSIONAL EXPERIENCE

MSBI/Sr. SQL Developer

Confidential, San Francisco, CA

Responsibilities:

• Involved in gatheringbusiness requirements, functionalrequirements,and dataspecifications and analyzing them.
• Developed and customizedcomplexSSISpackages,proceduresand functionsfor migrating data from legacy databases to new system.
• Hands on Experienceinworking withViews,Triggers, Stored procedures and functionsfor migrating data from legacy databases to new system.
• Analyzing tables and indexes, creatingrequiredindexesand tuning SQL queries. Loading the data from base tables to staging area usingSSIS
• Creating and managingDatabase projectsusing Visual Studio and setting up the auto deployments to servers usingJenkinstool.
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.
• Developing technicaldocumentation and providing process guide.
• Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, UDF's, constraints.
• Developed transact-SQL commands including complex queries, views, functions, stored procedures, cursors, and triggers on SQL server 2019/2016/2014 .
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.
• Designed packages in SSIS 2008 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.
• Created packages with Ragged Right data mapping.
• Experience in tools and systems on MS SQL Server BI Stack, including SSRS and T-SQL, Power Query, MDX, PowerBI, and DAX.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• ConvertedExcel Reports to Tableau Dashboardwith High Visualization and Good Flexibility.
• Designing and Developing the Dashboard Reports in Tableau.
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2019.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Cascading Parameters Crystal Reports, Sub reports, Ad-hoc reports, Drill down & Drill through reports using SQL Server Reporting Services (SSRS).
• Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using SSRS.
• Identify key performance indicators (KPIs) with clear objectives and consistently monitor those.
• Worked on projects using Agile and Waterfall model methodologies.
• Configured JIRA workflows according to the needs to the CM team and integrated the project.
• Management features of JIRA with the build and release process.
• Experience with centralized version control system such as Subversion (SVN) and distributed version control system such as GIT.
• Experience in Windows Azure, migrating database to Azure.
• Experience in database design and development using SQL Azure, Microsoft SQL Server, and Microsoft Access. Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services.

Environment: MS SQL Server 2019 R2, T-SQL, Data Stage. GitHub,TFS,MS SQL Integration Services 2019, MS SQL reporting Services2019, Power BI Service, DAX Studio, Tableau Server, Microsoft Visual Studio 2019, Crystal Reports, SharePoint Designer, SQL Server Management Studio, Azure.

MSBI/Tableau Developer

Confidential, Hackensack, NJ

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Extensive use of Stored Procedures by creating new stored procedures and modifying existing ones.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data and normalized tables.
• Established Joins and created Clustered/Non-clustered Indexes wherever necessary.
• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and technical specifications.
• Designed and created views for security purposes, implemented rules, defaults, user-defined data types, documented the table relationships with diagrams.
• Monitored and scheduled existing/new jobs on production environment.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated data from SAS environment to SQL Server 2019 with SQL Server Integrated Services SSIS.
• Migrated DTS objects to SQL Server Integrated Services SSIS environment.
• Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Develop and deploy dashboards, visualizations, and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the BI reporting platform, web portal, mobile, tablet devices, widgets, and email.
• Design and develop Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Designed, developed, and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Experience in Enterprise Environment and preparing Dashboards using calculations, parameters in Tableau.
• Created ad-hoc reports to users in Tableau Desktop by connecting various data sources, multiple views, and associated reports.
• Created user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)
• Created Parameterized, Cascaded, Drill-down, Crosstab and Drill-through Reports using SSRS 2019.
• Involved in migration and Conversion of Reports from SSRS .
• Responsible for gathering business requirements to create business user reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Experience in Configuring Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server Services.
• Followed Agile Methodology and coordinated daily Scrum meetings.
• Created usage-based aggregations in cube to minimize time for query retrieval from client tool Target.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
• Experience working with GitHub and JIRA for version management and bug tracking or a similar system.
• Provide TFS Security, Access administration and maintained workflows and managed deployments automated through TFS Using Perl object language.
• Setup and maintained GIT repositories along with the creation of branches and tags.

Environment: MS SQL Server 2019/2016, DTS, T-SQL, XML, Crystal Reports, Flat File, Data Stage, SQL Server SSIS, SSRS, Visio, IIS,Azure,GIT,TFS, Tabular Models, Azure, Tableau, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, Power BI Service.

SSRS/SQL/ETL Developer

Confidential, Atlanta, GA

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Used different Control Flow Tasks and Data flow Tasks for creating SSIS Packages. Designed packages using different types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks.
• Created Test script forUATand Production and developed Unit Test Plans Documentation.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Monitoring nightly ETL process from various highly different source systems and sources included SQL based databases and Excel Files. Also ensured that nightly backup jobs or cube processing or other ETL jobs didn't interfere with each other.
• Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in writing custom code expressions in SSRS.
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing, and debugging its components, and monitoring the resulting executable versions.
• Created Report Models for Business Users to create their own reports.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• Managed security and user access to Analysis Services cubes using creation of Groups and Roles by creating windows AD and Perspectives within the OLAP cube.
• Involved in Product Releases and support calls.

Environment: SQL Server 2016/2018, Data Stage, T-SQL, SSIS, SSRS, Crystal Reports, Share Point 2010, BIDS.