Candidates About

                                                                     Arun Jain                                              

SUMMARY OF QUALIFICATIONS

 

A dedicated individual with over 22 years of experience and strong academic background.  An extensive knowledge of Computer Science and excellent analytical skills.  A proven ability to prioritize tasks and forecast schedules accurately.  The capacity to motivate others to complete the tasks on time and pricing budgets.  Computer skills include:

 

Hardware          Sun E5500/4500, HP-9000, IBM RS/6000, IBM Mainframe, Compaq, IBM PC/AT, MicroVax II, DEC VAX 11/750, Window 2003 Server

 

Software           HPE Autonomy v11.5, Oracle 12c/11g, PL/SQL 12c, Sql*Developer v4.1.2, TOAD v12.6, Informatica 9.1, TortoiseSVN, JIRA, IBM CEDF/TRIRIGA, Ant, Oracle EBS/ERP R12.0 (Oracle Financials App), FFMS, Oracle 9iAS/9ids, Oracle Apps 11i, IBM Oracle Forms/Reports Server, OEM, Data Pump Export/Import 10x, Sql*Loader 10x, Oracle Discoverer 10g Reporting tool, BusinessObjects XI, Apache Server 1.3.x, Tomcat 3.2.1, PVCS, Visual Source Safe (VSS), Data Warehousing: Informatica PowerCenter 1.x / PowerMart 4.5.x (ETL); OLAP, Unix Shell Script, Oracle Replication Manager, Oracle8i Lite, ERWin, Booch methodology, MS Access 97/2000, COBOL, DB2/UDB, JCL, C

 

O/S                              Windows Server, SunOS 5.x Unix, Windows NT 4.0/Server, IBM AIX Unix V4, HP-UX Unix, MVS, VMS, MS-DOS 6.x

 

EDUCATION

·         M.S., Computer Science, Queens College (City University of New York), Flushing, New York

·         M.S., Mathematics, Maharaja Sayajirao University, India

 

Certification Achievement

·         Active Comptia Security+ certificate

 

Personal

·         U.S. Citizen; Active DoD Top Secret Clearance

 

PROFESSIONAL EMPLOYMENT

 

UCS, VA                                                                                                                       12/16 – 05/2018

Sr. Oracle Database Analyst (SME)

 

Software:  Oracle 12c, PL/SQL 12.x, Sql*Developer v4.1.2, TOAD v12.6, Informatica 9.1,

                  TortoiseSVN, JIRA, ERWin, XML, XSD, HPE Autonomy V11.5

OS/HW:     Windows 7 Enterprise Professional, Linux

 

·         Primary responsibility is to support the FinCEN (Financial Crimes Enforcement Network) applications for the Department of Treasury that collects and analyzes information about the financial transactions to combat domestic and international money laundering, terrorist financing, and other financial crimes

·         Worked on HPE Autonomy to index the selected attributes to store in the memory. Autonomy interfaces with Oracle database to retrieve the data from the database based on the FinCEN Query (FQ) selected by the end users

 

 

ARUN JAIN                                                                                                                   Page: 2 of 4

 

·         Designed/developed/implemented the FinCEN application by processing the external source data that is received in XML format. Using the Informatica, the data of CTRX (Currency Transaction Report) and FBARX (Foreign Bank and Financial Accounts) forms get Extracted / Transformed / Loaded (ETL) into FinCEN application.

 

Buchanan & Edwards, VA                                                                                                        06/16 - 11/16

Sr. Database Analyst (SME)

 

Software:  Oracle 11g, PL/SQL 11.x, Sql*Developer, TOAD, Informatica PowerCenter 9.1,

                  TortoiseSVN, JIRA, ERwin

OS/HW:     Windows 7 Professional

 

·         Primary responsibility was to support the Federal IC application that helps the agent to quickly locate the information that is most pertinent to their investigations.

·         Supported daily production monitoring for Daily Ingest Data of various dataset and act accordingly in case of any discrepancies. Implemented the ETL pipeline queries to ingest the data automatically.

·         Performed analysis, design, development, testing, and Implementation of the Visa Data Mart system in the Data warehouse environment using Informatica and Oracle Stored Packages / Procedures / Functions and other tools.

·         Performed data migration, Extraction, Transformation, and Load of data from different sources into the Staging area of the Data Mart system. Endeca/Solr team extracts the data from the Oracle database and index them (putting into the memory) for the faster retrieval used by the end users.

·         Analyzed the stored packages for Batch Search job data to improve the performance using Explain plan.  Improved the performance from on average 8 mins to 4 secs to support the GUI team.

·         Implemented Logical/Physical data models and entity relationship diagram of new/existing database using Erwin forward/reverse engineering.

·         Experienced working with JIRA management tool to track the daily development/production issues.

·         Maintained check-in/check-out of all the Oracle database objects/readme deployment script into SVN to deploy into Integration (UAT) and Production environment.

 

CACI, VA                                                                                                                      05/15 - 06/16

Database Analyst, Principal

 

Software:  Oracle 11g, PL/SQL 11.x, Sql*Developer, TOAD, IBM CEDF/TRIRIGA systems

OS/HW:     Windows 7 Professional

 

·         Worked as a Technical Project Lead to support the data migration of the NexGen Data Conversion project.  NexGen project supports the Air force base inventory data using IBM CEDF (Civil Engineer Data Framework) and TRIRIGA systems. The goal is to automate the execution of the jobs being submitted thru CEDF in order to process, validate and migrate the data.

·         Designed, Developed, Unit tested the stored packages/procedures/functions and SQL queries, and implemented the automation system into the production environment.

·         Regularly conducting a weekly meeting to get the status from the team and creating a Meeting Minutes.

 

CACI, VA                                                                                                                      06/12 - 05/15

Sr. Database/Data Warehouse Lead

 

Software:  Oracle 11g, PL/SQL 11.x, Sql*Developer, TOAD, Informatica (ETL), TortoiseSVN, Ant

OS/HW:     Windows XP Professional, Windows 7

ARUN JAIN                                                                                                                   Page: 3 of 4

 

·         Worked on data migration from the Investigative Management System (IMS) application to IMS Data Mart (DM) for the Department of State (DS).  IMS keeps track of all the applicant’s Visa and Passport information. This system also helps to crack down illegal Visa and fraudulent passports for the people who used for their own benefits.

 

·         Solely responsible for IMS DM application to manage for the client that includes gathering the new requirements, modify the design of the logical/physical models, development, unit testing, code review, managing the code in Subversion, and finally, used the subversion to create the build for deployment into Test, QARAC and Production environments.  Using DMS (Deployment Management Systems) application to create the deployment details, and after management approval, the deployment build is executed in the intended database environment. Solely responsible to troubleshoot and resolve the clients' issues for IMS DM in production.

·         The IMS application’s data structure was flattened means all the Objects and Varray types’ attributes used in the tables were replaced with the normal attributes either within the table or by creating a new child table. Modified the IMS DM data migration packages to take this flattened structure to migrate the data into IMS DM.  Created the deployment scripts to deploy all the modified objects (packages, tables, grants…) for QA Testing, and finally into Production.

·         Re-factored the design of IMS DM and implemented the code logic using Informatica (ETL tool).  Also, wrote several ad-hoc queries and created ad-hoc jobs using Informatica (ETL tool) to reconcile the data between IMS application and IMS DM.

·         Mentor developers working in our team and worked with Agile development framework environment.

 

ALTA IT Services, MD                                                                                                  02/12 - 06/12

Consultant (Sr. Oracle Developer Analyst)

 

Software:  Oracle 10g, PL/SQL 11.x, TOAD, SQL Developer, SQL*Loader, TortoiseSVN

OS/HW:     Linux Red Hat Enterprise Edition 5.5, Windows XP Professional, HP x86 Intel 64bit

 

·         Designed, Implemented and Maintained the Consolidated Law Enforcement Operations Center (CLEOC) application.  This system is being used by Naval Criminal Investigative Service (NCIS). The system keeps track of all criminal investigation done domestically and internationally for the Military and Civilian personnel by creating the cases and report the status of their investigations within CLEOC

·         Interacted with the client to understand the business rules and enhanced the CLEOC functionality

·         Wrote Stored Procedures, Functions, Packages, Triggers, Views to implement the existing CLEOC

·         Used TortoiseSVN for check-in/out the Oracle scripts/objects

 

CACI, VA                                                                                                                      10/04 - 12/11

Sr. Oracle Developer/DBA Analyst

 

Software:  Oracle 11g/10g, PL/SQL 11.x, Oracle E-Business Suite/ERP R12.0 (Financials Application), FFMS, Discoverer Reporting Tool, TOAD, AWR, SQL*Loader, Oracle Forms/Reports, Unix Shell Scripts, BusinessObjects (BO) XI, BO WebIntelligence, Erwin 3.x

OS/HW:     SunOS 5.10, Windows 2008 Server, Windows XP Professional, Sun E5500

 

·         As a FMS Lead – Responsible for supporting the Federal Financial Management Systems (FFMS) maintenance and enhancement project for Military Sea Lift Command (MSC).

·         Wrote/Modified/Maintained/Tuned several programs for the various FFMS modules (Projects, PO, A/R, A/P, GL and HR) on Oracle 11g database using TOAD, PL/SQL. Performed Unit & integration testing on ERP Changes. Used Oracle Forms/Reports, Discoverer Reporting tool and Unix Shell scripting to automate the load process to load the data into materialized view. Used Sql*Loader to load the data into the Oracle database. Used AWR and Explain Plans to improve the queries.  Mentored junior developers.

·         Installed/Maintained/Supported in-house an Oracle 11g database for the Development/UAT environments on Unix Server for FFMS application.  Refreshed the database from production dump using Data Pump Export/Import utility.  Used OEM tool for various tasks.  Used Cronjob for nightly database backup

 

ARUN JAIN                                                                                                                   Page: 4 of 4

 

·         Resolved client issues given in the form of ICCRs and provided technical solutions to the FFMS team members. Documented the comprehensive Technical and Installation guide.

·         Worked on SPS Increment 3 application for the Department of Defense (DoD) in the Data Warehousing environment. Installed BusinessObjects XI on Windows 2003 Server. Built Universe of SPS I3 system using BO Designer. Created several canned and adhoc reports using BO WebIntelligence. Worked on Gap Analysis from SPS Increment 2 to SPS Increment 3 application

·         Given presentation on FMS, ESPP and MS Vista Operating System. Contributed for the peer review of the documentation as requested.

 

Savantage Solutions, MD                                                                                             07/03 - 08/04

Sr. Oracle DBA in Govt. Finance/Data Warehouse Environment

 

Software:    Oracle9i/8i, Oracle 9iAS r2, Oracle Forms/Reports 6i Server, Oracle 9ids, Oracle Apps 11i, PL/SQL 8.x, PVCS 6.8, Export/Import, SQL*Loader, ‘AT’ utility

OS/HW:      Windows NT 4.0, SunOS 5.8/9 Unix, Sun E4500

 

·         Installed the following on Windows NT platform for JFMIP, govt. financial application software:

o    Oracle 9i/8i database and Oracle Forms6i and Reports6i Server

User can able to access Forms/Reports using client/server connection and thru Web

o    Oracle 9ids (Client Version) for several users. Configured Oracle Warehouse Builder (OWB)

·         Oracle 9iAS release 2; Configured the following components:

o    Forms Server / Reports Server / Discoverer

·         Installed Oracle 9i database on Sun Solaris Unix platform for the FFMS Data Warehouse project

·         Installed Oracle Apps 11i on Windows platform

·         Using AT utility, schedule jobs to take logical backups for four different instances:

JFMIP2 (Dev), JFMIP1 (QA), JCERT (Certificate) and JWINR (for WinRunner)

·         Migrated database from one instance to another using export/import tools.  Populated data into Oracle using SQL*Loader.  Written/modified and tuned the PL/SQL scripts based on the specifications

·         Monitored databases on daily bases and supported the development team with any database issues

 

Nextel Communications, VA                                                                                         05/02 - 04//03

Consultant (Oracle Data Warehouse Developer/DBA)

 

Software:  Oracle8i, PL/SQL 8.x, PVCS, Unix Shell Script, ERWin 3.5.2

OS/HW:      SunOS 5.6 Unix, Windows NT 4.0; Sun E4500

 

·         Worked the TBS (Telecom Broadcasting System).  It’s a Data Warehousing system that helps in keeping tracks of TRUNKS, CIRCUITS, EQUIPMENTS and PORTS

·         Maintained TBS logical and physical structures on Erwin 3.5.2

·         Wrote PL/SQL packages based on the business rules and Unix Shell scripts to automate the execution of the PL/SQL packages.  Tuned the code for performance boost

·         Created standard document containing several standards such as naming convention to use across the board for designing any applications

 

AcNet Corporation                                                                                                        06/96 – 11/01

Client: Litton PRC, Inc. – Virginia; Consultant (Data Warehousing Developer)  07/98 – 11/01

 

·                     Worked on an ETL projects (IRDM and PTDM) for USPS using Oracle database/Informatica.

 

Client: Booz Allen & Hamilton, Inc. – Virginia; Consultant (Developer)                         03/97 - 07/98

 

·                     Designed, developed, implemented and maintained the Adverse Event Reporting System (AERS) for the Food and Drug Administration (FDA).

 

Client: Litton PRC - Virginia; Consultant (Data Modeler)                                               06/96 - 02/97

·                     Designed Physical and Logical models for the CONUS Freight Management System for DoD.