Data Analyst Business Intelligence

Jithender Gundawar

Sr. SAS EBI Developer Data Analyst DBE Specialist

773-***-**** *********.********@*****.***

Summary

I am a Certified SAS Developer, DBE, and Data Analyst with over 16 years of combined education and professional experience designing, developing, automating, and analyzing enterprise-scale database systems. Expert in SAS Enterprise Business Intelligence (EBI) and Data Integration across federal agencies and private sector clients. Strong background supporting SSA-ARC platforms, database modeling, metadata management, data transformation, and system architecture. Adept in cross-functional collaboration, technical planning, agile methodologies, and SDLC best practices.

Designed, developed and deployed SAS Enterprise BI reports, dashboards, and stored processes to deliver actionable insights to business users.

Developed ETL processes using SAS Data Integration Studio, optimizing data flow from source systems to SAS Data Marts.

Automated complex data extraction and reporting tasks through SAS macros, reducing manual processing time by 75%.

Integrated SAS BI tools (Web Report Studio, OLAP Cube Studio, Information Map Studio) to create user-friendly, self-service reporting solutions.

Collaborated with business stakeholders to translate requirements into scalable, high-performance BI solutions using SAS EBI suite.

Optimized data models and metadata layers to enhance report performance and ensure data consistency across the enterprise.

Implemented security models and access controls within SAS Management Console to maintain data governance and compliance.

Led migrations and upgrades of SAS EBI environments, minimizing downtime and ensuring seamless transitions.

Provided technical guidance, documentation, and training to end-users on SAS BI tools and best practices.

Troubleshot system performance issues and optimized SAS server configurations to improve application response times.

Education

Education

MS, Biology — Bloomsburg University, PA, 2009

MS, Bio-Technology — SRTM University, India, 2003

BS, Microbiology — Osmania University, India, 2000

Certifications & Training

SAS Certified Base Programmer

SAS Enterprise Guide (EG 4.3) — SAS Institute, 2010

SAS Visual Analytics Studio — SAS Institute, 2013

Agile 101 Certification — Northrop Grumman Corporation, 2015

Bio-Statistics and Bio-Informatics Coursework — 2006

Technical Skills

SAS Tools: SAS 9.4, SAS Studio 9.4/EG 8.0, Data Integration Studio, Web Report Studio, Visual Analytics, Text Miner, Forecast Studio, Stored Processes, SAS Management Console, SAS Viya

Databases: DB2, IMS, Oracle, EDW, IDP

Programming/Scripting: JCL, PowerShell, COBOL, Shell Scripting, JavaScript, Python

Platforms: Mainframe, AWS, Solaris, Windows, Linux

Reporting: Dashboards, OLAP Cubes, Information Map Studio, Excel/Access, AMO, Power BI, Tableau

Others: SAS Portal, SAS ODS, SQL, SharePoint, DocBuilder

Present Position:

Company: NG/CGI/ITC/Leidos (SSA Contract)

Position Title: DBE3/SME3

Date of Employment:

January 2015 – Present

Duties and Responsibilities:

Analyze the requirements, procedures, and problems to automate and improve existing systems, using SAS-EBI (Statistical Analysis Systems - Enterprise Business Intelligence applications) tools.

Review SAS Architectural system capabilities, workflow, and scheduling limitations.

Conduct validation of EBI tools; provide Proof of Concept on SAS EBI tools, UNIT testing, integration testing and UAT coordination with various departments within SSA and business user groups.

Create plans outlining steps required to develop and test various tools and programs using structured analysis and design.

Document high-level technical requirements, specifications, testing and data flow-charts, coordination with team and data validation.

Create user guides to provide the high-level usability of the SAS products with in the ARC platform.

Solve SAS Interactive Matrix Programming Language (IML) application connection issue, and develop the script to spawn the multi-thread process.

Develop scripts to automatically capture user’s emails from metadata and active directory, ARC servers check script and check server’s health.

Assist in tools shakeout and Provided POC on BI tools such as, web report studio, SAS portal, Dashboard Studio, Stored Processes, Information Map studio and SAS Studio to various components within SSA.

Support the ad hoc requests from users and other components.

Support task 924/52 – WEP GPO, Rep Payee, SSI Monthly, quarterly and yearly Modernization projects.

Work with mainframe files, using TSO, and using SAS to extract the target data, and created reports, based on the project requirements.

Assist with the debugging of mainframe spawner jobs submitted/scheduled from ARC platform, and coordinated with admin team, and the business users in scheduling the jobs.

Provide training on SAS tools to the NG employees, and worked with the ARC users and educated them on the ARC-SAS platform.

Work on proof of concept for visual analytics auto load script to upload the datasets to the LASR server.

Trained the SAS users within the agency on SAS VA and configured the tools along with SAS admins.

Develop stored process, and trained users on the POC and usage.

Test and document the bugs in the SAS studio thin client utility, and communicated the issues with SAS technical support.

Create and test algorithm for job dependencies, which could be used for scheduling purposes.

Participated in training the peers in SAS and BI tools as part of the emerging technology program

Participated in the technology symposium conducted by Northrop Grumman to SSA employees.

Converted the mainframe files to Postgres database as part of the modernization

Skills utilized: SAS 9.4, SAS/studio 9.4/EG 6.1, SAS/Data Integration Studio, Web report Studio, Excel/Access 2000, AMO, DB2, IDP, IMS, Stored Procedures and Dash Boards, Visual Analytics, Text Miner.

Preceding Position 1:

Company: Common wealth of MA

Position Title: SAS Programmer/Analyst

Date of Employment:

August 2014 – December 2014

Duties and Responsibilities:

Worked with Mass Health and related stakeholders to develop automated macros to simply and efficiently provide standard data from the Data Warehouse.

Worked in teams to synthesize various, and potentially competing, requirements in order to produce solutions that will meet a variety of user needs.

Worked across departments to develop guidelines and specifications.

Prepared detailed specifications from which code will be written.

Documented work in clear and transparent fashion.

Developed automated processes for standard clinical measures.

Created, Validated, and Maintain SAS Macro programs.

Worked with Medicaid Claims and Encounter data.

Trained the staff on new SAS techniques and in SAS coding.

Applied fine tuning methods to fetch the data from the database to build the SAS Mart.

Used SAS reporting procedures to generate XML and excel reports for the team.

Responsible for ad-hoc requests for data analysis.

Skills utilized: Environment: SAS 9.3, SAS/Foundation 9.3/EG 5.1, PC SAS, Oracle 10/11., Toad, Cognos.

Preceding Position 2:

Company: UBS Financial Services (contract through SAS Institute)

Position Title: Sr. SAS EBI Developer

Date of Employment:

March 2014 – July 2014

Duties and Responsibilities:

Worked with the client’s financial customer data to develop reporting deliverables using SAS EBI suite of products.

Performed admin tasks such as, installation of SAS EBI products on the machines.

Coordinated with SAS team and technical support to achieve this.

Gathered requirements and worked with business analysts and management to understand the report requirements.

Used WRS, OLAP Cubes, information map studio and dash boards extensively to develop reports.

Created customer sort order to meet clients report templates.

Made recommendations to the client on reporting efficiencies.

Created portal user group and created information delivery portal to list the report links for the end users.

Performed trouble shoot, fix the server related issues, and coordinated with admin teams to fix them.

Responsible for providing the knowledge transfer on the product’s used an reports created

Supported data analysis and QA the data to ensure that calculation have been met.

Documented and responsible for knowledge transfer to team members about the project.

Skills utilized: SAS 9.3, SAS/Foundation 9.3/EG 5.1, SAS/Data Integration Studio, Web report Studio, Excel/Access 2000, AMO, Oracle, Solaris, IDP, IMS OLAP Cubes and Dash Boards.

Preceding Position 3:

Company: United Health Group (contractor)

Position Title: Sr. SAS BI Applications Developer

Date of Employment:

March 2013 – February 2014

Duties and Responsibilities:

Provided SAS programming and statistical support to the healthcare data.

Created Summary Reports and Detail Reports using Proc Report and Proc tabulate

Created RTF, PDF, and HTML listings, tables and Reports using SAS ODS.

Involved in writing code using EG & SAS/Macros to extract clean and validate data

Ensured that analyzed data and programming code met regulatory and company standards and are consistently structured to permit efficient programming and reporting.

Performed Quality Assurance (QA) procedures on work performed by other programmers.

Accessed data from many sources, such as oracle, DB2, SAS data sets, Microsoft Excel

Employed various SAS procedures, like Proc Print, Proc Report, Proc Migration, Proc Freq, Proc Tabulate, Proc Means, Proc Univariate, Proc Transpose, Proc SQL

Responsible for data mapping, data cleaning and data validation done according to company specifications

Worked with extraction of data from operational data stores, transformed this data, and loaded them into the data warehouse or SAS data marts, using SAS DI studio.

Designed the flow of data into SAS data sets, OLAP cubes, and relational data base tables, and created reports using web report studio.

Worked with various testing teams to support the development process.

Responsible for the ad hoc reporting requests from the business users, and created excel based reports and made them available using AMO.

Gathered requirement for set up of new SAS EBI platform (9.2 to 9.3) for the client, coordinated with SAS admin teams for getting the access to the BI tools.

Skills utilized: SAS 9.2/9.3, SAS/BASE 9.2/9.3/EG 5.1, SAS/Data Integration Studio, Web report Studio, Excel/Access 2000, AMO, DB2, Solaris/Shell Scripting.

Preceding Position 4:

Company: Texas Education Agency(contractor)

Position Title: Sr. SAS BI Developer

Date of Employment:

July 2012 – February 2013

Duties and Responsibilities:

Involved in translating business requirements into reporting solutions and also in the educational data analysis.

Worked on SAS Enterprise Guide 4.3, SAS Web Report Studio, Management Console, information map studio for report development and delivery.

Developed and integrating the parameter driven reports in SAS using web report studio, EG, templates, stored processes, using multiple data sources.

Involved in fetching the data from various data sources such as, Oracle and DB2, using complex PROC SQL pass-through facility.

Converted data sets according to the report requirements, by creating appropriate dimensions for complex cubes, using both pre aggregated tables, and also star schema.

Created the calculated measures, using both the OLAP cube wizard, and also using MDX queries.

Applied efficiency techniques to create the reports using both OLAP cubes, and SAS data sets.

Responsible for the data and report testing by other developers.

Documented the report architecture from report proposal to the report development and deployment in production.

Skills utilized: Base SAS, SAS Macros, SAS/GRAPH, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Map Studio, SAS V9.3, SAS Enterprise Guide 4.3, Excel and Solaris.

Preceding Position 5:

Company: Cable Vision (contractor)

Position Title: Sr. SAS BI Analyst

Date of Employment:

January 2012 – June 2012

Duties and Responsibilities:

Worked on report development using a various SAS procedures and tools including ODS, Enterprise Guide, Web Report Studio and BI Dashboard.

Developed reports in WRS with IMS, and SAS stored processes to generate Excel, html and PDF reports.

Scheduled jobs and distributed reports on daily basis based on the user profiles via emails.

Involved in the development of aesthetically pleasing graphs using Dash boards, WRS and information delivery portal.

Developed web portal application to access and test the customer data base.

Accessed data from various data sources such as oracle and MySQL server using pass through facility.

Created graphs using SAS stored process, using proc sgplot, and populated them in WRS for analysis purposes.

Created SAS table, and SAS views to populate the results in WRS via information maps and by stored processes.

Created and managed custom prompts and sued them across the enterprise.

Worked with other teams to create web pages according to the business requirements.

Developed and maintained of SAS Information Maps to support Web Report Studio reporting.

Created OLAP cubes using SAS OLAP Cube Studio to serve as source for BI dash board and Information map studio

Devised and rolled out Excel Dashboards or Templates by using Pivot tables, Graphs, references and lookup functions.

Used proc DB load, proc Access, proc import, and export to convert the excel files to SAS data sets, and vice versa.

Created prompts on data ranges, and for customers search tool.

Used SAS Enterprise Guide to support ad-hoc reporting requirements.

Skills utilized: Base SAS, SAS Macros, SAS/Access to Oracle, SAS/STAT, SAS ODS, SAS/GRAPH, SAS Data Integration Studio, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Map Studio, SAS V9.2, SAS Indexes, SAS Views, SAS Enterprise Guide, Excel, Solaris

Preceding Position 6:

Company: CSC (NC MMIS) (contractor)

Position Title: SAS BI Programmer Analyst (contractor)

Date of Employment:

April 2010 – January 2012

Duties and Responsibilities:

Provided SAS programming and statistical support to the Medicaid data.

Created Summary Reports and Detail Reports using ODS facility with Proc Report, DATA NULL and Proc tabulate.

Created RTF, PDF, and EXCEL listings, tables and Reports using SAS ODS.

Involved in writing code using Base SAS & SAS/Macros to extract clean and validate data.

Ensured that analyzed data and programming code met regulatory and company standards and are consistently structured to permit efficient programming and reporting.

Performed Quality Assurance (QA) procedures on work performed by other programmers.

Accessed data from many sources, such as DB2, SAS data sets, Microsoft Excel and flat files.

Responsible for data mapping, data cleaning and data validation done according to company specifications.

Extracted of data from operational data stores, then transformed this data, and loaded them into the data warehouse or data marts, using SAS ETL studio.

Designed the flow of data into SAS data sets, OLAP cubes, and relational data base tables, and created reports using web report studio.

Loaded and unloaded of data using DB2 load utility for testing.

Extracted transformed and loaded of data using SAS ETL to data mart.

Worked with SAS DI (Data Integration) studio and planning of data ware house, generation of cubes using SAS DI.

Documented, built and validated job complexity for ETL procedures.

Worked with BA in requirement gathering and developed specifications for the report purpose.

Involved in testing process, created test cases and logging the defects and coordinated with other functionalities in the testing process.

Executed batch jobs in both mainframe environments and UNIX using shell scripting.

Worked on ad hoc requests from the client and also from the technical lead on need basis.

Worked extensively in finance and claims processing groups.

Converted packed decimals to regular format in SAS

Imported COBOL copy book to read EBCIDIC and ASCII format, using SAS data integration studio.

Skills utilized: SAS 9.2, Environment: SAS 9.2, SAS/BASE, SAS/GRPAH, SAS/Data Integration Studio, E-Miner, SAS/EG 4.2, 4.3, IMS, Excel/Access 2000, DB2-XQMF, File Manager, OPTIM, Windows, TSO, Solaris, SharePoint, Docbuilder, Silk Center, R2W, COBOL, JCL

Preceding Position 7:

Company: Icon Clinicals

Position Title: SAS Programmer Analyst – Clinical Trials

Date of Employment:

October 2009 – March 2010

Duties and Responsibilities:

Created Analysis datasets from raw data, for Safety and Efficacy data.

Created Safety tables like Subject Evaluation, Demographics, Adverse Events (AE), Serious Adverse Events (SAE), Med History, Previous and Concomitant medications, Lab Abnormalities according to guidelines.

Worked on CRT (Case Report Tabulation), Ad-hoc reports, FDA regulations such as CDISC, MedDRA, 21 CFR Part 11, ICH, GCP guidelines and other regulatory submissions.

Developed Tables and Listings using PROC REPORT.

Responsible for validation of SAS programs, reports by independent coding, examination of selected summary output.

Involved in generating protocol deviation reports for data cleaning, abnormal values with respect to labs.

Created descriptive stats between baseline, change and relative change at subsequent visits, tables based on questionnaire, correlation and plots.

Skills utilized: SAS 9.2 on Linux, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, Proc/SQL

Preceding Position 8:

Company: Vertex Pharma

Position Title: SAS Programmer Analyst – Clinical Trials

Date of Employment:

September 2008 – October 2009

Duties and Responsibilities:

Created Summary Reports and Detail Reports using Proc Report and Proc tabulate.

Created Safety tables like Subject Evaluation, Demographics, Adverse Events (AE), Serious Adverse Events (SAE), Med History, Previous and Concomitant medications, Lab Abnormalities according to CDISC/SDTM guidelines.

Worked on CRT (Case Report Tabulation), Ad-hoc reports, FDA regulations such as CDISC, MedDRA, 21 CFR Part 11, ICH, GCP guidelines and other regulatory submissions.

Responsible for working on protocol deviations for the study.

Created RTF, PDF, and HTML listings, tables and Reports using SAS ODS.

Involved in writing code using Base SAS & SAS/Macros to extract clean and validate data.

Ensured that analyzed data and programming code met regulatory and company standards and are consistently structured to permit efficient programming and reporting.

Performed Quality Control (QC) procedures on work performed by others.

Employed various SAS procedures, like Proc Print, Proc Report, Proc Freq, Proc Tabulate, Proc Means, Proc Univariate, Proc Transpose, Proc SQL.

Responsible for data mapping, data cleaning and data validation done according to company specifications.

Involved in generation of analysis data sets from raw data, efficacy datasets, safety datasets, adverse events reports, demographic reports and patient data listings.

Skills utilized: SAS 9.1.3 on windows, SAS/BASE, SAS/MACROS, SAS/GRAPH, Proc/SQL

Preceding Position 9:

Company: Alkem Laboratories Ltd.

Position Title: Programmer/Analyst

Date of Employment: June 2003 – December 2004

Duties and Responsibilities:

Worked on various phases of clinical trials.

Developed programs for QC of Safety analysis.

Created code to check over all counts, by treatment counts, table format and documentation.

Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros.

Used procedures such as Freq, Means, Univariate, Tabulate, Report, Transpose for statistical analysis, for ad hoc requests by other Bio-statisticians from clients.

Provided programming support for creation and maintenance of programs used for data entry, data validation, statistical report generation and program validation.

Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros.

Skills utilized: SAS/BASE, MACROS, SAS/STAT, SAS/GRAPH, and UNIX

Contact this candidate