Sneha Bankar

Marketing Sales ,GTM and CRM Data Domain Define and gather requirements to build goal frameworks to track business metrics and measure the effectiveness of key business strategies and processes.

Participated in the Build Customer CDI integrated Platform for enabling the CSB platform for DELL Sales and Marketing from Vendor

Enabling the Analytical Platform for various Stakeholders to visualize key metrics and achieve the Attainments in terms of Strategic Targets

• Data Segmentation & interpretation and use for automated campaigns and strategic planning / insights that add value in all marketing initiatives and teams Identify digital behaviors of customers by analyzing the right data points to map their journey.
• Collaborate with stakeholders and business users to identify Data collection and CDI (Customer Data Integration) enhancements, and actively participate in the management of any related projects
• Build SQL scripts, data sets, analytical models, and dashboards to support business requirements.
• Build OLAP data warehouse/data marts, automate reporting, and generate insight to enable leaders to quickly and accurately see how key businesses and processes are performing.
• Develop projects from inception to delivery, ensuring that your data solutions deliver relevant, high-quality data and insights to intelligently grow Dell Marketing Business.
• Leveraged text, charts and graphs to communicate findings in understandable format.
• Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
• Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
• Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
• Created and automated data visualizations to present insights and tell compelling stories.
• Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
• Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.

Domain: Retail Data

• Defined parameters for technical development tasks such as Dashboard Development and data acquisitions.
• Organized system infrastructure documentation and operating procedures, strengthening controls and enhancing overall performance.
• Mentored junior team members, providing educational expertise on technical concepts in ETL and Dashboard development tools like Tableau and Power BI .
• Investigated and addressed system issues to enhance usability and improve functionality.

BG International Oil Company

• Mapped processes to holistically examine business flow and identify improvement opportunities.
• Developing Universe and universe structure based on client requirement The platform used is SAP BI 4.0 SP04
• WEBI Report Development consisting on semantic layer universe and Database views In the first phase built 7 WEBI reports on TVP Asset
• Enhancements of existing WEBI Reports on Oracle Database for different BG Assets and environments
• Mentoring new trainees on Business Objects 4.0 and report development
• Documented procedures and business processes and shared information with appropriate stakeholders.

• SAP BO/BI Installation and Administration
• Installation of SAP Business Objects XI R2 , XI 3.1 and SAP Business Objects Business Intelligence 4.0
• Migration and upgrading of all the environments to latest patches on databases like MYSQL, Microsoft SQL Server, and Oracle.
  Administration of BO XI 3.1 and 4.0 in servers and setting up security rights
• Scheduling Crystal , WEBI and DESKI reports to third party destination (EMAIL, FTP, File system) in different formats (PDF,EXCEL,WORD,RICH TEXT)
  Setting up connectivity of Crystal Report with databases like MYSQL, Microsoft SQL Server, and Oracle, DB2
  
  Crystal Reports Designing :
  Develop using on RDBMS using ODBC/JDBC , native connections
  Developing Crystal Reports based BW data sources like Infosets ,Open Data Sources, BW MDX,
  BW MDX Query, Table Cluster and Functions
  Analytical Reporting :
• Conducted research to test and analyze feasibility, design, operation and performance of equipment, components and systems.
• Participated in formal internal design reviews of proposed products and components, providing input on potential technical improvements.
• Oversaw layout, routing and integration of technical and electrical components.
• Drafted and captured technical schematics for use in project planning and execution.