Skills

• Skills
• Total Experience
• Last Used
• Expertise
• Experience gathering, documenting, and establishing requirements traceability using requirements traceability tools.
• 4 Years
• Experience with developing use cases and test case scenarios
• 6 Years
• Experience with providing consulting services in the area of Medicaid and health insurance.
• 5 Years
• Experience with managing projects that used the software development life cycle SDLC
• 13 Years
• 1 years
• Knowledge of Medicaid or commercial insurance
• 5 Years
• Information technology project management experience
• 6 Years
• Experience with project plans and work breakdown structures WBS for software development IT projects
• Experience working with and/or knowledge of the System for Electronic Rate
• 5 Year
• Vendor/contract oversight experience
• 5 Year
• Master's Degree
• Yes

Employment History:

Confidential

Interoperability System Consultant

Responsibilities:

• Managing Healthcare Data Conversion Data Quality implementation.
• Managing Medicaid Medicare Data Conversion Requirements Specifications.
• Leading Architectural design discussions and providing solutions on ETL components.
• Leading Working Group sessions with Legacy System owners - DHR, DHMH, Xerox for Data Conversion effort.
• Instrumental in establishing an electronic product filing process utilizing the System of Electronic Rate and Form Filing SERFF that improved the time period for approved filings.
• Leading ETL Design session and implementing ETL solutions.
• Leading Healthcare Functional Analysis / Calculations / Models with IBM Curam MD HIX on the Data Target definitions.
• Leading and defining Conversion Master Data Management MDM from Maryland State Systems CARES, MCHIP Premium, PAC, MMIS, MABS and Federal Data Hub.
• Created Work Breakdown Structures WBS for Engineering, IT, and Documentation.
• Creating and Managing Data Conversion Rules, Data Profiling Quality Rules for ETL development and implementation.
• Experience in working with Vendor oversight.
• Identified the system requirements, assumptions and dependencies and created Use case documents, test cases and test plans along with extensive use case narratives using MS Visio.
• Proven expertise in gathering, analyzing and documenting business requirements and developing BRD, FRD and helped in preparing SRS.
• Developing SQL procedures in DB2 databases for routine data analysis.
• Creating and updating Data Models for Conversion.
• Creating Data Source to Target Mapping for ETL development and testing.
• Creating Audit Alert System with sample Informatica Mapping Pre/Post SQL alerts .
• Identifying reusable data elements for ETL jobs.
• Testing sample ETL jobs in Sandbox server and guiding Testers with Traceability matrix..
• Configuring and installing Informatica client.
• Managing artifacts and users on SharePoint.
• Leading Data Modelers and Managing Business Process artifacts on Enterprise Architect server.
• Acting as Subject Matter Expert on Data Conversion and implementing SDLC across the Conversion effort.
• Leading ETL developers in terms of Conversion Rules, Design, and Specifications.
• Interfacing with SOA / Data Transfer Layer for Data Conversion and aligning Conversion Outputs.
• Developing ETL Data Exception Processes and Rules.
• Mentoring junior Data Analysts and implementing Data Quality Profile rules.
• Representing Project Management team during the Maryland State meetings.

Environment: DB2, Windows 2007, Informatica Power Center 9.1, Informatica Data Quality, Unix, Subversion Version Control , Share Point 2010, MS Office, MS Visio, MS Project, Enterprise Architect, ER Studio

Confidential

Senior ETL Solution Consultant

Responsibilities:

• Managed Clinical Data Integration ETL and MDM Informatica 9.01.x Data Quality requirements specifications.
• Defined various architectural principles and patterns as in TOGAF.
• Developed the Conceptual, Logical and Physical Data model and reviewed the same with Architectural Review Board.
• Accountable for Functional Requirements, Specifications, and Traceability.
• Analyzed Clinical and Commercial System of Records and developed subject areas model.
• Worked with Business users and Program Directors and defined DI-ETL governance and practices.
• Proven expertise in gathering, analyzing and documenting business requirements and developing BRD, FRD and helped in preparing SRS.
• Managed DI-ETL automated tested processes using HP Quality Center.
• Worked on Unix Scripts in various Informatica customizations.
• Excellent experience in developing project scope statement, Work Breakdown structure WBS , project management plan, communication management plan, cost management plan and project resource management.
• Created Use case, Test Plan, Test Cases and performed Testing for all the user scenarios.
• Developed and managed Metadata information in Oracle and SQL Server repositories.
• Informatica Test installations and configurations on the Sandbox server.
• Configured and installed Informatica client.
• Interfaced with both business and DI teams.
• Created project charter, project plans for Data Quality.
• Lead Informatica Alert System solutions in UNIX platform for Clinical databases.
• Facilitated data quality requirements gathered session with the Business.
• Extracted requirements from existed Master Data Management MDM artifacts for Clinical and Commercial solutions.
• Managed onsite-offshore deliverables.
• Conducted weekly delivery appraisals.
• Developed ETL, MDM Solutions and Process Governance Framework.
• Reviewed Governance Framework with Security, Audit, and Architecture teams.
• Aligned industry Process Framework CoBIT.
• Aligned internal Process Framework IS Governance.
• Coordinated with Data Integration Regression Test.
• Leveraged various platforms / framework for SOA, MDM.
• Managed end-to-end project artifacts in SharePoint and guided Quality Team with RTM. .
• Created RFC and Release Plan on Service Now.
• Guided Test teams through comprehensive RTM.
• Good hands-on in ISPDM based on CoBIT and ITCM framework / processes as per FDA compliance.

Environment: Windows 2007, Informatica PowerCenter 9.1, MDM, Data Quality, Informatica Analyst, Oracle 11G, Unix, Subversion Version Control , Share Point 2010, MS Office, MS Visio, MS Project, ISPDM, CoBIT, GSF, Oracle Business Process Publisher, ARIS

Confidential

Consulting Lead Business Architect

Responsibilities:

• Managed various Health Care Database Requirements, Business Processes, Project / Program Management for 4CAST, a National Healthcare Grants Allocation Framework.
• Defined and Measured project KPIs with Technology Management committee.
• Established cohesive inter-group collaboration with program Directors OIT, BHPR, FDA, BPIC, DHS, and SSA.
• Responsible for all traditional functions of Medicaid and Health consulting services company.
• Orchestrated Stakeholder analysis with various Healthcare Bureaus.
• Optimized product development approach across the Bureaus by usability survey.
• Design and implement benefit packages for Medicaid beneficiaries based on eligibility, age, county, poverty level, etc.
• Implemented Business Data Metrics across Bureaus Database systems.
• Implemented various development design solutions.
• Created comprehensive data dictionary from various Health Care databases.
• Analyzed huge volume of Source Data using SQL Server.
• Created ERDs for various Federal Bureau / Office databases using Erwin.
• Developed prototype s wireframes using Axure.
• Developed online data framework using ADOBE suite.
• Reviewed deliverables plans, designs, codes, documents, test cases, processes.
• Developed Test Plans, Test Cases along with RTM Requirement Traceability Matrix .
• Managed project artifacts on Share Point Project site and user management and customization.
• Designed and implemented Share Point Project Sites.
• Aided EPLC business process in project gate review sessions.
• Reviewed RFPs and SOWs from vendors.
• Hands on experience in data related to Federal Funds, Grants, Cooperative Agreements, Agency Transfers.
• Created and reviewed various HRSA EPLC security polices and governance models.
• Developed Trained Content and Plan.
• Conducted interactive trained for both users and stakeholders using Adobe Connect.
• Supported users in ad hoc database application issues.
• Interfaced with various HRSA bureaus and COO team.
• Responsible release notes for two subsequent builds.

Environment: .NET 2.0, MS SQL Server 2005, MS SSIS, AJAX, Share Point, Axure, MS Office, Adobe Robohelp, Fire Shot, Citrix.

Confidential

Lead Business Consultant

Responsibilities:

• Interviewed and mentored business analysts.
• Led and guided 2 BAs and 2 QAs on day-to-day basis.
• Led a team of 8-10 consisted ETL developers, business analysts, and testers.
• Created system specifications framework as a key deliverable.
• Facilitated JAD sessions with DHS.
• Developed Data Dictionary and Master Data Management MDM Framework for Tennessee State Systems TENNCARE, TCCMS, COTS, VRTS.
• Analyzed and built Proof of Concept Specifications for System of Records SOR .
• Gathered functional requirements from SMEs and create deliverable s .
• Responsible for all traditional functions of health and Medicaid consulting services company.
• Experience in working with Vendor oversight.
• Created Work Breakdown Structures WBS for Engineering, IT, and Documentation.
• Created Use case, Test Plan, Test Cases and performed Testing for all the user scenarios.
• Researched functional group documents and synchronized functionality with data elements.
• Created entity relationship diagram for daily refresh, a part of data conversion engagement.
• Allocated effort to team members as per project plan and drive the effort till delivery.
• Identified data components from source segments to VIP target tables.
• Conducted gap analysis in source and target tables.
• Conducted conversion intensive and extensive data map analysis.
• Interfaced with 3rd party vendors for daily TCCMS data dump.
• Guided ETL developers in interpreted and updated Informatica mapped as per requirements.
• Trained and mentored team members on functional / business concepts.
• Created named convention documents for internal and external deliverables.
• Created SQL queries to pull various source-target data in line with Informatica mappings.
• Created quick vlookups for data comparison in excel.
• Interpreted Meta data and translated as part of functional group analysis.
• Analyzed ETL stored procedures and lookup transformations to measure mapped complexity.
• Led ETL developers in conducted conversion map analysis to measure daily refresh mapped estimate.
• Created business process flow and configuration diagrams.
• Created ETL performance tuned checklist.
• Assisted architects in analyzed functional group data and data modeled approaches.
• Created ETL Unit test checklists and ensured accuracy in ETL construction phase.
• Conducted source data delete analysis and created delete requirements in BRD.
• Created Daily Data Refresh post process / operational requirements.
• Distributed client requirements to various internal groups.
• Created internal project plan for team members and back tracked team effort for rough estimates.
• Conducted daily stand-up and updated weekly status reports.
• Developed detailed traceability matrix and guided QA team in testing Data Conversion Outputs.
• Assisted PMO to base line tasks and updated project plans.
• Reviewed client deliverables and delivered artifacts to clients.

Environment: Windows 2003, Unix Sun Solaris, XML, Novell Group Wise Manager, Informatica Power Center 8.6 / 9.1, JIRA 4.4, Oracle 10g, Eclipse, MS OFFICE, MS Project, MS Visio, SnagIT, eRoom Version Control

Confidential

Consulted - Business System Analyst III

Responsibilities:

• Facilitated JAD sessions with Business, Development teams.
• Gathered requirements from Business and documented requirements using Requisite Pro.
• Responsible for all traditional financial functions of consulting services.
• Conducted GAP analysis in the AGILE processes.
• Conducted daily sprints in the absence of Coordinator and Managers.
• Updated Dashboards accessed data from Teradata.
• Created Work Breakdown Structures WBS for Engineering, IT, and Documentation.
• Analyzed and updated Dialer reports using Business Objects.
• Captured daily data using Dialer Health Monitor.
• Experience in working with Contract oversight.
• Facilitated weekly meeted as part of applications review processes.
• Developed COAT Cap One Agile Team IT processes and audited procedures and policies.
• Worked with fellow Business System and Analysts dured system investigations.
• Researched, documented, and recommended ad hoc issues presented to Business.
• Worked with Mission Control team in updated System Configuration files.
• Analyzed ProphIT, a System of Record, Online Transactional Data.
• Captured PhrophIT, online workflow data for phone and collection strategy.
• Monitored online banked / data collection methodology and recommended solutions for the gap.
• Investigated data models and analyzed database and guided ETL teams.
• Created data model diagrams and data mapped using Rationale Rose and Modeler.
• Configured diagram parameters and dependency properties in Rationale Modeler.
• Followed up, updated, monitored, and distributed burn down charts dured sprints.
• Created pivot tables on data findings.
• Created Test Plan, Test Cases and performed Testing for all the user scenarios.
• Created and researched on various use case scenarios and narratives.
• Automated macros for accessed and updated routine business reports.
• Developed system access documents and test scenarios as part of Traceability Matrix..
• Designed and implemented new processes, and standards.
• Managed documents on the Knowledgelink server, online portal.
• Managed migration of data from the legacy system to the new content portal.
• Coordinated with QA and Delivery teams for a smooth transition and handover
• Documented functional specifications as per releases documentation throughout SDLC.
• Using modeled techniques in created use cases, wire frames, and system boundaries.

Environment: Windows 2003, Oracle 9i, UNIX, Teradata, Business Objects Portal Info view , Avaya Proactive Dialer, MS Office, MS Visio, Call Tech OnQ ALI , ProphIT, MS Office, Knowledge Link Content Management Systems , HP Quality Center, QMS, TSYS, MS Visual Basic, SQL

Confidential

Rationale Tool, Specialist

Responsibilities:

• Conducted gap analysis in 100 use cases in Rationale Modeler.
• Validated UI Data extracted from various source systems.
• Reviewed code / queries using TOAD and checked coded conventions and constraints.
• Tested Models on dual-OS using VM ware to test legacy system and IBM portletts on Sandbox server.
• Created traceability matrix for mapped use cases, business rules with system codes.

Environment: IBM Rationale Modeler, Windows 2007, TOAD, , Novell Group Wise Manager, Business Objects, ERWIN, MS OFFICE, MS Project, MS Visio, eRoom Subversion Version Control .

Confidential

Web Portal - Consultant

Responsibilities:

• Implemented RUP methodology for Content Collaboration as part of VAS.
• Captured Wifi Platform requirements in IBM Requisite Pro.
• Conducted gap analysis in use cases updated use case diagrams using IBM Rationale Modeler.
• Created Test Plan, Test Cases and performed Testing for all the user scenarios.
• Developed Story Boards, Wire Frames as prototypes.
• Designed and implemented information architecture for the developer web site.
• Created Data Model for Device and Firmware Data Sets.
• Excellent experience in developing project scope statement, Work Breakdown structure WBS , project management plan, communication management plan, cost management plan and project resource management.
• Experience in working with Vendor oversight.
• Defined processes on 'online-shopped cart.
• Interfaced and implemented SSL Secured Sockets Layer for online transactions with Server Certificate.
• Crated and automated JSON/xml codes for developers.
• Designed and inputted on BSS/OSS architecture and diagrams.
• Automated Convent Conversion from HTML to Textiles a Ruby Mark-Up language .
• Developed WIKI web site and pages on the developer site.
• Set Up development environment and defined workflow on the site.
• Acted as SMEs to create sequential and technical FAQs.
• Worked with vendors for device GUI design specifications.
• Led QA team dured UAT and Releases.
• Maintained defects and configuration issues in Quality Center.
• Developed test plans and test strategies as per releases and modules.
• Archived and distributed project artifacts on the Share Point, REDMINE, and VSS servers.

Environment: Windows Vista, Windows Server, 2003, IIS 6.0, Linux Ubuntu, My SQL, Apache, Web 2.0, PERL / Shell Scripts, Alfresco Enterprise Content Management solution , Red Mine, Red Cloth, Java, Advanced Java, XML, XSL, HTML, DHTML, Flash, Ruby on Rails, UML, Agile, MS Office

Confidential

Consulted Data Analyst

Responsibilities:

• Acted as Subject Matter Experts SMEs in telecom data.
• Released TEMS requirements from stakeholders to development.
• Simplified complex information into a legible process.
• Decomposed use cases into feasible business and cases and rule in Agile SDLC.
• Created Test Plan, Test Cases and performed Testing for all the user scenarios.
• Automated sedle-source methodology to deliver 2000 pages of Web / online content in Unix Script.
• Proven expertise in gathering, analyzing and documenting business requirements and developing BRD, FRD and helped in preparing SRS.
• Structured Context-sensitive help CSH and automated the content through Adobe FrameMaker Unix.
• Developed and presented all the visual artifacts to the stakeholders and development team.
• Conceptualized, designed, and implemented project-specific Content Collaborative Management System CCMS on SharePoint.
• Developed a Collaborative Framework for Enterprise-wide users on SharePoint.
• Managed Operated System migration from Windows XP to Windows Vista.
• Developed Standards and implemented politics for imported into data the Share Point portal from 3rd party sources.
• Experience in working with Vendor oversight.
• Provided Level of Estimates to enterprise teams.
• Accountable for multi-project data sets, requirements and artifacts.
• Produced Wire-framed various software sub site prototypes and models on the Share Point..
• Installed, configured, tested, and documented .NET development frameworks.
• Developed and maintained defect management system on Clear Case.
• Automated the defect counts as a score card and dash board on the Share Point portal.

Environment: Windows XP, C, C , ASP, .NET, MS SQL, XML, XSL, MS SQL Server 2003, Share Point Server, VSS, IBM Clear Case, IBM Clear Quest, IBM Requisite Pro, QTP, MS Office, MS Visio, MS Project, Adobe Acrobat, UML, AGILE, SOA, SCRUM, ITIL

Confidential

Project Lead

Responsibilities:

• Managed Offshore-Onsite Delivery Model in the SharePoint Documentum environment.
• Produced project feasibility and cost benefit analysis to carry out new programs.
• Facilitated and elucidated project sessions with a large group of stakeholders and team members in RUP SDLC.
• Developed and revised Delivery scope.
• Managed and reworked project plans on a continual basis.
• Gathered requirements from Business and documented requirements using Requisite Pro.
• Created Use case, Test Plan, Test Cases and performed Testing for all the user scenarios.
• Excellent experience in developing project scope statement, Work Breakdown structure WBS , project management plan, communication management plan, cost management plan and project resource management.
• Managed technical assumptions, project risks, issues, and dependencies.
• Managed off shore teams during migration from a legacy system to a new data source.
• Defined critical measures and score cards to the project sponsors.
• Created and maintained requirements catalogue.
• Executed the test strategy and system test plans and developed test scripts for project silos.
• Managed defects and handled escalation as per test procedures.
• Ensured the tested environment at its maximum usage.
• Monitored accuracy of service level objectives.
• Responsible for System Audits and SIX SIGMA implementation.
• Managed QA deliverables and developed comprehensive Traceability Matrix ongoing basis for builds.
• Responsible for the release dates within the specific source control system.
• Coordinated with other teams to analyze if changes impact the business areas and work flows.
• Functioned as a project spokes person during crisis and critical mile stones.
• Provided leadership to team leads wherever necessary.
• Worked with the ITIL teams for the infrastructure processes implementation.
• Responsible for vendor data for transactional analysis and managed vendors for various data interfaces.
• Defined KPIs, dashboards, scorecards and ensured their performance and measures during pre/post releases.
• Managed Share Point Content Management System.
• Managed Business Continuity and Governance.

Environment: Windows 2003, Java, DB2, eRoom, Share Point, Documentum, IBM Clear Case, IBM Clear Quest, MS Office, MS Project, MS Visio, ITIL

Confidential

IT Functional Consultant

Environment: Windows 2003, Java, DB2, VSS, IBM Clear Case, IBM Clear Quest, Win Runner, Load Runner, Silk Route, Adobe Captivate, MS Office, MS Project, MS Visio, UML 1.8

Responsibilities:

• Responsible for all traditional functions of Health and Medical Benefits Billing, Consulting and Receipting Services across the Durban municipality City Governance, 120 booths .