AS a Senior BI Analyst with 13 years of IT industry experience, specializing in data analytics and business intelligence. A certified expert in AWS Architect, and Tableau Desktop and Tableau server and SysOps Admin Engineer, i'm strong on track record of migrating complex datasets between Tableau and AWS QuickSight, utilizing ETL processes and Snowflake for optimized data warehousing. He excels in designing and implementing interactive BI reports and dashboards across various platforms, including R, RStudio, and Tableau,Power BI coupled with extensive administration and performance tuning of Tableau environments. proficiency in SQL, alongside his hands-on experience with AWS data technologies (S3, IAM, RDS, Redshift, Glue), empowers him to deliver robust, data-driven solutions that enhance operational efficiency and decision-making. His commitment to best practices and continuous improvement in BI systems makes him a valuable leader in data strategy and analytics.A collaborative team player and leader,in cross-functional environments, where he effectively gathers reporting requirements and translates them into actionable insights. His strategic use of AWS data technologies and tools like Athena and IAM ensures robust data management and security practices, aligning with organizational goals and enhancing overall performance.
· Work with our Technical Business Analysts, customers & data source system experts to understand reporting needs, underlying source data and associated business rules
· Using ETL tools and/or SQL, develop data extract routines from a variety of disparate data sources and conform them to the Harris Resolve Data Integration Template format
· Develop data visualizations using a variety of applications such as AWS Quick Sight, Tableau, Tableau Online, and others. Participate in functional and technical design sessions Gather end-user requirements for data dissemination and reporting. Use various applications to analyze source system data and identify data quality issues and anomalies that will need to be corrected and/or handled in ETL routines
· The migration of legacy Tableau reports to AWS Cloud, enhancing data accessibility and system performance.
· Orchestrated the transition of critical business reports from AWS Big Site to Tableau Cloud, ensuring seamless integration and minimal downtime.
· Led extensive migrations between Tableau and AWS Quick Sight, optimizing visualization capabilities and dashboard performance.
· Managed reverse migrations from AWS Quick Sight back to Tableau, ensuring data consistency and alignment with user preferences and business requirements.
· Collaborated closely with the Product Manager and leadership board to align project objectives with strategic business goals.
· Played a pivotal role in architectural design sessions, contributing expertise in scalable cloud solutions and data integration strategies.
· Utilized the Tableau Content Migration Tool for efficient content transfer, maintaining data integrity and report functionality.
· Experience with AWS API Gateway, Lambda Functions.
· Design experience using Node, Express, REST.
· DynamoDB Streams by using NoSQL you can trigger a Lambda function to perform additional work each time a DynamoDB table using NOSQL
· Analyze and communicate test results and advancement
· Log and verify defects
· Work with partners and third parties on troubleshooting and analyzing issues
· Work as key member of R&D team to analyze and program changes in product suite
· Maintain development deadlines and provide accurate estimates
· Analyze and troubleshoot product stability issues reported by clients
· Follow functional/technical specifications and work with Business Analysts to ensure delivered products meet specifications
· Participate in a cross-functional team to design, build, test and deploy complex analytical solutions utilizing Quick sight.
· Participate in business requirements and design review sessions.
· Perform detailed analysis of source systems and source system data and model that data in Quick sight.
· Design, develop, and test Quick sight dashboards to meet customer requirements.
· Participate in design workshops, providing technical insight and knowledge.
· Experience in AWS data technology products and AWS environment S3, IAM policies, roles, RDS, Redshift, Glue.
· Strong SQL skills for data wrangling, querying, and transformation with AWS Athenas.
· Interpret written business requirements and technical specification documents.
· Create and maintain technical design documentation.
· Perform quality coding to business and technical specifications.
· Constructed API through AWS Gateway & Lambda, to ensure server calls are authorized before they modify the database, and handle API calls in a separate environment without database access
The DHS Tableau implementation and the associated charts, graphs, maps, and table data are critical to DHS’ COVID-19 response AWS Quick Sight Tableau supports all of the dynamic charts, graphs, tables, maps, etc. for the COVID-19 data on the DHS website in addition to supporting similar opioid publication information. As part of the State Emergency Operation Center, numerous internal and external staff have built processes and procedures to gather and present data dynamically via the Tableau system.
My Responsible I used to handle Pricing team and Generate reports like generate like File claims Reports, View claim status and payment details View pending claims, Respond to document requests and Activate mortgage insurance coverage, Transfer servicing, Transfer servicing, Report loan modifications, Cancel mortgage insurance and Access billing and premium details
Develop and document predictive models in a clear and reproducible manner.
Work on some of the most complex problems imaginable at the intersection of two dynamic industries – finance and technology. Assist in growing data science economic research skills in the team.
Build relationships with clients by understanding their business challenges and formulate business solutions using text analytics
Work with our Technical Business Analysts, customers & data source system experts to understand reporting needs, underlying source data and associated business rules
Using ETL tools and/or SQL, develop data extract routines from a variety of disparate data sources and conform them to the Harris Resolve Data Integration Template format
· Develop data visualizations using a variety of applications such as AWS QuickSight, Tableau, Microsoft Power BI, and others. Participate in functional and technical design sessions Gather end-user requirements for data dissemination and reporting. Use various applications to analyze source system data and identify data quality issues and anomalies that will need to be corrected and/or handled in ETL routines
· Execute testing of our software
· Analyze and communicate test results and advancement
· Log and verify defects
· Work with partners and third parties on troubleshooting and analyzing issues
· Work as key member of R&D team to analyze and program changes in product suite
· Maintain development deadlines and provide accurate estimates
· Analyze and troubleshoot product stability issues reported by clients
· Follow functional/technical specifications and work with Business Analysts to ensure delivered products meet specifications
· Developed expertise in Power BI and Tableau by completing online tutorials and hands-on projects.
· Migrated existing reports and dashboards to Power BI and Tableau, improving data visualization capabilities and user interactivity.
· Transformed data extraction, cleaning, and modeling processes to leverage the functionalities of Power BI and Tableau.
· Collaborated with cross-functional teams to gather reporting requirements and translated them into interactive dashboards and visualizations.
· Integrated multiple data sources into Power BI and Tableau, including databases, APIs, and spreadsheets, ensuring comprehensive data analysis.
· Designed intuitive and visually appealing dashboards in Power BI and Tableau, enabling stakeholders to make data-driven decisions effectively.
· Implemented advanced calculations and measures using DAX in Power BI and calculated fields in Tableau to derive valuable insights from the data.
· Participate in a cross-functional team to design, build, test and deploy complex analytical solutions utilizing Quick sight.
· Participate in business requirements and design review sessions.
· Perform detailed analysis of source systems and source system data and model that data in Quick sight.
· Design, develop, and test Quick sight dashboards to meet customer requirements.
· Participate in design workshops, providing technical insight and knowledge.
· Experience in AWS data technology products and AWS environment S3, IAM policies, roles, RDS, Redshift, Glue.
· Performance tuning / Server management of tableau server environment (clustering, Load
· balancing).
· Create/Manage Groups, Workbooks and Projects, Database Views, Data Sources and Data
· Connections.
· Manage and support migration of objects (dimensions, measures, hierarchies, reports,
· workbooks, dashboards), from development to production environments.
· Results oriented with an ability to work in team and individual contributor work environments.
· Innovative thinking to solve challenging problems.
· Results oriented with an ability to work in team and individual contributor work environments.
· Involved tableau server creating architecture, design, and development skills.
· Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that
· Strong SQL skills for data wrangling, querying, and transformation with AWS Athena.
· Spearheaded the migration of legacy Tableau reports to AWS Cloud, enhancing data accessibility and system performance.
· Orchestrated the transition of critical business reports from AWS Big Site to Tableau Cloud, ensuring seamless integration and minimal downtime.
· Collaborated closely with the Product Manager and leadership board to align project objectives with strategic business goals.
· Played a pivotal role in architectural design sessions, contributing expertise in scalable cloud solutions and data integration strategies.
· Utilized the Tableau Content Migration Tool for efficient content transfer, maintaining data integrity and report functionality.
· Led multiple projects leveraging AWS services, including Lambda, Athena, DynamoDB, S3, and Redshift, to optimize data storage and retrieval processes.
· Implemented AWS Glue for streamlined data management and transformation, significantly reducing manual data handling.
· Developed and maintained PostgreSQL and Snowflake databases, ensuring robust data architecture and support for analytics.
As a Business Objects and Tableau Developer at Lincoln Financial Group, I am proficient in creating database objects such as tables, views, procedures, triggers, and functions. My expertise in T-SQL allows me to provide definition, structure, and maintain data efficiently while creating Oracle SQLs, PL/SQL procedures, and queries. I am skilled in writing complex queries, using MS Excel for executing comparisons,
My experience with Tableau server involves building, publishing customized interactive reports and dashboards, and report scheduling. I have conducted extensive GAP analysis in projects and am adept at designing, building, and running Tableau dashboards. I have assisted business analysts in gathering requirements and in the design and development of ETL processes.
I have validated schemas, identified errors present in ETL, and participated in providing recommendations to fix problems. I am proficient in writing stored procedures in Netezza and converting cursor-based PL/SQL procs into set-based nzsql procs. My hands-on and extensive working experience in ETL processes using Informatica
I am experienced in creating dashboards, action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau. My expertise extends to Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica. I am adept at restricting data for particular users using Row-level security and User filters and have developed Tableau visualizations and dashboards using Tableau Desktop & Tableau Support.