SUMMARY:

IT professional with 20 years of experience designing and implementing practical, cost effective technical solutions for business processes in Life Sciences and Consumer Goods Industries. Recognized for helping customers understand and make use of their structured and unstructured data to improve their processes and inform their decision making. Expertise in SQL and NoSQL databases, business intelligence, data analytics, machine learning, data visualization. Software development experience in R, Python and other programming environments. Ability to interpret large volumes of data to draw conclusions. Experienced in all phases of the SDLC. Exceptional record implementing and driving adoption of business solutions and workforce effectiveness improvements. Track record of delivering on project management, vendor management, clear communications and fiscal management.

TECHNICAL SKILLS:

Programming Languages: R, Python, C++, PL/SQL, JavaScript, HTML5

Operating Systems: Windows, Unix/Linux, shell scripting

Databases, ETL, Big Data Processing: Tableau, MS SQL Server, Oracle, MySQL, MongoDB, KNIME, Apache Spark, Apache Hadoop.

PROFESSIONAL EXPERIENCE:

Confidential, Mount Laurel, NJ

Business/Data Analyst

Responsibilities:

• Provided Business Intelligence and Financial Analytics to managers and business users of Enterprise Real Estate division of Confidential . Created models for Cash Flow Reporting. Presented results and recommendations to senior managers.
• Designed and developed visual dashboards using Tableau (“Cash Flow Dashboards”, “Regional Managers Dashboard”, “Financial Tracking”, etc.)
• Educated and trained business users on best practices of data visualization.

Confidential, Whippany, NJ

Business /Technical Analyst

Responsibilities:

• Executed transition of selected applications for Confidential (MCC) IT of Confidential - Confidential integration. Partnered with Commercial business and IT to facilitate every aspect of the IT transition experience.
• Managed the Digital Marketing rebate campaign for wireless Dr.Scholl’s Custom Orthotics Kiosks - worked with business and third party vendors to provide wireless networking of in-store kiosks, the capture of logs in the field with mobile devices and integration of e-mails with company’s customer database, measurement and tracking metrics for the campaign (R, Oracle/Tableau).

Confidential, Summit, NJ

Applications Lead

Responsibilities:

• Managed applications within MCC Global Sales and Marketing organization about 50 countries, including the US. Key applications included Marketing Operations Management, Information Management Data Warehouse, Canada BI Analytics, Wal-Mart Data Warehouse, other Point of Sales (POS) and Business Intelligence (BI) applications.
• Managed the activities of 10-12 consultants in the support of MCC users across a number of departments using various technologies, like Microstrategy, Teradata, Tableau, etc.
• Led the transition of applications from MCC IT to world-class ITIL processes impacting 2500 users. Consolidated support to one outsourced vendor and improved availability 25% The transition allowed 20% cost reduction of operations and support.

Confidential, Summit, NJ

Business Analyst

Responsibilities:

• Managed projects leveraging advanced analytic techniques to provide insight into business areas of sales, marketing, and finance.
• Managed multiple applications, including a large (>15 TB) Data Warehouse (Microstrategy/Oracle) integrated with Wal-Mart Retail Link.
• Project managed MCC shipments data warehouse migration to Linux environment. The project included new integration processes to SAP, Business Objects, GL, Siebel Trade Fund application and Suncare Salesforce network.
• Sales Analytics - Led the implementation of analytics solutions for MCC Wal-Mart team. Successful expanding of Orchestro data warehouse to MCC logistics team to enable optimization of the supply chain.
• Executed the MCC Target POS analytics implementation focused on simplified processes and tools, and reduced finance and IT support cost.
• Forecasting Optimization - Successful implementation of the display forecasting process encompassing 300 sales reps and 6 internal organizations. Gathered and analyzed business requirements and created business and technical documentation based on the SDLC while managing business expectations. Supervised all programmatic development and production implementation and ensured on time, quality releases of system enhancements. The implemented hosted solution eliminated 25% in waste on display production (MS SQL Server, .NET, Python)
• Custom Orthotics Kiosks - Project managed the software development of Dr. Scholl's Custom Orthotics Kiosks. This kiosk with foot profiling technology was the key enabler to building this $20M product franchise.
• Managed the successful project for Kiosks wireless networking.

Confidential, Union, NJ

Lead Analyst

Responsibilities:

• Working closely with business, designed dashboards and reports in Oracle Analytics. Created dashboard and report standards, achieved improvements in performance and effectiveness of Analytics application.
• Designed custom analysis tools in application such as MS Access, MS Excel, MS SQL Server and other software.
• Involved in all phases of development including gathering and analyzing business requirements, translating these requirements into functional and technical designs and specifications, project planning, coordinating development, testing and deployment. Supervised the full lifecycle of the data acquisition to production.
• Implemented complete set of EIM data updates and syndicated data import process (MS SQL Server, C++).
• Led the design and implementation of daily Informatica ETL processes for Oracle Analytics application. Optimized ETL processes for updates of Analytics.
• Designed and implemented various data marts (in a Hyperion Essbase environment) supporting the Animal Health Sales and Marketing organization, and Regional and Product managers

Programmer/Analyst

Confidential, Fair Lawn, NJ

Responsibilities:

• Hands-on with design, development and enhancements of Enterprise Electronic Records system.
• Provided solutions for the application's integration to multiple external customers working with large and complex structured and unstructured datasets.