Microsoft Office Data
Resume:
SHIVARANJHANI PALANISAMY
Pasadena, CA *****
https://www.linkedin.com/in/shivaranjhani-palanisamy-243297104
ac1534@r.postjobfree.com
PROFESSIONAL EXPERIENCE
Business Analyst
General Motors, Grand Blanc, Michigan (July 2016 – August 2017)
•Responsible for analysis of key metrics and modeling the relationship of these metrics with the current business to provide actionable/innovative solutions for process and performance improvements
•Developed relevant data queries using business intelligence tools like Toad for Oracle and MySQL Workbench to generate information from machine data sources and other sources like MicroStrategy, MS SharePoint and Salesforce.com
•Created reports and visualized dashboards on both ad-hoc and monthly basis for leadership to help show trends as well as various KPI metrics using Advanced MS Excel and Tableau Software
•Developed front-end applications using MS Access and VBA to help ease of operations for marketing managers and executives
•Forecasted the sales and revenue data for the remainder of the calendar year using historical data to ensure effective resource utilization and task scheduling
•Analyzed existing data to provide insights on basic trends, predict revenue data and detect EWS (Early Warning Signals) for the remainder of the calendar year
•Acted as a Project Manager and collaborated with internal customers, cross-functional teams and off-shore teams to facilitate timely/thorough implementation of project tasks
Operations Analyst Intern
OpenX, Pasadena, California (October 2015 - March 2016)
•Administered Salesforce CRM applications, performed data munging and ensured data accuracy in the company’s internal database platform through the creation and implementation of data integrity queries
•Developed business logics and dashboards containing real-time data generated reports using Shiny server and R Programming to assist Account Managers with business decisions
•Worked on Micro-strategy, R Studio, SQL, MS Excel and VBA to provide reports on BOB Value Indexing
•Performed data analysis using SQL and traced the business activity to provide clear and compelling metrics in the revenue of the company
•Worked on Publisher Scoring reports to indicate the health of clients and to help in the development of ETL process to enhance their performance and increase their revenue value potentially
•Spotted key business insights, trends and opportunities using SQL queries and assisted the team with analyzing the performance of various aspects of the business
EDUCATION
•M.S. in Information Systems, New Jersey Institute of Technology, NJ, USA (May 2015) (GPA – 3.2)
•B.Tech. in Computer Science Engineering, Amrita University, TN, India (May 2013) (GPA – 3.4)
TRAINING
•Online training in SAS (January 2016 – June 2016)
•Independent study on Shiny server (November 2015 – June 2016)
•Completed Coursera John Hopkins R programming certification course (April 2015)
TECHNICAL SKILLS
•Reporting tools : R, Micro-strategy, Advanced MS Excel (Pivot tables, VLOOKUP, Macros), MS Word, MS Visio, PowerPoint, SharePoint(entry level), Tableau, SAS
•Database Systems : Oracle, SQL, TSQL, SQLite, MS Access, Salesforce, Workbench
•Design / Development : VBA, HTML, Axure RP, Shiny, Adobe
•Programming Languages : Java, C, C++ (Academic level)
PROJECTS
Data Analysis of Sample Super Store using R, SAS and Tableau
New Jersey Institute of Technology, NJ (January 2015 – April 2015)
•Analyzed large amount of Wal-Mart’s historical business data for specific instances of risk and spotted key insights to predict the needs of the customers and improve the profitability for the store
•Implemented a market basket analysis using various KPIs (Key Performance Indicators) to recommend products to the customers during purchase
•Devised a K-means algorithm to discover the underperforming regions that required new strategies to generate more revenue
•Formulated a generalized linear model, interpreted the results and generated dashboards containing graphs, charts and maps to display the current trend
•Provided inputs on business actions based on analytical findings and created actionable items to drive improvement in customer experience measures
Development of a Library Management System using MS Office and SQL
New Jersey Institute of Technology, NJ (September 2014 – December 2014)
•Built an enterprise system and a highly secure network for a Library, with the goal of enabling communications between employees and clients; where the network housed 100 devices across various departments such as HR and IT
•Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence
Diagrams, Collaboration Diagrams and Deployment Diagrams, using MS Visio
•Developed the management system with the help of SQL and HTML along with Microsoft Office Suite
Business Process Improvement using MS Visio
New Jersey Institute of Technology, NJ (January 2014 – April 2014)
•Analyzed an SDLC (Software Developing Life Cycle) process using Gap analysis and SWOT analysis along with cost estimation and risk mitigation and restructured the existing process
•Developed a process for ensuring that the SDLC allows for emergency releases to be merged into the main software application
•Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs
•Created Use case diagrams, using MS Visio, by performing Use-Case Analysis on the requirements
•Implemented the structure of the whole process through BPMN model in MS Visio
Design & Implementation of a Public Transport Database using SQL
New Jersey Institute of Technology, NJ (January 2014 – April 2014)
•Developed an easy-to-use web-based interface of a Public Transport and a Travel Booking Database Management System that can be accessed on an electronic device
•Created ER Models, ER Diagrams and Relational diagrams to understand and gather requirements of the transport network
•Used DDL and DML concepts in SQL to create and update databases, tables, index, views, triggers and joins
•Analyzed and defined the high-level needs and features of a particular organization
•Focused on the capabilities needed by the stakeholders and the target users, and why these needs exist
Development of database for a Distribution Business using MS ACCESS and SQL
New Jersey Institute of Technology, NJ (December 2013 – January 2014)
•Developed and implemented database for a Distribution business
•Large volume of information that changes on daily basis creates difficulties in serving customers. Designed the database to overcome the difficulties and managed to maintain the flow of the product from the supplier through the distribution business to the customers
Design of a Social Networking App using Axure RP
New Jersey Institute of Technology, NJ (September 2013 – December 2013)
•Analyzed existing social applications and designed a prototype of a new social networking application for college students which included all the positive features from the previous applications
•Developed a mock of the app using Axure RP
COMMUNITY INVOLVEMENT
•Volunteered at ‘Meekins Garden and Neighborhood Cleanup’ with GM Cares, Michigan (2016)
•Volunteered in constructing wood cabinets out of reclaimed materials at a ‘Habitat for Humanity - ReStore site’ with GM Cares, Michigan (2016)
•Assisted in managing inventory and sales operation at a non-profit organization with Ten Thousand Villages, California (2016)
•Volunteered to help in the construction of a government school near my college with Healthy Youth for Healthy India (2012)
•Helped in organizing a field trip and volunteered as a chaperone for nearby school students with National Service Scheme, India (2010)
Contact this candidate