SUMMARY

• Experience in BASE SAS, SAS/SQL, SAS/Macros, Advanced SAS, SAS DI Studio, SAS/ODS, SAS EG, SAS Viya, Reporting, Python.
• Having good experience in Health care, Banking and Retail
• Worked on different operating systems like UNIX, Windows, Mainframe, and JCL.
• Maintenance of large data sets, combining data from various sources in varying formats.
• Assisted leading Banking clients for automating their MIS system by integrating different data sources into SAS using SAS DI studio, SAS EG, SAS VIya.
• Experience in performing adhoc queries and User Acceptance Test (UAT) for various applications and reports on a daily/weekly or monthly basis.
• Well versed with creating HTML Reports for financial data using SAS ODS facility, Proc Report and extraction of data SQL - pass-through, PL/SQL facility. Wide-range experience in data manipulation and generating customized reports with SAS data steps and procedures.
• Have experience on end-to-end process in reporting and generation of analysis datasets.
• Created reusable Macros extensively, used existing Macros, and developed SAS Programs for cleaning, validation, and analysis and Report generation.
• Analysing, Developing, Designing, Implementing and automating the new reports arising out of new specification and reporting requirements.
• Excellent analytical, logical, error debugging and problem-solving skills.
• Experience in credit card strategy and recoveries.
• Good knowledge in Data Warehousing Methodologies, SAS Business Intelligence Tools and Database concepts.
• Automating the process using macros and scheduling the jobs in BATCH mode.
• Strong ability to adapt and learn new technologies, effective team player and have strong work ethics and excellent decision-making abilities.

TECHNICAL SKILLS

OPERATING System: Windows, Unix, Mainframe, JCL

Technologies: SAS, SQL, Macros, EG, SAS DI, SAS VA, Hadoop, Hive, Power BI

DATABASE: SAS, ORACLE, TERADATA, DB2, SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Northbrook, IL

Software Developer

Responsibilities:

• Understand and analyse current business process.
• Understanding business user requirement.
• Development, Enhancement and Analysis of SAS, SQL, TERADATA, MicroStrategy, SQL Server codes.
• Development of Data warehouse and Reports.
• Automation of current business processes.
• Conduct end to end unit Testing.
• Business process documentation.
• Understand and fallow HIPPA (Health Insurance Portability and Accountability) regulatory norms and process RX-CLIAMS
• Follow PBM business and RX-Claims and fallow norms while processing Rx-Claims
• Work on complex and Datawarehouse and RX-Claims process.
• Create a baseline measurement for how the current process works with existing code. How Health care RX-Claims data varies from the actual and implementing necessary enhancements.
• Create complex market models and Segmentation data for campaign management.
• Create and understand complex macros, SAS, SQL, Python and create reports.
• Development, extract and create data reports from Microstrategy.
• Create reports in agreement with the business process stakeholders by designing the report layout, metric definitions and frequency of publishing.
• Perform necessary checks in the code to rule out the possibility of errors before moving to production by testing every component of the code, validating using different data types and ensuring the final output is accurate.

Environment: SAS Viya, Studio, SAS EG, SQL, SAS Macros, Teradata, Oracle, Sql Server, JCL, Tableau, AWS

Client: We Energies, Milwaukee, WI

Role: SAS Developer

Responsibilities:

• Gathering Business user’s requirements from client.
• Understand Current Business flow in Mainframe.
• Migrated from Mainframe SAS to UNIX SAS Environment.
• Develop and enhance Current business flow.
• Conducting end to end testing.
• Crating results and Unit testing results in Both environments.
• Create documentation for business users.
• Involving UAT with business users.

Environment: Mainframe, JCL, SAS, UNIX, SAS SQL, SAS EG

Confidential, Irving, TX

SAS Data Conversion Developer

Responsibilities:

• Understand CSG and DEL documents of PRK data.
• Develop Design Document
• Depends Business requirement Extract PRK data, convert, cleansing, Aggregating, Validating and Loading data on FPRS.
• Develop reports and release business users.

Environment: SAS EG, JCL, Mainframe

Confidential

SAS Developer

Responsibilities:

• Understand Business Requirements
• Analysis of current system did automation of codes in SAS EG.
• Connect ORACLE PLTFORM by BASE SAS and developing and cleaning, validating preparing analytical data.
• Enhance and support Current system by using SAS EG.
• Development and implementation of business requirements in SAS EG

Environment: SAS EG, SAS Macros, SAS SQL, Tableau

Confidential

SAS Consultant

Responsibilities:

• Involved Data Model Changes from Basel II to BASE III
• Creating Detailed Design documents
• DesignedSAS DI Jobs to extract data from different sources like SQL server, MS Excel, MS Access, ORACLE, and TERADATA etc. transform them and then load into Staging Area.
• Creation PROFILES and removing duplicate, data by using DEDUPLICATION in DATA Flux STUDIO
• Profiling data and standardizing data according to business logics in DATAFLUX
• Applying Business logics, Cleansing Standardization and auditing in DATAFLUX before loading data warehouse.
• Designed and developed Jobs by using different transformations and user defined transformations by using SAS DI load intoDimension and Fact tables in Data warehouse.
• Creating Explorations & Reports as per Business Users requirement by using SAS VA
• Design, Build & Test sequencer jobs to run all jobs in sequence.
• Generated Dashboards with Quick filters, Parameters and sets to handle views efficiently.
• Created Triggers, Alerts, Messages, Mails in SASVA
• Loading data into LASER server for data Exploration and Analysis, Forecasting
• Created reports to users in SASVA by connecting various data sources.

Environment: SAS EG, SAS DI, SAS Macros, SAS/SQL, UNIX, Netezaa

Confidential

Sr SAS Developer

Responsibilities:

• Design and develop process according to technical process document.
• Defining rules in SAS Data Flux studio
• Applying rules and removing duplicate data and standardizing, profiling data in Data Flux studio
• Creation of reports and monitoring jobs Data Flux studio
• Create table metadata for source and target tables and create SAS DI jobs to populate the target tables on ORACLE by applying various transformations (SCD TYPE 2 LOADER, SQL MERGE, SPLITTER, SORT, LOOKUP, SUROGATE KEY GENARATOR etc..) by using SAS DI Studio
• Cleansing and validating data as per business requirements
• Deploy Jobs by using SAS DI Jobs on UNIX server.
• Automation of current reporting system and supporting for running process in BATCH mode.
• Responsible to design and development report as per business requirement by using PROC MEANS, PROC SUMMARY, PROC REPORT, PROC TABULATE, PROC UPDATE, PROC FRQ, PROC DATASETS, PROC PRINT, SET and SAS/ODS.

Environment: SAS EG, SAS DI, BASE SAS, SAS Macros, SAS SQL, JCL, Mainframe

Confidential

Sr SAS Developer

Responsibilities:

• Use to generate table, listing and figures using study’s specification and provided input data.
• Use to validate or develop code for live studies and use to review other’s codes as well in role of SME.
• Use to create utilities or SAS Macros and validate those utilities performing on live studies.
• Use to create ADS/TFLs using study’s specification.
• Use to do Statistical Analysis using the ADS and TFLs.
• Member of Recruitment team and use to train new associates for the process and domain.
• Use to train new associates joining the project on Base SAS and guide them for Base SAS certification.

Environment: Base SAS, SAS/SQL, SAS/Macros