Business Intelligence, Dba And Data Warehouse Analyst
CurrentBusiness Analyst, Marketing Professional, Database Administrator: Responsible for database construction and maintenance, indexing and system fine-tuning. Design and optimize queries and oversee execution. Implement database replication between servers. Create tables, stored procedures and views. Provide database backup and restore functions. Administrate security and login privileges. Conduct database analysis. Data Warehouse Analyst: Design and develop SQL databases for clients for research and reporting services using ETL technologies. Troubleshoot query issues, report malfunctions and system-wide challenges. Provide Business Intelligence using OLAP tools: Conduct data mining, research, analysis, insights and report writing to support Marketing and eCommerce opportunities. Proficient in Tableau, Adobe Analytics, Google Analytics. Advise clients on strategic marketing campaigns, provide economic forecasting, brand development, product or business positioning. Direct PR events, public speaking opportunities, sponsorships and promotional efforts, and social media activity. Advanced graphic design and illustration skills for effective presentation. Advanced Statistical Analysis (SPSS), including linear multi-variate regression (correlation, contingency tables, ANOVA, inference, chi-square, t-tests); time series analysis (database design, conversions and cleaning, trend analysis, modeling, forecasting and confidence estimation); exploratory and confirmatory factor analysis. • Successfully increased profits for small businesses and corporate entities. • Expanded operations into new markets and increased product awareness. • Designed internal operations to be more efficient, effective and that reduced costs.• Provided guidance on database development, data engineering and data mining. • Developed online applications that save money and increase efficiency.