Power Developer

Jules

Houston, Texas

281-***-**** ************@*****.***

PROFESSIONAL SUMMARY

• Highly skilled IT professional with over 6 years of work experience as a Microsoft Business Intelligence Developer (MSBI).

• Strong experience with Microsoft Suite (SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Power BI.

• Experienced with Solution Development Life Cycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing and Implementation of various client/server applications.

• Well versed in the ETL Lifecycle and Agile Methodology.

• Ability to prioritize multiple tasks. Excellent communication skills, proactive, self-motivated with teamwork spirit, goal-oriented, with excellent analytical, troubleshooting, and problem-solving skills, able to quickly adapt to the given role and deliver quality results early.

• Experience in logical and physical Dimensional Modeling, ER Modeling. SSIS

• Experienced in transforming unstructured data from various data sources such as Excel Spreadsheets, OLTP databases, XML files and other flat files.

• Created complex SSIS packages using various tasks, containers and transformations in Control flow and Data flow tabs.

• Implemented various Error Handling and Event Handling Techniques to ensure efficient package execution using Event Handler and Custom Logging.

SQL/SSMS

• Experienced in creating common table expressions (CTEs) to facilitate data manipulation.

• Solid understanding of Isolation Levels, Normalizing and De-normalizing databases and maintaining Referential Integrity by using Primary and Foreign Keys constraints.

• Good working knowledge in database debugging using SQL Server Debugger and SQL Server Profiler

• Experienced in designing and implementing Database Schemas, Data Modeling, Normalizing Datasets, Tables, Stored Procedures, Functions and Triggers, Constraints, Indexes, Views, Temp Tables and complex SQL statements.

• Proficient in establishing referential integrity, data consistency and data cleanup procedures to maintain high quality data that can be used for reporting. SSRS

• Experienced in the design and development of Reports and Dashboard, Sub-Reports, Drilldown and Drillthrough Reports, Parametrized Reports, Chart Reports, Gauge, Map Reports using SSRS

• Experienced with Report Server and Report Manager.

• Ability to Schedule standard and data driven Subscriptions.

• Ability to apply security roles to prevent unauthorized use of data. POWER BI

• Experience in Microsoft Power BI Suite (Power BI Desktop, Power BI Service, Power Query, Power Pivot, Power View, Power Map, Power Q&A), Microsoft Excel Pivot Table, Pivot Chart and Data Models to gather information from multiple sources, transform and deliver to the end user.

• Working knowledge of building statistical KPI reporting dashboards with predictive analysis.

• Excellent DAX Skills and the ability to create and troubleshoot complex calculations and measures

• Experience creating custom visualizations

EDUCATION / CERTIFICATIONS

• Master of Engineering in Quality Control and Management, University of Ngaoundere, a regionally accredited institution of higher education in the United States

• Microsoft Certified Professional: Microsoft SQL Server, by Microsoft Corporation

• Microsoft Certified BI Report Developer: Analyzing and Visualizing Data with Power BI & Microsoft Excel, by Microsoft Corporation

TECHNICAL SKILLS

Operating Systems Disk operating syst DOS, Windows XP/ Vista/7/8/10, Server 2012/2016 Office Tools MS Word, PowerPoint, Excel, Visio, Outlook, Publisher Databases (RDBMS) SQL Server 2014/2016/2018, T-SQL, MS Access Administrative,

Modeling &

Troubleshooting

SQL Server Management Studio (SSMS), SQL Server Profiler, Database Engine Tuning Advisor, SQL Sentry Plan Explorer, SQL Visio, Microsoft Visual Studio, SQL Server Agent, Windows Scheduler Business Intelligence

SQL Server Integration Services (SSIS), Import/Export Wizard, SSRS, Report Manager, Report Builder, Power BI, Power Pivot, Power View Integrated Development

Environments

SQL Server Business Intelligence Development Studio (BIDS), Visual Studio 2010/2015/2016/2018

Software, Languages

SQL, T-SQL, Statgraphics, Materials Control, MATLAB, DAX, M, C#

(for Script Task)

Quality Tools

Brainstorming, ISO 9001:2015, Flow charts, Pareto charts, Statistical Process Control, Gantt charts, PDCA-Cycle, Ishikawa diagram WORK EXPERIENCE

Houston June 2016 - Current

BI Developer

Responsibilities:

• Worked in Agile/SCRUM and System Development Life Cycle (SDLC) environment on complex system configuration, report design, data analysis and issues resolution.

• Involved in development from clients’ requirements gathering to the deployment of SSRS and Power BI reports and dashboards.

• Designed and developed data warehouse & data marts using Kimball star schema multi-dimensional model.

• Extracted, processed data from different data sources, clean and loaded into Datawarehouse.

• Created complex SSIS packages using various transformations and tasks such as Sequence Containers, Script component, For loop and ForEach Loop Containers, Execute SQL Task, Send Mail Task, File System Task, Conditional Split Transformation, Data Conversion Transformation, Derived Column Transformation, Lookup Transformation, Merge Join Transformation, Union All, Flat file source and destination, OLE DB source and destination, Excel source and destination, XML source.

• Created various Stored Procedures to implement slowly changing dimensions with Merge Statement to validate data from the source and update/insert the records into target tables.

• Created User Defined Functions to enclose business logic, making the system modular and secured.

• Created Calculated columns, measures, parameters, filters for interactive and flexible reports and dashboards.

• Involved in creation of various Business Intelligence/ Analytical reports and dashboards utilizing SSRS and Power BI with global filters/slicers, calculated columns and measures; complex DAX calculations and transformations; Query Editor & Power Query Formula Language (M-code).

Houston Feb 2013 - June 2016

BI Developer

Responsibilities:

• Worked with different departments to gain a rich understanding of the business, analytical, and reporting needs, including the identification of critical metrics.

• Performed detailed data analysis to determine the structure, content, and quality of the data through examination of source systems and data samples.

• Worked closely with the staff to identify Key Performance Indicators (KPIs) and iterate through versions of the deliverables.

• Involved in creation of various BI/Analytical reports and dashboards utilizing SSRS.

• Performed business configuration, process analysis, evaluated business procedures and problems, and identified areas for improvement

• Worked on dashboards using clustered column charts, 100% stacked column charts, line charts, line and clustered column charts, cards, KPIs, clustered bar charts, stacked bars, bar graphs, scattered charts, pie charts, gauges, geographical maps, Treemaps Tables, Matrixes, Gantt charts.

• Created and published various kinds of live interactive data visualization reports from Power BI Desktop to Power BI service, Dashboards and apps from Power BI service to end users.

• Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designed visualizations for concepts and prototypes to be presented to the management for validation.

• Documented tasks and progress using ISO and other company standards.

Contact this candidate