Overland Park, Kansas, United States
• Analyzed complex financial datasets using SQL, enabling enhanced data extraction and query performance for business analysis. • Developed extensive financial reports and dashboards using Tableau, facilitating better visualization and understanding of data trends. • Managed project documentation efficiently using SharePoint, ensuring easy access and collaboration across financial teams. • Integrated financial data processing workflows into Confluence, standardizing documentation and enhancing team collaboration. • Constructed predictive models using Amazon SageMaker, effectively forecasting financial outcomes and customer behaviors. • Administered AWS S3 for secure and scalable data storage, optimizing data management practices for financial datasets. • Collaborated closely with marketing and solutions teams to gather and prioritize data requirements, supporting CRM and omnichannel campaign operations. • Utilized SQL and Databricks to analyze complex datasets, validate data quality, and deliver insights aligned with marketing objectives. • Implemented AWS Redshift for data warehousing, significantly improving data retrieval and storage efficiency. • Utilized Apache Spark ALS for developing recommendation systems, enhancing personalized financial services and product offerings. • Supported marketing teams by diagnosing and resolving data-related issues, enhancing data accuracy for campaign activation tools. • Automated data integration and cleansing processes with Alteryx, significantly improving data quality and operational efficiency. • Conducted advanced data analysis using R language, providing deep insights into financial patterns and risk factors. • Employed AWS Recognition to perform detailed image and text analysis, enhancing data interpretation capabilities. • Designed and executed machine learning models with AWS SageMaker, boosting the bank’s analytics capabilities for predictive insights.
• Designed SQL queries to manipulate and manage retail data, enhancing decision-making and operational efficiency in the retail environment. • Developed SQL-based reports to support marketing’s understanding of customer behavior, aiding in audience segmentation and personalization efforts. • Created and maintained dashboards using Power BI and Qlik Sense to enable marketing managers to track campaign performance and inventory levels. • Created interactive dashboards using Power BI, providing actionable insights through visual analysis of sales data and customer trends. • Leveraged Qlik Sense for dynamic data visualization, aiding retail managers in understanding product performance and inventory levels. • Enabled self-serve analytics for marketing teams by consolidating data across various sources, including Google Data Studio and Looker. • Automated reporting processes using Python and SQL, improving efficiency in data handling for marketing and customer analytics. • Utilized Looker to integrate and analyze retail data, generating comprehensive reports that guided strategic planning and resource allocation. • Employed Google Data Studio to consolidate data from multiple sources, facilitating a unified view of retail operations and customer interactions. • Developed statistical models in MATLAB, analyzing complex datasets to identify patterns and predict future retail trends. • Applied Matplotlib in conjunction with Python to produce detailed graphical representations of data, enhancing the presentation of retail analytics. • Managed retail databases using Azure SQL, ensuring robust data storage, security, and accessibility for all levels of the organization. • Implemented data warehousing solutions with Azure, optimizing data aggregation and retrieval processes to support large-scale analytics. • Streamlined real-time data analysis using Azure Stream Analytics, enabling immediate response to market changes and customer demands.
• Integrated SQL and Oracle Data Integrator for seamless data flow between different healthcare systems, enhancing data consistency. • Managed healthcare data integrations using Apache NiFi, ensuring real-time data availability and system interoperability. • Utilized Informatica for complex ETL processes, streamlining data transformation and loading to improve healthcare data analytics. • Employed Kafka for efficient data streaming, facilitating timely data processing and analysis in healthcare operations. • Conducted data cleansing and transformations using SSIS, ensuring high data quality and reliability for healthcare reporting. • Analyzed healthcare data using Microsoft Excel, producing detailed reports to support clinical decisions and administrative planning. • Developed data documentation and governance protocols using GIT, maintaining data integrity and compliance with healthcare regulations. • Managed data interactions and integrations using FTP/SFTP, securing data transfers across healthcare systems. • Leveraged Linux-based systems for hosting and executing healthcare data operations, ensuring system stability and security. • Utilized XML and JSON for data interchange among healthcare systems, enhancing data accessibility and interoperability. • Implemented data extraction and integration processes using RESTful APIs, automating data flows and reducing manual efforts.
• Managed and optimized Microsoft SQL Server databases, enhancing performance and security for financial transaction processing. • Developed complex T-SQL scripts for data manipulation, improving data processing efficiency and reporting capabilities. • Utilized SSMS for database administration, optimizing queries and maintenance tasks to enhance system performance. • Created detailed financial reports using Excel, providing insights into transaction trends and operational efficiencies. • Maintained comprehensive system documentation, ensuring best practices and compliance with data management standards. • Developed and maintained GIT repositories for code versioning, enhancing collaboration and code quality in project development. • Monitored database performance using SQL Server tools, identifying and resolving issues to maintain system reliability. • Utilized Excel for advanced data analysis tasks, including pivot tables and data visualization for stakeholder reporting. • Implemented data backup and recovery procedures using SQL Server, ensuring data integrity and availability. • Conducted regular data audits using T-SQL, ensuring compliance with regulatory standards and data accuracy. • Automated data workflows using Python scripting, improving operational efficiency and reducing manual data handling. • Optimized data queries and indexes using SSMS, enhancing database performance and user query response times. • Facilitated team collaboration and project tracking using GIT, improving development processes and outcomes. • Developed SQL-based solutions to handle large datasets, enhancing data analysis and business intelligence capabilities. • Enhanced data security measures through rigorous SQL Server configurations and regular system audits. Environment: Microsoft SQL Server, SSMS, Excel, GIT, Python, SQL Server tools.