Responsible for the complete ETL process. Created stored procedures, functions, triggers to streamline client data to a SQL Server data warehouse. Analyze data, investigate ETL issues, work directly with data providers o…
Responsible for the complete ETL process. Created stored procedures, functions, triggers to streamline client data to a SQL Server data warehouse. Analyze data, investigate ETL issues, work directly with data providers on the data issues resolutions. Worked with Market Data – Equity and Fixed Income. Worked with client’s representatives to go over business specifications, gather trade data, set up data feeds, design customized mappings and processes, Used Tableau & reporting services (SSRS) to develop standard and customized client reports (Daily Weekly, Monthly, Quarterly, Yearly), including complex financial charts, list and tables. Used SSIS to transform various client data to SQL data warehouse Extensive development in Powershell scripts, C# and SQL Server. Deployed several powershell scripts to QA, UAT and Production environments. Rigorous testing of projects in QA/UAT environments
Good knowledge of Amazon Web Service (AWS) and Google Cloud (GCP) - Projects https://medium.com/@gchingwe, https://www.linkedin.com/in/gchingwe/
Extensively used Gradle, Jira, GITLAB and CVS
Extensively used SQL Server and Oracle functions, procedures and complex SQL queries to validate the in-house billing process. Created SQL Scripts to interface various modules in Visual Foxpro, VB, and C#. Worked with huge volumes of data. Worked on a big migration project mapping fields from Foxpro to Oracle table and created mapping documents for various data feeds.
Used Tableau to connect to Oracle to create various reports and dashboards for the finance department. Used Python, C#, SQL Server and Oracle on an in-house billing application/Support legacy application
Create Technical specifications documents based on the functional design document
Fully understand the full SDLC
Good knowledge of Amazon Web Service (AWS) and Google Cloud (GCP)
Extensively used Gradle, Jira, GITLAB and CVS
Extensively used SQL Server and Oracle functions, procedures and complex SQL queries to validate the in-house billing process
Created SQL Scripts to interface various modules in Visual Foxpro, VB, and C#
Worked with huge volumes of data
Worked on a big migration project mapping fields from Foxpro to Oracle table and created mapping documents for various data feeds
Used Tableau to connect to Oracle to create various reports and dashboards for the finance department
Used Python, C#, SQL Server and Oracle on an in-house billing application/Support legacy application
Create Technical specifications documents based on the functional design document
Fully understand the full SDLC
Developed and designed reports and dashboards in Tableau and MicroStrategy that displayed key performance indicators (KPIs) for enrollment, credentialing, affiliation management, batch and quality metrics
Extensively used Talend for ETL processes
Gained familiarity with Portico, Cenprov, and Amisys
Extensively used SQL Oracle functions, procedures, RDBMS and complex queries to validate dashboard values to ensure accuracy for provider, practitioner, and affiliation management data
Gathered business requirements, and documented and managed specifications in an Agile environment
Managed daily stand-up meetings and used the JIRA board to create, edit, assign and close stories/projects for users on a project
Supported BISAM, an attribution performance time-sensitive application for equity and fixed income funds
Extensively used the iXP tool and the BISAM application to monitor and troubleshoot flaws in the process related to attribution import, execution and report generation
Resolved data vendor related issues related to source data and target tables and the security master file that were transmitted with missing security codes
Developed PowerShell scripts for various tasks, such as automated e-mails, process logs, and SQL execution
Coordinated JIRA stories for various projects to ensure all projects met the set deadlines
Analyzed and improved SQL queries for any bottlenecks
Liaised with Managers, business users, and offshore teams on various aspects of the attribution execution cycle
Managed the daily stand-up meetings and used the JIRA board to create, edit, assign and close stories/projects for users on a project
Gather the business requirements and document and manage specifications in an Agile environment
Automated a system to run on a daily schedule to download 835/837 medical files (billing and payments)
Extensively used Microsoft Team Foundation Server (TFS) and Microsoft SourceSafe to manage all source code
Developed stored procedures to import client data into a SQL data warehouse
Completed extensive data modeling with data management skills and ERwin software
Worked on JIRA to manage projects
Consulted and communicated with the client executives to evaluate their requirements, gather business requirements, and document and manage specifications
Performed extensive development in automated PowerShell scripts, C#, and SQL Server
Automated the e-mail system to inform business users/Developers of success/failures in automated jobs
Deployed several PowerShell scripts to QA/UAT and Production environments
Performed rigorous testing of projects in the QA environment before deployment to Production
Participated in the design and development of a new Harbor data warehouse
Completed extensive data modeling using data management skills and ERwin software
Administered an SQL Server clustered environment, and worked with the RDBMS and jQuery library
Responsible for the complete ETL process
Worked with client’s representatives to review business specifications, gather trade data, set up data feeds, design customized mappings and processes, analyze test data, and investigate ETL issues
Handled the data aggregation (incoming through the various formats), and processed, validated and normalized the client’s trade data loaded into a Harbor data warehouse on a daily basis
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
