Luis Lema Email & Phone Number

Charlotte, Nc, Us

• Led a corporate intitive to transition from SQL Server and SSIS into cloud technologies.• Designed and built end-to-end data pipelines using S3, Snowpipe, Confluent Kafka, Snowflake, dbt and Airflow to replace hosted Apache Kafka, SQL Server stored procedures and SSIS packages.• Coached team members on cloud technologies, such as AWS, Snowflake, dbt Cloud and MWAA.• Designed and built data vault models using Snowflake and dbt.• Improved ETL run time from 9 hours to 2 minutes using dbt incremental models, Snowflake query optimization and clustering for better micro-partition pruning.• Created python DAGs in Airflow MWAA and Astronomer to orchestrate dbt jobs, as well as for data loading and monitoring.• Developed custom timetable plugins and operators in Astronomer to expand Airflow capabilities.

- Developed mobile apps for Android and iOS using Xamarin and C#.- Created and configured a WordPress website in AWS using Lightsail, CloudFront, Route 53 and S3. (www.plataformalatina.com)

Brooklyn, Ny, Us

• Used BigQuery to manage and analyze data.• Used dbt Core and dbt Cloud to create and test models.• Used Looker to create explores and views.• Used GitHub for version control.• Used Stitch to extract data from PostgreSQL into BigQuery.

Bellevue, Washington, Us

• Used Confluent Cloud to stream data from Azure Event Hubs and AWS Kinesis into Snowflake.• Designed, developed and troubleshot Airflow DAGs.• Created GitLab CI/CD pipelines.• In Azure Automation created PowerShell and Python runbooks to download SharePoint lists into Azure Blob Storage, load data into Snowflake tables, write files with Snowflake data to Azure Blob Storage and upload the files as attachments back to SharePoint lists.• Developed python scripts to POST and GET data from REST APIs.• Created databases, user, roles, schemas, tables, views, pipes, stages, storage integrations and managed permissions in Snowflake Cloud Data Warehouse.• Used Snowpipe to load data from AWS S3 and Azure Blob storage into Snowflake.• Loaded data from PostgreSQL into Snowflake using Airflow.• Developed advanced Jenkins pipeline jobs using Groovy.• Used Docker to stand up an Airflow server.• Used C# to programmatically create SQL scripts.• Used Python to programmatically create SQL scripts.• Used PowerShell to retrieve and update SharePoint lists.• Used AWS Lambda functions and Python to execute SQL scripts in Snowflake.• Created Sumo Logic sources, reports and alerts.• Used Python to export Snowflake data out to Sumo Logic and Braze HTTP endpoints.• Created Azure Event Hubs to send data to Azure Blob Storage accounts using Azure Stream Analytics jobs.• Created Azure Monitor Alerts.• Created Tableau reports and dashboards and published them to Tableau server.• Created an ASP.NET website using C#, MVC, Entity Framework and LINQ to search, update, delete and add data to the database.• Created advanced Power BI reports.

Bellevue, Washington, Us

• Engineered and developed a process to perform sentiment analysis on Reddit posts and iTunes App Store reviews for Wizards of the Coast's games using C# (connected to APIs and parsed XML and JSON data), recursive methods (retrieved nested comments), SSIS 2016 (loaded the data into the database), SQL Server 2016 Full-Text Search (looked for particular keywords or combination of keywords in the data), Dynamic SQL (traversed through posts, comments and reviews using a set-based approach to avoid cursors), and Power BI (presented the analysis using charts, word clouds, etc.).• Using Visual Studio 2015 developed Windows Forms Apps in C# for multiple teams to retrieve, update and delete data from the databases.

Renton, Washington, Us

Troy, Michigan, Us

• Developed PowerShell scripts to deploy SSIS environments to the SSISDB catalog.• Created PowerShell scripts to push build definitions from Visual Studio 2013 to Octopus Deploy.• Used Octopus Deploy and PowerShell to automate the deployment of SSIS projects. • Created, updated and optimized T-SQL stored procedures and views.• Created and maintained SQL Server Analysis Services cubes.• Used Splunk to query databases and develop reports.• Setup and configured websites on Internet Information Services (IIS).• Performed database administration tasks.

Bellevue, Wa, Us

• Developed several SSIS packages to import and export data between SQL Server and IBM AS/400 servers as well as flat files.• Developed SSIS packages to connect to a web service, programmatically retrieve and parse XML data using C#, and store it into a SQL server database.• Created and published ASP.NET websites to Microsoft Azure.• Created and managed Azure SQL databases, including administering permissions and data transfers.• Developed complex SSRS reports as well as RDLC reports for web applications.• Developed reports using QlikView.

Seattle, Wa, Us

Redmond, Washington, Us

• Involved in a project to create an end-to-end metadata driven ETL process, utilizing primarily Dynamic SQL and SSIS.• Improved the process to programmatically create SSIS packages using C#, adding the ability to load additional data sources including Excel spreadsheets, Access databases and SSAS cubes.

Redmond, Washington, Us

• Created an ETL process to extract data from text files into SQL tables using SSIS.• Created and updated stored procedures, functions and views to merge the new data with existing data in a Data Warehouse.• Updated a SSAS cube to include the new data.• Created complex stored procedures and a SSRS reports to show the data.

Bellevue, Washington, Us

Bellevue, Washington, Us

Bellevue, Wa, Us

• Updated SSIS packages to extract data for an existing ETL process.• Updated stored procedures to transform and load the data into a Data Warehouse.• Updated the database schema to store the new data.• Updated views to report the data.• Wrote documentation for the changes.

Bellevue, Wa, Us

• Involved in an ETL project to load several data sources including Excel spreadsheets, flat files, SQL tables and ACUCOBOL files into a Data Warehouse.• Created SSIS packages to extract the data from the different sources into SQL tables.• Wrote stored procedures, user defined functions and views to transform, load and report the data.• Helped with the database schema design.• Wrote support documentation for the ETL process.

Seattle, Wa, Us

• Prioritized and assign help desk requests to data operations technicians.• Provided customized data support for analytics team & key business users.• Created SSIS packages, jobs, triggers, and stored procedures to automate SQL tasks.• Optimized T-SQL queries.• Used Excel functions, pivot tables and data connections.• Troubleshot and resolved issues with our production systems & processes.• Communicated with clients and vendors to resolve data issues. • Managed onboarding process for new clients.• Supported third party applications.

Seattle, Wa, Us

• SQL: Wrote scripts to perform updates to tables and created queries to pull data extracts using T-SQL. Created tables, temporary tables, variable tables, views, stored procedures and SSIS packages.• ETL (Extract, transform, load): Managed data in various formats including Excel spreadsheets, text files, EDI, AIM and other proprietary formats. • Analyzed and cleansed data, verified the data was formatted appropriately, and loaded the data into production database tables using SSIS packages. • Performed data transformation using SQL stored procedures and troubleshoot loading issues inside the SSIS packages.• Created and tested FTP site connections using multiple protocols including SSH, SSL and SFTP. • Created and maintained Active Directory accounts, handled NTFS permissions, created and updated Exchange Server e-mail accounts and groups, resolved server connectivity issues, dealt with hardware issues including identifying and replacing faulty computer components, also software issues including Microsoft Windows, Outlook, and other proprietary software.

Seattle, Wa, Us

• Managed serviced and owned accounts. • Handled inquiries and resolved issues with the accounts.• Translated Spanish calls and documents for various departments within the company.

Fort Washington, Pa, Us

• Made and received bilingual calls. • Helped costumers resolve delinquent account balances.• Handled around 400 calls a day. • Awarded as the top collector for 8 straight months.

• Provided interpretation services in clinics and hospitals as well as in social services offices throughout the Puget Sound area.

Master Of Science In Information Systems

Bachelor Of Science In Information Technology

Bachelor Of Science In Computing And Software Systems

Education record

Associate Degree

Bachelor In Information Engineering