Farhan Baig

Plainfield, IL ***** 630-***-**** ad3hs5@r.postjobfree.com

SUMMARY

Encompassing 12+ years of experience designing, developing, and executing short/long-term projects leveraging fundamental knowledge of software development life cycle (SDLC), data migration, data analyzing, data visualization, and data engineering. Adept at designing complex packages, functions, procedures, and scripts and creating and maintaining process flows, event handlers, views, entities, and websites. Demonstrated success supporting internal teams drawing on strong active listening and interpersonal communication skills. Core competencies include:

Data Analyst Data Engineering Data Migration DevOps Recursive & Analytical Queries Data Visualization

Functional, Unit & UI Testing ETL Database Development Bulk Data Loading Requirements Gathering

Data Backups Report Generation Documentation Database Administration Quality Assurance

TECHNICAL SKILLS

Cloud Environment: Azure, AWS

Languages – Python, SQL, PL/SQL, T-SQL,.NET, Java, JavaScript, HTML, CSS

Databases – MS SQL Server, Oracle, PostgreSQL Snowflake, MongoDB

Development Tools –SQL Data Modeler, SSMS, Django, Flask, Aptify, Oracle Application Express (APEX)

Operating Systems – Linux, Windows

Tools –SSIS, SSAS, Data Stage, SSRS, Crystal Reports, Power BI, Jenkins, GIT, Eclipse, MS Office, Visio,

Utilities – Shell Scripting, Putty, SSH, Bash, Imp/Exp, Firebug, HTTP Watch, SQL-Loader, Data Pump, CVS

PROFESSIONAL EXPERIENCE

ABC SUPPLY INC – Chicago, IL June 2022 – Present

Data Engineer, SaaS healthcare

Collaborating with stakeholders to identify business needs, design optimal solutions, and conduct rigorous testing. Work with application architecture assessment and client engagement, with a proven ability to integrate diverse requirements into comprehensive data solutions.

Expertly transform business requirements into innovative technical solutions, employing Azure Data and Analytics services to address complex business challenges. Proficient in Azure Data Lake, Azure Data Factory, and Azure Data Warehouse.

Implement Python for efficient data extraction and processing, resulting in highly streamlined data workflows.

Skillfully design and execute data pipelines, data streams, and system integrations, elevating data processing and analytics capabilities.

Showcase proficiency in provisioning, configuring, and developing solutions for data enhancement.

Meticulously prepare data for analysis and architect pipelines to optimize data processes.

Efficiently manage and analyze data using MS SQL Server for data-driven insights.

Contribute to streamlined development and collaboration through Azure DevOps practices.

Employ a self-directed and organized approach to project management, consistently ensuring successful outcomes that satisfy stakeholders.

VIBRENT HEALTH – Fairfax, VA - Remote Oct 2021 – June 2022

Data Engineer, SaaS healthcare

Develop and maintain data pipelines to prepare data for the analytics team and support production operations, including tasks related to identifying and troubleshooting application issues and resolution or escalation.

Create and maintain optimal data pipeline architecture built-in Python/ Celery.

Build and deploy Docker images and maintain container deployments through Kubernetes.

Handle production issues in the AWS cloud.

Identify, design, and implement internal process improvements.

Assemble large, complex data sets that meet functional / non-functional business requirements.

Ensure code is high quality through automated tests, monitoring, etc.

Collaborate with the team to provide visibility into the data layer and related pipelines.

FHI360 – Durham, NC - Remote May 2021 – Sep 2021

Application Analyst II, Business Intelligence System

Responsible for the development and day-to-day maintenance and enhancements of the business intelligence application systems and reports in test and production operations, including tasks related to identifying and troubleshooting application issues and issues resolution or escalation.

Designed and developed complex, high-quality business intelligence (BI) solutions to overcome ongoing issues.

Ad hoc queries for data analysis, data modeling, BI development, and troubleshooting processes.

Applied technical skills using Power BI, Python, and SQL in data collection, data analysis, and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.

Worked with the Azure stacks to help build a modern data warehouse platform.

Involve in all steps of the SDLC process to provide solutions and recommendations.

Contributed to data migration components before migrating to production.

Develop and maintain standard/ad-hoc business reports, SQL queries, T-SQL functions, and .NET scripts.

Participated in cross-functional project teams and collaborated with business partners to determine and translate business requirements into technology solutions.

Built and published customized interactive and dashboard reports scheduling using the Power BI server.

AMERICAN DENTAL ASSOCIATION (ADA) – Chicago, IL Aug 2015 – March 2021

Senior Application Developer, Customer Relationship Management System

Utilize enterprise resource planning (ERP) system (Aptify) to retrieve member data and create reports for various departments. Modify database based on user needs, ensuring data integrity of web and desktop applications. Build, optimize, and manage database functions, procedures, views, and triggers. Gather/analyze requirements, develop the documentation, assign user permissions, and resolve system issues.

Worked with the Azure stack (Azure Data Factory, Azure Data Lake, Azure Databricks, Azure SQL, and Power BI) to help build a modern data warehouse platform.

Involved in migrating database from on-premises SQL Server to Azure Cloud.

Created and maintained data warehouse jobs and packages in SSIS.

Hands-on experience in implementing a DevOps pipeline using the Azure CI / CD toolsets.

Created jobs, reports, and business views in Aptify, process flow using Python and .Net scripts, and associated reports using Crystal Reports/SSRS.

Contributed to process improvement initiatives, including designing ad-hoc processes for backing up data and utilizing table performance to make the process faster.

ACCERTIFY INC. – Itasca, IL Aug 2014 – Aug 2015

Programmer Analyst, Fraud Validation System – American Express

Developed application (Interceptas) used by American Express business units to assess/mitigate risks associated with AMEX operations. Created Oracle-stored procedures, batch jobs, and database objects used to drive the front end. Gathered and analyzed requirements and developed documents for the SDLC process.

Created standard/custom reports using analytical/recursive SQL queries, BI Publisher, and Crystal Reports.

Designed pages/testing scripts in APEX and created/maintained Python scripts for in-house processes.

Translated SQL queries and PL/SQL functions/procedures from Jaspersoft to Radar.

Built, optimized, and managed functions, views, and triggers.

Conducted UI, unit, and functional testing on reporting scripts to meet requirements and repair defects.

Collaborated with the QA team to implement test cases and proceed to a production environment.

ALLANT GROUP – Naperville, IL Apr 2009 – Jul 2014

Programmer Analyst, Marketing System – GM Motors, Adobe & Ascena Retailors

Partnered with team lead and quality assurance to assess client specifications and test/rework applicable solutions. Contributed to project to automate production process to ensure data quality and reliability and establish ETL environment for EMEA and APAC services to cover all business segments. Participated in performance tuning at the application level. Collaborated with internal business units to design, develop, and deploy campaign processes. Provided 24/7 database support.

Built and maintained SQL scripts and complex data analysis and extraction queries.

Implemented aggregate and analytic functions based on specifications.

Monitored and analyzed indexes for performance tuning and query optimization.

Designed, documented, and executed unit test cases and all components before migrating to production.

Maintained documents and create reports for business analysts and end-users.

Used Crystal Reports to manage documents and create reports for managers, business analysts, and end-users.

EDUCATION/CERTIFICATION

Bachelor of Commerce (BCom), Statistics & Accounting UNIVERSITY OF KARACHI – Karachi, Pakistan -- 2005

Data Modeling, Warehouse and Data Administration COMPUTER SYSTEM INSTITUTE – Chicago, IL -- 2008

Azure Fundamentals Certification (AZ-900) MICROSOFT --2020

AWS Certified Cloud Practitioner (CLF-C01) AMAZON -- 2021

Contact this candidate