SUMMARY

• 7+ years of unique Health IT experience as an Analyst/Lead in deploying various projects from conceptualization to implementation.
• Exceptional communication skills to interview SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications.
• Experience in process modeling using UML (Use Cases, Sequence Diagrams, Activity Diagrams, etc.)
• Experience writing SQL queries and reporting the results to the business team.

TECHNICAL SKILLS:

Databases: Oracle 10g, Oracle 9i, Oracle 8i, SQL Plus, SQL Server 2005, SQL Server 2007, SSIS packages

GUI/Tools: Confidential Project, Visio, Confidential Office (Word, Excel, PowerPoint, Access), XML & HTML

Platforms: Windows NT/2000, XP Professional, HP UNIX

Defect Tracking: Quality Center (QC), Clear Quest, Defect Tracker (now Software Planner)

Testing Tools: LoadRunner, Quick Test Pro (QTP)

Methodologies: Agile, RUP, SDLC, Waterfall, Scrum, Six Sigma, CMMI, ITIL

Configuration Tools: Rational Clearcase LT, Visual SourceSafe (VSS), Rational Requisite Pro

Other Products: Navigator 10.0, IDX (GE owned), ERWIN, InteliScript (Reporting Tool), FTP, Remedy

Other Skills: Requirements Gathering & Management, Application design, development and testing, Database Design, Application Migration, Health Care Conversions. 

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

• Translate Health Information Exchange, Affordable Care Act (ACA) regulations impacting FACETS Claims systems into business requirements
• Utilize Agile project management methodology due to changing federal regulations
• Conduct JAD and brain storming sessions with the business owners and the stakeholders validate business requirements
• Create process flow diagrams to propose future state and validate impact
• Lead requirements analysis sessions with key matrix partners
• Create Project Requirements Document (PRD) defining Business, User, Functional and Non-Functional requirements
• Utilize HP ALM to track and trace project requirements
• Coordinate and participate in solution design workshops with the development team
• Schedule and conduct business and functional requirements reviews/walkthroughs with program participants to obtain business approvals
• Track open issues and determine plan for resolution
• Work closely with the PM to provide project status, work efforts and duration
• Participate in test planning sessions with the testing team to ensure all test scenarios are documented
• Plan and manage all tasks for requirements sessions; work with the requirements manager to set the session agendas, manage logistics, follow-up on action items
• Communicate cross functional requirements to appropriate teams
• Created Requirement Traceability Matrix (RTM) to ensure the project requirements are met
• Identify and help manage requirement gaps

Sr. Business Analyst Consultant/Project Lead

• Leading the Letters BA team for a long term, multi-billion dollar project using waterfall approach
• Prepare estimates, project plan tasks, budget and resource requirements
• Liaise client and development team in resolving gaps
• Capture changes/new functions/risks and analyze effect on deliverables
• Create and update FSDs (Functional Specification Documents) as required
• Coordinate development efforts with the print vendor for the new project
• Lead several Health Plan conversion efforts successfully into an existing application
• Coordinate and lead cross-functional task forces to identify and document functional requirements, work flow, information sources and distribution paths and system specifications
• Create/update design documentation to reflect functional requirements
• Coordinate and lead review sessions with Business community to review functional requirements
• Participate and identify gaps in data mapping
• Create/update System Change Documents (SCDs) for Production Support items
• Review Technical Specifications documents created by Dev Team and provide feedback
• Log/update system defects in Quality Center and ensure updates are made by teams involved
• Execute database queries to fulfill ad-hoc requests (SQL Server 2005)
• Lead and coordinate maintenance with cross-functional teams and Business community
• Utilize Remedy to log new or change requests
• Coordinate Release Management efforts with the Release Team
• Create deployment plans and conduct review with the team
• Participate in Systems and Regression Testing
• Coordinate UAT efforts with Business community
• Query IDX for inconsistencies with incoming data
• Perform knowledge transfer and mentoring to new team members
• Provide on-call support when required/assigned
• Demonstrate superior communication skills, both verbally and in writing

Manager of IT/Business Reporting

• Manage reporting group consisting of 7 analysts located across four different locations within the organization
• Performance of peer review and employee performance evaluation
• Lead Project FootPrints - converting all requests from emails to a ticketing system (backend SQL Server)
• Participate in Project FBO - providing guidance to development and DBA teams to create a replicated data warehouse environment for Finance
• Coordinate training sessions for InteliScript reporting tool
• Responsible for establishing and maintaining positive business relationships with other major segments of the organization
• Specialize in Ad Hoc reporting and analysis utilizing reporting tools, Excel, Access and Data Warehouse – to organize and section data
• Work closely with Account Management, Client Services, Clinical Staff, Proposal Team, and Sales Force to provide reports which assist in business making decisions
• Reports included Benefit Design Analysis, Formulary Analysis, Pricing Analysis, Trends Analysis and various RFP requests
• Assign team members to specialized projects
• Gather requirements from upper management for unique requests
• Utilize SQL Server 2000 & 2005 (DTS & SSIS packages) to load Pharmacy Claims data – performed formulary, pricing and network analysis using data provided
• Perform database queries to fulfill ad-hoc requests (Oracle 10g and SQL Server)
• Query SXC for inconsistency with claim adjudication
• Responsible for delivering accurate Pricing matrices to Finance Business Operations (FBO) team
• Involve in improving Drug Pricing and Pharmacy information in Data Warehouse
• Participate in and supported QA efforts
• Provide project updates to Project Management team

Business Analyst

• Share business processes and functional expertise with user community. Responsible for requirements gathering,analyzing, developing and consulting of user and functional requirements.
• Requirements gathering using Rational Requisite PRO, to facilitate requirements organization, integration and analysis
• Coordinate JAD sessions with developers to focus on the quality of the product
• Facilitated JAD session follow-up for Project Plan updates, gained consensus for User Acceptance Testing (UAT) requirements
• Completed the entity modeling and participated actively in modeling activities. Ability to define data requirements. Mapped requirements by process and division to subject area data architecture.
• Involved in writing the Business Requirements Documentation, which included the scope of the project, phases of SDLC, requirement analysis, tasks associated with the project, documentation needed, roles and the deliverables of the final product. This document was critical in providing any individual of the team with clear understanding of the project.
• Assist with assessing performance and capacity requirements, volumetrics and evaluation of key technology decisions.
• Participated in the ETL process from SQL server to Oracle 9i.
• Ensured that the interface specifications are published and controlled thorough understanding of methodology with a specific emphasis on its relation to information architecture, content management, object design, legacy interface, and persistence development.
• Assisted in implementation of new builds and releases of the existing applications (residing on UNIX platform). Provided configuration management of new releases, which resulted in enhanced project control.
• Participate in and support QA and UAT activities
• Involved in developing training manuals to ensure client understanding of the product

Confidential

Oracle Developer/DBA

• Performed database queries against relational data tables to fulfill ad-hoc report requests.
• Reviewed and finalized specifications for project with supervisor
• Troubleshoots any system failures and discrepancies.
• Ability to work with large sets of data to create analysis and reports for management
• Developed and maintained project plans using Confidential Project 2000
• Designed Physical and Logical model for the new Integrated database. ErWin is as a modeling tool.
• Participated in developing, maintaining and enforcing data standards, policies and procedures. Maintained Data Dictionary, metadata models, logical data models and see it through physical implementation.
• Monitored user interaction with the system and make necessary changes to the ever changing

Data Modeler/Business Analyst

• As an EDM (Enterprise Data modeling) team member, our objective was to define and socialize core business terminology across entire team, using common business language and through Universal data modeling.
• Developed an enterprise-wide relational data model, completed the business analysis of my subject area, meeting with end-users to identify business requirements.
• Reviewed and finalized specifications for project with supervisor
• Analyzed and decomposed business functions into Logical Data Model.
• Worked on the Logical Model, specification and modeling standards for the project.
• Presented the data model to the client utilizing Oracle Designer 2000.
• Translated data into a logical model, worked along with DBA’s and developers to convert the logical design to physical designed
• Reviewed requirements, create, develop and execute test plans and analyze results
• Provide feedback, conduct research tests, provide benchmarks and test results to the software development team through Confidential Project