PROFESSIONAL SUMMARY:

• Senior Data Engineer with 15+ years of professional experience, keen to help companies collect and exploit digital assets. Expert data modeler of OLTP Databases, Data Warehouses, Data Marts, ODS systems, OLAP cubes, managing information ranging from Finance, Accounting, HR, Supply - Chain, Operations, Sales, Marketing to E-Commerce business domains. Experienced at cleansing and organizing data into new, more functional formats to drive increased efficiency and enhanced returns on investment in the field of data analytics, business intelligence and data science.

TECHNICAL SKILLS:

Scripting Languages: T-SQL, PL-SQL, MYSQL, AWS Redshift, C#, Python, JS, PowerShell, DAX, VB.NET, HTML, CSS, JavaScript, ASP.Net.

BI Stack: SQL Server, MySQL, Oracle, IBD DB2, SSIS, SSRS, SSAS, Power BI, Tableau, Cognos, Crystal Reports, DOMO. Azure DevOps, Agile Methodology, Visual Studio, TFS, GitHub, Git Bash, Git Kraken, CICD pipelines.

Cloud Engineering: Microsoft Azure SQL IAAS/PAAS/IAAS, Azure Synapse, Azure Data Lake, Azure Blob Storages, Azure Data Factory V2, Azure PowerShell, Azure Key Vaults, Azure Logic Apps, Azure Function Apps, Azure Runbooks, Azure Databricks. AWS MySQL RDS, AWS Redshift, AWS S3, AWS EC2.

Data Domains: Sales, E-Commerce, Supply-Chain, HR, Finance, Accounting, Loan, Manufacturing, Healthcare, Insurance, Energy, Procurement.

PROFESSIONAL EXPERIENCE:

SENIOR BI ENGINEER

Confidential, Dallas, TX

Responsibilities:

• Gathered business requirements, analyzed, and designed solutions based on the requirements. Lead reporting platform and responsible for end-to-end delivery of the reports.
• Designed data ingestion from different sources in Azure Data Factory by creating pipelines, using activities such as Copy Data, Lookup, and Filter.
• Managed Data Flow for transferring data from Online Transaction Processing (OLTP) to Operation Data Store (ODS) and from ODS to Integration.
• Created ETL process, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies, Including Star and Snowflake schema.
• Migrated SQL database to Azure Data Lake, Azure data Lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and controlling and granting database access and Migrating On premise databases to Azure Data Lake store using Azure Data factory.
• Gained Hands-on experience in developing Logic App workflows for performing event-based data movement perform file operations on Data Lake, Blob Storage, SFTP/FTP Servers, getting/manipulating data in Azure SQL Server.
• Extracted, Transformed and Loaded data from sources Systems to Azure Data Storage services using a combination of Azure Data factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics.
• Built ETL processes for Data ingestion to one or more Azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure synapse) and processing the data in Azure Databricks.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards. Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Explored data in a variety of ways and across multiple visualizations using Power BI. Used Power BI Gateways to keep the dashboards and reports up to date. Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

SENIOR DATA ENGINEER

Confidential, Broomfield, CO

Responsibilities:

• Participated in Business Requirement gathering sessions, supported business users and stakeholders with technical issue resolution. Worked closely with multiple cross functional teams like engineering, Test, providing services for Software Development, Sustenance engineering and translation to Processes.
• Created Azure environments with Resource groups, Virtual networks (v-Net), Subnets, Network Security Groups, Azure Storages, Azure data Factories, etc.
• Wrote KQL queries to extract data from Kusto log analytics to read application logs.
• Created BI platform monitoring systems and automation jobs via Azure Logic App, Azure Webhook, Azure Function App and Microsoft Teams Notifications.
• Created and Maintained SQL Database projects and solutions via GitHub, Git Bash, Visual Studio and Azure DevOps (ADO) CICD pipelines.
• Built Business Intelligence Data Warehouse systems utilizing Azure Cloud Services (PaaS & IaaS), Storage, Web Apps, Active Directory, Logic Apps, Data Factory, Azure Monitoring, Key Vault, Visual Studio Online (VSO) and SQL Azure.
• Configured the SSIS packages using XML & SQL Server type configurations when the finalized ETL packages need to be moved onto the Production box.
• Deployed the SSIS packages using SQL Server package deployment wizard to deploy the packages on the production server.
• Developed the SQL Agent Jobs to schedule the ETL packages on a scheduled basis.
• Developed the SSRS reports by pulling the data from the Data mart by the extensive use of stored procedures and cursors.
• Scheduled and maintained various daily, weekly, and monthly ETL packages and jobs through SQL Server Agent in SSMS.
• Designed Data Models for OLTP Databases and developed Business Intelligence reporting solutions using SQL Server, Integration Services (SSIS), DTS Packages, SQL Server Analysis Services (SSAS).
• Created dashboards and interactive visual reports using Power BI and SSRS. Identified key performance indicators (KPIs) with clear objectives and consistently monitor those. Analyzed data and present data through SSRS and Power Bi reports that aid decision-making.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Generated SSRS and Tableau reports, maintaining dimensional as well as relational data structures and managing operational data store and data warehouse. Utilized comprehensive understanding of data types and best practices for organization and display. Used SSRS to generate Sub-Reports, Drill down, Drill-through, and Parameterized reports.

SENIOR BI DEVELOPER

Confidential, Dallas, TX

Responsibilities:

• Worked with the infrastructure team to maintain databases, design ETLs and build Analytics Reports. Involved in complete SDLC life cycle during requirement collection, analysis, design, and development of BI solutions.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer int data warehouse.
• Created very complex SSIS Packages with considering all the best practices like error handling, logging, configurations, deployments, maintenance.
• Deployed SSIS packages to various environments like Dev, QA, UAT, PT and production using indirect XML and SQL server configuration.
• Used various Data Flow Transformations, like Lookup, Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.
• Scheduled and executed SSIS Packages using SQL Server Agent configuration in XML and used them to deploy packages int SQL server
• Created various SSRS Reports involving variety of features like Graphs, Filters, Sub-Reports, Drill down, Drill-Through, Multi-valued parameters using MS SQL Server) as a source system.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Creating ETL packages to validate, extract, transform and load data-to-data warehouse databases using SSIS.
• Create SSIS packages using different sources and transform data using transformations, tasks, and containers such as Derived columns, Data Conversion, Merge Join, Conditional Split, Look Up, Sort, Union All, Multicast, File System Task, Script Task and Send Mail Task. Scheduled Jobs and Alerting using SQL Server Agent.
• Created new ETL packages to validate, extract, transform and load data into data warehouse, data mart using SSIS packages.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop
• Containers and Fuzzy Lookups etc.
• Designed and developed SSIS Packages to import and export data from MS Excel, Teradata SQL Assistant, SQL Server and Flat files.
• Scheduled SQL Jobs and SSIS packages to run at regular intervals to automate processes and maintain data consistency to achieve incremental updates of target data.
• Analyzed existing OLTP databases and created ETL packages in SSIS to export historical usage data-to-data warehouses, after validating market specific business rules.
• Reviewed and Tested packages, fixing bugs (if any) using SQL Business
• Intelligence Development Studio.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined
• Functions, and Triggers as required and promoted the changes in requested environment.

SQL BI DEVELOPER

Confidential

Responsibilities:

• Involved in gathering requirements and designing database workflow. Developed scripts in OLTP environment to insert, update and delete data in SQL Server database tables.
• Performed SQL server database development and maintenance, data modeling that support day to day business operations and auditing of databases for user transactions, login and database action and removing orphan users.
• Involved in Backups, Query optimization, Disaster recovery methods, High availability methods, creating Emails, jobs, alerts and in performance tuning, used SQL profiler.
• Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Built ETL Data Warehouse Ralph Kimball Methodologies for supporting Data Extraction, Transformation and Loading processing using MS SQL Server Integration Services (SSIS) and Loaded process from Heterogeneous / Homogeneous Data Sources, performed Data Verification, Data Cleansing, Data Integration, Data Import & Export.
• Provided Expertise in merging Data from various complex Data sources, Populating Dimension and Fact tables in Data warehouses, Cleaning and Standardizing the data loaded into OLTP and OLAP databases using SSIS.
• Applied various Transformations such as Lookup, Fuzzy Lookup, Merge, Merge Join, Conditional split, Multicast, Derived column, Cache, Slowly Changing Dimension (SCD Type 0, Type1, and Type 2).
• Designed SSIS ETLs using Error handling and debugging coding issues and troubleshoot production problems. Implemented Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Utilized SSIS tools like Import and Export Wizard, Package Installation, Job Scheduling and SSIS Package Designer.
• Applied Slowly Changing Dimensions Type 2 on Mapping Data Flows by adding few more columns, such as Current Flag and Surrogate Key, to track unlimited historical data.
• Transformed data from one server to another using SSIS Transformations like Conversion, Audit, Derived Columns, Lookups, Merge, Merge Joins, Slowly Changing Dimension.
• Design and Implemented processes for deploying, managing, and extracting data for reporting using SQL Reporting Services SSRS. Experience in creating Report models for Ad-hoc reports, Drill Down, Drill.
• Prepared parameterized reports utilizing Sub-Report and Crosstab type layouts. Developed various operational Drill-through and Drill-Down reports using SSRS. Involved with Query Optimization to increase the performance of the report. Utilized excel macro to format the SSRS report in excel. For instance, the macro would apply assorted colors to the different tab tag name. Utilized SSRS to create executive dashboards with graphs.