SUMMARY:

• SAFe 4 Certified Practitioner and a certified SFC (Scrum Fundamentals Certification).
• Over 10 years’ experience with Retail Banking Financial, Healthcare, Analytics & Pharmaceutical (Clinical trials) data.
• Proficient in Application Development skills in more than one technology and multiple design techniques.
• Experience with Business System Analysis including in depth knowledge of Software Development Life Cycle (SDLC) and practical knowledge of development methodologies like Agile SCRUM, RUP and Waterfall.
• Experience with both traditional Waterfall SDLC and Agile/Lean methodologies in an Agile/Scrum/XP environment.
• Familiarity with the Agile Framework and Scrum Methodology.
• A good understanding of using Agile Automation Test Frameworks.
• Possess a good understanding of the backlog tracking, burndown metrics, velocity and task definition.
• Well versed in writing User Stories and participating with the team for reviewing the product and retrospective at the end of the Sprint.
• Experienced in test planning, test case development and execution.
• Working knowledge of a variety of technologies and platforms, including legacy midrange, client / server and web services.
• Ability to manage multiple, concurrent projects, activities and tasks under time constraints.
• Familiarity with the Atlassian JIRA and Confluence.
• Provided SAS programming and analysis support with the Membership Extracts, Provider and Claims data for the Healthcare industry.
• Developed applications and provided programming support to Credit Card, Risk Management, Predictive analytics, Profitability analysis, Pricing applications for various Banking clients.
• Experienced working in a role of a SAS Programmer/Developer/Analyst on different clinical phases (Phase 1 - IV) including statistical programming in the Bio-Statistics space.
• Worked on different clinical phases including discovery, pre-clinical and clinical trials.
• Prior experience working with Watson LIMS (Bio-Analytical) and SAP CPCC applications and have worked extensively on Pharmaceutical Sales and Marketing data.
• Familiarity with the SDLC methodology in a pharmaceutical setting and also Post-Marketing or Prescription Data (IMS/NDC) analysis.
• Good communication, teamwork and influencing skills that foster a collaborative and continuous-improvement environment.

PROFESSIONAL EXPERIENCE:

Confidential, San Mateo, CA

Lead SAS Programmer

Responsibilities:

• Worked with Healthcare data including provider, membership details and claims data.
• A good understanding of the core systems, applications and technical platforms.
• Working closely with the IT and Analytics teams using Base SAS v9.4.
• Responsible for modifying, updating and maintaining SAS programs for the organization.
• Responsible for automating SAS programs & modify/validate processes from the legacy SAS applications.
• Providing analysis SAS datasets from data migration including importing raw files from text and excel data files.
• Assisted the team with Validation including program validation and independent programming on a regular basis.
• Generated Adhoc reports in various formats like text, CSV and PDF using SAS Proc Report/Proc Print/ODS.
• Proficient with Base SAS, Macros, Proc SQL and Statistical analysis using SAS statements, functions and procedures.
• Working within the Scaled Agile Framework (Scrum) methodology in support of the project’s PI implementation.
• Participate in the daily standup call and various other meetings like Sprint Planning, Review, Retrospective and the weekly project achievements.
• Working closely with the Scrum Master in documenting the user stories for implementing the Agile Scrum framework.
• Serve as the primary liaison between the IT, business end-users and work with the business to analyze business requirements
• Creating the Business Requirement Document (BRD) and Functional Requirement Document (FRD) by gathering requirements through frequent discussions with the business users and Subject Matter Experts (SMEs).
• Performing the GAP Analysis between the "AS-IS" model of the legacy system and the "TO-BE" model to identify the project gaps and document the standard operating procedures (SOPs) with the support of the SME’s.
• Working with the Quality Assurance Team and Development Team to ensure that they understand the specifications to deliver a quality product to the business
• Supporting the design and the flow diagrams for the Use Case, Class and the Sequence towards project documentation.
• Developing the test cases and test scripts with System Integration Testing (SIT) and User Acceptance Testing (UAT) for supporting the Quality Assurance activities.
• Assisting the teams with the validation of the SOAP requests and responses using the SOAPUI (v5.1.3) Test Suite.
• Supporting the backend testing using SQL Queries and validated the UI values against those present in the database. Used various DML commands like Select, Insert, Inner and Outer Joins.
• Providing a weekly progress status report to the management on a regular basis.

Confidential

Responsibilities:

• Worked extensively with SAS Health care data including provider, membership details and claims (lab) data.
• Created reports based on the Claims (Medical and Pharmacy) pulled using CPT, ICD-9 and NDC codes for various Diseases.
• Analyzed and Validated Medicaid data such as duplicate claims, service after death, multiple service providers etc.
• Updated metadata repository, data extracts and created ad-hoc reports.
• Worked on mapping analysis, updating, data extracts, data transformation, data analysis, testing and data validation.
• Extensively worked with PROC SQL for extracting data from Oracle database and generate reports.
• Create Edit Checks to verify the accuracy of the data.
• Responsible for Validating (Debugging) and resolving production issues on the Eligibility, Claims, Inpatient, Outpatient, Long Term Care and Pharmacy (Rx) data.
• Responsible for production updates (monthly, quarterly and semiannual) by processing client's eligibility and claims data from different carriers through the ETL to Data warehouse.
• Liaised between Data Management group and claims, actuarial, and underwriting business units to design, implement and support business processes.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and scheduling them on a scheduler.
• Used various Proc SQL techniques to update datasets, combine, and join various datasets.
• Created new macros and updated existing macros in the current macro library to improve efficiency of old SAS programs.
• Transforming data imported from external data sources into analysis data structures, using SAS statements, functions and procedures.

Confidential

Responsibilities:

• This position is typically considered as an advanced or a lead level resource.
• Assisting the project team with the designing, analysis, development, coding, testing (validate), and documentation.
• Programming in SAS to the specific business requirements documents and debug issues and log errors.
• Validating and testing all SAS codes for accuracy and efficiency.
• Develop SAS Unix based applications based on functional specifications that will support Marketing Campaign Tools-Retail & Pricing applications.
• The role also involves automating the applications thereby incorporating the required controls.
• Assist the team with the development of the specifications, by recommending alternative solutions to technical problems and programming efficiency.
• Providing programming support of ad-hoc requests and special projects as assigned from the stakeholders.
• Project interactions with business analysts and teams as required for communicating and clarifying the specifications and the resulting reports.
• Proficient in data manipulations including the usage of basic standard SAS statements, functions, procedures and use of SAS Macros along with SAS Proc SQL.
• Experience in bringing large data (i.e. millions of records) from non-SAS (Teradata or Oracle or DB2 databases) data sources into the SAS environment and performing SAS data manipulations.
• Experience in transforming the resulting SAS datasets into specific text file formats, and subsequently being able to manipulate the resulting text files with UNIX commands to include the standard headers and trailers.
• Facilitate and work towards consistent improvement in the development process.

Confidential, Phoenix, AZ

Responsibilities:

• Working in the capacity of a Senior Process Lead for the SLMIR onsite team.
• Provide statistical analysis and work on Predictive analytics on IT Service Management that includes (Incident/Change/Problem/Availability) using SPSS/SAS/other tools.
• Created and validated the related SAS datasets.
• Created and automated monthly reports and analysis.
• Supported the team with analyzing the data and provide the necessary data input.

Confidential

Responsibilities:

• Created Retail, Financial and Risk Management related SAS datasets.
• Created and automated monthly reports and profitability analysis reports for products like annual and 2-year loans.
• Worked with the Risk Management team in building the Risk Score models & Risk Tiers for controlling risks and increase the customer traffic.
• Generated monthly reports using Proc Report and SQL.
• Maintaining existing SAS code, adhoc reporting and supporting the reporting functions.
• Experience in requirement gathering, analysis, planning, designing, coding and unit testing in Windows & UNIX.
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and access tables.
• Experience includes using Base Procedures, Graph, Macros, Data Step, SQL, and Data Mining, extracting internal/external data including cleaning and validation, use of formats and in formats.
• Experienced in producing RTF, CSV, HTML and PDF formatted report files using SAS/ODS.
• Involved extensively in Data Extraction, Transformation, Loading, Analysis, and Reports for Banking.
• Worked in UNIX for File Transfer from one Server to other using SFTP and Winscp.
• Worked on Teradata, Oracle, SQL Server & MS Access Databases.

Confidential

Responsibilities:

• Working with IT & Analytics department on SAS Enterprise Guide v6.1 & Base SAS v9.4 as needed.
• Responsible for modifying, updating and maintaining SAS programs for the organization.
• Responsible for automating SAS programs & processes to accommodate existing and future SAS datasets.
• Providing analysis SAS datasets from data migration procedures including importing raw files from text and excel data files.
• Worked extensively on Summary and Re-conciliation reports.
• Maintained a format catalog in the DEV and PROD environments.
• Assisted the team with Validation including program validation and independent programming on a regular basis.
• Generated adhoc reports and TLG’S (Tables, Listings & Graphs) in various formats like text, CSV and PDF using SAS ODS.
• Proficient with Base SAS, Macros, Proc SQL and Statistical analysis using SAS statements, functions and procedures.
• Developed programming specification documents and Microsoft Visio flow charts for the team.
• Multi-tasking and working with other departments like Informatics for gathering requirements and providing necessary SAS input to the team.
• Worked predominantly in DW (data warehousing) and data store projects with the current assignment.

Confidential, Cleveland, OH

Responsibilities:

• Working with the Data Analytics Group
• Using SAS v9.2 to read, write, import and export data to other data file formats, including delimited files, Microsoft Excel, PDF files
• Maintaining the standard SAS programs and processes.
• Complying with the version changes and updates to facilitate the standard programs and internal practices.
• Experience with Base SAS, Procedures, Macros, Proc SQL programming.
• Running daily and weekly batches within UNIX environment and posting reports on to the FTP servers.
• Produce various specialty product report outputs for adhoc requests for different time periods including daily, weekly, bi-weekly reports.
• Converting raw data into the reading formats for processing the data.

Confidential, Chicago, IL

Responsibilities:

• Working with the Specialty Analytics Group
• Using SAS Enterprise Guide(EG) to read, write, import and export data to other data file formats, including delimited files, Microsoft Excel, PDF and access tables
• Reading in data from CATS, HMI and Rx2000 data sources and perform data analysis
• Experience with SAS includes using Base Procedures, Graph, Macros, Data Step, SQL, and Data Mining, extracting internal/external data including cleaning and validation, use of formats and informats
• Produce various specialty product report outputs for adhoc requests for different time periods including daily, weekly, monthly and quarterly reports
• Working on the Reconciliation report requests
• Experience in producing HTML, RTF, CSV and PDF formatted files using SAS/ODS
• Working with the Access database for data migration and data extracts
• Experience in developing complex SAS Programs, Proc SQL facility, Macros for data updates, data cleansing, and reporting.

Confidential, Boston, MA

Responsibilities:

• Providing a steady state application support to the Confidential Regulatory Affairs department for the content migration from eCTD builder to the recommended eCTD Manager applications.
• Validating and coordinating the eCTD Manager content migration efforts for the client within the Regulatory department and the stakeholders.
• Providing an overview of the imports performed during the day and tracking down any issues for sharing them with the stakeholders.
• Review the import reports and evaluate any errors for low, medium or high category.
• Discussing mitigation steps (business process or application issues) and provide solutions to the team periodically.
• Constitute an action plan for meeting the deliverables in a timely manner and suggest pro-actively any solutions that improve quality.

Confidential, Bridgewater, NJ

Responsibilities:

• Provide SAS support for the client with their Patient Narratives project.
• Working on legacy SAS Clinical databases with over 5 years data.
• Performed mapping, conversion and processing of raw data from various databases like Oracle Clinical & Clintrial.
• Performed edit checks and validation efforts to the programming team.
• Creation of ADS for the Biostatistics.
• Performed data migration to and from SAS data to XML formats.

Confidential

Senior Statistical Programmer

Responsibilities:

• Responsible for processing of clinical data required for analysis of clinical trials for Phase 1-3.
• Generate and QC analysis datasets, summary tables, data listings and graphs for in-house analyses of study data.
• Review programming plan and specifications for datasets and TLFs.
• Familiar with CDISC conventions, i.e., SDTM and ADaM models and hands on experience implementing these models.
• Strong understanding of clinical trial data and extremely hands on in data manipulations, analysis and reporting of analysis results.
• Interacting with client personnel, team members and participating in weekly team meetings.

Confidential, Raleigh, NC

Programmer

Responsibilities:

• Clinical SAS programming for the Data Management and Bio-statistics departments.
• Involved with SAS programming for Phase I - III clinical trials data in various TA’s.
• Developing dynamic SAS programs using Base SAS, Proc SQL and SAS Macros.
• SAS programming for project specific requirements and the CRF (Case Report Form).
• Programming validating and maintaining SAS programs for protocol driven and study specific guidelines in a timely manner for all project deliverables.
• Responsible for the development, production and validation of import/export and mapping SAS datasets and Clinical/data listings for various clients.
• Generating reports in PDF, CSV and XML outputs using SAS ODS (Output Delivery System).
• Developing listings for efficacy and safety data.
• Interacting with team members and Data Management personnel and participating in team meetings.
• Worked on UNIX and Windows platforms with PC SAS and Server SAS environments.