PROFESSIONAL SUMMARY:

• Over 16+ years of IT experience in various domains as Technical Architect, Development Team Lead, Developer that includes Architecture, Database Design and Development, Microsoft BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SQL Server 2019/2017/ 2016/2014/2012/2008 R2/2008, SSAS, SSIS, SSRS, T - SQL, Power BI and .NET.
• Diversified business knowledge in various industries including Insurance, Digital supply chain, Finance, CRM, ERP, Marketing and Logistics.
• Extensive experience in Database development for OLAP Systems (SSAS, SSIS, SSRS, Tableau and Power BI) using Azure SQL Server 2019/ 2016/2014/2012/2008 R2/2008 and Legacy MS Access database support.
• Development and support experience on POSTGRE, Sybase and Teradata databases.
• Extensive experience in Analysis services development (both star and snow flake schemas) of multi-dimensional models and tabular models using SQL Server 2019/ 2016/2014/2012/2008 R2/2008.
• Extensive ETL experience using SSIS for Data Extractions, Transformations and Loads, Provided Enterprise Reporting solutions using SSRS 2016/2014/2012/2008 R2/2008, Power BI tools (like power pivot, power views, Excel MSRA plugin, Power BI) and SharePoint Service.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, support.
• Experienced on Master data services QA environment creation and MDS data integration using SSIS.
• Developed 9 Business intelligence supporting automations for SSRS, SSIS and SSAS using C#.
• Extensively designed and developed ETL /ELT using Azure Data Factory (ADF), Azure IOT, Apache Kafka and analytics using Azure Analysis Services (AAS).
• Experienced on Azure SQL server, Azure Analytics and Azure data factory, Azure Machine learning and data encryption in SQL server.
• Experienced on Azure Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Table Storage, U-SQL, Stream Analytics and HDInsight.
• Analysis Services (SSAS Multidimensional Model / Tabular Model):
• Good understanding and designing of Star and Snowflake data models Schema used in ROLAP and MOLAP data modeling.
• Experience in designing and developing Tabular models. Implemented Role based and user based subject selection in Tabular models.
• Experience in SQL Server Analysis Services (SSAS) CUBE/Tabular design, development, deployment and tuning.
• Experience in MDX/DAX functions.
• Integration Services/ Data Transformation Services (SSIS):
• Experience in SQL Server SSIS (Integration Service) including package design, constructing, deployment and migration.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.
• Experience in populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

.

• Reporting Services (SSRS/ Power Pivots / Power Views / Power BI):
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Experience in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
• Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• TSQL (SQL Server/ Sybase / POSTGRE):
• Expertise in writing stored procedures, understanding the existing stored procedures.
• Extensive experience performance tuning using indexes, partitioning and execution plan.
• Experience in impact analysis on change requests.
• Provided production support for multiple databases.
• Created functions based on business rules.
• Experience on Temporary tables(Global, Local, CTE and table variable)

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2019/ 2016/2014/2012/2008 R2/2008, MS Access, Sybase, POSTGRESQL and Teradata.

Programming Languages: T-SQL, PL/SQL, C#.

VBA micros code development and support

Tools: & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual, Visual Studio .NET.

Operating Systems: Windows10/ 8/7/XP, Windows Server 2016/2012/2008/2003/2000.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Excel 2013 for Power Pivots, Power views and Power BI.

Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.

Application Packages: MS Office Suite, MS Outlook.

Deployment and version control: Azure DevOps, TFS, MS Octopus, PowerShell and NSIS Package creation.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Power BI Cloud and On-Prem/ PowerShell/Bitbucket

Responsibilities:

• Power BI reports development for On-prem and Azure Power BI service.
• Workspace and data refresh scheduled maintenance in Power BI Cloud.
• Technical architecture change to support external users authentication.
• Project development, testing and deployment plans.
• Cube development and validation to improve dashboards performance
• Detailed analysis on Business requirements by following JIRA stories
• Sprint wise delivery to business.
• Guided team on SSAS, Power BI, .NET and SSRS projects.
• Row level security implementation for Power BI reports and Paginated reports
• Data extraction from file system (Excel, tab delimited text files) and load in Teradata.
• GIThub DevOps utilization for code check-in, code merger and Sprint releases.

Confidential, Harrisburg, PA

SQL Server 2016/.NET 4.0/SSIS/SSAS/SSRS 2016/Power BI Cloud/ PowerShell/Azure DevOps

Responsibilities:

• Power BI and SSRS 2016 reports conversion by referring Cognos reports.
• Workspace and data refresh scheduled maintenance in Power BI Cloud.
• Provided proof of concept on two reports before application upgradation and Power BI conversion.
• Technical architecture change to improve the SSRS reports performance while rendering reports on UI.
• Experienced on project development, testing and deployment plans.
• Stored procedures preparation for SSRS reports.
• Detailed analysis on existing Cognos reports and migration to SSRS 2016.
• Report web services utilization in .NET application.
• Sharing experience on SSRS Drill through, Drill down and data driven subscriptions to team
• Ability to guide team on SSAS, Power BI, .NET and SSRS projects.
• Role based security implementation for Power BI reports.
• Data extraction from file system (Excel, tab delimited text files) and load in SQL server.
• Azure DevOps utilization for code check-in, code merger and Sprint releases.

Confidential

Tech Architect and Development Team Lead

Responsibilities:

• Created Azure data pipelines using ADF and loaded state Schools information into Azure SQL server.
• Developed jobs using ADF, managed data from different data sources, worked on structured, unstructured, and semi structured data integration in Azure Data warehouse.
• Provided VISIO diagram on data flow from on premises to Azure data warehouse.
• Experienced U-SQL code to extract data from Unstructured data.
• Implemented B2B Active directory strategies for data security and data sharing.
• Lift and shift the existing SSIS existing packages to Azure SQL server and executing packages using ADF.
• Tabular model design for Power BI reports.
• Power BI reports administration, design and deployment in power BI report server.
• Guided team on upgrading SSRS reports from .
• Provided proof of concept on two reports before application upgradation and Power BI conversion.
• Provided dynamic grouping, sorting, and filtering functionality information to team.
• Participation in project development, testing and deployment plan.
• SSRS reports deployment with PowerShell scripts.
• SQL queries preparation for SSRS reports.
• Detailed analysis on existing reports and migration to newer version.
• Utilized my SSRS web service experience and shared with team
• Experience sharing on SSRS Drill through, Drill down and data driven subscriptions to team
• Ability to guide team on SSAS, Power BI, .NET and SSRS projects.
• Role based security implementation for SSRS reports.
• TFS utilization for code check-in, code merger between Dev and Main branch.

Confidential

Technical Architect and Sr. Developer SQL Server 2016/MDS/SSIS/ MS Access

Responsibilities:

• Data modeling experience on Snowflake/Star schema
• SQL query performance tuning with execution plan.
• SSIS package development to extract data from ERP systems and load in SQL server database.
• Created Azure data pipelines using ADF and loaded state Schools information into Azure SQL server.
• Developed jobs using ADF, managed data from different data sources, worked on structured, unstructured, and semi structured data integration in Azure Data warehouse.
• Provided VISIO diagram on data flow from on premises to Azure data warehouse.
• Experienced U-SQL code to extract data from Unstructured data.
• Implemented B2B Active directory strategies for data security and data sharing.
• Lift and shift the existing SSIS existing packages to Azure SQL server and executing packages using ADF.
• Defect analysis and bug fix in SSIS packages.
• Migrated SSIS packages to ADF.
• Migrated tabular model in Azure data warehouse.
• Detailed analysis on MS access database-oriented Queries and SSIS package preparation for data extraction, transformation, and load.
• Extract data using SSIS from MDS and ORACLE JD Edwards ERP system data to SQL Server.
• Failure log in log files maintenance using SSIS package.
• Experience on Fact and Dimension model.
• Tabular model design for Power Bi reports.
• SSRS reports development for MDS information.
• Created DAX expressions for tabular model.
• Row level security implementation.
• Perspectives implementation on tabular model.

Confidential, Redmond, WA

Development Team Lead SQL Server/SSIS/SSAS/Power BI Cloud

Responsibilities:

• Worked in agile release life cycle as a SQL developer.
• Azure migration SQL server 2014 database, warehouse, and tabular model development
• Conduct thorough unit testing of code and document the unit test cases with the help of TFS MTM.
• Conduct appropriate performance testing to ensure solutions will meet performance criteria in meeting large volume data sets.
• Create Technical Design Specification documentation that clearly articulates the design and code being implemented.
• Data integrations using ETL
• Extract data from SAP generated tab delimiter text files and load into SQL Server.
• Worked on Azure SQL server migration for MS Sales project
• Stored data in Azure Blob storage
• Generated failure log in log files using ETL.
• Used TFS for code repository and code merging between monthly releases
• Deployments have been performed using MS octopus.
• Prepared stored procedures for application.
• Configuration changes performed for MSRA reports generation.
• Conducted code reviews with peer group before code check-in in TFS.
• Worked on more than 1TB database to support Microsoft sales report analysis using facts and dimensions.
• Experience on Fact and Dimension model.
• Work experience on Power BI reports
• Created DAX expressions for Power BI reports.
• Implemented row level security for Power BI reports.
• Worked on telemetry power BI report using MS Sales analysis database.
• Experienced on DBA activities like log shipping, environment setup for each release.
• Release management using MS release tool.

Confidential, Dublin, Ireland

Sr. Developer SSAS/SSIS/SSRS/Power Pivot/Power View / CRM

Responsibilities:

• Designed developed tabular models to hold data which can be easily used for generating Power pivots and Power Views.
• Implemented complex calculations in tabular model using DAX and complex calculations in multi-dimensional models using MDX
• Experienced in Designing, Building the Dimensions, cubes/Tabular with star schema using SQL Server Analysis Services (SSAS).
• Implemented all security levels in cubes/Tabular.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Worked in Creating partitions and Designing various storage modes to increase the performance of a cube/Tabular using SSAS.
• Also worked on Performance tuning of existing cubes/Tabular.Datawarehouse/Datamarts/ETL development using SSIS
• Designed and implemented SQL Server DATA WAREHOUSE based on business requirements.
• Has worked on designing of SQL-DB (especially star and snowflake) and optimizing the databases
• Developed SSIS Packages for pulling the data from source systems along with transformations and making them into facts and dimensions (Data Warehouse) which are required for building cubes (SSAS).
• Implemented different deployment models in SQL server 2012.
• CRM data integration with SSIS packages.Reports development with SSRS
• Developed complex SSRS and power pivot and power views.
• Have come up with some innovative ideas to implement complex things (by reducing re-work).
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed power pivots, power views, power queries and hosted the same in share point.
• Responsible for scheduling the subscription reports with the subscription report wizard. Played a Content Manager role on report server

Environment: MS SQL Server 2012/2008R2/2005, SQL Server Data Tools, Business Intelligence Development Studio, Visio, MS SQL Analysis Services 2012/2008R2, SQL server reporting services, MS Excel 2013/2010, Visual Studio 2013,Share point 2010, Power BI tools(Power Pivot, Power Query, Power Views)Employer: Accenture, India

Confidential, Redmond, Washington

Sr. Developer SQL Server ASP.NET/SSRS/SSIS Developer

Responsibilities:

• User address validation using 3rd party WCF service i.e., cybersource
• Adobe Omniture library usage for tracking User interest in Club Bing site.
• Work experience on .net 3.5 version.
• Automated SQL reports and Fraud functionality.
• Arvato Windows service management for prize distribution.
• Omiture data capture with respect to site clicks.
• Integrated Excel files data into SQL server using SSIS packages.
• Code merging and TFS deployments till pre prod.
• Web analytics using Adobe Omniture.
• Reports generation using SSRS
• Data integration using SSIS
• Used AJAX for client-side validations

Environment: ASP.NET, WCF, Reporting Services (SSRS), Integration Services (SSIS), C#, XML, Visual Studio 2008/2010, SQL server 2008R2/2008, MS Word, MS Excel Visio.

Confidential

Sr. Developer POSTGRE/ ASP.NET/Dundas charts

Responsibilities:

• Requirement gathering and documentation
• C# coding for TFG app utilization, used DUNDAS software DLLs to generate reports.
• POSTGRE database table creation, data load.
• Implemented DML commands on POSTGRE.
• DUNDAS reports have been implemented based on POSTGRE data.
• Created login page based on the authentication.
• Created web config file while deploying the project.
• Testing and Bug fixes using Bugzilla.
• Packaging with NSIS(Nullsoft Scriptable Install System) scripts.
• Implementation, Troubleshooting and Support Automated SQL reports and Fraud functionality.
• Integrated Excel data into SQL server using SSIS packages.

Environment: ASP.NET, DUNDAS software DLLs, Integration Services (SSIS), C#, XML, Visual Studio 2008, POSTGRE, MS Word, MS Excel Visio, NSIS scripts, JavaScript.

Confidential

Sr. Developer SQL Server/Sybase/ .NET/Dundas charts

Responsibilities:

• Winforms design, C# coding on data grid for CRUD operations and documentation.
• Testing and Bug fix using TFS.
• Used webservice to update or retrieve data from SQL server
• Support requests handling.
• Sybase database data integration with MSSQL server 2005

Environment: Visual Studio 2005, C#, Integration Services (SSIS), C#, XML, Sybase, MS Word, MS Excel Visio, TFS.

Confidential

Developer SQLServer2000/ .NET/MSOffice

Responsibilities:

• Asp.NET pages design and coding in C#
• Primary interop assembly’s usage to generate MS Word reports
• Deploying web application in server.
• Testing with help of Bugzilla
• Maintenance and Support
• Office automation using PIA assemblies using .net 1.1 framework

Environment: Visual Studio 2003, C#, XML, SQL Server 2000, MS Word, MS Excel.