Senior Business System Analyst Resume

SUMMARY:

Strong business analysis experience; Work effectively in a matrix environment; Demonstrated capability to work with business partners, analyze business and functional needs
In - depth knowledge of tools such as SQL server, SAS, Teradata, Oracle, Tableau and Power BI
Certified SAS Base Programmer for SAS; Advanced knowledge in SAS/Macro and SAS/SQL
Strong technical knowledge in using all types of SQL server constraints for database design, developing T-SQL queries, stored procedures, user defined functions, indexes, CTE and triggers to facilitate efficient data manipulation and data consistency
Experienced in SSRS to create different types of reports (tabular, matrix, drill down, sub-report, parameterized and ad-hoc reports)
Experienced in Tableau to create dashboards with quick filters, parameters and sets
Extensive knowledge in SSIS process like incremental loading, slowly changing dimension mapping, debugging, logging and dynamic SSIS packages
Extensive knowledge in using SAS Enterprise Guide and SAS Enterprise Miner for statistical analysis, predictive modeling and data mining projects
Experience in Python to manage data files
Good understanding of Star Schema and Snowflake Schema methodology
Experienced in Excel (vLookups, Pivot Tables, Match, Conditional formulas, What-if Analysis)
Rich experience in project management

TECHNICAL SKILLS:

Database: SQL server, Teradata, Oracle, DB2, Access

Reporting: Tableau, SSRS, Excel

Developing: T-SQL, PL/SQL, Visual studio, Python

Analysis: SAS 9, SAS Enterprise Guide SAS Enterprise Miner

ETL tools: SSIS

MS office: Word, PowerPoint, Visio

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business System Analyst

Work with a cross functional team on analyzing, reporting, testing and make recommendations to support business modeling
Gather and document business requirements (BRD) from appropriate business areas to design and configure clinical programs and ensure innovative, efficient solutions to meet business needs
Create functional specifications/requirements documents (FRD) and prototype new reports
Create, design, execute and track QA test cases to support pilot clinical programs
Research data & production issues received from the business; Document and communicate root cause of issues and recommend solution
Develop and deliver ad-hoc reporting following department standards
Demonstrate subject matter expertise (SME) within areas of responsibility
Assist with project planning, process & workflow analysis and documentation
Experience with all facets of the SDLC

Confidential

Data Analyst / Project Manager

Lead and managed international research collaboration with external (USA, EU) pharmaceutical companies
Identified and managed project constraints including resource, time and quality
Designed and managed project database, used stored procedures and triggers to ensure data quality and data integrity
Gathered data from various sources; used dynamic SSIS packages to load data files to database and archived original files with timestamp
Used SSIS packages to load data to data warehouse including transforms like aggregate, data conversion, derived column, conditional split, sort, audit, row count, look up and logging
Analyzed data and created various types SSRS reports like tabular, matrix, drill down, sub-report, parameterized and ad-hoc reports
Automated project file management with SSIS packages using Foreach loop and precedence constraints
Used Excel advanced features (vlookup, pivot table) to manage and analyze complex data sets

Confidential

Research Scientist

Confidential

Research Scientist

Analyzed complex pharmaceutical research data to identify trends
Transformed unstructured data to knowledge and applied it to gain business value