Sql Server Power Bi

* ****

Sunday Luke Ayobami

Telephone: +1-925-***-****, Email: ad5pkl@r.postjobfree.com

Key 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 Experience

05/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 Mathematics

Professional Certifications

• AWS Certified Data Analytics - Specialty

• Google Cloud Certified Professional Machine Learning Engineer

• Microsoft Certified: Azure Data Engineer Associate

• Microsoft Certified: Data Analyst Associate

5 Page

• Microsoft Certified: Power Platform App Maker Associate

• Certified ThoughtSpot Professional

• Google Data Analytics Professional Certificate

Professional 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.

Contact this candidate