Database Developer

APEKSHA MATHUR

Brooklyn, NY 443-***-**** *******.******@***.*** linkedin.com/in/apekshamathur EDUCATION

MS in Computer Science, New York University, NY May’17 Relevant coursework: Database Systems, Software Engineering, Algorithms, Computer Networks, Data Science BS in Information Technology, Jawaharlal Nehru Technological University, India May’15 Relevant coursework: Data Warehousing, Data Mining, Database Management, Advanced Java Technologies, C++, Data Structures TECHNICAL SKILLS

Programming: C, C++, Python, Java, ASP.NET

Databases: MySQL, T-SQL, PL/SQL, PostgreSQL, SQLite, Oracle Web Technologies: JavaScript, CSS3, HTML5, jQuery, AngularJS, Bootstrap, WordPress, PHP, Adobe Creative Suite (PhotoShop) Reporting Tools: R, Tableau, MS Office (Word, PowerPoint, Excel) Certifications: Microsoft SQL Server 2016: Query Data, Advanced SQL for Data Scientists, Core Java WORK EXPERIENCE

Database Administration Assistant, NYU-Department of Mathematics Brooklyn, NY MySQL Excel WordPress Oct’16-May ‘17

• Evaluated the existing database to determine and clean up outdated or unused items to be discarded and recommended improvements to computer systems such as installation of new databases

• Compiled lists of staff, PhDs, Adjunct professors and 7000+ undergrad students and materials on related coursework using databases

• Analyzed students’ requests to determine needed information, and assisted in furnishing or locating that information

• Approved, scheduled and planned after school workshops and ensured successful completion of 15+ operations within given time frame; developed and maintained information on the Department of Mathematics website Full Stack Developer, Crystal Brook Advisors New York, NY MySQL JQuery WordPress PHP Jul’16-Sep ‘16

• Developed a Customer Database Management System that supports the current web applications thereby reducing the processing time by 30%

• Reengineered the existing website to a more user interactive platform with continuous backup files from the website to local directories for instant recovery in case of problems

• Collaborated with the development team and selected programming languages, design tools, and applications to remodel the website from scratch

• Reviewed and updated web page content or links in a timely manner, using appropriate tools, and interacting with the third-party vendors to ensure the application would ensure to SEO principles Web Application Developer, Technical Consulting and Research Inc. New York, NY PHP MySQL JQuery WordPress HTML5 CSS3 May’16-Jul ‘16

• Consulted and negotiated with the management to prepare project specifications by analyzing technology, resources needs, and market demand, to plan, assess the feasibility and write supporting code for the project-‘Best We Can Be’

• Presented and explained proposals, reports or findings to understand and improved the overall traffic to the website by 20%.

• Built prototypes and designed working modules for the company’s dream project-‘Discover’ Software Engineering Intern, Bharat Heavy Electrical Ltd. Hyd, India ASP.NET Oracle Mar’15-May’15

• Analyzed and monitored the Software Asset Utilization Monitoring System (SAUMS) to determine, recommend, and plan instillation of a new system and huge modification of an existing system

• Developed software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design thereby saving the organization 17% on operational expenses

• Presented reports to manage inventory and usage of CAD Software by each department and the suppliers PROJECT EXPERIENCE

Internal Marks Management System Feb’17-Mar’17

• Transferred inbound data from sources like flat files, Excel (250,000+ rows) into database using SSIS Packages

• Developed a centralized paperless facility that can easily be modified and updated by the staff, improving their efficiency by 50% and reducing the scope of error

• Designed a web based front-end system(PHP/HTML/CSS) that allows the students to access their internal exam scores Social Networking Website (Techies.com) Oct’16-Nov’16

• Full-stack development(PHP/PostgreSQL/HTML5/CSS3) of social networking website with functionalities similar to Facebook

• Developed complex code such as Stored Procedures, functions, triggers, Indexes and views for the application VOLUNTEER WORK

Freelance Websites Events Volunteer-Make A Difference Web Designer-A Free Bird Core-Team Mentor-Becoming I Foundation