SUMMARY OF QUALIFICATIONS:

Over 15 years experience in Project Management (PM), Business Analysis (BA), Business Systems Analysis (BSA), Enterprise Systems Architecture (EA), Business Intelligence (BI), Development and Software Lifecycle Management in Financial, Healthcare, HR, Education, Consulting, and Manufacturing industries.

 

Project Management

·         Project management from project initiation through implementation and maintenance stages. Planning and coordination of multiple work project teams. Handle complex application features and technical designs through all phases of development and implementation cycles.

·         Lead teams in review, analysis and architecture of business systems, user requirements, use cases, data flows, and process flows. Train business users and technical staff on new systems, capabilities and technologies.

 

Enterprise Systems Architecture

·         Conceptual, technical, functional, database and application design for enterprise-level systems. Architecture and implementation management. Define technical standards, policies and procedures, platform and tool selection.

 

Development

·         Design, development, implementation and maintenance of enterprise-level business applications (Finance, Healthcare, Manufacturing, Education, Consulting, HR/Benefits).

 

 

INDUSTRY BACKGROUND:

Financial Services:             Mutual Funds, Funds Transfer, Domestic and Global Custody, Foreign Exchange

Healthcare:                         Patient Tracking, Claims, Referral Services

Consulting Services:          Requisitioning, Placement, Vendor Management

Manufacturing:                   Process Control, Inventory Management

 

 

EDUCATION:                      Brown University, Providence, RI

                                          Bachelor of Arts, Computer Sciences

 

 

TECHNICAL BACKGROUND:

PM Tools:                           Microsoft Project

Workstation Software:         Microsoft Office (Word, Excel, Visio, PowerPoint, Outlook, Access), Lotus Notes

 

Business Intelligence:          Crystal Reports, SQR, WebFOCUS

 

Methodologies:                   OOA/OOD, Extreme Programming (XP), ETL, RAD, JAD, DESIGN/1, METHOD/1.

 

Databases:                         Oracle (7,8i,9i,10g), MS SQL Server (6/7/2000/2005), Sybase (4/10/11/12/12.5), DB/2, MS Access, Lotus Notes

Languages:                         SQL (PL/SQL, T-SQL, ANSI SQL), PowerBuilder/PFC (3/4/5/6/6.5/7/8), Java, COM/DCOM, ASP, HTML, XML, Visual Basic, C/C++, FoxPro, ObjectView, dBase, Pascal, Basic, Lisp, Prolog, FoxBASE+/Mac, Assembler

Design/Development Tools: TOAD, ERwin, DBArtisan, S-Designor, PowerDesigner, Rational (ClearCase, ClearQuest), InfoPump, CVS, PVCS, Visual SourceSafe (VSS), FIX, Financial Fusion

 

Operating Systems:             Win 95/98/NT/2000/XP, OS/2, DOS, UNIX (IBM AIX, HP-UX, SunOS/Solaris, Linux), Mac OS, NetWare

 

 

PROFESSIONAL EXPERIENCE:

Sinoma Consulting, Inc., Lincoln, RI (08/1997 – Present)

Project Manager / Senior Architect

Founder and manager of a full-service IT consulting company. Responsible for financial and legal aspects, employee relations, staffing, strategic planning, vendor management, and customer relationship management (CRM). Personally provide Consulting Services to client companies.

Fidelity Investments / Strategic Advisers (SAT), Boston, MA (03/2005 – 01/2008)

Senior Architect / Project Manager

Database conversion, design, and development.

§         Project management – coordinate project schedules and work-loads, deliver presentations to business lines.

§         Responsible for defining organizational development standards (naming, coding, architectural, migration).

§         Mentor and train employees on Oracle database development/architecture.

§         Responsible for developing conversion strategy from Sybase to Oracle 10g. Migrated database schemas, procedural code and data. Automated majority of the migration process.

§         Design and develop Informatica transformations for data loads from various external and internal financial feeds (reference, returns, corporate actions, pricing, accounts, etc.).

§         Develop scripts, database procedures and packages to handle business logic and utility functions.

§         Perform extensive database performance tuning.

(Oracle 9i/10g, SQL Loader, Informatica, ETL, Rational ClearQuest, TOAD, Erwin, stored procedures, packages, Perl, UNIX scripts).

 

Workscape, Inc., Framingham, MA (11/2004 – 03/2005)

Senior Architect

Database design, performance tuning and development

§         Designed and developed ETL scripts/packages, using SQL Loader, Excel/macros, command-line scripts (DOS/UNIX).

§         Optimization/tuning of complex database processes.

§         Diagnosed, troubleshot and maintained core database logic; created/deployed database release packages for client distribution.

§         Provided database support and assist with integration of Oracle with front-end Java applications.

(Oracle 8i/9i/10g, SQL Loader, ETL, Rational ClearQuest, StarTEAM, eRooms, TOAD, Erwin, stored procedures, packages).

 

Investors Bank & Trust Company, Boston, MA (6/2004 – 10/2004, 12/2001 – 10/2003, 02/2000 – 09/2000)

Project Lead / Architect

Responsible for project management, architectural design, development, and production support of mission-critical financial applications (Automated Trade Instruction, ETF, Cash/Asset Management) in the data warehouse environment.

§         Lead development teams on multiple projects (3-10 people per project). Mentored and trained developers.

§         Responsible for the database design, data modeling and architectural reviews

§         Designed and developed trading applications, using PowerBuilder/PFC; Created company-wide object framework.

  • Developed System Requirements and Functional Specifications documents.

§         Developed complex data-mining/replication/ETL mechanisms in the data-warehouse environment, using SQL Loader, UNIX shell scripts, flat file manipulation, Oracle objects and MS SQL Server.

§         Implemented performance improvements using shell scripts and PL/SQL rewrites for various database components, including Advanced Queues, object views and legacy PL/SQL code.

§         Coordinated interfacing/integration of back-end code with Java/Weblogic development team.

(Oracle 7/8i/9i, MS SQL Server 2000, ETL, UNIX shell scripts, SunOS, FTP, XML, Cron, Argent, Crystal Reports, Rational ClearCase, Rational ClearQuest, TOAD, Erwin, Oracle AQ, Oracle collections, stored packages, object types, Weblogic).

 

Thomson Financial (AutEX/GTS Group), Boston, MA (6/2004 – 10/2004, 12/2002 – 01/2003, 10/2000 – 12/2001)

Senior Database Architect

Responsible for architectural design, development and performance tuning of the Global Financial Messaging System.

  • Architectural design, modeling, and development of database conversion from Sybase to Oracle; replacement of Financial Fusion databases with in-house solution.
  • Mentored/trained developers.

§         Responsible for the database design and data modeling.

  • Extensive work on back-end code optimization/performance tuning.
  • Integration of database components with Java/WebLogic and Financial Fusion servers.
  • Development of various trade-, ioi- and system- reports, integration with reporting tools.
  • Prepared Business Requirements, System Requirements and Functional Specifications documents.

(Oracle 9i, Sybase 11.9.2/12, UNIX shell scripts, FIX, Weblogic, ErWin, Financial Fusion, XML, CVS, PowerDesignor)

 

Ibis Consulting, Inc., Providence, RI (10/2003 – 6/2004)

Manager, Software Engineering Department

Software Engineering Department Manager (Developers, DBAs, QA and Technical Writers), reporting to CTO.

§         Short- and long-term strategic planning (including customer service, budgets, technical direction and business development/marketing) for the organization.

§         Department budgeting, performance reviews, project planning, task coordination and resource allocation.

§         Developed, managed, and published project documents, including statements of work, functional specifications documents, project plans, use cases, data and process flow diagrams, presentation, system test plans and implementation plans.

§         Managed resource allocation and delegated tasks across the project teams, including remote development teams.

§         Architectural design and modeling (front-/back-end), database development/performance tuning in VLDB transaction-intensive environment.

(MS SQL Server, Delphi, Microsoft CRM, BlueArc, Visual SourceSafe).

 

Bryant College – Executive Development Center, Smithfield, RI (11/2002 – 10/2003)

Chief Instructor / Oracle Certification Program (Evening classes, part-time)

·         Taught Introduction to Oracle 9i PL/SQL and DBA 3: Performance Tuning courses for Oracle 9i Certification Program.

·         Taught Introduction to Client/Server, Application/Database Design Methodologies, PowerBuilder Development, Object-Oriented Design and Development and Master Lab modules of the Client/Server program.

 

FLEXXperts, LLP, Natick, MA (02/1998 – 02/2000)

Technical Lead / Architect

As part of the software development team worked on the development of the commercial Lease Tracking Application.

§         Supervised and coordinated development efforts for several product lines.

§         Analysis, design, development and maintenance of Lease Tracking Application, using PowerBuilder, Oracle and UNIX scripts.

§         DBA for Oracle Server (7/8) on IBM AIX, HP-UX and NT (database design, administration, configuration, maintenance, installation, performance tuning, query optimization, etc.).

§         Developed COM/DCOM components for complex business logic, deployed to the MTS/IIS.

§         Developed ASP, JavaScript and VBScript application to handle internet-based Customer Issue Tracking.

§         Responsible for preparation and installation of client/server releases, version control, generation and maintenance of installation scripts (UNIX, Oracle, Windows).

§         Configured and administered Microsoft IIS and Exchange Servers; monitored load and activity.

§         Developed complex reports for Lease tracking, using VB, PowerBuilder, Crystal Reports and a variety of 3rd-party components.

(PowerBuilder, Oracle 7/8/8i, ErWin, IBT AIX, HP-UX, NT, shell scripts, MS SourceSafe, MS MTS/IIS, COM/DCOM, ASP, JavaScript, VBScript, Crystal Reports, ActiveX, OLE, MS Visual C/C++, MS Access)

 

Healthcare Automation, Inc., Providence, RI (08/1997 – 02/1998)

Senior Architect / Developer

Architect/developer in the large-scale software development project for the Distributed HomeHealth Solutions application.

§         Developed custom application framework using PowerBuilder/PFC and database objects (Oracle and Sybase).

§         Responsible for database design and modeling.

§         Participated in developing and documenting of use cases.

§         Development of complex reporting logic, using Oracle objects, Crystal Reports and PowerBuilder.

§         Supervised a team of junior to intermediate developers.

(PowerBuilder 5/6, Sybase 11, Oracle 8, Crystal Reports, PVCS)

 

PowerBuilder User Group of Southeastern New England, Providence, RI (11/1996 – 02/1998)

Steering Committee Member (part-time)

Active participant in the Committee business activities, including: scheduling, speaker and venue negotiations, coordination, etc.

 

Teleon Systems, Inc., Walpole, MA (1997 – 1999)

Engagement Manager / Vice-President

§         Senior Management duties for the startup consulting company: HR, planning, projections, financial aspects, etc.

§         Engagement manager on several client assignments. Performed tasks included: project initiation and management, generation of business and systems requirements documents, database design, creation and development (Sybase, Oracle, MS SQL Server), GUI design, usability studies, etc.

 

c.w. Costello & Associates, Inc., Providence, RI (05/1996 – 08/1997)

Senior Associate / Chairman of Education Committee

Senior consultant, participating in a variety of projects for the company's clients.

§         Coordinated work of the company Education Committee. Responsible for scheduling and course development.

§         Instructor for Introduction to PowerBuilder, Intermediate PowerBuilder, Advanced PowerBuilder, Client-Server Technology, Client-Server Relational Databases, and Object-Oriented Technology courses.

§         Analysis, design and development of the On-Line Customer Service Application for a RI-based student loan brokerage firm. Part of the focus team for Business Process Reengineering.

§         Development of Management Decision Support/Reporting System, using PowerBuilder, Sybase, SQR, and UNIX scripts.

§         Responsible for optimization of Sybase queries, stored procedures and triggers (performance improvements for some of the processes from several hours to several seconds)

(PowerBuilder, Sybase, Oracle, UNIX, shell scripts, PVCS, SourceSafe, Novell, FoxPro, Sybase, SQR)

 

ComputerEd, Lincoln, RI (01/1996 – 06/1996)

Instructor (Evening classes, part-time)

§         Taught Oracle SQL, Oracle Database Administration and Oracle ToolSet courses.

 

QCC, Inc., Dedham, MA (03/1995 – 04/1996)

Senior Consultant / Project Lead

As a senior consultant, participated in a variety of projects for company's clients.

Data Warehousing Project

§         Design and development of the database-independent Data Warehouse Management System, including Logical and Physical Browsers, DataMart definition, DataMart Load and Reporting modules.

§         Developed application modules to support ETL – source data extraction, mapping, transformations, loads.

Order Entry/Pricing Application

§         Project Lead for the Real Time Order Entry and Pricing Application for a precious metals manufacturer. Involved in research and documentation of business processes.

§         Designed, developed, documented functional requirements and conducted end-user training.

Phone Tracking Application

§         Designed and developed commercial Phone Tracking application, to track organizational phone usage.

§         Developed a variety of reports for incoming/outgoing calls, performed system maintenance, etc.

(PowerBuilder, MS Visual C/C++, MS Access, Oracle, Sybase, DB/2, Informix, MS SQL Server, ODBC, Crystal Reports)

 

Andersen Consulting, Boston, MA (06/1994 – 03/1995)

Information Systems Consultant

§         DBA for an On-Line Provisioning System Project for NYNEX (New York).

§         Performed logical and physical database design, database tuning, and performance optimization.

(Sybase, Oracle, OLTP, UNIX, DESIGN/1, METHOD/1)

 

American Power Conversion, W. Kingston, RI (12/1992 – 06/1994)

Programmer Analyst / MS SQL Server Platform Specialist

§         Performed logical and physical database design, database tuning, and performance optimization.

§         Designed and developed ETL scripts/interfaces, using InfoPump for data migration/replication between MS SQL Servers and Lotus Notes databases.

§         MS SQL Server DBA, InfoPump Administrator, Lotus Notes Servers Admin.

§         Designed/developed client-server applications, using MS SQL Server and Lotus Notes.

§         Responsible for customizing and internationalizing applications for the needs of foreign offices (Paris, Galway).

(MS SQL Server, InfoPump, NT, OS/2, PowerBuilder, Lotus Notes, ObjectView)

 

Brown University, Computing and Information Services, Providence, RI (12/1989 – 12/1992)

Applications Specialist

§         Designed and developed a variety of database applications in a multi-user environment.

§         Beta-tested FoxPro 2.0 for Fox Software, reported issues, verified fixes, provided direct input on product improvement.

(FoxPro, MUSE, FoxBase/MAC, MacOS, Novell)

 

Center for Scientific Research, Minsk, Belarus (06/1988 – 10/1989)

Programmer / Analyst

§         Designed and developed a number of PC database applications.

(FoxPro, DBASE, C/C++, Pascal)