| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateRajasekar Kamaraj Senior Data AnalystPHONE NUMBER AVAILABLE EMAIL AVAILABLESummary of QualificationsHighly skilled Senior Data Analyst with over six (6) years of experience in quantitative data analysis, data science, mathematics, statistics, and big data. Proven track record of success in solving real-world problems by deriving insights from complex structured, semi-structured, and unstructured data. Strong leader with a demonstrated ability to achieve goals within specified timelines. Excellent written and verbal communication skills.Areas of ExpertiseData Analysis and Exploration: Python, R, SQL, SAS, Exploratory Data Analysis (EDA), SplunkData Processing and Manipulation: PySpark, Databricks, AWS EMR, EC2Data Storage and Management: MySQL, Snowflake, Oracle, AWS S3, RDS, Redshift, NoSQL, TeradataData Integration and ETL: AWS Glue, SSIS,SSRS, Git & Version Control, REST APIEducationTeam Collaboration and Project Management: Agile Software Development, Jira, SharePoint, ConfluenceVisualization and Reporting: Tableau, PowerBI, ServiceNowMichigan Technological University Houghton, MIM.S. Data Science Aug 2016 - May 2018Anna University Chennai, IndiaB.E. Computer Science Aug 2010 - May 2014Career ChronologySenior Data Analyst Jul 2023 PresentCompunnel Inc. (Client: Freddie Mac)Proficiently developed dynamic Tableau dashboards for 6 vulnerability scans, enabling users to visualize and categorize vulnerabilities based on severity (Critical, High, Medium), empowering targeted remediation efforts.Implemented drilldown features allowing users to focus on specific vulnerability levels and initiate fixes.Designed the vulnerability scan dashboard with simplicity and clarity, ensuring usability from Senior VP to engineer level.Enhanced data analytics with vulnerability Tableau dashboards by devising advanced solution to precisely identify critical and high plugins and solutions, effectively reducing the % of overdue vulnerabilities per scan.Spearheaded the creation of a centralized data repository, facilitating easy access to actionable insights for stakeholders.Drove process improvement initiatives by introducing automated solutions, significantly reducing team workload and enabling a focus on additional projects, thereby enhancing team productivity.Developed multiple analytical solutions for vulnerability remediation using SQL, optimizing query performance to identify and prioritize vulnerability remediation efficiently.Developed a high-visibility dashboard in ServiceNow to dynamically view change tickets, categorizing them based on severity (High, Medium). This dashboard enables senior leadership to swiftly assess impactful changes.Successfully managed a team of two data analysts, overseeing performance cycles.Senior Data Analyst Jun 2021 Jun 2023Compunnel Inc. (Client: Capital One [June 2021 June 2023])Led the development and management of regulatory and compliance controls, ensuring adherence to internal policies and federal regulationsAnalyzed customer interactions (chats, calls, cases) to monitor front-line agent performance and customer trendsBuilt and maintained a Tableau dashboard for the Adherence Quality Assurance team, offering crucial insights and visualizations to track key metrics and performance indicatorsDemonstrated strong analytical skills in effectively documenting and translating business needs into actionable control scripts, resulting in streamlined processes and enhanced regulatory monitoring capabilitiesDeveloped and implemented automated data pipelines for diverse projects, ensuring smooth and accurate data integration, transformation, and loading using Snowflake, Databricks, and, Tableau reports.Extensive experience working independently and demonstrating a high level of expertise in data analysis, reporting, and visualization, resulting in streamlined processes and enhanced decision-making capabilitiesCreated and optimized SQL queries for data extraction and transformation, resulting in a 40% reduction in data processing time and improved overall data accuracyProvided production support and addressed issues reported by Adherence Quality Assurance team, ensuring the smooth functioning of the monitoring system and dashboardLeveraged Databricks to create and maintain an automated data pipeline for data ingestion and report generation from disparate sourcesPerformed Data Pre-processing, Profiling using Python and PySpark frameworks, enabling validation and automation of regular checksSuccessfully executed the data migration of 50+ scripts from Redshift to Snowflake, ensuring minimal downtime and preserving data integrity throughout the processCollaborated closely with cross-functional teams to ensure smooth data migration and implementation, effectively communicating and coordinating with stakeholders throughout the transition processProvided backend dashboard production support to service representatives using PySpark, Snowflake, TableauFulfilled ad-hoc request for retrieving complex transactional data for Tableau dashboardsSenior Data Analyst Jan 2019 Jun 2021HexaCorp (Client: Capital One [March 2019 April 2021])Played a pivotal role in maintaining data quality, mitigating risks, and optimizing costs for Capital One's enterprise data management teamDeveloped a comprehensive Reporting Suite for metadata tracking of internal data sets within the organizationUtilized Python to write highly complex scripts for gathering metadata and inventorying digital assets (Snowflake datasets, Amazon S3 buckets, and Teradata tables)Leveraged REST API calls to Nebula, an internal metadata reporting tool, to collect relevant data and applied data cleaning and business context addition techniquesImplemented automated nightly runs of the Python scripts using Linux Cron jobs on Amazon EC2 servers, ensuring up-to-date and timely reportingExecuted a high-priority project focusing on analyzing query usage for tables owned by the Enterprise Products and Platform Line of Business in the Snowflake technology platformDeveloped SQL Join queries to combine table inventory with extracted table usage data, enriching the analysis with owner details sourced from HR dataDemonstrated advanced skills in Apache Spark, SQL, data extraction, data mapping, and Tableau visualizationIdentified and addressed data risks in AWS S3 buckets by using Python scripts, REST APIs, and SnowflakeData Analyst Jan 2014 Aug 2016Voltech Engineers Pvt. Ltd.Analyzed and optimized the company's Enterprise Resource Planning (ERP) systems and data processesCollaborated in the development and implementation of new data management procedures and reporting tools, enabling real-time access to relevant and accurate dataDeveloped and implemented Power BI solutions, including complex dashboards and reports, resulting in a 30% increase in data visibility and improved decision-making for senior managementIdentified and resolved issues within the ERP system, contributing to improved data accuracy and streamlined operational processes |
