Ashok Duduru
Fairfax,VA
Summary
Experienced and enthusiastic Consultant with track record of success across wide range of industries. Possesses exceptional interpersonal, problem-solving and analytical skills to provide advice and expertise to client organizations improving business performance. Experienced in all aspects of operations, strategy and finance. Over 17+ years of rich experience in Information Technology with complete Life Cycle Implementations in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms, Operational databases, Enterprise Data Warehouses, data marts, Data Mining, Data Modeling, Transformation and Loading Methodologies, Reporting Tools, OLAP tools & environments with strong analytical skills of structured methodology for reporting / BI design, specification and development. 7 + years of working experience in BI/ETL tools using Tableau Desktop 2019/2018/10.x, MSBI, Cognos 10/8.3/8.4, Cognos Planning 7.2 (Analyst, Contributor Administrator and Contributor client) ,Cognos Impromptu 7.3, Transformer 7.3, Power Play, Impromptu Web Reports (IWR), Cognos Upfront and Cognos ReportNet1.1,Informatica 9.x,SSIS,Alteryx and Tableau online.
Overview
19
19
years of professional experience
Work History
Consultant
Asana Inc
08.2022 - Current
- Asana helps teams orchestrate their work, from small projects to strategic initiatives
- Involved in design and building data warehouse infrastructure from the ground up on Redshift for large scale data handling millions of records every day
- Implementing and managing ETL solutions and automating operational process
- Responsible for requirement gathering, coordination of offshore team
- Responsible for support-Operation activities on P0, P1 tasks at onsite and coordinate with offshore team for P3 and P4 tasks
- Analyzing on going issues and translating business requirements to technical requirements
- Design and develop relational database models and improve performance by tuning queries and coding complex SQL code
- Supporting and monitoring existing DAG pipelines using Airflow schedular for loading data to Snowflake
- Developed new Tableau reports for Marketing, Finance and Revenue teams
- Involved in Migration of Looker reports to Tableau
- Involved in Migration of Bizneyland reports to Tableau dashboard
- Involved in code changes and testing in Snowflake Datawarehouse/data lake
- Involved in ETL development using Python and SQL
- Extensively worked on fixing the existing Bugs/Enhancements in Tableau dashboards using the applications such as Salesforce, Recurly and Zuora (upstream data)
- Worked with business users and stakeholders from the requirements till release.
- Supported creation of detailed, technical financial models to value potential acquisition targets.
- Developed and updated tracking spreadsheets for process monitoring and reporting.
- Maintained database systems to track and analyze operational data.
Sr. Business Intelligence Coordinator
Direct Holdings Americas Inc
12.2009 - 08.2022
- This project has been implemented as a Business Intelligence solution for analytical needs of the Business users of DHG for order management, marketing, inventory, list rentals and finance P&L reports.The goal of this project is to develop relational and OLAP models and develop cubes, dashboards and KPI reports
- Building, publishing customized interactive dashboards/reports, dashboard/reports scheduling using Tableau Online
- Developing dashboards in Tableau 2019/10.5, 10.3
- Optimized Tableau Visualizations with huge amount of data to fit into the business requirements and repaired existing dashboards to make them business friendly by applying various filtering and parameterizing techniques
- Transitioned all reports from a legacy Microsoft Access database into Tableau Server, and trained users in the features and functionality of the Tableau Server web authoring tool to enable report customization
- Database migration activity between Development, Test and Production servers with ETL (SSIS, SQL Servers)
- Recording dashboard/report performance to identify the issues and improve the efficiency
- Analyzed and gained understanding of the underlying data and generated tableau dashboards with forecast and reference lines and Worked on querying data and creating on-demand reports and publishing the same to Tableau Online
- Manipulating the data front end by writing custom and tuning SQL queries for enhancing the database performance SQL
- Created TDE files as templates for continuous reporting which eliminated the need for creation of multiple new Tableau files for every report and reduced dashboard creation times
- Suggested best practices in optimizing Tableau desktop for its peak performance resulting in a significant decrease of development and delivery time
Sr. Technical Lead
HCL Technologies India Pvt Ltd
01.2004 - 11.2009
- Designed and developed the most suitable user interface such as dashboards, multiple charts types, trends, custom requests for excel export and objects for management dashboard/reports.
- Created data visualization using Pareto's, combo charts, heat maps, box and whisker charts, scatter plots, geographic map, cross tabs, histograms
Developed donut charts for analyzing Orders, Inventory data Building different KPI's using table calculations and calculated key figures manipulating strings, arithmetic calculations, aggregation options and logical functions - Using Level of Detail Expressions (LOD) for complex calculations, filtering huge dataset for required fields, advanced grouping and implementing semi additive measures
- Design, develop and implement data warehouse and business intelligence solutions for businesses
Designed and implemented a series of PowerPlay cubes, reports from an Oracle star schema architected data warehouse - Developed Supplier Performance, Purchasing dashboards and operational analytics
- Collected data from wide-ranging sources.
Optimized BI reporting capabilities for secure server environment. - Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
Developed intelligence-sharing dashboards, providing company-wide access to collected data.
Designed customized data collection models for specific visualization tasks.
Education
Bachelor of Engineering (B.E) - Computer Science And Engineering (CS & E)
Mysore University
AWS Certified Data Analytics - Specialty AWS Certified solution Architect – Associate Certificate AWS Certified Developer Associate Certificate Data Bricks Certified Data Engineer Associate - undefined
Skills
General Skills :
Data Visualization ,Machine Learning,Pattern Recognition,Statistical Analysis,Data preparation ,
Quality Management , Agile Methodologies
Technical Skills :
- Tableau ,Snowflake ,Cognos BI 10X,MSBI (SSRS, SSAS, SSIS) ,Power BI,Looker
- Modeling : Erwin, Visio, Framework Manager 84
- ETL Tools : Informatica Power Mart 9X, Alteryx 115, SSIS, Tableau prep AWS data pipeline,
- Databases : Snowflake Oracle,Sql Server ,Redshift,CosmosDB, DynamoDB (NoSQL), Redshift,AWS Aurora, and PostgreSQL
- Languages : Python, R, TSQL ,Unix Scripting
- Scheduling: Airflow, Control-M
Timeline
Consultant
Asana Inc
08.2022 - Current
Sr. Business Intelligence Coordinator
Direct Holdings Americas Inc
12.2009 - 08.2022
Sr. Technical Lead
HCL Technologies India Pvt Ltd
01.2004 - 11.2009
Bachelor of Engineering (B.E) - Computer Science And Engineering (CS & E)
Mysore University