Joseph Anesta Return to SAS Fifth Dimensions
Technical management analyst who manipulates and interprets data from a
variety of databases to help executive management make valuable decisions.
Guardian Life Insurance SAS/VBA Consultant 2/13/2006 to 4/30/2008
- My assignments included executing the
direct mailing system to thousands of clients to produce increases in
product awareness to achieve additional cross sales.
- Proficient in using HTML SAS
code to generate Excel spreadsheets and Lotus Notes Emails for
- Adept at uploading Unix Oracle
- Generate Visual Basic interfaces to select desired Oracle tables and
columns in a single SAS job.
Chase Manhattan Bank VBA
Consultant 4/15/2005 to 12/31/2005
Visual Basic support to update the web reporting system with SQL databases
- Dynamically creating pivot
tables with a VB macro has been instrumental in many applications.
- Strong over 10 years
experience of SAS and VBA macros.
Chase Manhattan Bank SAS/VBA
Consultant 8/5/2002 to 2/11/2005
- I created, automated and
documented the Customer Scorecard Collection and Reporting System and it
included a waterfalls report of monthly customer attrition.
- The MS-Word documentation
included VISIO flow charts to depict the products created.
- Created parameter driven code
to support a variety of applications with Oracle data.
- My VB macro to generate Pivot
Tables was disseminated for use among varied groups in the company.
SAS/VBA/Lotus Notes Consultant
6/2000 to 10/2001
- Revitalize a 24 month Axciom,
GNA, Triumph, and Legacy collection and reporting system.
- Significantly reduced the
computer resource utilization and improved turnaround time.
- Generated monthly spreadsheets
with pivot tables with numerous fields for analysis.
- Created Lotus Notes database
to accommodate users who are sharing tools, techniques, and file layouts.
- Developed Lotus Notes Agents
to list the activities of departments and users
Bank SAS/VBA Analyst 5/1999 to
- Developed an ad-hoc reporting
system for the bank's customer groups for the Risk Management Department.
Techniques to accommodate Oracle files with 50 million records assisted my
- My migration of mainframe
software to the P/C was successful and significantly reduced the mainframe
- I was responsible for ad-hoc
research reports on securities held at Citibank from the Security Header, Security
Database, Account Master, and the Address Master.
- To provide documentation and
to assist in formulating new 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. I created, installed,
demonstrated, and provided enhancements for this product on site.
U.C.L.A. B.S. - Computer Science 1976
SAS (Statistical Analysis System) Institute SAS Basic - 1979
Training Analytical Writing and Editing
Management for Technical Manager training seminar