SUMMARY

• 6 years of strong experience in data analysis, SAS programming, business reporting and performance monitoring. Subject matter expertise in end - to-end SAS application development from requirement gathering to system study, user testing, and training.
• Extensive hands-on experience in using Base SAS, Macro SAS, and SQL in UNIX environment.
• Highly skilled in usage of basic standardSASprocedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary as well as traditionalSASdata step programming.
• Experience in bringing large data fromSAS and non-SASdata sources into aSASenvironment and performingSAS data manipulations against the resulting sets. This includes ability to merge datasets and to writeSASMacros and generate list outputs/reports.
• Strong data warehousing and ETL skills using SAS and SQL. Proficient in preparing business specific and ad hoc reports and scorecards using key performance metrics for senior management and business partners for presentation and further analysis.
• Assisted colleagues and senior management across various geographies around how to leverage and interpret the available data and metrics.
• Excellent project and relationship management, communication and team building skills.
• Extensive experience in generating data driven insights to drive business outcomes.

TECHNICAL SKILLS

Platforms: Windows, Mainframes, Solaris, Unix

Programming Languages: Base SAS, SAS Macros, SAS SQL

Databases: DB2, Oracle, SQL Server

Other Technologies: ETL, MS- Office, MS- Power point, MS- Excel

Project Management Tools: Focal Point, Visual SourceSafe, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SAS Programmer Analyst

Responsibilities:

• Working with strong 22 global markets across the international card services portfolio with 2000+ users across central and regional marketing, risk and finance organizations.
• Deliver and create data mart solutions with advance metrics and business logics to provide insights covering the entire customer lifecycle: account acquisition, customer management, spend stimulation, digital engagement, product cross sell, and attrition mitigation.
• Maintain existing data-marts and lead initiatives to improve business processes per the requirement of different AMEX Business Solutions.
• Built shell scripts to execute the SAS programs on UNIX platform to process and extract terabytes of data from different data warehouses and prepare datasets for ad-hoc analysis and business reporting needs.
• Created new and standard reports assimilating data from non-conventional sources.
• Presented key findings and insights to the senior management on lending charge card portfolio around various matrices of customer spend activity to analyze and understand customer spend behavior.
• Developed and maintained forecasting and analysis of variance drivers to improve decision-making on strategies regarding organizing customer lifecycle data and promotions.
• Analyze data and decide on the variables to include in reporting data-marts and optimizing them for custom reports.
• Bringing in digital capabilities for customer early engagement.
• Developed and performance tuned various SAS modules hosting reporting applications.

Environment: Base SAS, Macro SAS, UNIX (VI Editor, Shell Scripts), Microsoft Excel, Oracle

Confidential, Charlotte, NC

SAS Programmer Analyst

Responsibilities:

• Led a team of 4 associates to manage and implement change requests which includes requirement analysis, development of SAS modules and test cases, quality assurance of the deliverables and code walk-through.
• Designed analytical solutions to provide accurate tracking of containers which resulted in smooth transition to automated tracking.
• Successful in identifying the problem areas and improved equipment management decision making.
• Led initiatives to determine inefficiencies and optimize movement of containers resulting in considerable savings in operating costs.
• Identified key measures for calculating empty equipment costs using location costs in evacuation paths and analyze available data to get daily stock.
• Created smart quality control solutions and worked closely with technology groups to resolve issues with upstream data.
• Worked with terabytes of data to convert into solutions which are easily consumed by reporting and analytical users.
• Created design proposals & relevant documents for implementation of large scale ETL solutions.
• Assisted business partners and colleagues for business related queries and was the point of contact for the off shore team.
• Highly skilled in SAS metadata and partnered with data mart owners to validate data sanctity and investigate issues.
• Performance tuning of SAS components and Automation of manual processes.
• Worked on SAS/MQ interfacing and Crontab for job scheduling.
• Managed production support for critical processes and resolved complex execution issues and production problems on critical scenarios.
• Mentored new team members for technical / process documentation as per needs of project methodology.

Environment: Base SAS, Macro SAS, SAS/Access, Unix, Message Queue Series, LSF Scheduler, Business Objects, Crontab

Confidential, Pittsburgh, PA

System Analyst

Responsibilities:

• Studied the bank’s corporate actions processing system and developed a fully functional change management request using PowerBuilder for the front-end and Pro*C++ for backend services (mainframes).
• Performance tuned and optimized the database queries to increase operational efficiency and reduce the execution time for processing high volumes of corporate actions and transactions.
• Prepared technical documents and training materials for different lines of businesses and users to better understand the change request.
• Performed stress tests on the system to check its ability to perform under high volumes of traffic.
• Devised a new feature of populating a fax template automatically by passing values from frontend instead of creating word document manually.
• Liaison with the technology groups to point out issues in upstream data, resolve the same and get new variables added.
• Conducted process reviews based on business request to identify gaps and weaknesses in systems and processes.

Environment: s: Pro*C++, Mainframes, DB2, and Sybase Power Builder 10.5.