SUMMARY

• MS Business Intelligence Developer with 6+ years of experience working with BI applications; SSMS, SSIS, SSRS, SSAS in Development, Test, and Production Environments.
• Variety work experience in different industry domains such as service, insurance, and finance. Excellent analytical, communication, and interpersonal skills.
• Competent in writing and presenting complex technical concepts, comfortable working independently and with different sizes of teams.
• SQL/ETL Developer having 6+ years of IT experience in Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
• Experience in IT with a solid background in Database development and Data warehousing using MS SSIS/SSAS/SSRS
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions (SCD) and Dimensional Modeling (Kimball/Inmon methodologies, Star Schema and SnowFlake Schema)
• Hands-on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2016/2014/2012/2008 R2/2008.
• Experience in developing, monitoring, extracting, and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Exceptional knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.
• Experienced in High Level Design of ETL Packages and SSIS Packages for sourcing OLE DB connection from heterogeneous sources like (Excel, CSV and flat files, MS Access, SAS, Oracle, DB2,)
• Experienced in using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Derived Column, Merge, Merge Join and Union all.
• Strong knowledge of Performance Tuning and Query Optimization.
• Skilled in maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.
• Experienced in Cloud implementation for BI platforms using Azure SQL PAAS/SAAS/IAAS, Azure Synapse and Azure Data factory.
• Created a lot of complex and custom Power BI reports, using Power BI Desktop and Power BI Service.

TECHNICAL SKILLS

OS: Windows XP/7/10, Windows Server 2016/12/08, UNIX/LINUX

Databases: SQL Server 2016/14/12/08 R2, Oracle 11g/8.0i, MS Access 2000/8.0, Teradata 14.0, DB2

Languages: T-SQL, PL/SQL, MDX, DAX, C#, VB.NET, XML, MYSQL, HTML, ASP.NET, .NET FrameWork, C, C++, JavaScript

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML 1.0, JavaScript, VB Script

ETL & Reporting: SSDT 2016/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS 2016/ 2014/2012/2008 R2), SQL Server Reporting Services (SSRS 2016/2014/2012 /2008 R2), PowerBI, SQL Server Analysis Services (SSAS)

Others: MS Office, Crystal Reports XI, Visio, Service Oriented Architecture (SOA), SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, DataStage, Informatica, Hadoop, Micro Strategy, ER-Studio, Microsoft TFS, Microsoft GIT, MS VSS, Synergy, HP Quality Center & Jira, Master Data management, Data Quality Services

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL BI ETL/SSIS Developer

Environment: MS SQL Server 2012/2008, MS SQL Server Master Data Services 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio/.NET 2008, SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data.

Responsibilities:

• Used provided existing tools and participated in meetings with the business users to gather requirements and design goals of the data warehouse.
• Provided a report on findings and recommendations based on analysis in order to satisfy clients inside the company and clients of the company.
• Identified trends and performance levels for metrics based on established benchmarks and created benchmarks using standard approaches.
• Served as the point of contact for projects with minimal ambiguity around the customer's objective for analytic request including creating analytic data sets and coordinating ad hoc analyses to address member inquiries & resolve anomalies.
• Worked on more than one of company mergers and data transportation on acquired companies.
• Assisted with creating ETL packages for data monitoring for mergers.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Lookup and Merge Join as required using SSIS.
• Developed SSIS packages for File Transfer from one location to the other using FTP tasks.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.
• Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in the Data warehouse.
• Deployed complex packages from development to production environment using proper package configuration.
• Scheduled the SSIS packages to keep extracting the data from OLTP at specific time intervals upon request.
• Created specific stored procedures on request to assist clients during COVID-19 for client loans.
• Created SSIS packages to help update the data to provide the clients with live data due to COVID-19
• Created stored procedures and correct perimeters upon requirements to keep with the federal guidelines with SBA loan.
• Did data transformation and data cleaning operations at the source query to reduce the load and to improve the performance of the Power BI report
• Developed queries via joining various tables to validate the data coming with different data discrepancies using existing fields and quantifying results with calculations.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal and default like queried and non-queried.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition in the reports.
• Created ETL packages to email reports on a daily/weekly/monthly/Quarterly and annual basis upon request.
• Created multiple pages using report view, with different tiles and visuals such as Bars, Pie and Column charts, Single or Multi Row cards
• Performed performance tuning and optimization of queries and stored procedures for reports that took longer execution time using MS SQL Profiler which were sent to clients and managers.
• Experience in working with Normalization/Denormalization, data design methodology and building Referential Integrity for the relational Database Model implementing as per business requirement.
• Flexible and project-oriented team player with excellent communication and leadership skills to develop creative solutions for challenging client needs.
• Created a lot of complex and custom Power BI reports, using Power BI Desktop and Power BI Service.
• Utilized Power Query Editor, which uses M language for building queries and merging (join), appending (union) or grouping the query dataset.
• Used Power Query to add custom columns such as conditional columns, index columns before loading the data into Power BI desktop.
• Used Data view to write complex DAX (Data Analysis Expression) to create Calculated Column (calculated for each row in the dataset) and Measure (calculated once, single value).
• Configured relationship properties such as cardinality at model view, cross filter direction and active properties.

Confidential

SQL/ETL Developer (SSIS, Power BI, SSRS, SSAS)

Environment: MS SQL Server 20012, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data

Responsibilities:

• Developed SQL queries or stored procedures used by reports to retrieve information from relational databases and data warehouses.
• Experience writing T-SQL functions views and other SQL Server constructs for use in ETL and reporting
• Created and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Shadowed deploying SSIS Package into Production and used Package configuration to export various package properties to make the package environment independent.
• Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.
• Supported Production Environment with daily checkups for maintaining scheduled packages
• Worked in partially blocking transformations and expertise in performance tuning of SSIS packages.
• Expertise in maintaining and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Proficient in developing parameterized reports, charts, graphs, linked reports, drill down reports using Power BI.
• Created SQL JOBS and scheduling and set alerts.
• Developed filters, reports, dashboards and created chart types, visualizations and complex calculations to manipulate the data in Power BI.
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions
• Used Power BI to implement a semantic model to simplify the analysis of business data and relationships by loading relevant data from Azure Synapse data warehouse

Confidential

SQL BI Developer (SSIS, Power BI, SSRS, SSAS)

Environment: MS SQL Server 2016/20012, MS SQL Server Master Data Services 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio/.NET 2012, SAP Business Objects, BI Extractor, Microsoft Excel, Add-In Excel with Master data

Responsibilities:

• Gathered functional requirements and Business requirements and write the technical specifications for building the Enterprise Integrated Data warehouse.
• Successfully extracted data from flat files/excel files, applied complex transformation and finally loaded to SQL Server data warehouse on a weekly basis.
• Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning.
• Created database objects like tables, view, store procedures, functions, triggers using SQL server.
• Developed numerous ad-hoc reports using SSRS for day-to-day financial reporting.
• Generated custom and parameterized reports using SSRS.
• Used SQL Server Agent for scheduling jobs and alerts.
• Extensively used SSIS transformations such as Lookup, Fuzzy LookUps, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from different SQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
• Provided scripts to DBA for production implementation of data warehouse and several other database objects.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS 2008/2012.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Built operational reports and analytical dashboards on top of Azure Data Warehouse to derive insights from the data using Power BI together with Azure Analysis Services.
• Work with Business analysts to create a data dictionary for the end-user.