Data Analyst Analysis

NYAMTSEND 703-***-**** VIRGINIA,USA

Data Analyst

Professional Summary

Highly skilled and motivated Data Analyst from Supervisory and Management career with a strong background in SQL, PL/SQL, SSIS, Tableau, and Python. Proficient in analyzing complex datasets, generating actionable insights, and presenting findings to stakeholders. Adept at designing and implementing ETL processes, data visualization, and predictive modeling. Demonstrated ability to collaborate with cross-functional teams and deliver data-driven solutions that drive business growth and process improvement.

Objective:

Seeking Data analyst an administrative, supervisory, or management position with a company which will require me to utilize my skills, abilities and experience to ensure the company's success ultimately allowing me to grow and enjoy a long and productive relationship.

Technical Skills

- Developed and optimized SQL queries to extract, transform, and load data from various databases into analytical datasets, improving data accuracy and efficiency.

- Utilized PL/SQL for data manipulation, data cleansing, and implementing business logic, resulting in a 20% reduction in data-related errors.

- Designed and implemented SSIS packages for data integration, transformation, and automation, streamlining data workflows and reducing processing time by 30%.

- Created interactive and insightful dashboards in Tableau, allowing stakeholders to visualize key performance indicators and make informed business decisions.

- Collaborated with business stakeholders to identify data requirements and performed data analysis to uncover patterns and trends, providing actionable insights for business process optimization.

- Utilized Python for data wrangling, statistical analysis, and predictive modeling to support marketing and sales teams in targeting high-value customers, resulting in a 15% increase in conversion rates.

- Conducted ad-hoc analysis and data mining to identify customer behavior patterns, enabling the marketing team to tailor marketing campaigns effectively.

SKILLS:

- Languages: SQL, PL/SQL, Python

- Tools: SSIS, Tableau

- Data Analysis: Data Wrangling, Data Visualization, Exploratory Data Analysis

- Statistical Analysis: Hypothesis Testing, Regression Analysis, Predictive Modeling

- Database Management: MySQL, Microsoft SQL Server

- Communication: Data Presentation, Stakeholder Collaboration

Professional Experience

DATA ANALYST BTM SOLUTIONS 05/2017 – 08/2023

I am responsible for ongoing monitoring, creating reports using SQL and surfacing of new threats in the digital advertising ecosystem. My team had extensive interaction with large data sets (we monitor hundreds of thousands of

transactions per second and collect tens of billions of events each day)

Analyze and investigate impression level data in order to conceptualize stories and write research reports based on the data.

• Partner with Marketing to drive publication and distribution of noteworthy stories coming from internal investigations.

• 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 data loader that connects REST based WEB API’s using JSON and XML body.

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

• Excellent analytical abilities and a strong ability to think creatively when approaching issues

• 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 with Strong data mining skills.

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

• Involved in several complex financial reports related to Non-performing Loans portfolio, which includes Credit Loss Reporting Package and Annual Reports Package.

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

• Apply business insight to research for C-Level thought leadership stories that define high level trends by industry, vertical or geographic area.

• Staying on top of emerging threats that could be first to market blogs

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

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

DATA ANALYST INTERNSHIP Zelis Payments, Bedminster, NJ 11/2016 – 04/2017

Conducted exploratory data analysis on a payment company's customer transaction data to identify patterns and trends.

Gathered and analyzed large datasets from various sources, including internal databases, external APIs, and third-party data providers, to identify trends, patterns, and insights relevant to the company's business goals and objectives.

Employed clustering algorithms to segment customers based on spending behaviors and demographics.

Presented findings through interactive Tableau visualizations, helping marketing teams target specific customer segments effectively.

Collecting and compiling transactional and user data from various sources, ensuring data accuracy, and performing data cleaning to remove inconsistencies and errors.

Monitoring and analyzing payment trends, customer preferences, and market dynamics to provide actionable insights for product development and marketing strategies.

Creating insightful and visually appealing data visualizations, charts, and graphs using tools like Tableau or Power BI to communicate findings and trends effectively to stakeholders.

Assisting in the development and maintenance of performance dashboards and reports to track key performance indicators (KPIs) related to payment transactions, user engagement, and business goals.

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

Public Officer, Mineral Resources Authority of Mongolia, Ulaanbaatar, Mongolia 2005 – 2015

• Reviewed drafts of legislation and regulations and made own contributions through inputs

• Evaluated mining projects and Researched market price of coal and built database of mining activities

• Established and maintained relationships with mining authorities in Germany and Australia

• Trained artisanal miners about legal environment and occupational health and safety standards

• Prepared and translated meeting presentations and other materials

• Established and maintained strong relationships with local, national and international constituencies

Executive Director and National Coordinator, SOS Children's Village of Mongolia 2002 - 2004

• Established and maintained strong relationships with local, national and international constituencies

• Responsible for all aspects of managing 14-house orphanage for 100 children, aged 2 months to 16 years, with annual budget of $250,000

• organized fundraising activities

• Worked with staff to prepare budgets, administer funds, and provide comprehensive reports

• Established and maintained strong relationships with local, national and international constituencies

• Hired, trained and supervised employees

Camp manager in Oyu Tolgoi 2001-2002

• Managed all camp housing, catering, supply, payroll, and other administrative activities necessary for successful operation of the camp; ensured that occupational health and safety standards were met

Salesperson and Translator, Mercedes Benz; Mongolian Star Melchers LLC 2000 - 2001

• Learned automobile capabilities and features; met and developed potential purchasers; negotiated sales deals and closed transactions

• Planned and monitored delivery of programs and services;

•Translation of technical texts

Executive Director for SALE, OSSO LLC, Ulaanbaatar, Mongolia 1998 – 2000

• Managed day-to-day local operations; met with store managers and negotiated sales contracts; monitored inventory levels; organized distribution of products; collected payments

Budget manager and economist at the Copper mining and processing plant Erdenet in Mongolia 1995-1996

• planning and analyzing production, reporting

Sales officer and accountant at the foreign trade corporation “ Technikimport”, Mongolia 1989-1991

•marketing, analyzing and calculating, reporting, generating financial balances

Education

• Degree in Engineering and Economics, Mining Academy of Freiberg, Germany 1984 – 1988

• Certificate, German Language Course, University of Wismar, Faculty of Engineering; Wismar, Germany 1984

• Certificate, German Language Course, Mongolian State University; Ulaanbaatar, Mongolia 1983

• Certificate of the High school in Russian language, Proficiency in Russian and English, 23rd Secondary School; Ulaanbaatar, Mongolia (graduated 1982)

Certification

• DATA ANALYST TRAINING AT THE BOOT CAMP "TECH2HIGH" October 2015

• International Mining for Development Centre (IMAD), Alumni Forum, Sydney, Australia May 2013

• Occupational Safety and Health, University of Western Australia; Perth Australia, Nov - Dec 2012

• Sustainable Mining Institute "Life of Mine-2012", University of Queensland; Brisbane, Australia July 2012

• Lausitz and Central German Mining Administration Company (LMBV), Senftenberg, Germany

o Certificate, Remediation of Mined Landscapes 2012

o Certificate, Restoration of Mining Sites 2010

• Vienna Chamber of Commerce and Industry, Vienna, Austria

o Certificate, Management Course 1992

PERSONAL SKILLS AND QUALIFICATIONS:

• Fluent in Russian, German and Mongolian; proficient in English

• Citizen of the USA since 12.2018

Contact this candidate