Sr. Developer Resume
TECHNICAL SKILLS:
Languages: C/C++, JavaScript, CGI, JSP, HTML,UNIX/LINUX Shell Scripts (Sh, Csh, Ksh), Sed, Awk, Perl,Sybase T - , Open Client/Open Server, Oracle PL/SQL
Database Systems: Sybase systems 11, 12, and 15, Oracle 8i, 10g, and 11g (Exadata), Microsoft SQL Server 2000 and 2005
Operating Systems: HP/UNIX, SUN-OS, Linux, Windows 7
ETL: Informatica PowerCenter, SSIS
PROFESSIONAL EXPERIENCE:Sr. Developer
Confidential
Responsibilities:
- Developed complex custom reports in T-SQL and PL/SQL in an Confidential Environment for Portfolio and Risk Managers utilizing Sybase 12.5/15.0 and Oracle 11g databases (Stored Procedures, Views, and Triggers).
- Managed database schemas and data loading for batch processing and ad hoc reporting in both Sybase and Oracle.
- Participated in the conversion of database objects from Sybase 12.5 to Oracle 11g.
- Proficient in T-SQL, PL/SQL (Collections, Dynamic SQL, Analytic Functions, Bulk Loading), Query Optimization, Performance Tuning, ETL.
- Provided support to the Risk Management department.
Senior Programmer/Analyst
Confidential
Responsibilities:
- Developed and maintained Mutual Fund Portfolio Accounting data.
- Design and development of database tables, indexes, views, and Stored Procedures utilizing Sybase 12.5 databases (HP/UNIX Server).
- Development of ETL processes (Informatica Power Center) to subscribe data from upstream systems, populate a multi-server/multi-database Portfolio Accounting system and to publish data to downstream systems.
- Development of Web pages (Perl, CGI, HTML) to provide ad-hoc reports to the users.
- Development of tools to help with the migration of software to QA and Production environments.
- Primary support of nightly and monthly batch processes and the Portfolio Accounting department.
Senior Programmer/Analyst
Confidential
Responsibilities:
- Developed and maintained Mortgage Insurance software.
- Design and development of database tables, indexes, triggers, views, and Stored Procedures utilizing Sybase and SQL server 2000 databases (Sun/Solaris/Windows Servers).
- Tuning and optimization of Sybase Stored Procedures and development of 'C' programs and UNIX shell scripts to automate batch processing and to create reports (SQR).
- Development of Web pages (JSP, JDBC, HTML) to interface with the back-end systems.
- Primary support of nightly and monthly batch processes and the accounting department.
Consultant
Confidential
Responsibilities:
- Developed Software to monitor the trading activity of Equity and Currency Options.
- Design and development of programs to load Trading data into an Interbase Database Management/Solaris System (C/C++, Embedded SQL) from a Mainframe system.
- Design and development of programs to extract, transform, and populate database tables with data coming from a Microsoft Access front end.
- Development of various Web based reports in a Data Warehouse environment (CGI, HTML, Perl, C++).
Senior Software Engineer
Confidential
Responsibilities:
- Redesigned the batch systems and optimized the performance of reports, Stored Procedures and UNIX Shell scripts. Helped with upgrading Sybase from version 11.9 to 12.5. These changes resulted in 60% improvement in performance of the nightly batch processes.
- Design, development, enhancement and maintenance of an Equipment Leasing System on a SUN/UNIX operating system.
- Tuning and optimization of Sybase Stored Procedures and development of UNIX shell scripts and C/ESQL to automate batch processing and to create reports.
Senior Programmer/Analyst
Confidential
Responsibilities:
- Redesigned the Web based Electronic Timecard System so that it could be used by different types of browsers and re-wrote many of the modules in "C". These changes resulted in 50% improvement in performance. The software became the official Timecard System at Confidential .
- Design, development, enhancement and maintenance of CGI programs using UNIX shell scripts, "C", Java Scripts, HTML, Sybase Stored Procedures, and Sybase DBLIB for a company wide Web based Electronic Timecard System (HP9000/UNIX).
- Development and enhancement of Sybase Stored Procedures and UNIX shell scripts to automate Payroll Processing and to interface with an accounting package.
Programmer/Analyst
Confidential
Responsibilities:
- Interviewed employees, gathered requirements, designed and developed a fulfillment system from scratch using C/C++, Sybase, and PowerBuilder.
- Design and development of interfaces using "C", SYBASE Open Server, POWERBUILDER, and a commercial Software package to perform real time address verification and correction.
