Robert Fruchtman

Old Bethpage, NY *****

Home: 702-***-****, acs5e8@r.postjobfree.com

Cell: 702-***-****

SUMMARY

With over 25 years experience in the full project life cycle of computer business systems, from meeting with users to handing over the system to maintenance developers. Industries I’ve been involved with include Real Estate, Finance, Healthcare, Government, and Insurance. Database expertise is in Oracle, both as a PL/SQL Team Leader, PL/SQL Developer, and Developer DBA. The sizes of these databases were as high as 5 TB. For Data Warehousing, we used ETL processes.

• 20 plus years of experience in development of applications using Oracle 4 - 12c.

• Expertise in developing SQL, PL/SQL scripts in oracle-distributed environment.

• Expertise in distributed query performance tuning by using EXPLAIN_PLAN, SQL Trace Utilities and hints provided by oracle.

• Possess strong programming knowledge in Oracle PL/SQL 6-12c, SQL*PLUS, SQL*LOADER.

• Expertise in Oracle Stored procedures, Packages, Functions, Cursors, Cursor

• Extensively used oracle tools like TOAD, SQL Navigator, and Sql Developer, etc.

• Designed and developed various applications using oracle products/tools for process automations software into database server using CRON, UNIX/Linux shell scripts, PL/SQL packages, procedures, functions, and database triggers based on client/server and multi-tier technologies

• Experience in Data migration Projects which uses SQL Loader, Data Pump, and RMAN, and PL/SQL programming, coding Procedures, triggers and functions, and packages

• Expert in Export, Import and SQL*Loader Utilities.

• Experience in data extraction, data migration and Data loading.

• Expertise in query optimization, debugging and application tuning using AWR, ADDM, along with Oracle DBA and session tables.

• Experience in designing and developing application systems using oracle extensive suite during all phases of system development life cycle, design and maintenance.

• Ability to work in a team and Positive orientation to expand present knowledge base, Active team player with positive and forward-looking attitude. Strong analytical, interpersonal and communication Sybase System 11.5, ASE 12.0, ASE 15.0

• Knowledge in ETL process using PL/SQL.

Employment History

PL/SQL Developer, Axiom Developer

Barclays Bank, NJ April 2014 to Present

Shell Scripting

Barclays has the program called Rainstor, which is a program for storing historical versions of financial source files from the business, which uses for Fed reporting. There are approximately 10 shell and perl scripts that I created and/or supported which handle this archiving on a daily basis via autosys. I create and support numerous Axiom reports that are used by the Federal Reserve. While designing the ETL portion of many of the Axiom reports that I create, pl/sql packages and procedures which I create are used for taking the staging data and moving to business tables.

Citibank, NY July/2012 – April 2014

Production Support, Developer DBA, ORACLE DBA, PL/SQL ETL, Shell Scripting Performance Tuning, and Architect, data modeler, Warehousing Oracle

On a daily basis, we bring in 20+ types of data sources such as bond data and swap data. This data is brought into a staging environment using Java Spring classes, which I support from time to time. The data is then messaged via Oracle packages. The team that I work with supports Citibank Treasury Risk. We support approx. separate pl/sql ETL processes which allow us to store every time of product that the bank supports including fixed, floating, and swap bonds, mmkt deposits, trups, hedge funds, deposits, etc. We get daily feeds either automatic or manual from the Risk Group, mostly as spreadsheets, and by using Java, bring the data into the database. This data is used for Risk reporting such as IRE and Stess. This data is available for the Risk group via a java based website. All of our market data comes from Bloomberg, which we retrieve via custom spreadsheets that make the calls for us.

Because of the large move into warehousing and federal requirements for reporting, Citibank has incorporated Oracle Exadata, which makes our queries significantly faster do to several factors including smart flash cache. It is seamless to our work on a daily basis, but does significantly speed up our work, smart flag logging, and compression, and handles indexing much better as well. Queried data with large results are retrieved faster because exadata only returns the required subset of data needed via using exadata storage by using smartscan with iDB commands and CELLSRV components of exadata scanning the blocks rows and columns. In the explain plains, exadata cell usage is included when it is used. The part that I play:

I am the creator, supporter of all ETL for our department. I am the data tuning person. I get AWR and ADDM reports hourly for production, QA, and DEV. I have access to all v$ views. I am also responsible for shell scripting along with another person. I do some lite Java coding. Sql Server

Responsibilities:

• Gathering the user requirements, analyzed the requirement and designed database solutions.

• Gathering information about the system and assisted in the development of deliverables. Working with the clients to gather system requirements.

• Write standard and complex T-SQL Queries and used joins and stored procedures to make sure results matched back to expected results based on business requirements.

• Used various transformations in SSIS dataflow, control flow using for loop containers, and fuzzy lookups.

• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

• Implement error handling and utilized event handlers for automated notifications using SSIS.

• Create SSIS packages for transferring the data from different systems.

• Involve in configuring and maintaining report manager and report Server in SSRS.

• Develop parameterized reports, caching reports, sub reports and Ad Hoc reports using SSRS.

• Write the queries for the drill down reports, identified and added the report parameters by using SSRS.

• Formatted the reports using the global variables and expressions in SSRS.

• Deploy the generated reports on to the Reporting server. Environment: SQL Server 2008R2, enterprise edition, BIDS, SSIS, SSRS, and Microsoft Office 2007, SVN. PL/SQL Java Consultant

Estee Lauder, NY January/2011 – June/2012

Production Support, VBA, Oracle DBA, Data Warehouse, Sql Server, support, shell scripting, ETL, CVSNT

Oracle

Java Spring classes are used for bringing in staging data for our pl/sql ETL processes. To bring in CVSNT into a dynamic company such as Estee Lauder, a large amount of database and source control was necessary. I also create, and configure Oracle databases, tablespaces, perform datapump exports and imports, properly setup up memory configuration, and handle any production support questions.

I created a data model for bringing in new clients of Estee Lauder. Each new client has their own needs for what needs to be stored in our database, to be shown in their websites. At Estee Lauder, we have 35 brands of products in 170 countries, each combination is a schema. For each schema, for example, Clinique-China, we would call the schema clcnweb. These schemas would actually have 4 instances on 4 different servers, one for Development, Testing, Staging, and Production. The database had to be architected this way for CVSNT promotions. Many schemas unfortunately did not have all these for instances, this had to be fixed. At Estee Lauder, we have a several Terabyte warehouse. This warehouse stores all aggregated information for all 35 plus brands, for all 170 countries. On a daily basis, we have materialized views that are executed, which populate these historical tables for reporting. We use numerous bitmap indexes, partitions, pruning, and analytic functions to pull out this information, mostly sum over, ranking, etc.

Our migration work is all based on fully documented ETL procedures. The first step is to meet with users, and build a mapping document between the old system and the new system. Before we load any data, we go through a data cleansing process, and load data into temporary tables. All data brought over is also logged into audit tables. We build ETL scripts and test for accuracy of data and that the process can be reliably repeatable. Another part of the process is making sure that the data is loaded as efficiently as possible. Because we are using PL/SQL for the ETL process, the process is very flexible and changeable. All processes take advance of parallelism, forall and bulk collect. Given that we often bring over numerous tables from an old system, we create migration scripts for each table, making the whole process very modular. Part of the data cleansing process is normalizing the data when appropriate. I spent several months working with Oracle ODI to help in working towards to a better approach. I created several source and target data stores. Setting up a meta repository. I also helped in setting up the fact and dimension tables. I created many bitmap indexes, partitions, and pruning. I created several spreadsheets using VBA for financial reports for management. These reports connected to their Oracle warehouse databases for data. I also created many reports using Crystal Reports for management.

Once the CVSNT process was fully architected, we had to then perform a data scrub of the whole organization, many instances of many brand-region combinations had source code that was different from development, so a large scale business activity ensued. CVSNT was incorporated into SQL Navigator via Team Coding connections. A build_make shell script was created such that when any committed source code change would automatically be called to keep database source in sync. On promotions, this build_make.sh script would take the changed source code and promote this source to the target environment. This was a very large architectural undertaking. This build_make.sh script was able to determine the source db info and target db info, and bring the source code from the repository to the target environment. The CVSNT processes are running on a Linux VM and the database is Oracle 11gR2. Flow charts created to describe the whole CVSNT process using Allclear Flowcharter software. Earlier in the process of using CVSNT, Visio was used, we switched because management liked Allclear better.

All pieces of this Oracle/CVSNT architected solution has been put into complete documentation. Documents for Administrators, promoters, and developers to perform their jobs using SQL Navigator tied to CVSNT.

At Estee, we update each brand/countries website every 5 years, so there is always ETL migration work. Moving the older data to the newer systems and altering the data to fit the new system. I’ve done dozens of these migrations as well. Our migrations involve updating, adding or removing procedures, packages, triggers, functions, tables, indexes, views, etc. Our migration/ETL work is done using PL/SQL scripts. All reporting that we do takes advantage of reference cursors. All product catalog information for websites all over the world, are updated via Materialized views. When customers opt in to any of our websites, they have to accept certain criteria such as our privacy policy; we use BLOB columns to store this information amongst over uses as well. To extract any of our privacy policy information, we use advanced XML. These migrations were 50% Oracle to Oracle Migrations and 50% Sybase to Oracle Migrations.

One part of the tuning process is having a very good knowledge our data, as well as having a properly modeled data model allows us to take advantage of the best sql tuning strategies. All our websites take advance of Oracle RAC, we use 2 node clusters. When any product prices change, we use advanced queuing and Streams for storing and retrieving messages to know how to adjust prices for the particular brand and region. Many of our management sales reports are delivered using Excel and VBA. Sql Server

Responsibilities:

• Participated in meetings for gathering functional requirements and served as the primary point of contact for most of the Enterprise Business intelligence design and development.

• Involved in creating database objects like tables, views, procedures, triggers, functions using T- SQLto provide definition, structure and maintain data efficiently.

• Involved in installing and maintaining MS SQL Server 2008R2.

• Designed SQL Server Integration Services (SSIS) packages to extract data from different sources to SQL Server Data Warehouse.

• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.

• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc

• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.

• Created SSIS packages for importing the Excel layouts into the database using SSIS.

• Developed, deployed and monitored SSIS Packages for pushing dada from SQL Server to MS Dynamic NAV.

• Performing the tasks of data conversions, lookups, adding derived columns, sending results in mails is done by making use of various tasks in SSIS for the data cleansing and auditing.

• Generate Reports Sales Order Report and Invoice reports by using SSRS.

• Created reports for users in different departments in the organization using web-enabled services in SSRS.

• Created Drill-down, Parameterized and Sub-Reports using SSRS. Environment: SQL Server 2008R2 enterprise edition, BIDS, SSRS, SSIS, MS Dynamic NAV and Microsoft Office 2007.

Consultant

Verizon Wireless, NJ November/2010 – January/2011

Oracle 11g PL/SQL development, shell scripting

This was a temporary assignment. Most time was spent performance tuning various running SQL statements. I fine-tuned various packages for performance. Oracle PL/SQL Development

Jefferies and Company, NY June/2010 – November/2010 VBA, Data Warehouse support, ETL, shell scripting (Full time) I worked on several projects including supporting many websites for database support. I created and altered numerous packages, procedures, triggers for these sites. Many management reports were also created.

Jefferies and company has a huge, multiple Terabyte database which gets populated on a daily basis, mostly stock and bond information. Materialized views exist for populating these historical data. There are at least 6 dimensions minimally including counterparties, Fitch, Moody’s and other ratings agencies. I did create reports out of this warehouse. I created many spreadsheets using VBA for product sales. Management also needed reports via Business Objects and Crystal Reports.

I created several ETL PL/SQL scripts for data migrations. We brought in SQL Server and Sybase data into Oracle. This was in support of a large data warehouse. I performed data cleansing strategies for normalization, and business rules. I met with several business analysts. Consultant

Cognizant NY/NJ (Full time) January/2010 – June/2010 Oracle

I supported and enhanced a Mortgage back securities program written in Powerbuilder. I also created and supported, and tuned, several PL/SQL programs in support of this Mortgage program. I also created numerous Crystal Reports for this Mortgage program. I create several core Java programs for reporting on the mortgage data that was brought into the system Sql Server

Responsibilities:

• Worked with data modeling product support team on tool features, functionality and maintenance.

• Involved in installing SQL Server 2005 and Management tools using SQL Server Setup Program.

• Involved in the creation of database objects like tables, views, stored procedures, triggers, functions etc using T-SQL to provide structure to store data and to maintain database efficiently.

• Wrote standard and complex T-SQL Queries and used joins and stored procedures to make sure results matched back to expected results based on business requirements.

• Run Import/Export wizard to provide CSV and Excel files to managers for the particular records they want for different meetings.

• Designed and developed SSIS (ETL) packages for migrating and transforming data from multiple sources like SQL Server and other sources so that it can be used and fed into the data ware house for reporting services.

• Created SSIS Packages to perform filtering operations and automated it to import the data on daily basis from the sources to SQL Server.

• Designed reports in report designer with end user interactivity by using parameterized and drill through features in SSRS.

• Automated certain jobs on daily basis for fresh data. Environment: SQL Server 2008 enterprise edition, BIDS, SSRS, SSIS, SSAS and MS Excel 2007. Oracle DBA, Data Warehousing Septemeber/2009 – December/2009 support, ETL work, SQL Server, VB6

This was a very temporary role as an apprentice to learn how to become a production Oracle DBA. I worked with Oracle database control and Oracle grid control. I also helped set up a program which could store all SQL performance information so that the firm would know where all bottlenecks were. We had automatic pulling of AWR information from Oracle into this repository for reporting purposes. The tool used was dbTrends. I helped in setting up ASM, and RAC configurations on Linux. Many reports were created using Crystal Reports. I provided several migration / ETL scripts for bringing Oracle 10g data into Oracle 11g for several website upgrades. I was responsible for helping to populate our data warehouse by creating numerous materialized views. Data is populated twice a day via dbms mview procedures. We used bitmap indexes, partitions, and pruning.

Customization responsibilities included extending Moody’s suite of products through VBA, creating customized Visual Basic 6 stand alone applications that interfaced with Mortgage product's through COM or directly with the Moody’s database in Sybase or Microsoft SQL Server, and creation of customized reports for Moody’ products. NY (Consultant) February/2009 – September/2009

Oracle PL/SQL developer on large SAP implementation, shell scripting, Data Warehousing, ETL work, VBA, Sql Server, VB6

All the reports in the Banner system are designed using JSP. I created a lot .JSP programs for showing this accounting data.

I supported the SAP developers by helping them to create SQL queries, by helping them to understand what Packages, Procedures, Functions, Triggers, etc were. This was mostly a teaching assignment, all developers at this college were SAP developers, and didn’t understand SQL. I trained them on how to use PL/SQL for their reports. SCT Banner from SAP was used in this project. I had to create several accounting reports using VBA, pulling data from both SQL Server and Oracle.

A interfaced was installed that runs on Windows, connecting to the current system using Visual Basic 6.0, Crystal Reports and MS SQL Server. I was involved in created an application to consolidate all their reports with the different classes to minimize the time spent from running their reports per class. Our Crystal Reports were based on students and teachers. The application was created using VB6 and the server using MS SQL Server 2005. All college data gets updated into large ware houses on a daily basis. Materialized views are used for this purpose along with PL/SQL ETL procedures. I worked on numerous reports to pull out data. We performed several migrations from Sql Server to Oracle. NY (Consultant)

New York University – New York, NY July/2008 – October/2008 Oracle DBA

This was a very temporary assignment. I was tasked with showing and documenting to management the strategy to implement a zero downtime strategy. I helped to install and configure an 8 node RAC configuration on Linux, and setup ASM. I also setup Grid Control to help DBA’s view their activity.

Consultant

Computer Sciences Corporation, NJ June/2008 – July/2008 Oracle Developer DBA / Oracle DBA, shell scripting This was my first stint as a Developer DBA. I setup many Oracle RAC instances along with Grid Control. I was also involved with setting up RMAN scripts and Dataguard installations. I also performed production support on numerous RAC installations. I also created several non RAC Oracle instances. I also created and supported several stored procedures for reporting purposes.

Consultant

Weil Gotshel, NY January/2008 – April/2008

Oracle Developer, shell scripting, Oracle 9i forms. For this assignment, we used Oracle Text to help lawyers find what they needed while in court. Some admin reports and forms were created using Oracle 9i Forms. Unfortunately, this assignment ended early because the Oracle text program did not function correctly. Consultant

Credit Suisse, NY September/2006 – December/2007

Oracle and Sybase Dev, mySQL, PHP, PL/SQL, OO PERL, PowerBuilder 6,5 and 9.2, shell scripting, Oracle 9i Forms, Data Warehousing, VBA, ETL work I worked on the CMBS project. CMBS is Commercial Mortgage Back Securities. On a daily basis, Standard and Poors employees enter new deals, when they get a new deal, into a front-end system called CORE. Later on during the day, after this new information in entered, a process takes place that copies this data to a main usable data area they call SFSS. On a daily basis, S&P gets performance data from a company called Trepp, and also, on a daily basis, this performance information also gets copied in to SFSS. I created many management reports using Crystal Reports. Analysts can then use a front-end PowerBuilder CMBS application for handling all their deals, and to look at reports about the data for these deals. The purpose for my job is to make sure that data gets entered correctly into SFSS from either the CORE system or Trepp, and if anything goes wrong, to fix whatever needs to be fixed, and/or alert the appropriate people to fix what is necessary. A second part of my job is getting requests from business analysts, for anything and everything relating to this data in SFSS, and producing the output that they are looking for. Some of this warehouse data had to be pulled into spreadsheets and analyzed using vba.

I handled the backend support for the Oracle 9i, 10g, 11g, and Sybase 11.5 for a large Dutch auction application in which our first client was Google. Many of the brokers who have received offers for stock on our auction are based on various derivative contracts, Interest Rate Derivatives, CDO’s, Equity, Credit, and Commodity Derivatives as well. On any given day, I am involved in one of several work processes, including the creation and maintenance of Stored

(Packages, Procedures, Functions, and Triggers, etc), including Indexes, Sequences, Tables, etc. Other tasks that I handle on any particular day include Optimization of Oracle objects using tools such as Statspack, etc, using Analyze with tables and indexes, using Oracle Trace, etc. I also handle the Importing and Exporting of data between numerous schemas; I also perform Sql Loader scripts on a daily basis. I also support RMAN scripts for backup of our partitioned database. Lastly, I am involved quite often in architectural work, including the use of Dataguard, RAC, Materialized views, Star Queries for Data Warehousing, ETL, overall database configuration tuning, testing scripts, Capacity planning, creating and supporting Data Modeling using tools such as Erwin, Sql Programmer, and Toad. We have established dblinks setup for DB/2 using gateway software from Oracle, where we have some client information. All shell scripts used to call our sql and stored procedures were written in Perl. The Time and Labor system at Credit Suisse is Oracle OTL. I did get involved from time to time in either updating some screens or creating new screens. This screens were most enhanced reporting screens for management. We have created many forms using Oracle Forms 9i. We also supported several front-end sales programs written in Foxpro and Clipper, some of the managers their came from an XBASE background. We also converted these systems to php/MYSQL.

I also created a Single-Sign-On solution protecting bank external-facing internet sites. Application was client/server 3-tier web architecture authentication and authorization engine written in OO Perl as a mod_perl Apache plug-in.

• Object oriented (OO) design and development.

• DBI::Sybase; Socket communications & multiprocessing parent/child calls.

• Over 8000 lines of OO Perl code.

• Required heavy real-world knowledge & use of network & internet security toolsets.

• SSL, strong encryption / cryptographic systems.

• Some documentation, client interface, support, training.

• Project included some personnel management over other developers.

• Created automated testing tools.

I implemented an interconnection to Credit Suisse site from FXAll.com, and TheMarkets.com, two major financial portals. The project was a Credit Suisse corporate standard; development was moved to London. Received merit prize & recognition at annual IT departmental meeting. The environment was Perl, OO Perl, Apache mod_perl, cryptography, Sun Solaris, DBI::Sybase, SSO, International banking / financials, web security, authentication, networking. Data gets copied over to large ware houses on a daily basis using CRON, shell scripts, and customized pl/sql programs. We use partitioning and pruning along with many bitmapped indexes.

SQL Developer

UBS Securities January/2005 – September/2006

Oracle 10g PL/SQL Developer, shell scripting, Data Warehouse support The day-to-day activities included creating and modifying of Packages, Procedures, Triggers, Indexes, etc. We supported the numerous websites from the back end. Numerous pl/sql reports were created for populating our corporate data warehouse. Much of the output for the business came via either Business Objects is Crystal Reports. SQL Developer

Credit Suisse, New York July/2003 – December/2004

Oracle 10g, shell scripting, Data Warehouse support We created a system for Dutch Auctions. I was responsible for creating shell scripts for bringing over data from various counterparties such as JP Morgan, Bank of America. We brought this data into a generic set of database tables. We then created scripts to populate very specific tables using aggregation and analytics. We used Business Objects and Crystal Reports for our business reporting. This data was then available to a management program in which managers to access which customers would be able to win shares in the auction. We have many pl/sql scripts, which run daily to update our corporate warehouses. I was involved with several data migrations from Sybase to Oracle, as well as Oracle 9i to 11g data migrations. PL/SQL Developer, Java Servlets

Deutsche Bank, New York March/2002 – June/2003

Environment: UNIX, Windows 2000, Oracle 8i/9i, Java, Weblogic, Visual Basic, VBA, C++. Department Function: Collateralized Debt Obligations (CDO), pricing, monitors. Responsibilities: Develop and maintain hundreds of Oracle objects including Packages, procedures, indexes, sequences, tables, views, and functions, triggers for CDO, mortgage backed securities, Conduits, etc. Developed and maintained VBA, C++, and Java. I Created KORN shell scripts to be called from CRON jobs. I used Toad and SQL Navigator. I also made great use of sql*loader, and export and import. Sql*loader is being used for loading data from legacy databases, including Paradox and Access databases.

PL/SQL, Java Developer

Picatinny Arsenal, NJ February/2001 – February/2002 Responsibilities: Creating and supporting all the usual Oracle objects such as Tables, Views, Procedures, Packages, Triggers, Indexes, and Sequences; I also handled performance tuning, and importing and exporting data.

Environment: UNIX, Pl/SQL, Oracle Forms, Oracle Reports, Stored Procedures, Sql*Loader Java Stored Procedures, Visual Basic 6.0, COM, DCOM, COM +, Active X, XML Development. I am responsible for the creation of oracle objects for an Oracle IFS (Internet File Server) knowledge base web site. The database is Oracle 9i. This site allows for searching for documents based on text within the document, various aspects of the document, like file size, name of document, etc. Files can be uploaded in the knowledge base through the web site, documents can be version controlled. Access control lists are used so that users with certain permissions can view these documents, certain users can remove documents, link documents to various folders. We used ASP with these IFS web sites. The IFS front- end was built using Java, JSP, and Servlets.

We also stored XML documents in IFS, using many XML features including DTD, XSLT, XSD, XDK, and XKU.

Development was done using Oracle Forms and Reports; I created and maintained various objects, including procedures (Java and PL/SQL), packages, tables, views, functions, indexes, sequences, partitions, synonyms, etc. I used ETL for loading data into an Oracle Warehouse. I maintained and supported an application written in VB, using COM, DCOM, COM+, and Active X. This application is used for storing and reporting on government weapons that are being researched.

PL/SQL, Java Developer

Milton Haber, North Miami Beach, FL August/1998 – July/2001 Responsibilities: I worked on Oracle objects for two different web sites, procurement, and scheduling. Many of these front ends were built using JSP and servlets. Environment: Linux Pl/SQL, PowerBuilder, Stored Procedures, Sql*Loader All procedures and functions are stored within packages.

Contact this candidate