We provide IT Staff Augmentation Services!

Business Intelligence Manager Resume

New, YorK

SUMMARY

  • Result oriented leader with 14 years of track record of delivering solutions that strengthen core business competencies.
  • Rich experience with formulating and interpreting business strategy into enterprise data requirements and implementations.
  • Design enterprise business intelligence end - to-end from technical aspect to user adoption and change process.
  • Strong data, process and business modeling skills.
  • Led enterprise data integration projects, envision business solution, formulate and implement enterprise data architecture and strategy.
  • Developed corporate policies and Business Intelligence governance policies to address information ownership, enrichment, security, quality and management across the enterprise.
  • Develop data warehouses, marts and solve highly complex data issues by applying data warehousing best-practices as well as “out-of-the-box” thinking. Diverse work experience across three continents including Europe, Asia and North America.
  • Experienced with managing onsite & offshore teams.
  • Experienced in cross-domain, cross-functional and cross-department projects.
  • Develops and executes a solution strategy around complex business issues.
  • Outlined solution architecture descriptions, monitored and governed their implementation.
  • Provides coaching and directional leadership to resources.
  • Act as a key liaison between business partners, applications support, operations, and executive management to devise business strategy.
  • Led & designed business solutions for the company’s Salesforce application to deliver global capabilities for the sales, marketing, and finance.
  • Great presentation skills, people management, communication skills, analyzing ability, strong work ethics, problem solving ability and capability to manage deliveries within tight timelines.
  • Dynamic and enthusiastic to accept challenges at work.
  • Thorough knowledge of Order to Cash process.
  • Worked in core team of organization for order to cash implementation.
  • Performed SWOT analysis to research potential BI solution, and improve performance.
  • Familiarity with gap analysis, and risk mitigation strategy.
  • Expert in creating & presenting project charter.
  • Good with documenting project scope, business requirements (BRD), use case/functional specifications (FSD), statement of work (SOW), project deliverables, acceptance criteria, work breakdown structure (WBS), Gantt chart.
  • Expertise in SDLC methodologies, waterfall, spiral, agile model of development.
  • Worked extensively on predictive analytics, converting raw data into actionable information.
  • As expert in Data Warehousing Technologies, having rich experience in Installation, Design, Development, Deployment of Business Objects, Informatica, & Oracle solutions.
  • Designed data architecture, data model, data governance rules. Expert in BO universe/report design, webi, Looker, Confidential, and Informatica design.
  • Excellent knowledge and experience in BO data integrator and Oracle Hyperion essbase smart-view, and oracle business intelligence. Sound knowledge of salesforce.com, OBI, Tableau, Python, PL/SQL, Infoburst. Rich experience in migrating scripts from UNIX to Windows.
  • Working knowledge of Hadoop framework.
  • Well versed with the concept of map reduce, sqoop, Pig, Hive, HBase, and Oozie scheduler.
  • Thorough knowledge of HDFS architecture, and concept of mapper, reducer, combiner and practitioner.
  • Good understanding of income statement, cash flow statement, balance sheet, liquidity/solvency/profitability ratios, importance of working capital, collection period, payable and receivable cycles, chart of accounts, general ledger.
  • Good understanding of activity based Vs traditional costing approaches.

TECHNICAL SKILLS

Technologies: Business Objects Webi, Confidential, Looker, Tableau, Python, Salesforce Analytics, Oracle Hyperion Essbase, Oracle Business Intelligence(OBI), Confidential, Informatica Power Center, BO Data Services, Xcelsius, JIRA, Oracle, PL/SQL, SAP BW, Visual Basic, Core Java, Unix Shell Scripts, DOS

BI Analytics: BO Webi, Confidential, Salesforce Analytics, Hyperion/Essbase, OBI, Looker

Data Modeling: Star Schema, Snowflake Schema, DFD, ERD

PROFESSIONAL EXPERIENCE

Confidential, New York

Business Intelligence Manager

Responsibilities:

  • Working as Business Intelligence Manager.
  • Working closely with different operations departments to improve global reporting/analytics, systems/processes.
  • Serving on distinct, cross-company advisory teams tasked with forming implementation plans, & executing final decisions regarding key competitive/strategicbusinessinitiatives.
  • Support sales, community, and executive level corporate analytics and dashboards.
  • Set up common taxonomy to align business definitions across different departments.
  • Extensively using JIRA to request management and prioritizing workload.
  • Managing budget and negotiate pricing structure with offshore vendors and software providers.
  • Working on standardization of business model and business entities.
  • Built the dimensional model, and implemented the data warehouse from scratch.
  • Responsible for managing offshore development teams. Organizes, plans, & directs activities of a technical staff.
  • Developing business oriented Confidential dashboards and analytics in business intelligence tool.
  • Performance tuning of dashboards and analytics.
  • Wears multiple hats of business analyst, data analyst, business intelligence manager, and data warehouse expert.
  • Responsible for designing & developing highly complex warehouse to enhance business reporting/analytical services.
  • Imparting training to Business User on Business Intelligence tools and technologies.
  • Transformed business rules to technical specs for ETL process. Writing/modifying SQL queries, PL/SQL procedures.

Environment: Confidential, Looker, Tableau, Confidential, Python, Salesforce, JIRA, Redshift, Postico.

Confidential, New York

Business Intelligence Lead

Responsibilities:

  • Worked as Business Intelligence Lead in Confidential Group.
  • Led a team of business intelligence specialist, salesforce developer, and database expert.
  • Rolled out & integrated BI solution for sales, sales operations, marketing, research, finance, billing and client services.
  • Served on distinct, cross-company advisory teams tasked with forming implementation plans and executing final decisions regarding key competitive/strategicbusinessinitiatives.
  • Led business solutions architect for the company Salesforce application with the goal of accelerating the ability to deliver global capabilities for the Sales, Marketing, and Finance.
  • Implemented new technologies / methodologies within home-grown applications/tools to ensure that all business units had feature-rich, easy-to-use software from a single source.
  • Did oversee completion of business intelligence projects. Ensured completion of projects in a timely fashion.
  • Build the dimensional model, and implemented the data warehouse from scratch.
  • Managed Salesforce reports and dashboards. Extensively used JIRA to manage and prioritize., workload.
  • Evaluated and selected vendors to acquire new business intelligence tools. Negotiated with vendors.
  • Evaluated the performance of subordinates in formal review. Trained employees in the performance of their duties
  • Wore multiple hats of business analysts, data analyst, system analysts, application/system designer
  • Ensured compliance with all operational policies and procedures.
  • Designed Business Objects Architecture, infrastructure, and development of the BO Universe.
  • Designed and created centralized access control security architecture.
  • Created Xcelsius dashboards. Analyzed existing ETL jobs, workflows, data flows for specific tuning opportunities
  • Imparted training to Business User on Business Intelligence tools and technologies.
  • Created Logical and Physical models for staging, Transition and production warehouse.
  • Extensively used ETL tool Informatica & BO Data Integrator for extracting and loading into different databases.
  • Wrote/modified SQL queries, PL/SQL procedures.

Environment: Business Objects Webi, Salesforce, Oracle Hyperion, Essbase, Oracle Business Intelligence (OBI), Informatica 9, BO Data Integrator, JIRA, SQL Server, Windows.

Confidential, Boston

Manager/ Business Objects Architect

Responsibilities:

  • Worked as a Manager/ Lead Universe Designer.
  • Developed project timelines for the release/deployments. Generated project status reports for all stakeholders.
  • Managed business intelligence systems failures minimize down time.
  • Interfaced with stakeholders determine their needs. Provided guidance & directional leadership to resources.
  • Deployed multiple reporting applications to create business advantage.
  • Set up event based scheduling in Web Intelligence for production reports.
  • Did overseeing the Quality procedures related to the project.
  • Created Logical and Physical models for staging, Transition and production warehouse.
  • Created mappings for loading from Source to Load Layer and from Load Layer to Integration Layer (targets).
  • Extensively used ETL tool for extracting, transforming and loading into different databases.
  • Writing/modifying SQL queries, PL/SQL procedures.

Environment: Business Objects XI R2 SP4, Webi, SQL Server 2005, Windows 2003.

Confidential

ETL Manager/ Data Analyst

Responsibilities:

  • Worked as a ETL Manager/Data Analyst. Analyzed the source system data across various platforms in different source systems.
  • Analyzed business requirements and worked closely with the various application teams and business teams.
  • Created Logical and Physical models for staging, Transition and production warehouse. Involved in designing the procedures for getting the data from all systems to Data Warehouse.
  • Analyzed anomalies, dependency and relationship across different tables.
  • Developed incremental strategy to extract data from various data sources like Oracle, DB2, flat files.
  • Configured BO data integrator job server to run jobs. Created and configured BODI repository in DB2.
  • Involved in Optimizing and Performance tuning on targets/sources/ dataflows.

Environment: Business Objects Data Integrator (BODI) 11.7, Oracle 10g, DB2, TOAD 8.5, Windows 2003.

Confidential

Informatica Consultant

Responsibilities:

  • Analyzed business requirements and worked closely with the various application teams and business teams.
  • Implemented security features on different domain folders by giving appropriate privileges.
  • Creating s;hared, global folders along with user privileges based on role of each player in the project. Used various data Sources like Flat Files, Relational Tables.
  • Involved in Optimizing and Performance tuning mappings & sessions.
  • Scheduling of workflows using ETL tools.
  • Supporting and Handling the issues in Production Environment.
  • Integration Testing of ETL processes.

Environment: ETL tool Informatica 8.1.1, Netezza, Oracle 10g, Business Objects(BO) XI,UNIX.

Confidential

Manager/ Informatica Consultant

Responsibilities:

  • Analyzed business requirements and worked closely with the various application teams and business teams.
  • Created Logical and Physical models for staging, Transition and production warehouse.
  • Delegated project tasks/workload to team members, and monitor the progress till completion.
  • Optimizing & performance tuning on targets/sources/mappings/sessions to increase the efficiency of sessions.
  • Responsible for overseeing the Quality procedures, unit testing, integration testing.
  • Implemented security features on different domain folders with user privileges based on different roles.

Environment: ETL tool Informatica 5.1/7.1.4, Kalido 7.0, Business Objects(BO) 6.5, Oracle 9i/10g, UNIX.

Hire Now