Business Analyst II Resume

SUMMARY:

Business Analyst with experience in banking, biotech, healthcare and non - profit management. Extensive work in database analysis and development, regulatory reporting, business requirement gathering, and data integration. Expert in SQL; Proficient in VBA, Python, HTML, Javascript, XML, Linux. Extensive use of databases and platforms such as MS SQL Server, Oracle SQL Developer, Tableau, QlikView, SAS, Cognos, Informatica, Visio, Oracle CRM, and Salesforce. Tri-lingual English, Spanish, and French

PROFESSIONAL EXPERIENCE:

Business Analyst II

TuftsHealth Plan, Watertown, MA

Manage and supervise data integration issues between legacy databases and new platforms during user acceptance testing (UAT) for system implementation; Liaise with IT and business users in streamlining the SDLC in both Agile and Waterfall environments
Gather requirements from Compliance to design complex SQL scripts to compile information and meet data governance guidelines provided by the Centers for Medicare & Medicaid Services (CMS) for the federal government’s Data Validation Audit
Compose, review, and edit departmental business requirements and corresponding codes imbedded in business systems, identifying and correcting the source of integration issues; Draft SOP’s to streamline technical and operational processes
Create custom reports by blending data in Tableau, Oracle CRM, Cognos, and MS SQL Server to provide actionable intelligence to stakeholders in Sales, Marketing, Compliance, and Product Development; Enabling sales to grow the member base by 5% and generate the highest fiscal year revenue in company history
QA and QC check applications utilized by end users in Sales, Marketing, Compliance, and Product Management; Create exception reports to pinpoint breaks in data flows and enable complex integrations between core systems

Confidential

Business Analyst

Aggregated data on patients filling prescriptions for off label use through company patient assistance, mitigating regulatory risk; Developed advanced SQL queries to create unique group lists to ensure that Sanofi remained FDA compliant
Using Tableau and QlikView, built and implemented custom reports and list pulls for business users in Sales and Marketing, resulting in the automation and offloading of several reporting tasks
Developed models to track YOY retention of prescribers for Sanofi medications, allowing regional business directors to increase margins and collectively exceed revenue targets by $200 million; Calculated ROI for Sales and Marketing units to assist with the ongoing restructuring of the company
Discovered over $25 million in sales and access opportunities by researching yearly regional sales statistics and developing internal SQL databases, identifying critically under-utilized territories along with units and prescribers that had not been retained

Operations Analyst

Confidential

Gathered AML and KYC requirements from Legal and Compliance in order to spearhead the development of the GS Mexico Broker Dealer; Opened and migrated over 400 fixed income and equity accounts with over $1.5 billion total assets under management
Initiated and completed project plans for major client account creation and migration and documented relevant Dodd-Frank and FATCA guidelines for Sales & Trading; Reviewed legal documents (including ISDAs) to ensure compliance with client due diligence requirements
Provided detailed reports on progress of Confidential trade account opening to Managing Directors in Sales & Trading, Operations, and Legal; Prioritized client onboarding projects in accordance with the business needs of the firm
Managed, updated, and tracked client account information warehoused within internal databases; Reported activity to Sales & Trading, Compliance, and Legal; Escalated issues to Managing Directors when exceptions were required for account opening

Business Development Manager

Confidential

Created, tuned, and deployed SQL queries for reporting to accounts payable and receivable, resulting in the streamlining of billing and purchase order processing
Developed Excel VBA scripts to automate ETL tasks for end of year financial reporting
Forecasted budgets across all departments to meet yearly financial goals set by the association, resulting in over 20% reduction of the branch deficit in FY 2013

SKILL:

Applications: MS SQL Server, Oracle SQL Developer, Tableau, QlikView, SAS, Cognos, Informatica, Visio, Oracle CRM, Salesforce

Programming Languages: SQL, VBA, Python, HTML, Javascript, XML, Linux

Languages: Fluent in English, Spanish, and French