We provide IT Staff Augmentation Services!

Sr. Sas Consultant Resume

4.00/5 (Submit Your Rating)

Chicago, IL

SUMMARY

  • 8 years of extensive programming skills using SAS wif Base and Advanced Certifications.
  • Expertise in Database Statistics, Business Analysis, Data and Team Management.
  • Strong noledge of statistical and data analysis applications: SAS Tools, SQL.
  • Proficiency in data manipulation applications: Excel. Excellent reporting and publication preparation skills using MS Power Point and MS Word.
  • Experience in analysing user requirements and provide customised analytical solutions to meet the complex reporting requirements wif high quality.
  • Good understanding of BASEL - II Concepts. Experienced in Regulatory reporting.
  • Experience in halping target and evaluate marketing campaigns.
  • Experience in end-end development, design and implementation of automation projects and tracking key pilot campaigns.
  • Successfully analyzed business workflow and system needs and defined and documented business logic and system processes.
  • Excellent Written and Oral Communication and experienced in preparing documentation on business needs.
  • Expertise in system design and development required for business process.
  • Expert in using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
  • Proactively manage up in case of conflicting priorities.
  • Self starter, Good team player, Strong team orientation & leadership qualities, hard working and enthusiastic, Very good logical skills suitable for process design, development & implementation.
  • Worked in onshore locations: Singapore and London.

TECHNICAL SKILLS

Statistical Packages: SAS/Base, SAS/MACROS and SAS/SQL.

Software Packages: MS Office

Tools: COGNOS, Business Objects, VBA, Qlikview, RCT

RDBMS: Oracle, Teradata, DB2, SQL Server

Operating Systems: Windows, UNIX

Languages: C, C++, Java, SQL

Web Related: HTML, DHTML

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. SAS Consultant

Responsibilities:

  • Provide support in delivering all monthly reports wif in timelines wif proper QC’s.
  • Understand the Infrastructure and the functionality of GLEAM.
  • Automated several existing reports using SAS DDE concepts which reduces the TAT and improved the quality of the deliverables.
  • Conduct variances analsysis to understand the movements in the RWA’s reported.
  • Prepare trends, comparisons to halp the business in preparing Sign off packs.
  • Analyse Client requirements by having regular interactions; Ask precise and right questions to obtain the detailed and accurate information regarding requirements, criticality, priority and do the documentation of the requirements.
  • Prepared documentation for the SIF requirements. Prepared process documents for all the projects handled.
  • Identifying and evaluating inefficiencies in the business process and recommending business solutions.
  • Implemented controls in analyzing the data to has clear line of sight. Review and enhance the effectiveness of all controls to improve the overall control environment.
  • Use project management methodologies, principles and techniques to develop project plans.
  • Created User and Training documentation, and conducted formal trainings to the team members.
  • Understand the business operations and prepare the functionality test plan which will be used by the team while doing the testing. Developed functional specifications for use of team members.
  • Analyzed business situations for various problems; initiated meetings and discussions wif business users and developers to solve the problems.
  • Act as a point of contact for information source, providing guidance and assistance in the system project decision making process.
  • Successfully analyzed business workflow and system needs and defined and documented business logic and system processes.
  • Took responsibility in developing functional solutions to the clients by ensuring quality and integrity.
  • Analyzed business situations for various problems; initiated meetings and discussions wif business users and developers to solve the problems.
  • Streamline process and automate wherever possible to reduce manual intervention in creating reports. Acted as a point of contact for escalations by stakeholders regarding deliverables.
  • Perform volumetric testing, comparision and variances of records in Input file against the data source system. The Output file is compared wif the Input data to ensure all data TEMPhas been transmitted and included wif no significant data loss.
  • Involved in giving business process related trainings and Technical trainings to the team members.

Environment: Base SAS v9.3, Enterprise Guide, SAS/Macros, SAS/SQL, SAS/ACCESS, MS Access, Teradata, Oracle, SQL Server, Windows XP, UNIX, MS Excel, MS Word, MS Power Point, RCT, Qlikview.

Confidential, Chicago, IL

SAS Consultant

Responsibilities:

  • Had regular interactions wif clients to understand the business requirements and prepare the documentation according to the requirements .
  • Marketing effectiveness consultancy evaluating and halping target marketing campaigns, meaning
  • Helping target marketing campaigns so they can generate more sales per $ marketing budget invested.
  • Campaign post implementation reviews
  • Providing insights and recommendations to the business on new processes from various analysis, campaigns and reporting data, thereby enhancing the future campaign activity.
  • Regular interaction wif the business partners for process, quality and timelines for deliverables.
  • Involved in various automation projects to create and deliver periodic reports, using SAS automation techniques and Excel features.
  • Deliver timely and insightful analysis across all products, channels and brands in the post campaign domain.
  • Regular interaction wif Pre-campaign, Modelling, Campaign deployment and the wider analytics teams towards joined-up campaign management.
  • Providing analysis and reporting for various campaigns under Direct Marketing, Individual Solutions and Digital Marketing and evaluating the performance of the same.
  • Streamlined and automated the reporting process wif zero errors and minimal manual intervention using SAS and VBA macros.
  • Involved in giving business process related trainings and Technical trainings to the team members.
  • Sound noledge on end-to-end campaign life cycle.

Environment: Base SAS v9.2, Enterprise Guide, SAS/Macros, SAS/SQL, SAS/ACCESS, MS Access, Teradata, Oracle, DB2, Windows XP, UNIX, MS Excel, MS Word, MS Power Point, VBA Macros.

Confidential

SAS Consultant

Responsibilities:

  • Generating MIS reporting on yearly, quarterly, monthly, weekly, daily basis.
  • Manage monthly transactions including obtaining all balances, initiating international and domestic funds transfers, current day cash positioning and reporting
  • Extracting data from oracle
  • Cleaning of data using data step and SAS base procedures
  • Automated SAS codes to run monthly and weekly and Daily reports.
  • Created new data files using PROC SQL, from the existing data sets for further analysis.
  • Developed SAS Programs based on wide usage of SAS/BASE, SAS/MACRO facility to generate tables, listings, reports, and the data is analyzed using SAS statistical procedures such as PROC MEANS, PROC FREQ, PROC TABULATE, PROC UNIVARIATE, and PROC SUMMARY.
  • Creating new data files using import techniques and modified existing data sets using Set, Sort, Merge, Update, and conditional statements.
  • Developed user defined formats and informants to integrate the date variables
  • Performed data integrity checks and data cleaning using SAS/MACROS and data steps, created HTML outputs wif table of contents using ODS HTML.

Environment: Base SAS v9.1.3, Enterprise Guide, SAS/Macros, SAS/SQL, SAS/ACCESS, MS Access, Teradata, Oracle, DB2, Windows XP, UNIX, MS Excel, MS Word, MS Power Point, VBA Macros.

Confidential 

Operations Research Analyst - SAS

Responsibilities:

  • Had regular interactions wif the Business Partners to gather the requirements.
  • Handling various activities of the project like information gathering, analyzing the information gathered, documenting the functional or business requirements.
  • Had regular interactions wif senior management to understood various process plans, business process, and functionality in detail.
  • Identifying new process, finding out gaps in existing process, arranging training modules for new process development and implementation.
  • Played instrumental role in integrating Zuji and LastMinute reporting wif Travelocity.
  • Effectively worked wif users to define business processes and information systems for supporting those processes and preparing detailed documentation.
  • Analyzed business situations for various problems; initiated meetings and discussions wif business users and developers to solve the problems.
  • Taken proactive steps to identify methods to ensure quality of deliverables.

Environment: Base SAS v9.1, SAS/Macros, SAS/SQL, MS Access, Teradata, Windows XP, UNIX, MS Excel, MS Word, MS Power Point, VBA Macros,COGNOS, Business Objects XI.

We'd love your feedback!