Stephanie Leblanc work email
- Valid
- Valid
Stephanie Leblanc personal email
- Valid
Stephanie Leblanc phone numbers
Stephanie Leblanc is a Principal Analyst at Carvana at Carvana. She possess expertise in microsoft sql server, sql, databases, analysis, data analysis and 16 more skills. Colleagues describe her as "Stephanie worked for me as a Business Analyst at Fidelity Investments. She was able to very quickly understand the data and operations of the group and provided immediate contributions in automating inefficient reporting processes and building new analysis through Hyperion. She is a naturally curious problem solver who enjoys challenging questions and can provide extremely effective technical solutions in a short time frame. She responds to direction and feedback very well and also is one of those rare individuals who is willing to provide a valuable alternate perspective even if it isn't positive news. I wish her luck and would gladly hire her again if I had the chance." and "Stephanie is a highly intelligent and hard-working analyst who is not content to simply come into work and grind out a day. She's interested in learning new things and is always pushing herself to the next level of skill. Let me give two examples: first, my team creates reports that are most often distributed via my company's internal Web. Up to last year, the report link was most often delivered via an internal email. If the customer lost the email, the link had to be "found" again and sent again. We very much needed a common "landing page" to serve both as a standard launch point for our internal customers from which they could all navigate to their respective reports, and to act as de-facto documentation for my team on what we needed to maintain. Stephanie took it upon herself to gather these disparate threads and weave them into an attractive and highly useful web site that is in use today. Second, my team currently uses SQL Server and SSRS as the primary environment and tool for creating reports. Stephanie came in knowing nothing about SSRS and in less than a year became pretty much the department's top expert in how to use that tool to create great-looking, interactive reports for our internal customers. Both examples showcase that she does not worry about what she doesn't know how to do -- she simply does things that need to be done and learns along the way. Working with Stephanie was a great pleasure and I know she'll be an asset to any team that she is part of."
-
Principal AnalystCarvana Dec 2022 - PresentTempe, Arizona, Us -
Senior Data Engineer, Product AnalyticsCarvana Oct 2019 - Dec 2022Tempe, Arizona, Us -
Sql Server Database EngineerKgb Feb 2016 - Oct 2019New York, Ny, Us● Scaled in-house autodocumentation schema and logging drawing, merging report subscriptions from ReportServer with existing logging of remote task executions to update Excel reports. ● Created SSRS reports for monitoring jobs, reports, procedure executions, table growth, etc. merged from across 8 SQL Server instances in a manner equally to both the user base and MIS' global support team.● Supported client invoicing and operational reporting for kgb's Directory Assistance and other call services and agent training with a focus on discovering, correcting, and preventing future errors/gaps in data staging, as well as polishing existing report delivery in SSRS, Excel. o Improved data integrity and transparencyo Optimized and automated ETL and reporting as-neededo Created strategic table-driven email notifications to cut down on manual analysiso bcp import/export of call detail records for invoicingo Templates for quick copy/paste translating legacy fixed-width files into Excel and human friendly SQL tables to examine contents in response to client billing inquirieso Meticulous documentation of process and solutions in JIRA for future reference, as well as formal documentation in Confluence● ETL of agent schedule and call data (Verizon Wireless, Tennessee Carriers) from internal routing switches to Data Warehouse, while maintaining invoice reports for clients (Excel, SSRS reports & subscriptions).o Managed recent call platform conversion from internally hosted call routing to Verizon's hosted vendor platform. This required transitioning all existing ETL processes from internal linked servers to OPENROWSET extracts from CSV files on network from the client.o Currently preparing for call platform change from Avaya to CX100/Bright Pattern. Created all new loaders, replicated existing reports with test data from Data Warehouse, worked with call routing team to establish consistent reporting mechanisms. -
Senior Data EngineerThe Advisory Board Company Feb 2015 - Feb 2016Washington, District Of Columbia, Us• Further scaled metadata model to support a companywide ETL process accepting variable single-stream client data, with differing requirements across 8 products via SQL Server.o Automated major data movement using dynamic SQL.o Phased data approach w/dynamic schema generation based on staging step.o Modeled 1:many relationship between data elements and columns to preserve integrity between dynamic spec and table creation.o Selective metadata columns deployed only where needed.o Modeled simple case pivoting handled programmatically.o Strategies and procedures to isolate customization in scripts requiring frequent maintenance, with intention to replace with more programmatic approaches as the platform matures.• Successful application of master healthcare spec developed in previous role in client implementation supporting two feeds and three products (SQL Server). o Led and trained five analysts on new approach to data collection.o Even with adaptive modifications, initial deployment for all three products was timely.o Data flow has since remained stable for nearly a year with minimal centralized support.• Developed procedure and source data element library for generating synthetic data in support of end-to-end testing that legally avoids exposing protected health information (PHI).o Spawn design creates tables and structures as data elements are identified.o Method for exception handling that maintains integrity of attached data to allow clean tests.o Simple weighting structure designed for refinement based on distributions observed in real data.o Supported the following data generation scenarios Simple lookup, with frequency Dependent sets of data elements Pattern-based data elements Procedures to generate random values in a range for each data type• Created support procedures for deploying data models with an eye toward scaling to automatic transformation practices upon maturity of process from backend users to frontend tools. -
Technical Operations Analyst, Associate DirectorThe Advisory Board Company Apr 2013 - Feb 2015Washington, District Of Columbia, Us• Designed data hub metadata schema describing relationships between data sets, data elements, and product requirements for flagship data product.o Built dynamic specification engine that identifies and assigns criticality to data requirements based on collection of products contracted. (SSRS)o In order to expose metadata functionality, architected healthcare schema to populate metadata tables, coordinating across 8 separate, siloed product services teams.o Master healthcare schema contains over 1,000 data elements describing hospital stays, patient demographics, parsed claims, billing records, OR supplies, etc.• Built a library of 75+ stored procedures executed nearly 10,000 times a month across 100 client implementations, scaling out prior work on Standardized Staging Architecture (SSA), with new deployments weekly. Heavy dynamic SQL, allowing model additions without script revision. Failure rate backbone procedures is <0.01%, and procedures have been in use and stable for four years. Defects have been detected on the order of about once per year since 2013, and are generally resolved within minutes by minor modifications/additions to procedures.• Supported a team of ~50 services analysts in SSA deployments, including schema-aware procedures to standardize transformations common to two or more client deployments.• Company-wide SQL Server knowledge resource and trainer. Designed and present SQL Style quarterly. Coverage on topics from formatting for ease of edit and shareability, to functional recommendations on table design, to defensive coding. -
Sr. Business AnalystThe Advisory Board Company Aug 2011 - Apr 2013Washington, District Of Columbia, UsStephanie joined the CCC BA ranks in August 2011, and quickly built a reputation as an all-around technical powerhouse. While supporting a full member pool, she pushed the envelope on how we think about staging and loading member data. In effort to standardize our ETL operations across all CCC members, Stephanie designed, developed, and implemented a new database architecture that would bring needed normalization and consistent naming conventions into the CCC deployment process. It was her willingness to challenge the status quo that also guided the CCC (and now CPRM) teams to apply more advanced concepts to our work using stored procedures and dynamic SQL. These applications have increase the speed of data processing, and reduced the amount of manual and custom coding required to build Crimson sites. Jun 13, 2013• Devised Standardized Staging Architecture (SSA), a collection of process guidelines and stored procedures in support of single-tenant ETL conducted largely from the backend (SQL Server).o Centralized library of stored procedures supporting generic ETL processes using dynamic SQL to intelligently move data (ex: Insert, Merge, Make Records Distinct, Dedup Table).o Creation and documentation of standard process, including phasing data such that errors can be quickly, or even automatically, detected by user or diagnostic.o Redesign of staging schema with consistent conventions and much-needed normalization.• SSA framework and library went on to be adopted by hundreds of users and deployments across four independent product data services teams, and has been in stable use with virtually zero maintenance for over four years. • Serviced 15 concurrent "high-touch" hospital clients. Primary focus on monthly data loads to load and massage data submitted in delimited files to tables within single-tenant SQL Server databases. Clients' difficulties ranged from limited technical acumen to frustration with frequent troubleshooting of the data load process.
Stephanie Leblanc Skills
Stephanie Leblanc Education Details
-
University Of New HampshireInterdisciplinary Mathematics: Statistics
Frequently Asked Questions about Stephanie Leblanc
What company does Stephanie Leblanc work for?
Stephanie Leblanc works for Carvana
What is Stephanie Leblanc's role at the current company?
Stephanie Leblanc's current role is Principal Analyst at Carvana.
What is Stephanie Leblanc's email address?
Stephanie Leblanc's email address is ca****@****ail.com
What is Stephanie Leblanc's direct phone number?
Stephanie Leblanc's direct phone number is (347) 441*****
What schools did Stephanie Leblanc attend?
Stephanie Leblanc attended University Of New Hampshire.
What skills is Stephanie Leblanc known for?
Stephanie Leblanc has skills like Microsoft Sql Server, Sql, Databases, Analysis, Data Analysis, Business Analysis, Access, Business Intelligence, Process Improvement, Etl, Html, Ssrs.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial