SUMMARY

• Detail oriented Business Data Analyst with 8 years of experience in Requirements Gathering, Data Acquisition, Data Analysis, Data Mining.
• Expertise in translating business requirement into EPIC, breaking down EPICS into features, executable user stories and tasks, creating UML diagrams - Use Case, Activity, Sequence, Process flow diagrams, UI mock-ups, Entity Relationship Diagrams (ERD), Data Flow Diagrams(DFD) using MS Visio, Lucidchart.
• Extensive experience in building ETL pipelines, extracting data from multiple sources(Oracle, SQL Server, AWS S3, Excel, Flat files), writing complex SQL queries to clean data, performing data transformations and generating reports to fit the analytical requirements.
• Experience in Data Mapping - prepared data mapping documents compromising Source and Target database details, business transformation rules.
• Strong understanding of OLAP, Data Warehousing, Dimensional Data Modeling, identifying Facts and Dimensions, designing Star and SnowFlake Schemas.
• Expertise in creating and maintaining clear and well-structured Business Requirements Document(BRD), Functional and Nonfunctional Requirement Documents(FSD), writing user stories, maintaining sprint backlog, identifying defects and bugs, using JIRA, Confluence, Sharepoint, IBM RTC for story tracking.
• Experience in preparing test cases and test scripts, executed System Integration Tests(SIT) and User Acceptance Testing(UAT).
• Experience in Data Science concepts - Data Wrangling, Data Mining, building Machine Learning models using Python libraries - Pandas, NumPy, Seaborn, SciPy, Matplotlib, Sci-kit learn and Machine Learning.
• Experienced in automating, configuring and deploying instances on AWS familiar with AWS IAM, EC2, SageMaker, S3 buckets, Redshift.
• Collaborated with Stakeholders - Product Owner, SME’s, Quality Assurance Analyst, Development team to identify business needs, gather requirements, understand the data guidelines and data sources available.
• Equipped with strong analytical, communicating and problem-solving skills with ability to prioritize tasks and work independently as well as effectively in a team environment.

TECHNICAL SKILLS

Programming languages: SQL, Python

Database, Data Warehouse: MySQL, MSSQL, Oracle, AWS S3, AWS Redshift, Snowflake, SSIS

Visualization & Reporting Tools: Tableau, Power BI, MS Excel, MS Visio, Lucidchart, SSRS

Tools:, Packages & Libraries: Pandas, NumPy, SciPy, Scikit-Learn, Matplotlib, Seaborn, Flask, Docker, Visual Studio, Anaconda, Jupyter Notebook, PyCharm, Spyder, Informatica, Spark, Apache Airflow, SAP

Cloud Technologies: AWS EC2, AWS IAM, AWS Lambda, AWS SageMaker

Version Control tools: GIT, TFS, SVN, JIRA, Confluence, Trello, Google suite, Sharepoint, IBM RTC, Azure Devops

PROFESSIONAL EXPERIENCE

Confidential, California

Sr.Business Data Analyst

Responsibilities:

• Orchestrate project implementation including requirement gathering, determining scope, creating a project plan and implementation using sprints.
• Performed requirements elicitation, translated business requirements as EPIC and user stories.
• Expertise in designing interactive visualizations and dashboards using Power BI and Tableau to deliver data driven solutions
• Used Python and SQL for data integration, transforming and managing data, generating reports useful for analysis and preparing analytical solutions.
• Implemented ETL architecture for data transfer from Source server to Data Warehouse which include server and database information, direction of data flow, column mapping.
• Designed Dimensional models using STAR, SNOWFLAKE schemas, used Slowly Changing Dimensions type 1,2,3 mappings as per requirement.
• Built ETL pipelines to filter and aggregate data, join various tables to retrieve desired data from relational and nonrelational databases like SQL server, My SQL, Oracle, S3.
• Created dags using Apache Airflow to automate and schedule ETL processes as needed through various sources such as API, AWS S3, Redshift, Snowflake.
• Performed Data Profiling to learn behavior of various features of data, integrated with external data sources to discover interesting trends.
• Created insightful reports using Tableau dashboards to provide business solutions on health claims.
• Created UML models - Use Case, Activity, Process flow diagrams, designed new UI mockups for existing web applications using Lucidchart.
• Prepared and analyzed AS-IS and TO-BE process for legacy applications and performed gap analysis.
• Documenting requirements for enterprise-wide initiatives in Agile(Scrum) and Waterfall SDLC methodologies in Healthcare and IT industries.
• Prepared Test cases and Test scripts, executed User Acceptance Testing(UAT) to ensure that the systems conformed to specifications of business requirements performance criteria.
• Conducted feature prioritization meetings with the stakeholders, drafted Epic and User stories in JIRA and was responsible for performing data quality checks.
• Worked collaboratively on Amazon Web Services(AWS) environment - created roles for EC2, S3 and EBS resources to communicate within the team using AWS IAM.
• Conducted backlog grooming sessions, analyzed bugs and defects, interacted with team members in fixing errors and also assisted in post-production support.

Data Analyst

Responsibilities:

• Implemented database changes - database objects creation and modifications, adding constraints using SQL.
• Designed logical and physical Data models, using Entity Relationship Diagrams to capture data flow and documented the details as functional specifications.
• Performed Data Mapping and created source to target data mapping document of input/output attributes with transformations, for ETL implementation.
• Executed Gap Analysis to analyze and document existing process workflows and evaluate the benefits of new/proposed process workflows.
• Conducted Data Wrangling to ensure data quality, consistency of the data, cleared formatting using standardization techniques, handled missing values, fixed outliers, scaled the values to reduce noise in the data.
• Developed dashboards with quick filters in Tableau Desktop and published them to Tableau Server which allowed users to understand the data and get information quickly.
• Facilitated test plan, test case walk-throughs for the business and development teams, refined and groomed and prioritized product and team backlogs.
• Developed test cases, test data, test scripts for executing System Integration testing(SIT) and User Acceptance testing(UAT) in order to ensure the solution meets the business requirements.
• Facilitated sessions with the Stakeholders to understand and gather business requirements, understand common goals and communicate them to the team involved, interacted with the Product Owner, Development team to finalize the user stories.
• Partnered with technical and business teams to identify potential risks and opportunities help businesses to accomplish data-driven decision-making.
• Developed high quality documents including business and functional and nonfunctional detailed specifications and uploaded to Sharepoint.
• Organized and facilitated Scrum ceremonies including Grooming, Planning, Daily Standup, Sprint Demos, and Sprint Retrospective.

Confidential, Minnesota

Data Analyst

Responsibilities:

• Reviewing business requirements, analyzing data sources Excel/MS SQL/DB2/Oracle for reporting and analysis projects using SSRS and Tableau.
• Conducted data mapping to collect and show relations between data from source and target database tables, represented these mappings using ERDs and data diagrams on MS Visio.
• Written SQL queries to extract and transform the data from various data sources, reviewed and optimized queries.
• Utilized Agile Scrum methodology to configure and develop process, standards and procedures.
• Conduct Exploratory Data Analysis EDA using Python programming and python libraries Pandas, Numpy, Matplotlib and Seaborn.
• Performed Data Cleaning - remove duplicates and irrelevant data, standardized capitalization, converted data types into meaningful format, fixed errors like typos, spelling mistakes.
• Performed Data Preprocessing - cleared formatting using standardization techniques from scikit-learn library, handled missing values, fixed outliers, scaled the values using StandardScaler, MinMaxScaler from Scikit-Learn library to reduce noise in the data.
• To handle missing data, implemented various imputation using SimpleImputer, KNNImputer from python and Scikit-Learn libraries.
• Created lambda functions in Python, used mapping, splitting techniques in Pandas to create new features based on existing features, that were useful for further analysis.
• Created dashboards, stories with Tableau to explain how insights and predictions can help the business.
• Validated Test Cases for System Integration testing and User Acceptance Testing (UAT).
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Business Analyst

Responsibilities:

• Analyzed Requirements and created Use Case, Activity, Process flow diagrams using ERP Architect.
• Interacted with Business users to gather business requirements and translated them into functional and non-functional specifications (FSD) thus defining key challenger, project scope, requirements and project deliverables.
• Prepared data models and performed ad-hoc data analysis using SQL to extract business insights.
• Created Requirement Traceability Matrix (RTM) for tracking and managing requirements to ensure that the solution is in compliance with business requirements.
• Facilitated JAD sessions to identify the business rules and requirements, system specifications and design process flow diagrams for application modules.

Confidential

Jr. Business Analyst

Responsibilities:

• Gather business requirements and design process flow, use case, activity UML diagrams and create BRD, FRD documents.
• Assisted in preparation of test plans and execution of Unit Integration, User Acceptance testing.
• Facilitated JAD sessions to identify the business rules and requirements, system specifications and design process flow diagrams for application modules