Data Analyst Sql Server

Bilguun Bayarsaikhan

Northridge, CA 818-***-**** *********************@*****.***

https://www.linkedin.com/in/bilguun-bayar-9043692ba/

Professional Summary

Detail-oriented Data Analyst with over 5+ years of experience in data analysis and visualization. Seeking to leverage my expertise in time tracking data analysis, financial forecasting, and process optimization to support resource allocation and decision-making.

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 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, Github, MS Office Excel, Outlook, PowerPoint, MS Project, MS Access

Work Experience:

Hankey Group, Los Angeles, CA, Data Analyst

Mar. 2021 – Current

Acts as a technical expert on complex and specialist subject. Supports management with the analysis, interpretation and application of complex information, contributing to the achievement of divisional and corporate goals, committed to continuous learning and staying at the forefront of emerging technologies, I bring a dynamic and adaptable approach to solving business challenges through comprehensive data analysis. Ready to bring my analytical prowess to contribute to the success of the team.

Manage deficiency reporting and conduct financial analysis using Power BI, Excel, and Tableau for data-driven decisions. Consistently present findings effectively to Executive Committees for strategic insights.

Lead the design and implementation of new business processes and controls across financial applications, utilizing SQL for data analysis, report generation, and control development.

Conducted data analysis using advanced Excel functions and tools to extract actionable insights.

Collaborate with cross-functional teams on system implementations, process improvements, and efficient workflows documentation.

Oversee quarterly audit testing reporting, including trend analysis and year-over-year comparisons for timely and accurate delivery to stakeholders.

Developed and implemented data analytics strategies for audits, including the identification of relevant data sources, data extraction, transformation, and analysis.

Participated in process improvement initiatives to optimize data collection and reporting.

Developed Python project that using 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, 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, NumPy, AWS Athena, Glue, S3.

Landstar, Jacksonville, FL, Data Analyst

Dec. 2019 – Feb. 2021

Landstar is a leading transportation and logistics company for one simple reason- our people. I was responsible for ongoing monitoring and surfacing of new threats in the digital advertising ecosystem. I had extensive interaction with large data sets, writing simple and complex queries. (We monitor hundreds of thousands of transactions per second and collect tens of billions of events each day).

Assist product management, data science, and development in product/solution planning and prioritization.

Analyze and investigate impression level data to conceptualize stories and write research reports.

Created ETL documentation such as Data Mapping, Transformation logic for Main Frame Layout, Updating Metadata documents for new Platform.

Conducted comprehensive data analysis by interpreting and applying statistical techniques to extract meaningful insights.

Developed and implemented efficient databases, data collection systems, and data analytics strategies, enhancing statistical efficiency and data quality.

Acquired and managed data from primary and secondary sources, ensuring the integrity and reliability of data systems.

Identified, analyzed, and interpreted trends and patterns within complex datasets, providing valuable insights to support decision-making.

Employed data cleansing techniques to review computer reports and indicators, identifying and rectifying code problems.

Collaborated with management to prioritize business and information needs, tailoring data analyses to meet strategic objectives.

Continuously sought and defined new process improvement opportunities to streamline data-related workflows.

Created, managed, and tracked stories in JIRA EPIC tools and discussions for solutions in daily stand meetings, template workshops with DMI team from Master Data management system.

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

Environment: Agile-Scrum, MS Office, Excel, Jira, SQL, LOS, Fiserv Signature, Crystal Reports, ETL, Tableau, Informatica.

Education:

Bachelor of Science in Finance 2011 Cal State University of Northridge

SKILLS

Proficient in Tableau, Power BI, Anaplan, Jira Tempo data and analytics, Alteryx, Excel, and SQL

Proficient in Data Cleaning, Data Analysis, Data Mining, ETL Processes

Experienced in Financial Forecasting and Process Optimization

Time Management and Team Leadership

Excellent written and verbal communication skills and presentation skills

Excellent problem-solving skills and critical thinking skills

Highly motivated, self-driven individual with a strong focus on process efficiency

Keen to learn every aspect of our industry.

Contact this candidate