TECHNICAL SKILLS:

Skills: Excel, PowerPoint, Word, Outlook, Lotus Notes, Crystal Reports, Visio, Toad

Tools: MicroStrategy 7.i/7.5/8.X/9.X/10.X, Business Objects XI, SAS Enterprise Module, Easytrieve Mainframe, Narrowcast distribution server, (OBIE) Oracle Business Intelligence Enterprise 10g, Tableau,Eloqua, DemandTools, Salesforce BMC Remedy ARS, Pier I

Databases: Access 2000/2003/2007/2010, SQL Server 2008/2012/2014, Oracle 10g

PROFESSIONAL EXPERIENCE:

Confidential, Tampa

Microstrategy Administrator

Responsibilities:

• Provide design, development, configuration and maintenance of tasks related to the development of the application and provide training to application end users.
• Support project teams and domain architects to improve development reliability and testing of Microstrategy.
• Partner with business groups to gather, refine and document requirements for Global Business Framework and Enterprise Data Warehouse
• Query, analyze and profile data from source to target to assess data integrity and identify gaps in the data to adequately and accurately meet reporting analytics needs
• Design, develop, test and deploy business intelligence solutions on the Microstrategy platform
• Consistently create insightful reports that effectively synthesize and interpret data to present an accurate and clearly communicated story for business deliverables.
• Understand complex business challenges & translate them into requirements/solutions
• Practice data governance principals by keeping consistent data dictionaries, sematic abstraction layers, metadata, business rule definitions and reporting catalogs
• Ensure data auditing and quality controls are established to ensure data accuracy and integrity
• Perform system administration tasks including change management and production support of the business intelligence infrastructure, data repositories and reporting content
• Manage application installations and software upgrades, secure model design, troubleshoot application and database connectivity along with load testing
• Manage configuration and version control of the production systems; maintain procedures while monitoring fault corrections
• Maintain application scripts and documentation related to software updates
• Ensure timely resolution of production issues while analyzing the root cause.
• Work with cross functional teams to coordinate unit, integration, data validation and user acceptance testing, then prioritize and tack defects to resolution

Senior Systems Analyst

Responsibilities:

• Lead adhoc reporting with various big data tools like Microsoft SQL Server/Business Objects to track corporate inventory and monitor contracted SLAs.
• Lead meetings between cross functional Project Management teams and Business SME’s/executives to develop and implement viable profit minded solutions.
• Leverages advanced technical skills, along with critical thinking and problem solving strategies, to analyze data and provide insights to help steer business decisions.
• Prepared detail and summary level reports including written interpretation of analytic results, data - business recommendations and alternatives to management

Sr. Business Analyst

Responsibilities:

• Gathered business requirements and technical requirements
• Wrote formal documentation such as BRD’s
• Prepared detail and summary level reports including written interpretation of analytic results, data-business recommendations and alternatives to management

Senior Business Process Analyst

Responsibilities:

• Lead adhoc reporting with various big data tools like Microsoft SQL Server to conduct data analysis for Health Care Commissions team.
• Lead the development of a new data universe to assist in tracking Member data, Sales trends and Commissions payouts.
• Analyzed trends to recommend process and/or operational improvements.
• Prepared detail and summary level reports including written interpretation of analytic results, data-business recommendations and alternatives to management
• Evaluated financial impact of implemented initiatives
• Developed VBA programs to validate imported and exported data to and from external data sources
• Developed various Excel and Word templates using VBA, Macros for the Sales communication letters

Senior Analytics Manager

Responsibilities:

• Focused on assessing the consumer ecommerce experience platform
• Worked directly with stakeholders to identify gaps in the online business model and business reporting needs
• Analyzed value chain against current and future marketplace to define new strategic direction and realign all enterprise ecommerce activities
• Required the use of SQL data mining tools to perform deep dive analytics to resolve issues in data quality
• Created and Maintained statistic profiles for both public and internal web sites
• Created and analyzed detailed statistic profiles for internal and external clients
• Worked with both internal teams and external contractors to implement and tag websites to ensure the measurability for the web site

Senior Business Systems Analyst/ MicroStrategy Developer

Responsibilities:

• Applied a data driven approach to define the data requirements for financial, sales and commercial market analytics solutions
• Gathered business requirements for a high visibility Revenue Data Warehouse design to support multiple lines of business
• Worked closely with development team in facilitating JAD sessions and requirements-review meetings with multiple stakeholders, representing multiple operational and business groups within Confidential
• Lead cross-functional teams to analyze the operational impacts and opportunities for technology changes industry-wide
• Wrote requirements and test plans for specialized customer facing projects
• These projects were designed to meet customer requirements and bring product usage online
• Subject matter expert in content management technology, influencing senior level decisions by using innovative solutions allowing for real-time delivery of industry trends according to market segment
• Perform required internal audits, providing recommendations for process improvement and updates of the BI environments
• Developed excel templates for reporting daily revenue data for department leadership meetings
• 8 years experience working with MicroStrategy desktop creating application objects like reports, compound metrics, filters, prompts for complex reports with Oracle Revenue DW as a backend
• 8 years experience working in a MicroStrategy 9.1.1 environment as an administrator of (Desktop client, Web client and Narrowcast Server)
• 8 years experience creating schema objects and public objects
• Consistently evaluated the existing MicroStrategy reports and analyzed their freeform SQL to understand the reporting requirement
• Enterprise wide primary point of contact for MicroStrategy reporting recommendations
• Expert at massaging & analyzing data using MS Excel VBA, MS Access, Pivot Tables and Charts

MicroStrategy Lead/Lead Analyst

Responsibilities:

• Managed all aspects of business analysis throughout the finance and accounting department acting as a liaison between the business and the technology teams to help analyze and drive solutions
• Instrumental in improving the online billing system's monthly reporting process and dashboard needs through the use of existing finance and accounting tools like MicroStrategy
• Managed and Architected the MicroStrategy Projects which involved creating the Attributes, Facts, and Hierarchies
• Trained user groups on new processes and restructuring reporting processes
• Lead the creation of MicroStrategy dimensional models based on business requirements
• Lead the analysis, design, and construction of the MicroStrategy metadata
• Created schema objects like attributes, facts, hierarchies and public objects like metrics, prompts and custom groups
• Converted existing manual prompted reports to automated non-prompted reports using Narrowcast Server
• Worked extensively on Narrowcast creating the Publications, Information Objects and Services
• Scheduled reports, reports services documents and dashing boarding using Schedule Manager
• Created Users, Designed role level security, and Managed privileges in the MicroStrategy Environment using the Administrator
• Achieved substantial cost savings by minimizing required man hours needed to deliver monthly reports
• Scoped user community requirements and briefed IT delivery managers and offshore development leads on requirements approach and progress for each initiative
• Developed Excel templates using VBA/Macros to balance and validate enterprise ETL reporting tools
• Designed, Coded, Tested and Debugged programs in Cobol/JCL language
• Enhanced business system functionality using COBOL/JCL language

Database Client Support Specialist

Responsibilities:

• Acted as the primary contact for clients, which included working with application specialist to address customer issues
• Supported the Data Repository product installations, customer SQL server databases and maintained the flow of information between the two
• Coordinated and delivered current product releases to customers
• Provided customer education and training sessions