SUMMARY:

• Over fifteen year of IT experience in Analyzing, Developing, and testing multiple projects from Healthcare, Financial, Automotive, Banking, Insurance and Retail industries
• Over six years of experience Business Analyst/Project management
• Financial industry experience includes working at Confidential, Confidential, Ford Credit, Confidential, AIG and Confidential Stock ledger/Sales Audit systems
• Experience in Gathering functional requirements by conducting JAD sessions, creating Use case diagrams, use cases using UML, activity diagrams, sequence diagrams and swim lanes
• Experience with creation of design documents, Requirement traceability matrix for the Projects
• Extensive experience working with Structured Query Language (SQL) on Relational databases like DB2, Teradata, Sybase, for data conversion, manipulation, transformation, reporting, data analysis and System design
• Experience coordinating, negotiating and motivating resources to deliver CUSTOM developed products
• Worked on Data warehousing projects involving ETL tools on IBM Mainframe environment at Confidential and Confidential Corporation for Data mining and warehousing applications
• Experienced in leading and working with off - shore teams
• Ensured effective and timeliness reporting to higher management. Effectively managed multiple projects at the same time
• Proficient in Test strategies, test cases, and test execution User/System Acceptance Testing and activities as needed for Quality assurance in System Installation and support
• Production support as needed for installation and system maintenance
• Highly proficient with Microsoft tools like, Excel, Word, Power Point, Visio, Microsoft Project
• Experienced with the RUP, USDM Methodology, PMBOK, Spiral, Agile, Waterfall

TECHNICAL SKILL:

Platforms: IMB Mainframe, Windows NT, UNIX, MVS, Windows 9x, ES 9000, Windows 2000, IBM 3090, DEC/VAX

Technologies: COBOL I/II, CICS, TSO/ISPF, SQL, Java, JDK, Assembler, RUP, File Aid, DYL280, DB2 stored procedure, JCL, JSCAN, PowerBuilder, Change man, PowerBuilder, JavaScript, Via soft smart test, doc, Superc, CA-7, VSAM, BIBO, HTML, EDI/Gentran, FOCUS, Peregrine

Tools: Microsoft Project, Excel, Visio, PowerPoint, Word, Microsoft SharePoint.

Databases: IMS (DB/DC), DB2, Teradata, Oracle, Sybase, SQL

EXPERIENCE:

Confidential, Boston, MA

Business Systems Analyst

Responsibilities:

• Qualified Medical and dental plans.
• Individual eligibility and Enrollments .
• Small business group enrollment.
• Eligibility for Medicaid or reduced priced insurance.
• Provider search and related issues .
• State Wrap and Subsidized plans
• End User testing and Migration of modules to production.
• Verification and validation of user requirements .

Technical Environment: J2E, SQL, Webserver, Oracle, Stored procedures, JIRA, Sharepoint .

Confidential, Wellesley, MA

Business Systems Analyst

Responsibilities:

• End User testing and Migration of modules to production, Verification and validation of user requirements

Environment: SQL Server, COBOL, IMS, Microsoft share point, Web, Visual Basic, Microsoft SharePoint

Confidential, Marlborough, MA

Technical Analyst (Technical Business Analyst)

Responsibilities:

• Interaction with end users on Business requirements and Service specialists to configure Outsourced Benefit Administration for Benefits program and Output file configuration.
• Gather client specific requirements.
• Responsible for communication between Technical team, Business Team, Project Management team and Support Team by providing project management status on accomplishments, issues to be resolved.
• Consult company clients regarding Health benefits (Medical, Health Dental, Vision), Spending account(HCRA, DCRA) and Flexible spending account and Life Insurance requirements gathering and verification of requirements for clients.
• Configuration of OBA products using code changes in XML, Java, and JavaScript for fulfilling client specific customization of OBA products.
• End User testing and Migration of modules to production. Verification and validation of user requirements.

Environment: COBOL, DB2, Maven, Eclipse, Clear case, Mercurial, JavaScript, Java, XML, Serving XML, Toad, Oracle, OBA products

Confidential, Providence, RI

IT Systems Analyst/ Tester (Consultant)

Responsibilities:

• Interaction with end users requirement gathering, creation of Use cases, Conceptual and detail design documents, System Integration and End user testing and system installation.
• Responsible for communication between Technical team, Business Team, Project Management team and Support Team by providing project management status on accomplishments, issues to be resolved.
• Conduct JAD Sessions to derive business requirements as applicable to projects.
• Reporting requirements for Corporate accounts payable modules.
• Used Concur, Actuate on SQLSERVER database for data analysis for business support using structured Query language (SQL).

Environment: Actuate, Concur, Toad MS Word, SQL, SQLSERVER, DB2, Excel, MS Visio, Java, COBOL, SQL, Windows XP Access

Confidential, Westborough, MA

IT Systems Analyst and Developer (Consultant)

Responsibilities:

• Interaction with end users requirement gathering, creation of Use cases, Conceptual and detail design documents, System Integration and End user testing and system installation.
• Responsible for communication between Technical team, Business Team, Project Management team and Support Team by providing project management status on accomplishments, issues to be resolved.
• Conduct JAD Sessions to derive business requirements as applicable to projects.
• Gathered requirements for design and structure of reports for Store System sales, Financial, Stock ledger application as per stakeholder’s requirements.
• Systems specs for changes to support business need i.e. Totals for regions, Cashier Traversity, T.K. Max reports.
• Functioned as QA Analyst with Business team for user sign offs.
• Day to day support activities for stores system and Stock ledger applications.
• System specs for Credit card encryption and decryption, Key rotation, to support transaction and customer information security for all Confidential.
• SOX documentation for MKS, EDOC and Financial application documentation.
• System testing for Germany, E-stores, TK home sense, Server changes for E stores.
• System specs and User acceptance testing for migration to new Tape systems for Store system and Stock ledger financial application.
• Used QMF and SPUFI on DB2 database for data analysis for business support using structured Query language (SQL).

Environment: MS Word, SQL, Oracle, Excel, MS Visio, Java, COBOL, DB2, Windows XP Access, IBM Mainframe

Confidential

Business Analyst (Consultant)

Responsibilities:

• Interaction with end users requirement gathering, Creation of Use cases, Requirement traceability matrix conceptual and detail design documents, End user testing and system installation.
• Responsible for communication between Technical team, Business Team, Project Management team and Support Team by providing status on accomplishments, Project Quality and budget, issues to be resolved with any of the teams.
• Analyze provider system as it interfaces with BCN/NASCO/P&A for changes required for new PA type provider.
• Responsible for design of reports (Format /structures) for Provider System, Medicare, GHI and POGS reports as needed by stakeholders to support project needs.
• Business requirements, project coordination, conceptual and detail design of provider system for changes to include PA as valid provider.
• Creation of system specs for PA project.
• Use case creation for Physician organization gain sharing provider system changes and support.
• Assignment, allocation and coordination of day-to-day SIT activities for GHI and Expand Medicare crossover projects. Worked as Test lead and coordinator for GHI and Expand Medicare crossover projects.
• Creation of Test cases and Support SIT/UAT activities for PA project.
• Maintenance of test schedules and SIT functional and technical test Matrix for presentation to top management for daily, weekly and monthly reporting.
• Participated and facilitated in Customer support and resolution of claims and other production issues related to project implementation.
• Used QMF and SPUFI on DB2 database for data analysis for business support using structured Query language (SQL).

Environment: MS Project, SQL, Visio, Word, Power Point, RUP, Java, COBOL, DB2, Excel, and IBM Mainframe

Confidential, MI

Business Analyst (Consultant)

Responsibilities:

• Generate requirements, create use case and design document.
• Responsible for communication between Technical team, Business Team, Project Management team and Support Team by providing project management status on accomplishments, Project status, issues to be resolved with any of the teams.
• Supported systems related to integrated sales planning/ reporting system ISP systems supporting Confidential . System deals with sales planning, actual sales for various geographic regions like International, USA, Canada, Mexico, Asia, etc.
• Participated and facilitated in business review session including feasibility, operation and business perspective of requirement System changes to accompany changes in business needs like changes in monthly, daily, weekly counts, in Dealer distribution codes, backup of transaction files, and change in Peg rate.
• Test case creation for UAT /System testing for integrated sales planning system projects.
• Customer support and resolution of production issues related to Vehicle, Geography hierarchies, long term and short term plans, Sales programming, production planning, capacity utilization.
• Knowledge transfer for Onsite /Offshore coordination.
• System support including specs and UAT testing for Confidential system service requests.
• Confidential deals with supply of motor parts from DCX depots to dealer, Dealer to dealer supply, Dealer and depots inventories (Dealers accessing such inventories), part locator, Dealer connect, online orders, back orders and suggested, material systems, financial transactions and reporting.
• System makes use of transaction processing as well as data warehouse for such processing and uses business object for reporting.
• Knowledge transfer for Onsite /Offshore coordination.

Environment: MS Project, Visio, Word, Power Point, RUP, Java, COBOL, DB2, Excel, UNIX and IBM Mainframe

Confidential

Programmer / Analyst (Consultant)

Responsibilities:

• Gather business requirements to design, develop, test, enhance, maintain and document applications for Pharmacy benefit management systems.
• System deals with insurance claim payments to be made to pharmacies.
• Med Impact replaces DRAMS systems.
• Participated and facilitated in business review session including feasibility, operation and business perspective of Med-impact a new software that will process pharmacy benefits instead of old multiple interfaces using old systems.
• System Design, Coding, and testing for new reports needed for conversion from DRAM to Med impact Systems.
• System integration testing of groups, Membership, claims and history modules.
• Test data transmission to Med Impact systems. IRIS claims inquiry system testing and modifications.
• Incident reporting using Peregrine systems.
• User Acceptance, system, integration, and regression testing of Med Impact systems.

Environment: RUP, MS Word, CICS, COBOL, DB2, JCL (Including JSCAN), IMS DB/DC, Peregrine, Rational, VSAM, Expeditor, ENDEVOR, Windows XP Access, MVS TSO/ISPF, and IBM Mainframe

Confidential, Dearborn, MI

Business Analyst (Consultant)

Responsibilities:

• Gather business requirements to develop uses cases, test cases and design documents for New Generation securitization systems at Confidential Credit.
• Securitization deals with getting funding by issuing notes from financial institution investors.
• Assets used to securitize are accounts receivables from Ford customers due to credit financing.
• High-level system design of interface to Ameriprise for processing of insurance policies provided by Ford Credit.
• Define test cases and User acceptance testing of securitization systems.
• Participated and facilitated in business review session including feasibility, operation and business perspective of securitization systems like Volvo, Ford Italy, Europe, UK, and North America.
• Participated in design of reconciliation of LA to NGSS systems.
• Day to day support of business operations including supporting investor reporting anomalies, financial analysis, summarization.
• Month end system support for NGSS securitization systems for North America and Europe.
• Requirements gathering and System specs for Reports as needed by stakeholders for Securitization, Reconciliation and other business needs.

Environment: MS Word, Visio, RUP, CICS, COBOL, DB2, JCL (Including JSCAN), VSAM, Xpeditor, MPUPS, Superc, CA7, SQL, RDBMS, File Aid, Windows NT, Access, MVS TSO/ISPF, and IBM Mainframe

Confidential

Programmer Analyst (Consultant)

Responsibilities:

• Design, develop, test, enhance, maintain and document applications for batch programs of Blue exchange project.
• Blue exchange was an interface systems use to process eligibility and claim processing by the plan provider (BCBSM) and claim submitter.
• The system was designed as per HIPAA (the Health Insurance Portability and Accountability Act) guidelines.
• Participated and facilitated in business review session including feasibility, operation and business perspective of Blue Exchange.
• Designed coded and tested batch program using DB2, COBOL, JCL, VSAM, IMS, MQ series, Socket programming, Xpeditor, and ENDEVOR for Blue Exchange batch modules.
• EDI/Gentran mapping changes and testing using X12 270/271 and 276/277 formats.
• Facilitate better design of Blue exchange DB2 tables as per business.
• Unit, system, integration, and regression testing of Blue exchange programs.

Environment: EDI/Gentran, IMS DB/DC, COBOL, DB2, JCL, VSAM, Xpeditor, ENDEVOR, MQseries, Windows NT, Packman, MVS TSO/ISPF, and IBM Mainframe

Confidential, Dearborn, MI

Programmer Analyst (Consultant)

Responsibilities:

• Design, develop, test, enhance, maintain and document applications for In house ETL development and data warehousing application
• Modeled data between operational DB2 database and data warehouse Teradata tables as per business, technical and operational requirements.
• Participated and facilitated in business review session including feasibility, operation and business perspective of ETL.
• Designed in house ETL programs as per FORD ADS standards and practices and available resources for GCAMP Data ware housing application.
• Coded and tested in-house ETL (Extract, transform and loading) tool using DB2, DB2 stored Procedures, BMC unload, COBOL, JCL, VSAM, IMS (BMP), Xpeditor and Teradata, Change man for POC VIN FSA as part of ETL proof of concept.
• Facilitate better design of operational DB2 and Teradata tables as per best Data warehousing.
• Unit, system, integration, and regression testing of production VIN FSA data mart.

Environment: IMS DB/DC, COBOL, DB2, Stored procedures, JCL, VSAM, Xpeditor, Teradata, Change man, BMC unload, Windows NT, Packman, ETL, MVS TSO/ISPF, and IBM Mainframe

Confidential

Business System Analyst / Programmer Analyst

Responsibilities:

• Design, develop, test, data fix, enhance, maintain and document applications for Inventory Management Systems and International Stores Systems.
• Assigned to the ELMO Project team to expand the number of distribution centers allowed from 15 to an unlimited amount for over 10,000 applications.
• Modified existing programs and tables using CICS, IMS, COBOL, JCL, DB2, VSAM, and Xpeditor.
• Conducted unit, system, integration and regression testing of ELMO project to facilitate expansion of distribution centers.
• Upgraded applications in CICS, COBOL, JCL and VSAM to consolidate Hard-line and Soft-line items eliminating check digits in purchase orders.
• Performed advanced shipment interface analysis, design coding, testing installation and support using COBOL, JCL, VSAM, DB2 and IMS.
• This interface was designed to transmit data from domestic mainframe systems to international stores systems based on Oracle database system.
• Conducted ETL Proof of Concept effort to evaluate cost benefit analysis of buying an ETL tool vs. an in-house coding effort to convert AIM IMS database to DB2 tables.
• Coding for In-house Data warehouse application development.
• Performed an ITEM conversion analysis, design, coding, and data modeling to convert the AIM IMS database into DB2 tables using in house coding to support auto replenishment systems.
• Coding of DB2 stored procedure to retrieve item detailed information.
• Data mapping of Vendor supplied EDI/Gentran formatted ASN (Advanced shipment notification) to Confidential proprietary format facilitating conversion for international stores projects.
• Provided Teradata production support for Confidential systems.

Environment: EDI/Gentran, socket programming, CICS, IMS DB/DC, COBOL, DB2, Stored procedures, JCL, VSAM, Xpeditor, EDI, Teradata, MQseries, Windows NT, DFIT, Packman, ETL, MVS TSO/ISPF, and IBM Mainframe

Confidential

Programmer Analyst (Consultant)

Responsibilities:

• Designed, developed, tested, completed data fixes, enhanced, maintained and documented software projects.
• Debt suspension products dealing with Debt deferment and debt waiver for benefit cardholders, account level facilities for lost, stolen and converted accounts.
• Canada Cobra dealing with processing of Canadian account holders with United States account holders.
• Enhance and maintain securitization systems of Confidential and integrate with systems of locally bought banks and other financial institutions.

Environment: CICS, COBOL, DB2, JCL, VSAM, Windows NT, MVS, TSO/ISPF and IBM Mainframe

Confidential

Business System Analyst / Programmer Analyst (Consultant)

Responsibilities:

• Provided online screen support for account processing using PowerBuilder and CICS screens to analyze the account and DB2 tools such as QMF, SPUFI, and Stored Procedures to analyze the account in the customer database system.
• Corrected financial reporting such as retro, bill, and annual balance utilizing Excel spreadsheets.
• Performed ad-hoc data fixes utilizing QMF, SPUFI, and Stored Procedures.
• Uploaded data to DB2 mainframe.

Environment: COBOL, DB2, JCL, VSAM, CICS, QMF, SPUFI, Stored Procedures, Windows NT, Change man, MVS, TSO/ISPF, PowerBuilder, and Excel