OBJECTIVE

To utilize my skills and abilities in impacting the success and growth of a cutting edge company as a SAS Programmer Analyst or SAS BI Developer.

SUMMARY

• Significant Data analysis and programming experience using SAS Windowing, SAS Enterprise Guide and SAS in Unix over 6 years of SAS Programming .
• Strong experience with design, development and testing of programming and analytic code related to healthcare programming analytic activities, projects and deliverables over 3 years of healthcare software programming .
• Experience in SAS Macro Development, SAS Business Intelligence, SAS/ACCESS, SAS/GRAPH, SAS/SQL, SAS/ODS and SAS Stored Process.
• Experience in extracting and manipulating data from Oracle database as well as from a variety of text files.
• Good command of Proc SQL, and experience writing and running SQL code in Oracle PL/SQL and Toad for Oracle.
• Experience performing and monitoring batch job schedules.
• Good interpersonal skills and accustomed to working in challenging environments under deadlines, excellent analytical and problem solving skills.
• Business Domains experience: Healthcare, Pharmaceutical, Technology, and NGO
• Current Technical Skills: Healthcare Data Analytics, Research Programming, SAS Base, SAS BI, Unix SAS, Oracle, PL/SQL, Toad, Unix, Balsamiq, MS Visio.
• Past Skills/Qualifications: Pharmaceutical and Marketing data research, Clinical trials data, Primary and Secondary research, Qualitative Quantitative analysis, SWOT Analysis, Report writing, Power Point slides and business development assistance.

WORK EXPERIENCE

Confidential

SAS BI Developer Health IT

• Responsible for developing customized SAS BI Reports for Fraud Case Alerts Management web application.
• Part of a development team tasked with implementing an integrated and flexible FPS 2.0 BI and Reporting framework to help management and end users access FPS data and interpret it using meaningful quality reports.
• Develop ASR Alerts Summary Reports and PrePay reports and meeting deadlines in a fast-paced environment
• Interface with SAS personnel, QA engineers, business analysts, other developers, and data modelers in implementing mandated case management functionality.
• Assist with other technical aspects of the contract where appropriate and practical.
• Helped create design specification document and develop report mockups based on design document.

Environment: Information Map Studio, Web Reports Studio, SAS EG, TOAD for Oracle, PuTTY, Balsamiq Mockups.

Confidential

Senior SAS Programmer Analyst

• Design, development and unit-testing of SAS and Oracle PL/SQL program code, functions and scripts to efficiently extract, merge and manipulate large volumes of healthcare data
• Research, analyze and calculate quality indicator measures related to clinical topics and conditions across all healthcare settings
• Perform client needs analysis and assessment collaborate with clients and business analysts to identify and clarify program, business and functional requirements
• Perform integrity analysis to identify data quality and integrity issues, as well as random sampling benchmarking and trading of data
• Design reporting templates and create report mock-ups and final reports illustrating the results of analytic and programming processes
• Gather and clarify business and technical requirements with data requestors
• Provide technical and analytic input to analytic team
• Develop adhoc reports and perform data analytics on Medicare beneficiaries
• Experience analyzing and manipulating huge healthcare datasets

Environment: SAS Programming, SAS Enterprise Guide, PL/SQL, Oracle, Unix, Unix shell scripting, Hummingbird Exceed, ConnectionCentral

Confidential

SAS Programmer/Reporting Developer Contractor.

• Work with project developers and architects, responsible for the design, development and implementation of difficult to complex SAS reports and data extracts.
• Develop codes, test, and debug new SAS report modules and make enhancements to existing report modules.
• Perform maintenance on existing report modules and contribute knowledge of underlying business processes and their impact on report data and presentation.
• Write reporting programs according to measures specifications manuals, business requirements and single source files.
• Partially work within the SAS BI Enterprise 9.x platform utilizing an Oracle database and Unix server environment.
• Work partially on integrating and mapping Oracle database/SAS reports to Teradata based IDR.
• Work with the technical staff to understand problems with reports and/or presentation of data and then resolved them.
• Develop report on Healthcare quality measures data for Physician Fee Schedule PFS services provided to Medicare Part B beneficiaries.
• Develop providers' performance reports on submitting Healthcare Quality Data Code.
• Some of the Reports developed include but not limited to Providers Annual Participation Report on quality data in PQRS/ERX Program, Quarterly Individual and GPRO Claims Management Reports, and GPRO Data Submission Report.
• Resolve customer complaints with the report modules and respond to suggestions for improvements and enhancements.
• Contribute to the development and maintenance of report module documentation such as Users' Guides, Training Artifacts or Operations and Maintenance Manuals.

Environment: SAS Base, SAS BI Enterprise 9.x, PL/SQL, Oracle, Quality Center, Unix SAS, Unix shell scripting, Hummingbird, SSH Tectia

Confidential

SAS Programmer Full Time Employee

• CRF data extraction, data analysis and data management from Oracle database.
• Run SQL queries using Oracle SQL Developer.
• Review both paper CRFs and eCRFs to cross check source verification.
• Detect invalid data, validate and clean data using PROC FREQ and PROC MEANS.
• Create customized reports and output using PROC REPORTS and ODS RTF ODS HTML statement in SAS for quick views of eCRF data, and export SAS reports to Excel.
• Review eCRF specifications and data against Study Protocol.
• Write SAS programs to generate the tables, listings and use SAS/GRAPH to create graphs on CRF data
• Perform other ad-hoc work as per Research Center's request.
• Write programs to perform safety and efficacy analysis on patients.
• Produce SAS data sets on vital signs of patients.
• Assist in answering adhoc requests whenever required.
• Serve as a Statistical Programming contact with research sponsors for SAS and statistical programming tasks.
• Developed Data inclusion/exclusion skills on this project.
• Ensure that datasets, tables, listings, and figures are sent to research sponsors within the project timelines.

Environment: SAS for Windows, SAS EG, Oracle, MS Excel

Confidential

SAS Programmer Analyst Contractor

• As a team member of the PMO, worked on an in house client project from Halopharma, a contract manufacturing pharmaceutical company located in Whippany NJ, to build an enterprise level commercial drug product data warehouse.
• Analyzed data on commercial drugs collected from multiple sources to facilitate building a data warehouse for the client.
• This project required creation of multiple small SAS data sets using data from multiple sources to develop a comprehensive data warehouse that were to be used by the management to develop sales and marketing strategy.
• Created HTML, PDF and RTF reports using SAS ODS.
• Imported data from Excel and flat files, and then created SAS datasets.
• Produced customized reports, graphs and tables using SAS data steps and proc steps.
• Contributed to integration of data across marketing research and clinical trials data.
• Validated data and handled errors in data using SAS programming techniques.
• Work also involved some Business Analysis, and gathering Business Requirement from company management, R D, clinical and quality assurance, research associates, sales and marketing managers.
• On this project gained understanding of Statistical Analysis Plan SAP , Standard Operating Procedures SOPs , and project management methodology guidelines.

Environment: SAS for Windows, Excel, PL/SQL, Oracle

Confidential

SAS Data Analyst Contractor

• Analyzed large amount of hospitality data on hundreds of small to mid-size properties of Wyndham group of hotels.
• Ran SQL queries in Oracle database to analyze and manipulate data.
• Wrote SAS programs to performed ad-hoc analysis and data manipulation.
• Created various SAS Reports, Tables, Graphs and Summary analysis on PMS systems being used in these properties.
• Checked for invalid/out of range data.
• Communicated with property managers to verify information and fix invalid data.
• Transferred data from Oracle database as well as MS Excel into SAS for analysis and used filters based on the analysis.
• Used SAS Import/Export Wizard as well as SAS Programming techniques to extract data from Excel.
• Compared data across various data sets and analyzed dimensions of data.
• Used SAS Base programming as well as SAS Enterprise Guide 4.0 to produce various reports, charts and graphs.
• Participated in the technology support team meeting to coordinate, review and determine appropriate hotel property software system for hotel property.

Environnent: SAS EG, Excel, Visio, SQL, Oracle

Confidential

Market Research Associate Full Time employee

• Supported marketing and business development efforts for IT projects.
• Coordinated with sales and professional services, performed consulting business analysis and technology job market research.
• Attended client and sales calls, generated consulting business leads, researched and reported new technology topics and prepared power point presentations that aided in the company's business growth.
• Assisted PMO with project analysis, data analysis, reports and presentations on projects
• Actively involved in generating leads on new business development in IT projects
• Statistical analysis of sales, performance of sales department, reports writing for sales and professional services.
• Researched scope of outsourcing software development and IT business operations in India
• Analyzed contract and direct labor rates with an emphasis on company's profit margin
• Made use of MS Visio and advanced features of MS EXCEL including pivot tables to perform my daily tasks.
• While continuing to be an employee at UCA Services, also worked as a market research intern on part time basis as part of graduate research program at Harris Interactive, a leading market research firm.

Market Research Intern Harris Interactive

• Testing online surveys, developing tabular plans and proofing banners.
• Data processing and analysis using SPSS.
• Participating in team meeting to discuss projects.

Confidential

Associate, Volunteer Statistics and Information Department

• Performed data analysis on various volunteer activities but in particular flood relief operations and blood donations
• Analyzed year-wise distribution of mailers and responders across the country.
• Improved questionnaires and conducted research studies for key opportunities for the Society in the area of disaster relief operations and initiatives that resulted in improved operational/process improvements.
• Data analysis of about 50 flood relief operations and blood donation campaign records that resulted in streamlining the work flow process.
• Compiled training data for hundreds of volunteers to aid the Director of Disaster Relief Operations aimed at expanding the volunteer base and trained volunteer memberships in flood prone areas.
• Helped in streamlining annual disaster assessment reports for more than 10 state level branches
• Used MS Excel and SPSS to perform the above tasks.

Confidential

Marketing Coordinator/Commercial Officer

• Market research analysis on textile industry and covered all aspects of research such as company research based on SEC filings, annual reports, press releases, articles, and regulatory bodies.
• Researched data for cotton yarn and textile export promotions
• Assisted Marketing Head in developing new markets
• Provided regular contribution to the company's monthly newsletter in form of articles/ market insights on yarn exports
• Used MS Excel to perform the assigned tasks.