Warehouse Data

Suhas Sabade

**** ****** **** **: 440-***-****

Leander TX 78641 E-Mail: ********@*****.***

Status : US Citizen

Summary:

●Over Twenty five years of experience in commercial RDBMS, Oracle ERP, OBIEE & Data Warehousing Applications.

●Participated in 4 Oracle ERP Implementations and Data Warehouse Implementations

●Passionate in Design, Development & Implementation of Cutting Edge MIS Reports & Dashboards for Executives.

●Exhibited Extensive experience in Building ERP & Data Warehouse & Reporting Solutions that bring Clarity, Consistency & Transparency in Oracle ERP and OBIEE Reporting.

●Increased Productivity by providing Consistent & Reliable OBIEE Reports in most areas of Business such as Manufacturing, Sales, Marketing, Finance, Warehousing & Inventory Management

Professional RDBMS Expertise:

Over 25 years of RDBMS experience in Oracle Database versions 12c to 6 and OBIEE 11g & BI Applications.

Oracle Developer Tools, Sybase 12.4 and Sybase ASIQ, NCR Teradata . Extensive experience in ERP

Applications ( Manufacturing, Order to Cash & Financials ) and Data warehousing Applications

Hardware: Microsoft Hyper-V based servers – both windows & Linux, RS6000, Sun

Sparc, NCR Teradata, HP9000, HP3000, IBM PC compatibles. IBM

S/390, NCR M/F, ICL M/F, DEC-10, PDP-11, HP-2100A, Micro Systems, Cross Assemblers

Operating Systems: Linux, AIX4.3, Sun Solaris, HPUX, AT&T-Unix, HP3000 MPE, NT4, MS-DOS, VM Windows 3.1/95-98/2000/XP

Programming Languages: PL/SQL, ASIQ-PL, TOAD, C, Pro*C, Cobol, Korn Shell Scripting,

RDBMS & Tools : OBIEE/OBI Apps, Informatica, Hyperion, Developer 2000, Forms 6i &

Reports 6i, Discoverer, Business Objects Reporting Tool, SUPRTOOL, QEDIT, Sybase 12.4, NCR Teradata, Syncsort, fastload, BTEQ

Work Experience :

Feb 2022 – Dec-2022

at TCS for Cisco Systems Remote Job

Oracle - OIC Project as

Production Support Analyst

Joined the TCS Team at Cisco Team for the Production Support work involving bringing in Data from various ERP Systems into Stand alone Oracle OIC Module and Processing the data for Compensation Calculation and Moving the data for various payments and reporting modules. Work involved Control-M, EBS Job Scheduling, Snowflake data Reporting.

Feb 2012 – Dec-2021

Seaman Corporation Wooster Ohio

Oracle ERP/BI Solutions Architect

Joined Seaman Corporation to Participate in Oracle ERP R12.1.3 Implementation and OBIEE ver11g 12c implementation. My main tasks were to work on the Fit Gap Analysis, Order Management, Inventory, Financials Master Data Preparation and Migrate to Oracle from Legacy Systems, Make a Fit-Gap Analysis and prepare RICE Items List for Customization and Implement them. Managed the Implementation of OBIEE 11 & OBIA 7.9.6.3 and OBIA7.9.6.4 with Manufacturing Module as well.

Working on Oracle manufacturing Module was of great interest at Seaman Corporation.

Projects Handled at Seaman:

●Master Data Migration from Legacy System to Oracle R12.1.3

●Vertex Q Series STQ4.0

●AP Checks Printing Program & Positive Pay Accounting

●AR Invoice Printing Program

●Implementation of Oracle Incentive Compensation Module for Salesreps Commission ● System Administration Tasks Setups

●Oracle Alerts Management Tasks in all Modules

●Ceridian payroll Interface to GL thru ADI

●Stabilizing iExpense & workflow Management

●Salesforce.com Module Implementation

●Post Implement Support of Order Management, Discrete Manufacturing & Finance Modules

●Post Implement Support in Sys Admin, in User Management, Security Management

●Post Implement Support of Oracle Incentive Compensation Module

●Post Implement Support of iExpense Module

●Post Implement Support of System Administration in Workflow Tasks

Projects handled as OBIEE Architect:

●Lead a Team of 3 to Implement OBIEE ver11.0 & BI Apps Version 7.9.6.3 & 7.9.6.4

●Supporting OBIEE Modules of Finance, Supply Chain & Order Management, Procurement & Manufacturing

●Designed and Developed several Custom ETLs into OBIEE and associated Reports.

●Designed and Developed hundreds of Key MIS Reports for the Senior Leadership Team & Business Managers

●Designed and Developed Executive Dashboards &Supported.

●Managing BI User Administration & Security

●Source to Target Data Validation

●Data Quality Checking

●Performing as Data Manager

Apr 2007 – ARROW ECS Programmer Analyst to

Jan 2012 Solon Ohio support Oracle Financials

Joined Arrow Electronics to Manage Oracle Applications after Arrow Bought IBM and HP Distribution

Business from Agilysys. I managed the Oracle Financials for Arrow Electronics for 2 years while Arrow Electronics was migrating to Oracle ERP Platform.

Upon separation of System from Agilysys there were a number of challenges and issues to adapt and stabilize the Oracle Applications for Arrow Electronics. Accomplished the following tasks in the process

1)I did a number of AP setups for the Chase Bank and positive pay file generation and automatic transfer to the Bank through the web methods.

2)Modified programs to print the AP checks on the Arrow check documents. It was a great accomplishment.

3)I did set ups for Lockbox process Automation for Arrow. The Bank of America EDI Format 823 files transmission was successfully incorporated into Oracle Apps Automated Lockbox Processing and it is very well stabilized within a short period of time. It was a great accomplishment too.

4)Monitored the daily Invoice Processing and Printing. Initially I did set up of printing the AR invoices at Corporate Office in New York

5)Participated in month end process and worked with Business Managers for closing the Period for the Month.

6)I supported Oracle Applications AP/AR/GL Modules and worked with users to resolve any issues that arose.

Participated in Arrow Oracle ERP Implementation and Contributed in Keylink OFS Integration with Arrow Electronics ASCENT Project.

Participated in KeyLink OFS data conversion for ASCENT Project. I was tasked for the conversion of open AP and AR Invoice data for ASCENT.

Participated in KeyLink to ECS Enterprise Data Warehouse Data Conversion, Integration and Data Quality Checks and data fixes.

Nov 2006 – Mar-2007

Agilysys Inc Solon Ohio

Oracle Financials

Application Developer

Joined Agilysys as a Oracle Applications consultant on a 3 months TEMP to PERM basis in NOV-06. At that time there were a number of issues with AP/AR process. I worked on the following issues and stabilized the Oracle Financials Applications

1)Oracle Alerts weren’t working as expected, causing a lot of wrong emails and confusions. I fixed all the alert jobs and controlled the information flow.

2)AP checks were not getting printed automatically due to missed timings causing the AP manager’s anxiety and our manual effort for dropping the files for printing. I fixed it by solving the problems of Oracle Apps processes and the FTP processes.

3)I worked on many AR jobs code fixes making the processes work fine without causing any problems with user tasks and applications like getpaid(collections).

4)I worked on the AP 1099 for the year 2006. The challenge was adding about 50 PCARD entries manually which were not in Oracle. I worked with AP managers for the automatic filing of electronic copy of 1099 with the IRS website.

I worked on a number of AP/AR jobs related to KeyLink Divestiture.

I worked on a transition plan to take a Lead Role in supporting AP/AR /GL for Arrow from

Apr-2007.

Sep 2006 – Thomson Medstat Data Warehouse ETL

Nov-2006 Ann Arbor Michigan Developer

Joined a team of 6 to develop ETL programs & procedures in Teradata SQL to create a Virtual Data Model linking 2 data models so that the end users will see the two data models as one entity for Clinical Data Reporting.

Thomson Medstat was working with CMS (Center for Medicare Medicaid Services) to integrate the huge CMS database in Teradata with Medstat Application database so that the various CMS bodies can effectively use the COTS (Commercial Off the Shelf ) products for various purposes like Program Integrity, Fraud Detection, Research, Program effectiveness. Thomson Medstat’s ’Decision Analyst’ is a very effective end user Clinical Data Analysis and Reporting tool.

Oct 2002 – SEP-2006

Invacare Inc

Cleveland Ohio

Production

Support/Technical Analyst

Joined as a team member of size 12 that supported a range of applications on a 24X7 basis IT Operations spread on two distinct platforms namely, IBM RS6000 based AIX-UNIX & HP 3000-MPE. Our Team was a part of Large Corporate IT Department that also Housed the Data Center which controls the Global IT Operations and Databases.

Oracle Applications 11i on database 9i :

Oracle ERP for Order to Cash was successfully implemented in Oct-2005 after developing for about 2 years. Post implementation Application Stabilization was a big challenge. I played a critical role in Stabilizing Oracle A/R Module.

I supported Oracle Applications - Oracle HRMS/Payroll, Oracle Accounts Receivables, Oracle Accounts Payables, Oracle Cash Management, Oracle General Ledger, Oracle Fixed Assets which were maintained under Oracle Applications 11.5.9 on database 9i.

I participated as a team member in database upgrade from 8i to 9i and application upgrade from 11.5.6 to 11.5.9. I played a reasonable role in stabilizing the Application and reducing the call volume.

Worked on OnBase documents user and OnBase database user for user data problems. Onbase is the Document Image Repository System for the Corporation and It seamlessly integrates with any system.

Notable accomplishments :

1Testing the Entire Application after the DBAs apply periodic patches.

2Customization of Oracle Reports after every patch. Customization was required for Check Printing Report & Deposit Advice printing Report due to customization of Overlay Document. 3 I redesigned the overlay of Payroll & AP check printing Reports as well as Deposit Advices. Processing

4Customizing new HP Laser Jet 8000 printer & MICR printing for Check printing.

5State Quarterly Wage Listing Reports on Tapes/ Floppies for Government Reporting.

6Checks reprinting. Deposit Advices reprinting for damaged prints.

7I corrected the PL/SQL Package in BEE Interface to calculate the attendance according to the Company Business Rules and Practices.

8I wrote a CRON run unix Shell Program that monitors all Concurrent Manager Jobs and sends an automated email to the listed members for any concurrent manager job that completes in warning or failure displaying the error log in the email text.

9I wrote a customized Oracle AR Collections Report that prints the Balance Due for a given set of parameters.

10I wrote an AP Check Printing Report under Oracle Apps Customized Objects taking the seeded Check Printing Report. This Report was used for Mexico Unit of the Client and to print customized Spanish Verbiage on the Checks and The checks are fed on a pre-printed continuous stationery on a Dot matrix Printer. The Report is being used for more than a year without an issue.

Data Warehouse Application & Business Objects Reporting :

I assumed the primary responsibility of Data Warehouse Application support and Business Objects Reporting Tool.

The data warehousing Application is hosted on a AIX based RS6000 server. The Data warehouse Application gets initiated through a CRON job. The data warehouse Application which starts at 12.00 MN and completes by 6.00 AM in the morning has the following 3 components :

1The ETL process consisting of the data transfer from legacy(Now Oracle Order management) application through a series of JCLs(Now APIs) scheduled on the HP3000/AIX Boxes. In all 26 files cross over from HP (Now Oracle OTC) to IW UNIX server.

2Data Load into Oracle 8i Database through a series perl scripts embedded SQLs & PL/SQLs 3 The Business Intelligence Reporting and Business Objects Reporting.

I was also responsible for Business Objects Server Administration involving, maintaining user profile, Broadcast Agent, troubleshooting user reports, maintaining universes, corporate documents, enhancement of Universes through BO Designer.

Business Objects Help Desk activities is a challenge as there were about 300 BO users and thousands of BO reports run against a host of different databases. I support user requests for Technical as well as Business reporting needs. Over a period of 2 years I have the credit of Stabilizing the Application. Data ware housing and BO Reporting is the most critical Application and the up time was maintained at 99.99 %.

I supported a number of interfaces that transferred data between the two main platforms HP legacy and AIX UNIX.

Feb-2002 – AT&T HR Greensboro NC - Data warehouse Project Systems Analyst Developer Oct-2002 (MIDAS)

Joined the Re-Platform Team to convert the MIDAS legacy system in Teradata on to Health Care Data

Warehouse (HCDW) with Oracle 8i as database, Informatica as ETL tool and Business Objects as Reporting tool. The project objective was to re-engineer the system & making the HCDW inbound/outbound data files conform to HIPAA compliant formats 834, 835 & 837

My role was to convert the historical data for 2000 to 2003 from teradata on to ascii flat files that go into new HCDW thru ETL process.

Dec 2001 – IGI Institute Bangalore. India Student Oracle 8i DBA

Feb 2002

As a part of Oracle 8i DBA workshop training, I was involved to conduct the entire DBA operation in parallel for the existing Oracle Server environment as a team member of size 4. The list of activities conducted were:

1Installing Oracle 8i Enterprise Version.

2Installing Oracle Enterprise Manager

3Oracle DBA Studio

4Creating Database, Taking Backup of existing database.

5Restoring database in new set up

6Conducting DBA operations on data files, redo log files & control files

7Archive log, no archive log operations & conducting crash recovery

8Conducting RMAN backup & recovery

9Conducting performance & tuning

10Analysis of log files & trace files

July 2001 – NC State Department of Health & Human Services Data warehouse

Oct 2001 Developer

My Job involved was automating existing modules and developing new modules of ETL

1I was part of a team that outsourced the data warehousing application in Department of Health & Human Services, North Carolina State Government.

2The application involved extensive coding in Micro Focus-COBOL (COBOL-85), Unix Shell Programming and SYBASE ASIQ RDBMS database & Business Objects Data reporting tool.

3I used my skills and experience to help automate existing manual Extract, Transformation & Load (ETL) process. In addition, I developed new automated ETL process for new source systems.

4The process begins with the Mainframe sending a trigger file to Unix system. Once the Unix system finds the trigger file, the cron job starts the automation process shell scripts that extract the data from Mainframe and transforms the binary files into ascii and loads the data into the Sybase data warehouse.

5I was also involved in the VB6, Oracle8, SQL Server based web application publishing warehouse reports & charts.

Environment : Sun Solaris, Sybase, Unix Korn Shell Scripting, NT, Business. Objects, Sql Server,

Oracle8, VB6, ASP, SAS-MDDB, IBM S/390

Apr 2001 – Jul 2001

City of Chicago Tax Department

Oracle 8i Developer

My Job involved was extensive coding in Developer 2000 Forms, Reports and Procedure Builder Modules of Tax2 System.

1I was part of the team that outsourced the Tax Audit & Investigation Systems of the Internal Revenue Department for City of Chicago.

2The environment was in Unix/NT Oracle 8i database & Oracle developer 2000 products.

3Phase-I was already in Production and maintained as a Keane engagement. In Phase-II New modules are added for Tax & Investigation. I joined Phase-II team, development of Field Audit component of TAX2 system.

4Extensive coding in Oracle Developer 2000 (8i products – Forms 6i & Reports 6i) Environment: NT-Oracle, Win-98, Developer 2000 (Forms 6i, Reports 6i).

Feb 1999 – AT&T HR Greensboro NC - Data warehouse Project Senior

Mar 2001 (MIDAS) Consultant

Medical Information Data Analysis System is a data warehousing Application for AT&T and Lucent HR Benefits Planning. The system consisted of Health Information data feed that comes from 10 different Insurance carriers including Aetna, Cigna, BC/BS, Prud, United, RX etc in IBM Tapes.

The key areas of application were to collect the medical, Prescription Drug & Dental data from various insurance carriers and do the ETL processing into the data warehouse.

My Job involved in TERADATA data warehouse ETL processing was :

1Production support

2Teradata warehouse Database Administration

3Module enhancements and

4New module development

The ETL Process involved was to transfer the IBM files from mainframe S/390 to Hrtera NCR Unix box thru NDM Connect Direct file transfer running JCLs on mainframe.

Data validation was done through a series of C programs using automated Unix Shell scripts.

Data preparation & sorting using SYNCSORT utility.

Data loading into Data warehouse using utilities FASTLOAD & BTEQ Korn Shell programming for process automation.

Database Administration, Adhoc query Reportng & performance monitoring & tuning.

Notable contribution made to the MIDAS System include:

1Introduction of production data scrub processes to reduce the errors.

2Improvements in ETL processing.

3Improvements in production Process monitoring, logging & error reporting

4Accomplishment of a one time project of separation of Lucent Data from AT&T data warehouse 5 Adding a new module of AT&T Dental Data processing.

6 Converting the production process steps into phases of Production Runs and introduction of client sign off for each phase.

Environment :

NCR Teradata V2R3.0, AT&T Unix, BTEQ v5.02,

Fastload v7.02 Syncsort, Korn Shell,

Oracle 8, Business Objects, Oracle Express MDDB front end operation

Jan 1998 – Feb 1998

Dept of Workers Comp at State of Ohio Columbus Actuarial Systems Development

Cobol

Programmer Analyst

1.Cobol programmer on NCR main Frame and Various Reports Development using Super Tool

Jan 1993 – HMT India. ERP Application of Computerized Online Project

Dec 1997 Manufacturing System (COMS) Leader

2.The ERP Application was consisting of 2 phases viz Phase-I for Procurement Modules and Phase-II for Production Modules.

3.I was the Project Leader for 4 ERP modules of Procurement Process Phase (Material Planning, Purchase, Stores & Quality Inspection). I was also the DBA for the 4 ERP Modules.

4.I conducted structured system analysis, determined user requirements, and developed methods and procedures for system operators. I did extensive coding in Oracle Forms/Screens, Pro*C, Reports and Menus. Each of the modules contained 100s of Forms, Reports, Pro*C programs, PL-SQL program scripts and SQL*Plus scripts.

5.I did production support and resolved production problems, enhancing user screens to increased efficiency and provide solutions to user needs

.

Environment: HP 9000 Host server, HPUX, Oracle 6/7.3, Pro*C, SQL* Plus, SQL* Forms, SQL* Report

Writer VT100 terminals, MS-DOS & Emulation

Feb 1992 – HMT India. Financial Accounting System (Monthly Team Leader

Jan 1993 Batch Processing)

1lead a team of 4 members on the design and development of Financial Accounting System including Material Accounting & Product costing.

2This System was implemented in Oracle 6.0/7.3 with Pro*Cobol, Pro*C, SQL* Plus, SQL* Forms, SQL* Report Writer in HP 9000 800 Series RISC based business server environment. 3 I worked as the DBA for the Financial Accounting System

Environment : HP 9000 Host server, HPUX, Oracle 6/7.3, Pro*C, SQL* Plus, SQL* Forms, SQL* Report Writer VT100 terminals, MS-DOS & Emulation

Education :

Karnataka Bachelor of Science in Mathematics and Mathematical University Statistics.

Contact this candidate