Professional Services Consultant
As a LinkedIn member, you'll join 150 million other professionals who are sharing connections, ideas, and opportunities. And it's free! You'll also be able to:
Along with with a degree in business / marketing, I have over 9 years of experience in a variety of areas in the technology industry with a primary focus on professional services. In addition to this, I have considerable experience in determining a solution to meet client’s needs based upon discussing and extracting user requirements and goals.
IT Professional Services, Website Design, MySQL, MSSQL, Crystal Reports, Database Design and Architecture
Privately Held; 51-200 employees; Information Technology and Services industry
February 2010 – April 2011 (1 year 3 months) San Francisco Bay Area
• Created MSSQL Reporting Services reports on both MSSQL and Oracle databases for all business needs including sales, marketing, accounting, and operations. Requirements and mock ups for reports were determined and created through discussion with department heads to determine needs and underlying issues.
• Used created reports to determine effectiveness of sales, promotional efforts, and the efficiency of operational actions. Explained findings and suggested solutions to executive level staff and business leaders.
• Assisted in project planning and requirements gathering for in house development efforts and marketing efforts.
• Developed promotional and onsite scenario logic using the ATG control center to provide onsite discounts and personalization.
Public Company; 10,001+ employees; MMI; Telecommunications industry
November 2009 – January 2010 (3 months) Sunnyvale, CA
• Generated new Crystal Reports on Motoblur service.
• Created MySQL ETL to create reporting platform.
• Presented reports to marketing and management staff.
Public Company; 1001-5000 employees; V; Financial Services industry
July 2009 – September 2009 (3 months)
• Data Analysis of Visa Global software compliance in an assistance of ITGC audit.
• Unicenter Asset Portfolio Management (UAPM) system in conjucture with IBM Tivoli and Microsoft System Center Configuration Management (SCCM) data to preform complete software compliance analysis.
• Using MySQL and associated tools to build reporting database; provides daily updates to management staff on status and issues within the UAPM system.
Privately Held; 5001-10,000 employees; Construction industry
October 2005 – April 2009 (3 years 7 months) San Jose, CA
• Performed technical support, inclusive of desktop, network, and application support, for field and office personnel in four (4) business units. Responsible for 150 users locally and 450 users regionally.
• Created Crystal Reports on all IT metrics including reports for hardware inventory, software compliance, departmental accounting and employee utilization.
• Sole responsibility to develop and maintain web based applications to assist the IT department as well as others.
*Created IT-specific policies and procedures to assist in guiding departmental adherence to management expectations. Built and maintained relationships with IT and telecommunications industry vendors to ensure responsive support and to assist in negotiation of proper pricing.
Significant Projects
• Created custom Crystal Reports to build a comprehensive inventory of computer hardware and software licenses in support of corporate internal audit. Linked Altiris hardware and software scans to Active Directory users lists, producing a computer by user report. Completed data analysis of Altiris hardware scans over the prior 12 months to determine software license usage against actual licenses purchased.
• Designed and developed and internal web suite used in managing documentation and updates of job sites IT specifications and needs, fast-reference for job site support, and user hardware/software access request management. Connected to back-end IT department matrix data for real-time, accurate assignment of active service tags, available hardware, and tied-back to appropriate purchase orders and invoices.
Privately Held; 501-1000 employees; Computer Software industry
September 2002 – October 2005 (3 years 2 months)
*Provided 3rd tier, specialized technical support for HEAT, GoldMine, and Crystal Reports to FrontRange clients and resellers. Emphasis on support surrounding database structures, data analysis, and challenges associated with custom environments.
*Developed, working directly with on-site customer engagement engineering team, custom application-metrics reports for client environments; based custom reports on client-defined functional requirements and measured success against user acceptance testing.
*Created an extensive set of reports to monitor call center metrics as used by the staff, management and executive teams. Provided daily updates to executives and management staff to show team performance against internal metrics used to measure departmental success.
Significant Projects
*Performed upgrade and/or translation of custom reports in support of internal migration from legacy HEAT ticketing application to ITSM.
*Worked with FrontRange software development team to translate existing data structures into updated format appropriate to data linking based upon proprietary data schema.
Public Company; 1001-5000 employees; Electrical/Electronic Manufacturing industry
June 1999 – August 1999 (3 months)
* Built user interface for customer-facing firmware loader, using Visual C++ 6.0. Operated independently, completing development phases on-time and on-budget.
* Designed and executed full regression testing plan for firmware loader simultaneous to retaining responsibility for coding application.