SUMMARY:

• Results oriented IT professional with a strong capacity to adapt to new situations quickly. Work well under pressure and consistently meets all imposed deadlines.
• Strong analytical skills and knowledge of database concepts as well as ability to apply professional principles to effectively summarize the data. Possesses excellent inter - personal and communication skills.

TECHNICAL SKILLS:

ERP: SAP R/3

Operating Systems: Windows 95/98/NT4.0/2000/XP/Vista/7/10, Access Database, AS/400

Technology and Tools: MS Excel 2003/2007/2010/2016 (Office 365) advanced Formulas and functions, writing macros/excel programming, Pivot Tables, V-Lookup, etc., SQL,PowerPoint - assembling and publishing dashboards, hyperlinks, CA Clarity PPM, IBM Cognos, Tableau Server, Oracle Instantis Enterprise Track, Alteryx, HeidiSQL, Teradata Studio Express, MySQL Workbench, ODBC connectors, MBOX, Cloudera Hadoop, HUE, Amazon Redshift, S3 Browser, STS, ACCPAC(SAGE).

PROFESSIONAL EXPERIENCE:

Confidential, Plainsboro, NJ

Sales Operation Data Analyst

Responsibilities:

• Responsible for maintaining a database system that supports complex contract pricing plans and obligation
• Downloading monthly GPO rosters and validating GPO to ensure accurate GPO fees.
• Analyzing and reconciling large sets of data (roster/pricing list) in Excel and Access.
• Managing and consolidating customer demographic account information in sales reporting database.
• Partnering with cross-functional team members like marketing and sales operations to provide analytical support
• Administering, extending, modifying and terminating contracts
• Preparing sales analytics as needed by corporate accounts and senior sales management
• Processing of contract documents and information for subsequent review and approval by sales

Confidential, Morris Plains, NJ

ITIS Report Developer/ Data Analyst

Responsibilities:

• Perform a variety of reporting, data quality, validation and data analysis activities in support of Global Portfolio Management PMO team.
• Creating & modifying reports in Business Objects Web Intelligence, Tableau, SQL, and Excel tools.
• Maintaining scheduled report jobs in Business Objects Web Intelligence and Tableau server.
• Performing ad-hoc reporting using BO Web Intelligence, Tableau, SQL and Excel tools.
• Providing data validation/correction in Clarity PPM, Oracle Instantis Enterprise Track tools.
• Designing and formatting reports to provide consistency and ease of use.
• Reviewing and validating reports for accuracy.
• Developing dashboards & metrics for leadership.
• Creating integrated analyses from multiple data sources like Alteryx, BO Web Intelligence, Teradata Studio Express, Cloudera Hadoop, Tableau and Excel tools.
• Data manipulation in Excel, pulling/validating data with SQL
• Working with stakeholders to gather report requirements.
• Documenting report functions and procedures.
• Administrative tasks related to Business Objects and Tableau server access rights
• Administrative tasks related to SharePoint site maintenance.

Confidential, Newark, NJ

Report developer/ Workforce Analytics Analyst

Responsibilities:

• Responsible for collecting and analyzing HR data and metrics to identify important trends.
• Developing and reporting of analytic summaries.
• Performing workforce analytics (leading/lagging indicators) and other ad-hoc reporting, including consolidating data and preparing reports
• In coordination with HRIS technical resources, developing effective reporting solutions that support business goals and objectives.

Confidential, Basking Ridge, NJ

Financial Business Analyst

Responsibilities:

• Reviewing and processing the daily Financial Transaction Data Report generated in MSS for new employees who require an Activity Type Code assignment.
• Processing client financial code change requests within the ONEHR (Oracle) system (Responsibility Code, Cost Center, Activity Type, and MSS FP&A POC updates for 116 Confidential companies).
• Responsible for proper code updating, client notification of completion, and general assistance with coding questions.
• Designing, maintaining and updating client online request log database for tracking Data and reporting purposes.
• Investigating, resolving and implementing via ONEHR, COGNOS and subject matter experts’ client issues related to all of their coding requests.
• All client requests are handled in a timely manner.

Confidential, Raritan, NJ

Data/Reporting Analyst

Responsibilities:

• Provide assistance to members of Global Account Management (GAM) Analytics Team on Ad-hoc projects.
• Responsible for development and distribution of weekly, monthly and quarterly forecast and activity reports to the (GAM) reporting and analytics team using Microsoft Excel.
• Perform ad-hoc data analysis and analytical research, and assist in development of new models and reports.
• Assisting the development of a new metrics reports.
• Responsible for extracting and validating data from various data sources (including IBM Cognos, Clarity PPM and SAP Business Objects - business intelligence) and dashboards as well as posting of reports and presentation to Web Portal.
• Conducted data analysis and presented data in a clear and concise manner.
• Responsible for Weekly reports: Clarity Forecast Extract, Intake Metric
• Responsible for Monthly Reports: Catalog Page Hits, AS (formerly Global Services) Demand Metrics, Partner Demand Deck, Forecast Accuracy, Operations Forecast, GPM Project Load, Forecast Portfolio.
• Responsible for Quarterly Reports: Forecast vs. Actual
• Creating query in Web Intelligence for Data Validation.

Confidential

Sales/Financial Reporting Analyst

Responsibilities:

• Examined and evaluated the purpose and content of business reports to develop new or to improve current use and control.
• In charge of reviewing reports to determine basic characteristics, such as origin, report flow, format, frequency, distribution and purpose of the report.
• Also part of the team that recommends new reporting methods to improve content and completeness of information in the reports.
• Assisted senior analysts by preparing and issuing instructions concerning generation, accuracy, timeliness and distribution of reports according to new or revised practices and procedures.
• Build/Maintained Access database with Oracle mapped tables (ODBC) to facilitate import/export reporting process.
• Create queries and retrieve data from a database by using SQL
• Provide Point of Sales (POS) and Original Equipment Manufacturer (OEM) sales reports to Reps.
• Provide Point of Sales (POS) and Original Equipment Manufacturer (OEM) Access Database updates to Finance.
• Data preparation for CRM Database
• Extensive use of Excel Spreadsheets, pivot tables, graphs.

Confidential

PensionAdministration and Support

Responsibilities:

• Reported directly to the Manager of Pension Administration and was primarily responsible for update and maintaining the pension database containing the census data for over 20,000 plan participants.
• Prepared SAP wage reports, employee data information (profile), pay stubs for research and reconciliation.
• Worked with team members for integration and user acceptance testing issue resolution.
• Tracking/updating HR related expenses into database using Excel spreadsheets.
• Assisted and manually enter new hires, terminations, salary adjustments etc. into SAP.
• Filing, copying, document scanning, database backups.
• Performed various special projects, calculations, and analysis requiring the use of several different software packages and systems, including SAP, PeopleSoft, KWASHA (pension system), and Microsoft Office.

Confidential

Sarbanes-Oxley Data Analyst

Responsibilities:

• As a member of the Sarbanes Oxley project team was responsible for entering, updating and maintaining process documentation and test plans in the company’s proprietary SOX compliance system (TARDIS). Other responsibilities included running ad-hock reports and performing tests of key controls.

Confidential, Mountainside, NJ

Technical Support Specialist

Responsibilities:

• Provided Help Desk Support for various home and office systems including operating systems updates, software updates, network password resets, account management, home drive & mail folder cleanup and LAN/WAN connectivity issues.
• Performed troubleshooting for Windows 95/98/XP/2000, Outlook, and MS Office 2000/2003.

Confidential, Springfield, NJ

Technical Support Specialist

Responsibilities:

• Supported users within Medical Transportation Company.
• Maintained and performed troubleshooting for PC’s, printers and related hardware problems
• Assisted in the administration of day-to-day maintenance of Novell, NT and Exchange platforms.
• Installed, maintained and supported Windows 95/98/2000/NT operating systems and PC Anywhere & VPN communication software.
• Independently maintained and repaired equipment. Made recommendations for replacement of equipment.
• Assisted in product evaluations and made recommendations for hardware and software purchases.

Confidential, Clark, NJ

Technical Support Consultant

Responsibilities:

• Trained users in system, network, and software capabilities and functions. Maintained and updated equipment data base files and/or other hard copy records regarding location, type of equipment, features, serial and model number and other identification codes, etc.
• Responded to client inquiries concerning systems operation and diagnosed system hardware, software, and operator problems.
• Recommended or performed minor remedial actions to correct problems.
• Provided updates, status, and completion information to manager, problem request tracking system, and/or users, via voice mail, e-mail, or in-person communication.
• Supported over 2000 users

Confidential, Piscataway, NJ

Trouble Desk Operator

Responsibilities:

• Worked cohesively with the technical, sales, marketing and other groups within the Company and the Company's affiliates.
• Set up and administrated User and Group Accounts.
• Implemented user rights.
• Installed and configured network printers and network protocols.
• Managed files, implemented data security procedures and performed backups.
• Installed and supported MS Office Suite
• Implemented NetWare connectivity.
• Managed clients and performed downloads and upgrade to keep software current
• Followed up on and resolved open trouble shooting tickets.
• Exclusively supported 100 local and remote network users.

Confidential, Bloomfield, NJ

Technical Support Specialist

Responsibilities:

• Implemented a small peer to peer network,
• Created and maintained system policies/profiles, users and other security for end-users.
• Installed and configured applications (MS Office 97/2000, McAfee Virus scan, I.E. 5.0/5.5, Adobe Photoshop 5.0, Norton Utilities 2000 etc.)
• Created user image by using Ghost v.5 program.
• Performed troubleshooting and diagnosed daily problems and attended to them in a quick and timely a manner to minimize downtime.
• Supported over 200 users.

Confidential, Parsippany, NJ

Field Service Technician

Responsibilities:

• Installed and configured operating systems including Dos 6.22 Windows3.x, Windows95, Windows98, WindowsNT workstation/server and Novell 3.12 client/server.
• Setup and configured office applications including MS-Office97, Norton Utilities8.0, Seagate Backup Exe7.0, pcAnywhere 8.0, Ghost v.4/v.5, McAfee Antivirus and Norton Antivirus.
• Performed hardware upgrades, setup, installations and troubleshooting of CD ROM's, hard drives, NIC cards, modems, ram, video cards and peripherals on desktops, laptops and servers from IBM, HP, Compaq, Toshiba, AST, Sony, Gateway and DELL.