CAREER SUMMARY:

• 9.6 years of extensive experience in BI Development including relational and multi - dimensional data
• Worked on SAS EBI Implementation (Installation and Configuration 9.2, 9.1.3), setting methodologies and developing architecture for SAS solutions
• Hands on experience on BI Product development, report migration, automation, support projects
• Developed more than 600 reports, 9 plus cubes to create KPI's, dashboards, drill up-down reports, drill through reports, prompt reports including different charts
• Strong problem solving skills with good technical and interpersonal skills. Quick learner with ability to meet deadlines and work under pressure
• Team player and self-starter with excellent communication skills and ability to work independently and as part of a team

SAS TOOLS EXPERIENCE:

Versions used: SAS 9.4, 9.3, 9.2 EBI, 9.1.3 EBI

SAS O/S Platforms: UNIX/Linux, Windows

Data Modeling and Reporting: SAS Base, SAS Macros, SAS EG, SAS Web Report StudioSAS Info Map Studio, SAS INTRNET

Cube Multidimensional: SAS OLAP Cube Studio, SAS Cube Viewer

Dashboard tools: SAS Dashboard, SAS Base

SAS Admin: SAS Metadata Server

Other BI tools used: Technology Specialization, IBM COGNOS/ 10 and 8.4.1 Framework Manager, COGNOS Configuration, Report Studio, Workspace, Transformer, Analysis Studio, Microsoft SQL Server, MSRS(SSRS)

MSAS: SQL Server

BO: Crystal Reports 2008/XI

Databases: Oracle10, 11 (Toad), MS SQL Server

PROFESSIONAL EXPERIENCE:

SAS Programmer Analyst

Confidential, Washington, DC

Responsibilities:

• Responsible for redeveloping and testing of the base SAS codes on Linux platform for PND application
• Focusing on automated codes, execution efficiency, error handling using SAS advanced macros
• Created Linux bash shell scripts to take user inputs by implementing validation for running SAS codes

SAS Analyst

Confidential, Greensboro, NC

Responsibilities:

• Coordinated business users and offshore team for converting business requirements into technical specifications
• Migrated Excel reports into SAS
• Set data validation steps before actual processing of the data for multiple Confidential product lines
• Worked on updating SAS code and optimization using SAS macros, procedures and functions

SAS Technical Lead

Confidential

Responsibilities:

• Ensured smooth transition from third party for ‘Customer Value’ reporting application
• Optimized and automated 67 Base SAS codes to improve performance against increasing high volumes of banking data
• Worked on high volume data sources for data quality code development and submit reports to the business for validations which saved job re-run time (in days)
• Integrated data using Base SAS and macros from data sources like Oracle, SQL Server, CSV available under single application which simplified decision making process across products for single user
• Applied business rules by working with a team of BA's and stake holders for banking products to reduce the cost required to maintain different applications for different products by 20%
• Created flat file (TEXT and CSV) output as a data source to SQL Server and SAP respectively
• Used XCOMM functionality for file transfers to different server locations within bank network
• Designed and developed relational and multi-dimensional reports, KPI's, dashboards using SAS Base, SAS Macros and SAS Graph, SAS Cube
• Used PROC SQL, PROC TABULATE, PROC REPORT, PROC SORT, PROC GREPLAY, PROC SUMMARY, PROC DATASETS, MERGE, SET etc.
• Designed and developed cubes using SAS Cube Studio for multidimensional reporting using SAS Analysis studio and SAS EG
• Created technical and functional documentation for all design and development that is helpful for the application support team
• Tools used along with SAS 9.2 were SAS EG,SAS DI, SAS visual analytics, SAS OLAP Cube studio, SAS WEB Report Studio, Information Map, Oracle, WINSCP, WIN Merge, Unix

SAS Developer

Confidential

Responsibilities:

• Ticket based SAS support, running the SAS jobs for different set of data
• Responsible for the performance optimization of a BI solution built on SAS 9.1.3
• Performance tuning of existing reports to reduce response time by modifications in report design, joins in SQL queries, segmentation, building complex queries at the database level
• Analyzed technically broken reports to give more information for decision making
• Updated the cubes built in SAS Cube studio which were used in multidimensional reports within report studio and SAS cube viewer
• Modified cube hierarchies to reach granular level by using drill up-down functionality using different dimensions
• Documented technical specifications different solutions and reports
• Tools used: SAS 9.1.3, SAS Information maps, web report studio, SAS cube, Oracle 10, Toad

BI Solution Engineer

Confidential

Responsibilities:

• Performed data modeling by merging different dataset and extracting information
• Created Information maps and Stored Process for report development in WRS
• Implementation of statistical models like WEIBULL, PARETO, BOX PLOT, CONTROL CHARTS, REGRESSION, CORRELATION, ANOVA for analyzing asset failure data
• Report development using procedures in Base SAS like PROC SQL, REPORT, SHEWART, GREPLAY, TEMPLATE,TABULATE, FORECAST, TRANSPOSE, GREPLAY, MEANS, SORT, BOXPLOT, GPLOT, GSLIDE and SAS ODS
• Developed KPI’s and Dashboards in SAS WRS 3.1 and Information Delivery Portal 2.0 using slider, speedometer, gauges and alarm indicators
• Developed cubes using SAS OLAP Cube Studio 9.2 for multi-dimensional reporting

COGNOS Developer

Confidential

Responsibilities:

• Report migration from Actuate 8 to COGNOS 8.4
• Created packages in FM and designed reports in COGNOS Report Studio using Oracle database
• Multiple server multiple database environment
• Integration of MSRS server with dot net front end application using web services
• Dynamic selection of the report at the runtime
• Report migration and integration with Iron Speed 5
• Migrated Crystal reports into MSRS reports using SQL server database
• SAS report development and support project
• Importing flat files, cleaning data using Base SAS functions and merging SAS datasets