Saurabh Vyas

Saurabh Vyas Email and Phone Number

Senior Business Intelligence Engineer @ Amazon Web Services (AWS)
Seattle, WA, US
Saurabh Vyas's Location
Seattle, Washington, United States, United States
Saurabh Vyas's Contact Details

Saurabh Vyas work email

Saurabh Vyas personal email

About Saurabh Vyas

9+ years of experience in the Information Technology Industry as Business Intelligence Developer with strong attention to detail, an ability to work in a fast-paced and ever-changing environment, and an ability to work effectively with cross-functional teams. Skilled in OBIEE, SQL, PL/SQL, Oracle Database and Talend open studio.• Proficient, diligent & focused professional with 9.5 years of overall industry experience on different Business Intelligence and Data Warehousing tools.• Worked in a globally challenging environment and resolved the challenges faced by business, assessed the impact of change and analyzed business requirements by utilizing my strong customer service, relationship building, project management skills and analytical abilities.• Have diverse work experience in domains like Transportation, Manufacturing, Supply Chain, Fleet Management with diverse roles of Developer, Team Lead, On-site Lead, Consultant and Data Analyst.• Successfully designed, delivered and managed Business Intelligence/Data Warehouse (BI/DW) projects using Software Development lifecycle and methodologies like Waterfall, Agile methodology and Scrum approach.• Extensive experience with ETL Tools like Talend Tool for Data Integration and Reporting Tools like OBIEE.• Hands-On experience in scheduling and monitoring ETL Jobs on Talend job on Talend Administration Center (TAC)• Varied experience of BI technologies such as Talend 6.x and 7.x, OBIEE 11g/12c and databases such as Oracle 9i/10g/11g, Postgres, Sybase.• Worked as BI Expert and onsite coordinator in US over more than 5 years and in Mexico for 1 year for various clients in United States.• Expertise in Data Warehousing Projects and integrating data from different source system database like Oracle, legacy systems, MSQL Server as well as good exposure in several facet of Data Warehousing, Data Quality Analysis and Design, ETL design and development.• Excellent communication and leadership skills with very good analytical and problem-solving abilities, strong presentation skills and a passionate mentor.• Successfully lead a Team of >20 from requirement gathering through to implementation and support.

Saurabh Vyas's Current Company Details
Amazon Web Services (AWS)

Amazon Web Services (Aws)

View
Senior Business Intelligence Engineer
Seattle, WA, US
Website:
aws.amazon.com
Employees:
142019
Saurabh Vyas Work Experience Details
  • Amazon Web Services (Aws)
    Senior Business Intelligence Engineer
    Amazon Web Services (Aws)
    Seattle, Wa, Us
    View
  • Amazon Web Services (Aws)
    Business Intelligence Engineer
    Amazon Web Services (Aws) Aug 2022 - Present
    Seattle, Washington, United States
    View
  • Amazon Web Services (Aws)
    Business Intelligence Engineer
    Amazon Web Services (Aws) May 2021 - Aug 2022
    Vancouver, British Columbia, Canada
    View
  • Amazon Web Services (Aws)
    Business Intelligence Engineer
    Amazon Web Services (Aws) Jun 2020 - May 2021
    Detroit, Michigan, United States
    View
  • Tata Consultancy Services
    Business Intelligence Team Lead/Developer (Talend Etl Developer, Data Analyst, Obiee Consultant)
    Tata Consultancy Services Nov 2017 - Jun 2020
    Canton, Michigan, United States
    Ø Involve in entire end to end process like requirement gathering, mapping validation, data model and physical data model validation with mapping, source file identification, layout validation with respect to mapping, data profiling to critical columns etc. Ø Design and develop complex mappings from varied transformation logic in Talend Enterprise Edition and by using various components like tJoin, tReplicate, tParallelize, tDie, tUnique, tSort, tMap etc.Ø Generate Autosys scripts to create email alerts on pending files for processing from vendors and WEX.Ø Enhance existing BO reports and BO Universe to include prompt data for new card types.Ø Enhance existing OBIEE reports to include prompt data for new card type and generate new reports to display Fuel Charges.Ø Troubleshoot and analyze existing Talend code to resolve effects Collaborate with the business analysts and ETL team members to resolve complex data design issues/provide optimal solutions that meet business requirements and benefits system performance.Ø Schedule Talend jobs using Talend Administration Center (TAC).Ø Generate SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms and implement logics to fulfill requirements.Ø Prepare, enhance and configure meta data and data models using OBIEE. Build interactive dashboards with drill down effect through Oracle BI Answer. Develop and design complex data structures, ad hoc queries, reports and analytics.
    View
  • Tata Consultancy Services
    Business Intelligence Team Lead/Developer (Obiee Lead/Consultant, Data Analyst, Etl Developer)
    Tata Consultancy Services Jan 2015 - Nov 2017
    Erie, Pennsylvania, United States
    Ø Gather requirements from the client for Engine Standard Process, translate them into technical design documents and work with team members in making recommendations to close the Standards.Ø Worked on several POCs to provide different solutions for business requirements for ex. Smartview for manipulation of data, Cost walk for Cost comparison.Ø Provide end-to-end business intelligence solution by configuring metadata & building Analytics Repository (RPD), dimensional business model design, generating reports, and creating Inter-Active Business Intelligence Dashboards and Answers reports using OBIEE.Ø Develop logical relationships in BMM layer and define Dimensions, Hierarchies, Measures, Aggregate Navigation, level-based measures, Metrics, Time Series Calculations, Aliases, Security management (Data level/Object level security) in OBIEE report development.Ø Build Answers & Interactive Dashboards with drill-down/drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization, utilizing Admin view to manage users, privileges, setting subject area permissions etc.Ø Generate SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms and implement logics to support Engine standard process.Ø Develop individual jobs based on mapping sheets to extract data from homogeneous and heterogeneous sources such as flat files and relational DB to load into Data warehouse using Talend jobs.Ø Work closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to repository.
    View
  • Tata Consultancy Services
    Business Intelligence Developer (Obiee Techno-Functional Developer, Data Analyst)
    Tata Consultancy Services Feb 2014 - Jan 2015
    Guadalajara, Jalisco, Mexico
    Ø Gather requirements from the client for Reports/Dashboards, Analyze, Design, Develop and Implement the solution to fulfill the requirements. Ø Design High Level & Low-Level Design documents, Functional & technical specifications. Ø Create Physical Model, Build BMM / Creation of Star & Presentation Layer, Configure Appropriate Security for Identified UsersØ Create Dashboards and Pages, created 34 Critical Reports and other weekly & monthly reports in Answers, Configured Security.Ø Generate SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms and implement logics.Ø Develop logical relationships in BMM layer and define Dimensions, Hierarchies, Measures, Aggregate Navigation, level-based measures, Metrics, Time Series Calculations, Aliases, Security management (Data level/Object level security) in OBIEE report development.Ø Build Answers & Interactive Dashboards with drill-down/drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization, utilizing Admin view to manage users, privileges, setting subject area permissions etc.
    View
  • Tata Consultancy Services
    Business Intelligence Developer (Obiee Developer/Lead)
    Tata Consultancy Services Apr 2011 - Feb 2014
    Mumbai, Maharashtra, India
    Ø Gather requirements from the client for Reports/Dashboards, Analyze, Design, Develop and Implement the solution to fulfill the requirements Ø Work on new Enhancements, design of new custom reports & dashboards based on the Enterprise Data Model based on Sales, Service modules, Finance, Order Management.Ø Develop SQL queries, PL/SQL interfaces for data verification & validation to populate data into Materialized Views & PL/SQL complex procedures to populate the data into tablesØ Generate SQL and PL/SQL scripts to install create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms and implement logics.Ø Develop logical relationships in BMM layer and define Dimensions, Hierarchies, Measures, Aggregate Navigation, level-based measures, Metrics, Time Series Calculations, Aliases, Security management (Data level/Object level security) in OBIEE report development.Ø Build Answers & Interactive Dashboards with drill-down/drill-across capabilities using global & local Filters, Business Rules with User Identity & Roles, Profiles & Personalization, utilizing Admin view to manage users, privileges, setting subject area permissions etc.
    View
  • Tata Consultancy Services
    System Engineer
    Tata Consultancy Services Oct 2010 - Apr 2011
    Mumbai, Maharashtra, India
    View

Saurabh Vyas Skills

Integration Sap Implementation Leadership Project Implementation It Transformation Outsourcing Supply Chain Management Transportation Management As400 Software Ag Oracle Sql Pl/sql Obiee Cognos Informatica Java Data Warehousing Weblogic Sdlc Etl Databases Business Intelligence Data Modeling Mysql

Saurabh Vyas Education Details

Frequently Asked Questions about Saurabh Vyas

What company does Saurabh Vyas work for?

Saurabh Vyas works for Amazon Web Services (Aws)

What is Saurabh Vyas's role at the current company?

Saurabh Vyas's current role is Senior Business Intelligence Engineer.

What is Saurabh Vyas's email address?

Saurabh Vyas's email address is sa****@****tcs.com

What schools did Saurabh Vyas attend?

Saurabh Vyas attended Rajiv Gandhi Prodyogiki Vishwavidyalaya, School Of Excellence, Mandsaur.

What skills is Saurabh Vyas known for?

Saurabh Vyas has skills like Integration, Sap Implementation, Leadership, Project Implementation, It Transformation, Outsourcing, Supply Chain Management, Transportation Management, As400, Software Ag, Oracle, Sql.

Not the Saurabh Vyas you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.