Ranga T. Kandalam

**** **** **** *****, ******** City, TX 77459 Cell: 832-***-****, Home: 281-***-****

E-mail: kkpdv7@r.postjobfree.com

__________________________________________________________________________________________

Summary

Seeking a position as a Business Analyst in the Healthcare industry.

Experienced IT Professional in project management and implementations of health care systems.

Professional Strengths

COMPETENCIES:

• Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into functional/technical requirements.

• Adept at preparing business requirements documents (BRD’s), defining project plans, writing system requirements specifications, and delivering project/status reports.

• Led and worked with teams to examine and solve business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for their customers.

• In depth knowledge of RUP’s Iterative Software Development Life Cycle process.

• Expert at analyzing, designing, and reengineering systems applications and business processes

• ICD-10 Subject Matter Expert (SME) to support the mapping of ICD-10 codes, impact analysis, requirements analysis, design analysis, and testing. This position will also be responsible for meeting third party vendors to discuss ICD-10 impacts to their business, document their approach and schedule for ICD-10 implementation, monitor their ICD-10

• Excellent written and oral communication skills with a results-oriented attitude.

• Proactive team player with demonstrated problem solving and analytical reasoning abilities.

• Experience in management of requirements throughout the Software Development Life Cycle (SDLC).

• Business Analyst with experience in healthcare, pharmaceutical health insurance industries

Sound knowledge of Health Insurance and Portability and Accountability Act (HIPAA).

• Monitoring & installation of EMR, training the staff and getting them upto speed on its operations

• Sound knowledge of Health Insurance and Portability and Accountability Act (HIPAA).

• Comply with Health Insurance Portability and Accountability Act (HIPAA) and ICD 10 requirements. Purpose of the project is to analyze GAP between current HIPAA 4010 / ICD 9 and compliance HIPAA 5010 / ICD 10 for state Medicaid Management Information System.

Technical Skills

Business Modeling UML, UML CASE Tools, Rational Rose, MS Visio, Agile, SCRUM

Project Management MS Office Suite, MS Project, MS I.E, MS FrontPage, MS Visual Studio. Primavera

Languages C, C++, Java, SQL and PL/SQL, ASP, ASP.NET, HTML, XML, Visual Basic, , JavaScript, Share Point, SAS, SPSS. ESRI Products ARC Info, ARC GIS, ARCView

Processes RUP, SDLC, Agile Modeling, SCRUM

Database Oracle, MS SQL Server, Microsoft Access, DB 2, GIS

Help Desk Management

Remedy 4.0, Clear Case.

EBS PeopleSoft, Oracle ERP, CRM

.

Freelancer

Freelancing Consultant In Health Care January, 2009 – Present

Business Analyst/Project Management

RESPONSIBILITIES:

Clients: Dharma Solutions, Suvega LLC Billing Company, Dr. Renu Tamirisa, MD., PA Independent Medical Practitioner, Dr. Chary Tamirisa., Independent Medical Practitioner., Sugar Land Medical Aesthetics., Medical Clinic and Holistic Clinic., Dr. Ravi Tamirisa., Pain management Doctor., Holistic Pain Specialist

Deliver successful education programs for healthcare practices implementing leading Electronic Medical Record (EMR) systems. Primarily responsible for delivering training, providing support and thought leadership to ensure that all levels of end users can effectively use the new EMR technology and processes established by the client. Secondary responsibilities include assisting with up-front planning and development of curriculum. Delivers instructor-led sessions, one-on-one coaching, and presentations for Super Users, Providers and Staff. Provides work-flow consultation when facility is transitioning from paper to electronic methods.

• Monitoring & installation of EMR, training the staff and getting them upto speed on its operations

• Performed follow up on sites

• Performed go-live assistance

• Coordination of input, deliverables and budgets

• Managing communication with internal team, suppliers and clients

• Ensuring that work is completed on time and within budget

• Research and input for presentations

• Collect information related to ongoing application upgrade and their impact on ICD-10 implementation and

• Created awareness within the departments regarding the need, impact, benefits and risks of ICD-10 code application.

• Developing SQL scripts for maintaining administration tasks.

• Tuned the SQL queries using SQL profiler. Involved in tuning the database

• Using ICD 9/ICD 10/ANSI/HL7 coding standards in Medicare and Medicaid domains of the healthcare systems and industry for both inpatients, outpatients, reimbursement methodology.

• Process documentation creation experience and ability to facilitate requirement sessions and proof of concept sessions

• Requirements gathering by conducting interviews with end users

• Good control on MS Office suite, MS Visio and MS Project.

Professional Experience

AECOM Technology, Dallas Dec, 2009 – Jan, 2011

Senior Business Analyst/Consultant

Role & Responsibilities:

• Gathered business requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME’s)

• Communicated and interacted on a regular basis with the project manager and development team during different stages of the project

• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.

• Prepared Business Requirement Document and used Rational Requisite Pro to manage, analyze, and convert business requirements into functional specifications

• Developed use cases from requirements and created UML diagrams such as use case diagrams, activity diagrams, and sequence diagrams

• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Rational Rose and MS

• Worked with Rational Clear Case and Rational Clear Quest to automate and enforce the development processes and aid with configuration management

• Managed schedules and collaborated with different teams working on the project

• Prepared project progress reports and status reports and submitted to the management on an ongoing basis

• Assisted with required data analysis, interpretation, correction and document presentation for various assignments

• Was actively working on custom functions, scripts, shell PDF and procedures for automated build acceptance and testing.

• Have about 2-3 years of PDF-Shell Tools software which was used to extend the Windows Shell and provide access to several tools to work with PDF documents directly from the Shell environment. Performed many common tasks with the PDF documents without the need of Adobe Acrobat or other PDF desktop applications.

• Worked directly from the Windows Shell to control the power the tools provide from batch and script operations, or even, from another application

Parsons Corporation, Houston June, 2008 – Aug, 2009

Business Analyst/Consultant

Role & Responsibilities:

Preparation of Proposal for Award of contract and getting Approvals Prepare Bid Comparative Statements, Prepare Proposal for award of the contract. Obtain Tender Board Endorsement for the Proposal and get the Approval from Competent Authority for awarding the contract.

• Studied and analyzed similar applications and brainstormed to gather effective requirements for the system

• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead

• Award of Contracts Preparation of Letter of Award, Obtain signature from competent authority and issue the same to the Contractor. Obtain signed & stamped copies of the Award Letter from the contractor.

• Conducted and participated in JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS) and used RequisitePro to maintain the requirements

• Used UML notations and RUP methodology to analyze and translate business requirements into system specifications.

• Data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2000/7.0, MS SQL Server upgrades from 7.0 to MS SQL Server 2000 and from 2000 to MS SQL server 2005.

• Used MS Visio to create process flowcharts and workflow Diagrams

• Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases

• Identified opportunities for business process improvement and initiated efforts to make improvements

• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.

• Maintain all the SQL documents includes installation and data conversion Procedures documents.

• Trouble shooting Problems by using SQL server profiler.

• Designed and installed new features to the network code using C, C++, Java, other languages, scripting languages and utilities. Maintained Client and Server systems using Unix, C,

Baltimore Metropolitan Council, Baltimore, MD & IEM, Baton Rouge, LA Nov, 2007 – June, 2008

Business Analyst

Role & Responsibilities:

• Gathered and documented customer requirements along with detailed functional design specifications and system documentation

• Identify the Potential Bidders suitable for executing the contract job, from the Registered Bidders List, and prepare the Proposed Bidders List. Obtain the concurrence of User Departments for the proposed bidders list.

• Coordination of Contract Arbitrations Coordinate with the Legal departments on the matters concerned with Contract Arbitrations

• Implemented SQL standards in writing Stored procedures, Triggers, Views, Sql functions and locking issues.

• Followed the Unified Modeling Language based methods using Rational Rose

• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams, and Sequence diagrams to help business users and developers better understand the process

• Created a process document to depict the flow of critical information

• Maintain all the SQL documents includes installation and data conversion Procedures documents.

• Trouble shooting Problems by using SQL server profiler.

• Developed and managed requirements traceability matrix to trace business and functional requirements

• Acted as liaison between the senior management and different teams with effective presentations

• Developed project status metrics for weekly evaluation of project status and impact of the Change Request on the Time line

• Assisted the development team in designing the GUI of the application

• Designed new systems applications using Management tools like MS project & Primavera P6, Maintained Client and Server systems using UNIX, C, Java, ASP, and other languages and utilities including TCP/IP, XML Schema and WS-Security.

H-GAC, Houston June, 1993 – April, 2007

Chief Engineer/Analyst

Role & Responsibilities: Provided project management support, headed the development and management of budgets, led and assisted project management in managing planners and modelers, identified project risks, Led the efforts of technical support, develop detail plans.

• Aided project management in managing planners and modelers to develop and implement the state of the art models on the HP, UNIX and NT servers system.

• Developed detailed project plans for multiple simultaneous projects, resulting in increased visibility of inter-project dependencies and improved development efficiency.

• Identified project risks. Designed and implemented project status reports and communications.

• Responsible for development and management of budgets, determining project scope, liaising between clients and staff throughout project lifecycle, and ensuring objectives were met.

• Provided project management support to the transportation department including the modeling group.

• Responsible for a few technical supports for integration projects with various clients.

• Coded Client/Server Systems on multiple platforms using Java, Unix, C, C# Standard Library, SQL, XML, UML, SQL Server, J2EE, ASP, .NET

Project Management / Leadership Responsibilities

Role & Responsibilities: Managed direct plans and operations, prepared and presented project reports, managed the identification determination, supervised technical analyses and evaluation, coordinated with interagency project coordination, led and create networks effort in GIS, led staff development effort.

• Managed and directed planning and operations by initiating, coordinating, and enforcing project, operational, and personnel policies and procedures; assessed risk and identified solutions on how to mitigate and manage high risk areas of project development.

• Developed Project Scope, Work Breakdown Structure, Assumptions, Project Schedules, Budgets etc. for various projects

• Reviewed month end financial statements of the project to monitor the progress of the project and identify any corrective actions necessary to bring the project on track.

• Performed Earned Value Analysis and prepared critical schedule and milestone analysis

• Involved in configuring and converting MS SQL server 6.5 database to MS SQL Server 7.0.

• Prepared and presented project status reports to public/private stakeholders, as well as the provision of critical assessments regarding complex issues related to design, construction, regulatory permits, finance and politics

• In-charge manager responsible for the identification, determination, and establishment of analytical assumptions and model parameters used.

• Supervised technical analysis and evaluations, project production, project delivery to client scope requirements, and in compliance with established schedules, budgets, quality assurance and control standards of H-GAC policies.

• Major task areas included demand analysis using the model for estimation and forecasting for all kinds of projects including Major Metropolitan Plan (MTP), conformity, regional, sub regional, corridor, Major Investment Studies (MIS), and State Implementation Plans (SIP).

• Interfaced and coordinated with inter-agency project coordination & planning and provided assistance in the ongoing modeling committee meetings.

• Programs involved the creation of network(s) in GIS environment, articulating the processes to incorporate into the model into the four-step process of demand models.

• Responsible for staff development, scheduling, assignments, training, and staff evaluations

Education & Personal

Master of Science (M.S), University of Illinois, Chicago, IL, USA, March 1991.

Bachelor of Science (B.S), JNTU College of Engineering, Hyderabad, AP, India, March 1981.

USA Citizen

References available upon request.

Contact this candidate