SUMMARY:

• Over 7 years of progressive experience in developing applications using Perl on MYSQL and Oracle. Experience involving development, testing, implementation and support of applications using Perl, MYSQL, Oracle, DB2 and Unix shell scripting
• Worked on all stages of Build & Release Management including analysis, design, development, testing and implementation.
• Comprehensive experience in development of Billing/Financial applications
• Experience in Automation of Build & Release system.
• Automated project requests by writing perl and shell scripts.
• Analyzed requirements for internal build tools developed using perl.
• Experience in cross compilation technologies for various target hardware architectures.
• Extensive experience in writing make files and build scripts.
• Experience in debugging and troubleshooting using tools like gdb.
• Analyzed and benchmarked internal applications built using object oriented perl and java.
• Extensively used GMAKE as the build utility
• Platform experience includes Windows, UNIX - AIX, Solaris, Linux, HP-UX.
• Experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services through SOAP Lite module and WSDL.
• Strong Experience in Perl scripting and Unix Shell scripting.
• Communicated with database using Perl DBI
• Passionate about troubleshooting and resolving difficult problems
• Experience in providing L3 level support including debugging complicated production issues, meeting defined SLA and performance indicators.
• Ability to be an effective team player and to work under severe time constraints.
• Familiar with ETL Tool Informatica Power center 9.5
• Experienced in Software Development Life Cycle (SDLC) starting from mission statement to product release
• Comprehensive knowledge of Data Analysis and Business Analysis, Server and Database Auditing, Security Audit for business systems
• Ensured strict adherence to Change and Configuration Management, Clustering, Disaster Recovery and Business Continuity planning
• Worked on tools like Rational Rose and Rational Clear Case.

TECHNICAL SKILLS:

Languages: PERL, Java JDK 1.6, mod perl, PERL DBI, C, Shell, sed & awk, Java, XML, SQL, PL/SQL

Operating Systems: LINUX, Sun Solaris, HP-UX, AIX, Windows XP/NT/2003/2000

Databases: ORACLE 11g/9/8.x, MS SQL SERVER 2008, MYSQL Web App Server Apache, Tomcat

Software/Tools: Autosys, Aqua DS, TCP/IP, HTML, DHTML, XML, JavaScript, UML, SeleniumETL Tool: Informatica Power Center 9.5/Rational Rose, CVS, SVN, SCCS, ClearCase, Eclipse.

PROFESSIONAL EXPERIENCE:

Confidential, Manhattan, NY

Perl CGI Developer

Responsibilities:

• Support batch jobs for the Financial Reporting Team front office applications.
• Analyze System and Business level requirements.
• Design and Develop code to implement new reports and modify the existing reports using Perl scripting with MYSQL as the backend DB on a Windows environment.
• Querying the report data from the Data Base tables, parsing the data and implementing the business logic.
• Bulk copying the processed data into Data Base tables for the downstream systems and reports for the users.
• Wrote Shell scripts for the automation of the unit testing.
• Created perl script for automated email to the team regarding the delay in upstream data files.
• Created Batch jobs in Autosys for the automation of the report generation and the bulk copy of the data from upstream into the tables.
• Involve in the decommissioning of the old code and replacing with new functionality.
• Conduct Unit and Integration testing for the bug fixes and new reports.
• Create documentation for the bug fixes and the new reports generated.

Environment: Perl, SQL Server, TSQL, MYSQL, SQL, Autosys, CGI, DBI, SQL/Plus, SQL, Windows

Perl Developer

Responsibilities:

• Made business study, Gathered user requirements, Analysis, Coding, testing and implementation
• Analyzed web server traffic, both with Analog stats package and homemade Perl programs
• Developed Scripts to generate HTML/JavaScript reports on Intranet
• Wrote numerous Perl scripts for Oracle data handling
• Designed, used, debugged many new Perl modules and existing Perl modules and Shell programs
• Developed CGI scripts using Perl/DBI
• Wrote Perl scripts to automate the verification of the information inserted in the database via the web application
• Proficient in server-side programming and debugging with Perl
• Worked on Backend Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle
• Developed Perl modules for all CGI pages and unit tests for all modules
• Used PL/SQL tables, array structures as a part of Oracle collections
• Developed holding upload system using Perl, CGI, for research group
• Created data maintenance utility using Unix Shell Scripts (Bash & Perl)
• Fixed bugs in existing Perl modules and BSH scripts
• Implemented automated monitoring procedures in a Unix Shell environment to alert the staff to a potential service interruption
• Supported to resolved production batch failures

Environment: Perl, CGI, KSH, HTML, Javascript, DBI/DBD, PL/SQL, SQL, Oracle, UNIX

Programmer Analyst

Responsibilities:

• Performed Coding in OOP PERL and Oracle.
• Design, development and testing of the Perl Scripts.
• Performed Gap Analysis, High Level Design and Detail Design.
• Performed Design reviews, Code walkthru’s and task estimation.
• Implemented using Perl scripts, DBI module for Data integrity problems.
• Extracted data from XML files and worked with SAX module of Perl for XML parsing.
• Wrote a Perl program to generate configuration files from Oracle Database.
• Written Korn Shell and Bourne Shell Scripts for retrieving data from Oracle Database.
• Created backend stored procedures in PL/SQL and SQL/Plus.
• Used VSS for configuration management.
• Did QA Integration testing. Created test cases test condition.
• Created Test script in Perl/Unix from automation and Ran the Test and validated results.
• Did documentation of Perl scripts and tests.

Environment: Perl, CGI, XML, Java, PL/SQL, Oracle 9i, JavaScript, DBI, SQL/Plus, SQL, UNIX

Programmer Analyst

Responsibilities:

• Performed Gap Analysis, High Level Design and Detail Design
• Performed Design reviews, Code walkthru’s and task estimation
• Created Data flow Diagrams and Process Flow diagrams.
• Performed Coding in PERL/CGI and Oracle
• As the reports are highly confidential the system security is taken care through another tool called Web scope. Developed that system using Perl, CGI Scripts and MYSQL.
• All the reports are developed using CGI scripts.
• Extensively used Adobe Photoshop for image-editing.
• Granting permissions for the view ability of the reports to sales rep are done through web scope. This is created using MYSQL database.
• I am the second level tech support for the whole application for US and Canada region.
• When I get an opus ticket from help desk I contact the Sales and marketing people of SGI regarding the problem they are having using the Application.
• Supplied extensive 1st and 2nd level phone and email support to 500+ end users across the US and Canada including onsite support.
• Utilized Opus for call management and applied Incident Management best practices for performing day-to-day Help Desk functions.
• Created procedural documentation for issues and resolutions. Periodically analyzed and interpreted business periodicals and professional journals to better understand client’s business requirements, its industry, goals and objectives.

Environment: PERL, OraPerl, JAVASCRIPTS, JAVA, ORACLE, MYSQL, UNIX, Solaris, PL/SQL, Adobe Photoshop, Windows, UNIX and Shell scripts.

Jr Perl Developer

Responsibilities:

• Analyze business requirements and create high level and detail design documents
• Perform development, testing and implementation of the applications using Emacs editor and Red Hat Linux server.
• Extracting data from raw input Call Detail record data and loading into database using Perl DBI and DBD with oracle.
• Loading of the CDR data into Oracle data base and generate alerts on the CDR data as per defective CDR count by absolute/percent values. Code written in Perl, SQL (oracle) on a Linux environment.
• Develop and support dashboard website for monitoring application performance, logging of errors and trouble shoot any inconsistencies in the data from upstream on each servers. Java, JSP and HTML front end, JDBC as the Oracle Backend with Tomcat as Webserver.
• Generating Alerts on any degradation of the VOIP call performance using Perl DBI/DBD SQL queries, object oriented Perl to map the call detail records category and displaying of alerts using Perl CGI/Apache web server.
• Parallelization of the ETL process using forking of processes in Perl.
• Design and Develop code in Perl, SQL (Oracle) and Linux platform for each release.
• Perform design, development, testing and implementation of the applications using Perl, Java, Shell Script and Oracle Database on UNIX and Windows Platforms.
• Conduct QA/UAT testing of applications and deploy them in production.
• Created test cases test conditions and test scripts in perl/unix.
• Creating automated test tool for integration and regression testing using Unix/Perl shell scripting on UNIX based environment.

Environment: Perl 5.8, Java JDK 1.6, Eclipse IDE, CGI, XML, Oracle 11g, PL/SQL, JavaScript, DBI, SQL/Plus, SQL,RED HAT Linux 5.9,Apache Tomcat 7.0.47