SUMMARY:

• Senior Business Analyst with 9+ years of industry wide experience in the domain of Healthcare, Pharmacy, Life Sciences, AME expert with solid understanding of Business Requirement elicitation techniques, Business Intelligence and experience in envisioning, representing and translating the product vision from the business sector to the software development by making critical contribution in varied domains such as Fund Accounting, Fund Management.
• IT professional over eight years of experience in Waterfall software development, administration, business analysis, design and implementation of B2B applications across various industries such as Retail, Manufacturing, Transportation and Logistics.
• Experience in design, mapping and development of maps and components for B2B integration using S.I 5.0, 5.2, GIS 4.1, 4.2 and 3.1 and Gentran Server 6.0, 4.0, 3.1, WDI 3.2.1 version and AXWAY XIB.
• Understanding HL7 Integrations and HL7 Structured data.
• 2 Years of experience in Enterprise Licensing with different systems (eLicence 3.0).
• Experience with end - to-end AEM/CQ admin responsibilities including author, publisher, dispatcher server installation, configuration and upgradation of servers, performance tuning, scheduling repository backups, weekly maintenance and reports, creating users/groups and maintaining their access controls using LDAP configuration, setting OSGI configurations, configuring replication agents, setting up run modes, creating OSGI bundles and packages.
• 3 Years of experience with Integration Message broker, MFT, Axway and B2B Patterns and flows.
• 5+ years of experience utilizing IBM Lotus Notes, IBM Domino and CISS.
• Change Management lead for 15-month enterprise-wide initiative to consolidate legal entities involving multiple stakeholder groups across several functional organizations. Participated as extended PMO member involved in project leadership throughout course of initiative.
• Change Management lead for business transformation initiative for Midstream business, including new system, process changes, governance changes, and organizational role changes. Built and managed Change Network across all domestic field locations
• Change Management lead for P2P initiative supporting project team plan and execute communication and training events for process and system changes involving most steps in the Supply Chain process affecting the entire Supply Chain organization
• Change Management lead for global SAP "new G/L" upgrade and reporting enhancement project involving accounting and finance stakeholders in all domestic and international locations. Built and managed Change Network across all locations, including Asia, South America, Europe, and Africa offices.
• 2+ years of experience in ingestion, storage, querying, processing and analysis of Big Data using Hadoop technologies and solutions
• 2+ years of experience of in Identity Management functions with Site Minder, TMG, Proxy and IAM.
• 2+ years of experience with Active Directory and Federation along with Domain Name System (DNS).
• Overall 3 years’ experience in Oracle E-Business Suite R12 Provide overall support to ensure the successful design, testing and implementation of the requirement.
• Good experience in handling different file formats like text files, Sequence files and ORC data files using different SerDe's in Hive.
• Extensive experience with SQL, PL/SQL and database concepts.
• Expertise in application development using Java, RDBMS, and UNIX shell scripting.
• Experienced in implementing software design for oil and gas data integration software using Java, SQL, XML, Apache Kafka, Apache Nifi, Apache Camel, and Apache Tomcat.
• Experience in assisting the MDM technical teams (team ranging from 15 to 20) throughout the implementation of the project.
• Good knowledge on ASP.Net and VB.Net and Jira and agile tools.
• Experience in MIFID regulations, MIFID 1 reporting, data sources and controls for reporting.
• Experienced performing completeness and accuracy analysis of MIFID transaction reporting
• Strong Experience in Requirement Gathering, Analysis and Elicitation, Business Requirements Mapping, Requirement Management, Designing Customized Solutions and Business Mapping with strong ability to analyze business practices and define optimal procedures. Expert in clarifying client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all stakeholders.
• Experienced with multiple payer applications including AMISYS and FACETS and DIAMOND, XLESYS.
• Great knowledge on Pharmaceutical/ Life Sciences industry, worked as a Quality Manager in the Circular Practical Training for Pharmaceutical Company while in the School. Had great Experiences in handling all the analytical instruments such as HPLC, mass spectroscopy.
• Proven record of high accuracy in designing and building healthcare benefits on the AMISYS system.
• Working knowledge in SAP Analysis for Office and OLAP
• Experienced working with complete Software Development Life Cycle (SDLC) such as Agile, Waterfall.
• Three plus years of experience in all phases of Project Development Life Cycle: business analysis, system analysis, design, development and implementation of Business applications.
• Four plus years of experience in soliciting client requirements through interviews, workshops, and existing systems documentation or procedures.
• Organized and disciplined team player with the ability to also excel in independent positions requiring minimal supervision.
• Demonstrates strong relationship building skills with stakeholders that aid in analysis and convergence of requirements for a project.
• Highly skilled in writing Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Request for Proposals (RFP), Statement of Work (SOW)
• Expert in creating UML Diagrams including Use Cases, Activity Diagrams, Flow charts, Sequence Diagrams, Collaboration Diagrams and Data Flow Diagrams using MS Visio.
• Expertise in assisting Testing teams with Test Plans, Test Cases and Test Scenarios, and manage defects using various Defect Tracking Systems.
• Strong business acumen, strategic thinking in a multicultural environment and presentation skills adept at creating, editing, and coordinating extensive communication networks.
• Excellent Interpersonal, and Analytical skills, with ability to handle challenges under pressure with ease.
• Participated on multiple analysis projects for various applications, developedinternally and by other solution providers.
• Involved in reviewing test procedures, defining test cases, reviewing and maintaining test scripts, analyzing bugs and User Acceptance Testing (UAT).
• Extensive experience in using MS Project for status reporting and planning.
• Experience in building SQL Queries, Creating sub queries, minus, union, inline queries and performance tuning of SQL (DB2 and Oracle).

TECHNICAL SKILLS:

Languages: C++, SQL, Java, Oracle iExpense and AEM 6.1

Operating Systems: Win 95/98/NT/2000, XP, UNIX

Internet Technologies: HTML, XML, VB script, Java script, MFT, Axway, Middleware Integration

Databases: MS SQL Server, MS Access, Oracle 8i, Toad, Oracle E-Business Suite R12 - Regulatory Admin, Financials, Order Management, Process Manufacturing, and Supply ChainOracle Big Machines - Configure/Price/Quote Tool

Application /Tools: Microsoft Project, Microsoft Visio, Rational Rose, MS Office 2003/2000/XP: HP ALM, IBM Lotus Notes, MS Word, MS Excel, MS Power Point, Rational Rose, RequisitePro, Rational SODA, Clear case, Clear quest, MS Front Page

Reporting Tools: Crystal Reports, Jira

Quality Management: Concept and Tools of Quality Management Test Director and Win Runner, ISO Concepts, Six Sigma Techniques

Web Technologies: ASP, JavaScript, HTML, DHTML, IIS, and FrontPage

User Interface: HTML, XHTML, CSS, Java Script

Documentation Skills: MS Project 2000, Jira, Confluence, Software Requirements Specification, Test Plans and Test Cases

Testing Tools: Manual Testing, HP Quality Center, Quick Test Pro (QTP), Win Runner, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Ohio

Axway B2Bi Mapper

Responsibilities:

• Develop data transformation maps to/from CSV, XML, X12, EDIFACT & flat files in Axway Data Mapper v 3.1. Most common transactions include 110,210,310,214,204,990,315,856 etc. EDIFACT Transactions like - INVOIC, DESADV, ORDER, IFSCUM, IFSTA, IFTMIN etc
• Designed the data migration strategy, test plans and scripts to verify data and migrated databases from SQL Server 2000 to SQL Server 2005-2008.
• Closely worked with MFT, AXWAY and AXWAY CSOS Developers and provided mapping documents and EDI.
• Assisted in Develop Integration activities in XIB 1.5 for developed maps. These include activities like receiving the file from the customer through B2Bi, Archiving, data conversion and delivering with the required file name to the application
• Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software
• Mapped Facets Accumulator Data: healthcare claims and 835: payment advice transactions, Captured all HIPAA-related EDI data in the repository using FACETS accumulator, Supported integrated EDI batch processing and real-time EDI using FACETS. Accepted inbound transactions from multiple sources using FACETS and Life Insurance.
• Designed complex packages for ETL to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, OLE DB, Excel and Access to SQL Server 2005
• Managed and Executed various Project activities such as Stakeholder Meeting, Data from Shared Data Center group, and QC activities from Centralized QC group.
• Utilized Lotus Notes application for the data processing with automatic tiff file creation of submitted surveys and action plans.
• Good Exposure in using of QTP integrated environment like Step Generator, Synchronization, Data Table, Actions, Recovery Scenarios, and Methods.
• Performed backend testing by executing SQL statements.
• Wrote SQL Scripts to insert regression test data into the database.
• Validated some of the reports, using complex SQL queries, generated during the process.
• Extensively used SQL queries to perform Backend Testing.
• Imported and exported data from and to Excel to and from QTP
• Mapped HL7 Integration and gathered Source to Target mapping for Dell Boomi team to convert the HL7 to Non HL7.
• Provided EDI Mapping document and Axway B2Bi mapping document for HL7 and Non-HL7 Interfaces.
• Responsible for prioritizing, designing, building, evangelizing mobile and SaaS payment software and services
• Constructed P&Ls and Payment Volume models from blank Excel spreadsheets for all SaaSProducts
• Re-engineered business process and standardized KPI, definitions for large data integration efforts
• Guided clients in implementing and managing Master Data Management programs, helping them balance DM project goals with strategic initiatives and DG goals
• Upgraded Customers, Users and Physicians to new systems using eLicence 3.0 system.
• Assisted in writing the Request for Proposal (RFP) for Enterprise MDM implementation for IDQ and Master data management.
• Good understanding of Integrations including Web Services, SAAS, Workday Architecture, Business Process Framework.
• Guide and Manage Informatica product implementations for MDM and Data Governance
• Educate and guide customers on MDM and Data Governance initiatives
• Data Governance Sales Play and Knowledgebase articles development
• Represent and present Informatica perspective/methodology on MDM and Data Governance at conferences
• Web-enabled Management Approval System for group emails via Lotus Notes
• Emails sent to large distribution lists require management authorization prior to delivery. Updated system allows managers to access and approve messages via a web browser via Lotus Notes.
• Updated and enhanced multiple tracking databases, used for software license, maintenance contract, and computer equipment tracking via Lotus Notes application.
• Updated dashboards and user stories using Jira and Confluence.
• Good understanding of integration patterns and content-centric application development patterns using Adobe Enterprise Manager 5.6.1, AEM 6.0 and AEM 6.1.
• Extensive experience in gathering, analyzing and documenting content management needs from Business ( digital marketing and branding) and translated requirements in terms of AEM templates, components and workflows
• Operate within a team of analysts in the Master Data division of the Logistics department
• Execute corporate business tasks through master data analysis, entry and management using SAP software
• Highly skilled in providing workflow analyses, working with third-party vendors and support team.
• Experienced with multiple systems, and training staff with multiple applications.
• Successful with project implementations
• Utilized IBM Lotus Notes for the Collaborative Client Server Software.
• Change Management lead for 15-month enterprise-wide initiative to consolidate legal entities involving multiple stakeholder groups across several functional organizations. Participated as extended PMO member involved in project leadership throughout course of initiative.
• Change Management lead for business transformation initiative for Midstream business, including new system, process changes, governance changes, and organizational role changes. Built and managed Change Network across all domestic field locations.
• Experienced with ALM and other HP Quality Center technologies.
• Change Management lead for P2P initiative supporting project team plan and execute communication and training events for process and system changes involving most steps in the Supply Chain process affecting the entire Supply Chain organization
• Change Management lead for global SAP "new G/L" upgrade and reporting enhancement project involving accounting and finance stakeholders in all domestic and international locations. Built and managed Change Network across all locations, including Asia, South America, Europe, and Africa offices.
• A team player with exceptional time management and multi-tasking abilities for Waterfall software development life cycle.
• Committed to providing high quality service, quick learner with superb decision making abilities.
• Excellent communication skills; able to build and maintain positive working relationships.
• Worked on Facets Claims Software System, to convert data from their legacy system (LRSP) and add custom applications to satisfy in-house requirements.
• Worked on AEM communities for users to communicate and post their reviews.
• Strong knowledge on AEM associated technologies like Sling, OSGI, Felix, Jackrabbit, JCR, and CRX.
• Involved concurrently in enhancement of HIPAA X12 4010 transaction to HIPAA X12 5010 and ICD 9-CM (Clinical modification) to ICD-10-CM/PCS (Clinical modification/procedure coding system).
• Expertise in Claims, Subscriber/Member, Plan/Product, Claims, Enrollment, Provider, Commissions and Billing Modules of Facets.
• Worked with Accumulators, Deductibles, Coordination of Benefits, and Overrides of the Claim Line detail and used them for testing various claims scenarios in Facets.
• Proposed FACETS claims adjudication procedures, standards and editing guidelines.
• Worked closely with developers and a variety of end users to ensure technical compatibility and user satisfaction.
• Assisted new team members on MDM technologies and project domain.
• Involved in developing the data quality rules to find out data anomalies and missing data using IDQ tool.
• Involved in data stewardship enablement and performed data steward role.
• Followed the UML based methods using Microsoft Visio to create Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams.
• Supported development of UAT cycle test scripts, Review User Acceptance Test Plan (UATP) and attend walkthrough
• Mapped HIPAA compliant EDI transactions for 837: healthcare claims and 835: payment advice transactions
• Created UML to ensure the business logic is clearly demonstrated to developers, created use cases to understand the narratives.
• Conducted FRS walkthroughs with technical departments to ensure design is accurate.
• Developed a file tracking application that organizes the location for all trust operations records. Used by business managers to request trust records with VB 6.0, MS Access 2000.
• Reviewed defect reporting and resolution in Mercury Quality Centre to track project progress against schedule.
• Wrote and executed system test plans, test cases and test data on MS Excel for the web-based application.
• Performed functional, smoke, regression, usability, system and integration testing.
• Identified, organized, and documented the changing requirements for the application using Rational Requisite Pro.
• Facilitated requirement gathering sessions, helped business to understand what can be accomplished quickly out of the box on AEM when compared to customizations.
• Acted as a SME on AEM ( CQ5) projects
• Engaged in system testing during User Acceptance Testing (UAT).
• Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines.
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
• Created use case scenarios and documented work flow and business process.
• Used RequisitePro to document requirements, associated change requests with requirements and connected requirements with Use cases.
• Prepared the UML Use Cases using Rational Rose.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to RUP for the stakeholder review.
• Worked on claims, Claim adjudication Membership, Eligibility, Accumulators,
• The process included importing claims into Facets that had been adjudicated and setting them in a "PAY" status so that a payment cycle could be run to create checks on Facets.
• Worked in association with RUP mentors to ensure fidelity to the standard RUP practices of the institution.
• Conduct weekly staffing calls, developed training material, lead numerous training sessions for both on-shore and off-shore resource managers and project managers, directly responsible for increased TriZetto wide services time entry compliance, project schedule design and maintenance, created data validation processes and tools
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Involved in maintaining and managing different versions of Documents using Rational Clear Case.
• Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders.

Environment: Waterfall, Rational Rose, SaaS, eLicence 3.0,Oracle E-Business Suite R12, HP ALM, Jira, AEM 6.1, IBM Lotus Notes, Rational Requisite Pro, Facets Trizetto,UML, RUP,MS Office, HL7, MFT, Axway, Message Broker Integration,Visual Basic, Win Runner, Facets accumulator,Test Director, Windows 2000,Java,J2EE,Oracle 9i, Citrix Met frame Server, pega and FileNet.

Business Analyst

Responsibilities:

• Performed the requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using Microsoft Visio and Microsoft suits for Waterfall.
• Prioritized deliverables, identified gaps, tracked defects, defined system requirements, created artifacts for testing and development.
• Experienced with AXWAY B2Bi environment and understanding of AXWAY protocols MFT, CFT, FTP and Sftp.
• Provided Axway mapping documents for File transfer.
• Worked with Manged File transfer (MFT) and Axway team and Integration teams to document Source to Target mapping and EDI Mapping.
• Debugging/testing the integration and map using data mapper builder, trace viewer, message log
• Setting up connectors like FTP, FILE, EMAIL, HTTP, MQ, JMS & VAN mailbox for receive/send activities
• Integrate SQL queries within maps to derive values from customer cross reference tables. e.g., charge code conversion or list of service types.
• Proficient in using EDISIM for validating customer test EDI files and also to generate test data for unit test cases
• Lead project teams and outcome for delivering the end state SaaS solution
• Good understanding of Integrations including Web Services, SAAS, Workday Architecture, Business Process Framework.
• Conducted Data Governance assessments and defined MDM/DG requirements. Interviewed senior architects and Integration analysts.
• Packaged Goods Product MDM application. Worked with key business stakeholders to define requirement
• Developed the framework, approach and plan for the data standardization and KPI's.
• Helped design the Information Assurance organization to set and maintain data quality, information standards, information flow and manage metadata across the organization along with MDM.
• Managed 4 cross-country functional BA's to develop enterprise performance measures and data standards for MDM and IDQ.
• Performs the clinical medical data coding aspects of assigned projects on a global basis using MedDRA and WHO Drug coding dictionaries.
• Performed Change Impact Analysis.
• Assisted in writing the Request for Proposal (RFP) for Enterprise MDM implementation for IDQ and Master data management.
• Responsible for on-time delivery and maintenance of project management, change management, and communication deliverables such as project plan, weekly project reporting, change charter, stakeholder analysis, RASCI chart, stakeholder assessments, training strategy and training needs assessment.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and OOD using UML.
• Enter incoming referral requests into EZCAP to generate an authorization number with paperless processing
• Understanding the AME and prepared and documented the required ASPECT Attributes list for compounds
• Worked with the following module suites: Oracle Financials (GL, AP, AR), Discrete Manufacturing (INV, BOM, WIP, Cost, PO), Supply Chain (Order to Cash, Procure to Pay, WMS), Advanced Planning (ASCP, DP, MRP), CRM, Human Resources
• Updated and enhanced multiple tracking databases, used for software license, maintenance contract, and computer equipment tracking via Lotus Notes application.
• Conducts clinical database adverse event review to ensure coded terms are clear, appropriate and complete according to established coding guidelines and conventions, using global medical data dictionaries.
• Involved in developing the UI pages using HTML, CSS, JAVASCRIPT, JSON, JQUERY, and AJAX. And used Asp.net framework.
• Lead analyst for AMISYS advance system migrations. Implementation of web-based Healthcare platform.
• Designed and tested processes and vendor integrations supporting membership, medical management, claim adjudication, and accumulator integration.
• Successfully completed system upgrades of core AMISYS system from legacy version to AMISYS advance 3.1 in 2008.
• Assisted with MedDRA and WHO Drug dictionary migration for NDA submission.
• Developed web pages using HTML5 and CSS 3 by Kendo Telerik UI
• Developed front end along with pages for user interactions; for the entire website using HTML5, CSS3, and JavaScript.
• Executed SQL queries to perform Backend Testing for Data Validation
• As a visual designer I emphasize cleanliness, readability, and objectivity in the content of an interface. I work on UX teams where I focus on making functional design elegant, visually compelling, and easy to perceive the intended interactions. These are the qualifications I possess:
• Assist and lead in the creation of inspiring mood boards and style frames.
• Translate mood boards into tangible visual design UI elements, and design comps.
• Create and produce visual assets for interactive prototypes that help iterate and evolve design concepts.
• Deliver production-ready design assets, and develop comprehensive Visual Design Standards and Guidelines.
• Work closely with Engineers and Developers during the product build to ensure design quality and integrity.
• Accurately estimate level of effort and time needed for individual design contributions.
• Manage design deliverables and track design related issues.
• Defined new validations through Angular.js for the form field validation implemented through HTML5.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Documented System requirements for Informatica data quality rules and system requirements for Information quality at source.
• Prepared the high level architecture and high level design of MDM solution for phase 1.
• Understanding the existing system's data model and interfaces for preparing the MDM logical data model and data mapping documents.
• Assisted new team members on MDM technologies and project domain.
• Involved in developing the data quality rules to find out data anomalies and missing data using IDQ tool.
• Involved in data stewardship enablement and performed data steward role.
• Followed the UML based methods using Microsoft Visio to create Use Cases, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams.
• Supported development of UAT cycle test scripts, Review User Acceptance Test Plan (UATP) and attend walkthrough
• Mapped HIPAA compliant EDI transactions for 837: healthcare claims and 835: payment advice transactions
• Created UML to ensure the business logic is clearly demonstrated to developers, created use cases to understand the narratives.
• Conducted FRS walkthroughs with technical departments to ensure design is accurate.
• Developed a file tracking application that organizes the location for all trust operations records. Used by business managers to request trust records with VB 6.0, MS Access 2000.
• Reviewed defect reporting and resolution in Mercury Quality Centre to track project progress against schedule.
• Wrote and executed system test plans, test cases and test data on MS Excel for the web-based application.
• Performed functional, smoke, regression, usability, system and integration testing.
• Identified, organized, and documented the changing requirements for the application using Rational Requisite Pro.
• Engaged in system testing during User Acceptance Testing (UAT).
• Supported the assigned project manager with creating detailed project plans and assisting in developing, scheduling and tracking project timelines.
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
• Created use case scenarios and documented work flow and business process.
• Used RequisitePro to document requirements, associated change requests with requirements and connected requirements with Use cases and Domain Models.
• Prepared the UML Use Cases using Rational Rose and Sparx architect methodology.
• Used MS Visio for flow-charting, process model and architectural design of the application.
• Documented business workflows textually as well as in UML diagrams according to RUP for the stakeholder review.
• Conduct weekly staffing calls, developed training material, lead numerous training sessions for both on-shore and off-shore resource managers and project managers, directly responsible for increased TriZetto wide services time entry compliance, project schedule design and maintenance, created data validation processes and tools
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Involved in maintaining and managing different versions of Documents using Rational Clear Case.
• Conducted FRS and URS reviews and walkthroughs with the designers, developers and stakeholders.

Environment: Waterfall, Sparx,Rational Rose, Toad, IBM Lotus Notes,Oracle E-Business Suite R12, MFT, Axway, Jira,Rational Requisite Pro, AEM 6.1, Facets Trizetto, Facets accumulator, UML, RUP,MS Office, ALM Quality Center, Visual Basic, Win Runner, Test Director, Windows 2000,Java,J2EE,Oracle 9i, Citrix Met frame Server, pega and FileNet.

Business Analyst

Responsibilities:

• Gathered requirement for the Facets implementation and performed solution analysis.
• Performed the requirement analysis, impact analysis and documented Business Requirements Document (BRD) and Functional Specification Document (FSD) using Rational Requisite Pro for Mobile website development including responsive design using Bootstrap and Zurb Foundation.
• Prioritized deliverables, identified gaps, tracked defects, defined software requirements, created artifacts for testing and development.
• Manage the creation of virtual (VMware) and physical environment builds for Trizetto clientele and manage their environment portfolios.
• Designed and developed Use Case Diagrams for the Facets Accumulator process modules and claims.
• Interacted with customers and established new corporate business. Fast paced customer service and sales driven work environment with salesforce.
• Created wireframes using Balsamiq and created User experience design using Adobe Illustrator, Adobe Dreamweaver and Adobe Fireworks
• Developed web pages in ASP.NET and used C# for code behind application programming interface.
• Developed the application using MVC 4.0 Architecture and Entity Framework.
• Used the ASP.NET server controls for the application.
• Involved in Full Lifecycle Mobile & Web Development - From Concept to Production
• Created SQL queries to perform insert, update or delete operation on MySQL database.
• Using advanced modelling features available in SAP HANA.
• Updated and enhanced multiple tracking databases, used for software license, maintenance contract, and computer equipment tracking via Lotus Notes application.
• Working on optimizing various HANA data models using best practices.
• Pushed data to SAP Design Studio to have a multiple dashboard boards on Planned Data, Actual Data and Variance Data.
• Utilized TriZetto’s Facets Accumulator Synchronization solution to
• Lead analyst for AMISYS advance system migrations. Implementation of web-based Healthcare platform.
• Designed and tested processes and vendor integrations supporting membership, medical management, claim adjudication, and accumulator integration.
• Successfully completed system upgrades of core AMISYS system from legacy version to AMISYS advance 3.1 in 2008.
• Serve as the functional team lead for the deployment of existing financial & manufacturing applications supporting corporate finance and treasury functions to newly acquired / migrated locations as well as the deployment of new financial & manufacturing applications that are required to support enhancements for existing systems. These Oracle Modules include: OTC, P2P, AP, QA
• Maintain and update EZCAP system with quarterly/annual updates to CMS' Medicare fee schedules, including but not limited to MPFS, DME, ASC, APC, etc. Maintain and update EZCAP system with all new or deleted CPT, ICD-9, HCPCS, etc.
• Manage relationships with key business owners and subject matter experts in order to regularly review customer satisfaction, project priorities, service needs, process improvements, etc.
• Gathered knowledge on Medicare Part- B, D HL7, HIPAA rules and regulations.
• Worked with customers in resolving acute issues, fixes involving Meditech (MT) software & coordinating all activity within each assigned Meditech module.
• Performed Impact analysis for readiness of ICD-10 conversion.
• Mapped HIPAA compliant EDI transactions for 837: healthcare claims and 835: payment advice transactions, Captured all HIPAA-related EDI data in the repository using FACETS, Supported integrated EDI batch processing and real-time EDI using FACETS. Accepted inbound transactions from multiple sources using FACETS.
• Collaborated efforts with technical staff and subject matter experts to establish the technical vision of product and analyze triple constraint tradeoffs.
• Analyzed business processes, requirements, and data necessary to provide detailed logic for ETL development.
• Created UML diagrams- Use Case Diagrams, Activity Diagrams, Sequence Diagrams Domain Models and ER Diagrams in MS Visio.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Conducted GAP Analysis of current state for Medicare Part-D (As-Is) ICD 9 and proposed state (To-Be) ICD 10 situations and represented the same on MS Visio.
• Supported development of UAT cycle test scripts, Review User Acceptance Test Plan (UATP) and attend walkthrough
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Recommended changes for system design, methods, procedures, policies and workflows affecting Medicare/Medicaid claims processing in compliance with government compliant processes like HIPAA/ EDI formats and accredited standards like ANSI.
• Managed the planning / test process for Medicare Part D Pharmacy Claims (PBM).
• Analyzed, maintained and updated FAQ knowledge base in SharePoint for better data accuracy and better timely data availability
• Created SAP Analysis for Office reports on OLAP using SAP BW data.
• Created SAP Analysis for office report on top of Sales data and MM data.
• Exported the SAP Analysis data to Crystal Reports.
• Exported the SAP Analysis data and saved it to PDF forms as per the client's requirement for SD reports.

Environment: Waterfall, Java, JSP, Illustration, Lotus Notes, design, adobe Photoshop, adobe illustrator, Trizetto, ASP.Net, VB.Net, Adobe Dreamweaver, Oracle Clinical, Oracle E-Business Suite R12, LIMS, CSS, cGMP, SAS, UI, Facets Accumulator, Balsamiq, FDA Regulations, Windows NT, MS Office (MS Excel for reporting), Rational Rose, Requisite Pro, Xcelys.