SUMMARY:

• IT Sr. Business Systems Analyst with 12+ years of industry experience and expertise in “Requirements Gathering & Elicitation, Requirements Management and Development, Process Modeling, Process Improvement, System Testing, Change Management and Customer Relationship Management with core target on delivery for Solution conceptualization & delivery, Benefits realization, Project Management with IT Service, Support & Services” handled multiple roles such as “Implementation Lead, Testing Lead, Change Coordinator”.
• Exposure to Medical and Graduate Admissions platforms, hands - on to the ERPs Banner, STARS (Student, Tuition, Admissions, and Records System) system which MCW used for Medical School Applicant Admissions. Exposure to modules Admissions, Registrar, Financial Aid, Tuition, Educational Services.
• Strong exposure to Vendor selection process includes the RFP Creation, RFP Response Analysis, Demo Scripts preparation, Score Card Management, Vendor Recommendation document creation etc.
• Expertise on the Retail Domain and exposure to the applications PMM (Portfolio Merchandise Management) and PEF (Product Entry Forms) for Product Creation, Product Approval, Marketing Data Manipulation and Approval. Exposure to Team Foundation Server (TFS) and .NET projects
• Expertise in Manufacturing domain ERP's; IFS Applications 7.5, 2003 & SAP on modules Order Management, Invoice Management, HR Management, Project Management, Supply Chain Management, Document Management, Report Management (Crystal Reports and Quick Reports) and Security/Roles Management.
• Experience in creating and maintaining Business documents writing skills: Business requirements document (BRD), User Stories, Use Case Specifications, Functional Specifications (FSD), Systems Design/ Requirements Specification (SDS/SRS), Data Flow Diagram (DFD), Diagrams as UML, Activity and Sequence
• Lead Scope Finalization, architecture design, develop and maintain test strategies (Black /White-Box Testing, User Acceptance Testing (UAT)), plans and scripts, delivery of IT solutions to the business on time, within budget and to agreed quality standards for different Business domain as Insurance Systems and ERP Systems .
• Strong experience with different SDLC methodologies, i.e. Agile and Waterfall, maintaining Test Matrix, Traceability Matrix and perform GAP analysis including identifying various test scenarios and training of end-users.
• Expertise in Health Insurance/Healthcare domain as a Business Analyst and Test Lead for Confidential . Experience in Banking and Retail domains on multiple projects.
• Strong Experience on data Conversion & Migration, mapping, work flow and design. Also mapping legacy data into interface file, develop business rules, value maps, clean legacy data, and perform manual and automated data audits.
• Analysis & Implementation experience on IFS Application and highly skilled in Facilitating and managing meeting sessions taking SME’S from various business & operation areas.
• Managerial and Leading skills with concentration to service accomplishment and ensure system/application management and maintain SLA .
• Well versed in writing SQL query for Validation & creating Data mapping, logical data modeling, class diagrams, ER diagrams and used SQL queries to filter data within database.
• Through with practical experiences of Business Analysis with several project deliveries with guidelines of IIBA ( BABOK based ). Extensive Project Management skill with Business Analysis experience of large projects and service delivery.
• Implementation, Service, Support & Maintenance with various domains with through Knowledge on IFS, SAP. Hands on Expertise in Document Management in Enterprise level (ERP: IFS) using SharePoint .
• Microsoft Excel: Expert (Formula on Financials, Logical, Mathematical, Look up & References, Array, Pivot tables, Charts & Graphs etc.). Knowledge on Infrastructure Management: concentration on Data Center and Help desk team management. Implementation, Service, Support & Maintenance on Web based applications (Training Server, Perception).
• Excellent communication, analytical, interpersonal and presentation skills.

TECHNICAL SKILLS:

Languages: COBOL, C, C++, C#, .NET, Coldfusion

DBMS/RDBMS: Oracle 11g, SQL Server Enterprise, Teradata SQL Assistant, SQL Developer

Front End/Web Tools: MS Visual Studio and Cold fusion

ERP and Fin Package: Banner, EASI, STARS, IFS, SAP, Simply Accounting and Tally.

Reporting package: Crystal report, Quick Reports

Project Management: Ms Project, MS Visio, Lotus Notes, Crystal Reports.

Process & Methodologies: SDLC, Waterfall, Agile and Test, QC & defect Mgt.

Testing tools used: File Aid, HPQC

Application Support: BMC Remedy, HP Service Manager, Service Desk

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

ERP Business Analyst

Responsibilities:

• Work closely with the Admission Directors in different campuses (Milwaukee, Green Bay and Central Wisconsin) to elicit requirements for the redesign and retrofit for STARS (Student, Tuition, Admissions, and Records System) system which MCW used for Medical School Applicant Admissions.
• As part of the Admissions 2017 project, MCW wanted to replace the Secondary Application, Screening Portal and ASIS (Scheduling System) where the medical applicants submit their application to MCW which was a third party application and was not cost effective. Involved in the MCW Secondary Application project from scratch includes Eliciting the Requirements, sign off for the Functional Design Document, Design the Forms, Integration Testing, UAT etc. Working on the Banner implementation project for Grad and Med school.
• Involved in Banner Implementation project for Confidential aiming for 2019
• Working on the Vendor selection process for Grad and Med school which includes RFP submission, RFP Analysis, writing Demo Scripts, Generating the Score Cards, preparing the recommendation Document etc.
• Exposure to Business documents writing such as Business requirements document (BRD), User Stories, Use Case Specifications, Functional Specifications (FSD), Systems Design/ Requirements Specification (SDS/SRS), Data Flow Diagram (DFD)
• As part of the Admissions 2017 project, MCW wanted to modify the STARS screens to accommodate the new campus addition and the Secondary Application changes. There are many correspondence letters and reports which are sending out of STARS depends up on campus and worked on the specs for correspondence letters and reports changes for all the campuses.
• As a part of Admissions 2017 project, MCW is replacing the third party screening portal and building a new in-house Screening Portal to screen the medical school applicants. Involved in this project from scratch from Requirement Gathering & Design.
• Exposure to creating the Test Cases for STARS Retrofit and for the different systems (Secondary Application, Screening Portal, ASIS Scheduling System etc.) which are connected to STARS.
• Used SharePoint for the project documentation which includes BRD’s, FDD’s, UAT’s, Meeting Agendas and Notes, Process and Procedures, Project Management, Status Reports and maintaining the Master List.
• Used SQL Server 2012 for writing queries and data analysis as a part of Admissions 2017 project.

Environment: Banner, EASI, STARS, MS SharePoint, MS Office 365, SQL Server, HP Service Manager, Microsoft Visio, Microsoft Project, Citrix etc.

Confidential,Grand Rapids, MI

Business Relations Analyst

Responsibilities:

• Work closely with Business Units, Marketing, Measurement and Product teams to answer strategically important business and product questions. The team identifies and solves important and complex problems utilizing data analysis and modeling skills
• Exposure to PMM, PEF Applications and coordinating the system changes with Micro strategy and BI Query teams
• Working on the PEF Enhancements requirement gathering for both Vendor and MPP ( Confidential Product Portal) to add a list of features/functions to the Product Entry Form.
• Worked on a project called “Label Insight Proposal for Confidential ” to have a searchable database with specific product information, including nutrition information, ingredients, and key product attributes.
• Working on the Knowledge Management portal to document the product creation approval process for Confidential .
• Part of the project GDSN (Global Data Sync Network) Major Release 3 is an update to GDSN standard which Confidential uses for standardized information exchange.
• Exposure to Business documents writing such as Business requirements document (BRD), User Stories, Use Case Specifications, Functional Specifications (FSD), Systems Design/ Requirements Specification (SDS/SRS), Data Flow Diagram (DFD), Diagrams as UML, Activity and Sequence
• Involved in reviewing the QA documents such as Test Approach Document, Test Case Document and Test Scenario Document. Also part of Design review for Development team.
• Develops plans to estimate and track work efforts and resources required to complete required business analysis tasks.
• Developing business relationships and integrating activities with other IT departments to ensure successful implementation and support of project efforts
• Manages the overall business requirements process and deliverables with a focus on consistency, quality and alignment to industry best practices.
• Use BMC Remedy to track on the Incident Management and Change Management
• Leads assigned business analysts to manage their workload, track their progress and ensure they have the support they need to be successful in completing their assignments.
• Confirms that results meet stated business requirements and keeps stakeholders up to date on work status and project progress.
• Provides support to overall project management as well as design, development, testing and deployment efforts.
• Partners with other members of project teams to establish clear roles and responsibilities across disciplines.
• Serves as a mentor and coach to members of the Business Analyst team and participates in peer reviews of requirements deliverables.

Confidential,Milwaukee,WI

IT-Business Systems Analyst

Responsibilities:

• Lead the Rockwell Projects “ IFS to IIQ integration ” using Agile Software Development Methodology on IFS user provisioning module and “ IEE upgrade for IFS ” which is an upgrade from Centura IFS.
• Worked on the financial area of ERP system, concentration with Supply Chain Management, GL, AP, Manufacturing SSB Project, Purchase and Invoicing .
• Involved in Elicit stakeholder needs, Preparing BRD based on requirements for implementing whole system, develop business case and define business requirements & solution scope (features).
• Worked on the tool Docman for the Knowledge Management solution for business partners include requirements gathering, defining scope of knowledge base, facilitating working sessions to build understanding of the intent of the KM project with business partners
• Knowledge management efforts typically focus on organizational objectives such as improved performance, competitive advantage, innovation, the sharing of lessons learned, integration and continuous improvement of the organization. KM efforts overlap with organizational learning and may be distinguished from that by a greater focus on the management of knowledge as a strategic asset and a focus on encouraging the sharing of knowledge
• Liaising with stakeholders to understand issues and gather data for current business process, Functional modeling of business scenarios through UML use cases
• Monitor project delivery, Assess and validate solution, Define transition requirements, Engage stakeholders, Preparing Business Case and test case for UAT, Reports requirements, Process Optimization
• Used HP Service Manager to track on the Incident Management and Change Management
• Participated in User Acceptance Test (UAT) and Implementation, Preparing Unit Test Cases and User Test Cases and performing Integration/Systems Testing and Business Process Modeling and simulation of process flows.
• Confidential complex Project Management at system side as Key team member resource.
• Guide and train up End User, Tier 1 and Tier 2 team members.
• Worked as a Certified Change Coordinator/Prod Move Coordinator in Confidential for multiple projects

Environment: IFS7.5 & 2003, SAP, MS SharePoint, MS Office 365, Oracle 11g, HP Service Manager, HP QC-ALM, Microsoft Visio, Microsoft Project, Cyber Ark & Citrix etc.

Confidential, Bloomington,IL

Business Analyst/Test Lead

• Worked on HIPAA-EDI (Health Insurance Portability and Accountability Act / Electronic Data Interchange) Project involved the validation and testing of the various HIPAA transactions in HL7/EDI X12 formats in order to simplify the way business was conducted with group customers and members. Utilized Facets software to store, send and receive enrollment, billing and health care claims according to HIPAA 4010
• Gathered requirements and analyzed them to convert into functional and non-functional requirements.
• Conducted meetings/interviews with stakeholders to collect business requirements, analyzed the root cause of the problems and developed use cases using MS Visio.
• Interacted with the SME’s to gather information about the health care provider enrolment, billing and health care claims processing and checked if they are processed correctly or not.
• Prepared storyboards and business Workflow/flow charts processes and models that cover "How" business process models are prepared.
• Responsible for defining and documenting System Requirement Specifications/feature requirements and supplementary requirements, creating requirements traceability matrix (RTM).
• Experience working on Medicare, Medicaid insurance, HIPAA 4010 and health care regulations. Tested the system and applications for compliance with the HIPAA, HL7 and EDI X12. Experience working on EDI X12 transactions such as 837, 270, 271, 276 and 835, Familiar with ICD 9 codes.
• Experience working on Microsoft SharePoint server for content management applications
• Worked with Facets software for maintaining data about the enrollment, billing and health care claims management and to store, send, receive HIPPA transactions and facilitate the administration of HIPAA privacy rights.
• Worked closely with the ETL data warehouse and BI teams while developing data marts, data models and while reporting and data mapping & validation and wrote SQL queries, prepared dashboards and performed data analysis.
• Used Service Desk to track on the Incident Management and Change Management
• Interacted with the QA team to develop test plans & test the test cases. Involved in Requirement Analysis, Writing scripts for Automating the test cases for Health Claims
• Testing bug fixes/Enhancements using production data in Abend-AID/File-AID/Xpediter and logging the bugs into State farms in house bug tracking tool
• Knowledge transition to the offshore team on details about the system and participate in deliverable reviews and presenting Weekly status reporting to client manager.

Confidential,Downers Grove,IL

Business Analyst/SME/Test Lead

Responsibilities:

• Managed requirements from system users and preparation of business requirement documents which provided appropriate scope of work for technical team to develop prototype and overall system.
• Created UML based diagrams using MS-Visio for Use Cases and Activity Diagrams, for better understanding of the layout of the new process.
• Gathered the functional and business requirements by conducting JAD sessions and participatory Design Sessions involving major leads from the Technical Department.
• Adopted process based on agile methodology; Partnered with Directors of business organization to identify gaps leading to IT infrastructure improvements.
• Extensive use of Excel, PowerPoint, Visio, and other MS Office products was required.
• Gathered requirements and participated in database design and development as well as report design and development, testing plan co-development and quality assurance.
• Optimize advertising campaigns to increase clicks and ROI for customers by editing campaign elements such as ad copy, keywords and geographic targeting.
• Extracted data from SQL server into temporary tables in order to cleanup and standardize column entries for re-import into new SQL data structures. Used extensive SQL to create/modify/delete data.
• Participated in conference calls Net Meeting and Daily Stand up Meetings with offshore and onshore team.
• Prepared custom reports and performed SQL query, data analysis and verification.
• Created UAT test scenarios and test cases and coordinated UAT.

Environment: MS Project, UML, SQL server, MS Word, MS PowerPoint, MS Excel, XML, SharePoint, Rational Requisite Pro.

Confidential

Business Analyst

• Interacted with clients to write business objectives into detail business requirements and ensuring that the requirements documented and what was developed was what was requested.
• Participated in requirements gathering from business users and developed BRD’s, FRD’s, conceptual design documents and ensured that client’s requests were delivered as accurately.
• Responsible for analyzing and resolving issues affecting the processes and systems in regards to Collective Billing across all Retail businesses.
• Coordinate with representatives of Sales, IT, Operations and other teams whose processes either impact Collective Billing or are impacted by Collective Billing.
• Regularly engage business processes, conduct analysis, define; plan, track, and complete project tasks while making recommendations for system and process improvements .
• Skills and knowledge to effectively address and resolve issues across multiple functional groups including but not limited to Information Technology, Back Office Operations (including invoicing, service initiation, remittance processing ), Consumer Operations, and Sales.
• Created training programs that helped others understand how to handle tickets and resolve them properly using WBT Awareness courses.
• Responsible for updating project status using MS Project and maintaining the Dashboard

Environment: M.S Excel, Word, SQL Server, M.S Project, PowerPoint, Microsoft Enterprise Library and Application Blocks, Visual Studio, Microsoft Access, Adobe Acrobat.

Confidential

Software Engineer/SME

• Understanding the requirement specifications and coding
• Identifying use case scenarios of the module under development or enhancement
• Defect fixing and implementing enhancements
• Writing unit test cases for the modules
• Functional testing of iterative builds for the developed modules
• Logging defects and tracking them through defect tracking tool