AGATHA COLANGELO
* **. ******** **** **********, ON L4H 3E4
905-***-**** ******.*********@*****.***
IT ARCHITECT / ADMINISTRATOR & TECHNICAL WRITER
Dynamic software development (SDLC) and systems / database professional with 20+ years of experience and a history of improving software / systems functionality and quality for IBM as well as key consulting clients. Strategic thinker with record of spearheading key technical writing and design initiatives in support of releases (including DB2). Demonstrated expertise in project management, training, courseware development, cost control, and process improvements. Proactive, diligent team leader with a unique blend of managerial, technical, design, marketing, and relationship-building expertise. Fluent in Italian.
AREAS OF EXPERTISE
IT Architecture Software Development (SDLC) Technical Writing Data Modeling
Database Administration Project Management Strategic Planning Cost Control
Information Development Quality Assurance Team Leadership Courseware Development
Training Release Management Process Improvements Documentation
Use Case Specialist Technical Support Web Design
PROFESSIONAL EXPERIENCE
ION DESIGNS, INC., Woodbridge, Ontario 2009 to present
Software design consultancy.
Software Designer
Orchestrating all work phases: joint application design (JAD) sessions, data modeling, detailed design and technical documentation, and quality assurance activities.
Major Contributions: Honored as an IBM Champion in 2010 & 2011. Spearheaded 25 successful senior executive JAD sessions.Facilitated successful system implementation by designing software system based on JAD sessions.
Selected Engagements: INNOVAPOST / CANADA POST
Use Case Analyst / Business Analyst (September 2010 to present): Playing a key role in two releases of the development of an electronic mailbox web application for use throughout Canada. Creating use case scenarios for JAD sessions, developing detailed design documentation, overseeing business analyst team of 4, writing technical documentation, coordinating French translations, and contributing to quality assurance activities. Also supporting development teams and assisting with PM work.
Data Modeler / Project Manager (May-August 2010): Performed all phases of data modeling development in conjunction with Treasury and Risk Management team. Enhanced productivity by single-sourcing data definitions and using VB macros to expedite updating of ERwin models. Managed all phases of a key economic capital project comprised of multiple data warehouses.
Information Architect (January to May 2010): Collaborated with reporting data mart project team in the development of application architecture and logical data models for Risk Management Assessment, including implementation of physical databases using DB2, ORACLE and SQL Server.
AGATHA COLANGELO Page 2 ******.*********@*****.***
IBM TORONTO SOFTWARE LAB
Toronto, Ontario 1988 to 2010
Software development / maintenance solutions unit (2,500+ employees) of global technology leader; lab generates code bases for released products and produces solution fixes.
DB2 on Campus Community President, Woodbridge – Volunteer Position (2009 to 2010)
Editor-in-Chief of the DB2 on Campus newsletter after establishing the publication. Directed the global DB2 Student Ambassador Program. Cultivated productive relationships with university students and professors worldwide; devised / deployed plans to maximize participation and benefits from involvement.
Major Contributions: Provided program-related future opportunities for students by maintaining interest levels.Founded the DB2 on Campus Quarterly Newsletter.
Staff Software Developer (1988 to 2009)
Added value to software / SDLC projects as needed. Performed technical writing and managed as many as 24 team members in drafting technical written materials and assisting customers (online) to support product releases (most recently). Generated key elements of software designs; facilitated development team’s coding by producing detailed low-level program designs and pseudo-code.
Major Contributions: Achieved outstanding record of meeting or surpassing quality, schedule, and cost targets while leveraging SDLC expertise to optimize products and increase team cohesion.Drafted several release manuals (including issue resolution and solution maintenance): Data Servers, Databases, and Database Objects Guide; DB2 Command Reference; DB2 Administrative API Reference; and Common Criteria Certification Manuals (Installation & Administration Guides).Facilitated enhancements of user proficiency / solution functionality for DB2 LUW Database Storage and Physical Database Design and Information Modeling by co-creating best practices white papers.Produced software for DataHub Support/2 product and wrote the IBM SystemView Information Warehouse DataHub Support/2 Installation Guide; optimized DB2 & SQL/DS products by generating supporting software.Led online help operations (and teams of 12-24 writers) during a pair of DB2 releases.Developed Visual Explain Tutorial and an Autonomic Computing e-Book (with Flash demos).Increased productivity / efficiency by suggesting multiple process improvements / tools.Earned IBM Patent Invention Achievement Award (in collaboration with colleagues) for Browser Independent PopUp Windows.Redesigned the DB2 on Campus website. Improved the market profile of DB2 Express-C in the global university segment by spearheading a promotional initiative, including a tour of universities in Italy.
Software Development Technical Writer / Special Projects (2006 to 2009)
Created product release manuals and co-wrote best practices papers. Led content conversion initiatives (SGML to DITA and book to topic format). Managed documentation process improvement group (6-8 team members). Developed sales / marketing collateral for DB2 Connect solution. Contributed to the English to Italian translation of the Getting Started with DB2 Express-C book and accompanying videos.
DB2 Product Release Developer / Technical Writer (2001 to 2005)
Oversaw online help operations for a pair of DB2 releases (supervised up to 24 colleagues). Advised on potential process enhancements. Wrote (individually or with teams) key manuals, online help, and tutorials for DB2. In collaboration with other colleagues, invented a patented browser-independent popup solution.
continued...
AGATHA COLANGELO Page 3 ******.*********@*****.***
Staff Software Developer, continued
DB2 Technical Writer (1997 to 2000)
Produced outstanding technical writing for DB2. Expedited seamless user product implementations while serving on DB2 Installation Guides unit covering numerous platforms (Windows 95 / NT, UNIX, Sun Solaris, HP-UX, etc.). Resolved user issues / release deficiencies as member of the DB2 GUI online technical help group.
Software Designer / Developer, Tester, and Technical Writer (1988 to 1997)
Devised and deployed software to bolster effectiveness / support for key products. Generated and executed REXX / SQL test scripts and cases. Developed code for the Distributed Computing Environment (DCE) operating system.
ADDITIONAL EXPERIENCE
UNIVERSITY OF TORONTO, Toronto, Ontario 2009 to present, 1998 to 2001
eLearning Software Designer and Developer, Italian Department (Stipend and Voluntary Affiliation)
Designing and developing interactive software for intermediate and advanced translation courses in cooperation Italian department and courseware support specialists (on Blackboard eEducation platform using Adobe Captivate/Web Premium).
EDUCATION
Bachelor of Arts in English and Italian
University of Toronto, Toronto, Ontario
CERTIFICATIONS / HONOURS
IBM Patent Invention Achievement Award (Browser-Independent PopUp Windows)
IBM Certified Database Associate (DB2 9 for Linux, UNIX, and Windows)
IBM Certified Specialist (DB2 UDB V6 / V7 User)
WHITE PAPERS
Best Practices - Database Storage
Best Practices - Physical Database Design
PROFESSIONAL DEVELOPMENT
Numerous Program Design / Development Courses
Software Development Courses, DB2 Certification Courses, Technical Writing Courses
PROFESSIONAL AFFILIATIONS
IBM Centers for Advanced Studies (CASCON)
International DB2 Users Group (IDUG), Society for Technical Communication (STC)
American Translation Association (ATA), American Association of Italian Studies (AAIS)
AGATHA COLANGELO Page 4 ******.*********@*****.***
TECHNICAL SKILLS
Databases:
Certified on DB2 (Linux, UNIX, and Windows Editions)
DB2 Connect (Basic Knowledge), MySQL, Microsoft SQL Server, Oracle
Database Tools:
CA ERwin Data Modeler, DbVisualizer
Languages:
PL / 1, PLAS, PL / SQL, SQL, C, C++, Java, Javascript, JQuery
COBOL, REXX, Object REXX, Visual Basic, Turing
Software Design / Development:
IBM Data Studio, Rational Data Architect Version 7, Task Modeler, Web Studio, NetBeans IDE 7
Platforms:
Windows, Linux, UNIX, AIX, MVS, VM, VM / VSE
File Management / Backup Software:
CMVC, Rational, Tivoli
Office Productivity:
Microsoft Office (including MS Visio & MS Project 2010)
Lotus Applications and SmartSuite
Information Development:
ID Workbench, ArborText Editor, UltraEdit Editor, DITA
BookMaster, BookManager, Adobe (FrameMaker, RoboHelp), SGML, HTML, XHTML, XML
Education Software:
Camtasia Studio, ToolBook, Adobe (Captivate, Web Premium)
Graphics Software:
Adobe (Dreamweaver, Illustrator), CorelDRAW
Translation Software:
IBM Translation Manager / 2, SDL Trados