Business System Analyst/data Analyst Resume
Bellevue, WA
PROFESSIONAL SUMMARY:
- Worked as a junior Business Analyst/Data Analyst with specialties in Requirements Gathering, Requirements Documentation, Testing and Data Analysis/Mapping/Modeling
- Extensively used SDLC methodologies. Specific methodologies include Agile scrum technique and Rational Unified Process (RUP) for managing iterative style of software development
- 1 plus years of experience in data analysis by executing SQL queries. 6 plus months of experience in Data Warehousing (DW/BI)
- Excellent analytical skills for understanding business requirements, system requirements/concept validation, and data related requirements, business rules/processes, and detailed design of the application
- Able to work with project manager in writing Scope & Vision Document during planning phase of the projects
- Extensive experience and understanding of Web Technology, Telecommunication, E - commerce, Process Mapping, Change Management, and Business Process Modeling (BPM)
- Able to map current practices with best practices in similar fields and model the gaps via Gap Analysis
- Proficient in analyzing Data Quality Issues - Data Redundancy, Data Consistency, Data Completeness, Metadata Analysis, and Data Schema Study
- Prepared Data Mapping Document comprising of Source Input Definition, Target/Output Details, Business Transformation Rules, and Data Quality Requirements
- Proficient in executing SQL queries for data analysis and preparing Data Profile Report
- Performed Data Mining in order to determine Data Mappings between various systems
- Ability to interpret/build Data Models - Logical Data Model, Relational (Normalization) Model and Dimensional (Star and Snow-Flakes) Model
- Strong understanding of OLTP, OLAP, ETL, Data Integration, Data Migration, Data Conversion Data Distribution, Data Profiling, and Data Governance
- Proficient in analyzing data by Data Mining, Statistical Analysis of data, Forecasting, Quality Control in Manufacturing and Production by applying Statistical Analysis (Control Charts), SPC, SIX SIGMA, Lean Manufacturing, Logistics, Transportation, Simulations, DMAIC, DOE, ISO standards, Business Optimization, Process Flow, FEMA, TQM, DFM, and 5s
- Broad Knowledge in reviewing Test Procedures, creating Test plans, Test scenarios, and defining Test cases for both System & Integration Testing
- User Acceptance Testing (UAT) with Test Plan, Assigning Team, Execution, Documentation and Defect Report
- Worked closely with QA team in planning Unit Test, Regression Test, Performance Test and System Integration Test
- Expert in using Load Runner for load testing, Quality Center/Test Directory for test management and QTP for regression testing and functional testing
- Business Requirements Document (BRD)
- Functional Requirements Document (FRD/FSD)
- Test Plan Document (TPD)
- Data Mapping Document (DMD)
- Data Profile Report (DPR)
- Gap Analysis Document (GAD)
- Root Cause Analysis Document (RCA)
TECHNICAL SKILLS:
Business Modeling Tools: Power Designer, MS-Visio
Project Management: MS Project, Requisite Pro, MS Excel, MS SharePoint
Defect Management Tool: Rational Clear Quest, Mercury Test Director
Databases: MS Access, SQL Server, SSIS, SSRS and SSAS
Statistical Analysis Tools: Minitab, SPSS, SAS
Data Mining: Confidential, Rapid Miner, Tracies, iDA, SAS
Risk Management Tools: Monte Carlo Simulations, Crystal Ball, What-if Analysis,and
Sensitivity Analysis, OPTQEST: Optimization Tools
LINGO, LINDO, Easy-Opt and What’s Best: Operating Systems
Windows 2000/XP/Vista, MS Dos: General
MS Office (Word, Excel, PowerPoint), MS Project, MS publisher: Lotus Notes, MS outlook
Programming Language: FORTRAN, OCTAVE, MSSQL
Design and Drafting: Auto Cad, Staad, SAP, Inventor
Queuing Model: Template
AUTO ID: RFID, Barcode Scanner
Understanding about tools: Simulations for decision making, CRM(SAP) Peoplesoft and salesforce.com, SMath Studio
PROFESSIONAL EXPERIENCE:
Confidential, Bellevue, WA
Business System Analyst/Data Analyst
Responsibilities:
- This project will model products from WPC (Web Product Catalog) for all channels in EPC (Enterprise Product Catalog): Postpaid Products, Prepaid Products, devices, accessories, rate plans and services; Support product model from Samson/SAP in EPC.
- Worked as a Business System Data Analyst and assisted the project manager in defining the Scope, Schedule and Budget of the Project
- Participated with individual and JAD sessions (Work Sessions) with the stakeholders (Offer Management) and the technical units (Amdocs) for business requirement gathering
- Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document
- Assisted in Data Analysis by Data Mapping among EPC, WPC, SANSON (Billing System) and SAP (Inventory) then worked with the design team in the designing of the Databases with extensive use of ERDs
- Extensively applied SQL queries for T-SQL.
- Created a Data Profiling Document that documented Column Analysis, Domain Analysis, Data Classification Analysis, Format Analysis, Data Properties Analysis, Primary Key Analysis, Foreign Key Analysis, Cross-Domain Analysis and Baseline Analysis.
- Used WebSphere Information Analyzer for Metadata Management that included data-driven creation of metadata and linking of metadata to physical objects.
- Implemented Slowly Changing Dimensions (SCD) Methodology to modify the existing dimensions table by Type I Response (Overwrite the Old Data Value), Type II Response (Create a New Dimension Record), and Type III Response (Create an Old Value Column).
- Applied Mapping Rules for multiple sources to multiple targets and documented Data Mapping Document clearly demonstrating the Transformation Rules.
- Assisted in creating Data Sample that included specific size of data from the database reflecting different data field elements’ values. Data Sample would then be compared with Source Application Systems to test the accuracy of data field elements values.
- Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required by business users.
- Used SQL Server Integrations Services (SSIS) to extract data, and quickly load data into SQL Server table, and handle data quality issues.
- Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports.
- Created reports with SSRS Wizards and Report Designer in order to test reports and validate reports by end-users. Also, configured Report Manager Security in SSRS.
- Established a Business Analysis Methodology around the Development Process
- Designed and developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Business Process Flow Diagram, by using MS Visio
- Provided key inputs in defining the projects and system requirements
- Assisted the team members in writing the Test Cases and executed the Test Plans for the User Acceptance Testing
- Worked with MS Access/Product Catalog Manager for the arrangement of the customer data
- Assisted the project manager in developing the project Plan, Scope Plan and Business Process Plan
Confidential, Jonesboro, AR
On Campus Intern
Responsibilities:
- Involved in Data Gathering, Data Validation, Data Profiling, and Data Quality
- Quality Assurance of Data with Statistical Analysis by using MINI Tab, SAS, and SPSS ; Control Charts, DMAIC, Box Plot, Histogram, Scatter Charts, X bar charts, X bar R Charts, root cause analysis, fish bone Charts, Time Series, ANOVA, Linear Regression, SPC, and DMAIC analysis
- Applied SQL Server Integrations Services (SSIS) to extract data, and quickly load data into SQL Server table, and handle data quality issues.
- Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports.
- Created reports with SSRS Wizards and Report Designer in order to test reports and validate reports by end-users. Also, configured Report Manager Security in SSRS.
- Designed Activity Diagrams, Sequence Diagrams, Business Process Flow Diagram, by using MS Visio
- Generated Reports using Pivot Tables and Pivot Charts to show the attributes
- Extensively applied Excel Macros, MS Access for Design Table, Forms, Reports and Queries
- Extensively applied MS Project for Gantt Chart, CPM, and PERT analysis
- Applied Confidential, SAS, Excel Mining, SQL for data mining - Logistic Regression, Discriminant Analysis, Correlation, Clustering, Naïve Bayes, Association, Decision Trees, Multiple Logistic Regression, Multivariate
- Involved in Root Cause Analysis
- Involved in FEMA Analysis
- Applied ISO 9000, 14000 for Data Quality Management and Environment Management
- Result Interpretation of manufacturing and production Optimization (DMAIC Process) for quality assurance
Confidential, Jonesboro, AR
Graduate Research Assistant
Responsibilities;
- Worked on Forecasting and Inventory Management
- Optimization of material flow from incoming materials to outbound finished goods
- Data gathering, analyze and determine root cause and implement corrective actions by using SAS, Mini Tab
- Applied FEMA concepts to identify failure concerns
- Understanding about Design Process and Assembly Review and Production Part Approval Process
- Gathering knowledge about manufacturing processes and verify process capability
- Identifying, communicating and solving quality issues
- Understanding functionality about Advanced Product Quality Planning (APQP) activities to ensure production readiness for New Product Introduction (NPI)
- Applied extensive knowledge on MRP, MBOM, and ECR
- Preparing Vision and Scope Documents
- SWOT analysis
- Forecasting and Financial Analysis
Data Analyst
Confidential
Responsibilities:
- Primary/ Secondary data collection
- Data Cleaning
- Data Mapping Data Quality, Data Profiling, Data Governance
- Clustering, Association and Predictive Analysis