Objective:

• Looking for a position where I can use my SAS, Python, and Banking knowledge and experience while leveraging my other technologies and skills to become a stand out key player; accomplishing much, attentioning to detail by following specifications and meeting timelines; documenting clearly and accurately; and willing to assist other team members to ensure they meet their goals and timelines.

SUMMARY

• Proven technical and analytical expertise; Strong leadership; Outstanding customer service; Commitment to excellence. More than twenty years’ experience writing thousands of new programs in many languages; managing hundreds of projects usually based around regulatory requirements; creating thousands of enhancements meeting regulatory demands or customer requirements; mentoring hundreds of IT professionals working as a team. Experienced in all facets of Software Development Life Cycle (SDLC), including requirements gathering, designing, coding, testing, and deployment. Solid understanding and experience in the Dodd - Frank act’s for Financial Reporting for both wholesale and Retail.
• Public real time reporting, swap data requirements such as primary economic terms, continuation and creation data. In-depth knowledge and experience in the risk management discipline designed for credit, market and liquidity risk for financial and banking institutions. Competent in all phases of portfolio investment, asset valuation and allocation. In-depth expertise and knowledge to analyze and efficiently integrate all real-time and historical information on stocks, bonds, and derivatives including but not limited to Covered Call Options, Long and Short Stock Options. Knowledgeable in Confidential, Confidential, American, and various International trading Markets with their various rules and inherent risk.

TECHNICAL SKILLS

Languages/Programming: SAS Data Integration Studio 4.2, 4.7, 4.9, SAS BASE, SAS MACROS, SAS SQL, SAS DDS Bank Model 3.2, SAS ACCESS, R programming, COBOL, Cobol II, CICS, DB2, Peoplesoft, Easytrieve, Visual FoxPro 5.0, PL/1, Assembler, OS/JCL, MVS/JCL, JES2/JES3, Business ObjectsPython, Focus Reports, Crystal Reports, Microfocus Cobol, Visual Basic, C, C++, PHP, Java, VB.NET, ASP.NET, VisionIP (Image Procesing), IBM CognosHTML, XML, XSL, SQL, VSAM, Dbase, CSP, PHP, CSS, JCP

Databases: Netezza, Teradata, DB2, IMS DB/DC, Oracle, MySql, Microsoft SQL Server, Microsoft Access, Foxpro, Visual Foxpro

Networking: LAN, WAN with TCP/IP, SFTP, FTP

Programming tools: Expeditor, File Aide, IBM Debug, Abend-Aid, Panvalet, Endeavor, Rexx/Clist, TSO/ISPF, CA7

Systems: IBM (Z/OS, OS/370, OS/390, 4331 DOS/VSE), UNIX, Microsoft Windows, IBM AS400, LINUX Servers both RedHat Fedora, and Ubuntu

PROFESSIONAL EXPERIENCE

Consultant

Confidential, Buffalo, New York

Responsibilities:

• Deposit Products and loans stored in dedicated computer systems. Besides U.S. demands, The European Banking Authority (EBA) is mandating the adoption of the revised Common Reporting (COREP) framework across all European entities. The reporting requirements are expanded monthly as The United States is still trying to determine what all to include in Dodd Frank congressional legislation that the banks also have to adhere. Once new requirements come, Analysis of where we at Confidential store the information and what COBOL programs need be updated or written to pull the data; what SAS programs have to be updated to calculate the new calculations; what Easytrieve programs need updating to manipulate the data; and where to store the new or updated data on our Retail DB2 tables; and lastly how best to add and transmit our Retail data to Confidential ’s Confidential reporting group so they can produce the reports needed for the month end reporting. With my financial background in Investments, good sound Analysis work and quality programming efforts has led to reporting exactly what is required on time. Built programs and jobs that run daily, monthly, and quarterly giving upper management real time data and thus knowledge of the financial situation of the bank. To build front end online screens for users I am writing new Python Code going to the mainframe getting data and returning that data via newly written Python Code.

Confidential, Mobile, AL

Responsibilities:

• While working at Protective life, I Taught and/or tutored these courses: Python Programming, Intro to Personal Computers; Intro to Computer Programming; Web development using JAVA, PHP, and HTML, Database Development using MySQL, MS ACCESS,SQL Server; Network Standards and Protocols; Linux Operating System (installation, server configurations, and commands); Linux System Administration. Was head of ITT’s Computer Club where we worked extensively on Robotics and we conducted live presentations? Wrote some programs for the local ITT Technical College in Python and SAS to keep track of students’ progress.

Financial Consultant / Analyst

Confidential, Mobile, AL

Responsibilities:

• Programmer Analyst. Used SAS/BASE, SAS/SQL, SAS/ACCESS, SAS REPORT to fetch data, manipulate data, and transfer data between mainframe and Windows NT with SQL Server as well as Linux servers often times converting files to XML to go back and forth between platforms. Used SAS DI Studio as platform to develop Macros and Programs. Main responsibilities were producing SAS reports with extensive calculations by using the various SAS products and platforms. In addition to SAS, Python was used extensively as well especially for its ability to handle multi-dimensional arrays.

Business Analyst - Consultant

Confidential, Mobile, AL

Responsibilities:

• Creating waterfall reports and analyzing data and creating ad-hoc's on deliverables. Extracted data from different sources like Oracle, DB2 and text files using SAS/Access, SAS SQL procedures and created SAS datasets. Automated the existing audit reviews and production. Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio. Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal. Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join. Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text. Created dynamic Macro arrays by SQL and with data step programs. Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting. Created reports using Proc Report, Proc Tabulate, ODS statements and Proc Template to generate output formats in HTML Excel and RTF. Documented the code and algorithms logically. Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Senior Programmer Analyst

Confidential, Birmingham, AL

Responsibilities:

• SAS Technical Lead / Cobol Programmer in the online group doing image processing among other applications. Successfully managed testing phase through implementation of the Y2K ATM/VISA Project. Also, from concept to implementation, led and architected Disaster Recovery Project; core member of mock disaster group that simulated and overcame disastrous scenarios. Analyzed scope, captured business requirements (retail and corporate banking), recommended process changes and documented the requirements for the development team.Estimated effort for the projects (and change requests) using function point analysis.
• Functionally tested the developed systems (UAT) and deployed them in the production environment. Supervised fallback drills for various software applications as a part of the business continuity exercise. Recommended process changes and documented the same so as to align them in accordance with SOX requirements. Managed multiple projects varying complexity ensuring timely completion. These projects realized significant savings in terms of time and money. Developed workflow based applications as per corporate banking business needs. Organized a vendor evaluation exercise (preparing questionnaire, collating responses and analysis of the same) to rate the vendor performance.

DB2 Database Admin

Confidential, Birmingham, AL

Responsibilities:

• Contracted with EBSCO to manage their Data Conversion Project, moving corporate-wide billing system from an IMS platform to one using db2 tables. With extensive performance testing, I determined the new system could not accommodate the size of the database. Recommended switching to Oracle saving the company millions and the project; Enhanced hundreds of programs written in Cobol or SAS for Y2K. Documented and diagrammed the design of solution interfaces, implementations, and dependencies. Provided detailed task definitions and time estimates for project deliverables. Created unit tests to ensure functional integrity of solutions. Troubleshoot application issues down to the network protocol level.
• Collaborated with development team members to create a consistent approach across feature implementations. Started the practice of code reviews to play an active role in ensuring best practices are enforced in all team development work. Communicated effectively with all Business groups meeting or exceeding their requirements and needs.

Senior Programmer Analyst

Confidential, Raleigh, NC

Responsibilities:

• Wrote numerous ad hoc SAS and FOCUS reports for staff scientist. Some of the payroll system was in COBOL and the other part was in PeopleSoft. Also used FoxPro. SAS Programmer for reporting 5 clinical studies (tables, listings and figures as well as adhoc requests from Clinicians, FDA, etc.) to requested specifications; development of a program that generates Patient Narratives cutting time for writing of Narrative
• Solution of adding text for PDF bookmarks in ODS RTF generated tables, listings and figures so output can go directly into MDoc; and an application to generate Dynamic Listings of the data for review (has the facility for the reviewer to subset the listings at the patient level - this uses SAS to generate the Excel application and workbook with VBA macros, and the reviewers use this Excel workbook to review the data replaced paper By Patient Listings).

Programmer Analyst

Confidential, Birmingham, AL

Responsibilities:

• working in the mainframe Billing System written mostly in COBOL with IMS databases. Heavily involved with testing new releases and handling trouble tickets. Made numerous enhancements to Cobol/IMS programs. Maintained the frontend jobs to the Billing System whose main function was to edit all the service orders so that no bad data was loaded to the databases. Capable of explaining complicated telecommunications concepts to non-technical professionals. Performs well in fast paced, high pressure environments. Expertise in the development and implementation of voice and data equipment.
• Experienced in the design, configuration and maintenance of numerous telecom systems, hardware and software applications. Capable of providing high levels of technical and telecommunications engineering support. Excellent communicator that collaborates with team members and consults with third party vendors to achieve goals. Proven ability to analyze existing systems and schedule upgrades to increase performance and productivity. Strong understanding of switching systems, mail, cabling, and PBX. Created supporting documentation for systems and software usage and control. Integrated cell phone data support into current systems, enabling company to monitor and document usage. Analyzed and resolved telecommunications billing issues. Wrote numerous Adhoc SAS reports for upper management.

Assistant Director

Confidential, Birmingham, AL

Responsibilities:

• A Director with extensive operational leadership experience in nonprofit and corporate environments seeking a new opportunities. Well-developed skills overseeing operations, managing budgets, leading fundraising and community outreach efforts, managing staffs, executing large-scale events, and serving on a Board of Directors.
• Proven track record of success increasing revenue through community outreach and fundraising efforts (grants, corporate sponsorships, donations, and events) Installed and modified a FoxPro customer database and reporting system; Designed and implemented training classes to train the staff on the system; Entered data for more than 10,000 members; Coached swim team; Hired the lifeguards, swim instructors, and other staff.

Junior Programmer Analyst

Confidential, Birmingham, AL

Responsibilities:

• Hired in as a beginning level programmer; But, quickly was recognized for strengths and was moved into the hard core programming team. Also, my strength of testing and verifying every field by comparing before and after results often times using my calculator to see if results matched. It was apparent that the users liked working with me so often used to gather user requirements and pass on to senior programmers the assignments to only come back to me for testing and implementing into production.