TECHNICAL SKILLS

Software Applications: Microstrategy 9.4.1/10.2, Some Tableau Desktop, OBIEE 10.1, SAP BusinessObjects, Microsoft Access, Microsoft Excel, PowerPivot, Microsoft Word, Power Point, Project, Visio, Microsoft SQL Server 2005/2008/2012/2014, Oracle, Netezza, MySQL, Aginity Workbench, Quest Toad, Quest Toad Data Modeler, ERwin DataModeler, Atlassian Jira/Confluence, Microsoft SharePoint, Microsoft Visual Studio, MKS Integrity, Some Microsoft SSIS, Some Informatica Powercenter 9.5.1

Programming/Technology: Relational database design., Data Warehouse design (Star - schema and snowflake), T-SQL, PL/SQL, SQL, Some HiveQL, Object-oriented programming and data structure design., Java, PHP, JavaScript, ASP, HTML, DHTML, CSS

PROFESSIONAL EXPERIENCE

Confidential

Data Analytics Manager

Responsibilities:

• Manage team of Business/BI analysts and developers for teh Enterprise Reporting and Analytics team.
• Team responsibilities and accomplishments include:
• Developing interactive executive and operational dashboards on web and mobile platforms
• Leveraging Microstrategy transaction services to create monthly technician performance review application dat allows management to review prior month employee performance metrics, view 12 month trend of these metrics, view employee calendar showing working days and vacation days, and input and save comments on their performance.
• Prior month reviews and comments are also made accessible to management teams.
• Developing automated reports for various departments
• Using data to provide insightful adhoc analysis of enterprise business operations questions
• Work wif IT on Data Mart designs to ensure they support teh analytic needs of teh Technical Operations division of Time Warner Cable.
• Gathering and creating requirements documents, create ETL logic requirements.
• Source Systems analysis and creating source-to-target mapping documents.
• Perform QA testing on BI and data mart changes.
• Coordinate release efforts of code or system changes.
• Training regional users on data mart structure and Microstrategy platform.
• Implemented Agile scrum process for team’s development efforts, and mentored team members on dis new approach to development.
• Demo major dashboard product launches to leadership teams.
• Managed and prioritized product backlog in a product owner role.
• Played scrum master role when needed.
• Assess new BI and analytics tools for team.
• Work wif cross functional teams to design and implement enterprise solutions dat include analytics components.
• Manage personnel resources for teh team.
• Train new team members on business operations, data structures and definitions, and Microstrategy tool when needed.
• Mentor team members on career development.
• Encouraged and promoted environment of both individual and team continuous improvement and evolution, and to embrace changes when new technology is made available to improve business operations.

Confidential

Data/Reporting Analyst

Responsibilities:

• Developed interactive Operational Dashboards for executive management and other applications using visualization tools and Transaction Services wifin Microstrategy.
• Created intelligent cubes and advanced external metrics/filters for other analysts to use.
• Created reports for internal analysts when complexity required teh use of more advanced features of Microstrategy (i.e. use of pass-through SQL using Apply functions).
• Provided ad hoc reports when needed.
• Assisted wif manual legacy Excel/Access-based report preparation when internal resources not available.
• Automated some manual report processes using Microstrategy.
• Trained internal TWC employees on Microstrategy and Data Warehousing concepts and experiences.
• Provided Business Intelligence expertise to internal employees.

Confidential

Lead Business Analyst

Responsibilities:

• Documented Data Warehouse project scope and approach documents.
• Performed source systems and data analysis.
• Collaborated wif Systems and Data Architects in assessing Business Intelligence and data virtualization tools.
• Created logical and physical data models to integrate financial/sales planning, POS, invoicing, and product master data from Home Entertainment division into Enterprise Data Warehouse to support domestic and international operations.
• Created EDW source-to-target mapping and report requirements documents.
• Interviewed business units and created business process flow charts.
• Worked wif BI architects and report developers to ensure EDW physical design (Netezza) was compatible wif Microstrategy architectures and met reporting requirements.
• Worked wif application team to incorporate application changes into EDW.
• Worked wif ETL developers in designing and validating transformation logic.
• Model testing, data validation and ETL testing.
• Trained others in EDW design and usage.
• OBIEE/Business Objects to Microstrategy report and Universe/metadata conversions.
• Debug data and reporting issues.

Confidential

Business Intelligence Analyst Lead

Responsibilities:

• Provide sales/financial/strategic analytics support to internal executive management and marketing/vendor management/ Business development/Accounting/Legal departments, to give insight into trends wifin teh online distressed real estate marketplace provided to teh mortgage servicing industry.
• Collaborated wif business/product development departments and various client account managers to consolidate customized business and system workflows specific to each of 150+ clients, for teh purposes of defining industry-wide KPIs.
• Collaborated wif internal departments to define company-wide KPIs.
• Collaborate wif and provided business perspective to Data Architect and ETL developers in Data Warehouse design sessions to ensure effective data models dat meet current and future analytics requirements.
• Define BI department roles/responsibilities, forecast needed staff levels, led recruitment efforts, and train new recruits.
• Discussed wif VP and Director of BI in developing department goals, strategic roadmaps, and product revenue models.
• Manage and allocate team resources in execution of projects.
• Provide mentoring support to team members.
• Oversaw Microstrategy platform build out.
• Used various source system, workflow, and functional decomposition analysis techniques (including SSIS, SQL, and ColdFusion source code debugging) to uncover Data Warehouse, ODS, and client reporting requirements, as well as to provide data mappings and ETL logic for internal/external ETL/report developers.
• Logical and physical data modeling.
• Data cleansing logic and strategy.
• BI/reporting/data consultation for external clients.
• Gathered ODS/Reporting request requirements from internal/external clients, and provided estimated LOE/ETA and technical specifications.
• Provide ADHOC reports to internal/external clients on request.
• Created and maintained source-to-target data mapping, ERD, and other technical documentation, and distributed to both internal and external customers on request.
• Provide ODS/OLTP training to team members, other internal employees, and external clients.
• Provide other internal and external ODS support on demand.
• Provided data extracts/reports from MS Great Plains database and worked wif Accounting department to resolve any GL entry/invoicing reconciling issues.
• Develop/modify SSIS packages, stored procedures, and table views used in ETL process.
• Research data issues found wifin Microstrategy, Data Warehouse, ODS, and/or ETL process.
• Support other existing reporting products and oversee global enhancements for workstation Ad Hoc reporting component, dashboard reporting, and customized data transfer files.

Confidential

Business Analyst

Responsibilities:

• Provided functional Business Analysis support to hazard insurance division of service outsourcing provider to teh mortgage industry.
• Gathered and documented requirements for systems and process changes through interviews wif business units.
• Collaborated wif developers in performing source systems analysis to determine scope and feasibility of change requests.
• Coordinated wif multiple development teams when change requests impact multiple systems.
• Performed QA and UAT and assisted wif systems design to ensure functionality.
• Coordinated wif developers and network administrators in setting up testing environments when changes affect multiple systems. Prior to testing, ensured dat software versions of all systems reflect versions dat will be in production after release date.
• Coordinated wif development teams to ensure migration of systems changes occur on teh same release date if multiple changes are co-dependant.
• Trained business units affected by business or insurance tracking systems changes.
• Used tools such as BusinessObjects XI, MS Access, MS Excel, and MS SQL Server Management Studio to perform data analysis and research, and to validate data integrity.
• Performed source system analysis and data validation for newly released data warehouse.
• Trained team members on teh design and use of teh data warehouse.
• Performed detailed analysis on ADHOC and automated reports requests.
• Assisted financial analysis department in how to use teh data warehouse for monthly and AD HOC reports.
• Researched and analyzed system and manual processes, and prepared written recommendations for changes and/or improvements.
• Documented procedures for newly designed processes or systems.
• Provided product support to business units.

Confidential

Business Analyst

Responsibilities:

• Performed marketing, sales, and operations analysis using Business Objects, TOAD SQL Client, Microsoft Excel, and Microsoft Access.
• Provided daily, weekly, and monthly sales and operations reports to executive management and various department managers.
• Provided strategic ADHOC reports to executive management.
• Assisted finance department and treasury department in preparing monthly forecasts.
• Used ERwin DataModeler and Microsoft Excel to create Dimensional Data Models dat reflect teh loan origination business process and allows for measurement of Key Performance Indicators.
• Trained Reporting Analysts and Data Miners in business processes, information technology processes, analysis tools, and using Enterprise Data Warehouse system.
• Alerted project managers to potential risks and issues of importance.
• Gathered requirements through interviews wif business owners and end users, workshops, and existing system documentation/procedures.
• Analyzed preliminary business and information technology processes and prepared groundwork for Enterprise Data Warehouse.
• Performed source systems analysis and created data mapping documentation.
• Provided data ETL logic to Enterprise Data Warehouse developers.
• Performed UAT before any Data Warehouse changes are released into production.
• Used industry standard analysis techniques to uncover client requirements such as data flow modeling, use-case analysis, workflow analysis, functional decomposition analysis, and object modeling.
• Performed periodic audits of data and report efficacy to ensure modifications of business processes are accurately reflected in Business Intelligence and Enterprise Data Warehouse system.
• Delegated workflow to other Reporting Analysts and led projects to completion.