ARCHANA KIRTANE

**** ******* **** *****, ** *****, USA, (M): 614-***-****, EMAIL: ac0evb@r.postjobfree.com

PROFESSIONAL SKILLS

INNOVATIVE IT PROFESSIONAL POSSESSING STRONG ANALYTICAL AND REASONING SKILLS.

POSSESSING 10 YEARS OF EXPERIENCE ON PROGRESS 4GL/ OPEN EDGE ABL DEVELOPMENT

4 YEARS OF EXPERIENCE INTO QAD MFG/PRO ERP SYSTEM AND PROGRESS 4GL DEVELOPMENT INTO QAD

3 YEARS OF EXPERIENCE INTO MORTGAGE INDUSTRY- JP MORGAN CHASE, NATIONWIDE INSURANCE

1 YEAR EXPERIENCE ON UNIFI

BUSINESS AND SYSTEMS ANALYSIS EXPERIENCE FOR ABOUT 5 YEARS

MANUAL TESTING & AUTOMATED TESTING EXPERIENCE OF 10 YEARS

PROGRESS DBA EXPERIENCE OF ABOUT 1 YEAR IN INDIA & 1 YEAR IN USA- DATABASE MAINTENANCE, DATABASE REPLICATION,

BACKUP & RECOVERY, AFTER IMAGE (AI) & BEFORE IMAGE FILE MANAGEMENT (BI), STARTING & STOPPING DATABASES.

MOVING PARSERS

PROGRAMMING LANGUAGES: PROGRESS 4GL (EB2, EB2.1, EB3) 9.1D, 10.1D, 11.0, 11.2, WEB SPEED 11.0 ON UNIX

OPERATING SYSTEM, PUTTY, SVN TOOL, JIRA TOOL, MICROSOFT WORD, EXCEL, POWER POINT, PROGRESS OPEN EDGE 11.2.

QAD MFG/PRO (CHUI, GUI, NETUI) - MANUFACTURING, DISTRIBUTION, FINANCE, EDI(EDI DOCUMENTS 214, 310,

850, 855, 856, 861, 810, 860, CREATING SNF FILES, LOADING & UNLOADING TRADING PARTNER, MODIFYING TRANSFORMATION

ETC.), WAREHOUSE, EUROPEAN ACCOUNTING

CUSTOMER SUPPORT EXPERIENCE & SDLC EXPERIENCE, AGILE METHODOLOGIES

BASIC KNOWLEDGE WITH OPEN EDGE APP SERVER (APPLICATION SERVER)

WORKED ON OPEN EDGE ECLIPSE, PVIEW (PROCEDURE EDITOR) & OPEN EDGE 11.2, JAVA, J2EE

EXPERIENCE INTO MORTGAGE SUPPORT SERVICES (PROGRESS 4GL DEVELOPMENT)

QLIKVIEW DEVELOPER & DESIGNER TRAINING & WORK EXPERIENCE

CERTIFICATIONS AND TECHNICAL SKILLS

APICS - BASIC SUPPLY CHAIN MANAGEMENT (BSCM)

JAVA, J2EE, C, C++, UNIX OPERATING SYSTEM, HTML, SQL

BUSINESS INTELLIGENCE: QLIKVIEW TRAINING

CRYSTAL REPORT SAP CRYSTAL REPORTS & VISUAL CUT 11

TOOLS:

SVN, JIRA

CRYSTAL REPORT, VISUAL CUT 11 (VC 11) & SAP CRYSTAL REPORTS

PUTTY, HARVEST

PVIEW (PROGRESS EDITOR)

OPEN EDGE ECLIPSE

HP QUALITY CENTER ALM

WORK EXPERIENCE

COLLABERA INC ( COLUMBUS, OHIO ) MARCH 2016 PRESENT

CLIENT: NATIONWIDE INSURANCE

PROGRAMMER ANALYST (PROGRESS 4GL/OPEN EDGE ABL)

PROJECT DESCRIPTION:

CURRENTLY WORKING ON NATIONWIDE INSURANCE MORTGAGE FINANCIALS PROJECT AS A PROGRESS OPEN EDGE

DEVELOPER/DBA ON NATIONWIDE UNIFI APPLICATION.

ROLES AND RESPONSIBILITIES:

WORKED ON PROGRESS 4GL 9.1D ON THE MORTGAGE PROGRESS PROGRAMS

WORKED ON FISERV UNIFI APPLICATION

HANDLING THE DAILY PRODUCTIONS DATABASE ISSUES RELATED TO MORTGAGE DEVELOPMENT, ENHANCEMENTS, CODE FIXING,

DEVELOPMENT.

MARKETING DATA, PCI, POWER PRINT PROJECT DEVELOPMENT. WRITING THE PROGRESS CODE TO FROM SCRATCH.

WRITING PROGRESS 4GL BACKEND QUERIES TO PULL THE REPORTS. WRITING PROGRESS 4GL CODE FROM SCRATCH AS PER THE

PROJECT REQUIREMENT

CONDUCTING THE MONTHLY PRODUCTION RELEASE, PERFORMING PROGRESS DBA ACTIVITIES LIKE TAKING PROGRESS DATABASE

& RESTORES, SHUT DOWN AND BRINGING UP THE DATABASES, RESOLVING AI EXTENT ISSUES ALONG WITH THE CODE

BACKUP

DEPLOYMENT INTO PRODUCTION.

PERFORMING THE SOFTWARE/CODE TESTING, UNIT TESTING USING HP QUALITY CENTER ALM TOOL

CREATING TECHNICAL DESIGN DOCUMENTS AND PROJECT REQUIREMENT DOCUMENTS

ATTENDING THE DAILY STANDUP MEETINGS

WORKED ON THE MORTGAGE REFRESH PROJECT GATHERING REQUIREMENT FROM BUSINESS DEVELOPING THE PROGRESS AND

CRYSTAL REPORTS BATCH SCRIPTS, UNIT TESTING THEM END TO END. WORKED ON 50 BATCH SCRIPTS, MOVED THEM TO THE SERVER,

ENHANCEMENT OF THE BATCH SCRIPT CODE, DEPLOYING, TESTING END TO END AND SUPPORTING THE MORTGAGE REFRESH PROJECT

AFTER THE RELEASE.

WORKED ON MORTGAGE REFRESH CRYSTAL REPORTS IN VISUAL CUT - GATHERING REQUIREMENTS FROM BUSINESS & ENHANCING

THE CRYSTAL REPORT BATCH SCRIPTS. INSTALLING CRYSTAL REPORTS VISUAL CUT 11 TOOL. SETTING UP THE REPORTS IN VC 11,

WRITING THE BATCH SCRIPTS & MAINTAINING AND SUPPORTING BUSINESS.

WORKED ON THE FANNIE MAE LOAN LIMIT PROJECT COMPLIANCE PROJECT. GATHERING THE REQUIREMENTS FROM BUSINESS,

CREATING THE TECHNICAL DESIGN DOCUMENTS & ENHANCEMENT OF 50 FANNIE MAE PROGRESS PROGRAMS TO UPDATE LOAN LIMIT

MAXIMUM VALUE. TAKING OFF THE HARD CODING FROM ALL 50 PROGRAMS AND SETTING UP THE LOAN LIMIT VALUE IN A

PARAMETER.

WORKED ON MORTGAGE BOT TSL UPGRADE PROJECT MORTGAGE BOT IS A NATIONWIDE FRONT END APPLICATION WHICH FEDS

WITH CUSTOMER LOAN INFORMATION FROM THE WEB PORTAL. MORTGAGE BOT WAS ON A 2003 SERVER DUE TO WHICH IT WAS NOT

UNIFI. WE MOVED THE PARSERS ON THE 2003 SERVER TO 2008 SERVER AND UPGRADED MORTGAGE BOT TO

ABLE TO TALK TO

TLS.

MANAGING THE PROGRESS DBA TASKS LIKE STARTING & STOPPING DATABASES & PARSERS. CONDUCTING DATABASE BACKUPS FOR

MONTHLY PRODUCTION RELEASES. MAINTAINING AFTER IMAGE & BEFORE IMAGE FILES BY CONDUCTING MONTHLY AI ARCHIVE

MANUAL & AUTOMATIC USING AI FILE MANAGEMENT, REPLICATING THE DATABASE.

COLLABERA INC ( COLUMBUS, OHIO ) OCT 2014 MAR 2016

CLIENT: JP MORGAN CHASE & CO.

PROGRAMMER ANALYST (PROGRESS 4GL/OPEN EDGE ABL)

PROJECT DESCRIPTION:

WORKED ON THE CHASE MORTGAGE PROGRESS 4GL PROGRAMS FOR THE LOAN HOTLISTS & DEVELOPMENT PROJECTS.

WORKED ON 200 LOAN HOTLISTS. CREATING QLIKVIEW DASHBOARDS

ROLES AND RESPONSIBILITIES:

WORKED ON PROGRESS 4GL 9.1D ON THE MORTGAGE PROGRESS PROGRAMS

WORKING WITH END CLIENT, MORTGAGE SUPPORT SERVICES BAS AND RESOLVING THE CODE RELATED ISSUES FOR THEM

CREATING TECHNICAL DESIGN EXPLANATION DOCUMENTS EXPLAINING THE COMPLETE WORKING OF THE HOTLIST

PROGRESS PROGRAM

WORKING ON THE LOAN HOTLISTS & CREATING THE DOCUMENTATION EXPLAINING THE WORKING OF THE PROGRESS

PROGRAM OF THE HOTLISTS.

DOCUMENTING ALL THE TRACKING VARIABLES OF THE HOTLISTS IN THE EXCEL DOCUMENTATION.

DOCUMENTING THE USAGE OF THE TRACKING VARIABLES IN THE EXCEL DOCUMENTS

ANALYZING THE CODE RELATED ISSUES FOR THE CLIENT & SUGGESTING THE CHANGES TO BE DONE IN THE CODE

WORKED ON A LOAN PURGING DEVELOPMENT - DEVELOPED A UTILITY PROGRAMS FROM SCRATCH TO FILTER WHICH LOANS NEED TO BE

DELETED BASED ON THE LOAN DELETION CRITERIA FROM AN INPUT CONFIGURABLE FILE.

CREATED AN OUPUT FILE WITH THOSE LOAN

NUMBERS, CREATED ANOTHER OUTPUT FILE WITH HIDDEN TABLE RECORDS THOSE EXIST IN DB WHICH HAS LOAN NUMBER. WROTE A

DYNAMIC QUERY TO DYNAMICALLY DELETE ALL THOSE TABLE RECORDS FOR THE LOANS TO BE PURGED.

WEEKLY MEETINGS

WRITE UNIX SCRIPTS TO EXECUTE THE BATCH RUN PROGRAMS

QLIKVIEW- IMPORTED THE HOTLIST SPREAD SHEETS INTO QLIKVIEW & CREATED THE DASHBOARDS & A KNOWLEDGE BASE FOR THE

CHASE.

BRAVEPOINT INCORPORATED (COLUMBUS,OHIO)

PROGRESS DEVELOPER A UG 2013 APR 2014

PROJECT DESCRIPTION:

DEVELOPED PROGRESS CODE FOR PROFITZOOM FINANCIALS PROJECT ON PROGRESS 4GL 9.1D, PROGRESS OPEN EDGE 11.2 &

MANUAL TESTING.

ROLES AND RESPONSIBILITIES:

WORKED ON PROGRESS 4GL 9.1D, PROGRESS OPEN EDGE 11.2 AS A DEVELOPER ON ENTERPRISE FINANCIALS

PREPARE BUSINESS REQUIREMENTS DOCUMENT & TECHNICAL DESIGN DOCUMENT

DEVELOP INVOICE CORRECTION FUNCTIONALITY CODE

DEVELOP RETAINAGE INVOICE FUNCTIONALITY CODE

DEVELOP TEST PLAN, TEST CASES IN WORD FORMAT & HP QC/ALM & PERFORM MANUAL TESTING IN JAVA SCRIPT SCREENS

WORKED ON JAVASCRIPT SCREENS.

MAHINDRA SATYAM LTD. (MUMBAI, MH, INDIA)

PROJECT LEAD O CT 2012 - MAR 2013

PROJECT DESCRIPTION:

PROJECT LEAD FOR ARTHREX PROJECT (FLROIDA, USA) ON PROGRESS 4GL 9.1D/OPENEDGE ABL & TESTING CHUI &

GUI

ROLES AND RESPONSIBILITIES:

PREPARE BUSINESS REQUIREMENTS DOCUMENT & TECHNICAL DESIGN DOCUMENT

LEAD AMI SLOWNESS PROJECT & FIXED 300 STANDARDS AND CUSTOMIZED ARTHREX CODE, ALONG WITH CODE

REVIEWS, TESTING REVIEWS, FULL TESTING & DEPLOYMENT

DEVELOP TEST PLAN, TEST CASES IN WORD FORMAT & PERFORM MANUAL & PERFORMANCE TESTING IN CHUI, GUI & .NETUI

CONDUCT DAILY CLIENT MEETINGS

MANAGE A SMALL TEAM AT OFF-SHORE, CONDUCT CODE REVIEWS, TESTING REVIEW, AUDITS

TATA CONSULTANCY SERVICES LTD. (PUNE, MH, INDIA)

I.T ANALYST A PRIL 2012 - MAY 2012

PROJECT DESCRIPTION:

I.T ANALYST FOR JOHNSONS CONTROL ON PROGRESS 4GL 9.1D/OPENEDGE ABL & TESTING CHUI & GUI

ROLES AND RESPONSIBILITIES:

WRITE CODES FROM SCRATCH LIKE CIM PROGRAMS, UTILITIES AND MODIFYING OTHER STANDARD AND CUSTOMIZED PROGRAMS

PREPARE BUSINESS REQUIREMENTS DOCUMENT & TECHNICAL DESIGN DOCUMENT

DEVELOP TEST PLAN, TEST CASES IN WORD & PERFORM MANUAL & PERFORMANCE TESTING IN CHUI, GUI

QAD INDIA PRIVATE LIMITED (MUMBAI, MH, INDIA)

SOFTWARE ENGINEER II J UN 2012 - OCT 2012

PROJECT DESCRIPTION:

TECHNO-FUNCTIONAL CONSULTANT FOR QAD DISTRIBUTION, EDI, WAREHOUSE DEPARTMENT ON PROGRESS 4GL 9.1D

& MANUAL TESTING

ROLES AND RESPONSIBILITIES:

DIRECT CLIENT SUPPORT

MODIFY QAD STANDARD CODES

DEVELOP TEST PLAN, TEST CASES IN WORD FORMAT & HP QUALITY CENTER & PERFORM MANUAL & PERFORMANCE TESTING IN

CHUI, GUI, .NETUI

CONDUCT INTERNAL AUDIT, CODE REVIEWS, TESTING REVIEWS, PEER REVIEWS

PREPARE BUSINESS REQUIREMENTS DOCUMENT & TECHNICAL DESIGN DOCUMENT

ATOS INDIA PRIVATE LIMITED (MUMBAI, MH, INDIA)

SYSTEMS ANALYST O CT 2010 - MAY 2012

PROJECT DESCRIPTION:

TECHNO-FUNCTIONAL CONSULTANT & DBA FOR SCHLUMBERGER (SLB) FOR AMS ARLINGTON TAM & AMS EB2.1 UPGRADE

ON PROGRESS 4GL 9.1D & MANUAL TESTING

ROLES AND RESPONSIBILITIES:

WRITE CODES FROM SCRATCH LIKE CIM PROGRAMS, UTILITIES AND MODIFYING OTHER STANDARD AND CUSTOMIZED

PROGRAMS AS PER THE SLB REQUIREMENT.

PREPARE BUSINESS REQUIREMENTS DOCUMENT & TECHNICAL DESIGN DOCUMENT

DEVELOP TEST PLAN, TEST CASES IN WORD FORMAT AND HP QUALITY CENTER ALM & PERFORM MANUAL & PERFORMANCE

TESTING IN CHUI, GUI

CONDUCT MONTH END DATABASE MAINTENANCE, DATA REPLICATION ACTIVITIES EVERY MONTH

CREATE UTILITY PROGRAMS FOR THE AUTOMATION OF USER VALIDATION ON PASSWORD & PSEUDO FILE

QAD INDIA PRIVATE LIMITED (MUMBAI, MH, INDIA)

SOFTWARE CONSULTANT I M AR 2007 - OCT 2010

PROJECT DESCRIPTION:

TECHNO-FUNCTIONAL CONSULTANT FOR QAD DISTRIBUTION, EDI, WAREHOUSE DEPARTMENT, MANUFACTURING,

EUROPEAN ACCOUNTING DEPARTMENT ON PROGRESS 4GL 9.1D & MANUAL TESTING.

ROLES AND RESPONSIBILITIES:

DIRECT CLIENT SUPPORT

MODIFY QAD STANDARD CODES

DEVELOP TEST PLAN, TEST CASES IN WORD FORMAT & PERFORM MANUAL & PERFORMANCE TESTING IN CHUI, GUI,.NETUI &

PROMON SESSIONS

CONDUCT INTERNAL AUDIT, CODE REVIEWS, TESTING REVIEWS, PEER REVIEWS

TRAIN ASSOCIATES & FRESH RECRUITED GRADUATES

PREPARE BUSINESS REQUIREMENTS DOCUMENT & TECHNICAL DESIGN DOCUMENT

THIRDWARE SOLUTION LIMITED

SOFTWARE ENGINEER J ULY 2006 - MARCH 2007

PROJECT DESCRIPTION:

SOFTWARE ENGINEER ON LEAR HALOL MIGRATION, TSL INTERNAL MIGRATION, BUNGE CLIENT SITE PROJECTS

ROLES AND RESPONSIBILITIES:

MIGRATION OF ALMOST 40 PROGRAMS FROM 8.5F TO EB2.1

VERSION

MIGRATION OF ALMOST 40 PROGRAMS FROM VERSION 8.6E TO EB2.1

TECHNO-FUNCTIONAL CONSULTANT AT BUNGE CLIENT SITE

DEVELOP TEST PLAN, TEST CASES & PERFORM MANUAL & PERFORMANCE TESTING ON CHUI & GUI

TRAIN ON MFG/PRO, PROGRESS 4GL

EDUCATION

UNIVERSITY OF MUMBAI, MH, INDIA

BACHELORS IN COMPUTER ENGINEERING, MAY 2005

DON BOSCO COLLEGE OF ENGINEERING

RANK: 2/60 (71.67%)

MAHARASHTRA STATE BOARD

HIGH SCHOOL SECONDARY CERTIFICATE (HSSC), MUMBAI, MH, INDIA, JUN 2001

VIDYAVARDHINI'S COLLEGE OF SCIENCE

RANK: 3/150 (82.17%)

ACCOLADES

AWARDED SUPPORT SPOTLIGHT OF THE MONTH IN MARCH 2010 BY QAD

AWARDED SUPPORT PERSON OF THE MONTH IN SEPTEMBER 2009 BY QAD

AWARDED SUPPORT SPOTLIGHT OF THE MONTH IN AUGUST 2008 BY QAD

AWARDED SUPPORT SPOTLIGHT OF THE MONTH IN SEPTEMBER 2007 BY QAD

Contact this candidate