Lead Business Analyst Resume

SUMMARY:

Data analyst with 7 years experience in the banking domain and 1+ years in the pharmaceutical domain. Skills include Business Analysis, Statistical Programming, Data Warehouse / Data Mart design and testing.
SQL proficiency, including queries against IBM UDB, Teradata, Oracle, MS SQL databases
Data warehouse analysis: ER modeling, data validation, ETL development and testing. Waterfall and agile methodologies.
Used SAS extensively for 8+ years on multiple platforms, including: data management, macros, statistical programming, reporting. Processed large (multi - million record) datasets. Twice passed the Advanced SAS programming exam.

TECHNICAL SKILLS:

Skills: Excel skills, including Pivot tables, Vlookup and VBA macros Project support applications: MS Project, MS Visio, Sharepoint, HP Quality Center Data analysis on three major platforms Unix (Sun Solaris & AIX Linux), Windows (SAS EG) Mainframe (IBM mainframe with MVS and JCL).

PROFESSIONAL EXPERIENCE:

Confidential

Lead Business Analyst

Responsibilities:

: Retail banking data warehouse implementation.
Requirements gathered, exploratory data analysis, source to target mapping, data modeled, tested & validated ETL output.
Queried data on MS SQL, Oracle and Teradata servers, used various SQL interfaces, TOAD, SAS, etc.
: Developed and distributed reports to support operational roll-out of new application processing system across multiple geographies.
Tested IT built data mart, accessed IBM UDB databases and raw data staged as SAS datasets by IT, developed reporting process and distributed reports.
Used SAS for ETL process and report generation on AIX Linux platform.
: Supported deployment of data mart and reporting suite for retail banking Marketing Analytics
Assisted with requirements gathering, exploratory data analysis, and development of ETL processes. Liaised with IT teams in deployment of Cognos framework and standard reporting in Actuate.
Used SAS EG, SAS on AIX Linux and UDB databases
: List processing and reporting for large credit card portfolio
List processing: Followed requirements set forth by Credit Risk and Marketing Analytics to select customers eligible for retail banking campaigns;
Reporting: Adhoc and standard reports distributed to business partners using credit card portfolio data.
Used SAS on Mainframe (MVS with JCL), SAS on AIX Linux, Excel VBA, Pivot tables, etc.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship