نبذة عني
Over 5+ years of strong experience in Business and Data Modeling/ Data Analysis, Data Architect, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, MDM, NoSQL, and Metadata …
Over 5+ years of strong experience in Business and Data Modeling/ Data Analysis, Data Architect, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, MDM, NoSQL, and Metadata Management Services Configuration Management. Experienced in using Microsoft Power BI. Enterprise Data Warehousing including Data Modeling, Data Architecture, SNOW FLAKE ,Data Integration (ETL/ELT), and Business Intelligence. Involved with data profiling for multiple sources and answered complex business questions by providing data to business users. Responsible for development of workflow analysis, requirement gathering, data governance, data management and data loading. Have setup data governance touch points with key teams to ensure data issues were addressed promptly. Responsible for facilitating UAT (User Acceptance Testing), PPV (Postproduction Validation) and maintaining Metadata and Data dictionary. Responsible for source data cleansing, analysis and reporting using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation in Excel. Actively involved in data modeling for the QRM Mortgage Application migration to Teradata and developed the dimensional model. Created views for reporting purpose which involves complex SQL queries with sub-queries, inline views, multi table joins, with clause and outer joins as per the functional needs in the Business Requirements Document (BRD). Conducted data cleaning, manipulation, modification and combination using variety of SAS steps and functions. Analyzed, tested, documented and maintained SAS programs and macros to generate SAS datasets, spreadsheets, data listing, tables and reports. Experience in business intelligence and data analysis, Reporting, Data Preparation, Data Validation, Data warehousing, ETL techniques, Visualizations, software, and predictive model design and development using Tableau, RDBMS tools, IBM Cognos, Power BI, Excel, python. Good understanding of machine learning models such as Supervised learning, Unsupervised learning, Regression, and Classification Linear Regression, Logistic Regression, K Nearest Neighbour, Decision Tree, and Random Forest using Python Packages such as Scikit Learn, Pandas, NumPy, Matplotlib, Seaborn, and Plotly. Extensive knowledge in Machine learning, Data mining, SQL Queries, and Databases. Proficient in writing queries and sub queries to retrieve the data using SQL from various servers including Microsoft SQL, Oracle, and MySQL. Experienced in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/Studio, Erwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling. Extensive experience in the development of T-SQL, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning, and optimization for business logic implementation. Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling Data Validation in ETL. Experience in Creating an Audit control system for the ETL process for Big Data and Data Warehouse Application. Extensive experience in business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting, and querying tools, Data mining, and Spreadsheets.
الخبرة
Data Analyst
This project implementation uses a feature-rich Windows UI, highly flexible and scalable services, large-
scale online analytical processing of large datasets, and warehouse reporting. It uses Hadoop for data
warehousing design, building, and maintaining Big Data workflows/pipelines to process billions of records
into and out of our data lake. The aim of the project implementation is to normalize the request-response
data from numerous services that are persisted in the AWS S3 bucket via the Kinesis stream. Building end
to end CI/CD Pipelines in Jenkins to retrieve code, compile applications, perform tests, pushed build
artifacts to Nexus Artifactory and use SonarQube and Jacocoin build system for continuously inspecting
Data / Bussiness Analyst
Involved in creating a platform for Validators where they could run scripts from R, Python and Java
Worked on SAS connections from Python using saspy module and ran SAS code
Used GPU for faster computation and benchmarking results
Utilized Apache Spark with Python to develop and execute Big Data Analytics and Machine learning applications, executed machine Learning use cases under Spark ML and Mllib
Created a backend server with Python Flask that implemented routing for indexing & showing page, and receiving the video & info data sent from the user
Responsible for gathering data migration requirements
Identified problematic areas and conduct research to determine course of action to correct the data
Analyzed reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports
Created an interactive dashboard application using R and Shiny to evaluate the quality measures using six-sigma charts using the complaint data metrics
Used Python, Tableau, and Excel to analyze the number of products per customer and sales in a category for sales optimization
Visualized data by using advanced tableau functions like action filters, context filters, and Level-of-Detail (LOD) expressions