VBA Developer

Priya Kumar

510-***-**** *****.*****.***@*****.*** Lean Six Sigma Green Belt certified

OBJECTIVE

A proactive and fast learning individual seeking an opportunity to work as a dynamic VBA developer utilizing analytical and methodical skills and relevant expertise to help the company achieve business goals while sticking to vision, mission and values.

EDUCATION

MASTER OF SCIENCE in Computer Science (89%) 2005 - 2007

Madura College Madurai, India

BACHELOR OF SCIENCE in Computer Science (84%) 2002 - 2005

Fatima College Madurai, India

SKILLS

Visual Basic VBA (Visual Basic for Applications) MS Excel (Advanced Excel Formulas Pivot Tables Charts Graphs VLOOKUP Power Pivot) MS Access MS Outlook MS Web Services MS SharePoint Power BI Tableau Python Django ORM MVT HTML CSS DOM Bootstrap JavaScript jQuery AJAX AngularJS ReactJS UI UX IIS VBScript SQL T-SQL JSON XML XSLT SOAP PowerShell ASP R NumPy Pandas SQLAlchemy Celery MS SQL Server SSMS SSIS SSAS SSRS Oracle MySQL PostgreSQL SQLite Gitlab SAP Visual Studio Code MS Visio Lucid chart MS SharePoint Designer.

EXPERIENCE

SENIOR VBA DEVELOPER 11/2018 - Present

Kaiser Permanente Oakland, CA

·Develop and maintain the tracking application using MS Access VBA and MS SQL programming for health care clinical trial studies.

·Create data models and database designs for the development of Cancer study tracking systems.

·Clean, transform, and validate data to ensure accuracy and consistency.

·Utilize VBA to automate repetitive tasks, improve efficiency, and enhance data workflows.

·Perform data cleaning, manipulation, and analysis using Python to efficiently handle large datasets.

·Design and create reports and dashboards using tools like Tableau and Power BI demonstrating key information for decision making.

·Develop APIs in Python to parse JSON data and load it into the database from third-party vendors.

·Develop scalable programs using Python, automating tasks, and scripting.

·Design and implement schema, complex SQL queries, stored procedures, triggers, and functions in MS SQL Server.

·Collaborate with team to understand their data requirements and provide analytical support.

·Ensure compliance with HIPAA regulations in handling sensitive healthcare data.

·Work on large data sets for Health Care data analysis and reporting.

DATA ANALYST 03/2018 - 11/2018

PG&E Concord, CA

·Responsible for improving order cycle metrics through research and data analysis, playing a vital role in reducing backlog orders by 82%.

·Created a forecasting data model to analyze order status and trends for the upcoming week. This will improve the decision-making process and highlight areas with a large impact on order cycle time metrics.

·Compiled and analyzed data from a different source in preparation for an external benchmarking submission.

·Automated business solutions for generating a summary of throughput on a week-over week basis.

·Created applications to automate cadence reports for identifying aging orders, in order to facilitate prioritization.

·Used Python libraries like NumPy and Pandas to manipulate and analyze data.

·Created and designed Tableau dashboards to tackle important business issues.

·Collaborated with cross-functional teams to identify business requirements and translate

them into analytical solutions.

VBA DEVELOPER 01/2012 - 09/2014

Hewlett Packard Chennai, India

·Developed and implemented an end-to-end solution for HP Finance's special pricing accrual process with an impact of $1.2 billion in rebates.

·Generated Pricing data model and reports through data and financial analysis.

·Collaborated with business users to understand business processes and suggested automation opportunities.

·Assessed end-user requirements for compliance with HP's data security policies.

·Documented functional specification and system design specification for the project.

·Owned the project requirements through design and implementation.

·Drove Performance Optimization tuning.

·Created plans for deployment of releases in SharePoint 2010/2013 Platforms. Managed in the

·establishment of tests, staging, and production environments.

·Triaged and fixed issues found during month-end closure and year-end closure.

·Documented End User Technical /Troubleshooting guide for use by Process Analysts in APJ, EMEA, and AMS regions.

·Championed SOX and ISO audit requirements for the project, including documentation for requirements, system design, and user guide.

·Provided end-user training to Americas, Europe, and Asia Pacific regional financial analysts.

BUSINESS ANALYST 03/2008 - 01/2012

Hewlett Packard Chennai, India

·VBA automation projects yielding to 16 Head Count.

·Provided automated solution that helped in improving the Accuracy, Efficiency, Turn Around

Time (TAT) and Customer Experience for HP Supply Chain (Order Management team).

·Extracted order information by scraping the intranet website using HTML DOM properties

·and methods to automate the order ETA reports.

·Automated different kinds of reports, KPIs, dashboards and scorecards.

·Automated Account review package for monthly and quarterly reports.

·Created and maintained internal website for the team.

Contact this candidate