| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Business Intelligence Sql Server Smithfield, PA Sql Server Production Support Coraopolis, PA SQL SERVER DBA Pittsburgh, PA Computer Science Sql Server Canonsburg, PA Qa Analyst Selenium, API and database testing, SQL, Postman Carnegie, PA Prior Authorization Customer Service Pittsburgh, PA Sql Developer .Net Pittsburgh, PA |
|
Click here or scroll down to respond to this candidate1 PageCandidate's Name
Telephone: PHONE NUMBER AVAILABLE, Email: EMAIL AVAILABLEKey I.T. Skills Analytical Tools: SQL Server Analysis Services (SSAS Tabular), Power BI, Tableau, ThoughtSpot, IBM Watson, Excel (Power Query/ Pivot/ Map) Reporting Tools: SQL Server Reporting Service (SSRS), Tableau, Power BI, ThoughtSpot, AWS Quick Sight Database: Microsoft SQL Server 2012/2014/2016 ETL: SQL Server Integration Service (SSIS), SQL Server Data Tools (SSDT) Cloud Technologies: AWS-s3 bucket, Athena, Google Cloud, Azure- Azure SQL, Azure Synapse analytics, Azure Data factory, Azure Blob Storage, Snowflake Programming Languages: T-SQL, DAX, R, Python, MATLAB Client Operating Systems: Windows XP/Vista/7/8/10 Server Operating Systems: Windows server 2003/2008/2012 /2016 Project Management and Change Control: JIRA, Service Now (SNoW) Productivity Tools: MS Office, Visio, Google G Suite, LaTeX Other: TCP/IP, Active Directory, Data Warehousing, and Data Wrangling Professional Experience05/2023- 04/2024: Constellation, Senior Data Analyst Designed, developed, and modified data infrastructure to streamline data analysis and reporting processes, improving overall efficiency. Created and maintained data management plans and standard operating procedures for handling and archiving data. Monitored data systems to ensure they were organized, secure, and accessible, enhancing data integrity and availability. Assessed system performance and made recommendations for hardware, software, and data storage improvements. Ensured data and information security by integrating and maintaining digital security systems. Oversaw the integration of new technologies and initiatives into data standards and structures. Assisted colleagues in performing data-related tasks, fostering a collaborative work environment. Reviewed presentations, manuscripts, graphs, and tables to ensure accuracy and quality of data representation. Evaluated the design, selection, and implementation of database changes by comparing them with business requirements and design documents.2 Page Advocated for and implemented best practices in data management and analytics to ensure consistent and accurate reporting.10/2021- 04/2023: Capgemini Inc, Applications Consultant Business Intelligence Analyst Integrated payment processing analytics into client solutions, emphasizing security and operational efficiency. Utilized Tableau and SQL to develop comprehensive financial and operational reports to track payment anomalies. Created custom analytical tools to monitor and report on payment system performance and risk parameters. Provided expertise in data visualization and reporting to support cross-regional business units with real-time analytics. Conducted in-depth analyses of payment transaction data to identify trends and develop proactive security measures. Led workshops on the use of analytical tools for strategic decision support, improving stakeholder understanding of data insights. Collaborated with engineering and product teams to design data solutions that enhance payment security frameworks. Spearheaded the development of predictive models for fraud detection using advanced statistical techniques in Python. Streamlined data processes to improve the efficiency and accuracy of financial reporting and reconciliation tasks. Developed and maintained a centralized data hub to ensure easy access to key payment metrics and performance indicators. Provided pre and post implementation support, including dashboard maintenance and user education. Defined detailed requirements including business rules and data acquisition needs. Extracted data from primary or secondary data sources and maintain databases/data systems. Evaluated current state metadata and captured strategies and implemented process improvements. Assisted in the preparation of analytic results and study methodology in the form of client reports, journal manuscripts, and abstracts/posters for professional meetings. Provided analytic advice to project team members, investigated issues with the data and reports findings. Developed and implemented strategies and solutions to remediate identified data management and data governance concerns.3 Page Conducted advanced statistical analysis using Python and R. 11/2020- 10/2021: Dash Technology Inc - Data Analyst Analysed healthcare and payment data to support cost-saving initiatives and vendor partnership assessments. Leveraged Excel and SQL to perform complex data transformations and produce actionable insights for cost management. Developed automated reporting solutions to monitor healthcare spending and predict future trends. Created dashboards that tracked the efficacy of health plan initiatives, aiding stakeholders in strategic decision-making. Employed data mining techniques to extract and analysed payer and provider data, enhancing data accuracy and service quality. Conducted ROI analyses to evaluate the financial impact of proposed healthcare service expansions and partnerships. Supported the design and implementation of new data collection and analysis protocols, improving data reliability and usability. Provided data analysis training and support to team members, increasing departmental capability and data literacy. Worked closely with internal and external partners to ensure the integration and alignment of analytics projects. Contributed to the development of policies and procedures that govern data use, ensuring compliance with healthcare regulations. Identified and assessed data quality metrics. Developed Tableau dashboards and reports to visualize key business metrics and communicate insights to stakeholders. Using Azure cloud-based technologies to design and implement data framework for effective information flow and better decision-making process. Involved in writing DAX queries and performance optimization of the Tabular Models. 01/2018- To 05/2020: Indiana University of Pennsylvania - Graduate Assistant Oversaw groups of students and assisted with academic projects in statistics and data science. Spearheaded a project focused on enhancing student retention rates and improving academic support services. Developed appropriate search queries to maximize research results. Created searches for data(Boolean, outlook, etc.) Conducted exploratory data analysis on various datasets using Pandas, NumPy and Matplotlib. Participated in code reviews and provided feedback to ensure code quality and adherence to best practices. Presented findings in internal research group meetings. Assisted with data cleaning and pre-processing using Python, SQL, and Power BI. 4 Page Assisted with data collection to be used for potential academic publications. 11/2014- 12/2017: Partner Mobile Inc - Data Analyst Created dashboard reports to support end users using SSRS. Created various Business Intelligence/Analytical Dashboards utilizing Power BI with global filters, calculated columns and measures with complex DAX measure groups, calculations and transformations using Query Editor and Power Query. Assisted with data cleaning and pre-processing using Python, SQL, and Power BI. Developed a linear regression model to predict partner mobile products prices. Compiled and analysed financial information for the organization. Developed a recommendation system using collaborative filtering to improve customer experience. Created and analysed monthly, quarterly, and annual reports and ensured financial information were recorded accurately. Presented findings to the data science team and provided recommendations for future projects. Developed revenue, expense analyses, projections, reports, and presentations. Mined data performed statistical analyses and predictive modelling. Gathered and analysed business requirements and translated the same into system/technical requirements. Created Entity Relationship (ER) diagrams for the proposed data mart. Improved performance with index analyses on tables and clustered and non-clustered indexes. Enforced business rules by creating constraints in both the production and relational data warehouse databases. Designed stored procedures for index maintenance, profiling data, staging procedures, and reporting databases. Redesigned existing stored procedures, triggers, UDFs, and views to improve the performance of queries. Created dashboard reports to support end users using SSRS. Designed reports using complex formulas and queried the database for generating different types of ad-hoc reports using SSRS. Used SSRS to create, execute, and deliver tabular, matrix and charts reports. Education & Qualifications MSc: Applied Mathematics, Indiana University of Pennsylvania, College of Natural Sciences and Mathematics, Department of Mathematical and Computer Sciences B.Sc.: Mathematics and Statistics, Federal University of Technology Minna, Nigeria, Faculty of Natural Sciences, Department of MathematicsProfessional Certifications AWS Certified Data Analytics - Specialty Google Cloud Certified Professional Machine Learning Engineer Microsoft Certified: Azure Data Engineer Associate Microsoft Certified: Data Analyst Associate5 Page Microsoft Certified: Power Platform App Maker Associate Certified ThoughtSpot Professional Google Data Analytics Professional CertificateProfessional Membership American Mathematical Society (AMS) Active Member Association of Data Scientist (ADaSci) Active Member Association for Computing Machinery (ACM) Active Member International Society for Data Science and Analytics (ISDA) Active Member Project Management Institute (PMI) Active Member Publications Ayobami, Sunday, et al. "Mathematical Modelling of Spread and Control of the Hepatitis C Virus." International Journal of Science and Research (IJSR), Volume Number: 12, Issue Number: 5, Year: 2023, Pages: 8. Ayobami, Sunday, et al. " Mathematical Modelling of The Transmission Dynamics of Covid-19 With Quarantine and Hospitality Treatment." International Journal for Research in Applied Science & Engineering Technology (IJRASET), Volume Number: 11, Issue Number: V, Year: 2023, Pages: 15. |
