Stephen Schell Email & Phone Number

Austin, Tx, Us

Austin, Tx, Us

Maryland Heights, Missouri, Us

Designed, coded and supported the following projects:Before/after data migration comparison tool in AWS Glue utilizing PySpark, Glue Crawlers/Classifiers, S3, Athena and Tableau summary/detail level reports with drill-through functionality.CloudFormation YAML configurations and CLI BASH scripts for deployment of all the team's AWS assets including KMS keys, S3 buckets, Lambda functions, Glue jobs/classifiers, tables, and related IAM policies.API data extraction Python tool allowing dynamic client-specific JSON configurations for bulk deployments to parameterized environments (DEV/QA/PROD) utilizing PUT/POST methods from Requests libraryIncremental data extraction using layered SQL queries within a confined API spaceSupported a legacy many-to-many SSAS cube and SSIS ETL process with 42 measure groups, 673 measures/calculations, 131 dimensions, and 2,164 dimension attributesSolutions Architect organizing viewpoint/perspective documentation for enterprise stakeholdersAgile/Scrum methodologies using Atlassian Jira, Bitbucket and ConfluenceAchieved certification as AWS Developer Associate with a score of 96%

Austin, Texas, Us

Coded SSIS 2016 ETL packages and T-SQL scripts into Azure Data-WarehouseData sources including MariaDB, cloud-based REST APIs, and JSON filesSummary & drill-through financial report development over Power BI Desktop/Service for desktop and smartphone viewingDevelopment of Power BI datasets for Cortana voice queriesSSAS 2016 Tabular Model Cube developmentData-Warehouse modeling for customer survey facts and dimensionsAgile/Scrum methodologies using Atlassian Jira, Bitbucket and Confluence

Developed complex data sets for migration from a legacy mainframe system to modern database financial systemCoded T-SQL scripts in SQL Server 2014 with a heavy emphasis on windowing functions & recursive algorithms as high as 80 steps.Coded SSIS 2014 ETL packages for data migration and QA testing.Project management utilizing Agile/Scrum methodologies within CollabNet TeamForgeDeveloped SSRS 2014 reports for tracking data quality and project status eventsDeveloped embedded C#.NET scripts within SSIS packages.Provided financial expertise in understanding the overall context of financial data sets

Austin, Tx, Us

Designed and developed Raw/ODS data-warehouse layers over Teradata 15 databaseCoded ETL workflows in Alteryx 11 from flat file sources into Raw tablesDeveloped ETL workflows in Alteryx 11 and Teradata SQL/BTEQ for ODS loadsProvided a unified data perspective of corporate Competitive Intelligence dataProvided technical advice to Competitive Intelligence Team on EDI/ETL processes and current data modeling methodologies

Austin, Tx, Us

Developed and maintained Summary, Detail & Financial reports via SSRS 2014Advised consulting team on design of ODS and Dimensional Data WarehouseCoded SSIS 2016 ETL packages for ODS database loadsManaged database and reports deployment via RoundHouse and C#.NET scriptsCoded SQL Server 2016 T-SQL stored procedures for reporting APIProgrammed a Revenue report aggregating by month and ordering by time across multiple hierarchy members over a floating calendar year.Interviewer and trainer for the BI/Reporting team

Maryland Heights, Missouri, Us

-- Data warehouse development and project management-- Interviewer and trainer for Data Engineering team-- OLAP data warehouse design, programming and SaaS production support utilizing SSDT over Microsoft SSAS 2012 and SQL Server 2014-- ETL design, programming and SaaS production support utilizing SSDT over SQL Server 2014-- Facilitating laboratory proof of concept designs including SSAS data mining and Hadoop Ecosystem architecture (Hive, Pig Latin, Sqoop, Oozy, Kafka)

Austin, Texas, Us

-- Developed OLAP Database and Ad Hoc Reporting solutions utilizing SQL Server 2008, Analysis Services 2008 (SSAS) and Integration Services 2008 (SSIS) for both Clinical and Financial Data.-- Develop query-based and dashboard reporting solutions utilizing Crystal Reports 2008, SQL Server Reporting Services (SSRS) 2008, T-SQL and MDX.-- Interviewed prospective new-hire candidates for report development positions.

Santa Clara, California, Us

• Manage and support offshore Business Intelligence development team.• Develop SQL Server 2008 Reporting Services and Analysis Services solutions.

Birmingham, Al, Us

(BBVA Compass, formerly Guaranty Bank)• Oracle 9i/10g Development (PL-SQL)• SQL Server 2000/2005 Development (T-SQL)• SQL Server 2000/2005 Business Intelligence Development (SSIS/SSRS/SSAS)• ASP.NET/XHTML/Javascript Web Application Development• Argo Data Application Development (Teller, Sales and Service, Business Intelligence Reports)• Korn Shell/MS DOS-XP Scripting• 3270 Mainframe Interface Support

• Oracle 10g/10gR2 Development (PL-SQL)• Oracle 10g/10gR2 Database Administration• Hyperion/Brio SQR Reporting• OSI TCCUS Banking Application Development and Support

Fullerton, Ca, Us

• Systems design and internet marketing consultant for senior management• Redesign of organization’s website structure and content management procedures

Charlotte, Nc, Us

Bachelors Degree, Management Information Systems

Associate'S Degree, Business Administration