Power Bi Data Engineer

Amir Siddiqui

Houston, Texas

****.**********@*****.***, 832-***-****, US Citizen

linkedin.com/in/amir-siddiqui-63443356

Data Architect, Business Intelligence Developer, Data Engineer EDUCATION

2019 – 2020 THE UNIVERSITY OF TEXAS AT AUSTIN ONLINE Professional Certification Program in Data Analytics and Big Data 2009 – 2014 UNIVERSITY OF HOUSTON, COLLEGE OF TECHNOLOGY HOUSTON, TEXAS Bachelor of Science in Computer Information Systems. EXPERIENCE

2020 – Current LIONGARD HOUSTON, TEXAS

4 YR. & 5 MO.Data Architect

● Engineered a custom Python-based ETL pipeline to extract, transform, and load data into over 80 tables from HubSpot, ConnectWise, QuickBooks, Salesforce, Intercom, Pendo, and Slack.

● Automated and scheduled Data refreshes through AWS Glue to Data Lake in S3 bucket to PostgreSQL RDS Instance.

● Developed a custom data change management script that automatically detects changes in source applications during ELT jobs and updates the data warehouse table schema accordingly.

● Architected Data Infrastructure to load data securely to Power BI Online utilizing AWS Infrastructure and Power BI Gateway.

● Created custom reports for that focused on customer net retention over company life cycle.

● Developed a series of Power BI reports to track key metrics across company sales, invoicing, payments, customer churn,Net Promoter Score and board-level reporting.

● Developed a custom Power Automate integration to deliver Net Promoter Score responses from Pendo.io and Intercom directly into Slack, with references to Salesforce metrics and related Stakeholders.

● Developed a custom solution to deliver weekly Power BI key metrics tailored through Slack alerts for the Executive Team.

● Designed and implemented a custom Slack app to trigger a Power Automate workflow, enabling seamless synchronization of Salesforce usage data with our Billing System, utilizing Power BI datasets as the intermediary.

● Developed a custom Power Automate integration with Salesforce to notify users of churned customers, leveraging Power Automate AI Builder to classify churn based on ticket details. 2019 – 2020 HOUSTON FOOD BANK HOUSTON, TEXAS

1 Yr.Data Scientist – Business Intelligence Developer & Data Engineer

● Saved $20,000 per year by replacing 3rd party ETL system that pushed data from Dynamics NAV to Salesforce by creating a custom-built integration with Dataloader.io.

● Developed over 10 different custom reports to handle with COVID-19 demands including, TEFAP intake, qkits, disaster box, call center logging, SurveyMonkey Survey, and MobilizeUS API.

● Created AWS Glue ETL Jobs to extract data from REST APIs, Sharepoint On-Prem and Data Warehouse to load into our report PostgreSQL database.

● Created a custom Python and PySpark script to pull data from our Transportation Management System via SOAP and loaded the data into a local database environment using AWS Glue.

● Created a Pounds by Cost by fiscal year report that saved a months’ worth of manual effort by our inventory department.

● Created a quarterly metrics report that rates each individual department, which is shared with our Executives and Board of Directors.

● Consolidated over fifteen custom reports that were used in our Backpack Buddy Program into one multi report Power BI dashboard.

● Developed a custom Google Sheet API connector for Power BI, using AWS Lambda and AWS API Gateway.

● Created a pounds distributed Power BI report per impacted areas from 2019 Tropical Storm Imelda.

● Utilized FormAssembly API, Dropbox API, Power BI API and Salesforce API for custom scripts and integrations.

● Supported multiple systems including, Power BI Gateway, Power BI reports, SSRS reports, Dataloader jobs and SSIS jobs.

● Created both departmental short videos for both the Data Team and the IT Team for our quarterly staff meetings.

2018 – 2019 STRIKE, LLC WOODLANDS, TEXAS

5 MO.System Support Analyst (Contract)

● Supported Mulesoft, K2 black pearl and PMG integration and workflows.

● Fixed and resolved employee information, checks, construction job inserts & updates.

● Create Support documentation for both K2 and Mulesoft, including error handling, stakeholder & support contacts.

● Worked with SQL Server, JSON, Active MQ, K2 BlackPearl 4.7, Cherwell. 2014 – 2018 BECHTEL OIL, GAS AND CHEMICALS HOUSTON, TEXAS 4 YRS. & 4 MO.Information Systems Analyst

● Developed and supported Project Information Coordination Register, which handles Deviations and Clauses supporting over 1000+ users, providing monthly data extracts of deviations and queries.

● Developed SSRS comparison report, written in PL SQL, of the Stock Codes and Specs from Materials Management System. This report allows users to compare historical snapshots.

● Created Materials Requisition Supplement forms using BP Logix and C# that allows Engineers to submit supplement approvals electronically.

● Developed Invoice forms utilizing BP Logix, C# and PL SQL allowing Accounting to submit multiple Invoices and routing them through a dynamic approval cycle interfacing with our Procurement system.

● Developed forms applications for requesting: Laptops, DMS access, Travel Authorization, Overtime, and Onboarding.

● Implemented VB.NET RFID Badge check-in /out solution that allows employees and clients access to the Houston office.

● Integrated Client’s identity trust tool with Form Application System.

● Consulted with Projects and Departments in developing automation solutions using C#, VB.NET, VBS, VBA, SSIS, Access, BP Logix, HTML connected to SQL Server and Oracle database.

● Supporting and administering multiple applications/solutions I had developed. 2013 – 2013 J.P. MORGAN CHASE HOUSTON, TEXAS

3 MO.System Support Engineer Intern

● Prevented compliance & controls issues by locking computer related accounts in a secure vault.

● Worked on global projects alerting on critical application dependencies.

● Provided high quality customer service.

2012 – 2013 HOSTGATOR HOUSTON, TEXAS

1 YR.& 4 MO.Level 1 Administrator

● Assisted customers in technical support for web hosting and troubleshoot client issues.

● Utilized WordPress, C-panel, Web Host Manager, CSS & HTML.

● Troubleshoot related issues such as Email Clients & Protocols, FTP, DNS, MySQL and Domain Names. ADDITIONAL INFORMATION

Skills: R Programming,Power Automate,AI Builder, Salesforce Dataloader, Dataloader.io, Python 3.6, AWS Glue, AWS Lambda, AWS API Gateway, AWS S3, VBA,VS Code, VB.Net, VBS, SQL Server (2008, 2012), Oracle DB, PostgreSQL, HTML, JavaScript, C#, XML, DAX, Power Query, SOAP, REST, JSON, BPLogix and SSRS. Certifications: Microsoft Windows Operating System and Security. Competencies: Process Improvement, workflow automation, ETL Integrations, Dashboard & Reports Volunteered: Bechtel Stewardship Boy Scouts Information Technology Badge Counselor. Provided information regarding the history of technology.

Contact this candidate