Designed and developed reporting tools to help identify performance indicators and support business needs with high-quality data integrity; Collaborated with business partners to identify opportunities to enhance and improve the current reporting structure; Reviewed and analyzed data to determine the best delivery method to promote continuous improvement with data-driven results; Lead management meetings detailing team performance.

Provide technical systems support to Wells Fargo Financial Crimes Technology; Consult with business partners to define business requirements and translate them into technical designs; Compile data from multiple data sources to use within reporting; Using various BI tools including Tableau to create project reporting and visualizations; Manage team projects including conducting project meetings and maintaining projects documents and timelines; Participate in QA testing for new application releases; Provide support to business users on the project application which can include researching data issues, troubleshooting system performance or granting system access; Gather data for reporting and analytics using tools such as Teradata SQL and SAS from numerous data sources. Create custom dashboards and visualizations with Tableau.

Perform ad hoc database queries from various data sources to assist research and analytical projects; create datasets in SAS and Excel to perform analytical tasks such as pivot tables and vlookups; conduct monthly Front Line Unit customer risk assessment review meetings; conduct user acceptance testing including writing and executing test scripts; supported multiple lines of business including creating custom reports using Crystal Reports, Cognos, MicroStrategy, Microsoft Access and SAS; created SQL Server stored procedures; acted as Associate Learning Portal Custom Reporting Tool reporting lead for GCSBB.

Provide technical systems support to Wells Fargo Securities which includes providing users access to systems including interfacing with front-office users; troubleshooting business issues within the trade system data warehouse and reporting systems; document system processes for all support team members to utilize; monitor system processes using sql scripts and ITRS; create, review and process sql scripts for trade system updates; utilize PAC200 to create work orders, change requests and problem tickets.

Provide technical systems support to Wells Fargo Securities which includes providing users access to systems; researching data issues with the trade systems; document system processes for all support team members to utilize; monitor system processes using sql scripts and ITRS; receive and process sql scripts for trade system updates; utilize PAC200 to create work orders, change requests and problem tickets.

Facilitate as well as participate in requirements review sessions with business and/or technical teams; develop business, functional and/or technical requirement specifications; provide support of end user issues, identifying, researching, and analyzing the issues in order to develop solutions; perform analysis during the defect lifecycle and perform root cause analysis of issues; write the requirements for the development team to correct issues; drive and assist with data analysis; perform research of key operational data to enable efficiencies and ensure overall data quality.

Support multiple lines of business, which includes/included creating custom reports using Crystal Reports, Cognos, MicroStrategy, Microsoft Access and SAS; perform ad hoc database queries from various data sources to assist Green Belt, Black Belt and analytical projects; creating SQL Server stored procedures; creating Questionmark assessment surveys, supporting web development efforts, using Microsoft Excel to extract data to create pivot tables, creating/supporting Microsoft Access database to send email notices to associates concerning training; acting as Associate Learning Portal Custom Reporting Tool reporting lead for GCSBB.• Designed data load scripts that reduced load time by 50%• Received 29 Spirit Celebration Cards for improving customer/client experience

Provided Sybase Adaptive Server Anywhere Database Administration support which included ensuring database currency and integrity by implementing Model Change Requests, monitoring the impact on the overall system, troubleshooting database errors, overseeing database version updates and providing database field user support. Developed stored procedures, functions, and triggers to aid in software development and database administration. Generated and maintained the system’s conceptual and physical data model using PowerDesigner. Provide application support to the user community via telephone, e-mail and person-to-person visits. Designed and developed Lotus Notes Configuration Management database.• Redesigned stored procedures to maximize database performance• Effectively provided troubleshooting support to system users world-wide

Provided Oracle Database Administration support in multi-database environment, which included creation of database objects, monitoring alert logs, monitoring RMAN backups and troubleshooting database errors. • Successfully installed and monitored Oracle standby database• Successfully installed Oracle Enterprise Manager 2.2.0• Successfully upgraded numerous Oracle 8.1.6 databases

Provided Sybase Adaptive Server Anywhere Database Administration support which included ensuring database currency and integrity by implementing Model Change Requests, monitoring the impact on the overall system, troubleshooting database errors, overseeing database version updates and providing database field user support. Developed stored procedures, functions, and triggers to aid in software development and database administration. Generated and maintained the system’s conceptual and physical data model using PowerDesigner. Provide application support to the user community via telephone, e-mail and person-to-person visits. Designed and developed Lotus Notes Configuration Management database.• Redesigned stored procedures to maximize database performance• Effectively provided troubleshooting support to system users world-wide

Information EngineerDeveloped process/program logic diagrams in order to facilitate the critical design process and GUI windows, which included window layout, window flows, and business process diagramming. Performed requirements analysis to derive Segment Design Specifications and requirement mapping from the design specification to the Requirements Verification Traceability Matrix. Conducted business reviews with users for concurrence and sign-off. Completed Unit Test Plans, which included test definitions and procedures.Software EngineerDesigned and developed several client budgeting applications using Microsoft Access including designing customized toolbars and implementing security. Developed detailed and complex budget reports using Crystal Reports and Microsoft Access for submission to Congressional Budgeting Committee. Maintained client resource database and reports including the import and export of data. Participated in the functional systems analysis, decomposition, and design to include user modeling and information flow. Developed user documentation, including user manuals, quick look-up guide, and training manuals.•Implemented new ways to import budget data from flat files into database format.•Effectively supported and trained users to ensure successful submission of budget reports.Oracle Express Server Database AdminMaintained user accounts, handled database structure additions and changes, and performed necessary system maintenance. Developed user reports using Oracle Financial Analyzer. Created a Lotus Notes database to provide an on-line user training registration.•Effectively developed 400+ user reports.•Received team award for exceptional work.Database DeveloperDesigned and developed a data gathering and storage application using Oracle 8i database Oracle Forms. Wrote SQL scripts in order to facilitate data import from legacy systems. Wrote user documentation, devised training plan and trained users on the application.

Provided help desk support for hardware and software including answering trouble calls and computer maintenance. Provided Lotus Notes Database Administrator support responsible for establishing and transferring mail accounts, maintaining office servers, and upgrading software and databases. Provided Lotus Notes development and maintenance support for office databases including creating and redesigning forms and views. Provided user training with desktop applications such as Microsoft Office Suite of Products, Lotus Notes and internal office applications. Redesigned and maintained a Microsoft Access database used for data input and retrieval. Designed and developed a REXX program to interface with a Microsoft SQL Server Database for data input and retrieval. Designed and maintained a Lotus Notes database repository for office policies and procedures.• Effectively provided customer support including troubleshoot and user training• Received 2 Exceptional Performance Awards.