SUMMARY:

• Highly motivated professional with 25+ years in Software, Database and Architecture Development.
• Strong Mathematical, Computer Science and Analytical skills.
• Provided achievements surpassing Silicon Graphics, IBM, Tableau and Microstrategy solutions.
• Great experience in High Performance Database Driven Application development, Web, Security and Automated Systems.
• Innovations in Digital Filtering, Image Processing and Computer Graphics
• Looking for a challenging position as Data Architect or Principal Software Developer.

TECHNICAL SKILLS:

Software: Strong knowledge in Object Oriented Software Development including C#, C, C++, Java, Java Script, Perl, Python, Shell

Operating Systems: MS Windows XP, UNIX (AIX 5.3, Linux 2.6, CentOS Linux, SunOS 5.10, IRIX, RHEL)

Development Environment: Microsoft Visual Studio 2005, 2008, 2010, NetBeans 8.0.2, Eclipse 2011, IntelliJ IDEA 10.0.3, Informatica PowerCenter (IPC), IBM InfoSphere DataStage 8.5, SAS 9.2

Web Development: IIS, HTTP, ASP.NET

PROFESSIONAL EXPERIENCE:

Principal Data Architect / Developer

Confidential, Washington, DC

• Created innovative database model for TAQ (trade and quote) analytics operations.
• Optimized performance to execute TAQ analytics functions in real time.
• Designed interactive algorithms to detect prevailing quotes to match trades with the finest (up to nanosecond) world class granularity.
• Developed efficient procedures to build complete NBBO (National best bid and offer) quotes.
• Constructed, compiled and published library of Netezza User Defined Functions (UDX) to reorganize operations on trillion record Confidential (Securities and Exchange Commission) databases.
• Created UDX based unique trade and quote validation and filter algorithms.
• Refactored slow Netezza window analytic functions to efficient iterative SQL code.
• Developed complete grand expert level set of TAQ daily and intraday analytics and mathematics functions. Provided analytics functions outperform operations based on existing Confidential Perl and SAS applications.
• Developed automated cron jobs to execute daily database conversion and upload.

Principal Data Architect

Confidential, Lorton, VA

• Created automated system to compare and improve execution plans for 11g and 12c Oracle databases.
• Developed fast algorithms to reconstruct principal Confidential ADIS tables with numerous referential integrity constraints.
• Resolved critical problem with remodeling ADIS prime table keeping truck of US nationwide passenger list for 15+ years.
• Developed algorithms to upload tables with referential constraints based on efficient bulk collect and “hint” technique never used before in overall Confidential environment. Improved performance from 40+ hours to 10 minutes.
• In a short time completed about 20 different development “stories” and improved ADIS application functional quality.
• Created innovative solution to deliver “Get Travel History” project in parallel based development technique. Individually completed majority of database tasks in few Sprints instead of lengthy development.
• Simplified dysfunctional Confidential /ADIS architecture solutions. Modified convoluted, infinitely running and never ending pivot based procedures and views to run in seconds.
• Resolved a number of outstanding performance problems no one around was able to approach.

Principal Data Architect

Confidential, Ashburn, VA

• Developed Java based Data conversion application to migrate data between top popular databases including Greenplum, Netezza, Oracle, DB2, MS SQL and others.
• Automated DDL, DML and data conversion scripts for data extraction, transformation and upload.
• Developed innovative algorithms essentially accelerating database conversion time by effective MPP architecture, high performance collocated joins, optimized partitioning and fast multithread data upload.
• Developed Data Architecture for multi - platform efficient data transformation, retrieval and maintenance.

Data Architect,

Confidential, New Carrollton, MD

• Discovered inevitable problems existing in RRP and CADE2 projects developed by IBM.
• Developed innovative ETL and data injection algorithms for "real time" database upload and updates.
• Completely re-factored Rule Execution code, decreased incomplete execution time from 30+ hours to 12 minutes.
• Delivered code to get 440 CADE2 DB2 FRR reports all automated daily compare to few months of manual labor.
• Developed algorithms and demonstrated 10+ times acceleration on getting Discovery reports.
• Migrated and consolidated Confidential EFDS, RRP and CADE2 Oracle and DB2 databases to Greenplum.
• Developed innovative Fraud Detection Data Mart to detect tax violations based on illegal data.
• Updated Confidential LRA Tableau scripts to increase few times Fraud Detection report execution compare to initial model.
• Discovered performance problems and provided recommendations to eliminate excessive table decomposition, over blowing data, redundant tables and partitions, inconsistence and duplicated data across multiple Confidential sources.
• Developed applications to generate Confidential CADE2 DB2 and Greenplum production size data for performance tests.
• Provided solutions for strategic Confidential DB2 IPM, Oracle and Greenplum EFDS and RRP mainstream database consolidation.
• Generated automated tools to detect referential integrity violations across multiple Confidential platforms for CADE2 DB2 databases. Developed unmatched performance execution referential integrity scripts.

Data Architect

Confidential, New Carrollton, MD

• Developed modern architecture and applications for multi-phase parallel data extraction and upload significantly speeding up legacy database conversion.
• Fundamentally improved and decreased existing IBM/ Confidential top complexity 1040 form conversion time for the whole US nationwide taxpayer data from 24 hours to 5 minutes.
• Migrated one of the largest Confidential EFDS production database.
• Identified and tuned slowly running SQL conversion scripts. Improved performance for for numerous Confidential forms.
• Moved billions of records (about 40 TB) of Confidential legacy data to Greenplum environment.
• Fixed numerous Greenplum segment error bugs existing in dysfunctional IBM and Confidential conversion code.
• Generated automated scripts to extract, clean up and convert 2000+ EFDS-RRP Oracle tables to Greenplum.
• Implemented algorithms to compare and match tax returns and track potential fraud.
• Created high complicity ETL transformation functions for uploading FDC tables to Greenplum.
• Developed comparison algorithms for Greenplum, Netezza, Oracle and MSSQL essentially improving development life cycle.

Data Architect,

Confidential, Kansas City, KS

• Developed Confidential Netezza C++ UDF (User Defined Function) library.
• Implemented innovative high complicity mathematical non-linear equations algorithms, significantly improved UDF precision and performance.
• Provided solutions for ErlangB and ErlangC UDF functions used for detecting mobile and other electronic device exact Earth locations. Essentially surpassed existing Tableau and Microstrategy market achievements.
• Managed and developed Confidential MS SQL and Oracle databases to Netezza data migration and consolidation.
• Implemented data migration from TF12 and TF72 to TF120 in a scope of Confidential modernization program.
• Delivered solutions for data migration from MS SQL, Oracle and Netezza TF72 to Netezza TF120 including 10 top volume Confidential databases.
• Completed IBM Streams (SPL) training for Big Data multiprocessing execution.
• Investigated solutions for accelerating data upload to Confidential - FLUX and Reveal set of databases.
• Developed algorithms for extrapolating data capacity to calculate required database storage.
• Developed parallel algorithms for loading Netezza databases using IBM Streams.

Principal Software Developer, Data Architect,

Confidential, Scranton, PA

• Worked on multiple projects as Data Architect
• Developed efficient architecture solution to migrate multiple databases including MSSQL, DB2 and Oracle to Netezza and Greenplum.
• Consolidated and loaded Confidential, Confidential and Novo Nordisk data warehouses.
• Essentially Increased speed of development by constructing automated process for complete line of operations including creating target database, downloading, transferring and uploading data using advantages of parallel processing.
• Developed efficient algorithms for converting partitions, primary, unique and distribution keys.
• Implemented DBA functionality and security for Postrgres databases
• Developed efficient backup and restore algorithms for Greenplum on different levels including various databases and schemas

Senior Software Engineer

Confidential, Rockville, MD

• Developed algorithms for massively parallel processing databases - Netezza and Greenplum/PostgreSQL to convert and migrate production data warehouses received from NASDAQ, Boston and Philadelphia stock exchanges (volumes about 1 TB a day).
• Created automated algorithms for refactoring legacy application, reduce existing code up to 10 times and significantly increase reliability of ETL transformations.
• Developed efficient ETL algorithms by eliminating multi-million record temporary tables and using aliases with minimized record number data sets.
• Constructed automated algorithms for assembling and converting Data warehouse DDLs.
• Provided data modeling and improvements for NASDAQ data warehouses.
• Converted Oracle cursor based functions to Netezza taking advantage of Massive Parallel Processing in Netezza User Defined Function (UDF) development.
• Implemented high level SQL transformations in UDFs to detect NASDAQ anonymous quotes.

Senior Software Engineer / Data Architect

Confidential, Vienna, VA

• Developed algorithms for generating massive scale EDI messages used by Confidential and ATS including all boundary CAMIR, ANSI, BAPLIE and CATAIR types for IBM Message Queue servers.
• Managed EDI automated development and test process.
• Provided M1 Informatica PowerCenter (IPC) development and conversion leadership.
• Substantially improved EDI message development process.
• Developed real time C# and Java database driven applications large EDI message execution.
• Developed automated algorithms to extract and load data from Oracle, SAS and SAP to DB2 and Greenplum for D6, M1 and M2 Data warehouses.
• Migrated Customs Services legacy data center IBM mainframe databases to DB2.
• Detected and improved long-running SQL queries by creating optimal joins, table partitioning and refactoring.
• Developed triggers for optimal performance DB2 database conversion.
• Improved capacity, determined DB2 production environment extrapolated size.
• M1/M21 Ocean/Rail/Air - Executed about 4000 automated EDI test cases, detected about 250 outstanding defects
• Discovered critical referential integrity problems for the whole set of ACE applications - D5, M1, M21.
• Developed data sanitization algorithms for entire set of ACE projects including D6, M1, M2.1, D7.
• Invented strategic approach for generating Performance stress tests with Production size Oracle 10i and DB2 data bases.
• Developed unprecedented complicity Performance stress tests for ATS S2TP, S2TF, D5, M1 and M21 releases.
• Created mathematical algorithms to detect critical defects in S2TP application by discovering the most inefficient queries.
• Developed Java and C# based applications for automated testing to enhance HP Quality Center and HP LoadRunner functionality.

Data Architect

Confidential, Arlington, VA

• Developed consolidated database to migrate multiple Confidential databases (NADDIS) into one source.
• Investigated referential integrity problems in numerous Confidential production databases and created reports for top management.
• Designed data modeling algorithms for converting multiple CIA legacy databases to Oracle.
• Converted production data to prototype database.

Senior Software Engineer,

Confidential, Vienna, VA

• Invented new design for critical parts Smart 3 application.
• Created Confidential (Court Services and Offender Supervision Agency) Auto-Screener database.
• Migrated Confidential production drug offender data.
• Developed high level complicity database driven Auto-Screener Web Application.