We provide IT Staff Augmentation Services!

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

  • Data-driven research toward PET/SPECT imaging agent development

Confidential

Research Scientist

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

Hire Now