Stephen Beadencup, MA

** ******* **. *** *** • Alexandria, VA 22314

703-***-**** • ac4xpp@r.postjobfree.com

Data Engineer

Technically savvy, self-directed professional with hands-on experience in ETL processes, workload automation, data analysis, data audit and quality, and database administration, including the creation, maintenance, migration, and cleansing of SQL databases. Stellar performance in positions requiring strong analytical and problem-solving skills. Able to ensure the integrity of data in extracting, processing, storing, manipulating, and analyzing. Proficient in analyzing data, interpreting results, and formulating written summaries of findings. Strong communication and interpersonal skills.

Areas of Expertise:

Data Integration & Analysis

Raw Data Transformation

Data Quality & Integrity

Workload Automation

Statistical Techniques & Methodologies

Database Design & Administration

Ad Hoc Data Report Development

Data Loading, Migration, & Cleansing

Technology & Information Management

Data Monitoring & Handling Systems

Technical Proficiencies

Platforms:

Windows 7, 8, 10; Windows Server 2008, 2012, 2016; Linux/Unix

Programming:

PL/SQL, SQL, C#, Python 2.7, 3.4; Visual Basic, Access, Crystal Reports

Tools:

Oracle SQL Developer, Toad, IBM InfoSphere DataStage, Aginity Workbench for IBM Netezza, Visual Studio 2017, SQL Server 2008, 2012, 2016; SQL Server Management Studio, Able2Extract PDF Converter, OmniPage PDF Converter, Oracle VM VirtualBox, Microsoft Office, SharePoint, Jira, Confluence, Putty, WinSCP, PowerShell, Active Directory, SAP Crystal Reports, Durkin Impact Reports, Google Analytics, MatchIT Data Quality Suite, ACT v16, Kleopatra, Northwoods Sales Automation Manager & Mail Merge, Photoshop, Acrobat, Filezilla, MicroStrategy, Able2Extract PDF Converter

Professional Experience

Amyx, Inc. / Securities and Exchange Commission, Reston, VA

Data Engineer, 9/2016 to Present

Currently fulfilling contract at the Securities and Exchange Commission (SEC) focused on enhancing data quality and data integration at the Center for Risk and Quantitative Analytics (CRQA). Assist CRQA Data Quality Manager in development and implementation of data profiling and cleansing plans, with specific focus on trade blotter, blue sheets, bank statements, credit card statements and phone record data related to SEC investigations. Interface daily with business leaders to understand data quality and cleansing goals. Conduct thorough data audits to identify data issues, errors, and redundancies to be corrected; and work with analysts and attorneys on all cleansing actions. Attend data quality meetings to deliver data cleansing presentations and provide status updates on projects. Submit weekly data quality reports to senior management.

Key Contributions:

Utilizing IBM Datastage, created and deployed automated ETL processes to cleanse, format and export files from Oracle and send the files to analysts and attorneys in various formats (Excel, .csv, text) for analysis.

Constructed Oracle database for archiving cleansed data. Continue to maintain and manage this database.

Created data compiling and formatting macros and queries to enable analysts to work with greater speed, accuracy, precision, and efficiency.

Trained data cleansing team members in use of IBM Datastage and Oracle SQL Developer. Additionally provided training on operational workflows, data governance, and quality control.

Quickly hit the ground running and made valuable contributions from day one, establishing reputation as a highly knowledgeable and driven team member.

Earned positive feedback from colleagues and management for strong work ethic, productivity, positive attitude, and collaborative work style.

Meridian One Corporation, Alexandria, VA

Senior Data Analyst, 2008 to 2016

Maintained, updated, migrated, and cleansed Oracle database information while ensuring data integrity for a creator, marketer, and manager of member benefit programs. Acted as primary contact for computer hardware and software support to 40 end-users. Communicated with IT vendors to report issues impacting user community. Served as the organization’s primary source for providing ad hoc, daily, monthly, and quarterly data reports for management review. Audited and transmitted daily file and managed rejects. Loaded monthly revenue, customer transactions, daily leads, and outbound call campaigns using DataStage. Created, modified, and scheduled automated reports. Compiled call center phone logs and Internet activity reports for management. Provided support in areas of computer hardware / software, server maintenance, and phone equipment.

Key Contributions:

Completed comprehensive database upgrade to optimize user experience, resulting in a more dynamic, business-friendly platform and interface.

Took on responsibility for database programming, which reduced reliance on third-party vendors, enhanced turn-around time, optimized resources, and minimized expenditures.

Consolidated all departments into one database with increased productivity and improved functionality.

Delivered accurate reports on a consistent basis outlining daily, weekly, and monthly sales progress.

Instrumental in consolidating numerous data-related procedures to improve accuracy and efficiency.

Demonstrated ability to learn tasks and responsibilities of the position at a faster rate than predecessors.

Top Shelf Closets and Cabinetry, Inc., Morgantown, PA

Senior Designer, 2002 to 2008

Designed and presented computer-aided designs, ideas, and quotes to residential and commercial clients for a producer of full-color line of custom closet systems. Demonstrated outstanding product knowledge and design skills to devise solutions based on the client needs. Revised and finalized designs for manufacturing process. Maintained project database with daily updates of schedules and inventory. Consulted with management on technical issues.

Key Contributions:

Served as Design Lead for HGTV’s Mission Organization.

Helped refine manufacturing paperwork processes for accuracy and efficiency.

STAPLES, Indiana, PA

Sales Technician, 1998 to 2002

Performed software / hardware installations, technical troubleshooting, and inventory assessments for the world’s largest office supply retail store chain. Carried out all aspects of customer support, help desk management, and auditing.

Educational Background

Ashford University – Clinton, IA

MA in Organizational Management (2009)

BA in Organizational Management; Concentration: Political Science (2007)

Contact this candidate