| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Lubbock, TX EMAIL AVAILABLE<Digital Resume> <LinkedIn>Professional Summary: I am a goal driven oriented and enthusiastic in finding a long-lasting solution to challenges or problems facing the group, I have an opportunity of solving some problems in my previous experience and I am one of the leading groups driven the overall company goals to success, I always keep this energy to add value anywhere I belongs, I love what I do. I am a Power BI developer with experience in developing business intelligence applications, Data Visualization with Scorecards, KPI'S and Dashboard Reports by using Power BI Desktop, creating calculated columns and measures, troubleshooting report performance. Troubleshoot Slowly running reports and Dashboard elements to improve report performance. Business Analysis through SQL, SSRS, SSAS. Professional ExperienceColaberry INC, Plano, TX. Power BI/SQL Developer Full time. April 2020 till Date Power BI Desktop Creating calculated columns and measures, troubleshooting report performance, troubleshoot slowly running reports and Dashboard elements to improve report performance, Creating Visualization in Power BI Service building dashboard, and customizing to meet the needs of the clients/end-users. SQL-Server, T-SQL experience in creating tables and Temp Tables, Table variables, stored procedures, views, indexes, triggers, joins, User defined functions (UDF), CTE, Database Models, and integrity in all SQL version platforms. SSIS Designed and developed SSIS packages, Validated/cleaned data using various transformations, and used XML development and XML file parsing. Worked on data flow transformations like XML Source, Flat file source, Excel source used functionalities for error handling by giving precedence constraints, breakpoints, checkpoints, logging, and data viewers. SSRS Created both shared datasets and package-level datasets, developed parameterized reports with drill-down and drill-through, developed a report with various charts, Table, Matrix and gauge used Sub-report to develop a dashboard. Configure and deploy dashboard to report server. Hi-Crush LLC, Odessa TX Power BI/SQL Developer Contract. September 2019-March 2020. Used Power BI to create dynamic reports, Data Visualization dashboard and used DAX to create calculated columns and measures. Using Dashboard Reports to generate Business Positive insights and Negative insights Used SSIS to extract, validate, Transform, and load data into the ODS. Prepared the complete data cleansing, mapping, and migrate jobs using SSIS Designed and developed SSIS package. Extracted data from different sources, cleaned it, loaded it to ODS, and created SCDs. Also created reports with SSRS.Schlumberger, Midland TX ETL/SSIS Developer Contract. April 2018 August 2019 Used SSIS to extract, validate, transform, and load data into the ODS. Prepared the complete data cleansing, mapping, and migrated jobs using SSIS Designed and developed SSIS packages and troubleshoots packages, validated/cleaned data using various transformations, and used XML Development and XML file parsing. Worked on data flow transformations like XML Source OLE DB source Flat file source Excel source used functionalities for error handling by giving precedence constraints, breakpoints, checkpoints, logging, and data viewers. Troubleshooting of SSIS PackagesEDUCATION, CERTIFICATION & TRAINING Data Analytics Certification - Colaberry Inc. (2021) Heavy Construction Academy Diploma Civil Engineering (2018) Osun State Polytechnic, P.M.B 301, Iree, Nigeria Associate Degree Marketing/ Management (2006-2010) Technical Skills:DMB/RDBMS MS-SQLETL SQL Server Integration Service (SSIS)Report Tools Excel, Power BI, SQL Server Reporting Service (SSRS) Documentation Written Business Requirements Documents (BRD) Languages T-SQL, DAXOperating Systems Windows ServerBI Tools SQL Server Management Studio (SSMS)Office Tools MS Word, Excel, PowerPoint |
