We provide IT Staff Augmentation Services!

Sr.sas Developer Resume

3.00/5 (Submit Your Rating)

Irving, TX

SUMMARY

  • Certified Base & Advanced SAS Professional with 8 years of working experience in HealthCare, financial, insurance and Pharmaceutical industries.
  • Have extensive experience in SAS programming on different platforms - Windows and UNIX, also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing and data validation.
  • Ability to turn business requirements into Technical Design specifications and documents, SAS Programs, and SQL Queries related toquantitative, statistical andfinancial models. Capable of working with cross-functional teams to manage projects, determine prioritization, and create appropriate timelines.
  • Experience in Data analysis and Reporting in health care, finance and marketing sectors. SAS experience includes detailed knowledge of statistical analysis of financial and health care data and in the production of reports and tables.
  • Primarily worked on Predictive modelling in financial and Medicare and Medicaid in HealthCare
  • Experience in SAS/BASE,SAS/EG, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
  • Developed new or modified existing SAS programs to load data from the source and create specific datasets.
  • Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting.
  • Performed data analysis on the datasets using PROC PRINT, PROC SORT, PROC TRANSPOSE, PROC MEANS, PROC SUMMARY, PROC TABULATE, PROC UNIVARIATE AND PROC FREQ.
  • Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
  • Performed Data management like Merging, concatenating, interleaving of SAS datasets using MERGE,UNION and SET statements in DATA step and PROC SQL.
  • Experience in using SAS to read, write, import and export to another data file formats including delimited files, spreadsheet, Microsoft excel and access tables.
  • Worked closely with Business users in gathering the requirements for project documentation and generated reports. Involved in all stages of SDLC (Software Development Life Cycle).
  • Ability to work in self-directed environment and very good team player with excellent analytical and problem solving skills
  • Worked extensively with SAS on UNIX, Windows and Mainframes, SAS Enterprise Guide, PC-SAS.
  • Professional Experience with Import Various External Data Files into SAS Dataset, working with large datasets and business applications by Using SAS/ACCESS, SAS/INFILE, SAS/IMPORT, SAS/SQL.
  • Extensively worked on various RDBMS like Oracle and SQL Server
  • Extensive Experience in arranging and participating in meetings with Business Users, Managers and suggesting recommendations for improving system performance.
  • Worked in Production support, Development, Technical project requests, Enhancement, implementation support, post-production batch monitoring and Client issues for all supported applications.
  • Develop project plan, work-breakdown-structure, metrics, tasks lists, action items, Identify critical paths. Understand and define priorities and milestones.
  • Proven skills in efficient processing of millions of records of data, optimizing SAS programs forbetter performance. ETL process design, Analyzing, Reporting and migrating Data from multiple platforms/databases using SAS,NDM and SFTP. Statistical distributions and calculations.
  • Thorough Knowledge and experience in Microsoft Office tools like MS Access, MS SharePoint, MS word, MS PowerPoint, MS Excel.
  • Excellent working experience in tools such as INFOMAN, Maestro, Autosys, Resolve IT and ServiseNow.
  • Involved in different server setups for new projects and accessing destination servers on various operating systems such as Unix, Windows and Mainframes.
  • Have knowledge on HADOOP-HDFS, PIG, SQOOP, HIVE,HBASE and MapReduce.

TECHNICAL SKILLS

Operating Systems: Windows 2007, MS-DOS, UNIX

SAS Tools: Base SAS, SAS/SQL, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/Connect, SAS/Enterprise Guide.

Programming Languages: SQL,PL-SQL C, JAVA,SQOOP,HIVE,MAPREDUCE,PIG

Database: Teradata, DB2, Oracle, MS Access, SQL server, HADOOP and Sybase.

Application Software: MS Office (Word, Excel, Power Point, Access).

Scheduling tools: Maestro, Autosys

Special Software: Infoman, Resove IT, Autosys(Work Load Center) and ServiseNow

Domains: Banking, Insurance, Health Care and Pharmaceutical

PROFESSIONAL EXPERIENCE

Confidential

Sr.SAS Developer

Responsibilities:

  • The main responsibilities in this position are to enable process and trend analysis and provide recommendations forthe implementation of new/revised operational and/or reporting processes in Ohio, Kentucky and Indiana.
  • Involved in requirements gathering, Estimation of Efforts,Coding Unit testing, RFC Creation, Cert Implementation and Production move.
  • Classification of reports based on Carsource Advantage Model of Care which involves Enrolment, member, claims, finance, marketing, pharmacy, provider, service operations, authorization regulatory and utilities.
  • Preparation of batch jobs, parameter files, log files, SAS jobs such as control, preparation, formatting, PULL, ETL and Report generation.
  • Developed new or modified SAS programs and used SQL Pass through facility and Libname methods to extract data from the Teradata and SQL Server DBs and created study specific SAS datasets, which are used as source datasets for report generating programs.
  • Made recommendations on new automation opportunities and ways to enhance existing automation tools.
  • Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation.
  • Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL.
  • Converted existingSAScode into high qualitySAScode that is efficient (fast), automated, maintainable, and follows industry best practices.
  • Created SAS Datasets with the usage of SAS MACRO, Macro Variables, CALL SYMPUT.
  • Developed ad-hoc reports using SQL Pass through, libname Statements and PROC SQL to interact with different RDBMS like Teradata and SQL server.
  • Analyzed data using PROC FREQ, PROC MEANS, PROC Transpose and proc univariate to effectively and efficiently coordinate quality activities and improve performance metrics of organizational goals.
  • Extensively used ODS HTML, ODS PDF, ODS RTF to prepare, compile, review and submit monthly and quarterly reports for quality committee meetings.
  • Used SVN tool to commit the new codes for prod implementation.
  • Creation of RFC’s with Implementation document with tagging of new and backout code, test case document and attending cab review meetings to explain the impact of new implementation.
  • Preparation of detailed design and code change document for future reference.

Confidential

Project Leader

Responsibilities:

  • Involved in requirements gathering & Estimation of Efforts.
  • Design Preparation.
  • Interact with assigned business analysts and project managers to perform work outlined
  • Assigning the projects to the team based on capacity.
  • Follow-up with the team and making sure the work done on time.
  • Successfully completed more than 20 development projects.
  • Developed SAS code and SQL’s for Data Extraction and Loading into flat files.
  • Reviewing Unit Test cases to make sure testing is done properly.
  • Conducting Final Inspection & Audit.
  • Working with large datasets and business applications
  • Regular Status meetings with the clients and TCS Managers on the progress of tasks.
  • Sharing of Knowledge with the team members.
  • Tracking and updating the project status by using the CCLM repository.

Confidential, IRVING,TX

Team Lead

Responsibilities:

  • Involved in presenting induction to the new joiners in the project
  • Worked as primary point of contact for all the Production support jobs
  • Resolved all the abends on time and achieved the customer confidence
  • Developed SAS code and SQL’s for Data Extraction and Loading into flat files.
  • Regular Status meetings with the clients and TCS Managers on the progress of tasks.
  • Automating the Job failures/alerts notification process by using the UNIX Scripting.
  • Resolved the abends as soon as received a call from command center.

Confidential

Team Member

Responsibilities:

  • Requirement Analysis
  • Create and review the design documents (both HLD and LLD)
  • Development and Coding
  • Test script Preparation
  • Unit and System Testing
  • Reviewing and Delivering
  • Bug Fixing
  • Conducting Final Inspection & Audit
  • Sharing of Knowledge with the team members
  • Regular Status meetings with the clients and TCS Managers on the progress of tasks.
  • Published the knowledge based documents into Knowmax.
  • Published code snippets in Mighty for automation which avoids re-work.
  • Prepared implementation Documents for Production implementation by Maestro Team.

Confidential

Team Member

Responsibilities:

  • Analyzing the Business Requirements and System Specifications to understand the application.
  • Involved in presenting induction to the new joiners in the project
  • Developed SAS code and SQL’s
  • Automation of run book preparation for support related activities after implementation.
  • Prepared implementation Documents.
  • Involved in Creation and review of test Scenario and test Case based on requirement and design document
  • Interacting with onsite coordinators and clients.
  • IQA & EQA activities in the project and preparing defects log
  • Customizing the existed components to work for the newly created
  • Creation of New Jobs & Schedules for Info quest.
  • Code fixing, testing, tracking all the documentation and code through IPMS tool mapping and following the standards defined in TCS-IQMS.
  • Monitoring and fixing production jobs during batch run.
  • Capturing of requirements for enhancement projects, coding,
  • Unit testing and System testing of the modules.

Confidential

Team Member

Responsibilities:

  • Understanding and Capturing of requirements.
  • Involved in the preparation of high level/low level design documents.
  • Involved in the Analysis, Development and testing phases of the project.
  • Involved in Analyzing and providing the resolution for the bugs raised.
  • Involved in the Unit testing and User Acceptance Testing.
  • Involved in the Resolution of technical issues while testing.
  • Production Support (Dedicated).
  • Worked on Control-M tool for keeping the system healthy and to make the jobs of various environments to run as per the schedule.
  • Creating our own region for testing modelling the UAT regions.
  • Adherence to IQMS (Integrated Quality Management System) by
  • Following quality procedures like IQA (Internal Quality Assurance).
  • EQA (External Quality Assurance) and FI (Final Inspection) for all the deliverables.
  • Adherence to IPMS by entering efforts and logging defects.
  • Adherence to SPEED by achieving goals periodically.

Confidential

Developer

Responsibilities:

  • Analyzing the Business Requirements to understand the application.
  • Prepared implementation Documents.
  • IQA & EQA activities in the project and preparing defects log
  • Code fixing, testing, tracking all the documentation and code through IPMS tool mapping and following the standards defined in TCS-IQMS.
  • Capturing of requirements for enhancement projects, coding,
  • Unit testing and System testing of the modules.

We'd love your feedback!