SUMMARY:

• 7 + years of strong MS SQL Server BI Developer experience with MS SQL Server 2019/17/16/ R2 suite of products such as SSIS, SSRS, SSAS and Power BI in healthcare, finance, retail and insurance;
• Expert in preparing modeling, designing, creating, implementing, handling and maintaining Microsoft SQL Server, Visual Studio 2019/17/13/12/10, Microsoft Access, Oracle Databases;
• Highly proficient in the use of T - SQL and PL/SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins;
• Experience in Microsoft SharePoint, MS Project, MS Visio, Erwin 9.2, Data Modeling, Visual Basic Analysis (VBA), MS Office, ALM for QA testing and Software Development Life Cycle (SDLC);
• Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies;
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data;
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical;
• Extracted data using SSIS from OLTP (Tabular) to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view;
• Expertise in creating databases, users, tables, triggers, views, stored procedures, functions, Packages, joins and indexes in database;
• Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement;
• Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS);
• Very strong in Azure system configuration, database migrations, backup and recovery, geographic data replication, performance monitoring and tuning and disaster recovery configuration and execution;
• Expertise in developing and extending MS SQL Server Analysis Services (SSAS) cubes, data mining models, deploying and processing SSAS objects;
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS);
• Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger) with Strong understanding of OLAP and OLTP Concepts;
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS:

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

Databases: SQL Server 2019/17/16/ 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, HTMLASP.NET, .NET Framework, C, C++, JavaScript;

Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script;

ETL & Reporting: SSDT 2019/17/16/14/12, BIDS 2008R2/08, SQL Server Integration Services (SSIS) 2019/17/16/ R2), SQL Server Reporting Services (SSRS 2019/17/16/ R2), Power BI Desktop/Service, SQL Server Analysis Services (SSAS);

Others: MS Office, SQL Server Notification Services, Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, Visual Studio 2019/16/12, DAX Studio, Azure Data Studio, ApexSQL;

DevOps: GitHub, TFS, Jira, Git, iTop;

Methodologies: Agile, Scrum, Waterfall.

WORK EXPERIENCE:

Sr. BI Developer

Confidential, Pleasanton, CA

Responsibilities:

• As a key developer, gather and analyze business requirements and translate business needs into long-term business intelligence solutions by working with T-SQL, ADF2, SSIS, SSAS, Power BI, and other Azure Cloud Service tools
• Develop and maintain SQL tables, indexes, stored procedures, views, and triggers created for Power BI reporting
• Create, optimize, and review SQL code for Power BI budgeting and forecasting processes
• Participate in the design, development, testing, and implementation of ETL/ELT solutions that utilize Azure Data-Factory, Azure Synapse, Azure Data Lake, and Azure SQL services
• Develop and maintain Azure Data Lake folders using industry best practice architecture
• Create Azure Data Warehouse to facilitate enterprise Power BI reporting architecture
• Process data using Azure Data Factory by creating Azure Data Pipelines and Data Flows
• Implement best practices in ETL/ELT development and engaged with clients and members of the business team to provide high quality and efficient ETL/ELT solutions
• Played a key role in Data Migration using SQL, Azure SQL, Azure storage, and Azure Data Factory, SSIS
• Built efficient SSIS packages/ADF2 pipelines for processing Fact and Dimension tables with complex transformations by maintaining SCD Type 2/SCD Type 1 historical data
• Plan and develop data ETL and ELT procedures using Azure Synapse to manage data and deliver tables required for Power BI Reporting
• Actively participate in agile project development framework (Scrum)
• Develop 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
• Develop filters, reports, dashboards and create chart types, visualizations, and DAX calculations to manipulate data in Power BI
• Work closely with other developers and stakeholders to recommend and design Azure SQL database and Azure Data Lake storage solutions that effectively reflect Client’s needs, security, and PBI report requirements
• Assist and support the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members.

Sr. SQL BI Developer

Confidential, Edina, MN

Responsibilities:

• Gathering, analyzing and documenting the business requirements and business rules by directly working with end users/clients.
• Created and maintained documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in scheduling and deploying SSIS Packages.
• Published SSRS reports in Report Manager, SharePoint web pages and in custom made ASP.NET web applications.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL codes and SQL joins for SSIS packages and SSRS reports.
• Extract, Transform and Load data from databases of systems like CRM, ERP and SharePoint
• Design, maintain and deliver SSRS reports sourcing from central database.
• Developed C#/VB console and web applications to manipulate databases and perform calculations
• Created Application Tracking Systems, Surveys and Manual Data Entry Web Apps using ASP.NET Framework.
• Implemented various tasks and transformations for data cleansing and performance tuning of SSIS packages.
• Extracted and Loaded SharePoint Lists and Surveys Data into SQL Server Database with SSIS
• Collaborated on multiple projects using GITHUB.
• Provided standard and ad-hoc reports on a regular basis and on demand.
• Worked extensively on system analysis, design, development, testing and implementation of projects.
• Developed and Maintained Crystal Reports.
• Pulled data into MS SQL Server Database from different DBMS databases like Oracle and Teradata with ETL packages.
• Created SSRS and PowerBI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.

BI Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Participated in the design, development and implementation of end-to-end Business Intelligence Solutions with Azure and the Microsoft BI Stack.
• Developed T-SQL Scripts to validate the data after the loading process. Modified and tested T-SQL stored procedures.
• Designed and deployed enterprise data warehouse solutions and dimensional models.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Developed and implemented Reporting and Analytics using Azure Synapse and Power BI.
• Designed and built ETL processes in On-Prem/Cloud BI solutions with the ability to utilize Data Factory, SSIS, and other ETL tools.
• Designed and developed database schema, Stored Procedures, Views and worked on optimizing database performance of queries and ETL processes.
• Created SSRS and Power BI reports sourcing from SSAS’s Multidimensional OLAP and Tabular model cubes with MDX and DAX.
• Provided end-user support by utilizing interpersonal skills to communicate with and instruct end-users on MS BI products and technologies
• Troubleshooted escalated BI issues including data, ETL and Power BI issues
• Assisted with development and implementation of a data analytics solution
• Worked with database team to optimize database performance of queries and ETL processes
• Developed stored procedures, complex joins, data exchange, XML data standard or data sharing model
• Developed SSIS packages using Transformations, Merge Joins, Fuzzy LookUps, and Derived Columns with Multiple Data Flow tasks, Script, Slowly Changing Dimension, Lookup, Data Conversion, Conditional-Split and many more
• Built and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Configured XML Packages and Error Handling using Event Handlers for On Error, On Warning, On-Task Failed event types
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third-party tools.
• Created Parameterized, Crosstab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.

SQL / ETL Developer

Confidential, New York, NY

Responsibilities:

• Participated in understanding the needs of the business and translated those into meaningful reporting that allows for actionable decisions.
• Designed, coded, and maintained ETL routines and dashboards with high quality output.
• Extracted and loaded data from multiple sources (Excel, flat files, SQL Server, Oracle) to the staging area.
• Created complex analytic queries on huge data sets; developed T-SQL stored procedures, triggers, and user-defined functions. Handled data manipulations as required.
• Provided expertise working with existing teams (contract and FTEs) to create business intelligence, stored procedures and reports, including design, development and management of a data warehouse environment used for analytics and reporting.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Identified and recommended changes to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity.
• Designed and built Dimensions and Facts, Staged data from various sources for future use in building warehouse Dims and Facts.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS and Power BI. Developed Multidimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Developed queries and calculated measures using Multidimensional Expressions (MDX) statements and functions to create complex calculations and to retrieve specific datasets from the cubes for profiles. Used Linked Servers and developed queries to retrieve data from SSAS and Database Engine servers.
• Supported implemented BI solutions by monitoring and tuning queries and data loads, and addressed user questions on functional and technical issues.
• Developed SSIS packages for File Transfer from legacy systems to upgraded application backend systems, Data flow task, File system task, Execute SQL task, and FTP task and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Documented specifications for Data Warehouse (DWH) extracts, reports, dashboards, or other outputs.