Associate Programmer/programmer/lead Programmer Analyst/senior Programmer Analyst/ Senior Software Developer Resume
4.00/5 (Submit Your Rating)
Seattle, WA
SUMMARY:
- Senior Software Developer with over 10 years’ experience incorporating user and business requirements into cost - effective business application software.
- Insurance industry experience with Property and Casualty Insurance, and Reinsurance.
- Innovator of creative solutions, systems and applications producing outstanding results for internal technology users.
- Collaborate with others in support of production issues, and coding questions.
- Experience working with relational database design concepts, ER diagrams and complex SQL.
- Create solutions across multiple platforms and databases.
- 10+ years in Software Development. Analyzed end-user and usability requirements in support of 21 different business applications. Analyst/ Developer/Tester, provided on-call support of daily edits, monthly Profit and Loss reporting for senior management and utility programs.
- Collaborated in the initial design, architecture, testing and product launch of a client/server, multitier application for Reinsurance using VB, DB2, and COBOL with embedded SQL. Maintained ER diagrams.
- Created multiple extracts using Informatica from Teradata, SQL Server, MQ Series, and TXT files and loaded DB2, Teradata and SQL Server databases for Financial, Claims, and Telephony datamarts in a Unix environment.
- Redesigned and reduced maintenance by 80% of a monthly Reinsurance reporting database in MS Access.
- Worked with internal technology users to develop and maintain a Weekly Premium/Loss reporting cube in Essbase.
- Implemented business user email notification of application status for a critical monthly reporting tool enabling users to start their work up to 6 hours sooner.
- Reconfigured multiple mainframe systems to improve run time by +65% and enabled data to be available 24 - 48 hours sooner for the internal technology users.
- Scripted batch processing for 18 Essbase jobs into mainframe ESP scheduling and configured cross data center scheduling.
- Resolved 50+ financial balancing issues while in a fast paced, complex environment for a SOX compliant company.
- Trained and mentored junior programmers in programming methodologies and best practices.
TECHNOLOGY SUMMARY:
- COBOL
- JCL
- JCLPrep
- Xpeditor
- Endevor
- Syncsort
- TSO/ISPF
- SDSF
- FTP
- SQL
- Teradata
- Access
- DB2 for z/OS
- SQL Server
- VB6
- Informatica
- Essbase
- IMS
- Excel
- VBA
PROFESSIONAL EXPERIENCE:
Confidential, Seattle, WA
Associate Programmer/Programmer/Lead Programmer Analyst/Senior Programmer Analyst/ Senior Software Developer
Responsibilities:- Developed, maintained and supported 21 business application software utilizing the Data Warehouse for Statutory and senior management reporting using COBOL and associated mainframe software, SQL, DB2 for z/OS, Access, and Essbase in an Agile environment.
- Developed and supported an Access business application for the Tax Department.
- Developed, maintained and supported business application software for Reinsurance using VB6, DB2 for z/OS, and Access.
- Developed ETL mappings using Informatica to load Teradata marts in support of claims and financial reporting.
- Developed Excel Macros in VBA to facilitate the importing and formatting of mainframe data for reporting analysis in MS Excel.
- Developed and maintained ER diagrams for Reinsurance Workstation.
- Collaborated with Project Managers, Developers, Business Analysts and Quality Assurance Analysts.
- Analyzed code for system testing. Created test transactions to debug, isolate and rectify issues.
- Established strong working relationships with internal business users.
- Participated in code reviews.
