Nicole M Welch Email & Phone Number

Spring Hill, Tn, Us

Albuquerque, New Mexico Area

San Francisco, Ca

Architect, engineer and administrator for all database tier operations of company products through complete life cycle: requirements, specs, development, deployment, maintenance and performance tuning. This environment runs on Microsoft Sql Server 2008 r2 and 2012.Define Best practices and standards as well as participate on the Architecture review and governance teams.Mentor and train technical team on usage and troubleshooting of databases. Define hardware sizing, disaster recovery and reliability recommendations for large customer systems.Key Achievements:Define a Service Oriented Architecture that will move Rodan + Fields from a legacy peer to peer monolithic and rigid environment to a highly agile environment, without affecting current SLAs. This middle out approach will eventually take Rodan + Fields into a complete cloud based environment, integrating CRM, Ecommerce and ERP systems with a Master Data Management serviceWide spread design and performance improvements across multiple legacy systems.

San Francisco, Ca

Architect and administrator for all database tier operations of company products through complete life cycle: requirements, specs, development, deployment, maintenance and performance tuning. This environment runs on Microsoft Sql Server 2008 r2 and 2005. Responsible for migration and synchronization strategies for all customer databases. Main resource for establishing system hardware and architecture requirements for large customer installations. Mentor and train technical team on usage and troubleshooting of databases. Define hardware sizing, disaster recovery and reliability recommendations for large customer systems.Key Achievements:Designed and Implemented an abstracted database model from the ground up, that is both agile and fast. This approach allows us to solve changing requirements to the database tier without affecting interfaces. Designed and implemented a polymorphic approach to building stored procedures that allows us to replace hundreds of stored procedures with just several. Designed and implemented a customer configurable data change management architecture that has full audit and notification control of all objects in the database.Nicole Welch

Architect for database and data warehouse design of company products (meter reading technology and analytical applications) through complete life cycle: requirements, specs, ETL development, deployment, maintenance and performance tuning of Olap solutions. Develop warehousing standards. Responsible for migration and synchronization strategies for all customer databases. Key resource for establishing system hardware and architecture requirements for large customer installations. Member of the Architecture Advisory Team.Mentor and train technical staff on troubleshooting SQL tools. Research and prepare reports; make recommendations for dealing with multi terabyte systems. Define hardware sizing, disaster recovery and reliability recommendations for large customer systems.Key Achievements:Created and implemented a new transaction based data loading process, that allowed 8000+ rows per second, an increase from 30 rows per second, resulting in the company entering the very large meter warehouse market. Received company award.Architected EE data tier allowing several applications to reuse the same schema for different purposes, saving deployment, development and maintenance time.Received Chairman's Award - Outstanding Achievement and performance bonuses.

Analyzed, designed and administered large VLDB systems and small data environments with SQL Server. Designed N-tier enterprise applications using Windows. Responsible for RDBMS conceptual, logical, physical modeling, normalization, capacity planning, installation, configuration, security, performance tuning, backup/recovery, advanced TSQL programming, partitioning strategies, clustering, stored procedures, replication and data migration.

Directed a 5-member team, provided technical coordination, reviews and mentoring. Created and implemented strategies and standards for all client /server, n-tier and intranet based applications. Conducted requirements analysis, design, construction, testing and installation of applications using Best of Breed solutions. Analyzed, designed and administered all data resources using SQL Server and Access. Provided complete database life cycle management and administration from RDBMS modeling, capacity planning, installation to data migration.

Researched and evaluated new technologies. Conducted requirements analysis, design, construction, testing and installation of applications using Best of Breed solutions, PowerBuilder, PFC framework libraries, Visual Basic. Used SQL Server and Access to analyze, design and administer all data resources. Performed complete database life cycle management and administration from RDBMS modeling to performance tuning and backup/recovery procedures.