Experience

Data Integrity Services Inc

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• POWER BI DEVELOPER

  • Feb 2022 - Present

  ALLEN, TX • Assisted and supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members. • Actively participated in meetings with different Departments, Managers, and End users to capture and document system requirements. • Assigned as Subject Matter Expert (SME) for SQL Server and T-SQL in developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes… Show more • Assisted and supported the Project Manager in leading multi-functional project teams in implementing data conversion strategies and communicating essential information to team members. • Actively participated in meetings with different Departments, Managers, and End users to capture and document system requirements. • Assigned as Subject Matter Expert (SME) for SQL Server and T-SQL in developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands. • Created complex analytic queries on huge data sets. developed T-SQL stored procedures, triggers, and user-defined functions. Handled data manipulations as required. • Cloud technology: AZURE Data Lake, Azure Data Factory, Azure Data Warehouse, AZURE SQL Database • Have been creating complex Pipelines using ADF V2, Azure Databricks, source being On Prem Servers or flat files / or Cloud Storages such as ADLS Gen2, Blob storage, involving Stored Procs to control pipelines, creating notebooks and doing data transformations • Experience in data discovery to data provisioning to Azure ADW and leveraging SSIS to create facts and dims, leveraging ADF to automate and provision data inbound to ADW; • Involved in configuring Azure platform for data pipelines, ADF, Azure Blob Storage and Data Lakes and building workflows to automate data flow using ADF; • Actively participated in migration of on-premise SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases across both on-premise and cloud deployments; • Design and Implement reporting solutions using Reporting Services, Power BI, or other data visualization tools. • Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI. Show less



PricewaterhouseCoopers Corporate Finance LLC

• United States
• Investment Banking
• 1 - 100 Employee

• SR.BI DEVELOPER

  • May 2019 - Jan 2022

  Orlando, Florida, United States • Daily scrum meetings with Project Managers, Business Analysts and end users/clients to gather, analyze and document the business requirements and business rules. • As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with mostly T-SQL, ADF2, Azure Synapse Analytics, Power BI and other Azure Cloud tools. • Built efficient ETL packages, using both SSIS and ADF2 pipelines for processing Fact and Dimension tables with… Show more • Daily scrum meetings with Project Managers, Business Analysts and end users/clients to gather, analyze and document the business requirements and business rules. • As a key member of BI team, delivered the best results to the development needs, accomplished successful outcomes by working with mostly T-SQL, ADF2, Azure Synapse Analytics, Power BI and other Azure Cloud tools. • Built efficient ETL packages, using both SSIS and ADF2 pipelines for processing Fact and Dimension tables with complex transforms and SCD type 1/ type 2 changes; Build workflows to automate data flow using Python and ADF2. • Strong experience with SQL Server and T-SQL in implementing, maintaining developing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Databases Models, creating and updating tables and checking the database consistency by executing DBCC commands. • Performed incremental data loading to synchronize data changes between OLTP and OLAP databases using SSIS packages, execute SQL task and merge; Send email notifications about ETL issues reports to development team by using Send Mail Task/Script Task/Execute SQL Task along with system stored procedure to send emails. • Involved in configuring Azure platform for data pipelines, ADF, Azure Blob Storage and Data Lakes and building workflows to automate data flow using ADF. • Migrated on-premises SQL server schemas to the cloud on Azure SQL Server and maintained databases across both on-premises and cloud deployments. • With the help of Azure Data Factory (ADF) copy job, transferred data from company’s website into Landing schema of Azure Data Lake Storage (ADLS) Gen2 to cleanse and standardize using Azure Databricks. • Implemented performance tuning on complex stored procedures, views, user defined functions and queries by creating proper indexes and optimizing the existing ones. Show less



FAIRWINDS CREDIT UNION

• United States
• Financial Services
• 400 - 500 Employee

• SQL/ETL DEVELOPER

  • May 2015 - Apr 2019

  Orlando, Florida, United States • Gathered and analyzed business requirements and translated business needs into long-term business intelligence solutions. • Interacted with business users and team leads for better understanding of business specifications and requirements, identifying data sources and Development strategies. • Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis. • Performed regular reviews on the… Show more • Gathered and analyzed business requirements and translated business needs into long-term business intelligence solutions. • Interacted with business users and team leads for better understanding of business specifications and requirements, identifying data sources and Development strategies. • Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis. • Performed regular reviews on the database to identify any performance problems, inadequate programming, and data duplication problems. • Created complex stored procedures, triggers, functions (UDF), indexes, tables, views and other T-SQL code and SQL joins for SSIS packages and SSRS reports. • Used SQL Server Agent for scheduling jobs and alerts. • Extensively used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. • Provided performance tuning within SQL, SSIS and SSRS. • Configured dimensional modeling for end users from hierarchy perspectives. • Involved in creating of SQL server MDS 2012 Web App that integrates with Add-in Excel and right SQL Server database. • Designed and developed various SSIS packages (ETL) to extract and transform data. • Optimization of queries by looking at Execution Plan for better tuning of the database. • Deployed SSIS packages into various Environments (Development, Test and Production) using Deployment Utility. • Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables. • Created complex stored procedures/execute task, updated and maintained ETL packages with high performance. • Normalized the tables and maintained Integrity by using Primary and Foreign Keys. • Coded T-SQL stored procedures for SSRS reports and deployed the reports for account managers to access via web browser. Show less