SUMMARY:

• Around 11 years of professional IT experience in various technologies including automation and data warehousing projects using Perl, Object Oriented Perl, java, Shell Scripting and SQL on UNIX, Oracle environments.
• Extensive experience in developing perl modules.
• Extensive experience in pattern matching, file handling, error handling, s, data structures, scoping, DBI, XML, OO Perl design, Shell scripting, Java script, CGI - Perl, HTML etc.
• Hands on experience in HTML,CSS,javascript,jQuery,apache and DHTML
• Hands on experienced in developing applications using, Core Java, Spring framework, Hibernate, JMS,JSP,, JDBC, multithreading, collection, REST MVC,SOAP, activeMQ, XML,SQL,PL/SQL and RDBMS like Oracle, SQL server and MYSSQL.
• Good Understanding of ETL technologies and concepts.
• Experience in Spring DI, AOP, Security, Spring JMS and Spring JDBC Template technologies.
• Certified Project Manager.
• Quick adaptability to any new work environment and new technologies. Have worked on multiple ETL tools and was able to cope up with no from the tool vendor.
• Possesses excellent analytical, communication, inter-personnel and problem-solving skills to handle client facing roles and end user communications.
• Handled several responsibilities like Requirement Analysis, Development, Design innovations (Providing Optimal Technical Solutions), Reviews, Client interactions, offshore team anchoring and onsite-offshore co-ordination activities.
• Strong experience of managing quality processes such as process audits and work product audits.
• Strong ability in multi-tasking and adapting to new work opportunities/agile environments.

TECHNICAL SKILLS

Operating Systems: Windows95/98/2000/XP/7,NT,UNIX(HP-UX 10.20, Sun Solaris 5.10, AIX 6.1.0,0), Linux 2.6

Database: Oracle 10g/9i/8i/8/7.x, MS Access, SQL server 2000, DB2, Sybase 12/11.2/10, Teradata V2R6.2, 13.0

Programming Languages: PERL,OO PERL, C,, SQL, PL/SQL,, JAVA,SPRING,HIBERNATE,JSP,Servlet

ETL / BI Tools: Ab Initio GDE 2.15, 3.x, Abinitio EME

Oracle Tools: SQL Loader, TOAD, SQL * PLUS and SQL Developer

Testing/Other tools: Quality Center 10.0, SharePoint, Crystal Reports, Business Objects, MS Office

Batch Process Schedulers: Crontab, Autosys, Control-M

Data Modeling: Erwin 3.5.2/4.0

Scripting Languages: Perl, Object Oriented Perl, Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, PA

Senior Application Developer

Responsibilities:

• Met with business/user groups to understand the business process and gather requirements.
• Created automation frameworks for mitigation and kafka process
• Developed Perl scripts for automatically cleaning up the jobs that are not active in contromM server.
• Worked on creating new controlM jobs and modifying the existing jobs based on business needs.
• Used GIT repository to checkin scrips and jobs.
• Developed NW status summary portal page for DEV and IStripe environments.
• Developed EM monitoring scripts using perl.
• Worked on Magic tickers and Jira tickets .
• Designed and coded artifacts that meet the specifications using Perl, Control M, Oracle,Java,JSP and UNIX.
• Analyzed functional requirements, mapping documents, assisted in problem solving and troubleshooting for both real time and batch applications.
• Extensively used pattern matching, file handling, error handling, s, data structures and DBI module.
• Wrote many Korn Shell scripts to automate parameter generation, combining files and support ad-hoc requests.

Environment: Perl, OO Perl,, ControlM,jquery,javascript, jQuery CPAN, DBI, Oracle 10.x SQL Developer, PL/SQL,java, spring, Hibernate,Erwin Data Modeler, AWK,SED, Teradada, Eclipse, DBVisualizer, SQL Developer, TOAD,Java, XML, MS Office, Share Point, control-m, UNIX Shell Scripting,Nortel Networks and VPN

Confidential

Senior Developer

Responsibilities:

• Met with business/user groups to understand the business process and gather requirements.
• Developed a thorough understanding of business specifications and produced technical architecture /design and code artifacts that meet the specifications using Perl modules, Autosys, Oracle, Teradata and UNIX.
• Analyzed functional requirements, mapping documents, assisted in problem solving and troubleshooting for both real time and batch applications.
• Accomplish automated data extraction, transformation and load process from heterogeneous source systems via Perl modules.
• Extensively used pattern matching, file handling, error handling, s, data structures and DBI module,
• Extracted data from various sources like databases, delimited flat files, mainframe files and XMLs and developed Perl code for loading into target database or creating outbound feeds.
• Wrote many Korn Shell scripts as wrapper to invoke and handle perl programs and support ad-hoc requests.
• Manage and support production release related activities. conducted RCA for defects identified in testing phases and fixed the root causes of issues.
• Provide system support and correct errors to maintain system after implementation.
• Prepared and executed test cases to perform unit testing and integration testing.
• Mentor junior members and optimize the SQL to improve performance.

Environment: Perl, OO Perl, jQuery, JavaScript, CPAN, DBI, java,,Oracle 10.x SQL Developer, PL/SQL,XML java, spring, Hibernate,, Erwin Data Modeler, AWK,SED, Teradada, Eclipse, DBVisualizer, SQL Developer, TOAD,Java, RCA, XML, MS Office, Share Point, control-m, UNIX Shell Scripting,Nortel Networks and VPN

Confidential

Senior Developer

Responsibilities:

• Met with business/user groups to understand the business process and gather requirements.
• Created mapping document and ETL design document.
• Created Perl Scripts, Ab Initio graphs to load data from flat files into Oracle after transforming the data based on Business requirements and mapping.
• Developed Perl scripts, modules and Ab Initio graphs which generate different report ready and staging output files.
• Designed and developed parameterized graphs using rollup, join, look up transformations from the Component Library and loaded data using Ab Initio as an ETL tool.
• Accomplish automated data extraction, transformation and load process from heterogeneous source systems.
• Wrote many Korn Shell scripts to automate/wrapper the parameter generation, combining files and support ad-hoc requests.
• Involved in providing various data feeds to other systems by extracting, filtering and transforming and creating flat files.
• Extensively used Partition and Departition components, to speed up the ETL process.
• Worked directly with non-IT business analysts throughout the development cycle and provided post-implementation support, investigation of data and report issues identified by customers.
• Prepared and executed test cases to perform unit testing and integration testing.Manage and support production release related activities.
• Post implementation monitoring and support. conducted RCA for defects identified in testing phases and fixed the root causes of issues.
• Handle and resolve live production issues raised by user within given SLA.
• Acted as SME for all application level clarifications, resolve doubts related to requirements / design and guide them on technical issues. Mentor junior members and optimize the Ab Initio Graphs to utilize less memory and improve performance.
• Worked as a Development Team Lead - leading a team of 5 developers.

Environment: Perl, OO Perl, Solaris 5.8, jQuery, javascript,, Oracle 10.x SQL Developer, PL/SQL, java, spring, Hibernate,, Shell scripting, SED,AWK, Java, XML, MS Office, Share Point, control-m, RCA,Nortel Networks and VPN

Confidential

Application Developer

Responsibilities:

• Involved in Requirements Analysis, Design, Development and implementation of the project.
• Designing and developing/Changing Perl Scripts and modules, taking high performance requirements into consideration.
• Developed UNIX shell scripts to handle pre file processing and getting the files ready.
• Prepared and executed test cases to perform unit testing and integration testing.
• Identify performance bottlenecks in the production processes and identify key places where SQL can be tuned to improve overall performance of the production process.
• Provide system support and correct errors to maintain system after implementation.
• Handle and resolve live production issues raised by user within given SLA.
• Acted as SME for all application level clarifications, resolve doubts related to requirements / design and guide them on technical issues. Mentor junior members and optimize the Ab Initio Graphs, SQL to utilize less memory and improve performance.
• Post implementation monitoring and support.

Environment: Perl, OO Perl, Oracle 10.x SQL Developer, jQuery, javascript,PL/SQL, Ab Initio (GDE 3.1.5, Co-Op: 3.1.4 and EME), Erwin Data Modeler,AWK,SED, Teradada, Eclipse,DBVisualizer,SQL Developer, TOAD,Java, XML, MS Office, Share Point, control-m, UNIX Shell Scripting,Nortel Networks and VPN

Confidential

Application Developer

Responsibilities:

• Involved in attending the client meetings and gathering the requirements and preparing detail design documents.
• Designing and developing perl scripts, modules and Ab Initio graphs taking high performance requirements into consideration.
• Implementing graphs using various partitioning component and techniques to improve performance.
• Extensively used pattern matching, file handling, error handling, s, data structures and DBI module
• Use re-partitioning technique and multi-partition file and flow to speed up the processing of data wherever applicable.
• Developed UNIX shell scripts to handle pre file processing and getting the files ready for processing through Ab Initio mappings.
• Wrote several PL/SQL, SQL, and shell scripts to investigate errors and to scrub the customer account and production data.
• Developed database triggers to implement data integration and to enforce validation rules.
• Created data mappings to load the data from flat files to target Oracle tables.
• Identify performance bottlenecks in the production processes and identify key places where SQL can be tuned to improve overall performance of the production process.
• Received client appreciation for the delivering automated processes and innovative reusable components.
• Provide system support and correct errors to maintain system after implementation.
• Handle and resolve live production issues raised by user within given SLA.
• Post implementation monitoring and support.

Environment: Perl, OO Perl, UNIX (HP-AIX) 5.3, Ab Initio (GDE 1.13.13, EME and Co-Op: 2.13), Java,Shell Scripting, SQL, PL-SQL, control-m and Quality center.

Confidential

Senior Software Engineer

Responsibilities:

• Involved in the project and task estimations.
• Developed the PERL scripts and fixed the burts for the WAFL-QA test cases
• Developed PERL scripts to automate the existing manual test cases in the project.
• Followed the NetApp coding standards and the guidelines while writing scripts.
• Reviewed the code written by the team members.
• Worked and coordinated with developers in developing the automation scripts.

Environment: Perl, OO Perl,UNIX and NATE

Confidential

Senior Analyst

Responsibilities:

• Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users
• Extensively worked on with the Ab Initio Enterprise Meta Environment (EME) to obtain the initial setup variables and maintaining version control during the development effort.
• Extracted data from various sources like databases, delimited flat files.
• Created sandbox utility using shell scripts for individual development and testing environment.
• Documented requirement and design document
• Involved in change management using Remedy Action Request System by creating SRs, IMRs and CMRs to raise issues
• Worked closely with data modelers and helped in the design of schemas and tables including SCDs.
• Developed wrapper scripts to periodically notify users in case of any failures with debugging information.
• Developed UNIX Korn Shell wrappers to initialize variables run graphs and perform error handling.
• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Pset, XFR, deployed scripts, DBC files for connectivity, create Package and exports.

Environment: Perl, OO Perl, CPAN, DBI, Ab Initio (GDE 1.15, Co>Op 2.15), UNIX, Oracle 9i, TOAD, Data Studio, AIX

Confidential

Technical Analyst

Responsibilities:

• Performed Requirement Gathering & Analyzing and negotiating customer requirements and prepared the requirements specification document.
• Analyzed Business Requirements and Identified mapping documents required for system and functional testing efforts for all test scenarios.
• Developed Use Case diagrams, business flow diagrams, Activity & State diagrams.
• Involved in developing the Restful web service using Spring.
• Developed Hibernate mapping files, Pojos and Hibernate configuration files.
• Developed the application using Spring Framework that uses Model View Controller (MVC) architecture with JSP as the view.
• Developed presentation layer using JSP.
• Used Log4j and implemented Log4j property file for logging purpose.
• Extensively used JQuery client side validation.
• Developed Selenium and Junit test frameworks.

Environment: JSP, HTML, CSS, Spring IOC, Spring MVC,Restful Web services, Java, Hibernate, JQuery, SQL, DB2, SVN, Log4j 1.2, XML, Agile model, SCRUM.

Confidential

Software Engineer

Responsibilities:

• Developed a web application using CGI-Perl, JSP and Servlets.
• Learned and implemented different design patters like Singletons, Factory method, Builder etc.
• Participated heavily and later maintained the documentation for projects
• Developed content management systems for multiple clients using J2EE
• Used EJBs in the application and developed Session beans to house business logic
• Developed views for JSP pages using jQuery and AJAX
• Worked extensively on creating rich front-end web interface using HTML/CSS, JSTL, JavaScript, jQuery
• Used JDBC for communicating with database
• Used SQL Server as the database for the application
• Implemented XSLT transformations for converting XML to HTML

Environment: Windows, Linux, CGI-perl,Java, JSP, Servlets, JDBC, HTML, CSS, JavaScript. jQuery