Aasish Tammana Email & Phone Number

San Diego, Ca, Us

United States

•Develop and maintain data models, dashboards, and pipelines; collaborate with Product, Marketing, and Finance teams to meet their data and reporting needs; manage data models in the data warehouse.•Created Employee Entity by integrating and deduplicating user data from UKG, Jira, and Salesforce. Utilized Data Vault 2.0 methodology to create link tables for the employees with various source systems.•Retraced Salesforce Opportunities using backend Snowflake data by mapping fields after conducting discrepancy analysis and resolution.

Tempe, Arizona, United States

La Jolla Shores, California, United States

• Integrated an AI chatbot (Anything LLM-GPT 3.5) with the company intranet to answer queries based on the documentation hosted. Achieved through a Python script running in a Docker image.• Drove Altium’s market penetration with data driven strategic marketing by securing partnerships with 40+ prominent colleges, facilitating Altium’s curriculum integration, expanding the company's footprint and revenue streams by $80k.

Tempe, Arizona, United States

As a Research Assistant at Arizona State University, I've had the privilege of working under the mentorship of Professor Pitu Mirchandani at the DHS Center for Accelerating Operational Efficiency. My research focuses on the critical intersection of advanced analytics and homeland security operations, with a particular emphasis on the COVID-19 pandemic. In this role, I've had the opportunity to contribute to studies that analyze the impact of various interventions and strategies during this unprecedented public health crisis.Key Contributions:◦ Conducted an extensive analysis of COVID-19 trends, with a particular focus on the years 2020 to 2023. My research delved into the dynamics of the pandemic, the effectiveness of measures implemented, and their influence on different U.S. states. States like Arizona, Alabama, and Vermont served as insightful case studies.◦ Leveraged spatial-temporal data analysis to explore the relationships between COVID-19 vaccinations, masking policies, and case trends. We aimed to determine the extent to which these interventions contributed to reducing the spread of the virus.◦ Explored trends, spikes, and declines in COVID-19 cases, hospitalizations, and deaths. My work shed light on the complexities of the pandemic and the multifaceted factors influencing its trajectory.◦ Collaborated on critical hospital staffing shortage data, providing valuable insights into the challenges faced by healthcare facilities during the pandemic.

Bengaluru, Karnataka, India

Analytics and Cognitive USI:◦ Conducted a full life cycle analysis of requirements, activities, and design through client engagements (Takeda Pharmaceuticals and AstraZeneca).◦ Developed over 20 reports containing different timeline charts and key performance indicator cards for visualization using Power BI DAX Syntax, SQL queries(Databricks Spark), data models. Held demo sessions for knowledge transfer.◦ Directed User Acceptance Testing to implement 200+ key propositions, optimized performance, and increased efficiency of 25+ client dashboards related to Procurement, Legal, Security, Digital Advisory Board, and Travel by 40%.◦ Retrieved, aggregated, cleansed and analyzed vast amounts of data from public web sources for 8 countries using data mining, population sizing, excel macros and automated scripts to support effective decision making.◦ Compiled the data using inferential statistics and time series analysis to generate actionable business insights.◦ Acquired 1 terabyte data from primary and secondary data sources and maintained databases/data systems. Handled the extraction, transformation and load processes to streamline data and connect to Power BI.◦ Scheduled and supervised Tidal Software jobs for 100% workload automation of data loads through data pipelines.◦ Maintained technical design documents, repositories, and upheld code quality of data team with 100% accuracy.

Bengaluru, Karnataka, India

SESSION MANAGEMENT:◦ Revamped a tool from go language to python to accept a Template Call Session Control Function (CSCF) file used for managing signaling from end users to generate 10 generic XML’s and eliminate manual efforts.◦ Wrote Bash scripts to perform md5 check for 4 file systems to ensure information is in same state.

Bengaluru Area, India

IN PLANT TRAINING:◦ Power Plants: An Overview Of Thermal, Hydro, Solar & Nuclear.◦ Control Equipment Manufacturing and Assembly: Ce Fabrication, Main Assembly & System Testing.◦ Management: Project Management, Material Management & Quality Systems

Bengaluru Area, India

INSIGHT INTO PRODUCT DEVELOPMENT AND PRODUCTION

Ms, Robotics And Autonomous Systems (Ai Concentration), 4.0/4.0

Activities and Societies: Grader for the Information Technology course - Programming Logic - IFT 101 (Jan 2023 - Present) Served.

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering, 8.46

Minors, Computer Science And Engineering, 9.5

Senior Secondary, Science, 93.67%

Science, 93.16%