SUMMARY:

• A highly successful IT Professional with expertise in Mainframe Technologies and in Health Care and Financial Services Domains aspiring for a Mainframe Lead position
• 9 years of expertise in IBM Mainframe Technologies and 2 years of experience in Confidential Datastage Suite
• 6 years of Healthcare domain expertise and 3 years of Financial Services domain experience
• Expertise in all levels of SDLC from requirements gathering till product delivery and maintenance.
• Healthcare SME with Business and Systems Analysis experience
• Certifications include DB2 UDB Family Fundamentals 8, Business Systems Analyst Certification, AHM 250 by AHIP,
• Excellent Communication, Leadership and Documentation Skills.
• 2 year of experience in coordinating activities in an onsite - offshore perspective - mentoring and guiding a team of 12 from onsite by getting requirement clarifications, test data setup, review of deliverables and presenting to client in an efficient manner
• Positive thinking and result oriented attitude added with strong analytical and problem solving capabilities
• Mentoring, team-building and relationship management abilities
• Proven ability to understand business problems and apply technology to formulate workable solutions.
• Project Process Expertise

SKILLS SUMMARY:

Operating Systems: Z/OS, OS390, Windows XP/2000/98SE

Languages: COBOL, JCL, SQL, CICS, Unix Scripts

Databases: DB2, IMS DB/DC

ETL: Confidential Datastage (Designer, Director, Administrator Client)

Tools: HP QC, File Aid, Abend Aid, Expediter, Changeman, SAR, Control-M, BMC, SPUFI, IOF, Super CE, EzyEdit, IBM PD Tools (Fault Analyzer, File Manager, Debug Tool), Fundamentals of REXX, Infogix UACR, CA Dispatch, Endevor, Insync, Dumpmaster, Micro Focus Mainframe Express, Serena Business Manager, PuTTY, AppTune, BMC Catalog Manager, Command Editor for DB2

Others: VSAM, IDCAMS, SORT utilities, RPC, Infogix UACR, Lotus Notes, MS Exchange, MS Office Suite (Word, Excel, Powerpoint), MS Visio, MS Project

Domain: Healthcare: HIPAA (4010, 5010), EDI (837/835/824/270/271/276 ), NASCO, ITS Home Host Business, CDHP, Claims Processing and Adjudication, Benefits Administration, TPA (MCS, JAA, FFE) claims process, ICD-10 Knowledge Banking & Financial: Mutual Funds, ETF, Brokerage, Client Tax Forms, IRS Forms, 1099 Forms (B, OID, INT), FATCA, Corporate Actions

Methodologies: Waterfall, Agile, Prototyping/Proof of concept

EXPERIENCE HIGHLIGHTS:

Confidential

COBOL/DB2/Datastage Developer

Responsibilities:

• Requirement analysis and functional modeling of those requirements and creating design flow diagrams
• Creating functional models or prototypes that will help the development team to understand the process/functionality as specified in the business requirements
• Successful in proposing alternatives for complex requirements related to IRS E-filing automation
• Designing job flows and data interchange mechanisms between various vendor systems to transmit as well as receive securities and transactions data to in corporate in tax forms.
• Communicate with business stake holders or work with business analyst to reaffirm the requirements are captured in the program by creating process flow diagrams or flowcharts
• Participated in business requirement gathering sessions and provided inputs about functioning of the current system, the complications of incorporating changes in the system and alternatives for the logic
• Coordination with data-stage developers
• Designing new DB2 databases, writing programs to insert, update, delete and extract data from and into these DB2 databases
• Creating and modifying screens to in corporate the changes with new databases
• Unit Testing and system integration of the DB2 table handler programs
• DB2 Performance tuning and creation of scalable solutions with re-usable program modules
• Design and coding of automation programs
• Creating parallel jobs and sequencer jobs in Datastage using different kinds of stages (including but not limited to sort, aggregator, transformer and lookup) and create reports out of files and databases
• Writing unix scripts to invoke datastage jobs as well as FTP files to/from mainframe and SCP to other systems as well as file processing scripts; updating SSI files
• Unix shell scripting to manipulating files, error checking and logging of FTP and SCP
• Batch scheduling - automatically receive files from other entities (via FTP) and systematically update DB2 databases (involves data transfers, data mapping and replication)
• Supported System Integration and Regression Testing for Tax Forms team for 5 months - tools used HP QC and Serena Business Manager
• Unit testing, integration testing, performance testing, production parallel testing
• Working in Agile Methodology with daily scrums and status reporting

Environment: COBOL, JCL, CICS, DB2, SQL, BMC, Performance Tuning, Microfocus COBOL, DumpMaster, Insync, ETL (IBM Datastage)

Confidential

Technical Lead/Business Analyst

Responsibilities:

• Requirements analysis, mapping design areas to those requirements using RTM, creating test scenarios and unit/system test plans
• Dealing with multiple TPA clients and their systems, specific transmission needs and data formats and benefit coding data
• Working closely with multiple technical leads (a lead will be coordinating a number of TPA clients) to figure out the accumulator structure, benefit design and claims transfer/processing flow
• Create a claims processing frame work Blue Exchange - COBOL, FTP, DB2, IMS DC
• Establishing a handshake mechanism to tally the claims that are sent out to TPA and received back from TPA via clearing houses using UACR balancing
• Creating queries to inquire and update the claims routing information for various TPA clients
• Creating the business and technical requirements document
• Design and coding reviews
• Write programs to systematically update DB2 databases for claims queuing and routing, also involves writing queries, optimizing queries for enhanced system performance
• Business Requirements elicitation, gathering, analysis and documentation
• Test data setup and testing coordination, FTP setup for files transfers from various TPA clients
• Quality Assurance, RTM, DPC
• Unit testing, Integration testing, User Acceptance Testing, Regression Testing, Implementation support
• Weekly calls with various TPA clients who are switching from a MCS to JAA product
• Mentoring the team by taking sessions on business knowledge and the technological implications in the systems

Environment: COBOL, JCL, DB2/SQL, IMS DB/DC, FTP, IBM PD Tools (File Manager, Fault Analyzer, Debug Tool), SAR, Control-M, UACR, Requisite Pro, RTM

Confidential

O ffshore Technical Lead/Project Lead

Responsibilities:

• This project awarded me special mentions from the project client side technical lead and project manager for the design of the process
• Requirement Analysis and documentation
• Proposed various solutions and design models to achieve requirement goals and to ensure high efficiency deliverables, although ensuring the solutions are scalable and cater to performance needs
• Writing technical requirements based on the business requirements and creating functional model based on BTRD
• Creating new IMS DC screens for enrolling mid-year members and reversing those transactions and inquiry of proration credits based of subscribers ID
• Developing new DB2 Database and I/O routines (programs to extract, insert, update and delete data, later phases of this project involved tuning of previously written queries)
• MQ messaging and transactions update - updating the MQ DB of HRA fund manager so that dollars are allocated properly - change of CICS screens for transaction enquiry
• Developing PL/SQL procedures & triggers to inquire/update the HRA interface (LITES)
• Reports and testing it against CA-Dispatch
• Creating use cases and functional design models
• Design, Coding, Testing and Debugging
• Implementation Support/Activities and Warranty support
• Review of deliverables to ensure quality assurance
• Mentoring and managing work load of 12 resources in the team

Environment: COBOL, DB2, PL/SQL, JCL, MQ, CICS, IMS DB, UACR, SAR, RPC, IBM PD Tools, DFSORT, BTRD, RTM, Requisite PRO

Confidential

Offshore Module Lead

Responsibilities:

• Requirement Analysis and estimation
• RPC testing, changes in IMS DC screens
• Develop PL/SQL programs to extract data to various report files and route it to CA-DISPATCH
• Performance tuning of PL/SQL programs using AUTOTRACE
• Program impact analysis and documentation and identifying possible areas of code/ performance/ process improvement
• Design, Coding, Testing and debugging
• Implementation Support/Activities
• Review of deliverables for quality assurance
• Handled the role of QC/DPC whose responsibilities include creating process metrics and handling the quality of deliverables for the project.

Environment: COBOL, JCL, PL/SQL, IMS DB, UACR, Control-M, SAR, File-aid, Abend-aid, Expeditor