Senior Data Architect Resume
Fredericksburg, VA
SUMMARY:
- A skilled leader and accomplished IT professional with 20+ years of experience, including 10 years of “Big Six” consulting.
- Experience with clients across a variety of industries including Federal Government/Agencies, Telecommunications, Utilities, Financial Services, Life Sciences, Banking, and Health Care.
TECHNICAL SKILLS:
Operating Systems: Linux, Solaris, AIX, Windows
Databases: Oracle 9i, 10g, 11g (RAC), 12c(RAC) SQL Server, MS Access, DB2, MySQL, Sybase
PostgreSQL: Detailed well - known
Software /Products/eCloud: Oracle E-business Suite 11, 12
PROFESSIONAL EXPERIENCE:
Senior Data Architect
Confidential, Fredericksburg, VA
Responsibilities:
- Prepared the data for using it in frame of Big Data and Elsaticsearch stack technology.
Senior Data Scientist/Data Architect
Confidential, Falls Church, VA
Responsibilities:
- Worked with Hadoop (Hortonworks frame) in RedHat 6 environment on AWS EC2
- Installed Ambari and used it for monitoring ecosystem
- Created a menu - like command line interface for HDFS (using Python and Shell) which remarkably improved productivity of data engineers supporting Hadoop; used this tool for such support
- Created a menu-like command line interface for Kafka (using Python and Shell) to manage Kafka
- Researched performance of MySQL vs the BRO IDS application in ingesting-retrieving log files
- Created a menu-like interface for data analysts (Python, Shell); using this interface, the data analysts retrieved information from the BRO IDS log files and compared the retrieving performance with performance of standard Window base applications such as WireShark
Senior Principal Engineer, Systems
Confidential, Springfield, VA
Responsibilities:
- Supported RAC Oracle databases (27+ Tb) for the ArcSight application as Oracle DBA and Data Architect in Unix (Solaris) environment on Oracle Super Cluster computers. Remarkably improved the database performance
- Built the menu-like command line interface (CLI) for monitoring cells in Oracle Exadata (Python, shell)
- Researched the statistical relationships between the Oracle Exadata cells and Oracle database servers (Python, Gnuplot)
- Significantly improved the DBA productivity while decreasing person-hours by automating DBA job through Python scripts implementation for Oracle RAC utilities.
Project Associate7 on Data Architect/Oracle DBA Roles
Confidential, Rosslyn, VA
Responsibilities:
- Increased productivity across client systems by supporting various Oracle databases with RAC (Oracle 9i, 10g, 11g, and 12c) on Unix/Linux/Windows servers in development, testing, and production environment.
- Ensured accurate/on-time completion by writing technical documents for managers/database administrators.
- Significantly improved productivity while decreasing person-hours by automating DBA job through database and shell script implementation.
- Facilitated the success of PeopleSoft and Education Logic Model in the development, testing, and production environment as Application Database Administrator.
- Increased database productivity on the DISA STIG (Security Technical Implementation Guide) by 25-50 % and on the supporting OEM 12c by 20-25 %.
- Maximized available disk space capacity around all computers in a Data Center by designing and implementing capacity management system that enhanced disk space control.
- Facilitated the effective use of Oracle E-Business Suite 11i as Application DBA.
- Led the effective merging of nine SQL server databases into one, including data analysis, database structure design, and ER diagram creation/updates.
- Wrote documents describing design of this merging and instructions for developers who use the Visual Studio (Microsoft .NET)
- Provided essential data for key monetary decision-making by designing, developing, and creating a database with warehouse database structure for a general econometrical model of the Information and Communications Technology (ICT) Sector.
- Ensured accuracy by adjusting the International Standard Industrial Classification (ISIC v4) to Jordan ICT and applied the designed database to the ICT sector of Jordan using the adjusted ISIC v4 data and client documents.
- Improved organization/operations by designing forms to aid in the registration of Jordan ICT-area businesses.
- Wrote documentation for management and technical personnel
- Decreased online transaction processing time (90%) by redesigning DLIS processing application
- Migrated the Ariel Research Lab Dangerous Goods Transportation database from SQL server to Oracle.
- For the “System for registration of US citizens abroad” project, improved access to data by analyzing 230+ out-of-synch databases, pinpointing problem, and re-synching them.
DBA
Confidential, Reston, VA
Responsibilities:
- Bolstered the DB2-Oracle conversion productivity by over 50% by developing automated conversion process and creating a GUI tool.
Senior Consultant on the Oracle DBA
Confidential, Armonk, NY
Responsibilities:
- Reduced downtime by providing 24X7 remote support of clients’ Oracle databases in tightly controlled development, testing, and production environment across AIX, Sun, Linux, and Windows operating systems.
- Increased DBA user support activity by 20%+ by creating GUI Change Password Helper to manage passwords.
- Boosted DBA support activity by more than 30% by developing shell/PLSQL programs that stopped and reported time-consuming Unix processes.
Team Lead
Confidential, Silver Spring, MD
Responsibilities:
- Redesigned the process of transferring data from various servers in the FAA network, migrated Oracle 8.0.5 on UNIX to Oracle 8.1.6 on WinNT, and lead the DBA team.
Team Lead
Confidential, Redwood City, CA
Responsibilities:
- Led integration of Oracle Financial Application with more than 250 access-based Helena Chemical Financial remote applications as technical lead.
- Improved data accessibility by leading the conversion of Sybase-based legacy applications to Oracle Manufacturing and developing deliverables compliant with Oracle Application Implementation Methodology.
- Dramatically boosted productivity by designing GUI tools that controlled data transportation for Helena Chemical and creating Pro*C or PL/SQL source codes that allowed no-code programming for Georgia Tech.
- Improved accuracy and compliance by participating in GAP requirements analysis; conceptual, detail, and physical design; implementation; conversion; and customization of Oracle Financial Applications
- Participated in GAP/requirements analysis; conceptual, detail, physical design; implementation; conversion; and customization of Oracle Financial Applications; mostly concentrated on Purchase Orders, General Ledger, HR, Inventory, Order Entry, Project, Accounts Payable, Alert, Bill of Materials.
Senior Researcher
Confidential
Responsibilities:
- Lead of a team, which built econometrics models on macro level. The team included economic researchers from countries departments of the Institute as well as programmers from the System Analysis department. The following models were designed and implemented:
- Dynamics of industrial outputs of an economics system, which does not have own oil resources, when the oil import is sharply decreased. This simulation uses the open Leontief Input-Output model for the Japanese data; the model can be used for any oil depended economics which has needed data (input-output matrix); used the linear programming part of MatLab, FORTRAN.
- The long-term simulation of Japanese economics with the various scenarios of the oil import trends; used Statistica, Visual Basic, SPSS; the model was used in the situational analysis of the USSR-Japan relationship.
- International trade (export/import) models between Russia and Japan, between Russia and India, between Russia and OPEK countries; used Statistica, Visual Basic, SPSS; these models were used in the situational analysis.
- Built a model of political relations between two countries (see My Publications); applied this model for simulating the India-Pakistan conflict in 1965 year (see My Publications); used the differential equations part of MatLab, Maple, MathCAD, the automata theory.