Data Analyst

Sr. Database Analyst

Professional Profile: Arthur Wied 954-***-****

SUMMARY

Arthur is an experienced SQL specialist with over Ten Years with Database and SQL Server Development with additional knowledge in web development frameworks, Data Modelling, Server Administration and SQL Deep Dive Diagnostics in different fields like Finance, Insurance, Transportation and Healthcare. Because of his countless skills, he largely contributed to company growth by increasing profits and saving the company money by being actively involved with various projects simultaneously. Similarly, he located and defined new process improvement opportunities by signifying legacy areas for reforms in existing process definition and process analysis by uncovering new opportunities. Performed wide-range analysis and provided solutions to ensure leading-edge data results. Arthur is a detail attentive analyst who is equally comfortable communicating with the business partners and simplifying technical documents into non-technical requirements. Experienced in SDLC methodology: Kanban, Agile.

Expert knowledge of all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development, and Implementation. Familiar with GCP (Cloud SQL) and Azure Platform, GIT, Visual Studio and DevOps source control. He looks forward to leveraging his data expertise and superior technical abilities with a new team.

EDUCATION

AA. Computer Engineering – Java Programming -2003 Everett, WA

AA. Computer Engineering -Network Administration-2003 Everett, WA

AA. Computer Engineering -Business Application-2003 Everett, WA

BA. History of Art and Antiquity - National Academy of Arts -1989 Warsaw, Poland

TECHNICAL SKILLS

Microsoft SQL Server 2008-2017

Azure SQL DBA

SQL Server Development

Data Warehouse

Data Modeling

Database Design-logical/ physical

SQL deep-level DBMS

T-SQL query tuning

Python-Data visualization

JSON, XML

SSRS RSDB Reporting

SSIS

ASP.NET

ADO.NET

Microsoft Office applications

MS Azure, Cloud SQL

PROFESSIONAL EXPERIENCE

Lockton Global – (Remote) March 2020- August 2020

Database Analyst

Accountable for facilitating the implementation of production data access strategy, data reporting and business intelligence initiatives to deliver timely relevant information to stakeholders throughout the Lockton Affinity organization and partner network. Worked with subject matter experts, technical team peers, key stakeholders at all levels, and clients to deliver business value through the applied analysis of business data. Operated within a culture of Autonomy and Purpose, with a high degree of accountability and was responsible for delivering thorough, high quality completed work on time with high visibility throughout the organization. Provided expertise in creating objects such as Databases, Tables, Stored Procedures, Triggers, Cursors, Constraints, Indexes, Full-text Indexes, Views, Indexed Views, T-SQL Merge Command. Maintained Index Maintenance, Index tuning, Rebuild Reorganizing according to Index fragmentation, running DBCC and DMV checks to monitor table and Index Statistics to check Data Integrity. Engaged in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer. Extensively used tools like SQLcmd, SQL Extended Events, Query Store, DMV’s, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance. Troubleshooted performance issues and fine-tuning queries performance and stored procedures, also monitored SQLOS by running Perfmon counters for resources contentions.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Created, deployed, and managed reports using SQL Server Reporting Services SSRS.

Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.

Responsible for data consolidation, analysis, database tuning and business reporting.

Developed and maintained reports for stakeholders at all levels of the organization.

Identified and fixed the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing optimal Query Execution plans.

Provided support to research teams or management by collecting and analyzing data and reporting results based on the needs of end-users.

Took ownership of refactoring and performance tuning of existing stored procedures and scripts in optimizing code to the highest compatibility level and optimal level of parallelism. Resolved issues with high CPU usage and thread contention by implementing spinlocks strategy.

Assisted in implementing or developing systems to capture business operation data in SQL Databases in Cloud Google and Microsoft Azure PaaS.

Recommended automation of administrative tasks like creating maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.

Contributed to the design of relational databases for data storage or processing. Assisted in the creation of database architecture, and data repositories and data warehouses.

Ensured data accuracy. Improved the performance of data applications by adding Error handling through TRY-CATCH statement and contributed to resolving unexpected crashes.

Maintained data integrity and data processing efficiency by working to eliminate redundancy and applying best practice data stewardship techniques. Also, performed database regular Backups Full/Differential/Transaction Log Backups into Disk and Restoring on requirement.

California Public Schools - (Remote) Oct 2019-Dec 2019

Database Architect /Developer

Responsible for the architecture and design of a school enrolment database.

Daily routines:

Used assessment skills to research and analyze the business opportunities of the client and making reason decisions.

Worked in the initial, intermedia and the final stage during the requirement capture and implementation also providing support after go live.

Modelled databases in Conceptual, Logical and Physical stages.

Established and implemented standards and strategies for data management, lifecycle, and quality

Normalized database to 3,5 BCNF assuring referential integrity between relations and implemented constraints for attribute key uniqueness.

Implemented Business logic by using T-SQL DDL, DML, stored procedures, triggers, and in-line table Functions and Views.

Created and used T-SQL scripts to generate database, tables, views and UDF functions. Remotely implementing, optimizing data objects queries and testing via private VPN access.

Gathering and reviewing the operational metadata to detect performance status of each component.

Frequently participating in online meetings and discussions.

Access E-Forms - (Remote) Jan 2018- Sep 2019

SQL Analyst

Regularly engaged in real-time troubleshooting, diagnostics, performance tuning, debugging, unit testing and fully supporting back-end Relational Database (RDBMS), performance, and quality. Demonstrated a mixture of a high level of self-discipline and composure when under pressure.

Effectively performed root cause analysis of issues and report the outcome to the business community and Management provided recommendations along with risks and issues involved.

Created and implemented complex design using nested triggers for insert tasks.

Refactored code in parametrized Insert/ Update stored procedures utilizing the FOR XML.

Utilized Ranking, Offset and Aggregate functions together with Common Table expressions.

Modelled processing workflows and provided data integration using leading-edge integration results and expert tips for best performance.

Conducted configuring Registered Servers, Linked Servers, and Multi Server Administration.

Quick in identifying targets for research and metadata analysis in SQL Server/ Windows Server using Extended Events objects, Query Store, DMV’s, SQL Audit, Transaction Logs, Performance Counters indicators, and other diagnostics related and performance tuning tools.

Maintained indexes, query plans and statistics in large database.

Demonstrates deep understanding of SARG-able search predicates in queries.

Designed and built databases, schemas, tables from logical to physical stage and enforced data integrity by effectively applying constraints.

Normalized database according to BCNF rules for best referential integrity.

Built the transactional model with concurrency control for ADO.NET data access logic.

Created, Altered, Dropped Indexed Views, created partitioned Views with Union sets.

Worked with Asp.net backend tier, custom-built datasets, and stored procedures.

Time effectively worked with internal development staff to resolve fixes, updates and customer requests and issues.

Worked in agile and lean environments, worked together with end users/customers to understand business requirements, recommended technical solutions, and documented functional requirements.

Managed and successfully maintained customer relations with business partners, software distributors, vendors, and retailers resulting in a steady growth of company sales.

Assisted junior analysts with providing solutions and encouraging collaboration among other team members.

Microsoft Corp, Redmond, WA 7/2017 -1/2018

Sr. Database Developer SQL/ ASP.NET– Business partners data warehouse (Contract)

Performed all stages of the data science life cycle: business understanding, data cleaning, data exploration, predictive modelling, and data visualization with Power BI and Excel.

Promptly delivered high-quality performance tuning and actively participated in all phases of the development life cycle during time-sensitive deadlines.

Created ad hoc data visualization in Python such as histograms, timelines, and pie charts.

Worked pro-actively to gauge the performance of the application & database and provided recommendations to achieve the optimal architecture.

Parsed and transformed the XML and JSON element-based schemas for inverse and reverse of flat files to hierarchies SQL server system environment.

Participated in ad-hoc ASP.NET, code editing on Live server for the front-end application development.

Created and managed Full text SQL search catalogues including bulk import and mappings of documents in Azure.

Operated, and personally overseen GIT and Team Foundation Server (TFS) source and published web-based application from Development thru Staging branch to Production after each Agile sprint.

Used TFS to create QA automatization scenarios.

Created SSRS projects and reports in Visual Studio, sort, drill down data and toggle object visibility to modified report, assigned item level permissions and site security roles, created report schedules and subscriptions.

Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc. Cleaned data filtered data by reviewing metadata reports, and performance indicators to locate and correct code problems.

Expertise with initializing and properly utilizing the Columnstore index for bulk load transactions.

Handled production/Development servers with more than 1 TB of database size with complex structures.

Effectively managed Microsoft external/internal customer support queue and efficiently maintained data layer access management with over 250K members.

Handled daily email load and triaged incoming inquires in a highly dynamic environment.

Created detailed documentation about code review and providing ideas for solutions.

Attentively connected with clients via Skype and provided support for geographically dispersed Microsoft groups.

Community Health Plan Washington, Seattle, WA 3/2017-6/2017

BI Developer ETL- Insurance Data Warehouse (Contract)

Actively involved in designing, coding, unit testing and implementing high-quality software for CHPW’s Enterprise Data Warehouse with Hedis quality measurement.

Applied approved application development practices for the analysis, design, prototyping, development, and unit testing of CHPW applications primarily for usage in the Extract, Transform and Load (ETL) functions moving data and metadata into the Data Warehouse.

Used different control flow tasks like SFTP, Bulk Insert Task and data flow tasks like merge, merge join, look up, data conversion, derived column, conditional split.

Built the physical data model for customer review and approval and constructed the registration database using Erwin, and PowerBI.

Managed the extract processes from the dimensional warehouse environments to meet any regulatory requirements for Hedis (measure performance on health and service).

Developed and tuned existing data warehouse applications to ensure optimal performance and the highest level of accuracy for large data processing and preparation for reporting tables.

Modified star schema and identified the requirement of snow flake schema in the design.

Demonstrated Unit tested application programs identified errors in program logic and verify functionality and compliance with user specifications for optimizing query performance time.

Thoughtfully applied his ideas during design and code reviews for accurate data extraction with the BI team.

Demonstrated understanding of Agile philosophy and familiarity with Scrum project methodology during daily sprints.

Evergreen Health, Monroe, WA 9/2015-3/2017

SQL Data Analyst -Clinical database management

Coordinated the use of data and information in the Hospital’s clinical and business departments.

Researched and facilitated resolutions of support or production-related SQL processes and transactions for financial operations.

Created various tools for extracting and manipulating data in SQL Server.

Processed and analyzed data according to specific standards and routinely exported to federal and state Government agencies.

Designed, developed, tested, tuned, and implemented ETL processes, highly complex T-SQL and analytical SQL queries, stored procedures, indexed views, and table value functions.

Cleaned, optimized, and prepped data destined for all external reporting requirements using existing auditing reports and tools.

Built professional SSRS reports for billing and financial departments by utilizing stored procedures and parameters for repetitive expressions.

Frequently interacted with development and end-user personnel to determine data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases and reports using complex T-SQL programming methods.

Designed from scratch multiple SSRS “last-minute reports” and Dashboards for the EHM Board of Directors, physicians, and various departments to save their time in search and obtain statistical data and predictions.

Conducted in depth analysis for assessing the suitability for server-less and provisioned compute tier and conducted deployment with SQL Database Migration SQL AzureMW and Azure SQL Database.

Written and understood Microsoft High-Performance T-SQL with large data and wide tablature (up to 500 columns).

Has written multiple financial T-SQL statements, stored procedures, and views using industry best practices such as window functions (Offset Aggregate, Ordering and Framing

Ranking Functions) and for in-memory efficiency.

Created, developed, and managed internal procedures for various job functions with the EHM to ensure data integrity and efficient processes.

Ski Valley Montessori, Monroe, WA 9/2008-6/2015

Programming Instructor

Helped to plan, build, and set up a computer lab at the Montessori School, frequent voluntary work as a guest instructor for a computer programming class.

Planned, prepared, and delivered instructional activities that facilitated active learning experiences.

Developed outlines of work and lesson plans, prepared classroom for class activities provide a variety of learning materials and resources for use in educational activities, instruct and monitor students in the use of learning materials and equipment, use relevant technology to support instruction, observe and evaluate student's performance and development, assign and grade classwork, homework, tests and assignments, encourage and monitor the progress.

Dollar Plus Zone, Inc.

4/2004-6/2008

System Analyst SSRS reporting

SSRS RDBS in a private equity investment firm that acquires middle-market businesses with growth potential and a clear path to value creation. He worked on the Migration of SQL Server 2000 to SQL Server 2005 and created reports using SSRS.

Developed scripts to migrate data from multiple sources.

Performed data backup, recovery, and transfer operations.

Analyzed business recovery requirements and maintenance strategies and plans for critical

Created DTS Packages to export and import data from CSV files, Text files, and Excel Spreadsheets.

Created Summary Reports, Sub Reports, and Drill-down Reports using SSRS.

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business need using SQL Server Reporting Services (SSRS).

Implemented back-end parameterized stored procedures to be called by the business tier application.

Contact Information:

Arthur Wied

Email: **********@*******.***

Phone: (954) 342- 7325

LinkedIn: www.linkedin.com/in/arthur-wied

Contact this candidate