SUMMARY

• 5+ years of IT experience with Database using SQL, MYSQL, and MS SQL Server Admin, support, Business Administration, Management, Data Analyst and Business Analyst.
• Experience in Microsoft Technology such as Outlook, Excel, Word, PowerPoint, Visio, Planner, Team, SharePoint, and Publisher.
• Experience in Data analysis, Data Warehousing, Data Wrangling, Data Lake and Google Big query.
• Experienced in SQL to creating database schemas, data analysis, T - SQL, writing simple Stored Procedures, index, and performance tuning.
• Experience in data visualization tools such as Power BI and Tableau.
• Knowledge of Java/J2EE and Python development in all phases of Software development life cycle including Analysis, Design, Development, Testing, Implementation, and Documentation.
• Knowledge in UNIX, Linux, Scrum, Agile, Water falls methodology, and Git.
• Experience in using JIRA tools which is mainly used for tracking production issue.
• Experience inSAPHANAStudio, Information Design Tool, CMC, Dashboard, SAP Lumira, designing Information Views Attribute, Analytical and Calculation Views.
• Experience in wine POS System software which using for retail business.
• Able to troubleshoot software related issues on computers, Android, and Apple devices.
• Experience in giving Customer service, Production, and Deployment Support.
• Possesses adequate written and an excellent Communication skill, Strong Analytical, Problem Solving, Interpersonal skills and Quick Learning abilities.
• Highly motivated, willing to work independently and in a team environment.

TECHNICAL SKILLS

• Java
• Python
• SQL
• MySQL
• SQL Server
• Oracle
• Sap Hana
• Lumira
• Power BI
• Tableau
• Outlook
• Word
• Excel
• PowerPoint
• Planner
• SharePoint
• MS Visio
• Quick Book
• Wine Pos System.

PROFESSIONAL EXPERIENCE

Confidential, Linden NJ

Data Analyst

Responsibilities:

• Design database schema, create tables to store data, and perform data manipulation.
• Worked on data analyze and visualize using SQL, MS Excel, MS Visio, Power BI, and Tableau.
• Worked on Data Warehouse, ETL, Data Cleaning, and perform analysis using google big query
• Create interactive dashboards and reports using Power BI, for teams within the organization.
• Maintain invoices records for payments and filing for future data references.
• Used Quick Book to manage accounting functions such as Payroll, Invoice Payments, employee Data, daily reporting, invoices records for payments and filing for future data references.
• Gathering all information and requirements for retail and marketing products.
• Maintain Inventory administration, keep up database records, and keep up worker records, and optimizes website content to achieve e-commerce sales goals.
• Provided technical and process user support functions and software training to staff.
• Assists the team and management with projects and tasks as needed.
• Acts with integrity and trust, modeling behavior that respects our employees, peers, and customers in accordance with the core values of our company.

Confidential, San Francisco, CA

Data Analyst || Application Support

Responsibilities:

• Designed Database Schema and Writing SQL queries, worked with RDBMS concepts for creating database objects such as tables, functions, stored procedures, indexes, views.
• Reported, research, correct, and test defects in reports, and other database related functions.
• Designed and created column store tables, data model, HANA Views to support several business reports based on closed opportunities from Planning and financials.
• Pushing and pulling the code to/from the central Git Repository for code integration and version control.
• Excellent understanding of the System Development Lifecycle (SDLC) and QA Methodologies
• Provide Application Support using Linux, Jira as well as data analysis and visualize using SQL, ETL, MS Excel, MS Visio, Power BI, and Tableau.
• Translated business requirements into functional implementations
• Create custom reports, pivot tables, Advance Functions, VLOOKUP, Macros, and creative charts in the Microsoft Excel.

Confidential, Rahway NJ

Business Data Analyst || Admin Assistant

Responsibilities:

• Experience in Inventory management, maintain database records, Quick book payments and maintain employee records. Used Microsoft Word, Excel, and PowerPoint for data sheets.
• Developed, maintained, and executed SQL scripts/queries and validated completeness, integrity, and accuracy of data. Understand and analyze the business requirements
• Created various types of data visualizations using Python and Tableau. Gathering all information and requirements for retail and marketing products.
• Maintain updated noledge of company products and services to better provide customer support and service solutions.
• Communicated with all team members on issues of mutual concern through meetings, written communication, and tracking systems Assists the team and management with projects and tasks as needed.
• Provide ongoing administrative support to senior executives, driving organizational success through the management of daily operations and special projects
• Manage executive calendars, strategically coordinating meetings, appointments, events, and travel arrangements

Confidential, Newark, NJ

Office Administrator

Responsibilities:

• Created and managed student data, assist phone calls, guided students in the admission process, addressed transfer and fees related questions. Preparing a daily report about the offices
• Looking after the budgets of each department, Design and implement budgets for different departments, Delegation of responsibilities to the other staff members
• Conducting meetings with the employees where they can voice their grievances

Confidential, Union NJ

Office Assistant/IT Tech Support

Responsibilities:

• Provided business-clients with efficient support - Responded to phone calls, emails, and in-person requests. Instructed and trained end-users regarding computer literacy.
• Installed software, configured, and tested customer PC’s, analyzed functionality of peripheral appendages, Serve as a frontline communication for the office.
• Worked closely and TEMPeffectively with vendors to replace/repair defective hardware and software.
• Ran routine phone troubleshooting and configuration. Resolve office-related malfunctions and respond to requests, Maintain trusting relationships with suppliers, customers, and colleagues

Confidential

Production Analyst

Responsibilities:

• Experience in Manufacturing Products, retail & marketing of quality products. Coordinate with vendors for retail pharmacy and hospital requirements.
• Providing Product innovation support to the production team. Analyze consumption and production rates and determine production efficiency.
• Attend weekly meetings to discuss about production issues and updates. Monitor the execution of production plan and identify deviations. Communicate production status and error updates to management on regular basis.
• Evaluate issues, analyze root causes, and derive solutions. Generate production reports for management and customers.

Confidential

Pharmacy Technician

Responsibilities:

• The manipulation of pharmaceutical apparatus in common use. Experience in reading, translation, and copying of prescriptions including the checking of doses.
• Review patient profile and dispensing medication prescribed. The dispensing of prescriptions illustrating the commoner methods of administrating medications and the storage of drugs and medicinal preparations.
• Inventory management, reviewing patient chart and dispensing medication prescribed. Maintaining patient’s prescription records.