SUMMARY

• Data Analyst with 7+ years of extensive IT experience in Business/Data Analysis using SAS software in WINDOWS environments. Excellent experience in Data Management, ETL, Data Quality, Data Modeling, Data Integration and Business Intelligence projects. Analytical, methodical and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business needs and spirit to add value to your organization.
• Certified SAS professional with over 7+ years of design and model development usingSASto compile and analyze large data sets including data step processing, data mining, data manipulation, macro creation, data transformation, variable construction optimization.
• Extensive exposure on every steps of entire project life cycle including data collection, query, modifying and analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes.
• Producing weekly & monthly reports on company financial & customer performance and key performance indicators
• Produce reports and analyses on key business channels, marketing campaign performance and impact of key initiatives
• Identify key trends, issues and root causes and make recommendations
• Conduct some basic statistical analysis to better understand data insights (Histogram/Boxplot, t - test, ANOVA, linear regression, cluster etc.)
• Extensive experience in DATA merging sub setting with the use of PROC SQL, Merge and SET statements.
• Experience in SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS in Windows environments
• Skilled in using SAS Statistical procedures like PROC REPORT, PROC TABULATE, PROC CORR, PROC ANOVA, PROC LOGISTI, PROC FREQ, PROC MEANS, PROC UNIVARIATE.
• Experience writing advance SQL programs for joining multiple tables, sorting data, creating SQL views, creating indexes and metadata analysis. Experience in performing Ad Hoc Queries for various application and reports on a daily, weekly and monthly basis using complex SQL Queries.
• Thorough knowledge in all phases of data analysis, including definition and analysis of questions with respect to available data and resources, overview of data and assessment of data quality, selection of appropriate models and statistical tests and presentation of results.
• Significant experience in requirement gathering, building, designing and testing the application to meet the functional Design and Business Process Design.
• Strong experience with databases like Oracle, Teradata, MS SQL Server, DB2 and MS Access.
• Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables using LIBNAME.
• Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Sound financial domain knowledge of Fixed Income, Bonds, Equities, Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Sales and Marketing.
• Create detailed user interface designs, including prototyping, for external (web) and internal (client/server) applications using Visio and Axure RP Pro.
• Proficient knowledge of MS office (Excel, Power Point, Visio, Access, Project, outlook) and SQL.
• Skilled at learning and applying new IT methodologies; exceptional ability to translate complex technicalconcepts to a non-technicalaudience.

TECHNICAL SKILLS

Operating Systems: Windows 9x/00/NT

Statistical Software: Base SAS, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/STAT, SAS/MACROS, SAS/SQL, SAS/ETL, SAS/ARRAYS, SAS/ENTERPRISE GUIDE,BaseSAS,SASSQL,SASMACROS,SASGRAPH,PROC ANOVA, PROC LOGISTIC

SAS Procedures: Sort, Transpose, Tabulate, Print, Contents, Means, Chart, Plot, Univariate, Summary, Anova, logistic, Glm, mixed, Reg, SQL, Copy, upload, download, Datasets, Format, Boxplot, freq, forms, Gfont.

Data Analysis/Visualization: Tableau, Cognos, Data Mining, Data Modeling, Data WarehouseBusiness Intelligence, Statistics concepts

Languages: Java, PL/SQL, Hadoop, SAS, PHP, R, Python

Databases: MS SQL Server, MS Access

Testing Tools: Integration, Unit, UAT

Operating Systems: Windows 95/98/2000/XP/VISTA

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Applied statistical models and other computational approaches to extract insights from large proprietary agronomic data sources
• Worked on seeking and identifying datasets with potential to address customer needs
• Established scalable, efficient processes for large-scale data analysis, model development and model implementation
• Presented analysis and resulting recommendations to senior management
• Leveraged data to present a compelling business case to optimize investments and operations
• Communicated and educate technical and non-technical employees on analytics and data driven decision- making
• Understanding of A/B and Multivariate testing techniques and measures.
• Created data set and utilized SAS data and procedural steps of Base SAS programming codes to import data into SAS and analyzed these data for with various statistical methodologies and manipulation for management.
• Perform ad hoc data analysis for business strategic planning, monitor customer performance and Loyalty program performance.
• Programed customized data displays, (including data listings, summary tables and routine graphics) code is to be written using Base SAS programs, SAS procedures, or standardized macros.
• Supported SAS Programming activities for membership and claims data and involved in software development life cycle of the project.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
• Developed User Manuals and provided orientation and training to end users for all modified and new systems.

Environment: SAS 9.0, SAS Enterprise Guide, Cegid(POS system), Magento (e Commerce system),SAP, MS Visio, MS Project Windows XP, SQL Server, Crystal Reports, UML Modeling, UAT, Project Management.

Confidential

SAS Data Analyst

Responsibilities:

• Collected and compiled data and prepared summary statistics for studies, report, and surveys
• Created charts and graphs to demonstrate data and to facilitate interpretation
• Prepared research studies, statistical reports, and informational reports utilizing data from multiple sources
• Perform extraction, transformation and loading from large Oracle tables.
• Create new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Used procedures such as Proc Freq, Proc Format, Proc Means, Proc sort, Proc Print, Proc tabulate and Proc report.
• Worked on various SAS products to develop SAS/BASE, SAS/SQL, SAS/ACCESS and SAS/MACROS to develop solutions.
• Developed dynamic SAS programs and produced Reports using BASE SAS, SAS/MACROS, and SAS/STAT & GRAPHS.
• Developed and supported the implementation of new statistical models & analytics for customer segmentation that were used for improving portfolio profitability.
• Developed new SAS programs and modified existing SAS programs.
• Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.
• Involve in discussions with business users and data architects to define metadata for tables to perform ETL process.
• Involved in developing, testing, and writing programs and reports in SAS according to specifications as required.
• Extensive experience in Data Manipulation and Analysis using SQL Queries, Set, Merge and Update techniques.
• Performed manual testing on applications and Wrote Test Procedures to validate the key aspects of application.

Environment: SAS 9.0, Hisense POS system, Oracle 12 ERP, DB2, SQL Server, Arvato CRM solution, datacenter project, API management, BI analytics (Cognos), skincare system, Microsoft Visio, Documentum, Integration.

Confidential

Business Intelligence Analyst

Responsibilities:

• Create and use user-defined and automatic macro variables within the SAS Macro Language.
• Automate programs by defining and calling macros using the SAS Macro Language.
• Use various system options that are available for macro debugging and displaying values of user-defined and automatic macro variables in the SAS log.
• Create data-driven programs using SAS Macro Language.
• Generate detail reports by working with a single table, joining tables, or using set operators in the SQL procedure..
• Analyzed data and results using statistical techniques in order to provide meaningful reports and information.
• Performing data analysis, data migration, data preparation, graphical presentation, Statistical analysis, reporting, validation and documentation.
• Analysed large data sets consisting of million records using PROC SQL, PROC SORT, PROC PRINT, PROC TABULATE procedures.
• Generating reports to communicate key findings and articulate strategic implications using PROC PRINT, PROC REPORT, PROC TABULATE, PROC MEAN.
• Built summary reports after identifying customers, occupancy period and revenue generated using PROC SUMMARY, MEANS and FREQ. Updated Revenue item table on a daily basis.

Environment: SAS 9.0, SAS Enterprise Guide, SAS/BASE, SAS/MACRO, SAS/Graph, Teradata, DB2, ORACLE, SQL Server SQL Server, Microsoft Visio, Microsoft Access, Microsoft Excel

Confidential

Junior Data Analyst

Responsibilities:

• Created set-up programs for study environment generating generic formats and library references, compiled standard macros, and created macro variables, etc.
• Created and modified existing SAS macros to report summary/descriptive statistics as well as inferential statistics.
• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Performed extraction, transformation and loading from large Oracle tables.
• Wrote macros to develop a concise and reusable code.
• Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for reporting.
• Converted large data from Oracle toSASdata sets by using SQL pass through and Libname facility.
• Merged the datasets to provide the users with the data in the required form.
• Performed validation of SAS programs using various sophisticated techniques and communicated findings to the programmer /data manager/statistician.
• Reviewed edits check specifications to ensure data accuracy and data validity/integrity.
• Reviewed Derived Data Tabulations to ensure compliance with the submission requirements.

Environment: Base SAS, SAS/SQL, SAS/ODS, SAS/Macros, SAS/Graph,Oracle, Teradata, DB2, MS Excel, MOVEX ERP, Tech POS, Warehouse management system, API management, SAS 9.0, SQL Server, Oracle, MS Visio.