ASHWIN SATHU

• Implemented self-service reporting functionality in Sisense, empowering stakeholders to analyze and extract insights from data independently; reduced report generation time by 40% and enabled timely, data-driven decision-making for stakeholders.
• Analyzed data trends, visualized key data quality metrics and key performance indicators (KPIs), and engaged the Product team by providing insights for 3 new reporting features.
• Spearheaded End-to-end testing, validating and final sign-off on all features going into the product, including creation of automation scripts, validation, security, functional, regression, and load test scripts, data dictionary, documentation and executing the scripts in AWS/Databricks/DBT.
• Identified new data that needs to be implemented into the data warehouse and collaborated with the team to ensure that the data is migrated.
• Authored data scoping on metadata, data deduplication, document/update mapping and transformations in AWS/Databricks and Sisense/Birst.
• Identified issues, performed root-cause analysis of data irregularities, and have them resolved.
• Led validation efforts for the Data Engineering team to migrate code from AWS to Databricks.
• Created scripts for Regression testing of all Sisense dashboards, reports, attributes, and measures.
• Acted as Subject Matter Expert and provided support to Customer Reps for servicenow tickets.

Environment: AWS, S3, Athena, Databricks, Dbt Cloud, Paradime, Birst, Sisense, SQL Server, Jira, IntelliJ, Confluence, Kafka, Airflow, Spark, Python, SQL, Slack, GitHub, Mastercontrol, Postman, Snowflake

• Supported data needs for multiple product teams for their reporting/analysis.
• Acted as Interim Data Modeler and created/updated Data models based on requirements using Erwin.
• Validated job design and data flow, ran, and monitored jobs/ sequences using Datastage.
• Ensured quality data flow from Hadoop(HDFS) into the target tables without any discrepancies.
• Created DW Automation Regression suites and documented the process in Confluence.

Environment: Oracle 11g, SQL Developer, Datastage 11.7, JIRA, Agile, Confluence, Hadoop Impala (HDFS), Agile, BitBucket, UltraEdit, Kafka, DbVisualizer Pro, Hue, Control-M, Sourcetree.

• Onboarded 15 new vendors, set up their SFTP connections and validated the files sent via SFTP.
• Established governance of data feeds from third party vendors to ensure traceability, ownership and compliance in partnership with business, vendor management and compliance/audit.
• Implemented File Auditing, Data Profiling, Trend Analysis for multiple daily, weekly, and monthly production files to track and cleanup bad data from the database, increasing data efficiency by 60%.
• Created several data extracts from Oracle Data warehouse weekly for internal reporting and analysis.
• Evaluated, processed, analyzed, and created statistical profiling data for reporting using Tableau.
• Conducted risk analysis and assessment to estimate campaign outcomes using data extracts.
• Worked with Community & State, Medicare & Retirement, Employee & Individual data, HEDIS 2018/2019/2020 data related to Diabetes, Asthma, Child Imm, WellChild, Adult, Women etc.
• Designed complex SQL scripts to perform Data Validation, Data Profiling and Auditing.

Environment: Oracle 11g, Maestro, Workfront, Sharepoint, Tableau, IpSwitch, Python, Kafka

• Led QA team on a large Data Migration project to move from Ditech’s custom mortgage system to MSP, achieving timely bug-free migration.
• Managed a small team of 5 QA by coordinating and distributing tasks as per business needs, conducting daily status update sessions, represented the QA team for weekly status update with project team.
• Scripted complex SQL queries based on design documents which included complex calculations for Mortgage PI, PTR, ARM, Servicer, Investor, Shortage/Surplus etc.
• Designed test artifacts to validate multiple PowerBI reports that needed to be sent to FNMA.

Environment: Oracle 11g, SQL Developer, MS Test Manager, PowerBI, JIRA, Sharepoint, UltraEdit

• Performed data analysis and created analytics in Cognos which helped increase customers' (farmers) farming efficiency by 25%.
• Worked with very little to no-documentation to come up with test cases and build SQL validation scripts.
• Tested Windows and Mobile version of CPS Central and CPS Guest login using SOAPUI.

Environment: Netezza 6.0, Aginity Query Analyzer, IBM Datastage 8.7, HP ALM, Cognos 8.0, SOAPUI 4.0, SharePoint, UltraEdit, MTM/TFS 2012

• Responsible for QA efforts during each phase of the software development life cycle.
• Compared and validated all reports that were migrated from Business objects to Microstrategy.
• Created complex SQL queries to test and validate the backend DW data and front-end report data.
• Created Automation Suite for all report related test cases using Microstrategy Integrity Manager reducing validation time by 40%.

Environment: Oracle RDBMS 10g/11g, SQL Server 2012, SSMS 11.0, SAP BO, Microstrategy 9.0, HP ALM 11.0, TFS 2010, Test Manager, Jira, Citrix, Mingle, IBM Clearquest 8.0, NEO, SSIS, Informatica.

• Represented the QA team in scrum meetings and coordinating all QA efforts.
• Created complex SQL scripts from scratch for testing ETL jobs/tables and Business Objects Reports.
• Worked in an ERP system environment, used SAS EG to query the tables and store the datasets.

Environment: DB2 9.7, AQT 9.0, HP Quality Center, PL SQL, SSIS, Business Objects, SAS EG 4.3, Agile.

• Spearheaded QA efforts for the ETL and BI teams for Data Migration project, established working templates for Test plan, Test cases and Test scripts for ETL and BI related projects.
• Validated several Scorecards, Drilldown and Pivot reports published in Microstrategy and Tandem.
• Successfully migrated all reports from a legacy reporting system (Tandem) to Microstrategy.
• Validated the DTS and SSIS batch processes and stored procedures, ensuring bug-free code.

Environment: SQL Server 2008, T-SQL, DTS/SSIS, Microstrategy, SSMS, Test Track Pro, MTM/TFS 2010

• Actively involved in multiple projects (Data Migration and Data Integration projects) in an Agile environment, each running parallel with the other and with tight deadlines.
• Defined and implemented quality initiatives to reduce risk when using sensitive Claims data.
• Verified the mappings and the data flow, ran the workflows, and monitored status in Informatica.
• Managed and delivered scheduled, recurring reports in SAP Business Objects to stakeholders.

Environment: Oracle 10g/11g, TOAD 9.0, AQT, VersionOne, SAS, FTP Pro, Putty, Informatica 9

• Responsible for converting and validating xml files generated using EDI standards
• Performed extensive data testing for Data Migration from SAP BI to Oracle 11g environment
• Tested and executed Informatica Batch processes prior to data validation
• Environment: Oracle 11g, TOAD, HP ALM, JIRA, SQL, SAP BI, Informatica, Filezilla, VI Editor, XML