SUMMARY:

Business / Technology Analyst with 17+ years’ experience creating and maintaining end to end Enterprise IT/AI/BI Solutions for sectors: Medical/HealthCare, Hedge Fund, Private Equity, Real Assets, Business Accounting, Finance, Marketing, Media/Entertainment, Technology, Education and Government.

CORE COMPETENCIES:

• Automation /Robot Framework Tableau Micro Strategy Reporting Data Visualization Presentations UAT/ QA Data Analysis
• Business Process Re - Engineering Strategic Planning Vendor Management Meeting Facilitator Project/Program Management
• Data Analysis Budgeting Data-Driven Insights Big Data / AI / BI /Data Science Data Modeling Word Excel VISIO KPIs
• AGILE/SCRUM WATERFALL

PROFESSIONAL EXPERIENCE:

Sr. Business systems analyst

Confidential

Responsibilities:

• Developed, oversaw and managed User Stories / requirements and functional specifications for Agile projects.
• Partnered with cross-functional BSAs and executive team members to develop and administer Regression and Integration Testing, User Acceptance Test (UAT), and Selenium / Robot Framework Automated test scripts.
• Provided guidance/direction as appropriate to technical delivery teams for deployments, tool testing, and sign offs.
• Audited data to ensure data integrity.
• Created KPIs to measure success.
• Configured and troubleshoot Riversand’s MDM (Master Data Management) Application to maintain data governance.
• Created business artifacts as needed: business cases, requirements, wire frames, user stories, use cases, test cases, product backlog, project budgets, capital requests, forecasts, workflow diagrams, training documents, Excel, Word, Power Point, Audit and status reports.
• Worked with Product Owners and Technical Members to create prototypes, using analytical and data science tools to explain complex ideas and requests (SQL, T/SQL, PL/SQL, Tableau, Python, Excel, VBA, Macros, Access, JIRA, Confluence).

Sr. Business systems analyst

Confidential

Responsibilities:

• Collaborated with onshore and offshore Accounting and Finance executive stakeholders and business users to understand business processes, goals and gaps to enhance their Financial Analytics and Sales/Royalty Reporting Systems.
• Identified financial analytic solutions that helped Accounting/Finance analyst be more efficient and produce more accurate reports.
• Developed, oversaw and managed requirements and functional enhancement specifications for Agile projects.
• Worked between remote development teams, internal IT and business users to ensure requirements were being met
• Partnered with other BSAs and the QA Team managed by the Testing Center of Excellence (TCOE) to develop and administer Integration Test and User Acceptance Test (UAT) approach, scripts and plans for software validation and acceptance.
• Provided guidance/direction as appropriate to technical delivery teams for deployments, tool testing, and sign offs.
• Partnered with stakeholders and team members in monthly, quarterly, and yearly financial cycles (forecasting, reporting)
• Audited data to ensure data integrity
• Supported MDM efforts (Master Data Management)
• Created business artifacts as needed: business cases, requirements, wire frames, user stories, use cases, test cases, project budgets, capital requests, forecasts, workflow diagrams, training documents, Excel, Word, Power Point, Audit and status reports.
• Worked with process owners to resolve any data issues by creating prototypes and using analytical and data science tools (SQL,T/SQL, PL/SQL, MicroStrategy 9/10, Tableau,SAP,SSIS, Informatica)

sr. Business analyst

Confidential

Responsibilities:

• Liaison between the marketing and technology departments (on-shore / off-shore) for Marketing and Promotion Analytics Reporting System projects: Hortonworks Hadoop (Big Data), Business Intelligence/Analytics, Data Warehouse, Master Data Management, Micro Strategy, Tableau, TeraData, Qlikview, and Omniture projects.
• Assisted project managers as a backup project manager and as the voice of the business for process re-engineering projects 15+ million
• Facilitated meetings with 10 stakeholders and cross-functional team members to get agreements on 30 business cases
• Evaluated new development requests by meeting with stakeholders and using industry standard templates to ask the right questions to help avoid unnecessary projects/risk assessments
• Performed quantitative analysis to provide insights and actionable recommendations to marketing stakeholders
• Supported MDM efforts (Master Data Management)
• Created business artifacts as needed: business cases, requirements, wire frames, user stories, use cases, test cases, project budgets, capital requests, forecasts, workflow diagrams, training documents, Excel, Word, Power Point, Audit and status reports.
• Analyzed complex queries and wrote T/SQL and PL/SQL queries to research data patterns discrepancies found by the business
• Participated in nationally broadcasted training videos for AT&T University/Samsung explaining current trends in entertainment technology.

SR. Business analyst

Confidential

Responsibilities:

• Liaison between the City Manager’s Office and technology department to discuss roadmaps for Tableau / Azure Cloud Based Data Science/Business Intelligence projects using Microsoft’s (MS SQL,T/SQL, PL/SQL SSIS, SSRS, SSAS, SharePoint)
• Analyzed current business processes from each of the city’s departments to identify which processes can be re-engineered with technology and to benchmark improvement performance.
• Evaluated city department’s reports to the City Manager’s to create data mapping documentation.
• Gathered business requirements from business stakeholders and internal customers to create High-Level Documentation: Workflow Diagrams, Visio Diagrams, Excel Documents, and Word Documents

sr. Business analyst

Confidential

Responsibilities:

• Liaison between the business and technology departments for Financial Analytics and Sales Reporting Systems Scrum Big Data/ Data Analytics and business re-engineering projects.
• Led project meetings, proposed new solutions and implemented new workflows to maximize productivity
• Utilized data analyst techniques to cleanse and find data patterns for ad-hoc Micro-Strategy and SSRS reports.
• Participated in the evaluation, redesign, and modification of existing SSIS logic to support change, improve system performance and for master data management
• Created and modified complex algorithms using T/SQL and PL/SQL Queries, stored Procedures, and Architected ETL solutions using SSIS
• Created functional documents and Visio diagrams to translate business requirements into project documentation.
• Supported MDM efforts (Master Data Management)
• Hands-on software development utilizing Microsoft BI suite/SQL Data Tools: C#, .NET, Java, SQL Server, Oracle, NETEZZA, Teradata, SSIS, SSAS, web services, Visual Studio 2012-2104, Agile Project Management: Scrum, Jira, and SVN

IT Director

Confidential

Responsibilities:

• Liaison between the business and outsourced technology departments for Financial Analytics and Sales Reporting Systems projects (Agile / Waterfall based software development projects iOS, Android, BI, Data Analytics, Data Warehouse, Big Data, Hadoop, Qlikview, Tableau, SSRS, SSAS, AWS, Azure)
• Managed remote contractors using SCRUM
• Business artifacts: business cases, requirements documents, wire frames, user stories, use cases, test cases, project estimates (budgets), capital requests, forecasts workflow diagrams, training media, Excel, Word, UAT/QA, and status reports.
• Facilitated small to large sized meetings with cross-functional team members and other contributors.
• Created complex SQL queries, built Data Warehouses, built Business Intelligence/ Data Science systems
• Hands-on development utilizing MS BI suite/SQL Data Tools: C#, .NET, Java, SQL Server,T/SQL, PL/SQL, Oracle, SSIS, web services, Visual Studio, Agile Project Management, Tableau, SDLC, Azure, Amazon AWS
• Worked concurrently with the job below.

Business analyst

Confidential

Responsibilities:

• Led senior-level meetings to discuss current business processes to re-engineer business processes for financial data reconciliation projects
• Created and translated business requirements into functional documents, web application and report specifications
• Project management of an Accounting Business Intelligence System using Microsoft Business Intelligence Development Studio 2010, Visual Studio 2010, SQL Server 2008 R2, T/SQL, PL/SQL,SSIS, SSRS, C#, asp.net 4.0, Telerik Controls, and Agile PM
• Designed data cleansing and ETL solutions using SAP BW and Entertainment Partners and Cast and Crew financial data
• Modified SAP BW excel reports and queries
• Utilized data scientist techniques to find data patterns for adhoc reports (SharePoint 2010 compatible)
• Created algorithms using SQL Queries, stored Procedures, and SSIS packages
• Designed the application for tablets, mobile platforms, Windows, Mac, and Linux Operating Systems
• Led project meetings, trained new staff on the system, created project and application drafts, managed and delegated tasks, and recommended changes as required
• Developed an efficient and repeatable process for reconciling and comparing SAP BW and 3rd Party Accounting Systems financial data

IT business analyst

Confidential

Responsibilities:

• Created and translated business requirements into functional documents and web applications
• Developed a Business Intelligence System using Visual Studio 2010, Microsoft SQL Server, T/SQL, SSIS, SSRS, C#, asp.net 4.0, Telerik Controls, Agile Project Management
• Designed and developed data cleansing and ETL solutions to transform data from multiple sources into raw data
• Created algorithms/workflows using SQL Queries, Stored Procedures, and SSIS packages to automate the ETL process
• Led meetings and presentations for the project, trained staff on the new system, created all project documentation and successfully completed project as anticipated

IT business analyst

Confidential

Responsibilities:

• Prepared financial reports and prepared budgets to assist senior staff in making sound business decisions with telephony and technology services.
• Formatted vendor supplied spreadsheets to translate data into applicable information
• Re-engineered business processes to implement a Data Analytics/Business Intelligence System to track usage trends for telephony reports
• Created algorithms using T-SQL Queries, Stored Procedures, SSIS packages, SharePoint and Access databases
• Reconciled invoices and approved reimbursement requests

IT Support Analyst

Confidential

Responsibilities:

• Provided data analytics and database support to high-level accounts such as Pepsi Bottling Group and Premier Beverage
• Efficiently implemented new analytic reports and application/database enhancements
• Assisted clients with Access, SQL, and Oracle databases upgrades and maintenance
• Modified the corporate ticketing system for HIPPA compliance using T/SQL, PL/SQL and Visual Basic
• Worked concurrently with the job below.

IT Business Analyst

Confidential

Responsibilities:

• Analyzed technology needs, built the computers and server infrastructure for an MS Access based medical application.
• Built workstations and servers to automate office processes
• Budgeted, designed, managed and networked office to support Medical Mastermind
• Created custom batch files to backup data and upgrade Medical Mastermind databases