Performed project management and business systems analysis for the following business initiatives, working with senior CA business and IT management.• As part of the Information Management – Chief Data Office team, providing solutions to business requirements by leading a multi-location team of ETL developers, business\data analysts and quality assurance testers to deliver automated reporting and integration for CA Finance teams. • Organized and led projects using the Agile (Scrum) methodologies. Led daily stand up calls with the project team, managed product backlog, and conducted risk mitigation strategies as needed.• Led the project release management ensuring all required documentation, approvals, change orders, deployment plans and schedules were set for project go lives.• Experience in working on Data Lake and Data warehouse based on Azure Cloud and Teradata platforms.• Conducted Impact analysis for new Projects to determine what changes would be required for the downstream systems and data warehouse.• Created customer business views using SQL in the Teradata warehouse for business Finance and Sales Operations personnel.• Coordinate fiscal year changes with source system owners to determine impact to data warehouse as well as moving new objects and data elements to the warehouse for the new fiscal year.• Design, build, test, and implement enhancements to reports for the warehouse to satisfy business requirements and improve the efficiency of business processes. Manage all phases of testing: development, quality assurance and user approval testing.• Facilitated the coaching and mentoring program for the Chief Data Office team for new team members to learn the Business\Data Analyst role and responsibilities. • Led Data Analyst team to adopt MS Talend Data Quality tool for analysis of new data requirements for the data warehouse.• Reversed engineered R-Script program for SaaS subscription-based metrics to be generated from Teradata data warehouse.

• Project managed implementation for Business Objects reporting application for over 400 + users worldwide. • Created functional specifications for dashboards, reports and security administration for finance and educational services users. • Developed reports and dashboards for financial and product related analytics.• Managed and configured the security administration for all users for Business Objects. • Lead BA to coordinate the procurement of new servers to prepare Revenue reporting system to have 3 different environments (Dev, QA and Prod). • Worked with DBA teams to implement databases and security.• Designed security model to designate row level security for users located in different regions and Business Units.• Worked with DBA, release management and application support teams to set up system monitoring and alerts.• Implemented workflows and service desk queues for new user access requests and enhancements.• Created Service Desk Knowledge based articles for users of the system. • Created MS Access database ETL program to automate product hierarchy reporting.

• Implementation of Commissions system for CA Sales Fiscal Years 2006 and 2007 compensation plans. • Designed, implemented and supported a Commissions Interface application that provided CA’s Commissions group with 36 feeds. • Managed the development and QA team for interfaces. • Designed, managed and implemented SAP integration to Commissions system providing HR, contract and billing information for CA’s Commission’s team. • Managed project life cycle and supported rollout of Centive V4 web-based application for 36 feeds providing data for the commission calculations and payments for 3,000 sales employees.

• Responsible for the creation and administration of special custom bonus calculated payrolls requiring the development of special calculations to apply taxing and deductions which were not provided by the current payroll service system.• Designed, developed and implemented timesheet special calculations for multiple state.• Provided payroll reports using MS Access and ADP Reportsmith.• Liason for 3rd party vendors to create file specifications to feed data to 401k and Health Benefits vendors.

Promoted through four levels of product technical support. Supported the sales process through systems analysis, development, and presentation of comprehensive ADP Employer Services solutions to prospects and client base. Researched and developed relationships with third-party vendors to complement ADP solutions. Developed and delivered training on new products and services for the sales force. Created return on investment presentations to deliver to prospect’s senior management.

Supervised a team of technical specialists implementing software and systems for medium sized organizations. Assisted management to determine training needs for Implementation associates. Conducted good will client visits for escalated client issues requiring technical expertise. Provided technical support and career counseling for Implementation associates

Performed conversion analysis for client Payroll/HR needs. Analyzed and programmed unique prospect requirements including Job costing, Customized Union Reporting, General Ledger, Benefit tracking, and interfaces to outside systems. Worked with third-party vendors to design interfaces to non-ADP applications. Monitored clients’ implementation schedules to ensure that installation met targeted completion dates. Conducted onsite software training for clients. Installed ADP software products for time keeping and payroll at client sites. Promoted to Senior Account Executive after one year in the field.

Implemented and modified management reports. Supported clients on ADP time keeping and payroll programs. Created special calculations. Processed amendments for taxes and W2 adjustments.

Supported customers by taking customer payroll, general ledger and tax data over the phone and entering the data into ADP payroll system to generate payroll checks and reports.