| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name
Kent, Ohio PHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLE Summary Data professional with over 6 years of experience in Finance industry, possessing a strong foundation in statistics and machine learning concepts. Skilled in using R, Python, SQL, and other tools to create and implement effective data- driven solutions. Proficient in developing interactive dashboards and reports to help businesses make informed decisions based on real-time data analysis.EducationMasters in Business Analytics Aug 2022 - Dec 2023Kent State University, Kent, OHBachelor of Technology 2013-2017RVR & JC College of Engineering, IndiaExperienceABN Tech, Texas Jan 2024 - PresentBusiness Intelligence Analyst:Created reports and dashboards using Power BI tool for monitoring operational applications, increasing visibility by 75% and reducing downtime by 30%.Curated ETL transformations in Power Query and implemented Row Level Security, Data Analysis Expressions (DAX), measured and calculated column creation during report development in Power BI.Collaborated with cross-functional teams to identify and prioritize reporting needs, resulting in a 25% increase in user adoption of the BI system.Developed Python and R scripts to automate both structured and unstructured data manipulation processes, resulting in a reduction of 50% in time spent on manual data processing tasks.Designed and developed complex ETL packages using SSIS according to the needs and requirements of the client.Developed and implemented procedures (i.e., PL/SQL), functions, views, and triggers in Data warehouse to enhance data management and report performance.Served as a collaborative team member within both project management and software development life cycles (SDLC) including analysis of business functions, design, development, testing and documentation as required by end-users for ELT and reporting.Capgemini, IndiaData Analyst: Jan 2017 - July 2022Developed SAP Business Object Dashboards to track key Performance Indicators (KPIs) and provide current performance metrics for departments of e-commerce company, resulting in an overall increase in productivity of 20%.Developed and executed complete ETL process using Informatica tool to extract and transform data from different flat files and Relational Database, resulting in a 60% reduction in processing time.Optimized Data warehouse performance by designing and deploying a new schema that improved query response time by 40%.Performed data extraction, transformation, and load into the database tables from various data sources such as Oracle database, flat and excel files using SQL Server Import Export Wiz.Initiated Performance tuning measures to increase the application throughput by effective code optimization techniques. Academic Projects Data Consultant Apr 2023Evaluated machine learning algorithms and selected the model that has the highest efficiency to retain customers.Decreased churn rate by 15% by developing a Decision Tree model in R that improved the business profits.Credit Risk Model Financial Organization Python (Pandas, NumPy, Matplotlib) Analytical SkillsUtilized statistical techniques to build and validate PD and LGD models, resulting in accurate risk assessments.Dashboard Creation Portage Animal Protection League (APL) Power BI Financial Analysis Cost-Benefit AnalysisDeveloped a dashboard to track KPIs for APL, resulting in increased efficiency and improved decision-making.Created interactive visuals to analyze and present adoption rates, intake trends, and animal health metrics data.SkillsLanguages: SQL, Python, R, HTML, Shell Certification: Microsoft Certified Power BI Data Analyst Framework: PysparkTools: TIBCO Spotfire, Power BI, Tableau, Excel, Informatica, SAP Business Objects, SQL Server Integration Service (SSIS), Azure Databricks, SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS)Techniques: ETL, Data Modeling, Visualization, Regression, Optimization, Forecasting, Clustering, Hypothesis Testing Predictive Modeling, Statistical Analysis, Web scrapingDatabase Management: SQL Server, Oracle, MySQL, Hadoop, SAP BW, AWS Redshift |