Sammury

Experienced Data Analyst professional with a strong analytical background in Compensation Industry utilizing SAS applications and protocols. Strengths also include expertise in Executive Compensation Analyst to support HR and consulting services to evaluate and analyze salary data for executive and top management. Proven ability to: take charge of projects identify resolve problems and bringing projects to timely completion serving internal - external clients.

PROFESSIONAL EXPERIENCE

Confidential

Executive Compensation Analyst/SAS Data Analyst

• Perform research, analysis and clean compensation data on executive Long-Term Incentive compensation plans and programs for the Fortune 500 companies.
• Evaluate and Analyze equity awards for Fortune 500 executives and middle management through company peer group, proxy analysis, interviews and executive compensation surveys, to ensure client deliverables in the design, administration and awarded values of long term incentive programs performance based, stock options, stock appreciation rights and restricted stock plans per U.S. Securities Exchange Commission regulations.
• Conduct report preparation and production of big data through the proprietary Global Compensation Databank required for market and client report preparation.
• Support internal executive consultants and external clients with the design of executive compensation programs, benchmarking, market intelligence, and data analysis to ensure company global competitive-ness.
• Product lead performing micro and macro analysis of market data ensuring accuracy and completion of financial, media, energy and pharmaceutical health sciences Global Executive Compensation Surveys.

Data Analyst/SAS Analyst

Confidential

• Created SAS programs and provided reports on complex survey specific Compensation Policies and Practice P P section of Mainline Custom survey line. Convert P P FoxPro programs into SAS.
• Provided P P reports to Report production group using SAS Data Step, SAS functions and Procedure statement like Proc Means, Tabulate, Sort, Format, Report, Freq, SQL, Univariate. Performed in-depth statistical analysis and provided reports on individual surveys P P 's sections.
• Updated SAS Outliers programs, SAS macros and provided results with current year specifications and methodology. Delivered SAS reports scheduled to be published on CompTrack and CompSource Website. Ensured all deliverables complied with Professional Excellence protocols and expectations.
• Volunteered to assist Survey Analyst group with processing and loading submissions into database. Contacted Clients for incomplete or erroneous submissions and followed-up for completion.
• Provide Technical Support to Clients Submission group in handling resolving loading issue and extracting data from online spreadsheet submissions. Assisted survey programmer in survey setup using Confirmit.
• Mapped International Surveys Oracle Data elements to consolidate into Microsoft SQL Server. Support ETL process to facilitate smooth data movement and transformation.

Confidential

Key Entry III Application Programmer/Data Entry Supervisor 10

• Programmed, designed, analyzed and implemented over 35 survey specific programs on KeyEntryIII Application. Supervised and trained 7-10 Data Entry staff and served as resource to new recruits.
• Developed, compiled and implemented new DE Prototype program which consolidated more than 15 programs. Analyzed and debugged any issues or problems encountered during testing process. Develop Reformat program to consolidate multiple tables into single table.
• Managed Front End DE Operations including Data collection, Data elements naming conventions and provided supporting documents. Managed and updated Data Dictionary, provided Database structure and also assisted Database Administrator to create SQL tables on Microsoft SQL server.
• Managed and updated DE Application menu system. Consolidated DE Menu system programs for Batch check operations and final Print Out operations into single programs for optimal output results.
• Supervised, trained and managed existing staffs, help new recruits understand Key Entry III Application System by assigning and prioritizing work and timely completion of survey deadlines.
• Assisted Sr. Software Developer in setting up reports on CompTrack Online using HTML and JavaScript. Resolved CompTrack Online Pre-production bugs from bug-tracker application. Provided Technical Support to internal and external client on CompTrack product.
• Data Entry Supervisor/Backup Operations Technician
• Performed Daily backup operations and procedures, supervised Data Entry Staff members and DE Operations.
• Performed daily backup operations using Backup Exec OmniBack II application on Sybase, HP and desktop computers. Performed ad-hoc backups restorations.
• Maintained backup logs of all backups and restores performed. Responded to tape's or alternative media's mount request. Maintain integrity of library system monitor hardware for problems and malfunctions.
• Ability to work independently and as a team member. Resolve problems and communicate solutions to other team members. Work with software and hardware vendors to troubleshoot and resolve backup issues.

TECHNICAL SKILLS

• SAS: Base SAS, MACRO, ODS, SQL and Procedure Statements.
• KeyEntryIII Software package: Object-oriented Design Programming, Data Model Database Programming.
• QA/QC: QTP/QC/Selenium/Java/SQL/Linux.
• Databases: MS SQL Server/Oracle.
• Microsoft Office: Word, Excel, Access, PowerPoint Outlook.