Data Analyst / Programmer Resume
5.00/5 (Submit Your Rating)
SUMMARY
- An Analyst / Programmer with over 25 years of IT Industry experience including 20 years programming experience in various Industries.
- In depth knowledge and experience in all aspects of teh development life cycle from analysis and design to implementation.
- Solid foundation in various business applications. Proven experience in batch and online support. Highly motivated professional with a strong work ethic.
- Consistently produces deliverables on time and correctly.
TECHNICAL SKILLS
- Sybase SQL
- Informatica
- Natural Adabas
- Qlikview
- Perl
- UNIX
- Microsoft Word
- Collateral Management System
- Regulatory Reports
- Batch Processing
- Shipping Systems
- Excel
- Fluent in French
PROFESSIONAL EXPERIENCE
Confidential
Data Analyst / Programmer
Responsibilities:
- Extensive use of Sybase SQL for data extracts to create reports in a batch mode
- Responsible for extracting data related to Collateral Management and write to files, using Sybase SQL and data transfer.
- Batch processing and Realtime/online support functions.
- Create and maintain SQL code for ad hoc reporting both on Crystal Report and in - house reporting application.
- Extensive use of Sybase SQL to analyze data in order to trouble shoot and fix issues during batch processing.
- Identify report needs and create/improve daily/weekly/monthly reports accordingly, using Sybase SQL stored procedures and/or SQL queries.
- Maintain a smooth running of overnight batch processing using Autosys job scheduling.
- Perform batch and real time support duties, including on call responsibilities
- Trouble shooting issues both in batch processing and real time.
- Perform unit and regression testing on enhancements and fixes to system application.
- Oversee application deployments on a monthly basis
- Create and maintain Informatica graphs for data extract and loading into Sybase database.
- Extract data using Sybase SQL stored procedures/extract SQL and load into QlikView application
- Part of teh team for integration of Equities Collateral Management into teh Firm’s Global Collateral Systems.
- Maintain EUC reporting on MS Access. Convert same into Sybase SQL procedures and queries for batch/ad-hoc processing.
- Helped develop and maintain a robust Collateral Management system and reporting system.
- Involved in teh most recent regulatory UMR exercises, writing regulatory reports based on FA requests using Sybase SQL.
