SUMMARY:

A Data Analytics & Warehousing Architect with diverse industry experience in finance, healthcare & supply chain. Professional expertise includes Data Warehousing, Data Science & ETL (AWS console & Alteryx Admin) and Data Analytics (SQL Queries, Creating Databases, Tables & KPI Metrics). Familiarity & Exposure to Linux distributions (Ubuntu server), Linux Scripting Language & Microsoft Azure Platform.

WORK EXPERIENCE:

Confidential

Alteryx Specialist/Data Architect (Consultant)

Responsibilities:

• Set up Alteryx server & managed server/configurations
• Set up User Managed (MongoDB Replica)
• Create Identity Access Management, Users, Groups & Multifactor Authentication
• Create VM in MS Azure
• Create and place alteryx server on MS Azure VM
• Create alteryx workflows with advanced analytics
• Create analytical application in alteryx designer and store on alteryx server for non - technical user
• Create In-database alteryx workflows and data preparation for visualization in Tableau & Power-BI
• Create ETL between different data warehousing such as snowflake & Redshift via Alteryx workflow
• Create working using API as a data source and utilizing connectors for better data ingestion.
• Utilize R to create Arima and exponential smoothing models
• Facilitate in creating tableau visualization dashboard and enable the data to tell a story
• Managed & create database snowflakes data warehousing on azure VM

Confidential

Data Science/Center Management (Consultant)

Responsibilities:

• Set up Alteryx server & managed server/configurations
• Set up User Managed (MongoDB Replica)
• Create Identity Access Management, Users, Groups & Multifactor Authentication
• Create S3 bucket & storage tier
• Create EC2, EBS & Cloud Watch
• Set up AWS RDS instance, backup & configuration
• Set up AWS Redshift instance & backup
• Set up AWS DynamoDB instance & backup
• Create Domain Name with Route53 registration
• Add AWS resilience and auto scaling
• Routing policies lab, Weighted policies lab, Latency policies lab & Failover policies lab
• Install & Create Multiple Applications (SQS, SWF, SNS, Elastic Transcoder & API Gateway)
• Utilize Lambda Concept & build serverless webpage
• Administer Alteryx Gallery Platforms & Data Connections
• Alteryx Systems Settings, ODBC & DSN connections to different data sources
• Create Admin Data Governance & Best Practices
• Familiarity with Tableau Administration & Tableau Clusters
• Utilize windows physical server with support, maintenance & troubleshooting on which Alteryx resides
• Manage permission & user roles (Curator, Artisan, Viewers & Gallery Admin)
• Utilize Gallery Data Connections, User Data Connection and System Data Connection
• Utilize the Alteryx Server Usage Report for server activities, runtime, jobs, users & log files
• Install Ubuntu Linux distributions based on Debian Architecture and install Tableau Cluster, File Store, App Server & Gateway.
• Scale Up Tableau Server on Ubuntu multi nodes

Confidential

Business Intelligence (Consultant)

Responsibilities:

• Agriculture Sales & Marketing data analytics support with BI, ETL & Data Modeling
• Marketing analytics strategy
• Alteryx advanced analytics Macros, Predictive Analytics, Spatial Data, Connectors, Tableau Hyper Extracts, In-Database tools, Transform & Join.
• Schedule Alteryx, set schedule location, add gallery, batch macros & Iterative macro.
• Utilize SQL to run ad hoc data analysis via Toad for Oracle
• Support Sales & Marketing with data visualization and making a data tell a story & discovery
• Replicate Excel Reports in Spotfire Visualization.
• Some Alteryx Admin work, Alteryx Analytical App, Alteryx Analytical Gallery, Security & Permission.
• Some Alteryx Admin Work, District, Workflows, Collection, Private Studio, Controller & Server Set up.
• PGAdmin & PGSQL, Data warehousing, OLTP, OLAP, Data warehousing Architecture & flows
• Data Modeling and Data warehouse applications
• SQL Queries (COUNT, LIMIT, ORDER BY, BETWEEN, LIKE, GROUP BY, HAVING, JOINS, UNION)
• SQL Queries (Creating Database & Tables, Views, Table Schema, Restore)
• Marketing analytics SEO & SQR
• Social Media data & analytics with Python & R
• 3rd party marketing data collection and analysis using Python
• Advanced Data analytics in Python and sometime R studio
• Utilized SQL & Alteryx to generate user reporting & Tableau server details from PostgreSQL database
• API data source with alteryx (GoogleAdWord, Bing, Youtube)
• Create visualization in QlikView
• Create Chart, graphs, piechart & trend in QlikView

Confidential, Las Vegas, NV

Business Intelligence Analyst

Responsibilities:

• Supply Chain data analytics support with Procurement categories & factors
• Utilize Alteryx to Prepare, blend and analyze all your data using a repeatable workflow
• Run predictive, spatial and statistical analytics in one intuitive interface in Alteryx
• Alteryx workflows creation, Alteryx ETL, Data Science & Data Preparation
• Alteryx advanced analytics Macros, Predictive Analytics, Spatial Data, Connectors, Tableau Hyper Extracts, In-Database tools, Transform & Join.
• Bonfire bid analysis, project creation, analysis & reporting
• Uses Metadata to deep dive into reporting data to analyze & profile compliance data that will give information about the overall picture of the entire reporting and use that data to tell a story to managers & leaders via Tableau Visualization graphs & charts.
• Created reports in Tableau with different type of properties like chart controls, filters, Interactive Sorting, Parameters filters, Data Filtering, Extract filters, Context filters, Dimension Filters.

Confidential, Las Vegas, NV

Sr. Business Intelligence Analyst

Responsibilities:

• Alteryx workflows & ETL Processes
• Alteryx advanced analytics Macros, Predictive Analytics, Spatial Data, Connectors, Tableau Hyper Extracts, In-Database tools, Transform & Join.
• Defining and recommending metrics, measures, reporting and solutions for Tableau Visualization
• Create Big Data ETL process for visualization process
• Uses Metadata to deep dive into reporting data to analyze & profile compliance data that will give information about the overall picture of the entire reporting and use that data to tell a story to managers & leaders via Tableau Visualization graphs & charts.
• Created reports in Tableau with different type of properties like chart controls, filters, Interactive Sorting, Parameters filters, Data Filtering, Extract filters, Context filters, Dimension Filters.
• Complete User Acceptance Testing with client for both ETL & Tableau visualization processes.
• Coordinate (and participate in) production support, Tableau dashboard troubleshooting and deployment to Tableau Servers for multiple usability & create extract schedules via Server.
• Data Governance Processes, Policies & Framework for Tableau Dashboard & Data Source
• Data Warehousing Online Transaction Processing
• SQL Queries (COUNT, LIMIT, ORDER BY, BETWEEN, LIKE, GROUP BY, HAVING, JOINS, UNION)
• SQL Queries (Creating Database & Tables, Views, Table Schema, Restore)

Confidential, Eden Prairie, MN

Consultant (Data Analytics)

Responsibilities:

• Work extensively with Big Data Analysis & Profiling (MDM) as well as Data Governance & Survivorship.
• Work with SMEs to identify and define attributes from source table to be profile.
• Created basic Tableau Dashboard to visualized trend & record counts to management & team.
• Utilize Tableau Server & created basic Data Filters, Parameters & Calculated fields to visual MDM trend & record counts from previous month & current month.
• Create Survivorship rules for data governance & mapping.
• Review Data Dictionaries and select target attributes to be mapped to the Master Data Management Repository.
• Review Data Model and select target attributes to be mapped to the Master Data Management Repository (MDM).
• Utilize Teradata to connect to client source database and pull sample data
• Utilize DB Visualizer to connect to client source database and run Basic SQL queries
• Utilize Aginity for data store connection & analytics purposes
• Create high quality reporting visualization in tableau
• Create Survivorship and User Stories in Rally (CA)
• Utilize Global ID for Data Profiling & Enterprise Ecosystem
• Utilize IBM Info Analyzer for Profiling
• Familiarity of Data Lake and Tenant
• Familiarity of Data Fabric and Tenant
• Knowledge of Hadoop Ecosystem (nodes, rack, cluster, MapReduce jobs)
• Knowledge of Pig scripting & HiveQL
• Utilize Data Visualizer to connect to client source database and pull sample data

Confidential, Minneapolis, MN

Lead Data Analyst /Systems Analyst

Responsibilities:

• Utilize Metadata to get information about COG KPI Metrics & AML Compliance monthly reports.
• Troubleshoot Microsoft Access & Excel using Visual Basic for Application.
• Data Analytics & Reporting lead
• Data Reporting, System Configuration and General Technical assistance.
• Create ad hoc reporting and queries via SQL, VBA and Oracle.
• Create Tables, Queries, Micros and Modules in Microsoft Access & SSMS.
• Financial Reporting including utilizing KPI Metric and SOX Compliance.
• Investigate and trace data from source to destination.
• Created dashboards using Calculated Fields, Filters, and Parameters, groups, sets and hierarchies in Tableau.
• Used VBA & Basic SQL to import & scrape data from data storage to DBMS.
• Summarize data in Excel, Access & SSMS via VBA & Basic TSQL.
• Create Intranet site for business lines, enhanced reporting process and utilize web focus queries.
• Develop entire Access Database from start to finish.
• Import and Export Data from Excel, Access & SMSS.
• Train and lead teammates on VBA, SQL and Access applications.
• Some EDI practice for Data Interchange via Intranet and FTP.
• Work with developers & business line regarding SDLC (Analysis, Design, Implementation, and Maintenance & Planning).
• SQL Queries (COUNT, LIMIT, ORDER BY, BETWEEN, LIKE, GROUP BY, HAVING, JOINS, UNION)
• SQL Queries (Creating Database & Tables, Views, Table Schema, Restore)

Confidential, Las Vegas , NV

Technical Business/Data Analyst

Responsibilities:

• Act as a liaison between the business unit and technical team.Work with developers & business line regarding SDLC.& creation. (ETL)
• Business requirement & liaison with partners’ data & information group for solution delivery.
• Use cases, GUI, screen, interface designs and test cases.
• Collaborate with developers to establish technical vision & analyze tradeoffs between usability and performance needs.
• Work independently with user to define concepts.
• Drive and challenge business units on their assumption of how they will successfully execute their plan.
• Create Details statuses of files using Excel's hyperlink (link files), tables (fields for data manipulation), sorting and filter for SQL Programing.
• Communicate and collaborate with business owners and end-users to analyze information needs &functional requirement.
• Use SharePoint to locate and update resources.
• Use Pivot table and Visio flow chart.
• Design specifications for SDLC (Agile Software Development).