Programmer Analyst Resume
New York, NY
Summary of Qualifications
Dynamic and dependable Senior Programmer Analyst with a broad base of experience concentrated in the Health Care, Insurance, and Financial Industries. Excellent communication and interpersonal skills with a reputation for forming productive business relationships at all levels. Strong understanding of business processes and requirements. Highly analytical and organized with a demonstrated ability to troubleshoot and resolve end user and system issues, identifying root causes to develop effective solutions and corrective actions. Maintains professionalism and productivity, even when handling multiple responsibilities in fast-paced environments with severe time constraints. In depth knowledge gained through a solid academic background, numerous training courses, and hands-on experience.
Programming and Computer Skills
Business Intelligence & Reporting Tools: Cognos Impromptu Administrators Series (Use of Catalogs), Cognos Impromptu Web Reports Server Administration Series, Business Object, Upfront, Crystal Enterprise, Crystal Reports, Business Objects
Data Warehouse Tools: Oracle SQL, Oracle PL/SQL
Database Management Relationship Systems: Oracle, Informix
Database Tools: Oracle PL/SQL Developer, Informix SQL
Programming Skills: SQL, PL/SQL, UNIX Shell Scripting, C, Informix ESQL/C,AWK, Korn Shell, HTML
Operating Systems: UNIX Operating Systems (HP-UX), Microsoft Windows 7
Source Control: ClearCase Source Control System, UNIX Source Control (SCCS), Makefile, RCS, Make, CVS
Document Tools: Document Library Science (DLS) - DDM Admit, DDM Batch, DDM Edit, DDM Migrate, xPression, CompuSet, DocMerge
Professional Experience
Confidential, Roslyn, New York Information Systems – Development Division Unit
Data Warehouse / Cognos Programmer Analyst 12/2003 - Present
- Work closely with business analyst, project managers and business personnel to quantify / clarify business
automation needs and requirements
- Perform requirements gathering and analysis where required
- Develop / maintain technical specification and documentation where required
- Maintain and develop data warehouse / data mart schemas in Oracle database environment
- Design, code, test data warehouse / data mart ETL programs utilizing Oracle PL/SQL
- Design, code test business intelligence applications / reports utilizing Cognos / Business Objects Crystal
- Design, code, test data feeds / interfaces to third party –external systems where required
- Design, code, test business applications utilizing various development language
- Develop reports for modules that include claims, policy, financial, risk using Cognos / Crystal Report tools.
- Maintain familiarity with new technology / technology standards and apply / integrate them effectively
- Interface with external vendors to address issues / enhance vendor supplied applications when necessary
- Perform moderate to advanced project management duties on technical projects when necessary
- Adhere to department / corporate policy and procedures pertaining to IT Operations
Programmer Analyst 12/2000 – 12/2003
- Consult with business users to identify business automations needs
- Perform requirements gathering and analysis and develop technical specification and documentations
- Designs, codes, test and debugs database application in Oracle DBMS/UNIX environment.
- Designs, codes, test and debugs reports utilizing Cognos Impromptu / Powerplay environement.
- Designs, codes, test and debugs reports utilizing Business Objects Crystal Reports
- Designs, codes, test and debugs database application in Informix DMBS/UNIX environement
Education
Master of Business Administration, Management Information Systems,
Bachelor of Science in Computer Science,
Additional Professional Training
Crystal Reports – Report Design I, II, III
Impromptu Report Building – Cognos
Impromptu Advanced Reporting – Cognos
Fundamentals of DLS
Advanced Topics of DLS
Developing SQL Queries for Oracle Database
Oracle Application Development & Tuning
Oracle PL/SQL Programming
Foundations of Property & Casulaty Insurance
Developing SQL Queries for Oracle Database
Document Library Science (DLS) & OASIS System
Risk Analysis Management System (RAMS)
RTF Claims Forms in OASIS System
Claims Inquire OASIS System
HEAT Help Desk System
Clear Case LT and the UCM Process
Language Skills
Fluent: English and Russian