AKSHATHA KAPU

USA ad321v@r.postjobfree.com +1-312-***-**** linkedin.com/in/akshatha-kapu-741b7512b KEY SKILLS

Programming Languages: MySQL, PostgreSQL, Pyspark, Python (NumPy, Pandas), R, Java, HTML, LookML. Databases & Engineering Tools: Tableau, Looker, Jupyter, Power BI, SSIS, SaaS, VS Code, Oracle, DataBuilt Tool, MicroStrategy, Ubuntu.

Big Data Technologies: Hadoop (Hive, Spark), AWS (S3, EMR, EC2) Skills: Data Analytics, Account management, Artificial Intelligence, Azure, Databricks, SAP, Requirements gathering, Google Suites (GCP), Automation, ETL, RDBMS, Shell scripting, Data cleaning, transforming/analysis, Git, Jira, Github, Agile, Airflow, Snowflake, confluence, Project Management, Operations, Microsoft Excel, PowerPoint, Data Visualization, Testing. PROFESSIONAL EXPERIENCE

Senior CSS Application Developer Analyst United Parcel Services Sept 2023 – Current, Parsippany, NJ

• As a developer, I work on Data Development: Develop complex queries, apply best practices for performance tuning, gather data requirements to meet users and business needs, and maintain proficiency in database technologies to remain current with industry standards. Data Analysis: Audit and analyze raw data from external sources, research and locate valid data sources for customer reporting needs, and present new ideas for reporting current data. Data analyses must maintain attention to detail to achieve precision and accuracy.

• Redeveloped the entire Microsoft Access Macros along with its SQL queries into Python script for the Longview application and also built the dashboards using Oracle Business Intelligence tool.

• Conducted work sessions to gather relevant information, liaising between IT and business owners to ensure solutions satisfy business problems and opportunities and process design, technology planning, and testing for UPS Controls, Standards, and Strategy (Financial Systems) department.

• Responsible for EPM application management, administration, and full systems life cycle management activities, including audits, analyses, technical requirements, design, coding, and testing.

• As a supervisor, I do manage employees, conduct performance reviews, and ensure assigned workload is complete accurately and on time. Ensure management protocols such as pay integrity & data integrity. Data Management Analyst Avant Jun 2022 – Jun 2023, Chicago, IL

• As a part of new finance migration projects, built ETL pipelines, dashboards, and machine learning algorithms and predictive models that enable monitoring of the credit cards, TD, Loan products and monitor credit performance metrics for our core process improvements.

• Collaborated with the data modeling team to understand business requirements and data models, ensuring accurate data transformations.

• Optimized ETL jobs for performance improvements, resulting in a 25% reduction in processing time.

• Collaborated with cross-functional stakeholders teams to define key performance indicators (KPIs), track progress, and ensure alignment with business goals and to develop and maintain data governance and data quality standards.

• Developed and maintained data pipelines to ensure the timely and accurate transfer of data, supporting both batch and real-time data processing.

• Managed, optimized, and tuned data warehouses (Snowflake, Redshift, BigQuery) for improved performance and query efficiency.

• Built and maintained data models and schema designs for efficient data storage and retrieval and worked with big data technologies (e.g., Hadoop, Spark) to process and analyze large-scale datasets.

• Developed custom scripts and programs in Python to automate data processes and ensure data quality using Jupyter Notebooks.

• Assisted in data migration projects, ensuring seamless transitions between data platforms and systems and created documentation for data engineering processes, standards, and best practices. Data Science Capstone Illinois Institute of Technology Feb 2022 – May 2022, Chicago, IL

• Designed, created and developed data pipeline for analysis of Covid-19 clinical trials with high potential to deploy for other indications, web Scraped data from 15 clinical trial websites and converted Json to structured model

• Employed Azure Power BI to analyze market dynamics and customer preferences, enabling pharmacy start-ups to strategically position the products and achieve a 17% boost in customer acquisition. Business Data Analyst Sun Plus Software Technologies Pvt. Ltd. Apr 2017-Oct 2019, India

• Conducted competitive analysis and market research to identify opportunities for business growth and expansion into new markets and regular data audits and quality assessments, identifying and rectifying data inconsistencies and anomalies.

• Collaborative work with account managers to develop and maintain strong client relationships, resulting in a 10% increase in client satisfaction scores.

• Utilized data visualization tool- Tableau to create interactive dashboards, enabling real-time monitoring of key performance metrics.

• Worked with building complex SQL queries, Python, and data integration tools to extract, transform, and load (ETL) data from various sources.

• Actively contributed to the development of data security protocols, encryption methods, and access control measures to protect sensitive data. Data Analyst Intern Adroit Claretdene InfoTech Pvt. Ltd. Feb 2017- Apr 2017, India

• Conducted comprehensive ad-hoc data analysis to uncover key insights in consumer purchasing behaviors, feedback, and demographics, resulting in data-driven decision-making for strategic marketing initiatives.

• Facilitated seamless communication between technical and non-technical teams to gather acceptance criteria; conducted deep-dive analysis to refine user engagement stories, design risk/problem management metrics, and KPIs, ensuring compliance with business objectives and regulatory recommendations. EDUCATION

Illinois Institute of Technology Chicago, IL

Master’s in Information Technology and Management (GPA 3.7/4.0) Vidya Vikas Institute of Engineering Mysore, India Bachelor of Engineering in Computer Science (GPA 3.9/4.0) CERTIFICATIONS

Google Data Analytics Professional Certificate

Python Language Professional Certificate

Tableau-Data Visualization Certificate

Contact this candidate