Rukia Alhusaini
Chicago,IL
Summary
Seasoned Senior Data and Software Engineer with over 13 years of IT experience spanning Application Development, Business Analysis, Data Engineering, Data Analysis, Data Visualization, Application Integration, Quality Assurance (QA) and DevOps. Proficient across various industries including Finance, Insurance, Government, High Tech, Manufacturing, Consumer Goods and Professional Services.
Multi-talented attentive team player with quick learning ability and passion for Data. Actively pursuing “Azure Data Engineer Certificate DP-203” to further enhance expertise in Azure Synapse Analytics, Azure Databricks, Scala, Azure Data Factory, Azure Stream Analytics, Azure Cosmos DB, Azure HDInsight, Azure Purview, and Power BI. Eager to contribute these skills into an Azure Data Engineer Role.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Software QA Engineer
Manufacturing - Slalom Inc.
Chicago, IL
04.2024 - Current
- Attended various Agile / Scrum meetings across different teams and collaborated with software development engineers to understand new features and architecture.
- Executed test cases, increased overall testing efficiency and test coverage by 40%, and reduced the turnover time for QA testing by 20%.
- Documented manual QA test scripts and developed User Acceptance Testing (UAT) and Regression Testing test plans
- Provided technical demo of UAT test strategies to business users.
- Reported bugs, tracked issues and defects using Jira.
- Performed all sorts of testing (code review, functional, non-functional, performance, usability, security, and compliance) and utilized QTest as Test Management Tool.
- Increased team productivity by providing guidance and mentoring junior QA engineers
Azure Data Engineer
Finance – Slalom Inc.
Chicago, IL
03.2023 - 03.2024
- Built complete data integration and migration infrastructure using Azure Data Lake Gen2, Azure Data Factory (ADF) and Azure SQL Database to Extract, Load and Transform (ELT) various Salesforce Sales, Service, Knowledge, CPQ and Billing objects.
- Decreased data ingestion time and streamlined batch processing times by 40% by implementing parallel processing in ADF.
- Provided technical support to other team members and presented the entire integration migration infrastructure to the client.
- Mapped current data structure using data dictionary, data catalog and source to target mapping documents and reduced overall data storage size by 40%.
- Wrote complex stored procedure, improved query performance and constructed reusable and scalable ADF packages
- Parameterized all connection strings while securing them in Azure Key Vault.
- Successfully established all necessary Azure Linked Services and Data Sets with Salesforce, Azure SQL Database and Azure Data Lake Gen2 and Azure Blob Storage.
- Scheduled data transformation and control flow activities, automated workflows through triggers, and monitored pipeline executions.
- Processed structured and unstructured data through Python and PowerShell scripts.
- Maintained data quality, data security and governance through data validation, data cleansing, error handling, data encryption and masking.
DevOps Engineer
Government Sector - Slalom Inc.
Chicago, IL
05.2022 - 02.2023
- Led the deployment automation process through Continuous Integration and Continuous Delivery (CI/CD) by applying Agile Methodologies and following DevOps Best Practices.
- Promptly troubleshooted deployment issues and constantly communicated release plans and status updates to various teams.
- Collaborated with software developers verbally and non-verbally through Jira, followed up on their stories and insured readiness of metadata changes for deployment.
- Recommended solutions to resolve deployment issues between environments.
- Successfully managed and completed Release Management tasks utilizing Copado DevOps and facilitated the movement of Salesforce Metadata changes throughout the CI/CD pipeline from Dev to QA, to UAT and finally Production.
- Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets
Data Analyst
Consumer Goods - Slalom Inc.
Chicago, IL
02.2022 - 04.2022
- Used Tableau CRM and Einstein Analytic as a data visualization and reporting tool to communicate data insights and build Top-Management Sales Reports and Dashboards.
- Created Tableau CRM lenses, recipes, dataflow, joins and datasets and wrote SAQL (Salesforce Analytics Query Language) queries for data preparation.
- Conducted business user training and provided technical support to Client IT Department on the created reports and dashboards.
- Actively sought out feedback from end-users to refine visualizations, ensuring that they remained relevant and effective over time
- Created interactive dashboards that allowed users to explore datasets independently, leading to increased engagement with company-wide analytics initiatives
- Worked closely with the client to understand their unique business needs, tailoring visualizations accordingly for maximum impact
Business Analyst
Professional Services - Slalom Inc.
Chicago, IL
11.2021 - 01.2022
- Participated in requirement gathering workshops with business leaders and end-users.
- Documented current state versus future state and designed flowcharts using Figma.
- Created system and technical design documents for new enhanced business process and performed gap analysis to identify areas of improvements.
- Developed diagrams to describe and lay out logical operational steps
Application Integration Specialist
Manufacturing - Perficient Inc.
Chicago, IL
10.2020 - 10.2021
- Built custom REST and SOAP APIs using RAML, MuleSoft Anypoint Platform and Oracle Integration Cloud (OIC) to help integrate various systems and big data sources together, Salesforce, Oracle ERP, Webservices, On-Premises Database and Data Warehouse.
- Created data integration packages, built transformation flows to process JSON, XML, CSV files and scheduled and monitored batch update jobs.
- Managed connections, adaptors and endpoints monitored and debugged API calls.
- Used JIRA during the life cycle development of the project to keep track of the active sprints.
Salesforce Developer and Administrator
Sales - Perficient
Chicago, IL
01.2019 - 10.2020
- Worked with standard and custom Salesforce objects, validation rules, process builders, visual flows, workflows, email templates, approval processes, and other components.
- Automated new business processes within Salesforce by writing Apex classes, apex triggers, REST webservices, visualforce pages and lightning web components (LWC).
- Created change sets and migrated metadata/code between Orgs using Git / Git Hub.
- Provided support for all Salesforce users and managed their access through users’ licenses, profiles, role hierarchy, permission sets and sharing rules.
- Worked with third party tools such as Pardot and Quip and conducted research on AppExchange for potential new apps and packages.
SQL Server and SharePoint Administrator
HR - Perficient
Chicago, IL
01.2015 - 12.2018
- Used SQL Profiler for performance tuning and query optimization.
- Managed database security and created user accounts, permissions, and profiles.
- Scheduled and monitored SQL Server Agent Daily Maintenance Jobs.
- Performed database monitoring, configuration, backup and recovery using SQL Server Management Studio (SSMS)
- Developed Data Models for new databases and applied normalization techniques.
- Provided end-user support and administration for all SharePoint environments.
- Migrated custom code, forms, and web parts to various SharePoint servers.
- Customized SharePoint sites using HTML, CSS, and JavaScript, wrote PowerShell scripts and managed content types, templates, document libraries and lists.
SQL BI Developer Analyst
Operations - Perficient
Chicago, IL
01.2015 - 01.2018
- Designed and built drill-down project management and leadership KPI reports using SQL Server Reporting Services (SSRS).
- Developed SQL Server Integration Services (SSIS) Packages to Extract, Transform and Load (ETL) data from SQL Server Database, SharePoint into SQL Server Analysis Services (SSAS).
- Implemented and managed slowly changing dimensions (SCDs) and optimized ETL pipelines to handle SCD Type 1, Type 2, and Type 3 scenarios efficiently,
- Shadowed the Data Warehouse Administrator, wrote DAX (Data Analysis Expressions) and MDX (Multidimensional Expression) queries and helped with cubes processing, and partitioning using star schema and snowflake schema.
.NET Developer
Accounting - Perficient
Chicago, IL
01.2011 - 12.2014
- Created databases, schemas, large tables, user defined functions, complex views, clustered and non-clustered indexes, and insert/update triggers.
- Built complex stored procedures and views using Transact-SQL (T-SQL) that spam over multiple tables using all sort of Inner and Outer Joins as well as Unions.
- Developed custom workflows, web pages, web forms, web apps, web parts, and event handlers using C#.NET, ADO. Net, MVC, ASP.NET and Visual Studio.
- Participated in the entire Software Development Lifecycle (SDLC) by collaborating with business users, writing technical documents, developing, debugging, and deploying code, maintaining version control, and preparing and executing test cases.
Education
Master of Arts - Management Information Systems
DeVry University
Schaumburg, IL10.2010
Skills
- Azure Modern Data Platform
- SQL Server
- Microsoft BI Tools
- C#Net / ASPNet
- Salesforce Sales / Service Cloud
- MuleSoft / Oracle Integration Cloud
- Copado / Azure DevOps
- Tableau CRM
- SharePoint
Certification
- Microsoft Azure Data Engineer (In Progress)
- MuleSoft Developer
- Copado Developer
- Copado Administrator
- Salesforce Certified Application Architect
- Salesforce Certified Sharing and Visibility
- Salesforce Certified Data Architect
- Salesforce Certified Sales Cloud Consultant
- Salesforce Certified Developer
- Salesforce Certified Admin
- Salesforce Certified App Builder
- MCSE: Data Management and Analytics
- MCSA: SQL Server
- MCSA: Web Applications
- MCSD: App Builder
Timeline
Software QA Engineer
Manufacturing - Slalom Inc.
04.2024 - Current
Azure Data Engineer
Finance – Slalom Inc.
03.2023 - 03.2024
DevOps Engineer
Government Sector - Slalom Inc.
05.2022 - 02.2023
Data Analyst
Consumer Goods - Slalom Inc.
02.2022 - 04.2022
Business Analyst
Professional Services - Slalom Inc.
11.2021 - 01.2022
Application Integration Specialist
Manufacturing - Perficient Inc.
10.2020 - 10.2021
Salesforce Developer and Administrator
Sales - Perficient
01.2019 - 10.2020
SQL Server and SharePoint Administrator
HR - Perficient
01.2015 - 12.2018
SQL BI Developer Analyst
Operations - Perficient
01.2015 - 01.2018
.NET Developer
Accounting - Perficient
01.2011 - 12.2014
Master of Arts - Management Information Systems
DeVry University
- Microsoft Azure Data Engineer (In Progress)
- MuleSoft Developer
- Copado Developer
- Copado Administrator
- Salesforce Certified Application Architect
- Salesforce Certified Sharing and Visibility
- Salesforce Certified Data Architect
- Salesforce Certified Sales Cloud Consultant
- Salesforce Certified Developer
- Salesforce Certified Admin
- Salesforce Certified App Builder
- MCSE: Data Management and Analytics
- MCSA: SQL Server
- MCSA: Web Applications
- MCSD: App Builder
Similar Profiles
Rosemarie La GuardiaRosemarie La Guardia
Senior Financial Operations Analyst at Slalom Inc.Senior Financial Operations Analyst at Slalom Inc.
Shonzayla JohnsonShonzayla Johnson
Siemens at ManufacturingSiemens at Manufacturing
Luis Alberto MunozLuis Alberto Munoz
Tesla at ManufacturingTesla at Manufacturing