Greg Hawkins Email & Phone Number

Saint Paul, Mn, Us

Eden Prairie, Minnesota, United States

Provide support for analysts as the company's SAS Administrator.Assist with the maintenance and upgrades of various systems and platforms.

• Guided offshore resources through development and implementation of business reporting and analysis while using multiple data sources, complex data structures, and different reporting tools, primarily SAS and SQL. • Identified, cataloged, and implemented numerous jobs for automation.• Implemented "transaction-based model" to reduce cost on the delivery of numerous, standard reports.• Analyzed processes and programs for opportunities to simplify and automate.

Supervised delivery and presentation of financial data using many different reporting mechanisms. Championed effort to transition users to new UNIX environment.• Managed onshore and offshore resources through collection and distribution of “minimum metrics” data for 15 credit card and 28 retail portfolios resulting in consolidation of most pertinent data into a single location with a manageable format.• Identified numerous efficiencies in programs that were slated for automation. Supervised addition of those changes before jobs were scheduled, allowing for over $30,000 in annualized savings.• Renegotiated the delivery of several other automated reports, which further reduced the annual CPU costs by 83%.• Coordinated and delivered live video training for 80 new UNIX users in the United States and abroad. Led effort to record 8 progressive lessons and post centrally for new users to review on their own schedules.

Supervised production of Profit and Loss reports (P&Ls) for the Office of the Comptroller of Currency. • Facilitated standardization of SAS, Access, and Excel pieces of P&Ls, which included transforming a very complicated process into a simple, parameter-driven routine that allowed analysts throughout company to quadruple their output while at same time virtually eliminating incidence of errors.• Led effort to automate many of other reporting processes including Daily Credit Line Activity, Weekly Adverse Action, and Monthly Utilization reporting, which enabled analysts to prioritize analytical responsibilities.• Published weekly “technical” tips to promote knowledge sharing, receiving numerous accolades from employees, peers, and executives.

Supervised a team through the processing of numerous customer selects while keeping to very aggressive deadlines.• Introduced group to the SAS "%include" statement, which standardized code across many clients, reduced select processing time by 40%, and allowed team to migrate 100% of list processing in house.

Used SAS on UNIX and COBOL on the mainframe for extraction and verification of data for Allina's hospital data warehouse.• Converted numerous automatically generated SAS jobs to Impromptu, allowing users to submit jobs on demand and reducing fixed processing time for remaining SAS jobs.