SUMMARY

• Over 7 years of extensive experience in SAS programming, Data Management, Predictive Modeling, Business Analysis and SQL
• Certified Base and Advanced SAS programmer for SAS 9
• Experienced, Certified Statistical Data Analyst with extensive experience in banking/finance, health care and insurance industries
• Chartered Financial Analyst(CFA) Level 2 candidate with good understanding of statistics, quantitative methods, economics, corporate finance, Financial reporting
• Significant experience and strong skills in data preparation for Data Mining
• Experience in Base and Advanced SAS programming procedures like with PROC SQL, PROC REPORT, PROC ACCESS, PROC GPLOT, PROC GCHART, PROC FORMAT, PROC TABULATE, PROC APPEND, PROC TRANSPOSE
• Extensively used SAS Enterprise Miner, where fraud detecting and credit card predictive models have been built, assess and scored using logistic regression
• Experience in SAS/BASE, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments
• Strong experience with databases like Oracle, Teradata, MS SQL Server, DB2 and MS Access
• Extracting multi - million record file, data mining and analysis, creating marketing incentive reports
• Strong ability to write SQL queries using PROC SQL
• Involved in coding and pulling data from various oracle tables using Unions and Joins
• Customize the variables to user-defined formats using PROC FORMAT in printing reports
• Experience in working with SAS Enterprise Guide Software for reporting and analytical tasks
• Adept at preparing Business requirements documents (BRDs), defining project plans, Writing system requirements specifications, and delivering project reports
• In depth knowledge of RUP’s Iterative Software Development Life Cycle (SDLC) process and Agile Software Development
• 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
• Effective team player with strong communication and interpersonal skills

TECHNICAL SKILLS

Operating Systems: UNIX, Mainframe, MS Windows

Language: SAS, SQL

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS, SAS/Graph, SAS EG, SAS Miner

Database: MS-Access, Oracle, Teradata, SQL server, DB2

Other Technologies: Visio, Microsoft Office (Word, Excel, PowerPoint, Outlook)

PROFESSIONAL EXPERIENCE

Confidential - St. Paul, MN

Sr. Data Analyst

Responsibilities:

• Involved in Analysis and Marketing Team to make business decisions
• Interacting extensively with end users on requirement gathering, analysis and documentation
• Involved with key departments to analyze areas and discuss the primary model requirements for the project
• Involved in credit risk assessment model to calculate risk factor for individual clients based on hierarchy
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications
• Performed complex statistical analysis using PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Extensively performed Data Cleansing during the ETL’s Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable Macros
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Wrote SAS programs in UNIX platform
• Extensively used SAS ODS facility to create customized reports in HTMLPDF,RTF
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g., SAS Integration Studio, SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access
• Performed competitor and customer analysis, risk and pricing analysis and forecasted results for credit card holders on demographical basis
• Effectively prepared and published various performance reports and presentations
• Environment: SAS/BASE, SAS/MACRO, SAS/ETS, SAS/CONNECT, SAS Enterprise Guide, Teradata, DB2, ORACLE, SQL Server, UNIX

Environment: SAS Enterprise, SAS 9.0, SAS/Base, SAS/Macro, AbInitio, Micro Strategy, Tableau, SAS/SQL, SAS/OLAP, SAS/STAT

Confidential - Chicago, IL

SAS Programmer

Responsibilities:

• Developed complex SAS macros to simplify SAS code and effectively reduce coding time
• Perform data analysis on large data volumes to support business decision making
• Working with business users to understand requirements and translate them into technical specifications
• Experience in creating reports in SASEnterprise Guide v4.2/4.3
• Some Experience in building predictive models to support business decision making
• GenerateSASdatasets to be used for trend reporting as well as assist with solution specifications, report development, and code review/testing activities
• Utilized SAS/ACCESS to extract data from Sybase and other relational databases for analysis
• Interacted with Risk Managers and Analysts to define targeted customer segments
• Extract, transform and load datasets with basic modeling variables for each segment type Using PROC IMPORT and SQL queries, imported data from Oracle database into SAS files
• Manipulated and updated the tables as per specifications
• Performed data cleaning by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and macros in SAS
• Formulated action plans and presented key information regarding profit dynamics to the senior management in the Bank
• Maintain and enhance existing SAS reporting programs for marketing campaigns
• Produce SAS Graphical reports showing Trend Analysis charts for campaign
• Worked on CONVERSION of SAS code originally in ORACLE to TERADATA compatible SAS code
• Generated the List outputs for Marketing Teams that have the list of customers to target as part of Campaigning
• Prepared ad-hoc reports, documenting SAS work, and directing SAS outputs to RTF and HTML files through SAS ODS facility
• Used PROC/SQL and SQL - pass-through mechanisms
• Helped in the setup of SAS Connect with DB2 and Oracle in the new environment along with testing and validation

Environment: SAS Enterprise, SAS 9.0, SAS/Base, SAS/Macro, AbInitio, Micro Strategy, Tableau, SAS/SQL, SAS/OLAP, SAS/STAT, Web Reports Studio, MS-Excel and Windows XP/7 and UNIX Sun Solaris

Confidential, San Jose, CA

SAS Programmer

Responsibilities:

• Working on multiple project tasks in support of the design and implementation of analytic solutions
• Responsible for analyzing various database (DB2 & Teradata) containing transactions, demographic, loan, account and region
• Interfacing between various business and technical teams
• Responsible for providing the consulting team withdata preparation, data analysis using SAS as a primary tool
• Executedata crunching, write codes,merge/purge/ and split data, and do ad hoc queries/cut data programmingin SAS
• Developing and maintaining SQL based database that interfaces with both SAS to automate history archiving, retrieval, and forecast generation
• Documenting all SAS programs developed and write other documentation as needed. Identify and share best practices for key topics
• Creating large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/BASE
• Analyzing data using various statistical PROCEDURES like PROC SUMMARY, PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC REG and PROC ANOVA
• Using SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction
• Also involved in data validation for ETL process flows. Identifying and acting on duplicate values, invalid values, and missing values
• Coordinated with the team of analysts in SAS Enterprise Miner data exploration tool is used for customer-targeting campaigns, credit scoring, churn analysis, and fraud detection

Environment: Base/ SAS, SAS/Macro, SAS/SQL SAS/Connect, SAS/Graph, SAS/Access, Windows, Teradata, DB2, UNIX & SAS/ENTERPRISE Miner, Guide, Tableau

Confidential

SAS Business Analyst

Responsibilities:

• Working withbusinessowners for requirement gathering and analysis and conducting JAD sessions
• Responsible for administering and maintaining document's like project plan, requirements, solution designs, component designs and other project execution and management related documents throughout the project lifecycle
• Resolve queries raised during the Design/Development and Testing Phases
• Facilitatingbusinessand user acceptance testing (BAT/UAT)
• Responsible for creating, maintaining requirement deliverables and reviewing documents created by team members
• Bridge gap betweenBusinessSubject Matter Experts, Development and testing team
• Used SAS/BASE, Macros to develop dynamic SAS programs to extract, validate data
• Cleaning, Data Manipulation and transforming data using Data step and SAS Base procedures for review
• Used SAS analytics to customize insurance plan so that to reduce healthcare premium expense of clients
• Extensively used various statistical Procedures like PROC FREQ, PROC MEANS to understand data quality, produce reports and handle the missing values
• Analyzed the data of advertised contents based on people response and created reports based on their demographic information
• Generated customized reports using SAS/MACRO facility, PROC REPORT, PROC TABULATE and PROC SQL
• Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets
• Generated high quality reports and listings in HTML, EXCEL and PDF formats using SAS/ODS
• Performed data analysis on employee data for required fields as per client requirements

Environment: Base SAS, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ODS, UNIX, Mainframes, SAS Enterprise Guide, SAS BI

Confidential

Business Analyst

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000