Stephen Beadencup, MA
** ******* **. *** *** • Alexandria, VA 22314
703-***-**** • firstname.lastname@example.org
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
Statistical Techniques & Methodologies
Database Design & Administration
Ad Hoc Data Report Development
Data Loading, Migration, & Cleansing
Technology & Information Management
Data Monitoring & Handling Systems
Windows 7, 8, 10; Windows Server 2008, 2012, 2016; Linux/Unix
PL/SQL, SQL, C#, Python 2.7, 3.4; Visual Basic, Access, Crystal Reports
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
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.
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.
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.
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.
Ashford University – Clinton, IA
MA in Organizational Management (2009)
BA in Organizational Management; Concentration: Political Science (2007)