Marius Draganescu Email & Phone Number

Chicago, IL, US

Chicago, IL, US

Continue developing new data solutions, improve data availability and data quality, database performance tuning as part of the data engineering team within Advanced Analytics and Insights.

Chicago, IL, US

As part of the Advanced Analytics and Insights department, I'm working on rearchitecting the existing data warehousing solution to reduce administration and improve data availability. Developed ETL/ ELT framework that allows parallel processing and adds data quality metrics for reporting (Python, SSIS, SQL Server). Created Database Programming Standards.

Burr Ridge, IL, US

- Development of in-house applications (TSQL, SSIS, VBS, C#, Web using CodeCharge Studio), including Loan Origination, Portfolio Management, Mobile Remote Deposit Capture, etc. - SQL Server proactive administration (including performance tuning of large database).

Lombard, IL, US

• Administration of systems and all core software in a mixed iSeries mainframe/ MS SQL servers environment (25% of time), report writing (40% of time, BI, compliance), applications and utilities development (30% of.
• Designed and coded electronic teller application as part of a development team (I designed and created the database as well as the reporting part, the front end being web-based). This application is saving the.
• Automated some existing processes and optimized others on the Unisys mainframe (ex: converted file transfer process to using SanDataMover instead of FTP to reduce CPU utilization, automated the daily review of DTS.
• Designed and coded cross platform application which tracks critical files change information on the Unisys mainframe (for compliance), ETL into a SQL database (coded using WFL, Cognos macro scripting). It includes a.
• Designed and coded complete data mart solution for BI reporting (SSIS and Cognos Impromptu reports). Files from a Unix platform are being imported into a SQL database and several reports (Cognos) are being run.
• Reduced processing times significantly (50%) for several reports and extracts by optimizing a Very Large Database (SQL 2000)

Blue Bell, Pennsylvania, US

• Experienced Systems Administrator, DBA and Programmer with extensive professional experience in Unisys mainframes. Highly proficient in support and administration of MCP, DMSII and SQL databases. Successful track.
• Administered around 480 Unisys DMSII databases for both outsourcing and internal clients in a highly automated environment (database backup, load, recovery, rollback, update (physical and logical database changes).
• Designed, coded and implemented processes or applications (ALGOL, WFL, Java on MCP, some COBOL) to improve process flow and automation (for example, a fully automated database log files recovery process (from backup).
• Planned, scripted (WFL) and executed several database consolidations and moves with minimum downtime which resulted in significant cost savings
• Designed and coded a database/ applications test suite for benchmarking/ testing (DMSII and ALGOL). Containing all DMSII structure (table) types and a suite of programs, it allowed extensive testing of Unisys released.

Blue Bell, Pennsylvania, US

• Technical support for various utility applications running on NX Clearpath mainframes including Blpack, Blsched, Bldist, Blsource, Bllib and DARGAL (troubleshooting, installation, upgrades etc)
• Developed a series of software tools for internal use (mostly WFL scripting) for the automation of processes (installations, upgrades, operator procedures)
• Created documentation for users and system operators
• Disaster Recovery for all NX Systems inclusive of documenting procedures and techniques