Your Host

 

Pierre Leclerc
Serving corporations and individuals
On line and on site

514-257-0734

[email protected]

 

Business Analyst
and
Excel-VBA Developer

I worked as a Business Analyst for 25 years, I have University Degrees in Accounting, Management and Science. I am also certified by Microsoft in Excel and Access, and certified in VBA and EssBase.

My long experience in accounting, data analysis and reporting allows me to rapidly understand the needs of my clients and my knowledge of the technology allows me to develop the optimal reporting process.

Having tried to work with most reporting applications within major databases and ERP systems, having tried Crystal Report, I chose Excel.

I chose to work with Excel because it is the best and the cheapest utility to develop reports whatever the source of the data (Essbase, JDE, SAP, Oracle, SQL Server and any old legacy system).

I chose to work with Excel because it is the best way to share information over the Internet in a format that can be either read by a recipient or used to feed other reporting processes.

I chose to work with Excel because the programming language within Excel (VBA) allows me to automate these time and money consuming analyzing and reporting tasks. VBA aloows me also to develop incredible applications, databse front-ends and back-ends.

But I mainly chose to work with Excel because I can share my expertise with my clients allowing them to become self-sufficient. Nothing is hidden in my applications so they can maintain and modify them.

My client call me back for new projects only.

I work mostly on line (Internet and telephone).

I develop stand-alone applications and complex data analysis
in Excel and VBA-Excel.

 I develop database front-ends using VBA to automate reporting processes in Excel downstream from Essbase, all major databases, ERP systems and specialized applications.

I develop database back-ends using VBA to automate data loading processes with Excel upstream from Essbase, all major databases, ERP systems and specialized applications.

Along the way, I share my expertise in VBA, Excel,
data analysis and reporting.

I also coach groups of analysts on site helping them develop analyzing and reporting skills while I create small customized VBA procedures to automate the data gathering, the printing and the Emailing of hundreds of reports at the click of a button.

You want better information and you want to get it faster?

What you need can be done in Excel.

Get in Touch

mandates@excel-vba.access.com

Clients

The National Bank of Canada

The Chase Manhattan Bank *

The United Bank of Switzerland *

Bell Helicopter Textron

Molson's Breweries

Deloitte Consulting

Air Canada *

Deutsch Bank

Gildan Activewear

(BCV) Banque cantonalle vaudoise *

Desjardins Securities *

Medcompliance

and many professionals around the world*.

* service on line