Ma Isabel

• 10+ years of robust professional experience in Data collection, Data Extraction, Data Cleaning, Data Aggregation, Data Mining, Data verification, Data analysis, Reporting, and data warehousing environments. • Strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications • Extensive experience in querying languages using SQL, PL/SQL, T-SQL, SAS. • Experience in building high throughput ETL pipelines and building high performance data lakes. • Proficient in Data Analysis with sound knowledge in extraction of data from various database sources like MySQL, MSSQL, Oracle, Teradata and other database systems. • Expertise in developing advanced PL/SQL code through Stored Procedures, Triggers, Cursors, Tables, Views and User Defined Functions. • Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS), SSRS. • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS) and defined Data Source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles. • Worked on Big Data analytic with Petabyte data volumes on Microsoft's Big data platform (COSMOS) and SCOPE scripting. • Expertise in Normalization/DE normalization techniques for effective and optimum performance in OLTP and OLAP environments. • Developed Merge jobs in Python to extract and load data into MySQL database. • Hands on experience in SAS programming for extracting data from Flat files Excel spreadsheets and external RDBMS (ORACLE, MySQL, DB2, Sybase) tables using LIBNAME and SQL PASSTHRU facility. • Expertise in Data Manipulations using SAS data step, such as Formats/Informants, Merge, Procedures like PROC APPEND, PROC DATASETS, PROC SORT, PROC TRANSPOSE. • Experience in developing predictive models like Decision trees, Interactive decision tree, Gradient boosting, Regression, Neural networks etc. using SAS enterprise miner. • Extensive knowledge of advanced STAT procedures including PROC REPORT, PROC TABULATE, PROC CORR, PROC GLM, PROC ANOVA, PROC LOGISTIC, PROC TTEST, PROC SGPLOT PROC REG, PROC FREQ, PROC MEANS, PROC UNIVARIATE. • Automate the process of data extraction, transformation and processing using shell scripts. • Used Test driven approach for developing the application and Implemented the unit tests using Python Unit test framework. • Experience in developing programs by using SQL, SAS & shell scripts and scheduling the processes to run on a regular basis. • Highly Experienced in Statistical, Econometric & Machine Learning Techniques: Descriptive Statistics, Regression, Time series, Panel Data Regression, Bayesian Methods, Clustering, Dimensionality Reduction, Market Basket Analysis, Logit, Probit and Tobit Models, Ensemble Methods, Bagging, Boosting and Pasting methods, Perceptron, CNN and RNN, Monte-Carlo Simulations, NLP • Worked in creating different Visualizations in Tableau & Power BI using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports. • Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated Fields, Sets, Groups, Parameters in Tableau. • Created Dashboards style of reports using Qlikview components like List Box Slider, Buttons, Charts and Bookmarks. • Database analysis tools Teradata SQL Assistant, TOAD and Erwin. Data cleansing tool Win Pure. • Responsible for creating ETL design specification document to load data from operational data store to data warehouse. • Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages. • Formulated procedures for integration of R programming plans with data sources and delivery system.