Manpreet Kaur

E-mail: addr7o@r.postjobfree.com Phone : 571-***-**** LinkedIn : linkedin.com/in/manpreetkaur27/ Professional Summary

• A result-oriented Business Data Analyst with 5+ years of experience in Finance, Networking, Telecom, Sales and Marketing Domain with extensive exposure to analyzing user requirements, business modeling, process simulation data analysis and statistical modeling including data extraction, manipulation, forecasting, design and implementation.

• Strong Business, Communications, Written and Presentation Skills written (reports, implementation requirements, project status reports, oral presentations, e-mails), update executive staff and team members with goals, project status, with expertise in conflict resolution. Extensively worked with various database systems like Oracle, Teradata, MS Access, Flat files, XML and SQL Server.

Core Competencies

Database:

SDLC Methodology:

Data Modeling:

Language:

Tools:

Documentation:

Certification:

SQL Server, Oracle, MS Access.

Waterfall, Agile / Scrum.

Star Schema, ER Diagrams, Pivot tables.

C, C++, Python, SQL, R.

Tableau, Salesforce, Confluence, HP Quality Center, JIRA. MS Project, MS SharePoint, MS Visio, Business Process Modeling (BPM), Business Intelligence (BI). HP ALM

(Application Life cycle Management), HP UFT (Unified Functional Tester), SEED Certified Technology Specialist, Scrum Alliance Certified Scrum Professional credential ID- 001080729 Professional Experience

Business Data Analyst, Hughes Network Systems, Germantown, Maryland, USA., April 2019– Present

• Working closely with Pre-sales, Product Line Management, Marketing, Business Group, UI/UX and Customer service Teams for North America and International Division to create and analyze Salesforce.com standard objects like Accounts, Contacts, Contracts, Opportunities, Products, Quote, Activities, Reports and Dashboards.

• Co-ordinating with Team to implement scrum ceremonies (grooming, sprint planning, reviews, retrospectives, daily stand-ups, etc.)

• Conducting various brain storming, JAD to accomplish the integration requirements daily. This involved communicating with various other internal teams within Hughes and external vendors.

• Involving in maintaining requirements, defects, test Cases in Jira for Tracking and Testing purposes. Working on Analysis, design, development, and implementation of salesforce.com applications.

• Developing front-end prototypes, BRDs, FRDs, Configuration Tech Design Documents, Interface specification Documents which provided Detail descriptions of the salesforce functionality.

• Co-ordinating with cross functional groups such as product marketing and operations to create work flows rules, time triggered Task, process builder, Email alerts, Field Updates, approval processes, approval page layouts and defined approval actions on them to implement Business logic and at the same time automate the processes.

• Creating Use Case diagrams by analyzing the business process followed by Class diagrams, Activity diagrams and Collaboration diagrams in UML.

• Utilizing MS-Visio for model diagrams and Rational Rose for UML class modeling and Visual modeling.

• Working closely within DEV, TEST and PROD environments to deploy development of Apex Classes, Controller Classes, Apex Triggers and Visual Force Pages for various functional needs.

• Working closely with Release Management Team for consolidating Signoffs from business users and providing them with post and pre-Migration data mapping documents.

• Working on test cases during SIT, Functionality, Smoke testing & assisted business users during UAT Testing. Supported Business Users during and after UAT & Production deployment and checkout.

• Integrating the API and Web Services for extracting the data from Installation portal, DSS and Oasis Portals to store in the Salesforce CRM using REST services.

• Pro-efficiently using SQL, SOQL and SOSL queries for data cleanup and data analysis. Created multiple reports and dashboards based on business requirements and displayed using Tableau

• Communicating complex analytical insights and business implications effectively and Actively manage the timeline and deliverables of projects, focusing on interactions within the team as and when required.

Tools: Salesforce.com platform, Apex Classes, Visual Force, Apex Triggers, SQL, SOQL, SOSL, JIRA, Agile SCRUM Framework, HP ALM, MS office suite, Agile Central, XML, Visio, MS Project, MS Word, MS Excel, MS Access, UI/UX, Rational Rose. Data Analyst II, Capital One, McLean, Virginia, USA., August 2018 – March 2019

• Worked closely with the Sales, Accounting, Marketing, Administrative Support, Finance and Business Intelligence teams to gather/analyze requirements and map them to solutions that leverage salesforce functionality.

• Responsible for driving the User Requirements / Functional Requirement Workshops.

• Assigned user stories and worked with team members to resolve any issues they have in completing the tasks by providing support and guidance.

• Worked with the Marketing team for defining CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote, Forecasting, and Call Center.

• Implementing and managing Agile and Scrum practices for onshore and offshore teams.

• Worked towards Migration of security framework to SFDC Wave using users, roles, public groups and implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.

• Worked on Salesforce.com Service Cloud development including SDLC, standard and custom objects, Apex, and Visual force pages.

• Building data sets from information resources such as SFDC Sales cloud, SAP BW and Oracle in SFDC Wave.

• Assisted in development of marketing materials to support ongoing opportunities for the Campaign Management at the various accounts.

• Worked on Salesforce.com Service Cloud development including SDLC, standard and custom objects, Apex, and Visual force pages.

• Visualization of data over multiple channels such as Web and Mobile using SFDC Wave.

• Used Redshift within AWS. Used Amazon s3 along with Informatica Cloud Services to load data into s3 bucket.

• Summarized abnormalities, provided suggestions to senior analyst and maintained data archive stored on AWS

• Used Autosys scheduler to schedule ETL jobs per required batch scheduling timelines.

• Worked on SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results.

• Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop to validate static and dynamic data for data validation. Manpreet Kaur

E-mail: addr7o@r.postjobfree.com Phone : 571-***-**** LinkedIn : linkedin.com/in/manpreetkaur27/

• Perform UAT testing and certify the release application before production release.

• Prepared and executed Test Cases, Test Scripts for Functional Testing, Regression testing and Defect tracking in HP ALM.

• Worked with data mapping from source to target and data profiling to maintain the consistency of the data.

• Performed Defect Reporting and Tracking using HP ALM.

• Involved in creating UAT test scenario, test cases from FRD and design document.

• Validated and executed Test Cases in UAT environment in different browsers and logged defect in Jira for failure Test Cases. Tools: Salesforce.com platform, Visual Force, Apex, SFDC Wave, SFDC Sales cloud, SQL, SQL Server, AWS, Amazon s3,UML, Rational Requisite Pro, Test Manager, Windows, Agile, MS Visio, MS Access, MS Project, UAT, JAD, UML Diagrams, Tableau, HP ALM. Business Data Analyst Sr., Axis Bank Ltd, Mumbai, Maharashtra, India., May 2014 – July 2016

• Worked with Inward Remittance team a s a subject matter expert in Fixed Income Annuities, Equities, Swaps, Finance, Trading Cycle, Portfolio Analysis & Management, Asset Management, Bonds and Bond Trading Cycle, Pricing and Derivatives to understand and gather requirements to improvise calculations of credit risk

• Created documents in support of defining the source to target data mappings, business rules and data definitions.

• Built and analyzed datasets using R and Python (in decreasing order of usage).

• Provided support to Data Architect and Data Modeler in Designing and Implementing Databases for MDM using ERWIN Data Modeler Tool and MS Access.

• Used pandas in Python for developing various machine learning algorithms.

• Efficient in Data Manipulation & Visualization, Web Scraping, Machine Learning, Python programming, SQL, Unix Command.

• Understanding of data warehousing, data modeling and ETL concepts.

• Performed the administration, configuration, maintenance & upgrade of Tableau Servers.

• Creating groups, projects, workbooks and the appropriate permissions for Tableau server and security checks.

• Used Unix Shell Scripts to schedule workflows.

• Used MS Access, MS Excel, V-Look Ups, Pivot tables and charts, MS PowerPoint, MS Outlook, MS Communicator and User Base to perform responsibilities.

• Wrote UNIX Shell Scripts for Informatica Pre-Session, Post-Session and Autosys scripts for scheduling the jobs (work flows)

• Created ETL workflows and mappings to provide data migration and integration from production (Oracle) database into warehouse DB (Teradata) using Informatica PowerCenter tool.

• Developed and implemented process and decision criteria recommendations based on Teradata flow from reporting tools such as Tableau.

• Performed Data Analysis on the Analytic data present in Teradata and AWS using SQL, Teradata SQL Assistant Tools: Finacle,Intellect, SQL Server, UML, MS Excel, V-Look Ups, Test Manager, R and Python, Teradata, Windows, Agile, MS Visio, Teradata, UNIX, MS Access, MS Project, UAT, JAD, UML Diagrams, Tableau, HP ALM.

Business Data Analyst, Pigments & Allieds, Mumbai, Maharashtra, India ., July 2011 – June 2012

• Documented project artifacts, Business Requirement Document (BRD), Functional Requirement Document (FRD), Test cases and Conducted Joint Application

• Development (JAD) sessions based on business user concepts and specifications.

• Created conceptual, logical & physical data models with Erwin and Created and modified datasets using SAS SQL procedure.

• Lead QA activities including Unit Test cases, Flow Diagrams etc.

• Documented the UAT Plan for the project and worked with the UAT Team to ensure every acceptance criteria for the requirements has been included in the UAT task plan.

• Expands program within the community in accordance with strategic and operating plans.

• Generated test reports using Quality Center

• Achieved excellence targets for program satisfaction and quality as evidenced by results on regular evaluations by participants and parents. Tools: Finacle,Intellect, SQL Server, UML, MS Excel, V-Look Ups, Test Manager, R and Python, Teradata, Windows, Agile SCRUM Framework, MS Visio, Teradata, UNIX, MS Access, MS Project, UAT, JAD, UML Diagrams, Tableau, HP ALM. Academic Projects

,

Trends from Twitter

• Performed sentiment analysis on large data sets extracted from Twitter hashtags, with the help of MapReduce, Hive, to predict the trends with national polling aggregates and published dashboard for visualization using tableau. Grocery Shop

• Developed Text analysis project using market basket analysis “Grocery Shop” With the help of R Programming and R Studio. Zola hop

• Developed a web and mobile based Shoe Shopping Application prototype in JSP and HTML using Axure. Data Security: TheChallenge in Cloud Computing framework

• Developed a mechanism for data access control to store in Semi trusted servers like cloud with the help of VMware

•

Educational Qualification

Virginia International University, Fairfax, VA. M.S., Information Systems- May 2018 GPA – 3.75/4.0

University of Mumbai, Maharashtra, India. B.E.,

Information Technology - May 2015 GPA – 3.5

Extra-Curricular Activities

• Secured a position on the Dean’s list for Fall 2017 at Virginia International University.

• Technical Lead / Brand Activation for Indian Society for Technology (ISTE) - RAIT Chapter, Mumbai.

Contact this candidate