SUMMARY:

• Certified SAS Programmer/Analyst with 8 years of experience in Analysis, Design, Development and Validation of applications mostly in financial sector.
• Worked extensively on SAS Procedures and Data Step Programming to develop the process flow applications from Data Acquisition to Data Modification and Reporting.
• Experience with SAS/BASE, SAS/MACROS, SAS/STAT, SAS/CONNECT, SAS/ACCESS. SAS/GRAPH, SAS/SQL and SAS/ODS in Windows and UNIX environments.
• Excellent commanding in generating reports in HTML, PDF and RTF formats using Output Delivery System (ODS).
• Widely used SAS for various ETL purposes.
• Wrote BTEQ, SQL scripts for large data pulls and ad hoc reports for analysis.
• Strong skills in SQL, Data Warehouse, Data Extraction, Data Validation, Reporting and Excel.
• Expertise in SQL Procedures, Functions, Views and Triggers. Experience in trouble shooting techniques, tuning the SQL statements, Query Optimization and Dynamic SQL.
• Extensively worked in creating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Expert UI designer specialized in developing visually stunning Micro Strategy Dashboard using Report Service.
• Expertise in Business Intelligence Applications using Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.x/11.1.1.x).
• Good Knowledge in all the latest BI Tools focusing on Tableau and Qlikview Dashboards in latest Design, Presentation and solving client's reporting needs.
• Worked with Targeted Marketing Campaigns, Online Banking, Global Investment, Performance Analytics, Reporting, Capital Markets, Debit Card, Credit Card, Deposits, Funds Transfer and Client Information Systems.
• Expertise in creating tables and views on top of the Finance Data mart/ production databases by using Teradata and UNIX as per Ad - hoc request.
• Enhancements and evaluation of credit/debit card system and Financial Applications.
• Strong knowledge of credit risk model development & strategy design.
• Keen analytical skills in preparing Credit scorecards, drafting credit policies and recommending risk tolerance levels in various portfolio concentrations.
• Good statistical knowledge of descriptive models including various sorts of mixed models and predictive solution models including linear, multiple regression models.
• Experience in creating complex test plans, requirements and designing test cases. Managed execution of different testing phases.
• Highly motivated individual with excellent organizational and interpersonal skills.

TECHNICAL SKILLS:

RDBMS: Teradata, MS Access, DB2, MS SQL, Oracle

SAS Tools: SAS Enterprise Guide, PC SAS, Unix SAS

Languages: C, C++, T-SQL

Scripting: UNIX Shell Scripting, VB Script

Methodologies: SixSigma, DMAIC

SAS Expertise: SAS v 9.0, 9.1, 9.2, 9.3 SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ODS

SAS Procedures: Print, Means, Univariate, Correlation, Regression, PROCSQL, Report, Frequency, Sort, Summary, Tabulate, Format, Import, Export, Transpose, Compare,Gplot and Gchart etc.

Query Tools: Microsoft SQL Server Management Studio, Teradata SQL Assistant, SQL Enterprise Manager, ETL Tools, MS SQL Server Integration Services (SSIS), Toad

Documentation: MS-Office 2003/07/10, MS-Visio, IBM Lotus Notes

Operating Systems: Windows 95/98/2000, Windows XP, Vista, Windows7/8, UNIX, IBM Mainframe

Other: Subversion (SVN)

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

SAS Programmer

Responsibilities:

• Importing data and creating SAS Datasets, used PROCSQL to join tables and merging data using DATA MERGE or PROC APPEND according to the requirement and generate the reports and analyze those results.
• Implemented various procedures such as PROC Tabulate, PROC Means and PROC Report to generate tables, listings, graphs and reports.
• Created complex and reusable Macros and extensively used existing macros.
• Generated high quality reports in the form of listing,HTML, RTFandPDFformats usingSASODS.
• Altered existing datasets using set, merge, sort, formats, functions and conditional statements.
• Made the results actionable for Marketing, Campaign Planning, Strategic Planning, Finance and Sales organizations.
• Created and delivered recurring as well as ad hoc marketing campaign programming within stipulated timelines.
• Actively involved in list production for various customer campaigns of products and marketing.
• Coordinated with the market research and analysis team for customer segmentation and targeting of various products.
• Assisted in developing regression models for better decision-making on the consumer purchasing pattern.
• Efficiently coordinated with marketing department to finalize launch of targeted campaigns.
• Responsible for analyzing business requirements and developing Reports using PowerPoint and Excel to provide data analysis solutions to business clients.
• Automated data analysis programs with a goal of improving efficiency. Used SAS system macros for error handling, code validation, date stamping of log files and collected files to a given directory.
• Designed the ETL process for loading the tables using Informatica Powercenter 8.1 and made use of SQL stored procedures.
• Worked in performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Developed analytical processes, statistical models and quantitative approaches for automated reporting capabilities.

Environment: SAS 9.1.3/9.2, SAS Enterprise Guide, Cognos, Teradata, UNIX, Informatica, SQL, Teradata 13.0, Oracle Teradata SQL Assistant, PowerPoint, MS Excel, MS Word.

Confidential, Atlanta, Georgia

SAS Analyst

Responsibilities:

• Developed SQL queries for data retrieval from relational databases for quality control reviews against the original source data.
• Generated Pivot tables in MS Excel and charts/tables in MS PowerPoint using the OLAP cubes for the business users.
• Integrate the business, technical and operational metadata captured from various tools and created data lineage showing end to end data flow.
• Design and implement metadata change management and deployment process while moving metadata from one environment to other.
• Wrote UNIX Shell scripts and design batch process to automate the metadata import-export, run data lineage and metadata deployment process.
• Designed the metadata, workflow, models in Excel with great transparency and used SAS macros to process the excel file and generate ETL, model scoring and cash flow analysis SAS code.
• Built several Teradata objects such as Tables and Views.
• Developed SAS PROC SQL code to transform the original to target datasets for complex applications using ETL process.
• Performed data analysis for global consumer and small business AML/Regulatory Compliance.
• Demonstrated the understanding of business rules to identify high risk factor for customers.
• Created SAS MACROS for applications to customize SAS software programs and used the existing ones for standard reporting.
• Combined and maintained large data sets from several sources in varying formats using set and merge.
• Assist in Deployment and provide Technical & Operational support during Install.
• Involve in Post implementation support.

Environment: SAS Enterprise Guide, Teradata SQL Assistant, T-SQL, SAS, PowerPoint, Excel, IBM z/OS,Informatica Power Center, IBM Mainframes.

Confidential, Dayton, Ohio

SAS Programmer

Responsibilities:

• Performed analysis on campaign response datasets and created reports with extensive use of BASE SAS, Macros, SAS reports and procedures and linking with DDE to produce tables and graphs.
• Performed end-to-end marketing campaigns in design & coding and analyzed post campaign results.
• Provided campaign population insights and coordinated with marketing analysts.
• Creating, cleaning, validating and updating SAS data sets. Implementing SAS programs by SAS procedure and SAS Macros.
• Effectively usedInformaticaparameter filesfor definingmapping variables,workflow variables, FTP connections and relational connections.
• Responsible for creating ETL design specification document to load data from operational data store to data warehouse.
• Developed load scripts to work with multiple data sources (SQL, Flat Files, Excel, and MS Access).
• Coordinated with the market research and analysis team for customer segmentation and targeting of various products.
• Building up VBA Macro for Processes which are recurring jobs to pull data for specific requirement.
• Created Daily, Weekly, monthly reports related by using Teradata, MS Excel, and UNIX.
• Migrated data from Flat Files to Oracle database by designing scripts in SAS for compatibility with Oracle.
• Provided Keen analytics in preparing Credit scorecards, drafting credit policies and recommending risk tolerance levels in various portfolio concentrations.
• Automating and Scheduling the Teradata SQL Scripts in UNIX.
• Generated Ad-hoc reports by using Oracle, Teradata, BTEQ, and UNIX.
• Used SAS to develop various ad hoc programs and reports as well as provide detailed monthly tracking analysis, executive summaries, and presentations to Senior Management on performance and execution of Marketing programs and trend analysis for Planning and Control issues.
• Extensively worked on Unix Shell Scripts for automating the SQL scripts, checking daily logs, sending e-mails, extracting the data from legacy systems, setting user access level, automating backup procedures, Scheduling the jobs, checking Space usage and validating the data loads.

Environment: SAS V9, ORACLE, UNIX, Teradata SQL Assistant, SAS Enterprise Guide, Putty, Excel, Tableau.

Confidential, Jersey City, NJ

SAS Programmer

Responsibilities:

• Extensively used existing macros and developed new SAS macros for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Used SAS ODS to create HTML, RTF and PDF outputs files in the process of producing reports.
• Automated data analysis programs with a goal of improving efficiencies. Used SAS system macros for error handling, code validation, date stamping of log files and collected files to a given directory.
• Developed variousOBIEEreports using Subject Area in order to show data related to project requirement.
• Developedcustomized interactive dashboardsinOBIEEusing drill down, guided navigation, prompts, filters, and variables.
• Generated Pivot tables in MS Excel and charts/tables in MS PowerPoint using the OLAP cubes for the business users.
• Definedsession and repository variablesandinitialization blocksto streamline administrative tasks and modify metadata content dynamically.
• DevelopedDimensional Hierarchies,Level Based Measures,and added multiple sources to business model objects.
• Generated listings and reports from SAS programs using MACROS, ODS and PROC TEMPLATE /REPORT/ TABULATE.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL files.
• Hands on of working with heterogeneous data sources.
• Program complex edit checks to support the ongoing review and cleaning of clinical studies, and program reconciliation checks for external data review and cleaning.

Environment: Base SAS, SAS/EG, SAS DI studio 4.2, SAS ETL, SAS Web Report Studio, SAS OLAP, Excel, UNIX (SOLARIS), Windows, Teradata.

Confidential

SAS Programmer

Responsibilities:

• Migration of data from DB2 to SAS Files in UNIX.
• New Unix Shell scripts to run the jobs in place of the JCL.
• Creation of new functional parameters for reusable macros for the new jobs in UNIX.
• Correlating and presenting weekly or monthly data to senior management.
• Used SAS and SQL skills to perform ETL from DB2 and Teradata databases and created SAS datasets, SAS macros, PROC/data steps and SAS formats as required.
• Developed reports as per business requirements and created various reports like summary reports, tabular reports, excel reports etc.
• Developed new/modified macros for report generation using SAS/Macros as per business requirements.
• Created SAS datasets from various sources like Excel datasheets, flat files and created reports and files from existing SAS datasets.
• Responsible for correcting and maintaining daily, weekly, and monthly insurance claims and payments reports using SAS.
• Responsible for creating and delivering recurring as well as ad hoc marketing campaign programming within strict timelines while under constantly changing requirements using SAS, PROC SQL, and Teradata SQL in a UNIX environment with Oracle, Informix, and Teradata relational databases.
• Used SAS to develop various ad hoc programs and reports as well as provide detailed monthly tracking analysis, executive summaries, and presentations to Senior Management on performance and execution of Marketing programs and trend analysis for Planning and Control issues.

Environment: SAS/Base, SAS/Macro, SAS/STAT, Unix Shell Script, Perl UNIX programming, SAS v8/v9, SQL Assistant 12.0, MYSQL, Windows NT/2000.

Confidential

Data Analyst

Responsibilities:

• Worked directly with end users to gather Business requirements,
• Design and develop a front application in VB 5.0.
• Designed and developed Search and View screens and did field level validations for all the fields used in the application using VB6.0.
• Perform data manipulations using UNIX, BTEQ and KSH scripting.
• Designed the database in MS Access (Creation of Database, tables, views and Procedures).
• Performed validation testing and UAT to produce clean and consolidated results.
• Manipulated and updated the tables as per specifications and extensively used stored procedures.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.
• Came up with methods to improve functionality and effectiveness of the code by brainstorming with other team members during team meetings and discussions.
• Assisted the DBA with scheduling jobs, running various scripts related to space management
• Assisted in documenting User Manual and facilitate UAT and provide follow up to resolve the issues.
• Automating reports using MS Excel with ODBC Connection.
• Scheduling SQL Job to run at night times.
• Designed and developed a metadata driven automated reporting system

Environment: Base Visual Basics 6.0 MS Access, Word, Excel, Windows