Manager Data

Avroham Rothstein

** ***** ***** #*** ****** NY *0950

845-***-**** • *********@*****.***

IT manager/Senior Software Developer / Team Leader

Personal Synopsis:

I am a solutions-oriented professional with more than 18 years of experience Managing developing, supporting and enhancing mission-critical systems to meet the business demands. I am a professional in all aspects of the development lifecycle, from initial analysis and design through development, testing, implementation and enhancement. I excel in partnering with multi-national user teams to analyze and anticipate business needs and develop business solutions to support growth. I am an analytical problem solver; strength in designing applications and interfaces to ensure appropriate integration and information access.

TECHNOLOGIES:

Languages

PERL Unix Shell scripting

C# C

PL/SQL SQLLoader

Kshell SQL

MSSQL SQLPLUS

SSIS SSRS reporting

ORAPERL LITE Java

LITE COBOL

Databases

Oracle 9I, 10G &11G SQL Server

MSSQL

Operating systems

Unix Solaris 10 Windows NT/2003/2008 AS400

Experience:

Mar. 2015 – Current C & A Marketing, NJ

IT manager, Application owner database/server admin

Responsible for managing the IT team C & A Marketing a rapidly e-commerce company

of 300+ employees.

Managed a team of 7 and worked team leader in creating and maintain various stored

Procedures to automatic process order for various channels. Worked with a third party

Company on setting up all our EDI solutions and a dropship portal for about 300 drop ship and wholesale customers. Managed an off-shore team in creating a product database for the company to keep track of their thousands of products and upload them on various market places. Managed the network team for the whole company in maintain and upgrading our servers.

Jun. 2000 – Mar 2015 Deutsche Bank, NJ

Application owner, scripting developer and support

Responsible for several applications at Deutsche bank including AML, Actimize and compliance applications.

(2006 –- 2015) Actimize/AML/ Compliance

Joined the compliance team working on the AML project as an AML team member. Involved in setting up the Mantas application in the UK and Germany and was appointed as a the lead team member to setup various complex Control M batch streams. Worked on the Actimize team as lead team member in setting up the environment and maintaining it through out its lifecycle. Took on the role of application owner for 30+ compliance applications in the bank

Role:

Implemented and worked on the Mantas platform, as the risk assessment tool for our AML solution, was responsible for the installation, configuration of the Mantas product and all code related tasks associated with.

Worked close with our user team on setting up all needed scenarios for their work.

Involved in setting up the mantas platform on our server and writing our own PERL scripts for manipulating the data, SHELL scripts and loading the data and batch processes and PL/SQL packages and procedures to map and process the data on the database.

Worked on the Actimize team to help setup the environment, which included creating various PERL, PL/SQL, Unix Shell scripts and server and database setups as well as setting up the Control M streams for the batch processing.

Responsible for fixing all PERL and Shell code issues and setup the Control M jobs, which made their project go live instead of missing the go live date and was the main contact person for all their server migrations/upgrades and on boarding of the new Surveillance products including Control room and futures.

Assisted the Compliance IT with the Legal IT deliverables as well

Responsible for doing the batch jobs and data mining on the Oracle database

Contributed to high priority including Audit point closures and HW migrations

Highly performed on several other infrastructure initiatives as well as maintained important application documentation.

Led the infrastructure, migrations, upgrades and all other server details for 35+ compliance applications in the bank

Involved on a daily basis in the development for the Actimize team, this included maintaining and modifying existing code or creating new modules as needed which was all done using Perl and shell scripting for the data manipulation and loads and (SQL) PL/SQL for any database reports, changes or updates.

(2000 - 2005) - CRES (Consolidation, Reconciliation, Expansion, Submission)

Role:

Key member of a multi-national team of 8 charged with rapid changes of enterprise-wide regulatory reporting system that ran on a monthly basis and had to be submitted by 6PM on the sixth business day

Responsible for designing the programs to be self-motivated to insure timely delivery of the data with no manual intervention

After starting as a consultant was hired as a full time and was promoted to AVP after 5 years.

After proven success of CRES design was loaned to other teams helping them follow the same design and theory for their systems

Served as primary contact representing United States stake holders and had worked with the business user teams on a daily basis to answer questions, identified and prioritized changes with set timelines and expectations

Worked with the business in gathering requirements and documentations for the business functions

Provided system support, interface design and development, user testing support and develop enhancements to appropriate system modules using Perl, PL/SQL and some Shell scripts

Credited for programming and supporting data feeds for 400 disparate systems using Perl, PL/SQL and Shell scripting

Perl Scripts were used parse the input data and create a standard input file to load the data on the database using sqlloader

Created various packages and stored procedures to map the data and run various reports of the data that was loaded on the database

Worked on various operating systems including AIX, Solaris, windows XP, NT and 2003.

Noted for leading initiative to integrate feeds from GFIS to replace the LS2 feeds

As the lead person in the US for this team, responsible for al the meetings for the IT team

Responsible for the UAT testing prior to rolling out the code to production that included testing the code plus the data against the user requirements to make sure that all scenarios are addressed against the code

Responsible for planning, testing and documenting yearly NY risk management’s DR test. These tests were cleanly executed with no unresolved issues.

1998 – 2000 AT&T, NJ

Programmer

Accountable for maintaining, modifying and developing shell-script tools to

monitor production-related issues strengthen and stabilize mission critical

collections system.

Role:

Programmed numerous modules, enhanced existing modules and stored procedure using Perl, PL/SQL and Unix Shell scripting

Credited for writing programs to reflect change in area codes requiring extensive updating and programming of over 10 modules

Received recognition of Excellence Award for quality and ability to meet aggressive deadlines

Communicated with multiple users and IT communities to respond to inquiries and requests of system enhancements.

Tested and modified various Perl scripts for migration from the NCR to the SUN server

EDUCATION:

Bachelor of Arts, Liberal Arts, United Talmudical Seminary, Monroe NY, 1994

Application Development, AT&T School of Business and Technology, 1999

Somerset, NJ

Diploma in Computer Programming, COPE Institute New York NY, 1998

Contact this candidate