Swapnil

SEO Reports Automation Data Preparation: Collected Data from Existing system(Sharepoint, Flat Files) and imported in Snowflake using SAS Macros, Also Download data on weekly basis from Google Data Studio and Google Search console to track the performance and different KPIs for Keywords, URLs and Pages of Client's Portal. Data Integration: Created a Project end to end which performs data cleaning, Import weekly downloaded files merging different datasets to identify the top performing monthly keywords and move those final datasets into Snowflake using SAS for powerBI consumption. Switched PowerBI connection from existing Sharepoint folder to Newly created Snowflake tables. Enhanced PowerBI reports by using calculated Measures and automatic scheduling it on weekly basis. Data Analysis/Strategy : Created KPIs using SAS to identify Monthly Top performing Keywords on Google search for Clients portal, Number of Clicks and Impression on Links. Paid Search Daily reports to analyze the daily expense on google and Microsoft. Analyze Vendor(Insurer) performance by creating reports in SAS Data Preparation: Imported premium data from DB2 system and perform complex ETL jobs such as merge, append, pivot etc using PROC SQL, created relationship between various dataset and performed data cleaning, transformation and pre-processing to prepare the data for reporting. Data Analysis and Strategy Calculated the reported KPIs such as Annual/Monthly premium paid by the client, number of employee covered etc. for various health plans provided by the insurers. Created a detailed report for internal consumption to help derive strategic decision making and a consolidated report for the client to report to US government.' Data Integration after an acquisition (or Merger) Data Preparation: Imported all relevant data from multiple sources such as flat files and DB2 Systems using proc import and proc sql and performed necessary data cleaning, transformation and pre-processing to ensure accuracy and consistency in the data. Data Integration Loaded the Newly acquired entity's data in corresponding DB2 Tables ensuring precision in terms of format and informat stored. Translated the newly acquired data as per the existing system through mapping using PROC Format. Created new Activities in "Workbench Conversation" and internal tool, that interacts with the DB2 system to load and transform the data. Analysis and Strategy: Created reports in SAS/SQL to analyze the quality of data integration into DB2 system using JCL and setup configuration tool by triggering pre-designed activities