SUMMARY:

• Dynamic and accomplished IT professional having 11+ total years of experience in IT Sector. This includes 5.5+ years as Sr. IT Business Analyst/Project Manager in O&G, Retail/Telecom, Insurance and Pharmaceutical Domains. 5+ years in design, development, maintenance & QA Testing Projects in Manufacturing, Banking & Insurance domains in IBM Mainframe environments.
• Excellent and verbal and writing skills, especially with regards to presenting findings to both technical and non - technical audiences.
• Have worked with key business partners to write and execute user stories to drive Large Scrum Projects using Agile Sprint and Epic planning. Implemented and monitored all the phases of SDLC.
• Experienced with core IT processes such as Service Request Management(ITSM), Asset Management(ITAM), Incident Management, Problem Management and Change Management(Kurt Lewin & Confidential ).
• Incorporated ITIL concepts for ITSM that focuses on aligning IT services with the needs of business.
• Acquired broad knowledge of Business needs & served as liaison between IT and Line of Business.
• Demonstrated strong work ethic, which is vital to the project as well as company achieving its goals.
• Responsible for soliciting and gathering functional and nonfunctional requirements, business vision documentation, context diagramming, stakeholder identification, process and data flows, use cases, user testing planning, and user test execution and analysis approach as related to Project.
• Exhibited financial expertise, leadership, analytical thinking, communication abilities, and proactivity. Performed QA functions like UAT, System/Integration Testing, Impact analysis, Risk analysis and Gap Analysis.
• Resolved questions/issues/conflicts with business requirements between business unit and IT.
• Managed changes to any business requirements and facilitated sign offs and approval as Product Owner
• Successfully created User Stories, user acceptance criteria, process flows, Use Cases, test plan, test design spec. & Translated URs to create testing scenarios, test data, test cases & test execution
• Concepts of ITIL - Service Strategy, Service Design, Transition, Operation, Continual Service Improvement
• Certifications Obtained: IBM Certified Database Associate: DB2 UDB V8.1 Family Fundamentals.

SKILLS:

Product & Project Management ERP ITIL ITSM ITAM Service Catalog Portfolio Management SDLC Product Backlog Agile (Sprint & Scrum), Kanban & Waterfall Methodologies Budget & Schedule Management Change Management (Kurt Lewin & Confidential ) Data Analysis ETL Metrics Solutions Design & Estimation Mobile Perspective API Data Management & BI Data Visualization & modeling Cloud Computing Web Service Dashboard customer websites Order, sales & customer websites CRM Salesforce CaaS SaaS Defect Prevention & Tracking ServiceNow JIRA Service Desk e - commerce - supply chain, inventory management, internet marketing

TECHNICAL SKILLS:

Technology Area/Domain: Product Suite

IBM Mainframe: TSO/ ISPF, COBOL, JCL, SQL, Xpediter, Endevor, File-Aid, CA-7

Operating Systems: MVS, Z/OS, OS/390, Windows NT/XP/7/10.

Database: SQL, DB2, ORACLE, IMS, VSAM, Salesforce DB

Tools: /Software: JIRA, MS SharePoint, MS Visio, MS Project, Rally, ServiceNow, JIRA Service Desk, MS Office, SOAP UI, Tableau

WORK EXPERIENCE:

Confidential, Houston, TX

Sr IT Business Analyst / Project Manager

Responsibilities:

• As BA, conducted requirements sessions with global stakeholders, built As-Is and To-Be work flow analysis, surveys, use cases and scenarios, maintain product backlog, product management, exhibited Agile Sprint planning and tracking it with JIRA.
• Managing Scrum teams working on web based application for data standardization and data normalization.
• Worked as Product Manager to check product backlog, cross-project information, resourcing requests and release scheduling, Agile Sprint planning, Kanban and Scrum activities tracking,
• Wrote SQL queries to verify data. And used Excel and Tableau and for data visualisation.
• Facilitated and actively participated in all the Scrum activities: Release Planning, Sprint Planning, Scrum of Scrums and Daily Scrums. Communicated (verbal and written) with business, development, and senior management on progress of Release Period project goals, objectives, and testing efforts.
• Gap Analysis that involves the comparison of actual performance with potential or desired performance.
• Contributed to the team's progress by taking up some SOAP UI Testing and manual testing. Wrote test cases and helped QA leads with test plans. Also wrote UAT scripts and worked with business stakeholders to run the scripts and got sign off for acceptance.
• As a Project Manager implemented ITAM using Insight on JIRA Service Desk earlier Service Now to manage on-boarding of employees, financial information, marketing & legal assets and metrics for schedule cost and profitability. As BA, displayed to Customers the Services & Products in Service Catalog style.
• Successfully implemented ITSM using JIRA Service Desk for service request ticket tracking, workflows, data schemas, screens, SLAs, and reports while giving end-to-end visibility to IT management.
• Experience with CRM processes like Sales, Marketing, Customer Service & Support and business processes.
• Strong knowledge database and data manipulation skills using SQL. Worked in SQL Server and Salesforce DB.
• Applied Change management using Kurt Lewin process as needed to fulfil requirements for the end user.
• Devised and prioritized the Product Backlog by conducting requirement churning sessions with various Business / Product Teams. Facilitated and participated in risk and issue identification, impact analysis, risk analysis.
• Strong research and analysis skills, able to define technical product requirements to solve complex business and operational problems
• Significant understanding of data warehousing, Informatica & Oracle techniques and their impact on reporting and analytical solutions .

Confidential, Hartford, CT

Sr.IT Business Analyst / Project Manager

Responsibilities:

• Worked as Project Manager Confidential o provide cross-project information, resourcing requests and release scheduling.
• Facilitated and participated in risk and issue identification, impact analysis..
• Interpreted the needs for the end customer in order to ensure the discount code was easy to use when received through Direct mail or Email
• Worked closely with other business analysts to provide technical guidance, conducted workshops with the business users designing, configuring, and testing to provide post implementation support.
• Involved in Iterations/Sprint planning and assigned owners for each task in Iterations.
• Applied Change management process using Confidential & Lewin model as needed to fulfil requirements for the end user.
• Effectively managed/communicated project changes, as delivered per Change Control Board.
• Participated in cross-functional teams between developers and financial analysts to gather requirements and provide data analysis within the user story, feature, epic, sprint and Scrum using Rally ALM.
• Created User Stories, planned, scheduled and added Backlogs for the prioritisation process.
• Reviewed and approved final Business Requirements, High Level Project Test Strategy, Design, Detailed Design, Requirement Traceability Matrix(RTM), Application Test Plan and Release Plan.
• Designed, created and maintained reports that are clear, concise, and representative of the intent owner needs and objectives using query, reporting, and visualisation tools like Excel and Tableau.
• Identifying the test data for the test cases & worked on writing the complex SQL queries using Flow Control, bulk INSERT, and CREATE, DELETE and UPDATE statements. Data visualisation analysis using Excel and JavaScript.
• Contributed to the team's progress by taking up some SOAP UI Testing and manual testing. Wrote test cases and helped QA leads with test plans.

Environment: SQL, PowerPoint, MS Visio, SharePoint, MS Office, Rally ALM, SOAP UI.

Confidential, Hartford, CT

IT Business Analyst

Responsibilities:

• Participated in using the Agile Methodologies on projects utilising full Systems Development Life Cycle (SDLC), while using MS SharePoint for storing project documents.Build logic to send email/mail notifications
• Conduct workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements about the online money transfer experience.
• Conducted requirement gathering sessions with the purpose of creating User Stories, Epics, and Features created for the various releases throughout the year.
• Quick ability to identify, research, investigates, analyse, define and document business processes.
• Responsible for identifying and documenting business rules and creating detailed Use Stories.
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications. Act as a resource in understanding how IT systems carry out business functions and assist in ensuring the timely and effective implementation of projects.
• Designed and developed Use Stories, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using MS Visio.
• Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Develop the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Assist in development of training materials for new technology and process improvements.
• Interact with team to review and develop and review data exchange or data sharing models.
• Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.

Environment: MVS, OS-390, MS Project, SQL, PowerPoint, MS Visio, SharePoint, MS Office, COBOL, JCL, DB2, Endevor, File-Aid, xpediter, CA-7.

Confidential, Groton, CT

IT Business Analyst

Responsibilities:

• Responsible for implementing change requests and enhancements.
• Interacted with business to understand business needs. Analyse user requirements and help Business Analysts create the Functional and technical Requirement Specifications. Developed technical solution blueprint and review with client.
• Business analyst for enterprise wide remediation program consisting of Application Vulnerability, Server archiving, Audit management and Data Loss Prevention projects
• Created user stories and use case for data and visualisation requirements.
• Worked successfully toward Traceability matrix, mapped SOP to business requirement, business requirement to user requirement, user requirement to Use cases for solution which did not had business requirement and functional requirement.
• Solves critical Business Functional, Investigational data issue raised by the clients in data access program and implement solution to generate visualisation
• Created business flow for Inspection Management requirement with key business stakeholders using Visio.
• Perform impact analysis, configuration design and development of business flow change request. Understand changes to business functionality and developing BRD, FSD, Traceability Matrix, Test Plan UAT and Training Material.
• Maintain the compliant state of the health care applications by following approved Standard Operating Procedures (SOP) and SDLC process.
• Work with third party vendor for business functional and technical solution and successfully negotiated service and cost model.
• Analyse reported defects and fix dashboard/visualisation related issues using ServiceNow
• Provide support to team members in understanding and working on the critical business processes and value stream modelling.
• Interacted with Onshore and Offshore team in terms of getting business needs passed on, getting business requirement validated and ensure that Application is up to the mark by following Quality standards.

Environment: Microsoft Office Suite, Remedy, MS Visio, MS Project, Quality center, SharePoint, ServiceNow.

Confidential

Senior Software Engineer

Responsibilities:

• Build logic to send email/mail notifications
• Prod bug debugging and permanent fix implementations.
• Testing and execution of JCL’s and COBOL programs.
• Meet with architects and tech leads to brief on the business requirement and convert it into tech requirements.
• Design and implementation of minor Enhancements /workarounds to the user problems when needed.
• Conducted Database testing-Vendor Coordination-Documents Validation-Conducted Integration Testing and System testing
• Created Tech Specs, Unit test plan & results documents. .
• Coordinating with onshore team for the coding and test cycle runs.
• Confidential (Unit Linked Strategic Operations) is a Project which deals with Unit Linked Policies. Confidential comes under an area called UKFS. ULIP Policies are mainly dealing with Pension Policies.
• The Main 3 Systems associated with Confidential are 1) PRE (Pricing Rule Engine) 2) TP (Transaction Processing) and 3) Pipeline/MI (Pipeline/Management Information).
• New Business can come through Agents, Brokers and Online and if it is a Unit Linked Policy then Confidential will be processing those Policies depending on the amount, Type of Policy and the Type of Fund we need to go for. (Types of Funds Include Funds Specific to SL and Funds Not Specific to SL). Customer can pay money through Debit, Credit Card and Cheques.
• Initially the transaction will be in Pending Status and In case of forward pricing the allocation date will be two days after the Effective date and once the funds get allocated then the status will change from ‘Pending to Active’.
• Cheques can be suspended for a maximum of 15 days. If it’s not encashed within this timeframe then the transaction will be kept in reversal status for another 15 days. And after 15 days if the status remains same, then everything will clean out and will delete the entries from all the db2 tables.
• Support for New test environment.
• Converted Jobs, Procs and Control cards for Separate Test environment.
• Involved in DPG and SMR activities.
• Used AGILE methodology.
• Attended daily SCRUM meetings.
• Extensively worked on Iterations.

Environment: MVS, OS-390, CA-7, Abend Aid, File-Aid, DB2, Oracle, Endevor, Xpediter, COBOL, JCL, CICS, VSAM, DB2, Easytrieve.

Confidential

Senior Software Engineer

Responsibilities:

• Provided 24/7 support and handled client queries for various Inventory, Product Data Management and Planning applications.
• Inventory application maintains the inventory for the materials. Planning application forecast the Inventory, Which need to be manufactured in next week.
• Build logic to send email/mail notifications Responsible and Coordinated with Performance Testing (Stress/Load tests),Security testing and Accessibility Testing.
• The support involved development and maintenance of Inventory applications and enhancement of applications.
• Prod bug debugging and permanent fix implementations.
• Testing and execution of JCL’s and COBOL programs. Writing new JCL. Extensively working on ETL concepts in IMS and VSAM DB.
• Meet with architects and tech leads to brief on the business requirement and convert it into tech requirements.
• Design and implementation of minor Enhancements /workarounds to the user problems when needed.
• Analysis, Coding, Testing, Review, Release and implementation activities for work Requests based on Waterfall Model.
• Handling User requests and Queries
• Jobs Monitoring and fixing within the SLA if any ABEND occurs.
• Worked in Planning and Inventory domain areas.
• The main objective of another internal project PDM- Enhancement in EDAC application is to retire the IMS BOMBASE DB partially from EDAC (Engineering Data Access Control) application system.
• The EDAC system has all product and product line information of the manufacturing goods. This is a core system which has interface with different external systems.
• SME for the Inventory application EDAC.
• Was the DP coordinator, involved in monthly DP meetings with QA’s.
• Written different JCL and involved in major code changed during project: Bombase retirement.
• Has handled multilevel implementation and job monitoring during the 18 months project.
• Being a full-time employee, was able to coordinate with contractors and onsite teams.
• Had direct interaction with Clients and other teams across the globe.

Environment: MVS, OS-390, CA-7, File-Aid, Abend Aid, DB2, Oracle, Abend Aid, DB2, Endevor, Xpediter, COBOL, JCL, VSAM, DB2, Easytrieve, IMS DB/DC, PL/SQL

Confidential

Assistant System Engineer

Responsibilities:

• Design and implementation of minor Enhancements /workarounds to the user problems when needed.
• Analysis, Coding, Testing, Review, Release and implementation activities for work Requests based on Waterfall model.
• Handling User requests and Queries. Jobs Monitoring and fixing within the SLA if any ABEND occurs.
• Production Support and Maintenance for Express Payment which is a consumer product, an economical bill payment service that allows consumers to pay their auto, mortgage, credit card and other bills faster.
• Express Payment is currently available Confidential Confidential agents within the United States and via the Internet.
• Middleware / Point of Sale (POS) applications involve Websphere, Informatica support and Country Currency Conversion.
• Express Payment and the other above said application systems have specific users with whom interaction is desired to identify with their requirement and deliver a quality product.
• These specific users login their requirement in form of Information Technology Request (ITR) and Account Help Desk (AHD).
• Money Order is a form of payment that can be used by its purchaser to pay bills or other financial obligations or to purchase goods or services worldwide.
• Adding agents and creating new JCL and coding in the base COBOL program the logic as per the tech spec.
• Complete understanding of the business logic in source (programs) and complex architecture is required to provide 24X7 services for quick turnaround.
• Impact Analysis of the programs related to ITR/AHD
• Coordination with onsite team and Identifying the components and outline the changes to be done
• Development of Cobol, Easytrieve programs as per the ITR. Implementation of test cases and documenting it.
• Packing the components and raising an Infra. Monitoring the job during implementation.

Environment: MVS, OS-390, CA-7, File-Aid, SQL, Oracle, Endevor, Xpediter, COBOL, JCL, CICS, VSAM, DB2, Easytrieve, PL/SQL.

Confidential

Programmer Analyst

Responsibilities:

• Was in payroll department to ensure that all systems are functioning properly and that payroll is properly distributed to all employees in a timely manner.
• Managed payroll financial and accounting processes for the organisation so that payroll and benefit reporting activities are accurate, timely, funded properly, cost-effective, and business and employee sensitive.
• Very good experience in Installation, configuration and maintenance of SQL System.
• Experience in Data Modelling (Logical and Physical Design of Databases), Normalisation and building Referential Integrity Constraints.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Maintained financial accounting and controls associated with the payroll system and benefit plans in a multi-state environment.
• Coordinated accounting entries between the subsidiary companies and the payroll accounting system.
• Met immediate reliability, accuracy, and timeliness needs and expectations while simultaneously addressing longer-term process and policy needs.
• Accomplished results with a varied staff, utilising influence and persuasion rather than power and reporting relationships.
• Maintained fraud prevention and detection controls.
• Managed payroll conversion/integration for and newly joined resources.