We provide IT Staff Augmentation Services!

Senior Programmer Analyst Resume Profile

4.00/5 (Submit Your Rating)

New, YorK

Hands-on IT Professional with extensive experience in the full Software Development Life Cycle process and Mainframe programming languages/methodologies with proven success in project management and implementation as well as customer support and interaction. Highly motivated and detail-oriented problem solver. Excellent analytical ability, judgment, consultative and communication skills and the ability to work effectively with clients and IT management and staff. Knowledge of Sarbanes-Oxley SOX compliancy.

TECHNICAL SUMMARY

  • Hardware: IBM z Series
  • Software, Language and Tools:
  • Mainframe: COBOL, COBOL II, Enterprise COBOL for z/OS, MVS/ESA, MVS/JCL, DB2/SQL, VSAM, IDCAMS, CICS, VM, IMS DB/DC, IMS DL/I, TSO/ISPF-PDF, PANVALET, IBM Utilities, ENDEVOR, FileAid, Abend-aid, Xpediter, KORN Shell Scripting, SPUFI
  • PC: Microsoft Word, Excel, PowerPoint, Outlook, C, Knowledge of Oracle 10g and above, TOAD for Oracle, SQL, SQL Loader, UNIX scripts, Brio Query, UltraEdit-32
  • Databases: IMS, DB2 z/OS, Oracle, SQL server
  • Operating Systems: IBM z/OS, MS-DOS, Windows 7, XP, NT, 2000 , UNIX
  • Networking: TCP/IP, FTP, SFTP, PGP data encryption

PROFESSIONAL EXPERIENCE

Confidential

Senior Programmer Analyst, Data Warehouse

  • Successfully implemented Reservation and Rental Price Consistency project, one of Avis Budget Group's ABG projects that support strategic initiatives. Developed, tested and implemented impacted mainframe programs from the Data Warehouse legacy systems.
  • Tested all the Data Warehouse mainframe applications for all mainframe environment upgrades.
  • Represented the Data Warehouse mainframe environment for the 2013 and 2014 Disaster Recovery Exercises.
  • Modified 90 of mainframe programs impacted by project to remove credit cards from Data Warehouse. Established the new DB2 table to hold the credit cards. Populated and purged complex DB2 table. Made suggestions incorporated into the final solution.
  • Liaised with business side to gather information from the Warehouse and provide results for business requirements.
  • Trained new end-users in accessing Data Warehouse using Brio Query.
  • Generated reports for business requests including off-airport, mini-lease, preferred rentals, optional services, insurance and legal reporting.
  • Extracted, transformed and loaded legacy data into Data Warehouse and developed analytical SQL queries to generate reports using data in data warehouse and data marts.
  • Performed the process of loading data to Data Warehouse from external files through SQL Loader.
  • Managed IT projects including Improve Unlimited Budget Return on Investment - a new process to receive monthly files from a third party vendor and load the data into Data Warehouse database for reporting purposes and adhoc marketing initiatives and created appropriate technical documents i.e. Project Definition Document, System Specifications, System Test Plan and SOX compliance documents .

Confidential

  • Performed all facets of the software development life cycle including coding, testing and implementing applications software and systems.
  • Liaised with business community and the Development team to provide solutions to every business requirements.
  • Served as Technical Lead to implement several large 250K projects to support the strategic business initiatives.
  • Facilitated file transfer capability between ABG and third-party vendors by employing UNIX scripts to send and receive files electronically via File Transfer Protocol.
  • Designed, documented, tested and implemented branch initiative that eliminated the printing of all paper statements and invoices, saving the corporation more than 90K in postage and stationary costs.
  • Led project to automate currency conversion on Avis.com and Budget.com that allowed customers' immediate currency calculations.
  • Led efforts and implemented ABG Payment Card Industry PCI Compliance project to mask the credit card information to satisfy the security concerns regarding the credit card exposure.

Confidential

  • Created appropriate technical documents for assigned projects i.e. Project Definition Document, Project Solution Statement, System Specifications, and System Test Plan .
  • Assisted in research and evaluations of alternative solutions to recommend the most efficient and cost effective solution for systems/program design.
  • Performed and delegated system maintenance and handled production and operational problems.
  • Provided mentoring and cross training to programmers and new team members.
  • Analyzed, coded and contributed to the successful implementation of project to convert the native currency of participating European countries to Euros.

Confidential

  • Provided coding status to Technical Lead, including: technical milestones, test results, technical issues, and schedule concerns.
  • Programmed basic codes utilizing well defined specifications, devised standard system procedures and participated in systems testing process.
  • Tapped to be member of Y2K team to ensure all the Back Office Accounting systems were Y2K compliant.

We'd love your feedback!