Mark A. Brown

Canton, MI 734-***-**** ac2y3t@r.postjobfree.com https://www.linkedin.com/in/mark-brown-9790b915

BA/PM/MANAGEMENT TECHNOLOGY PROFESSIONAL

Very successful at aligning system specifications with customer requirements to deliver projects on-time, on budget, revenue producing, correctly, and requiring low ongoing maintenance. Written 100s of functional and technical specifications against large databases. Can provide example of one 15+ page Microsoft Word one that I built at home with some complex formulas in Excel. Have at least one technical specification that integrated/ETL six different databases/systems. Successfully designed, developed, and implementing various systems throughout SDLC. Very successful with clients, Product Owners, Stakeholders, web teams, off-shore development teams, and system users including training.

My work has been the #1 factor in generating over one-million-dollar IT programming revenue annually for 10+ years.

Successfully managed BA/PM work for several rebate/bonus systems that wrote close to one billion dollars in checks. Designed, including QC system, complex multi-tier bonus structures for extended warranty sales that gave $40 Million+ in annual bonuses to 2000+ Auto Dealers. Client audit found 100% accuracy of bonuses.

Another client gave me a medal for my work. Have 21 references, including five former bosses. Have many recommendation letters, four are on LinkedIn.

Worked with CRM databases close to 15 years including some with Teradata CRM, and helping client understand millions of customer data for Salesforce. Project Managed/Business Analyst for various systems/databases including one for 10+ years with over 10 million customers, 40 million transactions and 200 million survey questions. Excellent at data analyses. For instance, proactively created smart codes for the client that became their de-facto standard.

Have used SQL for 20 years. Worked with Tableau team to help improve their product, including table connects and SQL. Worked some with QlikView, can provide samples. Have designed data structures and written many Oracle functions and procedures including using cursors and loops. Also, used Microsoft SQL Server including using temp tables and outer joins.

1.Designed/wrote SQL comparing a relational Oracle database with a dimensional Microsoft SQL Server database.

2.Designed and wrote 20+ procedures/functions package that was used to do the business rules for a CRM web site.

3.Designed and wrote numerous functions to handle a statistical predictive model for a web site.

4.Designed and wrote the SQL for a completely new BI reporting solution.

My director (one of my references) said in an email to me: Great job - delivering the BI project! I still can’t get over us delivering a new capability (from scratch) in less than 6 weeks. The client was ecstatic and said he found no holes in our solution.

Leadership Competencies

●Team Leadership & Collaboration

●Project Management

●Customer Relationship

●Resource Planning & Execution

●Technical Designs

●Business Design & solutions

●Budgeting

●Estimations

●Process Improvements

Technical Competencies

Methodologies Business Tools Databases/Types

●Waterfall

●MS Excel

●Oracle PL-SQL

●Agile (SCRUM)–Fundamentals Certified

●MS Word

●Microsoft SQL Server T-SQL

●Life Cycles

●MS Visio

●Some QlikView

●Relational Databases

●Dimensional Databases

Professional Experience

Independent Consultant 2017

BA and PM consultant.

●Writing requirements/specifications/testing for PY Innovations company to improve client web site.

●Database/Data analyze for Archer Corporate Services (ACS) to help their client to start a new digital campaign.

Archway Marketing Service, Romulus, MI July 1999 to January 2017

IT Manager/PM/BA

Built and used SQL throughout my career. Wrote functional and technical specifications and did estimations/quotes. Managed/led teams of Developers and contractors providing systems support for various technologies. Oversaw all aspects of ongoing projects including quality, performance, customer relations, scopes, schedules, data modeling and budgets. Led development of project quotes and procedures as well as training customers across numerous platforms.

●$1 million+ in annual IT revenue growth with client by improving and creating new technology solutions to improve efficiencies, reduced time to market and inventory overages.

●Received “DRTV Veteran Medal of Honor” from client for analyzing and CRM management increase customer base.

●Awarded twice as the best CRM system designed in an audit by Deloitte as well as by Johnson & Johnson “Lean team”.

●Analyzed and consolidated data for client with several FDA/FCC recalls and compliances with CRM data.

●Successfully worked with HIPAA laws and FCC opt-out laws on over 10 million customers.

●Managed setup of several fulfillment/CRM eCommerce Sites, which contributed towards increase in new customers.

●Data Modeling with EDW/Tableau teams reporting product. Led audit of EDW and Tableau reporting for the EDW.

●Managed/specified a Rebate Management and Distribution System that printed over $200 million in checks annually.

EDS – (July 1996 to July 1999)

Lead Production Support team for all of all GMACI EDS software 24/7. Consultant.

Responsible for all technical support of all production systems including Sybase, C++ and Mainframe (JCL…). Was the liaison between EDS and GMACI business people for all the systems EDS supported.

●Successfully maintained and improved all new campaigns for a one Million+ annual sales warranty system.

●Ensured that each of my team members was crossed trained between all IT systems used within Production Support.

●Found and corrected C++ code proactively. Improved our deployment of software.

American Community Mutual Insurance Company-ACMIC (April 1990 to June 1996)

Designed, developed and implemented Small Business Health group rate matrix system, installed at all agent offices.

Appointed the only IT active JAD (Joint Application Development) member for Health Insurance business.

Head Actuarial said I could become an Actuarial if I chose.

Past Side Consulting/Teaching Jobs

C++ Programmer for ACMIC after leaving permanent employment. Twice hired as Programmer for two projects at Eagle Financial Corporation. Project Manager for project at Environmental Engineering Firm Enviro. Programmer Consultant for Rochester Sales. Computer Instructor at Cleary College. Political Science Instructor for two years at Wayne State University.

Education and Professional

Master of Public Administration – Wayne State University.

Bachelor of Arts in Political Science – University of Michigan

ISO Auditor certified

Scrum Fundamentals Certified (SFC)

State of Michigan Life Insurance License (Resident Producer)

Contact this candidate