Resume

Sign in

Microsoft Office Data

Location:
Tampa, Florida, United States
Posted:
January 15, 2018

Contact this candidate

Mamatha is a certified SAS programmer with around 3 years of combined work experience in, data analytics, data management, reporting, and research and development (R&D)

Experience in requirement gathering, analysis, planning, designing, and coding in Windows and UNIX environments. Excellent ability in data query, cleansing, validation and mining

Hands on experience with SQL scripting and querying on RDBMS such as MSSQL Server Management Studio and Oracle.

SAS programming experience and In-depth knowledge on SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ MACROs, and SAS/ACCESS

Strong SAS programming backgroud,in DATA step and PROC step for maintaining and updating existing code, ad-hoc reporting and supporting the reporting functions, and claims processing.

Experience with data extraction from oracle database, MS Office files and flat files using SQL and SAS.

Experience in data transformation by using PROC FORMAT, PROC TRANSPOSE and Arrays. Experience in data combine process by using MERGE and PROC SQL JOINS, OPERATORS

Hands on experience in microsoft office suite including use of excel and access for data analysis and management.

Accustomed to working in challenging environments under deadlines, excellent analytical, and problem solving skills with ability to adapt and learn new technologies quickly

Enjoys contributing to a team effort and creating a good work environment with positive approach

EDUCATION:

Master of Sceince in Chemistry, Osmania University, India

Bachelor of Science, Osmania University, India

CERTIFICATION: SAS Certified Base Programmer for SAS 9 (Certificate#BP055889v9)

TECHNICAL SKILLS:

SAS Skills: SAS/BASE, SAS/GRAPH, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/STAT.

Operating Systems: Windows XP, Windows Vista, Windows 7, Unix/Linux

Databases: Oracle, SQL Server, MS Access, Other Tools: SQL, MSOffice (Word, Excel, Powerpoint)

PROFESSIONAL EXPERIENCE:

Khaitax Technologies - Hyderabad, India Nov ’14 –Dec ‘15

Data Analyst - SAS

Khaitax based in Hyderabd, India support their US and UK based health care clients with analytics including data analysis and data management. These resources support health care business operations from start to finish including reporting tools and automation platform. As a SAS data analyst, My responsibilities in the financial transactions management (FTM) project included Data Extraction, Analysis and Report Generation within microsoft office and SAS envirnment.

Data Extraction and Cleaning:

Developed SQL queries to retrieve required data from servers. Completed extensive data processing and validations using SAS datasets.

Developed programs using Base SAS & SAS/Macros to extract data and create SAS datasets from various sources like Oracle database, Access database, Excel and flat files using Import techniques.

Used macros, stored processes and procedures like PROC SQL, PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE, and PROC REPORTS.

Created large datasets by combining several datasets using inner and outer joins in SAS SQL and BASE SAS merging techniques

Analyzed various tables using data manipulation techniques like Merging, Appending, Concatenating and Sorting.

Wrote Output delivery system (ODS) layout and SAS procedures to create HTML and PDF reports. Created XLS, CSV and PDF reports for healthcare data.

Prepared graphs using the modified data in SAS /GRAPH and PROC GCHART for business analysis. Generated simple statistics of the data using SAS/STAT with PROC MEANS, PROC FREQ

Worked with team members to develop standards for graphical and tabular reports

Prepared PowerPoint presentations using data from SAS programs to explain the results to management at monthly progress meetings.

Arene Life Sciences – Hyderabad, India April ’13 –Nov ‘14

Research Analyst

Arene Life sciences is engaged in development and manufacturing of Active Pharmaceutical Ingredients and Drug Intermediates. As the research analyst, I was responsible for data collection and analysis and documentation of research data and findings for various pharma products under development.

Worked as part of research team to document criteria for development and application of new products. Supported scale up and production implementation of new products.

Maintaining laboratory journals & records as per procedure.

Extensively used Microsoft office products clean up, organize project data.

Developed validation procedures to meet the product development needs.

Performing various ad-hoc analyses of research data.

Developed monthly project reports and presentations for project status meetings

Developed custom templates in excel and word to improve documentation efficiency.

Worked with QA team to review reports and initiate corrective actions if required.

Developed SQL queries to retrieve required data from servers. Completed extensive data processing and validations using macros in Excel and SAS.

Analyzed various tables using data manipulation techniques like Merging, Appending, Concatenating and Sorting.

Vishvodaya Junior College – India June’11–April ‘13

Chemistry Instructor

Taught Chemistry for classes 11 and 12 covering topics from organic, inorganic, physical and general Chemistry. Developed course work, testing material and provided grades. Obtained a success rate of 100% for classes two years in a row. Developed academic projects for students and supervised them. Conducted lab work and assisted students with experiments and documentation.



Contact this candidate