SUMMARY

• Improve bottom line with automation and business intelligence.
• Forward - thinking solutions creator who uses multiple cutting-edge technologies to improve processes and drive business.
• Expert in using enterprise applications, creating data warehouses, and utilizing variety of tools for automating processes and creating reports, KPIs, and actionable metrics to drive business decisions.
• Skilled at creating dashboards that drive instant decision making and lead to better results.
• Solves complex business problems, exceeding expectations and return on investment.
• Superb communication skills.
• ITIL Certification in IT Service Management

TECHNICAL SKILLS

Languages: T-SQL | PowerShell | .NET | Web service and API utilization

Platforms: Microsoft Windows | Microsoft SQL | Microsoft SharePoint

Applications: Visual Studio | IIS | CA SDM | CA ITCM | CA APMCA Service Accounting | CA CMDB | CA Spectrum

Databases: SQL database administration | SQL database designData warehousing | SQL Server Reporting Services | SQL Server Integration Services | ETL | Business intelligence design and analysisOracle | SQL*Plus

Tools: Process design | Process automation | Process streamlining Dashboard, KPI, and Metric Design

Other: Cross platform, application, and software integrationIT asset management | Incident/Change management

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

IT Systems Analyst

Responsibilities:

• Developed business intelligence system for real time well data, resulting in discovery of over $1M annually of unrealized revenue.
• Recipient of BHI ROS Innovation award.
• Developed integration system between MS Exchange and CA Service Desk Manager to automate creation, updates and tracking of service incidents, reducing 80 to 100 man hours monthly for Real Time Monitoring Team.
• Worked with stakeholders, business and process owners, and team members from analysts to vice presidents to gather requirements, build customer use cases, and make suggestions for deliverables.
• Built database structure and schema, including triggers, stored procedures, t-sql, dynamically created SQL code, and other functionality to fulfil requirements, in Microsoft SQL Server 2005, 2008, and 2012.
• Used Powershell and Exchange Web Services to retrieve, process and incorporate external data from CSV and Excel files into data warehouse.
• Used SQL t-sql, linked server objects, designed SSIS packages and store procedures to perform ETL functions and integrate data from source SQL and Oracle servers.
• Designed and implemented maintenance plans within SQL to ensure proper backups, index upkeep, and performance monitoring and ensuring compliance with IT security policy.
• Built advanced stored procedures to process data within warehouse to generate periodic emailed reports for various needs. Email sends directly from the server utilizing internal dbMail function.
• Developed multiple on demand reports with SSRS, BIDS, and Visual Studio - including drill down, charts and graphs, selection criteria and other functionality.
• Developed executive dashboards by integrating into SharePoint and using PowerView. These include charts, graphs, and ArcGIS ESRI maps to display geolocation data visually.
• Used SSIS, created connections into SharePoint to gather user required input required for certain datasets within the warehouse. These SSIS packages allowed movement of database back and forth between SharePoint and the warehouse.
• Design of websites for searching, data display, and access using ASP, HTML, IIS with database integration.
• Used PowerShell, Visual Studio, SQL, web services, APIs, and other tools to create automation for processes based on feedback from team members.

ITAM Support Engineer

Confidential

Responsibilities:

• Designed infrastructure for data warehouse hardware, including developing requirements for storage, IOPS, thru-put, and processing needs for RFP of server hardware.
• Developed and implemented data warehousing and business intelligence system for ITAM, correlating data from various systems across the environment. Resulted in significant savings in IT asset management, as well as major improvements in security, compliance, and disaster recovery areas. Focus on process streamlining and automation.
• Designed and implemented ITAM infrastructure and process, allowing Baker Hughes to be noted by Gartner as Best in Class for Asset Management.
• Developed automatic IT Asset ordering process, significantly reducing man hours as well as improving delivery times for new assets to customer.
• Worked with stakeholders, business and process owners, and team members from analysts to vice presidents to gather requirements, build customer use cases, and make suggestions for deliverables.
• Built database structure and schema, including triggers, stored procedures, t-sql, dynamically created SQL code, and other functionality to fulfil requirements, in Microsoft SQL Server 2005, and 2008.
• Used Powershell and Exchange Web Services to retrieve, process and incorporate external data from CSV and Excel files into data warehouse.
• Used SQL t-sql, linked server objects, designed SSIS packages and store procedures to perform ETL functions and integrate data from source SQL and Oracle servers.
• Designed and implemented maintenance plans within SQL to ensure proper backups, index upkeep, and performance monitoring and ensuring compliance with IT security policy.
• Built advanced stored procedures to process data within warehouse to generate periodic emailed reports for various needs. Email sends directly from the server utilizing internal dbMail function.
• Used SSIS to create connections into SharePoint to display datasets in portal lists. These SSIS packages allowed movement of database back and forth between SharePoint and the warehouse.
• Design of websites for searching, data display, and access using ASP, HTML, IIS with database integration.
• Developed multiple on demand reports with SSRS, BIDS, and Visual Studio - including drill down, charts and graphs, selection criteria and other functionality.
• Fully automated IT Asset desktop/laptop procurement process using CA UAPM API, SharePoint integration with SSIS, and change order creation with CA SDM web services. System orders standard systems based on stock levels within UAPM location and asset status information.
• Developed ETL and t-sql based processes integrating with CA SDM to load configuration item information in CMDB from data warehouse.

Confidential

Technical Analyst

Responsibilities:

• Worked with stakeholders, building ITIL compliant design of process and tools, ensuring all business functions included.
• Collaborated with vendor, ensuring process. Designed and implemented integration between Service Desk and ACD.
• Analyzed, designed, and implemented improvements to infrastructure including hardware recommendations as well as configuration of clustering for database and application servers and load balancing lay out.
• Developed database driven, web based applications, streamlining processes and increasing effectiveness of support personnel.
• Designed database structure in Oracle to support web applications built for global support teams.
• Designed and implemented automated web based process for managing user rights on global hardware assets of 40,000 endpoint.
• Coordinated tier 3 support if required to bring resolution. Served as interim supervisor of team of 10 support technicians. Supervised team of 4 after hours support personnel.
• Earned ITIL Certification in IT Service Management.