Professional Experiences:
Biz Insider Tech Nepal P. Ltd – Associated Project Coordinator/ Business Data Analyst (02/2015-06/2017)
Passionately involved in the complete Software Development Life Cycle (SDLC) in both agile and waterfall methodology.
Created Business Requirements Document (BRD) and Functional Requirements Document (FRD) by working diligently with IT staff and project manager.
Helps in efficiently conducting Gap Analysis (GAP), User Acceptance Testing (UAT), and System Integration testing (SIT) and SWOT analysis.
Designed mockup and wireframes to properly communicate visual data flow to the end users.
Developed use cases, activity diagrams and sequence diagrams for an explicit understanding of the vision document.
Supervised team members work, carefully managed the development and deployment programs whenever needed.
Experienced in writing complex SQL Queries to implement the business logic and created clustered and non-clustered indexes.
Performed Data Modeling, ETL and reporting using MSBI shops (SSAS, SSIS, SSRS, Power BI), Erwin, MS Visio, etc.
Created SSRS reports like Drill Down, Drill through, Parameterized Reports, Sub-reports, Dashboards and Scorecards as per the specific requirements.
ac8wwg@r.postjobfree.com
2155 Evans Ct House, Falls Church, VA, 22043
TECHNICAL SKILLS:
MSBI (SSAS, SSRS & SSIS)
Power BI
Tableau
MS SQL
Oracle
PL/SQL
Python
SAS
Erwin
Agile
Waterfall
Scrum
MS Office
Educations:
Dakota State University
Madison, SD
Master of Science: Information System (Dec 2018)
GPA: 4.0
Academic Experience: Research Assistant (08/2017-12/2018)
To assist, gather, analyze, document, prepare and archive the research outcomes and report it to the supervisor.
Collaborated with multiple faculties across different departments to carefully conduct interdisciplinary research projects
Perform web scraping and data extraction using Python.
Responsible for cleaning and transforming data into meaning information by creating a report and performing data analysis on the data set.
Create the reports, conduct research and prepare presentations for the Provost of the university.
Professional Summary:
Motivated and ambitious Business Analyst with more than 3 successful years of extensive experience in both traditional (waterfall) and Agile SDLC environment with a thorough understanding of various database platforms like Oracle and MS SQL.
Extensive expertise in developing prototypes, mock-ups, sequence diagram, use case, dashboards, scorecards, reports, and Logical and Physical data models using data modeling tools like Erwin and MS Visio
Extensive understanding of efficiently implementing BI solutions using Microsoft BI Stack (SSAS, SSIS, SSRS, Power BI) and writing complex SQL queries involving multiple table inner and outer joins.
A proper understanding of HIPAA transaction EDI's like 270, 271, 276, 277, 835, 837 and 834 and about the claim processing system.
AL
Arun Lamichhane