Anna Patel Email & Phone Number

Redmond, Washington, Us

Redmond, Washington, Us

Redmond, Washington, Us

Mclean, Va, Us

-Creating solutions for complex business problems by ingesting Big Data sets, creating automating Python scripts, developing SQL and batch scripts to manipulate HDFS and S3 files, and utilizing Python and Jython scripts to manipulate and analyze data-Developing software applications using SCRUM and Waterfall methodologies-Utilizing Steamsets application to ingest structured and unstructured text, csv, & xml files to a Cloudera platform that utilizes HDFS, Impala, & Hive-Writing documentation to develop, test, and document data quality and validation to be implemented in Spark prevalidation and profiling pipelines- Researching Machine Learning concepts such as regression to predict trends in data and identify potential PII- Write code in JavaScript, SQL, and some Scala to implement new software features in web application for DoD OSD client- Training junior data engineers and new data engineers to use applications and quickly and efficiently complete development tasks- Create SQL, Python & batch scripts using Python to remove control characters, re-join split lines based on column count, and sanitize data in order to fully ingest data for functional team and customers- Fix defects and Fortify SQL Injection findings to ensure code is working correctly and compliant with DoD security regulations

Reston, Virginia, Us

- Create and execute scripts for processing tasks related to various database projects- Create PL/SQL stored procedures to automate manual database tasks such as expiringrecords or appending to existing records- Execute SQL statements in order to update, insert, create, delete data invarious schemas- Serve as backup for various team members by executing SQL statements, runningprocedures, and check log files for nightly cron jobs- Troubleshooting issues with existing processes that cause errors or problems on web service applications- Refresh materialized views as needed to keep data updated for various webservices/projects- Utilize windows Powershell to run scripts and see SQL output - Embed SQL and integrate PL/SQL code within JAVA class files to allow for utilization of JAVA expressions- Utilize TOAD for Oracle to connect to databases and view database objects

Arlington, Va, Us

- Creating XML schemas for web service development and comparing data objects with java programs in Eclipse- Querying databases using SQL plus and creating advanced queries with inner and outer joins and Union statements- Verifying accuracy of DDL and DML statements using SQL Developer to ensure data was created and modified accurately when transferred from a Sybase to Oracle Database- Executing Unix shell scripting in order to tail event logs, edit files via Vi Editor, as well as execute scripts- Serving as a “product owner” by defining functional requirements into software tasks, prioritizing software functionality based on stakeholder needs, and collaborating with team members to create integrated work products- Developing and delivering briefings and presentations for stakeholders as well as facilitating meetings- Creating sequence diagrams in UML tools such as Artisan and Microsoft Visio- Providing risk assessments to stakeholders by tracking key events, voicing lags in schedule, and providing reliable solutions to avoid risks from becoming issues- Developing methods to improve business processes such as training and group cohesion

- Served as business systems analyst by gathering requirements and creating software specification documents- Aided company in achieving CMMI Level 2 maturity by serving as internal process auditor for all projects-Deciphered PL/SQL statements in order to translate code and document it in system design- Extracted data elements from XML schema files in order to document definitions and incorporate in business requirements- Represented company as point of contact and liaison on projects - Served as Data Architect by creating data dictionaries and drawing data flow diagrams in ER Studio- Tested software applications in-house to ensure business and technical needs are met- Created process DFDs in JDeveloper and Microsoft Visio

- Served as Project Lead utilizing Microsoft Project and Microsoft Visio to outline project schedule and create models of application user interface- Implemented Drupal CMS to convert company website from HTML to a web-based content management system- Recorded and developed test scripts, recruiter and management forms, issues registry, business request forms, and documentation for systems and process problems- Initiated meetings with departments for requirements gathering and analysis- Provided IT support through software configuration, creation of user accounts, and troubleshooting- Recruited qualified candidates to fill positions for government task orders

Master'S Degree, Applied Information Technology

Bachelor'S Degree, Business Information Systems