Shweta Verma

New Delhi, adjfma@r.postjobfree.com 91-987*******

PROFILE

● 4+ years of rich-techno functional working experience in “Tableau server & Desktop”, “Data Analytics”, and “Data Warehousing” projects using multiple database platforms, analysis tools and BI Delivery solutions for Tata consultancy Services (Dec 2016-Present day).

● Functional Skills: Business Analysis, Data Visualization, Predictive Analytics.

● Technology & Tools: Tableau Desktop, Tableau Server, OBIA, Microsoft Excel, Google Analytics, alteryx, QlikSense, Oracle SQL, SAML 2.0, Microsoft Azure Active Directory, ServiceNow, NGautofix.

● BI-DW-Enterprise Data Lake Methodologies: Dimension modeling(snowflakes, star schemas), Data warehouse concepts, OLTP, OLAP, Data mart, Normalization, Performance tuning

● Certifications: Tableau Server Certified Associate, Amazon Web Services Certified Cloud Practitioner, Microsoft Azure(AZ-900) fundamental certified, Scrum Fundamentals Certified, Six Sigma Yellow belt. EDUCATION

Babu Banarasi Das National Institute of Technology &Management Lucknow, UP Bachelor of Technology, Electronics & Communication Engineering Aug. 2012 – Jul2016 EXPERIENCE

PROJECT#1 CMI UK & EU BT Sept2019- Present Day, Gurgaon Client British Telecom, Gurugram

Role Tableau Developer& Tableau Server Admin+ Oracle Business Intelligence Admin Tool &Technologies Tableau desktop2020.2, Tableau Server2020.2, OBIEE 12.2.1.2, Postgresql, Oracle SQL, Unix script

Project Summary:

British telecom one of the world’s leading communications services provider ranging from BT broadband, mobile services, Television subscription across UnitedKingdom. Being part of BT wholesale line of business developed relevant dashboards and administrated Tableau which was appreciated by clients. Responsibilities:

● Designed data driven models and configured customized Tableau Dashboards with drill down capabilities, filters and parameters which provides actionable insights into data visualization backlog by analyzing multiple data sources and deriving relevant KPI’s, metrics and charts

● Designed and maintained advanced charts like Radial bar, Sankey chart, Time Series graph, Dendrogram Chart to provide up to date and accurate information.

● Prepared and published impactful and interactive reports and dashboard by implementing numerous capabilities such as data blending, table calculations, custom SQL, advanced calculated fields and custom geo encoding

● Monitor Tableau server activity and usage statistics to identify possible performance issues/enhancements. Perform maintenance activities like logs cleanup, archiving logs. Prepared dashboards on Tableau server through readonly database using postgres database’s data.

● Good Knowledge of tableau repository, tabadmin and tsm commands.

● Created, maintain subscription and alert, users, groups. Good knowledge of permission on Tableau Server

● Created and scheduled unix scripts to automate the processes for Obiee and Tableau.

● Worked on catalog development and rpd deployment; Administration of environment with respect to changes and development changes and implementation feasibilities. Shweta Verma

New Delhi, adjfma@r.postjobfree.com 91-987******* PROJECT#2 CARDONE ENGAGEMENT Feb2018 – July 2019, Gurgaon Client SBI Cards & Payments Services Ltd, Gurugram Role Tableau Developer, Oracle Business Intelligence(OBIEE)Admin Tool & Technologies Tableau Desktop 2020.0, OBIEE 11.1.1.7, DAC 11.1.1.6,Informatica 9.5.1(OBIA); Siebel (ERP), Postgresql, Oracle SQL/PL-SQL

Project Summary :

SBICARDS is the second largest credit card issuers/provider in the country. It has diverse businesses dealing in different Line of Businesses. Migration of SBI Gurgaon’s data center to Bangalore, migrating the technologies used to the latest version. Also, different reports are developed and automated from time to time. Responsibilities:

• Prepared dashboards using calculations, parameters in tableau and created calculated fields, groups, sets, hierarchy.

• Provided 24/7 production support for Tableau users.

• Responsible for Debugging, Optimizing, and Performance Tuning of OBIEE Reports/Dashboards.

• Migrating Obiee’s catalog to a different environment (Development, production).

• Responsible for fixing any defects in the OBIEE (either on configuration or reporting side). Also educating the clients on the usability of OBIEE.

PROJECT #3 ACE ZEBRA DTR AUTOMATION Apr 2017-Jan 2018, Gurgaon Client Airtel, Gurugram

Role OBI Developer (OBIEE + ODI).

Tool & Technologies OBIEE 11.1.1.7, ODI 11g, Oracle E-BusinessSuite (ERP), Oracle 11gR2(RDBMS) Project Summary :

Automation of provision calculation as well as the Reconciliation process. Airtel has diverse businesses dealing in different Line of Businesses having different rules for provisions; thus, various reports were developed considering the legal pursuant.

Responsibilities:

• Worked in Development of metadata repository (RPD), configured metadata the business model layer &physical data model and web catalog objects as per the reporting requirement using OBIEE Admin and Web tool.

● Responsible for creating queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.

● Responsible for Developing and deploying interactive dashboards, analytics, and reports properly according to business requirements.

● Identifying production faults and critical issues followed and troubleshoot them. AWARDS AND HONOURS

● Awarded “Star of the month” (Oct 2020) by mentors and Team lead for outstanding performance.

● Awarded “On the Spot Award” and “Best Team Award” for automating, quick problem solving abilities.

● Participated and stood first runner-up in a dance competition conducted by The Times of India(third largest newspaper in India).

PUBLICATIONS

Verma, S. "Fully Informed Particle Swarm Optimization for Solving Economic Load Dispatch" ICRIEECE 2018 Decreased annual generation cost by 3% through power demand allocation optimization using valve point effect.

Contact this candidate