* * * * * SMITA R. MODI

Summary

• **+ years of experience with various programming languages.

• Over 20 years in Informix 4GL development.

• Over 5 years in Oracle PL/SQL development.

• Expertise in crafting Oracle SQL & Informix SQL queries and scripts including Stored procedures, packages, and functions.

• Skilled in schema and table design & index creation.

• Hands-on experience in UNIX Ksh scripting for purposes of process automation, data loads/unloads, and file transfers between servers.

• Experience in all phases of SDLC (Software Development Life Cycle) from Requirements gathering to Implementation.

• Proficient in Business requirements analysis, Data architecting, Solutions development, Coding, Test case writing, QA assistance, UAT support, Deployment, Documentation, and Post-production support.

• Excellent communications skills written and spoken. Documentation frequently referenced for thoroughness, accuracy, and clarity.

• Diligent and optimistic personality. Known by peers and user community for enthusiastic, helpful, problem-solving attitude.

Technical Skills

Hardware: IBM P-series, I-series Unix based Enterprise servers. Operating System: AIX Unix, MS-DOS

Programming Languages: Informix SQL, Informix 4GL, Oracle SQL, PL/SQL, Unix scripting. Familiar with Java, C#, Pro*C.

Databases & Tools: Informix versions 3 thru IDS 12.1, Oracle 9i Other Utilities: TOAD, Visual Studio, SCCS, SVN, PVCS, Jira, Git, Crucible, Tivoli Education

Wichita State University: Bachelor of Science Mathematics & Computer Science 1992 SMITA R. MODI

Database Applications

Software Developer

Analyst/Programmer

2509 Willowdale Dr.

Carrollton, TX 75006

adbo0w@r.postjobfree.com

720-***-****

2 P a g e SMITA R. MODI

Employment History

Ettain group @Inmar Intelligence-- Software Developer Ft Worth, TX (2019 - Now)

• Design, development, testing and deploy of Informix 4gl applications.

• Production support of Informix solutions on AIX platform that interact with warehouse supply chain activities such receiving, sorting, and shipping.

• Troubleshoot Jira tickets to identify program bugs/corrections needed.

• Craft SQL statements to apply data correction strategies for production problems.

• Participate in Agile/Scrum activities such as sprint planning, story grooming/sizing, daily standups, deployment, retrospective.

• Provide off hours production support as needed.

ADT Security Services-- Sr. IT. Applications Developer Aurora, CO (2002 - 2019)

• Maintenance, enhancement, reporting, troubleshooting, & user support for Informix applications billing 3M+ customers across multiple Billing, Monitoring, & Financial platforms.

• Active in conversion of programs and data migration Informix v. 9 to 11 to IDS 12.

• Key role in design, construction, and maintenance of ADT Authorized Dealer application. This is a custom-built application launched in mid-1990’s for compensating and incenting dealers to seek out quality customers. The rules table driven design maintains a variety of factors for which a dealer would be paid multiples and bonuses as Funding for selling his customer to ADT for billing and monitoring services.

• Over the years this application has been adjusted, altered, and enhanced to meet business needs of dealers nationwide. The Authorized Dealer program now comprises nearly one- half of ADT’s revenue stream (the other half being Direct side customers).

• With growing pressure from executive level team members to retire Informix, my team members and I have been active in systematically migrating customer population being billed on Informix platform to Oracle MMB platform (direct side). This includes a solo project to modify all Informix Payment Processing applications to identify and redirect customer Credit card, Lockbox, and ACH/CC payments that arrive after the account has been divested.

• Skilled in Unix Ksh script writing for report processing, event automation, data extraction, & file transfers interfacing with internal and external platforms.

• Proficient in crafting Informix stored procedures that perform specific operations for consumption by 4gl programs, and also for invocation by external entities such as MQ Broker and Cold Fusion applications requiring interaction with data stored in Informix.

• Active in troubleshooting and maintenance of real-time transmission solution known as Datalink, a wherein a series of programs written in 4gl and Pro*C components to send Informix customer data via ODBC connection to Oracle for monitoring.

• Proficient in enhancement of PL/SQL packages, functions, and procedures necessary for transforming Informix sourced data records to Oracle destination tables and columns.

• Skilled in writing new SQL queries and optimization of existing queries and scripts for performance tuning.

• Responsible for deploying & configuring latest version of web service tool Apache Tomcat.

• Responsible for upgrading to latest version of Java, including download, installation, and re- compiling of Java based daemon processes.

3 P a g e SMITA R. MODI

• Liaison with internal customers & end users as well as outside vendors for schedule coordination, requirements gathering, testing, and QA acceptance.

• Proficient in writing documentation such as Design Specifications, Test strategies, and Data Dictionary documents.

Royal & Sun Alliance-- Oracle Applications Developer Englewood, CO (1998 - 2000)

• Development of PL/SQL functions and stored procedures on Oracle 7 Data Warehouse.

• Data analysis of customer data of high risk, short term auto insurance policy customers.

• Provide ad-hoc reporting services and statistics to business members for accurate impact analysis of catastrophic events and rate increases. Quest Database Consulting @ADT-- Software Developer Aurora, CO (1996 - 1998)

• Maintenance, enhancement, reporting, troubleshooting, & user support for Informix applications billing 1M+ customers across multiple Billing, Monitoring, & Financial platforms.

• Active in conversion of programs and data migration Informix v. 3 to 7.

• Key role in design, construction, and maintenance of ADT Authorized Dealer application. Paladin Consulting @JCPenney-- Software Developer Dallas, TX (1995 - 1996)

• Design & implementation of Informix 4GL components of Non-Conveyable Receipt Processing subsystem (NCRP) for product warehousing.

• Assist in troubleshooting of warehouse activities pertaining to 4GL applications. Southwestern Bell Mobile Systems-- Software Developer Dallas, TX (1993 - 1995)

• Development and maintenance of Informix 4GL applications supporting customer phone number activation system.

• Write unix shell scripts for report generation and automation of data solutions.

• Provide Production Support as necessary for troubleshooting of applications. Boeing Aerospace Co.-- Software Developer Huntsville, AL (1991 - 1993)

• Enhancement & maintenance of Informix 4GL software utilized for tracking and maintenance of resource data of International Space Station (ISSP).

• Active in conversion of applications, files, & data from Informix SE to Online Engine. Cessna Aircraft Co.-- Software Programmer Wichita, KS (1990 - 1991)

• Development and maintenance of source code in FORTRAN used for conversion & analysis of flight test data to Engineering Units.

4 P a g e SMITA R. MODI

Descriptions of some Projects & Tasks

Make code changes to shell scripts ftpenv.sh, bisftp.sh, post2050ftp.sh, & prepftpf.sh. Execute the scripts from test server and inform Kyle to catch the files on jaxap3077. cust_detail.txt.gz

super_att.txt.gz

achcanc.txt.gz

test.adai2.ADTInfmx.20120824142649000.ebill

test.adai1.ADTInfmx20120619161202680

Code changes to adpcvatoc.4gl for making A C flips automatically have Monthly billing. Unit test and assist Warren Knight with UAT testing. Write documentation for the adpxcaac program. Help Prod Support research problem with Order# 310259829. It had OldANSC Prod $491.88.

• Order was Opened on 3/19 with Ansc Prod $455.88, which corresponds to its monthly service charge $37.99. Thus—the NewANSC amount $36 was subtracted from daily PTD total.

• Order was Closed on 4/13 with Ansc Prod $527.88, due to its monthly service charge having increased to $43.99. This time—the NewANSC amount $36 was added to the daily PTD total. I agree with Bob Wheatley’s assessment. The imbalance was due to this particular order Closed in a different fiscal period from which it had been Opened. The NewANSC total at the end of Fiscal period 6 should’ve been $72 higher. Also, the NewANSC total during Fiscal period 7 is now artificially $36 higher than it should be.

Correct the ACH Returns program (achrtran) so that it better handles failed credits. The logfile indicates a decryption error when the program finds no payment record associated with the failed credit. To test-- Prepare a file to load /prod/rpts/ACH/MELLONachrYYMMDD. Make sure to include at least 1 transaction that is a credit by pinpointing an already existing record that begins with first 3 positions in the data string “622”. Then, to ensure the portion of the code we changed will execute, remove this ba_no’s billing_ach record. This will cause the program to go look for the account’s onetime_ach record. Also, we want that onetime_ach record to be a credit, so set up a bogus onetime_ach record for the customer. VtxDaemon not working on any of the test boxes. With help from Cliff Asselin, got javaenv.sh file re-pointed to new Vertex server sy02720.adt.com and new Trusted_id setting. Download Java 8.64 and install on Dev server. Re-compile all java source code version 6, including background processes VtxDaemon, CryptDaemon, & AddrDaemon. Download Apache Tomcat latest version 9.0.13 and install on all test servers. Prepare documentation for Production Support team member to make same upgrade to Prod server. Assist Prod Support to identify the reason 20.13.13 (trakconv) program causes datalink crashes.

• The problem was occurring when user enters a dealer number > 100,000,000.

• Apply code correction and deploy to production.

• Grant Olson says “Great Job and Thank You to Smita”. 5 P a g e SMITA R. MODI

ADT Dealer License numbers. Stored procedure cal_dlr_license. By designing a new stored proc, I condensed the number of dealer license records reported to adt.com from 3400 to 473 using the following techniques:

• Exclude 240 “bad” dealers by way of exclusion table.

• Fix logic pertaining to Number active licenses.

• Remove references to license_rqmt.lr_code as it's not really needed.

• Add logic to handle the text 'ADT REQUIRED' in license_no field.

• Change selection and ordering criteria to be based on dealer Name instead of dealer Number. This eliminated what the business users consider to be "duplicates". Modify adt_mml_site_system_create PL/SQL function that will identify an MT dealer account from Informix and invoke new function create_job_no_assignment.

• Research for QA folks and for John. Dig into mmsvc, owriter, & xfpxmxfr code to figure out how the ‘#3xxxxxxxxx’ CS number gets transmitted to MMB.

• Research for Ana Vazquez pertaining to Auto Cancellation process and Acmapdca. Help Ana Vazquez figure out why test accounts are not showing up with jobs on MMBTSRN1 test environment. Provided Dan with an sql to create record jobtype_id “INSD” in table JOB_TYPE. Now, it looks like Ana’s test record U795695424 was handled correctly by the adt_mml_site_system_create function. Job# 96020993 was generated. Apply necessary code changes to Payment processing applications that handle Credit Card, Lockbox, & ACH Returns.

• These modifications were necessary in order to prevent above mentioned applications from processing any payments that may be submitted by Divested customers.

• Divested accounts are those that have been migrated to MMB Billing on Oracle platform.

• Worked intimately with QA resources who have little experience with Informix 4GL processes. Design and craft PL/SQL package adt_pkg_sm2k_import to accept and process files received from Informix via unix shell script crrdata_to_mmb.sh. Fine-tune the shell script to be more fault tolerant in instances of network blips with the use of pro*C functions. 6 P a g e SMITA R. MODI

Recognitions & Awards

Peter Marra, Manager HQ Accounting. Feb 7, 2019

“I also wanted to share my experience of working with Smita. Her helpful and patient attitude made the whole process go very smoothly with zero frustrations. She communicated with me regularly and followed up without me having to constantly chase after her. I personally really appreciate that from a developer. I am not that familiar with Informix, and she was able to help me understand what was needed to be done from the technical side. She also was quick to grasp the Accounting piece of it, which she herself was not familiar with at the beginning. It was a great experience working her and I would jump at the opportunity to partner with her again.”

Sue Klaus, Director Application Integration & Design Oct 2, 2018

“Recognition for your contributions on the INFX to MMB data migration. For outstanding support related to the determination of business requirements, development and QA support of the three Informix split payment files. There was no BA assigned to this project. Therefore, Smita had to work with the business and IT SMEs to gather requirements, as well as dig into INFX code. Additionally, she had to educate the QA resources on the INFX programs, since QA resources are unfamiliar with INFX. Much of her work was done on an overtime basis, since she was juggling multiple development efforts at the same time.”

Tom Nakatani, VP. IT Executive Jul 17, 2018

Submitted for Certificate of Royal Blue Excellence. "Thank you for your outstanding support related to the determination of business requirements, code development and QA support of the three Informix split payment files. This development was critical to the success of the project!”

Grant Olson, Sr. IT Specialist Jun 12, 2018

“I wanted to say Great Job and Thank You to Smita for the change to the 20.13.13 trakconv program. The screen shot below shows that the Owriter processes have been up since 5/26 – which is a big difference after the daily crashes that went on for a few months.”

Contact this candidate