Data Management

Aruna. K

**+ years of experience in Information Technology with Predictive analysis, Data mining, Data warehouse concepts (ETL), Data Marts development, OLTP and OLAP BI (Business Intelligence) applications and reporting.

Exposure in overall SDLC includes requirement gathering, development, testing, debugging, development, documentation, production support and project management methodologies.

Strong interpersonal and analytic skills; ability to solve business problems.

Worked on Health Care, Pharmacy, Retail, Advertising and Finance domains.

Expertise in SAS 9.4/9.1 with experience in Base SAS, Macros, SAS / Access, SAS Business Intelligence Suite (BI), SAS Visual Analytics (SAS VA), SAS Ms Office Analysis (SAS OA), SAS Management Console, SAS Enterprise Guide, SAS Data Integration (SAS DI) on Windows and UNIX.

Loading data from external files like CSV, Sql Server, Oracle into SAS metadata environment.

Experience in handling huge volume of data to see patterns and trends in identifying future analysis.

Involved in designing and implementing data modeling techniques and Reports for Analytical department.

Created different types of Reports like drilldown/ drill through/ Linked Reports, highlighting, etc.

Created Visually rich Dashboards with KPI measures, bubble plot, Graphs, interactive reports, etc

Successfully implemented various Performance tuning techniques, SQL query optimizer, etc

Experienced with Security Management in SAS Management Console by managing users/ groups/ roles.

strong knowledge of claims management process, Knowledge of Medicaid and Medicare Services.

Hl7 Standards, HIPAA, Compliance issues, Electronic Health Records, Electronic Medical Records and EDI/HQ

Good Knowledge on Hadoop Cluster architecture and other components such as HDFS Job Tracker,

Task Tracker, Hadoop ecosystem components like Hadoop MapReduce, HDFS, HBase, Hive, Pig, etc.

Followed Scrum, Agile / Iterative development methodology.

Professional Experience

PointRight Inc., MA Jun'16 -Till Date

Sr. BI Developer

PointRight Inc. is delivering leading predictive analytics solutions to thousands of post-acute providers, hospitals, payers and insurance organizations. PointRight Inc. is one of the first analytics company to server long-term post-acute care market. PointRight provides a range of analytics solutions that enables to achieve data quality, lower rehospitalization, achieve quality measures, manage risk and manage reimbursement and operations.

Responsibility/Highlights:

Work with business users and statisticians to analyze Business Processes and BI requirements.

Worked on Predictive analytics in building the scorecard.

Loading Tables into SAS LASR Server, Register metadata, importing external files into SAS VA environment.

Design and implement historical and incremental load processes, batch jobs, error handling, audit logging.

Created data extraction (ETL jobs), extracting data from various sources and loading into SAS Server.

Performed Query optimization to improve performance of ETL process to load data.

Created Global and local filters, Graphs and exported to PDF / VA Report Object in SAS Visual Analytics.

Developed various Predictive Models for credit scoring in decision trees, regression, etc.

Created Dashboards, interactivity between report objects, display rules, conditional highlighting, KPIs, etc.

Created Cross-Tab, Drill-Down, Hierarchies, and Models like Forecast with Line-chart based on Time Series in SAS VA.

Created Text Analysis, Regression (Decision) Trees, Tree Maps, Network Diagrams and Bubble Plots.

Worked on source data to identify granularity of data marts, associated Dimensions and Facts, etc.

Created SAS information Maps with measures, Prompts and filters for analysis and Reporting.

Designed Complex reports in SAS Web Report Studio by creating conditional Formatting, Master-Detail

Relationship and Drill-through reports.

Created SAS OLAP cubes with measures, hierarchies, aggregations, etc.

worked extensively on Cube slicing, dicing, Drill-down, drill through functionalities.

Knowledge on Advanced Predictive Models, Market Basket Analysis & Text Mining Techniques, Decision Tree, Neural Networks, Summary statistics, Hypothesis test and ANOVA.

Prepare detailed design and mapping documents, and architecture diagrams.

Proactively communicated the Project status to the Internal Leads and stack holders

Follow Agile / Iterative development process.

Environment/Tools: SAS/BASE, SAS/MACRO, SAS/SQL, SAS Information Map studio, SAS Web Report Studio, SAS Enterprise Guide, SAS VA (Visual Analytics), SAS Data integration Studio, SAS Management Console, SAS e-Miner, Terradata, Oracle, Sql server, SSIS SSRS.

Blue Cross Blue Shield, NJ Nov'14 - May'16

SAS Programmer

Blue Cross Blue Shield is a nonprofit corporation and an independent licensee of the Blue Cross and Blue Shield Association. BCBSM's commitment, is what differentiates it from other health insurance companies doing business in the state. It offers access to health care coverage for everyone, regardless of circumstances and never dropped the coverage for health reasons Partnering with the state to cover and provide support for clinics statewide.

Responsibility/Highlights:

Creating Business Requirements (BRD), Functional Requirement (FRD) and Technical Documents.

Performed statistical analysis and data management using SAS tools.

Handled Millions of Records Using SAS Proc SQL Procedures.

Created new macros for reports generation using SAS/Macros as per the business users requirements.

Developed Stored Procedures in SAS Enterprise Guide.

Generated high quality reports in Listing, HTML, RTF and PDF formats using SAS ODS.

Results are performed using SAS programming techniques such as SAS Macro language, advanced data manipulation, and statistical procedures.

Created calculated items, filters and various types of Prompts in the metadata models.

Generated reports using PROC REPORT, DATA _NULL_ and PROC TABULATE for customized report writing.

Developed new or modified existing SAS programs to load data from the source and create study specific datasets

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

Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis

Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros.

Optimized the Performance for SAS OLAP Cubes (SAS OLAP, SAS OLAP slice and dice, aggregations, etc.)

Created Data modeling for Dimensional data marts as well as 3NF data warehouse. Design for Conformed

Dimensions and Facts, using Enterprise Data Warehouse Bus Architecture.

Extracted, performed validation and generated SAS data sets from Teradata.

Performing Unit and Integration testing, validation and sanity checks on the deliverables.

Worked on Excel/VBA (macros).

Environment/Tools: Base SAS, SAS Macros, Proc SQL, SAS Web Report Studio, SAS Information Map, SAS Dashboard, SAS Enterprise Guide, SAS Management Console, Oracle, Teradata, Excel, VBA.

Lodestone, India Feb'12 - Oct' 14

SAS Programmer

Lodestone is an Analytics focused company which provides end-to end capabilities to clients for Analytics Solutions, Implementation, Training & Resources. Lodestone Learning is the only Accredited Training Partner to SAS (the Global leader in Analytics software) in two states with domain expertise in Life sciences, Healthcare, Pharma, Retail business, etc. It is also implementation partner to SAS India for Mid-Market Corporate. It works extensively with clients to provide them Analytics resources on Contract and Full time basis.

Responsibility/Highlights:

Created SAS database files, Ad-hoc analyses and graphical reports

Created Conceptual, Logical and Physical design for data warehouse and data marts with Star Schema.

Data modeling for Dimensional data marts as well as 3NF data warehouse. Design for Conformed

Dimensions and Facts, using Enterprise Data Warehouse Bus Architecture.

Maintained source code version control.

Had knowledge on SAS CONNECT and TCP / IP Winsock

Confirmed to agency build and deploy procedures and programming standards

Completed development assignments in an organized, efficient and timely manner.

knowledge on SAS configuration wizard for Integrating the Integrated Object Model (IOM) among the work

space server, Stored process Server, Metadata Server and OLAP Server to plan, install and configure.

Had Knowledge on documenting SAS Error Messages and RC (return code).

Provided knowledge transfer.

Create / built, tested and validate the enhancements based on the requirements and documents provided

and create / modify design test procedures accordingly.

Created SAS formats and stored them in the SAS Library.

Conducted Training sessions on SAS,Prepared Training Material and Conducted Trainings on EXCEL, EXCEL - VBA, Data ware house, SQL Concepts and on Clinical Standards.

Conducted training sessions on Designing and implementing Data mapping, ETL process and Schemas.

Had Knowledge on Hadoop Distributed File System and its Architecture.

Environment/Tools: SAS/BASE, SAS/MACRO, SAS/SQL, SAS Information Map studio, SAS Web Report Studio, SAS Dashboard, SAS Enterprise Guide, SAS Information Delivery Portal, SAS VA (Visual Analytics) / JMP, SAS Data integration Studio, SAS Management Console, SAS e-Miner, Oracle 10g,Sql Server, Excel/VBA. Hadoop, Map Reduce, Latin Pig, Hive.

GVK, India Jan'10-Feb'12

BI Programmer

GVK is a globally recognized, integrated pharmaceutical company with core competencies in the development and manufacture of Active Pharmaceutical Ingredients (APIs) and Finished Dosage Forms as well as in drug discovery to treat a number of diseases and conditions in varied therapeutic areas. The project was analysis of Phase-III clinical trial data of multiple studies.

Responsibility/Highlights:

Responsible for providing Clinical SAS programming and analysis support for clinical studies across multiple protocols for the submissions like CSR and Safety.

Generated Tables, Listings and provide QC check, validation of outputs for Oncology clinical trials.

Involved in Developing, Debugging, and validating the project-specific SAS programs to generate derived SAS datasets, summary tables, and data listings according to departmental standards.

Used Sorting, Merging techniques and Proc SQL on the raw data sets for value added data preparation, to get the required Reports or Analysis data sets.

Built Macros and create macro variables using %LET, CALL SYMPUT, and DATA _NULL_ to help generate analysis data sets and create specified structure of TLFs.

Created analysis datasets based on the guidelines provided in the Data Definition Tables (DDT) and following the CDISC standard. Used SDTM model (3.1.1)/ ADAM for domain creation and CDISC compliant analysis datasets.

Used SAS ODS to report outputs in different formats like RTF, PDF, and HTML

Created SAS Datasets according to CDISC, stand-alone statistical reports, etc

Contributed to Integrated Summary of Safety (ISS), Integrated Summary of Efficacy (ISE) and Reports for clinical Studies.

Documented, summarized and recorded data as per standard operating procedures (SOPs) and FDA regulations.

CDISC mapping using SDTM model- created data tabulations and verified using Proc CDISC. Worked with different classes (intervention, events, findings, special purpose).

Create / built, tested and validate the enhancements based on the requirements and documents provided by the users

and create / modify design test procedures accordingly.

Good Experience with CDISC models such as SDTM, ODM, ADaM and Define.XML to be utilized for data

capture, ware housing, and submission

Used HIPAA standards for protecting PHI (Protected Health information) to do de-identification of the PUF datasets and made the information available to researchers as not IIHI (individually identifiable health information).

Provided knowledge transfer (KT) to other IT developers.

Environment/Tools: SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/MACRO, SAS/SQL, SAS Information Map studio, SAS Web Report Studio, SAS Dashboard, SAS Enterprise Guide, SAS Information Delivery Portal, SAS VA (Visual Analytics) / JMP, SAS Data integration Studio, SAS Management Console, Oracle 10g, Excel/VBA..

Tech Mahindra, Hyderabad, India Mar'06 - Dec'09

Programmer

Emergency Management and Research Institute, is a world class organization to handle Emergencies caused by either Medical, Police or Fire. The Emergency(108) calls are handled at EMRI call center from the entire nation and is been redirected to the respective state, which is answered by call taker to reach the site with life saving equipped ambulance. 108 Emergency in India is operated in12 states, head quarters located at Hyderabad. The EMRI-108 office has more than 15 different departments require various reports and Dashboards.

Responsibility/Highlights:

Functioned as the primary liaison between the business line, operations, and the technical areas throughout

the project cycle. Worked on gathering, analyzing and documenting business requirements.

Designed and implement business layer (business rules and transformations) and presentation layer.

Experience in creating database layer, physical layer and presentation layer, defining appropriate

relationship between query subjects, connecting and testing the data sources.

Created Ad-hoc reports in Query Studio and standard reports in Report Studio and developed reports from medium to high level complexity using Report Studio and Analysis Studio.

Created Conceptual, Logical and Physical design for data warehouse and data marts with Star Schema.

Data modeling for Dimensional data marts as well as 3NF data warehouse. Design for Conformed

Dimensions and Facts, using Enterprise Data Warehouse Bus Architecture.

Created Multidimensional Models(OLAP) and Multi-Dimensional reports using PowerPlay.

Created MOLAP packages using IQD files from FM models and published to Cognos Connection.

Created several Dashboards and Scorecards with Key Performance Indicators (KPI).

Used scripts and variables, email notifications for ETL process using Data Integrator.

Interacted with QA team for Unit Testing, System Testing and Performance Testing and Production Support.

Environment/tools:Cognos7.x, 8.x (Framework Manager, Report studio, Query Studio), Informatica 7.1, Oracle9i, TOAD, SQLServer 2005, SSIS, SSRS, Seagate Crystal Reports, Windows 2003 and NT Server, Ms visual Studio - ASP Dot Net, C#.

Education

Degree / Certificate

School, Location

Year

Score

Ph. D - Health

Annamalai University, India

2015

Highly Recommended

M Phil - Hospital & Health Care

BITS- Pilani, India

2010

7.82 CGPA

MCA - Computer Applications

MK University, India

2002

75%

Contact this candidate