SUMMARY

• SAS Certified Statistical Business Analyst, Certified SAS Advanced, SAS Clinical and SAS Base programmer wif 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, Postgres SQL, SAS/Macro, SAS/ETL, SAS/ARRAY, SAS/Connect, SAS/Access, SAS/ODS, SAS, SAS/EXCEL, SAS/EG, 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 for marketing department.
• Worked wif credit risk models by developing logistic regression model to identify default customer from non - default customer for approval of application loan.
• Plan & coordinate market research by developing models, logistics, linear regression, clustering & decision tree.
• Creates ‘Best Practices’ guidelines for creating and maintaining SAS projects/programs; participate in peer reviews for designs, code, and other work products.
• Skilled in writing SAS scripts & SQL programming for merging SAS large datasets, preparing data, producing and validating report, 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.
• Worked in data modeling for operational, retail analytical research, credit loan & relational Databases.
• Strong in SQL reporting, PROC SQL, SAS scripts in UNIX platforms & 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, transformation & reporting in different SAS ODS format tables, listing & graphs.
• Getting a trends, patterns and correlation from big complex data sets.
• Ability to organize, manipulate & analyze healthcare data set by using SAS & SQL tools.
• Created Statistical modeling in predictive modeling like logistic regression & linear regression models for identifying default customer non default for approval of credit loans & promotions (Credit risk model) for banking project.
• Created reports in SAS and import / gather data from and exported to Excel spreadsheets, Oracle and other applications and also involved in extracting data from XML files, flat files, CSV, Dat files, Teradata, 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 knowledge of management need and issues regarding data analysis and good understanding of leveraging technology and business process skills in pharmaceutical industry to generate innovative solutions by providing insights, & actionable recommendation from large desperate data set.
• Created Ad hoc reports by using SAS ODS in different format, like PDF, RTF & HTML
• Strong Knowledge of advanced excel for reporting (H-Lookup, V-Lookup, Pivot, Index, macros, SumIf, Sum product, VBA etc) & PowerPoint for presentation.
• Worked in banking projects for data analysis, data mapping from multiple sources, data preparation and reporting in teh form of Tables, listing & graphs.
• Strong knowledge 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 & worked wif development team.
• Strong skill in reporting by SAS tools like, Proc Report, Proc Tabulate sourced from survey and attitudinal data to enable better decision-making by internal teams
• Worked in developing models for campaign analysis to identify a customer accept/reject market promotion.
• Created SAS macros program in Windows / UNIX for developing routine programming codes & test, debug programming codes developed by junior programmers.
• Ability to drive matrices from data, validate Inputs, analyze logs from production jobs & develop reports by using business intelligent tools.
• Experience in defining, analysis, design, implementation, maintenance different models.
• Supervise teh work of junior programmers in area SAS Analyst/Programmers serving on teh same projects and offshore projects.
• Create SAS/SQL codes, Teradata & maintain changes to code base and documentation of teh overall process.
• Strong experience wif SAS functions, formats, informat & knowledge of UNIX environment.
• Manage data, pull data from data marts & different external database, cleaning & ready for reporting & model development.
• Worked wif data teams in supporting any issues related wif data & handling multiple projects.
• Worked on big data for running millions records by exporting from SAS to Hadoop environment, me.e by running SQL commands in Hive & Impala & reporting by using business intelligence tools like tableau & Ms-PowerPoint.
• Importing & exporting SAS data set from relational database to Hadoop by using Sqoop.
• Strong skill in Tableau for data extraction from different sources & presenting complex reports to management team easily.
• Attention to detail, communication skill, time management, leadership skill, collaboration, independent solving skill, team work, labor work, assigning projects according priorities, interpersonal skill & decision making.

TECHNICAL SKILLS

SAS Tools: SAS/Base, SAS/Stat, SAS/Graph, SAS/SQL, SAS/Access, SAS/ODS, SAS/Report, SAS Data Integration Studio 4.9

Statistical Tools: SAS v 9.x/8.x, 6.x, SPSS, R, SQL

Database: Oracle, SQL Server, MS Access

Operating Systems: UNIX WINDOWS

Programs: Microsoft Office Suite (Word, Excel, PowerPoint, Access and Outlook)

PROFESSIONAL EXPERIENCE

Confidential

SQL/SAS Programmer, Data Analyst & Statistical Analyst

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 knowledge to ensure accuracy of insights using SQL, SAS/ETL, SAS/SQL and SAS.
• Utilized advanced statistical techniques to create high-performing Statistical 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, SQL/SAS A/B testing.
• Involved in advanced statistical analysis, such as development of production-ready algorithms, cluster and decision trees for retail project.
• Worked wif autosys schedule for running in large volume data of millions records, modify and migrate legacy code to change control environment.
• Writing SAS codes in Unix environment & set up structured environment for change control.
• Imported data from FoxPro to SAS environment & produce reports by using different SAS procedures.
• Exporting & importing big data from relational database to Hadoop environment by using Sqoop.
• Query big data in Hive, Impala and returns teh result to SAS.
• Developed advanced statistical model for identifying default customer from default in Banking industry.
• Played a pivotal role in summarizing findings, preparation and presentation of reports to key stakeholdersand 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

Confidential

Technical IT Consultant and SAS programmer

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

Confidential

Statistical programmer, Data analysis and SAS Clinical programmer

Responsibilities:

• Extracted data from Clinical database, me.e data submission strategy, me.e., legacy data, pooling data, communications wif regulatory agencies
• Provide Statistical programming support for clinical trials data reporting wif guidance from Biostatistician.
• Reviewed clinical protocols, Statistical Analysis Plan (SAP), data management plan, aCRF (Annotated CRF) to meet company needs & requirements.
• Extensive knowledge in developing and storing Macros ; experience in handling clinical data for different phases ( clinical trials II, III & IV) and has a good knowledge on FDA regulations, ICH guidelines and Drug development process,
• Producing report for clinical trials in teh format of RTF, PDF, HTML file using SAS ODS facility.
• Worked in health care data in data preparation, analysis and reporting to management team.
• 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.
• Worked in informatica developer experience for health care domain.
• 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, ETL, 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
• Skill in generate 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