Business System Analyst/SAS Admin Resume

SUMMARY

Certified PMP Practitioner and Data Warehouse/Systems Consultant with over 12+ years of applied information technology IT experience specializing in the development of Data Warehouse architecture dat involves data integration and the conversion of data from multiple sources and platforms. Knowledge in the installation, configuration and management of SAS Enterprise Business Intelligence platform. Industry experience includes Banking, Telecommunications, Mortgage, Health, Insurance and Retail.
Provide leadership on high profile projects. Consistently demonstrate ability to communicate well with different organizational levels, from end users and technical staff to the executive level. Consistently meet tight deadlines and focus on quality results.
Developed Functional and Technical Specifications. Designed test plans to ensure correct results. Administered reports on a large - scale application with different types/formats.
Implemented SCRUM Methodology for Wipro Projects
Experience of conducting Sprint planning, Sprint review, Sprint retrospective and conducting Daily scrum meeting.
Develop and Maintain User Story, Product backlog, Sprint backlog and Burn down charts, Scrum board.
Estimation of User Story and task.
Educate and reinforce scrum methodology and agile framework to team members and key stakeholders
Knowledge of DevOps and Kanban concepts.

TECHNICAL SKILLS

SAS BI: SAS EBI 9.2, SAS 9.4, SAS Management Console, Enterprise Guide, Data Integration Studio, Platform Scheduling LSF, SAS Information Map, Web Report Studio, SAS OLAP Studio, BASE SAS, SAS Macros, SAS/Access, SAS Portal, SAS Dashboard.

SQL BI: SSRS,SSAS, and SSIS

Databases: Oracle 9i/10g, MSSQL Server, MS Access, Teradata, Sql server 2008

Languages: VB, VB.net, Oracle PL/SQL. MDX Query

Operating System: Windows 2000, Windows NT, Windows 9x,Linux

Data Modelling Tool: IBM Rational data architect, ER-Diagram

Version Control Tool: VSS and SVN

Project Management: Microsoft Project, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Business System Analyst/SAS Admin

Responsibilities:

Maintenance and Support SPO Application.
Maintain Kanban board to track the tasks for SPO.
Conduct the weekly stand-up.
Interact with Business to solve the day to day queries.
Support and Manage SAS Servers.
User group and Security Access using SAS Management Console.
Apply Hot Fixes, Maintenance Releases and renew Licenses.
Using Information Map Studio to build information maps structures
UsingSASStored Process Web application to build Selection Screens
Olap Cube Studio to build Olap cubes.

Confidential

Project Lead /Scrum Master

Responsibilities:

SRS Document and Technical specification document creation.
Data model review and creation of Low Level Design Document for ETL.
Created of UT Test Cases, SIT Test Cases.
Coding usingSASBase andSASMacro.
Generating Ad hoc and scheduled reports usingSAS/ODS,SAS/Access andSAS/Connect
Used SAS/STAT procedure such as Proc Sort, Transpose, Freq, Mean, Report, Summary, etc. to analyse and report the data.
Creation ofSASMacros and updating the existing Macros.
UsedSASODS to produce HTML, PDF and RTF format files.

Confidential

Technical Lead/Data Architect

Responsibilities:

Primary consultant for implementing logical model to Physical Design which involves defining data attributes and domain.
Database sizing, creating Data Definition Language DDL and trigger scripts for database constraints implementation and verification.
Interfaced with Confidential Project Managers, Technical Leads, Application Developers and other Database Administrators to extract user requirements and formulate Data Warehouse architecture.Extensive hands-on experience in the analysis, design, development and implementation of Operational Data Stores ODS and Data Warehousing DW systems including STAR, SNOWFLAKE, Multi-Dimensional data base MDDB design.
Designed the methodology for creating data stores/data marts, which entailed data scrubbing, transformation and grouping
Designed application, development and production database environment to allow on-going development and enhancement on highly visible production system

Confidential

Tech Lead

Responsibilities:

Design process to integrate metadata and data sources from multiple systems and platforms.
Design, Code and Implement Extraction, Transformation and Loading ETL code for Data Aggregation using SAS Data Integration Studio
User group and Security Access using SAS Management Console.
Create SAS Reports using Information map and Web Report Studio
Create job schedules using LSF.
Extracted data from Oracle views using variousSAS/Access methods including libname statements and the SQL Pass Through facility.
Used Data Null andSASprocedures such as Report, Tabulate, Freq, Means, Summary and Transpose for producing customized reports.
Used Enterprise guide to write the stored procedures, Generate Reports and also performed Data and Statistical analysis.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship