Jonathan Long Email & Phone Number

US

Johnston, Rhode Island, US

• Designing, Development and implementation at all levels. (Application frontend and backend as well). Pick huge amount data from client applications through Middleware language (XML) and loaded into current Application.
• Replicated Excel reports in Power BI and Developed Multiple Power BI Dashboards/Reports.
• Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users. Generated Monthly, Yearly, Quarterly and Daily reports in Power BI.
• Assisted in Production OLAP, wrote queries to produce reports using SQL Server 2019, Reporting Service (SSRS)
• Designing current database by adding tables, relationships, creating stored procedures, views and performance tuning of SQL queries and stored procedures.
• Created Datasets using different data sources like Microsoft SQL Server, Microsoft Azure, Excel, and SAP HANA.

Bloomington, Illinois, US

• Gathered data from various external sources into a data warehousing system with the help of ETL process.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.
• Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.

• Played an active role during the requirements gathering, analyzing, and designing of the system
• Designed, reviewed, and created objects (Views, Indexes, etc.) based on logical design models, user requirements and physical constraints.
• Wrote various T-SQL queries, Stored Procedures and used them to build packages.
• Created Triggers, Tables, Views, and SQL Joins for various applications.
• Analyzed the data using Statistical features in Power BI to develop trend analysis
• Wrote DAX expressions to create new measures, calculations per business requirements.

Thane, Maharashtra, IN

• Experience in maintaining the existing system, fixing bugs and enhancements by creating packages using control flow, data flow components.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For-Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail Task, Lookup, Fuzzy.
• Experienced in developing data reports in SSRS & Power BI using DAX formulas, expressions, graphs involving multiple slicers, connecting to various sources for consuming data's, establishing connectivity using Power BI.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in writing T-SQL Queries, sub-queries and complex joins for generating Stored Procedures and Views.
• Created the Power BI report on data in ADLS, Tabular model, Azure Data bricks and SQL server.