| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEPROFESSIONAL SUMMARYSenior advanced analyst with 14.5 years of comprehensive experience in database design, development, support, data mining, cleaning, visualization, and business analyticsSkilled in translating complex business requirements and technical specifications into actionable insights to drive strategic business decisionsProficient in ETL techniques like SSIS, SAS, Informatica and PalantirExpert in creating RDBMS, DataMart in various environments MSQL, Oracle, Teradata, Vertica and PalantirStrong 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 TableauExpert in Vertica table design and optimization techniques such as Projections and Partitioning.Proficient in completing projects on extremely committed schedules and budgetsAn effective communicator with strong analytical mindset, problem solving and interpersonal abilities and ability to grasp technical concepts quickly and easilyTECHNICAL SKILLSDatabasesMS SQL, Oracle, MS Access, DB2, Teradata, SAS, VERTICA, Palantir.Big DataHDFS, Map Reduce, Pig, Hive, Flume, HBase, SqoopProgramming LanguagesT-SQL, PL/SQL, HTML, XML, MDX, C, C#, R, PythonETL ToolsSSIS, Informatica, SAS, SSRS, SSASReporting ToolsMicroStrategy, Power BI, Excel, TableauDatabase ToolsSSMS, Toad, Razor SQL, Rapid SQL, SQL AssistantCertificates and Training:Learned Tableau and trained coworkers on the same as part of Circle of KnowledgeUdacity courses in big data that include Hadoop, Hive, PIG, Mongo DB, RMicroStrategy Architect, 10.011: MicroStrategy 10 Certified Analyst (MCA)Experience:Roles and Responsibilities:Senior advanced analytics AT&T Mobility Services, LLC. Atlanta Jan 2022CurrentAnalyze 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 TableauAnalyze seasonality and other factors impacting offer take rates to inform strategic decisionsDevelop and present insights about Test vs Control analysis of various offers in ATT wireless servicesSME 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 proficiencySenior Statistics Engineer AT&T Mobility Services, LLC. Atlanta Apr 2018Dec 2021Access, 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 relationshipsDevelop 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 provisioningHandled numerous customer escalations and automated process to prevent such errors in the futureSenior Specialist Data Analyst AT&T Services, Inc. Atlanta SEP 2013Apr2018Primarily 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 RosterCreated OLAP Cubes and supporting them for U-verse repeats/ Calls / Dispatches using SSASUsed 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 KPIsDeveloped 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 DSLDesigned and Developed metrics and Analysis Dashboards with Trends by using MicroStrategy for U-STARSW Development/Support Crystal Equations, IL (Client -AT&T) APR 2011SEP 2013Involved in Rockwell to AVAYA Migration to support ATT Call center dataCreated Region, Center, Manager, Supervisor, and Employee Cascading ReportsTransferred 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.EDUCATIONM.S in Computers and information sciences in University of South Alabama, Mobile, AL (Jan2009-dec2010)Bachelors in Bio Medical and Instrumentation engineering in JNTU, INDIA(June2004-May2008) |
