Principal Data Engineer Resume
3.00/5 (Submit Your Rating)
Houston, TexaS
SOFTWARE EXPERIENCE:
Databases: Structured Query Language (SQL) for all Database management systems. MS - SQL Server SSMS (T-SQL) / SSIS / SSAS*,MS-Access, MySQL,MS-Excel (Used as a database for limited resources purposes), Big Query
Maps: ESRI ArcGIS, Quantum GIS*
Programming Languages (Intermediate Level): VBA, C#, Python, Java, C++ and Visual Basic*
Reporting: Tableau,SSRS
PROFESSIONAL EXPERIENCE:
Confidential, Houston, Texas
Principal Data Engineer
Responsibilities:
- Data Warehouse Development; Led and worked with a small team into switching relational databases to become more report and analytics oriented utilizing MS - SQL Server (T-SQL, Stored Procedures, Functions, Triggers C# and SSIS) by de-normalizing all required information with all relevant calculations on deep level of granularity allowing business partners to slice and dice chunks of data to serve their needs efficiently and effortlessly, scheduling jobs according to the business needs and speeding up existing processes.
- Reporting; Created and worked with SSRS reports, moved and scaled up the reports into Tableau dashboards to support business decision by providing insights, process progress and anomalies depending on reliable data sources and remarkable business acumen through interactive dashboards.
- Agile Development; using the agile development method to in leading the team into getting passed our milestones providing the minimum viable products (MVP), adding maintenance and troubleshooting measures, documentation and providing insights about next potential steps to improve continuously
- Additional Development: Created supporting tools to ETLs using C#, Python and NodeJS respectively to consume, process and load data into the centralized data warehouse. Utilized the MS-Office suite to help provide quick and easy solutions to ad-hoc reporting and task automation using Visual basic for Applications (VBA) that is embedded within the whole package.
- After working hand in hand with the Call Center and the Business Intelligence teams to gather the requirements, needs and future goals I managed, to build an all-purpose order management system SQL flat table by developing a sequence of trackable T-SQL stored procedures, functions and staging layers providing the business with all the necessary information despite the resource limitation
- Working with the Workforce manager to understand the concepts and KPIs of the workforce for a multi-functional call center, I managed to switch Tableau from a reporting tool into a call center workforce management and staff forecasting tool through embedding the key formulas of workforce management into user-controlled dashboards by applying dynamic calculated fields and parameters to translate business input into a staffing model
- Utilized Tableau and MS-SQL Server to build a remake data module allowing the business to track the impact of returns and improve the services, products and user experience
- By understanding Tableau’s data structure and utilizing T-SQL Skills, I Built the Vendor Performance Tracking module to establish vendor performance patterns that suit the business needs with the ability to report these updates to the vendors for feedback which served in most of the product-based analysis and machine learning modules
Confidential
GIS and System Analyst
Responsibilities:
- System development; built and maintained reliable information systems and databases using MS-SQL Server, MS-Access and MS-Excel (VBA)
- Data management; directed, supervised and coordinated the data collection process internationally (from / to: Jordan, Iraq, Switzerland, Syria, Lebanon and South Sudan) while having a centralized database in Jordan
- Quality assurance and data archiving; validated, verified, analyzed and stored input to serve the reporting process
- Reporting; represented the data and analyzed data in different forms of reports (text, data tables, pivots, charts, maps) statically and dynamically serving different needs and counterparts internally and externally with SSRS and Excel
- Capacity building; expanded personal knowledge base and skill set, developed and improved the team’s capacity on handling daily tasks and facing job challenges in addition to training colleagues in other departments on using developed systems and data reporting tools
- Map production; Utilized ArcGIS and Google Earth to produce numerous maps to represent the current situation, main focus and interesting anticipated upcoming events
