Nancy Weber

- Aspired to encourage the Enterprise Applications team to collaborate, celebrate accomplishments, & continuously learn while working to maintain numerous enterprise systems & facilitate business processes essential to the college community.

- Reviewed/added complex SQL & PL/SQL logic within existing EnterpriseSCHEDULE jobs to improve business processes.

- Analyzed/documented database procedures & functions referenced within the Active Directory process toward the larger, ongoing effort of improving the User provisioning process.

- Partnered with College Departments through numerous requirements elicitation sessions to identify business & system requirements.

- Developed ARGOS datablocks per End-User specifications to replace existing Microsoft Access databases & facilitate important business processes.

- Developed ARGOS charts & visualizations to facilitate data analysis & increase business insights.

- Assisted End-Users with ARGOS extract development, encouraging a 'self-service' approach to data reviews & analysis.

Collaborated with a global marketing team to establish a central database for the industrial gases business, improving its data collection, maintenance, and analytics efforts.
- Facilitated extensive reviews of existing data collections and numerous workshops with team members to assess database requirements. Identified required data structures and data elements and documented findings in formal data dictionary.
- Established database utilizing Microsoft Access 2007. Developed database forms required for data entry, edits, and views. Created queries and data extracts necessary to data summarization and analysis.
- Merged relevant data from existing data sources to the database as requested. Established and facilitated data cleanse processes to improve data quality, incorporating required data adjustments via update, delete, and append queries.
- Enhanced database performance by transferring data and database queries from Access to Microsoft SQL Server 2008.
- Developed SQL queries and data extracts essential to the market assessment process. Established numerous SQL functions to automate complex calculations. Enhanced database output options as system requirements evolved.