OBJECTIVE

• Detail oriented and innovative professional looking for a challenging role in the Business Intelligence/Data Warehouse realm by leveraging and improving upon my current role and to develop my business intelligence/data warehouse skills and contribute to the company's progress.

SUMMARY

• 8+ years of hands on experience in Business Intelligence, Data Integration and Data Warehousing projects, Information Management and Delivery involving Complete Life Cycle (Requirements Gathering, System Analysis, Design, Implementation, Testing and Migration)
• Extensive experience in Relational Databases (RDBMS) such as Oracle, SQL Server and Traditional OLAP/Relational OLAP databases using Micro Strategy/OBIEE.
• Actively involved in Business and Functional Analysis, Data Modelling, and Source System Analysis, Design, Reporting Architecture, development and implementation of BI Applications.
• Managed complete ETL and monitoring SQL Server Agent Jobs, mapping and extracting data and writing queries.
• Designed Scorecards, Metrics Dashboards, Performance Summary Dashboards, and Dynamic Content Dashboards and best Design practices.
• Provided training to business users and dashboards presentations to higher management.
• Comprehensively worked in creating complex reports (grid, freeform, drilldown, adhoc) and market measure documents using features like Advanced Filters, Metrics, Templates, Prompts, Consolidations and Custom Groups.
• Excellent Communication, Analytical and Problem solving abilities with excellent understanding of system development life cycle and proven project management skills.
• Exposure to Global Delivery Model on managing Onsite/Offshore projects and ability to quickly learn new domain, business and latest technologies.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data - Flow, Process Models and E-R Diagrams.
• Manage Scope: Guard against Scope Creep and also ensuring the sponsor approves the scope-change requests.
• Risk Management: Identify Risks up front, continue to access potential risks throughout the project and resolve issues as quickly as possible.
• Leadership: Develop effective culture-sensing skills, understand the voice of the client and translate the voice into work that creates value.

TECHNICAL SKILLS

BI tools: Micro-Strategy BI Reporting, OBIEE, SAS

DW/ETL Tools: Informatica Power Center, Teradata EDW

EDM: Data Modeling, Erwin, DBA

CRM: SalesForce

MDM: Informatica

Data and Statistical Analytics: Big data, Hadoop, IBM SPSS, text analytics

ECM: SharePoint

Additional Experience: C#, VB.Net, JAVA, Java Script, MS Project, MS Visio, OOP, Design Patterns, UML, HP Service Manager, TIBCO AMX BPM 3.5 and BPMN.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Project Manager

Responsibilities:

• Worked in the role of project manager and architect handling cross functional teams. Create Program Strategy & Roadmaps.
• Involved in scoping of project and suggesting cost effective means of maintaining application or parts of application.
• Preparation of Statement of work and related Service Level Agreement for the suggested projects.
• Responsible for project planning, scope management, resource estimation, metrics definition, change control process, risk management, verification and validation, final project closure and hand off.
• Performed Extraction, Transformation and Loading data into data mart. Created procedures, triggers and views appropriate to business logic.
• Coordinating client groups, Development team to build the Informatica system/data architecture, component interfaces, conceptual process models and data flows. Working with business operations stake holders, analysts, business operations staff, data providers, developers and DBAs to Initiate Data Integration, Governance & Federation processes & policies.
• Designed and prototyped scorecard\dashboard management reporting systems for pre-sales efforts and future corporate vision.
• Liaison between Data Warehouse team, client, and front end systems group. Identified required enhancements, architecture, ETL, and Use Cases\testing.

Confidential, Oldsmar, FL

Business Intelligence/Data Warehouse Consultant/PM

Responsibilities:

• Evaluated enterprise DW architecture feasibility, risk and technologies related to business change (i.e.) assessing, identifying and recommending BI and related business stakeholders' data requirements; BI solution prototyping and development; processes and performance from business and technical standpoints; and the impact of data changes on business and/or IT processes);
• Prioritized, prepared and implemented BI and DW architectural improvements (i.e. developing and recommending alternative DW technical and data management solutions, methodologies, strategies and architectural improvement plans)
• Actively participated in system analysis, system architecture and system development life cycle. Enforced data management processes across the enterprise.
• Played key role to analyze and convert the customer data from legacy system to the new system while minimizing system and customer outages.
• Designed data governance and data quality process for the subject areas including periodic communication plan to the business team.
• Designed and developed data conversion strategies and facilitated data conversion, mapping and cleansing workshops.
• Designed and implemented reporting data sources and complex reports that are used by the business users on a day to day basis.
• Substantially increased application response time by initiating a capacity planning analysis project to research storage trends and make recommendations on when to add storage.
• Mitigated risk factors through careful analysis of statistical data. Anticipated and managed change effectively in rapidly evolving global business environments.
• Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures.
• Scope new projects, interpret business needs, translate technical issues, identify and model data requirements, identifying business rules requirements, and test requirements.
• Analyzed and categorized business requirements and translate into optimized business process flows, business use cases, and activity diagrams with the TIBCO AMX tool.

Confidential, Lakeland, FL

Programmer Analyst (BI/DW Developer)

Responsibilities:

• Extensively worked in various data warehouse and business intelligence projects, complex data integration projects and full life cycle development projects.
• Identified data management gap, cost of data replications, and solution benefits for short and longer terms.
• Delivered data migration code to move retail store data from various legacy systems to new centralized system.
• Coordinated with end users to understand and document business and functional requirements for complex projects, including full software development life cycle, DW/BI/ETL tools and other related technologies.
• Designed and developed data cleansing routines utilizing typical data quality functions involving standardization, transformation, rationalization, linking and matching that leverages knowledge within data, master data and technology management.
• Performed source-target analysis, designed and developed source-target mapping specifications and workflows, and performed end-to-end testing of interfaces.
• Optimized code performance by analyzing indexes, joins and views.
• Standardized the accounting policies that are applied consistently across the enterprise along with its configurable rule engines.
• Designed and developed a data warehouse for the Accounts Receivable and the Point of Sale departments. This included the effort of extracting the data utilizing the Teradata ETL tool “Enterprise Data Warehouse”.
• Created reports against this data warehouse, utilizing the “Micro-Strategy BI” reporting tool. This also included generating real time live reports.
• Subject Matter Expert of the HP/Peregrine ServiceCenter application. This included performing the role of business area coordinator, project lead and lead developer for implementation of HP ServiceCenter 6.2 application.
• Responsibilities include process architecture design, strategic business process modeling and implementation, infrastructure integration, process development, solutions management (definition, planning, development and deployment) and end user mentoring.
• Tailored and customized the HP ServiceCenter application for the Service Desk, Incident Management, and Problem Management and Knowledge Management modules.
• Collaborated with business subject matter experts to identify business requirements and rules to build solutions that solve customer problems and deliver business value.

Confidential, FL

Business Systems Analyst

Responsibilities:

• Identified new business development opportunities for this health care firm; analyzed business processes to identify areas of reducing operating costs and improving efficiencies.
• Involved in the discovery, analysis, implementation and deployment of a number of complex business processes that are being used by the company to engage with their existing and new accounts.
• Applied business modeling frameworks such as Business Process Modeling Notation (BPMN) to solutions.

Confidential, Tampa, FL

Business Systems Analyst

Responsibilities:

• Worked as a liaison between the end users and the development team for the implementation of a in house web based records management application named eRMA Electronics Record Management Application . The project involved a complete redesign of their existing system by converting it into a process based framework by applying the core principles of BPM.
• Implemented numerous business optimization processes and reporting tools that improved efficiency, reduced expenses, labor costs, and maximized profit by automating outdated manual processes.
• Recommended and implemented new technology solutions; and trained clients how to utilize new technology to reach their business goals.