SUMMARY:

SAS BI, Base, Stored Procedures, Web Report Studio OLAP, ETL, Excel Pivot Tables, VLOOKUP, SSRS, SSAS, SSIS, Microsoft Business Intelligence, SQL, Data Modeling, Visual Analytics, reporting, analysis

TECHNICAL SKILLS:

Application software knowledge: Windows XP, 7 & 8, MS Office, word, excel, Canopy, EMR, First Net, Epic, Mozilla, and Internet Explorer, SQL, SAS Enterprise, Management Studio, data mining, R, Excel advanced features, Pivot tables, VLOOKUP, CRM, Salesforce, Siebel, Tableau, OLAP, MS BI

PROFESSIONAL EXPERIENCE:

Confidential

HealthCare Tech

Responsibilities:

• Importing, cleaning, transforming validating and modeling data with the purpose of understanding and making conclusions from the data for decision making purposes
• Data Visualization presenting data in charts, graphs, tables, designing and developing relational databases for collecting data, designing data input and data collection screens
• Write SQL commands to query, map, join, delete, and merge tables, columns, rows of data, manipulate, filtering, aggregating and analyzing large data sets. SSRS, SSIS create reports, import and export data
• SAS applications: SAS Enterprise Guide, Grid Manager, Base SAS, SAS Management Console, Enterprise Miner, Office Analytics SAS administration experience including installation, configuration, tuning, troubleshooting and end user support, SAS Base programming and Business Intelligence.
• Excel: Data modeling, Power Query, Power Pivot, Power View, and Power Map, VLOOKUP, HLOOKUP, conditional formatting, aggregations, formulas, functions, import large datasets, analyze data and report findings, query large data, print reports, publish reports to web, SharePoint and intranet.
• Map to data sources: Hadoop, on premise data sources, streaming data, cloud services, Excel, Access and SAS, CRM, Salesforce, SharePoint and SQL.
• EMR: Canopy, Epic, Cerner rollouts, EMR installation, troubleshooting and training medical staff.

Confidential

Consultant

Responsibilities:

• Integrate and mine large data sets, connecting data from disparate sources to identify insights and patterns using traditional as well as predictive and prescriptive analytics. Source, scrub, and join relevant public, commercial, and proprietary data sources.
• Performing complex data extractions and manipulations, which culminate in the design and production of ad - hoc analyses and reports for external clients and company management
• Help to design and maintain the internal relational database infrastructure that the business relies upon for reporting and analysis
• Performing data validation to ensure accuracy and appropriateness of analytic models
• Designing and automating reports for efficient production
• Act as an internal consultant to work across company departments to gather data and perform analysis
• Preparing executive summary reports and present to management
• Collects, analyze, aggregate and summarize financial, market research and sales data.
• Understand the business needs analyze, manipulate, query and aggregate data. Extract data from multiple sources: CRM, Salesforce, RDMS, OLAP, SQL databases, Excel, Access, CSV, flat flies, Hadoop, perform ad-hoc analysis, translate and communicate results to key decision makers.
• Excel Advanced User: Performed Advanced Data Analysis and reporting. Created / used Pivot Tables and conditional formatting to summarize data and find trends. Utilized Microsoft Business Intelligence analyzes, map, aggregate and model data.
• SAS administration, creating and assigning, establish connectivity to data sources, add users and manage their access, check status and operate servers, backup and restore the SAS environment, manage connection profiles, create data structures, generating reports, recognize and correct syntax errors, import and export raw data files, manipulate and transform data, combine SAS data sets, create basic detail and summary reports using SAS procedures.

Confidential

SAS Administrator

Responsibilities:

• Collects, analyze, aggregate and summarize financial, market research and sales data.
• Understand the business needs analyze, manipulate, query and aggregate data.
• Extract data from multiple sources: CRM, Salesforce, RDMS, OLAP, SQL databases, Excel, Access, CSV, flat flies, Hadoop, perform ad-hoc analysis, translate and communicate results to key decision makers.
• Excel Advanced User: Performed Advanced Data Analysis and reporting.
• Created / used Pivot Tables and conditional formatting to summarize data and find trends.
• Utilized Microsoft Business Intelligence analyzes, map, aggregate and model data.
• SAS administration, creating and assigning, establish connectivity to data sources, add users and manage their access, check status and operate servers, backup and restore the SAS environment, manage connection profiles, create data structures, generating reports, recognize and correct syntax errors, import and export raw data files, manipulate and transform data, combine SAS data sets, create basic detail and summary reports using SAS procedures.

Confidential

Analyst

Responsibilities:

• Researching and correcting consumer complaints, quality assurance functions, data evaluation, working with other departments during testing/loading/project planning to complete User Acceptance Testing (UAT).
• Auditing data sets, preparing information for clients, manual data review, and support activities for other departments.
• Extensive phone calls to business owners to verify and enhance their business information
• SQL, experience working with large data sets, excel, vlookup, hlookup