Sandra .O. Email & Phone Number

Irving, Texas, Us

• Conducting continual data integrity checks to ensure distributor sales reports are accurate and complete. Performing 3 specific data validations on member, product and contract data. • Processing daily pharmacy claims to downstream pharmacy applications and tools. Serving as a SME on advanced analytical processes, procedures and validated pharmacy spend data. Working with various internal and external stakeholders to correct erroneous source data.• Developing mapping and data processing procedures to import data from various data sources and populate the client database.∙ Performed data validation and data integrity checks ensuring the accuracy and completeness of pharmacy distributors reports∙ Tracked and reported weekly metrics related to performance∙ Developed/Executed SQL queries from multiple large databases (Oracle and SQL server), analyses and deliverables for leadership including standard and ad-hoc reports∙ Performed ETL using SQL in Microsoft Azure Studio• Resolve SalesForce ICE Cases on an ongoing basis, delivering high quality reports with a quick turnaround for any ad-hoc data request reports.• Work closely with team to understand & apply ETL to Automated Data Submission feeds/loads through the different screening & staging layers, from File Explorer (FE) to Spend Manager (SM), and subsequently into ODS, every month

New York, Ny, Us

• Collate updates on projects, reviews the data with the team and generate project status reports• Analyze data including creating pivot tables, VLOOKUP, and graphs using excel • Format, manipulate, and analyze large data sets, all while maintaining the highest levels of data accuracy.• Excellent organizational skills and the ability to manage multiple tasks at the same time• Able to manipulate complex data from multiple sources and work with users of the data to define actions and outcomes.• Perform Level I Delivery and Product Analysis using documented research methods• Use and update SQL code for deliverable processing• Identify and escalate missing data (inputs) to Production Support and Supervisor for immediate action• Strong Knowledge of Power BI to import data from various sources such as SQL Server, Text/CVS and Excel workbook

Atlanta, Ga, Us

• Use SSRS, Microsoft Power BI and Microsoft Excel: Pivot Table, Power Query, Power Pivot, and Data Models to gather information from multiple sources and deliver information to the end user• Experienced performing analysis and presenting results using SQL, SSIS, MS Access, Excel, SharePoint, Pivot Tables and Visual Basic scripts• Reviewed data and classified the tables /measures function by using multiple queries, view, and procedures.• Troubleshoot T-SQL, SSIS and SSRS errors and performance issues and address them as required• Assisted managers and business units in developing reports, presentations, and analysis for managements.• Formulated and documented the physical ETL process design based on business requirements and specifications. Demonstrated strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, and expressions.

Bachelor'S Degree, Computer Science

Education record