Data Analyst Business

Anuroop Reddy Mannem Business Data Analyst

Location: Denton, TX Phone: 469-***-**** Email: *******.*****.******@*****.*** LinkedIn SUMMARY

• Experienced Business Data Analyst with 5+ years of expertise in data analytics, business intelligence, and data governance across finance, HR, and e-commerce sectors, delivering actionable insights and driving business growth.

• Proficient in Data Visualization and Reporting using Tableau, Power BI, and Excel to create dynamic dashboards and visualizations, enabling stakeholders to make informed, data-driven decisions that enhance performance and efficiency.

• Skilled in Data Extraction and Transformation (ETL) leveraging SQL, Python, and PL/SQL to automate workflows, streamline data pipelines, and reduce manual data processing by over 30%, improving operational efficiency and data accuracy.

• Strong Cloud Computing Experience utilizing AWS and Azure for data storage, processing, and governance; experienced in optimizing cloud costs, ensuring data accessibility, and maintaining compliance with industry regulations.

• Advanced Analytical and Problem-Solving Skills in data cleaning, mining, modeling, and predictive analytics using frameworks like Scikit-learn and TensorFlow to perform impact analysis, A/B testing, and churn prediction, leading to process optimizations and cost savings.

• Expert in Data Governance and Quality Assurance by implementing data validation rules and privacy protocols using SAP and SAS, ensuring compliance, improving data integrity, and enhancing reporting accuracy by over 20%.

• Technically Versatile with a Diverse toolset including Git, JIRA, Docker, Kubernetes, SQL Server, Oracle, and Microsoft Office Suite, enhancing project management, data visualization, and software development for effective business solutions.

• Strong Understanding of SDLC and Agile Methodologies, participating in all phases from requirement gathering to deployment. Effective communication, leadership, and problem-solving skills enable seamless collaboration between technical and non-technical teams, ensuring timely project delivery and creative data solutions for stakeholder satisfaction. TECHNICAL SKILLS

WORK EXPERIENCE

PNC Financial Services, TX Jul 2024 – Current

Business Data Analyst

• Led a customer financial behavior analytics project using SQL and AWS Redshift, integrating data from multiple banking systems to provide executives with enhanced client insights, reducing reporting time by 40%.

• Developed and maintained ETL workflows using Python and SQL, automating loan application data processing and reducing manual data entry efforts by 35%.

• Designed and deployed interactive Power BI dashboards for tracking key loan performance metrics, enabling real-time data- driven decision-making and improving portfolio management efficiency by 25%.

• Spearheaded data governance initiatives, implementing AWS Glue for data lineage tracking, enhancing regulatory compliance and improving data auditability by 20%.

• Conducted cost analysis to optimize cloud-based data storage solutions on AWS S3, achieving a 12% reduction in storage costs while enhancing data retrieval speeds.

• Utilized machine learning algorithms to forecast customer creditworthiness and loan default risks, improving lending strategies and reducing loan default rates by 10%.

• Worked closely with cross-functional teams to document technical and business requirements, leading to the successful launch of a new online banking feature ahead of schedule by 15%. Business Data Analyst Intern (PNC Financial Services) Jan 2024 – May 2024

• Supported the development of an ETL pipeline using Python and SQL to consolidate retail banking transaction data, reducing data discrepancies and manual interventions by 25%.

• Collaborated with senior analysts to develop Power BI dashboards for tracking customer account activity and financial product performance, leading to a 20% improvement in customer insights for the marketing team.

• Assisted in the implementation of data governance protocols using AWS Glue, enhancing the traceability of financial data and improving data compliance by 15%.

• Contributed to the creation of PL/SQL scripts for data validation, improving the consistency of transaction reports and minimizing reporting errors by 20%.

• Attended cross-functional meetings to document data requirements and user stories, aligning project goals with business objectives and stakeholders to support the successful delivery of new financial data solutions. Languages Python, SQL, C

Databases Oracle, Mongo DB, Microsoft SQL server

Frameworks NumPy, Pandas, Matplotlib, Seaborn, Plotly, Scikit-learn Visualization Tools Tableau, Power BI, Excel

Cloud AWS

Analytical Skills Data Cleaning, Data Mining, Data Warehousing, Data Governance, Gap Analysis, A/B Testing, Problem- solving, Critical Thinking, Cost/benefit analysis, Impact analysis, Risk analysis, SWOT analysis, Use Case Diagram, ROI, Data Modeling, Data Structures, Continuous Integration and Continuous Deployment

(CI/CD)

Tools Git, GitHub, SAS, SAP, Jupyter Notebook, VS Code, Docker, Kubernetes, Visio, Lucid chart, MS Office Suite(Word, Project), JIRA, Docker, Office365 tools (Teams, Outlook, PowerPoint) Methodologies SDLC, Agile (Scrum)

Adons Softech, India Jan 2021 – Dec 2022

Business Data Analyst

• Designed and implemented scalable data pipelines using ETL tools (Apache NiFi, AWS Glue, Databricks) to automate the extraction, transformation, and loading of HR data from multiple systems, reducing manual HR data management efforts by 40%.

• Developed interactive dashboards and visualizations using Power BI providing real-time insights into employee performance, turnover, and engagement, contributing to a 15% improvement in employee retention and a 20% reduction in absenteeism.

• Built predictive models utilizing machine learning frameworks (Scikit-learn, TensorFlow) to forecast employee turnover and optimize HR processes, helping reduce voluntary turnover by 10% through proactive intervention.

• Streamlined HR workflows by automating processes like payroll and leave management, cutting operational costs by 30% and reducing process times by 25%, contributing to a 15% increase in HR team productivity.

• Collaborated with HR and IT teams to integrate global HR data systems across business units, ensuring data consistency and enhancing workforce planning accuracy by 20%.

• Utilized Azure Logic Apps and Azure Functions to automate HR processes such as employee onboarding and document approvals, reducing process times by 20% and enhancing overall workflow efficiency.

• Supported data governance and quality by ensuring compliance with data privacy laws and implementing robust data validation procedures, improving the accuracy of HR reporting by 18%.

• Leveraged advanced Excel techniques (pivot tables, VLOOKUP, macros) to create ad-hoc reports and track key HR metrics, facilitating data-driven decision-making for senior stakeholders and improving reporting turnaround time by 25%. Softright WebTech, India July 2018 – Dec 2020

Data Analyst

• Led a project to enhance the e-commerce platform's performance by analyzing user behavior data using Google Analytics, Excel, and SQL, which resulted in a 30% increase in website traffic and conversion rates.

• Developed and automated data extraction workflows using Python and SQL to improve data quality and reduce manual data collection efforts by 35%, enhancing efficiency in business reporting.

• Built dynamic Excel dashboards to visualize KPIs for web traffic, user engagement, and sales, providing stakeholders with actionable insights for decision-making on marketing and sales strategies.

• Conducted data cleansing and data validation using SAP and SAS tools to ensure the accuracy and consistency of e-commerce data, leading to a 25% improvement in data reliability for business intelligence.

• Collaborated with cross-functional teams and stakeholders to design and implement A/B testing on website features, analyzing test outcomes to optimize user experience, which improved sales conversions by 20%.

• Analyzed customer demographics and purchasing behaviors using SAS to identify key market segments, allowing the marketing team to tailor campaigns effectively and increase ROI by 15%.

• Maintained a centralized MySQL database for efficient storage and access to sales and web interaction data, improving data retrieval and reducing report generation time for management by 40%.

• Partnered with the web development team to define and document requirements for tracking new website features, ensuring seamless integration with data reporting tools and successful feature rollouts. WORK EXPERIENCE

Master of Science in Advanced Data Analytics May 2024 University of North Texas, USA

Postgraduate Program in Advanced Construction Management Mar 2016 National Institute of Construction Management C Research Bachelor of Technology in Civil Engineering May 2013 Jawaharlal Nehru Technological University

Contact this candidate