Caroline Kyeni
Summary
Skilled IT professional with 7 years of experience as a MSBI/ETL Developer. Experience of all the phases of the Software Development Cycle (SDLC) using Agile methodology.
Strong business acumen with excellent verbal, written and visual communication skills. Proactive, goal oriented, self-managing and teamwork spirit, ability to prioritize multiple tasks. Highly motivated with excellent analytical, troubleshooting, and problem-solving skills.
Overview
7
7
years of professional experience
Work History
ETL Developer
Sky Bridge Resources
2021.05 - Current
- Member of development team assigned to Optum health care which designs and/or creates, maintains, deploys, and manages SSIS packages for internal business teams and customers.
- Work with end users, Business SME's to understand the requirements.
- Uses SQL, data models, data dictionary and schema to perform data and business analysis.
- Formulate and document ETL process design bases on business requirements and specification including source to target mapping and transformations.
- Develop, test, manage and implement SSIS packages in development server ready for deployment to the production server using package configuration.
- Coordinate with the DBA and QA teams to ensure projects are successfully deployed into testing and production environments.
- Automate the execution of the SSIS packages using SQL Server Agent jobs.
- Peer review team members code for quality and standards.
- Experience in diagnosing and resolving incident tickets and errors.
- Conducting performance tuning and optimization for database queries and SQL stored Procedures.
Business Intelligence Developer
Samsung
2020.01 - 2021.04
- Act as the key interface between business and technology teams in defining and influencing business requirements.
- Collaborating with the Software Development teams to develop SQL Server-based business intelligence (Stored procedures, Database Views to feed into the visualization tools).
- Conducting performance tuning and optimization for database queries and SQL stored procedures.
- Analyze data-related systems integration opportunities and challenges, validating data models from a data integration perspective for current and impacted projects to drive quality improvements.
- Coordinate with the development and support teams to ensure projects are successfully deployed into testing and production environments.
- Code review to provide peer's assistance, ensure compliance and code readiness prior to Quality Assurance (QA).
ETL Developer
ZTE
2015.12 - 2019.12
- Designed and developed data marts using multi-dimensional models – star schema.
- Identified Key Performance Indicators (KPIs) measures in accordance with the requirements.
- Formulated and documented the physical ETL process design based on business requirements and system specifications including source to target mappings, transformations, aggregations etc.
- Translate business and user requirements into specific systems, applications and/or process designs for custom technical solutions.
- Performed data extraction, transformation, loading (ETL) between systems using SQL tools (SSIS).
- Implement different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to dimension tables in the data mart.
- Completion of project through the entire lifecycle of collecting requirements, recommending the appropriate solution, creating project plans with realistic estimates, unit testing, code review and deployment and creating reports
- Tactical enforcement of data governance policies and rules.
Education
Supply Chain And Logistics
Collin College
TXSkills
- Operating Systems: Windows 98/2000/2003/XP/NT/VISTA, 7, 8, 10, Windows Server, Mac, OS
- Database Tools: SQL Server Management Studio (SSMS), Azure SQL Server, SQL Profiler, Query Analyzer, Power Point
- GUI Tools: SQL Server Business Intelligence Development Studio, Visual Studio
- Languages: T-SQL
- OLAP Tools:
- Power BI, SSRS
- ETL Tools: SSIS
Additional Information
- SSIS Experience in transforming unstructured data from various data sources.
- Responsible for complex SSIS packages using various transformation and tasks.
- Implement various error handling and event handling techniques to ensure efficient package execution. Optimize slow running packages.
- SSMS Creating normalized datasets, stored procedures, functions, triggers, indexes, constraints, views, temp tables, tables, and complex SQL statements.
- Establish referential integrity, data consistency, data cleanup, indexing procedures to maintain high quality clean data for reporting.
- Troubleshooting T-SQL, SSIS, SSRS errors and performance issues as required.
- Exposure to Power BI suite to collect information from various corporate sources and develop reports to end users.
- Exposure in Power BI Importing data from various sources and performing required transformations in Power BI Query editor using UI and M code, creation of analytical dashboards depicting critical KPI's, and use of Power BI Gateway's to keep dashboards and reports up to date.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
There is a powerful driving force inside every human being that, once unleashed, can make any vision, dream, or desire a reality.
Tony Robbins
Timeline
ETL Developer
Sky Bridge Resources
2021.05 - Current
Business Intelligence Developer
Samsung
2020.01 - 2021.04
ETL Developer
ZTE
2015.12 - 2019.12
Supply Chain And Logistics
Collin College
Similar Profiles
Scott Sturges Master's In NursingScott Sturges Master's In Nursing
Registered Nurse PACU, Endoscopy, ICU, Cath Lab at Sky BridgeRegistered Nurse PACU, Endoscopy, ICU, Cath Lab at Sky Bridge
Nicole CherroNicole Cherro
Prevention Education Associate at Blue Sky BridgePrevention Education Associate at Blue Sky Bridge
Stefan TealStefan Teal
Associate Advisor at Blue Sky Business ResourcesAssociate Advisor at Blue Sky Business Resources