Steve Picciano Email & Phone Number

Hackensack, NJ, US

North Bergen, New Jersey, United States

• Business AnalystResponsible for the creation and distribution of virtually all reports for the organization, which currently has 97 stores. As the sole analyst, I have a hand in operations, sales and merchandizing..
• Built an Open-to-Buy report that allows the merchandisers to see whether they are over or under-bought. The report is over 250 double-sided pages and is automated to print each specific merchandiser’s report.
• Built various reports that measure pertinent metrics such as sales, traffic, shrink, turnover, etc…
• Created the yearly review forms for all stores, pulling data from databases I created and maintain.
• Created a daily report that tracks the order status of all products.
• Re-built a tool to allow allocators and planners to determine to which stores products should be shipped.

Run and send daily sales reports, create and upload submission forms for billing, do general ad-hoc analysis and to help create a contract database so that details of contracts can easily be queried and tracked.

Warren, NJ

• Created and disseminated daily, weekly, monthly and ad-hoc reports for major pharmaceutical company clients; managed large data sets and developed trend analysis reportsKey Accomplishments:
• Analyzed data sets of up to 10 million prescription sales to determine and report retail pharmaceutical customer demographic and sales trends for manufacturers
• Developed a Visual Basic application to save the organization 20 work-hours per month; the application automatically bundled reports and generated emails for clients
• Ensured all outgoing data was HIPPA and FDA compliant

Carlstadt, NJ

• Served as a Project Manager/Data Analyst where I developed reports that facilitated operations and improved performance by allowing the other mangers more time to meet with clients. Supported the Client Services.
• Created a report that measures the company’s adherence to client service level agreements
• Designed an interactive Excel report to view and reject trends by product
• Developed an inventory tracking spreadsheet to monitor inventory levels
• Utilized MS Excel and Access to design various company data sources
• Developed an application enabling company representatives to search a specific HCP to determine approval status of drugs and available client sales representatives

Little Falls, NJ

• Maintained and developed sales and disposition reports and reconciled billings. Provided data maintenance.
• Formatted business leads for utilization by sales force
• Created databases utilizing MS Access and Excel including the development of queries, macros, reports, and forms to monitor company compensation and billing practices
• Created database to streamline quality assurance practices

Clifton, NJ

• Performed ad hoc analysis of sales, payroll, store operations, analysis of return and markdown percentages. Reviewed employee payroll to analyze financial impact and recommend action. Managed storewide inventory and.
• Developed company financial reporting system to analyze net sales activity, operational effectiveness, and comparative sales
• Designed a performance measurement system with benchmarks for store and district managers that determined bonus amounts for mid-year and year-end reviews and provided supervisors with individual and aggregate.
• Analyzed customer service data to determine storewide strategies and trends
• Recipient of the Service Excellence Award (R.O.S.E. Award) for 3rd Quarter in 2006 for analysis and assistance to other analysts and executives