Irfan Muzammil SM

Business Intelligence & .Net

adxv5t@r.postjobfree.com +1-848-***-**** New Jersey

EXECUTIVE SUMMARY

Microsoft Azure Certified Professional with around 9 years of profound experience as Microsoft SQL Server & Business Intelligence, in Healthcare, Insurance & Finance domains.

Expertise in Application development, Major & Minor Enhancements, Maintenance and production Support in SQL Server & business intelligence

Worked on all phases of SDLC & data warehouse includes Requirement Analysis, Design, Coding, Testing, Integration, Code Reviews, Implementation, Maintenance analyzing issues & defect fixing

Highly proficient in T-SQL, SSIS, SSRS, MS SQL Server 2018/2016/2014/2008 and Stored Procedures, Triggers, Functions, XML, Cursors, Indexed view in SQL Server.

Trained and manage developers, advising other groups in organization on SSIS development, data warehouse development and ETL development best practices & Expertise in T-SQL, C#, SSIS, SSRS

Expert in Performance improvement by tuning database applications, error handling via TRY/CATCH with event logging, locking/Dead Lock/block management & Service Broker for SQL Messaging Framework in SQL Server, jobs, reports & SSIS packages.

Having good experience in Analyses & Performance improvement of SQL jobs by using SQL Profiler, SQL Activity Monitor, SQL Tuning Advisor and Query Execution Plan.

Good SSIS Experience in usage of Control flow, Data flow, ETL, Execute package, Expressions & precedence constraints, static, dynamic variables, file dynamic loading, For each loop, sequence containers & Transactions and script tasks and Sending mail tasks.

Experienced on Database administration tasks such as DB Back up and restoration through Maintenance plan, Encryption and decryption on DB, Table and column level, Updating statistics, and Achieving High availability for DB Servers.

Good Knowledge on Migration of On Premises SQL DB to Azure SQL Server and DB.

Good Knowledge on creation of Azure SQL Server, Azure SQL DB, Azure Data factory, Linked services, Pipelines & Integration Run time in Azure portal.

Good knowledge on Creation of Source, Target datasets, Transferring data by using Copy Data Activity in ADF ( Azure data factory), Azure SSIS IR & Azure Integration Runtime

Experienced in using Microsoft dynamic CRM for user and client data management. Worked Microsoft dynamic CRM Back end database

Having Good Knowledge in Red Gate Plug in functionalities such as SQL Compare, SQL Search, Push & Pull the objects between SQL Server and source control such as GIT, TFS, SVN

Experienced in Event handlers, Error logging, check points, Mail sending and debugging in SSIS

Expertise on SSRS reports creation, configuration, security, consuming API, subscription.

Working Experience on Both SSAS Tabular & Multidimensional Models and good knowledge on SSAS MDX Queries with Rank, Case, Tupples & Sets.

Experience in using CTEs, Derived tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data Warehouse consistency as well as to support the existing applications

Having Good knowledge on the Azure Data warehouse concepts like Azure SQL, Blob storage, Azure VMs, SaaS, PaaS, IaaS concepts.

Good Knowledge on Migration of on Premises SSIS packages to Azure Data Factory.

Having Good knowledge on SSAS cube design including named queries, named calculations, perspectives, hierarchies, KPIs, partitions and deployment.

Improved SQL jobs by using Query execution planner & SQL profiling tools in SQL server

Worked on High priority Production issues both in SQL and SSIS with minimal SLAs

Expert in MSBI solutions, web and windows applications through .Net framework.

Expertise in creating complex SSIS packages for ETL purposes in 2014/2012/ 2008 as an ETL.

Created SSIS packages involved ETL, transformations such as Lookup, Aggregate, Derived Column, Conditional Split, Union All, Merge, Data conversion and loading to Data Warehouse

Experienced in loading different data source data to SSIS packages like SQL server, flat file & csv.

SSIS Expertise In Full, Incremental Load, change data capture, Slowly Changing Dimensions

Having vast experience in Linked servers, Open query and open Row set queries in SQL server

Expertise in Creation Of Different Type of SSRS Reports Such As Parameterized, Multi Valued, Cascade Parameterized, Sub Reports, Drill Down And Drill Through Reports

Led the team for Cloud Migration from one client server to new servers with jobs migration.

Experience in Logging, Error handling using Event Handlers & Error output configuration for SSIS

Development experience in Agile methodology with scrum process with all scrum ceremonies.

Managed the source code repositories such as TFS, SVN AND GIT & Experience in Control M jobs

Having Development experience in back end, front end & middle layer of applications

Led the Migration activities such as firewall requests, firewall validations, software installations, job configurations and job validations and migrations issues fixes etc.

TRAINING & CERTIFIATIONS

Generic and Stream (MSBI &.NET) training completed in Infosys Limited - Mysore.

Achieved Microsoft certification in Azure - AZ-900.

Achieved Power BI certification through the learning platform.

SOFTWARE PROFICIENCY

Development Languages

MS SQL, HTML, MDX, DAX queries, C#.Net & Batch scripts

Database

SQL Server 2008/2014/2016/2017, Microsoft Azure SQL, Oracle

DB Transformation Tool

SSIS, Azure Data Factory.

DB Reporting Tool

SSRS, Power BI, PBI Desktop

Analyzing Tool

SSAS Tabular, SSAS Multidimensional, Power BI

Mark Up Language

HTML 4.0, XML, XAML

IDE

Microsoft Visual Studio, SQL server Data Tools for Visual studio.

Additional Tools

JIRA, Service Now, Red Gate Plug-in, Microsoft Dynamic CRM.

Domain Knowledge

Pharmacy, Insurance, Finance & Banking.

Server

SQL, SSIS Server, SSAS Server, Azure Server, IIS, Azure

Other Skills

SCRUM, Waterfall, Postman Services, CTRL M job Scheduling

Source Control

TFS, SVN, GIT

EMPLOYMENT HISTORY

Project: Celergo 2.0 Development – BI Data team 11/2022 – Till Date

Client: ADP (Automatic Data Processing) Inc, Parsippany, NJ, U.S.A

Developer, DBA - SQL, SSIS/ SSRS

Automatic Data Processing, Inc. is an American provider of human resources management software and services, headquartered in Roseland, New Jersey.

SSRS Reports Development for different clients for payroll management, SSIS Jobs for automations.

Monitoring tool was Siebel, Jira, Reporting tools are SSRS and Power BI, Process followed was Agile and Scrum and source code repository was Bit Bucket.

Responsibilities:

Designed and developed SSRS reports based on the client requirements by using visual studio 2017 and SQL Server 2018.

Database schemas, tables, indexes, stored procedures, views, linked server concepts, cursors, triggers, optimization techniques and functions using -SQL scripts.

Database schema comparison through visual studio to compare the different databases and servers

Got appreciated by development of data scrambling project to scramble the client data in lower environments based on selected clients to manage the data protection / privacy in lower environments

Development/Enhancement the SSRS Files (.Rdl) based on the User requirements.

Worked on SQL JOB Creation in SQL Server 2016, SQL Server 2018.

Worked on Data purging based on the client requirements.

Lead the Weekly deployments of Database changes, Reports and packages.

Worked on DB migration tool to get the historical data based on the payroll, pay period and clients.

Great experience on managing Microsoft dynamic CRM for the client data management and reports deployments. Worked and deployed changes on all CRM environments (DEV,TEST,UAT & PROD)

Vast Experience in creating complex T-SQL, Open query, Open Row set queries and linked servers

Experienced in creation of different report such as drill down, drill through reports

Experienced in creation and interactive sorting in SSRS reports by having the groups created.

Involved in Code review, Code merge, Code deployment, support for the development applications.

Worked on Seibel tickets to support the applications and reports as a production support activities.

Involved in testing like Unit test, Integration test, Acceptance test and Regression testing.

Responsible for bug fixes, root cause analysis and other bug fixes activities.

Involved in HOTS, Review & Scrum meetings, planning and other meetings through scrum process.

Taken ownerships on delivery, deployment and demo activities for projects or stories worked by team

Developed parameterized SQL queries and stored procedures

Involved in complete SDLC cycle from analysis through deployment and maintenance

Key Skills & Tools:

T-SQL, SSRS, SSIS, MICROSOFT CRM, C#, SQL Agent, JIRA, Bit Bucket, Siebel.

Project: Western Union Business Solution – BI Data team 07/2021 – 10/2022

Client: Western Union, Denver, Colorado, U.S.A

Tech Lead, SQL, SSIS/ SSRS

Western Union is an American multinational financial services company, headquartered in Denver, Colorado and it offers money transfer services to every country Iran and North Korea.

Development of SSIS Jobs, SQL Jobs, SSRS Jobs, Dot net applications as well

The Trades are reported using POWER BI.

Monitoring tool was JIRA and reporting tools are SSRS and Power BI with Agile and Scrum Process

Data analysis and performance Improvements in business intelligence projects.

Responsibilities:

Designed and developed database schemas, tables, indexes, stored procedures, views, linked server concepts, cursors, triggers, optimization techniques and functions using -SQL scripts.

Improved the performance of real-time business activity monitoring report and reduce the report response time by more than 50%

Development/Enhancement in the SSIS packages with Error handling, Event handling, Performance improvements, SSIS job schedules, XML and SQL package configurations.

Development/Enhancement the SSRS Files (.Rdl) based on the User requirements.

Worked on SQL JOB Creation in SQL Server 2016, SQL Server 2018.

Developed various transformations and error handling in SSIS jobs.

Experienced in Project & Package deployment of SSIS. Used XML and SQL table for package configurations.

Led the team for the migration of all jobs, servers from one to other cloud environments.

Led Team from front to manage all the activities with respect to JIRA Development Stories.

Vast Experience in creating complex T-SQL, Open query, Open Row set queries and linked servers

Experienced In Usage Of For each Loop And For Loop Containers And Script Components In SSIS

Experienced in creation of different report such as drill down, drill through reports

Experienced in Creating Power BI reports with integration of SSIS and SQL server.

Designed SSRS reports as per client requirements using Visual studio SQL server Data tools

Involved in Code review, Code merge, Code deployment, support for the development applications.

Created SSIS packages which involved a variety of transformations & loading into Data Warehouse

Experienced In Usage Of Static And Dynamic Variables, Parameters And Expressions In SSIS

Involved in testing like Unit test, Integration test, Acceptance test and Regression testing.

Responsible for bug fixes, root cause analysis and other bug fixes activities.

Worked on Deployment of SSIS Jobs, SQL Jobs, Console Applications, services, SSRS Jobs.

Involved in HOTS, Review & Scrum meetings, planning and other meetings through scrum process.

Taken ownerships on delivery & deployment activities for projects or stories worked by team

Developed parameterized SQL queries and stored procedures

Involved in complete SDLC cycle from analysis through deployment and maintenance

Worked on Power BI reports to have the SSRS reports replacements.

Key Skills & Tools:

T-SQL, SSIS, SSRS, DAX, Power BI Reports, C#, XML, HTML, SQL Agent, JIRA, GIT hub.

Project: Ultimus Org Chart Update & Enhancements for Mexico applications 02/2020 – 06/2021

Client : Ultimus, NY, USA

Senior SQL, SSIS Developer, Cognizant Technologies Solutions

Ultimus BPM Studio is a collaborative Integrated Development Environment (IDE) used to design, model, develop, simulate, and test every business process.

Application Development for loading business data to DB, performing business logics, invoking web service with data processed, Updating Organization chart of Ultimus UI

Support for Ultimus Latam applications with ticket handling by service now and Database analysis and performance improvements for reduction of tickets.

Responsibilities:

Responsible for development, Enhancement & Support activities of various applications of Ulitmus

Reduced number of major incidents by 23% through problem management

Improved the customer service by implementing the Access provision Automation

Developed Console application to have the data fetched from Database and sending to Web Service

Achieved the service Improvements in existing applications by presenting the ideas with clients

Expert in production support activities like bug fixes and root cause analysis.

Responsible and Maintained the source code in SVN Source code repository for all the projects.

Communication with direct app users to know the issues and resolution on the same.

Coding, Performing Unit and Integration Test and code reviews for peer developer.

Analyzed the data through postman services application to know the web API activities.

Developed on SSIS and SSRS projects where there is need of BI enhancements and support activities.

Analyzed on Data warehouse concepts like Extract, Transformation and Load with good experience!

Developed data models to convert raw data into actionable insights in Power BI.

Tested and Reviewed Data warehouse SSIS packages, fixed bugs using SSDT.

Key Skills & Tools:

T-SQL, SSIS, C#, SVN, Control M schedule, SQL Agent, WCF

Project: IDIC, CFDI, E Auto Sanofi 10/2018 – 02/2020

Client : Sanofi, France (Pharma)

Senior SQL, SSIS Developer and support, Cognizant Technologies Solutions

Sanofi is a French multinational pharmaceutical and healthcare company headquartered in France

Development, Enhancement and support for Sanofi applications which is used for pharma domain.

Responsibilities:

Responsible for development, Enhancement & Support activities of various applications of Sanofi

Expert in production support activities like bug fixes and root cause analysis.

Responsible and Maintained the source code in SVN Source code repository for all the projects.

Communication with direct app users to know the issues and resolution on the same.

Coding, Performing Unit and Integration Test and code reviews for peer developer.

Analyzed on Data warehouse concepts like Extract, Transformation and Load with good experience!

Developed data models to convert raw data into actionable insights in Power BI.

Enhancement and Tested and Reviewed Data warehouse SSIS packages, fixed bugs using SSDT.

Key Skills:

SSIS, T-SQL, C#, MVC, WCF, WEB SERVICES, SVN, MS SQL, ASP.NET, HTML, CSS, LINQ

Project: ACE Next Application Development 05/2017 – 06/2018

Client : Travelex, UAE Exchange, Abu Dhabi, UAE

MS SQL Server Developer/ WPF

Travelex is currency exchange company. Its businesses are currency exchange, issuing prepaid credit cards for use by travelers, supplying central banks with foreign currency and global remittance.

Development of windows based WPF application with SQL Server for Money Remittance, Reports generation, Currency Conversion using MVVM pattern Includes Log shipping and high availability.

Responsibilities:

Designed and Developed the user interface and services for the Ace Next Application product using C#, WPF, MS SQL, XAML, Entity Framework, XML, LINQ.

Organized and discussed in requirements for the development of Reports generation

Developed the report generation in the WPF ACE Next application.

Created parameterized SQL queries and stored procedures to query database tables.

Developed stored procedures, views, tables, cursors for the required functionalities

Developed Functions, Triggers for the requirements & email functionalities for the report submission.

Developed localization concept to make sure the application is feasible for all the regions or all countries with their own languages for the user communication.

Involved & created different patches for different deployments based on testing in QA&UAT

Created and scheduled windows services based on the requirements.

Involved in testing like Unit test, Integration test, Acceptance test and Regression testing.

Involved in bug fixes, root cause analysis and other bug fixes activities.

Provided Test support and deployment support activities

Skills & Tools Used:

T-SQL, WPF, MVVM, XAML, SVN, SQL Server 2014, Visual Studio 2017, Entity Framework.

Project Title: AllState Finance Inforce Metrics & Selection DB 03/2016 – 04/2017

Client: All State Insurance, Illinois

SSIS/SSAS/SSRS Developer, Insurance, Infosys Limited

BIE is a data repository and reporting environment. This project gives an opportunity to

enhance the existing BIE DE Normalized and Normalized models for the purpose of AFIM reporting and selection database extracts for Selection DB .

Responsibilities:

Involved in gathering requirements, mentoring the team and delivers the code on time

Created OLAP Tabular models for analysis.

Created CUBES with dimensions and fact tables.

Analyzing project and design specifications

Develop software improvement initiatives to minimize operating time and maximize efficiency.

Preparation of high level design, detailed level design, coding; code review.

Involved in Unit Testing and Functional testing.

Monitoring the Month End Support activities

Analyze the business and system requirements.

Identify and validate defects found

Participate in knowledge management activities

Project: Valuation Monthly Close Processing Optimization 05/2014 – 02/2016

Client : Allstate Insurance, Illinois, USA

MS SQL Server/SSIS Developer, Insurance, Infosys Limited

Improved monthly close process 60% by re organizing the process and by reducing manual works.

Data Analysis, Optimization & process improvement consists of receiving Business files, zipping, copying, loading to DB, Transforming and sending data to downstream & reducing manual works.

Dealt and maintained application with Life, Property and Causality coverage Insurance products.

Responsibilities:

Prepared and involved in discussion for business requirements for performance improvement

Eliminated 60% of manual interventions & decreased SLA breaches for client reporting by 15%

Created the functional requirements and planned for the development.

Improved the performance of applications by tuning database run

Developed the export mechanism using SSIS packages in a regular interval manner.

Developed stored procedures, views, tables, cursors for the required functionalities

Used Email Mechanism using SMTP protocol for email functionalities

File watcher jobs scheduled to find file and invoke jobs instead of waiting for manual intervention

Balance & control mechanism implemented to validate records loaded to database and input file

Retention process was implemented to have retention mechanism of DB data in regular interval

SQL Agent jobs were created to have the retention process implemented and scheduled

Coding, Performing Unit and Integration Test. Maintaining the code in TFS.

Involved in testing like Unit test, Integration test, Acceptance test and Regression testing.

Key Skills:

C#, MS SQL Server 2008, Batch Scripts, SSIS, SMTP, File Watcher jobs, SQL Agent Jobs, TFS, C#.

EDUCATION AND PROFESSIONAL DEVELOPMENT

Bachelors in Electrical and Electronics Engineering May 2014, Anna University

RMDEC, Chennai

Contact this candidate