Data Manager

JEGAN SELVARAJ

425-***-**** ******.***@*****.*** Greater Seattle Area, WA

PROFILE STATEMENT

• An Industrious Data and Business Enthusiast, with 8 years of experience at major fortune 500 tech companies, driven to boost business performance by leveraging statistical programming analysis in solving complex business problems. Demonstrated ability to envision, document and clearly communicate end to end solutions for business problems.

• Knowledge in Data Engineering, Business Analysis, Advanced Analytics, Data Analysis, Analytical decision making, Business Intelligence Reporting, Visualization, and Project / Program Management.

• A certified Level 1 Ethical Hacker who specializes in securing information systems and to forestall the hacking mechanisms.

PROFESSIONAL EXPERIENCE

MultiCare Tacoma, USA

Program Manager Business Analyst 12/20 – 03/21

• Program Management: Orchestrated advanced support and analytical work in managing, monitoring, coordinating, facilitating, and tracking the program’s foundational data initiatives.

• Collaboration: Enterprise data steward for membership domain data, worked on data interoperability, quality assurance, and user acceptance testing, process improvement, departmental and administrative policies, and communication.

• Reporting: Produced reports using SQL Server Reporting Services (SSRS). Proficient in using MS Visio for data flow and modeling diagrams, MS Excel for pivot tables and visualizations, and JIRA for project tracking.

• Business Intelligence: Used Power BI to derive intelligent inferences from the medical data that address business problems.

• Documentation: Created user stories and estimations during sprint planning for development and testing team to break down high level specifications.

• Communication: Supported and aligned teams’ efforts to fulfill stakeholder’s needs. Managed payors’ relationships and expectations by a clear communication process. Milgard Center for Business Analytics Tacoma, USA

Business Intelligence and Data Analytics Consultant 08/20 – 12/20

• Process Improvement: Performed Pricing Analysis of Quantum Windows for Milgard donor by preparing data for pricing algorithms and comparing data long-term to competitors using Excel/VBA, Microsoft Visual Basic.

• Optimization: Improved the manual pricing process by saving the time taken by 50% using automation.

• Reporting: Created a reporting framework using Excel/VBA that reduces the data discrepancies improving operational efficiency by 20%.

Delta Airlines INC. SeaTac, USA

Business Analyst Project Manager Internship 06/19 – 06/20

• Leadership: Led a Kanban team of four to optimize flight scheduling by improving flight delay prediction by 30%.

• Collaboration: Collaborated with cross-functional teams and influenced leadership to improve the flight operations of Delta Airlines. Generated Business requirements and functional specification documents to manage client relationship effectively by defining goals of the project and break down of high-level goals to functional deliverables.

• Business Intelligence: Created business recommendations using the inferences generated from data visualization using Power BI and Tableau.

• Analytical Skills: Descriptive Analytics using SQL to identify the root cause of the flight delays. Incorporated prescriptive analytic modeling using statistical regression, Azure ML Studio, MS SSMS, R, SQL Servers, and Visualized using Tableau. DELL INC. Chennai, India

Python Developer SDE I & II 12/13–06/19

• Innovation: Identified poor QoS as a major deterrent to seamless user experience. Delivered a strategic analytic solution to automate validation of network switch performance. Developed the analytics system/dashboard visualizations in-house, improving the accuracy of defect detection by 150%. Awarded employee of the quarter.

• Problem Solving: Performed Text Analytics of Networking S Series S6000 10/40GbE Switch Stacking results and Early Automation scripting using Agile methodology and python to improve the accuracy of the validations by 30% and to reduce the man-hours by 40%.

• Creativity: Completed Data Analysis and Regression tests of results from Snake Traffic/Optics validation scripts before hand-off to the stakeholders and reduced the total time required by 40 minutes.

• Optimization: Set up python-based automation using Robot framework to validate Microsoft Firmware upgrade. Reduced the time required by two hours, eliminating manual effort by 30%. Accenture Bangalore, India

Business Warehouse Developer 08/13–12/13

• Data Integrity: Improved the quality of data extracted by effective ETL operations up to 20% and accelerated the implementation/delivery of BI solutions up to 25% by monitoring performance, leveraging solutions, data integrity, and efficient communication. PROJECTS

Machine Learning and Data Modeling of Mortgage data using Azure ML and MS SQL Data Studio to analyze loan applications

• Storytelling: Established a predictive experiment to envision Mortgage funding decisions using various factors of Mortgage applications by recognizing the regulating aspects from the Data.

• Machine Learning: Overhauled the accuracy of the prediction up to 78% using Azure ML, Excel, and MS SQL Studio.

Data Analytics and Visualization to redefine sales strategies by interpreting the influencing factors for popularity index of Spotify Music tracks using Tableau and MS SQL Server

• Business Intelligence: Instituted Business and Data Understanding, documentation, Data Description/Preparation, Bi-variate statistics, and visualizations to interpret the manipulating factors of Spotify Music. Utilized Tableau, Tableau Prep (for Data Prep), Excel and MS SQL Server for visualizations.

• Used Tableau Visualizations identified the major components that affect the sales and popularity of Spotify Music.

EDUCATION

Master of Science in Business Analytics University of Washington Tacoma GPA: 3.93 Bachelor of Information Technology Madras Institute of Technology Chennai India GPA: 3.70 ADDITIONAL INFORMATION

• Analytical Skills: R, Python, MS SQL, Excel, Pivot Tables, Oracle, PowerApps, Teradata, MySQL, PowerBI, Tableau, MS Suite, Azure ML, Excel, Visio

• Other Technical Skills: C, C++, Ruby, HTML, CSS, JavaScript

• Publications: Published white paper on “Design of Intelligent Child Interactive System Using Humanoid Robot and Cloud Computing” – ICSRN

• Interests: Learning new languages, digital art, Toastmasters, community volunteering.

Contact this candidate