Data Sas
Resume:
Madhav
**********@*****.***
Summary
Technology-driven SAS and Teradata Professional with 11+ years of experience directing program development and test analysis in highly-competitive market environments.
Core technical expertise in design, development and debugging SAS programs and Macros to query, extract and manipulate large datasets, perform statistical model analysis, produce files, tables, listings, graphs, reports using SAS/BASE, SAS/STAT, SAS/SQL, SAS/ACESS, SAS/MACRO, SAS/ODS, SAS/ETL, SAS/GRAPH, SAS/CONNECT, in Windows and UNIX environment
Advanced skills on data cleaning and manipulation using PROC procedures such as PROC SUMMARY, PROC SORT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE, PROC PRINT and many SAS data steps such as ARRAY, MERGE, SET etc.
Command in producing tables, listings, report employing SAS procedure steps such as SAS ODS, DATA _NULL_, PROC REPORT, and PROC TABULATE
Strong exposure to all steps of project life cycle such as original data collection, secondary data query, data manipulation and analysis, summary of findings, develop analysis indications, communicate strategic insights and presentation of results
Experience creating ad hoc reports as per requirements
Good UNIX and Shell Scripting skills
Thorough knowledge and hands-on experience of Data Warehouse; experienced with data on databases such as MS-Access, Teradata, Oracle, SQL Server, good understanding of Legacy, Relational and Multidimensional DBMS
6+ years of experience in Teradata (Teradata SQL Assistant, BTEQ, Fast Load, MultiLoad, TPump, FExport, ARCMain, PMON, Visual Explain)
Excellent Programming experience in Teradata SQL, Stored Procedures, Macros and Triggers etc.
Extensively worked on the data movement between SAS and Teradata/SQL Server.
Effective communications liaison between business and technical groups, creative and resourceful, problem solving with excellent decision-making capabilities
Experience in using SAS as data management and statistical analysis tool in retail bank, credit card, insurance and other financial services.
Self-motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas
Education & Certifications
Masters of Science (Computer Science, IASE Deemed University, INDIA) 2003
Post Graduate Diploma in Computer Application (Ministry of S.S. Industries, Govt. of India. 1997)
Bachelors of Commerce (Kakatiya University, INDIA) 1995
Technical Skills
BI Tools: SAS/SQL, SAS/GRAPH, SAS/BASE, SAS/CONNECT, SAS/ACCESS, SAS/MACRO, AS/INSIGHT, SAS/LAB, SAS Enterprise BI server, SAS/ETL, SAS Enterprise ETL Server
Languages: C, SQL, COBOL
Databases: Teradata 15.0, Oracle 9.x/8.x/7.x/6.x, MS SQL Server 2012/2008/7.0, MS Access
OS: Windows - 95/98/00/XP/7/NT, DOS, UNIX
OR Tools: STAT GRAPHICS, STAT EASE, SAS 9.3, 9.2, 9.1.3, SAS 8.2
Platforms: Windows and UNIX
Office Tools: MS Word, Advanced MS Excel, MS PowerPoint
Professional Experience
Capital One, McLean, VA Apr 2013 – Present
Computer Programmer / Information Analyst
Capital One is a diversified bank that offers a broad array of financial products and services to consumers, small businesses and commercial clients. A Fortune 500 company, Capital one has one of the most widely recognized brands in America. As one of the nation’s top 10 largest banks based on deposits, Capital one serves banking customer through branch locations primarily in New York, New Jersey, Texas, Louisiana, Maryland, Virginia, and the District of Columbia.
Responsibilities:
Under direction of Capital one Associates, code statistical models using SAS for production model implementation.
Interpret business request to product model sample data.
Interpret model data specifications.
Code efficient data selection against Teradata warehouse
Code various model implementation stags conforming to established SAS coding templates.
Analyze existing model implementation processes and propose efficiency enhancements.
Encode and test modifications to existing approved codes.
Produce scored datasets using new models on past time periods.
Analyze data on various environments, Teradata, SQL server, DB2, etc. for suitability in use for statistical model development.
Perform activities to assist statistical model developers in monitoring stability, validity, and performance of their models.
Coordinate request between business analyst, statistical analyst, and data analyst for fulfillment.
Environment: SAS 9.3, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS Enterprise Guide 5.1, Teradata 15.0, Linux 2.6.32, Windows 7, Microsoft Office 2010, Attachmate EXTRA! X-treme 9.2
DFC Global Corp., Berwyn, PA Feb 2011 – Apr 2013
SAS Programmer Analyst
Dollar Financial Corp is a leading international diversified financial services company primarily serving unbanked and under-banked consumers for over 30 years. The Company’s products, principally its short-term consumer loans, check cashing services; secured pawn loans and gold buying services provide customers with immediate access to cash for living expenses or other episodic needs. Dollar Financial Corp. was originally organized in 1979 and now operates a network of approximately 1,236 stores, including 1,144 company operated stores in the United States, Canada, United Kingdom, the Republic of Ireland, Sweden, Finland and Poland. The Company has the largest store network in both Canada and the United Kingdom and a strong presence in key U.S. markets
Responsibilities:
Support Decision Science (DS) group data and reporting requirements
Design and code data marts in SAS, providing run documentation wherever appropriate
Build reports in SAS and Microsoft Excel, taking advantage of pivot table capabilities
Serve as a liaison between DS group and IT in the ongoing build of global data warehouse
Designed and Developed a Data Mart consisting of two datasets with summarized Daily and month end data.
Created weekly and monthly dashboards with country level, Region, and Store level groupings.
Developed Vintage reports at loan level and customer level. Loan vintage Report, New customer and existing customer vintage reports.
Created a monthly bucket report to provide collections performance information for higher management, this report is based on exact 30-day intervals from the day of return unlike calendar based reports where number of working days not consistent across accounts. This report also provides a tool for planning / budgeting at delinquency bucket level.
Environment: Base SAS 9.3, SAS/Access, SAS/Connect, SAS/SQL, SAS/ODS, SAS/Macros, SAS/Graph, SAS Enterprise Guide 4.3, SAS/Stat, SAS/ETS, SAS Add-In for MS Office, Windows XP, MS-SQL Server 2008, MS Excel 2007, MS Access 2007.
Capital One, McLean, VA Oct 2008 – Jan 2011
SAS Data Analyst
Capital One Bank, headquartered in McLean, Virginia. It offers a broad array of financial products and services to consumers, small businesses and commercial clients in the U.S., Canada and the UK. Capital One is one of the 10 largest banks in the US based on deposits. Ranked #145 on the Fortune 500 and serving approximately 45 million customer accounts
Responsibilities:
Worked with the Banking division handling customer requests, modifying existing report and creating new reports based on the business criteria. Also created ad-hoc reports.
Worked closely with the analysis team and the risk management team and provided support by providing reports based on their requirements.
Upload flat files, excel files, and SAS datasets to Teradata using libname & data steps. Extract source data from Oracle to create SAS datasets using PROC step.
Extract data, create new datasets from raw data files using Import techniques and modify existing datasets using SET, MERGE, SORT, UPDATE, and conditional statements.
Perform time series analysis, create regression models and generate reports using proc report, proc tabulate for consumer profiling, segmentation and targeting.
Create reports in Excel spreadsheets using SAS/ODS, Pivot Tables and implementing them in PowerPoint presentation.
Access flat files using SAS/ACCESS.
Create reports in PDF and RTF format using SAS/ODS
Extracting the data from Teradata as per the Business requirements using Fast Export and BTEQ.
Developed the BTEQ scripts to load the data from the new feeders systems.
Coded and tested the MVS batch jobs to execute the BTEQ and other load scripts.
Coded the scripts to load the data from flat files sources into Staging using Teradata TPUMP, MULTILOAD, FASTLOAD and BTEQ.
Coded BTEQ scripts to generate monthly, weekly, quarterly reports.
Performance tuning of the Teradata SQL queries. Optimized the queries using Explain plans, Collect statistics, Primary and Secondary indexes
Environment: Base SAS 9.2, 9.1.3, SAS/Access, SAS/AF, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS Enterprise Guide 4.2, 3.1, SAS/ETL, Teradata 12.0, Teradata SQL Assistant, Windows 2003, XP, Oracle 9i, MS Excel, MS Access,
Royal Bank of Scotland, Bridgeport, CT Aug 2006 – Jul 2008
SAS Analyst / Programmer
RBS National Bank, headquartered in Bridgeport, Conn., is a nationally chartered limited purpose bank. It provides both consumer and commercial credit cards nationally. RBSNB is an agent bank for Citizens, Charter One, Peoples Bank and a joint venture partner with the Kroger Company. It manages 1.6 million U.S. customer accounts and is a subsidiary of Citizens Financial Group, Inc., a $161 billion commercial bank holding company headquartered in Providence, R.I. Citizens is owned by RBS (The Royal Bank of Scotland Group plc).
Responsibilities:
Interacted with business users and gathered the requirements.
Extracted customer data form database (DB2) using SQL which included analysis of large data sets.
Scrubbing and sub setting data for the purpose of sustaining data accuracy as well as maintaining data quality; creating and selecting new variables
Worked with various direct marketing campaigns and provided analysis and reports.
Supported and maintained SAS applications for new campaigns
PROC SORT procedure was used to sort data sets before applying the MERGE statement when merging various Oracle tables
SAS data sets were constantly created and updated using the SET and UPDATE statements
SQL joins procedure was used to join various data from different data sets across various databases
Imported the spreadsheet data into the SAS using Proc Import procedure then generate the reports.
Proc Export procedure is used for exporting the data from SAS to spreadsheets
Applied simple statistical procedures such as PROC MEANS, PROC FREQ in analyzing data
Frequently supplied audit reports to the Audit Team based on their queries using various SAS procedures which often included the DATA_NULL_ data step.
Generate customized reports as required per the formats provided by the vendor.
Maintained routine SAS MACROS to create Audit reports, Waterfall reports and Final mailing lists.
Extensively used SQL query analyzer to write SQL queries.
Held regular meetings with program managers and statisticians where discussions included the technical specifications provided to them in the code.
Provided required reports to parties concerned to generate the technical specifications and analysis of the data.
Transferring files using FTP.
Loaded data of various campaigns in the database for future records and data analysis for future promotions
Documented and maintained records.
Modified older programs with hard-corded data values with Macro programs to enhance the flexibility, reusability of SAS programs and also to reduce system resources.
Environment: Base SAS 9.1.3, SAS/Access, SAS/AF, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/Macros, SAS Enterprise Guide, SAS/ETL, Windows NT, Oracle 9i, MS Excel, MS Access
ICICI Bank, Bangalore, India Sep 2003 - Jun 2006
SAS Programmer
ICICI Bank was originally promoted in 1994 by ICICI Limited, an Indian financial institution, and was its wholly-owned subsidiary. ICICI Bank is India's largest private sector bank with total assets of 3,461.29 billion. ICICI Bank currently has a network of 3,050 Branches and 10,890 ATM's across India.
Responsibilities:
Extensively interacted with business users for requirements gathering, analysis and documentation.
Extracted the source data from Oracle, and various flat files using data steps in SAS
Provided ad-hoc data analysis and reporting support for Sales and Marketing using Base SAS programming.
Created SAS datasets from Oracle database with random sampling technique and created Oracle tables from SAS datasets by using SAS Macros.
Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset merging techniques of SAS/Base.
Performed data manipulations on data stored in Oracle using SQL Assistant and PROC SQL.
Analyzed data using various statistical procedures like Proc Summary, Proc Means, Proc Freq, Proc Univariate
Used SAS/Macro facility to create macros for statistical analysis, reporting results and data extraction.
Proposed a set of action plans to mitigate the risks identified with the sourcing decision.
Generated HTML, Listings, Excel and RTF reports for presenting findings of various statistical procedures using procedures like Proc Report, Proc Print, Proc Freq and also SAS ODS
Extensively used SET, UPDATE and MERGE statements for creating, updating and merging various SAS datasets.
Used PROC SUMMARY and PROC REPORT to document the results and presented using
MS Power Point.
Created programs to set up data. Did data entry, conversions, validation and corrections, creating permanent formatted SAS data sets for present and future analysis.
Created individual rtf files for summarizing the results and also to document the metadata.
Wrote SAS Macros, SAS program codes, to import and export data from and to EXCEL
Environment: SAS 8.1 (Base, Stat, Graph, Macro, ETL, ODS), Windows NT, Oracle 9i, PL/SQL, SAS Management Console, MS-Office
Contact this candidate