Objective

Seeking Data Management, Data Analyst, Visual Analytics, Modeler and SAS Clinical programmer .

SUMMARY

• Certified SAS Advanced, SAS Clinical and SAS Base programmer with more TEMPthan 6 years of experiences
• Diverse experiences in data management, statistical modelling, SQL/SAS programing, quantitative and qualitative data analysis, data modeling, clustering, and advanced data processing such as querying and mining large data, time series analysis, generalized linear model, linear and logistic regression, multivariate regression analysis, neural networks, hypothesis testing, ANOVA, MANOVA
• Extensive IT industry experience in software development using Windows using SAS, proficient in data step, SAS/BASE, SAS/SQL, Proc/SQL SAS/Macro, SAS/ETL, SAS/ARRAY, SAS/Connect, SAS/Access, SAS/ODS, SAS, SAS/EXCEL, Excel/Macro and SAS/GRAPH, Proc Freq, Proc Means, Proc Tabulate, Proc Format, Proc Transpose, Proc Summary, Proc Compare, Proc Contents and extensive experience in DATA STEP programming and SAS functions like SUBSTR, INDEX, SCAN, COMPRESS, COMPBL, STRIP, INTNX, INTCK, CAT etc.
• Define business problems, design a solution, implement solution and monitor teh solution if it needs modification by developing models.
• Creates ‘Best Practices’ guidelines for creating and maintaining SAS projects/programs; participate in peer reviews for designs, code, and other work products.
• Skilled in SAS/SQL programming, merging SAS large datasets, preparing data, producing and validating reports, SAS formats, and managing data, data extraction by infile & input statements from different source and cleaning data ready for report, merging data set using different SAS functions.
• Strong in SQL reporting, PROC SQL, PROC in UNIX & PL SQL programming skills for data mining, creating, maintaining existing code, adhoc reporting and supporting teh reporting functions.
• Extraction or pull huge data from RDBMS, merging, data cleaning, data preparation & reporting in different SAS ODS format tables, listing & graphs.
• Created Statistical predictive modeling like logistic regression & linear regression models for identifying default customer non default for approval of credit loans & promotions.
• Created reports in SAS and imported from and exported to Excel spreadsheets, Oracle and other applications and also involved in extracting data from XML files, flat files, CSV, Dat files, unstructured data and relational databases, transforming teh data and loading into teh data warehouse(DW), worked in data integration (ETL) and SQL programming and reporting.
• Strong noledge of management need and issues regarding data analysis and good understanding of leveraging technology and business process skills in finicail industry to generate innovative solutions by providing insights, & actionable recommendation.
• Created Ad hoc reports by using SAS ODS in different format, like PDF, RTF & HTML
• Created relational data structures, including relationships between tables and grouping data. & technical skills to manipulate and analyze data in a variety of formats (e.g. SAS, SQL, Access, JCL)
• Created reports in SAS (SAS reporting) and imported from and exported to Excel spreadsheets, Oracle, DB2, Unix and other applications and also involved in extracting data from XML files, flat files, CSV, Dat files, unstructured data and relational databases, transforming teh data and loading into teh data warehouse(DW), worked in database manipulation (ETL), SQL programming and reporting in tables, listing & graphs.
• Strong Knowledge of advanced excel for reporting (H - Lookup, V-Lookup, Pivot, Index, macros, SumIf, Sum product, VBA etc) & PowerPoint for presentation.
• Created dashboards and data visualizations to communicate meaningful metrics to teh management team.
• Perform hypothesis test for different level projects, variance test, validation, verification, modeling building & model selection.
• Strong Experience in data analysis & systems implementation for support of large complex projects & documentation with data issues & adhere to data security.
• Strong noledge of SAS visual analytics by using SAS 9.3- SAS 9.4, SQL, Tableau & Advanced Excel in medical industry in putting reports in Dashboard.
• Created SAS program, maintain teh existing SAS program, work with development team to address & solve debug issues.
• Consult with project staff on project needs & maintain professional relationship with project personnel
• Publish and validate results to be consumed by downstream systems & applications.
• Worked in defining analytical variables & help consulting with project staff on project needs.
• Created SAS macros program for developing routine programming codes & test, debug programming codes developed by junior programmers & documentation.
• Ability to drive matrices from data, validate Inputs, analyze logs from production jobs & develop reports by using business intelligent tools.
• Supervise teh work of junior programmers in area SAS Analyst/Programmers serving on teh same projects.
• Strong experience with SAS functions, formats, informat & noledge of UNIX environment.
• Manage data, pull data from data marts & different external database, cleaning & ready for reporting & model development.
• Worked with data manager in data quality control (QC), verification, data security procedure & data validation check by using different SAS procedures to support technical reports.
• Work with teh technology team and other stakeholders on setting reasonable expectations regarding data formatting and turn-around times.
• Worked with data teams in supporting any issues related with data.
• Strong data visualization, Big data Hadoop & reporting by using business intelligence tools like tableau
• Attention to detail, communication skill, time management, leadership skill, independent solving skill, team work, assigning projects according priorities, and interpersonal skill.

TECHNICAL SKILLS

SAS Tools: SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS, SAS/Report, SAS Data Integration Studio 4.9Statistical Tools: SAS v 9.x/8.x, 6.x, SPSS, R, SQLDatabase: Oracle, SQL Server, MS AccessOperating Systems: UNIX WINDOWSPrograms: Microsoft Office Suite (Word, Excel, PowerPoint, Access and Outlook)

PROFESSIONAL EXPERIENCE

SAS Programmer,

Confidential,

Responsibilities:

• Involved in data analysis and modeling projects from sample design, reception and processing of data, performing analyses and modeling to final reports/presentations, communication of results and sales support.
• Queried and mined large data sets, combined data from disparate sources to identify insights and patterns; apply both statistical and business noledge to ensure accuracy of insights using SQL, SAS/ETL, SAS/SQL and SAS.
• Utilized advanced statistical techniques to create high-performing predictive models and creative analyses to address business objectives and client needs using different statistical modelling and analysis tools using SAS, SPSS and Excel and involved in data validating data using Excel and SQL/SAS.
• Involved in advanced statistical analysis, such as development of production-ready algorithms, cluster and decision trees
• Strong experience in SAS Integration Studio for data integration & reporting.
• Experience in handling project in identifying default customer from non-default customer & Hadoop data management for teh entire analytic life cycle, me.e from data management to data exploration, model development like logistic regression model and deployment.
• Design and generate tracking and data entry tools as needed.
• Played a pivotal role in summarizing findings, preparation and presentation of reports to key stakeholders and played an active role in preparing and presenting complex written and verbal reports, findings, and presentations
• Created clear and easy to understand reports for client needs and third party collaborations.

Environment: SAS 9.2/9.4, SPSS, SAS/WPS, SAS/ETL, SAS/SQL, Excel, Word, PowerPoint, Tableau, R

Technical IT Consultant and SAS programmer

Confidential, Eritrea

Responsibilities:

• Construct, manipulate large and complex datasets using SAS/EG for data management
• Responsible for testing, debugging, revising and refining SAS programs
• Modify incoming data using SAS/SQL code.
• Experience in implementation of large complex projects.
• Analyzed large data sets using statistical techniques such as general linear and mixed models, analysis of variance
• Perform descriptive and multivariate statistical analyses using SAS
• Generate statistical report, summary tables and graphical representations for financial reporting.

Environment: SAS 9.2, SAS9.4, SAS/Macro, SAS/ETL, SPSS, Excel, ACCESS, VBA, SAS Data Integration Studio 4.9

Statistical programmer, Data analysis and SAS Clinical programmer

Halibet Hospital, Eritrea

Responsibilities:

• Extracted data from Clinical database, me.e data submission strategy, me.e., legacy data, pooling data, communications with regulatory agencies
• Provide Statistical programming support for clinical trials data reporting with guidance from Biostatistician.
• Reviewed clinical protocols, Statistical Analysis Plan (SAP), data management plan, aCRF (Annotated CRF) to meet company needs & requirements.
• Identified and correct data step syntax and programming logic errors.
• Provide analytical support to clinical trials under supervision of Biostatistician.
• Assess processes and procedures involved to bring together disparate inpatient datasets (including across studies) into one cohesive dataset that is ready for use by analysts.
• Performed data analysis on teh datasets & summary report on integrated summary of report (ISS) & ISE
• Produced customized and ad hoc reports, listing, and graphs.
• Prepared SDTM, AdaM, and ODM data sets as per CDISC standards to submit regulatory bodies (FDA).
• Performed validation analysis data sets, tables, listing, figures and graphs derived from clinical data set.
• Worked in clinical trials for different therapeutic area specific analyses
• Contribute in develop complex SAS Macros to simplify SAS code and TEMPeffectively reduce coding time
• Extensive use of PROC SQL to perform queries and Joins
• Involved Validating teh data sets and comparing teh results to that of source programmers output
• Worked Generated output in various formatted files, me.e define.xml & pdf for regulatory bodies.
• Exported data and report to sponsor and other clients
• Worked in planning and executing teh transfer and analysis of data for data safety monitoring boards/independent data monitoring committees

Environment: Base SAS 9.2 SAS 9.4, SAS MACROS, SAS CLINICAL, SAS/GRAPH, SAS/SQL, SAS ETL and SPSS