Power Bi Business Analytics

Jyotsna D Talacheeru

Phone: 571-***-**** Email: *.********@*****.***

PROFESSIONAL SUMMARY

Senior advanced analyst with 14.5 years of comprehensive experience in database design, development, support, data mining, cleaning, visualization, and business analytics

Skilled in translating complex business requirements and technical specifications into actionable insights to drive strategic business decisions

Proficient in ETL techniques like SSIS, SAS, Informatica and Palantir

Expert in creating RDBMS, DataMart in various environments MSQL, Oracle, Teradata, Vertica and Palantir

Strong command of database schema design, normalization, constraints, triggers, keys, views, and indexes.

Expert in creating interactive and visually compelling reports and dashboards using tools like SSRS, SAS, MicroStrategy, Power BI and Tableau and Implemented security measures to restrict user access and ensure they could only use specific reports as permitted.

Proficient in database administration tasks including role management, user permissions and performance tuning in MicroStrategy and Tableau

Expert in Vertica table design and optimization techniques such as Projections and Partitioning.

Proficient in completing projects on extremely committed schedules and budgets

An effective communicator with strong analytical mindset, problem solving and interpersonal abilities and ability to grasp technical concepts quickly and easily

TECHNICAL SKILLS

Databases

MS SQL, Oracle, MS Access, DB2, Teradata, SAS, VERTICA, Palantir.

Big Data

HDFS, Map Reduce, Pig, Hive, Flume, HBase, Sqoop

Programming Languages

T-SQL, PL/SQL, HTML, XML, MDX, C, C#, R, Python

ETL Tools

SSIS, Informatica, SAS, SSRS, SSAS

Reporting Tools

MicroStrategy, Power BI, Excel, Tableau

Database Tools

SSMS, Toad, Razor SQL, Rapid SQL, SQL Assistant

Certificates and Training:

Learned Tableau and trained coworkers on the same as part of Circle of Knowledge

Udacity courses in big data that include Hadoop, Hive, PIG, Mongo DB, R

MicroStrategy Architect, 10.011: MicroStrategy 10 Certified Analyst (MCA)

Experience:

Roles and Responsibilities:

Senior advanced analytics AT&T Mobility Services, LLC. Atlanta Jan 2022–Current

Analyze TDATA (Top offers) decisioning metrics such as tool utilization, customer acceptance and take rates using extensive customer data from Centers, IHX, AT&T Retail and Authorized Retail channels by creating dashboards in Tableau

Analyze seasonality and other factors impacting offer take rates to inform strategic decisions

Develop and present insights about Test vs Control analysis of various offers in ATT wireless services

SME for Smart Attributes to identify potential customers to target for specific wireless offers.

Successfully saved $5M and extensive development time over a two-year period by proactively developing an innovative in-house project.

Doubled retention offer take rates through continuous analysis of offers and collaborative insights sharing with channel partners, resulting in significant customer savings and reduced churn.

Trained team members on using Tableau and Palantir, enhancing their analytical capabilities and tool proficiency

Senior Statistics Engineer AT&T Mobility Services, LLC. Atlanta Apr 2018–Dec 2021

Access, reconcile and consolidate subscriber data from large disparate data sets to analyze operational metrics that will drive cross functional insights and measure cross-selling progress.

Gather, analyze, and interpret a wide variety of data to make predictions understand the impact of seasonal changes on sales future outcomes or identify differences in relationships

Develop reports, charts, tables, and other visual aids in support of findings to track trends in customer cross-selling across channels.

Inform design of trials and business initiatives to ensure cross selling results can be tracked and meaningful insights can be gathered (e.g. test vs control methodology for in-market tests etc.);

Fulfil the offers promised to customers during the sale by tag them with right offers. Proactively tighten the process and saved over $600K in single processing due to duplicate provisioning

Handled numerous customer escalations and automated process to prevent such errors in the future

Senior Specialist Data Analyst AT&T Services, Inc. Atlanta SEP 2013–Apr2018

Primarily involved in DirecTV, U-verse, Service management, DSL and Narrowband projects to design and develop data models (physical/logical) based on the given specs and requirements.

Created and maintain the DIRECTV, U-verse and Entertainment CARE organization Roster

Created OLAP Cubes and supporting them for U-verse repeats/ Calls / Dispatches using SSAS

Used SAS tool to bring DirecTV data to derive agent level metrics that rolls up to center/ vendor level.

Narrowband CARE Scorecard saved approximately $989k on Tech dispatches for 2016 over 2015 by identifying unnecessary Dispatch Tickets from necessary Dispatch Tickets.

Developed Scorecards for Narrowband, U-verse and Service management Call level data to track KPI’s

Developed Audit reports by tracking cases created on canceled Customers to detect fraud.

SME for Avaya call data and CRM for U-verse, Service management, DirecTV and DSL

Designed and Developed metrics and Analysis Dashboards with Trends by using MicroStrategy for U-STAR

SW Development/Support Crystal Equations, IL (Client -AT&T) APR 2011–SEP 2013

Involved in Rockwell to AVAYA Migration to support ATT Call center data

Created Region, Center, Manager, Supervisor, and Employee Cascading Reports

Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files to SQL Server using SSIS/DTS using various features like data conversion etc.

Bulk data migration using SSIS from flat files and Scheduling Jobs, Alerting and Maintaining SSIS packages.

Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

EDUCATION

M.S in Computers and information sciences in University of South Alabama, Mobile, AL (Jan’2009-dec’2010)

Bachelors in Bio Medical and Instrumentation engineering in JNTU, INDIA(June’2004-May’2008)

Contact this candidate