Loading...

Clarity

Erik Hanley

Montreal, Quebec, Canada

I have more than 15 years of experience as an Analyst-Programmer and Database Architect. I have mostly experiences with Microsoft SQL Server as a programmer and Database Architect, Transact-SQL (T-SQL), ASP.NET, VB.NET, C#, Debugger, HTML, Javascript (mastering easily all requested Framework), CSS and frameworks creation and integration.

I also have experience in PHP, MySQL, Quality insurance and Testing. On the business side, I have more than 10 years in employee productivity and call centers (outbound & inbound) as a data analysis.

I'm a team player and I like to be aware of all business and IT factors when working on a project. You have a problem? I have the IT solution for you!

I'm a code lover.

$5.00/min

—
0 Calls

—

0 Reviews

—

Avg. call

Business Development Information Technology Productivity Database Design Business Coaching Call Centers Operational Efficiency Database Management Database Marketing Cost Reduction

Call me to talk about

Database Architecture and Development

Senior Analyst Programmer with more than 15 years of experience. I can help you design efficient databases structures for your needs.

Call Center Productivity

More than 15 years of experience as a Senior Analyst Programmer and more than 10 years in employee/market productivity projects. I can help you increase your sales agents performance, target your leads and lower your expenses.

How to Become an EPIC Programmer

With more than 15 years as a Senior Analyst Programmer and 10 years of experience managing programmers, I can help you become an EPIC programmer. I will give you clear guidelines and provide coaching on how to become the best programmer of your team/company with real business challenges.

Answers 12
Reviews 0

Answers

Erik Hanley answered

How can I create a database of emails for a specific client market?

Hi, my name is Erik and I'm a Senior Database Architect working in marketing and employee productivity since more than 15 years.

Buildind a B2C database of potential customer can be a real challenge. My suggestion is to start with public data websites. It's all about doing researches and keep the data clean so it's usable.

If you need to have a structured database built with the informations you are looking for I'm available to help. Do not hesitate to send me a call request.

Regards,

Erik

Schedule a call • Share • Flag

B2C

Email Marketing

Databases

Erik Hanley answered

What's the Best way to Set Up a Relational Database?

Hello,

My name is Erik and i'm a Senior Database Architect with more than 15 years of experience and I also have 10 years of experience managing programmers.

The best way to ensure data relations between your objects (Product selected, type of coating, etc) is the following: you should explain to the developer that you want a 100% dynamic parent/child associations between objects without any limits on associations between objects.

If you need more details and/or want to schedule a call, we can go over your business requirements and I can help you build the technical specs for your programmer. I am also available to develop the data structure that you need.

Regards,

Erik Hanley

Schedule a call • Share • Flag

Database Design

E-commerce

Erik Hanley answered

What factors determine good geographic areas for telehealth implementation?

Hello, my name is Erik and as a Senior Analyst Programmer in marketing I had the opportunity to build targeted leads list for sales agent, witch is quite similar to your goal with this question.

You are on good track with your suggestion of using multiple models to determine your "customers" potentials by areas, internet availability, etc. We can also think of people age, specific area's health problems, etc. There's multiple trends we could find by managing all the information in a structured database. If you are interested to develop this idea combined with data mining/analysis skills, I will be happy to help you.

I look foward to help you on a call and don't hesitate to send me a message if you have questions.

Regards,

Erik

Schedule a call • Share • Flag

Healthcare

Healthcare Information Technology

Telecommunications

Erik Hanley answered

Where can I learn SQL for business professionals? I need only the reporting part. I can run basic queries, but want to do more heavy queries.

Hello, my name is Erik and I'm a Senior Analyst Programmer. To build more complex queries you must practice, practice and practice. Challenge yourself! Think of complex results you want in a report and do the query, however how long it will take. Over time, you'll become more efficient in building queries and you'll be able to analyse any data.

If you need help to get a step by step guideline to follow or want private SQL training, I'm available to help you.

Regards,

Erik

Schedule a call • Share • Flag

SQL

PostgreSQL

Business Coaching

Erik Hanley answered

What is a good strategy to find new customers, either B2B or final customers?

Hello,

My name is Erik and i'm a Senior Analyst-Programmer with 15 years of experience.

I do have experience to build marketing B2B and B2C lists for outbound call centers. I can help you building potential customers lists and also help you build and train your sales agents. There's many possible strategies to reach potentials customers: outbound calling, e-mail marketing campaigns, publicity (ads), etc.

Feel free to schedule a call with me, I will be more than happy to help you establish a marketing strategy to reach potential customers.

Regards,

Erik

Schedule a call • Share • Flag

Marketing Strategy

Lead Generation

Strategic Partnerships

Erik Hanley answered

Can you recommend a mentor evaluation form for startups? Thank you!

Hello,

My name is Erik and I'm a Call Center Expert and Senior Analyst Programmer. I've been working on employee/leaders productivity since more than 15 years.

I suggest prior to establish an evalutation form, you must align clear revenues and profits goals and also layout your top social values. By splitting those objectives by executive, and then by employees, you will end up having an evaluation form that is aligned with your revenues/profits objectives with a combinaison of respect with the company's values.

I will be more than happy to help you with this and please feel free to schedule a call so we can have this evaluation form for all employees and leaders up and running!

Regards,

Erik

Schedule a call • Share • Flag

Mentoring

Startups

Erik Hanley answered

Running a sports camp, do I need to have two people who are working it with me fill out an independent contractor form? Or can I just cut them a check

It will surely depends on where you are located. In Canada, you can ask the 2 employees/contractors to provide you a bill like any company does when they sell services to customers and you can pay them by check. The employee/contractor would need to be registered as a company (incorported or registered on their names, it doesn't matter). Expect to pay sales taxes if you go this way but you won't have any "employee paperwork" to do.

Regards,

Erik

Schedule a call • Share • Flag

Tax Accounting

Corporate Law

Small Business

Erik Hanley answered

What are good platforms for outbound marketing for a development agency?

Hello,

My name is Erik and i'm a Call Center Expert and Senior Analyst Programmer with more than 15 years of experience.

I've been working in the outbound sales of one of the biggest telecom company in Canada since 6 years. There's many different options you could use depending of your marketing goals. If you need help building a outbound call center, leads generation and sales productivity tracking and improvement, I will be happy to help you. I can help you to build a custom end-to-end solutions, from developement to operations and revenues.

With my IT and outbound sales experience, I will be able to help you acheive your sales objectives. I'm hoping to be invited on a call to be part of this amazing project.

Regards,

Erik

Schedule a call • Share • Flag

Business Development

Lead Generation

IT Outsourcing

Erik Hanley answered

For B2B companies, where do you go for lead generation? What are some best practices?

Hello,

My name is Erik Hanley and I have been involved in the outbound marketing business since 6 years and I've been a Senior Analyst Programmer for more than 15 years.

I suggest you hire a marketing professionnal combined with a data expert programmer (like me!). Data combined with Marketing thinking is, by experience, the most successful way to have leads, especially for high priced products. You can always use a marketing agency to help you, but they won't work accordingly with your objective as for them, leads equals money, however the leads quality.

If you need additionnal help to find team members that would generate you leads (more than 2-3 per month!), please Schedule me a call and I'll go thru my past expériences and lessons learned with you. I can help you on the data side and help you hire a marketing professionnal (or more if needed).

Regards,

Erik

Schedule a call • Share • Flag

B2B Lead Generation

Lead Generation

Marketing Strategy

Erik Hanley answered

What is the cost to acquire users for an iPhone game app?

Hi,

My name is Erik and I'm a Senior Analyst-Programmer with more than 15 years of experience combined with 6 years of being a Sales Call Center expert.

It does depends on specific factors. Some of them are: Cost of application, quality of the game, is it a unique game, is there geographical limitations, how agressive is your ads campaigns, etc. The average cost to users acquisition is variable depending on the product sold. Some applications/games cost almost nothing to market (like Pokemon Go!) and others that has more challenges.

If you want to discuss on a call about ways increasing your users (and revenues if it applies) and how to do efficient marketing for your game, don't hesitate to schedule a call with me.

Regards,

Erik

Schedule a call • Share • Flag

iPhone apps

Erik Hanley answered

What are some of the best PBX phone apps/system for sales and for marketing? IE Grasshopper versus Twilio, for small business and startups.

Hi,

My name is Erik Hanley and I'm a Call Center Expert and Senior Analyst Programmer with more that 15 years of experience. If you need help to set up a call center/PBX phone app, you need to evaluate your needs and budget and then look for the telecom providers. Using VOIP providers Vs traditionnal phone lines will impact the cost and phone line qualities.

If you need help to set up your telecoms for your small business/start up, i'm the good person to help you. I will be happy to help you on a call.

Regards,

Erik

Schedule a call • Share • Flag

Marketing Strategy

Online Marketing

Email Marketing

Reviews

Member since August 2016