About Me
Detailed-oriented and results-driven Information Science professional who excels at maintaining large databases, performing data collection and analysis, and conducting detailed reports. Experience in product analytics, …
Detailed-oriented and results-driven Information Science professional who excels at maintaining large databases, performing data collection and analysis, and conducting detailed reports. Experience in product analytics, storytelling, industry research, and database management to increase productivity and reduce costs. Expertise in a broad range of technologies, including business process tools such as Microsoft Project, Excel, MS Access, MS Visio, a wire framing tool such as Balsamiq, and Azure. Possess great analytical skills, excellent multitasking skills, strong attention to detail, and a significant ability to work in a team. A verifiable track record of managing complex projects while always delivering on time and above expectations. Dedicated team member and collaborator with experience working in diverse teams to meet complex and varying customer desires and impeccable conflict resolution abilities. Decisive and direct yet flexible in responding to constantly changing assignments. Good knowledge of using JIRA and reviewed them in subsequent iterations of the application development
Experience
Business Data Analyst
Responsible for providing data analysis that focused on improving the user experience and optimizing user retention
Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions, and common table
expressions to track user activity metrics such as retention rate and daily active users. Optimized existing queries to
run faster on large datasets.
•Created and analyzed business requirements to compose functional and implementable technical data solutions.
•Designed and maintained MySQL databases and created pipelines using user-defined functions and stored procedures
for daily reporting tasks.
•Spot and analyze trends in user activity data, identify underperforming user segmentation, and report insight to
stakeholders.
•Built ETL pipelines to retrieve data from NoSQL databases and load aggregated data into the analytical platform.
•Generated, wrote, and ran SQL scripts to implement the DB changes, including table updates, addition or update of
indexes, creation of views, and store procedures.
Data Analyst - part time
Responsible for providing data analysis that focused on improving the user experience and optimizing user retention.
Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions, and common table expressions to track user activity metrics such as retention rate and daily active users.
Optimized existing queries to run faster on large datasets.
Created and analyzed business requirements to compose functional and implementable technical data solutions.
Designed and maintained MySQL databases and created pipelines using user-defined functions and stored procedures for daily reporting tasks.
Spot and analyze trends in user activity data, identify underperforming user segmentation, and report insight to stakeholders.
Built ETL pipelines to retrieve data from NoSQL databases and load aggregated data into the analytical platform.
Generated, wrote, and ran SQL scripts to implement the DB changes, including table updates, addition or update of indexes, creation of views, and store procedures.
Data Analyst
Assist in data preparation activities including exploration, cleansing, validation, integration, transformation, and aggregation of data.
Support the design and implementation of technical enhancements to the company’s data warehouse, including database design, ETL processes, access, and security.
Develop ETL processes and reusable packages according to standards reflecting industry-specific best practices.
Participate in and influence the design, planning, and implementation of the organization’s projects and initiatives regarding database system performance and administration.
Design, develop, and support databases, data marts, data dictionaries, and metadata repositories.
Participate in the analysis and resolution of issues related to information content, data integrity, integration, and performance.
Support the implementation of Business Intelligence solutions for company-wide performance reporting needs.
Analyze the data and identify gaps, data quality issues, and integrity issues.
Create and maintain system documentation, including a data dictionary.
Assist IT team in supporting database administrator functions, including managing servers and users.
access, database security, optimization and performance tuning, capacity planning, and disaster recovery.
Develop and maintain data standards for consistency and quality.
Collaborate with Subject Matter Experts and Product Owners to define the data requirements and source-to-target mapping necessary to support advanced analytics initiatives.
Provide recommendations for technical solutions based on best practices
Data Analyst
Extracted databases from the server using SQL queries and stored procedures, and built an ETL pipeline using Python.
Performed complex analyses of the developmental, financial, and organizational databases Using Excel.
Participated in identifying, analyzing, and interpreting trends, patterns, correlations, and anomalies in complex datasets to find insights and draw conclusions.
Lead in the development of data analytics visualizations and statistical reports to assist News Safety Sol and its clients in their decision-making processes
Design, build, and deploy business intelligence reports and create plots and dashboards using PowerBI.
Responding to customer queries, problem identification, and solution, and maintaining SLAs, analysis, and visualization of insights from customer data (using Python, Tableau, and SQL) for decision-making to improve the customer’s involvement by 10%
Integrate and Forecast revenue and reservations using Excel statistical tools based on market trends and profit margins.
Analyzed the service reports to identify the weaker areas for support and helped optimize the support processes, thereby reducing SLA breaches by 25%.
Build several machine learning and statistical models for solving stakeholders’ problems.
Understand data mapping and data flow within the supported systems.
Production Designer
Illustrate design ideas using storyboards, process flows, and sitemaps.
Proficient in using design software such as Adobe Creative Suite, Sketch, or similar programs.
Experience creating detailed and professional concept renderings for a range of projects.
Collaborate with the client to successfully create prolific social media graphics suitable for target marketing.