Alex Tsirlin Email & Phone Number

Holmdel, Nj, Us

New York, United States

Greater New York City Area

Holmdel, Nj

SailPointVaronisWindows Administration for SQL ServerSQL Server Database AdministrationOracle Database SQL for ReportingANSI SQL / PL-SQLSSIS (ETL) / SSRS & PowerBI (Reporting/Dashboarding)JavaPowerShellUnix/Shell ScriptingWindows/Batch Scripting

Madison, New Jersey

Quick Overview:DataGuardRMAN Backup and RecoveryDisaster RecoveryPatchingCloningMigrationsHigh AvailabilityVLDBPartitioningILMAdvanced CompressionMaskingSubsettingVPDAIX / SolarisDevelopment of Administrative CustomizationsDiscoverer (Tuning and Troubleshooting)Performance TuningShell ScriptingSQL*Plus / PL/SQLHyperion Installation and Maintenance (Auxiliary Support)OEM / Grid ControlMonitoringProduction SupportProcess ImprovementResearch and Development

Teaneck, Nj

Focus on Database Administration, Business Requirements Analysis, Integration, and Programming.Support many applications, ranging from Oracle Financials (E-Business Suite) to in-house and some third party. These applications reside on Windows, Linux, and Solaris operating systems while utilizing Oracle, SQL Server, MySQL, and TeraData databases.Primary focus is on performing DBA activities for Oracle Financials (EBS). This includes software support/maintenance and server administration.Secondary focus is on supporting and maintaining several other Oracle and MySQL databases and servers as well as SQL Server and TeraData database applications.Third focus is on internal and external projects. One of such projects is integration between Salesforce.com and internal systems. Internal systems consist of various Traffic Systems, KALIDO DIW/MDM, TeraData DIW, Oracle Financials, and Active Directory. These systems utilize Oracle, SQL Server, and TeraData databases. Integration/ETL from and into Salesforce.com is performed by me via IBM CastIron.Fourth focus is on production support, performance and query tuning, EBS reports/ interfaces/ customizations/ extentions/ workflows, building and maintenance of internal (web)/application, server administration and client support.Experience Summary: Oracle, SQLPlus, PL/SQL, RMAN, Streams, DataGuard, Oracle Forms/Reports, BI/XML Publisher, ASP .NET, SQL Server, DTS, SSIS, MySQL, TeraData, Active Directory, IBM CastIron, Crystal Reports, Microsoft Office, server/software installation and maintenance.

Focus on E-Business Suite Implementation for multiple divisions and in multiple languages with following modules GL, AP, AR, FA (Fixed Assets), ONT (Order Management), WSH (Shipping), PA (Projects), QP (Advanced Pricing), IB (Install Base), INV (Inventory), and PO (Purchasing).Perform Oracle Apps DBA responsibilities such as patching, cloning, tuning, monitoring, change control, etc. on Linux RHEL4 AS with Oracle Database 10g Enterprise Edition in a RAC configuration.Customize and extend Oracle Applications 11i release 11.5.10.2 using various programming languages and tool sets.Provide ADP TAXWARE post-implementation maintenance, end user support, tax research, administration, and correction of various issues.Write SQL, PL/SQL, UNIX, and Perl scripts.Revise Oracle Workflows.Define Oracle Forms Personalizations.Revise Java extensions for OMR using Bursting.Write and administer SQL, Oracle Developer, Oracle Discoverer, and XML Publisher Reports.Develop interfaces using API’s and/or Interface tables.Create data conversions in Excel and upload them via ADI and Web ADI.Design and generate reports using Oracle FSG and RXi.Upload data using DataLoad design and execution.Prepare and validate system test scripts, user and system documentation using Oracle AIM methodology.Provide support, and training when necessary.Problem solving techniques utilizing vendor support sites and personal resources.

Focus on E-Business Suite Implementation with multiple divisions in multiple currencies with following modules: GL, AP, AR, FA (Fixed Assets), INV (Inventory), PO (Purchasing), AME (Approvals Management), and HRMS/PER (Human Resources) with OAB (Advanced Benefits).Customize and extend Oracle Applications 11i releases 11.5.9 thru 11.5.10.2 using various programming languages and tool sets.Develop HRMS Interfaces for ADP, United HealthCase, Prudential, Guardian, Gordian, etc.Develop HRMS Advanced Benefits System Extracts, Functions and Fast Formulas.Write SQL, PL/SQL, UNIX, and Perl scripts.Revise Oracle Workflows.Revise OA Framework pages, Forms and Page personalization settings, and AME rules.Write and administer SQL, Oracle Developer, and Oracle Discoverer Reports.Develop interfaces using API’s and/or Interface tables.Create data conversions in Excel and upload them via ADI.Design and generate reports using Oracle FSG and RXi.Upload data using DataLoad design and execution.Prepare and validate system test scripts, user and system documentation using Oracle AIM methodology.Provide support, and training when necessary.Problem solving techniques utilizing personal resources and Oracle Support (Metalink).

Focus on E-Business Suite Reporting Development with following modules: GL, AP, AR, FA (Fixed Assets), INV (Inventory), PO (Purchasing), ONT (Order management), WSH (Shipping), QP (Advanced Pricing), TM (Trade Management), and OPM (Process Manufacturing).Customize and extend Oracle Applications 11i releases 11.5.8 thru 11.5.9 using various reporting tool sets.Write and administer SQL, Oracle Developer, and Oracle Discoverer Reports.Using SQL and PL/SQL design and develop modular database objects used in reporting.Create data conversions in Excel and upload them via ADI.Design and generate reports using Oracle FSG and RXi.Upload data using DataLoad design and execution.Prepare and validate system test scripts, user and system documentation using Oracle AIM methodology.Provide support, and training when necessary.Problem solving techniques utilizing personal resources and Oracle Support (Metalink).

Focus on E-Business Suite Post-Implementation, Administration and Support with following modules: GL, AP, AR, FA (Fixed Assets), INV (Inventory), PO (Purchasing), ONT (Order management), WSH (Shipping), QP (Advanced Pricing), and OPM (Process Manufacturing).Daily routines consist of managing, maintaining, and customizing Oracle Applications 11i, building in-house software applications for ease of reporting and automation, purchasing and maintenance of personal and Macintosh computers, provision of training and support, research and implementation of various devices as well as tools to accommodate for company ongoing advancements and employee productivity.Latest project focused on implementing handheld devices for Process Manufacturing, Shipping, and Inventory modules, in order to reduce delays, user based errors, and to increase customer satisfaction.Work closely with Financial Controller in order to determine and resolve day to day issues that commonly originated from hardware, software, or human inaccuracy.Perform Oracle Apps DBA responsibilities such as patching, cloning, tuning, monitoring, change control, etc. on Microsoft Windows 2003 AS with Oracle Database Enterprise Edition versions 8i and 9i.Customize and extend Oracle Applications 11i releases 11.5.8 thru 11.5.9 using various reporting tool sets.Develop SQL, Oracle Developer, Oracle Discoverer, and Crystal Reports.Develop 3rd party in-house software using several different technologies and techniques.Using SQL and PL/SQL design and develop modular database objects used in reporting.Create data conversions in Excel and upload them via ADI.Design and generate reports using Oracle FSG and RXi.Upload data using DataLoad design and execution.Prepare and validate system test scripts, user and system documentation using Oracle AIM methodology.Problem solving techniques utilizing personal resources and Oracle Support (Metalink).

Bs, Computer Science

* Transferred from Middlesex County College. * Most if not all of my CS professors have at one time worked for Bell Labs :). * Graduated.

Cs, Computer Science

* Computer Science program with transfer to Rutgers University. * Best teachers and community that I have been a part of. College has well.

Programming, Java, C, Vb, Cobol I/Ii, Jcl, Cisc.

* Graduated with Honors in Computer Programming. * This school had the best material presentation and technical documentation I have ever.