PROFESSIONAL SUMMARY:

• Committed IT professional with around 10 Years of experience in software development, design, analysis, coding, testing, implementation, support and Analytics.
• 5 years experience in Data warehousing and SAS analytics using SAS v6.12, SAS v8, SAS v9, SAS/BASE, SAS/MACROS in windows/unix environment.
• 4 years of experience in Openlink ENDUR/FINDUR 8/9.1/10.2 application support and administration.
• 2 years of experience in IBM BPM , Informatica 9 , Business Objects , IBM Process Designer 7.5, Tortoise SVN and application support and administration.
• Having good knowledge on AVS Scripting and jvs.
• Extensive experience in development of various software applications using SAS on windows and UNIX with Oracle, SQL-Server, MS-Access, Excel and Sybase databases.
• Expertise in SQL Server, Oracle, Sybase databases.
• Strong knowledge in Base SAS, Macros, SAS Procedures , Openlink Findur and Endur

TECHNICAL SKILLS:

• Operating Systems: Windows 98/XP/NT/Vista/ UNIX Sun Solaris
• Languages: Base SAS, C, C , Java, AVS Scripting
• Databases: SQL Server, Oracle, Sybase, MS Access
• Web Technologies: JavaScript, HTML
• Special Software's: SAS, Remote Administrator2.1 , Tortoise SVN , Control-M, WinScp, RapidSQL9,Business Objects , Micro Strategy , IBM BPM, CA Workload Automation
• Vendor Products: Openlink ENDUR/FINDUR

PRORFESSIONAL EXPERIENCE:

Development / Production Support / Administration / Configuration

Confidential

Project1: Basis Adjustment Inventory System

BAIS takes the Basis Adjustments amounts from Findur, attaches them to specific Bond ticket numbers or Mortgage Loan number and Segment, tracks them through the various asset transfers in Maximis or Enterprise, amortizes the Basis Adjustment amounts every month over the remaining life to maturity of the asset, and records income and loss amounts in the general ledger. In summary, BAIS is the vehicle that amortizes and inventories Basis Adjustments that are attached to hedged items. If a hedged item is disposed, then the remaining unamortized balance of its associated basis adjustment is to be written off.

Responsibilities:

• Extensive use of PROC SQL to perform queries, join tables
• Used data null and PROC REPORT to generate the outputs.
• Active participation in monthly departmental meetings and providing the necessary inputs on how to improve the standards.
• Worked closely with Statisticians, Data managers.
• Extensive experience in working with people across other sites when required.
• Validating the data sets and comparing the results to that of source programmers output.
• Ability to write some common macros that are useful across multiple studies.
• Ability to work on multiple projects simultaneously and meet the deadlines as and when required.
• Perform validation on derived datasets and following the standard operating procedures during the validation process.
• Generate reports either in HTML, PDF or RTF formats according to the client specifications. Providing Quarter End Support

Environment: Base SAS, SQL Server 2008, IBM BPM Process Designer , Business Objects, Micro Strategy, Findur

Features Used: SAS Base, IBM Process Designer, Business Objects, Findur10.2, SQL-Server2008/2012, Tortoise SVN. Micro Strategy

Project2: Manulife Derivatives Application:

• The Derivatives application is a valuation, accounting and reporting system for derivative assets for Manulife, John Hancock and their subsidiaries. It consists of numerous components, most notably FINDUR and a Hedge Matching Algorithm HMA .
• Confidential is a vendor developed, fully integrated front through back office solution for derivative trading, control, administration, accounting and reporting. Manulife uses FINDUR to administer derivative instruments. As part of the Derivatives Integration project, FINDUR has been customized to support FAS 133 accounting/reporting and modeling of John Hancock derivatives. Reuters is an additional key component of FINDUR that provides real-time and end of day pricing information.

Responsibilities:

• Reviewed large macro codes for running the programs.
• Assigned the tasks of designing and developing project-specific SAS programs like producing analysis datasets, graphics and reports
• Responsible for testing and implementing cross-project SAS programs and developing utilities
• Worked with the Statisticians, Data Managers to provide SAS programming in analyzing Data.
• Generated final study reports, tables, listings and graphs by using PROC Tabulate, PROC SQL, and PROC GChart.
• Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.
• Provided reports with minimum risk and optimum result.
• Participated in project meetings, presentations and updating research findings.
• Testing/Debugging/Modifying AVS scripts.
• Database restoration as per user requirement using SQL Server Management Studio and Lite Speed.

Environment: Openlink Findur Application, Windows

Features Used: Findur9.1, SQL-Server2005, SAS

Production Support / Administration

Confidential

Project 1: Open link Endur Application

• Wholesale Gas currently manages about 250 PJ/avia spreadsheets by gas market this covers 40 of the interconnected markets. As AGL's business grows so does the number of contracts/contract types utilizing several haulage arrangements across multiple pipelines. AGL business has outgrown its spreadsheet-based scheduling systems these systems are fragmented and lack 'audibility.
• To overcome this impediment AGL has come up with set of two applications Endur iOpt. Endur iOpt are two applications developed by Openlink. Together these two systems are known as Openlink systems.

Responsibilities:

• Understanding the Business and its Requirements
• Solving the production issues within SLA timelines.
• Installing Endur Application in all the users' machines.
• Implementing new Endur versions for all the users.
• Endur Database up gradation.
• Monitoring server's every day.
• Resolving Login issues for the new users.
• Implementing new enhancements in Endur with coordination of Openlink Sydney.
• Configuration of new enhancements.

Environment: Openlink Endur Application, Windows

Features Used: Endur, AVS Scripts, Remote Administrator2.1

Production Support

Confidential

Project 2: SAS KM Reports

This is primarily used for:

1. Analysis of information and production of month end reports.
2. Delivering billing history and churn information to other AGL Business Applications.

• The two primary users produce a range of reports that are viewed in Excel by approximately 50 people.
• It extracts data from various external systems like CIS , Mainframe and UNIX that provide SAS KM with input information. These data are processed by SAS System and finally Reports are generated and stored in various file formats like CSV, Text, Spreadsheet, Doc etc.

Responsibilities:

• Understanding the requirements of the Application
• Created and edit check programs to find data discrepancies in raw datasets provided by Data Management Group.
• Worked with the Statisticians, Data Managers to provide SAS programming in analyzing Data.
• Generated final study reports, tables, listings and graphs by using PROC Tabulate, PROC SQL and PROC GChart.
• Validating the datasets and comparing the results to that of source programmers output.
• Solving the production issues within SLA timelines.
• Writing SAS Macros to improve the performance of the application.
• Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.

Environment: SAS 8.2, Windows

Features Used: SAS 8.2, Remote Administrator2.1.

Production Support

Confidential

Project 3: Apollo SAS Backend

• Confidential is a new system in AGL that arose out of the AASB139 compliance project in late 2004 and early 2005. AGL required a new system that must be specially tailored to the Australian Accounting Standard AASB139 requirements and in particular, The Apollo system is a stand-alone system in order to minimize the system impacts caused by changes in AGL's interpretation and application of the standard.
• Confidential is not a decision-making tool. Apollo is an operational system that supports regular monthly energy accounting processes in the AGL Finance and Risk business. Apollo's core functionality is to apply the chosen accounting treatment to the AGL derivative portfolio as per the business methodology and generate the summary results that are eventually entered into the General Ledger system.

Responsibilities:

• Understanding the Business and its Requirements
• Generated final study reports, tables, listings and graphs by using PROC Tabulate, PROC SQL and PROC GChart.
• Solving the production issues within SLA timelines.
• Writing SAS Macros to improve the performance of the application.
• Developed various forms of outputs like RTF, HTML, PDF files using SAS ODS facility.
• Running manually the SAS jobs requested upon the users and generating the reports.

Environment: SAS 8.2, Windows

Features Used: SAS 8.2, Remote Administrator2.1.

SAS Analyst

Confidential

Project: NUHC ETL Project

• Single Customer View - NUHC focus on one single Version of the Truth to:
• Manage Customer effectively and improve customer retention.
• Improve sales, Establish robust customer networks.
• Increase efficiency and reduce operational costs via accurate and automated data handling.
• Improve Management Information Reporting
• Improve analytical capabilities

Responsibilities:

Requirements gathering and Due diligence

Environment: SAS, Windows

Features Used: SAS

Analyst

Confidential

Project: Analytics project for Target Financial Services

Process: Modeling and Statistical Analysis

• TFS's MSA team provides access for various data sources required for MSA, the account-level primary data e.g. data from CDW-v and CDW-p , credit bureau information and/or guest purchase information. This data is used by TCS to develop predictive models that support TFS operations including:
• Guest Services
• Marketing
• Fraud
• Collections
• Existing Accounts
• New Accounts
• The concrete purpose of TCS is to help out TFS to predict account risk i.e. the likelihood that an account will 'go bad' during the next 6 months , account collectability, fraud, account profitability, account retention, and response to marketing offers by way of developing predictive models.

Responsibilities:

• Understanding the Business and its Requirements, Developing SAS code to extract data from data warehouse.
• Analyzing the datasets based on their requirement. , Massaging the datasets using sas code

• Data validation and quality control check of the displays and datasets according to the different QC levels.
• Investigate, prepare, analyze, and validate data for down streaming Modeling and Analysis.
• Extracted data from Oracle database using Pass through Facility.
• Extensively worked on PROC REPORT and PROC TABULATE to produce reports for the purpose of validation.
• Involved in writing code using data step programming and macros to extract, clean and validate date from external source.
• Extensively worked with complex and huge datasets, and generated reports in various formats such as PDF, RTF, HTML and list files using SAS ODS facility.

Environment: CITRIX, SAS 9 Tools, Oracle, UNIX.

Features Used: Base SAS, SQL, UNIX Sun Solaris .

Associate Developer

Confidential

Project: Detail Data Store for Banking Solutions

• The Detail Data Store for banking Banking for DDS is a data warehouse that serves as the single version of the truth for the SAS Banking solutions.
• As such it contains the atomic level data and the historical information needed to populate the solution data marts.

Responsibilities:

• Understanding the Business and its Requirements
• Generating sample data using GSApps Tool
• Creating datasets and applying business rules on the datasets with base SAS and Macros.
• Massaging the datasets using sas code
• Loading cleaned data into DDS repository

Environment: SAS 9 Tools, GSApps

Features Used: GSApps, SAS 9.

Analyst Programmer

Confidential

Project: Business Financial Services Performance Measurement

Business Financial Services - Performance Measurement, a Data Warehousing application for Business Financial Services of Standard Chartered Bank, Malaysia Berhad, basically measures the profitability of BFS customers by Product. Information from both Wholesales and Consumer Banking Data Warehouse will be extracted for BFS use.

Responsibilities:

• Understanding the Business and its Requirements
• Hands-on experience working as a SAS programmer
• Expertise in Database management and SAS programming
• Designing the logical and physical model based on reports
• To prepare the data according to suggested schema model
• Reading flat files using Base SAS and creating datasets.
• Managing the data using Base SAS and Macros

Environment: Frontend: Power Builder 6.5, Backend: Sybase 12.5.2, MS-Access 97 ETL Tool: Base SAS, Macros, SAS/ Access