Cloud Data Warehouse/BI Consultant Resume Dallas, TX - Hire IT People (2024)

SUMMARY

• 11+ years of experience in Analysis, Design, Development, and Implementation of Business Intelligence Projects.
• 11+ years of experience in data visualization tools such as Tableau, MicroStrategy, Alteryx and Power BI.
• Strong analytical and complex problem - solving skills with the ability to work independently and in team environments as well as the ability to work simultaneously on multiple projects with competing priorities.
• Excellent communication skills and a strong ability to work effectively with business and technical individuals.
• Ability to perform data analysis, troubleshoot data integrity issues and trend data analysis.
• Adept understanding of data warehouse architecture. (ODS, EDS, EDW, Data Marts), business intelligence, dimensional modeling, and requirement gathering.
• Experience providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Outstanding data analysis skills including data mapping from source to target database schemas, data cleansing and processing, writing data extract scripts/programming of data conversion, and researching complex data problems.
• Extensive experience connectingTableau, MicroStrategyand Power BI to various other data sources like Oracle, Teradata, SAP Hana, Redshift, SQL Server, Snowflake and Alteryx.
• Created highly interactive data visualization reports and dashboards using feature such as data blending, calculations, filters, actions, parameters, maps, extracts, context filters, sets and aggregate measures of Tableau/MicroStrategy/Power BI
• Strong hands-on experience implementing dashboards, data visualizations, and analytics using Tableau desktop and server.
• Utilized Tableau’s flexibility to build a tabbed application with a wide range of options like quick filters, calculated fields, dynamic interaction, and flexible ad-hoc capabilities in various functional areas such as finance, sales, marketing, and human resources.
• Strong experience deploying Power BI solutions across an organization.
• Utilized Power BI to develop various analytical dashboards that depict critical KPIs along with slicers to allow end-users to have full interactivity with the data and the ability to filter based on specific criteria.
• Advanced skills in developing fact, attributes, dimensions, transformations, grids, and dashboards in MicroStrategy.
• Experience designing, creating, and tuning complex MicroStrategy documents and dashboards.
• Proficient in database design, modeling, creating stored procedures, indexes, functions, triggers, and views using SQL server.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, Power BI, SAP Business Objects

ETL Tools: Alteryx, SAP BODS

Databases: Snowflake, Teradata, Oracle, Hive, SAP HANA, MySQL

Language: PL/SQL, SQL, Python, R

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

Cloud Data Warehouse/BI Consultant

Responsibilities:

• Participated in design meetings for creation of the Data Model and provide guidance on best data architecture practices.
• Participated in the development, improvement, and maintenance of Snowflake database applications.
• Utilized Alteryx for data preparation and Tableau for visualization and reporting.
• Worked on green field implementation of Snowflake.
• Strong experience in migrating other databases to Snowflake.
• Experience with Snowflake Multi - Cluster Warehouses.
• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake tables.
• Experience building Snowpipe.
• Experience using Snowflake Clone and Time Travel.
• Created data pipelines using Python (Apache Airflow) to copy data from Data Marts to Snowflake.
• Utilized Python scripts to copy data from Hadoop to S3.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Extensively developed various types of visualizations such as Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps or Symbol Maps, Pareto charts according to deliverable specifications using Tableau.
• Utilized advanced features of Tableau software to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Extensively used analytical features in Tableau like statistical functions and calculations, trendlines, forecasting etc. in reports.
• Published developed dashboards and reports on the Tableau Server so end users with access to the server can view the data.
• Responsible for designing, building, and testingworkflows and analytical apps in Alteryx
• Utilized Alteryx tools to design and develop ETL workflows.
• Create workflows to fetch data from different sources to HDFS using Alteryx and Schedule jobs.
• Improved performance using Batch Macros and standardized the input file cleaning process using standard macros of Alteryx.
• Experience loading data to snowflake warehouse Alteryx.
• Created severalTableaudata extracts using WDC tool of Alteryx to design well performing dashboards.
• Used Alteryx to provide analysts the unique ability to easily prep, blend, and analyze all their data using a repeatable workflow.

Environment: Tableau, Alteryx, Power BI, Oracle, AWS, Jira, Service Now, Hadoop, Impala, Hive, Snowflake

Confidential - Dallas, TX

Sr. BI Consultant

Responsibilities:

• Prepared project reports as well as assisted the project manager in developing weekly and monthly status reports, policies, and procedures.
• Developed technical specification documents related to Tableau and Power BI server design and architecture.
• Built and published customized interactive reports and dashboards using Tableau and Power BI server
• Migrated Power BI Reports and Dashboards to Tableau to embed them in Client Application.
• Setup hierarchies in the Data Model for providing drill down options in the reporting environment.
• Extensively worked on different types of filters in Power BI and Tableau.
• Developed customized calculations using LOD, Sets, Bin or DAX to meet user requirements.
• Worked on administration tasks like adding/removing objects Permissions, Ownerships and User filters.
• Experience creating SQL datasets for Tableau and Ad-Hoc reporting.
• Collaborated with ETL team to improve data performance from multiple data sources.
• Developed enterprise-wide cascading reports in Tableau/Power BI to monitor the performance of cubes, logging of the nightly ETL loads, and user activity of cubes.
• Proficient in developing entity-relationship diagrams, star/snowflake schemas, and modelling transactional databases and data warehouses.
• Blended the data from different databases in to one report by selecting the primary keys from each database for data validation.
• Worked with Data Architecture, Security Architecture, SSO team, AD team and Infrastructure SME’s to ensure that all aspects of the solution architecture are defined and elaborated.
• Embedded Power BI reports on Salesforce portal page as well as managed access of reports and data for individual users using roles.

Environment: Power BI, Tableau, Teradata, Access, Postgres SQL, Tivoli, GCP Cloud

Confidential - Dallas, TX

MicroStrategy Developer

Responsibilities:

• Interacted with business users, project manager, and SMEs to gather business requirements and translated them to technical requirements.
• Utilized MicroStrategy to build and published customized interactive reports and dashboards.
• Designed data model and table structures in data warehouses using snowflake schemas to support MicroStrategy reporting.
• Collaborated with ETL team to understand data flow and make recommendation to improve the efficiency of reports.
• Utilized MicroStrategy intelligence cubes, aggregates, VLDB setting, and database optimizations to optimize MicroStrategy reports and improve efficiency.
• Debugged complex reports by identifying issues and troubleshooting to make appropriate changes.
• Worked on administrative tasks such as creating user groups, object migration, granting access, events, and creating subscriptions for scheduled deliveries.
• Extensively worked on intelligence server administration, configuration of memory settings and performance monitoring.
• Converted SQL server functions into the Teradata store procedure for confirming data.
• Delivered visualizations and widgets including Bubble Grids, ESRI Maps, Heat maps, Time Series, Waterfall graphs, Microcharts, and Scatterplots
• Implemented calendar, geography, economic, and demographic enhancements to client data models.
• Created schemas, metrics, reports, and documents to support business goals.
• Developed SQL queries to meet reporting requirements.
• Implemented Mobile versions of Dashboards for iPad and iPhone.
• Acted as Team Lead and MicroStrategy Architect on multiple projects.

Environment: MicroStrategy, Oracle, MY SQL, Informatica, Tivoli