際際滷

際際滷Share a Scribd company logo

Rajeev Tiwari Projects Xavient

Download as DOC, PDF
R
Rajeev Tiwari

This document outlines several projects the author has worked on in business intelligence and data analytics. It describes roles as a solution/data architect, lead developer, and developer on projects involving data warehousing, ETL, reporting and dashboarding. Technologies used include Tableau, Oracle, SQL Server, Teradata, Hyperion and AWS. Responsibilities included requirements gathering, data modeling, design documentation, testing, and resource management. The projects were for companies in media, telecom, and satellite television industries.

1 of 2
Download to read offline
Assignment/Project Details Solution/Data Architect: OMS Analytics Neustar, US: (Current Project) Environment Tableau, Oracle, HTML, Java, Tomcat, Angular JS, Jira, Agile Synopsis Neustar is a trusted, neutral provider of real-time cloud-based information & analysis to the Internet, telecom, financial, media & advertising and retail industries. This Project is for creating an Analytics application which will ensure Data Security by allowing only authenticated users to access their relevant dashboards with data specifically meant for them. As part of this assignment, I had completed the assessment study, understood the business requirement, monitored and mentored overall solution design. Also involved in delivery & resource management from offshore. Architect/Lead cum Developer: Jabber Migration Project Dish Network, US Environment SSIS, SQL Server 2012, Postgres Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers This Project was about migrating data for Lit Hold users from Postgres cluster (9 nodes) where Jabber messages are stored. Information for the Lithold users is available in LDAP. In this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD). I also worked in the capacity of coordinator cum developer from offshore. Solution/Data Architect: BI-DW POC Cadreon, US Environment Data Warehousing, Unix Shell scripts, Tableau, AWS, Redshift, Amazon S3 Synopsis Cadreon is IPG Mediabrand's Ad Tech unit, responsible for developing best-in-class programmatic technology solutions. This POC was to test the feasibility of Redshift for their DW/BI requirement. As part of this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD) for building the new Data warehouse and analytical reporting solutions. Involved in delivery & resource management from offshore. Architect/Lead cum Developer: CIBR Migration Project Cadreon, US Environment MSBI 2008, .Net, Oracle 11g, Perl, Amazon S3, Golden Gate, Java, AWS and Tableau Synopsis Cadreon is IPG Mediabrand's Ad Tech unit, responsible for developing best-in-class programmatic technology solutions. This Project was to redesign and migrate existing CIBR Project from MSBI technologies to Java, Oracle and Tableau based on cloud environment. In this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD) for building the new Data warehouse and analytical reporting solution. I also worked in the capacity of DB developer along with delivery & resource management from offshore. Lead Developer: CIBR Project Cadreon, US Environment MSBI 2008, .Net, Perl and Tableau Synopsis Cadreon is IPG Mediabrand's Ad Tech unit, responsible for developing best-in-class programmatic technology solutions. This Project was for creating an application for collecting, cleansing, messaging and then uploading data into the Database and then show them in the form of Report/Dashboards to Cadreon analytics team for reviewing performance of campaigns. In this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD) of the new application for Data processing and analytical reporting solution. I also worked in the capacity of DB developer along with delivery & resource management from offshore. Developer: BI Migration Project Echostar, US Environment Teradata, Oracle and Hyperion Synopsis EchoStar Corporation is a global satellite services provider and developer of hybrid video delivery technologies. It is the owner and operator of the satellite fleet for closely affiliated Dish Network. In this assignment, we had to ensure migration of reports from Hyperion 8.3 to 9.3. I was responsible for Testing of reports in new and old environment and identifying the issues as well fixing of the issues. Created/Updated data models, SQL Queries and Dashboard (wherever required). Developer: Business Analytics RFCs Dish Network, US Environment Teradata and Hyperion Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers
In this assignment, I was responsible for doing feasibility analysis, Impact analysis and making changes to the existing reports as per the BRDs. In case of request for new reports creating data model, queries and Dashboard (wherever required). Developer: Dashboard Automation Dish Network, US Environment Teradata and Hyperion Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers In this assignment, I was responsible for automating Dashboard in BQY which was built in Excel and was consuming a great deal of manual time and manipulation. I created data model, queries and Dashboard. Developer: RSN Consolidation Dish Network, US Environment Informatica, Teradata and Hyperion Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers In this assignment, we had to identify similar reports, SQL scripts and processes running on EDW; consolidate them to cut down on the number of queries hitting the database thereby improving performance and processes. We had cut down the count of reports for one domain from 28 to 6 and merged 12 similar interactive reports into one consolidated dashboard driven report. .

More Related Content

Rajeev Tiwari Projects Xavient

  • 1. Assignment/Project Details Solution/Data Architect: OMS Analytics Neustar, US: (Current Project) Environment Tableau, Oracle, HTML, Java, Tomcat, Angular JS, Jira, Agile Synopsis Neustar is a trusted, neutral provider of real-time cloud-based information & analysis to the Internet, telecom, financial, media & advertising and retail industries. This Project is for creating an Analytics application which will ensure Data Security by allowing only authenticated users to access their relevant dashboards with data specifically meant for them. As part of this assignment, I had completed the assessment study, understood the business requirement, monitored and mentored overall solution design. Also involved in delivery & resource management from offshore. Architect/Lead cum Developer: Jabber Migration Project Dish Network, US Environment SSIS, SQL Server 2012, Postgres Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers This Project was about migrating data for Lit Hold users from Postgres cluster (9 nodes) where Jabber messages are stored. Information for the Lithold users is available in LDAP. In this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD). I also worked in the capacity of coordinator cum developer from offshore. Solution/Data Architect: BI-DW POC Cadreon, US Environment Data Warehousing, Unix Shell scripts, Tableau, AWS, Redshift, Amazon S3 Synopsis Cadreon is IPG Mediabrand's Ad Tech unit, responsible for developing best-in-class programmatic technology solutions. This POC was to test the feasibility of Redshift for their DW/BI requirement. As part of this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD) for building the new Data warehouse and analytical reporting solutions. Involved in delivery & resource management from offshore. Architect/Lead cum Developer: CIBR Migration Project Cadreon, US Environment MSBI 2008, .Net, Oracle 11g, Perl, Amazon S3, Golden Gate, Java, AWS and Tableau Synopsis Cadreon is IPG Mediabrand's Ad Tech unit, responsible for developing best-in-class programmatic technology solutions. This Project was to redesign and migrate existing CIBR Project from MSBI technologies to Java, Oracle and Tableau based on cloud environment. In this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD) for building the new Data warehouse and analytical reporting solution. I also worked in the capacity of DB developer along with delivery & resource management from offshore. Lead Developer: CIBR Project Cadreon, US Environment MSBI 2008, .Net, Perl and Tableau Synopsis Cadreon is IPG Mediabrand's Ad Tech unit, responsible for developing best-in-class programmatic technology solutions. This Project was for creating an application for collecting, cleansing, messaging and then uploading data into the Database and then show them in the form of Report/Dashboards to Cadreon analytics team for reviewing performance of campaigns. In this assignment, I had completed the requirement analysis, build the new data model, and completed the design documents (Data Mapping, HLD and LLD) of the new application for Data processing and analytical reporting solution. I also worked in the capacity of DB developer along with delivery & resource management from offshore. Developer: BI Migration Project Echostar, US Environment Teradata, Oracle and Hyperion Synopsis EchoStar Corporation is a global satellite services provider and developer of hybrid video delivery technologies. It is the owner and operator of the satellite fleet for closely affiliated Dish Network. In this assignment, we had to ensure migration of reports from Hyperion 8.3 to 9.3. I was responsible for Testing of reports in new and old environment and identifying the issues as well fixing of the issues. Created/Updated data models, SQL Queries and Dashboard (wherever required). Developer: Business Analytics RFCs Dish Network, US Environment Teradata and Hyperion Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers
  • 2. In this assignment, I was responsible for doing feasibility analysis, Impact analysis and making changes to the existing reports as per the BRDs. In case of request for new reports creating data model, queries and Dashboard (wherever required). Developer: Dashboard Automation Dish Network, US Environment Teradata and Hyperion Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers In this assignment, I was responsible for automating Dashboard in BQY which was built in Excel and was consuming a great deal of manual time and manipulation. I created data model, queries and Dashboard. Developer: RSN Consolidation Dish Network, US Environment Informatica, Teradata and Hyperion Synopsis Dish Network (stylized as "dish") is an American direct-broadcast satellite service provider. The company provides satellite television, satellite Internet access, audio programming, and interactive television services to commercial and residential customers in the United States. As of April 2016, the company provided services to 13.9 million television and 628,000 broadband subscribers In this assignment, we had to identify similar reports, SQL scripts and processes running on EDW; consolidate them to cut down on the number of queries hitting the database thereby improving performance and processes. We had cut down the count of reports for one domain from 28 to 6 and merged 12 similar interactive reports into one consolidated dashboard driven report. .