SUMMARY

• Overall 8 Years of Industry experience as a Sr. Business/Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Mapping, Data Profiling, Data Modeling and Business Intelligence.
• A successful Business Systems Analyst and a proven track record in Information Technology, providing business solutions for client/server, web - based and Service Oriented Architectures (SOA).
• Extensive experience working in diverse business and technical environments and possess domain knowledge in Financial, Insurance Claims with Reporting and Analytics.
• Expertise in Software Development Life Cycle (SDLC) including Waterfall, Agile, Rational Unified Processing (RUP), Unified Modeling Language (UML), QA methodologies and defect management.
• Professional experience working closely with clients on large-scale collaboration and content management projects; communicate and present concepts and deliverables to clients.
• Proficient in conducting Requirements Elicitation Sessions understands BI Implementation and Data Lineage processes and can provide Data Governance and Deployment strategies for new/sustaining development.
• Extensive experience in system analysis, master data management, troubleshooting data dependencies, review data loss, data inconsistencies and documenting RCA - root cause analysis for systematic procedures in problem identification through technical expertise and provided architectural information to Master Data Management to EDW teams
• Worked with stakeholders to develop Collibra Data Governance, Risk Management and Compliance blueprint for success and architecture.
• Certified Collibra Data Governance LEVEL 1 consultant.
• Extensive experience in the field of Business Analysis, working with the technical resources to implement management business requirements into the software application in Healthcare, Insurance, financial industry.
• Experienced in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Subject matter expert on the Collibra Metadata Tool (Data Governance tool).
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• It includes analysis and establishing requirements for tools supporting clinical operations, integration needs, regulatory needs, reporting needs etc.
• Successfully worked closely with business, PMOs and IT teams on applications in areas of R&D Business technology.
• Strong fundamentals in Investment Banking and Capital markets.
• Certified Level 1 certified.
• Understanding of SDLC- methods; Agile methodology; Application Lifecycle management (ALM); Change management and Service management (SMLC).
• Facilitation of software release lifecycle. 24/7 Support availability as required.
• Derive BRD and FRS documentation; Ad-Hoc reports; SOP’s, Release notes
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Document business diagrams and Use Cases using UML. Business Processes models (BPMN).
• Understanding of Clinical Trial phases; systems validation Data domains; ICH - GXPs, 21CFR-part-11; CDISC data models; MedDRA terminology in preparation for FDA-NDA submissions. IDMP - ISO norms (EMA) ;HL7.
• Familiar with claims processing; Facets-HMS; ICD-9/ICD-10. PHI; HIPAA.
• Working knowledge of ETL process; Database concepts; Data mapping, analysis and reporting.
• Quick adaptation to various lines of business, assess information into systems definition.

TECHNICAL SKILLS

Modeling Tools: UML,BPMN, MS Visio, Rational Rose, MS Project

Concepts: SDLC (RUP, Agile, Waterfall), SMLC; change Management; SWOT, Cost-Benefit; Six-Sigma, Quality and Risk Management (QRM)

Applications/project Management/ Version control: Version One, EAPM; CA Clarity, JIRA, confluence MS project; Quality center; Requisite Pro, Clear Quest, Clear Case ;

Database understanding and Environment.: RDBMS; MS SQL Server/ Oracle clinical; OIM/IAM, SAS, C, C++, HTML,XML,XSL; XL Miner; IAM, Active Directory Query, TFS/Final Builder; Share point, Share point Designer; Office 365; InfoPath

Testing Tools: SQUIDS,QTP,QC Win Runner, Load Runner.

BI Tools: Business Objects, Tableau 9.1, Advanced Excel, Power Pivot.

Change Management: Clear Case, SharePoint, Doors, RequisitePro, StarTeam.

Service Management; Release management: ServiceNow; CA Service Desk; Enterprise Turn Point (ETP); Serena Release Manager.

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. Business Systems Analyst

Responsibilities:

• Responsible for the management of the software process from requirements gathering, documentation, management approval, client approval, development, to testing and final presentation to the client.
• Responsible for Requirements Elicitation, documentation and sign off for UI enhancements and implementation of Box code with Mendix platform.
• Performed GAP analysis on existing architecture and services code and created a traceability matrix for requirements and rapid application development code for Mendix code leverage and rich UI development.
• Worked with integration partners and documented business scenarios for DocuSign and Office365 integration on Mendix platform, I was the subject matter expert for Claims Submissions and workflows.
• Performed data preparation steps including data extraction of target data from multiple databases, integration of multiple datasets and creation of derived variables, application of business rules and wrote Use Cases for quality control checks to help QA teams.
• Worked in environment - driving business outcomes in Agile ways of working.
• Participated in manual testing including System, End-to-End, Regression and User acceptance testing.
• Provided Analyst support across all Software Development Lifecycle phases and created deployment plan.
• Created Requirements Traceability matrix using Confluence and integration with JIRA, created JIRA Dashboards to demonstrate project tracking, customer reports, status reports, iteration burndown, etc.
• Coordinated UAT test efforts, worked with release engineering teams on defect fix and code migration to higher environments, re-testing defect corrections and approvals.
• Worked in Agile framework for product development and delivery, performed user story documentation, elicit requirements in story documents and story mapping with functional requirements-FRD.
• Used AgileScrumto createuser stories, specify acceptance criteria, groom product backlog, and participate in Sprint events.
• Acted as the liaison between the business and the technology area to implement software upgrades, create new reports, document business use cases, conduct user acceptance testing, and design future enhancements for the migration to Medix platform platform.
• Collaborated with functional analysts and actuarial teams to document mock-up screens and developed UI specifications with page navigations and content managed by Development teams for UI development.
• Created Page Templates, Layouts and Themes for UI framework for UI Development team and QA testing.
• Used JIRA for User Story preparation, tasks for development and QA, managed product backlog for iterative development and focused for March 2017 planned release into production.
• Managed Product backlog, release work items in Jira, reported to senior management using Dashboards..

Confidential, Charlotte, NC

Business System Analyst / Project Management

Responsibilities:

• Responsible for requirements documentation, review, management and Manage against proposedtimelines/project plans.
• Helped Confidential business units implement long term strategic metadata strategies that align with thecompany’s enterprise level data strategy and support of the company’s regulatory guidelines.
• Guided business partners thru the on-boarding of metadata into the Enterprise Data GovernanceCenter(EDGC).
• Implemented Collibra Connect Integration templates and workflows.
• Experienced in integrating data from varied systems to CollibraDGC using Mulesoft.
• Worked with the business partners and understanding their business processes and metadata, I was ableto build a trusting relationship with the Reporting Mapping and Issue Identification Initiative(RMII) team.
• Used the SDLC processes to complete all project requirements, documentation, testing, andcommunication.
• Guided RMII business partners, FDSS Business Systems Consultants(BSC) and technical developersthru the ‘RMIICollibra to Tableau POC’ to determine if RMII Overlap reports could be created using theCollibra Connect API with Tableau.
• After engaging in an Agile project, the FDSS BSC and technical developers successfully created aworking process that used Collibra Connect to extract data from EDGC and provide that data to theTableau reporting server.
• By accomplishing this, the RMII Tableau report developers were able to create 4 working reports for theRMIIbusiness partners.
• The findings of the “RMIICollibra to Tableau POC” were presented to management and are reviewed for its strategic implementation.
• Project was successfully completed and released into the Production environment
• Subject matter expert on the Collibra Metadata Tool
• Responsible for requirements gathering, requirements documentation and creating Agile User Stories for enhancements to business rules.
• Created User Acceptance Test cases, user stories and Acceptance criteria documents.
• Responsible for managing and maintaining relationships with clients as they pertained to new enhancements, GAP analysis, monthly reporting, and current expectations.
• Identified client training needs, created the training plans, developed training materials and conducted training sessions that drives system adoption.
• Ability to work with all members of the project team, following the project through the Systems Development Life Cycle and ensuring that business objectives are met.
• Maintained Issues Tracking Worksheet to track issues and rectify it accordingly and used HP ALM for Defect Management and performing User Acceptance Testing.

Confidential

Business Systems Analyst

Responsibilities:

• Responsible for managing and maintaining relationships with clients as they pertained to newenhancements, GAP analysis, monthly reporting, and current expectations.
• Responsible for the gathering of requirements, from clients, completing business analysis, and writing of the Data Dictionary, Preliminary and Final Function.
• Understand user expectations and develop functional requirements and raises clarifications with stakeholders.
• Knowledge Transfer to the development team on Functional Specifications.
• Trained developers on functional concepts and resolve functional problems faced.
• Acted as SPOC for business requirements and represented the end user in the development team.
• Lead and conducted functional testing thereby responsible for certification of product release before user acceptance.
• Understand Agile practices (daily scrum, iteration planning, retrospective, test driven, model storming) and follow the same.
• Work with Compliance and Regulatory operations to follow and monitor different IT process.
• Wrote Functional Specifications for a large domestic fixed income system.
• Responsible for the management of the software process from requirements gathering, documentation,management approval, client approval, development, to testing and final presentation to the client.
• Provided consulting services to external clients and generated actual revenue equal to 235K.
• Performed manual testing including System, End-to- End, Regression and User acceptance testing.
• Provided Analyst support across all Software Development Lifecycle phases, and created deploymentplan.
• Created Requirements Traceability matrix using Confluence and integration with JIRA, created JIRADashboards to demonstrate project tracking, customer reports, status reports, iteration burndown, etc.
• Coordinated UAT test efforts, worked with release engineering teams on defect fix and code migration tohigher environments, re-testing defect corrections and approvals.
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, SequenceDiagrams, OOD using UML tools.
• Acted as the liaison between the business (fixed income) and the technology area to implement softwareupgrades, create new reports, document business use cases, conduct user acceptance testing, anddesign future enhancements for the trading platform.
• Worked closely with traders, portfolio managers, the equity and fixed income support team, projectmanagers and developers to enhance functionality and to correct problems with fixed income, equity andderivative trade related systems.
• Worked with Portfolio Management/Accounting system: Portia and handled Corporate, Municipal,Treasury, Agencies and High Yield Traders.
• Worked with Fixed Income Trading System: Bloomberg Portfolio System and handled Corporate Bonds, Mortgage Backed Securities (MBS), Asset Backed Securities (ABS), Inflation-Linked Treasury Bonds (TIPS), Municipal Bonds, Warrants and Preferred Stock,
• Work includes enhancement topics such as: Uploads, downloads, Auto Pair off Financing (repurchase agreement / Repo) transactions, and the calculation of Interest, Expense, Accretion, Amortization &; cost of carry, as they pertain to Mortgage Backed Securities (MBS) and Management Reporting.

Confidential

Business/Data Analyst

Responsibilities:

• Involved in all phases of software development life cycle (SDLC) in RUP framework. .
• Analyzed the current billing and claims data provided from existing BRD’s (Business Requirement Document).
• Provided input to the HEDIS system that used Quality Compass to provide a selection base for various healthcare plans.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality.
• Have considerable expertise in Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).
• Strong experience in the Data Analysis, Data Profile, Data Quality, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Involved in Design mappings, created data flow diagrams and documented the ETL high level and low level design approach.
• Experienced in utilizing statistical tools like SAS, SPSS, MS office suite, MS projects, MS Visio and requirement management tools.
• Experienced in Data profiling, validating, monitoring and cleansing across the enterprise through Informatica Data Quality (IDQ).
• Strong understanding of various PMO techniques used in SDLC such as Rational Unified Process (RUP), Waterfall, Agile and SCRUM with hands on experience in each of them.
• Daily validation of batch files for Enrollment and Billing and discussing error with internal and external parties.
• Experienced with TriZetto Facets Application Groups: Claims Processing, Guided Benefit Configuration, Medical Plan, Provider, Subscriber/Member, Utilization Management.
• Worked on HIPPA compliance as well as strong knowledge of Medicare (Parts A, B, C, D) & Medicaid, NCPDP Version D.0, FACETS, EDI, HL-7, CPT and ICD-10 codes.
• Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrollment hence analyzing and documenting related business processes.
• Worked within a growing knowledge of X12 4010 HIPAA 837 I, P, D, 835, 834, 820, 270, 271, 276, 277, 278, EDI, Privacy, Security, and Medicaid.
• Defined, developed specs for federal reporting specific to Medicare Advantage.
• Conducted ICD-9/ICD 10 conversion analysis through ICD 9 and ICD 10 proposed mapping documents and HIPAA 5010 system capabilities of EDIFECS tools. Update mapping documents as required for version upgrade and change requests.
• Recommend tactic to implement HIPAA 4010 ( EDI X12 837,834,278,270) in the new System.
• Involved in mapping and validation of different EDI transaction used for claims filing like ANSI X12 837 (I, P, D) for claim submission, ASC X 12 270/271 for the eligibility/benefit inquiry and response, ASCX12 276/277 for the claims status enquiry and response and ASCX12 835 for the healthcare claim payments.
• Experience in validating and driving the requirements for the conversion of the HIPAA 5010 from HIPAA 4010, this new NCPDP Upgrade supports the HIPAA mandate to be fulfilled for all the EDI transactions i.e. Claims, Claim Status Inquiry/Response, and Payment Remittance etc.
• Created Gap/Impact Analysis Document for changes of the EDI Transactions (837, 835)
• Developed straightforward DBMS queries, knowledge of HL7 and XML interface messaging.
• Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose/MS Visio/BPMN towards facilitating clear understanding of the business process.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Developed an implementation guide for Partners for EDI X12 transactions such as 834, 835,837,270 and 271.z
• Performed AS IS and To BE analysis for EDIFECS Standards- HIPAA 5010 Database Setup for new version releases.Documented proposed changes and coordinated development, testing and production release environments, includingend-to- end testing.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera,Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modelingand Design.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on RUP methodology.