SUMMARY

• Dependable, divergent thinker with a great work ethic that uses patience, humor and professionalism to mentor and inspire team members to achieve organization goals.
• 10 + years of experience in designing, building and supporting multi - regional IaaS/PaaS/SaaS solutions & distributed applications on public cloud providers such as Citrix, Amazon AWS, GCP, Azure etc.
• 5 + years Managing advanced AWS provisioning and configuration technologies components (VPC,EC2,S3, ELB, ElastiCache, RDS, Route53, Data Pipeline, CloudWatch, CloudFormation, and others) with a passion for advancing and continually improving our DevOps automation and practices to keep our applications easy to deploy, monitor, scale and backup in a Multi-AZ cloud environment.
• 20+ Years in database administration, with extensive experience designing, coding, testing, replication, high availability, disaster recovery, security, automated backups, performance tuning and supporting next-generation database solutions in Azure Analysis Services (SSAS) and Azure SQL Server environments.
• 5 + years of experience in DevOps with AWS, Azure & Google Cloud. Experienced in production deployments leveraging CI/CD & Build & Deploy Pipelines. (e.g., Elastic Beanstalk, Lambda, IAM, AWS CodeCommit, CodeBuild, CodeDeploy, Jenkins, Maven, Kubernetes, Docker, & Gitlab Repositories)
• 10 + expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI), AWS Glue, & C# Scripts for importing or exporting to or from DB systems such as Oracle, MSSQL, Mongo DB,, DynamoDB, PostgreSQL, MySQL, Amazon Aurora & Amazon Redshift.
• Experienced with python data analysis Scikit-Learn, Pandas, Numpy, Matplotlib, Jupyter Notebooks and R statistical programming languages.
• Experienced in business intelligence and analytics related projects using data warehouse dimensional design principles, Tabular-based reporting, and Tabular Data Models. Skilled in an assortment of technologies, including JDBC, T-SQL transformation queries, Windows, Azure SQL and Unix+ using Agile/Scrum development methodology.
• Strong leader with experience training and inspiring developers. Motivated and managed the staff team with excellent communication and solid presentation skills. Empowered and envisioned team members to train individuals and groups.
• 5+ Years of Microsoft SSRS/Business Intelligence (BI) report development experience. Functional and technical knowledge of the features, proper configuration and support of Microsoft SQL Server Report Server and Power BI gateways.
• 20+ Building a solid background in leading Microsoft infrastructure products such as Windows Servers. Successfully upgraded multiple systems from 2000 through 2019. Adept with all facets of active directory/LDAP administration and domain controllers. Configured various mainstream infrastructure technologies that include PowerShell Scripting, Hyper-V, VMware, Citrix Xen Apps, Linux, Oracle, SQL, DNS, NLB, DHCP, IIS, DFS, SAN/NAS, routing, switching, & clustering.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Warehouse Architect / Database Analyst

Responsibilities:

• Managed all phases of the data warehouse development lifecycle, from gathering requirements to testing, implementation, and support; Including the development of dimensional and hybrid data models, data lakes, warehouses and data marts for BI analytic and reporting systems.
• Imported data from My SQL, Oracle, Progress, PostgreSQL, MongoDB, MSSQL, to Azure SQL DW to generate reports. Used Power BI & Amazon QuickSight to explore data in a variety of ways and across multiple visualizations.
• Created DAX Queries to generated computed columns and Implemented gateways to keep the published dashboards and reports up to date.
• Tasked with scrubbing, preparing and modeling algorithms with (R, Python, SLQ, etc.) and comparing statistical models like Decision Trees, K-NN & Naive Bayes for decision makers.
• Inspired team and led efforts to analyze data for source/target mappings, created T-SQL scripts for data processing and proactively identified, managed, and corrected data quality issues with reports provided to CR managers.
• Introduced and implemented DevOps solutions for a range of projects, by creating automated CI/CD solutions Managed users, roles, and privileges through IAM in the AWS Management Console.
• Documented all aspects and composition of business analysis including As-Is/To-Be process flows, requirement specifications, business rules, functional requirements, reference manuals, uses cases and knowledge transfer.
• Applied database and administration of multiple educational databases required for longitudinal analytics utilizing SQL Server Integration Services (SSIS) Packages, Data Warehouse fact and dimension tables, SQL Server Analysis Services (SSAS) Tabular Models, SQL Server Reporting Services (SSRS), Power BI reports and dashboards.
• Database and operating environments included, but not limited to: Open Edge Progress, MongoDB, Oracle, MYSQL, Microsoft SQL Server, and Access.

Confidential

Server Systems Engineer

Responsibilities:

• Developed, created and updated complex databases based on specific business requirements and maintained MSSQL 2000/2005 staging databases while analyzing, creating, and maintaining SQL scripts to load and transform data from other systems. Designed and implemented the virtualization process of the data center. Seamlessly managed all user access to securely hosted data. Performed technical tasks that included computer programming associated with software installations, system modifications, system integration, and application maintenance.
• Responsible for the development & support of SSRS reports that are primarily based on information from SQL Server application and BI Databases. Used Visual Studio and SQL Server Report Builder to modify or enhance SSRS reports and develop new SSRS reports. Team lead in the creation of functional Requirements and technical Specifications Documents as well as documenting the enhancements made to the SSRS reports.

Confidential

LAN/Wan Administrator & Instructor

Responsibilities:

• Daily administration, maintenance and troubleshooting of Windows 2000 domain designed to handle network and internet traffic for over 1000 intranet users.
• Developed complete Asp.Net 1.0, IIS 5.0, SQL 2000, and internet capabilities. Responsible for mentoring and instructing students in a goal-oriented fashion in NT4/2000.
• Developed effective teaching techniques to facilitate student perception, retention and participation.
• Explained to students in a laymen manner how to maintain campus networks using advanced troubleshooting processes without compromising security.