SUMMARY

• 11 years of professional experience in Information Technology supporting in Banking, Finance and payroll Industry.
• Expertise in SAS AML, SAS Fraud Management tool to write rules in real time environment.
• Perform a complex analysis and builds predictive models to combat Fraud and Money Laundering Financial Crimes.
• The SAS AML Product includes a Graphical User Interface called Scenario Administrator to control the various components of a scenario.
• Strong background in software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Ability to write programming inSAS and the SAS Macro language in Unix/Window/Mainframe environment
• Develop programs & Convert designs and specifications into SAS programs following programming standards and best practices of the clients.
• Experience working with end - users in defining SAS analysis requirements, and performing SAS programming and statistical analysis.
• Quality assurance testing and data analysis using SQL and SAS, extracting data from data warehouse tables using SQL or SAS PROC SQL.
• Create test scenarios for the SAS projects and run tests to find errors and confirm that computer programs meet specifications & analyze code to find causes of errors and revise code.
• Ability to use SAS to analyze client and internal data and develop reports
• Provides input on database design for optimal structures for the support of data collection as well as analysis using various SAS Products.
• Participate in the creation of automated processes, data repositories, reporting, and analyses from multiple systems and data sources using a variety of tools, including SAS, SQL, and BI tools.
• Support production of Clients applications. Monitor performance of production applications and provide necessary support.
• Provide technical assistance by responding to inquiries from others regarding errors, problems or questions about programs.
• Document SAS algorithms and procedures.
• Worked with various databases like Oracle 10g, DB2 (AQT), Teradata (SQL Assistant), Netezza and Microsoft SQL Server.
• Well versed with supporting multiple applications and performing team activities.

TECHNICAL SKILLS

Operating Systems: Unix, Mainframes & Windows

SAS: Data step, Procedures, Proc SQL, Macros, ODS, STAT, GRAPH, Access, Connect, SAS EG/stored procedures, SAS Add-in for Microsoft office, Information Map studio & Web report studio.

Mainframes: IOF,ISPF & JCL

Languages: JCL/Mainframes, SQL

Databases: Teradata, Oracle, Sybase, DB2, SQL Server & Netezza.

QA Tools: HP Quality Center

Other Tools: Ultra Edit Studio, Telnet, WS-FTP ProAdvance Query Tool (Db2), Teradata SQL Assistance tool for Teradata and Netezza & SQL server management studio, Clearcase

PROFESSIONAL EXPERIENCE

Confidential, CA

FCRM- AML Analyst

Responsibilities:

• Responsible for supporting Analytics and Information (AI) department of the FCRM
• Apply wide array of advanced analytics techniques and address the business issues facing FCRM
• Perform a complex analysis and builds predictive models to combat fraud and money laundering financial crimes.
• Documents models and work with business partners to develop analytic plans
• Responsible for all aspects, develops SAS/SQL code SAS EG to generate daily alerts to monitor behavior of new account customers in order to identify possible fraud activity. Extracts and analyses large transaction data for new customer analysis
• Supported in simulating business rules and analyzing SAR (Suspicious activity report).Filing rates using SAS/SQL and Unix/Linux scripts to monitor the performance of the current risk rules under Unix/Linux systems.
• Authors SAS code for the APA (Alert Preprocessing & Analytics)business rules, including cash rules, wire rules and other rules to monitor potentially suspicious activity using enterprise guide and Unix/Linux scripts.
• SAS macros, PROC SQL and multiple SAS functions.
• Rewriting Customer Risk Ranking(CRR) under SAS environment and quality check of the CRR monthly report.
• Supports in debit card fraud modeling via SAS Enterprise Miner.

Confidential, NC

Fraud Strategy Analyst

Responsibilities:

• Responsible for writing rules in real time environment in SAS Fraud Management tool. extracting ideal data from the available data sources i.e. RH(DB2),Teradata (The W database) and MS SQL server.
• Writing simulation SAS code to match results with rule fires in testing environment.
• Done Analysis on Deposit and pos side to match with the fraud trend.
• Defined many number of UDVs(User Defined Variables) in SAS Fraud Management to determine the count and sum from transactions.
• Extensive working knowledge of data on Deposit and pos tables.
• Determined many fraudulent accounts using RH data Analysis.
• Identified fraud accounts and closed upfront before they go to OD(over draft) status.
• Responsible for generating adhoc reports.
• Written SAS Macros to determine the performance of SFM rules.
• Checking the stored procedure in SAS EG for the population of UDVs for transactions.
• Extensive used sql queries in fraud analysis

Confidential, NC

Sr. SAS Analyst

Responsibilities:

• Responsible for the development/enhancement/testing of the tickets received at central location i.e. project governance site. The status of tickets can be tracked from that site. Developers are responsible for providing the regular status updates.
• Identifying and extracting the ideal data from the available data sources i.e. Teradata (The W database), Netezza and MS SQL server.
• Identifying the required metadata information from the data dictionary or by consulting data architects.
• Created SAS stored procedures using SAS enterprise guide for analysts. These procedures are accessed by them using SAS Add in for Microsoft office and SAS Web report studio.
• Verifying the access of Teradata/Netezza datamart using the concepts of “help table” or “help database” through “Teradata SQL assistance tool”. Similar approach is used for SQL server database through SQL server management studio
• Used pass-through facility to bring data to the SAS and performed manipulations according to the project requirement. Libname connection to RDBMS is also used some times for straight forward data pull from single table with multiple filters.
• Client doesn’t have SAS/Access license to SQL server. The workaround approach is to pull the data from SQL server management studio to a flat file and then retrieving the flat file information using SAS datastep statements INFILE & INPUT.
• Upgraded the utility macros which are used across the teams to meet the developer needs.
• Used fast load technique of Teradata to load the SAS data into Teradata and then perform joins within Teradata using pass through facility.
• Created weekly, monthly or daily reports based on business requirements and were scheduled at crontab.
• Delivered the reports to the end users by downloading them from the UNIX servers using the ftp tools WSFTP or TECHTIA or ULTRAEDIT.
• The legacy reports were delivered either by loading it onto the sharePoint folder directly or emailing to end users using SAS filename statement and email engine.
• Documenting the SQL query date filters to SAS tables using SAS Macro concepts for the purpose of internal Audits.
• Followed client specific indentation for all SAS codes.
• Promoted the codes to UAT after the unit testing of all development tasks. Business users would approve the UAT results and then the codes would go to production.
• Ability to self-prioritize the open tasks at the governance site and complete them in real quick time.

Confidential, IL

Sr. SAS Developer

Responsibilities:

• Developed new SAS codes and modified existing SAS programs to load data from the source and create specific datasets, which are used as source datasets for report generating programs.
• Developing programs and Macros based on the new requirements
• Optimization using macros parameters.
• SAS Code enhancements as per the requirements
• Build scenarios and test cases to test the functionalities mentioned in the business requirement document.
• Communicate status on testing efforts by generating the reports based on the test case results.
• Writing SAS Macros for repetitive iterations
• Redesigning the report structure using SAS procedures.
• SAS Code changes for the internal audit review meetings.
• Code fixes for the issues found in testing
• Used SAS formats, SAS Macros creation in sampling process.
• Redesigned the tool to improve the performance, automated the tool to reduce the human interference.
• Developed Information maps using Info map studio for the end users.
• Tracking and communicating status/progress of project to managers
• Generating the reports on SAS EG using stored procedures as per the requirements.
• Involved in developing Proc-SQL quires for merging concatenating and updating the data.

Confidential, NJ

SAS Developer

Responsibilities:

• Developed SAS Macros to simplify SAS code and effectively reduce coding time.
• Created SAS programs using SAS/BASE SAS/MACROS and SAS/SQL .
• Imported data using LIBNAME and PROC SQL Pass -Thru facility to reduce processing time.
• Performed basic statistical analysis using PROC MEANS, PROC FREQ.
• Coordinating with the team for various enhancements in the process.
• Involved in development and enhancements of SAS Programs.
• Used various components of an INPUT and INFILE statements to Process raw data Files.
• Extensively used SAS ODS facility to create customized reports in HTML.
• Checking the SAS datasets for Monthly updating and sending the reports to client for verification.
• Using SAS/Base to perform sorting, merging, updating and generated reports.
• Generating reports by using procedures like Proc Sort, Print, Proc Tabulate and Proc Report.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Formats Functions and conditional statements.
• Involved in testing the correctness of the data before the delivery.
• Created SAS stored procedures to be accessed from SAS Add-in Microsoft office for the dynamic reporting.

Confidential, NJ

SAS Developer

Responsibilities:

• Created SAS programs that performed variety of tasks like deriving and/or summarizing data; joining data from multiple databases; generating listings and statistical summaries.
• Used SAS procedures like: Proc Mean, Proc Freq, Proc Transpose, Proc Report, Proc Summary, Proc Tabulate, Proc SQL, PROC PRINT.
• Involved in SAS ODS (Output Delivery System) to create HTML, RTF and PDF output files.
• Used SAS Macros, Procedures, and Statements like SET, MERGE to manipulate and analyze data for sending reports to end-users.
• Responsible for validating and deriving procedures for the accuracy of the output.
• Resolved data inconsistency issues and performed data cleaning.
• Followed a strict Software Development Life Cycle.
• Resolve customer queries and application issues
• Respect of the timelines and completing tasks before the timelines.