Sameera Prasad Email & Phone Number

San Francisco, Ca, Us

Tampa, Fl, Us

Client: NikeCreated and built data pipelines using Apache Airflow and Python for the supply chain inventory team to manage the availability and in-transit inventoriesOptimized and maintained Spark jobs for data migration from AWS EMR to Databricks, Snowflake on AWS Cloud using Pyspark and SQL.Engaged in the resolution of analytics challenges by troubleshooting and designing cloud-based data architecture using AWS stacksCollaborated closely with the project management and business teams to thoroughly outline the requirements for retail listings

Beaverton, Or, Us

Worldwide, Oo

Client: Meta/ Facebook IncCleansed and extracted data using complex SQL queries to fetch data from various sources to improve scalability.Developed metrics to assess the impact of meta-ads on the internal technologies within meta using Python and SQLCollaborated in design discussion to reduce gap between clients and technical consultants regarding end-to-end business requirementsDesigned detailed documentation and reports for clients supporting the functioning of requirement.

Thousand Oaks, Ca, Us

• Automated CI/CD pipelines & ETL process, helping teams migrate real time streaming data to cloud utilizing S3, EC2, DMS• Automated API utilizing Python and Flask to enhance the existing application dashboard of EDL Platform with additional functionalities• and deployed through Kubernetes• Developed cost data and built Billing Cost Tableau Report to notify users related to increase in expenditure and resources• Utilized Apache Airflow to build and orchestrate Pipelines to perform data migration activities for databases like Oracle, Postgres• Cleansed Data using Pyspark and SQL to Develop Tableau Dashboard for business users to study trend of Covid 19 affecting business• Adopted AGILE Methodology to efficiently design the process flow with the development team and stakeholders.• Performed testing and developed a detailed document as a part of Proof of Concept (POCs) for stakeholders.• Collaborated in data fabric discussion and planning with Business SMEs and Solution Architect and took ownership to develop end to end architecture of EDL Platform• Documented details Techub and conducted a knowledge transfer session for users to understand business requirements

Tampa, Florida, Us

Managed customer database to track financial data and spotted fraud transactions according to compensation plans, gift vouchers.•Performed data extraction and data manipulation by writing advanced SQL queries to remove inaccurate data discrepancies. •Designed interactive dashboard reports using PowerBI and Excel to analyze and identify high-risk transactions incurring losses.•Developed solutions to reduce future losses by 67% and generated risk management reports explaining fraud transactions.

Tampa, Florida, Us

•Teaching assistant for Undergraduate level course: ISM Information System Management•Manage students’ records by executing SQL queries to extract information from the database.•Develop and revise reports and presentations.•Mentor students on HTML, Python, SQL and data visualization tools like Tableau by conducting online training sessions and assignments.•Process and develop weekly student progress reports using Tableau, MS Access and advanced Excel tools like Vlookup, Pivot.

Dublin 2, Ie

•Led a team of 3 new associates to resolve service requests related to financial business analytics.•Increased efficiency of payment extraction process by 80% using data extraction, cleansing and root cause analysis of payment failures•Designed interactive dashboards using Tableau and Excel to analyze and share the company’s growth strategy.•Recommended solutions to resolve critical client payment failure incidents and documented reports for assisting clients.•Volunteered for a Global event on Inclusion and Diversity in the workplace and received recognition for delivering outcomes on time.

Master'S Degree, Business Analytics Information System

Bachelor'S Degree, Electronics And Telecommunications Engineering

Executive Mba, Project Management