Amruthalakshmi Rajagopal

Arlington, TX 385-***-**** adyb9n@r.postjobfree.com LinkedIn Link GitHub Link Summary

Highly skilled and detail-oriented Data Analyst with 5+ years of experience analyzing complex data for software and business data analysis. Proficient in data integration, visualization, ensuring data quality, project management, and effective client communication. Adept at applying strong analytical and problem-solving skills to drive data-driven decision-making within organizations. Experienced in implementing ETL (SSIS), possessing a deep understanding of data modeling (Star/Snowflake schema), and maintaining large-scale data processing systems. Committed to delivering valuable insights and driving strategic outcomes through comprehensive data analysis. Skills

Programming: Python, SQL, R, HTML, CSS, JavaScript, C++, Java Database: Oracle DB, MySQL Server, Google Big Query, AWS, Azure Big Data Technologies: Data Warehousing, Hadoop, Apache Spark, Kafka Data visualization: Tableau, Microsoft Power BI (DAX), MS Excel (VLOOKUP, Pivot tables) Test management: JIRA, Confluence, Selenium, SAS, Informatica, A/B testing Platforms and tools: Jupyter, SAS, Agile, Microsoft Office, Epic, APEX, Agile CRM Machine learning/libraries: Regression, Classification, Deep Learning, NLP, Pandas, Scikit-Learn, NumPy, Seaborn, PyTorch Certifications Link: my Certifications

• Google Data Analytics (Excel, Tableau, Power BI, SQL,R)

• SQL for data analysis – LinkedIn, Udemy

• Power BI, DAX – Microsoft, LinkedIn

• Fundamentals of Azure Data lakes – Microsoft, LinkedIn Work Experience

GRADUATE STUDENT Asst (ANALYST) – UNIVERSITY OF TEXAS, ARLINGTON [Jan 2022 – May 2023]

• Analyzed HRIS and payroll data models for accessing data from the Snowflake server tables and validated for data redundancy.

• Worked on Tableau to build Interactive Dashboards with drill-down capabilities for data migration status to produce a strategic analysis report highlighting investment initiatives and requirements for technical and ETL development.

• Reviewed business strategic goals and recommendations to discover gaps, enhance strategic effectiveness and proposed measures for evaluating long-term returns on IT investments in terms of profits. BUSINESS DATA ANALYST INTERN (UI/UX Design Systems) - Q2 (Banking&Financial); Austin, Texas [May 2022 – Aug 2022] Tools: Power BI, ETL, Jira, design Systems (Tecton toolbox), confluence, Bitbucket, Abstract, Sketch Environment: SQL, Python, CSS, HTML

• Reported directly to Director of UI/UX and coordinated with Product Owners, solution design, development, business stakeholders, and gathering business requirements to configure 45% semantic models of Tecton’s UI components in Sketch and Abstract with applied design techniques.

• Participated in grooming backlog (JIRA), daily scrums, retrospectives, and sprint reviews (JIRA and Aha! Project management) with product owner and technology partners to meet release timelines and adding business value.

• Built data dashboards and visualizations, understanding the risk management models, developed reports using Power BI, developed, and maintained ETL pipelines to the transform data using Python.

• Designed integration test plan for CRM data extraction (data lakes, data marts), development of data models, and data pre- processing to leverage Tecton’s UI features efficiency from 55% to 70% for Quarter 3 and 4. PRODUCTION SOFTWARE ENGINEER (Data/BI)– ORACLE CERNER HEALTHCARE CORP; India. [Oct 2019 – May 2021] MILLENIUM Architecture; applications/tools, and Relational databases

• Participated and furnished technical management in all stages of BI projects by understanding CRM data extraction, business requirement, designing, developing, and maintaining dashboards and reports for end user using Tableau and Excel.

• Responsibilities involved with clients and stakeholders’ communication, gathering requirements analyzing the applications issues, and data profiling for identifying defects.

• Performed a feasibility and risk study to identify the application risk, business critical and high-risk areas while maintaining HIPAA, EDI(Healthcare) and standard code sets and their appropriate use.

• Analyzed complex data sets using SQL and Python for data extraction, data preparation, creating dashboards, and administer the SQL server to run query search engines.

• Mentored cross-functional team of 13 and provided technical directions and monitored KPI’s while ensuring quality and safety standards for all data validations to solve application issues targeted to 25% integration.

• Enhanced data processing accuracy by 15% and proposed technical solutions to client’s issues based on product goals. TEST ENGINEER (Data/BI)- KPIT TECHNOLOGIES; India [Oct 2017 – Oct 2019] Client: NSI and BMW - Data testing and development strategies Environment: Teradata, Excel, Python, SQL, MS-Office, Tableau

• Collaborated on two critical Middle Office Applications for data profiling – KITE and C3, conducted data audits (Advanced Excel – checking for statistics, data types, missing values, data quality assessment).

• Wrote complex SQL queries involving joins, sub queries and created data mapping documents to capture the source to target data flow and any transformation and business logic involved.

• Conserved data quality assurance formals within STLC, SDLC, AGILE methodologies and improved 15% database utilization rate for better outcomes in building, maintaining, and troubleshooting issues with data pipelines.

• Developed use cases, and performed functional tests, end-to-end integration tests and regression tests resulting in improving the quality by 45% and executed detailed data quality analysis for quality issues with cross functional teams and root cause analysis. SOFTWARE ENGINEER INTERN - FIRST GLOBAL SOFTWARE; India [Jan 2017 – May 2017]

• Elicited and detailed functional system requirements and non-functional system requirements from cross-functional technical teams to identify needs of new analytical environment.

• Implement backup and recovery solutions to ensure data integrity and redesigned functional and business use cases.

• Developed a custom program for full customer master data upload and resolved 45% of application issues by performing functional and integration testing.

APPLICATION ANALYST - SIEMENS Technology [May 2013 – Aug 2014]

• Understand and elicit requirement document for application validation.

• Test and evaluate application design and code (front end) as per client’s requirement.

• Work with troubleshooting teams to resolve the application issues and improve efficiency by 20%. Projects

Wells Fargo: NLP text processing - University of Texas, Arlington (Campus Analytical Challenge) [Jan 2023 – Mar 2023]

• Performed Data Wrangling and Cleansing by filtering and aggregating, missing value handling, deriving additional columns from existing datasets, cleaning (removing blank spaces, formatting dates, capitalizing)

• Implemented natural language processing (NLP) techniques such as tokenization, lemmatization, stemming, and stop-word removal to preprocess text data.

• Validated the data using python data libraries and designed interactive dashboards using Power BI to monitor key performance indicators (KPIs) for sales, and categories that customer transacted the most resulting in improved decision making.

• Trained and evaluated machine learning models including regression, KNN, SGD classifiers, neural network, CNN, RNN, LSTM, Random Forest. Calculated loss function, and accuracy to predict the transaction category with high accuracy.

• Achieved 66% accuracy in predicting the Retail Trade category, which had the highest number of transactions (5643). Fraudulent credit transactions - University of Texas, Arlington; Fadlab Research team [Aug 2022 – Nov 2022]

• Implemented data mining techniques such as Manipulation or dropping of data before it is used to enhance performance.

• Aimed at identifying fraudulent credit card transactions occurred in two days, takes value 1 in case of fraud, 0 otherwise.

• Worked with highly imbalanced data with 492 observations as 1’s and 280K as 0’s. Applied Oversampling methods like SMOTE, class-weights, random sampling.

• Tested models like Random Forest, XG Boost and Logistic regression. Observed PR curve and Balanced accuracy for predictions and acquired 83% accuracy.

IT Investment Analysis of HSBC and Citigroup - University of Texas, Arlington; Fadlab Research team [Jan 2022 – Mar 2022]

• Executed data profiling, data discovery and cleansing to fix data quality gaps and inconsistency. Ingested data from disparate sources using Talend into staging schema and further into a dimensional data model.

• Developed dashboards with POWER BI to analyze the IT investment trends of HSBC and Citigroup from 2006-2016. Conducted SQL analysis to evaluate the stored procedures and trigger functions of both organizations and identified areas for improvement.

• Produced a strategic analysis report highlighting investment initiatives and reporting requirements for technical and ETL development.

• Provided recommendations for enhancing operational and strategic effectiveness and proposed measures for evaluating long-term returns on IT investments in terms of profits.

Education

The University of Texas at Arlington (UTA) Master of Science in Information Systems (GPA: 3.7) [Graduation: May 2023] Relevant Courses: Business Stats and Analytics, Big Data, Data Science, Data Mining, Data Warehousing, Data Analytics Visvesvaraya Technological University (VTU) Master of Computer Application [Graduation: May 2017] Bangalore University (BU) Bachelor of Computer Application [Graduation: May 2013]

Contact this candidate