Read I am a technical management consultant who analyzes and interprets data from a variety of databases to help executive manageme text version

Thomas Joseph Anesta

201 Old Post Dr., Hauppauge, New York 11788 (631) 360-4992 [email protected]

I am a technical management analyst who manipulates and interprets data from a variety of databases to help executive management make valuable decisions. My tenure in the Risk Management groups at American Express, Chase, and Citibank, and my expertise in SAS, VBA, JCL, and IBM Utilities, enabled me to revitalize a "24 month Axciom, GNA, Triumph, and Legacy" collection and reporting system. The revitalized version significantly reduced the computer resource utilization and improved turnaround time. This multiple MVS system process dynamically transported data to the required system. The Smart Trigger and Acquisitions requests required access to the summarized information to be manipulated individually using pivot tables. The resulting pivot tables of critical mailing campaign statistics were created by my VBA macros. My VBA macro to generate pivot tables from spreadsheets with numerous fields is a helpful tool. With a few clicks and drags the pivot table is generated. For the past few years, I have specialized in VBA programming, developing and designing SAS macros on mainframes, Unix, and personal computers (Windows/NT/98). My experience in the transference of data between these systems has been valuable in the design of reporting systems. I have years of modeling experience to answer "what if" questions. Modeling products are easily utilized when the correct data in the desired format is analyzed. I have developed techniques to generate SAS input statements from descriptions of record layouts (Cobol Copylibs and Spreadsheets). I use SAS, Visual Basic for applications, Access, Excel, and Word to create reports and visual presentations that clearly present my analysis. As a veteran programmer/analyst, I have developed expertise in several programming languages and applications. This enables me to learn new languages and applications rapidly. I am prepared to quickly implement the programming techniques that I have developed. I have also created Microsoft VBA macros to satisfy custom requests. For example, Visual Basic Excel macros were created and given to a customer to evaluate the customer's investment exposure to foreign countries. This interactive macro generated the desired report with a minimum of user technical expertise. Icons were generated at the opening of the workbook to start this procedure as requested by the customer. I created, installed, demonstrated, and provided enhancements for this product on site. Documentation of tools, techniques, and files is a necessary requirement to assist in formulating new requests and to make available past requests. At one installation every assignment was given a corresponding Word document containing vital information to describe the request. I designed a VBA macro using an Excel platform to read each word document, searching for and reporting on key components of existing requests. My reputation for detailed documentation in the finance industry is well respected. My successful experience on Wall Street encompasses several aspects of information management. I have validated assumptions for management to effectively develop the most advantageous plans of action. As Salomon's Capacity Planner, I gave a Capacity Planning presentation to the chairman, John Gutfreund. That presentation averted a multimillion dollar expenditure by formulating a strategy based on analysis with BEST/1 models and MICS data. As a group manager, I am able to promote a collegial atmosphere of goal-oriented endeavor. Groups under my direction form dynamically to undertake new tasks and projects. Mentoring relationships are formed reciprocally among the staff. My groups have earned a reputation for interpreting requests and producing the desired solutions. I trained staff and promoted top-down structured programming techniques to enhance the SAS programming environment. Experience American Express NY, NY 6/2000 to 10/2001 SAS/VBA/Lotus Notes Consultant Chase Manhattan Bank, NY, NY 5/1999 to 6/2000 SAS Consultant Citibank, NY, NY 7/1993-4/1999 SAS Consultant Shearson Lehman Brothers, NY, NY 1987-1992 Capacity Planner Salomon Brothers, Inc, NY, NY 1979-1987 Capacity/Performance Analyst, System Programmer Grumman Data Systems, Calverton, NY 1976-1979 System Programmer, Application Programmer Education U.C.L.A. B.S. - Computer Science 1976 SAS (Statistical Analysis System) Institute SAS Basic - 1979 Salomon Brothers Inc. Training Analytical Writing and Editing - 1983 Management for Technical Manager training seminar ­ 1988 124 Days of company enrichment courses

Thomas Joseph Anesta

201 Old Post Dr., Hauppauge, New York 11788 (631) 360-4992 [email protected] American Express 6/2000 to 10/2001

Primary focus of my position in the Risk Management group was to analyze large databases with SAS and develop VBA macros to enhance user interface. Reporting platforms included PC, MVS-TSO, MVS-Batch, and Unix. I reduced batch job turn-around time and computer resource consumption by improving the SAS code and interfacing SAS jobs with MVS utilities, Syncsort, SuperMatch, and Fileaid. A corporate decision to migrate SAS from the MVS mainframes to Unix proved to be effective. SAS in a UNIX platform can access and write to MVS mainframe data using FTP. My assignments included creating a user-friendly Lotus Notes database to accommodate users who are sharing tools, techniques, and file layouts. My VBS experience facilitated the development of Lotus Notes Agents to list the activities of departments and users. Responsibilities included organizing a multi-system data collection system to generate monthly spreadsheets with pivot tables for analysis. I used VBA macros to generate pivot tables from spreadsheets with numerous fields.

Chase Manhattan Bank 5/1999 to 6/1/2000

My responsibilities included ad-hoc reporting on the bank's customer groups for the Risk Management Department. I developed techniques to accommodate Sequel/Oracle files as large as 50 million records. I created SAS and VBA macros to efficiently use SAS on the personal computer.

Citibank 7/1993-4/1999

I was responsible for ad-hoc research reports on securities held at Citibank. I created over 1,500 SAS programs to generate these reports at Citibank. The Security Header, Security Database, Account Master, and the Address Master were a few of the databases that contained the security information. To assist in formulating new requests and to make available past requests, each report had a corresponding Word document containing vital information, which described the ad-hoc request. I used an Excel worksheet as a platform to expedite the search for key components of existing requests. Visual Basic Excel macros were created and given to a customer to evaluate the customer's investment exposure to foreign countries for Risk Management. To accommodate the user, an Icon became available just after opening the workbook that contained the macros. This icon would start the interactive macro and generate the desired report with a minimum of user technical expertise. I created, installed, demonstrated, and provided enhancements for this product on site.

Shearson Lehman Brothers 1987-1992

As the Manager of Capacity Planning at Shearson Lehman, I trained the capacity planning group and promoted top-down structure programming techniques to develop SAS modules. By utilizing my SAS source modules, my group was able to accelerate its programming abilities and rapidly produce reports. My analysis prevented excessive expenditure for proposed extended storage, and CICS applications were grouped by their resource consumption to improve efficiency.

Salomon Brothers 1979-1987

System support of the Prime computers on Salomon's trading floor was my initial assignment. During my first year there, I was moved to the systems group supporting the IBM mainframes. I programmed SMF exits in Assembler language and resolved system bottlenecks. In 1979, I started to analyze the SMF and RMF records that described the computer system's resource utilization with the SAS programming language. I developed in-house SAS code to extract the data from RMF and SMF until I installed MICS. To evaluate computer environments and quantify workloads to predict the adequate (but not excessive) hardware required to support applications, I installed and used Best/1 and Capture/MVS. As Salomon's Capacity Planner, I gave a Capacity Planning presentation to the chairman, John Gutfreund. As a result of that presentation, I averted a multi-million dollar expenditure by formulating a strategy based on analysis with BEST/1 and MICS, which utilized additional DASD rather than the proposed purchase of superfluous mainframe. This plan extended the life of the existing computer system for a year and smoothly accommodated a significant workload expansion.

Grumman Data Systems 1976-1979

After graduating from U.C.L.A, my first programming job was to generate graphic reports of F-14 flight test data using Fortran. Soon thereafter, my abilities enabled me to join the Systems group to work on the Control Data Operating System. Programming in Assembler language, I improved the performance of the operation system and supplied system support during flight tests. The U.C.L.A. Graduate course, 'Current Topics In Computer Science Programming Languages and Systems' was a study of topdown structured programming, modular programming, programming with abstract data types, and structured coding. These techniques have been useful in completing assignments.

Information

I am a technical management consultant who analyzes and interprets data from a variety of databases to help executive manageme

2 pages

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

1236829


You might also be interested in

BETA
I am a technical management consultant who analyzes and interprets data from a variety of databases to help executive manageme