Business Domain

Banking/Finance

Commercial Lending, Retail Banking, Collections Charge-Offs, Equities, Derivatives, MBS, CDO, Branch Operations, Loan Origination/Servicing, Exchanges, Broker/Dealers, Orders, Trades, Margin, Settlement, Custodians, Accounting, Stock Records, General Ledger and Sub Ledgers, Regulators, Regulatory Reporting, Compliance, Fraud/Loss Prevention, CCAR, DFAST

Technical

• 9 years of robust professional experience as a Data/Reporting Analyst and Developer in SAS
• 6 years of experience in RDBMS and DWH environment in SAS, Teradata, Sybase and Oracle for analysis and reporting
• 6 years of Experience in MS Excel, MS Access, Excel VBA, SAS DDE etc for application development, scorecards and dashboards for analytics reporting
• 5 years of experience using SAS on UNIX domain
• 5 years of experience with direct customer facing role including requirement gathering, coordinating meeting, seamless communication and participation in business and strategy planning meetings
• 4 years of experience working with SAS BI Suite Enterprise Guide, Olap Cube Studio, SAS Add In, Information Map Studio and Web Reports delivering high performance business reports
• 4 years of experience working in agile scrum development process
• 4 years of experience in physical and logical data modeling and schema design using industry standard tools like Erwin and others
• Extensive experience building and maintaining reporting data marts in SAS for risk analytics, consumer analytics, business development etc
• Extensive experience extracting information form enterprise data sources like Oracle, SQL Server, DB2 UDB, Flat files, text files, Spreadsheets, VSAM from within and outside the firm
• 4 years of experience with Teradata version 12 SQL Assistant, BTEQ, FastExport for ETL, analysis and reporting
• 3 years of experience with OBIEE products Oracle, PL/SQL, OWB etc for analysis, development and reporting
• Excellent communication and presentation skills with ability to effectively communicate to diverse technical and non-technical audience with required SOW, SLA, BCR, QTP docs

SUMMARY

• SAS Advance and Base certified with Over 7 years of robust professional work experience in Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Application Development and Reporting with SAS
• Understanding of the client's vision, goals, limitations, data sources and time lines
• Firm grasp over understanding of business needs and strategies to develop reliable and effective solutions
• Firm understanding of Proc Olap and Proc Infomap to deliver solutions meeting complex business needs
• Extensive experience transferring data across platforms Mainframe, Unix, PC based on the business and reporting needs
• Vast experience in presentation using SAS, Excel, Pivot Tables, DDE for presenting the end results
• Proven skills in SAS Base data step and proc and SAS Macro fulfilling on demand business needs
• Advanced SQL skills with ability to code complex queries to load, clean, format store data
• Clear understanding of data modeling principles like star and snow-flake schema, dimensional data model, 3nf etc
• Designed several ETL jobs using SAS DI Studio to port the ODS data into data marts with tasks involving configuring metadata libraries in SMC, developing transformation logic and staging the final data
• Ability to code complex MDX code for OLAP cubes to have a tradeoff between storage space and performance
• Experience in SAS/STAT with linear and logistic regression, ANOVA, DOE, Clustering etc to gain insight into the data
• Skilled in analytical and business reporting using SAS, MS Office, VBA and RDBMS technologies
• Conceptual knowledge of marketing mix, segmentation and association rules, market basket analysis, test and control groups, sample size criteria, hypothesis testing etc in marketing domain
• Experience in loading SAS Metadata Server with metadata from external packages for ETL development
• 3 years of experience in job scheduling and load balancing using SAS Grid and LSF
• Involved in preparing and reviewing BRD, FRD documents to serve development and reporting
• Experience in coding mathematical expressions in SAS as per the requirement using legacy and new functions
• Extensive experience in Teradata tools utilities like SQL Assistant, BTEQ, FastExport TPump for business analytics and reporting on massive Enterprise Data Warehouse
• Strong skills in requirements gathering, analysis and ETL design, coding, debugging
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc
• Completed several projects with accountability for design, development, and implementation of enhancements which involved secure data transfers to external vendors
• Involved in projects having to deal with cross functional teams and multiple stakeholders
• Minimum time to self sufficiency in any environment
• Excellent communication and report writing skills, with the ability to effectively communicate results of analytics to diverse audience

TECHNICAL SKILLS

WORK EXPERIENCE

Confidential

SAS Developer

Responsibilities

• Directly involved in gathering complex business requirements pertaining to recent or old pattern of abnormal behavior or activity on different channels that would affect the end customer of the bank
• Convert business requirements into technical specifications using available tools and technologies
• Design the needed aggregations, transformations and mapping of the data entities to suite the build and execution phases of the applications
• Use SAS, SQL, XML, PL/SQL and Windows batch programming techniques to code the technical specifications apply business logic and produce automated reporting solutions
• Create detailed business and technical documentation for individual projects
• Maintain and contribute to the modulated software development environment for loss prevention
• Work individually and as part of a team to put forth ideas pertaining to technical and analytical solutions
• Use Agile methodology to build, test and deploy models and applications
• Involved in mapping and transfer and summarization of transactional, operational, actuarial, econometric and demographic data for EWARS Early Warning And Reporting System applications
• Extensively use Proc Olap and Proc Infomaps to build data sources for the reporting applications using SAS, AMO and Web Reports
• Routinely deal in with large internal and vendor data and perform performance tuning, query optimizations and production support for SAS, Oracle 11g
• Responsible for troubleshooting and delivering outputs using PROD/DEV/QA environments
• Develop test cases/plan for individual project assignments of Loss Prevention reporting using ID Portal
• Involved in preparing Data Quality Review Plan DQRP to adhere to the internal specifications
• Provide production support and retrospective version control on the application on ad hoc basis
• Implement the needed fuzzy logic in pattern mapping and segregation of the customer profiles using SAS programming techniques

Environment: SAS ENTERPRISE GUIDE, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, SybaseIQ, SQL Server, RCS, UNIX, RCS, UltraEdit, IBM Tivoli

Confidential

SAS Developer

Responsibilities

• Extensively used SAS on UNIX platform to develop custom business solutions
• Collaborate with business area to understand business needs, capture supporting requirements and resolve issues
• Developed and supported infrastructure to implement Statistical and Economic models
• Conduct walkthroughs of requirement artifacts and communicate effectively with business, development and testing teams during construction phase to ensure clear understanding of requirements
• Effectively used version control to coordinate the development across the various phases
• Used SAS to develop custom desktop solutions for the Stress Testing of the Commercial Loan portfolio of the bank
• Extensively used SAS macros, loops and other techniques to perform program and application automation
• Responsible for Phase I/II and III model validations for Commercial lending portfolio of the bank in Energy, Muni, Construction, C I Consumer and Industrial to derive PD Probability of Default , LGD Loss Given Default and EAD Exposure at Default
• Responsible for implementation of the various quantitative models in retail domain targeting delinquency, charge-offs
• Participated in datamart design and build using Oracle 11g, Toad, SQL Plus for the consolidation of the very large vendor data into the enterprise systems
• Supported in house oracle datamart administration using configured environment variables, parameters, stored procedures, group profiles
• Extensively used SAS Grid architecture on UNIX/Linux to perform job and workflow scheduling
• Used SAS and system options to improve the performance of the existing sas programs
• Participated in the process of streamlining the data process underlining the program automation
• Used SAS program techniques to develop custom and enhances reports for customers using AMO, Olap Cubes, OBI
• Used parallel processing in SAS to aggregate programs to significantly reduce the execution time of the applications that fetch aggregated and partitioned data
• Performed rigorous query tuning and performance optimization for the applications that process the large transactional data

Environment: SAS ENTERPRISE GUIDE, SAS OLAP Cube Studio, SAS Information Map Studio, Add In, SAS/SQL, SAS/MACROS, SAS/BASE, Teradata, RCS, UNIX, RCS

----------------------------------------------------------------------------------------