Alex Perelman
Langhorne, PA ****3
**************@*****.***
Summary
** ***** ** ********** ** an application architect and application developer with infrastructure and operational support.
Skilled contributor with experience working in any type of SDLC process.
Excel in research, analysis and problem solving.
Solution and relationship orientated with excellent communication skills.
Computer Skills
Platforms:
UNIX AIX, RHEL LINUX, CDH, .NET, Hive, Impala
Languages:
Unix Shell scripting, SQL, PL/SQL,COBOL, PERL
RDMS:
ETL Tools:
Oracle 19c, DB2, Hive, Impala, Snowflake
Connect ETL (formerly Syncsort), Informatica, SnapLogic
Scheduling Tools:
DevOps:
TWS (IBM Tivoli Workload Scheduler), Autosys
Jenkins Core, GitHub, JIRA
Employment History
Fidelity Investments, 100 New Millennium Way, Durham, NC (Remote from PA)
Principal Software Engineer April 2022 to Present
As part of Index Management team, daily tasks include:
•Responsible for ETL process of ingesting, cleansing, transforming, linking, and delivery of incoming securities data provided by Bloomberg and Rimes data aggregators used to create and maintain 3500+ indices sourced from numerous independent securities.
•POC to convert ETL processing from Informatica PowerCenter to SnapLogic.
•Responsible for daily processing of GAA Investments data provided by US and International banks.
•Make improvements to reduce batch cycle processing time.
•Provide informatics to portfolio managers to assist in making critical client investment decisions.
•Create, develop, and maintain PL/SQL packages across environments for load of Operational Data Store (ODS) and Asset Management Warehouse (AMWH) database.
•Provide on-call support for batch processing and user issues in collaboration with offshore resources.
Icon PRA Health Sciences, Blue Bell, PA
2019 – 2022
Principal Software Engineer
As part of Private Label team responsible for development, maintenance, and operational support of $20 million revenue generating products software suite designed to process incoming prescription drug data and lab data used in clinical research trials, helping patients get needed drugs, and for other better healthcare outcomes.
Automation of repeatable tasks to streamline daily processing. Worked on multiple changes to scale up manual processing from dozen legacy products to 100+ daily automated runs.
Proactively monitoring of daily streams to allow for uninterrupted execution.
Increase resiliency and reliability. Proactive changes to eliminate common failures related to server connectivity, bad data, late file deliveries.
Creation of common reusable modules for external vendor deliverables to S3 buckets, Azure Blobs, and SFTP servers.
Creation of summary dashboard for daily processing metrics monitoring.
Act as liaison with Prod Support, Retail and Product Management teams improving relationships and product line stability.
Participate in CAB meetings to release Private Label products to Prod environment.
UnitedHealth Group Horsham, PA
1999 – 2019
Software Engineering Lead
Participated in development and support of multi-facet Medicare Supplement Health Insurance products big data application SMART (SHIP Marketing Acquisition and Retention Tool) containing over 100 million individuals used for marketing campaigns creation and implementation, merge/purge maintenance data and analytical reporting.
Currently supervise team of 5 IT professionals responsible for daily operations of 7 systems involved in all aspects of Marketing, Claims and Content Management.
Work with 3rd party vendors to support data quality and ETL software.
Work with UNIX, Database, IT Security, EBiz and Data Governance teams to comply with corporate requirements.
Participate in multiple upgrade projects to keep all 3rd party software up to date.
Upgraded DM Express ETL tool to multiple versions with currently running at version 9.4.
Set up Marketing system batch processing running 24/7 utilizing TWS scheduling software.
Support Release management via CI/CD and versioning tools like XL Deploy and Subversion.
Continuous performance improvements for DMX, database processing and korn shell scripts.
Participate in the Software Delivery Life Cycle from analysis and design through implementation.
Provide application and client support on a rotating on-call basis by responding to CA Service Desk incidents of varying severity.
Serve as a subject matter expert in regard to several applications for team members and others.
Participate in multiple Agile projects.
Participate in data migration project to set up daily ETL (Extract, Transform and Load) data feeds to Optum BDPaaS (Big Data as a Service) DEEP analytical database.
DoubleDay Select Delran, NJ
March 1999 – November 1999
Programmer/Analyst
Short term contract for conversion project for Book Club, a warehousing company working directly with consumers to provide various book selection based on membership options in migration to new owner BMG Music.
Converted and transfer inventory system to new owner BMG Music’s systems and frameworks using Cobol/DB2 and VSAM.
Participated in daily operation and maintenance of various batch streams.
Campbell Soup Camden, NJ
1998 – 1999
Programmer/Analyst
Support of packaging and delivery systems for Campbell Soup, Godiva Chocolates and Vlasic food products.
Participated in Y2K testing.
Developed and supported using Cobol, CICS, VSAM, DB2.
Education
Continuing Education:
Unix and Shell for Programmers by Learning Tree
IBM Quality Stage Match Software by IBM
IBM Unica Campaign by IBM
DMX by Syncsort