| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Senior Data Architect Data Modeler SQL Database Developer Software EngineerNew York, NY PHONE NUMBER AVAILABLE EMAIL AVAILABLE Candidate's Name &#Street Address ;s LinkedInCAREER SUMMARYI am one of the three data architects who built the New York Stock Exchange s CIF20 database. I conceptualized anddesigned the database s centerpiece, the Events Table, where all the NYSE trading information was processed for 15 years.My work at the NYSE pretected investors and market integrity. It is one of my career s defining moments.TECHNICAL SKILLSRDBMS: Microsoft SQL Server, IBM DB2/Netezza, Cloudera Operation Database (OpDB), OracleDatabase Design Tools and Data Modeling Software: SQL, ErwinProgramming Languages/Development Tools: SQL, Oracle PL/SQL, Extract, Transform and Load (ETL) design toolsincluding Python, PL/SQL, C++, C,Data Modeling for Database and Data Warehouse Designs: Star SchemaPROFESSIONAL EXPERIENCEE*Trade for Morgan Stanley, Jersey City, NJ May 2022-May 2023Data Modeler / Developer - Wealth Management TechnologySenior data developer who collaborated with business teams and project leads to create business requirements, analyzesystem integration challenges, validate business data objects for accuracy and completeness, evaluate databases fordiscrepancies, and recommend applicable solutions.Protected data integrity by regularly monitoring the status and ensuring the accuracy of all reports in production, systemintegration testing (SIT) and user acceptance testing (UAT).Designed, generated, updated, and published widgets, pages, and routes for all reports in production, SIT and UAT.Created and defined the Data Dictionary through the identification and classification of all fields and tables that aidedthe development of technical specifications required by stakeholders.Served as primary 24/7 on call technical expert for the Margin Team s reports to the Network Operations Center team.SAIC, Dulles, VA October 2021-January 2022Solutions Architect, ContractorContracted to provide technical expertise and recommendations for a government contractor.Streamlined 84 business requirements down to 11 through analyses of vendor database tools and capabilities to expeditevendor sourcing for the National Geospatial Data Asset (NGDA) Scanners and Graphs teams.New York Stock Exchange, New York, NY May 2004-September 2019Lead Data ArchitectTechnical expert for NYSE data initiatives providing technical direction, data analyses and models, IT concepts, strategies,solutions, and managing and maintaining the data architectures.Designer and developer of the CIF20, a parameter-driven information database used by the NYSE for 15 years, whichprovided real time on-demand trading information that addressed required user functionalities and anticipated IT needs.Creator of the Events table that produced immediate order status reports to traders and supported market surveillanceanalysts with critical updates ensuring compliance to standards and allowing for the expeditious detection of investorfraud.P a g e 1 R.Previte ResumeNew York Stock Exchange, New York, NY (continued) May 2004-September 2019Lead Data ArchitectEnhanced user investigations by extracting details using SQL that joined Events and other structured data tables of theCIF20 database to identify and resolve inconsistent source data issues.Improved response rates of market surveillance users for the NYSE and Financial Industry Regulatory Authority(FINRA) by coordinating ETL into a new database to instantly capture trading information.Increased productivity by implementing optimal strategies, developing custom solutions, and applying technicalstandards that integrated with the NYSE data architecture and provided business users with ad hoc analysis/reporting.Focused on Data Cleaning, including Missing Values, Duplicates, Inconsistencies, Anomalies, and Data Corrections.Boosted end user efficiency by performing daily database query to troubleshoot core extraction issues, writing, andtesting results to resolve and repair transformation problems.Improved NYSE operating efficiencies by leading the strategic direction to revamp data architecture and apply bestpractices that ensures consistent data quality and reliability, database optimization and functionality and adherence todata standards.Data management and maintenance of an IBM DB2/Netezza database for 10 years, and a Cloudera database for 5 years.Lucent Technologies Inc., Whippany, NJ (formerly AT&T Network Systems) July 1998-December 2002Senior Product Manager (Security clearance: Secret)Creator and product manager for 3 databases: the Cost of Goods Sold Management, Staff Management, and the ForecastDatabase System.Built the Cost of Goods Sold Management Process which decreased annual product costs by $1M+ and established animproved cost-effective inventory and factory build plan.Developed a Microsoft Access forecast database system that led to efficient tracking and monitoring of global productvolume movements.Project Manager (Security clearance: Secret)Optimized expenses by managing the prototype equipment program that matched customer requests to suppliercomponent prototype availabilitiesEDUCATIONNew York University, Stern School of BusinessMaster of Business Administration, ManagementCornell University, Cornell EngineeringMaster of Engineering, Electrical EngineeringRutgers University, School of EngineeringBachelor of Science, Electrical EngineeringP a g e 2 R.Previte Resume |
