SUMMARY:

• Insightful, success - oriented, results-driven Analyst with over 15 years of diverse experience in IT. Seeking a dynamic environment where professional excellence, high performance and team member value are expected utilizing advanced analytical thinking, research, collaboration and interviewing skills.
• Nominated for Q1 2015 President’s Growth and Innovation Award for the Confidential Power Tools Americas Sales Analytics using Alteryx and Tableau
• Designed and developed distributed enterprise database application from concept to beta testing
• Successfully & independently implemented consulting firm supplied Excel analysis model, to a five-hospital, 60+ patient center system, previously applied to single hospital systems
• Organized smooth management of large volumes of data from multiple sources & formats incorporated in rigorous financial analysis to assess cost of five-hospital system re-engineering & integration patient care delivery system
• Designed & developed baseline Access database for clinical analysis established by corporate initiative for clinical resource management accountability. Clinical design target defined by inpatient/outpatient length of stay statistics from various system sources for analysis of effectiveness of chosen clinical pathways used in a five-hospital system relative to high-cost diseases affecting specific patient populations
• Facilitated growth of software engineering computer lab from stand-alone to fully networked & multi-platformed

TECHNICAL SKILLS:

Software Tools: MS Office Suite (Word, Access, Excel, PowerPoint, Project, Visio, Outlook) MS SharePoint, SQL Server Enterprise Manager/Analyzer Microstrategy Peregrine Asset Center IBM Maximo, MS Visual Studio 2008 TIBCO SAS Enterprise Guide 4 Alteryx Desktop Tableau Desktop/Server Oracle BI

Development Languages: Visual Basic / VBA (Access, Excel) C / C++ Pascal FORTRAN JOVIAL IBM Assembly, XML HTML Java J2EE SAS 9.1 for Windows

Databases: Microsoft Access Oracle SQL MS SQL Server (2000, 2005, 2008) SQL Query Analyzer SQL Server Enterprise Manager/Management Studio Oracle SQL Developer Windows Server 2003 Teradata 13, Teradata SQL Assistant

Methodologies: Structured Analysis and Design Full SDLC Six Sigma (DMAIC) Agile Software Development

Applications Developed: F-16 avionic hardware software simulation program Portfolio Planning and Tracking enterprise database, GPS Tracking and Scheduling database Military Parts Inventory database Sales ExcellenceReporting database

PROFESSIONAL EXPERIENCE:

Confidential, Great Falls, MT

Analytics Consultant

Responsibilities:

• Provide direct reporting and analytical data support for select supported human resource teams
• Responsible for reporting operations and automation via MS Access and MS Excel
• Partner with data analysts, technologists, and human resource partners

Technical Environment/Tools/Languages: Windows XP, MS Office 2007(Word, Access, Excel, Outlook), MS SQL Server (2008), TOAD for Oracle, Oracle, SQL

Confidential, Davidson, NC

Business Systems Analyst

Responsibilities:

• Nominated for Q1 2015 President’s Growth and Innovation Award for the Power Tools Americas Sales Analytics using Alteryx and Tableau
• Developed Americas Sales Analytics reporting automation application and data warehouse via Alteryx and Tableau
• Automate extensive manual process of manipulating Revenue and Bookings BI extracts with integration of AOP in Excel templates to produce reporting in alignment within the Americas Power Tools Sales Team organization structure
• Transformed process from manually generated Excel workbooks, to an Alteryx Analytic Application which in addition to automating the manual process seamlessly generated Tableau ready exports to refresh all dependent Tableau templates
• Transitioned access of performance information from emailed Excel workbooks to Tableau reports on Tableau Server
• Enhanced Sales Team performance with the provision of a more complete picture of Sales insights, accomplished by providing consistent data integrity, historical realignment, ease of accessibility, faster availability and timely reporting thereby enabling each to manage their accounts, targets and growth
• Increased efficiency and timeliness of availability with Sales Performance Reports published on the Tableau Server usually within 3 hours of the Industrial Segment BI Data Load availability
• Resulting data warehouse historically aligned business units, products, sales team members and channels not previously available and was utilized at across the company for business insights in Product Realignment, Demand Planning, Pricing, and Marketing

Technical Environment/Tools/Languages: Windows XP, MS Office 2007(Word, Access, Excel, PowerPoint, Visio, SharePoint), Alteryx Designer (9.0, 10.0), Tableau Desktop/Server (8.0, 9.1), Oracle BI, SQL

Confidential, Charlotte, NC

AVP - Analytics Consultant

Responsibilities:

• Responsible for consulting with partners to identify and define business requirements and translate business needs into complex analysis designs and recommendations.
• Consult with clients to design, develop and administer complex analysis designs and recommendations
• Identify and recommend data sources; compile data from multiple sources to summarize results and trends
• Ensure feedback related to quality is gathered and acted upon at critical points during projects
• Provide programmatic support for WFF conversion to MSP Reporting
• Provide analytic research and reporting support for various lines of businesses
• Designed First Touch Demand Queue Request Process
• Implemented and performed First Demand Queue Request Touch Process Touch to collaborate with requestors to gather requirements and identify data sources to provide the correct information before analyst are assigned to projects
• Created Companion First Touch Intake Request Assessment SharePoint site
• Stayed current with regulatory updates to find reporting solutions for business required changes
• Provided primary support for SPOC manager and business partner review meetings
• Demonstrated critical thinking skills with the ability to quickly recognize and resolve problems, taking ownership of issues with partners, and see them through to resolution
• Demonstrated excellence at identifying stakeholders, understanding business needs driving reporting solutions
• Managed small projects requiring coordination, resource allocation and consultation to other analysts on the team
• Performed management of the SPOC team’s demand/work queue. Created real-time updatable Demand Queue Management Tool
• Created and maintained reporting solutions for regulatory communication and other executive level reporting needs
• Data integration between SharePoint and excel

Technical Environment/Tools/Languages: Windows XP, MS Office 2007(Word, Access, Excel, Outlook, PowerPoint, Visio, SharePoint), Teradata, SAS 9.1 for Windows, MS Visual Studio 2008, SAS Enterprise Guide 4, Teradata SQL Assistant, SQL Server Management Studio, MS SQL Server (2005, 2008), SQL

Analytics Consultant

Confidential

Responsibilities:

• Took initiative with business partners to ensure requested reports are validated as accurate to avoid potential operational and/or MHA-C audit risks, communicating to users of reports when compliance issues come to light on reports. Clearly guiding them to manage operational risk
• Research current/upcoming changes to understand upstream and downstream impacts and potential risks
• Prioritize requests by complexity and expected delivery dates. Communicated encountered delays, negotiating new due dates if necessary
• Worked extensively with the business units to design and ensure new reporting meets expectations
• Define testing plan prior to implementation of change or update. Review testing plan with manager.
• Execute testing plan. Receive final sign-off from manager for all tests conducted
• Create testing documentation with before and after impacted data set values
• Continuous collaboration with business partners regarding anomalies and recommendations for implementing business requirements through monitoring reports and researching business process documentation
• Formulated initial SD 12-04 reporting criteria from high level requirements for new and modified reports
• Initiated meetings with Alert Team business partners to flush SD 12-04 criteria to lowest data element level
• Developed testing documentation and tracking tool
• Expanded work into business analysis/architect projects

Technical Environment/Tools/Languages: Windows XP, MS Office 2007(Word, Access, Excel, Outlook, PowerPoint, Visio, SharePoint), Teradata, SAS 9.1 for Windows, MS Visual Studio 2008, SAS Enterprise Guide 4, Teradata SQL Assistant, SQL Server Management Studio, MS SQL Server (2005, 2008), SQL

Analytics Consultant 1

Confidential

Responsibilities:

• Continuously communicated identified risks to business partners
• Collaborate across cross-functional business lines and investor groups to gain and share project knowledge
• Engage sponsor, key stakeholders, PM’s, SME’s and TOG to communicate effectively with all involved in the projects
• Facilitated project meetings with effective use of agendas, issues logs, meeting summary and next steps
• Partner with Business Unit to design and develop new reporting or enhance existing reporting
• Provide accurate, detailed and timely identification of impacted populations for specific reporting needs
• Identify and analyze business problems to address issues including requirements definition, process review
• Identify technical and business solutions, gathering, documenting and updating business requirements, review and create workflow process mapping
• Develop and execute test scripts
• Develop and maintain strong relationships with business partners and internal/external team members
• Identify issues and escalate/manage resolution as required

Technical Environment/Tools/Languages: Windows XP, MS Office 2007(Word, Access, Excel, Outlook, PowerPoint, Visio, SharePoint), Teradata, SAS 9.1 for Windows, MS Visual Studio 2008, SAS Enterprise Guide 4, Teradata SQL Assistant, SQL Server Management Studio, MS SQL Server (2005, 2008), SQL

Confidential, Charlotte, NC

Analytics Consultant

Responsibilities:

• Create, update, edit production development documents and reports
• Support business partner questions regarding data and analysis
• Review code for internal/external data sources, mappings, etc.
• Review and clean data to create analytical datasets
• Utilize knowledge of database structures and contents to aid in design analysis
• Data reconciliation
• Develop swim lane diagram interactions between user and various systems
• Lead requirements gathering sessions with stakeholders
• Created data dictionary for enterprise decisioning tool SQL database
• Assist in developing the reporting templates and analytics, ensuring overall delivery objectives align with reporting strategy.
• Validate criteria implementation accuracy through analysis of expected values/records in testing data sets.

Technical Environment/Tools/Languages: Windows XP, MS Office 2007(Word, Access, Excel, Outlook, PowerPoint, Visio, SharePoint), Teradata, SAS 9.1 for Windows, MS Visual Studio 2008, SAS Enterprise Guide 4, Teradata SQL Assistant, SQL Server Management Studio, MS SQL Server (2005), SQL

Confidential, Charlotte, NC

Network Data Analyst

Responsibilities:

• Performed process to generate weekly data input feeds of host records and server products; loaded data into central repository system used to bill lines of business for server hosting usage; performed weekly variance research and reporting to aid in finance trending and forecasting of product volumes

Technical Environment/Tools/Languages: Windows XP, MS Office 2007(Word, Access, Excel, Outlook, SharePoint), Nexus, Ariba, Iron Mountain, Clarity, Maximo, Peregrine Asset Center, MicroStrategy 8, Oracle Hyperion Essbase, SQL

Confidential, Charlotte, NC

Systems Analyst

Responsibilities:

• Programmatically modify an Excel-based Corporate Real Estate space utilization optimization model using Excel VBA and advanced Excel functions
• Developed complex distributed Enterprise Microsoft Access real-time strategic and tactical planning repository and management reporting application for Corporate Real Estate Strategic and Occupancy Planning and Reporting, from concept to beta-testing (functional roles: Systems Analyst, Business Analyst, Data Analyst, Data Architect, Access Application Developer, and Database Management)
• Extensive business process research to extract technical implementation requirements through collection and evaluation of forms, Excel spreadsheets, scorecards, numerous other documents and interviews with internal and external SMEs.
• Primarily end client-facing role with minimal supervision; project lead for first two months; sole developer remaining eight
• Designed and created database structures, tables, relationships, forms, queries and reports
• Developed user interface with unbound objects manipulated using VBA/SQL/queries
• Front-end / back-end distributed design
• Uploaded data from Excel files imported as Access tables, Mining of data sources using Oracle Developer SQL, Access queries and embedded SQL inside Access VBA
• Wrote and performed database functional testing specification scripts
• Presented database application to end users and senior level executives
• Automated import of Excel file data into application database populating related tables/fields using queries and VBA; export of Access tables to formatted Excel/XML files using Access VBA, VLOOKUPs, pivot tables
• Corrected xml code errors to import to Access
• Evaluated data integrity, identified, reported and/or resolved anomalies and generated quality metrics charts using Excel pivot tables
• Initiated and designed first business process flow diagram between internal/external cross-functional business units
• Effective cross functional internal business units and external partner collaboration
• Generated Excel variance analysis reports through database’s automated application export functionality using Access VBA
• Performed analysis to generate volume and activity metrics charts

Technical Environment/Tools/Languages: Windows XP, MS Office 2003/2007(Word, Access, Excel, PowerPoint, Visio, Outlook), MS SharePoint, Ariba, Iron Mountain, Oracle SQL Developer, Oracle, VBA (Access/Excel), XML, SQL

Confidential, Charlotte, NC

IT Applications Analyst

Responsibilities:

• Initiated and developed enhancement in user security reporting process
• Upgrades, maintenance releases, enhancement management, job queues and schedules
• Ensured proper administration and usage of assigned application software
• Vendor interactions for problem resolutions
• Installed application service packs and upgrades
• Effective communication with business units / Liaison with vendors for staff / Daily User assistance
• Internal customer support
• Administered user profiles and accesses / SME during security team meetings in areas of application management
• Assured expertise in administration of applications and databases / Maintained comprehensive documentation for application usage and support
• Functioned as subject matter expert in relation to application software, and other equipment operations
• Ensured proper operations of application servers and assigned equipment
• Provided input to business solutions at the departmental level
• Participated in application enhancement software evaluation process
• Planned, organized, monitored and communicated project status
• Supported the application systems team in providing timely and quality assistance in handling user requests

Technical Environment/Tools/Languages: Windows XP, MS Office, 2003 (Word, Excel, PowerPoint, Outlook), MS SharePoint, ANDAR, The Financial Edge, Campaign Reporter, Track-it, MS SQL Server 2000, SQL Query Analyzer, SQL Server Enterprise Manager, Windows Server 2003, SQL

Confidential, Great Falls, MT

Jr. Web Developer / Web Portal Analyst

Responsibilities:

• Data mining: extraction, drill-down, report preparation and presentation
• Applied established core measures from collected Confidential webmart data to analysis and reporting tool
• Performed extensive research on accuracy/consistency of data pools prior to analysis tool development; identified erroneous information via reasonableness and configuration analysis; relayed significance of erroneous configurations in data loaded to Confidential webmart and data anomalies to team members and management to engage management’s assistance to address urgency of issues; diligently followed-up with individuals identified to aid in resolution of issues
• Prepared weekly trending and ad-hoc data analysis for core metric transactions (claims search, eligibility search, and patient search) through company’s Confidential webmart
• Served as analysis tool SME during team meetings during tool development process and reporting
• Created system summary scorecard via linked Excel analysis models

Jr. Web Developer

Confidential

Responsibilities:

• Created data instances and bindings for XFDL and XFORMS using XML syntax variations for each template type
• Created SharePoint Competitors Comparison document
• Created internet application business rules documentation in preparation for application language translation
• Checked out source code from SVN into RAD 7

Technical Environment/Tools/Languages: Windows XP, RAD 7, Confidential, Eclipse, MS Office 2003 (Word, Excel, PowerPoint, Outlook),MS SharePoint, IBM WebForms, Confidential, Real VNC, SVN, XML, XFDL XFORMS, Java J2EE, CSS

Confidential, Fort Worth, TX

Responsibilities:

• Promoted from “Engineering Assistant” to Engineer Senior in less than 6 years, having 15 credits in computer science, through strong interest to advance applicable knowledge by pursuing intense self-study of company and vendor resource material
• Independently generated software data pump in one month estimated to be two-man four-month task
• Established DEC hardware/software engineering support workstation environment for 200-man project relative to: networks, cabling mediums, security, hardware, software, memory, future growth and requirements
• Facilitated growth of computer facility from one stand-alone to fully developed networked multi-platformed environment
• Nominated by Configuration Management Auditors as responsible for achieving best organized software development library

Engineer Senior

Confidential

Responsibilities:

• Generated User Manual and Software Design Documents per MIL-STD-2167A standards by abstracting requirement information through review of Pi Bus simulation model code (C), module components, data structure, input/output, error handling & flow of execution
• Engineer ( Confidential ): Conducted training in usage of Cadre Teamwork software design and Interleaf documentation software programs for Confidential . Established internal Cadre User’s Group. Produced training material, outlines and demonstration models. Provided daily user assistance for Interleaf documentation system. Created Interleaf user manual as on-line training system. Surveyed development community to report software tool needs for in-house or commercially available tools. Coordinated and set-up vendor product demonstrations and evaluations and informed user community of such. Initiated development of OFP process model resulting in implementation of a TQM Computer Resources Impact Team providing guidelines for addressing issues
• Managed a multi-platformed computer laboratory: Facilitated physical relocation of laboratory and growth from one stand-alone Micro VAX II with five VT 220 terminals to fully developed computing resources connected to five local company networks. Planned and implemented facility changes via teleprocessing and facility’s procedures, submitted requests for moves and installations, installation of data communications, electrical power and Ethernet cables. Maintained current schedules of all lab activities. Managed reservations for equipment and software. Created and maintained hardware configuration diagrams for current and future versions. Ensured operability of all computer systems: provided daily system management of all VAX equipment (recover system hang-ups/halts, monitor system activity, operation of peripherals, system backup, installed hardware & software, preventative diagnostics); user assistance; establishing lab management and user procedures; tracked system and user problems; submitted activity reports; maintained user accounts and security
• Established a DEC hardware and software engineering support environment of VAX work stations and peripherals for a 200 man project, regarding networks, hardware, cabling mediums, software and future growth capability and requirements. Directed set-up of hardware. Installed software

Software Engineer

Confidential

Responsibilities:

• Modified real-time embedded JOVIAL source components and appropriate documentation from Software Change Requests generated in code walk-throughs.
• Created test routines for unit and integration tests. Developed simulation model in VAX Pascal/FORTRAN using structured techniques.
• Analyzed system requirements to design software implementation of a special mode and define its interface to external FORTRAN environment.
• Specified execution flow, input/out, program decisions, coded, tested, documented and presented model design for acceptance