Candidates About

 

Dharmesh Panchal

Professional Profile:

Extensive experience in analysis, design, development, implementation, system integration, maintenance, automation, support and software engineering of variety of applications on Unix/Linux and windows platforms using C, Unix Shell, Perl, AutoSys, TIDAL and Client/Server RDBMS packages such as Sybase, Oracle and SQL server. Experience involves working into various industries such as financial, retail, telecommunication, insurance and media.

 

Computer Skills:

Operating Systems	AIX, HP Unix, Unix, Solaris, Linux, Windows
Hardware	IBM RISC6000 (390/590/SP2), HP 9000/728, Sparc Ultra 10
Programming Languages	C, PRO*C, Perl, OO Perl, Strawberry Perl, ANSI-SQL, T-SQL, PL-SQL, SAS Basic Programming for clinical trial studies
RDBMS/Config. Mgmt.	Sybase 11.*/12.*, Oracle 9i/10g/11g, SQL Server 2000, Teradata 13.10.05.11C, SCCS, PVCS, CVS, Subversion, ANT, MAVEN
Miscellaneous	Ksh/Csh/Bsh, Powershell, TCL/TK, AutoSys, TIDAL, UC4, DBartisan, Rapid SQL, SQL Assistant for Teradata, Toad for Oracle, Sendmail, FTP/SFTP/NDM/SSH Tectia/PGP/PUTTY, T-SQL Performance & Tuning, Excel, VBA, SDLC, BIDW Metadata, KRONOS T&A, FIX Protocol

 

Education:

 

·         MS          (Computer Science)            - NJIT, NJ              (GPA - 3.8)

·         BS          (Electrical Engineering)     - MSU, INDIA        (GPA – 3.6)

 

Projects:

 

The Children's Place (Credit Card Tokenization)

Apr 2017 – Jul 2017 (Sr. Application Developer/Systems Analyst)

Environment:  Perl 5, AIX/Ksh, Strawberry Perl, SFTP, PGP/GPG, UC4

• Developed various Perl and Ksh applications to transform customer's Credit Card accounts from historical ZIP/GPG files into a valid SHA1/SHA2 hash values. The combination of hash values and credit card numbers were then used to generate unique token values by third party vendor. The final token values were used to update internal systems
• Performed complete systems analysis of all existing AIX/Ksh batch processes running on UC4 scheduler
• Migrated all the Perl/Ksh applications running on AIX to Powershell/Strawberry Perl in Windows 2012 environment

 

Zuppudy (Digital Information Management System)

Jan 2016 – Mar 2017 (Sr. Application Developer)                       environment

Environment:  C, Perl 5, Csh, Ksh, SFTP, PGP

·         Supported, modified and improved performance of various Cron and AutoSys production processes that are critical for real-time notification systems

·         Developed a file watcher daemon process in Perl to monitor arrival of data/confirm files from source system

·         Developed automated file backups on the server side using C and Perl scripts

·         Developed shell scripts to adhere to specific system administration needs.

 

Bank Of Tokyo, MUFG, Jersey City, NJ         (Liquidity Risk Management)

June 2015 – Dec 2015 (Sr. Application Developer)

Environment: AIX, Perl 5.6, Ksh, TIDAL, Oracle

Worked in a Liquidity Risk Management System (LRMS) project development team. Duties

involved  writing Perl as well as Ksh scripts to automate product instruments and collateral data

extraction from DWH tables and transferring it to The Data Mart (TDM) core. The data then got

moved to ETL OUT environment using Informatica workflows and finally to OFSAA stage (Oracle)

tables. The OFSAA UI allowed users to modify the information within OFSAA tables. The OFSAA

batch processes were configured to drive the business logic within oracle tables. The end cycle of

the process generated 2052A/CUSIP data reports containing bank's complete liquid assets and

liability for final submission to Federal Government. Also designed entire LRMS daily batch

processes configured to be executed through TIDAL jobs/groups/sub-groups, job/email actions,

job/file events and variables. The complete system design involved SDLC methodologies including 

significant component  of system integration

 

AT&T Research Labs, Middletown, NJ (Data Mining & Research)

March 2013 – November 2014 (Sr. Software Engineer/Data Analyst)

Environment:  C, Perl 5, Csh, Ksh, SUN Solaris, Teradata10.1.1, SFTP, PGP

Worked in Intelligent Mgmt. Systems/Applied Data Mining Research group for Network

Technologies  division. Duties involved conducting fraud analysis as well as optimization of existing

and designing new processes. Also authored numerous C applications as well as Unix/Perl/SQL

scripts to generate high volume extracts of wireless accounts/activities from Teradata using fast

export (fexp) and BTEQ, transforming the information into flat files as per requirements,

translating final results into excel and/or web based reports for AT&T clients via Perl modules.

PGP encrypted reports then were transmitted to clients using SFTP technology. Also wrote

Unix/Perl/SQL scripts to load information from flat files into Teradata tables using fast

load (fload) utility

 

November 2011 – January 2013 (Overseas - INDIA For Family Events)

 

Coach Inc., Carlstadt, NJ (TIDAL Enterprise Scheduler)

March 2011 – September 2011 (Sr. Tidal Administrator/Analyst)

Environment:  Powershell, VBA script, Perl 5, Csh, Ksh, Bash, C, SFTP, PGP

Successfully migrated:

(a)   Over 200 PGP encrypted FTP daemon file moves between Windows and Unix platform into TIDAL Enterprise Scheduler (TES) - SFTP adapter

(b)   Numerous file moves into TES SAP adapter, Oracle adapter, SQL adapter and Business Objects adapter

Combinations of job actions, job events, Ksh/Perl/VBA/Powershell scripts and C applications used to automate processes via TES jobs in production environment. Also assisted in TIDAL master/agent installation and configuration process on various Unix and Windows servers

 

GEDA, Gandhinagar, INDIA         (AES Production System)

November 2008 – January 2011 (Sr. Software Engineer/Data Analyst)

Environment:  C, Perl 5, Ksh, IBM AIX, Windows 7, SQL Server, PGP, SFTP

Developed daily, weekly, monthly, quarterly and yearly reporting applications designed to produce details and summary of alternate energy production as well as consumption of a large scale wind and solar farms. MS SQL Server DB was used as a primary source of required information for gathering already recorded per unit (each solar array module and each wind turbine generator) hourly data. C applications used to interface with DB and produce flat files.  Group of various PGP encrypted files then were transferred to IBM AIX server using SFTP. Further required calculations as well reformatting was done using Perl 5 and Ksh scripts on AIX server and final PGP encrypted reports were transmitted using SFTP to traditional power generation agencies at state government level for further electric feeder/grid power generation calculations and processing

 

Avis Budget Group, Parsippany, NJ      (Fleet Planning System - PROS)

March 2008 – September 2008 (Sr. Software Engineer/Data Analyst)

Environment:  C, Perl 5, Csh, Ksh, SUN Solaris, Sybase 12.5/Oracle 10g

Developed interface between source and target Unix systems using ETL approach. Following separate applications in that order were developed using independent Perl applications embedded into Unix Ksh scripts

On the source system

·         Developed Ksh/Perl DBI application to extract Fleet plan forecast information generated by SAS models from multiple Oracle tables. Stored Procedures/Functions/PL-SQL was called from Perl application. Extracted information was stored into multiple Unix flat files

·         Developed Ksh/Perl scripts to PGP encrypt these files

·         Developed Ksh/Expect scripts to transfer generated data files along with associated confirmation files to destination system using Secure FTP (SFTP)

·         Performance tuned various Oracle stored procedures

On the target system

·         Developed a file watcher daemon process in Perl to monitor arrival of data/confirm files from source system

·         Developed Ksh/Perl scripts to PGP decrypt these files

·         Developed Ksh/Perl scripts to BCP data files into temporary Sybase tables

·         Developed Sybase stored procedures/T-SQL to transform data into temporary tables and then load them into permanent tables

·         Developed Ksh/Expect scripts to send a confirmation file using SFTP back to a source system

 

                Entire process flow mentioned above between two systems was driven through a JAVA based UI                 which was developed on the source system with single sign-on GUI

 

Fiserve, Jersey City, NJ            (Outsourcing/Reporting – IMD/CIS)

July 2007 – February 2008 (Sr. Software Engineer /System-Data Analyst)

Environment: AutoSys, Perl 5, Perl Regular Expressions, C, Ksh, IBM Aix,                                                   Windows Powershell, VBA

·         Developed new APL control jobs on AIX platform to generate client’s Fixed Income instruments as well as Derivatives products investment portfolio account reports on a quarterly as well as monthly basis for over 150 clients. Each of these clients contained over an average of 75000 accounts. These reports initially were generated in Postscript format. Combination of C, Perl and Ksh were used to manipulate these PS reports in various ways and distill PS files to generate final PDF format reports

·         Created combination of NDM, SFTP and/or RCP scripts to transfer these reports to either client’s destination production server or FTP server and also CD burn them to be mailed

·         Created AutoSys JIL scripts to automate this process for daily/weekly/monthly/quarterly jobs

·         Developed APL control jobs to generate daily APL extracts containing client cash accounts trade as well as portfolio performance information

·         Participated in APL (Unix platform) to EPL (Windows platform) migration as well portfolio performance reports and output design process using Dialogue (Exstream), a third party vendor product. Created numerous VBA and Windows Powershell scripts to automate and execute batch processes

 

Lehman Brothers, Jersey City, NJ      (Broker Audit System)

May 2006 – May 2007 (Sr. Software Engineer/Developer)

Environment: Sybase (T-SQL), C, Perl 5, Perl, Ksh/Csh, SUN Solaris

Developed new Csh/Ksh/Perl scripts to incorporate new data feeds into a pool of existing data

feeds. Used most Unix files and directory maintenance commands as well setting permissions on

them. The broker/trade information was extracted from DB2/Sybase databases through Perl scripts

and C source using DBI/DBlib modules. The final wrapper scripts were developed using Csh/Ksh.

The extracted information (via Unix flat files) was fed into Vendor (SUNGuard) Broker Audit System

package using Unix FTP/SFTP. The NT batch processes loaded information into MS SQL server

2000 database

 

Krutika Inc., Bloomfield, NJ

February 1998 – April 2006

A)   Bank of America (Electronic Trading Services System)

(02/2003 – 04/2006) – Developer/Analyst (Ridgefield Park, NJ)

Environment:  Sybase (T-SQL), Oracle (PL-SQL), C, Perl5, Ksh, Linux,

  SUN Solaris

·         Defined business model and converted existing Fixed Income/Derivative applications from C/Sybase (T-SQL) environment  into Sybase/Perl (DBI-CGI)/HTML environment and created Oracle (PL-SQL) stored procedures

·         Performance Tuned existing Oracle Stored Procedures

·         Supported, modified and improved performance of 25 Cron and 68 AutoSys ETSS/WebETSS production processes

·         Designed Web based IPO Management application, allowing BOA clients to create and manage IPO offerings over Internet

B)   America on Line (All Music Guide Feed System)

(01/2002 – 11/2002) – Programmer/Analyst (White Plains, NY)

Environment: Sybase (T-SQL), C, Perl 5, TCL/TK, Ksh, SUN Solaris

·         Developed process to extract extremely large amount of artist/album/tracks/performers related information from set of Sybase tables into ASCII Unix flat files. Information published to front end Web Servers to be displayed on AOL web sites. Process developed using two different approaches (Sybase/C/CTlib and Sybase/Perl/DBI) for better performance benchmarking

·         Created Sybase stored procedure/triggers and Ksh/Perl scripts to extract information

·         Created TCL/TK scripts to parse, process and publish input data from MapQuest (mapped for latitude/longitude/zip code) to web servers 

C)   CSFB (Fixed Income – Prime Brokerage)

(10/2000 – 10/2001) – Support Analyst (NYC, NY)

Environment: Sybase (T-SQL), C, Perl 5, Ksh, SUN Solaris

·         Developed Sybase tables driven generic data feed parsers and data loaders using C to process and book multiple client trades (executed through external as well as internal clearing broker services) of various Fixed Income (Prime Brokerage Services) products such as BOND, EQUITY (STOCK/OPTION), REPO/RREPO, FX, MORTGAGE and CDSWAP

·         Designed OOP processes to generate PGP encrypted Unix flat files of this trade information to feed various downstream systems.

D)   Prudential Global Asset Mgmt (GEAC SSR)

(02/2000 – 07/2000) – Support Analyst (Newark, NJ)

Environment: Sybase (T-SQL), C, Perl 5, Ksh, HP-UX, FIX

·         Performed system analysis, design and created functional specifications for automated process to load daily as well as monthly Equities Cash Balances/Holdings files from various feeding systems into GEAC SSR system according FIX protocol standards

·         Performed system analysis, design and created functional specifications to map existing reconciliation process with Prudential’s internal account keeping system

·         Converted functional specifications into various pieces of source code written using Perl/OOP/Ksh scripts, C and Sybase stored procedures/triggers

·         Created AutoSys processes/JIL scripts to control processes

·         Enhanced and added new incoming feeds to GEAC SSR system according FIX protocol standards

E)   Instinet (Clearing Interface System)

(06/1999 – 01/2000) – Support Analyst (NYC, NY)

Environment: Sybase (T-SQL), Oracle (PL-SQL), C, Perl 5, Ksh, HP-UX, VMS

·         Migrated CIS components such as Equities Cash, Fixed Income and Derivative applications from Sybase (11.0.2) to Sybase (11.5.1). Created Ksh/Perl/SybPerl scripts as well as C source to make new enhancements

·         Tuned Sybase stored procedures for efficiency and performance

·         Performance tuned Oracle Stored Procedure for better efficiency

F)   Salomon Smith Barney (Fixed Income Research Migration)

(07/1998 – 04/1999) – Programmer/Analyst (NYC, NY)

Environment: Sybase (T-SQL), C, FORTRAN 77, Perl 5, Ksh, SUN OS/Solaris

·         Migrated Fixed Income Research Group Subsidiaries (Emerging Markets, Structured Portfolios, Corporate/Government Bonds, Mortgages and Index) applications from SUN OS (4.1) to Solaris (2.5.1) as well as Sybase (11.5.1) to Sybase (12.5)

G)   New York Life (Member Application Processing System)

(02/1998 – 06/1998) - Developer (NYC, NY)

Environment: Sybase (T-SQL), C, Perl 5, Ksh, IBM Aix

·         Performed design, analysis and coding for the interface between NY Life’s vendor system and MAPS for daily RECVSS and SENDSS processes

·         Created  Ksh scripts to BCP vendor data to populate internal Sybase tables and created C/DBlib application as well as Sybase stored procedures/triggers to process the data

·         Developed Unix tools and Ksh scripts to perform cleanup on Sybase repository tables as well as application log directories for the data and files older than five days  

H)   AT&T (ACFBI System)

(06/1996 – 06/1997) - Developer (Short Hills, NJ)

Environment: Sybase (T-SQL), C, Perl 4, Ksh, HP-UX

·         Performed design and analysis of project as well as hardware and software requirements

·         Involved in setting up complete project development environment for developers, starting from setting up Unix login Ids, Sybase user Ids, writing shell (Ksh/Perl) scripts for generating generic user profiles, standard make files, setting up SCCS, defining DB model and creating common C/Sybase libraries and DB stored procedures

·         Developed project for matching and merging customer’s various accounts information via Unix flat files and Sybase tables to generate customer’s bundled accounts in a Unix flat file to be uploaded to CFAR and ICV systems