Punjab Technical University

University of Florida - Warrington College of Business

Senior Product Marketing Data  Analyst at Oracle

San Francisco, California, United States

- Using Advanced R scripts and SQL queries to calculate churn and growth of customers  consuming different services and also, performing analysis to understand the M/M, Q/Q, Y/Y trends•	 Performing correlation analysis around buying/usage  trends of customers using different services at the same time and helping product managers understand these patterns•        Providing operational support by Automating manual tasks around measuring weekly/ monthly product KPI's, marketing asset performance, etc using R, SQL, Adobe Analytics and Oracle Analytics Cloud (OAC)•	Creating presentations for Marketing Leadership and other stakeholders capturing insights around customer segmentation, target audience sizing guide for single or even combination of Oracle Products •	Building ad-hoc reports  using web analytics tools like Adobe Analytics(Omniture SiteCatalyst) to gather insights around web traffic and customer experience to help Marketing and Product teams measure the overall asset performance and to assist in measuring the impact of their efforts•	Leveraging Oracle Analytics Cloud( OAC), creating dashboards to provide cross-product pillar insights and also capturing service usage for customers across different regions•	Supporting Product Management Team in survey creation and to help drive key product insights•	Measuring the performance of online and offline campaigns and reporting on marketing KPIs like leads, conversion rates, website traffic, influence analysis, etc

Oracle

Senior Product Marketing Data  Analyst

- Creating dashboards using SQL & Tableau to help distill insights into presentation format for Marketing leadership and also non-technical audiences primarily focusing on Pipeline, Growth, and other operating metrics •	Performing deep dives into a lead to customer profiles for specific events for analysis to showcase attendees and their interests for products and services•	Analyzing interactions, leads, opportunities, dashboarding and presenting insights to help Marketing, Sales and Product teams understand MoM/QoQ/YoY trends•	Analyzing and creating pipelines for Marketing Operations that could help bring more quality leads and help assist Demand Management in Lead routing using Salesforce•	Using Statistics, measuring the effectiveness of campaigns and their performance based on the rate of conversions and engagement of the leads that could help scale new nurture channels within Marketing•	Performing a deeper analysis, mainly correlations with intent to understand the behavior of prospects /suspect in Salesforce/ Marketo and  their interactions with the most effective marketing programs/ channels using R, MSSQL and Tableau

Citrix

Sr. Analyst, Marketing Advanced Analytics

- Gathering data, to analyze the customer profile, segmenting customer feedback, and dashboarding them into sentiments based on the result of a campaign or survey using advanced SQL, R scripts and Tableau•	Generating, updating and decommissioning the customer/ partner attributes by leveraging Salesforce for marketing analysis and improving the overall customer experience•	Collecting data from disparate sources within Salesforce to perform data preprocessing and reporting key performance indicators ( KPI's) to the leadership for different geographic locations•	Creating data models, maintaining databases and performing sanity testing of customer/ partner data against Salesforce(CRM) for accurate reporting•	Designing surveys using Qualtrics and Vision Critical to register the response and feedback from the customer and partners for better product experience and market research •	Using Advance R scripts and SQL queries to calculate churn as well as retention rate for customers and partners and also, performing analysis to understand the MoM, QoQ trends•	Contributed to research projects and recruited 5500 + customer, influencers and partners to help learn more about their experience and bridging the gap between Product and Engineering teams

Marketing Insights Analyst

- Conducted multivariate tests to measure the performance of Citrix ADC( Web Traffic Load Balancer) as a part of the performance engineering team and comparing them against other predefined sets of 18 KPI's / matrix •	Leading and maintaining performance regression testing in an effective way for new and existing Citrix ADC(MPX version) by leveraging existing framework using Python, Linux, Perl, and MySQL•	Created automated test cases using Python to measure the performance of Citrix ADC along with conducting regular and ad-hoc analyses•	Worked as a performance test engineer to set up performance automation strategy for networking products using Python, MongoDB, and MySQL •	Implemented performance characterization for the new product (Citrix ADC )and collaborating with sales and product teams to project performance matrix to internal/ external stakeholders•	Working  closely with Dev and Test Engineering teams to manage the movement of hardware(servers, networking assets, etc) from on-premise to colocations and planning for quarterly/yearly budget for new engineering resources

Software Test Engineer - 2

- Deployed and supported the Enterprise Mobility Management (EMM) solution on existing Fortune         500 companies •      Supported the sales(pre/ post) teams in performing proof of concept(POC) and post-implementation of mobile solutions with upgrades and assisting in other technical requests/issues•	Engaged with existing VMware clients/customers to access and scope their unique product needs•	Interfaced with quality analysts  as well as  between engineering, product and consulting teams to         communicate clients’ complex technical issues, identifying trends and opportunities to ensure         speedy and recommend resolution

VMware

Software Consultant

- Worked as a full-stack developer involving the designing and developing an existing web application using the .NET framework, HTML, CSS, and MSSQL•	Creating ER diagrams for designing and modeling databases for effective data management, querying, validating, and auditing •	Provided technical software support to employees (Directors, Student Assistants, etc) at the Career Resource Center (CRC)

University of Florida

Graduate Student Assistant  -  Website Developer

- Implemented the data migration and certifying of an existing ADS application( built using DB2 and Oracle) over to MSSQL and created client questionnaires•	Automated and engineered the manual load process of extraction, loading, and transformation of functional specification using Java and other batch scripting tools

Business Intelligence Analyst Intern

- Designed, Build, Extracted, analyzed, loaded and transformed(ETL) functional designs to improve business performance and reduce risk•	Assisted and supported various processes( SSIS, SQL)  running in production •	Optimized and reduced business reporting that initially took 30 hours down to 1 hour and 18 minutes using Big Data (Cosmos) for Xbox and Windows 8; this aided the client in decision-making and forecasting for its upcoming product launch•	Created dashboards/ reports to showcase trends in subscription and entertainment industry data; this helped client draw correlations from campaign trends and do further predictive analysis•	Coordinated with the client on data  mining for analyzing, outlining data collection requirements, and creating data shapes for understanding the online purchase behavior of Microsoft’s customer base•	Chosen as a subject matter expert (SME) from Accenture to transition business knowledge on key performance indicators to vendor teams at the client site (Microsoft, Redmond)	

Accenture Technology Solutions

Senior Business Intelligence Analyst

- Worked as Business Intelligence (BI) developer and implemented the functional specification for migration of data from legacy systems to Operational Data Store•	Designed, Created and Supported ETL processes to Automate data collection and maintained reporting processes/pipelines including data quality•	Designed and executed optimized business reports by using tools like SSIS, SSAS, SSRS and Report Builder 2.0 •	Took on the additional responsibility of Database Administrator for managing and maintaining clients data space •	Led a team of functional testers and gained expertise in utilizing reconciliations, sanity, report-level and cube testing

Tarun Sharma