Experience Summary

• Worked on all phases of DW/BI implementation lifecycle from conceptualization, requirement gathering, analysis, design, implementation, testing, maintenance and support
• Handle challenges and complexities of data mart design and BO universe designs
• Strong experience in designing data mart/data warehouse with Dimensional Data Modeling techniques (Kimball Methodology) using ERWin/SQL Data Modeler tools
• Experience in Agile BI Methodology – Epic planning, sprint planning, formulating appropriate sprint stories/tasks, successful sprint execution and adding value in scrum and sprint retrospective sessions
• Worked closely withexecutives/businessusers to understandbusiness processes, KPI’s, reporting needs, gather/document technical and business requirements and drive BI/DW usage/strategy
• Undertook various BI initiatives by anticipating business needs and assisted executives/BI Architect to form DW/BI strategy, recommend BI products and implement best practices and process improvement
• Initiated Data Governance and Data Stewardship Strategies
• Designed and implemented highly complex to moderate level BO Universes involving multiple Fact Tables
• Proficiency in Business Objects XI R2/3.0 Suite, designing universes from various data sources, optimizing universe design, managing universe meta-data, designing reports in Webi and Deski, designing dashboards in Xcelcius and Dashboard Manager, implementing and managing BO user security, BO server administration.
• Experience and working knowledge of other BI tools – OBIEE, Tableau and MSBI
• Evaluated various BI tools and interacted with BI vendors in choosing suitable tool that meets BI objective
• Worked closely with the ETL team to sync ETL strategy with BI requirements, ensure timely data loads and test data quality
• Performed analysis and provided expert advice on data analysis/reporting strategies to user satisfaction
• Performed BI application usage analysis and maintenance of BI infrastructure
• Analyzed and provided recommendations in standardizing organization’s BI/DW infrastructure
• Identified data quality issues and supported the data integrity requirements
• Experience in building OLAP cubes, Dashboards, Analytical Reports with various BI Tools (BO,OBIEE,MSBI)
• Proficiency in developing complex SQL queries with various databases
• Experience of BI projects in many industries: Entertainment & TV Network, Internet Services and Media, Finance and Manufacturing
• Presented various papers in the BI field and awarded ‘Best Paper in BI domain’
• Demonstrated leadership qualities, recognized for performance excellence and team management skills
• Understanding of Data Governance, MDM, ERP, SAP BW and Business Process Modeling
• Provided BI tools training to users/team members, provided guidance and end user support

BI/DW Technical Skills
Business Objects XIR2/3.1: Universe Designer, Web Intelligence, Query as a Web Service, Crystal Xcelcuis, Desktop Intelligence, Server Management and User Security using Central Management Console (CMC)
Oracle BI (OBIEE) : Server Administration – Physical Layer, Business Model and Mapping Layer, Presentation Layer, Oracle Answers, Oracle Dashboards, Oracle Delivers (Alerts & iBots), BI Publisher (Scheduling)
Microsoft BI (MSBI): Analysis Services (OLAP Cube), Reporting Services (Report), Data Marts in SQL Server
Kalido: Kalido Business Information Modeler (BIM)
Tableau: Tableau Analytics Server 6.0
ETL Tools: Informatica, Business Objects Data Integrator Microsoft Integration Services
DB Languages: SQL, PL/SQL
Databases: Oracle 9i/10g, SQL Server 2005, Sybase 12.5 Adaptive Server
Data Mining: MS Excel Data Mining, Rapid Miner, SPSS

Work Experience

Business Intelligence Specialist (May 2011 – Till Date)
Confidential, Bristol, CT

• Product Owner of 3 Business Objects Universes and Webi reports based on these universes
• Worked on challenges and complexities of data mart design and universe designs
• Designed data marts using dimensional modeling techniques in SQL Data Modeling tool
• Designed Business Objects Universes
• Worked closely with the Data Architect and ETL development team
• Adopted Agile BI development protocol and standards. Worked on Serena Agile Tool.
• Performed Data Quality check and wrote SQL statements to test ETL loads (Initial and Delta Loads)
• Initiated and implemented BI Standards across the organization (Classes, Objects, Reporting, Version Control)
• Initiated data management, data governance and data stewardship strategies
• Implemented complex objects, joins and data fetching mechanisms
• Implemented object level security at universe level
• Suggested and implemented organization level BI enhancements
• Assisted BI Architect in designing BI strategy and long term vision of BI applications across the organization
• Converted legacy reports from source system into dynamic analytical BI reports
• Worked on Kalido Business Information Modeler to design EDW level data models
• Assisted in Universe Design for Operation Data Store (ODS) model (Non-Dimensional Model)
• Implemented complex variables/formulae to design Webi Reports
• Designed challenging Webi reports involving high level formatting/layout and complex designs
• Provided insight and suggestions for improvisations in Agile BI Methodology and took ownership for successful sprint execution
• Assisted in Agile Methodology - Epic planning, Sprint planning, formulating appropriate sprint stories/tasks
• Worked closely with the Admin Team during BI content migrations across environments (SB, Dev, QA, Prod)
• Analyzed BI requirements and perform data analysis to ensure availability of data to meet BI requirements

Business Intelligence Specialist (Jan 2011 – May 2011)
Confidential,Youngstown, OH

• Enhanced dimensional data model designs and design BO universe using Universe Designer in BO XI 3.1
• Designed ETL strategy, performed data loads into the data mart and ensure data quality
• Initiated data management, data governance and data stewardship strategies
• Updated dashboards and report designs showing trends, patterns and other required data analysis using Business Objects XI 3.1 Web Intelligence, Xcelcius
• Worked closely with users to understand KPI, gather and document reporting, analysis and data requirements
• Trained senior executives/users in making the best use of the BI solution

Business Intelligence Specialist (May 2010 – Dec 2010)
Confidential, Sterling, VA

• Worked on multiple projects and at various levels from Project Lead to BI Analyst/Developer
• Recommended by Senior Technical Manager to be a part of ‘BI Initiative Committee’

Project: BO Design/Development

• Interacted with the business users to gather reporting and data analysis requirements and understand KPI’s
• Initiated ‘Agile Development Methodology’ as project lead for this
• Collaborated with data architect to design dimensional data model
• Designed BO Universe to integrate with existing BO infrastructure
• Lead a team of two report developers to develop reports that meet requirements and ensure quality
• Worked closely with the ETL team to sync ETL strategy with BI requirements, ensure timely data loads and test data quality, review ETL mechanisms for data integration
• Worked closely with the Data Architect while in designing data marts, transforming the logical data model to physical data model at database level, recommend design changes, test and ensure query performance
• Promoted BO for future reporting initiatives by presenting prototypes to various business units

Project: BO Migration

• Worked closely with executives/business users to understand data analysis/dashboard/reporting requirements
• Developed a detailed level project plan and roadmap for BI platform migration from BO XI R2 to XI 3.1
• Lead the project to ensure timely delivery, track project progress and incorporate changes in project plan
• Analyzed existing universes/dashboards/reports and provided recommendations to enhance the designs
• Provided both technical and business enhancement to the current reporting/BI environment
• Identified high priority dashboards/reports and high traffic reports and analyzed the effect of migration it
• Documented/summarized the potential breaks for universe, dashboard and reports migration

Project: Data Management Initiative

• Worked closely with executives to drive the new data management initiative to standardize the data architecture
• Assisted executive management to conceive/develop an organization level data management and BI strategy
• Promoted dimensional modeling methodology and EDW standards to various business units
• Promoted BI standards, data governance and data stewardship across all business units within the organization

Project: Tableau – Analytical Dashboard Development

• Interacted with the business users to gather dashboard and data analysis requirements and understand KPI’s
• Handled complex and unconventional drill-down and roll-up requirement using Tableau Server 6.0
• Designed objects/variables within the Tableau environment to handle links to other Tableau dashboards
• Designed analytical dashboards using Tableau Server 6.0 for one of the most complex requirements

Business Intelligence Specialist (Aug 2009 – April 2010)
Confidential,Youngstown, OH

Project: Build a data mart, design dashboards and reports to help management optimize class-scheduling process by determining trends, patterns and other detailed data analysis. This BI project was aimed to support decision-making and help achieve maximum Return on Investment (ROI) with minimal resource wastage.

• Worked closely with users to understand KPI, gather and document requirements (Analysis/Report/Data)
• Analyzed various BI tools suitable for the project based on business objectives and technical requirements
• Designed dimensional data model and BO universe using Universe Designer in BO XI 3.1
• Designed ETL strategy, performed data loads into the data mart and ensure data quality
• Developed OLAP data cubes, dashboards and reports showing trends, patterns and other required data analysis using Business Objects XI 3.1 Web Intelligence
• Trained senior executives/users in making the best use of the BI solution

Business Intelligence Analyst (May 2009 – July 2009)
Confidential,Santa Clara, CA

Project: Enable Mobile BI to mid and top level management. Evaluate existing data mart designs for Mobile BI data. Analyze, design and implement dashboards on OBIEE platform. These dashboards were required specifically to be viewed on mobile devices. Perform all required steps using OBIEE to implement such a Mobile BI solution.

• Analyzed business requirements and designed a Mobile BI solution with Oracle BI (OBIEE) as a platform
• Analyzed and evaluated the existing data mart designs for data sets required for Mobile BI (dashboards)
• Analyzed KPI’s and developed queries/reports using Oracle BI Answers to meet Mobile BI requirements
• Designed dashboards using Oracle BI Interactive Dashboard to be specifically viewed on mobile devices
• Built a schedule plan to schedule reports and deliver alerts/reports to mobile devices (Delivers & BI Publisher)
• Compared and analyzed popular mobile devices & recommended best suited for Mobile BI on OBIEE platform
• Single-handedly managed project implementation and solution delivery

Business Intelligence/Data Warehouse Analyst (Feb 2008 – Aug 2008)
Confidential, New York City, NY

Project: Build a data warehouse to drive profitability by highlighting areas of value creation and value destruction at a team-by-team and client-by-client level. This system would source Expense, Revenue and other relevant data including reference data. This data warehouse would be used as source to design reports and dashboards to calculate client and team level profitability to be used by the Activity Based Monitoring System (ABM).

• Module Lead for the Business Objects universe/report design part of the project
• Designed a dimensional data model using ERWin and build a data warehouse in Sybase Adaptive Server 12.5
• Designed and maintained BO Universes, consolidated BO universes connecting to the new data warehouse
• Designed reports in BO XI R1/R2 Web Intelligence and Desktop Intelligence
• Implemented user security/rights and entitlements using BO administration tool
• Designed SQL queries using QaaWS to be used in dashboards outside the BO environment
• Managed migration cycle to migrate reports to the consolidated universe and across other environments
• Designed transformations in Informatica, performed data loads and monitored ETL jobs

Senior Business Intelligence Engineer (Jan 2006 – Jan 2008)
Confidential, San Jose, CA

Project: Performed in-house beta testing of BO XI 3.0 before product release. Worked on various projects and assisted clients to design BO Universe, reports and dashboards, migrate to BO XI from BO 5.x/6.x, implement user security and perform BO server administration.

• Designed various universes in BOXI R2 Universe Designer to facilitate business and technical needs
• Developed reports, dashboards in BOXI R2 Desktop Intelligence, Web Intelligence & Crystal Xcelcius
• Performed troubleshooting on issues in Universe, Deski, Webi, BO Servers, CMC, BO Security & User Rights
• Resolved ODBC and migration issues by recreating objects, formulae, prompt, etc. that fail during migration
• Handled user rights & administered BO XI R1/R2 Servers using Central Management Console
• Assisted clients in scaling & sizing the BO XI R1/R2 deployment for performance optimization

Technical Support Engineer (June 2004 – May 2005)
Confidential,, India

• Performed troubleshooting of OS related issues on Microsoft Windows 9x & NT/XP platforms
• Performed in-depth research on the functioning of latest viruses & spy wares and devising solutions

Education

Master of Computing and Information Systems
Bachelor of Engineering in Information Technology

Certifications/Honors/Awards/Memberships

• Business Objects Certified Professional – BO Enterprise XI R2 (BOCP)
• Oracle Certified Professional – Oracle 9i Database Administration (OCP DBA)
• Completed training in Operations Management, Business Process Management and Supply Chain Management (SAP ERP). Awarded SAP ERP Certificate by SAP University Alliance program at Youngstown State University
• Awarded Honorary Membership to the Golden Key International Honor Society for academic excellence
• Awarded Teaching Assistantship at the CSIS department, YSU
• Awarded ‘Best White Paper in Business Intelligence’
• Member of ‘The Data Warehousing Institute’ (TDWI)

Personal Skills

• Excellent Team player and ability to manage people, time and resources well
• Excellent planning, problem-solving, decision-making and analytical skills
• Willingness to learn, adaptable, dedication and responsiveness towards work
• Excellent interpersonal, verbal and written communication skills
• Ability to work in challenging, fast paced environment and handle project responsibility under pressure situations

Other Interests

• Preparing for ‘Certified Business Intelligence Professional’ (CBIP) certification
• Pursue ‘Project Management Professional’ (PMP) certification
• Pursue ‘Six Sigma’ process management certification