Nicole West Email & Phone Number

Herndon, Virginia, Us

• Achieved Scaled Agile Framework (SAFe 5) Product Owner/Product Manager Certification (September 2022), AWS Cloud Practitioner Certification (October 2022), and AWS Solutions Architect Associate Certification (December 2022). Currently preparing to earn the AWS Data Analytics Specialty Certification in early 2023 and learning about Snowflake architecture.• Represent data-related concerns as the sole Chief Data Office (CDO) member on the Agile Program Management Council (PMC), a group that is leading the transformation to Scaled Agile Framework (SAFe) product development via a pilot project.• Collaborate with the Application Architect and other Data Architects to design structures and processes that adhere to accepted enterprise standards and practices, and that minimize resource contention and potential points of conflict or failure.• Provide guidance on performance tuning ETL processes by implementing AWS recommended practices for Redshift physical structures, periodic maintenance, and SQL development techniques.• Review existing data architectures and flows to identify and recommend potential improvements in resiliency, scalability, and data quality, particularly regarding integrations between Redshift and Tableau.

Austin, Texas, Us

• Collaborated frequently with the Vice President of Data and Insight, Data Product Manager, and Product Owner to review and refine the feature requests on our roadmap and prioritize tasks to fulfill those requirements alongside tech debt and production support.• Coordinated with the Business Intelligence (BI) Admin/Architect and BI Developers to implement new data structures and continuously improve existing data structures to meet the data quality, performance, and usability standards of the BI platform.• Led a remote agile team of data engineers and data warehouse developers to translate business requirements into a design that enhances our enterprise data model and enables the Business Intelligence and Data Science teams to glean valuable insight.• Designed and implemented a team code review process intended to set and regulate review standards and expectations, share siloed knowledge, ensure code quality, and minimize frequent distraction so developers can remain focused on their individual sprint commitments without blocking their teammates, resulting in more consistent successful sprints and more predictable velocity.• Organized and facilitated a monthly data-focused virtual gathering for our entire Data Team intended to celebrate our sprint accomplishments and provide a creative and safe space to socialize, build relationships, share knowledge, and demo new ideas.• Renovated a legacy publishing process that contained complex code to perform functions that have never been used in its 4-year existence and that required developers to update code in an additional code repository for each schema change, which introduced unnecessary risk, and required additional time and steps to complete the work.

Austin, Texas, Us

• Consulted the Architecture, Data Science, CloudOps, InfoSec, and IT teams and Data and Reporting Analysts from various departments on multiple simultaneous projects and provided advice on how to onboard new data into our ecosystem, create and comply with data contracts, minimize redundancy, and meet quality standards.• Implemented a system of accountability and data stewardship in the form of data contracts which represented the agreement between source data provider and the data reservoir, and provided a user reference and change notification mechanism to consumers.• Produced documentation and diagrams to visually guide teams through best practice recommendations and to provide implementation options including the costs and benefits of each.• Worked closely with the Data Product Manager to align on the enterprise strategy and feature priorities in order to organize and inject the most critical future project requirements into the Data Value Team's roadmap.• Paired with Data Engineers to incorporate the data contract process I created into our AWS Glue Catalog implementation where I created a json configuration document to mirror each approved data contract, allowing that data to be compressed into a gzip file, stored securely in S3, and made accessible via Athena for ad-hoc query and analysis the following day.

Austin, Texas, Us

• Translated business requirements for new and evolving feature requests into table and view designs optimized for data retrieval from both the business intelligence platform and ad-hoc queries from analysts.• Developed the SQL code to create/modify database structures in AWS Redshift, to load new data from AWS S3, and to perform the nightly ETL to update the data.• Advocated for a traditional Kimball style dimensional model in Redshift to best support our BI platform in MicroStrategy.• Led the data validation effort for institutions upgrading to our newest platform, ensuring minimal differences in critical business metrics and achieving sign-off from the CFO and leaders of the Analytics team including Business Intelligence and Research.• In effort to challenge myself and familiarize myself more quickly with AWS infrastructure and tools, I became the first member of my team to attempt and achieve an AWS certification.

Austin, Texas, Us

• Organized and lead a monthly hackathon-inspired meeting dubbed “BI Swarm” in which members of the business intelligence (BI) team propose issues in need of a creative solution and we choses one to tackle together in a short time frame, typically 1-2 hours; topics may include sharing critical knowledge and lessons learned, improving our team velocity, or elevating the client experience.• Implemented dashboard development life cycle process including distinct development, UAT, and production environments while serving as the interim MicroStrategy platform administrator.• Assisted our Microsoft SQL Server database administrator in the over-night upgrade from version 2008 R2 to 2014 and was subsequently recognized by the SysOps team for my contribution to the project and granted administrator (sa) privileges over the SQL Server instances that the BI team uses daily.

Austin, Texas, Us

• Automated existing data capture process within my first month of employment by implementing VBA code in an Excel worksheet that amalgamated data from multiple tabs and inserted it into SQL Server upon the click of a button, and obtained additional industry standard data from external sources that enabled benchmarking and peer comparison reporting.• Established myself as a consistent resource for helping troubleshoot and optimize existing T-SQL code and shared with teammates proven techniques to simplify and expedite our data retrieval and analytical processes.• Utilized SQL Server Management Studio (SSMS) as the primary tool for T-SQL development, developed reports and dashboards using MicroStrategy 9.3 and 9.4 Developer client and the Web version, and supported legacy reporting built in Microsoft Access and Excel.

San Antonio, Texas, Us

• Reported to the Director of Analytics and Business Intelligence and provided information ranging from performance metrics dashboards for the leadership team to individual order details for client managers.• Recognized after only two months with the company for automating various weekly and monthly reports and saving one particular client manager an estimated 20 hours per month.• Used PL/SQL Developer to query transactional data in Oracle 9, typically for ad-hoc analysis purposes and developed in SQL Server Reporting Services 2005 (SSRS) and deployed reports to Report Manager 2.0.

• Developed reports and dashboards for executive leadership using Crystal Reports XI and administered the BusinessObjects Enterprise XI server initially, and then transitioned to SQL Server Reporting Services (SSRS).• Organized and led the corporate data stewardship team and served as the lead technical data steward.• Partnered with a team of consultants in the development of a Microsoft-based BI platform, including the construction of an enterprise data warehouse using Microsoft SQL Server 2008 and SQL Server Integration Services (SSIS) as the ETL tool to integrate customer data from DB2 and geographical data from Oracle.

Armonk, New York, Ny, Us

• Provided technical assistance to a wide variety of clients utilizing multiple versions (from R5 to R7 Beta) of Lotus Notes and Domino as part of their business solution.• Following 7 week Boot Camp as an overview and introduction to the product, was assigned to the CASE team, in February 2004, which focuses on specific areas of the product such as calendaring and scheduling, server statistic and event monitoring, and server cluster and partition maintenance.• Scheduled for 20 hours per week of phone shift time for working new incident reports, in which I took live calls and responded to ESRs (Electronic Service Requests) via the Web within 2 hours of submission.• Researched and tested possible inadequacies in the product, and reported confirmed bugs to Development.• Maintained a personal customer satisfaction rate goal of 90% (94% prior to leaving).• Was active in IBM's Diversity and New Hire Networks as a volunteer during group events.

Armonk, New York, Ny, Us

• Worked closely with developers and project manager to document and ASCA certify internal data mart and data warehouse projects in order to prove the security and integrity of stored customer data.• Extensive flowcharting experience with Microsoft Visio and exposure to UNIX/LINUX, DB2, and SQL.

• Provided after-hours and weekend technical support for six branches, approximately 250 end users.• Worked in conjunction with the Network Administrator to learn basic networking functions using Novell NetWare 4.1 and Windows 2000 Server and assisted with system upgrades and installing new releases.• Responsible for periodic processing of important database information for management, and various other personnel.

Masters, Management Information Systems

Bba, Computer Information Systems

Associate Of Science Degree, Business Administration

Education record