Post Job Free
Sign in

Microsoft Office Project

Location:
Hyderabad, Telangana, India
Posted:
April 07, 2017

Contact this candidate

Resume:

Kirti A

+1-614-***-****

aczpf6@r.postjobfree.com

Professional Summary:

Dynamic Business Systems Analyst professional with 8 plus years of experience in Financial and Healthcare domain.

Good experience and knowledge in developing and evaluating Business process models and flows, Requirement elicitation, Data analysis and Data Mapping of Healthcare industries

Good Management, Execution and Documentation skills

Good knowledge in Automated Clearing House (ACH), Bank clearing system, Electronic Funds Transfer(EFT)

Articulate communicator with building rapport at all levels with internal and external associates.

Resourceful approach to problem solving, identifying and documenting root causes and corrective actions in documenting mitigation and contingency plans.

Proficient in ICD-9-CM and ICD -10-CM coding and claims processing.

Extensive knowledge of Medicaid, Medicare, Procedural and Diagnostic codes and Claims Process.

Effective in managing and executing multiple tasks and assignments ahead of schedule

Created Use Cases, work flows, screen shots and Power Point presentations.

Designed and implemented new requirements using ASP.Net, CSS, C# and Java script

Strong knowledge of software development life cycle (SDLC- feasibility requirement analysis, Design, construction, Testing, Implementation, Support) and Rational Unified process (RUP) and UML methodology.

Expertise in EDI and HIPAA Testing Privacy with multiple transactions exposure such as Inbound Claims 837-Institutional, 837-Professional, 837-Dental, 835-Claim Payment/Remittance Advise

Experienced in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Risk Analysis and mitigation plan, Cost benefit analysis and ROI analysis and Fit Gap analysis

Proficient in Rational tools including Rational Rose and Requisite Pro

Involved in development of business logic layer for various applications using various development tools (Java and .Net)

In depth knowledge of Agile, Scrum and XP methodology, risk engineering, MS Visio

Proficient in creating Business Cases, Business Requirements Document (BRD), Functional Requirements Specification (FRS), Change Requirements Document (CRD), User Stories, Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, Requirements Traceability Matrix (RTM), GAP Analysis, Cost Benefit Analysis.

Good understanding of Financial Statement Analysis, Capital Budgeting, Portfolio Analysis & Stock Valuation. Worked with boosting efficiencies and implementing optimized process flows throughout the SDLC phases.

Performed UAT and exposure to user certification testing (UCT) and Operational Readiness Testing (ORT)

Expertize in understanding and supporting the client with Project Management activities such as Project Planning, Project Definition, Requirement planning and management, Requirements Definition, Analysis, Design, Testing, System Documentation and user training also performed Business process Re-engineering when necessary within the project scope

Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close)

Experience in implementation of set up of Microsoft Office SharePoint 2007

Excellent skills in project and Performance Management to support Strategic Planning, Goal Setting, Strengthen Accountability, Enhance Decision Making and Improve Customer Service

A very good team player with excellent communication and written skills, Presentation and reporting skills

Software/Hardware:

C#.Net, VB.Net, AS 400, Goldmine, SQL, IDMS, QTP, MS Windows NT 4.0/2000, Windows 95/98, Windows XP, MS Visual Studio.Net, IBM WebSphere 5.0, Power Builder 5, 6.5, 7, Rational Rose, UML 2.0, RUP, OOAD, MS Visio and Visual Studio.Net, Sybase SQl Anywhere 5/6, Adaptive Server Anywhere, Crystal Reports, MSSQL 7, Oracle 6 / 7.x / 8i / 9i, Oracle – TOAD, Informatica, SharePoint, Business Object, ETL, Cognos, Erwin ODBC, Visual Source Safe 6.0, Cobol, Source Off-Site, Round-Table, Win CVS, NUnit.net, MS Project, MS-Office

Education:

Bachelors in Computer Science

Masters in Supply Chain Management

Professional Experience:

Cigna Healthcare, Bloomfield, CT August 2015 to Present

Senior Functional Business Analyst

This Project was based on Building Financial Foundation for Cigna’s three major Financial products and building an application to support its monthly, weekly and daily activities and reports. The main purpose being to localize reporting by establishing a single and comprehensive source of data for management reporting. Each product had its own Business users, Requirements, Release Cycles and Delivery Dates. TCS and Accenture partnered to Deliver this Application in a timely manner to its End Users.

Closely have interacted with the designers and software developers and client business partners to understand the application functionality, navigational flow as a proficient Business Functional Analyst in a Software Development Life Cycle Environment

Functioned as the primary liaison between the business line, operations, and the technical areas throughout the entire project life cycle.

Coordinated with the quality assurance analysts and system architects to deliver quality product at the end of each release cycle

Responsible for the development of requirements analysis and systems design documentation along with providing mock ups and prototypes and getting it reviewed with Business owners before passing to Development teams for development both on-site and offshore which helped to visually understand complex functionalities and business needs of end users

Worked on Business Process Re-Engineering and change management when there was a requirement change and also worked on enhancements within the application for various releases

Update the weekly tracker of the project plan and track changes or risks involved as per release dead line

Good understanding of ASP.net for business rules and validations on UI screen, DB level

Document and Design UI to help Development team know how Business Requirement gets translated into Application Functionality (System Requirements) and also turn them into technical requirements

Have documented Business requirements using Cigna’s defined templates and standards

Have designed various screens for a java based UI application and been part of an entire SDLC process

Performed requirements modeling and develop analysis diagrams also Modeled Use Case Diagrams, Activity Diagrams and Data Flow Diagrams using MS Visio

Involved in writing functional test cases and executed test scripts as part of Unit and Integrated application testing in various environments to minimize defects

Facilitated meeting and discussions with various teams of business users, Business analysts and technical analysts

Performed system requirement planning, Analysis and design to help and document structured requirements management with the help of prototypes using mock up tools like Axure RP

Worked with technical teams and business users to identify and problems and get appropriate workable solutions

Have interacted with stakeholders to identify the client business processes and gather requirements and business processes

Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data

Communicate with offshore teams to support application development activities

Created test cases and test plans for the User Acceptance Testing (UAT) using rational testing tools

Followed the UML methodology to create Business Process Diagrams including Use Cases Diagrams, Activity Diagram (Swim Lane Diagram) for AS-IS and TO-BE process also conducted fit gap analysis when needed and came up with solutions

Transformed Business Requirements into in detailed Functional Requirements for the purposes of preparing the Functional Requirement Document (FRD) which were highly complex in nature and coordinate the same to Technical team for development and QA team Bug tracking using HP ALM

Have conducted brain storming sessions and coordinated meetings for requirement gathering with end users and SME’s

Responsible to update weekly trackers to be on track to meet milestones

Discuss Daily updates with offshore teams to get updates on developed screens and do unit testing before each deployment to higher environments and then coordinate accordingly with QA’s and Testing teams to deliver Test Cases and Test Scripts

Experience in implementing Microsoft Office SharePoint and upload meeting minutes, Review, Track and update project plan/ status on weekly basis and FRS updates as and when appropriate in a very Agile Business Environment

Environment: Oracle Application Suite, Toad, SQL Server, MS Visio, Agile methodology, Rational Rose, Requisite Pro, Microsoft Office Suite (Word, Excel, Power Point, Visio) Axure RP 8

Webster Bank, New Britain, CT January 2015 to June 2015

NICE Actimize Business Analyst

This project was to implement NICE Actimize solution for ALM with two suites (Customer Due diligence) and SAM (Suspicious Activity Monitoring) The project was also based on the Credit Loss Severity initiative. This included various enhancements to the Risk Based Capital Model. The model would project Webster's Capital Position, by estimating the economic impacts to PPNR (Pre-Provision Net Revenue) and Stress Losses under the required hypothetical stressed scenarios. It included risk-based capital stress test, which is a cash flow stress test that determines the amount of total capital for Webster Mortgage that is sufficient to maintain positive capital during a defined stress period.

Responsibilities:

Facilitate requirements-gathering sessions both internally and with clients.

NICE Actimize system knowledge with strong knowledge on data acquisition, sourcing and integration

Experience with gathering business requirements and performing analysis also helped with designing and facilitating of biweekly project plan updates from the users

Been part of project management activities such as project planning, defining scope and Risk analysis

Experienced in Microsoft Office applications, including Word, Visio, Access, Excel

MS SQL database and query experience and HTML screen development

Utilized technical writing skills to create effective documentation and training materials.

Worked with the development team and executed QA test plans and test cases based on business requirements and functional specifications.

Gathered high level requirements from the business documented into business requirement documents and converted to technical and system requirements, created user stories, and prioritize the backlog with project manager

Generate system flow charts and design documents

Been part of documenting various Business requirement documents by the clients Business Standards and templates

Helped with Coordinating, supporting and implementing data acquisition related activities also develop current state business process models for account transitions from the current system to AML system

Developing and generating technical specifications as needed and Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Facilitated user story workshops. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specifications

Supported various Webster banking system support staff in data acquisition exercises for the NICE Actimize implementation

Uploading, maintaining and distributing documents on MS SharePoint 2013.

Conducted JAD/RAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.

Interfaced and supported a variety of constituents; including IT management, Business lines, Support groups and Vendors as and when needed

Environment: Tableau 8.x, Teradata, Oracle, SQL Server, MS Visio, Agile methodology, Rational Rose, Requisite Pro, Microsoft Office Suite ( Word, Excel, Power Point, Visio)

Wells Fargo, Charlotte, NC March 2013 – Nov 2014

Sr. Business Analyst

Working as a Business Data Analyst on the Wells Fargo Fraud Detection and Prevention Portfolio, I have worked on a suite of fraud related applications allowing users to get information about Online and Mobile Fraud. The portfolio also includes applications for 'Reporting Fraud'. The applications in this Portfolio allow Payment Fraud Detection via MasterCard Secure Code and verification via Visa Purchasing Protection Program. They also provide guidance on protection against Check Fraud, ACH Fraud, Impostor Fraud and Commercial Card Fraud.

Responsibilities:

Participated in an agile style atmosphere and participated in daily Scrum/Stand-Up meetings using Agile Scrum standards.

Meeting all quality Mortgage Banking and Bankruptcy workflow against compliance procedures for Wells Fargo and SEC.

Reviewing and developing data models and database designs with development teams, entity-relationship models are used with relational databases, normalizing, and de-normalizing, indexing, and defining views

Delivered requirements for integrating bank balance and transaction, previous day and current day information reporting for ACH, Wire, Memos, Return, Loans, Controlled Disbursements, Lockbox and Data exchange

Responsible for validating Loan Modifications and Amended Proof of Claims (APOC’s) and Proof of Claims (POC).

Review Deed of Trusts, exhibit A, notes, and any riders attached to Proof of Claims (POC’s) filed.

Excellent communication and presentation skills used to help achieve optimal success and help build better team cohesion.

Facilitate technical discussion with development and QA teams. Also identified technical and implementation risks.

Incorporated Automated Clearing House(ACH) functionality for the Private Label Credit Card for Cash Advance abilities

Gathered high-level requirements by conducting stakeholder meetings, interviews and discussions.

Created and maintained requirements traceability matrix (RTM) and established traceability across all SDLC phases

Worked with teams to finalize screens using AED (Adobo experience Design)

Good experience in RUP Business Modeling process. Involved in Six Sigma process analysis and improvement hence performed continuous research on ways to improve current business processes.

Participated in weekly project status meetings, published meeting minutes, updated risks/issues/action items.

Involved in testing with external 3rd party systems, while processing the ACH and credit card transactions by sending ACH and credit card details and vice versa

Assisted release project manager in coordinating with enterprise release coordination tasks on a bi-month major releases and monthly minor releases using Iterative and agile environments.

Performed process analysis, identified and eliminated process in-efficiencies and provided recommendations for process improvements (eliminated duplicate environment change request forms which were existed across several functional areas)

Involved with developing and documenting process flows for business processes through JAD sessions with stake holders, SME’s and management.

Ensured senior IT management & business users are correctly advised on release windows and testing requirements.

Reviewed the consolidated project changes of each release with internal review boards & technology review boards to make them understand what technology and business changes are getting implemented in the current release and discussed impacts.

Environment: UML, MS Office Suite, MS Visio, Agile Scrum,, MS TFS, DW, Ad-hoc reporting, SharePoint, MS Access

BNY Mellon, Austin, TX March 2011 – January 2013

Project Coordinator/Business Analyst

Worked on the enhancements for the Broker, Dealer & Hedge Funds Clearance & Settlement System and Asset Servicing System (Federal, DTC, Fund Systems) including products like MBS, Bonds and Treasury Funds.

Responsibilities:

Assisted Scrum Master in identifying tasks to be part of sprints and helped Business Analysts write the User Stories.

Delivered FRD, Use Cases, Wireframes (mock-ups) and Data Requirements based on the detailed requirements of the project and reviewed with business users, technical, data and QA teams.

Responsible for all the tasks that assigned to Business Analysts and delegate tasks between junior BAs.

Managed end to end solutions of each sprints.

Managed all the Sprint related defects and made sure it should resolve before the Sprint (Agile Approach).

Managed communication with the team at a detailed functional level, discussed/resolved issues and managed customer expectations.

Conducted JAD sessions with the stakeholders, end users and SME, to determine the critical business processes and identify key functional requirements for LoanServ system adhering to the Mortgage Servicing Industry practices and FDIC guidelines.

Analyzed, documented and managed end to end functional requirements, and obtain sign-off for functional requirements from necessary parties and managed end to end Functional/Data requirements for Security Master to add, view and modify securities such as MBS, Funds, Treasury, Corporate Bonds and helped Data teams to analyzed the data (Collecting and Storing) to download intraday and End of Day by using informatics tool.

Ability to display strong sense of urgency and work in a fast paced, dynamic, team oriented environment. Helped QA team to do SIT, Regression and UAT testing.

Supervised Pre and Post Release Issues.

Validated the various business processes with a committee of Subject Matter Experts (SME's) like Mortgage Services, Underwriters, Credit Analyst etc, to ensure the rules and guidelines have been met.

Conduct status meetings, created and distributed daily / weekly status reports to update the Manager on current / future work and issues found during Sprint.

Proactively identified issues with a project and ensured that issues are promptly resolved or escalated. Worked with Onshore & Offshore developers and testing teams.

Used Traceability Matrix to trace the requirements through each stage of the requirement gathering process, which takes into account any changes in scope during the life of the project.

Managed Sprint scope by ensuring that changes to scope are documented and approved with project change request forms. Ensured all sprints documents and appropriately archived following sprint completion.

Environment: MS Office 2010, Team Foundation Server 2010, SQL Server 2008, MS Visio, SharePoint 2010, .Net, Agile Scrum

Nebraska Medicaid– DHHS, Lincoln, NE May 2010 - February 2011

Business Analyst

This project is on implementing National Provider Identifier (NPI) compliance for NE-DHHS Medicaid Management Information Systems (MMIS) under HIPAA 5010 Project. I have worked on the Eligibility (270/271) and Enrollment (834) legacy system that is currently in place with mainframe systems for the backend. Analysis is done on identifying impacted systems, reports, interfaces, screens and policies due to NPI crosswalk implementation.

Responsibilities:

Prepared various documents such as Business Requirement Documents (BRD), General System design (GSD) and Impact documents.

Performed Requirements Gathering and Analysis through interactions, meetings and periodic walkthroughs with potential users of the application along with the creation of Use Case Scenarios based on business requirements.

Worked on Curam Software V6.0 to implement eligibility system for IBM Healthcare Reform Case Management

Worked on Curam platform for customize and upgrade SACWIS Statewide Automated Child Welfare Information Systems

Provides second review of claims when providers and members question the appropriateness of payment

Modeled Use Case Diagrams, Activity Diagrams and Data Flow Diagrams using MS Visio.

Experience in Business process analysis and mapping with Curam Application Suite

Provided client with different types of solutions on curam platform (Cash Assistance, Food Assistance, Curam Child Service, Adult/Child Care)

Facilitated meeting discussions between business users, business analysts and technical analysts.

Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational

Involved in HIPAA EDI transactions such as 834, 835, 837 (P, D, I) 270, 271, 278.

Worked within the areas of process improvement and enhancements of Billing/ Payment systems for Medicare Part D functional area.

Executed total claim audit to validate accuracy of configuration, provider payments, and claims processing.

Defined Functional Test Cases, documented, Executed test script in Facets system

Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall

Analyzed various inbound and outbound interfaces to determine the impact of HIPAA 5010 and NPI implementation.

Responsible for requirements gathering, identifying data set and data analysis of data for dashboards and reports utilizing software for its end users.

Worked with Claims, enrollment, eligibility verification for members and providers, benefits setup, and backend payment cycle in Facets.

Gathered, defined and documented highly complex business requirements.

Developed workflows that demonstrate current and proposed business requirements.

Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile

Consolidated the analysis of multiple business lines after the COTS evaluation.

Produced Gap Analysis documents for HIPAA 5010 and ICD-10

Identified and documented benefit code sets, along with troubleshooting and resolving errors in claims.

Designed High level design, for New process, integrating with legacy and Facets

Prioritized the individual word load that involves multiple project assignments and deadlines.

Created and executed test cases, test scripts, data sets and user procedures.

Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages

Ensured testing results correspond to business users’ expectations.

Well versed with HIPAA, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing alternative solutions using best practice model and principles.

Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA

Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.

Gained experience on Quality Center, Microsoft Outlook, Lotus Notes, Microsoft Word, Microsoft Excel, Microsoft SharePoint, Microsoft Visio, Microsoft Access and Clarity.

Worked with HIPAA rules and regulations to draft business rules and claim processes

Environment: Quality Center, Rational Rose, Rational Requisite Pro, Curam, Windows XP, Informatica, DB2, MS-Project, MS-Office Suite, MS Visio, MS Visual

Northern Trust Corporation, Chicago, IL August 2009 – April 2010

Business Analyst (Process Improvement)

The Alternative Asset servicing department (AAS) is responsible for supporting a group of defined assets that are generally not exchange traded. AAS processes cash movements, corporate actions and accounting entries, updates fund valuations, collects and reconciles against fund statements, audits client reporting and responds to queries from clients, internal partners and fund companies. Additionally, in some cases AAS executes trades.

Responsibilities:

The scope of the project is to address the gaps and issues with the current Transitions (client onboarding), transaction (Capital calls, stock distribution, Cash distribution) processes, valuations/PLT process and Audit/ Reconciliation process.

Understood the process of New Client onboarding, account set up, transaction processing, valuations and statement follow up, audit and reconciliation of stocks, cash and alternate investments.

Conducted business process reviews to understand current state business processes and how underlying applications support and enable these processes.

Collaborated with business partners and stakeholders to identify and define high level and detailed business/functional requirements.

Documented the Business Requirements Document (BRD) and the Functional Specification Document (FSD) and heavy involvement in the Acceptance of the User Stories and Defects.

Participated in Business Process Modeling sessions, acted as a documentarian, facilitator, and subject matter expert in sketch sessions.

Conducted interviews and performed and user analysis in order to create Business Cases for AAS systems.

Conducted preliminary investigation for all project requests. Reviewed requirements, specifications, test, support and training plans to ensure they are in line with business objectives on projects.

Participated in Business Process Management group efforts to collect and analyze metrics and continually improve processes owned by the group.

Conducted root cause analysis in order to recommend product enhancements for stock distribution processes and other appropriate actions to improve productivity.

Demonstrated success in facilitating discussions with all levels and functional areas of the organization.

Prepared scope, gap and impact analysis documentation.

Provided guidance to project team regarding functional requirements.

Partnered with testing resources to identify testing requirements.

Ensured and validated that delivered functionality meets the business objectives.

Proactively identify opportunities to utilize current or innovative technical solutions to improve business processes and products that provided cost savings or efficiency gains.

Environment: Windows, Agile, UML, MS Office Suite, Teradata, XML, HP Quality center, Rational DOORS

First Health Services Corporation (FHSC), Richmond, VA February 2009 – Jul 2009

Business Analyst

Provided technical support for the Virginia MMIS system responsible for the development of requirements analysis and systems design documentation, responsible for Health Premium Payments, Third Party Liability Subsystem and Financial conversion documentation. Served as a liaison between the State and the Technical Support Group, conducted meetings, and created detail specifications for areas of the subsystem related to TPL and HIPAA. Participated on Detail Design documentation for the MARS Subsystem. Developed new Fiscal Agent Proposal write-ups for the TPL Subsystem for several states including Delaware and D.C. Medicaid.

Responsibilities:

Met with various HMO, PPO, Medicaid/Medicare, and Tricare / Champus Representatives discussing benefits of contracts on behalf of facilities or appeals from denials and compliance issues

Integrating systems of record into conformed dimensions and fact tables.

Involved in analyzing the claims on basis of Primary and Secondary Payers and performed Medicare subsidy eligibility check for employee group plans.

Participated in JAD Sessions for gathering requirements from SME'S. Played the role of a Facilitator in the JAD session.

Track and archive monthly receipts and payments, update budget tracking programs

Managed the team of consultants responsible for developing on-demand Medicaid Management System reports.

Tested the adjudication of Claims and migration Process.

Worked in validation of Claims in Mainframes.

Provider inquiry about the status of claims. This involved checking the MMIS claims subsystem to see the status of claims sent and informing the providers if the claims have been suspended / denied or paid. .

Experience with data migration (ETL development), document data manipulation processes and scripts

Developed detailed use case models and supporting specifications.

Involved in decision making of converting manual test cases into automated test scripts and analyzing their life time and time required to update the scripts.

Reported and analyzed all application defects, user issues and resolution status to the higher manager using Mercury Quality Center.

Created use cases, activity diagrams and process diagrams using Microsoft Visio.

Derived the requirement dependencies by working with other business analysts from different modules.

Supported in creating test cases to check the functionality of the enhanced application.

Environment: Rational Rose, Clear Quest, Microsoft Project, Crystal reports, SharePoint, Mercury, Lotus Notes, Erwin, Microsoft Visio, Microsoft Office suite, Business Objects



Contact this candidate