Data Scientist Big

Sherry Nahid Fairfax, VA

Email: ******.*.*****@*****.*** Phone Number: 571-***-****

SUMMARY

Accomplished Data Scientist and Database Engineer with expertise in Extract, Transfer, Load (ETL) processes and cloud migration. Skilled in SQL optimization and data visualization, delivering actionable insights that drive business outcomes. Recognized for strong problem-solving, critical thinking, and collaborative team efforts. Developed automated reporting solutions that enhanced data integrity and streamlined operations, significantly boosting fraud detection capabilities. Experienced in the design and analysis of Big Data databases and user interfaces, with experience across a wide range of technologies including ETL, Splunk, Elasticsearch, QlikView, Power BI, Tableau, eBusiness Suite (EBS), Oracle, SQL Server, MariaDB, PostgreSQL, Cognos, MicroStrategy, and various programming languages. Extensive experience in legacy system conversions and data integration, with a focus on innovative solutions to complex data challenges.

SECURITY CLEARANCE

●Currently hold a Public Trust Medium Level Clearance (issued in 2018)

●Previously held Secret Clearance (issued in 1995)

FUNCTIONAL SKILLS

●Big Data Analytics and Visualizations

●Extract, Transform & Load (ETL) of warehouse/reporting data

●Relational Databases Architecture, Design, Tuning & Data Integrity

●AWS Cloud Migration

●Unix Shell Scripting & SQL (Oracle, SQL Server, MariaDB, PostgreSQL)

●Splunk Core Certified Power User

●Elasticsearch

●Deltek CostPoint & Contracts Management

●COTS Integration & IBM Cognos

Legacy System Conversion & System Integration

TECHNOLOGY AND TOOLS

Hardware and Equipment Unix-based servers; NT Servers; Sun and SPARCstation; DEC VAX; HP 9000

Operating Systems and Environments Unix; Linux; MS DOS, MS Windows; VMS; DEC OSF/1

Programming Languages SQL; PL/SQL; Python; R; Cognos BI; COBOL; C

Database Management Systems Oracle; SQL Server; MariaDB (20TB); PostgreSQL(20TB)

Applications Tableau; Power BI; Splunk; Elasticsearch; pgAdmin; Deltek Costpoint and Contracts; Oracle Financials; PeopleSoft; Microstrategy Design and Reporting, Oracle Warehouse Builder, Oracle Forms, Visual Studio; SQL*Loader; QlikView.

EXPERIENCE

Noblis Inc., Reston, VA 2001 - Present

Data Scientist/Database Engineer 2018 - Present

Technical lead for managing relational databases and performing ETL for User Behavior Insider Threat program

●Led the AWS Cloud migration of On-prem R, Python, SQL, and MariaDB systems to the cloud for the IRS User Behavior Insider Threat program.

●Collaborated with Fraud Analysts to investigate cyber fraud and insider threat activity within the IRS Cyber Fraud Group, utilizing advanced data extraction and analytical techniques to identify fraudulent transactions and suspicious usage patterns.

●Database Administrator for MariaDB and PostgreSQL Big Data environments with 20TB of data, overseeing cloud migration, data loading, SQL optimization, and overall database administration.

●Built Python and R-based query tool applications to streamline the investigation process for Insider Threat analysts.

●Designed and implemented a scalable, end-to-end solution for digital transaction monitoring, encompassing large-scale processing, integration, and analysis of system logs and databases.

●Developed automated ETL data ingestion workflows for cybersecurity log files, using UNIX Shell scripts, Python, R, and SQL to dynamically parse and normalize raw log data from various sources.

●Created automated Splunk reports and dashboards, streamlining monthly Cyber Fraud and Insider Threat reporting processes, enhancing data visibility, and improving quality control.

Lead Deltek Analyst/Developer 2015 - 2018

Technical lead for converting Oracle Projects and Contract Module to Deltek Systems

●Technical lead for the implementation of Deltek Costpoint and Contract Data Management. Led the gathering of requirements and mapped and transformed data for the conversion from Oracle eBS to Deltek.

●Managed and maintained Deltek Financial and Contract systems, ensuring their optimal performance and functionality.

●Automated and streamlined various user processes, improving efficiency and reducing manual effort.

●Developed dashboards using Tableau, Power BI, and QlikView for financial and budgeting tools, aggregating data from multiple sources and transforming it into intuitive visualizations. Enabled drill-down capabilities for deeper data insights and analysis.

Internal Infosys Principal 2001 - 2015

Oracle developer, applied SQL, PL/SQL, Oracle Forms and Oracle Reports to support Oracle Financials System.

●Designed and developed interfaces between financial, contract management, budgeting, and pricing systems, ensuring seamless data integration and enhancing operational efficiency.

●Provided technical support for Contracts, Projects, and HR modules in eBusiness Suite, ensuring smooth system operations and resolving any technical issues.

●Created a budgeting solution in Excel using VBA to streamline and improve financial planning and management processes.

●Led and executed the technical implementation, transformation, and integration of contract data for Oracle Project Contracts. Served as the technical lead for the eBusiness Suite upgrade from 10.7 to 11.5.5.

●Generated reports using Oracle Reports 6i and Discoverer and developed a data warehouse and ETL mappings using Oracle Warehouse Builder. In addition, developed SQR and UNIX programs for PeopleSoft to support large-scale report distribution.

●Analyzed legacy asset management and pricing databases, designing the conversion of all historical data into Sunflower and Propricer. This transformation enabled tighter integration with financial systems, enhancing data accuracy and operational efficiency.

●Led the complete upgrade of eBusiness Suite from release 11i to R12, ensuring a smooth transition and enhanced system functionality.

Century Link, Arlington, VA 1998 - 2001

Senior Technical Consultant

●Implemented conversion routines for migrating Oracle Financials Accounts Payable and J.D. Edwards GL data to PeopleSoft 7.5 using SQR, PeopleTools, and SQL. Served as the sole technical lead in the implementation of the PeopleSoft 6.1 Budget Module. Led the technical efforts in maintaining and troubleshooting the GL system, including upgrading it from version 6.1 to 7.5.

●Developed new panels and customized existing ones using Panel Designer and PeopleCode. Managed the PS Payroll to GL interface system and worked with Message and Database Agents, Business Process Designer, and Query Tool.

The MITRE Corp., McLean, VA 1994 - 1998

Senior Technical Staff

●Initiated and led the migration of management accounting reports from SQL*ReportWriter to SQR within the Oracle Financials environment. Developed the infrastructure required to enable seamless execution of SQR reports within Oracle Financials.

●Led both the functional and technical teams in converting MITRE’s customized billing modules to utilize Oracle’s billing extension. Designed, developed, and implemented billing extensions, and created detailed specifications and test plans for the team to execute.

●Served as the technical lead for multiple upgrades of Oracle Financials Project Accounting, overseeing the development of customization routines using Pro*C to meet specific business needs.

EDUCATION

Graduate Certificate, Data Analytics, George Mason University

Master's, Computer Science, Johns Hopkins University

Bachelor's, Computer Science, University of Maryland University College

CERTIFICATIONS

Project Management Professional (PMP) 2016 - Present

Splunk Core Power User 2023 - Present

ITIL 2016 - Present

Certified ScrumMaster (CSM) 2013

Contact this candidate