Bethoon

Sr SAS Consultant/Data Analyst

Email: ac01g5@r.postjobfree.com

Phone: 860-***-****

Summary:

Certified BASE SAS and Advanced SAS Programmer with over 8 years of experience in SAS Module and SAS BI tools on various domains like Banking, Retail and Health.

Experience in Agile software development methodology.

Experience in all phases of software development lifecycle (SDLC) including Requirements, Analysis/Design, Development, and Testing. Formats, in formats and procedures like Append, Sort, Transpose etc.

Expert in working with SAS Enterprise Guide for reporting and analytical tasks.

Implementation of end-to-end ETL Process for IBM mainframe Operating Systems and proficient in using RDBMS from Oracle, DB2, SQL, SQL Server, MS Access, and Excel.

Expertise in generating reports by using different SAS procedures like Tabulate, Report and by using ODS to different output destinations like HTML and Excel.

Generated multiple stored procedures in order to be used in Web Portals and Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS ACCESS, and Excel.

Experience working with UNIX environment & capable of adopting any operating system/environment. Extracted data from different sources like Oracle and Teradata and text files using SAS/Access.

Worked on the Big data Using HIVE. Moreover, Knowledge on python scripting.

Expertise on Data Warehousing, Data Mining and data analysis.

Provide the transformation/Analysis data to Data modeling team.

SQL procedures and created SAS datasets and Knowledge on the data stage. Migrated the data stage project to SAS.

Experienced on the stored procedure creation.

Experienced with insurances claim process.

Experienced with health care codes like ICD9, ICD10, CPT, HCPCS, DRG… etc

Experience in tuning application-using tools like Explain Plan, SQL Trace and TKPROF for high efficiency. Good knowledge of Data integration and migration.

Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.

Validates data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.

Strong knowledge of installation, configuration and troubleshooting of SAS Information Map Studio, SAS OLAP Cube Studio, SAS Information Delivery Portal and SAS Web Report Studio.

Worked on the ETL process in SAS DI studio.

Scheduled the SAS DI jobs using the schedule manger.

Knowledge on the sas management control.

Created complex web reports from SAS data and information maps using SAS WEB REPORT Experience in Base SAS v 8.2/9.0/9.1.3/9.2/9.3/9.4, SAS/STAT, SAS Macros, SAS/GRAPH, SAS/CONNECT, and SAS/ACCESS on Windows and UNIX platforms and competence in carrying out statistical analysis of large-scale data.

Quality assurance procedures of other programmer’s work, validating, debugging, documenting and optimizing SAS programs for QC and QA.

Proficient in creating and maintaining many datasets using ARRAY, MERGE, UPDATE, SET and PROC SQL.

Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities.

Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines. Provide timely and accurate support for Product Management team in their Time lines in Agile environment

TECHNICAL SKILLS:

Programming languages – SAS, SQL, BigData(Hive), WPS, Unix Shell Scripting, Python(Self Trained)

SAS Tools – SAS/BASE, SAS/MACROS, SAS/SQL, SAS Enterprise guide, SAS GRID, SAS DI Studio, SAS Visual Analytics, Big Data(HIVE)

Machines: IBM Mainframes and Windows

Databases – DB2,T-SQL,SQL, Teradata and oracle

Version control –IBM Rational Clear Case, Tortoise SVN and GIT

Job Scheduler – Crontab and ESP scheduling

Automation –Shell scripts (bash, ksh).

SDLC-Waterfall and Agile

Web Data Sources –Google Analytics, Omniture, core metrics and Media math

Reporting Tools –Excel and Tableau

CERTIFICATION:

SAS Certified Base Programmer V9

SAS Certified Advanced Programmer V9

Professional Academy for Healthcare Management (PAHM)

PROFESSIONAL EXPERIENCE:

Client-CIGNA Healthcare, Bloomfield, CT Sep2014 to till date

Project: Incentives and Motivate Me

Sr SAS Consultant/Data Analyst

Worked as a SAS consultant involved in the design, development and technical support for incentive applications projects within the client organization for generating MIS reports and providing data insights and reporting metrics in insurance domain.

RESPONSIBILITIES:

Worked as generally performed in agile environment working on tight timelines at the client's location.

To understand the business rules and provide the rewards for clients and generated reports for aggregate and detailed reports on based on the client request.

Used SAS Macros, SAS SQL, PL/SQL, and BASE SAS for developing application and Repairing Documentation, Flowcharts for the process.

Data analysis, reports using SAS procedures and SAS Macros.

Good experience in deploying SAS EBI software Experience in maintaining a large multi-platform SAS environment it includes SAS Business intelligence tools and SAS application tier.

Worked as ETL developer using the SAS DI Studio in Windows Environment.

Scheduled the jobs in DI studio using the schedule manger.

Developed the Stored procedures and run on the SAS WRS studio.

Developing and Managing projects including designing, coding, implementation and maintenance using technologies such as SAS, MS Office, PROC SQL, PROC FREQ, PROC MEANS, and PROC REPORTS.

Developed SAS Macro programs to create Ad-hoc reports.

Created Macro program to create Macro variables to pull data from DB2 for monthly data extracting.

Extracted data from different sources like Oracle, Teradata and text files using SAS/Access.

Hands-on experience in SAS programming for extracting data from flat files, EXCEL spreadsheets and external RDBMS (ORACLE) tables using LIBNAME and SQL PASSTHRU facility

Passing Macro variables to UNIX server from windows remotely created from windows to develop good user interface for the end user.

Knowledge on PHI and HIPAA Omnibus Privacy and Security Rules.

Experienced with claim process data.

Experienced with health care codes like ICD9, ICD10, CPT, HCPCS, DRG etc.

Create macros to merge multiple tables using hash table, DOW loop and SQL.

SQL procedures and created SAS datasets.

Migrate the data stage reports to SAS

Mange reporting team including SAS Analyst, Report Developers, Data Analysts

Developed UNIX shell scripts to automate new user creation process on UNIX servers

To develop alerts, applications and macros to support the new business logic

To understand and utilize the existing general macros and policy logics

Expertise in transforming data imported from disparate data sources into analysis data structures, using SAS functions, options, ODS, array processing, macro facility, and storing and managing data in SAS data files.

Completely automate the process and migrate the same with the UNIX shell scripts.

Prepared the dashboard and custom reports using the tableau software.

Scheduled jobs in to IBM mainframe using the ESP scheduler.

ENVIRONMENT: SAS/ACCESS, SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH,SAS/SQL,SAS/BI, SAS/Enterprise Guide, DB2,HIVE,Teradata, MS OFFICE, UNIX, Agile, Tableau,ESP scheduling

Company-Data Song, Hyderabad, India Aug 2012 - Sep2014

Project: Visa Pay Wave Cards

Sr. SAS programmer

Worked as a Sr. SAS programmer involved in the design, development and technical support for multiple applications in BI Applications projects within the client organization for generating MIS reports and providing data insights and reporting metrics in banking domain.

As part of data insights team did POC on some of the marketing promotions done by business using A/B testing with provided test and control groups and sometimes creating control groups using survey select procedures.

Involved in Creating MIS reports on huge volumes of transaction data by considering their recency, frequency and affluence as key measures with final goal to create a single reporting solution across the geographies.

Worked with the business users to create the functional specifications and technical solution documents to identify key reporting metrics and measures and to identify the validation plan and approach for the new reporting systems.

Optimized and developed a scalable reporting solution using SAS GRID, SPSS and Hashing in SAS some of which were later migrated in cloud.

Successfully migrated non PII data reports from SAS to Cloud using Hive.

Developed data transformations and ETL processes using SAS DI studio.

Developed presentation and user interface reports using SAS Visual Analytics.

Develop and implement validation codes in the process to make sure data integrity and create summary statistics to validate against other sources with same information.

Scheduled jobs in to UAT environment using crontab scheduler.

Tools and Technology: SAS/BASE, SAS/MACROS, SAS/SQL, SAS Enterprise guide, SAS GRID, SAS DI Studio, SAS Visual Analytics, Hive, SQL, UNIX shell scripting, Clearcase, Excel, JIRA

Company-Data Song, Hyderabad, India Aug 2009– Jul 2012

Project: William Sonoma Retail

SAS programmer

Worked as a SAS programmer involved in the design, development and technical support for ETE application within the client organization using traditional SDLC processes involving in all three phases Development, Testing and Production Support in retail domain.

Involved in developing an application that triggers promotional emails based their behavioral events (web) such as browse, cart, abandoned cart, out of stock and free shipping etc.

Worked with the Marketing promotions team to create the functional specifications and technical solution documents to design and implement Triggered events for emailing.

Developed notification applications using SAS to notify job failures and key data feed health reports.

Designed and developed MIS reports for different marketing channels and sub brands in William Sonoma such as Pottery Barn, West Elm, Pottery Born Kids ...etc.

Analyses the marketing promotion effectiveness by business using A/B testing using test and control groups.

Used SAS pass through facility connect to different data bases like Teradata and DB2.

Created reusable and efficient SAS applications for production implementations.

Scheduled the production jobs using crontab and Debug and technical support to any bugs and issues in the production run.

Tools and Technology: SAS/BASE, SAS/MACROS, SAS/SQL, SAS Enterprise guide, Teradata, SQL, UNIX shell scripting, Excel

EDUCATION:

Master of computer application at JNTUA University in 2009

Contact this candidate