Alise Seltman

ALISE S. SELTMAN- Lake Road, Greenlawn, NY 11740E-Mail: - Technology, Compliance, HR Benefits and HRIS/HCM professional with a strong background in Data Management, Reporting, Business Analysis, Project Management, and Compliance and HR Systems Design, Implementation, and Maintenance. Successfully completed development, documentation, and management of: SharePoint tool, InfoPath forms, SharePoint workflows, and Access and SQL databases. Effectively completed multiple data conversions from legacy systems to new system. Managed projects, people, UAT, and data (ETL, mapping, conversions, reporting, metrics, KPIs, KRIs, analysis, dashboards, QA, auditing, etc.). Strong experience with requirements documentation and BRDs, process documentation, training, Agile projects and sprints, Wireframes, PoC, ETL, gap analysis, and vendor management. TECHNICAL SKILLS Advanced MS Excel (VBA & Macros) and MS Access (VBA & Macros), Visio, MS Project, MS PowerPoint, Word ETL, SQL, Business Objects/Business Intelligence (BI), MS SQL Server, Oracle Developer, Toad, Crystal Reports, Cognos InfoPath, SharePoint, SharePoint Designer (HTML, Workflows, some JavaScript), Wireframes, WebEx, ServiceNow, Quality Center Older Apps: ADP, Taleo, UltiPro, Cornerstone onDemand, Lawson, iVantage, TimePro, OneSource, Salesforce, ProjectOne, Cyborg PROFESSIONAL EXPERIENCE CITIGROUPSeptember 2010 – Present VP, Compliance - Senior Systems/Data/Reporting/BA Analyst/PMApril 2017 – Present Development, implementation, and oversight of the Global Regulatory Change Management Program and Systems. Manage a Regulatory Change Tool for processing Regulatory Changes issued for 675 regulators in over 100 countries Maintain and update tool using SharePoint, HTML, SharePoint Designer and InfoPath; Gather and document system requirements, manage Agile Sprints and Scrum meetings, and log/track user stories on the Agile site; Conduct ETL and PoC; Manage all UAT testing, and data transformation and maintenance; Research and resolve all system issues for Sr Management and other users Manage project for new tool development: contribute to BRD/FRD/Documentation creation; Create SharePoint workflows, current and future process flow diagrams, and UAT test scripts; Manage Agile sprints and Scrum meetings with onshore/offshore developers, all UAT testing, ETL, and meetings with Sr Management to review documents and obtain feedback Oversee SharePoint site storage limits, request additional space (as needed), and manage entitlements Create Key Performance Indicators (KPIs)/Key Risk Indicators (KRIs) Dashboards, State of Compliance (SOC) Reports, and Ad-Hoc Reports; Conduct QA, UAT, Data Sampling/Auditing, and Data analysis; Present findings to Senior Management Reduce Risk by participation in development and reengineering of the Regulatory Change Process (RCP) Implement automated SharePoint, MS Excel, MS Access solutions; Develop Access database to replace manual QA process Present at strategy meetings with Senior Management, and regular Regulatory Change Coordinator (RCCs) Create process/procedure/training documentation; Communicate to/train Senior Management and regulatory change participants VP, Compliance - Senior Technical/Metrics/Data Analyst/PM/Senior BAJune 2014 – April 2017 Managed various technology databases and data projects, documented requirements and processes, and created BRDs and CRs Worked with Senior Management and other Compliance professionals in over 100 countries while managing the monthly AML Suspicious Activity Reporting (SAR) data process: compliance, collection, compilation, processing, analysis and reporting Conducted data analysis, and created metrics and dashboards for CAPs owned by the Chief Compliance Officer and his Directs Coded SQL queries to perform ETL and convert and align data-sets from multiple data sources to Assessment Units (AUs) Processed entitlements and access to databases, SharePoint sites, and Risk Assessments for all of Compliance at Citigroup Facilitated weekly global AU strategy meetings with Senior Management and onshore/offshore developers Developed Access and MS SQL Server databases to manage data, conduct analysis, and develop reports for Senior Management Participated in the system architectural review/design for all systems projects: created and maintained diagrams/documentation, provided design input, conducted initial review of CRs/BRDs/MDDs, and backed-up Senior Management for final review and sign-off Wrote UAT test scripts for Portal Projects, conducted tests, and provided sign-off Worked with Senior Management while handling project planning/development of the Compliance SharePoint Portal Designed and created Compliance Team’s SharePoint portal pages using Wireframes, HTML, SP Designer, and some JavaScript CONSULTANT - (through Princeton Information) Senior Global Technical Business Analyst/PM-Senior Data AnalystSeptember 2010 – June 2014 Citigroup Private Bank (CPB) - SQL and Business Intelligence Compliance/AML/Risk Data Reporting/System Management. Managed projects, and documented Global Business/Technical/Data/Reporting requirements and changes to code and processes Created Wireframes; Provided Wireframes and requirements to local, remote, and offshore developers Coded complex SQL and Business Intelligence (BI) queries, reports, and metrics for: Compliance/AML/Risk Senior Management, BI audit/regression tests in UAT/PROD, and data mapping and comparisons between systems during UAT and post Production phases Created Global SQL queries, compiled results from regions, and provided data, metrics, and/or dashboards to Senior Management Assisted Senior Management, and other users with BI report issues, and created ad hoc BI reports for Private Banking BI end-users Coordinated Global system enhancements with all regions and provided offshore dev team with system enhancement requirements CitiKYC Project (create one global KYC system throughout all Citi’s LOBs) and In View Project (Web and Mobile Banker/Client app) Met with stakeholders and SMEs to gather/document business requirements, created user stories, managed Agile Sprints Produced/maintained BRDs, FRDs, CRs, etc. and obtained signoffs from Senior Management, Legal, Compliance, and Business Created and maintained CRs for each Business Requirements in Quality Center, and conducted UAT and post-production testing Developed current and future process flows and defect tracking documents, and conducted/documented gap analysis CLIENTS INCLUDE: Verint Systems, Sesame Workshop, Leviton Manufacturing, Teach for America CONSULTANT - Technical Project Manager / Senior Business Analyst / Senior Business Systems AnalystJuly 2008 – August 2010 Managed multiple HR technical projects, and worked with Senior Management/Stakeholders from many lines of business Met with Senior Management and Stakeholders and SMEs to document high-level business requirements Created project plans using MS Project, ran weekly meetings, delegated tasks, updated statuses, and resolved any issues Ran reports, created dashboards / metrics / graphs, and developed electronic forms using InfoPath Used MS Excel to perform compensation & bonus calculations, data analysis, data audits, data transformation, and data mapping Used requirements to create current and future processes flows using MS Visio Worked with HR System vendors to resolve system issues and enhancements Developed technical specifications for vendors; participated in vendor demos and managed vendor relationships Conducted and documented vendor research (including Gartner research); Presented research findings to Stakeholders ASTADIA, INC. (Management Consulting Firm specializing in OnDemand, SaaS system implementations) Technical Project Manager / Implementation ManagerNovember 2007 – June 2008 Assisted corporate clients through the implementation process of Cornerstone onDemand and Team Manager applications Met with Senior Management and SMEs to gather and document business requirements; Created process flows using Visio Conducted Business Analysis, Kick-off, Configuration workshop, and weekly team meetings during the implementation process Created PoC and customized branded portals for each client Setup and tested system for clients, trained client project team on system, and created training for end-users Developed implementation tools/documents for team using Visio/PowerPoint B.R. GUEST LLC (Large Restaurant Management Company), New York, NY Director, HRIS and Benefits/ Technical Project ManagerMay 2007 – October 2007 Managed the HRIS and Benefits functions for 2000 employees in 15 different locations (NY, Chicago, Vegas) for this restaurant management company. Presented system recommendation to Executives Project Manager/Business Analyst for HRIS implementation; Lead system selection process; Analyzed business needs/requirements Developed reports using Crystal, SQL, and Excel; Researched and resolved all system issues Overall responsibility for system changes: New Hire, Change, and Separation paperwork for all restaurants Managed HRIS and Benefits functions and team, and handled all Benefits issues Implemented and administered all employee Benefits METLIFE (through SPHERION CONSULTING), LIC, NY CONSULTANT – Technical Project Manager / Senior Business Analyst February 2006 – May 2007 Managed global HR and compensation technical projects and project plans for all regions while working with Global Executives Created various advanced spreadsheets: budgeting, data analysis, cost projections, informational, etc. Helped develop Visio Organizational Charts and PDF Job Descriptions for 17 Global offices Created data collection Spreadsheet for the UK, and used spreadsheet to create Database; Developed process flows; Trained users Developed an Expatriate Assignment and Compensation Database in Access; Developed process flows; Trained users JENNISON ASSOCIATES LLC (Asset Management Firm - SUBSIDIARY OF PRUDENTIAL), New York, NY Project Manager / Senior Business Systems Analyst / Sr. HRIS & Benefits AssociateApril 2003 – October 2005 Managed HRIS, Benefits and Compensation Analysis functions for this Asset Management Company Managed HRIS and Benefits Team; Project Manager for UltiPro ASP full life-cycle HRIS implementation Lead system selection process, presented system recommendation to Executives, negotiated contract; implemented system Conducted Business Process and GAP Analysis Directed project team, conducted process and system analysis, performed data mapping and conversion, setup and tested system, wrote technical specs, and worked with vendor to resolve implementation issues Loaded data and application updates onto Backup Server including entering and running SQL commands Assisted with setup and testing of Ceridian Payroll and Tax Services Ran 6 live system parallels; Audited and corrected all data between the systems; Trained Payroll staff on Payroll process Conducted data analysis using MS Excel, MS Access, Cognos, & ReportSmith Created a Compensation database and planning reports using MS Access in order to simplify the year-end Comp process Calculated severances, conducted Adverse Impact testing for AAP and EEO compliance, and provided data and analysis for AAP Managed all Benefits functions: Medical/Dental, Transit, FSA, 529 Plan, Life Insurance, STD/LTD/Maternity/FMLA, Workers’ Compensation, Retirement, COBRA, Compliance, bills, cost analysis, reporting, government filing, contract negotiations, etc. CLIENTS INCLUDE: Christie’s Auction House, PepsiCo (BSG), Edison Learning, Ambrose PEO, Enablevision CONSULTANT - Senior Business Systems Analyst / Technical Project ManagerOctober 1999 – October 2002 Assisted with completion of Christie’s Phase I of Global HRIS implementation from ADP Help-Desk support/system issues resolution (logged into Test Director, researched, called vendor, followed-up to completion) Set-up system, conducted data analysis and validation, created reports/queries, and ran weekly meetings with Global team Lead Pepsi’s migration from Merrill Lynch’s legacy platform to Merrill’s Option Choice platform for ESOP plan. Analyzed current and future data feeds to and from Merrill, mapped data, conducted a Gap Analysis, and identified discrepancies Defined changes to new platform, and determined potential programming changes, project cost, and need for resources Created Process Flows of current and future processes Developed reports and Queries in MS Access, SQL, and Business Objects to compare and verify data Conducted full life-cycle implementations of Lawson system at Edison Learning, Ambrose PEO, Enablevision clients Project Manager: Managed staff/project team/consultants; Conducted Business Process and GAP Analysis; Designed Process Flows; Created and maintained project plan; Facilitated weekly meetings; Analyzed and maintained budget Handled ETL (converted date from legacy systems into new Lawson system) Managed vendor selection process, negotiated contracts, and maintained relationships Worked with SMEs to conduct business needs analysis; Wrote technical specs for IT to develop vendor interface Wrote documentation; Setup, tested and maintained system; Managed data validation process Configured and customized Web based Employee/Manager Self Service using HTML Created customized branded portals for over 350 clients using HTML and JavaScript Worked with NetASPx to implement their ASP solution Created reports and queries; Analyzed data using MS Excel and MS Access Developed training for users, and conducted “train-the-trainer” sessions GREY ADVERTISING INC. (Advertising Agency), New York, NY Systems Project Manager /Assistant Manager, BenefitsNovember 1997 – October 1999 Project Manager for large scale, full life-cycle, multi-year implementation of a corporate wide HRIS system (Cyborg), HR Intranet/Internet, and Employee Self Service Setup HRIS tables and tested system, created HRIS reports, developed training materials, and trained users Managed Benefits staff, and all Health & Welfare and Retirement plans Performed Benefits/Compensation research and analysis; Prepared Severance and Benefits cost analysis Researched and selected vendors; Negotiated contracts/rates renewals; Implemented new Benefits plans Handled Employee Relations issues, and directed a variety of HR, Wellness, Benefits, and Compensation projects ANDERSEN CONSULTING, LLP (Management Consulting Company), New York, NY Benefits Analyst January 1997 – November 1997 Managed Benefits Assistant and all Health and Welfare Benefits Processed and tracked FMLA, NJ FLA, Maternity, STD, and LTD claims; counseled employees on state/federal entitlements Designed and presented Benefits training for large HR staff and conducted weekly orientations of up to 100+ employees Reviewed and approved processing of all Workers’ Compensation and ADA claims Worked with Vendors and Third-Party Administrators daily EDUCATION State University Of New York At Albany - Bachelor of Arts Major: Psychology, Minor: Organizational Communications, 16 credits Technology Classes Suffolk County Community College – Associates Major: Business Administration Coach Training Alliance – Certified Coach Training Program New York University – coursework in Project Management Business Analysis Hunter College (continuing education) – Web Classes (HTML, JavaScript, Unix, Linux, SQL, etc.) Queens College (continuing education) – Certificate – Microcomputer Programming New York University – HR Classes (Introduction to HR, Recruiting) Udemy – Agile Crash Course