SUMMARY

TECHNICAL SKILLS

Application/Functional areas/Packages worked on

BI product set implementation, custom application development in UNIX environment

Management Tools

MS Project, MS Visio, Clarity, Rational Portfolio Manager, Rally

Types of projects worked on

Full cycle SDLC, re-engineering, migration, maintenance, AGILE

Environments worked on

Unix AIX , Windows, Citrix Metaframe, Red Hat Enterprise Linux

Languages/Tools/Methodologies worked on

SAS: Grid Manager, Enterprise Guide, Enterprise Miner, Management Console, Base SAS, SAS macros, Enterprise Business Intelligence Server, SPDE, SAS Connect

Database: DB2-UDB, Netezza

Scripting: KSH, sed, awk, VB Script, lexx, yacc etc

Other: subversion, Managenow, Infoweb, MQC, Method 1, OPAL, WebSphere 7, Visual Basic, Troux

Languages/Tools exposed to

Actuate, MS .NET, Java, C, POSTGRESQL, X Windows, GNU Linux, JBoss, Oracle, Tableau, Clarity, Rally, Troux, Service-Now

PROJECT SUMMARY

Name of the project

Confidential

Client

Confidential

About the project

Centralized Merchant team is primarily responsible for maintaining relationship with millions of merchants. It focuses on analyzing merchant behavior and providing business insights to help merchants drive revenue and grow their business. Our primary goal was to improve merchant satisfaction especially among small merchants.

Team Size

20

Duration

Confidential

Role Responsibilities

• Onshore Business Development Manager
• Manage Relationship with client managers by providing them business insights
• Presented and lead various innovative initiatives to identify non-performing merchants and score them based on various value points
• Recommended and designed various merchant offers and value drivers to drive the growth of merchant business and partnership with AMEX
• Performed various innovative analytics including seasonality analysis, call ability, triage analysis, Opt Blue conversions, and rules of engagement etc.
• Plug Play analysis for merchants spending comparison with industry average
• Merchant pain points, speed of pay analysis
• Responsible for effective communication between the technical team and the client managers. Provide day to day direction to the project team and regular project status to the stakeholders
• Active member of solution team to draft strategies and proposals for new business opportunities in American Express. Present proposals to Client Directors and VPs
• Perform project control and reporting and provide regular project status report to all project stakeholders
• Mentor project resources
• Participate in American Express/IBM project audits and ensure that project is fully complaint to IBM and AMEX standards
• Provide consultation, recommendations and review reports to technology and business directors and VPs

Tools Methodologies

SAS, AIX, SAS EGuide, SQL, MS Office

Name of the Platform

Confidential

Client

Confidential

About the platform

RAMP is a platform for BI, Analytics and Predictive Modeling with card member and merchant data. The card member and merchant data marts are stored in SAS-base data warehouse in AIX environment. The RAMP environment employs various analytical software products to enable quick turnaround of adhoc data creation, statistical model building and in-depth analysis of Card member and Merchant data. This will enable the business Users to develop strategic analysis critical to the ES business, powerful predictive models and MIS in a timelier and cost effective manner.

Team Size

20

Duration

Confidential

Significant Projects on RAMP Platform

RAMP SAS Grid Migration:

• Designed, developed and published overall strategy and plan for migration from existing environment to new SAS Grid environment in all the Dev/QA/Prod environments.
• Prepared Architecture and Design for SAS Grid environment
• Provided Capacity Analysis and Cost Benefit Analysis Reports.
• Installed and configured SAS 9.2 on all the Grid Nodes.
• Installed and Configured SAS Grid Control Server, Metadata Server and failover High Availability environment.
• Installed and Configured Platfrom LSF, Platfrom Process Manager for load sharing and scheduling.
• Configured Load Balancing and Queues for better performance and control.
• Designed self-service macros for users to submit, track, prioritize and control jobs in Grid Queues.
• Provided Architectural Recommendations and best practices and presented demo sessions to business community
• Migrated 100 TB Data, Scheduled Jobs , SAS metadata and 300 RAMP Business users across various geographical locations to new Grid environment
• Proposed and Implemented Idea of migration of Tier1 SAN to Tier 2 SAN for Demand Management Saves

RAMP Data Refresh, Analytics and Extraction Projects:

• I played a vital role in planning, analysis, design, develop and implementing various data refresh and extraction projects in RAMP like Authorization data refresh, Global Closed Loop Refresh, ROC Clean Process, Addenda Refresh, Global Charge Volume extraction process, Model Scoring process, Merchant Scoring, Work bench data aggregation, Merchant Analytics etc.
• Performed adhoc analytics and provided insights and reports for client managers
• Designed innovative ideas to reduce outage periods for refresh, download time to staging area.
• Designed and recommended data refresh and integration strategies.
• Guided and motivated team members to deliver high quality solutions.
• Performed reviews in various phases of projects and provided recommendations.

DB2 to Netezza Migration:

• Provided impact analysis and designed changes in existing SAS jobs and metadata libraries to access Netezza instead of DB2.
• Trained developers and user community to optimize SQL queries and SAS jobs.
• Resolved user queries and provided best practices.
• Provided inputs to DBAs and Data Architects for optimal design of tables in Netezza.
• Explained architecture and benefits of Netezza to Business director and users.

RAMP Platform Improvement/Administration Initiatives:

• Administered Configured SAS Platform for better performance and availability
• Applied SAS Hot fixes in timely fashion to keep the environment on latest and greatest SAS release
• Coordinated with SAS consultants and IBM performance team to tune system SAS variables
• Evaluated new SAS products for the benefit of business growth and better performance
• Provided Architectural Recommendations and best practices and presented demo sessions to business community
• Optimized File System Configurations and TSM Backup policies for cost savings.
• Lead RAMP SAS 9.3 upgrade and Web Platform initiative.
• Contributed to enhance existing reference architecture for SAS Web environment to include and configure middle-tier.

SAS 9.3 Upgrade:

• Designed, developed and published overall strategy and plan for SAS 9.3 upgrade in all the Dev/QA/Prod environments.
• Coordinated effectively with various teams like RAMP Capabilities Team, Business Team, AET team, IBM EID Team, SAS Support Team.
• Partnered with Capabilities team to present multiple knowledge sharing / Best Practices / Q A sessions to 200 business users so that transition from SAS 9.2 to SAS 9.3 was smooth and seamless.
• Effectively coordinated and guided offshore team to change application code and test all the modules of RAMP application with more than 1000 test cases to ensure defect free UAT and production roll out.
• Provided Cost Benefit report, Migration Strategy/Approaches documents prior to SAS 9.3 upgrade

RAMP User Admin and Space Management Projects:

• Recommended and designed innovative ideas for user administration and security
• Designed and implemented User Access Admin Stored Process to define and control user access
• Provided recommendations on Metadata security
• Designed automated Space management, Space Usage Reports and clean work modules

Tools Methodologies

Unix AIX , Windows 2000, Citrix MetaFrame, SAS products: SAS EG, SAS EM, SAS Management Console, base SAS, SAS Macros, SPDE, DB2-UDB, Netezza, lex, yacc, awk programming.

Name of the project

Confidential

Client

Confidential

About the project

Duration

Confidential

Role Responsibilities

• Offshore Technical Lead
• Played vital role during impact analysis on existing data captures processes.
• Enhanced existing daily data capture process to add/update dataset structures for Fee based products and payments.
• Enhanced existing processes that refreshes SAS data mart and SAS reports and decommissioned obsolete reports.
• Develop one time adhoc off-load process to retain history data.
• Design and Develop SAS Macros to calculate new KPIs based on Fees as per business requirement.
• Responsible for creation of various documents like data mapping, detail design document, Playbook, test cases, status report etc.

Tools Methodologies

Windows, Citrix, Oracle, PC SAS, Base SAS, SAS Macros, PROC SQL, Toad, Quality Center, Clearcase

Name of the project

Confidential

Client

Confidential

About the project

Wellmark is providing health insurance to millions of Americans. Wellmark has multiple wellness vendors including Healthways, WebMD and UnityPoint etc. which provide wellness services to Wellmark members. The various wellness services contract is being transferred to WebMD instead of Healthways. So all the eligibility files eligible members for wellness services should be modified and sent to WebMD.

Duration

Role Responsibilities

• Involved in extensive impact Analysis on existing eligibility processes.
• Enhanced and modified existing eligibility processes.
• Created new SAS programs for eligibility, biometrics, incentives processes.
• Extracted data from SYBASE IQ databases to identify the eligible member.
• Created new data mart with dimension and fact tables for eligibility, redemption, reward action, digital health assistance etc.
• Develop Audit and Balance check programs for validations.
• Designed and developed KSH programs for automatic execution of eligibility processes.

Tools Methodologies

UNIX - Solaris, Citrix, Sybase IQ, Base SAS, SAS Macros, PROC SQL, KSH, Serena Dimension, Informatica, Ultra Edit, Vi editor

Name of the project

Confidential

Client

Confidential

About the project

Team Size

Confidential

Duration

Confidential

Role Responsibilities

• On-Site Business System Analyst Test Manager
• Responsible for Requirement Gathering, Analysis, System Integration Testing, User Acceptance Testing and ensure defect free and high quality solution to meet business requirements
• Test plan and Test execution, Defect management

Tools Methodologies

Name of the project

Confidential

Client

Confidential

About the project

WIM Warehouse Integrity Manager is in house developed utility to load data in DB2-UDB based Data Warehouse from MF files and maintain integrity by balance checking and reporting. Project was about enhancing the utility to generate load card files dynamically, support binary format data and other controls and maintenance scripts.

Team Size

4

Duration

Confidential

Role Responsibilities

• Offshore Module Lead
• Design, develop, integrate and test modules, peer reviews.

Tools Methodologies

AIX, DB2 UDB, POSIX ksh scripts

Name of the project

Confidential

Client

Confidential

About the project

SmartSelect is a Client Server Application used by Information Insights team to execute Campaigns. Project involves Enhancement, Maintenance and support of Mystic, A UDB Data Warehouse-based reporting and data extraction tool using custom-built ETL and OLAP products and SQL query generator built in VB to generate list of card members for a campaign based on criteria's selected by users.

Team Size

15

Duration

Confidential

Role Responsibilities

• Application Developer
• Design, Develop, test and production support

Tools Methodologies

Windows 2000, AIX, DB2 UDB, POSIX ksh scripts, VB 6.0, Java, Managenow, Infoweb