We provide IT Staff Augmentation Services!

Bi/dwh Lead Resume

New York, NY

SUMMARY:

  • 17 years of experience in Manage /Lead Business Intelligence project and teams with extensive experience in using Business Intelligence products such as SAP BI 4.1, Micro strategy 10.8, Tableau 9, Talend 6/5(ETL).4,Oracle Warehouse Builder (OWB) for ETL, Data Modeling, Oracle, PostgreSQL.
  • Extensive knowledge on Industries like Telecom, Ratings, Banking, Manufacturing, Retail and FMCG, Healthcare etc.
  • Extensive experience in design and development of Business Intelligence ETL and Reporting suites and Design and Development of Data warehouse & Data Marts.
  • Implemented Single Sign On (SSO) from Curam, a java based application to BO enterprise.
  • Good experience in performance tuning of reports and universes.
  • Strong background in Data warehousing and Reporting & Dash boarding solutions.
  • Involved in creation Proof of Concept POC for BI solutions.
  • Good understanding on Business and reporting requirements and able to produce the requirements analysis document.
  • Strong Experience in Developing Operational and Analytical Reports, Testing Reports and Creating and Executing Test Plans.
  • Hands on experience on creating scalable - pre-defined reports.
  • Excellent understanding on Data warehousing concepts and strong experience in implementing data warehousing methodologies
  • Excellent experience in implementing Dimensional Modeling Techniques like star-schema, snow flake schema etc.
  • Excellent Team Leading, Team Management and User Interaction Skills.
  • Strong communication skills, strong analytical, problem solving, and conceptual skills.

TECHNICAL SKILLS:

BI Reporting Technologies: Micro strategy 10,SAP BI4,Business Objects XI-R3.1/R2/6.x (Supervisor, Designer, Reporter), Web Intelligence 6.5/2.7, CMC, CCM BODI, Crystal Reports 2008, Xcelsius 2008, Qlikview 11, BOSDK.

BI Integration Technologies: Talend 5.4/6, Oracle Warehouse Builder(OWB 11 g R2),Informatica 6.5

Applications: Netcracker, Kenan, Salesforce19, Curam 6, Java, C, COBOL

Databases: Oracle, DB2, Teradata, SQL Server 2000

Servers: Tomcat 5, IIS

Other Technologies: Excel, MS Access, TOAD, Citrix

Version Mgmt Tools: VSS, CVS,SVC

PROFESSIONAL EXPERIENCE:

Confidential

BI/DWH Lead

Responsibilities:

  • Leading BI Insights team
  • Executing ETL/BI DWH / BI Reporting project end to end.
  • Migrated the reporting platform from SAP BI 4.1 to Miscrostrategy10.
  • Conducted User education sessions, on new reporting environment.
  • Leading the conversion project (reporting).

Confidential

Data Modeling, ETL Design & Development, Reporting.

Environment: Talend 5.4 / 6,BI 4.1,Oracle 11g,Postgres 9,Net Cracker10, Kenan, Salesforce 19, Telax 19.

Responsibilities:

  • Analysis, Design & Development of Business Planning Data model, Experience and familiarity with
  • Data Warehouse best practices.
  • Analyzing requirements, designing databases, ETL jobs, Reports Design and Development, creating and executing unit test cases.

Confidential

BI Tech Lead

Environment: BI4.1,Oracle 11g,Talend 5.2

Responsibilities:

  • Implemented full reporting life cycle - requirements gathering through implementation including: preparing the functional, scope, mapping documents and high level and low level design specification documents.

Confidential

Business Objects Tech Lead

Environment: BusinessObjects3.1SP6,Oracle 11g,OWB11,Curam 6,BOSDK,Ecplise

Responsibilities:

  • Involved in full reporting life cycle - requirements gathering through implementation including: preparing the functional, scope, mapping documents and high level and low level design specification documents.
  • Hands on experience on Universes Design and Development using Dimentional Modeling techniques .
  • Expertise in reports design & development using Web Inelligence .
  • Designed and implemented the ETL transformations in Stating, Central & Data Mart areas using OWB ETL tool.
  • Implemented Single Sign On(SSO), from the Curam application to Busienss Objects Enterprise system using BO SDK .
  • Well versed with Business Objects Authentications and Authorizations, Creating/Administrating Users & Groups, designated their Security Levels in CMC, assigned Roles, & Access Levels on the Applications and folders.
  • Expert in Designing Dimensional Modeling (Star Schemas, Snow flake schema) and Operational Data store (ODS) in Data Warehouse design.

Confidential

Business Objects Reporting Lead

Environment: BusinessObjects3.1,SQL server 2005,ACTIMIZE

Responsibilities:

  • Design and development of universes and reports for Confidential datawarehousing system.
  • Hands on experience in tuning the performance reports and universes.
  • Accountable for delivery of AML Reports and Universes.

Confidential

Business Objects Reporting Lead/Administrator

Environment: Business Objects XIR3.1 (WebI, Designer, CMC), BODI

Responsibilities:

  • Developed the summary and detailed BO reports as part of ESR package.
  • Modified the existing universes to develop the new set of reports
  • Hands on experience in tuning the performance reports.
  • Unit testing the jobs and preparing the Unit test cases and system level test cases.
  • Schedule and sequence the jobs according to the requirement.
  • Involved in preparing Unit Test Cases and executing them
  • Administration of Business Objects
  • Experienced in integration of SAP and non-SAP data to load into the data warehouse.
  • Good knowledge on Data Services and Rapid marts.

Project EDW Reporting

Confidential

Business Objects Reporting Lead/ Administrator

Environment: BusinessObjectsXIR3 (WebI, Designer, CMC), Live Office, Crystal Reports 2008, MS Access, Data Integrator.

Responsibilities:

  • Crystal Reports development for reporting needs of Confidential ’s data warehousing system.
  • Created Universes for Live Office Reporting.
  • Hands on experience in tuning the performance reports.
  • Used BODI for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
  • Modified the ETL jobs to improve performance
  • Parameterized ETL jobs to allow portability and flexibility during runtime.
  • Extensively used Join, Look Up and Merge stages to meet different business requirements and performance.
  • Experienced in Data Load Performance Tuning, Query Performance Tuning using Business Objects Data Integrator tool.
  • Good knowledge on Data Services and Rapid marts.
  • Created flat file data sources to extract data from non SAP source systems.
  • Scheduled, maintained, and supported the distribution and access to reports through the use of several implemented web-based reporting tools, published generated reports on Crystal Enterprise.

Confidential, New York,NY

Business Objects Lead

Environment: BusinessObjectsXIR3/R2(DeskI,WbI,Designer,Supervisor),Live Office,6.5,(DeskI,WebI,Designer,Supervisor)O/s: Windows 2000, Sun Solaris, BEA Web logic.

Responsibilities:

  • Development of Canned and Ad-hoc reports for Ratings Reporting Users and creating user friendly reports .
  • Migration of Reports and Universe from Business Objects 6.5 to Business Objects Enterprise XI R2 deski and Webi.
  • Report performance issues are resolved at various levels.
  • Involved in migration of the reporting system from BO-XI development to Test and from test to production environments.
  • Hands on experience in tuning the performance reports.

Confidential, Danbury,CT

Senor Business Objects Developer /Administrator

Environment: Business Objects BOXI-R2 / 6.5, Oracle 9i, Windows NT

Responsibilities:

  • Setting up and Installing Business Objects Enterprise XI R2 on Solaris box.
  • Reports and Universe migration from Business Objects 6.5 to Business Objects Enterprise XI R2 Deski and Webi.
  • Used the Migration wizard to migrate the reports from 6.5 to XIR2 and the report conversion tool to convert the Desktop Intelligence reports to Web Intelligence XIR2.
  • Involved in Migrating Objects from Development to Production and having strong experience in Trouble shooting skills
  • Created Users, Groups and Folders in Business Objects XI R2 and implemented security on all these levels.
  • Implemented Object Level Security to Business Objects XI R2 Universes.
  • Involved in all Analysis, Development, Testing, or Business Objects XI R2 Reports
  • Implemented Security at Various levels like Global Security, Folder Level Security and Object level Security.
  • Implemented Data warehousing schemas like Star-Schema.
  • Resolved critical issues by giving best Innovative workarounds for some critical issues thus delivering the reports with in the timelines.

Confidential, Cook County,IL

Business Objects Lead

Environment: Business Objects BOXI-R2, Crystal Reports XI, MS AccessResponsibilities:

  • Involved in Setting up and Installing Business Objects Enterprise XI R2.
  • Migration from Business Objects 6.5 to Business Objects Enterprise XI R2.
  • Developed various types of reports like Simple, Drill down Report, Cross Tab reports for better analysis using BO-XI R2.
  • Involved in Migrating Objects from Development to Production and having strong experience in Trouble shooting skills
  • Created Users, Groups and Folders in Business Objects XI R2 and implemented security on all these levels.
  • Implemented Object Level Security to Business Objects XI R2 Universes.
  • Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports.
  • Involved in all Analysis, Development, Testing, or Business Objects XI R2 Reports
  • Implemented Security at Various levels like Global Security, Folder Level Security and Object level Security.
  • Created canned reports using Crystal Enterprise XI, for scheduling the reports.
  • Resolved loops and Chasm Trap and Fan Trap issues using Aliases and Contexts while designing the Universes.

Confidential, NY

Business Objects Tech Lead

Environment: Business Objects 6.5/BOXI-R2 WebI6.5, Crystal Reports XI, JSP, BO API, DB2, Windows2000

Responsibilities:

  • Using BO, Various types of reports like Simple, Drill down Report, Grouped Cross Tab are created for better analysis.
  • Basing on the requirement of Top management required reports were published as corporate documents on web using INFOVIEW
  • Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formulae etc.
  • Created pre defined Conditions in Universe.
  • Developed Performance Management Dashboards to set goals, measure and monitor KPI for Balance Scorecard initiatives
  • Customer Intelligence Dashboard provided trending, alerting and forecasting of Sales Metrics by Product Analysis, Region Analysis, Customer Analysis and Organizational Analysis
  • Creating complex full client and Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
  • Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports.
  • Involved in customizing the Java Server Pages using Business Objects API
  • Designing and Deploying Universes, developing Complex Reports using complex SQL queries and joins.
  • Created canned reports using Crystal Enterprise XI, for scheduling the reports.
  • Leading the Reporting Team
  • Involved in Migration of Business Objects 6.5 to Business Objects XI R2 and Vertical Scaling in XI
  • Coordination with other Portal Team and ETL Teams.

Confidential

Business Objects Reporting Lead

Environment: BusinessObjects6.5/Webintelligence6.5, Business Objects BOXI-R2, Crystal Reports XI, Oracle 9i, JSP, TOAD

Responsibilities:

  • Reports Developed with PL/SQL Procedures and Free Hand SQL
  • Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
  • Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
  • Developed Performance Management Dashboards to set goals, measure and monitor KPI for Balance Scorecard initiatives.
  • Determined requirements for the Customer Intelligence Dashboard for the Strategic Business units
  • Created thin client reports using Web Intelligence
  • Involved in customizing the Java Server Pages using Business Objects API.
  • Involved in all Analysis, Development, Testing, Tuning and Maintenance, as well as resolved problems during implementation.
  • Created canned reports using Crystal Enterprise XI, for scheduling the reports.
  • Designing and Development of Universes and Complex Reports

Confidential

Sr. Software Engineer

Environment: Business Objects 6.5.1, Web Intelligence 2.7/6.5, Broadcast Agent Publisher version 5.6, Tera Data, Ab Initio, ASP, XCOM and Mainframes.

Responsibilities:

  • Responsible for Designing Universes, Developing, Testing and Maintenance of Reports and Responsible for assigning the tasks to the team, video conferencing and Telecom with the onsite team as part team coordination and team management.
  • Understanding of Business & Reporting Requirements and producing the Requirement Analysis Document.
  • Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
  • Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
  • Used the Drill Down/Up functions to analyze data.
  • Created contexts and aliases to resolve multiple match paths in universe model.
  • Designed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins.

Confidential

Reporting Lead and Onsite Co-coordinator

Environment: Business Objects 6.5.1, Web Intelligence 6.5, Oracle 9i, Siebel 7.1, VSS,TOAD

Responsibilities:

  • As an Onsite Co-coordinator I was responsible for Designing Universes, Developing, Testing and Maintenance of Reports.
  • Formulated Data to appear in Master-Detail, Cross-Tab Reports
  • Involved in modifications and maintenance of Business Objects Universes.
  • Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @functions, Cross Tab, Master Detail and Formula’s etc.
  • Linked Universes based on the requirements

Confidential

Software Engineer

Environment: Business Objects 6.5.1, Web Intelligence 6.5, Oracle 9i, Siebel 7.1, VSS,TOAD

Responsibilities:

  • I was responsible for Designing Universes, Developing, Testing and Maintenance of Reports.
  • Formulated Data to appear in Master-Detail, Cross-Tab Reports
  • Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard
  • Used Drill Up/Down operations done for different aspects of client business.
  • Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.

Confidential

Software Engineer

Environment: DB2, ASP, BO, TOAD

Responsibilities:

  • Creating Universes based on the user requirement and classes, objects and Creating user Objects.
  • Specified the joins and checked the cardinalities. Resolved loops by creating aliases and contexts.
  • Creating Reports using Business objects reporter and Thin Clients Reports

Confidential

Software Engineer

Environment: Oracle 8, ASP, Business Objects 5.1,TOAD

Responsibilities:

  • Ad-hoc reports were used for used for Business Objects user modules for various portfolios using the universes as the main Data providers.
  • Created the reports using Business Objects functionalities like combined queries, slice and Dice, Drill Down, cross tab, Master Detail and formula etc
  • Implemented User Objects in Reports.
  • Created Conditions in Universe and also Prompts for dates and other objects
  • Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.

Confidential

Software Engineer

Environment: Business Objects 5.1, Oracle 8, TOAD, VSS

Responsibilities:

  • Creating ad-hoc reports, and drill down, slicing and dicing, ranking
  • Specified the joins and checked the cardinalities. Resolved loops by creating aliases and context.
  • Ad-hoc reports were used for used for Business Objects user modules for various portfolios using the universes as the main Data providers.
  • Created the reports using Business Objects functionalities like combined queries, slice and Dice, Drill Down, cross tab, Master Detail and formula etc

Confidential

Software Engineer

Environment: BusinessObjects4.1, Oracle 8, TOAD, VSS

Responsibilities:

  • Analyzing the data in Drill Down, Slice and Dice mode. Reports are created using Business Objects to analyze data related to, issuing Policies and revenues earned from each region.
  • Resolving loops in universe and creating the aggregate functions
  • Developed and created classes with Dimensions, Detail and Measure objects and specified the hierarchies
  • Organized data in reports by using filters, sorting, ranking and highlighted data with Alert
  • Maintained the user list, reports and the universes in repository from the various groups.

Hire Now