TECHNICAL SKILLS:

Data: SQL MS SQL Server, MySQL, Oracle RDBMS, PostgreSQL (DML/DDL/DCL, indexes, stored procs., triggers); Amazon AWS S3, EC2, VPC, etc.; Hadoop Hive + metastore, YARN, HDFS, Tez, MapReduce; XML with XSLT/XPath/XQuery; regular expressions Java Regex, Perl Regexp (PCRE)

Procedural/Object - Oriented: Linux/GNU shell (Bash), Python 3, Visual Basic for Applications 7 (VBA/VBE), MS Windows scripting (CMD shell, VBScript, JScript, Script Host), C++, PHP, JavaScript ( Confidential )

Enterprise: JIRA (SDLC issue/bug tracking), Subversion (SVN) and Git version control (CLI, AWS CodeCommit), Remoting (SSH/Telnet, RDP, SMB/Samba), RSA/AES cryptography, MS Office with VBA

Systems: JDBC/ODBC/etc., MS Windows Server, networking and web (TCP/IP, DNS, HTTP, firewalls)

Operations: Agile, Lean Methodologies; system testing; requirements lifecycle; process improvement; auditing; Good Documentation Practices (GxP)

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

Solutions Analyst

Responsibilities:

• Develop automated testing for REST APIs
• Automate testing workflows to increase total analyst throughput without increased staff levels
• Define testing workflows usable by various analyst skill sets across different toolsets
• Define and train staff on standards for documentation and testing
• Prioritize and integrate production support with ongoing development activities
• Propose and implement proactive operations solutions (or process efficiency and quality)
• Develop “replayable” pipelines for executing tests with dynamically generated test data
• Develop JSON-to-XML tool in Python (created new software to mitigate licensing risks)
• Wrote custom HTTP client application to support flexible system testing
• Created JSON serialization format to support automated interfacing with legacy SOAP/XML API
• Identify, evaluate, and approve new software tools available for use throughout the organization
• Translate requirements into piecewise development tasks
• Manage immediate and future requirements for multiple system releases
• Elicit requirements in all development stages - initial analysis through post-release enhancement/bug fix
• Develop start-to-finish dialogue with subject matter experts to complete implementations
• Develop new requirements document format to improve development, testing, and production support wners/experts of data to properly interpret records and attributes
• Profile data sources to evaluate fitness for business and development needs
• Consume and integrate multiple upstream systems for ad hoc and Confidential

Confidential, Rockville, MD

Surveillance Business Analyst

Responsibilities:

• Write multi-stage SQL/Hive scripts (±2000 lines) against large datasets (<40 billion records)
• Prototype applications and reporting logic based on iterative user feedback
• Tune SQL and Hadoop runtime: “selective disk writing,” execution strategies, Java VM resourcing, etc.
• Use Linux Bash for data work: Python/Perl/GNU scripts, Amazon AWS CLI, database clients, etc.
• Use Confidential (JavaScript-like) to automate query execution across servers
• Implement SQL abstractions: simplify downstream logic, improve reusability, reduce development errors
• Machine learning: analyze and document Weka/R algorithms used for clustering and classification

Confidential

Responsibilities:

• Guide code development and quality control (QC) testing while advocating for stakeholder needs
• Deliver UAT and training collateral; prioritize and resolve customer concerns
• Use JIRA to lead collaboration among Business Analysis (BA), Development (Dev), and QC
• Ensure runtime performance and maintainability by advising Dev on changing business needs
• Structure and automate manual processes

Confidential

Responsibilities:

• Elicit and consult with Confidential Market Regulation directors on functional requirements
• Inform precise BRD/FRD changes from research, ad hoc analysis, user dialogs, QA feedback, etc.
• Develop expertise in U.S. Treasuries markets (primary/secondary, cash/derivative, TRACE reporting)
• Research vendor offerings for trading services in the U.S. Treasury interdealer market
• Document data flows from ETL through application output (e.g., diagrams, source-to-target lineage)

Confidential, Hagerstown, MD

Solutions Developer

Responsibilities:

• Elicit business and technical requirements through ongoing stakeholder dialogs
• Develop software specifications by analyzing SQL Server databases up to 938 tables in size
• Generate exploratory reports using SAP Crystal Reports, MS Excel, and XML+XSLT
• Produce graphical training documentation to support major releases
• Own process improvements from business objectives down to UI interactions
• Perform and document time-and-effort process analyses for improvement initiatives
• Create custom management views into transactional data for decision-making support
• Achieved 79.6% time cost reduction for monthly claims process with software-based automation
• Create user-facing reporting system in MS Excel using SQL and VBA
• Design, program, and test VBA code, multipart SQL queries, and MS Forms
• Authored 27,000-text-line Excel VBA application to semi-automate monthly insurance claims process
• Write applications and scripts in PHP, C++, JScript/JavaScript, XML, Windows VBScript, Linux shell (Bash)
• Set and execute policies regarding recordkeeping, risk management, and external communications
• Audited labor records for compliance to internal and 3rd-party standards

Confidential, Frederick, MD

Scientist I, Production

Responsibilities:

• Developed C#.NET software with 3rd party API using 92-table MS SQL databases.
• Comprehensive equipment maintenance program successfully reduced equipment failures by over 75% (Qtr/Qtr)
• Improved time cost by up to 93% for materials retrieval process with improved operational protocols
• Acquired capital assets to develop improved user-facing hardware/software controls
• Drove operations decisions through statistical analysis of biologic data (e.g., 5-P parametric analysis)
• Wrote site’s Standard Operating Procedure for Luminex technology analysis and operations