Nicole J. McDonald

(Formerly Nicole J. Sanders)

**** * ******* ***.

Los Angeles, CA 90034

256-***-****

adgw7u@r.postjobfree.com

Experience

Senior Database Administrator/Architect/Developer

June 2020 - Present

Ask Doss - Houston, TX (Remote Consultant out of Los Angeles, CA)

Highly recommended and featured in Forbes, Ask Doss is the ground breaking new addition to DOSS Brands, founded by CEO Bobby Bryant with the help of COO Chris Norton and CTO Jacob Daigle, to utilize ground breaking technology that proficiently transacts real estate at an affordable price. Ask Doss is a voice activated personal assistant that aids in the home buying process from A to Z. DOSS is a digital real estate brokerage that encompasses everything Real Estate. For both buyers, sellers and real estate agents, DOSS expedites finding properties, buying, renting, selling, mortgages, home warranty and home security - DOSS does it all. “BETTER. FASTER. SMARTER.”

www.askdoss.com

https://profiles.forbes.com/members/realestate/profile/Bobby-Bryant-CEO-Founder-Ask-Doss

Analysis of data files of different formats to determine best type of database to store data for ETLs reporting and search capabilities

Create ERDs for Database Design

Create Data Catalogue to easily identify data elements, locations and originating sources

Design and create databases, schemas, tables, sequences, constraints, indexing, users, roles, security measures in a Cloud environment

Create ETLs to normalize, transform, join and insert raw data from a data lake into a databases and S3 buckets for voice search application

Create stored procedures with scheduled jobs as necessary

Database Maintenance tasks: backup/restore, replication, tuning

Perform full software lifecycle: requirements gathering, requirements analysis, design, implementation, error logging and handling, testing, documentation, deployment, and user training/guides.

Work closely with team mates on requirements, daily needs, bugs and training via online conferencing

Work well in a multi-team atmosphere using Agile approach with SCRUM method/technology

Technologies used: pgAdmin4, Postgres 11/12, MongoDB, Apache Spark, AWS RDS, Elasticsearch, Python, PyCharm, SQL, LINUX/UNIX, ETL, Jira, GitHub

Application Developer

October 2018 - February 2020

California Association of Realtors - Los Angeles, CA

California Association of Realtors is a statewide trade association comprised of over 100 local real estate organizations throughout the state of California. The company was first formed by a group of 70 real estate agents in order to prevent misconduct throughout the industry on May 27, 1905. They played a major role in having the first real estate licensing laws in the United States in 1919. They develop and provide tools and applications necessary for real estate companies, brokerages, realtors and other members to conduct business in an ethical and efficient manner while providing property rights to the public utilizing a strict code of ethics.

Performed Database Administration for the internal IT department and Application Development Team to integrate with internal and forward-facing websites and ERP/CRM tools used within the company using Microsoft SQL Server and SQL.

Daily tasks: Architected and developed tables, views, queries, Stored SQL procedures, triggers, scripts, automated jobs, notifications and database backups/ recovery on MS SQL Server using SQL.

Architected and developed a new project using SQL that consolidated member data and dues owed to California Association of Realtors with the actual amount paid and variances for each member by Association by creating a new database, schema, tables, views, queries, Stored SQL procedures, triggers, scripts, automated jobs, notifications and database backups/ recovery on MS SQL Server using SQL.

Architected and implemented processes to prevent users from bypassing rules set in place by the company for user fees and dues payment to California Association of Realtors via SQL and MS SQL Server.

Enhanced productivity of CRM application by pruning the SQL Server database, using the CRM Bulk Deletion Tool, pruning CRM logging tables and executing a new database maintenance plan on a bi-weekly basis.

Mitigation of Single Point of Failure Database servers for Disaster Recovery, including set up and configuration of secondary SQL Server with back-up/restore failure logging, alerts and email notifications providing detailed error messages.

Upgrade SQL Server database environments from 2008 to 2017

Consolidated and migrated all Production SQL Server Instances from a VM/NetApp environment to an OVH Cloud environment.

Project Planning in place to create a Data Warehouse for multiple existing databases used for both internal and external use of data stores.

Developed and maintained SQL Server Maintenance Plans and tuning performed using scheduled jobs with SQL Server Agent.

ETL experience: Created SSIS packages to extract and load data from SQL Server and wrote and maintained procedures in T-SQL that performed the transformation needed for reporting and dashboard display of data. These packages and procedures are run on a nightly basis via SQL Server Agent.

Prepare and deliver presentations to large groups of people (customers/users) on a consistent basis.

Perform full software lifecycle: requirements gathering, requirements analysis, design, implementation, error logging and handling, testing, documentation, deployment, and user training/guides.

Provide technical support and troubleshoot issues for users.

Worked closely with upper management (VPs of Innovation and Technology, Staffing, Human Resources and Finance) on requirements, daily needs, bugs and training.

Worked well on a small team as a part of a multi-team atmosphere using Agile approach with SCRUM method/technology

Technologies used: SSAS, SSIS, SSRS, MS SQL Server 2008-2016, Visual Studio Business Intelligence Development Studio, Entity Framework, T-SQL, ETL, Sitecore, Microsoft Dynamics, Microsoft 2001 and 365 CRM, OVH server hosting, GitHub, Jira, NetApp, SnapManager, Slack#, SCRUM, MS Word, MS PowerPoint, MS Excel.

Senior Database Developer

March 2018 - October 2018

Internet Brands, Inc. - El Segundo, CA

Internet Brands, Inc. provides web solutions for businesses and media websites for consumers.

They originated in 1998 as carsdirect.com and have grown to serve over 100,000 business clients, hosting websites including, but not limited to: WebMD, Demand Force, Medscape, Honda, Lexus, Audi, Wikitravel, Wedding Bee, Apartment Ratings, Total Attorneys, All Law, Craftster, FitDay, DoItYourself and Satisfacts. Between the online media, e-commerce and community websites, Internet Brands receives over 250 million monthly website visitors.

Developed new and modified existing database structures and ETL jobs for reporting on various websites maintained through Internet Brands, Inc.

Technologies used: Pentaho 7.1, pgAdmin 4, SQLYog, SQL Server Management Studio 17.4, Oracle, Postgres, MySQL, PL/SQL UNIX, ETL.

Senior Programmer/Analyst

October 2014 - November 2017

General Dynamics (formerly CSRA, Inc. and CSC) - Huntsville, AL

CSRA, Inc specializes in providing IT professional services and solutions to the federal and state governments for agencies such as NASA, Homeland Security, Health, Civil and Defense. They have over 50 years of experience and over 19,000 employees. CSRA, Inc. was once part of Computer Sciences Corporation until November 27, 2015 when CSC split the government contracting section of the company into a separate entity. CSRA, Inc. was named a Military Friendly® Employer for 2018, a designation distinguishing companies that boast the strongest job opportunities, hiring practices, and retention programs for transitioning service members and spouses seeking civilian employment. CSRA is now known as General Dynamics.

Designed, developed and implemented websites for the Alabama Community College Systems on the Alabama Supercomputer Authority contract that were used for required state and federal reporting.

Developed tables, views, queries, procedures, triggers, scripts and database backups on both MySQL and MS SQL Server.

ETL experience: Created SSIS packages to extract and load data from MySQL to SQL Server and wrote and maintained procedures in T-SQL that performed the transformation needed before inserting the data from relational tables to data warehouse tables (dimensions and facts). These packages and procedures were run on a nightly basis via SQL Server Agent and through a command package written in C# that utilized system tables to determine the data dependency, in order to populate dimensions and facts in a multithread manner.

Developed a cube using SSAS that users could utilize for ad-hoc queries, reports and graphical representations of the data warehouse. Created a website in IIS that hosted the cube and developed a SOAP package that authenticated the users by accessing SQL Server Membership tables.

Developed and maintained ASP.NET pages/Web Forms for user dashboards (charts and graphs), data-viewers and reports.

Technologies used: Visual Studio 2012 (MS .NET - C#, ASP, DevExpress), SSAS, SSIS, MS SQL Server 2012, Entity Framework, MySQL Workbench, T-SQL, ETL, TFS, SCRUM, Management Internet Information Services (IIS), MDX, SOAP, MS Word, MS PowerPoint, MS Excel

Software Engineer

July 2006 - October 2014

SAIC/Dynetics Technical Services - Huntsville, AL

SAIC and Dynetics Technical Services are both companies that provide IT professional services and solutions to the federal and state governments for agencies such as NASA, Homeland Security, Health, Civil and Defense. These companies provided service for the NASA UNITeS/MITS contract. SAIC was the prime contractor when I began working on the UNITeS contract and Dynetics was awarded the contract when it was rebid in February 2010. The contract was renamed to MITS after Dynetics became the prime although the role and functionality of the contract remained exactly the same. The UNITeS/MICS contract served as the IT Service department for NASA headquarters in Huntsville, AL.

Designed, developed and implemented MICS (Management Information Control System), the web application that was used as the NASA contract reporting tool for UNITeS/MITS. This tool was used for budgeting, spend plan, employee task assignment and tracking, accounts payable, procurement, property and equipment tracking and the federal reporting required by NASA in order for the contract to receive funding.

Developed the user interface and reports using Oracle Forms/Reports, Toad for Oracle and PL/SQL on Oracle database.

Maintained and created forms, reports, database packages, procedures, functions, triggers, queries, views, and scripts.

Technologies used: Oracle Database/Forms/Reports, TOAD, SQL, PL/SQL, CVS (software version control), MS PowerPoint, MS Excel

Programmer Analyst

June 1999 - July 2006

Teledyne Brown Engineering - Huntsville, AL

Teledyne Brown Engineering provides innovative and proven systems engineering, advanced technology application, software development, and manufacturing solutions to space, military, environmental, and missile defense requirements for NASA, Army, Navy, and the Air Force. In 2015 TBE won the James S. Cogswell Outstanding Industrial Security Achievement Award from the Defense Security Service (DSS).

Designed, developed and implemented PDL (Payload Data Library), the application that is used at NASA’s International Space Station to record payload, flight and experiment data while scientists and commanders are on a mission.

Designed, developed and implemented (BFAST) Business and Financial Support Tool that was used to maintain, analyze, and report company financial data.

Developed the user interface and reports using Oracle Forms/Reports, Toad for Oracle and PL/SQL on Oracle database.

Maintained and created forms, reports, database packages, procedures, functions, triggers, queries, views, and scripts.

Technologies used: Oracle Database/Forms/Reports, TOAD, SQL, PL/SQL, CVS (software version control), MS PowerPoint, MS Excel

Programmer Analyst

December 1998 - June 1999

Computer Sciences Corporation - Huntsville, AL

Computer Sciences Corporation is a nationwide company that provides professional IT solutions, professionals and services to other companies. In September 2012, CSC was ranked 8th in Software Magazine’s Software 500 ranking of the world’s largest software and service providers.

Performed testing and bug fixes for an application used on Arnold Air Force Base in Tullahoma, TN.

Developed the user interface and reports using Oracle Forms/Reports, Toad for Oracle and PL/SQL on Oracle database.

Maintained and created forms, reports, database packages, procedures, functions, triggers, queries, views, and scripts.

Technologies used: Oracle Database/Forms/Reports, TOAD, SQL, PL/SQL, CVS (software version control), MS PowerPoint, MS Excel

Education

University of Alabama in Huntsville

Bachelor of Science in Business Administration in Management Information Systems

December 1998

Programming Skills

Microsoft SQL Server SSAS/SSIS/SSMS AWS

Team Foundation Server Data Warehousing/ ETL Apache Spark

T-SQL DevExpress Python/Pycharm

C#/VB/ASP.NET Agile/Scrum MongoDB

MySQL MySQL Workbench Postgres

Oracle Database PL/SQL pgAdmin

Oracle Forms/Reports Pentaho 7.1 Jira

SQLYog Microsoft CRM Slack#

MS Office MS Internet Information Services (IIS) Unix

Contact this candidate