Sunandan Kumar Soora Mobile - 317-***-****

Email- adcwn8@r.postjobfree.com

Experience Summary:

•13+ years of total IT experience with wide experience in various technologies and Applications.

•Experience in Pharma and Insurance (Life sciences & Health care) domains.

•Experience in Supply chain (Manufacturing, Demand and supply, Inventory) and Market research analysis (Sales, Ex-factory sales, Rx, DDD, activity, alignment and open payments), Plan of Care, Patient visits, schedules, ICD10, reinsurance, claims, member enrollments.

•13 years of SAS Developer experience in Base and Advanced SAS and SAS DI.

•Experience in the areas of Enterprise Application/Data Integration and Reporting tools.

•Experience in comprehending and maintaining complex enterprise IT architecture with wide variety of applications.

Skills Summary:

•Certified Base and Advanced SAS programmer.

•Expertise in Base and Advanced SAS programming, merging SAS data sets, Macro facility, SAS Functions, storing and managing data in SAS files.

•Experience in Base SAS, Advanced SAS, SAS EG, SAS DI tool (ETL) and SAS BI tools.

•Extensively used SAS with SQL in extracting data from relational databases like Oracle, Netezza and DB2.

•Experience with Unix scripts and windows batch scripts.

•Expertise as Reporting Analyst using SAS and Business Objects.

•Expertise in different methods of data extraction and reporting (SAS, Business Objects, Excel VBA)

•Expertise with IOM (Integrated Object Model) SAS servers.

•Monitoring Data flow in live production environments (UNIX batch jobs)

•Ability to handle multiple tasks individually as well as in a team.

•Problem Management, Issue resolution, System fixes and enhancements.

•Coordination with various functional and technical –onsite and offshore teams.

•Possess strong ability to quickly adapt to new applications and platforms.

•Experience in SAS Administration activities using SAS Management Console.

•Experience with ETL tool- SAS DI studio.

•Experience with Reporting tools like Business Objects, SAS BI tools, Qlikview, Cognos.

•Knowledge of Clinical trials (SDTM and ADaM).

•Knowledge of grid architecture (Grid control server, Grid nodes, Grid clients, Grid manager module and etc.), grid computing and General Parallel File system (GPFS).

•Knowledge of DataFlux dfPower Studio (dfpower architect for quality, dfpower profile configurator for profiling).

•Knowledge of Hadoop transformations like Hadoop container, Pig, Hive, Hadoop File Reader and Hadoop File Writer.

Technical skills:

SAS Products : SAS V9.4, Base SAS, SAS Macros, SAS EG, SAS-DI, SAS-BI, SAS-OA SAS Management Console and Flow Manager.

ETL Tools : SAS DI Studio

Reporting/Analytics Tools : BO-XI, QlikView.

Operating Systems : UNIX, Windows, Mainframes

Database : Oracle, Netezza, MS Access, DB2

Tools : TOAD 7.2, Reflection 8.0.3, SSH Secure Shell, FileZilla, Putty, Excel

Languages : HTML, XML, UNIX Shell script, Batch script, PL/SQL, JCL

ERP : SAP APO/ECC Demand Management Related Job monitoring, Data extraction and reporting, SAP ECC – Integration of Inbound and outbound logistics with Third party Warehouse Management systems.

Education:

Master of Computer Applications (MCA), Osmania University, Hyderabad, India. (200-2003)

Details:

May 2019 – Till Date

Project Title : National Medi-Cal Encounter Reporting Team (Health Care)

Client : Kaiser Parmanente, CA

Role : SAS Analyst/Developer

Description:

The main goal of this project is submitting claims (837) files for different plan partners like LA Care, CalOptima, IEHP, Gold Coast Health plan, Virginia and etc. on monthly/weekly basis. And receive responses from Plan Partners (999/277CA) in the form of acknowledgement or errors. Reconciliation will be done, and claims will be resubmitted throughout the month.

Claims, Members and NDC data is extracted from oracle database and Plan partner, EDI (paper claims) other data extracted through flat files using SAS programs to create professional and Institutional files with claims, membership and drug code data and submitted to Transunion to create 837 files.

Responsibilities:

•Monthly Production support. Monitor JCL jobs.

•Create monthly report for waystar and Payer rejections.

•Submit 837- and 200-byte files in Clear IQ.

•Monitor Responses from Payer.

•Modification/maintenance of existing SAS programs.

•Generating SAS datasets from tables in Database using SAS/Access, set, infile (flat files), merge

•Using procs like print, sort, cport, export, SQL and etc

•Involve in migration of Mainframe SAS to SAS Grid.

Environment:

SAS V9.4, Mainframes, TPX, Reflection (FTP), JCL, Oracle, SQL Developer, Clear IQ, Excel

Jan 2018 – Apr 2019

Project Title : Financial Reporting (Stoploss and Statistics for Workday) (Health Care)

Client : Healthfirst, NY

Role : SAS Analyst/Developer

Description:

Stoploss- This project is to support reinsurance (stoploss) in organization and help EMR team. Stoploss reports created and refreshed every month for different line of businesses (Medicaid, Medicare CHPLUS, HFIC, Complete Care, HIXPLAN) with members, claims (Exceeded threshold and eligible for submitting to state) and service lines information using SAS. Development/changes to reports are done using waterfall model and following existing Production release procedure. Stoploss reports are scheduled to refresh every month and Business team uses these reports (excel files) for submitting to state.

Statistics for workday- Purpose of this project is to provide/develop statistics (Utilization, Days, Discharges, Scripts, Visits, Member months etc) for different areas like Service lines, Member months, Dental, Vision, Pharmacy and etc. Data is extracted from SAS DWH and output (SAS Datasets-Lines and Header) created with required columns and formats. These datasets are converted to xml and loaded to workday for financial reporting and submitting to state.

Medical home Automation- Eligible providers’ information along with PMPM amount needs to be reported every month. State provides back payments along with eligible provider information in excel format. This information is merged with required columns pulled form data warehouse and loaded/appended to Medical home tables in DWH. And Medical home, Finance summary, Med county reports are created for current month.

Responsibilities:

•Translating business requirements into technical requirements.

•Modification of existing Reports and development of new Reports using Base and Advanced SAS.

•Following release management process.

•Create Functional Specs, and other process related documents.

•Informal testing, coordinating formal testing with QA team and UAT with Business team.

•Presenting changes in CAB meeting.

•Attending client meetings and status reporting.

Environment:

SAS V9.3 for windows, HP ALM (Application lifecycle Management), Service now, TFS( Team foundation server), Excel, Docusign, DAF(Deployment automation Frame work)

Jun2017 –Dec 2017

Project Title : SAS platform for Actuarial Team (Health Care and Financial)

Client : CNO Financial Group, Indianapolis, IN

Role : SAS solution Architect, Administrator and Developer

Description:

This project is about to setup SAS Enterprise Guide for different departments like Corporate, Product Management and Valuation. Existing system is developed in FOXPRO and MS-ACCESS.

All projects need to be developed using SAS EG and need to implement Enterprise solutions to share the data across actuarial departments with security and Metadata concepts using the SAS IOM servers. Need to automate process of loading flat files provided by System Admin using Autosys and develop stored processes and Macros, which can be used by Actuarial team.

Responsibilities:

•Provide solutions at architecture and configuration level.

•Develop standards and Processes to achieve enterprise solutions.

•Create documents for standards, migration and other operational processes.

•Perform Administrative activities.

•Development of Stored processes and Macros.

•Represent internal SAS committee meetings.

•Coordinate team members to develop projects in SAS.

Environment:

Base and Advanced SAS, SAS EG 7.1, Management Console, Oracle, MS SQL server, LINUX 7.3, Autosys.

Aug2016 –May2017

Project Title : Actuarial platform (Insurance and Visiting nurse Data)

Client : Visiting Nurse Service or New York, NY

Role : SAS Consultant.

Description :

This project is about to develop and maintain Actuarial platform for VNSNY CHOICE. Data is extracted from different sources like NYS roster, CMS MMR data, Healthplex, TMG Facets, CVS/Med impact and etc. tables in Oracle. And integrated, Transferred and loaded as Inpatient, Enrollment, and Medicare and Medicaid Claim inventory using SAS DI Jobs. Need to run jobs every month to load facts and dimensions into data warehouse. All target tables are in oracle.

The other project is to support VNSNY CHHA, developed using BASE and Advanced SAS. There are SAS programs which are scheduled to run weekly to provide data for Visiting nurse services likes Plan of care, visits, schedules, ICD10 etc. Data is pulled from Db2 and oracle and reports are created and exported to Vista plus.

Responsibilities:

•SAS DI, SAS Developer.

•Support existing SAS DI Jobs.

•Support informatica team to migrate ETL mappings.

•Creation of stored processes, Assigning Libraries, metadata setup and testing using SAS EG.

•Delivering varies type of reports using Base & Advanced SAS oracle and DB2.

•Requirement gathering for developing reports.

•Modification of existing Reports, development of new Reports and testing using Base, Advanced SAS.

•Generating SAS datasets from tables in Database using SAS/Access, set, infile (flat files), merge and hash.

•Using procs like print, sort, means, transpose, export and etc.

•Extract data from oracle Data access using implicit and explicit pass-through SQL.

•Customer Communication.

•Status Reporting.

Environment:

•SAS V9.4- SAS DI studio 4.9, Management Console, Base and Advanced SAS, SAS EG 7.1, Oracle 11G, EXCEL, VBA, Toad, DB2, Informatica, windows server 2012 and Vista plus.

Nov2015 –July2016

Project Title : UCB Europe EDWH (Pharmaceutical Sector)

Client : UCB pharma, Smyrna, GA

Role : SAS DI Consultant.

Description :

The main goal of this project is to build data warehouse for sales, Territory (Brick) management, Ex-factory sales, wholesaler sales and activity for around 10 European countries like Belgium, France, Norway and etc. Project is planned in different phases. Current phase is for Ex-Factory sales. Data for CNS and IMM therapeutic classes is pulled from different sources like flat files from IMS, Referential files from Business, Financial data from SAP, Supply chain data from visa and integrated using SAS DI studio and loaded into Netezza database. Extraction, Load and transfer (ELT) process is used in most of the cases for efficient performance of SAS DI jobs. Different layers are developed to perform ELT process like Landing and Staging layers-Data is stored prior to integration, Integration layer-Data quality, integration checks are performed, EDWH layer-Needed calculations are performed, Datamarts (DMA) layer- Datamarts are created based on reporting needs.

Open Payments – Developed ETL Jobs to load General and Research Payments (US) from CMS along with Physician information. This data is used by Compliance team to take decisions on Payments.

Responsibilities:

•SAS DI consultant and SAS Developer role.

•Analyzing Business requirements and developing SAS DI Jobs.

•Ensures adherence to locally defined standards for all developed components.

•Development of SAS DI jobs using waterfall model (SDLC) to Extract, Load and transfer (ELT) data from different sources to Netezza.

•Implementation of Data Federation architecture.

•Requirements gathering and involved in design.

•Modifications of Physical data model.

•Creation of Job flows and schedule jobs using Schedule Manager.

•Execution of Flows using Flow Manager in Development environment.

•Creation of Promotional document and Operational guide.

•Supports the migration activities (deployment instructions).Study existing ELT architecture and rules to fit development into it.

•Customer Communication.

•Status Reporting.

Environment:

•SAS V9.4- SAS DI studio 4.9, Management Console, Flow Manager, Base and Advanced SAS, SAS EG, Oracle 11G, Netezza, Aginity work bench, Erwin data modeller, Visio, Cognos, Qlikview(Integration testing purpose).

Feb2015 –Oct2015

Project Title : Global One BI (Insurance Sector)

Client : Allianz, Bengaluru, India.

Role : Technical Lead.

Description :

The main objective of this project is to provide Platform as a Service (PaaS) to Actuarial team. It provides a shared service platform for Business Intelligence solutions. AMOS is the provider of platform for Business Intelligence solutions and it implements and operates a shared service BI Platform for the Allianz Operational Entity. SAS BI and DI tools will be used in this project. Architectural documentation is completed as part of Phase0. Phase1 is under progress. Phase1 includes running a sample project on Enterprise guide based on infomap, Creation of a report using WRS, creation of a stored process, presenting information using Information delivery portal, DI jobs to extract data, defining user groups

Responsibilities:

•Project Management, technical architect.

•Technical involvement of phase1.

•Creation and execution of stored processes, Execution of Infomaps using SAS EG.

•Coordination of offshore and onshore.

•Review of architectural documents.

•Team Development: individual goal setting, mentoring, performance measurement.

•Customer Communication.

•Status Reporting

Environment:

•SAS v9.3 for Linux, SAS-BI (9.3), SAS DI(4.3), SAS EG, SAS OA, Oracle 11G,SAVI, WINSCP

Aug2012 – Jan2015

Project Title : Adhoc Reporting for Market Research (Pharmaceutical Sector)

Client : Eli Lilly and Company, Indianapolis, IN.

Title : SAS Developer and Reporting Analyst.

Description :

This Project provides business intelligence to US sales forces (Cardio, Men’s Health, Diabetes and MSK). It includes information like prescriptions written by HCPs(physicians), Activity (Calls, Samples and Details) done by sales representatives at different alignments (Territory, District, Area and Division), Plantrack data and Drug distribution sales. We extract data from Netezza database and create data mart, develop SAS reports to different sales forces in the organization for market research, S-T-P approach (Segmentation, Targeting and Positioning) and to take important decisions. Reports are created on Adhoc basis to provide information related to Physicians, Accounts, prescriptions, sales activity like calls, details and samples, Drug distribution sales, decile, targets, plan track, weekly xponent and alignments. IMS health provides Rx, Sales data monthly and weekly. All reports are provided in excel format. Other responsibility of this project is to provide data (SAS datasets) different clients like ZS associates, Merkleinc and MarketRx on monthly and weekly basis to support analytics in the organization.

Responsibilities:

•Translating customer requirements into technical requirements.

•To develop activity reports (Calls, Details and Samples) for various sales forces along with customer and alignment information using SAS. These reports enable them keeping a track of activities conducted by sales representatives to promote their brand products.

•To develop Rx reports for Sales forces to know the Rx count trend for Physicians at different alignment levels (Territory to Division) and Rx count trend for insurance plans.

•Developing structured and efficient reports for analyzing the sales trend.

•Maintenance and Execution of SAS Data warehousing for Marketing & sales.

•Delivering varies type of reports using SAS and Netezza.

•Using Procs like print, sort, sql, summary, transpose, export and etc.

•Coordination with offshore team.

•Using SAS/Connect (Signon with TCP) to connect PC SAS and Linux.

•Working with Linux shell programs to execute SAS programs.

•Generating SAS datasets from tables in Database using SAS/Access. Extract data from Netezza and flat files.

•Data access using implicit and explicit pass-through SQL.

Environment:

•SAS v9.3 for Windows and Linux, Base SAS, SAS Macro, SAS/SQL, SAS/Access, SAS/Connect, LINUX, Netezza, Aginity work bench, SSH Secure Shell, FileZilla and MS- Excel.

Feb2011 - Jul2012

Project Title : Business Reporting (Pharmaceutical Sector)

Client : Eli Lilly and Company, Indianapolis, IN.

Title : SAS Developer.

Description :

This project keeps track of activities performed by sales representatives on monthly basis. Activity information is displayed at Sales representative, Territory, District, Area, Region an d Division and sleeve levels as dashboards. Activity information includes Calls done to doctors, Dialogues with doctors, Field days, Percentage of call frequency, Count of programs, Count of HCPs attending programs, Brand details and etc. Sales activities are captured in dashboards. There are separate dashboards for Diabetes, MSK (Musculoskeletal), Neuroscience, Men’s Health, Oncology and Cardio sales forces. Activity and Alignment data is extracted from Oracle database using SAS programs. Some information is provided as flat files. These files are exported to SAS. Further metrics in dashboards are calculated using SAS programs and exported to excel sheets. Apart from monthly dashboards, customers’ requests for different reports are considered as adhoc requests and using SAS adhoc reports are delivered to customers.

Responsibilities:

•Coordination with offshore team.

•Creating dashboards for different sales forces every month.

•Translating customer requirements into technical requirements.

•Working with large Sales representatives’ activity datasets.

•Extract data from different sources i.e. Text, csv and Oracle database to SAS.

•Cleanse and organize the SAS datasets for further analysis.

•Develop and maintain general-purpose and ad-hoc SAS programs for extraction, presentation, manipulation, analysis and reporting using SAS 9.2

•Using PROC SQL Pass through Facility to extract data with Oracle for data mining.

•Create SAS datasets from tables in Database using SAS/Access. Extract data from flat files, oracle database and created SAS data sets for Analysis.

•Using SAS/Connect to connect PC SAS to Linux.

•Working with Linux shell programs to execute SAS programs.

Environment:

SAS v9.2 for Windows and Linux, Base SAS,SAS Macro, SAS/SQL, SAS/Access, SAS/Connect, LINUX, Oracle 10G, TOAD, Putty, FileZilla and MS- Excel.

Oct2005 – Jan2011

Project Title : Global Business Integration Project (GBIP). (Pharmaceutical Sector)

Client : Eli Lilly and Company, Indianapolis, IN.

Role : Onsite Coordinator and SAS Developer.

Demand Management and Inventory (DMI)

Description :

The Global Demand Management System (GDMS) involves Cleaning, Processing and Reporting Demand Management information like monthly, weekly and annual Plant site demand, forward coverage, open orders, back orders, make to order, planned production at a plant site, Sales Forecasts, expired stock and etc This information is used to support Business Intelligence and helps Marketing and Demand Management Coordinators, Replenishment Coordinators and other affiliates to make analysis and to make sound decisions in the organization.

The GDMS Data mart consists of SAP ECC and APO master and transactional data. This data is then used for SAS and SAP Business Objects Reports that run daily, weekly and monthly as batch processes.

Environment: SAS Base v9.1, SAS Macro, SAS/SQL, SAS/Access, SAS/Connect, SAS/Graph, and SAS/ODS, BO-XI, UNIX shell scripts, Perl, Unix 11, Oracle 9i, PL/SQL HTML, TOAD, Reflection, SAP-APO, SAP ECC, AR system(Remedy), Documentum, HP Quality Center.

FINCOE

Description :

FINCOE is a suite of 20+ applications (Auto Audit, AGERS, Transfer price System, Business Dining room, Royalty Tracking System, Genesis and etc) developed using oracle, ColdFusion, spotfire, Business objects, MS access and Java. The primary purpose of this module is to integrate various local and legacy financial applications with enterprise wide global SAP ECC system to consolidate financial information. These applications are composed of ETL, Data Staging, Integration and Reporting applications.

Environment: BO-XI, Oracle 9i, PL-SQL, Spotfire, ColdFusion, Java, MS Access

Responsibilities:

•Problem Management, Issue resolution, System fixes and enhancements.

•Coordination with various functional and technical –onsite and offshore teams.

•Modification of existing Reports and development of new Reports using Base and Advanced SAS.

•Scheduling batch jobs (UNIX crontab).

•Modifying existing Unix shell scripts.

•Using different type of procedures like print, sort, gplot, transpose, datasets, export, means.

•Trouble Ticket analysis and resolution.

•Change Management.

•SOPs to adhere Good Manufacturing Practices (GMP) and 21 CFR part11 (Electronic signatures and records)

•Preparation and Modification of Functional Specs, Technical Specs and Code Review in Documentum.

•Informal Testing and Formal testing using Test Scripts in Test Director and HP Quality center.

•Monitor incidents in own area and ensure effective & efficient delivery of support services as per SLA (Service Level Agreement).

Contact this candidate