Data Analyst

VICKY MALIK

ac3l18@r.postjobfree.com 972-***-****

Charlotte, NC

SUMMARY

Proficient in SAS, SQL, Relational database, Microsoft Office (Excel, Access, Power point, Word, Outlook), Microsoft Visio, Microsoft Project, R programming, Tableau

Well-versed experience in different domains such as FMCG, IT, Banking, Insurance

Experience in data mining, data warehouse and using databases with large-scale, complex data sets, data profiling, Advanced Excel, VLOOKUP, VBA, Macros

Performed quantitative and qualitative analysis on large data sets

Good knowledge in machine learning, predictive modeling using support vector machine - SVM, Naïve Bayes (NB), regression, clustering, Looker

Developed general-purpose and ad-hoc SAS programs for the extraction, manipulation, analysis, presentation, and validation

Excellent knowledge on Business Analysis, Data Analysis, requirement gathering and creating Business Requirement Documents and Technical Specification Documents, Star schema, Snowflake schema, and excellent knowledge on Kimball and Inmon methodologies

Strong knowledge and experience in Manual Testing, Automation Testing using Selenium Web Driver, Java programming, analyzing, creation and execution of Test Cases, HTML, GIT repository, Jenkins (CI)

Good knowledge in Informatica, ETL, Python, machine learning

Passion to learn new things about systems, business and data and apply knowledge resourcefully

Highly adaptive to a fast-paced team environment and with a proven ability to work in a team Environment and individually.

Excellent verbal and written communication skills, attention to detail

PROFESSIONAL EXPERIENCE

Bank of America – Charlotte, NC Mar.17 - Present

Business Data Analyst

Collaboration with departments for Identification of Key Performance Indicators(KPIs), evaluate and provide presentation to Senior Vice-president

Organizing and facilitating the Joint Application Development (JAD) sessions with project stakeholders and subject matter experts to capture business rules, processes, and system requirements

Communication and interaction on a regular basis with the project manager and development team

Modified Use cases and updated BRDs to reflect changes in business need

Preparation of Business Process Models that depicted modeling of all the activities of the business from the conceptual to procedural level

Providing recommendation for strategy and process improvement.

Identification and adoption of best practices in analysis, reporting, data integrity, validation and documentation

Conducting and analyzing information technology processes and researching of new techniques for streamline process

Performed SQL queries and maintenance of databases

Conducting adhoc analysis with different data sources to identify gaps and trends. Reduced error rate by 15%

Performing document research, design, development, layout formatting and editing

Utilizing Business Intelligence tool (Micro-Strategy, Tableau) to extract reports, modeling of data and metadata and developing actionable solutions

Designing protocol, data collection, cleaning, analysis and management of data

Netlogic Solution- Frisco, TX Feb.16 – Mar.17

QA Automation Tester

Performed automated tests (Using Selenium WebDriver) to conduct functional and regression tests on the applications

Creating software and system documentation for developers

Preparation of test Scenarios, test design, test cases as well as data prep prior to Testing

Execute test cases and logs defects in JIRA and defects triage calls with project stakeholders

Involved in enhancement of automation frameworks using Selenium, Jersey client and TestNG

Implemented a Data Driven Automation Framework using Selenium WebDriver

Used Gradle to build and run Selenium Automation Framework and TestNG as a test runner

Tested Business processes which are exposed as Message Based Processes Using SOAP UI Tool

Used Jenkins for continuous integration and scheduling the build

PepsiCo – Gurgaon, Haryana, India Jun.10- Apr.13

MIS Analyst (Data Analyst)

Harmonized with departments, operational teams for identifying, defining and documenting business requirements and translated into actionable items

Coordinated with Marketing team and product development team to understand business needs and developed actionable solutions.

Assisted with business case, planning and monitoring, translating and simplifying requirements

Developed and monitored forecasting models, performed trend analysis

Analyzed and interpreted data sets using different techniques. Documents findings, summarized and presented data-driven and analytics based recommendation

Created and implemented process improvement for vendor management. Increased sales by 35%

Designed predictive models and developed strategies for deploying them

Initiated Sales dashboard every month, quarter that presented a snapshot of performance of Brand, categories and players to the finance

Predictive model and clustering of customers to assess marketing campaign performance

Assessed a new measuring technique and identified its principal sources of variations

Designed templates for the team to automate many steps in process also built validation process that involves the complex data structure within an aggressive timeline.

Leveraged large data sets and provided recommendation on retail business forecasting

Hewlett Packard (V5 Global Services Pvt Ltd) – New Delhi, India Mar.09- June.10

Hewlett Packard (Bytech India Pvt Ltd)- Gurgaon, Haryana, India Jan.07- Feb.09

Data Analyst

Captured, developed and documented data definitions, business rules, data quality requirements, logical and physical data model based on requirements

Developed and governance data collection processes that optimize statistical efficiency and performed data quality operations and developed customized format for payment processing

Used Siebel tool to register partners with HP, documentation and highlighted to key stakeholders for any discrepancies

Contact this candidate