Michael Goncharov

Benicia, CA ad41sj@r.postjobfree.com 925-***-****

Experienced IT professional with over 12 years in resolving complex technical issues, analyzing and evaluating the effectiveness of operations, and collaborating with cross-functional teams to enhance product stability. Skilled in data visualization, designing, developing, and maintaining software applications, and databases.

Experience Summary:

Led and executed business analysis and programming projects for 10+ years, encompassing scope definition, data modeling, file specification testing, ETL protocol development, rules clarification, and custom reporting application building. Developed database models supporting decision-making research utilizing Power BI and MS Excel.

Experience writing T-SQL scripts for various reports including financial, and company performance reporting using tools such as Excel, Power BI. Created interface-stored procedures to load, scrubbing, and transform sensitive and confidential data into the database automatically based on their schedule. Compiled data from various data sources and prepared reports, as well as performed ad-hoc queries for the senior management team on sales and marketing performance.

Experience working in a multi- server environment and with large datasets. Designed complex database queries (T-SQL) that greatly improved response times of Web\Windows-based applications while reducing load on database servers. 6+ year of experience working with automated systems (AUTOSYS), including their connectivity and integration to other automated systems.

3+ year experience working with ITRS-Geneos and App Dynamic monitoring tools to assist in problem identification, maintenance, such as hardware, software, applications, and operating procedures.

4+ years of experience in maintaining SQL Server security, setting up SQL agent jobs, and maintaining database statistics, indexes, and fragmentation. This involves ensuring that the databases are secure and free from any vulnerabilities, as well as optimizing their performance by regularly monitoring and fine-tuning the indexes and statistics.

Experience using SQL Server Management Object (SMO, VB.NET) to manage and automate the operation processing, such as restore, backup, and running scheduled jobs. This skill has helped to improve the efficiency of database management and ensure the smooth functioning of operations.

8+ years of experience participating in the design and interpretation of data analyses; provides recommendations for improvement of data quality and reporting. Presented data, and recommendations to the business team.

Resolved system-wide technical issues by coordinating with the technology teams, leading to a 25% increase in system efficiency. Managed a knowledge base to help customers self-service and allow the sharing of cross-departmental information, resulting in a 95% customer satisfaction rating.

10+ years of experience collaborating with the engineering, and finance teams to design and implement streamlined workflows (SSIS), which has resulted in an overall team efficiency improvement of about 25%. During these collaborations, worked closely with tech teams to support data mining, analysis, reporting, and program improvements that have led to an impressive 40% increase in customer satisfaction. Managed the complex ETL processing tasks to timely completion and when necessary appropriately escalated issues. All processing tasks were always met a customer SLA (Server Level Agreement).

Implemented a data quality process to improve overall data quality, resulting in a 30% reduction in data errors and increasing data accuracy by 30%. Always gains a deep understanding of the data to identify gaps, issues, and disconnects in production as well as opportunities to optimize processes and improve performance. Provided analytical support to resolve operational issues including process design, data validation, and scrubbing.

Developed and optimized T-SQL scripts, leveraging derived tables, table variables, and complex queries to enhance data retrieval efficiency by 40% and reduce query execution time by 50%.

Extensive experience in designing, developing, documenting, and testing of ETL jobs in data warehouse, including schema design, ETL (SSIS), end-user presentation (via analytic reports, graphs, etc.), testing, deployment, and post-deployment support.

Have a strong background in designing and implementing database code objects to aid complex mappings. Experience developing the SSIS package Conversion Utility (.NET, SQL) to convert 300+ SSIS packages during the tech refresh and make the Corporate Trust System migration project much simpler for the team.

Trained new hires and translated complex technical information to a non-technical audience, resulting in a successful onboarding programs. Liaising with external parties such as vendors (Oracle, Microsoft) to resolve the issues.

Developed and implemented Business Continuity Plans (BCP) for business-critical applications and operational databases, resulting in the ability to operate efficiently in the event of a disruption. Conducted Business Impact Analysis and Risk Assessments to identify critical business processes and potential risks, resulting in improved resilience.

Conducted research on how to perform preliminary analysis and visualize data using Python. Additionally, learned about developing predictive models on large-scale datasets by leveraging machine learning techniques to address business requests.

Having experience with both client's and developer's viewpoints in development project situations, I am well-versed in understanding and meeting the needs of both parties. Effectively communicated technical concepts to non-technical stakeholders and translate business requirements into technical requirements for developers. This ability to bridge the gap between clients and developers has resulted in successful project outcomes and satisfied clients.

Excellent analytical, problem solving, and code-reading skills. Utilized analytical skills to analyze complex functions, procedures, and problems to find creative, logical, and effective solutions.

3+ years of experience using JIRA and Confluence as part of the development life cycle.

Utilized Agile methodology, a development process that focuses on planning, building and deploying IT solutions, include requirements, discovery and solutions improvement through the collaborative effort of cross-functional teams.

Technical Skills:

Languages: Visual Basic.Net, Microsoft VSTO (Visual Studio Tools for Office), VBA (Visual Basic for Application), ADO.NET, T-SQL, PowerShell, DAX (training)

Database: SQL Server 2008/2012/2014/2016, DB2, Teradata, Oracle, MS Access, Microsoft Excel

Ancillary Skills: JIRA, Power BI, OBIEE, Crystal Reports, AUTOSYS, Microsoft Team Foundation Server, Visual Studio Code, MS Office Suite, C++, Informatica, Red Gate Tools, Microsoft Azure Cloud, Python, Microsoft Fabric (training)

Experience:

9/2009 – 4/2024 Wells Fargo Bank, San Leandro, California

Title: Senior System Support Engineer\ IT Analyst

Provided second-level operational support for the Support Desk team and improved organizational support efficiencies by creating ServiceNow, and JIRA tickets to transfer knowledge to the technology teams. Additionally, I have assisted in identifying systems and operational problems on Windows and Azure environments, and have recommended solutions and changes to streamline procedures for more effective reporting. And providing on-call support for critical production processes to ensure things run smoothly.

Worked with the internal and external stakeholders to resolve a variety of issues including hardware, software, dataflow design, data quality, and performance issues. This resulted in a 25% decrease in customer-reported issues and improved product stability.

Monitored and managed complex operation processes daily by identifying areas with performance issues and assisted to implement new methods to support performance improvement, resulting in a 35% reduction in processing time.

Provided performance diagnostic expertise, including analyzing query plans, and improving efficiency by re-indexing, updating statistics, and recompiling stored procedures, resulting in improving the database performance and loading speed by 50%. Analyzed database health and consistency by using DBCC commands and DMVs (Dynamic management views).

Performed software development using industry-standard ETL (Extract, Transform, and Load) tools to create new data source loads using over 20 different data sources, including SharePoint sites, data source files, DB2, Teradata, Oracle, and SQL databases. I also re-engineered and automated existing data pipelines. Also created SSIS (SQL Server Integration Services) routines to move records from relational databases into the data warehouse. Additionally, I have created configurations for SSIS packages that allow them to adapt to different run-time conditions flexibly. Conducted user acceptance testing to ensure that the software delivered met requirements and expectations.

Analyzed engineering workflows, defined requirements, and developed new ETL process (SSIS, VB.NET, SQL) to synchronize SQL database users using both SQL Server principal and Active Directory info, resulting in a 25% increase in operational efficiency.

Designed stored procedures, views, and other application database code objects to aid complex mappings. Served as subject matter expert (SME) on data structures and integrity for financial applications, and assisted the business team with data analysis using Excel, Power BI, data management, data transfer, and troubleshooting complex issues.

Documented each customer's processes, procedures, customizations, configuration, and troubleshooting tips for 8+ business-critical applications on Confluence (contributing to knowledge sharing within the team) to support operational/business procedures. Prepared PowerPoint presentations, data visualizations (Entity Relationship Diagram (ERD)), and reports using Power BI, and Excel. Developed database models to support decision-making research that enabled efficient data retrieval and analysis, resulting in a 20% improvement in reporting speed and accuracy.

Created and maintained various reports, tracking spreadsheets, and on-demand ad-hoc queries and report requests, as needed, and within specific timeframes.

Planned and developed a new data load framework (SSIS, .NET) to automatically retrieve the latest data from the production SharePoint sites, resulting in a 35% increase in operational efficiency.

Designed and developed a new monitoring process using the .NET Framework and SQL CLR to automatically monitor the disk space on the database servers, resulting in an 80% increase in operational efficiency. This was a great initiative as it can help keep track of the disk space and send email notifications if the disk space threshold has been surpassed.

Collaborated with the application, SQL DBA, and business teams on designing and creating new databases on the SQL instances to support ETL processes, which resulted in a 15% reduction in production costs. Also gathered requirements from the business team to develop data models, created DDL scripts, and deployed the database objects.

Designed and implemented Business Continuity Plans (BCP) for business-critical applications and operational databases, resulting in increased preparedness and minimized risks for the organization. During BCP events, led the BCP failover\failback events by working with the network administrators, and SQL DBA team to run failover and fallback activities to ensure the cluster's resilience.

Collaborated with the SQL DBA team to configure a High Availability (HA) solution. Monitored cluster health, disk space, and performance metrics. Ensured that the SQL Server instances on each node up-to-date with the latest patches and updates. Created a validation process to check that the passive node becomes the new active node and starts serving the database requests.

Led the project to migrate Microsoft Access Databases to SQL Server databases to improve the security, reliability, and performance of the business-critical production systems.

Cooperated with the technology teams to migrate the applications to Azure Cloud (public), resulting in a 25% reducing costs.

4/2009 – 9/2009 California Department of Public Health, Richmond, California

Title: System Analyst\Database Administrator

Designed, developed, tested, and implemented the ETL routines based on requirements gathered directly from business user interactions.

Conducted a thorough analysis of the data extracted from various sources, including hospitals and data centers, to ensure its accuracy and readiness for transformation. This resulted in a 40% reduction in data duplication and improved data accuracy by 30%. The data transformations included modifying data types, adding or removing columns, and utilizing functions to create calculated columns.

Monitored and tuned databases to meet the performance and availability requirements of online systems and multiple applications. Participated in report query optimization, index design and planning, index analysis, and tuning, resulting in reduce query execution time by 20%.

Collaborated with the software developers and clinical staff to analyze and document requirements (scope), and business rules (use cases).

7/2006 – 11/2008 SS&C FundRunner, San Francisco, California

Title: SQL Support Engineer

Developed, implemented, and optimized tables, views, stored procedures, indexes, functions, and complex ad-hoc queries, improving database performance and booting speed by 50%.

Installed, configured, and maintained a Hedge Fund application, resulting in a 25% reduction in system downtime.

Developed ETL processes for data warehousing and automated tasks. Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.

Debugged and fine-tuned stored procedures and database environment. Accomplished a 15% improvement in the performance of every ETL/SQL and application component, and ensured application response and data reliability by adhering to stern service level agreements.

7/2005 – 7/2006 First American Corp, Fremont, California

Title: Application Analyst\Business Analyst

Designed and developed several database applications to improve internal reporting processes and reduce inefficiencies in data gathering.

Monitored server performance, and tuned the database server and applications, reducing system downtime by 25% and improving overall system reliability by 25%. Upgraded and maintained SQL Server and related software.

Collected and analyzed the data from various sources to produce the reports (Crystal Reports, SSRS) for delivery to the clients on a weekly/monthly/quarterly basis.

To streamline reporting processes, automated standardized reporting by integrating Microsoft Office tools into scheduled, hands-free reporting solutions. Also used Excel Add-in for SQL Server Analysis Services (SSAS) to provide flexible reporting and analytical capabilities for data imported into Excel from Analysis Services cubes.

Education:

Rostov State University

Apply Mathematic

MS, Biology

Certifications/Training:

Santa Cruz Extension: Completed Advanced SQL, Data Warehouse, JDBC Connection, UNIX System, C++ classes

Completed the "Database Systems and Concepts" certificate program at UC Santa Cruz.

Contact this candidate