Data Engineer,Python SQL Server Visual Studio Data Visualization

LAKSHMI PRABA RAVICHANDRAN

Email: *********@*****.*** Phone: +1 (248)- 255- 9994) Location: Michigan, USA Data Engineer & Machine Learning Enthusiast 4+ Years in SQL, Python & Data Engineering Built Predictive Models & Dashboards Experienced in ETL, Data Pipelines, Anomaly Detection MS in Computer Science, Wayne State University PROFESSIONAL SUMMARY

Highly motivated Data Engineer and Software Professional with over four years of experience in data pipelines, SQL, and machine learning. Strong foundation in building data-driven solutions and optimizing workflows across platforms. Proficient in Python, SQL, ETL, and data visualization tools. Passionate about applying machine learning techniques to deliver predictive analytics and insightful business solutions. Seeking to leverage expertise in data engineer and contribute to impactful decision- making. KEY EXPERTISE AREAS:

Data Engineering & Pipelines: Proven experience in designing, optimizing, and maintaining scalable data pipelines using SQL, ETL tools, and cloud platforms like GCP and Snowflake to ensure efficient data flow and integrity. Machine Learning & Predictive Analytics: Hands-on expertise in implementing machine learning models for anomaly detection, recommendation systems, and predictive analysis to enhance decision-making capabilities. SQL & Database Management: Strong proficiency in SQL, managing relational and NoSQL databases, and developing dashboards using SQL Server Management Studio, Visual Studio, Tableau, and MongoDB for clear, actionable insights. CAREER ACHIEVEMENTS:

Dashboard Development: Developed a comprehensive dashboard for Blue Cross Blue Shield of Michigan, improving the reporting process for the FRMA team by centralizing critical data and reducing report generation time by 25%. Finance System Transformation: Played a pivotal role in end-to-end quality assurance for Centrica’s finance systems, successfully transitioning multiple systems (MS CRM, SAP) into an integrated financial platform with zero post-launch critical defects.

Cloud Migration Success: Led the QA efforts in a large-scale data center migration project for Centrica, overseeing the seamless transfer of IT services to new data centers without disrupting business operations, contributing to a 40% reduction in operational costs.

CORE AND TECH SKILLS

Technical Skills: Proficient in Python, SQL, R, and data visualization tools like Tableau, emphasizing expertise in data manipulation and analysis.

Machine Learning Proficiency: Experience in implementing machine learning algorithms for predictive analysis and anomaly detection, with a focus on practical applications. Data Engineering: Strong knowledge of ETL processes, relational databases (MySQL, SQL Server), and cloud platforms such as GCP for data warehousing.

Soft Skills: Excellent problem-solving abilities, effective communication skills, and strong collaboration capabilities to work within diverse teams.

Tools and Frameworks: Familiarity with Jupyter Notebook, Splunk for log analysis, and agile project management tools like JIRA to streamline workflow and enhance productivity. EDUCATION

MS in Computer Science, Wayne State University, Michigan, USA CGPA: 3.81/4.0 2021-2022 B.Tech in Information Technology, Anna University, India CGPA: 8.26/10.0 2007-2011 WORK EXPERIENCE

Blue Cross Blue Shield of Michigan

Role: Data Science and SQL Server Intern

MAY - 22 TO AUG - 22

Role Summary: Developed and optimized FRMA reports and dashboards, enhancing data visualization and decision-making processes for the FRMA team.

KEY RESPONSIBILITIES:

Created comprehensive FRMA reports using SQL Server and Visual Studio. Designed and implemented a user-friendly dashboard for report visualization. Collaborated with cross-functional teams to gather report requirements. Analyzed data to identify trends and insights for the FRMA team. Maintained and updated existing SQL queries for performance optimization. Conducted testing and validation of data accuracy in reports. Documented processes and developed user manuals for dashboard usage. Assisted in data pipeline management to ensure data integrity. Participated in team meetings to discuss project progress and challenges. KEY SKILLS/TOOLS/TECHNOLOGIES USED:

Python SQL Server Visual Studio Data Visualization Dashboard Development ETL Processes Data Analysis Reporting JIRA

Cognizant [DEC - 2011 TO AUG – 2015]

Role: Associate Data Engineer

Project: Dyno Finance Integration

KEY RESPONSIBILITIES:

• Developed conceptual, logical, and physical data models using Visio to optimize data organization and integration.

• Assisted with data warehousing and data modeling tasks.

• Worked on data validation and error handling using Informatica Data Quality to improve data accuracy.

Role: Data Engineer

Project: Data Center Migration & Transformation

KEY RESPONSIBILITIES:

• Created data visualizations using Tableau to improve data analysis and decision-making capabilities, collaborating with data scientists and analysts to build data models for visualization and reporting.

• Utilized Spark libraries for data processing and analysis, including Spark SQL for SQL querying, Spark Streaming for real-time data processing, Pandas and Numpy for data cleaning, deduplication, feature selection and data manipulation. Role: QA Engineer

Project: MW Upgrade and Banner Upgrade

KEY RESPONSIBILITIES:

• Responsible for Jobs Scheduling, monitoring data flow.

• Created data visualization reports and interactive dashboards in Tableau. ACADEMIC PROJECTS

Weather forecasting using data mining – Performed predictive analysis using supervised Data Mining techniques. Anomaly Detection in credit card transactions using Machine learning Techniques. Network Defense and Countermeasures- Anomaly detection in splunk using log flies from different operating systems. Book Recommendation system- Built a Recommendation system using Collaborative filtering with K Nearest Neighbors approach.

Contact this candidate