Worked on Java Spring Boot micro-services supporting US Treasury post payment processing applicationWorked on design and implementation of Pyspark file processing framework for US Treasury payment dataPyspark performance tuning Worked with various components in AWS environment like DynamoDb, Postgres Aurora, Lambda Functions, Step Functions, Kinesis Streams and SQS QueuesWorked on Avro serialization/deserialization projects in Python and JavaCreated docker images to be used by the Gitlab pipeline for testing ETL using DataStage for data warehouse loadCreated stored procedures for database maintenance and business logic

Project lead in creation of stand-alone SQL Server environment for Fraud and Payment Operations departmentsResponsible for design and development of Fraud and Payment Operations data warehouse, including data mapping, table/index design and creation ETL processes via SSISAutomated replication of Oracle tables from various Sprint systems including Nextel Data Warehouse (billing system), Point of Sale, Sprint.com and Prepaid (Virgin and BOOST mobile)Automated load of Sprint's web log files

Created an automated confirmation text message notification process for ACH Payments using Java helping Sprint cut letter vendor costsCreated an automated process to keep credit card auto-pay information up to date improving auto-pay payment decline rate.Created JSP application in support of productivity tracking process to collect employee productivity data through web entry for those processes that could not be systematically trackedCreated JSP payment search improving efficiency of payment investigation processWas responsible for transferring credit card and bank account information during billing system migration

Gathered report requirements from various groups in Payment OperationsWorked with accounting department to create automated reporting to be used on Sprint's general ledgerEliminated manually generated reports by migrating SQL to Crystal Server environment improving efficiency and report availabilitySupported 50 automated daily, monthly weekly reports and was the point of contact for adhoc report requestsCompiled presentation decks on Payment Operations metrics for executives using Excel and Power PointCreated reports pertaining to payments, refunds, credit card chargebacks, check returns and SLA metrics