Inian Patrick

Senior SAS Data Analyst: Data Warehouse/ETL

+1-651-***-****

adikee@r.postjobfree.com

SUMMARY:

** ***** ** ********** ** IT industry, with the focus in Data warehousing/ETL applications. Enterprising professional with a reputation for exceptional analytical ability and demonstrated success utilizing teamwork and communication skills. Hands on experience in SAS, SAS Macros, SAS EG, UNIX, Teradata, JCL and SQL Tools. Excellent analytical, problem-solving and documentation skills. Team player with excellent Interpersonal and communication skills. An enthusiastic and out-going individual, with ability to interact with the team members and would like to curve my career as a Data Scientist.

Specific Expertise:

Over 11 years of experience in software industry. As a developer worked in various domains including Banking, Healthcare and Insurance.

9 years of experience in designing data warehousing projects including SAS/ Teradata having sound knowledge in Data warehousing Concepts and Tools like Teradata and BASE SAS.

Designed, developed SAS projects, Involved in Debugging and monitoring, and troubleshooting issues/tickets.

Worked on the planning and coordination of work activity for projects involving more than 2 million records.

Experience in SAS programming for auditing data, developing data, performing data validation QA and improve efficiency of SAS programs

Good in root cause analysis using 5 why and fish bone technique.

Explained and validated work results and insight applied to tools used for client analysis and documentation of SAS files and library structures.

Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Unix and PC SAS.

Good Exposure on UNIX Shell Scripting and commands.

Strong experience in SAS Base, Advance SAS, SAS Macros, SAS Procs and SAS SQL.

Strong Quantitative and analytic abilities to analyze and validate data as Data Analyst. Strong problem solving skills, self-motivation and the capacity to work under pressure with tight deadlines and strong attention to detail

Self-motivated and proactive, with attention to detail, deadlines, and good quality control practices

Be proficient in SQL and a visualization tool (Tableau or SAS); a working knowledge of data manipulation in SAS is

Strong knowledge of SQL and Business Intelligence Tools (Tableau, SAS, etc.)

Strong attention to detail, testing to identify defects, and ability to drive remediation.

Strong problem solving skills, self-motivation and the capacity to work under pressure with tight deadlines and strong attention to detail

Self-motivated and proactive, with attention to detail, deadlines, and good quality control practices.

CERTIFICATIONS:

BASE and Advanced SAS Certified Base Programmer for SAS 9

Cognizant Certified Programmer - AHM250(Health Care)

TECHNICAL SKILLS:

Operating Systems

Windows NT, Windows XP/vista/2007/10, Unix

Languages

Shell Scripts, SQL

Database

Teradata, DB2, SQL Server

Data warehouse

SAS 9.4

Browser

Chrome, Internet Explorer, Mozilla

Incident Tracking Tools

BMC Remedy

Version Control Tools

TFS

Internet Technologies

HTML, XML

Other Tools

Putty, WinSCP, Excel, VBA

Project Model

Waterfall & Agile

PROFESSIONAL EXPERIENCE:

Client Name: Wellmark, Des Moines, Iowa July ‘19 – till date

Role: Senior Data Analyst

Project Title: DCM Replacement - Xoriant US Corporation

Project Description: DCM Replacement is one of the critical team which Manage data mapping document and keep business developers and testing team in sync for changes made from DCM to Vue.

Roles & Responsibilities:

Responsible for SAS coding on UNIX, testing, debugging, and creating detailed technical design documents from business requirements.

Work with IT and Business Stake holders team to document business rules and transformation of data from Source to target.

Perform root cause analysis, functional and mapping changes for the issues reported in production.

Perform system and data analysis and provide input to technical solutions. Interact with business and vendors to discuss best practice for solutions.

Create scenario documents and high level process flow diagrams. Interact with Architects to discuss possible solutions to meet business requirements.

Creating mapping documents for dev team.

Technology: SAS, Teradata, Facets, SQL Developer, UNIX, Flat Files, Windows 7

Client Name: JP Morgan Chase, Columbus, OH Sep ‘18 – Jul’19

Role: Senior SAS Developer

Project Title: Deposit Fraud team - Xoriant US Corporation

Project Description: Deposit Fraud team is one of the critical team which monitors suspicious activities across all checking/savings accounts in JP Morgan chase and send them alerts to the customer.

Roles & Responsibilities:

Monitors suspicious activity on “watch/compromised” account list.

Review on-us signature verification including HELOC checks.

Analyzes daily check transactions to identify on-us and deposited items that appear to be fraudulent or unusual activity.

Compare check and deposit characteristics with account history and known customer behaviors.

Notify Branch Operations Managers on deposit holds that should be placed or extended from previous business day activity.

Reviews suspect reports such as daily fraud that will flag duplicate or out of range serial numbers, checks numbers missing, and larger than average or largest dollar amounts.

Notify members on suspected fraudulent activity or unusual activity. Assists member with branch personnel with closing accounts due to fraudulent activity.

Handling P1 and P2 tickets.

Technology: SAS, SQL Developer, UNIX, Flat Files, Windows 7, AutoSys

Employer Name: Xoriant Corporation June ‘18 – Aug’18

Role: Senior SAS Developer

Project Description: This project involves in extracting Healthcare data and Sending reports to the

end user using requirements doc.

Roles & Responsibilities:

Responsible for SAS coding on UNIX, testing, debugging, and creating detailed technical design documents from business requirements.

Provided technical support and knowledge of system availability times.

Performed disaster recovery tests to ensure system availability and functionality.

Analyzing data and providing suggestion for business solutions bases on output results (.csv, .xlsx).

Mentored employees and individuals involved in projects to foster business acumen.

Assisted in streamlining processes to reduce and make daily workload more efficient.

Involved in supporting the team for technical issues in Coding, Testing and Support

Running daily, weekly and monthly batch jobs and monitoring those jobs.

Handling P1 and P2 tickets.

Technology: SAS, SQL Developer, UNIX, Flat Files, Windows 7, AutoSys

Client Name: Citi Bank, Elk Grove Village, IL Mar ‘18 – June ‘18

Role: Senior SAS Developer

Project Title: Customer Data Intelligence – Jelly Update (Xoriant US Corporation)

Project Description: Jelly Update is one of the identified critical reports for which the Data Conversion of CDI is targeted for 1Q 2019. The report production is to be conversion of data in Citi Insight.

Roles & Responsibilities:

Responsible for SAS coding on UNIX, testing, debugging, and creating detailed technical design documents from business requirements.

Deliver results quickly in a fast-paced environment while working on multiple projects.

Report based on Management Reports and Self-Service Reporting.

Maintain a reports library.

Create a common access point across all data/report.

Analyze and identify presence of any bug in system and escalate issues if required and assist all engineers to validate and resolve all bug issues.

Prepare schedule for all test activities and document all bug issues for database and implement all test scripts for various projects.

Technology: SAS, SQL Developer, UNIX, Flat Files, Windows 7, AutoSys

Client Name: Wellmark BlueCross, Des Moines, IA Jun ‘16 – Mar’18

Role: ETL Developer

Project Title: Quantum Reporting Solutions - Cognizant Tech solutions

Project Description: This project Extracting Healthcare Membership Eligibility, Enrollment and Claims data and Sending reports to the end user.

Roles & Responsibilities:

Responsible for offshore deliverables including code, test plans, test cases, test results and weekend support for manual jobs.

Analyzing data and providing suggestion for business solutions bases on output results (.csv, .xlsx).

Interacting with client to understand required document and create technical design document using Visio.

Involved in supporting the team for coding, unit testing and warranty support.

Running daily, weekly and monthly batch jobs and monitoring those jobs.

Technology: SAS, Teradata, SQL Developer, UNIX, Flat Files, XML, Windows 7

Client Name: CVS Caremark, Chennai, India Sep ‘14 – May ‘16

Role: SAS Support

Project Title: Suspicious Order Monitoring – Cognizant Tech Solutions

Project Description: This involves for monitoring the suspicious drug purchased by the customer or drug sold by the stores from the distribution center and outside vendors. So, we need to send out file to distribution centers regarding the purchase details of each drug from all drug stores. In order to perform the above activities on a huge population, batch jobs that run on operating systems were made use along with SAS programs for generating file to share with client.

Roles & Responsibilities:

Responsible for offshore deliverables including code, test plans, test cases, test results and weekend support for manual jobs.

Coordinating with the onsite team.

Mentored employees and individuals involved in projects to foster business acumen.

Performed disaster recovery tests to ensure system availability and functionality.

Assisted in streamlining processes to reduce and make daily workload more efficient.

Attended daily status meeting to follow-up and resolve outstanding group issues.

Involved in supporting the team for technical issues in Coding, Testing and Support.

Technology: SAS, SQL Developer, UNIX, Windows 7

Client Name: Blue Cross Blue Shield of MN Mar ‘12 – Sep ‘14

Role: ETL Developer

Project Title: CARRS – Cognizant Tech Solutions, India

Project Description: This project involves primarily getting the sampling count for the finalized claims from STAR finance for next 3 years. We need to handle both healthcare claims data from STAR & NASCO system and identifying CARRS histories generation either by SAS portal or existing Batch job, this ensures histories will be created for an account claims when process migrated from STAR to NASCO.

Roles & Responsibilities:

Analysis of requirements, converting the functional description to the technical workflow design Involved in user requirement study and development of the project.

Realization of the design into Mainframe-SAS coding

Coordinating with the onsite team

Involved in code review and test cases review

Involved in Project Management Activities to Maintain the Quality

Involved in supporting the team for technical issues in Analysis, Design, coding and Testing.

Technology: SAS, SQL Developer, JCL, DB2, Windows 7

Thomson Reuters, Chennai, India Feb ‘11 – Mar ‘12

Role: SAS Analyst

Project Description: This project involves in extracting Healthcare data and Sending reports to the end user using requirements doc.

Responsibilities:

Report generation in SAS using UNIX platform.

Understanding the SAS errors and by considering SAS LOGS.

Debugging the errors and production the output according to the client needs.

Technology: PC SAS, SQL and Unix

Aon Hewitt, Chennai, India Feb ’09 – Feb ‘11

Role: Batch System Analyst

Project Title: Batch Implementation

Project Description: This project involves generating daily, weekly and monthly reports for enhancing the business and Involved in writing and updating Standard Operating Procedures (SOP) for reviews.

Responsibilities:

Extensive experience in Enhancement, Maintenance, running batch jobs.

Finding the root cause of the failures and providing a solution for it.

Experienced in working with project teams for execution and implementation of software projects

Excellent communication & interpersonal skills

Experience in Report Generation using SAS procedures.

Able to write and develop the SAS code depending up on the Client need.

Great knowledge in understanding the Requirements and work accordingly.

Good knowledge in Data step, functions, statements, Macro & SQL

Technology: SAS, SQL, JCL and DB2

EDUCATION:

Bachelors of Electronics and Communication Engineering from Anna University, Tamil Nadu, India

Contact this candidate