We provide IT Staff Augmentation Services!

Business Consultant Resume

San, FranciscO

PROFESSIONAL PROFILE:

  • Passionate about using all knowledge & skills acquired at various Healthcare, Insurance, Legal and Financial companies to help users resolve business problems
  • Expert level in T - SQL application development, database design, reporting solutions and performance optimization
  • Understanding of database modeling for RDBMS & OLAP (star & snow-flakes schema).
  • Excellent at data quality improvement and QA/QC
  • Proven background working with users to understand and document business requirements as well as improving data(base) quality. Very proactive Client/ Users Support management.
  • Self-motivated, result-oriented, and excellent verbal and written communication skills.
  • Local candidate, can interview and start a new project immediately.

TECHNICAL SKILLS:

Operating Systems: MS SQL Server 2012/2014, Windows XP/7/10, LINUX (GVIM, FILEUTIL)

Languages: T-SQL, Python

Business Intelligence: Microsoft BI (SSMS, SSAS, SSIS, SSRS), BIDS, PowerPivot, Report Builder, Tableau

Software/Applications: MS Office 2010/2013, JIRA/BitBucket/ SourceTree/Confluence, TeamViewer9, Pivotal Tracker, Vault, SalesForce DESK.com, Confidential Analytics, Crystal Report XI, Web Outlook, Cisco VPN, Citrix

Medical: HIPAA, ICD9X/10, CPT, NDC, NPI, HEDIS, UNOS, Transplant

Medical Databases: CRMS Mc Kesson, NextGEN, BioClinica CTMS, SIMS Claims Management, TeleResults (TITUS)

Confidential: GoogleSQL, Confidential CRITIQUE, Confidential WorkFlow, Confidential SPHINX, Confidential BUGANIZER, Confidential Desktop

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco

Business Consultant

Responsibilities:

  • Supporting the iTRACKER Software Compliance database operations for the Wealth Management Business Unit.
  • Developed new SQL scripts for aggregated Loads Counts, Orphean servers identification. Created Store Procedures.
  • Using a TABLEAU application to download Monthly Server/Scanned reports.
  • Developing new VIEWS on the Tableau Portal for data aggregation . Reported using Excel, Outlook.
  • Participated in Global meeting with others collaborators, using Skype 4 Business.
  • Ran Friday weekly data loads with accuracy and on-time .

Confidential, Mountain View

Business Analyst& Business Intelligence Developper

Responsibilities:

  • Maintenance of Revenue Workflow Monthly applications from Europe, Russia, China, Latin America
  • Updated GoogleSQL scripts with new user’s requirements. Identified, documented, resolved defects and tested new BI solutions.
  • Used CRITIQUE, a tracking and monitoring tool to coordinate data analysis with others team’s members.

Confidential, Novato, CA

Sr. T-SQL Developer & Database QC Analyst & DBA Performance Analyst

Responsibilities:

  • Working with Sr Analysts, updated user’s requirements for compatibility with new Case Management System
  • ReDesigned 100’s of SQL Store Procedures from V1 schema to V4 schema for the new Case Management CMPv4 system.
  • Identified, Fixed and Documented database migration script defects. Used JIRA for monitoring.
  • Built scripts to create missing/incomplete database Indexes improving code performance.
  • Configured Job Agents for Automated nightly & week-end jobs .
  • Implemented Database “tracing” feature to document execution results of Automated jobs.

Environment: & tools: SQL Server 2012/2014, SSMS, T-SQL, JIRA, BitBucket, SourceTree, Confluence, TeamViewer9, MS Office 2013

Confidential, San Francisco, CA

Sr. Data Analyst

Responsibilities:

  • Under supervision of Sr Titus Analyst, provided TITUS database support for the Transplant Department medical staff.
  • Analyzed new Reports requirements and developed SQL ad-hoc reports (all Organs, many Transplant phases, many Medical conditions), trained new users.
  • Executed specials projects: 1) Configured new Zebra labels printers used by the Post Kidney Transplant group with TITUS TrTubes module and Crystal Reports. 2) Updated mapping of the Quest Lab utilization lists interface with Titus test codes nomenclature 3) Developed SQL extracts to manage the USPS Mails and Emails addresses of Confidential listed patients. 4) Did “root cause analysis” investigation to fix missing data from dashboards.
  • Monitored and updated daily Titus user’s access and Kaiser connectivity to HealthConnect

Environment: & tools: SQL Server 2012, T-SQL, Crystal Reports XI, TeleResults TITUS/Presidio, ZEBRA Technologies.

Confidential, Berkeley, CA

SSRS/T-SQL Developer

Responsibilities:

  • Upgraded / Developed a dozen of SSRS reports for the MS Dynamics NAV ERP system; Included complex SQL Queries to DataWarehouse, parameters, visibility, sub-reports, drill-downs, exports to PDF and Excel.

Environment: & tools: SQL Server 2008R2, T-SQL, SSRS, Report Builder 3.0, GoToMeeting.

Confidential, San Ramon, CA

Client Support Technician

Responsibilities:

  • Joined Confidential to address a 6 months old backlog of client’s tickets.
  • Fixed and upgraded SSRS reports, SQL Store procedures
  • Provided fast, updated responses to user’s calls for assistance, rebuilding relationship with Clients of SIMS application.
  • Developed skills with triggers, xml and multi-tasking.

Environment: & tools: SQL Server 2008R2, T-SQL, SSMS, SSRS, Report Builder 3.0, Web Outlook, Vault, SalesForce DESK.com

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

  • Participated in the REFACTORING of 100’s of Store Procedures for the Global E-Commerce development project.
  • Participated in daily Agile/Scrum design meetings.
  • Used JIRA to monitor progress and team-up with QA group.

Environment: & tools: SQL Server 2012, T-SQL, SSMS, Visual Studio 2010, JIRA, Web Outlook

Confidential, San Francisco, CA

SSRS Developer

Responsibilities:

  • Developed SSRS Report for Accounting, using CTMS on-Point Clinical database and Account Payable as sources.
  • Provided database Analysis for Data Sources Integration processes

Environment: & tools: SQL Server 2008 R2, T-SQL, SSMS, SAS, Visual Studio 2008, SSRS, MS Excel 2010, PowerPoint, Web Outlook

Confidential, Foster City, CA

SQL Data Analyst/IT Auditor

Responsibilities:

  • Developed T-SQL Ad-hoc Datasets Analytics for the HealthCare Provider Sunshine Act Compliance Audit.

Environment: & tools: SQL Server 2008 R2, T-SQL, SSMS, MS Excel 2010/ Web Outlook/ EMC Documentum

Confidential, San Francisco, CA

SQL Developer/ QA Analyst

Responsibilities:

  • Developed a SQL module made of several Store Procedures, to PIVOT data coming from SalesForce Surveys file; Use Cursors, DYNAMIC SQL, System Store Procedures and Functions;
  • Process successfully the CALNOC (Collaborative Alliance for Nursing Outcomes) submission for AUG, OCT & DEC 2012 in collaboration with the 2 Nursing Analysts from the Confidential Nursing Process Improvement Team.

Environment: & tools: SQL Server 2008 R2, T-SQL, SSMS, Visual Studio 2008, SSIS, MS Office 2010/Excel/Outlook/PowerPoint

Confidential, San Francisco, CA

SQL Developer/ QA Engineer

Responsibilities:

  • Joined a team of 6 QA Engineers to Audit & Debug hundreds of 2011 HEDIS measures for the Florida BSBC Insurer.
  • Developed SQL scripts, extract and aggregate records from Claims files to QC results generated by Confidential Health proprietary software (HealthSmart Designer & HealthSmart Manager)
  • Used PIVOTAL tracker to monitor progress/results with team members. Participated in bi-weekly AGILE/ SCRUM meetings under product manager leadership.
  • The team was ed the NCQA 2012 HEDIS on March, 10th 2012.

Environment: & tools: SQL Server 2008 R2, SSMS, T-SQL, SAS, PIVOTAL Tracker, Plastics, MS Office / Excel/Outlook 2010

Hire Now