Sql Server Business Intelligence

MUNKHBOLD, UNDRALBOLD

Vernon Hills, IL, ***** +1-773-***-**** ***********@*****.***

Professional Summary

5+ years of IT experience in Data Analysis, Design, Development, Maintenance and Documentation of Business Intelligence solutions, Strong knowledge of MSSQL, Oracle, MySQL, Snowflake with Strong SQL and ETL job (SSIS) and BI Tools (Tableau) experience.

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

Work Experience

DATA ANALYST SPECTRUM 05/2023 – CURRENT CONTRACT

Results-driven Data Analyst with a proven track record of transforming data into actionable insights to support business operations and strategic decision-making. Proficient in SQL, data visualization tools (Tableau, Power BI), and statistical analysis to identify trends, optimize processes, and improve customer engagement. Adept at collaborating with cross-functional teams to develop dashboards, generate reports, and present complex data findings to stakeholders. Passionate about leveraging data analytics to drive growth and efficiency in dynamic environments.

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 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 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.

DATA ANALYST FOUNDEVER 03/2020 – 04/2023 CONTRACT

Insightful and results-driven Data Analyst specializing in customer experience (CX) analytics to support strategic decision-making and operational efficiency. Proficient in data visualization (Tableau, Power BI), SQL, and advanced data analysis techniques to identify trends, optimize processes, and enhance customer interactions. Adept at translating complex data into actionable insights that improve service delivery and client outcomes. Passionate about leveraging data to help Foundever deliver seamless, meaningful customer experiences for leading global brands.

Collect, clean, and analyze large datasets to provide actionable insights that enhance customer experience (CX) and operational efficiency.

Develop dashboards and reports using tools like Tableau, Power BI, and Excel to track key performance indicators (KPIs) and business trends.

Conduct in-depth analysis of customer interactions to identify pain points and recommend data-driven solutions for improving client satisfaction.

Collaborate with cross-functional teams, including operations, technology, and customer support, to define data requirements and deliver analytics solutions.

Perform root cause analysis on operational issues and present findings to senior management for strategic decision-making.

Identify patterns and trends in customer behavior to support marketing, product development, and service enhancement initiatives.

Build predictive models and perform advanced statistical analyses to forecast trends and optimize business processes.

Develop and automate reports to streamline performance monitoring and provide real-time insights to stakeholders.

Ensure data accuracy and integrity by validating data sources and maintaining comprehensive documentation.

Support continuous improvement initiatives by identifying opportunities for process optimization through analytics.

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

RESEARCH ENGINEER ANALYST PROFESSIONAL ENGINEER OF MINISTRY OF CONSTRUCTION AND URBAN DEVELOPMENT 12/2013 – 06/2016

Results-driven Research Engineer Analyst with expertise in analyzing engineering data, evaluating construction designs, and conducting research to support large-scale infrastructure projects. Skilled in technical assessments, cost analysis, and ensuring compliance with national and international construction standards. Adept at collaborating with multidisciplinary teams to deliver innovative and sustainable solutions for urban development. Passionate about contributing to strategic planning and policy-making to advance infrastructure growth and modernization.

Conducted technical research and analysis on engineering trends, materials, and innovative construction technologies to support infrastructure development projects.

Evaluated and optimized construction designs, specifications, and feasibility studies to ensure compliance with national and international standards.

Performed cost-benefit and resource allocation analyses to improve efficiency and reduce project expenditures.

Assessed environmental and structural impact data to support sustainable urban planning initiatives.

Prepared and presented detailed technical reports, research findings, and policy recommendations to senior officials and stakeholders.

Conducted risk assessments and developed mitigation strategies to address potential engineering and operational challenges.

Monitored construction project progress, ensuring adherence to budgets, timelines, and regulatory guidelines.

Collaborated with cross-functional teams, including architects, urban planners, and contractors, to achieve project goals.

Provided expert recommendations for the development of engineering codes, regulations, and best practices.

Supported policy-making initiatives aimed at advancing national infrastructure and sustainable urban development.

Education

MASTER OF DATA ANALYSIS CERTIFICATE COURSE TECH2HIGH VA, USA 2018

BACHELOR ELECTRONICS ENGINEERING AND HARDWARE 2002 - 2006

ULAANBAATAR UNIVERSITY

Contact this candidate