About
Over the years, I have learnt in order to succeed I have to attentively observe, interpret, and solve a problem because that is my passion. I am therefore passionate about this very important role being entrusted to me by you and stakeholders. Not only do I let my heart lead me but also, I am committed I will not rest till the job is done.
Hours Available / Wk - 40 hrs
Portfolio
Small Business Doing Business with Federal Government
Federal contracting can facilitate an exponential growth to a small business not just large company.... ... More
Employment History
-
ETL/DW DEVELOPER
COLABERRY INC
March 2018 - Present
• Gathered business requirements, definition and design of data source and data flows.
• Performed data extraction, transformation, and loading (ETL) between systems using SQL tools such as SSIS.
• Analyzed source system data to determine the data model and ETL solution that will meet business requirements.
• Designed and Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, for loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Created SSIS packages to load customer information from a flat file, excel and Json using SSIS
• worked on managing ETL processes by pulling large volumes of data from OLTP to a staging Database using SSIS for data transformation.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Troubleshooting within SSIS Packages to improve performance