SUMMARY:

• An accomplished IT Professional having over 15 years of corporate experience working in financials, retail, mortgage, health care and insurance domains
• A Team leader, skilled in developing and maintaining a broad vision, cultivating excellent relationships, and communicating effectively across the organization to build focused and productive teams.
• Successful in ensuring integrity and delivery of multiple projects with respect to time, budget, scope, change, risk and resources.
• Extensive Experience in all stages of the Software life cycle - from Requirement Analysis, Development, Testing, Maintenance and Implementation with Multiple Domain Expertise.
• Successful in bridging the gap between the business and technology groups
• Team player, enthusiastic and self-motivated.

TECHNICAL SKILLS:

OS: OS/400, Windows XP/Vista/7, Unix, Linux

Programming: RPG/400, CL/400, RPGLE, Embedded SQL, ILE CL, SQL/400, RPG Free, Java servlets, JSP, VB

Tools: IBM Rational Development studio for I, ROBOT Scheduler, TurnOver Change Management System, Hawkeye, DBU, TOAD, eClipse, Visual Studio, Oracle SQL Plus, HP Quality Center, Microsoft Office Suite

Databases/RDBMS Technologies ERP ETL Tools: DB2/400, DB2 UDB, SQL Server, Oracle 11g, DB2Midrange - AS400/ iSeries /i5/System I, J2EE, Java servlets, JDBC, XMLJD Edwards one world, IPMS, PkMS, JDA MMInformatica

PROFESSIONAL EXPERIENCE:

Confidential, Dallas TX

Sr Programmer Analyst

Responsibilities:

• Maintainingand managing the LM plan, EPS, LAMP, Homebase and collections suite of applications.
• Successful implementation of secure transmission of files from iSeries to Linux/Windows platform using SFTP to meet banking standards
• As part of the base team and SER team, I was involved in requirement gathering by liaising with the business, Impact analysis, design, develop, testing and provide production support.
• Lead, maintain, coordinate and mentor the off- shore team for developing and maintaining the Collection application suite and eps pay plan application.
• Designed and developed a process to do bulk upload of customer mortgage accounts from Fidelity system to Confidential ’s (Countrywide’s) in-house mortgage application using free format RPG and embedded SQL
• Create, maintain and test various eps payplan utilities using Free format RPG, CL/400, DB2 using ILE concepts Service programs, procedures, Modules, embedded SQL etc.

Environment: AS/400, RPG/400, CL/400, SQL/400, Java, ILE RPG, ILE CL, embedded SQL, MQ Series, DB2/400, Turnover, Hawkeye, XML, VB, Free format RPG

Confidential, Houston TX

Sr Systems Analyst

Responsibilities:

• Lead and manage the Treasury services team for IRFE.
• Extensively involved in requirement gathering by directly liaising with the business, Impact analysis, Development and testing various treasury and Interest rate derivative products and applications.
• Member of the RPGLE code review team, where coding standards are reviewed periodically and all code developed are ensured to adhere to the standards
• Successfullysupported the production systems based on the "follow the sun model". Trained, mentored and managed the team to provide day to day support
• Designed a work flow in IRFE to multi stream the RPGLE trade upload process. During the merger of Bear sterns, we were required to load huge volumes of trades at one go. By multi streaming the process, we were able to increase the load from 24-30 processing intensive trades per minute to around trades a minute. We were able to load huge volume of trades quickly and accurately saving lot of time and money to the company.
• Enable applications to STP (Straight through process) the trades directly to the downstream using XML via MQ series. Wrote various utilities using ILE RPG, CL/400, DB2 using ILE concepts Service programs, procedures, Modules, embedded SQL.

Environment: AS/400, RPG/400, CL/400, SQL/400, Java, ILE RPG, ILE CL, embedded SQL, MQ Series, DFU, DB2/400, SEU, PDM, Turnover, Hawkeye, XML, Informatica, IBM Rational Development studio for I, Free format RPG

Confidential,, Columbus OH

Sr Programmer Analyst

Responsibilities:

• Responsibilities included Impact analysis, development and testing of their in-house built ERP system.
• Extensively worked with service programs, Binding directories, Procedures. Used advanced skills of ILE RPG.
• Provide day to day support for all VCF and Confidential stores. Task Included, Identifying the problem and fix the Problem.
• If program changes are required create a new project and complete the fix/enhancement as required by the problem ticket.
• Created Test cases, Test Plans and reports for the applications and performed all levels of testing.

Environment: AS/400, RPG/400, Cobol/400, CL/400, SQL/400, ILE RPG, Cobol, ILE CL, MQ Series, DFU, DB2/400, Aldon Change Management System

Confidential, Williams Sonoma, LLC

System Analyst

Responsibilities:

• Responsibilities included gathering user requirements, Impact analysis, development and testing.
• Worked with modules like Inventory control, Order management, replenishment, and fulfillment.
• Manage and maintain day to day production support issues on the IPMS and JDA MMS system
• Design, develop, code and test various Interface programs to PkMS application using RPG/400, ILE RPG, DB2/400. Was a key member in the Confidential in William Sonoma.
• Modify existing programs due to the Changes in Files and Interfaces on PkMS using RPG/400, RPGLE, CL/400, JDA MMS
• Created Test cases, Test Plans and execute the same

Environment: AS/400, RPG/400, CL/400, JDA MMS, SQL/400, Lotus Notes, Java, JSP, Servlets, WebSphere Application Server 3.5, Robot, ILE RPG, ILE CL, DFU, DB2/400, Cobol/400, Turnover Change Management System

Systems Analyst

Confidential

Responsibilities:

• Worked on the Vendor phase out project which consisted of changing the print locations for vendors based on specific requirements by the Vendor. Along with the print locations, there were changes in the type of letter used, change in attributes, s etc.
• Worked on the Geca to Fortis Carrier Conversion which required changing of carriers used for under writing. In the event of change in carriers, there is a series of database changes and associated programs inclusive of Multipage and Single page subfiles, to move the existing customers and the forthcoming solicitations to the new carrier. In this project the carrier is changed from Geca to Fortis resulting in Changing the database and affected programs.

Environment: AS/400, RPG/400, CL/400, JDA MMS, SQL/400, Lotus Notes, Java, JSP, Servlets, WebSphere Application Server 3.5, Robot, ILE RPG, ILE CL, DFU, DB2/400, Cobol/400, Turnover Change Management System

Programmer Analyst

Confidential

Responsibilities:

• As part of the Backoff BAU team I was involved in Impact analysis, design, development and various development projects to support the day-to-day Backoff support. Was involved in Implementation and production Support for BackOff Systems on a daily basis

Environment: AS/400, RPG/400, CL/400, SQL/400, Cobol/400, ILE RPG, ILE CL, DFU, DB2/400, IBM Visual Age for Java, WebSphere3.5, Aldon Change Management System, Hawkeye

Programmer Analyst

Confidential

Responsibilities:

• Worked on the Confidential price length conversion project which comprised of enhancing the price field from 7 S4 to 16 S8. The Project consisted of 4 phases and I was involved in analysis, design, development and testing of all the phases.
• Worked on the B204 mapping project comprising of mapping of ADP data which contains information regarding Bookkeeping, Finance and Stock details. ADP had modified the structure of B204. To accommodate these changes, Banc of Americas database structure had to be modified. This was a very crucial project as the Banc of Americas trade details, and Books of accounts are derived from the B204. I was involved in analysis, design, development, Implementation and Implementation support.
• Worked on Salesman code enhancement project which required enhancing the Registered Rep ID of Montgomery securities from 3 numeric to 3 character, so that number of registered reps are increased from 6.

Environment: AS/400, RPG/400, CL/400, SQL/400, Cobol/400, ILE RPG, ILE CL, DFU, DB2/400, IBM Visual Age for Java, WebSphere3.5, Aldon Change Management System, Hawkeye