MICHAEL D.
MOCIOIU
OBJECTIVE
BI
Analyst (Consultant) position
Seeking to
provide expertise in the following areas:
Use Cases, Conceptual/Object Diagrams,
Interaction Diagrams, Component Diagrams, Class Diagrams, Package &
Deployment Diagrams, Managing Multiple n-tier Enterprise Projects
14 years
of progressive IT work experience.Self-starter, reliable, quick learner, a true team player.
Professional appearance and attitude having excellent
support and customer service skills.
Accustomed to working in a very fast-paced environment, able
to handle multiple tasks simultaneously.
Able to communicate clearly and consistent orally and in
writing, customer and business oriented with excellent leadership, technical
and people skills.
Fast and accurate having advanced programming abilities and
interface design skills.
Hard-worker, creative, detail-oriented, sociable and a good
sense of humor.
Highly analytical, well organized and able to work
effectively under pressure in order to meet deadlines.
Good business sense and able to understand the departmental
impacts of business decisions.
Experienced in systems analysis, requirement definition,
test plan creation, and implementation processes.
Business & Systems Analysis, IT Cross-Team Coordination and Liaison: 7 years
Microsoft Web Development: 5 years, IIS, HTML, ASP,
ASP.Net, VB.Script, Crystal Reports for Web
Java Web Development: 3 years, Tomcat, HTML, Java,
JavaScript, JSP,
Servlets, Applets, JDBC, Eclipse IDE
Databases, Data Analysis, Database Design & Development, Testing: MS Access (97, 2000, 2003): 9 years; SQL Server (6.0, 6.5, 7.0, 2000): 7 years; Sybase, Oracle, DB2, Informix, MySQL: 2 years
Data Access & Connectivity: 10 years,
ODBC, OLE DB, DAO, RDO, ADO, XML, Jet SQL, Transact-SQL, JDBC
Macromedia Director & Lingo: 1 year,
scripting, multimedia development
Reporting: 10 years, MS Access Reports,
Crystal Reports (6.0, 7.0, 8.0, 8.5, 9, 19, XI, for. Net), Data Dynamics Active
Reports 2.0
Modeling & Architecture: 7 years,
Data Analysis, OOD, n-tier Client Server Distributed Architecture; MVC, UML,
Rational Rose, Enterprise Architect
Unix: 2 years, AIX, Solaris, Scripting, CGI, C, Web
Templates
Release Management & Versioning Tools: 10 years,
Visual Source Safe 5.0, 6.0 (NT); Rational Clear Case (Unix/Windows)
MS Office (MS Access, MS Word, MS Excel and MS PowerPoint): 10 years
Project Management: 7 years
Team Lead: 7 years
User Support/Help Desk/Tutoring and Teaching: 7 years
Familiar with: TSO/CICS, OLAP, DTS, Lotus Notes,
Visio, Perl, SAP, AJAX, Powerbuilder
Senior BI Consultant, Mississauga, Ontario (August 2007 – Present)
Environment: MS Office 2003/2007, Siebel, Oracle BIEE, AC Nielsen, Proclarity, MS SQL Server
Developed and
monitored key performance indicators (KPI’s) using Siebel Analytics, OBIEE, MS Excel, MS Access, MS Powerpoint, AC Nielsen, Cognos TM1
Communicated brand performance insights
Delivered pricing and margin scenarios/analysis using Siebel Analytics and Cognos TM1
Developed complex Siebel Analytics/OBIEE reporting portal and dashboards for
pricing, sales, field surveys and trade segmentation
Planed field force activities ensuring adequate workload and resources
Performed targeting and segmentation functions using internal and external data sources
Executed trade strategies by engaging Regional Management teams
Assisted in the development of brand programs/launches
Assisted in forecasting of programs spending and sales volume using Cognos TM1
Managed relationships with Area Sales Managers and external data suppliers
Trained Area Sales Managers in using Siebel Analytics, Cognos TM1 and MS Access
Senior Systems Analyst/Technical Lead (VB6/VB .Net/MS Access/SQL Server consultant position) at Ministry of Community and Social Services, Toronto, Ontario (January 2007 – August 2007)
Environment: IBM-PC compatibles; Windows XP, .Net
Framework 1.1 Visual Studio .Net 2003, SQL Server 2003, ErWin, MS Visio, MS
Access 2003, Visual SourceSafe)
Performed business/systems
analysis and design in support of the new business requirements for ministry’s
Disability Unit Applications (DAU and SBT) in a Visual Basic 6.0/VB.Net/VBA/MS
Access 2003/SQL Server 2003 environment.
Produced business and
technical documentation (MS Word design documents and MS PowerPoint
presentations) for the implementation of new business solutions.
Liaised with business, IT
teams to gather and document new business requirements and worked closely with
the business and project resources to complete systems analysis, application
design, development and implementation.
Performed system data
analysis, proposed and documented data conversion plan and implemented new SBT
system and data migration from MS Access to SQL Server.
Completed
detailed testing plans, prepared and deployed prototypes/demos and led testing
activities with client and QA staff.
Senior Systems Analyst (VB .Net/CICS consultant position) at Rogers Communication Inc., Toronto, Ontario (October 2006 - December 2006)
Environment: IBM-PC compatibles; Windows XP, .Net
Framework 1.1 Visual Studio .Net 2003, Crystal Reports for Visual Studio
.NET, Visual SourceSafe)
Performed business
requirements gathering, business/systems analysis and design for Rogers’s SGI
call centre application in a VB.Net, Windows Forms, Web Services and CICS
environment.
Worked closely with the business and IT teams to complete systems analysis,
application design, and development for SGI call centre applications.
Liaised with business
units, IT teams to gather and document new business requirements and produced
business and technical documentation (MS Word design documents and MS
PowerPoint presentations).
Prepared
testing documentation and led testing activities with developers and QA staff.
Performed data analysis
and designed and developed usage reports using Crystal Reports for Visual Studio .NET.
Systems Analyst/Programmer (Visual Basic/COM/Informix/MS
Access position) at Siemens Canada, Toronto, Ontario (July
2004- September 2006)
Environment: IBM-PC compatibles; Windows XP, Windows
2000, Visual Studio 6.0, Crystal Reports 10, Visual SourceSafe, ClearCase,
Enterprise Architect, Java, Eclipse, Tomcat, Web Services (Osgi/Knopplerfish)
Performed
business/systems analysis, application design and development for Siemens
HiPath Pro Center call centre applications.
Worked as part of the GUI
team on the design and development of large-scale call centers applications
using Visual Basic 6.0 COM components and Informix/MS Access 2003 databases.
Specific projects & releases: participated in the analysis, design and
development of the highly rated Siemens HiPath Pro Center Suites 6.5 & 7.0
- Multimedia Design Center (including development of the HPPC 6.5 drag &
drop flow design editor for routing & queue processing voice, email and web
chat flows management).
Worked on the design and
development of Osgi/Knopplerfish Symphonia Services in a Java/Eclipse
environment.
Performed detailed
systems analysis, design and implementation, produced technical design
documentation (MS Word, Enterprise Architect), designed and implemented GUI
forms, classes, and services.
Designed and developed
CRM usage reports using Crystal Reports
10.
Documented and performed
unit test, performed third party tools and controls research and prototyping,
third party integration and release management.
Systems Analyst/Programmer (Visual Basic/MS Access/SQL Server position) at Canadian Center for Occupational Health and Safety, Hamilton, Ontario (July 2003- July 2004)
Environment: IBM-PC compatibles; Windows XP, Windows
2000, Visual Studio .Net, Active Reports 2.0, Visual SourceSafe.
Performed
business/systems analysis, application design and development for worldwide
poison call centers applications affiliated with the Canadian Federal
Government Agency for Health and Safety and with World Health Organization.
Worked on the systems
analysis, design and development of Visual Basic 6.0/VBA/Visual Basic .Net – MS
Access 2000/SQL Server 2000/Data Dynamics Active Reports distributed
applications.
Designed and developed
application reports using Visual Basic 6 and Active Reports 2.0.
Reverse engineered and
documented existing applications in order to support future changes and
enhancements, liaised with business, IT teams to support business requirements
analysis and software design and development.
Provided the migration
plan and implementation for the conversion of a MS Access 2000 database to SQL
Server 2000. This included system analysis, database schema and connectivity
migration as well as Jet SQL code conversion to Transact SQL and the use of SQL
stored procedures.
Provided release
management consulting (established Source Safe procedures, Source Safe database
set-up/maintenance and code version management).
Performed user
interaction & support, documented and led the unit testing and product
packaging and deployment.
Senior Systems Analyst/Team Lead(Visual Basic/MS Access/Excel/SQL Server consultant position) at VM Resources Ltd, Thornhill (Greater Toronto Area), Ontario (February 2003- July 2003)
Environment: IBM-PC compatibles; Windows NT
Server&Workstation, Windows 2000, Visual SourceSafe.
Led the systems analysis,
design and development of a Visual Basic 6.0 – Excel 2000 Touch-Screen
application involving working with multiple Excel Worksheets, DAO and document
automation.
Designed and developed a
MS Access 2000 database and a flexible automated reporting system (Visual Basic
6.0) for a metal manufacturing company in Vaughan, Ontario.
Prepared
testing documentation and led testing activities with development and QA teams.
Provided Visual Basic and
RDMS (MS Access 2000 and SQL Server 2000) analysis and consulting.
Performed business requirements
analysis, software design and development, user interaction, unit testing and
product packaging and deployment.
Systems Analyst/Programmer/Team Lead (Visual Basic/MS Access/SQL Server consultant) at Emegamaster, Toronto (July 2001- February 2003)
Environment: IBM-PC compatibles; Windows NT
Server&Workstation, Windows 2000, Visual SourceSafe.
Provided systems
analysis, project management and full software development life cycle expertise
for Emegamaster consulting firm.
Led the web site design,
development and deployment of
www.torontohotjobs.com (Java Script, CSS, HTML).
Designed and developed a
Visual Basic 6.0/MS Access 2000 management system (data storage and reporting)
to store candidate’s information.
Converted and migrated
the MS Access 2000 candidate database to SQL Server 2000.
Worked on the design and
development of TorontoHotJobs.com’s Resume Bank using SQL Server 2000 database
backend, ADO, Visual Basic 6.0 front end.
Prepared testing plans and led the testing activities with QA team.
Senior Programmer Analyst (Visual Basic COM/DCOM position) at Bank of Montreal, Toronto (February 2001 - July 2001)
Environment: IBM-PC compatibles; Windows NT Server&Workstation, Windows 98, Windows 2000, Crystal Reports, Visual SourceSafe, Rational Rose, Centerpoint LinkWorks.
Worked on the reverse engineering, analysis, design and
development of existing Corporate Banking Applications (Document management
applications) in a distributed environment, using Visual Basic 6.0 COM/DCOM
components, VBA automated document generators (Word, Excel) and having an
Oracle 8/DB2 back-end.
Performed systems analysis of 4 existing three-tier client
server systems (Facility Information Application, Lending Transaction System,
Risk Review and Credit Approval Request), documented business use cases and
component architecture.
Gathered users requirements, dealt with the user and
performed component change impact analysis, code changes and the release of a
new set-up kit for Credit Approval Request system. (Visual Basic COM/DCOM,
DB2).
Performed unit testing of Credit Approval Request system on
the Windows 2000 platform. Established and documented installation and testing
plans, software requirements and configuration settings for the new Windows
2000 images (CAEWIN client, network drive mappings, DCOM settings).
Worked on development of Seagate Crystal Report (8.0, 8.5)
web drill-down applications and IIS/ASP intranets used to provide internal
intranet policies, banking and credit information.
Provided business support, help desk and user tutoring and
teaching, cross-team coordination and liaison between the development team and
various business segments.
Systems Engineer at Charles Schwab, San Francisco (March 2000 - January 2001)
Environment: IBM-PC compatibles; Windows NT Server&Workstation, UNIX, ClearCase, PC Anywhere.
Performed web development and unit testing for www.schwab.com Web Trading Server using CGI (C), Java,
JavaScript, HTML, under UNIX (AIX, Solaris).
Provided technical & business support for eLeads System,
using C (UNIX) and Visual Basic 4.0 (NT).
Acted as a link between the business partners and the actual
development process, provided business support and cross-team
coordination/liaison between Business Analysts, the development team, and the
QA/Release Management team.
Trained 4 new developers in using Schwab's development
environment and tools, performed time estimates, code reviews and customer
support.
Maintained a permanent contact with the QA department,
documented testing plans and managed release entries.
Focused on improvement of the overall development life cycle
and came up with new requirements for the QA related to bug tracking and recording.
Software Developer (Visual Basic/Access position) at MDR Technologies, Oakville (January 1999 - March 2000)
Environment: IBM-PC compatibles; Windows NT Server&Workstation, Windows 95, Visual SourceSafe.
Performed the analysis and migration of an Assets Management
System (Delphi, Visual Basic COM components having an Access 97 back-end) to
SQL Server 7.0 by using ADO. (Built a Visual Basic 5 ActiveX component that
uses ADO to access the SQL Server database and used Transact-SQL to move Access
97 queries into SQL Server stored procedures.)
Performed performance tests using ADO, DAO against SQL
Server 7.0 and Access 97 (using the Call Detail Records collected from the
switch).
Analyzed and migrated a Telecom Billing System (MFC, Visual
Basic and Delphi COM components, Access 97 back-end) to SQL Server 7.0 using
ODBC links and CDAO objects.
Worked as a part of a team of 8 in the design and
development of an Access 97 Assets Management System used to primarily store
the network information (network nodes, cabinets, shelves, cards, trunks,
telephone sets and generic equipment). Created custom reports using Access
Basic.
Maintained a permanent contact with the QA department and
managed new release entries.
Programmer Analyst (consultant position) at Rogers Shared Services, Markham (June 1998 - December 1998)
Environment: IBM-PC compatibles; Windows NT Server&Workstation, Unix, Windows 95.
Performed systems changes/development and database
administration for the existing Document Management Cantel VRU Report Server.
(Visual C++ 5.0 front end, SQL Sybase Anywhere back-end).
Responsibilities: analysis, documenting and modifying
existing procedures, creating new report applications, providing support for
the Business Analyst and the end-user.
Designed a SQL Server 6.5 database for collecting and
tracking the network information; developed a two-tier client-server
application (ODBC, RDO) using Visual Basic 5.0 to access and modify the
database.
Used Seagate Crystal Info 6.0 to generate custom user usage
reports based on the existing business logic of an old Visual C++/Sybase
reporting system.
Performed systems analysis and created software
documentation for the VRU Cantel Credit Card Balance Inquiry and Payment System
by tracing the SGL, HGL and C files under UNIX platform.
Performed Y2K compliance analysis for the VRU Cantel System.
Programmer Analyst at NTG International Inc., Markham (September 1997 - June 1998)
Environment: IBM-PC compatibles; Windows NT Server, Unix, Windows 95.
Designed and developed a client-server application (ODBC,
DAO) using Visual Basic 5.0 as a front-end and MS SQL Server 6.0 as a back-end
to store the information and access the Metronet Toronto Building POP
Implementation database.
Designed and developed an Access 97 database for tracking
the countrywide network information (Network Information Database): site
information, machine information (ACD, PBX, VRU, Voice Mail, general and
detailed information), contact information. Connected the database with the
Visio network diagrams. Generated custom reports. Performed an Intranet Web
publishing of the database using ASP.
Designed tables and relationships for a Contact Management
Access 97 application. Tested logical design using queries. Designed forms
(GUI). Wrote code using Access Basic and Jet SQL. Generated reports.
Worked as part of a team of 6 in designing and developing a
Multimedia application - Interactive Game for children (using Macromedia
Director 6 and Lingo Script Programming).
Telecom Engineer at Alcatel Network Systems, Timisoara,
Romania
(August 1993 – August 1994)
Participated in the telephony systems installations in the
following Romanian cities: Craiova, Arad, Bacau.
Used blueprints and technical documentation and coordinated
activities of telephony installations, acted as liaison between Alcatel’s
French and Romanian Rom-Telecom engineers.
1996-1997
Programmer Analyst Diploma (91% final
average)
CDI College of Business and Technology, Toronto
1988-1993
Master of Science in Engineering
Faculty of Fine Mechanics, Optical/Electronics major
Technical University
Timisoara, Romania
1983-1987
Computer Operator and Programmer Analyst Certificate
Math/Physics Secondary School Specializing In
Computers, Timisoara, Romania
Canadian Academic Evaluation by University of Toronto
Degree certified between Masters and Bachelor of Science
level in Mechanical Engineering
US Academic Evaluation by Trustforte Corporation
Bachelor in Computer Science
Additional courses
Course
conducted by GrafP Technologies.
The Capability Maturity Model (CMM), Carnegie Mellon
University/Software Engineering Institute
Thompson
Certified Training Courses:
Java Language Fundamentals, Java IO, Java Collections &
Error Handling
Web Services, Java Server Pages and Servlets
Object Oriented Analysis and Design using UML
Citizenship: Canadian