Data Lake Cloud Computing

Overview:

Twenty years of professional experience in software architecture and development. Expert and highly familiar with web development, system integration, data engineering and cloud computing.

Skills Summary:

Experience in UI/UX Design technologies, front - end technologies/ framework and libraries like Flex, jQuery, HTML, DHTML, JavaScript, ES6, Bootstrap 4.0, Material Design, JSON, CSS, XML/XSLT, AJAX.

REST API, ASP.NET Core, DevExpress, C#, VB.NET, C++, MVC4, WCF, NodeJS, Angular 4//8/13, VueJS, HTML5, CSS.

Azure DevOps, GitHub, Git, Pipelines, TFS, Git, Jenkins, Docker, AzCopy, Azure CLI, PowerShell, CI/CD

Experience in Azure and AWS Cloud computing, Azure Functions, Apps, Blob Storage, Logic Apps, Data Lake Analytics, Data Lake Storage, Data Factory, Table Storage, U-SQL, SSIS, Azure AD, VMs.

Java/J2EE, Spring Boot, Spring MVC, Spring Data JPA, Spring Web Services, Maven.

Oracle 11G/9i, MS SQL 2016, TSQL, MongoDB, CosmosDB, OLAP, Data Warehousing, Business Objects.

Expert in Data Visualization and ETL tools using DTS, SSIS, SSRS, PowerBI, Crystal Reports, Plotly, Chart.JS, D3.js.

Experience using Drupal 7.24, Documentum 4i, DQL, DFC, COTS Integration (ConnectShip, LexisNexis)

Professional Experience:

Azure Data Engineer – Autonomic Enterprise Inc. (DoD - DTIC) – Fort Belvoir, Virginia 06/2023– Present

Designed and implemented complex ETL pipelines using Azure Data Factory to efficiently ingest and transform data from multiple sources into a Data Lake and Azure SQL Database. Modified existed database scripts to increase system performance. created new stored procedures and functions.

Created CI/CD pipelines in Azure DevOps to automate development implementation with Databricks and Azure Data Factory, enabling faster and more reliable deployment of data pipelines.

Assisted in the migration of on-premises databases to Azure SQL Database, redesigned and optimized inefficient ETL workflows, reducing load times by 70%, improving overall system efficiency, and ensuring timely data delivery.

Created Azure Resource Manager (ARM) templates, Implemented Terraform to manage infrastructure as code for Azure resources, reducing deployment time by 50%

Key Technologies: Azure, ADF, ARM, Terraform, SQL, Data Lakes.

Full Stack Developer – AltaITS (BAH - FBI Academy) – Stafford, VA 07/2021 – 05/23

Involved in SDLC for requirements analysis, design and development of web based applications in fast paced agile methodology. Implemented abstract, sealed classes, interfaces to construct the business and data tiers. Participated in peer code reviews for other team members.

Modified existed database scripts to increase system performance. created new stored procedures and functions. Created Custom reports to meet management needs.

Fixed existing bugs in all Courses, Evaluations and Gradsheets modules, Integrated new code into existing products, provide product enhancements and resolve product defects to meet client needs.

Key Technologies: .Net Core, EF 6.0, Blazer.NET VueJS, Angular 1.7, Bootstrap, TypeScript, SQL Server.

Full Stack Developer – Deloitte Consulting LLP (Department of Treasury) – Washington, D.C. 07/2019 – 07/2021

Migrated OFAC (Office of Foreign Assets Control – Dept. Of Treasury) Web Apps from on- premise to AWS Cloud.

Developed scripts for Data migration from legacy applications to new applications

Developed new /enhanced an existing oracle package (procedures and functions) to meet the applications modernization and increase overall system performance.

Fixed existing bugs in all OFAC modules (Enforcement, Compliance and Licensing), Integrated new code into existing products, provide product enhancements and resolve product defects to meet client needs.

Participated in peer code reviews for other team members

Key Technologies: .Net Core, EF 6.0, TypeScript, Oracle, SQL Server, Angular 8.0, ReactJS, AWS, Java/J2EE, Spring Boot, Spring MVC, Spring Data JPA, Spring Web Services, Maven.

Senior Software Developer/ Azure Data Engineer - Paradise Management - McLean VA 9/2015 – 06/2019

Developed monitoring tools to monitor system health and reliability, publishing custom reports and dashboards with Azure Log Analytics KQL, PowerBI, PowerShell and Azure CLI.

Designed ETL to reduce the current several-hours migration process to less than 30- minutes. Developed and implemented solutions for cleansing data to remove errors and ensure data consistency. The ETL process is to collect data from different repositories and generate XML files for foreignassistance.gov.

Performed Database indexing, profiling, tuning and written stored procedures to increase system performance.

Developed innovative user interfaces and interactive models that leverage next generation web technologies to improve user productivity and operational efficiency. Designed the UI, styles and interactive web visualizations on world map data. Developed REST API calls using C#, Web API 2.0, Core 3.1

Maintained and fixed existing bugs in azure cloud-based web services/apps of foreignassistance.gov. Maintained FIND dashboard Web site and implemented visualization features using react-plotly.js.

Developed web-based application to facilitate the process of uploading data to foreignassistance.gov. Created WebJobs, Azure Functions, Logic Apps, and implemented Blob Storage using Azure SQL.

Developed and managed CI/CD process for different types of applications and automated as many processes as possible, created ARM templates to automate setup for resources provisioning (Azure PowerShell).

Developed Azure Data Factory to migrate and process data of different format types.

Key Technologies: C#, MVC, WebAPI, SQL 2015, AzCopy, Azure CLI, PowerShell, U-SQL, Azure SQL, SSAS, SSRS, Windows Azure, SQL Azure, Azure Storages (Blobs, Tables, Queues), Azure Logic Apps, Data Factory, SSIS, HTML5, Angular2/4/5, ReactJS, VueJS, Node.JS, Material Design 2.0, Bootstrap 3/4, Swagger, Postman, GIT, JIRA, DevOps, GitHub.

Sr. .Net Developer - RealInterface, Inc. - Washington, D.C. 8/2012 – 09/2015

Architected, designed and implemented the Office Wage Hour – Claimant MIS system. Applied best design patterns such n-tier, MVVM, Repository, and Singleton for designing key reusable components, involved in designing UI parts to be mobile friendly using knockoutJS, Bootstrap and HTML5 skills.

Architected and developed and delivered Time-Entry system. Created the required stored procedures and views using SQL Server, assured enterprise application integration by selecting tools, specifying shared data and code resources, defining interfaces and workflows, developed functional specifications, Use Cases and Test Scenarios.

Created an identity verification process using LexisNexis Instant Verify and Instant Authenticate to validate the registered user’s identity. Reviewed software security vulnerabilities including SQL injection, Cross Site, scripting, buffer overflows Improper use of Cryptography, Malicious code and various other vulnerabilities.

Used SSIS Packages to transform and load staging and reporting tables with the help of Data flow task, Execute SQL task, Sequence container and Data flow transformations.

Key Technologies: SOAP Web Services, SiteCore 6.0, API, SITECORE, ASP.NET, MVC4, TSQL, VueJS, jQuery.

Sr. Application Developer - National Computer Services Consultants - Washington, D.C. 07/2011 – 7/2012

Designed and Developed core application components for the Criminal Investigation Management System.

Created web services to meet client requests to allow remote application to communicate with CIMS.

Participated in design meetings to determine system requirements and determine design of components.

Assisted with data migration to ensure the new system formats and requirements were met.

Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environment, extracting, transforming and loading (ETL) data from legacy database using Microsoft SSIS and Data Export tools.

Key Technologies: Delphi 2010, .Net, ASP.NET, Nunit, Business Intelligence, TSQL, Ajax.

Sr. Application Developer - IBM-Global Business Services - Washington, D.C. 10/2010 – 06/2011

Working closely with TSA NDO (National Deployment Office) system analysts to translate requirements into .Net technology solutions to create online browser-based Personnel Deployment system.

Written automated SQL scripts to migrate legacy data to SQL database.

Worked on SSIS Package, DTS Import/Export for transferring data from to SQL Server.

Key Technologies: .Net, ASP.NET, WCF, MVVM, MVC2, SQL, SSRS, Nunit, LINQ, Agile, JavaScript, Ajax.

Sr. Programmer Analyst Lead - Computer Science Corporation (CSC), Washington, D.C. 8/2009– 08/2010

Developed and managed requirements and system design for SMI (Secure Mail Initiative).

Performed necessary SMI integrations with FTPSecure COTS.

Performed ConnectShip system evaluation and software recommendation. (COTS)

Ensured SMI comply with the current Section 508 accessibility requirements.

Successfully involved in test driven development model (TDD) using NUnit and performed code reviews.

Key Technologies: .Net, VB.NET, MVVM, ASP.NET, JavaScript, SQL, NUnit, SSRS, TFS, Agile, VS2008, ConnectShip

Sr. Application Developer - Serco North America, Washington, DC 07/2004 – 8/2009

Led the development of CAS (Central Alarm System) for Department of Energy. The CAS provides the capability to accept, process, display and store data from RPMs, NII machines and Cameras. The CAS system allows users to effectively manager alarm/event processing and to access the status of the system.

Engaged in the development and implementation of intelligent traffic system devices, including traffic signals and lighting, traffic control systems, traffic sensors components to be integrated with CAS using C++.

Implemented an Interface between 360 Surveillance video display systems using C++.

Designed and Implemented the ArchiveManager component systems using WinForms.

Key Technologies: Documentum 4i, DQL, DFC, ACLs, Java J2EE, Java Beans, JSP, Apache Struts, SharePoint 2007

Business System Analyst -Documntum - Xenel, Inc. (Saudi Aramco), AL-Khobar- KSA 07/2001-07/2004

Implemented a mechanism to import EMRS legacy database into the Documentum Docbase and developed migration tools to import Manpower excel sheets to the centralized SQL Server using DQL and DFC.

Customized the Documentum DTC (Desktop Client) using VB and COM

Created procedures to import, search, file and retrieve electronic and non-electronic documents

Performed Documentum 4i administration duties including installation, configuration, maintenance.

Delphi Programmer - QTech, Inc. - Orlando, FL 06/1995 – 05/2001

Enhanced existing real-time software of INFINTI hotel reservation system to accommodate multiple languages and facilitate remote reservations.

Designed INFINTI level security system to prevent unauthorized creation, editing or deletion guest information. Developed customized and batch utilities to migrate AMOS-D daily transactions to Disney World Cruise JD Edward HR/AP/AR/FI Modules. (Delphi, C++)

Education and Certifications:

University of Central Florida, Orlando, FL

Master's Degree in Computer Science (30/36Hrs Completed) 01/1994 – 01/1996

Motilal Nehru National Institute of Technology (MNNIT), Allahabad

Bachelor's Degree in Computer Science 01/1987 – 01/1991

CompTIA Security+ 701 Certification 11/10/2024

Clearance: Top Secret/SCI (DoD).

Contact this candidate