SUMMARY:

• IT professional having 12 years of experience in architecture, analysis, design, development, testing, maintenance and implementation of complex Mainframe, Data Warehouse and content management applications spanning across banking and financial domain.
• In depth understanding of core banking functionalities and more than 5 years of experience in FIS Systematics core banking application.
• Worked extensively in Informatica Cobol, JCL, DB2, CICS, IMS DB - DC, VSAM, TSO, ISPF, SQL, CSF DESIGNER.
• Has worked with teams collaborating from multiple geographical location with considerable work experience
• Proficient using of informatica Power Center tools (Designer, Workflow Manager, Workflow Monitor, Repository manager 9.5and data bases like Oracle, DB2 windows and UNIX and mainframe environments. well versed with PL SQL shell scripting and exposure to data visualization using tableau.
• Good understanding of data analysis and profiling using multiple mainframe tools and utilities as well as ad hoc reporting using Tableau and Informatica
• Proficient in using tools and utilities such as Expeditor, Intertest, File aid, QMF, SPUFI, DFSORT, ICETOOL, SQL developer, CSF DESIGNER in both online as well as batch environments.
• Proficient in data modeling for OLTP relational databases and Data warehouse applications using Ralph Kimball and Bill Inman design principles including Facts and dimensions tables, Slowly Changing Dimensions (SCD) and Dimensional Modeling - Star and Snow Flake Schema.
• Proficient in designing and developing Data Marts in a data warehouse for business subject areas.
• Experience with handling Informatica Designer, Informatica Workflow Manager, Workflow monitor and Repository Manager.
• Experience in designing Reusable Transformations in Informatica such as Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Expertise in developing and running Mappings, Sessions/tasks, Workflows, and Batch processes on Informatica server.
• Adept in gathering end user requirements and converting them into functional specifications with excellent documenting and analytical skills.
• Well versed with preparing the high level and detail design documents along with the System impact analysis(SIA)
• Preparing project schedule, allocating and prioritizing tasks to the development team, conducting weekly status meetings, and reporting weekly project status.. worked on AJILE methodology well aware of defect tracking mechanism.
• Strong in problem solving, coordination and analysis.
• Highly motivated with the ability to work effectively in teams as well as independently.
• Fast Learner, good communication and presentation skills, ability to quickly adapt to the technical environment coupled with very positive user interaction & team spirit.
• Strong trouble-shooting, problem solving, analytical and design skills.
• Possess effective communication, professional attitude, strong work ethic and interpersonal skills experienced in using incident management application such as service now excellent presentation skills and ability to train and lead technical as well as business users with professional use of word, excel and Visio. proactive and self starter approach to problem solving and leading the team.

TECHNICAL SKILLS:

Mainframe: COBOL,JCL,IMS DB-DC,CICS, Systematics, Expediter, Chnageman

BI & ETL Tools: Informatica PowerCenter 9x, Data Warehousing, Tableau, SQL developer

Databases: Oracle 11g, DB2,VSAM

Operating System: MVS, Windows XP/NT/2000/98/95, Unix (AIX)

Languages: SQL, PL/SQL, COBOL

Scripting Languages: Unix Shell Scripting.

Domains: Core Banking, property and causality insurance, Investment products

Others: HP Quality Center, CSF designer, Microsoft word, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Technical architect

Responsibilities:

• Certified accounts awaiting tax identification number(TIN)
• Customer identified by IRS as having provide missing, invalid, or incorrect TIN
• Customer identified by IRS as having underreported earned interest
• Nonresident alien account holder for notification requirement for form W-8
• Uncertified interest bearing account holders for notification of requirement for W-9
• Worked as the technical lead for converting the application from home grown legacy application to FIS enterprise solution.
• Worked as SME and identified the gaps to come up with specification document for the customization.
• Extensively worked on COBOL, JCL, VSAM and Intertest to design and develop applications for supporting the certification tracking
• Designed and developed batch programs to process IRS inputs for missing TIN accounts
• Designed the batch process to compose the xml tag file for the consumption in HP exstream and filenet.
• Customized the FIS suite of programs as per the Confidential standards and
• Developed the process to handle the C notices .
• Designed and developed scheduled and ad hoc reporting using Cobol and Tableau.
• Developed NDM jobs to transmit the files to interfacing application. lead the team of developer by assigning work and reviewing the deliverables.
• Worked as disaster recovery coordinator for Continuity of business testing prepared and presented training sessions for the users to effectively use the newly installed HX application supported the batch application as and when needed.

Environment: Mainframe, windows, Unix: COBOL,JCL,CICS,VSAM,Flat files, Unix, Tableau, Systematics . oracle 11g. Informatica PowerCenter.

Confidential, Toronto, Ontario

Technical architect

Responsibilities:

• Worked as the transition manager for the initial phase of the project to ensure seamless project transition from competing vendor.
• Prepared the transition plan, timelines and cost estimation and risk assessment document
• Gather and mentored the team of developers to execute the transition plan.
• Worked as the single point of contact for the client and Vendor .
• Analyzed and documented the existing programs, jobs and Procs written in COBL, JCL, DB2 and SAS. worked extensively in COBOL,JCL,VSAM and DB2 to complete the ongoing work requests. analyzed the batch flow for personal portfolio statement generation and prepared the data flow from different I/O interfacing application.
• Designed and developed informatica workflows using Aggregate, filter lookup, joiner, expression, sorter transformation to replace the existing batch as and when possible.
• Redesigned the statements composed using CSF mainframe and Compuset to be composed by CSF designer running in AIX platform
• Designed and developed the data records in format needed by CSF designer
• Designed and developed the korn shell scripts to process the CSV files using the CSF engine to prepare the AFP file for document printing prepared the reconciliation report and the companion file for running the statement composition batch application designed and developed the tagged logical element to be used by CMOD for paperless processing worked on Extracting and transforming data from multiple mainframe and oracle applications to prepared the CSV output desired by the CSF designer tool
• Used the CSF designed tool to generate various types for outputs such as AFP,PDF and TLE to support the paperless initiative

Environment: Mainframe, windows, AIX: COBOL, JCL, VSAM, Flat files, AIX,. oracle 11g. Informatica PowerCenter.

Confidential, Toronto, Ontario

Technical lead

Responsibilities:

• Interact with the client and getting the knowledge on the application. Identify the pain areas in current system and capture the new requirements for future system
• Collecting the Requirements, prepare Requirement specification documents for future/enhanced system, prepare technical specification documents for future system/system
• Feasibility study, prototype development, with preliminary technical and risk analysis.
• Preparing the technical specifications and estimation based on analysis
• Design and developer jobs and programs using JCL,COBOL, IMS DB-DC and VSAM
• Unloading the DB2 as well as the IMS database and creating reports as per the business requirement
• Support for the online and the batch applications
• Enhancement and modification of existing IMS DC screens to accommodate new taxes and charges as needed preparing historical report showing rates variation over the years developing the programs to introduce new screen edits for IMS -DC screens
• Enhance and introduced new IMS segments to carry the new rates, charges and fess
• Ad hoc mainframe report generation as requested by business
• Document the rated application and presented it to management to pave way for the modernization of the application. writing the row level trigger for updating changes from master table to reflect in additional tables.

Environment: Mainframe, IMS, windows: COBOL,IMS DB-DC, JCL, VSAM, Flat files, Oracle

Confidential

Technical lead

Responsibilities:

• Worked extensively on IM, ST and RM applications.
• Organized meetings to gather end user business requirements and defined the report specifications.
• Scoping - Analysis of systems and Business Processes involved based on the Business input
• Involved in resource Planning and reporting resource utilization from offshore
• Preparation of Detailed design document from the BRD and FRD
• Monitoring the batch execution and provide timely fix for the failed jobs enhanced and developed new and existing Cobol programs for IM and ST application
• Worked on Account number expansion project and conducted detailed impact analysis
• Participating the daily defect meeting and assigned the defects to concerned developer.
• Provide all defect related statistics
• Involved in preparing the project work flow and documentation of the existing functionalities.
• Test plans covering extensive test cases based on analysis followed by signoff from peer reviewer & approver.
• Final Deliverables to customer with unit test report. designed and developed report using COBOl,JCL sort and VSAM input files

Environment: Mainframe, FIS Systematics windows, COBOL,CICS JCL, VSAM, Flat files

Confidential, Bellevue, Washington

Technical lead

Responsibilities:

• Organized meetings to gather end user business requirements and defined the report specifications.
• Involved in designing and implementing the rating process for auto line of business using COBOL programs and VSAM files and IMS DB DC
• Did the database design in IMS DB in order to hold the new data fields into the database and format them to the screen layout
• Worked extensively on the complex rate engine for premium computation part for auto line of business using the rate files.
• Solved the premium outage issues in reference to the policy premium processing over different transactions.
• Worked extensively on manually testing the complex rate engine for premium computation part for auto line of business using the rate files.
• Prepared and reviewed the test plan test case and technical design documents.
• Participating and conducting in weekly status and SCRUM meetings..
• Responsible for testing and implementing the large scale development and enhancement project.
• Ensured the optimal utilization of the available tools and utilities such as EXPEDITOR, QC, FILEAID for testing purpose.
• Engaged in prioritizing and planning the work execution
• Scoping - Analysis of systems and Business Processes involved based on the Business input

Environment: Mainframe, windows, COBOL,IMS DB/DC JCL, VSAM, Flat files

Confidential

Senior Developer

Responsibilities:

• Responsible for testing of and enhancement of a zero tolerance, high end business application development project.
• Utilized the available tools and utilities such as EXPEDITOR, INTERCOM, and DFSORT for debugging and development.
• Designed and developed and modified batch COBOL, IMS DB DC programs and JCLS for the agency download file.
• Defined multiple new IMS transaction related to newly developed IMS DC screens
• Modified the DBD to reflect the change and addition of new IMS segments
• Analyzed the functional requirement to prepare the technical design document and test plan test case.
• Involved in reviewing the technical design and test plan test case document.
• Involved in parallel testing of agency download files..
• Facilitating Technical Specification document walk through with the Projects Lead Business Analyst and the Service area Leads.
• Involved in training others in the online system and functionalities.
• Delivered high quality work on time with multiple competing priorities.
• Participated in Defect and Bug tracking meetings.
• Preparing the project closure document, delivery document and knowledge sharing documents for future reference.

Environment: Mainframe, windows, COBOL,IMS DB/DC JCL, VSAM, Flat files