Lenny is available for hire
Hire LennyLenny Ardiles
Verified Expert in Engineering
Software Developer
Location
Atlanta, GA, United States
Toptal Member Since
June 18, 2020
Lenny is a data and analytics consultant with 20 years of experience specializing in Microsoft SQL Server tools, including SSAS, SSRS, and SSIS. He is an expert at SQL query optimization, end-to-end architecture, and the development of data warehouse projects. Lenny focuses on development with .NET, Python, JavaScript, and Spark.
Portfolio
Entera
Snowflake, Data Build Tool (dbt), Prefect, Cube.js, Docker, GitHub Actions...
Facebook
Spark, Presto, A/B Testing, Streaming Data, Python 3, Python 2, Dashboards...
Amazon.com
Redshift, Microsoft SQL Server, Amazon Web Services (AWS), AWS Lambda, AWS Glue...
Experience
Availability
Part-time
Preferred Environment
Node.js, Redshift, SSAS, MySQL, Apache Airflow, SQL Server BI, SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), Git, SQL
The most amazing...
...thing I've created is a single SSIS package to dynamically stage and process nightly, slowly changing dimensions for hundreds of tables—it's still in use today.
Work Experience
Staff Data Engineer
2023 - 2023
Entera
- Led the data engineering team in architecture and data modeling.
- Handled the data integration of public census and geographic address data, as well as improvements on the data process flow.
- Fixed a security bug on the open source project Prefect.
Technologies: Snowflake, Data Build Tool (dbt), Prefect, Cube.js, Docker, GitHub Actions, Jinja, Airbyte, Data Warehousing
Data Engineer
2018 - 2020
- Handled Facebook Marketplace pipelines from event logging to dashboarding for B2C in its first year, far exceeding transaction growth expectations.
- Enabled A/B testing with Deltoid holdout processing and provided data to support the measurement of new features.
- Supported Marketplace subteams for the Marketplace feed, loading performance dashboards, Marketplace ads, and core shared functionality, such as product dimension enhancements and privacy integration.
Technologies: Spark, Presto, A/B Testing, Streaming Data, Python 3, Python 2, Dashboards, Data Warehousing
Data Engineer
2017 - 2018
Amazon.com
- Built a data warehouse for an enterprise asset management (EAM) system. Developed reports and SSAS cubes for accessing data quickly.
- Provided mentorship, led project tasks, and designed technical architecture for integrating sorter logs for fulfillment centers across North America (for the jam reduction project).
- Led a team of data engineers integrating several data sources.
Technologies: Redshift, Microsoft SQL Server, Amazon Web Services (AWS), AWS Lambda, AWS Glue, Python, Data Engineering, Data Pipelines, Amazon QuickSight, Amazon S3 (AWS S3), Business Intelligence (BI), Data Warehousing, PostgreSQL
Business Intelligence Consultant | Senior Manager Level 2
2014 - 2017
Self-employed Consultant at AT&T
- Owned all data processes that reported official U-verse campaign effectiveness: proactive and loyalty campaigns and movers campaigns—direct mail, email, outbound telemarketing.
- Produced the primary source for U-verse end of contract roll-off, U-verse retention offer tracking, and data sources for retention cost for call center compensation. Designed data structures, documented logic, QA, and managed deployment.
- Contributed to the end-to-end architecture and development of campaign management data processes and reporting from several sources to consolidate and correctly measure churn metrics and significance from a previously inconsistent data standard.
Technologies: SQL Server Integration Services (SSIS), Microsoft SQL Server, Data Engineering, Business Intelligence (BI), Data Warehousing
Senior IT Developer
2012 - 2014
Home Depot
- Oversaw SQL Server Analysis Services (SSAS) development enhancements on MyDrill cube for all sales, inventory data, and YOY metrics at an SKU, store (2,200 stores), and daily level.
- Served as an IT lead for the Sales Analysis project and the SQL Server Analysis Services (SSAS) SKU attribute project.
- Created a cube for query usage to learn which metrics were being used and see reports on how MyDrill queries took to render in Excel based on dimensions selected.
- Designed architecture of business intelligence solutions technical specifications and contributed to the preparation of technical documentation.
Technologies: Microsoft SQL Server, Data Engineering, Data Warehousing
Business Intelligence Developer III
2011 - 2012
Assurant Solutions
- Developed an ETL framework to reduce development time importing, staging, error handling, and preparing for SCD type 2. Scalable and easily handles nightly imports of 60 million rows. One configurable SSIS package dynamically handles multiple projects.
- Contributed to the dimensional modeling design based on requirements. Broke down tasks and time estimates for ETL development, cube development, SharePoint site development, and report development.
- Contributed to SQL Server Analysis Services (SSAS) development on several databases using perspectives, translations (Spanish and Chinese), MDX, calculated measures, role security dimensional attributes, role-playing dimensions, and server sync.
- Supported power users for reports at multiple locations and countries to help train them in bridging skills required for them to build self-service reports.
Technologies: SSAS, Microsoft SQL Server, Data Engineering, Business Intelligence (BI), Data Warehousing
Business Intelligence Consultant
2010 - 2011
Sheridan Healthcare
- Designed, built, and integrated the reporting solution within the new browser based revenue cycle management solution, including about 30+ reports.
Technologies: C#, .NET, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server, Data Engineering, Business Intelligence (BI), Data Warehousing
Consultant
2009 - 2010
BUPA Latin America
- Saved 2-5 days of work each month by automating accounting processes for reporting formerly identified, documented, and reported details of validations required for improved data quality for a large data migration project.
Technologies: SQL Server Reporting Services (SSRS), SSAS, Microsoft SQL Server, Data Warehousing
Information Systems Consultant
2008 - 2009
MetLife
- Optimized a large TSQL process that decreased code by 75% and improved performance from 18 minutes to less than 4.
- Improved an SQL server process, written in more than 100 DTS packages, that processes trades of securities and integrates with the CAMRA securities accounting system.
- Produced information for securities, accounts, securities prices, security types, FX rates, brokers, issuers, and business syndicated loans, returning the tax lots and positions to the trading system.
Technologies: VB.NET, SQL Server Integration Services (SSIS), Microsoft SQL Server, Data Warehousing
Software Developer
2004 - 2008
For Eyes Optical
- Led the applications development group in building solutions to assist the company in selling retail eyewear for distribution to all of its stores for the seventh largest retail eyewear chain in the United States by revenue with 120 stores.
- Served as an IT lead for the purchase and integration of an optical POS system. Worked with management teams and SMEs to gather requirements and develop 2.000+ question requests for proposal (RFP). Evaluated and scored all RFP submissions for presentation to the company execs.
- Developed SSIS packages in Microsoft SQL Server 2005 for creation of an operational data store (ODS) based on the National Retail Federation’s ARTS data model.
- Implemented a two-way transactional replication on SQL Server 2000 for hurricane mitigation in Florida to migrate the web server offsite for disaster recovery. Identified database objects that were used by the web site and decoupled from the main database server.
- Improved and optimized stored procedures for the sales commission calculating system, speeding up an 8-hour process to about 16 minutes.
Technologies: SharePoint, ASP.NET, VB.NET, Microsoft SQL Server, Data Warehousing
.NET Programmer
2002 - 2004
ABC Distributing LLC
- Introduced a client/server team to the .NET framework while still in version 1.0. and converted existing Visual Basic 6.0 module libraries to Visual Basic .NET libraries and developed other libraries to be familiarized and utilized by the team.
- Integrated time tracking of projects through the allocation of hours from Niku Time into the Remedy project tracking system.
- Contributed to the client/server team, developing internal libraries, tools, and project management integration. I also built a custom application for the CEO to track his projects.
Technologies: Visual Basic, Crystal Reports, ASP.NET, VB.NET
Experience
End-to-end Data Warehouse Development
I am experienced in data warehouse architecture, development, ETL processing, and SSAS cube creation in various industries. Relevant experience includes retail at Amazon, The Home Depot, and Facebook Marketplace; ABC distributing; marketing technoloy at AT&T; and insurance at Assurant Solutions and MetLife.
Query Performance Optimization
I have consistently been able to speed up slow queries.
Data Management
Managed a team of data engineers, building a data warehouse of metrics from a dozen data sources. Daily scrum meetings, data architecture, team building. Subject areas included safety metrics, training data, sensor data, issues, and equipment repair metrics.
Skills
Languages
T-SQL (Transact-SQL), SQL, Stored Procedure, Python, Java, Visual Basic .NET (VB.NET), Snowflake, C#, VB.NET, Visual Basic, JavaScript, Python 3, Python 2
Paradigms
Database Design, Business Intelligence (BI), ETL, Data Science
Storage
Microsoft SQL Server, RDBMS, Databases, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Data Pipelines, PostgreSQL, MySQL, Redshift, Data Integration, Teradata, SQL Server Data Tools (SSDT), SQL Stored Procedures, Amazon S3 (AWS S3), PL/SQL
Other
Data Warehouse Design, Data Engineering, Data Warehousing, Entity Relationships, ELT, Data Modeling, Reporting, Performance Tuning, Data Mining, Data Management, Data Architecture, Real Estate, Data Analytics, Health Insurance, Data Analysis, Big Data, Azure Databricks, Team Leadership, Optimization, Financial Systems, Data Migration, Health IT, Machine Learning, Database Optimization, Data Build Tool (dbt), A/B Testing, Streaming Data, Dashboards, Prefect, Cube.js, GitHub Actions
Frameworks
Spark, .NET, ASP.NET, Jinja, Presto
Libraries/APIs
PySpark
Tools
Apache Airflow, SSAS, Crystal Reports, AWS Glue, SQL Server BI, Git, Amazon QuickSight
Platforms
Amazon Web Services (AWS), Databricks, SharePoint, Oracle, AWS Lambda, Docker, Airbyte
Industry Expertise
Insurance
Education
2010 - 2011
Master's Degree in Management of Information Systems
Florida International University - Miami, FL
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring