Data Analyst Senior

Srinath Bhagyanagar

443-***-**** *******.***********@*****.***

Summary

Results-driven Senior Data Analyst with over 5 years of experience in data analysis, data modeling, predictive analytics, and actionable business intelligence. Proven expertise in Python, SQL, Tableau, and big data platforms, with a strong foundation in statistical analysis, machine learning, and data storytelling. Adept at translating complex business requirements into insightful reports and strategic recommendations aligned with current market trends in data-driven decision-making.

Experienced Senior Data Analyst professional with 5+ years of experience in transforming business requirements into actionable data models, prediction models and informative reporting solutions

Proficient in providing solutions using data collection & aggregation, data processing, data mining, data visualization and big data techniques. Adept at python, SQL and Tableau.

Proficient in performing exploratory data analysis, data cleansing, and data visualization using data mining tools.

Proficient in Python and its libraries such as Numpy, Pandas, Scikit-learn, Matplotlib and Seaborn.

Use case creation, data modeling, data mapping, CSS

BRD, FSD/FRS, Requirements Traceability Matrix creation

Implementation and release planning

Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validations.

Data Migration, Data profiling, Data Integration and Meta data Management services.

Extensive experience in analyzing and designing complex Mappings

Experience in writing SAS programs for data extraction; modify existing programs for data extraction

Extensive experience working with RDBMS such as SQL Server, MySQL, Oracle and NoSQL databases such as MongoDB.

Proficient in data visualization tools such as Tableau, Python Matplotlib, Python Seaborn, R Shiny, R ggplot2 to create visually powerful and actionable interactive reports and dashboards.

Coordinate new business opportunities, worked with sales team to identify opportunities

Knowledge and experience working in Waterfall as well as Agile environments including the Scrum process and using Project Management tools like Project Libre, Jira/Confluence, Kanban and version control tools such as GitHub/Git.

Technical Skills

Programming: Python (Pandas, NumPy), R, Basics of Java, PySpark.

Data Visualization: Tableau, Python (Matplotlib, Seaborn), R(ggplot2), Power BI, Qlik, MS Excel

Databases: Snowflake, MySQL, Microsoft SQL Server, Oracle, PostgreSQL, MongoDB

Other tools: MS Office Suite, Google Analytics, Adobe Analytics, SAP Business Objects, ETL- Informatica

Education: Masters in Computer Science, Silicon Valley University San Jose, California.

Work Experience

Fannie Mae, Reston, VA

Sr Data Analyst April 2022- Present

Responsibilities:

Being an SME (subject matter expertise) provided all the existing business rules, data definitions and logic That would help the New Migration team replicate the old process.

Worked actively/directly with Leadership team, explaining about the project developments etc.

Actively conducted meetings for Data Mapping between the old Structure to the New Structure.

Gathered requirements and created Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.

Performed extensive Data Validation and Data Analysis to ensure accuracy and quality of the report.

Performed transformations using SQL Queries to extract and load data into user managed tables.

Acquiring data from primary or secondary data sources and maintaining tables for analysis purpose.

Extensively participated in Joint Application Development (JAD) sessions to develop and agree upon a system that focuses on the business requirements.

Extensively Validated XML’s to understand what data is passed thru API calls against what’s been written to actual tables and identify any data issues.

Leverage technologies like Python, Advanced SQL and Spark to reveal the insights hidden within huge volumes of numeric and textual data.

Developing validation plans for specific system implementation projects.

Ability to define problems, issues and opportunities, analyze data, establish facts, and draw valid conclusions from various datasets.

Worked alongside teams within the business or the management team to establish business needs.

Acted as a liaison between the business user group and the technical team.

Monitor UAT activities with cross functional QA Teams to validate and test the data to be in sync with the team during testing to ensure the data quality before moving into PROD environment.

Define and initiate change requests for business stakeholders and prioritize and validate all requests with the business.

Dell, Austin, TX

Sr Data Analyst June 2021 – March 2022

Responsibilities:

Communicated and coordinated with end client for collecting data and performed ETL to define the uniform standard format.

Queried and retrieved multiple unstructured datasets through web scraping to get the sample dataset.

Analyzed the business needs, interpreted business user requirements and translated them into reports supporting the business needs

Worked with end users to gain an understanding of information and core data concepts behind their business.

Collected and merged census data, Geospatial data and other publicly available data using Beautiful Soup.

In preprocessing phase, used Pandas to remove or replace all the missing data and balanced the dataset with Over-sampling the minority label class and Under-sampling the majority label class.

Used dimensionality reduction techniques and other feature engineering, feature normalization and label encoding Scikit-learn preprocessing techniques to reduce the high dimensional data (>150 features) collected from various sources.

In data exploration stage used correlation analysis and graphical techniques in Matplotlib and Seaborn to get some insights about the High opportunity neighborhoods and poverty levels.

Set up data preprocessing pipeline to guarantee the consistency between the training data and new coming data.

Collected the feedback after presentation, retrained the model to improve the performance.

Created an interactive Tableau dashboard for highlighting the High Opportunity Neighborhoods and suggested strategies to increase housing choice for low-income households.

Designed, developed, and maintained daily and monthly summary, trending and benchmark reports in Tableau Desktop.

Environment: Web scraping, SQL, Linux, Python, Machine Learning (Linear Regression /Random Forest), Tableau, ETL.

Bed Bath & Beyond, Union, NJ March 2018 – June 2017

Data Analyst

Gather requirements from the client and design sales reports/custom sales analysis tools to meet sales management business objectives

Provide expertise and consultation to the team on analytic coding questions, data solutions and oversee the project till completion

Design, build and maintain data warehouse solutions to support Business Intelligence (BI) and Reporting projects using Microsoft SQL Server

Collaborate with a cross-functional team of data scientists and product managers to define and understand the data requirements for analysis

Perform statistical modeling and regression analysis to develop strategic business insights

Pull data from large AWS, PostgreSQL and Snowflake databases using complex SQL queries and python scripts.

Gather and validate the information collected by applying judgment and analyze data with aggregations and descriptive statistics

Use R Language for performing data analysis and statistical tests for A/B testing.

Compile results into a coherent story and present them in a spreadsheet or dashboards.

Develop the data pipeline process to feed analytics, reports and tableau dashboards for ongoing reporting to stakeholders.

Implement automation script using Cron jobs in python for updating the dashboards.

Document the results and upload the project code in GitHub repositories

Communicate research results, recommendations, opportunities to the executive teams, product owners and implemented the techniques for priority projects.

COMCAST, Herndon, VA July 2012 – Feb 2016

Middleware Administrator

Installed and configured Oracle Weblogic Application Server 10.x/11g/12c on Sun Solaris 8/9, Red Hat Linux environments and provided necessary standard infrastructure template documents to build QA and other environments.

Performed installation of Weblogic software binary across different environments using automated as well as manual procedures.

Collaborated with team to work with Amazon AWS tools and assisted in building infrastructure for various web applications, assist with documentation and security assessment.

functions like log rotation.

Develop and maintain production quality dashboards, custom views, saved searches and alerts for Splunk Operations

Configured Node Manager for administration of Managed servers.

Deployed various WAR, EAR, JAR applications in Domain and clustered environments.

Deployed applications on multiple Weblogic Servers and maintained Load Balancing, High availability and failover functionality

Configuration of monitoring tool (Nagios, Wily, HP BAC) for monitoring various services running on the servers and log monitoring tools like Splunk

Monitored and tuned JVMs, JVM heap size, garbage collections in Development, System Test, Staging and pre-production.

Worked in container based technologies like Docker, Kubernetes and OpenShift

Explored and performed troubleshooting of emerging application run time issues from UNIX server console.

Tuned the JDBC connection pools initial and maximum capacity to the same value in production systems to avoid creating new connections on the fly during load spikes.

Performed Starting, stopping and clearing the cache of Weblogic servers.

Deployed various WAR, EAR, JAR applications in Domain and clustered environments.

Performed Server log and Domain log monitoring, application deployment and performance tuning of Weblogic.

Updated JVM parameters like maximum and minimum heap size in Weblogic startup scripts.

Involved actively in monitoring free space, disk usage, locating files, checking and clearing log files, administration and monitoring of disk-based file system.

Monitored the Weblogic Execute Queues, JMS Queues.

Experience with BIG IP F5 Load Balancer administration, netcache devices for alerting on applications.

Involved in configuring Web Security tools – LDAP server, SSL certificates.

Worked on troubleshooting various LDAP and SiteMinder issues with operations team

Used SiteMinder to ensure user's ability to access information quickly and securely

Provided 24/7 on –call support for production and non-production environments which included product test, staging, training and break fix environments.

Interacted with Development teams for Application architecture changes, with respective to weblogic configurations.

Documented standards, issue log and oncall logs

Used Weblogic WLST command line interface to check attributes of the runtime mbeans.

Coordinated web platform infrastructure changes following standardized change control process.

ENVIRONMENT: Oracle Weblogic Server 11g/12c, JDK 1.4/1.5, AWS, S3, EBS, EC2, ELB, Kubernetes,J2EE, OEM, JDBC, JSPs, Tomcat, Apache 2.x, JMS, Perl 5.0, Puppet,EJBs 3.0., VMware,Red Hat Linux 4.0, Shell Scripting, Oracle 11

Contact this candidate