SUMMARY

• More than 16+ years of 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.

TECHNICAL SKILLS

Operating Systems: AIX (3.*/4.*), HP - UX.A (B10.20), Unix (SVR 4.3), Solaris (2.5.1), Linux, Windows NT (3.0/4.0), Windows NT/XP/Vista/7.0

Hardware: IBM RISC 0/590/SP2), HP 9000/728, Sparc Ultra 10

Programming Languages: C, PRO*C, Perl, OO 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.11 C, SCCS, PVCS, CVS, Subversion, ANT, MAVEN

Miscellaneous: Ksh/Csh/Bsh, Powershell, TCL/TK, AutoSys, TIDAL, 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

PROFESSIONAL EXPERIENCE

Confidential

Sr. Application Developer

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

Responsibilities:

• 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.

Confidential, Jersey City, NJ

Sr. Application Developer

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

Responsibilities:

• 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 actionsjob/file events and variables. The complete system design involved SDLC methodologies including significant component of system integration.

Confidential, Middletown, NJ

Sr. Software Engineer/Data Analyst

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

Responsibilities:

• 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 requirementstranslating final results into excel and/or web based reports for Confidential &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.

Confidential, Carlstadt, NJ

Sr. Tidal Administrator/Analyst

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

Responsibilities:

• Over 200 PGP encrypted FTP daemon file moves between Windows and Unix platform into TIDAL Enterprise Scheduler (TES) - SFTP adapter.
• 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.

Confidential

Sr. Software Engineer/Data Analyst

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

Responsibilities:

• 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 Confidential state government level for further electric feeder/grid power generation calculations and processing.

Confidential, Parsippany, NJ

Sr. Software Engineer/Data Analyst

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

Responsibilities:

• 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.
• 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.

Confidential, Jersey City, NJ

Sr. Software Engineer /System-Data Analyst

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

Responsibilities:

• 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.

Confidential, Jersey City, NJ

Sr. Software Engineer/Developer

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

Responsibilities:

• Developed new Csh/Ksh/Perl scripts to in corporate 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

Confidential, Bloomfield, NJ

Developer/Analyst

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

Responsibilities:

• 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

Confidential, White Plains, NY

Programmer/Analyst

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

Responsibilities:

• 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

Confidential, NYC, NY

Support Analyst

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

Responsibilities:

• 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.

Confidential, Newark, NJ

Support Analyst

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

Responsibilities:

• 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

Confidential, NYC, NY

Support Analyst

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

Responsibilities:

• 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

Confidential, NYC, NY

Programmer/Analyst

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

Responsibilities:

• 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).

Confidential, NYC, NY

Developer

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

Responsibilities:

• 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

Confidential, Short Hills, NJ

Developer

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

Responsibilities:

• 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