VICKY MALIK
*********@*****.*** 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