For the given job description <<Experienced Business Analyst in Telecom PromosAnalyze promo & defect data and create analyses & summarize as specified.Root cause analysesPreparation of training materials.Support process definitionDocumentation>> the resume: <<Professional SummaryDependable, results-driven Data Analyst with extensive experience in collecting, organizing, interpreting, and disseminating various types of statistical figures and strong focus on detail, accuracy, collaboration and delivering unparalleled client service. Expertise in data analysis, reporting structures and product and customer analytics. Key strengths include excellent organizational skills, effective time management, and willingness to assist peers and colleagues during peak workload periods. Proven ability to exercise good judgment and work well with minimal supervision and being able to make quick decisions in high pressure situations. Strong technical, project management and negotiation skills. Knowledgeable about business process improvement methodology and productivity optimization strategies. Recognized for integrity, trustworthiness, work ethic & objectivity. My goal is to develop new skills and utilize my current skills to gain graduate assistantship to develop advocacy and leadership skills.
SkillsSQLTableauPythonMS Office Suite -Access/Project/Excel/PowerPoint/Word/OutlookData Science Research MethodologiesPattern and Trend Identification
Work History08/2020to01/2022Data AnalystConsumertrack–Los Angeles,CA,Analyzed Clients Financial Data and performed reconciliations to verify completeness of data setsProviding support for data acquisition and extraction from clients’ accounting systemsCarrying out the manipulation and upload of more complex data sets from a variety of finance systems across various business areas and clients into deloitte’s platformCarrying out Data manipulation using tools such as Excel and Microsoft SQLPerforming reconciliations to verify the completeness of datasets provided to clientsCarrying out data quality checks which will need to be raised to the Audit practice or client as appropriateAssisting and guiding audit teams with data extraction from client systemsBeen the engagement team's first point of call when using Analytics platform for troubleshooting or general functionality queries; providing them with assistance and guidance in the use of our platformHaving a high-level understanding of the system being supported and using Microsoft SQL to troubleshoot any issues raised by the Audit practice via the help desk systemPossible development and maintaining of various bespoke pieces of work built outside of our analytics platform on a client by client basisCreated reports for audit parameters using PowerBIHands on experience in Performance Tuning, Query OptimizationStrong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.08/2017to01/2020Data AnalystConsumertrack–Chicago,IL,Analyzed client’s sales, marketing, and finance departments to automate processes, implement internal and external reporting structures, and develop cost effective solutionsConducted needs assessment to define user requirementsIdentified overlaps and established metrics and database structure to support all organizational reporting requirementsPrepared regular status reports to enable continuous improvement and improve the overall performanceCollated data and performed volume calculations to present complex solutions in simple terms to clients and enable decision makingDesigned, implemented, and analyzed results of marketing initiatives, including email and onsite promo campaigns, recommending most effective selling strategies and contributing to additional revenues of more than 2.9 MillionDeveloped a route optimisation tool for a leading retailer in India who serves millions of customers in more than 400 cities in every state of the country through digital platforms and over 1500 stores that cover over 16 million square feet of retail space:Improved collections process for a leading retail bank that reached more than Rs 245 million monthly outstanding on a portion of its unsecured credit portfolio during the economic downturn, this was classified as early stage delinquentsBuilt analytical models to obtain the probability of collection from customers based on various actionsThe client was able to realign call center agents to more impactful areas (such as late stage delinquency) and reduce staffing levels in early stage delinquency by 35%Resulted in annual cost savings of >Rs 85MM without impacting the collection ratio of 98% for the early stage delinquents07/2016to03/2017HR InternAmerican Modern Insurance Group–Evansville,IN,Worked with HR team to coordinate company events.Assisted human resources and recruiting teams by scheduling phone screens and on-site interviews and planning recruitment related events.Filed paperwork, sorted and delivered mail, and maintained office organization.Developed strong written and verbal communication skills.Supported efforts to optimize employee engagement, diversity and inclusion to enhance performance management and retention.03/2012to06/2015Programmer AnalystPackaging Corporation Of America–Harrisonburg,VA,Developed programs and created files using SQL, PL/SQLCreated group data warehouse for distributionDesigned various management, forecasting, and end user reportsAnalyzed business requirements and leveraged my technical skills to automate scripts to provide end-user support and regular maintenance to the databasesPreviously index fragmentation on each index per table in the properties were checked manually, and if it met a certain threshold, we executed rebuilding of the indexSaved 45% of the time (reducing the time spent on repetititve activities),Reducing 30% of the cost spent on repetitive activitiesUsed the time saved to solve quality issues which resulted in 45% increase in efficiencyDetermined the right stored procedures, views, and functions for the applicationCreated/documented specs and test cases for each PL/SQL procedure.
EducationExpected in01/2024totoMaster of Science:Data ScienceUniversity of Memphis-Memphis,TNGPA:Expected in07/2017totoMBA:Human Resources and Marketing ManagementBharathiar University-,GPA:Expected in04/2011totoBachelors of Engineering:Computer Science and EngineeringAnna University-Chennai,India,GPA:>>. The result is, Potential Fit

Fit assessment: Potential Fit