Charles Peter

Expert in SQL for creating complex queries, enhancing database efficiency, and handling data for extensive uses, encompassing database architecture, normalization, and indexing.
Utilized SQL Server Integration Services (SSIS) to assuring data quality and integrity to meet analytics and reporting needs, scalable data warehouse solutions were designed and built.
These solutions included dimensional data modelling, logging, error handling and ETL operations.
Utilized SQL Server Reporting Services (SSRS) to develop and implement interactive reports, enhanced report performance by designing and parameterizing queries effectively, and worked with stakeholders to gather requirements and provide insights-driven solutions that improved the ability to make business decisions
Developed and implemented tabular models, optimized cube performance through efficient partitioning and aggregation design, and used SQL Server Analysis Services (SSAS) to produce user-friendly data visualizations and analytical solutions that gave stakeholders actionable business intelligence insights
Designed and developed interactive and visually appealing Power BI dashboards and reports to facilitate analytical findings to decision-making for various business units to make concrete conclusions
Using Power BI, developed and optimized complex DAX calculations to ensure efficient data retrieval and accurate reporting, Integrated data from multiple sources such as SQL Server, Excel, and cloud-based databases to create comprehensive and cohesive reports, implemented data models and transformations using Power Query to clean and structure data effectively
Proficient in Microsoft Excel with expertise in data manipulation, advanced formulas (VLOOKUP, INDEX-MATCH, etc.), and creating dynamic pivot tables for comprehensive data analysis and reporting
Experienced in automating workflows and performing advanced analytics to derive actionable insights using Python
Managed and led a four-person Data Migration team, guides the team through technical issues for implementation and cross functional team management
Utilized cloud services such as Amazon Web Services (AWS), Amazon EC2, Amazon Redshift, CI/CD Bamboo pipeline, AWS Database Migration Service (DMS), AWS Schema Conversion Tool and Amazon S3 to create scalable and efficient data integration solutions
Utilized the AWS Schema Conversion Tool (SCT) to convert T-SQL code to PostgreSQL, facilitating the migration of database objects from on-premises SQL Server to AWS Redshift
Skilled in configuring, managing, and troubleshooting SQL Server replication processes (snapshot, transactional, and merge replication) to ensure high availability, data consistency, and synchronization across distributed systems
Responsible for gathering requirements from business users, create use case and functional requirement documents, review designs, and technical solution for software projects
Writes, reviews, and edits technical documents in accordance with template requirements
Proven ability to operate independently with minimal direction or technical documentation, regularly producing excellent outcomes by utilizing proactive initiative and good problem-solving abilities and maintaining technical documentation for future reference
Participated in all phases of the Software Development Life Cycle (SDLC) using Scrum and Agile methodologies, contributing to sprint planning, daily stand-ups, and retrospective meetings
Proven track record of building effective working relationships with a wide range of customers, employees, and outside groups
Monitored SLA performance, track defects, derive metrics and conduct project closures, document project risks and formulate risk mitigation strategy
Participated in architecting new products and features
Reviews the existing repository in case of new problems, or new solutions and implements the information in specified templates to ensure reliability of current database
Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork
Served customers in a friendly, efficient manner following outlined steps of service

Expert in SQL for creating complex queries, enhancing database efficiency, and handling data for extensive uses, encompassing database architecture, normalization, and indexing.
•Utilized SQL Server Integration Services (SSIS) to assuring data quality and integrity to meet analytics and reporting needs, scalable data warehouse solutions were designed and built. These solutions included dimensional data modelling, logging, error handling and ETL operations.
•Utilized SQL Server Reporting Services (SSRS) to develop and implement interactive reports, enhanced report performance by designing and parameterizing queries effectively, and worked with stakeholders to gather requirements and provide insights-driven solutions that improved the ability to make business decisions
•Developed and implemented tabular models, optimized cube performance through efficient partitioning and aggregation design, and used SQL Server Analysis Services (SSAS) to produce user-friendly data visualizations and analytical solutions that gave stakeholders actionable business intelligence insights
•Designed and developed interactive and visually appealing Power BI dashboards and reports to facilitate analytical findings to decision-making for various business units to make concrete conclusions
•
Using Power BI, developed and optimized complex DAX calculations to ensure efficient data retrieval and accurate reporting, Integrated data from multiple sources such as SQL Server, Excel, and cloud-based databases to create comprehensive and cohesive reports, implemented data models and transformations using Power Query to clean and structure data effectively
•Proficient in Microsoft Excel with expertise in data manipulation, advanced formulas (VLOOKUP, INDEX-MATCH, etc.), and creating dynamic pivot tables for comprehensive data analysis and reporting
•Experienced in automating workflows and performing advanced analytics to derive actionable insights using Python

Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings in the SDLC process
Proficient at solving issues and spotting chances to generate revenue, utilizing data-driven insights and strategic analysis to improve organizational performance
ETL workflows and performance were enhanced through the use of best practices for data processing, index management, and query optimization

• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings in the SDLC process
• Proficient at solving issues and spotting chances to generate revenue, utilizing data-driven insights and strategic analysis to improve organizational performance
• ETL workflows and performance were enhanced through the use of best practices for data processing, index management, and query optimization

Designed and developed complex SQL queries, stored procedures, and functions to support various applications and reporting needs and enhanced system efficiency by optimizing database performance through query tuning and indexing
Data from several sources was loaded, transformed, and extracted using ETL processes that were created and managed using SSIS
To provide stakeholders with crucial business insights, reports and dashboards were created, developed, deployed, and analyzed using large datasets using SSRS, SSAS cubes and Power BI
To gather requirements and provide specialized BI solutions, communicate with and make recommendations to business analysts and stakeholders.
Created and maintained technical documentation for the application
Proficient in generating dynamic pivot tables and pivot charts to summarize, analyze, and visualize large data sets for business insights
Skilled in cleaning, organizing, and transforming large datasets using Excel’s built-in functions and tools (Text-to-Columns, Flash Fill, etc.)
Used coordination and planning skills to achieve results according to schedule
Collaborated with development/QA teams to troubleshoot database issues and resolve them
Responsible for monitoring progress, conflict management and change and release management through Backlog Grooming, Daily Scrum, Show and Tell, Retrospection, remove impediments, business solution design and reporting

• Designed and developed complex SQL queries, stored procedures, and functions to support various applications and reporting needs and enhanced system efficiency by optimizing database performance through query tuning and indexing
• Data from several sources was loaded, transformed, and extracted using ETL processes that were created and managed using SSIS
• To provide stakeholders with crucial business insights, reports and dashboards were created, developed, deployed, and analyzed using large datasets using SSRS, SSAS cubes and Power BI
• To gather requirements and provide specialized BI solutions, communicate with and make recommendations to business analysts and stakeholders. Created and maintained technical documentation for the application
• Proficient in generating dynamic pivot tables and pivot charts to summarize, analyze, and visualize large data sets for business insights

Created and maintained databases and database objects, fine-tuning them to satisfy business objectives, including tables, stored procedures, views, triggers, constraints, user-defined data types and functions
Use the server-side scripting language in Cold Fusion to apply business logic to the application
In charge of handling issues, resolving bugs, debugging, and testing the product in authentic, controlled environments before to launch
Developed, maintained, and implemented SSIS packages using a variety of data sources, including Excel, RDBMS, and flat files

• Created and maintained databases and database objects, fine-tuning them to satisfy business objectives, including tables, stored procedures, views, triggers, constraints, user-defined data types and functions
• Use the server-side scripting language in Cold Fusion to apply business logic to the application
• In charge of handling issues, resolving bugs, debugging, and testing the product in authentic, controlled environments before to launch
• Developed, maintained, and implemented SSIS packages using a variety of data sources, including Excel, RDBMS, and flat files