Portfolio
Oil and Gas
In the oil and gas industry, executing large capital projects in E&P will continue to pose daunting ... ... More
Employment History
-
Data Engineer\\ Data Warehouse Developer
Colaberry Inc,
May 2021 - Present
• Created complex SSIS Packages with error handling, using various tasks and transformations, like Sequence Containers, For Loop and Foreach Loop Container, Script, Execute SQL, Execute Package tasks, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, destination, excel source and destination, etc.
• Maintained SSIS packages for production and test environment for incoming source application files.
• Implemented different Slowly Changing Dimension tables in the Data Warehouse.
• Designed, implemented, and maintained Database Schemas, Entity-relationship diagrams, Data modeling, Tables, Store Procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, and Complex SQL Statements. -
Data Engineer\\ Data Warehouse Developer
Wamar Express
May 2017 - December 2019
• Proficient in creating complex SSIS packages with error handling, using various tasks and transformations like Sequence/Foreach Loop Containers, Script Task, Execute SQL, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, etc.
• Experience in relational and multidimensional data modeling with strong knowledge in Star/Snowflake Schema, Fact, and Dimension in the transportation industry. -
Data Engineer\\ Data Warehouse Developer
Ross Dress for Less
January 2020 - May 2021
• Monitored SSIS packages validation, error handling, and optimization issues regarding for the supply chain of the company.
• Created SSIS packages using various control flow and dataflow tasks to extract the data from multiple sources like Excel, XML, JSON, and OLTP and consolidate them into staging tables for the supply chain of the company.
• Maintained SSIS packages for production and test environment for incoming source application files.