SUMMARY

• Having 6 Years of total IT Experience in Java, Mainframe and Informatica Power Center with a strong emphasis on analysis, coding, and testing.
• Business Knowledge in Telecom and Insurance domain.
• Experience in Development and Production Support.
• Extensively worked on standalone Java Programs to process data in flat files and store in desired output format.
• Hands on experience in analyzing and fixing production support issues for Java applications.
• Experience in Mainframe projects like Enhancement and Support of Applications with PL1, COBOL, JCL, DB2 and IMS skills.
• Extensive Experience in handling the tools such as TSO/ISPF, File Manager, SPUFI, ENDEVOR and XPEDITOR.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in ETL design, development and maintenance using Informatica Power Center 8.6.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Well versed in UNIX shell scripting.
• Responsible for all activities related to the development and implementation.
• Experienced Confidential Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data.
• Excellent communication, documentation and presentation skills using tool like PowerPoint.
• Lead Requirement gathering session for my applications.
• Good interpersonal and communication skills, commitment, result - oriented, calm and focused while tackling challenging tasks.
• Knowledge in SDLC development

TECHNICAL SKILLS

Programming Skills: Java, HTML,SQL, UNIX Shell Scripting

Programming Languages (Mainframe): JCL,COBOL,CICS, PL1

Data warehousing Tools: Informatica Power Center 8.6

Operating Systems: Unix, IBM Mainframe: OS/390, Windows XP/2000, Linux

Databases: Oracle, IMS-DB, DB2

Tools: /Utilities: Toad, Eclipse, TSO/ISPF, SPUFI,XPEDITER, ENDEVOR, File Manager, ASSIST (Ticket manager), Quality Center (Ticket manager)

PROFESSIONAL EXPERIENCE

Confidential, Dallas, Texas

Java- ETL Informatica developer

Responsibilities:

• Involved in requirement gathering and creating different document as SR, HLD,AD etc;
• Created Java Programs which interacts with Informatica using Unix Shell scripting.
• Maintain and debug Java applications.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Developed ETL programs, workflows mappings using Informatica to implement the business requirements.
• Designed and created complex source to target mappings using various transformations like Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs using UNIX shell scripting.
• Deploy new releases and ensure production stability
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.
• Analyze any Job or workflow failure and take the actions as required.
• Communicated with business customers to discuss the issues and requirements.
• Handle ticket using QC as ticket monitoring tool.
• Handle Sonar and TDP-RM tool for the application.
• Used Version Controlling tool SVN to maintain the version of deployed code.

Confidential

Mainframe developer

Responsibilities:

• Supports and maintain few applications of FriendsLife and always given high priority for the production issues. Analyze the production problems and take the action immediately.
• Monitoring of scheduled jobs for Overnight Batch Processing and provide support for online and batch applications.
• Conducting analysis of ABEND and issues faced by user and suggesting the best resolutions within SLA
• Perform code changes or data changes to fix the issue and perform testing in lower environment before deploying it into production.
• Written various Selcopies to perform the data change in IMS database.
• Prepared and Update various Run Book according to requirement changes.
• Identified and implement various performance improvement solutions.
• Involved in fixing the issues using Assyst (Online Issue Tracking Software)
• Involved in Unit Testing.
• Achieve Star Team award for the successful completion of transition for Friends Life Applications.
• Won the Spot Awards and client appreciation for application support and timely deliverables.

Confidential

Responsibilities:

• Analyzed and debugged the application and data issues.
• According to requirement perform changes in the program. Created packages to deploy the code to the production environment
• Communicated well with team mates and also with other module members to avoid any discrepancies.
• Submitted the deliverables within deadlines.
• Used Xpeditor tool to debug the issues.