Site hosted by Angelfire.com: Build your free website today!

MICHAEL D. MOCIOIU

Thornhill, Ontario

E-mail: craiova_maxima_4ever@yahoo.ca

 

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

 

HIGHLIGHTS

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.

 

DETAILED IT BACKGROUND SUMMARY

Industries: 14 years, Telecom (CRM), Credit Card & Billing Systems, Asset Management, Brokerage/Trading, Banking (Risk Management), Medical/Health, Retail (sales)

Business Intelligence: 4 years, Siebel Analytics, Oracle BIEE, Cognos, Proclarity, AC Nielsen

Business & Systems Analysis, IT Cross-Team Coordination and Liaison: 7 years

Application Design and Development, GUI, OOD, OOP, Class Design, Distributed Component Development, Unit Testing, Support: 10 years, Visual Basic 5: 2 years; Visual Basic 6: 7 years; C++/Visual C++/MFC:  2 years; COM/DCOM, COM+, MTS, ActiveX: 8 years, VB.Net: 3 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

 

EMPLOYMENT HISTORY

 

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.

 

EDUCATION

 

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