We provide IT Staff Augmentation Services!

Lead Data Analytics Consultant  Resume

Pleasanton, CA

PROFESSIONAL SUMMARY:

  • Over 8 years of experience, providing innovative solutions in financial and healthcare domain.
  • Experience in developing SAS procedures, macros, data steps for data cleaning, formatting and reporting.
  • Strong experience in SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/ODS, SAS/SQL.
  • Strong experience in SAS/GRAPH, SAS/STAT, SAS/ACCESS in WINDOWS and UNIX environment.
  • Experienced in procedures like with PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, PROC APPEND, PROC TRANSPOSE.
  • Performing Adhoc reports by using Oracle, Teradata, BTEQ, and UNIX.
  • Strong skills in Data Warehouse, Data Exploration/Extraction, Data Validation, Reporting and Excel.
  • Knowledge in Migration of SAS codes from PC SAS to EG SAS and 9.2 to 9.4.
  • Extensive experience in preparation of reports, tables, listings and graphs.
  • Profound knowledge and strong experience in table analysis using PROC FREQ with LIST, OUT, MISSING options.
  • Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
  • Experience in MS Excel, PowerPoint and Other MS Office Suite.
  • Enhancement and evaluation of credit/debit card system and Financial Application.
  • Validating, testing, debugging code to determine accuracy and quality.
  • Familiar with Data Visualization tool like tableau.
  • Extensively used Teradata SQL, BTEQ for the backend process to build the business rules
  • Familiar with a Teradata Database environment (Large Database, Thousands of Tables and Views).
  • Extensive experience in SAS Visual Analytics which provide metadata centric environment for a wide range of business intelligence and environment.
  • Proven skills in data cleansing, data archival, data migration on different SAS Environment.
  • Developed weekly, monthly, quarterly reports by using MS Excel, MS Access, Teradata,SQL.
  • Experience in Automating and Scheduling SQL Scripts in UNIX using Korn Shell Scripting.
  • Experienced in complete lifecycle of systems design and development.
  • Strong experience with databases like Oracle, MS SQL Server, DB2 and MS Access.
  • Senior Data Analyst with extensive experience in Systems and Technical Analysis.
  • Possess experience as a SAS programmer in UNIX, Mainframe and PC Environment.
  • Highly successful in developing synergistic relationships to bring projects to completion on time and within budget.
  • Quick learner and excellent team player with good communication and presentation skills.

TECHNICAL SKILLS:

SAS Procedures: Print,Means,univariate,Correlation,Regression,SQL,Report,Freq,Sort,Tabulate,Format,Import,Export,Transpose,Compare,Gplot and Gchart.

SAS BI Tools: SAS Enterprise Guide, SAS Data Integration Studio, SAS Management Console,SAS Information Map Studio,SAS customer Intelligence Studio.

SAS Expertise: SAS/BASE,SAS/MACROS,SAS/STAT,SAS/GRAPH,SAS/SQL.SAS/ACCESS,SAS/ODS,SAS/REPORTS.

Advanced SAS: Macros, Data null, reports, array processing, hash objects,pointers,display manager.

Databases: Teradata, SQL Server 2000/2005, Oracle (8i/9i/10g), MS - Access 97/2000, PL/SQL, T - SQL, ADO.NET, SQL

Scripting: UNIX Shell Scripting (Bourne, Korn, C Shell), VBscript, VBA, JSP

Reporting tools: Crystal reports 9.0/10.0, XtraReports

Platforms: Windows NT/2000/2003/XP, UNIX, DOS+

PROFESSIONAL EXPERIENCE:

Lead Data Analytics Consultant

Confidential, Pleasanton, CA

Responsibilities:

  • Dealt with huge quantities of Medicaid and Medicare claims data
  • Imported data from SQL Server and Excel to SAS datasets.
  • Modified existing datasets using Set, Merge, Sort, formats, functions and conditional statements.
  • Analytical function applied across data in multiple sources (Hadoop, Teradata, Excel).
  • Involved in establishing connections to different data sources (SQL Server, Vertica, Teradata, SAP, Salesforce, Azure Cloud, and web site data) and pulling relevant data from these source systems for data modelling.
  • Used SAS datasets to create reports using Proc Print, Reports, Proc Transpose, Proc Tabulate, Proc Import, Proc Freq and Proc SQL.
  • SAS Visual Analytics enables you to gain insight from all your data, no matter the size of your data.
  • Integrated suite of web applications that offers intuitive, drag-and-drop interactions, rapid, highly visual responses, and role-based access to functionality is done by SAS Visual Analytics.
  • Created Dashboard Reports in SAS visual Analytics as per Clients Requirement.
  • Involved in migration from 9.1 SAS to 9.4 SAS.
  • Performed the automated data driven testing using Winrunner.
  • Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
  • Used options like DROP, KEEP and RENAME to work with some variables.
  • Sorting, printing and summarizing the SAS data by modifying and combining SAS datasets.
  • Developed various reports like daily input report, monthly reports Report procedure.
  • Extensively used SAS/Macro facility to provide reusable programs that can be conveniently used to update reports.
  • Proc summary, proc means, proc tabulate are used for report generation.
  • Performed detail analytics while producing financial reports so that the financial data is checked and are accurate
  • Generated reports, tables, graph to identify market opportunities and recommended business strategies based on analysis of internal and external data sets.
  • Developed programs using the Libname statement and SAS Views to extract and report error statistics.
  • Updated business specifications, created system flow charts and prepared test plans.
  • Used Microsoft Access and Excel to provide output analysis data

Environment: SAS 9.3, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/CONNECT, SAS Visual Analytics 7.3, Excel, Access, Oracle, SQL, PL/SQL, Teradata, UNIX, Tableau, Hyperion Brio, Business Objects.

Sr SAS Programmer

Confidential, Des Moines, IA

Responsibilities:

  • Participated in First production for customer campaigns across a variety of products and marketing.
  • Coordinated with marketing department to finalize the list of individuals to whom the loan can be forwarded so that targeted campaign can be launched.
  • Developed Macro programs to clean, validate and update data to perform data analysis and generate reports.
  • Modified existing datasets using Set, Merge, Sort, formats, functions and conditional statements.
  • Debugged, created maintained and documented adhocs reports on demands.
  • Used options like DROP, KEEP and RENAME to work with some variables.
  • Used Teradata/SQL, Oracle, UNIX Shell Script, SPSS, STATA, R, MS Office (Especially advanced in Access, Excel VBA/Pivot Table & PowerPoint), exposure to Business Objects.
  • Provided database support to modeling and production team.
  • Performed QA audits to ensure that all delivered files were validated by matching the output results to the business requirements.
  • Generating code for HTML using VBA
  • Importing/exporting large amounts of data from files to Teradata and vice versa.
  • Used FTP (File Transfer Protocol) to transfer files across platforms
  • Analyzed the web based Product Offering Engine financial applications for the creation of credit card campaigns involved in Mobile Payment Application.
  • Using SQL queries, extracted data for metrics reporting from a variety of systems, Including Loss Mitigation, Recovery, and Business Banking.
  • Developed analytical processes, statistical models and quantitative approaches, leveraging SAS ad hoc and automated reporting capabilities.

Environment: SAS/BASE 9.1.3, SAS/MACRO, SAS/Enterprise Guide, SAS/ODS, UNIX, SQL, MS Office.

Sr Data Analytics Consultant

Confidential, Los Angeles, CA

Responsibilities:

  • Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports using Tableau.
  • Creating macro with dynamic parameter and Conditional joining of sass data sets using lookup.
  • Export data from sass data set to excel, csv and html.
  • Using n and error for conditional processing and iterating.
  • Creating delivery plan to ensure, as a team we meet deliverables timeline and meet or exceed expectation.
  • Manage Development and execution schedules and distribution of work as per skill sets of resource.
  • Creating and publishing weekly project status, project plans and reports to stake owners, manager and team.
  • Creating and redefining project plans as per requirement and change request respectively.
  • Requirement gathering from client.
  • Benchmarking deliverables to exceed client’s expectation (Customer first).
  • Research and development in SAS and VBA.
  • Creating ETL jobs for integrating various business process and data.
  • Creating reusable macro and macro variable.
  • Data cleansing and validating.
  • Using dictionary table for creating data set, subsisting data sets, transpose data sets, concatenating multiple columns and conditional check.
  • Changing format of data as required in output or reports as per stakeholders understanding.
  • Extensively used Data Null and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.

Environment: SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/CONNECT, Excel, Access, Oracle, SQL, PL/SQL, Teradata, UNIX and Windows XP.

SAS Programmer

Confidential, Hartford, CT

Responsibilities:

  • Design, select appropriate SAS procedures for each statistical analysis.
  • Generated output in various formatted files such as Excel sheets, RTF and PDF using SAS/ODS.
  • Test-run SAS program on mock data to ensure smooth analysis implementation.
  • Use PROC SQL/IMPORT to import from mainframe oracle databases and .xls sheets.
  • Standards with the techniques of Macro, SQL Join, and DATA Step Sort and Merge.
  • Produce quality customized reports as per client requirement.
  • Migrated data from Flat Files to Oracle database Designed scripts in SAS to be compatible with Oracle to load and access data from the Oracle tables.
  • Work with statistician to analyze the results obtained from various statistical procedures like PROC REGRESSION.
  • Connected to Mainframe and Oracle from SAS using Macros.
  • Experience in creating user friendly macros and replacing the code with macros to reduce code redundancy.
  • Develop and debug routine SAS macros to create tables, graphs and listings.
  • Providing descriptive statistical analysis using tools FREQUENCY, MEANS and UNIVARIATE.
  • Imported data in the form of sas datasets from flat files of various formats like tab delimited, .CSV, etc.
  • Maintained large data sets, combined data from various sources in varying formats using set and merge.
  • Developed Queries using PROC/SQL to retrieve the data based on the matching columns.
  • Design and develop a front application in VB 5.0.
  • Created and maintained data management and statistical report programs.
  • Created data sets from raw data sets for the analysis of safety and efficacy data using SAS to access remote clients.
  • Created Functional requirements and design document.
  • Created summary data using various functions, arrays and transpose.
  • Worked extensively with business users on requirements gathering, analysis and documentation.
  • Performed data mapping, data transformation, validation, and documentation.
  • Sorting, printing and summarizing the SAS data by modifying and combining SAS datasets.
  • Performed data validation by creating SAS code to clean up the invalid data entries.
  • Contribute to the development of manuscripts, labels, scientific and commercial presentations, and regulatory response documents.
  • Assisted statisticians in generating frequency distributions and to present the results in histograms, box-plots, pie-chart and scatter-plots using the graphical procedures.
  • Move data sets across platforms (from PC and Mainframe to UNIX and Vice Versa).
  • Worked directly with end users to gather Business requirements.

Environment: SAS 9.3, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/CONNECT, Excel, Access, Oracle, SQL, PL/SQL, Teradata, UNIX and Windows.

SAS Programmer/ Analyst

Confidential

Responsibilities:

  • Created SAS data mining and scoring data sets from source tables by programming in BASE SAS. Report Generation and Documentation with respect to evaluation of model performance and effectively communicating the results to higher management
  • Responsibilities include writing SAS MACRO CODE, SCL to read and create METADATA files on Unix.
  • OLAP Cubes and ETL skills to provide for all types of programs.
  • Pulled DB2 fields for marketing campaigns and used SAS for reporting campaigns.
  • Created complex and reusable Macros and extensively used existing macros and developed SAS
  • Developed an Automated Quality Control System for Data Validation and data integrity.
  • Documentation, preparing statistical reports using SAS.
  • Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
  • Develop FASTLOAD and MLOAD scripts to load data from legacy system and flat files through Informatica to Teradata data warehouse.
  • Involved with Business analysts to Provide Business Performance Data using Teradata, Oracle, SQL, BTEQ, and UNIX.
  • Wrote BTEQ, SQL scripts for large data pulls and ad hoc reports for analysis.
  • As per Ad-hoc request created tables, views on the top of the Finance Data mart/ production databases by using Teradata, BTEQ, and UNIX.
  • Created tables, indexes, views, snapshots, database links to see the information extracted from SQL files.
  • Created and implemented a new enterprise-wide Data Quality standard to further address emerging data quality risks- including Basel compliance
  • Created different set of tables (Like Set, Multiset, Derived, Volatile), Macros, views, procedures using SQL scripts.
  • Worked on Testing Primary Indexes and SKEW ratio before populating a table, used sampling techniques.

Environment: SAS 9.3, SAS/BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SAS/CONNECT, Excel, Access, Oracle, SQL, PL/SQL, Teradata, UNIX and Windows.

SAS Programmer

Confidential

Responsibilities:

  • Used BASE SAS, Macros, SAS Enterprise Guide, and SAS SQL for programming.
  • Modified macros for report generation using SAS Macros as per the requirements.
  • Programmed with SAS Enterprise Guide query builder for constructing complex queries analysis.
  • Extensively used Data Null and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files.
  • Develop, enhance and execute complex programs and reports with proper documentation.
  • Worked with complex datasets to extract customized reports using PROC SQL, PROC SORT and PROC REPORT, PROC TABULATE.
  • Created SQL views for retrieving and dynamically updating data.
  • Maintaining large data sets, i.e. reading in data from various sources in various formats to create SAS data sets and/or ASCII files.
  • Documenting the process, i.e. documenting all the possible information about the application like SAS programs, DATA files and source.
  • Preparing project plan for the execution.
  • End to end project management and hands on delivery when required.
  • Sets up QA/QC framework and ensures adherence and constant improvement.
  • Used SAS system macros for error handling, code validation, date stamping of log files, collected files to a given directory and scheduling.
  • Develops business and technical knowledge of team members and identifies opportunities of improvement.

Environment: Base SAS, SAS/SQL, SAS/Graph, SAS/Stat, SAS/Access, SAS Macros, MS Access, VBA, SAS UNIX.

Jr. SAS Programmer

Confidential

Responsibilities:

  • Involved in the support of Phase I clinical trial
  • Responsible for developing new SAS programs and modifying existing SAS programs.
  • Convert MS-Excel, MS-Access tables into SAS data sets.
  • Created and validated analysis datasets based on the dataset specification, annotated CRF and raw datasets.
  • Perform statistical analysis of complex business data sourced from disparate systems.
  • Extensively used SAS for generated code which can give output to the desired formats.
  • Perform statistical analysis and data modeling for research and technical data.
  • Produced customized reports using PROC REPORT, PROC TABULATE and PROC SUMMARY.
  • Provided descriptive statistics using PROC MEANS, FREQ and UNIVARIATE.
  • Develop and debug routine SAS macros to create tables, graphs and listings.
  • Using n and error for conditional processing and iterating.
  • Using SAS ODS and add-in to generate reports in various UI formats as per requirements.
  • Sorting, printing and summarizing the SAS data by modifying and combining SAS datasets.
  • Created edit-check program and created clinical review listing for clinical team to review for data consistency.
  • Developed SAS Scripts and SQL for Data Extraction and Loading into flat files.
  • Sorting, printing and summarizing the SAS data by modifying and combining SAS datasets.

Environment: Base SAS, SAS/SQL, SAS/Graph, SAS/Stat, SAS/Access, SAS Macros, MS Access, VBA, SAS UNIX.

Hire Now