Data Consolidator Resume
New, YorK
SUMMARY
- 8 years of experience in design, development, maintenance and testing of distributed and client/server applications using Perl and Shell Scripting, Oracle, Sybase on UNIX, Linux and Windows environment.
- Strong exposure on Perl Scripting and Shell Scripting on UNIX and Linux environment.
- 8 years of extensive experience in development in PERL, CGI, DBI/DBD, HTML, Oracle and SYBASE based applications.
- 8 years of experience in development in Perl script, Modules and Perl OOPs.
- Strong exposure on to install various perl modules from CPAN.
- 8 years of experience in UNIX Shell Scripting (Korn Shell, Bourne Shell, C Shell, Bash Shell).
- Experience and Sound Knowledge on Banking Domain and Change Management System.
- Excellent knowledge of DBMS concepts and good experience in Oracle and Sybase.
- Expertise in Configuration Management using ClearCase, CVS, SVN and Hermes and well versed in code management using Repositories.
- Strong experience in Black box and White box, Integration and Performance testing.
- Extensive experience wif Autosys.
- Strong experience in the field of IT including Requirements Analysis, Design, Development, and Maintenance using UNIX shell scripting, Object oriented programming in Perl.
- Strong experience in design, development and testing on client - server based pure open systems using UNIX Shell, Perl Scripting, PL/SQL, Linux, AIX and Windows environment and Good knowledge on HTML,JavaScript and XML.
- Developed the scripts which extract data from DB using DBI and Sybperl.
- Solid experience wif Data Conversions using perl regular expressions.
- Involved in developing enterprise web applications in Perl using CGI.
- Experience working wif Object Oriented Perl in creating Perl Modules.
- Strong exposure on perl Module LWP::UserAgent, LWP::Simple, FileHandle, WWW:: Confidential, XML::Parser, XML::Writer, HTTP, Test Module.
- Thorough Understanding of Perl data structures (references, arbitrarily deep nesting in data structures)
- Thorough Understanding of Perl OO development, Using and 6+ years of experience in IBM Rational Clear Quest 7.0.0 wif Perl scripting API development in window box, creating schema, creating new database, debugging using DBWin32 third party tool, deploy schema from one environment to another environment, checking source control versions and development of Global script and schema script using CQPerl and API.
- 8 years of experience of change management system.
- Strong experience of Action Request system (Remedy) to handle user requests and requirements for change management system.
- Strong experience in maintaining source code using CVS (Configuration Version system) in unix environment, check out Code, status of particular script, difference between two versions, check-in code and maintain history.
- Experience in automation testing scripts by developing various unix shell script and perl script.
- Good experience in web performance testing tool using HttpWatch open source.
TECHNICAL SKILLS
Operation System / Hardware: UNIX, Linux, AIX, Abinitio and SUN Solaris, Window XP.
Languages: Perl scripting and OOPs, UNIX Shell Scripting (Korne, Bourne, C, Bash shell), Oracle (SQL and PL/SQL)/Sybase, HTML, java script and XML, CGI, DBI, CPAN Module LWP, LWP UserAgent, LWP Simple, FileHandle, WWW Confidential, XML Parser, XML Writer, HTTP, Test Data, Test Debuger, Test simple.
Database Oracle: 9i, 10g, MySql/Sybase 15.0.3, MS-Access 2000
Tools IBM: Rational Clear Quest 7.1.2.2 development wif Perl, Action Request system (Remedy),WinScp(file transfer tool), httpWatch (Web performance testing tool)
Source Control: CVS, SVN, Hermes
Web Server: Apache Web Server
PROFESSIONAL EXPERIENCE
Confidential, New York
Data Consolidator
Responsibilities:
- Interaction wif the System/business users to understand the IA runs requirements and prepare usecase/requirement document.
- Planning, Execution, Monitoring and Analysis of Impact Analysis for Credit Risk Analytics team.
- Designed new features & enhancements for the specific client requirement.
- Review and modification of design documents and data model.
- Preparation of estimates for identified new features/requirements.
- Work includes both bug fixing and new feature development.
- Lead the team and get the daily updates from the team
- Used Sybase as Database and involved in writing the SQL queries.
- Developed Stored procedures to generate the data.
- Generating the reports using Perl.
- Developed Unix Shell Scripts for background jobs.
- Development of UNIX shell scripts to automate manual processes.
- Automate various manual tasks using UNIX shell script to save time and manual efforts.
- Promptly solves code problems in existing UNIX shell script, Perl script, Sybase stored procedure.
- Working on connectivity of severs to servers working wif UNIX admin team.
Environment: Solaris 5.10, Perl, Sybase 15.0.3, UNIX, Linux, Abinitio, HTML, JavaScript, Perl, UNIX SHELL SCRIPTS, CVS, Crontab, Autosys.
Confidential
Roles and Responsibilities:
- Understanding the client requirements by studying functional documents.
- Requirement study and preparation of requirement specification document.
- Involved in Designing the prototype (GUI based Design).
- Lead offshore developer on development of Perl script and unix script.
- Designed new features & enhancements for the specific client requirement.
- Involved in production support activities like data migration and enhancement as per the requirement of the user etc.
- Involved in the unit testing of the application by developing automation shell scripts.
- Generating the reports using Perl.
- Developed Unix Shell Scripts for background jobs.
- Used Oracle as Database and involved in writing the SQL queries.
- Work includes both bug fixing and new feature development.
- Developed many existing unix shell script to new scripts, wifout any functionality change but using new logic to maintain code readability, maintenance and performance in terms of time.
- To analysis the impact of the code changes in the other part of the application and develop the requirement according to it, to give robust solution.
- Checkin and check-out the code using CVS and migrate the code into test environment.
- Develop regression testing scripts to create 36 shell scripts for all the 36 CLIs and create reports if any new bug introduced in the system.
Environment: Unix Shell Scripting (Korn shell, Bourn shell, Bash shell, c shell), Perl scripting, CQPerl API’s, Oracle 10g, Action Request System (Remedy). Solaris 10, AIX, LINUX, CVS version control, DBI Module. SFTP, FTP, cron Jobs scheduling.
Confidential
Responsibilities:
- Understanding the client requirements by studying functional documents.
- Requirement study and preparation of requirement specification document.
- Lead offshore developer on development of Perl script and unix script as per the requirement.
- Involved in Designing the prototype (GUI based Design).
- Designed new features & enhancements for the specific client requirement.
- Involved in the unit testing of the application, making test cases and do system testing.
- Developed shell script for the background jobs.
- Create new Perl script to generate the report format which can be used in GUI.
- Test the whole application in terms of performance by using performance tool HTTPWatch.
- Developed perl Module using perl object oriented.
- Developed perl scripts to develop monthly report and on basis of that create report graphs and publish in production site.
Environment: Perl scripting, CGI-Perl, HTML, java script, Oracle 10g, Action Request System (Remedy), Solaris 10. Shell scripting, CVS version control, FTP, SFTP, Unix environment, AIX, LINUX environment.
Confidential
Responsibilities:
- Provided prompt, accurate, and respectful support to users, employing high degree of customer-service skill and technical expertise while ensuring customer satisfaction.
- My responsibilities include business requirements analysis, architecture and design, extensive internal and external development in Perl, testing, and implementation. me was the lead developer that took the system from requirements to production. All work was done PERL
- Development of Perl Hook Codes, perl global scripts in ClearQuest Schema.
- Took initiative to learn company internal organizational structure to optimize problem-resolution efficiency.
- Troubleshooting techniques to verify solutions.
- Contributed ideas to improve customer service and suggested ways for second-level support to interact wif customers and remain in the loop.
- Frequently resolved issues related to the code or by interact wif users.
- Quickly learned new tasks and rapidly resolved customer problems.
- Create User, User Group and update ClearQuest user/group using Clearquest Administration.
- Creating reports, provide different report formats using ClearQuest report.
Environment: Perl, Oracle 10g (SQL/PL/SQL), Clear Quest Designer Tool, Rational ClearCase tool and Solaris 10 and Window sever 2000, AIX, Linux servers.
Confidential
Responsibilities:
- In AR system the time taken for resolving an issue cannot be tracked whereas it can be done here.
- All the concerned people are notified wif the development of the issue in CMSR.
- A perfect life cycle is followed in resolving an issue unlike AR System.
- Metrics of the issue can be tracked using CMSR.
- All the steps taken to resolve the issue are clearly mentioned in the notes section of the CMSR.
- The changes made are pushed into the system through a Release plan and proper downtime if required.
- Took initiative to learn company internal organizational structure to optimize problem-resolution efficiency.
- Lead offshore developer on development using CQPerl API in Rational ClearQuest schema.
- Quickly learned new tasks and rapidly resolved customer problems.
- Prepare requirement document, code review document, unit test case document.
- Test the whole application in terms of performance using HttpWatch.
- Develop global scripts to add new functionality in the system.
- Push the local schema to the development environment and test environment.
- Create newlocal schema, copy of production schema and database connectivity wif that schema.
- Create virtual users and give administration privileges for the development point of view.
Environment: IMB ClearQuest 7.1.2.2, CQPerl, Oracle 10g, Windows 8 Server, Unix environment. Perl scripting, shell scripting, CVS.