SUMMARY:

• I am an Analytics Lead with twenty years of experience managing the development of custom reporting and analytics software.
• I have a strong technical background myself and have led groups of programmers as a technical lead and a liaison to management facilitating communication between the two groups with documentation (requirements, status reports, etc.) and meetings.
• I have been involved in the development of many complex business systems in both a technical and functional capacity.
• My strong technical background directly facilitates my ability to manage in a functional capacity inasmuch as I can fully relate to the efforts of technical resources.
• For instance, I can accurately estimate the time it will take to develop a technical product because I have spent so much time as a developer myself.
• My development background comes with a good eye for knowing what can be automated and how to automate it.
• When I design a user interface it will have the least amount of human interaction possible while maintaining enough flexibility to accommodate changes in the processes it supports.
• My methods are a result of working on similar projects for different business environments over time.
• That varied environmental experience has given me a bank of analogies that I apply to find success in achieving business goals.
• As a natural evolutionary step for someone who manages the organization and delivery of data, I have spent many hours learning how to find patterns and trends within the data I manage.
• The custom business intelligence tools I have designed and built have significant impact on my clients’ decision making by offering insight into how their businesses function over time.
• By visualizing past performance on key attributes I help making informed decisions regarding likely future state.
• I am lucky to have been employed by people who serve as great role models. I have spent much time working directly with senior executives many of whom I remain in contact with long after our immediate professional relationship ends. From these relationships I have gained a management perspective that compliments my experience as a technical and functional resource, especially related to systems development, data management and reporting.
• I very much look forward to learning more about this position.
• Please contact me for an interview Confidential your convenience.
• Analytics Lead with a specialty in custom automated reporting application development.
• Over twenty years of experience in business systems development.
• Experienced liaison and team lead. Skilled communicator and author of SDLC related documentation.
• Track record of managing complex IT projects and exceeding expectations.

CORE COMPETENCIES:

• Analytics Lead/Technical Business Analyst
• Custom BI/Decision Support/Application Development
• Strong Technical Background (Access, CSS, Excel, HTML, JavaScript, PHP, SharePoint, SQL, VBA)
• Enterprise System Experience: AS 400 Mainframe, Data Marts, JD Edwards, Oracle, SAP, SQL Server
• Database Administration, Data Analysis, Visualizations (Excel, Tableau, PowerBI)

PROFESSIONAL EXPERIENCE:

Reporting and Analytics Lead

Confidential

Responsibilities:

• Built an analytics department for the Project Management Office Confidential company
• Hired, trained and developed a team of analysts delivering products essential to the management of several service lines, including but not limited to: Project Management, Program Management, Cost Management, Design Management, Project Planning, Vendor Management and Operations
• Led daily scrum development meetings
• Developed and implemented a robust reporting system architecture in a challenging security environment
• Interviewed senior management to determine the performance indicators for tracking as keys to our success and built forward looking reports visualizing movement toward our goals
• Led regular meetings focused on identifying and addressing any hurdles to the success of our programs
• Elected team manager for the Operating Committee, an internal organization committed to maintaining a positive work environment
• This is a permanent position

Technical Business Analyst

Confidential, NY

Responsibilities:

• Managed the development of an underwriting workstation for the Risk Management group
• Elicited requirements from underwriting staff and management
• Built a user interface, database and business logic to capture, process and store information related to the quote and bind process
• Centralized data and automated form data to facilitate faster document creation (For instance, type in your name once and it will be on all of your new forms)

Environment: Access, Excel, SharePoint, SQL Server, VBA

Technical Business Analyst

Confidential, New York City, NY

Responsibilities:

• Managed and addressed any client concerns related to reporting or technical issues while training junior staff and maintaining a one hundred percent on - time schedule on a very aggressive development project
• Elicited functional requirements from senior leadership in a highly iterative environment for a custom program management system Confidential a prominent, global financial services company
• Successfully delivered a system giving our client a complete perspective on their program management effort allowing them to focus from projects to milestones to individual tasks, task owners and progress Confidential each level

Environment: Access, Excel, TFS, SharePoint, SQL, VBA, Visio, XML

Owner

Confidential, New York City, NY

Responsibilities:

• Created a technical services company specializing in healthcare reporting systems
• Developed an online portal, including backend database, server-side scripting and frontend GUI development, to help managed care facilities track data for customers, human resources and quality assurance, significantly reducing the manual effort related to regulatory reporting requirements
• Updated the clinical trial reporting effort for a pharmaceutical company by eliminating obsolete information; sourcing newly available data; and building dashboards providing real-time reports Confidential the touch of a button
• Professionally managed various other ad-hoc services for the healthcare industry like updating ICD codes, data migration (especially fundraising), database development and configuration of various COTS applications
• Environment: Access, CSS, Excel, HTML, JavaScript, MySQL, PHP, PowerPoint, SharePoint, Tableau, VBA
• This company was closed

Technical Business Analyst

Confidential, New York City, NY

Responsibilities:

• Automated the creation of a staff awards vetting manual
• Saved hours of effort for this yearly awards program by automating manual ‘cut-and-paste’ practices with VBA
• Authored a technical requirements document outlining gaps so that when anticipated environmental changes occurred, future technical staff would have a head start on creating an even better system

Environment: Access, Excel, SharePoint, SQL, VBA

Project Manager and Technical Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Authored a time and cost estimate and acted as technical team lead and mentor for a team of six developers, on this multi-million dollar, sales benchmarking system
• Mapped data sources and programmatically automated data delivery from various, disparate sources
• Develop algorithms to “drill-down” into data and export custom, ad-hoc reports to reflect trends, patterns and give creative insight into the sales effort
• Acted as a SME and liaison to corporate leadership providing status reports and tracking milestones

Environment: ADO, Data Mart, Access, Excel, ODBC, SQL Server, VBA

Technical Business Analyst

Confidential, Philadelphia, PA

Responsibilities:

• Interviewed industry experts to define requirements for an Anti-Money Laundering (AML) reporting system reflecting the most cutting edge industry trends and current regulations
• Developed a “smart import” function to read in dissimilarly formatted mainframe files, score transactions and automatically output alerts to a team of AML investigators
• Successfully reduced AML analysis staff from a large team of professionals to a single resource and cut processing time from many months to only a few hours - a demonstration was very well received by the United States Office of Currency Control during an audit

Environment: Access, AML, EFT, Excel, SQL, VB