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.