Data Sql
Resume:
Ashok Kumar
acot7p@r.postjobfree.com
Objective:
To give the best quality service and demonstrate the competence that
satisfies the interest of the company.
Summary:
. 7+ years of extensive experience in the field of SAS in Programming /
Business Analysis and Data Analysis projects.
. Processed large datasets with billions of records for data
transformation including data cleansing, data scrubbing, data
profiling and applying business logic rules to incoming data.
. Expertise in advance SQL programming for joining multiple tables,
sorting data, creating SQL views, creating indexes, campaign
management and metadata analysis.
. Good command in using SAS/BASE, SAS/MACRO, SQL, SAS/STAT, SAS/ACCESS
SAS/CONNECT, SAS/ODS, SAS/GRAPH, Excel, Tagsets, Teradata, MS Office
tools with more than 5 years of experience.
. Created SAS Programs to generate new datasets from raw data files
imported and modified existing datasets using SQL, Set, Merge, Sort,
Update, Formats and Functions.
. Good command in SAS procedures, reporting and Summary procedures,
generating reports employing various SAS procedures like PROC PRINT,
PROC REPORT, PROC PLOT, PROC CHART, PROC SQL, PROC SUMMARY, PROC FREQ,
PROC TABULATE, and PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC
TRANSPOSE and Data _null_.
. Working experience with SAS tools, SAS Enterprise Guide, SAS
Enterprise Miner.
. Skilled in working with PROC SQL, SAS arrays and SAS Macros to
automate SAS tasks and to convert and produce file with different
formats as per the requirements.
. Understanding EBI requests and translating them into actionable
reports from acquiring relevant data, modifying data if needed,
building the reports, outputting the reports, etc.
. Strong skills in Developing SAS Programs for Data Analysis, Data
Requirement Analysis and Data Mapping for ETL process and working with
Analysis of Variance (ANOVA), Regression Analysis, Linear Models,
Multivariate Analysis, and Predictive Solution Models including
linear, multiple, polynomial, and nonlinear regression models.
. Experienced in handling data with data integrity during extraction,
manipulation, processing, analysis and storage.
. Excelled at identifying, developing and using strengths of team
members, as well as locating, detecting and resolving problems and
weaknesses of each team individual.
. Expertise in Data archival, Data Modeling and Data migration, ad-hoc
reporting and code utilizing SAS on UNIX and Windows Environments
. Expertise in SAS Data Integration (DI) studio, SAS Management
console and SAS BI suite
. Built data input and designed data collection screens-Managed database
design and maintenance, administration and security for the company.
. Responsible for leading software testing, troubleshooting, and
implementation.
. Support end-users, company-wide to resolve database and software
issues utilizing remote desktop tools.
. Database recovery and subsequent problem resolution.
. Meet with customers to determine their needs, gather and document
requirements, communicate with customers throughout the development
project to manage customer expectations, resolve issues, and provide
project status.
. Coordinates project development and implementation activities.
. Strong Knowledge in advanced Analytics and Data mining Techniques.
. Different data mining, query model, processing model, and data
collection techniques.
. Query Reports using Access and SQL.
. Design, coding, testing, debugging, and documentation of multiple
treatment and payment SAS programs for charge-off card data. Prepare
daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot
tables, and pivot charts, etc.), and present findings and
recommendations to all levels of senior management.
. Develop SAS and VBA macros for automating the analysis, process, and
report generation.
. Excellent programming skills in developing programs to increase the
performance and efficiency of SAS programs and importing, extracting
and loading the data into various servers like Oracle, SQL Server, DB2
with specific bulk load techniques.
Work Experience
Florida department of education:
May 2014 to Present.
Role: SAS Programmer
Florida department of education built an Educational Data Warehouse as a
part of State Wide longitudinal Data Round 4(SLDS R4) Federal Grant. EDW is
an integration of desperate source systems like K12 Schools, WDIS Technical
Educations, and Florida College Systems. EDW is used for longitudinal Data
Analysis by teachers, researchers, parents, legislatures and many more. In
this integrated data warehouse each student is identified uniquely
throughout the EDW by assigning a new education ID called Florida
Educational ID (FLEID). Part of this grant allows public users will access
all longitudinal reports in the form of SAS web reports and Dashboards.
Responsibilities:
. Extensively used the reporting capabilities of SAS EG and SAS
Microsoft Add-in to perform analysis on OLAP Cubes and Information
maps.
. Streamlined data preparation and ETL process, develop BASE SAS code
for individual reports and load summary data from various reports to
DB2.
. Collaborated with business analysts to develop strategies and code to
perform data quality check using SAS STAT capabilities with
descriptive statistics memos on critical data elements on incoming
data and data loaded to warehouse.
. Written Efficient BASE SAS Macro's to read and convert large EBCDIC
files from mainframe to SAS Datasets.
. Effectively used BASE SAS, Data step, Proc Report, Means, Tabulate and
SAS ODS capabilities to produce ad-hoc reports in PDF, Excel and RTF
formats for descriptive statistics and aggregations.
. Involved in writing code using Base SAS & SAS/Macros to clean and
validate data fromoracle tables.
. Worked with these SAS functions PROC STAT, PROC PRINT, MERGING,
MACROS, PROC SQL, SAS Import and Export, SAS Variables, nodupkey, PROC
Compare.
. Wrote SQL queries using PROC SQL.
. Build Quick Reports from Web Report Studio using Information maps,
create filters, graphs, and customize reports.
. Involved in producing analysis data sets by viewing metadata from SDTM
and ADAM data
sets. Developed various backend SAS application programs, such as Proc
import, export, Functions, Triggers, Procedures and Packages using SAS
and SQL language for the top management for decision making.
Environment: BASE, MACROS, ODS, SAS STAT, SAS Graph, SAS ACCESS, Hash
Objects,
SAS EBI Tools - SAS DI Studio, SAS OLAP Cube Studio, SAS Web Report
Studio, SAS Information Map Studio, SAS Information Delivery Portal,
SAS Enterprise Guide 4.2 and SAS Stored Process Applications, SQL, R (R
programming Academic),Windows, DB2.
Wellcare Health Plans.Inc (Florida)
March 2012 to April 2014
Role: Sr. SAS Consultant/Analyst
Responsibilities:
. Created customized reports to help client provide in understanding
risk and accordingly perform better customer selection and customer
satisfaction.
. Worked as the primary liaison between the business line, operations,
and the technical areas throughout the project cycle. Primarily
focused on analyzing and documenting business requirements.
. Proficiently used SAS procedures like PROC SQL to extract data from
different relational database management systems and used SQL
Assistant to analyze and query from the Teradata DB.
. Performed Data Cleansing widely during the ETL's Extraction and
Loading Phase by analyzing the raw data and writing SAS Program and
creating complex reusable Macros.
. Constructed SAS programs on UNIX platform to clean the data according
to the specifications.
. Coordinated with vital departments to analyze areas such as customer
retention, opportunities and customer segmentation. Store and
distribute SAS Enterprise Guide results in different formats such as
HTML, Tagsets, PDF, WORD based on the user group requirement with
SAS/ODS.
. Extracted, transformed and loaded data from large Teradata tables
using Data stage in data ware house. Passed parameters in shell script
to read daily and on request jobs to reduce complexity of business
process.
. Performed data analysis, statistical analysis, generated reports,
listings and graphs using SAS tools.
. Maintained large data sets, combined data from various sources in
varying formats to create SAS data sets.
. Assisted in DI Studio, EBI design meetings to build the SAS data mart.
. Used SAS/ACCESS to gather data from RDBMS like TERADATA and DB2
. Create partition tables and apply threading techniques using SASTRACE.
. Used SAS Data Step logics to Sort, Merge, Stack, Update and Interleave
datasets for producing required analysis of data and used SAS Business
Intelligence to produce required Reports.
. Execute data crunching, write codes, merge/purge/ and split data, and
do ad hoc queries/cut data programming in SAS
. Worked with complex datasets to extract customized reports using PROC
SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a
preferred list of customers as per the given requirements from
business analysts.
. Developed Stored Processes to distribute reports in a secure manner.
. Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
. Efficiently prepared and published various performance reports and
presentation.
Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT,
SAS/GRAPH, SAS Management Console, SQL Script, SAS Enterprise Guide, Data
Modeling, Data Migration,SAS EBI, SAS DI Studio 3.4, JavaScript, HTML,
Teradata, Oracle9i, PLSQL Developer, UNIX.
General Electric, NY
May 2011 to Feb 2012.
Role: SAS Programmer
Responsibilities:
. Extracted data from the Relational database using SAS/Access tools
like PROC SQL and
libname engine into the SAS environment.
. Involved in writing code using Base SAS & SAS/Macros to clean and
validate data fromoracle tables.
. Worked with these SAS functions PROC STAT, PROC PRINT, MERGING,
MACROS, PROC SQL, SAS Import and Export, SAS Variables, nodupkey, PROC
Compare.
. Wrote SQL queries using PROC SQL.
. Created datasets and generated reports using PROC Tabulate, PROC
Report, Data Null, SAS arrays, PROC SQL and Macros.
. Build Quick Reports from Web Report Studio using Information maps,
create filters, graphs, and customize reports.
. Involved in producing analysis data sets by viewing metadata from SDTM
and ADAM data
sets. Developed various backend SAS application programs, such as Proc
import, export, Functions, Triggers, Procedures and Packages using SAS
and SQL language for the top management for decision making.
. Implemented all modules logic by using Triggers in a macro program.
. Good understanding of database objects and ability to triage issues.
. Lead experience in managing data migration teams for end to end data
migration processes, creating data migration functional
specifications, data flow, data mapping specs, data extraction, data
cleansing, data transformation, data remediation, data mitigation,
data migration to SAS, Data archiving and system retirement.
. Experience with SAS Demand Driven Planning and Optimization (DDPO)
. Provided technical support to end users on SAS, SAS Enterprise
Miner, SAS Enterprise Guide, SAS Data Integration Studio and SAS BI
Suite
. Created a SAS customized reports using proc report, proc summary, proc
means, proc
freq, proc sort and proc transpose.
. Produced outputs (TLGs) as per Specifications in Reporting and
Analysis document. Converted
existing raw-data into CDISC standards and reviewed CRFs to ensure the
consistency and adequacy with the protocol requirement.
. Created and maintained SAS programs to generate derived datasets and
required summary
reports. Handled Demographic data, Adverse Events (AE), laboratory
data (lab data) and physical and vital signs.
. Created various graphs such as Bar Charts, Line Plots, Profiles Chart,
Scatter plots using SAS/GRAPH.
. Developed SAS programs to generate baseline, follow-up, drug safety
reports from Oracle data base
. Develop SAS programs to generate data summaries, data listings and
safety analysis.
. Statistical procedures were applied as per the protocols provided by
bio statistician using SAS application.
. Graphical and HTML reports were generated on demographics, safety and
baseline characteristics
Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/STAT, SAS/CONNECT,
SAS/GRAPH, SAS/ODS, SAS/Web Report Studio, SAS EG, SAS/ Information Map
Studio 3.1, SAS DI Studio, Data Modeling, Data Migration, MS Excel, DB2, MS
Visio, MS Project, Teradata, Oracle9i, EXCEL, UNIX.
McKesson Pharmaceuticals, Inc San Francisco, CA
July 2010 to April 2011
Role: Clinical SAS Programmer
Therapeutic Area: Cardiology
Responsibilities:
. SAS programming expertise in producing ADAMS, Tables, Listings and
Graphs from SAS/BASE, SAS/MACRO and SAS/GRAPH, SAS/SQL, SAS/ STAT.
. Develop, modify and validate SAS programming work according to
Statistical Analysis
plan (SAP).
. Created and validated ADAM datasets like ADSL and BDS datasets for the
study
. Created tables, listings, graphs for safety reports.
. Performed Statistical Analysis using SAS/STAT procedures PROC MEANS
PROC FREQ
etc
. Worked on datasets like Demographics, AE, Vitals, Concomitant
medication, Physical
Examination, Labs.
. Generate reports, listings and graphs using SAS/BASE, SAS/MACRO,
SAS/SQL and
SAS/STAT.
. Create reports in RTF/pdf format using SAS Output delivery system as
per the client
requirement.
Environment: SAS 9.1, BASE/SAS, SAS Macro, SAS/ACCESS, SAS/CONNECT,
SAS/ODS, SAS/Internet, App Dev Studio 2.0/2.02, SAS/SQL, SAS Warehouse,
SAS DI Studio, Data Modeling, MS Office, Unix.
MMS Holdings Inc Canton, MI
Sept 2008 to May 2010
Role: SAS Programmer/Analyst.
Responsibilities:
. The project included generation of statistical analysis on data using
SAS, SAS/Stat, SAS/Access, SAS/SQL, SAS/Macro, SAS/Graph, and Oracle
on Windows NT for the e-Commerce and CRM group. Performed ETL
operations to upload data onto Oracle databases, created and maintain
Macro libraries.
. Used SAS and SAS Tools for pre-processing data, data analysis,
statistical analysis, and created
. Permanent formatted SAS data sets.
. Performed Data analysis, statistical analysis, generated reports,
listings and graphs using SAS Tools SAS/Base, SAS/Macros and
SAS/Graph, SAS/SQL, SAS/Connect, SAS/Access, campaign management.
. Used sorting and merging techniques on the input data sets for Data
Preparation, to get the required output and then writing the code
using SAS tools.
. Developed routine SAS macros to create tables, graphs, Tagsets,
Teradata and listings for inclusion in reports and maintained existing
ones.
. Developed reports using PROC REPORT, PROC TABULATE and DATA_NULL_ for
analysis.
. Drive data migration strategy and process to enable quality data
delivered without any delay
. Designed statistical summary tables, graphs, and patient data listings
using base SAS procedures like proc summary, proc Tabulate and
SAS/Graph.
. Conducted and generated the Regression, Correlation studies and
Analysis of Variance (ANOVA) using Proc REG, Proc CORR, Proc GLM, Proc
ANOVA.
. Performed data extraction by converting MS-Word documents and MS-Excel
tables into SAS data sets.
. Analyzed data through problem solving. Performed data archival, Ad-hoc
reporting, and coding utilizing SAS on WINDOWS.
. Converted ORACLE data tables into SAS data files using SAS SQL Pass
through Facility, and uploaded SAS data files into ORACLE tables using
SAS Dbload procedure.
. Build reports from the processed data, generated several reports from
analyzed data and converted the data into dbf format and sent to the
client and also the reports were sent to web, creating Universes using
web intelligence.
. Performed program documentation on all programs, files and variables
for accurate historical record accordingly for future reference.
. Used Output Delivery System (ODS) facility to write custom safety and
efficacy reports directing SAS output to RTF and HTML files.
. Extensively used the SAS/ Macro facility to write weekly and monthly
reports.
Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, SAS DI Studio, Data
Migration Oracle, DDPO, Teradata, Window NT.
Cognizant, Chennai, India.
Aug 2007 to April 2008
Role: SAS Data Analyst
Responsibilities:
. Data gap and database anomalies like Insert, Delete and Update were
efficiently used.
. Extensively developed programs and performed unit test using SAS, DB2,
and SQL for analysis of large datasets and data manipulation.
. Proficient use of SAS/Access, SAS/Connect to connect to various
databases such as development, test and production database.
. Statistical Analysis Software (SAS) Proficiency: (PROC SQL against
Oracle and SQL Server databases, PROC Report, PROC
Tabulate, Excel, Tagsets, Teradata, ODS report output)
. Experience using SAS as a data extract, transform, and load (ETL)
tool
. Well versed with importing, Accessing, Integrating and synthesizing
data using SAS/STAT to produce statistical analysis such as
regression, multivariate, survival, psychometric and cluster analysis.
Quarterly and annual sales and profit summary reports were prepared
using the Proc Report.
. Developed and maintained Excel Reports for sales data on a need basis.
. Expertise in Microsoft Excel for development, maintain and automate
the report using different excel functions, creating crucial reports.
. Implemented data management plans designed to meet project deadlines.
Environment: Base SAS, SAS EG, SAS/Access, SAS/Connect, SAS/Stat, SAS EBI
Enterprise Server, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, MVS, JSP,
Oracle 9, DB2, PL/SQL, Teradata, MS Excel.
Accenture, Bangalore, India
January 2006 to May 2007 Role: Clinical SAS
Programmer
Therapeutic Area: Diabetology.
Responsibilities:
. Extract data from Oracle database using SQL pass through facility, MS
Access, Tagsets Excel sheets, and Delimited text files. Import and
export procedures were applied in these procedures.
. Extracted, merged the data from diverse sources using matching
conditions and then upload in to the data warehouse based on user
defined Business rules.
. Develop SAS Reports using PROC REPORT, PROC TABULATE and load SAS data
sets as tables into Oracle and SQL Server using SQL pass through
facility, library reference method.
. Validate data and create reports using different procedures like Freq,
Means, Transpose, Datasets, Sort, Compare, SQL, REPORT and SAS/ODS
facility.
. Create, enhance and incorporate new systems with existing systems SAS
Programs for generating reports, graphs, tables and lists.
. Indexing huge SAS data sets and utilizing those indexes as a part of
SQL queries for quick results and write SQL joins to Merge the data
sets to find exceptions from different tables.
Environment: SAS9.0, MS SQL, HTML, Windows NT/2000, Teradata, Oracle and
Linux.
References:
Sreeni: acot7p@r.postjobfree.com
Tami: acot7p@r.postjobfree.com
Contact this candidate