SUMMARY

• Highly motivated data - driven Analyst wif over 5years of proven experience in analyzing data and interpreting valuable insights that drives growth and retention.
• Proven expertise wif demonstrated history of success in executing data & analytics end to end projects and creating data-driven strategic initiatives for better optimization.

TECHNICAL SKILLS

Database Specialties: Data Analysis, ETL, Data Modeling, Data Integration and Migration

BI Reporting/Data Visualization Tools: Tableau, Business Objects, Power BI, SSRS

Data Analysis Tools: SQL, Advanced Excel, Python, Infomatica, SSIS

Web Analytics: Google Analytics, Google Tag Manager

Big Data Technologies: AWS, Microsoft Azure, Hadoop

Business Analysis: Needs Assessment, Elicitation Task, JAD sessions, GAP Analysis, User Requirement Analysis

Software: MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), MS Visio, MS Office, MS Project, JIRA

Processes/Technologies: Waterfall, Agile, MS Office SharePoint.

PROFESSIONAL EXPERIENCE

Data Analyst / Consultant

Confidential

Responsibilities:

• Healthcare Analysis - Analyzed healthcare data that identified key influencing factors of heart disease and hypertension, identified patterns and the impact of demographic and behavioral factors on patients wif these diseases, and the likelihood of patients having hypertension and heart disease. Developed an analytics dashboard by applying descriptive statistics on historic data. Generated key insights and created an executive report outlining the problems and possible recommendations to help reduce the likelihood of patients contracting these diseases.
• Retail Analysis - Extracted datasets from multiple sources (Google analytics, QuickBooks, Salesforce CRM) and loaded the datasets into SQL relational database, created multiple tables required for analysis and leveraged SQL syntax to retrieve, manipulate and extract results of analysis. Integrated SQL server into Power BI, built data models & created relationships across multiple tables. Analyzed customer data and created KPI metrics to measure success. Finally built an analytics solution that provided valuable insights on sales and automated reporting in real-time. Presented my findings and high-level insights and recommendations on business initiative strategies to help drive sales and maximize profit and ROI.
• Website Analysis - Integrated Google Analytics into Power BI to build an automated dashboard solution for the company for real-time reporting and insights. Identified KPI metrics based on the business goal. Collected, transformed, analyzed, and built an interactive dashboard that provided insights on the TEMPeffectiveness of marketing campaigns. Created marketing strategies based on the insight on the most efficient marketing media mix channel for launch new campaigns which helped save wasteful marketing spend, increased CTR & customer acquisition rate.
• HR Analysis - Extracted datasets from Postgre SQL database by exporting into excel format thus cleaning the data and integrated by transforming it into Power BI to build an automated dashboard solution for the company for real-time reporting and insights. Personnel KPI metrics were analyzed based on the business goal and successfully provided data story and the executive report for the company.

Analyst

Confidential

Responsibilities:

• Identified the needs of all stakeholders by traveling on-site for project requirements and emergencies in underground utility mapping.
• Audited Data and mapping on existing records & provide report on imperfect or unnon existing data for damage prevention
• Primary function was to analyze ArcGIS Data map for National grid to ensure the measurement are relative for a successful underground locate thus saving the company 100% no structural damage for my coverage.
• Analyze underground Verizon, Comcast, and RCN utilities mapping wif the use of PMT and USIC “Translore” data mapping.
• Created reports in accordance wif the procedures for providing a successful damage prevention for all stakeholders involved.
• Interacted wif Business Analyst, SMEs, Contractors, and other relevant Architects to understand Business needs and functionality for various project solutions.
• Assist wif the daily management of operational functions of the Project Team, including preparation and minutes for standing meetings, reporting processes and information flow.
• Collecting and analyzing the project’s requirements and transfer the same noledge to the development technology team.

Business Data Analyst/Project Coordinator

Confidential

Responsibilities:

• Implemented and executed full data analytics project lifecycle from data collection, data cleaning, apply statistical analysis and visualizing KPI metrics, presentation, and storytelling to generate insights on performance.
• Merged data from disparate sources, applied statistical analysis to get the summary of historic trend, pattern, outliers and key drivers for a data-driven decision making.
• Data Analysis of existing content on SharePoint and Exchange on-premise/ legacy platforms to migrate to online platforms and implementing Office365 applications at organizational level
• Providing documentation support for requirements gathering process communication to stakeholders.
• Successfully assisted in eliciting and analyzing requirements from clients to create high level business requirement documents such as The Charter and Project plan.
• Adequately documented gap analysis and design of new functionality for IT Infrastructure Build out for new and existing facilities.
• Successfully engaged in various technical project management processes wif scope, schedule, and Cost management.
• Coordinated business activities on behalf of PM towards application development and integration of projects such as Microsoft office 365 roll out and SAAS for the firm using MS Projects.
• Hands on experience in extracting data files from various database sources, thus using ETL techniques in data cleaning/scrubbing.
• Gathering and analyzing data, performing multi-varied statistical analysis like Regression using Advanced Microsoft Excel tools like VLOOKUP, HLOOKUP, INDEX-MATCH.
• Created reports on different Key performance indicators (KPI) on Power BI dashboards for various projects.
• Consistently assisted wif the insights of various data reports thus sharing ideas on inferences made and proffer solutions to help management improve business decisions.
• Evaluated and articulated business and technical requirements to identify impact, risk, and benefits by performing various forms of elicitation task to create solutions to business problems.
• Documented business requirements, functional specifications and user stories for new systems, systems change and enhancements.

Customer Service/Lead Data Analyst

Confidential

Responsibilities:

• Team lead for account services integration on Omniflow Intelligent Business Process Suite project into the core banking system of FLEXCUBE.
• Collected and evaluated consistency and importance of different business intelligence data against performance of users and other needs.
• Credited for playing key role in generating over $.5 million per year in revenues through structured marketing on automated data reports for target markets.
• Adequately Extracted data from various sources such as Business objects thus using ETL techniques in data cleaning/scrubbing for performance analysis and creation of dashboards.
• Consistently Improved the decision-making process by supporting wif insights and conclusion needed from the analytics and visualization created.
• Promptly collaborated wif Project Managers, Business Partners, and other IT experts by attending meetings for optimization of the department projects for the success of the company.
• Successfully Planned and executed events and training programs using MS PowerPoint thus producing 2 times the goal of all qualified team leads.
• to business problems.
• Documented business requirements, functional specifications and user stories for new systems, systems change and enhancements.
• Adequately gatheird daily data from databases wif the use of SQL and business Objects to preform research analysis wif excel and SPSS tools and develop complex reports on customer service data.
• Demonstrated an advanced proficiency in MS Excel by using pivot tables to analyze business metadata and build summary reports.
• Observed market trends by building classification models using data mining techniques wif different classifiers and produce reports to get a clear picture of the department’s operations and ways to improve it.
• Proffered the results of findings wif the use of Microsoft PowerPoint into easily understand report insights and presentations for management to improve system efficiencies and reduce total expenses.
• Improved by 40% the units profit margins and sales on intercompany catalog, product matching, inventory, and timely delivery of orders to clients by analyzing wif Microsoft excel, business objects and other CRM tools.
• Successfully provided the department wif process and sales improvement strategies by working closely wif subject matter experts, marketing teams or management to develop and implement plans.
• Responsible for training employees in new processes and strategies to help wif process or sales improvement and initiatives.