Prem Shah Email & Phone Number

Burbank, Ca, Us

· Develop and monitor critical business impacting KPI such as Ad deliveries, reach, revenue for each campaign using industry leading analytical BI tools like Tableau & MicroStrategy for our Streaming Service Platform. Write complex SQL queries against Snowflake & Microsoft SQL Server to bring in valuable insight to help optimize ad targeting practice ending in boosting streaming revenue. · Utilize JIRA to capture ad-hoc analysis request from our business stakeholders, conduct one-on-one meetings with them to translate those business requirements to technical specs. Track development of these requests through Sprint and work with QA to validate developed reports and dashboards before handing back over to our stakeholders.

Dallas, Tx, Us

Dallas, Tx, Us

· Provide meaningful insights through dynamic analytics and visualizations to help upper management make data driven marketing decision improving the accuracy of the organization’s postpaid forecasting model.· Automate analytical dashboards and reports using Tableau & Excel to help accelerate the time taken from raw data to meaningful analytics as well as reducing human reliance and saving the department 25 weekly man hours.· Perform ad-hoc analysis to provide detailed drill down information for specific business queries and requests from upper management as well as executive teams.· Mentored and trained team members across various Marketing & Sales organization on their code migration projects utilizing new Palantir platform.

Dallas, Tx, Us

· Utilized MS SQL, Tableau, Excel, and Power BI (dashboard & visualization tools) for data analysis and to create visually impactful dashboards.· Improved quality and reliability of products by highlighting critical production issues through critical KPI within Tableau dashboards, on real-time basis helping factories save ~750K dollars annually by cutting down re-work activities.· Led a team of data analysts to improve production yield to 99.5%, reducing customer complaints, rollouts, and service calls, saving company close to 2.5 million dollars annually.· Provided daily, weekly, monthly, and quarterly production quality reports and dashboards for various level of management groups.

Temecula, California, Us

I have been in the real estate services business in the Anaheim Hills, Cerritos, Cypress, Laguna Beach, Newport Beach, Huntington Beach, Orange, Yorba Linda, and Irvine real estate markets for quite few successful years and will be here for many more. This longevity and confidence comes from my real estate services to a great many buyers and sellers, and their recommendations to others that result in repeat and referral business that keeps me productive and successful.As a full service real estate professional, I work with buyers, sellers and investors in real estate transactions spanning all of the price ranges and property types.

El Segundo, Ca, Us

· Established a uniform secure communication link between DIRECTV and 25 different global supplier sites for easy, encrypted data transfer.· Architected and designed databases and table structures in MS SQL Server to capture 35M+ weekly production data records and normalize it from global factories across various suppliers.· Used Google Analytics to run reports with back-end connection to MS SQL server.· Identified and implemented an immediate resolution system to monitor data anomalies to highlight outliers and anticipate database.

El Segundo, Ca, Us

· Lead a team of test engineers in charge of developing complete test automation framework for set-topbox middleware testing.· Successfully developed and validated a complete regression test suite comprise of 50+ functional testprocedures and automation test scripts.· Developed a VBA based macro enabled Excel workbook to auto log test validation failures fordevelopment team on JIRA / QC database.

San Jose, Ca, Us

· Curated 40+ distinct test procedures and test cases based on requirements from QA manager forvarious DIRECTV STB Middleware.· Provided technical support to cross functional test teams, through improvised solution forefficient and effective test practices for new product testing.· Provided daily defect analysis report found during testing to development team for furtherinvestigation and potential fixes.

Bachelor Of Science (B.S.), Electrical Engineering

Certificate, Six Sigma Green Belt Process Improvement

Certification, Data Science

Specialization Certified, Business Intelligence & Data Warehousing