Construct audience purchase segments to analyze brand sales impact and identify target customers on social. media platforms and the CVS portal via CVS Media Exchange (CMX) campaigns using the LiveRamp tool.❖ Execute data preparation, including data retrieval and querying using SQL and Google BigQuery Database, and implement data cleansing processes with R and Python.❖ Planning and developing Tableau workbooks to support business objectives, resulting in a 10% increase in team productivity.❖ Adapt at receiving and monitoring data from multiple data streams, including Access, SQL, and Excel data sources.❖ Generate data cleaning and data wrangling with NumPy, Pandas, and Datetime in Python to merge data, change the data type, remove duplication and null values, and check outliers.❖ Streamline data collection tools through automation to reduce manual effort and improve business efficiency by 80%.❖ Worked directly with business users to de

Conducted routine data validation and rigorous testing of intricate SQL queries on diverse inventory orders, utilizing Teradata SQL Assistant, and pinpointed critical issues to prevent data discrepancies.❖ Participated in all phases of data collection, data cleaning, developing models, validation, and visualization.❖ Utilized R programming within Tableau to construct dashboards for forecasting, prediction, and data accuracy assessments.❖ Extensively engaged in graph creation by combining data from various databases using blending techniques.❖ Efficiently extracted sales and inventory data, generating usable reports and processes to avoid back-ordering.❖ Designed statistical analysis for large customer data sets, lowering cart abandonment rates by ~27%.❖ Provided support to senior data analysts, resulting in a positive impact on the company's overall performance.Project 2: International Data Lake Migration for Retail Client ❖ Engaged with business users and clients to collect project requirements and assess modi=ications, actively analyzing ad-hoc SQL queries.❖ Conducted a Proof of Concept with Google Big Query to validate data accuracy and assess the speed of migrating data from Teradata to the Google Cloud Platform.❖ Established and managed Tableau data models, enhancing data accuracy by 20% and reducing data processing time by 25%.❖ Produced comprehensive documentation elucidating the analysis of various ad-hoc SQL queries for international markets.❖ Worked on an internal portal for accessing all the business services by using Service Now Content Management Application.❖ Use large data sets and Teradata to build statistical analysis models and reports. ❖ Analyzed inventory usage reports and managed end-to-end processes to update and verify special orders.❖ Managed process improvement projects to streamline existing systems and order fulfillment centers.

Employed AWS tools, including Cloud Formation and Elastic Beanstalk, to implement automation processes, resulting in a 60% reduction in infrastructure setup time and a 25% increase in team productivity.❖ Performed Data Cleaning, Data Screening, Data Exploration, Data visualization, Feature Selection and Engineering using Python libraries such as Pandas, NumPy, Scikit-learn (Random Forests), and Matplotlib.❖ Utilized techniques and business intelligence (Tableau) to create 24 dashboards and 35 ad hoc reports to address business problems and streamline processes.❖ Performed data validation of the reports using MS Excel, MS Access and other internal systems.❖ Leveraged PostgreSQL to create and manage extensive databases, boosting data processing effiiciency by 34%.❖ Developed Spark SQL queries to expedite data processing compared to standard MapReduce programs.❖ Collaborated with the ETL team to ensure that source to target mappings are correctly translated into ETL code.❖ Assisted in the design of a data architecture that meets the needs of the organization ❖ Created and maintain data dictionaries and other forms of metadata. ❖ Worked with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.❖ Created source (OLTP applications) to target (DWH) mapping documents to capture additional application data elements.❖ Loaded the source-to-target mapping documents from source systems into the enterprise data warehouse.❖ Collaborated with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.

Created and maintain data dictionaries and other forms of metadata. ❖ Worked with end users to gain an understanding of information and core data concepts behind their business.❖ Involved in extensive data validation by writing several complex SQL queries. ❖ Working with business users to gather requirements and transform them into reports and dashboards using Power BI.❖ Responsible for transforming data from various sources into Power Query Editor (SQL Server, CSV files etc.) to generate business dashboards using pie charts, bar charts, tables, and other visualizations.❖ Troubleshooting data issues, validating result sets, and recommending/implementing process improvements by leveraging the insights from the analysis made.❖ Performed test creation, organization of tests with respect to product releases and components.❖ Consulted with the client area to analyze system requirements and capabilities, identify associated risks, and resolve problems.