SUMMARY

• 15 years of experience on mainframe systems using COBOL and DB2.
• 15 years of experience on Unix systems using OO languages and data warehousing tools.

TECHNICAL SKILLS

Languages: COBOL, PowerBuilder, Java, SQL, PL/SQL, PL/1, JCL, Easytrieve, Assembler, SAS, C++, AFP, Abinitio

Markup Technologies: XML, XSL, CSS, HTML

Platforms: MVS, Unix, Windows NT

Databases: DB2, Oracle, Sybase, IMS, CICS, VSAM, IDMS

Methodologies: SDLC, Agile, UML

Middleware: MQ Series

Development Tools: Rational Rose, JBuilder, JDeveloper, WSAD, Xpediter, File - Aid, Endevor

Security: RACF, ACF2

PROFESSIONAL EXPERIENCE

Senior Abinitio Developer

Confidential

Responsibilities:

• Analysed, designed, developed and implemented data warehousing solutions in Abinitio.
• Migrated and converted Abinitio graphs and Unix scripts from London to Winnipeg server.
• Worked in an agile development environment.

Senior Mainframe Developer

Confidential

Responsibilities:

• Provided mainframe development and support for PPSR (Personal Property Security Registration) System utilizing COBOL and IMS.
• Assisted business analyst with the creation of requirements documents.
• Demonstrated excellent verbal and written communication skills.
• Resolved issues in an accurate and timely manner.

Mainframe Performance Analyst

Confidential

Responsibilities:

• Responsible for performance enhancements related to MIPS reduction and scheduling in partnership with the application teams.
• Assessed various DB2 queries and created various REXX reports to recommend changes to the application teams.
• Used IBM Rational Asset Analyzer, Splunk and TWS scheduler.

Senior Mainframe Developer

Confidential

Responsibilities:

• Provided production support for the Rural Property Tax (RPT) and the Property Transfer Tax (PTT) Systems using COBOL, PL/1, DB2 and IMS.
• Completed design reviews and code reviews for other team members.
• Used HP workflow software to submit and receive review requests.

Senior Abinitio Developer

Confidential

Responsibilities:

• Analysed, designed, developed and implemented data warehousing solutions in Abinitio GDE under AIX.
• Demonstrated ability to deliver high quality results under tight deadlines.
• Demonstrated strong problem solving skills while managing multiple priorities.
• Worked in an agile development environment.

Senior Abinitio Developer

Confidential

Responsibilities:

• Analysed, designed, developed and implemented data warehousing solutions in Abinitio GDE and Oracle under AIX.
• Utilized EME for source control and metadata repository.
• Set graph input parameters with PDL and psets.
• Designed and developed Korn shell wrapper scripts for all graphs.
• Used ESP to schedule production processes.
• Worked in an agile development environment.

Senior Abinitio Developer

Confidential

Responsibilities:

• Analysed, designed, developed and implemented data warehousing solutions in Abinitio GDE and DB2 under AIX.
• Worked with BA to refine business requirements in an iterative development project.
• Utilized EME for source control and metadata repository.
• Experience gained reading XML data in Abinitio.
• Worked in an agile development environment.

Senior Software Developer

Confidential

Responsibilities:

• Used Abinitio GDE, MicroFocus COBOL and SAS to extract data from various mainframe systems (primarily MasterCard) to various Sybase and DB2 data warehouses running Unix (Solaris and AIX).
• Interacted with BA to gather business requirements and create detailed business requirements document.
• Analysed, designed, developed and implemented data warehousing solutions in Abinitio.
• Developed graphs with multiple subgraphs and over 100 components.
• Experience with the following Abinitio components: Reformat, Rollup, Join, Partition, Departition, Lookup Files, Normalize and Denormalize.
• Experience with the following Abinitio concepts: MFS files, EME and performance tuning.
• Utilized EME for source control and metadata repository.
• Set graph input parameters with PDL and psets.
• Involved in testing and production support of Abinitio upgrade project to co-operating system version 3.0.
• Contributed to design, code and deployment reviews on small development teams for high profile projects.
• Demonstrated ability to deliver high quality results under tight deadlines.
• Demonstrated strong problem solving skills while managing multiple priorities.
• Demonstrated excellent communication skills by translating technical information into business solutions.
• Used Autosys and JIL to schedule and monitor production jobs on Unix with complex interdependencies.
• Provided leadership to the web-site development committee.
• Provided business hours and on-call production support.
• Provided mainframe production support using COBOL, DB2 and JCL.
• Experience with Connect Direct (NDM) to transfer data from mainframe to Unix.
• A subject matter expert in COBOL.
• Used ACF2 to control access to mainframe datasets.
• A wealth of experience with relational databases and writing SQL statements.
• Worked in an agile development environment.

Senior Programmer/Analyst

Confidential

Responsibilities:

• Used COBOL, CICS and DB2 to enhance the General.
• Worked with business to define requirements and develop detailed design in a multi-tasking environment.

Intermediate Systems Developer

Confidential

Responsibilities:

• Used COBOL, IMS and DB2 to enhance the Operator Profile system.
• Documented business rules for existing CRT systems to prepare for their retirement.
• Developed customer extracts for BASEL data warehouse.
• Used MQ Series to create customer address notifications.

Programmer

Confidential

Responsibilities:

• Used PL/1-IMS and ASSEMBLER to modify and enhance the Flight Operations System (FMIS, ALPAC, HLW, FIDS).
• Familiar with tools such as BTS, INFO/SYS and PANVALET.
• Served as ADF co-ordinator.

Programmer

Confidential

Responsibilities:

• Used EASYTRIEVE, EASYTRIEVE PLUS and COBOL II in a VM/CMS environment to produce a variety of reports.
• Involved in coding, testing and debugging activities.
• Served as a contact person for user problems in a large multi-site computing facility.
• Involved in problem determination, analysis and resolution.
• Developed installation verification code in FOCUS.
• Operated computer graphics facilities.