Stan S Email & Phone Number

Philadelphia, Pa, Us

Working for car dealership marketing company. Developing and maintaining company’s PostgreSQL database.Project: Various ongoing database optimizations to improve performance.• Consolidating multiple queries into a single query that accesses the tables only once• Leveraging parallelism anywhere it is possible• Using dynamic SQL to generate queries containing hundred or more calculations• Utilizing partition pruning and partitioned tables, along with utility procedures, to generate and maintain them• Deploying immutable functions used in indices• Employing constraint triggers to enforce business rules• Identifying and resolving any database anomalies/issues using RDS as well as generated incident reports• Archiving or retiring old dataImpact: • Reducing memory and CPU usage to save costsProject: AI Generator • Compiled data from multiple databases to create segments based on unique household counts using specific criteria utilized to populate a website• Created reports comparing segments using set operations on such counts

Philadelphia, Pa, Us

Project: R-scores • Implemented an R-score rating process to rank each customer's likelihood of buying a car or a service• Added a calculation that used normal distribution to classify customers into specific ranges based on such ratingProject: Audience Generator• Developed table valued functions used by an application that calculated customers of certain demographic who have not bought or serviced a car in a specific time framesProject: NCOA Scrapping• Implemented a script and DB procedures that collect and process data using an API of any customers who moved in the past Project: Email Generator• Developed procedure to identify customers who would receive emails based on certain criteria until specific quota is filled.Data Migration Project:• Designed processes that uploaded data into AWS S3 buckets to be transferred between databasesProject: Encryption/Decryption• Implemented procedures that use special functions that encrypt/decrypt customer identifiable data for security compliance

Ambler, Pennsylvania, Us

Worked for American Express litigation support. Created MS SQL Database Infrastructure to speed up legal documents generation.• Continued database reporting support and training of future replacement

Ambler, Pennsylvania, Us

• Supported American Express collections department, automating and expediting the legal document creation process using database procedures and functions to generate final legal documents in MS WordImpact:• Succeeded in removing 95% of manual input, overtime, and errors in generating legal correspondence between parties through collaborative effort of the team• Made significant contributions in boosting incoming revenue, thus receiving bonuses during the processProject: Debtor Status Tracking• Identified certain collectors who transitioned debtor statuses initial to final during a certain time frame using recursive CTEs Project: Scraping Website Data• Implemented one shot full process that scraped data from interactive website using Selenium, did calculations in a database, and created final legal document

Atlanta, Ga, Us

Worked for an outsourcing company, completing different projects for different clients.Project: IT Department Performance BI Report• Developed multiple PowerBI dashboards using DAX calculations with integrated custom python 3D graphs to display performance and metrics of each individual IT team memberProject: Automatic Product Ordering (APO) System• Implemented data-driven model for a bakery that calculates and forecasts number of products to be delivered for each seller store Project: Data Source Switch for a Reporting Process

Worked for energy media publication company. Responsible for some database and ETL tasks.Provided the most extensive real-time database of waterborne flows for all crude oil and refined products globally, which included oceangoing, inland barge, ship-to-ship transfer, and floating storage Built and managed PostgreSQL database, along with queries, functions, tables, triggers, as well as integrity relationships, constraints, and indices Maintained coordination with partner companies, including DataMyne and InchCape for data loading and reports generation Performed web scraping from the internet or email accounts, as well as parsing in the MIME, HTML, XML, Excel and Base64 formats and loading into the primary database Took charge of drafting email status alerts for particular tables; writing Perl scripts to produce Excel client reports; and uploading files to the SSH File Transfer Protocol (SFTP) site

Bachelor Of Science - Bs, Computational Mathematics

Education record