System Analyst Resume
Summary
- Associate with 8.5 years of IT work experience with both Management and Technical skills. I have executed projects in the realm of Application Development, Maintenance/Enhancement, production support and Conversion/Porting. Successful at designing and implementing the Mail Management System which is an USPS compliance requirement for Citi in a short span
- My technology forte is UNIX, Shell/Perl Scripting, C/C++, Pro*C, StreamWeaver, AFP technology and Mosaic Architecture and Oracle database. I have also worked in Java Swing and have exposure to C# .Net.
- Diverse experience in Banking & Financial services and Manufacturing network sector with good exposure in Customer Communication and Client management applications
- Very good experience of working in different relational databases like Oracle, E-SQL, MS SQL Server and non-relational DB like ISAM and CDS. Worked extensively on PL/SQL stored procedures, cursor, function, packages, triggers, indexes.
- Strong experience in Perl Scripts development. Worked with array, hash, subroutines, packages, DBI libraries for database connectivity and parsing files. Developed several perl process to monitor the input, process the input jobs and NDM the output jobs.
- Strong object oriented development - Perl, C++
- Excellent skills in working with UNIX shell scripts. Developed shell scripts for feed file integrity checks, polling, FTP activities using commands like find, grep, pipe, cut, redirection and utilities likeawk and sed.
- High skills in working on various UNIX environment and worked in porting an applications across different UNIX versions like Solaris, HP-UX, AIX, SCO-UNIX and Linux.
- Extensive experience with Cron and Autosys job scheduler like writing jil scripts for creating job definitions. Also used commands like autorep for checking status, definitions, sendevent for starting jobs, changing status. Experience in working with and supporting CA Technologies Workload Automation AE in UNIX AIX environment.
- Worked extensively in NDM (Network Data Mover) scripts for job/file transmission and conversant with FTP, FTPS, SFTP, SCP protocols and encryption methods.
- Exposure to working in onsite client’s place for about 3 years; good experience in Onsite-Offshore delivery model and its co-coordinating activities and managing the project delivery.
Technical Expertise
Environment
SUN, IBM-PC, HP, IBM and IA64 (Itanium) Workstations
Operating Systems
Languages
C/C++, Pro*C, ESQL, StreamWeaver, JAVA Swing, OFB, C# .Net
Databases
ISAM, Oracle SQL & PL/SQL, E-SQL, MS SQL Server
Scripting
Perl Scripts with DBLib, Korn/Bash Shell Scripting, Autosys JIL scripts, Make files, NDM control cards
Compiler tools
cc, aC++, xlC_r, gcc
Debugger tools
gdb, dbx, iDebug
Scheduling tools
Autosys, Cron, CA Workload Control Center
Communication Utilities
NDM, SFTP, telnet, SSH, rcp/rsh, SCP
Other tools
Make, Clear case, Connect Direct, SQL Loader, RCS, Microsoft Visual Source Safe, MS Visio, QC
Methods
OOPS Methodology
AFP Technology
MOSAIC Architecture
Qualifications
- Bachelor of Engineering (B.E.) in Information Technology
Professional Experience
Confidential, May 2010 to Present
Role: IT Lead and Application Developer
Brief Profile:
- Generates and embed Full IMB in all statements/letters mail-pieces
- Embeds other barcodes like 3of9, 2of5 for ease print facility processing
- Job splitting according to the weight/sheet data
- Allows both English and Spanish mail-piece processing
- Pre-sort facilities according to the USPS norms for the better discount
Responsibilities:
- Designed, developed, and implemented the below process using Perl
- FileStab process to monitor for the different input files complete receipt using NDM system logs and to trigger the processing of the same
- Invoke process to integrate the StreamWeaver to generate the USPS and PrintFacility specific barcodes. In addition, all the other Business requirements are implemented
- Dynamically SW control card is generated using a separate PERL process according to the job info loaded into Oracle DB
- Process to parse the sidefiles generated and load them to Oracle DB to extract/manipulate and generate control reports using SQL *PLUS
- Output process to dynamically create the NDM control cards according to job different destination specifications
- NDM verification process to check and alert for any ndm failure
- Purge process automation to clean the input/output jobs and logs to maintain only specific days
- Developed SQLLoader control files and sql scripts to load and extract the reporting information and generating the control reports
- Developing the PL/SQL stored procedures, cursors and functions to generate job processing control reports and MIS reporting on need basis
- Developed and configured Autosys JILs scripts to automate all the perl script jobs. Worked on CA workload system GUI to manage the autosys process created
- Development of day end processes using Perl / UNIX Shell Scripts.
- Configured the NDM nodes for all different destination nodes. Generated keys using keygen to generate CA certificates and configured secure+ NDM connection with 3rd party vendor system.
- Defined, designed, and implemented MIS reporting systems, tools and applications to facilitate management of content.
- Developing appropriate strategies for the implementation of the project
- Created specifications like Functional Specification, Technical Specification and System Manual doc for prod-support that addressed all business requirements, user interfaces, process flow, performance, and scalability.
- Participated in all stages of the development life-cycle including architecture, design, implementation, and unit testing.
- Remediated, rerouted and addressed trouble tickets and participated in on-call rotation for handling trouble ticket requests in the post-implementation phases (4-weeks) for every releases
- Managed and coordinated development and test environment upgrades.
- Interfaced with vendors to evaluate and implement new software hardware products.
Technical Environment:
IBM AIX, StreamWeaver, Oracle SQL, Autosys, NDM, Perl, UNIX shell scripting, Putty, Autosys CA, QC, Mail360 components, FTP/SFTP, SCP
Confidential, February 2007 to April 2010
Role: System Analyst, Application Developer and IT Lead
Responsibilities:
- Location customization involving development of UNIX shell / Perl scripts, stored procedures
- Developed batch processes for financial reporting applications and modules using Perl and Korn shell scripts on Oracle database
- Developed the Pro*C E-SQL code for the minor utilities to integrate with Database for day-to-day activities like snd_app, rcv,app
- Created necessary makefiles to pre-compile, compile and build the Pro*C e-sql codes as binary
- Proficient in archiving and backups. Day to day administration of the Development, Test, Stage and Production environment.
- Efficiently managed disk by deleting old log files.
- Generated keys using keygen and also configured SFTP and FTP.
- Modify Management Information System (MIS) back-end reports and integrate data fixes to data warehouse table
- Requirements analysis and rollout strategy plan
- Determining the estimation for the new functionalities and capacity planning
- Preparation of functional and detailed design specifications
- Perform functional testing
- Coordinate user testing and rollout the application including both server and client packages to production
- Translated requirements and functional designs into technical designs.
- Maintained backup schedules for server storage. Read and interpreted UNIX logs
Technical Environment: SCO UNIX, Mosaic, OFB, Pro*C, E-SQL, PL/SQL, Perl, Unix shell scripting, Clear case, putty, Make, scp, rsh
Confidential, Japan August 2006 to December 2006
Role: Technical Lead and Analyst
Responsibilities:
- Make file preparation
- Analysis on Linux porting issues
- System test cases preparation
- Build and Release Management
- Bug fixing and product integration support
- Regression testing on other Windows and UNIX platforms
Technical Environment:
Windows 2000/2003, RedHat Linux 7.1/7.2, Sun Solaris 9, HP-UX 11i, IBM-AIX 5.2, SUN ONE Studio 10, cc, aCC++ 3.6, Visual Age C++ 7.0, gcc 3.2.3, C++, Shell script , ISAM DB, MS VSS, Hitachi’s SRMVC, Hitachi’s SoftPro, Hitachi’s CLMAN, Data Collection tool, Cluster setup command, Clear case, putty, Make
Confidential, Japan May 2006 to July 2006
Role: Analyst, Development and Quality Lead
Responsibilities:
- Requirements analysis and estimation for the new functionalities
- Preparation of functional and detailed design specifications
- System test case preparation
- Testing and Bug fixing
- Defect prevention and Quality assurance
- Release and implementation
- Responsible for Project deliveries
- Responsible for estimation of the projects
Technical Environment: Windows 2000/2003, Sun Solaris 9, HP-UX 11i, IBM-AIX 5.2, C, C++, SUN ONE Studio 10, aCC++ 3.6, Visual Age C++ 7.0 , ISAM DB, Unix shell scripting, MS VSS, Hitachi’s SRMVC, Hitachi’s SoftPro, Hitachi’s CLMAN, Clear case , putty, Make
Confidential, Japan October 2005 to April 2006
Role: Module Leader, Analyst and Quality Leader
Responsibilities:
- Requirements analysis and feasibility study
- Estimation for the new functionalities
- Preparation of functional specifications
- Analysis of impact areas and design for the new functionalities
- Build Environment setup
- Bug fixing
- System testing
- SK support
Technical Environment: Windows 2000/2003/XP, j2sdk 1.4.2_03, Java Swing, Eclipse 2.1, MS VSS, Hitachi’s SRMVC, Hitachi’s SoftPro, Hitachi’s CLMAN , Clear case
Confidential, Japan December 2004 to September 2005
Role: Application Developer
Responsibilities:
- Analysis of the requirements and preparation of design memos
- Estimation for the new functionalities
- Preparation of functional specifications
- Design and coding
- Bug fixing and product integration support.
- Coding
- Test case preparation
- Used STLs, hash table, vector, set to overcome performance related issues
- Compilation and Building environment setup
- Performance data collection
- Testing
Technical Environment: Windows NT 4.0 Japanese Version, Sun Solaris 9, HP-UX 11i, IBM-AIX 5.2, C, C++ , SUN ONE Studio 10, aCC++ 3.6, Visual Age C++ 7.0 , ISAM DB, MS VSS
Hitachi’s SRMVC, Hitachi’s SoftPro, Hitachi’s CLMAN , Clear case , putty, Make
Confidential, Japan April 2004 to November 2004
Role: Application Developer
Responsibilities:
- Make file preparation
- Analysis on porting issues to the UNIX(Solaris, HP-UX, AIX) platforms
- System test cases preparation and testing
- Coding of data collection tool using shell scripts
- Used dbx, gdb for debugging and bug fixing
- System testing
- SK support
Technical Environment: Windows NT 4.0 Japanese Version, Sun Solaris 9, HP-UX 11i, IBM-AIX 5.2 , C, C++ , SUN ONE Studio 10, aCC++ 3.6, Visual Age C++ 7.0 , ISAM DB , UNIX Shell scripting, MS VSS, Hitachi’s SRMVC, Hitachi’s SoftPro, Hitachi’s CLMAN , Clear case , putty, Make