SUMMARY:

• 10+ years of experience in SAS programming as well as the SAS BI Suite and knowledge on Big data and Hadoop File system.
• Run Base,SAS/Access,SAS/STAT,SAS/Graph,SAS/STAT,SAS/DI studio and SAS/EG.
• Capable of processing large sets of structured, semi - structured and and unstructured data supporting systems application architecture.
• Able to assess business rules, collaborate with stakeholders and perform source-to-target data mapping, design and review.
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.
• Knowledge on Ecosystems like Hive, Pig, Sqoop, Map Reduce, Flume, Oozie, Spark and capturing data from existing databases that provide SQL interfaces using Sqoop.
• Having very good analytical and coding skill as well as project management skills.
• Built Connectivity between SAS to Vendor tools and Open Source systems
• Pulling Hadoop files into sas and Convert as a sas datasets
• Design document to develop new algorithm for Analytics
• Design analytic frame as per Adhoc-Queries for Analysics
• Cube designing as per analysis and reporting
• Migration of sas application and SAS datasets
• Create and Maintain transport files which is running on various systems
• Develop and Modify predefined Macro applications
• Extensive experienced in coding to create list tables, Cross tab, chart and plots using SAS/BASE, Graph and ODS and optimizing programs by using advanced SAS Programming techniques for development.
• Experienced in producing detail and summary reports using PRINT, REPORT, MEANS and SUMMARY procedures
• Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, and SAS/GRAPH in Windows, and Mainframe environment
• Experience in working with multiple databases like Oracle, DB2 and Teradata
• Experience in development of documentation like Technical Specifications from BRD and Process/Program flow
• Thorough knowledge in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports
• Have very good knowledge on Health Care Insurance domain and statistics.
• Involved in all phases of Project Life Cycle.
• Expertise on various BI Suite tools like: SAS Enterprise Guide, SAS DI,SAS Management Console, SAS Stored Process Server, SAS Web Report Studio and SAS Information Delivery Portal.

TECHNICAL SKILLS:

SAS: Base, Macros, Graph, Access, Stat

SAS BI Tools: SAS/EG, SAS/DI, Dashboard 4.3, Information Map Studio, Web Report Studio and OLAP Cube Studio

Hadoop: Hive, Pig, Sqoop, Spark, Impala, Map reduce.Spark

Special skills: Cognos,R, Tableau.

Databases: Oracle,Teradata and DB2.

Utilities: MS-Office 2003 and 2007

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Associate

Responsibilities:

• Deliver ad-hoc and production reporting on an as needed basis. Automation of the process wherever is possible
• Coordinate with the Business team to conduct internal checks, controls and analysis provide RWA variance explain and change in RWA analysis. managing the calculation, consolidation, reporting and explain of Market Risk RWA.
• Review the test results before sending it to client.

Confidential

Sr.Associate

Responsibilities:

• Automating manual process and optimized existing programs.
• Interact with the Business subject matter experts and determine business questions and data requirements.
• Developed new QBR reports based new data and also worked on enhancement of existing QBR reports.
• Improve operational efficiency by automating and integrating programs and increased reusability
• Review the test results before sending it to client.

Confidential

Sr.Associate

Responsibilities:

• Responsible for developing stored process and DI jobs and update the existing reports.
• Interact with the Business subject matter experts and determine business questions and data requirements.
• Review assigned tasks and provide feedback to onsite and offshore.
• Review the test results before sending it to client.

Confidential

Sr.Associate

Responsibilities:

• Compared the files submitted to the state and the response files received from CMS for identifying the errors and issues in the claim/ pharmacy files. This validation process involves thorough checking of Provider, member, pharmacy and other related files to find the root cause of the problems.
• Supported the production data submissions on a weekly/monthly basis to NY State and/or CMS as required by reporting schedule determined by state.
• Responsible for handling both internal and external errors in data submission process. Error records must be managed and corrected according to organizational policies and procedures.
• Responsibilities include documenting development requirements, reviewing specifications, creating test plans, process flow charts and reviewing the user-acceptance test data.

Confidential

Lead Programmer

Responsibilities:

• Requirement gathering and understanding the specs.
• Task Estimation and develop frame work for reporting.
• Providing technical assistance to the team. Review the assigned tasks of the team.
• Verifying the test result by checking the Actual result with the expected result reviewing the test results before sending it to client.

Confidential

Lead Programmer

Responsibilities:

• Gathering requirements from onshore.
• Understanding the Technical Specs.
• Preparing low Level Design documents based on given Business specifications.
• Developing report code and generating the reports.
• Provide status report on the progress of work to Onsite and offshore RM.
• Reviewing the test results before sending it to client/onsite.
• Post production jobs monitoring.

Confidential

Lead SAS Programmer

Responsibilities:

• Gathering requirements from onshore.
• Understanding the Technical Specs.
• Preparing low Level Design documents based on given Business specifications.
• Developing SAS report code and generating the reports.
• Provide status report on the progress of work to Onsite and offshore RM.
• Reviewing the test results before sending it to client/onsite.

Confidential

SAS Programmer

Responsibilities:

• Interacting with onsite coordinator and client.
• Requirement gathering and understanding the specs. Task Estimation
• Assigning work to team as per work-plan.
• Providing technical assistance to the team.
• Understanding Mainframe FOCUS applications recoded into SAS
• Testing Performance of SAS application compare to FOCUS applications
• Verifying the test result by checking the Actual result with the expected result.
• Maintain proper back plan for each resource tasks
• Get the approval from the client for completed tasks.
• Involve in production implementation activities.
• Post production jobs monitoring.

Confidential

Sr.SAS Programmer

Responsibilities:

• Understanding scientific data across clinical documents
• Documenting the development plan and Quality check steps
• Query and Analyzing the data from information warehouse
• Data preparation
• Data cleaning and validation
• Creation and modification of relevant attributes
• Aligning the attributes position, naming convention, label and formats
• Creating the final report with client specification formatsQuality checks
• Steps are followed as per development plan
• Code standardize and annotation
• Check/uncheck the Quality check documents by monitor the logic, constrains, attributes position, naming convention, label, formats etc…
• Codes and results are followed as per Quality standards then sharing to clients through SharePoint.

Confidential

SAS Programmer

Responsibilities:

• Access remote files by using Filename statement, FTP Access Method.
• Count the number of observations based on line of business and other key variables
• Creating required datasets by using extracted data based on different products and markets.
• Calculating disruption frequencies based on line of business by using Freq applications.
• Calculating frequencies based on referral codes.Combine different data sets by using Merge or join Statement.
• Calculating Descriptive statistical results
• Generating alerts based on UCL and LCL values.
• Involve in production implementation activities.
• Writing Automated Email generation code in SAS to receive the alert information.

Confidential

SAS Programmer

Responsibilities:

• Access remote files by using Filename statement, FTP Access Method.
• Creating required data sets based on application requirement.
• Applied transformations for structuring the data by using SAS procedures, Functions & Merge Statement.
• Experienced in using Proc SQL, Proc Print, Proc Append, Proc Means &Proc transpose, Proc report.
• Generated reports in ODS, HTML, RTF formats.