We provide IT Staff Augmentation Services!

Technology Consultant Resume

PROFESSIONAL SUMMARY:

  • Technology Consultant with Eleven years of experience in various SAS Business Intelligence & Analytics Tools, SAS Administration, problem - solving, leadership, implementation and management of complex software systems.
  • Experience in SAS Administration 9.2, 9.3, 9.4 and BI Architecture.
  • Installing and configuring SAS products on Server, Client and managing Metadata Repositories.
  • Disaster recovery and performance tuning of the SAS applications.
  • Maintaining SAS user/groups privileges, managing software licenses.
  • Given SAS and SAS EBI tools training to team members.
  • Expertise in handling complex Processes using Base SAS, SAS/Macros, SAS/Access, SAS/Connect and SAS EBI Tools.
  • Experience in Integration of various Data Sources like MS-Access, Excel, Flat and CSV Files.
  • Good experience in extracting tables from Oracle and Teradata using SAS.
  • Experience in various SAS Solutions as SAS Integrated Profitability Management Solution (IPM), Activity Basied Management (ABM), SAS Anti Money Laundering Solution (AML) and SAS Metadata Server.
  • Involved in Pre-sales, POC projects, RFI and RFP.
  • Well versed with Data Warehousing Concepts.
  • Worked on various projects involving data warehousing platforms like ETL.
  • Received corporate Training in Basel II.
  • Attentive in understanding and providing quality solutions to customer reported problems.
  • Experience in quality reviews to ensure that best quality output has been shared with the clients.
  • Analyzed business requirements from customers in a detailed way and proposed solutions which were very effective and user friendly.
  • Built good working relationship with the team members and provided guidance in coordinating and completing shared tasks.
  • Motivated the team members in a way that led to positive results within the team.

TECHNICAL SKILLS:

Technologies: SAS 9.1.3, 9.2 and 9.3 (SAS Base, SAS Macros, SAS Connect, SAS Access and SAS BI Tools - SAS DI Studio, SAS OLAP Cube Studio, Management Console, Stored Process, SAS Enterprise Guide, SAS Information Map Studio, SAS Web Report Studio and SAS Information Delivery Portal), UNIX, Windows 2000/XP/2003 Server, Mainframe and SQL.

SAS Solutions: SAS Integrated Profitability Management (IPM and ABM) and SAS Anti Money Laundering (AML).

Industry Expertise: Banking, Insurance, Retail and Market Research.

PROFESSIONAL EXPERIENCE:

Confidential

Technology Consultant

Responsibilities:

  • Installing and configuring SAS products on Server and Client (ABM & PM).
  • Monitoring servers, deploying patches and hotfixes.
  • Disaster recovery and performance tuning of the SAS applications.
  • Maintaining SAS user/groups privileges and managing software licenses.
  • Re-architecture the existing Integrated Profitability Management project, due to the performance issues.
  • Involved in Data Warehouse Architecture design for ABM Solution.
  • Worked as an Technology Consultant to assist in technical support to offshore and on-site team members.

Technologies: SAS Activity Based Management and Profitability Management solutions SAS BI Tools SAS ABM Server & Client, SAS PM, SAS DI, OLAP Cube Studio, Information Map Studio and Web Report Studio, Windows.

Confidential

Project Lead

Responsibilities:

  • Worked as an Onsite Project lead to manage the offshore and onsite team members.
  • Conducting weekly meetings with offshore and onsite team for work assignments, status reviews and clarifications.
  • Assisting in building a technical foundation for Confidential .
  • Involved in Data mart design.
  • Developed complex ETL jobs using SAS DI Studio.

Technologies: SAS BI Tools - SAS DI, OLAP Cube Studio, Windows and Mainframes.

Confidential

Project Lead

Responsibilities:

  • Involved in Data Warehouse Architecture design for Data One project.
  • Installing and configuring SAS products on Server and Client.
  • Developed ETL jobs using SAS DI Studio.
  • Built the Metadata Index comparison tool with SAS Store processes.
  • Following the SDLC methodology for the development of SAS ETL jobs.
  • Involved in QC operations and data analysis responsibilities to make sure that the data delivered is accurate.
  • Conducting weekly meetings with team for technical work assignments, status reviews and clarifications.

Technologies: SAS EBI Tools, SMC, SAS DI, SAS Connect, SAS Access, Control-M, Winris, E2Klist, Windows and Mainframes.

Confidential

Project Lead

Responsibilities:

  • Migrated the SAS programs from Mianframe environment to Windows environment using SAS migration procedures.
  • Sheduling SAS programs through Control-M and Winris tools.
  • Involved in Testing and Debugging of SAS code.
  • Improved the performance of existing processes.

Technologies: SAS Macros, SAS connect, SAS Access, Windows, Control-M, Winris, Mainframes and VMS.

Confidential

Project Lead

Responsibilities:

  • Involved in the complete SDLC process for the build of a DWH (common data store layer), UDS (User data store layer) and the Information Portal (reporting layer)
  • Understanding the CDM model and developed the Physical data model in DB2 Mainframe.
  • Also based on the CDM model of UDS layer, develop the SAS based model in the UNIX environment for reporting.
  • Developed XML reports using SAS XML Mapper.
  • Performed Data validations/integrity checks before delivering to Business Customers.
  • The detailed flows of each automated process are documented accordingly for future reference.

Technologies: SAS Macros, SAS Connect, SAS Access, SAS XML Mapper, Windows and UNIX.

Confidential

Project Lead

Responsibilities:

  • Involved in project management and the impact analysis meetings.
  • Involved in requirements gathering and in designing phase.
  • Migrated existing SQL programs in Mainframe platforms into SAS programs in Windows platform.
  • Sheduling SAS programs through Control-M.
  • Involved in Testing and Debugging of SAS code.
  • Improved the performance of existing processes.

Technologies: SAS Macros, SAS Connect, SAS Access, Windows, Control-M, and Mainframes.

Confidential

Project Lead

Responsibilities:

  • Developed ETL jobs using SAS DI Studio.
  • Creating semantric layer with SAS Information map studio, which is using for adchoc reporting for super users.
  • Create various combinations of Information maps and OLAP cubes to generate reports.
  • Given SAS BI training to team members.

Technologies: SAS Macros, SAS Connect, SAS Access, SAS BI Tools - SAS DI, OLAP Cube Studio, Information Map Studio and Web Report Studio, Windows and UNIX.

Confidential

SAS Senior Analyst

Responsibilities:

  • Tracking of the response and booking rate to generate valid data for former decisions.
  • Execute some stat analysis and weekly tests and null test.
  • Selection of affine Address for different WM Products.
  • Execute different tests to be prepared for the new legal base in Germany (new data Protection Act)
  • Ex-Post analysis of model performance, model stability, fact finding analysis
  • Campaign selection from the prospect database.
  • Data testing and database management.

Confidential

SAS Consultant

Responsibilities:

  • Involved in Data cleaning using SAS DI Studio.
  • Developed ETL jobs using SAS DI Studio.
  • Data Mappings between databases to Core system.
  • Created Scenarios and Risk factors for Knowledge systems.
  • Involved in Testing and Debugging.
  • Scenario Administration, Customization and Tuning.
  • Scheduling of ETL Codes, Report Generation through Autosys.

Technologies: SAS Connect, SAS Access, SAS BI Tools - SAS DI Studio and SAS AML Solution.

Confidential

Sr. Software Engineer

Responsibilities:

  • Analyze the requirements.
  • Involved in Data cleaning with SAS programs.
  • Develop SAS scripts to update the detailed datasets.
  • Develop custom SAS macros and UNIX scripts.
  • Involved in Testing and Debugging SAS code.

Technologies: SAS Base, SAS Macros, SAS Connect, SAS Access and Windows 2003, UNIX

Hire Now