System/data Analyst Resume
Eden Prairie, MN
SUMMARY:
- Experienced Business Analyst with proficiency of Agile Scrum and Waterfall methodologies.
- Highly effective communication skills with strategic solutions. Ensured alignment to the strategic vision and enterprise systems plan.
- The Lead Business Analyst provided guidance in formulating new requirements, and aim to improve business processes by developing creative and alternative approaches to solving business problems and identifying business strategies, issues and opportunities, while assisting business partners in identifying and prioritizing new initiatives and capabilities.
- Coordinated with Project Managers in the development of detailed project plans and work assignments while monitoring progress to ensure project deliverables are met.
- The Lead Business Analyst assisted in developing test cases and participated in the quality assurance process to ensure that requirements are properly implemented while producing user training documentation and working with the business to train users.
- Created Tableau dashboard reports for collaborating with developers. Quick learner, self - starter, Life Long Learner. Ability to adapt Gherkin language.
TECHNICAL SKILLS:
Tecnical skills: Windows 9x/NT/2000/XP MS Office Suite. HP ALM. MS T - SQL, Oracle PL/SQL, SAP ERP, Business Objects, Crystal Reporting, SDLC. HL7 interface., SAS, MS BI, SSIS, SSRS, SSAS, ETL Tools, Jira, CA Rally Tool, Oracle OBIEE 11g, Peoplesoft ERP, Sharepoint 2010, Excel VBA, Pivot Tables, MS Visual Studio. MedNet. Epic Clarity. MS Dynamics CRM/XRM, MS Dynamics AX, MS Project. WebEx. MS TFS. TriZetto Facets, Pega Systems. PACS. Tableau 9.2 HTML5, CSS3, Java, JavaScript, SOAPUI, REST, JSON XSD, XML, XHTML, XPath, UI/UX Design, API Web Design. .Net MVC5. Casewise Modeler, CA Erwin. Vision Tracker. IBM Websphere. Xamarin Mobile. UML Data Modeling. Balsamiq Wirefarming Mockups.
Business Skills: ICD-9, CPT, PHI, HIPAA Standards, JCAHO Standards, Clinical Laboratory Setting. ITIL Framework, TQM, Lean Six Sigma. Quality Management. CMS guidelines. ISO 9000, DMAIC, BPM, RSA, EDI Edifact/ X12, ANSI/X12, Agile Scrum, Waterfall, RUP, UML. RSA. HEDIS. IIBA BABOK. Certified Scrum Master. IIBA CBAP Training. TOGAF framework, Zackman. Quality Measures (HEDIS/NCQA) in Healthcare industry. SAFe Agile.
PROFESSIONAL EXPERIENCE:
Confidential, Eden Prairie, MN
System/Data Analyst
Responsibilities:
- Extracted data from SQL Server and DB2 using SSIS packages to load it into data warehouse repository.
- Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
- Created a relational model and dimensional model for online services such Clinical EMR records.
- Worked with the business product owners and Data Architects to understand new functionality of EMR.
- Understood logical data models and physical data models using ER-Studio and EMR Salesforce.
- Collaborated with data architects for data model management and EMR Salesforce Objects.
- Collaborate closely with ETL developers on technical specification for integration component development.
- Analyzed requirements and demonstrate problem understanding, model data management and design data.
- Liaise between Subject Matter Experts, Data Analysts, Analytic experts, Engineering teams, Architects.
- Develop data integration components and collaborate with ETL developers on ETL map target to source.
- Clinical Care Data Warehouse standards and processes for Client's Enterprise Data Warehouse architecture.
- Experience in designing & developing logical & physical data model using data warehouse methodologies
- Captured technical metadata through data modeling tools and data profiling and gap analysis
- Good Analytical skills are required to identify discrepancies in the data before loading in Data warehouse.
- Translated data needs into including models, conceptual design diagrams, user stories to support iterations.
- Effectively communicate with product team and support Engineering team during development cycle Agile.
- Discover insights and opportunities using statistical, data mining and visualization techniques.
- Documented and communicate findings, verbally and visually, easily understood by business partners.
- Worked with the business product owners and Data Architects to understand new functionality Data lake.
- Developed detailed source to target data mapping and data transformation rules for data modeling.
Confidential, Eden Prairie, MN
Technical System Analyst
Responsibilities:
- Evaluated requirements and prepare detailed technical user stories in CA Rally Tool for Developers.
- Experienced with XML, XML Schemas, XSLT, XPath, SOAP, REST, JSON, WADL and WSDL.
- Documented new APIs / Services and modify existing ones after evaluating the following database models.
- Created new and maintain existing documentation related to web processes and functionality and servers.
- Reviewed recommendations on existing implementations with developers and application architects.
- Collaborated with QA team to ensure testing efforts align with system deliveries and business processes.
- Collaborated with product owners and software engineers to develop test scenarios for agile scrum team.
- Designed and implement product features in collaboration with business and IT stakeholders
- Participated in strategic decisions regarding enterprise architecture for technology domains.
- Conducted technical analysis within requirements context, diagrams and documents formats.
- Worked closely with executives and subject matter experts to establish portfolio architecture strategy.
- Delivered solution blue prints and architecture roadmaps for various business capabilities solutions.
- Provided database support evaluating existing systems and providing recommendations.
- Simplified changes to product portfolio to improve competitive position and product performance.
- Directed change management analysis to investigate and identify impact of changes.
- Performed high level management responsibilities for the SharePoint platform for project.
- Worked with custom development team to ensure accurate & on time delivery of solution.
- Experienced writing Functional Specification Documents (FSD’s) and Technical Specifications Doc.
- Ability to design a new feature in Balsamiq wireframing for annotated screen mockups and sitemaps.
Confidential, Minnetonka, MN
Business Data Architect
Responsibilities:
- Worked business boundaries to drive commonality and reusability in solutions to real-world problems.
- Participated in strategic decisions regarding enterprise architecture for technology domains.
- Conducted technical analysis within requirements context, diagrams and documents formats.
- Worked closely with executives and subject matter experts to establish portfolio architecture strategy.
- Delivered solution blue prints and architecture roadmaps for various business capabilities solutions.
- Reviewed recommendations on existing implementations with developers and application architects.
- Provided database support evaluating existing systems and providing recommendations.
- Facilitated solutions that serve the enterprise mission of modernization and simplification.
- Collaborated Clinical Service Domain in Enterprise Architecture and Infrastructure teams HEDIS.
- Facilitates changes to product portfolio to improve competitive position and product performance.
- Ensured solutions developed across organization are aligned to enterprise architecture standards.
- Guidance of business architecture to effectively business strategy financial targets (cost and benefits).
- Ensured requirements are in alignment with business strategies and architecture roadmap/framework.
- Directed change management analysis to investigate and identify impact of changes.
- Performed high level management responsibilities for the SharePoint platform for project.
- Worked with custom development team to ensure accurate & on time delivery of solution.
- Articulate business requirements and architect complex solutions leveraging Salesforce.com
- Design and end to end delivery of multiple complex salesforce.com projects on CRM platform.
- Translated requirements into Solutions with proper strategic development in MS Dynamics CRM .
- Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model design.
- Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing
- Created and implemented ER models and dimensional models (star schemas) generated SQL scripts.
- Worked with the business product owners and Data Architects to understand new functionality Data lake.
Confidential, Eden Prairie, MN
System Analyst
Responsibilities:
- Ability in Requirement managing and documenting business specifications with UML method.
- Organized, facilitated, scheduled and managed highly complex project schedules, prepared project.
- Created actual reports and effectively communicated all levels of organization for business solution.
- Developed strategies on SDLC phases including Requirement Analysis for UAT testing.
- Conducted technical analysis within requirements context, diagrams and documents formats.
- Validated requirements with stakeholders and the project managers, provided suggestions.
- Conducted change management analysis to investigate and identify impact of changes.
- Translated business needs into application design and developer coding review documents.
- Acted liaison between business and system analysts, developers and project managers.
- Traceability matrix of test cases to corresponding requirements and process of solutions.
- CSP Facets automating the existing enrollment systems for NJ Dual SNP HEDIS Medicare.
- Worked with business and technology to determine product future direction to product inquiries.
- Good understanding of SharePoint customizations using SharePoint for project update.
- Provided business analytical support with OBIEE and data warehousing solutions.
- Configures PeopleSoft HCM 9.2 and supports development efforts to validate functional requirements.
- Prepared dashboards report using Tableau tools data and the integration process.
- Created integrations between technologies via APIs and web services with both new and existing web.
- Expert in data analysis and looking for data trends and reporting results and writing analysis reports.
- Managed complex business initiatives to balance requirements for functionality, efficiency and quality.
- Developed detailed source to target data mapping and data transformation rules for data modeling.
- Presented and evaluated design solutions objectively and facilitate conflict resolution for the project.
- PeopleSoft modules with 9.2 upgrade will impact the new Contract Management functionality users.
- Configure the PeopleSoft 9.2 system to meet each client’s unique business requirements.
Confidential, Burnsville, MN
Data / System Analyst
Responsibilities:
- Gathered and validate requirements with stakeholders through User stories and personas.
- Organized, facilitate, schedule and manage highly complex project schedules, prepared project.
- Agile Scrum framework supporting backlogs prioritization and grooming sprint retrospectives.
- Constructed reports from data to analyze with SAP Business Objects and Crystal Reports.
- Provided support throughout the EHR implementation life-cycle post Go-Live support.
- Assisted project team members with the design and development of Clarity reports.
- Worked closely with stakeholders to translate their business need into technical specifications.
- Facilitated the business requirement process using JAD sessions, workshops and interviews.
- Participated in the gathering and documenting of requirements from SharePoint users.
- Performed high level management responsibilities for the Vision Tracker platform for project.
- Facilitated requirements analysis for solutions and improvements based on SharePoint.
- Provided full SDLC for SharePoint sites and applications to support project objectives.
- HEDIS ownership of managing quality data and interventions for defined markets opportunities.
- Defined best practices for creating Tableau dashboards by matching requirements to the charts to be chosen.
- Administered and analyzed the reporting and analysis development, implementation and changes.
- Per the enterprise objectives using SQL business model and mapping layers.
- Experienced with medical imaging domain knowledge including: DICOM, HL7, HIS, RIS, PACS, EMR.
- Ability to learn and support DICOM, PACS and their connectivity/integration issues with our software.
- Monitoring equipment, data analysis system, MedNet platform for heart tracker devices and PCI.
- Conducting basic Mednet Access troubleshooting and perform other duties as assigned as time.
- Ability to manage complex business initiatives to manage project for functionality within Vision Tracker.
- Define UI/UX Design features for software to help facilitate application integration and improve usability.
Confidential, St Paul, MN
Clinical Business System Analyst
Responsibilities:
- Worked with interfaced practice and EHR systems, uploaded reports directly to systems.
- Collaborated on applications design and effective implementation of applications.
- Provided full life cycle support for PeopleSoft maintenance applications and upgrades.
- Experienced with complex data mapping requirements specifications for both EDI transactions.
- Assisted team members and end-users in the design and development of Epic Workbench Reports.
- Solid understanding Software Development Life Cycle (SDLC) phases and UAT.
- Knowledge and appreciation of business concepts with detailed requirements gathering report.
- Designed and created reports for internal and external clients based on business requirements.
- Claims validation in Facets application which includes claims pending status, member status etc
- Investigated and developed necessary design work reporting capabilities per organizational need.
- Analyzed and synthesize business requirement documents for finding solutions.
- HEDIS project Processing, tracking and organizing incoming Medical Records for patients’ data.
- Connected Tableau server with share-point portal and setup auto refresh feature.
- HEDIS reporting from data systems VIPS mainframe environments for quality improvement. Provided support
- IT and Imaging teams on administering PACS system and DICOM related upgrades.
- Supported for installations and maintenance on medical devices per organizational needs.
- Assured successful conduct of assigned clinical programs consistent with R&D systems.
- Defined requirements in Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
- Conducted IT Reviews of the gathered requirements with the Enterprise Interface IT Partners.
- Ensured that the compliance requirements identified by Data Privacy in Vision Tracker.
- Extracted data from SQL Server using SSIS packages to load it into a single data repository.
- Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
- Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model design.
Confidential, Bloomington, MN
Business Analyst
Responsibilities:
- Excellent leadership skills included performing a variety of software testing SLDC.
- Performed system, unit, acceptance, regression, load and functional with performance testing.
- Applications testing used both automated and manual testing methods.
- Validated project business requirements for System and System Integration testing.
- Excelled in findings, documenting and reporting for bugs and errors.
- Reviewed Peoplesoft applications for overall business process control. 9.0
- Leveraged knowledge of object-oriented to help validated and verified all the projects.
- Component assignments and then coordinating JAD sessions for business value and need.
- Gathered BRDs and FSD coordinated development and testing activities until final release.
- Developed data mapping, designed data warehouse systems for data integrations ETL tools.
- Designed and created customized reports and dashboards on the CRM platform in salesforce.
- Functional and technical expert for PeopleSoft HCM and ELM applications functionality.
- Lead BSA with technology centric client solution scoping calls & other meetings.
- Ensured that designing, recovery and implementation of an OBIEE platform is carried out effectively.
- Agile legacy system analysis and integration modeling all data sources along with mapping.
- Track and monitor projects by creating queries and dashboards using the MS Dynamics CRM.
- Articulate business requirements and architect complex solutions leveraging Salesforce.com.
- Developing testing strategies, coordinating testing, deployment activities, coordinating and conducting UAT.
- Experienced in maintaining and keeping traceability matrix and reporting requirement/project status.
- Ability to manage complex business initiatives to balance requirements for functionality, efficiency and quality.
- Developed detailed source to target data mapping and data transformation rules for data modeling.
Confidential, Minneapolis, MN
HR processes analyst
Responsibilities:
- Assisted with and coordinates the data collection for chart audits and quality reviews as assigned.
- Established and maintained accurate and confidential client reporting system.
- Documented all clinical data Including medical procedures and medications.
- Responded to EHR tasks and assisted patients regarding health information in a timely manner.
- Assisted in the release of medical information and ensured per HIPAA guidelines.
- Followed-up with CMS insurance carriers on unpaid claims to ensure full payment is received.
- Billing and collection of all third-party insurance carriers and private payer sources.
- Analyzed and interpreted explanation of benefits statements and electronic remittance advice.
- Ensured compliance with enterprise Information Management standards and processes.
- Informed provider when diagnostic studies are completed, prepare for review, and document in EMR.
- Ensured that designing, recovery MS Access and maintain database management.
- Thorough knowledge of state and federal regulations as they pertain to health informatics.
- Working knowledge of the Quality Assurance process in the long-term care/subacute setting.
- Documented information captured and reviews with Nurse Clarifications are resolved issues.
- Responsible to maintain the patient health information and ensuring that is complete and accurate.
- Provided access to medical record information through release of information processes.
- Respond to staff requests for patient records by retrieving and delivering medical files records.
- Perform chart constructions and use the department's computer system to compile information.
- Located records which have been checked out or are missing for safeguarding patient records.
Confidential, St Louis Park, MN
Claim Analyst
Responsibilities:
- Collections in a Medicaid/Medicare environment and worked with encounters for Resolutions.
- Medical coding reviewed patient records and assigned codes with ICD-9 and CPT standard.
- Submitted claims to insurances and Processed payment from insurance companies.
- Ensured Healthcare Maintaining Organizations are reimbursed for all procedures.
- Researched, corrected and re-submitted rejected claims for encounters.
- Submitted all claims to CMS insurance carriers and private payer sources either electronically.
- Created mapping requirements specifications for both Transactions EDI.
- Navigated the location-specific Electronic Medical Record system to input documentation.
- Analyzing clinical documentation; assigns appropriate diagnosis and procedure codes.
- TriZetto integrated healthcare solutions that help payers achieve efficiency and profitability.
- Hospital billing application analyst with experiences in all aspects of Epic EMR billing system.
- HEDIS Medical data management and reporting strategy related improvement action plans.
- Sent correspondence to CMS to gather information or provide updates for corrections.
- Reviewed enrollment/eligibility submissions to identify any missing data to validate information.
- Dedicated to providing a secure, effective, integrated patient data and financial data delivery system.
- Collaborating with business partners and end users to design, build, test, train, implement, evaluate.
- Reported and resolve all High Cost Outlier claim denials for HMO and Commercial Insurance Carriers.
- Reviewed ageing reports to ensure all accounts are being worked to payment with resolutions.
- Ability to recommend customization of the application for unique department scenarios. build application tools with minimal assistance from team members and the application manager.
Confidential, MN
Application Analyst
Responsibilities:
- Delivered world-class customer service and built customer satisfaction and loyalty.
- Handled a high influx of inbound calls within a dynamic call center environment.
- Responded to customer inquiries and requests and resolved issues efficiently and professionally.
- Multiple call center support applications to efficiently assist customers and agents.
- Help Desk, contributed training and acquired skills within a Technical Support.
- Provided leadership and demonstrate influence management to drive results within teams.
- Resolved all customers’ billing issues by listening and guiding into good directions.
- Understood all call center software applications with high customer service techniques.
- Helped customers for delinquent and written off accounts collected debts.
- Provided telecommunications and computer-related training and assistance.
- Assisted sales management to create processes in salesforce.com to help monitor activities, trends.
- The Salesforce translated requirements into technical solutions to meet the business objectives,
- Ensured robust controls are implemented, and drive consistency and best practices in CRM platform.
- Troubleshoot technical issues and identify modifications needed in addressing the issues.
- Delivered quality customer support of business technology applications in collaboration with IT team.
- Developed strategies to improve service development life cycle and application governance processes.
- Monitored application incident queue, resolved issues, and coordinated problem resolution with leaders.
- Maintained strong working relationships with business technology personnel and business technology vendors.
- Supported processes and procedures of governing Change and Release application administration system.
- Actively participates in facility support through solution implementation, activation, and post-live support.
- Analyzed customer payment reports against projected cash, to find discrepancies and take steps to correction.
Confidential
Business Analyst
Responsibilities:
- Provided leadership and demonstrate influence management to drive results within teams.
- Business processes and translating supported and leveraged with the appropriate technology.
- Estimates, technical configuration and development between the application outsourcer.
- Determining if solutions being developed business units have applicability and processes.
- Understood all call center software applications with high customer service techniques.
- Provided telecommunications and computer-related training and assistance.
- Worked with business users to gather requirements and translating into functional specifications.
- Implementing reservation and ticketing systems for improvement, customer loyalty program.
- Worked with the business to create user training materials and train the trainers.
- Ensured that the compliance requirements identified by Data Privacy and Practices in business.
- Business and IT teams to ensure functionality is delivered planning and implementation methods.
- Testing; technical documentation for business processes as defined in the methodology.
- Tracked Project Requests in the Enterprise Releases and helped resolve issues/risks arising out of it.
- Supported in creating Test Plan and Test cases for the application in environment using Quality Center.
- Communicated design patterns and best practices in service oriented analysis, design and development.
- Developed detailed design specifications including service models and message schemas.
- Worked closely with business teams to strategize solutions that support long term business objectives.