SUMMARY

• Extensive experience in SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS, SAS/STAT and SAS/GRAPH .
• Tableau for reporting and visualization of the Reports
• Extensive experience in SAS programming and data analysis using BASE SAS software in WINDOWS and UNIX Environment.
• Hands on experience in SAS programming tasks such as extracting and merging SAS data sets, writing SAS procedures, macros, validating data, producing reports, and using SAS formats and functions.Extensive experience in SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS, SAS/STAT and SAS/GRAPH .

  Tableau for reporting and visualization of the Reports

  Extensive experience in SAS programming and data analysis using BASE SAS software in WINDOWS and UNIX Environment.

  Hands on experience in SAS programming tasks such as extracting and merging SAS data sets, writing SAS procedures, macros, validating data, producing reports, and using SAS formats and functions.

• Experience with SAS procedures such as PROC IMPORT, PROC EXPORT, PROC TABULATE, PROC SORT, PROC FORMAT, PROC PRINT, PROC MEANS, PROC FREQ, PROC REPORT, PROC TRANSPOSE, PROC SGPANEL and PROC SGPLOT .
• Modified existing SAS programs and created new SAS programs using SAS Macros to improve ease and speed of modification as well as consistency of results.
• Experience in data management tasks such as data extraction, data validation, data processing, data cleaning, and data analysis.
• Proficient in preparing business specific and adhoc reports using key performance metrics for senior management and business partners for presentation, forecasting and further analysis.
• Proficient in all regression steps of missing and capping treatment, variable transformations, bivariate analysis, logistic regression, scoring and validation.
• Has expertise in Oracle 10g, TOAD 8, SQL Server 2005, SAS (Enterprise BI Server), Cube Designer (SAS OLAP Studio).
• Star Schema and Snow Flex Schema in SAS DI .

TECHNICAL SKILLS

• Operating System: Windows XP, 7, 8, Windows Server 2003, 2008, 2008 R2, 2012 andUNIX (Sun Solaris) and Red Hat Linux.
• Office & Other Tools: Experienced in MS Office (Excel, Word & PowerPoint) & Photoshop etc.
• RDBMS: MySQL, Oracle, Greenplum & MS Access.
• SAS Skills: Base SAS, SAS Enterprise Guide, SAS Data Integration Studio, SAS Information Map Studio, SAS OLAP Cube Studio.
• Web Applications: SAS Visual Analytics (VA), SAS Web Report Studio (WRS), SAS BI Dashboard, SAS Information Delivery Portal (IDP) and Strategy Management (STM)
• Other Applications: SAS Management Console (SMC), SAS Deployment Manager, SAS Migration Utility, SAS/BASE, SAS/PROC, SAS/SQL, SAS/ODS, SAS/Graph, Stored process, SAS/Intranet, SAS/MACRO SAS Migration Utility etc.
• Operating Systems: Windows 2003, Unix and Linux.
• RDBMS: Oracle, Teradata, DB2, MS Access, SQL server.

PROFESSIONAL EXPERIENCE

Confidential

SAS BI Developer

Responsibilities:

• Prepare the data and data analytic as per the business requirement
• Working in EBA to extract the data from different subject areas over the different Country.
• Run the Daily, weekly monthly production batch.
• ETL design for source to target mapping for different banking clients.
• Generate different matric or dashboard as per need.
• Published all Reports from Web Report Studio, BI Dashboard and Information Map into Information Delivery Portal .
• Tableau for reporting and visualization of the Reports

Environment: - SAS Base, SAS Enterprise guide, Tableau, Unix and windows.

Confidential

SAS EBI/EDI developer

Responsibilities:

• Involved in requirement gathering, discussion and gap analysis, ETL design, coding and testing as end to end DataMart creation for ASH.
• Working in ASH to extract the data from different subject areas over the different states.
• Coordinating with onsite team for requirement gathering, product enhancement and testing
• Supported to offshore team located in India.
• Interacted with Clients and Business Users for requirement gathering.
• Tableau for reporting and visualization of the Reports

Environment: - SAS Base, SAS Enterprise Guide 4.6, SAS DI Studio, SAS BI Dashboard and Stored process server, filesystem, salesforce, db2, oracle Teradata, Unix and windows, Tableau

Confidential

SAS EBI/EDI developer

Responsibilities:

• Development and Maintenance of Data ware House and Reporting for business.
• Handling data for particular Business or Region.
• Dash boarding and Reporting for Business or Region.
• Designed and developed Extract, Transform, Load (ETL) processes using Base SAS to populate Reporting Data Marts.
• Quickly adapted to the system which was developed, for maintenance.
• Understood the Business Requirement and communicated timely for enhancement of KPI Input System.
• Enhanced the KPI Reporting System to generate the report graphs.
• Developed ad-hoc reports using Base SAS and Enterprise Guide.
• Performed Data validations post reading the data from flat files.
• Merging and summarizing data using different procedures.
• Tableau for reporting and visualization of the Reports

Environment: - SAS Base, SAS Enterprise Guide 4.6, SAS Information Delivery Portal., SAS web report Studio, SAS BI Dashboard and Stored process server, filesystem, Teradata, Unix and windows., Tableau

Confidential

SAS Base/EDI developer

Responsibilities:

• Development and Maintenance of data ware House for EMIA Market.
• Handling data for particular Business or Region.
• Dash boarding for Business or Region.
• Designed Visualizations in SAS VA and developed compliance Web Portal Applications using SAS BI tools like SAS Stored Process, SAS Information Map Studio, SAS OLAP Cubes, SAS Web Report Studio, and SAS BI Dashboard.
• Implemented Security Features for Compliance Dashboard. Generated SAS EG stored processes with static and dynamic prompts for product-specific analyses.
• Published all Reports from Web Report Studio, BI Dashboard and Information Map into Information Delivery Portal.
• Developed Portal pages for Business\End Users for data exploration and saving their reports.
• Scheduling Deployed Jobs and monitoring of batch jobs in LSF Scheduler (Platform Process Manager).
• Scheduled SAS OLAP Cubes Script files (.bat) and SAS EG projects (.vbs) in Windows Task Scheduler.

Environment: - SAS Base, SAS Enterprise Guide 4.3, SAS Information Delivery Portal. SAS Management Console 9.3 SAS DI Studio, SAS Information Map Studio, SAS web report Studio, Unix and windows.

Confidential

SAS Base/EBI developer

Responsibilities:

• Extracting data from data ware house, understanding the data and testing it. Different kind of datasets Testing and Variable Testing as per the requirements.
• Find out the Variable which used in HR System.
• Find out the attrition rate for particular Business or Region (here we have also performed Testing).
• Creation of Dump variable and checking or Test as per Business rule.
• Created SAS datasets in local SAS directory and Test it creation one is matching or not.
• Responsible for converting the business rules to SAS Datasets and then used to generate Dashboard, model, and reports. Created reports and efficacy reports using PROC REPORT for publishing and submission.

Environment: - SAS Base, SAS Enterprise Guide 4.2, Windows.

Confidential

SAS Base/EBI developer

Responsibilities:

• Installation and Configuration of SAS Business Intelligence Enterprise Server V9.2.
• Getting Data from Data source to create SAS Datasets and data warehousing by DI, Creating Information maps, Creating Web reports.
• Extract Statistical data from transactional data source with statistical procedures.
• Understand requirement and help to create requirement Specifications.
• Create SAS Dashboards and administrate application.
• Create Different KPI’s, OLAP Cube, Cross Tabs, and Summary Detail Reports, Parameterized and Drill Down Reports in SAS, Create analytical and statistical reports.
• Handling SAS Information Delivery Portal with Jsp page.
• Generate KPI’s Dashboard from OLAP in WRS.
• Maintain Record of work and make proper documentation.
• Environment - SAS Base, SAS BI Enterprise Server 9.2, SAS Enterprise Guide 4.2, SAS Information Delivery Portal. SAS OLAP Cube designer, SAS DI Studio, SAS Information Map Studio, SAS Management Console 9.2., SAS web report Studio, SAS BI Dashboard and Stored process server, Oracle10g, Windows 2003 Server, UNIX.

Environment: - SAS Base, SAS Enterprise Guide 4.2, SAS Information Delivery Portal. SAS Management Console 9.2., SAS OLAP Cube designer, SAS DI Studio, SAS Information Map Studio, SAS web report Studio, SAS BI Dashboard and Stored process server, Oracle10g, Windows 2003 Server.