Business System Analyst/data Analyst Resume
Michigan, TroY
PROFESSIONAL SUMMARY:
- Over 9 years of experience in Business Systems Analysis and Project Management working in the Banking, Healthcare and Finance Domain. Well versed in Software Engineering methodologies - Agile using SCRUM (certified), Product Owner (certified) Test-driven development, Iterative development, Kanban and traditional Waterfall. Experienced in working with clients to implement requirements and in providing team leadership for development support teams comprising of the client and third party contract staff. Excellent work ethics and analytical skills coupled with excellent communication, written and interpersonal skills describing a committed team player. Extensive experience working with users, technical teams, project managers, SMEs, as well as senior management.
- Proven ability to work in an extremely fast paced environment, meet deadlines, and perform at high standards with limited supervision, including an ability to manage project teams located across multiple delivery sites.
- Thorough understanding of software development methodologies such as Waterfall, RUP Iterative System Development Life Cycle process, Agile/Scrum iterative development and Hybrid Model.
- Experience with claims process and adjudication in the Medicare Part A, B, C and D, Medicaid and Private Insurance Sectors.
- Experience on HP-Quality Center, HP-ALM and for Testing Quick Test Pro and Automation testing.
- Strong knowledge on ICD 9 and 10 and with claim processing.
- Experience as a business analyst, quality analyst, project manager, product analyst or product manager for an online / web organization.
- Experience in eliciting/extracting detailed business requirements from customer/project stakeholders or system artifacts .
- Good Knowledge and Experience on API’s for integrating applications for SOAP Webservices and REST Webservices.
- Helped them understand the development methodologies such as TDD, BDD and ATDD .
- Good knowledge on Devops on continuous integration/continuous improvement.
- Experience on Tools like Confluence, JIRA, RALLY and Sharepoint .
- Experience on Cyber security tools like CA Siteminder , Identity Access manager .
- Experience in Functionality Testing, Black Box Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, Performance Testing and Maintenance testing in different projects.
- Experience in Software Development Life Cycle (SDLC) methodologies and techniques.
- Experienced in creating Specifications and designing Conceptual, Logical and Physical Entity-Relationship diagrams.
- Experience in Capital market, Wealth management, share market, derivatives, bonds and FIS.
- Worked on visualizing and analyzing the data using Adobe target and analytics with the marketing team.
- Experience in web based applications and web analytics to improve the systems development have knowledge on CCAR.
- Experience in Impact Analysis, Cost-Benefit Analysis, Gap Analysis, and SWOT Analysis to check a project’s feasibility.
- Experience in Client side validations, Server side validations, Object oriented and web based applications.
- Experience in Devops on Configuration management, continuous virtualization and continuous testing.
- Professional expertise in working with multiple teams on different levels of Scaled Agile Frameworks (SAFe).
- Facilitated scrum ceremonies such as Product Backlog meeting, Daily Scrum meetings, Sprint Planning meeting, Sprint Review meeting and Retrospective meeting and Extensive knowledge in maintaining Product backlog, Burn down chart and Team Velocity. Sound understanding of Microsoft Technologies.
- Experience with scrum techniques such as Poker planning, MoSCoW, INVEST, T-shirt size, Silent writing, Nudging, Modelling behavior, Relative Mass Valuation. Sound understanding of PLM..
- Worked in complete project life cycle of Analysis, Design, Implementation, Functional and Regression testing.
- Experienced in conducting JAD session, SWOT ANALYSIS, interviews, USER STORIES and requirement workshops with business to gather requirements.
- Experienced in working with Waterfall, Agile Scrum, Rational Unified Process (RUP) and Waterfall Scrum methodologies.
- Worked on HIVE for analytical processing and MAPREDUCE for processing different languages.
- Experience on YARN Resource management and HDFS for storage of the data
- Created Wireframes, mock up screens and performed impact analysis.
- Experienced in documenting Unified Modeling Language (UML) diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, Data Flow and Business Flow Diagrams, CRUD charts , RACI charts , document requirement using MS Visio and Rational Rose.
- Extensive experience in Change Management, Participating in Change Control & Impact Analysis.
- Proficient in using MS Visio, Rational Rose and UML for generating Use Cases, Class Diagrams, Entity relationship (ER), Sequence Diagrams, Activity Diagrams, KPI’s and Collaboration Diagrams.
- Good knowledge on SalesForce and Enterprise SaaS customer relationship management (CRM).
- Experience in EDIx12(Enterprise data interchange) and EDIFACT (Enterprise data interchange for administration, commerce and Transport).
- Extensive implementation knowledge of Databases, Data table structures, Datawarehousing, Schemas, Data Marts, OLAP operations like rollup, drill down, slicing/dicing, Star Schema, Snowflake Schema and Galaxy Schema using BI tools.
- Knowledge on JDBC and ODBC.
- Knowledge on IBM Curam business architecture with JAVA J2EE 3 tier architecture.
- Experience in creating SQL queries/ SQL scripts for data analysis including triggers procedures.
- Involvement in Data Mining / Dimensional Modeling, Database Debugging, ETL process and Business Intelligence Reporting using Tableau Desktop 8.2, IBM Cognos, Spotfire, Informatica Power Center.
- Solid understanding of SOAP & REST Webservices and other internet protocol suite like HTTP, TCP, FTP.
- Extensively interacted with the designers, developers to ensure functional implementation of business requirements and the QA team in executing Test Plans, Test Case scenarios, Test Logs, Test Objectives.
- Sound knowledge on various Amazon Web services tools like EC2, Elastic Bean Stalk, AWS Lambda and also storage file system and databases like S3, Glacier, Elastic cache and RDS, Dynamo DB, Redshift.
- Experience on Big Data tool like Hadoop on classifying the structured, semi-structured and unstructured data using FLUME and SQOOP Hadoop.
TECHNICAL SKILLS:
SDLC: Waterfall, Agile, Scrum, TDD, RUP, SAFe, RAD, Kanban
Modelling tools: MS Visio, Balsamiq, Tableau, Toad Data Modeler
Business Analysis tools: Rational Rose, JIRA, Rally, MS Project Clear Quest, JIRA-greenhopper,Confluence
AWS Cloud tools: EC2,Lambda,elasticbeanstalk,Eloadbalancer,Autoscaling,RDS,elasticcache,S3,Cloudfront,cloudwatch,cloudformation.Redshift.
Languages: VB, C# & JAVA, SQL, PL SQL, Nunit, MS SQL, DOT Net,
Web Technologies: XML, HTML, SOAP, Web Services
Defect Tracking Tools: HP ALM QC 11.0, Team Foundation Server
Testing Tools: CODED UI 3, QTP, UFT, Selenium,cucumber, HP load runner, J-meter
Internet Technology: XML, HTML & PHP, Firebug 2.0.14
Framework: Data Driven, Keyword Driven, Hybrid, BPT, LinearVersion Control CVS, Tortoise, Visual Studio 2013
Documentation: Adobe Acrobat9 Professional, Microsoft Visio, Microsoft Office, Share point
Protocols: Http, Https, SMTP, FTP, SOAP
ETL: SAP Data Services, SAS Data Management, Informatica,Talend
Databases: SQL Server Management Studio, Oracle 8i-9i, MS SQL Server 2012, SQL Dev, Team Foundation Server (TFS) 2012
PROFESSIONAL EXPERIENCE:
Confidential, Michigan,Troy
Business System Analyst/Data Analyst
Responsibilities:
- Involved in identifying the problem definition as part of continuous process improvement using Define,
- Measure, Analyze and Improve to support the business continuity of the organization.
- Prepared Cost benefit analysis, calculated Benefit to cost ratio, and conducted GAP Analysis.
- Conducted elicitation techniques like user observation, brainstorming, client interviewing and document analysis and Conducted JAD Sessions with various stakeholders. Created workflows using BPMN.
- Worked on Hadoop (Big Data) Hive for retrieving the data from HDFS and Mapreduce.
- Analyzed existing reports and ETL programs in old datawarehouse.
- Closely working with the Trading application services.
- Developed Data Migration, Data Profiling and Cleansing rules considering data linkage and data transformation rules.
- Developed Data Mapping and Data Transformation documents between Legacy database, Production DWH and front end applications.
- Worked on Hive(Hadoop) integrating AWS redshift with AWS RDMS and Dynamo DB.
- .Created Project initiation document and established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements.
- Gathered requirements from business and technical end to develop mainframe and the web portal backend.
- Worked on Creating Work space for Team collaboration tool Confluence.
- Worked on Data Migration of SOA application to AWS cloud with AWS EC2, AWS Elastic Bean stalk.
- Worked on Hive(Hadoop) for fetching the data for SQL-based queries.
- Documented FRD, BRD, Functional specification and mapping documents.
- Created UML diagrams such as Sequence diagram, use case diagram, KPI’s and activity flow diagram.
- Good Experience in testing and defect logging tools like HP-ALM, and SOAP UI.
- Worked on SOA design and development using IIB, implementing business logic and message flows
- Created static prototypes and screen mock-ups. Conducted Triage calls for the testing team.
- Designed the Test Plan and Test Cases for all processes and Web Services.
- Documented functional requirement artifacts with detailed wireframes, workflows and dataflow diagrams.
- Managed stakeholder expectations, status, risks, issues and escalations. Created product release plans.
- Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
- Effectively communicated weekly project status, burn down charts to executive and business leadership
- Prepared Cost benefit analysis, calculated Benefit to cost ratio, and conducted GAP Analysis.
- Aided the back-end team in data mapping, data mining, data validation and data integration.
- Implemented and maintained development best practices including creating processes/documents.
- Demonstrated a proactive approach to identify risks to project success; developing effective action plans for resolution. Assisted with the coordination and management of certain aspects of the project under the supervision of the Sr. project manager and develop project schedules and timeline.
- Present solutions in written or oral reports and prepare and deliver presentations using Power Point.
- Manage activities associated with the project and the success of that project. Developed Templates and specifications for the reports generated.
- Develop excel tools used to track project progress and developed training orientation of new staff.
- Development of training programs to meet teams identified educational needs.
- Worked on Adobe experience manager to manage create and deliver digital experience
Environment: MS Word, MS Project, MS Excel, (Waterfall), MS Visio, XML, SOAP UI, HTML, UML, HP-Quality Center, MS PowerPoint, Oracle11g.
Confidential, cambridge, MA
Business System analyst/Scrummaster
Responsibilities:
- Managed burn down chart, monthly budget and reported project status to PMO and higher management.
- Conducted user interviews for requirements gathering, analysis, and design.
- Assisting in developing various programs for Medtronic’s diabetes management program ‘Turning point’ including A1c and emergency visit reduction
- Assisting in analysis of legacy insulin pumps versus newer pump for clinical and cost related outcomes.
- Worked on EDIx12 Batch files like 837 for medical claims, including professional, Institutional and dental.
- Researched articles for methods on Fitbit-CGM studies, diabetes, healthcare, analysis performed by pharmaceutical, hospitals and insurance industry to build stronger foundation for the team.
- Worked on EDIx12(Enterprise data interchange) and EDIFACT (Enterprise data interchange for administration, commerce and Transport).
- Evaluated efficacy and outcomes of existing healthcare programs and helped create model to target the right patient population for programs such as medication adherence in diabetes patients.
- Worked closely on ICD 9 and 10 with claim processing.
- Worked on 834,820,278 and for benefits enrollment, payroll deduction and premium payment, requests for health services reviews, claim status inquiry and eligibility inquiry.
- Worked on HIVE for analytical processing and MAPREDUCE for processing different languages.
- Worked on EDI transaction 835 electronic remittance refunds from providers to insurers.
- Experience on YARN Resource management and HDFS for storage of the data.
- Utilizing EMR, claims and integrated data for analysis and various other purposes
- Developed project plan for various projects including evaluation of Medtronic products, high end cost assessment, FITBIT-CGM to understand the impact and outcomes on various groups of diabetes patients.
- Leading offshore team by directing them on various projects such as chat bot and diabetes expert system as well as ensuring to meet the delivery deadlines
- Worked on Medtronic’s value-based integrated care services team to improve the programs efficacy and healthcare outcomes
- Worked with the project teams in planning the projects, and managing projects to completion.
- Plan and lead scrum ceremonies and facilitate Epic, Story and Task entries in Jira.
- Collaborated with our DevOps team to define standard practices for continuous integration and delivery.
- Created Visio flow diagrams for identification and extraction of diabetes population
- Interacting with Chief Medical Officer for guidance and approval on various methodologies that is built
- Coordinated and worked with Marketing, healthcare policy, Economics and data innovation team.
- Presenting to senior level management involved in areas of marketing, health economics, data innovation and diabetes services and solutions team
- Lead and participated in daily team scrum meetings as well as business discussions regarding project status.
- Facilitated Sprint Planning, Release Planning, Daily Stand-Ups, Product Demos and Sprint Retrospectives. Removed impediments/blockers to keep teams productive.
- Collaborate with cross functional teams and build schedules and plans, Identify and manage dependencies with other internal or external teams to align deliverables.
- Improved team velocity and leveraged tools like burn downs and capacity modeling to ensure that the teams are efficient and productive and Facilitated discussion, decision making, and conflict resolution.
- Helped to prioritize user stories using MoSCoW and Planning Poker techniques.
- Provided training to users, and involved in conducting UAT sessions to gain user confidence and approval.
- Performed requirement walkthroughs with the Dev and QA teams with the aim to develop testing strategies and test plans such that test cases reflect user needs and created functional and non-functional requirement documents and technical specification documents and delivered within project timelines.
- Conducted user sessions, created user stories using the requirements gathered in user sessions.
- Managed and ensured smooth flow of in-house projects using Kanban- visual management tool based on Agile
- Facilitated sprint retrospective meeting by using Ideaboardz.
- Involved in reengineering of the application to increase performance and accuracy of the system.
- Conducted GAP Analysis and created the GAP Analysis document and performed paper prototyping.
- Performed project planning, project scheduling, cost & time estimation (GANTT Chart) using MS Project.
- Involved in System, Regression, Performance, UAT testing and documentation of the project life cycle.
Environment: MS Word, MS Excel, MS Visio, MS PowerPoint, MS Project, UML, HP ALM, Hybrid (Waterfall, Agile/ Scrum), JIRA-green hoper SQL, HP Quality Center 10.0, JIRA
Confidential, Florida,Tampa
Business System Analyst
Responsibilities:
- Developed high-level and low-level documents like Business requirements documents (BRD) and System requirements specification (SRS).
- Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings.
- Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the team.
- Evangelized the benefits of Scrum to ensure its smooth adoption and tracked velocity and sprint progress.
- Analyze client’s business requirements and processes through document analysis, interviews and workshops.
- Communicate client’s business requirements by constructing easy-to-understand data and process models.
- Collaborate with cross functional teams and build schedules and plans, Identify and manage dependencies with other internal or external teams to align deliverables.
- Handled issues/ risks proactively and worked with the Senior Management Teams to deliver the projects.
- Facilitated Scrum meeting with technical/non-technical team, SME’s to clarify business rules & solve impediments and translated Functional requirements into User stories using Rally.
- Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations and adopted scrum techniques using Moscow and planning poker.
- Day-to-day management of cross functional, global software development project teams.
- Direct and lead development team from project initiation through delivery of final product.
- Conducted Business workflow analysis, process analysis, SWOT analysis, cost-benefit analysis and Gap analysis to know the condition of the current process in use.
- Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
- Extensively interacted with data analysts during the ETL operations in identifying the source files/databases from OLTP systems and implementing the transformation logic for achieving data uniformity.
- Involvement in Data Mining/dimensional Modeling, Data Extraction/ Transformation/ Loading (ETL), OLAP operations like rollup, drill down, slicing/dicing, pivoting using BI tools and Reporting using Tableau.
- Involved in Project Management activities like defining / managing project scope, schedule management,
- Creating project plans, tracking and communicating project status, and milestones using Gantt chart.
Environment: JIRA,Java/J2EE, Mongo DB, RESTFUL Services, HTML5, CSS3, object-oriented JavaScript, Data Caching Services, Fault Tolerant architectures, zero downtime systems. SQL Server, PL/SQL
Confidential
Systems Analyst
Responsibilities:
- Gathered requirements , functional specifications , designed, tested, and enhanced business systems.
- Developed technical solutions to business problems, Created Vision and Use case documents .
- Developed and implemented comprehensive test plans to ensure that systems and programs are tested.
- Created GUI elements, Workflow Diagrams, Activity Diagrams and cross functional diagrams.
- Designed wireframes and mockups and designed the Catalog management process.
- Determined proper installation parameters for software and hardware, for smooth integration and transition.
- Analysed detects, identified and corrected technical problems and deficiencies
- Validating the Web Service responses using SOAPUI .
- Design robust and scalable test plans for feature components which can be easily incorporated into the overall feature test plans and meet customer requirements with little or no guidance.
Environment: VB, MS Team Foundation Server/Team Edition, HP QTP 11.5, HP ALM QC, SharePoint, XML, HTML, MS Test Manager 2010, SQL Server, PL/SQL, WSDL, SOA, Crystal Reports, Web Services.
Confidential
QA Analyst
Responsibilities:
- Preparation of test cases to test the Internet Circuitry.
- Preforming End to End testing for the Paid Services Management.
- Providing fault analysis results to the appropriate team and assigning the defect to teams for research.
- Test automation to build scripts without guidance. This includes working with complex configuration environments, build servers, virtual labs, generalizing tools to accommodate multiple languages and architectures, integrating test automation , and assuring that tools and processes scale to accommodate the evolving needs of our diverse teams.
- Validating the Web Service responses using SOAPUI.
Environment: VB, MS Team Foundation Server/Team Edition, HP QTP 11.5, HP ALM QC, SharePoint, XML, HTML, MS Test Manager 2010, SQL Server, PL/SQL, WSDL, SOA, Crystal Reports, Web Services.