We provide IT Staff Augmentation Services!

Business Intelligence Consultant, Principle Architect/engineer Resume

Carlsbad, CA

SUMMARY:

  • Over 25 years of software engineering experience in development, management, and consulting roles.
  • Experienced in all phases of software development using a wide variety of tools, technologies, and software development methodologies.
  • Strong technical background in architecture, design, and development supported by masters degree in software engineering.
  • An established senior manager responsible for budget, staff, structure, policy, and overall direction of information technology initiatives with a proven track record of successful project implementations in a variety of industries including aerospace, health care, automotive, and pay media. Capable of understanding business objectives and transforming them into technical solutions working independently or in team environment.

TECHNICAL SKILLS:

  • Database Design
  • Data Warehouse Design
  • ETL
  • Business Intelligence
  • Analytics/Reporting
  • SQL Server 2005,2008,2012,2016
  • Oracle 9,10,11,12
  • SSIS, SSAS, SSRS
  • T - SQL, PL/SQL
  • Visual Studio. TFS
  • OLAP, Data Mining
  • Power BI,Dundas, Crystal Reports
  • Visual Basic, ASP, HTML,,XML, .NET, C#
  • Agile Methodology

PROFESSIONAL EXPERIENCE:

Business Intelligence Consultant, Principle Architect/Engineer

Confidential, Carlsbad, CA

Responsibilities:

  • Worked with executive management to define a new business intelligence strategy and technology road map in the pay-media industry.
  • Traveled to client sites to gather reporting requirements, present new business intelligence initiatives and provide architecture and design assistance.
  • Designed logical and physical enterprise data warehouse in accordance with dimensional modeling principles across sales and marketing, warehouse, shipping, finance, product, service/installation, and customer support business processes.
  • Developed ETL platform using SSIS integrating data from various data sources including relational, flat file, xml, and web services.
  • Proficient in Microsoft T-SQL and Oracle PL/SQL programming.
  • Experience in performance monitoring and query optimization.
  • Developed multi-dimensional and tabular OLAP data sources using SSAS including key performance indicators to support self-service reporting initiatives.
  • Developed operational reports and analytical dashboards using SSRS, Power BI, Dundas to deliver data visualizations providing strategic insights and operational regulatory compliance.
  • Developed data mining models using supported algorithms for statistical analysis and intelligent marketing campaigns.

Engineer, Architect, Director Software Engineering

Confidential, San Diego, CA

Responsibilities:

  • Conducted presentations and demonstrations with internal and external corporate executives to define and implement industry leading CRM applications.
  • Structured, staffed, and managed a 30 member team consisting of web engineers, database engineers, system engineers, technical analysts, and network engineers.
  • Designed and implemented on-line transactional processing databases using Microsoft SQL Server for new call center CRM applications across sales and service dealer operations.
  • Led development of service reminder, survey, scheduling and sales applications used by 300 seat call center using Microsoft SQL Server and Microsoft ASP.NET web user interface.
  • Worked with leading telecommunication vendors Aspect and Avaya to integrate dialer and ACD into call center applications leading to substantial growth of the company.
  • Developed ETL services to collect data from over 3000 ADP and Reynolds & Reynolds dealer information systems to feed operational data store supporting email, direct mail, and phone marketing campaigns.
  • Led proof of concept exercises to deliver targeted marketing campaigns and reporting solutions using data mining within Microsoft business intelligence stack (SSRS,SSAS,SSIS).

Software Development Manager/Engineer

Confidential, San Diego, CA

Responsibilities:

  • Led a team of 5 engineers in successful delivery of new product line.
  • Developed client/server graphical user interface for radiology department using Visual Basic, COM, ADO, and T-SQL stored procedures.
  • Designed on-line transactional relational data model using Microsoft SQL Server.
  • Conducted performance monitoring and optimization in live production environment.
  • Developed HL-7 compliant data exchange services.
  • Developed reporting solutions using Crystal Reports.
  • Presented solutions to clients and successfully led product installations at hospital sites.

Programmer/Analyst

Confidential, San Diego, CA

Responsibilities:

  • Traveled to subcontractor sites to lead engineering design documentation review and approval.
  • Developed information system solutions with Microsoft SQL Server and Visual Basic.
  • Chosen to participate with Microsoft Consulting team to automate pre-launch test checkout.
  • Completed Masters Degree in Software Engineering.

Hire Now