SUMMARY

• Team - Focused IT Professional wif strong interpersonal skills and a passion on delivering efficient and cost effective software solutions.
• Over ten years of experience in teh management, development, deployment, and maintenance of multiple international ERP, ETL, BI and database projects.
• Twenty years of experience successfully working in team and customer focused environments

TECHNICAL SKILLS

• Microsoft Business Intelligence Development Studio (BIDS)
• Microsoft SQL Server 2012
• SAP Business Objects
• Microsoft Dynamics SL/CRM
• PMBOK - Project Management
• Agile Project Management
• IT Project Management
• Python
• Data Analytics
• JavaScript
• HTML
• R Data Visualization
• Power BI

PROFESSIONAL EXPERIENCE

Confidential, Tucson, AZ

System Consultant

Responsibilities:

• Systems Consultant focused on teh Intergraph Public Safety Dispatch and Mobile Public Safety solutions
• Manages teh coordination and administration of complex enterprise level Public Safety projects as teh dedicated system consultant using teh noledge of Project Management, Technical Support, Software Engineering Principals, Data Mining and Analysis
• Produced technical documentation and lead corporate training
• Responsible for Black Box and White Box testing of various mission critical software systems
• Assists in managing on-going system development, administration and maintenance services
• Technical liaison between Tucson City IT, Intergraph Communications Center staff and Intergraph technical personnel
• Assist in troubleshooting issues related to Map/GIS data as it relates to teh Intergraph Public Safety software
• Lead Public speaking events to showcase company software solutions
• Lead Quality Assurance and Development of Intergraph Public Safety Solutions
• Manages and develops GUI customization work via JavaScript, HTML,XML/XAML creation/modification of various me/Dispatch and Mobile Public Safety application dialogs
• Performs analysis of data sources and processes to ensure data integrity, completeness and Accuracy
• Applies noledge of T-SQL to write and modify complex T-SQL scripts
• Applied noledge of DB backup/restore and Disaster Recovery Planning including full backup, differential backup, and log backup

Confidential, Tucson, AZ

Enterprise Management BI Analyst/ ETL Consultant

Responsibilities:

• Participated in data warehouse development to document reporting and Business Intelligence (BI) requirements; developed and modified and enhanced existing reports based on expanded Corporate data; verified information integrity; and design BI dashboards, charts / graphs, drill-downs, and dynamic reports to meet new Corporate needs
• Manages projects via Agile software methodology, supported by Team Foundation Server
• Verifies accuracy of table changes and data transformation processes, and tests changes via QA/QC processes prior to deployment
• Responsible for teh development and implementation of enterprise data warehouse (EDW) wif emphasis on data warehousing, OLAP, star schemas or reporting cubes for reporting and data analysis
• Lead Public speaking events to provide and showcase software implementation metrics for corporate managment insight
• Produced technical documentation and lead corporate training
• Manages procedures and implementation of data warehousing ETL projects including data extraction, manipulation, and cleansing tools via Agile methodologies
• Leads requirements gathering, conceptualizing solutions, and developing a framework for implementation of a SQL Server Reporting Service Reports, data warehouse, data mart, and or data web solution
• Evaluated, Analyzed and developed alternate BI Reporting solutions such as Tableau
• Facilitates data warehouse system maintenance and SQL database table changes associated wif software applications and Microsoft SSIS migration of data to data warehouse cube
• Engages in control activities to ensure data quality and adherence to enterprise data policy
• Ensures data integrity by executing necessary processes and controls around teh flow of data

Confidential, Tucson, AZ

Project Manager/ Sr. Systems Developer/ ETL Consultant

Responsibilities:

• Managed, Developed and Deployed Microsoft Dynamics SL modules to increase office efficiency and improve data reporting capabilities for various projects in teh United States, Mexico and South America.
• Analyzed and worked wif a combination of international internal and external resource teams to support, and/or developed business process improvements, create reports, or system enhancements
• Developed Business Intelligence and Report solutions for Engineering, Finance, Warehouse, Procurement, and Construction Management
• Managed and Coordinate wif network administrators, DBA’s and external software programing resources to assist wif resolving support issues, manage software upgrades, and/or system enhancements
• Perform software improvements, patches, upgrades, and/or software license purchases
• Developed and Managed Crystal (2008 and 2011), SharePoint, and Microsoft SQL Server Reporting Services Reports
• Evaluated, Analyzed and developed alternate BI Reporting solutions QlickView and Tableau
• Provided international on-call technical software support, mentorship, training, and maintenance for over 160 international users
• Conducted key Financial and Corporate stakeholder, end-user and client interviews to develop or enhance existing systems or business processes
• Provided Microsoft Dynamics data and served as for client and IT Point of Contact for SAP Business Objects Reports
• Managed ETL projects to provide multiple clients data for SAP, Ellipse, Dynamics, and Oracle system
• Utilized analysis, and research methodologies to introduce, construct, and manage new software technologies, evaluate and recommend business processes, and work toward teh development and creation of standard reports and forms to increase organizational productivity and efficiency.
• Trained and developed support material for over 160 international users through cross departmental efforts
• Validated monthly Financial Cost data reports wif Cost Department, Project Managers, Procurement leads and International clients
• Applied noledge of DB backup/restore and Disaster Recovery Planning including full backup, differential backup, and log backup

Confidential, Tucson, AZ

Systems Analyst / IT Consultant

Responsibilities:

• Collaborated wif Information, Educational and Medical departmental Managers to deploy Microsoft Business Productivity Online Standard Suite for faculty and Staff.
• Interacted wif staff to learn and document requirements used to produce business documents.
• Wrote technical requirements and utilized Microsoft Project to ensure teh system met user requirements and was deployed under budget and ahead of schedule.
• Interact wif designers and internal system developers to understand software limitations.
• Assisted programmers and managed project schedule during system development.
• Perform system testing and resolved software and hardware issues.

Confidential, Tucson, AZ

Support Analyst

Responsibilities:

• Provided quality and professional IT Customer Support to ensure users maintain optimal productivity.
• Monitored and efficiently resolved halp desk tickets generated from phone, email, web, and voice mail from 5 national properties.
• Utilized remote VPN technologies to monitor, manage, and maintain software environments.
• Maintained and repaired problematic software and PC hardware and ensured virus definitions and software patches were up-to-date.
• Prioritized customer service, document support resolutions, implemented best troubleshooting methodologies, and followed Help Desk procedures.

Confidential, Tucson, AZ

Project Lead / Data Analyst / ETL Specialist 

Responsibilities:

• Developed and deployed technology for teh COPLINK® program
• Designed, analyzed, tested, deployed and administered regional information sharing systems for over 26 national law enforcement agencies resulting in over 1.3 million dollars in revenue for KCC
• Responsible for teh analysis, evaluation, data cleansing and transformation of Law Enforcement data from diverse relational database systems
• Planned and implemented QA/QC practices to ensure projects successfully progressed through all phases of teh System Development Life Cycle
• Installed, configured, and managed SQL Server Management Studio 2k to 2k8, AS/400, and Oracle 8i-11g databases
• Analyzed various RDBMS via data mining to construct XML maps to facilitate in teh migration of data from an Oracle/AS/400/MS Access/SQL Server Database to a SQL Data Warehouse
• Configured, tested, and established network connectivity between multiple and diverse relational database management systems for teh migration of source data to a SQL 2k to 2k8 database