PROFESSIONAL SUMMARY:

• 10+ years Business Analysis with a focus on requirement gathering and reporting for multiple, large data warehouse systems.
• 10+ years of complex SQL programming in conjunction with VBA programming to provide complex proprietary toolsets for inter - business production.
• 5+ years of working with technical teams to migrate, develop and maintain product wellness.
• 12+ product implementations with both software and hardware.
• 5+ years SharePoint experience.
• Expert in Microsoft Excel with the ability to automate using VBA.
• Expert in SQL with ability to write complex script, stored procedures, and create graphical BI solutions (SSRS) using Report Builder, Tableau, and MSBI.

TECHNICAL SKILLS:

Knowledge Base: Veeva Vault, Microsoft Office Suite (Inc- Access and Excel), VBA (macro writing), SQL, SSRS, SSIS, Visio, SharePoint, BOX, Document Management, Technical Document Writing, Test Plan and Test Script Authoring using HP Application Lifecycle Management, Script Execution, Process Documentation, Reporting, Leader/Management, s Report Builder, DQL, AS400

PROFESSIONAL WORK HISTORY:

Business Analyst

Confidential, CA

Responsibilities:

• Redesigned company front end Access database to streamline vessel tracking and cargo storage.
• Joined Access tables using complex SQL Query Script and Excel documentation to provide an agile reporting tool for executive management.
• Created operation reports with basic quick button macros to gather real-time data and identify errors in the database.
• Liaison between departments to ensure operational requirements were followed appropriately while improving processes.
• Led design sessions with end users to streamline previous database structure.
• Worked with Finance and COO to develop a tool that allowed reporting to include missing finance data.
• Evaluated the Port’s proprietary Database solution and formulated a migration plan for ongoing data warehouse development.
• Performed complex analysis and presented results using SQL, MS Access, Excel, and Visual Basic scripts.

Business Analyst

Confidential, Thousand Oaks, CA

Responsibilities:

• Lead team of 6 for QA testing to ensure functionality and effectiveness of the new global Confidential eTMF SaaS multi-tenant system.
• Created and maintained our Requirements Specifications, Data Migration Plan, and Design Specification documents for 2 large high-profile projects.
• Maintained defect analysis, authoring test plans and test scripts, and managed oversight of test script execution using HP Application Lifecycle Management system (ALM).
• Recommended changes and improvements to IS importation process based on technical and business data and validation runs to ensure 100% data quality and integrity.
• Acted as a liaison between IS Confidential Technical Teams and Vendor Management to develop and maintain our web-based cloud solution.
• Managed Biosimilars Life Science data handling from vendor submission.
• Helped create new Biosimilars tool used to handle the complete data importation life cycle from vendor.
• Helped develop ETL programs using Informatica to implement the business requirements.
• Introduced design standards for new importation processes to enhance audit and support capabilities.

IT Analyst

Confidential, Scottsdale, AZ

Responsibilities:

• Worked with Management and Sales team through the entire develop lifecycle to create a set of dashboard tools which improved sales opportunities, processes, and provides measurable sales success.
• Worked with SharePoint developers to create an effective financial system security tracking.
• Worked with BI Architects to gather change management documentation including (process documentation, wireframes/flowcharts, test results, etc.) to define and implement a new cost management solution.
• Worked with BI Architects to automatically create and upload third party data to Table using SSIS, Power BI and Report Builder.
• Created new SQL indexed tables/views to cut processing time.
• Created quick view SSRS reports to help divisional executives handle pertinent sales questions from the field.
• Performed all DBA functions using SQLPlus for SQL type databases.
• Designed databases, stored procedures, reports, and data input interfaces using SQL Server.
• Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts.
• Performed sophisticated ad-hoc or ongoing custom analyses against customer profiles to evaluate business process.

Business Analyst

Confidential, Thousand Oaks, CA

Responsibilities:

• Worked with SharePoint Administrators to develop and maintain master data for data storage division.
• Compiled data for database maintenance, structured data collections, and end user support through the use of relational databases and other reporting tools.
• Provided custom reports to management and clients based on specific requirements relating to access lists and content within Department & Team file shares across the Confidential network.
• Worked with stakeholders, management and implementation partners to gather, manage, and prioritize requirements, raise issues, identify obstacles, and recommend options to ensure success of the IS security project.
• Participated in JAD and RAD workshops.
• Deployed a series of interactive dashboards which provided management with the ability to quickly identify issues within the project and improve business process.

Analyst

Confidential, Westlake Village, CA

Responsibilities:

• Participated in SCRUM workshops as a business liaison for cross-functional teams within the mortgage sector to support multiple project deliverables.
• Created process mapping and system mapping for points of integration under direction of BI architect.
• Created use cases for stakeholders, management and implementation partners to identify, clarify and organize system requirements and ensure success of the mortgage retention program.
• Created graphs showing distribution of customer response times using Tableau
• Performed analysis and presented results using SQL, Excel, and Visual Basic scripts.
• Created a series of Power BI dashboards for management to monitor and maintain employee workloads.
• Developed interactive tool to monitor staff efficiency and help improve business process.

Business Analyst

Confidential, Albuquerque, NM

Responsibilities:

• Worked with BI Architects and executive management to gather system information used to integrate our proprietary CRM solution with existing customer systems.
• Managed programmer team of two to develop and maintain IS product line using MYSQL, PHP, Linux, and asterisks languages.
• Used JAD & RAD workshops to identify, clarify and organize system requirements.
• Coordinated and trained community organizations (911, City Council, and Senior Living Program of Santa Rosa) in the development and implementation of our Senior Assistance Program.
• Compiled and analyzed narrative for customer profiling and sales.
• Developed ETL programs using Informatica to implement the business requirements.
• Audited data to ensure that shipmentswerevalid and delivered correctly, with appropriate pricing
• Verified and analyzedshipment manifeststo ensure thatdeliveries were met andclaimswerevalid
• Investigatedand settled claims by applying technical knowledge and human relations skills to effect fair and prompt disposal of cases .
• Used Exceland ERP/SAP softwareto create a complex cost matrixused to audit shipment cost at Confidential .
• Managed customer care for Highrise building project at Confidential .
• Managed customer care and coordination of services for Highrise building project.
• DevelopedPrimeSkillWebpageusing XML and HTML languages.
• Stay-at-home dad

Financial Analyst/Business Analyst

Confidential, Santa Monica, CA

Responsibilities:

• Approved expenditures for supplies, materials, and human resources, ensuring that materials, labor, and equipment were used efficiently to meet the budget requirements.
• Performed marketing analysis research and presented findings to executives which directly influenced pricing and sales strategy.
• Presented forecasting and strategic planning research to executive management showing pricing, value of products, lines, and services.
• Controlled and analyzed network switch cluster.
• Compiled and analyzed narrative for customer profiling and sales.
• Remotely managed interdepartmental and international teamsof threefor implementation of products.
• CreatedPolicies and Procedures and explainedtheir application within the context of the assigned program field.
• Used Chrystal Reports for CTO to control and analyze network Traffic patterns and conditions.
• Collaborated with in-house programing team of twoto improve analytic software.
• Evaluated the financial aspects of product development, such as budgets, expenditures, research and development appropriations, and return-on-investment and profit-loss projections.
• Managed vendor accountsincluding cost analysis, billing analysis, and product development.
• Compiled and presented system mapping to executive staff.

Financial Analyst/Business Analyst

Confidential, Santa Monica, CA

Responsibilities:

• Used sales forecasting and strategic planning to ensure the sale and profitability of products, lines, and services, analyzing business developments and monitoring market trends.
• Developed all financial analysis documentation including; P&L, EBITDA, budget, and cash flow for the sale of company to the Highpoint conglomerate.
• Controlled and analyzed networkswitch cluster.
• Built complex network tool which help to manage network costs and identify errors in the system uncovering areas for improvement.
• Used Chrystal Reports to compile and analyze narrative for customer profiling and sales.
• Collaborated with in-house programing team of two to improve billing software.
• Coordinatedsales team meetings to improve sales techniquesand product lines.
• Represented executives, committees, and boards of directors to special interest groups and others.
• Compiled and presented system mapping to executive staff.