Consultant Resume
SUMMARY:
Confidential has a diverse range of experience in systems analysis, software development, quality assurance, and database management. He has an educational background in biochemistry and technical experience in environmental science. He is seeking a mid - level Data Analyst role with a growing company where he can continue to innovate and increase his depth of experience.
SKILLS:
Data Analysis
Data Analyst, database, Microsoft Access
MS Access, MySQL,Oracle, SQL, API, C/C++,C++, FORTRAN
Python, Pandas, Pycharm, Structured Software
Software Development, Systems Analysis
VBA, Data Quality
JIRA, Selenium, Data Sources
Command Line Interface, User Interface Life Cycle
Amazon Web Services
AWS, Microsoft Dynamics, Dynamics, Eclipse
Java, Technical Support, Linux, Linux/Unix, unix,Qlikview
Web Services, Emission, Simulator, Industrial Processes, Geology
EXPERIENCE:
Confidential
Consultant
Responsibilities:
- Perform data analyses for litigation and probate cases, such as tabulating financial records and calculating assets and liabilities
- Maintain the law firm's client filesystems in both physical and electronic formats
Confidential
Data Analyst / Python Developer
Responsibilities:
- Supported up to four workgroups at a time, on both short - term and long-term projects
- Assessed project status and priorities through weekly check-ins
- Wrote scripts in Python and VBA and committed code changes to GitHub repositories
- Managed projects and tracked task progress using the Agile workflow with Atlassian JIRAPROJECT HIGHLIGHTSMining EPA Emissions Data Sources - Standardized Emission and Waste Inventories (StEWI) Prepared EPA data sources for creation of life cycle inventories, composed of inputs and outputs for a system of connected processes
- Developed Python scripts to retrieve raw emissions data and convert into a standardized formatCloud Computing - NanoQSAR / Analytics Notebook
- Ported R code into Python using Jupyter as part of a pilot project for Analytics Notebook Wrote standard operating procedures and guidance for specific tasks
- Tested scripts in both local and cloud computing environments (AWS)
- Tested parallelization of processes with sample dataPopulating Databases from Lab and Field Reports - Great Lakes Sediment Database (GLSED)
- Led Python development project for validating Excel data which was to be imported into Access and Oracle databases
- Imported data from lab and field reports into Access databases
- Testing Application Ported from Fortran to VBA - Hydrologic Evaluation of Landfill Performance (HELP)
- Contributed code in VBA for Excel to read and validate data formats
- Performed extensive tests of user interface and data import
Confidential
Data Analysis Contractor
Responsibilities:
- Provided technical support to the Systems Analysis Branch (SAB), in the Sustainable Technology Division (STD) of the Office of Research and Development (ORD)
- Modeled unit processes to analyze connected inputs and outputs of a system in a variety of applications for Life Cycle Assessment (LCA)
- Tested and reviewed software products for quality assurancePROJECT HIGHLIGHTSProtocol for Developing Input - Output Models of Industrial Processes - Life Cycle Inventory (LCI)
- Wrote a Batch wrapper script to provide a command line interface for database import with a Java plugin
- Developed a template for creating new unit processes in a Life Cycle Inventory database
- Managed backend databases using SQuirreL SQL ClientModeling Onroad and Nonroad Motor Emissions - Motor Vehicle Emissions Simulator
- Configured run specifications for simulation of vehicle fleets and non-road equipment
- Wrote SQL scripts to process output data from a MySQL database
- Calculated pollutant emission factors of a given vehicle or equipment type at the national fleet level and for several statesModeling Pesticide Releases to Soil and Groundwater - PestLCI
- Contributed updates to an EPA version of PestLCI in Excel, in order to improve the output data quality for use in other EPA projects
- Compiled meteorological and agricultural data from sources including NOAA, NASA, USDA, and CROPWAT software, which are used in the emission calculations
