We provide IT Staff Augmentation Services!

Database Management/consultant Resume

2.00/5 (Submit Your Rating)

Belleville, MI

SUMMARY

  • 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.
  • Designed/wrote SQL comparing a relational Oracle database with a dimensional Microsoft SQL Server database.
  • Designed and wrote 20+ procedures/functions package that was used to do the business rules for a CRM web site.
  • Designed and wrote numerous functions to handle a statistical predictive model for a web site.
  • 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.

TECHNICAL SKILLS

  • 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

Confidential, Belleville, Mi

Database Management/Consultant

Responsibilities:

  • Database Management for HCP Programs
  • Writing requirements/specifications/testing for PY Innovations company to improve client web site.
  • Database/Data analyze for Confidential to help their client to start a new digital campaign.
  • Database Management for Confidential for HCP Programs.

Confidential, Romulus, MI

IT Manager/PM/BA

Responsibilities:

  • Received “DRTV Veteran Medal of Honor” from client for analyzing and CRM management increase customer base.
  • 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.

Confidential

Lead Production Support

Responsibilities:

  • 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.
  • 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.

We'd love your feedback!