SUMMARY

• Having 13 years Extensive experience in SAS BI and DI along with SAS/BASE, SAS/MACRO, SAS/SQL, SAS/ODS, SAS/STAT and SAS/GRAPH.
• Extensive experience in SAS programming and data analysis using BASE SAS software in WINDOWS and UNIX Environment.
• Integration of both traditional and emerging data sources with SAS customer intelligence CI.
• 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.
• Excellent analytical, problem solving, communication and interpersonal skills with good knowledge in finance and credit cards’ business domain.
• Has expertise in Oracle 10g, TOAD 8, SQL Server 2005, SAS (Enterprise BI Server), Cube Designer (SAS OLAP Studio).
• Using SAS/SQL for extract, transfer and load ETL methodology and processes.
• Good analytical, conceptual and strategic thinking and planning.
• Star Schema and Snow flex Schema in SAS DI.
• Having expertise on Hive and Python, tableau.

TECHNICAL SKILLS

Operating System: Windows 2000, Linux, MVS/ESA, OS/390, z/OS

Environment: Client/Server

Database: Oracle 10g/9i/8i, Oracle Clinical 4.x, MS Access, SQL Server, Hive, DB2, Teradata

Internet Tools: HTML, ASP.net, JSP

SAS Skills: SAS/BASE, SAS/PROC, SAS/SQL, SAS/ODS, SAS/Graph, Stored process, SAS/Intranet, SAS/MACRO, SAS Enterprise Guide, SAS Information Delivery Portal, SAS Information Map Studio, SAS Management Console, SAS Web Report Studio, SAS BI Dashboard, SAS Enterprise Report., SAS OLAP Cube designer, SAS DATA Integration Studio (ETL)., Hadoop, python, SQL/HIVE, SAS, SAS Enterprise Guide 7.1.

Languages: C, PL/SQL, UNIX, Shell Scripting

Other: Data Modeling, Excel, SAS Enterprise Guide and DI

PROFESSIONAL EXPERIENCE

Confidential

SAS Consultant

Responsibilities:

• Handing 16 processes and SAS jobs (700) including dependencies for scheduling
• Worked extensively with business users on requirements gathering, analysis and documentation.
• Existing process and job documentation, including implementation plans and amendment
• Modifying data using SAS/BASE and Macros.
• Worked on analysing medical claims data and interfacing SAS with MS office applications such as Access/Excel.
• Built, maintained, and scheduled SAS production
• SAS jobs source code (Autoexe and global program)
• Data in BIW 2.0 and views to create equivalence to 1View from the Colossus program.
• Build prove area or Test data location for all environment.
• X command replacements from the Barclays platform team
• Tivoli scheduler: Run and Monitor of flows

Environment: SQL/HIVE

Confidential, NY

SAS Developer

Responsibilities:

• Prepare the data and data analytic as per the business requirement
• Working into extract, testing and impact the data from lending transformation areas over the different Country.
• Run the Daily, weekly and monthly Dashboard production batch.
• Data analytics for CR data as per business demand
• Generate different matrix or dashboard as per need.
• Adhoc request handling as per business demand

Environment: SAS, SAS Enterprise Guide 7.1.

Confidential - PA

SAS Developer

Responsibilities:

• Prepare the data and data analytic as per the business requirement
• Working into extract, testing and impact the data from lending transformation areas over the different Country.
• Run the Daily, weekly monthly production batch.
• ETL design for source to target mapping, testing for different banking vendor.

Environment: SAS, SAS Enterprise Guide 7.1.

Confidential, SAN ANTONIO, TEXAS

SAS 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 matrix or dashboard as per need

Environment: SAS, SAS Enterprise Guide.

Confidential

SAS 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

Environment: SAS Base, SAS BI Enterprise Server 9.2, SAS Enterprise Guide 4.2

Confidential

SAS Developer

Responsibilities:

• Development and Maintenance of Data warehouse and Reporting for business.
• Handling data for Business or Region.
• Dash boarding and Reporting for Business or Region

Environment: SAS Base, SAS BI Enterprise Server 9.2, SAS Enterprise Guide 4.2

Confidential, NY

SAS Developer

Responsibilities:

• Development and Maintenance of data warehouse for EMIA Market.
• Handling data for particular Business or Region.
• Dash boarding for Business or Region

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

Confidential

SAS Developer

Responsibilities:

• Extracting data from data warehouse, understanding the data and testing it. Different kind of data sets 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 perform Testing).
• Creation of Dump variable and checking or Test as per Business rule.
• Created SAS data sets 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 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