Data Analyst Sql Server

Jargaltsetseg Badamzul

Clifton, VA ***** 703-***-**** *************.********@*****.***

Professional Summary

• Data Analyst with 4+ years of IT experience in Business Intelligence solutions, specializing in data analysis, design, development, and documentation. Strong knowledge of MSSQL, Oracle, MySQL, Snowflake, and expertise in SQL, ETL development (SSIS), and BI tools (Tableau). Transitioned from 6+ years of accounting to a data analytics role over the last 4 years, leveraging financial and technical expertise to deliver actionable insights and optimize business processes.

• Proficient in using Python (Anaconda) and NumPy for data cleaning and preprocessing tasks. Developed Python scripts to handle data cleaning, removal of duplicates, handling missing values, and standardizing formats. Ensured data integrity and improved data quality, resulting in accurate analysis and reporting.

• Skilled in Python (Anaconda) and NumPy for data quality assurance and validation. Implemented data cleaning procedures, including outlier detection, data type conversions, and consistency checks.

• Experienced with Data Warehouse in the development and execution of data conversion, data cleaning and extractions, data governance, data profiling and standardization strategies.

• Experience working closely with key Stakeholders, Subject Matter Experts (SME's), Application Owners and Data owners and Cross-Functional Teams to get the Data Lineage (Source System Details, Server Details, Table, Column, Views, etc.).

• Experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).

• Experience in writing the Oracle SQL Queries and procedures based on the requirement.

• Experience developing Custom BI Reports using Tableau.

• Strong understanding of various SDLC methodologies such as Waterfall and Agile.

• Experienced in choosing the right data types for the metadata based on the source data and helps in maintaining consistency between source and target systems.

• Moderate experience in different Databases like Azure, MSSQL, Oracle, SQL Server, MongoDB, Hadoop, Cassandra.

Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL) TECHNICAL SKILLS:

SDLC: Agile-Scrum, UML, RUP, Waterfall

Database Tools: SQL Server Management, SQL Loader, SQL Developer, TOAD Languages: SQL, PL/SQL, Python, Anaconda, NumPy

ETL Tools: Informatica, SSIS.

BI Tools: Tableau, Crystal Reports, SAS, Business Object, Power BI Databases: SQL Server, Snowflake, Amazon Cloud (AWS), REDSHIFT. Operating Systems: Windows, Linux, MAC, Windows server 2012. RDBMS: SQL, Oracle, and MS Access

Utilities/Application: Notepad++, Visual Studio Code, MS Office Excel, Outlook, PowerPoint, MS Project, MS Access

2

Work Experience

DATA ANALYST PATELCO CREDIT UNION 11/2020 – CURRENT CONTRACT

Patelco credit union offers a wide variety of lending Products to Homeowners such as fixed and adjustable-rate mortgages (ARM), VA loans, FHA loans. SC Bank Mortgage Servicing had been facing challenges with their former mortgage Sub Servicer and it has resulted in loss of customers and significant revenue mainly deriving from mortgage interest. The project was a data ware housing project, which included the warehousing of data from different data sources into the target data warehouse. I worked as Quality analyst for the warehousing of mortgage and account related data.

• Worked extensively in Data Migration and data conversion from legacy to Oracle platform, documented Data Mapping and data profiling requirements, data transformation requirements for ETL and data integration.

• Developed Python project that uses Anaconda and NumPy for data quality assurance and validation. Implemented data cleaning procedures, including outlier detection, data type conversions, and consistency checks.

• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from PC Data warehouse.

• Retrieve data from the data warehouse and use the data to create insightful reports and analyses.

• Worked on user defined stored procedure PL/SQL Developer for data conversion from flat files to database.

• Written various SQL queries for the data analysis and reporting purposes with the help of analytical and aggregate functions and correlated sub queries.

• Provided support of ad-hoc JIRA requests and special projects as assigned directly or through Agile.

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.

Environment: Jira, ServiceNow, SQL Server, SQL, SSIS, SSRS, Tableau, Oracle, UNIX, MS Office suite, Azure, Python, Anaconda, NumPy.

SALES ACCOUNTANT ANUN LLC 06/2013 – 04/2015

Detail-oriented Accountant with experience in managing financial operations at Anun LLC. Skilled in maintaining general ledger entries, preparing financial statements, managing accounts payable and receivable, and ensuring compliance with tax and reporting regulations. Proficient in using accounting software and Excel to streamline processes, prepare reports, and ensure accuracy. Demonstrated ability to analyze financial data, resolve discrepancies, and support strategic financial decision-making. Reliable, organized, and dedicated to maintaining financial integrity in a dynamic business environment. Collaborate with management to address immediate data-related concerns and provide strategic guidance.

• Manage General Ledger: Record, categorize, and reconcile financial transactions to ensure accurate financial reporting.

• Financial Reporting: Prepare monthly, quarterly, and annual financial statements in compliance with accounting standards.

• Accounts Payable & Receivable: Oversee accounts payable and receivable processes, ensuring timely payments and collections.

• Tax Compliance: Ensure timely and accurate filing of tax returns and compliance with local tax laws and regulations.

• Budgeting & Forecasting: Assist in preparing budgets and financial forecasts, providing insights into variances and cost-saving opportunities.

• Financial Analysis: Analyze financial data to identify trends, provide actionable insights, and support business decision-making.

3

• Audit Preparation: Support internal and external audits by providing requested documentation and clarifications.

• Process Improvement: Identify opportunities to streamline accounting processes and enhance efficiency within the department.

• Regulatory Compliance: Ensure adherence to financial regulations and company policies for all accounting activities.

• Collaboration: Work closely with other departments to provide financial insights and support decision- making.

Environment: Slack, Microsoft Teams, Jira, Trello, Sap, Oracle, Excel. RECEIVING CLERK TAVAN BOGD LLC 06/2009 – 06/2013 Receiving Clerk with expertise in verifying shipments, maintaining accurate records, and optimizing inventory operations. Skilled in inspecting goods, coordinating with vendors, and analyzing inventory data to identify trends, improve processes, and enhance operational efficiency. Proficient in leveraging data to support decision-making and streamline supply chain workflows. Conduct ad hoc analyses in response to specific business inquiries or challenges, providing timely insights to support decision-making processes.

• Collaborate with management to address immediate data-related concerns and provide strategic guidance.

• Inspect and verify incoming shipments for accuracy, quality, and compliance with purchase orders.

• Maintain accurate records of received goods, discrepancies, and returns using inventory management systems.

• Coordinate with vendors and suppliers to resolve issues related to deliveries or damaged goods.

• Organize and optimize storage areas to ensure efficient inventory management.

• Collaborate with the warehouse team to ensure timely and accurate distribution of goods.

• Welcomed customers, assessed their needs, and provided appropriate assistance.

• Stayed informed about current sales, promotions, and payment/exchange policies.

• Processed payments and authorized product shipments to customers.

• Compiled and submitted daily sales performance reports to the Supervisory Accountant. Environment: Slack, Microsoft Teams, Jira, Trello, Sap, Oracle, Excel. EDUCATION

MASTER OF SCIENCE APRIL 2020- MARCH 2022

THE STRAYER UNIVERSITY

MASTER’S DEGREE, MBA CONCENTRATION ON ACCOUNTING SEP 2019 – APRIL 2020 THE UNIVERSITY OF THE POTOMAC, WASHINGTON, DC

BACHELOR'S DEGREE, ACCOUNTING SEP 2011 - MAY 2013

THE MANDAKH UNIVERSITY, MONGOLIA

BACHELOR'S DEGREE, BUSINESS ADMINISTRATION SEP 2005 - MAY 2009 THE NATIONAL UNIVERSITY OF MONGOLIA, MONGOLIA

Contact this candidate