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.
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, Oracle 10g, Excel/VBA.
9+ years of experience in Information Technology with Data Modeling for Data warehouse, Data Marts
development, Data Analysis for 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 Pharmacy, Health, Retail, Advertising and Finance domains.
SAS 9.4/9.1 with experience in Base SAS, Macros, SAS / Access, SAS Business Intelligence
Suite (SAS BI), SAS Visual Analytics (SAS VA), SAS Ms Office Analysis (SAS OA), SAS Management
Console, SAS Data Integration (SAS DI), SAS Enterprise Guide, SL , UNIX.
Loading data from external files like CSV, Sql Server, Oracle into SAS metadata environment.
Converting existing ETLs process from SSIS to SAS.
Writing SSIS stored Procs to get data from Oracle and pass it as input to RESTAPI for further data analysis.
Involved in designing and implementing data modeling and Reporting for Analytics department.
Created different types of Reports like drilldown/ drill through/ Linked Reports/ conditional highlighting, etc.
Created Visually rich Dashboards with KPI measures, Ranges , bubble plot, Graphs , Alerts, links, Spark
table, interactive highlights, etc
Experience in handling huge volume of data to see patterns and trends in identifying future analysis.
Successfully implemented various Performance tuning techniques.
Experienced in SAS Version control / Change management, etc.
Experienced with Security Management in SAS Management Console by managing users/ groups/ roles.
Followed Scrum, Agile / Iterative development methodology. Excel/VBA (macros).
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, Oracle 10g, Sql server, SSIS, SSRS, SSAS. SDTM, ODM, ADaM and Define.XML to be utilized for data
capture, ware housing, and submission. SAS 9.x, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, SAS/STAT, SPSS, Excel, Oracle 8, TOAD, windows, UNIX.
to 03/2017 MA
Work with business users and analysts to understand and analyze Business Processes and BI requirements.
Worked on source data profiling to further understand business processes and relevant data, to identify the
processes to capture, define granularity of data marts, associated Dimensions and Facts, etc.
Loading Tables into SAS LASR Server, Register metadata, importing external files into SAS VA environment.
Created Hierarchies to drill-down on desired category items in SAS Visual Analytics.
Created Global and local filters, Graphs and exported to PDF / VA Report Object in SAS Visual Analytics.
Created interactivity between report objects, display rules, conditional highlighting, KPIs, etc.
Created Conditional highlighting with the user required indicators by providing ranges in SAS BI Dashboard.
Created calculated items and filters in the metadata models to improve performance.
Designed Complex reports in SAS Web Report Studio by creating conditional Formatting, Master-Detail
Relationship and Drill-through reports.
Created matrix, reports, drill down reports and developed reports with graphs using SSRS.
Created SAS OLAP cubes with measures, hierarchies, aggregations, etc.
worked extensively on Cube slicing, dicing, Drill-down, drill through functionalities.
Created SAS information Maps with measures, Prompts and filters for analysis and Reporting.
Provided Training to user on creation of Ad-hoc reports across agencies.
Design and implement historical and incremental load processes, batch jobs, error handling, audit logging.
Prepare detailed design and mapping documents, and architecture diagrams.
Created data extraction ETL jobs using SSIS, extracting data from MS ACCESS, Oracle and MS Excel and loading into Databases.
Performed Query optimization to improve performance of ETL process to load data.
Follow Agile / Iterative development process.
Sr. BI Developer02/2012
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.
Confirmed to agency build and deploy procedures and programming standards.
Worked on documenting SAS Error Messages and RC (return code).
Proactively communicated the Project status to the Internal Leads and stack holders.
Provided knowledge transfer to other IT developers.
Create / built, tested and validate the enhancements based on the requirements and documents provided
by the users and create / modify design test procedures accordingly.
to 01/2012 Hyderabad, India
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.
Programming according to specifications, creating analysis datasets, listings, tables and figures for phase III clinical trials with high quality and within milestones.
Responsible for data collection, management and manipulation of clinical database Retrieved from Oracle using SQL within SAS to be analyzed and exported to Excel for further analysis.
Prepared clinical data listings and summaries for statistical analysis and clinical data using SAS system.
Connected various databases (ORACLE, DB2, SQL SERVER) such as development and production database
using SAS/ACCESS, SAS/CONNECT.
Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and proc SQL.
Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
Generated statisticaltables, listings and graphs, including Patient Demography and Characteristics, Adverse Events, Laboratory etc., based on Statistical Analysis Plan (SAP) and Case Report Forms (CRF).
Created and implemented statistical analysis plans and specification documents.
Gathered requirements for making changes to the existing Electronic Medical Records(EMR), Electronic Health Records(EHR) and Ambulatory Services for the existing Epic Interfaces.
Involved in development for data exchange from EMR, EHR to Electronic Lab Reporting Systems.
knowledge in claims management process, CMS, Health Assessment Systems , HL7 Standards, HIPAA.
Mappings and Message Validation, (EHR) Electronic Health Records, Electronic Medical Records.
Developed safety tables including Adverse Events (AE), Vital signs, Laboratory values, ECG and
Interacted with other line functions, such as Biostatistics, Data Management, to ensure a high
level of client satisfaction through successful execution.
Assisted in investigating and applying new SAS programming methods and techniques to enhance current systems by using various SAS macros and standard programming procedures.
to 12/2009 Tech Mahindra – Hyderabad, India
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.
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 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).
Developed Multi dimensional Objects (Cubes, Dimensions).
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#.
Ph. D - Health: 2015Annamalai University-
M Phil - Hospital & Health Care: