Steven M. Davis Email & Phone Number

Morristown, New Jersey, US

nyctechsupport

Cheyenne, Wyoming, US

Am involved in crypto since 2016 with an interest in market and data analysis and applying that to various financial application designs. Prior to finding crypto, my focus formany clients has been application and database design, application reverse engineering, overall business logistics when applied to deployed technology and analysis of existing data.

• Reverse engineering and documentation of a health care network data warehouse due to key personnel loss in the organization, which consists of SQL databases, an array of flat files and other data sources, Talend ETL.
• Document as many shortcomings/areas of improvement.
• Create visuals (data models) and documents of the varied components, as well as data movement/transforms. The models were system driven at a high level, and data driven at lower levels.
• Full source to destination modeling - at a table level at minimum, field level for pertinent fields
• Provide counsel and direction for data privacy - as this is a healthcare client - HIPPA, PII, PHI and SPII all need consideration.
• Provide counsel and direction for "moving the platform forward." This include(s/d) documents, data maps, software recommendations, security, etc

Pune, Maharashtra, IN

• Onsite for client Glafelter
• Architecture of Datawarehouse/Datamarts for global dashboard/KPIs in paper manufacturing including measures such as production plan vs actual, machine downtime, quality and waste
• Led team of 8 offshore/onshore developers, with hands on development, direction and code review on Azure, ADF/SSIS and PowerBI Premium
• Guidance and technical assistance to corporate IT team to setup Azure/ADF, and transactional replication to Azure staging database from Optivision and PI.
• Reverse engineering and documentation of various current localized solutions for consideration in new BI system
• Data modeling of current systems data, mapping to DW and logical/physical modeling of datawarehouse

Pune, Maharashtra, IN

• Onsite for client Perrigo
• Led team of 6 offshore developers, with hands on development and code review within BODS, SSIS and PowerBI Pro
• Architecture of POC EDW/BI solution from disparate source systems relating to global customer, sales order and delivery entities.
• Gathering and analyzing customer requirements/source systems including SAP R/3, Syteline and Innatrack
• Development and communication for validation with the business units Conceptual and Logical data model
• Technical and data governance assistance with hierarchal model for Item entity, considering OTC, human pharma, vet pharma and pet products for usage in Oracle PDH

• Mapping/modeling of current Physical transactional database designs and Logical Data Flows in preparation for build of new transactional database and datawarehouse in Microsoft SQL Server/Azure and Oracle environments
• Guidance on data design for expanding into new lines of business
• Creation of several UML diagrams documenting current business process for streamlining
• Development of ERD’s to model entities at the conceptual level
• Establishment of documented database development and design standards including Schema definitions, syntactical documentation of code, and object naming principles.
• Technical guidance on tactical vs strategic paths for future development in using Agile methodologies

• Development of Conceptual and Logical Data Models utilizing Microsoft Visio and Embarcadero – ER/Studio 10/11
• Design of application systems map showing dataflows between applications, with documentation and dictionary for each connected system at conceptual and logical levels
• Mapping/modeling of current Physical and Logical Data Flows in preparation for implementation of SalesForce
• Data profiling to provide strategies and guidance for targeted data cleansing.
• Mapping/modeling of several full current physical data flows from source systems to reports to record business rules and transforms to initiate and implement new physical model and datawarehouse structure/schema.
• Development of and presentation/participation in several workshops/training sessions for companywide major master data initiatives including Customer Master, Customer 360, Organization Master, Distribution Channel.

Please contact me for details

US

Development of Complex T-SQL queries, stored procedures triggers, and SSIS packages to implement complex business needs.Development of SSIS (ETL) packages to import, cleanse and modify data from varied sources.Development of jobs on Talend (ETL) to import, cleanse and modify data from varied sources.Data pulls in response to client needs for marketing.

• Team leader coordinating efforts of 2 Business Analysts
• Interpretation of Federal Regulations and guidance notices regarding reporting requirements for new and “substantially equivalent” products for R&D department.
• Analysis of 100+ current process documents for discovery purposes – data/systems, reports, personnel/roles across several departments and legal staff.
• Reverse engineering and modeling of current data and reports(SSRS and Business Objects), which included database DDL’s, ETL flows (SSIS, XML, ADO and stored procedures) and current reporting for production system.
• SQL Stored procedure, SSIS, SSAS and SSRS code review and mapping
• Design of application systems map showing dataflows between applications to current reports, with documentation from source to destination, as well as transforms for each field on all current reports.

New York, New York, US

• Design of application systems map showing dataflows between applications, with backing documentation for each connected system.
• Internal database discovery, mapping and archiving SQL server databases, as well as moving databases between servers during server consolidations and upgrades.
• Created data dictionaries for all existing and new databases
• Implemented, maintained and responded to SQL job failure notification with post mortem reporting.
• Created system wide job/task timing map creation, and realignment to allow for smoother system function and performance tuning.
• Coordinate with third party application vendors and technical staff for modifications needed by business, modification of internal systems as needed due to implementation of changes and documentation surrounding.

Manhattan, New York, New York, US

• Analysis of pre-existing data from disparate databases for commonalities in an effort to re-architect data structures
• Analysis of all ETL processes used in bring data into the databases from a variety of sources/data types, as well as those processes in use to export data from existing databases to external sources
• Designed new transactional databases, while maintaining existing ones and design/development of new datawarehouse
• Optimized and enhanced performance of stored procedures, reconfigured index structure for Web and transactional DB’s
• Modified existing data warehouse and created new SSIS packages for data feeds
• Created ERD diagrams for new data bases

New York, New York City, US

• Designed a multiple fact table Enterprise Data warehouse Architecture and assisted in development of the conceptual and physical Data Models
• Provided strategies and the Data Warehousing Best Practices based on Inmon methodology
• Worked within business line to gather the needs and translated them into a Data Warehouse solution
• Assisted in analysis of multiple client source systems and current reporting structures including Microsoft AX2009 and BlueCherry to determine full extent of data to be subject to BI.
• Reviewed the ETL code and tuned mappings and workflows for better performance.
• Reviewed sample SSAS cubes for data tuning

Toronto, ON, CA

• Analysis of an existing client facing internet application with a SQL Server 2008r2 backend and.net frontend, developed for the manufacturing vertical to enable them to manage their supply chain. Then analysis was.
• Analysis of design of model datawarehouse developed by internal staff, and sample SSAS cubes built to provide business intelligence. This analysis was geared towards documentation and recommendations for the.
• Development of a 2 stage ETL process utilizing SSIS to move data from the transactional to the datawarehouse.
• Technical assistance in development of cubes utilizing SSAS for usage in the new reporting system being developed.
• Development of several prototype pages for differing reporting techniques using parameterized SSRS, customized DEVEXpress pivot components and ASP/VB/datagrid designs.
• Development of prototype dashboard for comparative analysis utilizing Microstrategy

Houston, TX, US

• .Sungard Client site - Commodities Trading company, Greenwich CT
• Design and development of a intranet based Pivot Table and reporting solution utilizing ASP.Net, SQL Server, SSAS, Office Web Components (OWC) for pivots and charts/graphs and internally generated XML.
• Customization and parameterization of OWC components as requested by client
• Debug and tuning of varied cubes and MDX queries in SSAS where result set was inaccurate or was in need of format reconstruction.
• Development of various excel workbooks for traders and back office utilizing VBA extensivelySungard Client site - Medical Community company, Irving, TX
• Reverse engineering and documentation of an application developed utilizing SQL Server 2008 and ASP.net/VB.net

• End client - MTA NYC
• Development of MS Access 2003 and 2007 databases utilizing TSQL, SQL Server 2000 and VBA.
• Debug and correct non-working VB.Net application utilizing ADO.Net connections to SQL server 2000.
• Creation of process re-engineering document, statement of work, and implementation of process.
• Debug and correct non-working VB6/SQL Server 2000 application.
• Development of Stored procedures and jobs to clean and archive data utilizing SQL server 2000.

New York, New York, US

• Development of SSIS (ETL) packages to import, cleanse and modify data from varied sources.
• Development of base reporting structure utilizing SSRS.
• Training of staff on usage of SSIS and SSRS (MS SQL Server BI Tools) for continuation of module development by internal resources.

New York, NY, US

• Financial database redesign and redevelopment to conform to standard IT practices and procedures utilizing SQL server 2005 creating a robust database structure
• Development and redesign of SSIS packages manipulation of data from over 60 source files being imported on a monthly basis for use in a financial reporting application
• Documented current workflow and procedures implementing changes to the workflow to increase the speed of reporting production while decreasing manhours in the process
• Documentation of hardware and software needs for a move of the database structure, code and SSIS packages from a standalone server to a secure corporate database solution, with control of the database and frontend to.
• Assistance with setup and design of a 3 tier database modification path (DEV, QA and Prod) from a single point of failure mode.
• Assistance in modification of several VBA driven Excel/Access Finance applications used in post Bankruptcy/new regulatory accounting process

New York, NY, US

• Database architecture and development for sales, renewals and cancellations utilizing MS Access, SQL Server and salesforce.com
• Datascrubbing of existing data from varied sources
• Development of varied SSIS packages, and VBA within Excel and Access to manipulate data for reporting purposes and distribution of reports.
• Front end interface developed utilizing MS Access for data overrides, data imports and FX rate change inputs as well as report generation.

US

• Redevelopment and Automation of Financial Reporting system utilizing Excel, Access, SQL Server, Oracle
• Development of Stored Procedures and SSIS packages on SQL server 2005/2008 for ETL of data pertaining to financial reporting system
• VBA development within Excel and Access to Automate Financial reporting and distribution process.

New York, NY, US

• Redevelopment of existing MS Access Database to be utilized in multiple offices for HR purposes.
• Development of reporting system utilizing MS Access, Excel and VBA
• Documentation on migration of Client to Access 2007 and Back-end to SQL Server
• Coding and recoding of assorted TSQL and VBA code as needed.
• Development of SSIS packages for ETL within various SQL Server databases.
• Training of 3 employees on Access 2000, 2007 and SQL functionality

• Development and tuning of various databases and processes on the SQL Server 2000, 2005 and 2008 platforms including Stored Procedure tuning, SSIS and SSRS tuning. Focuses on index tuning, query modifications.
• Technical assistance in development of OLAP Databases and SSAS/MDX Queries for BI purposes.
• Database administration for databases up to 2 terabytes including T-SQL coding, stored procedures, backup/recovery, high availability.
• Technical assistance in development of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering
• Technical assistance in developing datawarehouses for using in BI operations
• Use of various internal, Microsoft and third party tools such as PSSDiag, Cleartrace, PAL, RML Utilities, SQLDIAG.

Technology writer/reporter for a local Community Services Oriented new newspaper in NYC. Ground level, grassroots investigation and writing about issues of concern for area residents in the Technology arena from security & scams, to provider investigations and more.Webmaster for soon to come website for design, development, content, SEO, Ad revenue and.

Development of SSIS packages including SQL, Sprocs, views and scripting as part of a migration effort from MS Access to SQL Server 2005Development of varied ASP.Net pages to display migrated datasets, and allow for variables to be passed to calculations included in parameterized queries.Consultant for insurance company client.Stamford, CT

Fairfax, Virginia, US

SQL Server Database admin/developer for IA Disaster recovery. Worked on varied application projects which included ASP.Net, C#, VB.Net, SQL 2005, SSIS, SSRS, MS Access, MS Excel, MS Outlook.SQL server 2005(SSIS, SPROCS, Triggers, Views, Table design layout and optimization) + SQL 2005 Reporting ServicesDevelopment and team lead on callcenter and.

Columbia, South Carolina, US

• Report development for workflow management system for varied forms of client contact (phone/fax/scanner/electronic)
• Oracle 9i PL/SQL (SQLPlus and SQL Developer) and SQL server 2005 stored procedure coding for data extracts and reporting.
• Perl Development (utilizing vi editor and putty) in Unix (AIX) environment for data extracts and processing
• Development of tracking and posting tool in VB6, ADO, SQL 2005, and IBM Websphere (MQ Series) native API calls.
• Development of various report modules using Business Objects 5.1, and SQL Server 2005 reporting services.
• Development of several MS Access 2003 databases for project management and tracking, data analysis, and testing of data extracts and imports (backend Oracle 9i, SQL server 2000, SQL Server 2005, VBA coding and Text.

Washington, DC, US

Dev of various databases used in daily business.Liaise with varied departments for technical, process, and user specsDevelopment of SPROCS and triggers in SQL 2000Data Analysis for FEMA management reporting needsDirect assist for data utilized in various press conferences by LTRO senior management and Florida State representativesRedesign of varied.

Debug and redevelop Stored Procedures, Triggers and DTS packages in a custom insurance applicationDevelopment of various reports utilizing Crystal ReportsEnhancement of existing Access Databases(Access/VBA/SQL) for finance division Test, Debug optimize and recode stored procedures developed for an inhouse built application.Des Moines, IA

New York, NY, US

• Development of new code using VB.net and ADO.Net and migration of old VB6(Winforms and win32calls) code to the.Net platform
• Installation and implementation of SQL Server 2000 on a Windows 2000 Server/WinXP client network
• Migration of multiple Access databases to SQL Server 2000
• Redevelopment of VBA and VB6 code that deals with data in databases being migrated
• Development of stored procedures and triggers using TSQL on SQL Server 2000 to automate/change prior methodologies.
• Redevelopment and enhancement of current Subs and Functions in over 30 VB6 applications to increase performance on new platform

New York, New York, US

coordinated efforts with Satyam team in development of Excel/Word/.net /VBA based pitchbook and other external facing documentation solutions. Development of process reengineering documentation and process, with heavy communication between outsouced onsite and offsite staff and internal clients. Development/debug/redevelopment of VBA/sql/.NET code.

New York, NY, US

Continue development and administration of Access 2000 database relating to SOX issues utilizing VBA and SQL.Development of canned reports from SOX data gathered utilizing Access, Excel and Crystal Reports.Development of various templates, reports and pivots in Excel utilizing links to other Excel workbooks and ODBC for AccessAssistance in SOX QA.

Lausanne, CH

Development of suite of Excel templates for financial reporting of wholesale clients to PMDevelopment of Excel Add-Ins Utilizing VB6 for manipulation of financial templates on return from clients, including conversion of data to format needed for export to Oracle.Richmond, VA and NY, NY

New York, NY, US

Cleanup and redevelopment of Project Control database developed in Access 2000, including redefining tables, relationships, views, queries, and VBA code.Coding scripts to Auto Import and append data to Access from varied CSV and Excel sources.Development of Intranet front-end for Project control Database in HTML/ASP.Net (Webforms) including data entry.

New York, New York, US

• Dev of Access/SQL app to replace a manual attachment process.
• Dev of Intranet app utilizing ASP, VB6, VBS, Crystal Reports and SQL Server 2000 for insurance issuance and documentation control.
• Lead Dev of financial modeling application utilizing Excel/Access 97 and 2000 for migration, workflow and Business case support utilization for process improvement.
• Presentations for meetings regarding development of application.
• Diagraming workflow (Visio) and Project development support
• VBA development for varied application needs.

QA testing, documentation and rollout scripting of various applications being migrated to Windows XP platform.Vendor and client contact to resolve issues arising from migration.Testing and redevelopment of network based Access 97 databases and Excel 97 workbook applications being migrated to Office XP including rewriting VBA code as needed.Documentation.

• Develop and manage team of 6 Excel/Access(VBA) professionals in migration/remediation of front and middle office areas
• Balance workload between remediators and re-assign clients as needed
• Migration of varied VB6 (.dlls and.exe) codesets to VB.Net platform
• Testing and redevelopment of network based Access 97 database applications and Excel 97 workbook applications being migrated to Office XP/2003 including rewriting VBA and testing.dll and.xla add-ins as needed
• Active in desktop remediation and testing process at client desktop
• Installation and/or re-installation of market data applications and add-ins as needed

New York, NY, US

• Technical lead and Project manager for multi-application migration project: Corel Office suite to MS Office 97 suite, including WordPerfect to Word, Lotus 123 to Excel, Quattro Pro to Excel, and Paradox to Access.
• Assist users with file conversion, recreate existing files, rewrite macros using VBA, recreate tables, charts, footnotes, headers, etc, recreate database forms and templates, enhance functionality, and resolve.
• Development of custom applications for areas including Finance and HR using Visual Basic 6.
• Help desk final escalation point on non-resolvable technical issues.
• Custom application development utilizing MS Office suite, including MS Access, Excel and Word, and VBA macro programming, providing updates as needed or requested for various UN departments.
• Provide technical assistance with MS Office 97 to Office 2000 and 2000 to XP/2003 migration projects.

Design, set-up, and administration of Website with monthly content updates.Development of custom multi-tier application for patient administration and billing utilizing MS Access, SQL Server 7.0, Excel charting, Word templates and VB6(win32) and VBA programming for use by 25 users.Build, set-up and configuration of 2 server 25 PC network using Windows NT.

IT

to be modified

New York, NY, US

Details to come shortly!Brooklyn, NY

More to come shortly.NY, NY

BR

more to come shortlyNY, NY

Education record

International Finance

Education record

International Finance