SUMMARY:

Obtain a Data Analyst position with an established firm that will enable me to use my skills and experience to make a significant contribution to the company’s goals, as well as, provide opportunities for career advancement.

SKILLS & ATTRIBUTES SUMMARY:

• Expert written & verbal communicator
• Broad technical knowledge in mapping
• Expert in planning/managing projects
• A team player, strong interpersonal skills
• Strong skillset in data analysis/reporting
• Highly organized with attention to detail
• Customer focused, service oriented
• Interacts well with field & management
• Self - starter who thrives on challenge

SOFTWARE & SYSYEMS:

Software tools: Microsoft Office (Word, Excel, PowerPoint, Visio, Project, Access), ESRI ArcGIS, ESRI ArcMap, AutoCAD, ServiceNow, ADDM, SCCM, RV Tools, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), MS Power BI, Adobe (Illustrator, Photoshop, Acrobat, Visual Studio) and Crystal Reports. Database systems and platforms including MS-SQL, MySQL and Oracle database engines (RDBMS), GPS field devices, Windows OS, Sharepoint, and AWS Cloud Services.

PROFESSIONAL EXPERIENCE:

DATA ANALYST

Confidential, Annapolis, Maryland

Responsibilities:

• Provide database management, data transformation, analysis, and reporting services to ensure timely completion of electronic data deliverables EDD) for a firm engaged in the migration of infrastructure assets of public and private sector companies.
• Conduct data acquisition including data discovery and collection of field and site data. Convert Access and My SQL databases for ingestion into MS-SQL, analyze and reconcile data, as well as, prep and import data. Perform data quality control and audits.
• Use ServiceNow, SCCM, ADDM, RV Tools, as well as, ITIL, ETL, and ITSM tools to manage, merge, update, extract and interpolate asset data. Manage project CMDB to maintain real-time service catalog of hardware, software and infrastructure assets.
• Use ArcGIS to generate coverages, change projections, as well as, conduct spatial and statistical analysis for project planning.
• Use ArcMap to import and spatial data, create thematic maps, and manage geodata versioning. Use Power BI to develop reports for analytics and visualization. Use PowerPoint and Photoshop to prepare weekly and monthly presentations for project teams.
• Use SQL Server Management Studio (SSMS) to create and manage MS-SQL databases for customer assets and maintain linkages between tabular and spatial databases. Perform database backups. Manage user accounts. Write, edit and maintain SQL queries.
• Use Visio to design and document data processes and management workflows. Use Excel and Visual Basic (VBA) to develop templates and macros to automate import of large datasets and ensure timely completion of electronic data deliverables (EDD).
• Use SQL Server Reporting Services (SSRS) and Power BI to develop and publish standard and ad-hoc reports that integrate tabular and spatial data into project dashboards for visualization and statistical analysis. Export custom datasets for advanced analysis.
• Manage Sharepoint project sites and develop libraries, lists, dashboards and forms. Document workflows and best practices.
• Travel to client locations in the United States to meet with customer representatives to inventory, assess and manage asset data.

BUSINESS ANALYST

Confidential, Houston, Texas

Responsibilities:

• Provide data management and analysis for oil/gas services firm engaged in field services and management of drilling and wellhead sites.
• Plan and manage projects for the capture, conversion, spatial analysis, assessment and reporting of location and event data.
• Travel to field locations for data collection. Use GPS devices to collect spatial data.
• Use Excel to collect, import and update tabular data.
• Use ArcMap to import geographic data, interpolate point data, prepare maps, conduct spatial analysis and manage GIS data.
• Design, develop and document Excel templates, macros and workflow processes to collect, import, assess and report facilities operations and environmental data.
• Document metadata for GIS data sources and data attributes. Train teams in data processes.
• Design, develop and document .Net applications using Visual Basics (VB.net) to review, evaluate and assess customer site data.
• Maintain Sharepoint libraries. Create lists, libraries, forms, and workflows. Design site structure and visual appearance.
• Use SSMS to manage master MS-SQL databases (tabular and spatial). Use Access to create and manage project asset databases.

BUSINESS/DATA ANALYST

Confidential, Houston, Texas

Responsibilities:

• Provide analysis and reporting for an oil/gas services firm engaged in the management of global drilling and field operations.
• Use SCADA and field management system to perform data acquisition for remote sites. Use Excel to prepare and input field data.
• Use ArcView GIS to import and manage spatial data and perform mapping of assets and site data.
• Coordinate updates and corrections with project teams to ensure maps, databases and reports are accurate and up-to-date.
• Support business development team with proofreading, input and review of RPPs and proposals. Use PowerPoint to create customer presentations and conduct technical demonstrations of services and electronic data deliverables.
• Use SSRS and Crystal Reports to develop dashboards and reports for decision support, visualization and data analysis.
• Travel internationally to complete project work at field locations in Asia Pacific, Europe, North America (US and Canada).

SENIOR GIS ANALYST

Confidential, Denver, Colorado

Responsibilities:

• Perform analysis for a firm engaged in publishing geospatial data and petroleum information, and performing GIS services.
• Gather, convert, analyze, and import spatial data collected by field data team. Use ArcView GIS to digitize paper maps and convert historical geographic data to electronic spatial data. Use Arcinfo to perform projection changes and generate coverages.
• Coordinate updates and corrections with project teams to ensure maps, databases and data sets are accurate. Define workflows for processing and loading data. Perform quality control using Excel to export, review and audit data attributes for data correction.
• Use ArcView to create thematic maps for customer projects that adhere to data standards and map theme requirements.
• Provide support and to engineering and field team users to assure consistency with company standards and practices.

TECHNICAL WRITER/ GIS ANALYST

Confidential, Houston, Texas

Responsibilities:

• Provide documentation and GIS support for energy firm engaged in natural gas pipeline construction and operations.
• Travel to remote locations throughout the United States to perform data collection of pipeline facilities and infrastructure. Analyze, correct and remediate data using Excel. Convert and import tabular data into MS-SQL. Import spatial data with ArcView.
• Use Crystal Reports and Excel to prepare tabular reports. Use Adobe Illustrator and Photoshop to develop visual aids and graphics. Use ArcView GIS to prepare maps. Use PowerPoint to develop presentations for planning, analysis and decision support.
• Digitize infrastructure from paper pipeline maps to convert paper-based map records to digital GIS data.

TECHNICAL WRITER

Confidential, Houston, Texas

Responsibilities:

• Document operations and processes for firm engaged in the global decommissioning and remediation of environmental sites.
• Interface and collaborate with management, engineering and field personnel, conduct interviews, and perform research in order to develop technical content and graphics. Use Photoshop to edit and process satellite imagery and site photographs.
• Use Microsoft Word to write technical documents, manuals and standard operating procedures (SOP) for field teams conducting environmental remediation and decommissioning of nuclear facilities, chemical/ explosive munitions sites, and weapons facilities.
• Use ArcView GIS to import, map and analyze imagery and spatial data to document and test geodata management processes.

TECHNICAL WRITER

Confidential, Houston, Texas

Responsibilities:

• Provide documentation and support for energy services firm engaged in oil and gas manufacturing and environmental services.
• Use Microsoft Word to write operations and maintenance manuals. Use Adobe Illustrator and Photoshop to produce graphics and illustrations, as well as edit photographs. Use AutoCAD to prepare site drawings and process & instrumentation diagrams.
• Collaborate with engineering and field teams to compile field and technical data in order to document services and operations.