Prerna Malhotra
Business Intelligence Analyst
San Antonio,TX
Summary
Prudent Business Intelligence Analyst with 10+ years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Overview
11
11
years of professional experience
5
5
years of post-secondary education
Work History
Business Intelligence Analyst
HCL Tech
San Antonio, United States
01.2014 - Current
- IT experience in Business Intelligence using SAP BO-BI 4.2/4.1/4.0 (BI Launch Pad, Web Intelligence, Explorer, Dashboards/Xcelsius, Lumira, Design Studio, QaaWS, BIWS, Live Office, Central Management Console) and Tableau Reporting Tool
- Strong hands-on experience implementing dashboard, data visualization, and analytics using Tableau Desktop and Server
- Experience in Data Warehousing and Business Intelligence area in Banking and Finance domains
- Complete knowledge of execution in all phases of Software Development Life Cycle - Requirements gathering, Architecture, Design, Coding and Unit Testing, Integration testing, system testing, UAT, deployment and production support
- Participated in all aspects of the project lifecycle, following stringent rules and procedures for testing and promoting code in compliance with Change Control Board processes
- Experience in Agile Methodology Projects. Iterative, Story and Task execution. Planning & Forecasting, playing scrum roles, iteration planning, story & task writings to meet the business goals
- Involved in dimensional data modeling, design of Star Schema and Snowflake Schema.
- Extensive experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
- Extensive Experience in design & developing of IDT/UDT Universes
- Experience in creating Complex WebI Reports and performance tuning
- Designed, developed, and maintained reports and Multilevel dashboards in Tableau
- Experienced as a Data Analyst and in transforming client requirements documents into business requirements documents
- Proficient in data visualization, Reporting, and Analysis using Bar Charts, Line Charts, Tree Maps, Pie Charts, Heat Maps, Scatter Plots, Dual-axis, Geographical Maps in Tableau Desktop
- Good knowledge on best practices in designing and supporting BI applications
- Extensive experience in writing complex sql queries for Oracle, Netezza, SQL Server and DB2 databases
- Experience in creating Control M schedule for BO reports
- Good knowledge of data warehousing concept and ETL tool Datastage
- Strong problem-solving skills and have excellent coding/debugging skills
- Strong interpersonal skills with the ability to interact with end-users, managers, and technical personnel. Proficient in learning new technologies and quickly adapting to new environment
Media Auditor
Yahoo Software Development India Pvt. Ltd.
Bengaluru, Karnataka, India
07.2009 - 03.2010
- Worked in a fast-paced team environment, quickly and accurately processing tasks received from US-based
- Review and classify online display advertisements to aid in better placement and visibility for the advertisers and to assist in more revenue generation for the publishers
- Obtained training successfully on the parallel process-Demand Quality Management
- Analyzed, defined, and recommended guidelines for both processes
- Prepared extensive training documents for the same in Spanish, adhering to company policies and guidelines
- Successfully handled training and induction of new hires following guidelines and process up gradation
- Ability to solve problems and identify opportunities through the use of analytic and critical thinking
Business Analyst
Symphony Marketing Solutions
Bengaluru, Karnataka, India
04.2008 - 06.2009
- Involved in all phases of Software Development Life Cycle. Gathering, analyzing, documenting business requirements, functional requirements and data specifications for Dashboard and Report development
- Processed data retrieved from various retailers across Spain, based on cultural knowledge, to shape it for market research usage by different parties including manufacturers, retailers and internal market research teams
- Created Consumer Product Goods market analysis reports for clients using MS Office tools Access, Excel and PowerPoint
- Supported top clientele by providing varied research inputs in the sphere of their marketing efforts
- Supported the sales, marketing, and brand teams by addressing any challenges/opportunities for the various product-markets
- Recommended business solutions for marketing strategies based on the reports and research
- Managed relationship with the clients, ensuring continued business
- Liaised with the home team in Spain to coordinate and integrate the process with the Global Operations Content team
- Provided instant service to clients, which entailed provision of quick response to customer concerns
- Improved process to efficiently deliver market reports and business solutions
- Trained and guided the new employees on the business process and other development programs
Education
Master of Science - Finance
Rochester Institute of Technology
Rochester, NY 08.2011 - 07.2012
MBA -
Ohio University Christ College
Bengaluru, India 07.2006 - 12.2007
Bachelor of Arts -
Delhi University
New Delhi, India 07.2002 - 06.2005
Timeline
Business Intelligence Analyst
HCL Tech
01.2014 - Current
Master of Science - Finance
Rochester Institute of Technology
08.2011 - 07.2012
Media Auditor
Yahoo Software Development India Pvt. Ltd.
07.2009 - 03.2010
Business Analyst
Symphony Marketing Solutions
04.2008 - 06.2009
MBA -
Ohio University Christ College
07.2006 - 12.2007
Bachelor of Arts -
Delhi University
07.2002 - 06.2005
Similar Profiles
Abhishek KumarAbhishek Kumar
Data Engineer/Technical Lead at HCL Technologies Limited (HCL Tech)Data Engineer/Technical Lead at HCL Technologies Limited (HCL Tech)
Suraj Prasad KhilarSuraj Prasad Khilar
Lead Engineer at HCL Tech ( Citrix Outsourced To HCL )Lead Engineer at HCL Tech ( Citrix Outsourced To HCL )
Kalairani KKalairani K
Supply Chain Analyst / Buyer / Configuration Analyst (Team Lead) at HCL TechSupply Chain Analyst / Buyer / Configuration Analyst (Team Lead) at HCL Tech
Unnikuttan UUnnikuttan U
Technical Specialist at HCL TechTechnical Specialist at HCL Tech
Collin DoanCollin Doan
Sales Associate at Sams Club DistributionSales Associate at Sams Club Distribution