For the given job description <<Primary PurposeThe JPI Group is seeking a Business Analyst (BA) to join our rapidly growing team. The successful candidate will provide analytical support for our utility-led energy efficiency incentive programs by collecting, analyzing, and reporting program data. This role will also serve as the programs point of contact with IT Teams to manage, improve and test program databases.
Tasks May IncludeCompile and analyze program and project level data such as energy savings, incentives, and application statusDevelop and run reports, processes, graphs, and dashboards to track key program performance metrics, including forecasting energy savings, tracking budgets and client invoicesDevelop, streamline, document, and automate program processesUtilize group-wide and ad hoc databases for analysis and reportingPerform a critical analysis of program data to identify operational and data anomalies and exceptionsQuickly translate data and accompanying analysis into internal, client, and management presentationsManage and perform quality control on reports and analysesManage backend processes to provide cadence reporting to the client and in-house finance and accounting teamsNotify manager of projected anomaliesPrepare backend data to make ready for other parties to processFollow and enforce QAQC processesAssist with trade ally managementDocument role to ensure continuity of workManage small initiatives to completionContinuous improvement of backend tools and client deliverablesOther tasks as neededWhat were askingBachelors degree in the analytic discipline.Three to Five years of experience compiling and analyzing data and producing data-intensive reportsHigh attention to detail and reporting precisionUnderstanding of and management within large utility-client bureaucraciesA proven and demonstrable grasp of data analysis tools such as Power BI, Oracle, SQL Server, Excel or equivalentHigh Degree of Proficiency with Excel inclusive of Pivot Tables, Data Management Tools, and advanced formulas and functionsDemonstrated analytical abilities to develop and implement resolutions for business challenges and issues.Willingness and ability to travel, via airplane, as required up to approximately 10% of the year.Preferred SkillsFive to Eight Years of energy efficiency experiencePrior experience in market research inclusive of market analysis, market assessment, and market segmentationFamiliarity with energy savings analysis and modeling toolsProficiency in and understanding of accounting concepts (invoicing, accruals, forecasting, etc.)Familiarity with data reconciliation applications (e.g. month-end accounting reconciliations, accruals, inventory reconciliations, etc.)Excellent oral and written communications skillsPrior participation in complex database management system projects. Experience with JIRA is desiredPrior project experience in data mining andor analytics initiativesPro-active approach to the analytical tool and analytical model developmentPositive, collaborative, and team-oriented attitudePassion for energy and sustainability>> 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