| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateNYAMTSEND PHONE NUMBER AVAILABLE VIRGINIA,USAData AnalystProfessional SummaryHighly 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 CollaborationProfessional ExperienceDATA ANALYST BTM SOLUTIONS 05/2017 08/2023I 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 oftransactions 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 APIs 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/2017Conducted 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 constituenciesExecutive 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 employeesCamp 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 metSalesperson 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 textsExecutive 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 paymentsBudget manager and economist at the Copper mining and processing plant Erdenet in Mongolia 1995-1996 planning and analyzing production, reportingSales officer and accountant at the foreign trade corporation Technikimport, Mongolia 1989-1991marketing, analyzing and calculating, reporting, generating financial balancesEducation 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, Germanyo Certificate, Remediation of Mined Landscapes 2012o Certificate, Restoration of Mining Sites 2010 Vienna Chamber of Commerce and Industry, Vienna, Austriao Certificate, Management Course 1992PERSONAL SKILLS AND QUALIFICATIONS: Fluent in Russian, German and Mongolian; proficient in English Citizen of the USA since 12.2018 |
