Highly motivated enthusiastic individual with analytical, reporting, process improvement, communication, organization, and project management skills. Experience in the financial services pharmaceutical, healthcare, and technology sectors.
SKILLS TOOLS
Advanced in MS Excel, Access, PowerPoint, Word, Project, Visio, and SharePoint.
Development experience in Business Objects, Crystal Reports, Oracle, PL SQL, Toad, Remedy, MS SQL, Sybase, Informatica, IBM Info Sphere, Data Stage, and Pentaho.
Experience with data discovery, data modeling, data mapping, data quality analysis, and data warehousing.
Knowledgeable in the System Development Life Cycle SDLC .
EXPERIENCE
Confidential
Business / Data Analyst
Supported the Traded Products Compliance / Global Wealth and Investment Management GWIM Technology Department in the development of an Operation Risk Management System.
Conducted front end data comparison to verify data extraction from object-oriented python system to a Java application pointing to an Oracle Database.
Traced source of data discrepancies by analyzing source , staging, and target databases.
Validated the accuracy of daily ETL processing by applying business requirements to source system data using MS Excel formulas.
Identified the impact of calculation methodology changes on aggregated Residual and Inherent Risk Scores at various levels of the process map.
Worked with lead business analysts to identify, prioritize, and manage application defects to resolution.
Participated in testing of concurrency issues and provided documentation to development team.
Profiled replacement issues management system data feed to verify that required columns were included in replacement feed.
Prepared and updated replacement issues management system data feed mapping document during system integration testing.
Developed PL/SQL scripts to support data validation and system integration testing.
Created data dictionary to provide developers a reference for business definitions and data profile details such as possible values.
Confidential
Business / Data Analyst Consultant
Supported Data Governance process for the Corporate Controllers Department.
Identified and documented data quality issues.
Developed tools to identify data quality issues with source system data.
Created detailed file layout specifications for source system data feeds.
Worked with Business Process Owners to documented high-level business requirements.
Prepared functional requirements documents for target system.
Developed SQL scripts to support current operational reporting functions.
Confidential
Business Data Analyst Consultant
Supported the Vendor Management and Governance Departments of Corporate Information.
Worked with contract negotiators to develop reports and processes to track contract expirations, map expirations to renewals to calculate the rate of increases, and confirm contracts not being renewed to support improved accuracy of budget projections.
Validated data feed from Ariba Buyer to Remedy Asset Management system.
Created reports to compare Remedy Asset Management and Altiris Client Management Inventory to identify discrepancies.
Lead project team that conducted Root Cause Analysis into Asset Inventory Discrepancies.
Developed and implemented changes to the company wide Windows 7 Upgrade redeployment process to prevent the creation of new discrepancies.
Created monitoring reports to ensure adherence to process.
Leveraged advanced SharePoint list, library, and template functionality to improve Vendor Governance SharePoint Site Design leading to demonstrable increases in site utilization.
Confidential
Business / Data Quality Analyst Consultant
Supported the Data Governance Department of Business Data Solutions.
Conducted business rules discovery interviews with Key Stakeholders to support development of a comprehensive Data Quality Management Strategy.
Developed Data Quality Metrics to support regulatory reporting requirements.
Aligned existing Data Quality metrics to support process improvement using Lean Six Sigma.
Developed workflows with exception details and suggested values to support Data Quality monitoring and improvement.
Provided training to middle-office data entry staff.
Created Data Quality executive dashboard to support regular reporting of multiple dimensions of Data Quality to senior management and board of directors.
Documented system interfaces and business processes to support Data Quality improvement initiatives.
Confidential
Business / Data Analyst Consultant
Supported the Supplier Management Department of Applications Services.
Conducted business rules discovery interviews with Key Stakeholders to document and develop a comprehensive data quality management strategy.
Documented system interfaces and business processes to prepare an accurate and comprehensive overview of enterprise architecture for senior leadership.
Implemented forecasting model utilizing SAP APO business intelligence and data warehouse analytics.
Prepared demand forecasting and budget projections using MS Excel.
Access impact of divestitures on demand forecasting and budget project activities.
Created performance scorecards using Business Objects to support monitoring activities.
Updated table structure and Oracle PL/SQL Scripts to align Data Marts and Data Warehouse.
Documented and improved logical physical data model to support reporting environment improvements.
Developed cross-functional metrics to support performance improvement using Lean Six Sigma.
Utilized advanced knowledge of statistics to support negotiations of Customer Survey SLA.
Streamlined and automated ETL processing of time data using VBA.
Created MS Access database to support time reporting.
Supported the transition of existing processes to a new outsourcing model.
Worked with operations support areas to improve the applications support and delivery models which resulted in reduced timeframes and improved client satisfaction.
Support the global implementation of the SAP Order to Cash module.
Confidential
Business / Data Analyst Consultant
Supported the service contract department for an environmental services management firm.
Documented logical and physical data model to support system implementation.
Developed reports utilizing existing service data to identify service locations to re-bid.
Negotiated new and existing service contracts.
Researched service availability, pricing, and regulatory requirements in new markets.
Developed a pricing model, utilizing existing client data resulting in a 50 reduction in the lead time for new business proposals.
Created monthly savings reports and process to invoice savings fees to clients.
Managed and resolved service issues to exceed client expectations.
Confidential
Business / Data Analyst Consultant
Accountable for coordinating the environmental compliance programs for an optoelectronics manufacturer.
Developed systems to generate monthly, sales, forecast, and inventory reports, writing routines linking and transforming data from multiple sources.
Designed a materials content database to generate product content datasheets from component level data.
Worked with the sales and engineering directors to coordinate environmental reporting to meet emerging industry standards and client requirements.
Confidential
Business / Data Analyst Consultant
Supported the administration and clinical operations of a 45 million integrated behavioral healthcare delivery system in Northern New Jersey.
Realigned department structure in accordance with Activity Based Costing Initiative ABC .
Prepared quarterly profit and loss statements.
Developed grants compliance reports to monitor regulatory and contractual compliance.
Worked with directors to prepare budgets for new and existing programs.
Created a database for directors to maintain department staffing and monitor staff productivity.
Designed and implemented improved data integrity and validation processes throughout revenue cycle.
Provided systems training and support to administrative and clinical staff.
Performed service and grant utilization analysis by service and location.
Confidential
Business / Data Analyst Consultant
Supported the conversion of the securities trading system for a multinational investment bank.
Prepared reference data for conversion from an in-house AS400 to an integrated ADP vendor system.
Created a system requiring users to enter global account identifiers to generate new account numbers for the New York securities trading system ensuring all new accounts were linked to the company's global system.
Designed systems to track documentation, update settlement instructions, and increase operational controls.
Confidential
Benefits and Payroll Data Analyst
Administered retirement benefits, pension and health insurance, for benefits outsourcing clients.
Managed payroll and Health Welfare system interfaces with clients and vendors.
Maintained employee history and personal data.
Developed Excel spreadsheets and MS Access databases to determine benefits eligibility and calculated benefits payable.
Created detailed systems manual for training purposes.
Tested systems to be implemented to identify technical issues.
Followed through on technical problems to resolution.
Acted as department liaison with IT.
Confidential
Disability Claims Administrator
Administered benefits for integrated group short-term and long-term disability insurance clients.
Coordinated claims resolution with physicians, employers, employees, and in-house clinical team for integrated short and long-term disability clients.
Determined benefits payable and processed payments.
Privacy Policy
