Airflow, ETL and data warehousing. Working with Azure ADO and AWS environment.

My role consists of working on a team responsible for the design, development, implementation and daily execution of data lake and data-warehousing processes on AWS. We rely on RDS, S3, EC2, SWF, and Redshift for our ELT processing.

Business Intelligence developer responsible for data warehouse design, implementation and maintenance. Primary tools include SQL Server, SSAS, SSIS, and SSRS.

Designed and implemented SQL Server databases and complex stored procedures for data analysis and parameterized reporting to provide clients with organization specific data needed for key business decisions Helped design and implement data warehouse and OLAP cube with SQL Server to help expedite the querying of research data for online client facing applications Developed complex Excel models from user requirements to analyze and aggregate large sets of data from multiple data sources for business intelligence reports Built web based dashboards with SAP Xcelsius to dynamically display key research results and KPIs onlineDesigned, built and launched complex web-based surveys using Vovici and JavaScript to capture large sets of external participant data on varying research topics and organization initiatives to aid clients in business decisionsBuilt ASP.Net web services and small ASP.Net applications that query SQL Server databases and return result sets in a consumable manner to end user customersGathered requirements and developed wireframes and story boards for web based applicationsInstructor for Advance Excel training course

Performed risk-based analysis to identify possible issues and opportunities for process improvementProvided mitigation and action plans for Professional BusinessDeveloped MS Access database and VBA forms to track and generate reports for Sarbanes-Oxley testingPerformed SQL based queries in a QMF environment from IBM base tables, routinely pulling sales, inventory, and markdown data and providing analysisBuilt presentations for management and routinely reported to management and cross functional business ownersPerformed store walks to develop a better understanding of processes in the retail industry

Assisted Sarbanes-Oxley audit projectsDeveloped business process maps and identified business controls

Selected as an undergraduate teaching assistant, providing MS Office instruction to a class of over thirty students