We provide IT Staff Augmentation Services!

Business Intelligence Lead Resume

Plano, TX

SUMMARY

  • 10+ years of experience in information technology in analysis, design, reporting, development with an emphasis on data warehousing and data integration systems integration and support on various applications
  • Exposure to data modeling, normalization, business process analysis, reengineering and logical & physical database designs using various methodologies and concepts
  • Strong knowledge of data warehousing concepts and dimensional modeling
  • Highly conceptual innovative problem solver with excellent organizational and communication skills.
  • Developed, tested and deployed applications in windows, unix and linux environments
  • Experienced in various Financial Applications such as OFSAA, Summit, AIM/Bloomberg, Quantum and Murex experience in etl using sap dataservices, informatica, ssis. exposure to development / migration to cloud aws write / design automation framework and scripts in jenkins, ruby mine.
  • Data warehousing with requirement gathering, data model analysis, etl, sap business objects - universe & report design, business objects administration - BO 6.5 to bobi 4.1, cmc, webi, udt/idt.
  • 5+ years experience working on business compilation plan with business and i.t.
  • Excellent communication and analytical skills required for effective work in application and development. Know how of bridging the gap between business & i.t.
  • Extensive experience in business object xi r2, 3.1, 4.0 business objects full client, supervisor, cmc, designer, idt & udt, sap bip 4.1, broadcast agent publisher, info view, web intelligence explorer, web intelligence reports, dashboards, performance manager, business query for excel, application foundation, zabo, and web sdk.
  • Created complex and sophisticated reports with multiple data sources, drilldown, slice and dice features using various tools such as Business objects, SAP BW/BI, Tableu, Crystal Reports, etc..
  • Experienced in crystal reports, xcelsius, tableu
  • Experience in retrieving data from multiple sources, business objects universes, flat files, stored procedures and custom sql.
  • Experience in creating of business objects & web intelligence reports from various sources such as oracle, terawatt, ms sql server2008, 2012 & 2014, access and sybase, Confidential Netezza

TECHNICAL SKILLS

Operating systems: Windows 2000/nt/98/95, sun solaris 2.x, hp-unix, red hat linux 7.2/7.3

Reporting tools: Business objects 4.0, 4.1, xir3/ xi r2/ 6.1/ 5.1, universe design, dashboards, sap nip 4.1 crystal reports, info view, webi, designer, performance manager, xcelsius, cmc/ supervisor, Confidential excel, Confidential visio, ms access, tableu, qlikvu

Rdbms: Oracle7/ 8i/9i/10I, SQL SERVER, TERADATA (sql, pl/sql, stored procedures, functions), ms-access 2002/2003, sql server 2000/2005/2008 , db2,tera data, sap bw

Gui tools: Toad 6.3.7.1, sql navigator 4.0,sql server management studio express, sql management studio.

Etl tools: Informatica (power center 5.1/6.2/7.1.2 ), OFSAA, ssis, data intrigator/ services.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Business Intelligence Lead

Responsibilities:

  • Provide direction & support to development teams with both functional & technical processes
  • Oversee and improve BI Processes both in production and non-production environments
  • Improve & Implement data governance methods around multiple applications
  • Present new & innovative technologies & ways to integrate with existing tools build & maintain reporting structure for several Business Areas
  • Manage I.T. & Business relationships in order for successful delivery to Enterprise
  • Work closely with leadership to align on technical efforts and implementations
  • Build and maintain knowledge base documentation for various areas of the project

Environment : oracle 11g, BI Publisher, OBIEE, AWS

Confidential, McLean, VA

Data Analyst / Developer

Responsibilities:

  • Full life cycle data integration - from requirement gathering to Go Live
  • Regular interaction with user base in order to meet delivery timelines
  • Data integration into multiple client facing applications / general user interfaces/database
  • Development of new sql queries along with modification / enhancement to existing sql queries in sql developer lead system test and code migration process - build automation framework & scripts in jenkins, ruby mine. create, execute, monitor & troubleshoot batch process in ofsaa
  • Analyze / Desgin and maintain Reports in Tableu
  • Design and develop complex webi reports in bobi 4.1
  • Development & design using sap bobi 4.1 universe in udt
  • Create variables and formulas in reports both in webi rich client as well as bi launchpad
  • Support and maintain universe using universe design tool
  • Publish adhoc reports & schedule reports in various output webi using both webi rich client & bi launchpad
  • Conversion of handle frequent migrations of objects bo universes and reports across environments
  • Requirement gathering and analysis for new requests from business
  • Worked to maintain & Support Financial Applications such as SUMMIT, MUREX and BLOOMBERG

Environment : oracle 11g, bobi 4.1, SQL Server 2014 SP2

Confidential, Toronto, on

Senior bi consultant

Responsibilities:

  • Design and develop complex webi reports in bobi 4.1 analyze data from various sources and design integration plan into data mart system integration and data transformation using etl process in data services
  • Development & design using sap bobi 4.1 universe in idt & udt
  • Administration in sap bip 4.1
  • Create variables and formulas in reports both in webi rich client as well as bi launchpad
  • Developed and modified dashboards using bo
  • Support and maintain universe using information design tool
  • Maintain bo administration with cmc. Execute regular migrations & promotion of objects using both cmc & lcm.
  • Publish adhoc reports & schedule reports in various output webi using both webi rich client & bi launchpad
  • Conversion of handle frequent migrations of objects bo universes and reports across environments
  • Perform proof of concept for complex requirements on business objects platform
  • Prepare material for power users & provide for business objects / webi

Environment : sql server 2008, bobi 4.1, sap data services

Confidential, Harrisburg, pa

sr. Solutions engineer

Responsibilities:

  • Design and develop complex webi reports in bobi 4.1
  • Developed dashboards, proof of concept using tablu & qlikvu.
  • Support changes and issues in production environment.
  • Analysis & documentation of existing reports & environment
  • Db analysis using sql server management studio
  • Create varaiable and formulas in reports both in webi rich client as well as bi launchpad
  • Developed and modified dashboards using both bo and xcelcius
  • Support and maintain universe using universe design tool
  • Maintain bo administration with cmc. Execute regular migrations & promotion of objects using both cmc & lcm.
  • Design and develop data model for business objects
  • Design and maintain workflows using data services 4.0
  • Part of upgrade from boxi 3.1 to 4.0
  • Publish adhoc reports & schedule reports in various output webi using both webi rich client & bi launchpad
  • Conversion of handle frequent migrations of objects bo universes and reports across environments analyze and make changes in the db according to requirements.
  • Worked with sap bw data platform with bo webi reporting, monitor data loads and perform testing & performance tuning.
  • Worked on sap psm (public sector management)

Environment : sap bw, sql server 2008, bobi 4.1, Confidential ssis.

Confidential, Calgary, ab

Sr. Business objects / business intelligence consultant

Responsibilities:

  • Develop and maintain bo universes & webi reports in both bo 3.0 and bobi 4.0
  • Developed complex dashboards in bi launchpad and xcelcius.
  • Maintain and modify sap bw data model to align with business objects reporting.
  • Handle migrations of objects, universes & reports from bo 3.0 to bobi 4.0
  • Conversion of handle frequent migrations of objects bo universes and reports across environments analyze and modify b.o. Reporting platform according to changes by client requirements
  • Perform etl analysis along with developing various transformations in bo data services
  • Develop, schedule and execute jobs in bo data services
  • Publish reports in infoview & schedule reports in various output webi using both webi rich client & infoview
  • Analysis & documentation of existing reports & environment
  • Db analysis using toad & oracle client

Environment : sap bw, oracle 10g, boxi 3.0, bobi 4.0, unix, Confidential netezza

Confidential, Toronto, on

Business objects administrator / business intelligence consultant

Responsibilities:

  • Provide support for business objects xi3.1 bobi4.0 admin. For various application teams & groups
  • Day to day server support for all three environments - development, acceptance & production
  • Publish reports in infoview & schedule reports in various output webi & crystal
  • Handle frequent migrations of objects & users for various application teams & user groups
  • Maintain functional security for the business objects interface & structure.
  • Analysis & documentation of day to day issues & resolves
  • Build user base and folder structure in new environment using central management console in b.o.
  • Analysis and modification of db design and structure according to requirement
  • Analyze and modify b.o. Reporting platform according to changes by client requirements.
  • Lead a proof of concept for an archiving project with 3rd party products from Confidential

Environment : db2 mainframe, business objects xir3.1, Confidential db2 data studio, crystal reports 2008.

Confidential, Hartford, ct

Business objects/ business intelligence consultant

Responsibilities:

  • Provide support for business objects xi3.1 bobi4.0 admin. For various application teams & groups
  • Day to day server support for all three environments - development, acceptance & production
  • Publish reports in infoview & schedule reports in various output webi & crystal
  • Handle frequent migrations of objects & users for various application teams & user groups
  • Maintain functional security for the business objects interface & structure.
  • Analysis & documentation of day to day issues & resolves
  • Build user base and folder structure in new environment using central management console in b.o.
  • Analysis and modification of db design and structure according to requirement
  • Analyze and modify b.o. Reporting platform according to changes by client requirements.
  • Lead a proof of concept for an archiving project with 3rd party products from Confidential

Environment : db2 mainframe, business objects xir3.1, Confidential db2 data studio, Confidential netezza, crystal reports 2008.

Confidential, Toronto, on

Business objects/ business intelligence consultant

Responsibilities:

  • Install & implementation of latest version of business objects
  • Build database in sql server 2008 using odbc
  • Migration of b.o. Universes & reports - (webi, deski & live office) from boxir2 to bobi 4.0
  • Build security structure for user base in new environment using windows ad
  • Build user base and folder structure in new environment using central management console in b.o.
  • Develop spec. Documentation as well as design documentation according to client requirements
  • Analysis and modification of db design and structure according to requirement changes
  • Analyze and modify b.o. Reporting platform according to changes by client requirements.
  • Analysis and modification of db design and structure according to requirement
  • Lead a proof of concept for an archiving project with 3rd party products from Confidential

Environment : sql server 2008, oracle 10g, business objects xir2,business objects xir3.1, business objects 4.0 (bobi 4.0)

Confidential, Toronto, on

Business objects/etl developer

Responsibilities:

  • Requirement gathering & analysis for migration of data from source to target
  • Develop spec. Documentation as well as design documentation according to client requirements
  • Analysis and modification of db design and structure according to requirement changes
  • Develop etl using business objects data services for migration of data
  • Create complex transformations and queries for etl code.
  • Analyze and modify b.o. Reporting platform according to changes by client requirements.
  • Develop complex reports using business objects xir3.0
  • Develop & maintain reports using cr 10

Environment : netezza, sql server 2005, oracle 10g, business objects xir3.1, business objects data services, sql advantage, sql assistant, winsql.

Confidential, Milwaukee, wi

Business objects architect

Responsibilities:

  • Participated in all phases including requirement analysis, client interaction, design, coding, testing, support and documentation
  • Responsibilities included participating in functional design, performing data analysis, writing complex sql statements within business objects reports.
  • Participated in business compilation plan with the end users and i.t.
  • Worked extensively with business objects6.5 and xir2 to design and develop universes for report generation mainly from sybase and oracle9i
  • Analyzed various data and created reports in business objects xi in webi as per requirements.
  • Created complex scheduled reports & dashboards using business objects xir2 web intelligence, infoview.
  • Created prompts and functions in reports according to the requirements.
  • Worked in with toad and sql advantage to do data analysis and write complex sql statements.

Environment : sybase 12, oracle 9i, teradata, business objects6.5 & xir2, power builder, sql advantage, sql assisstant

Confidential, Austin, tx

Business objects consultant

Responsibilities:

  • Design and development of bo xir2 universes and webi reports.
  • Worked as a part of business intelligence team of 8 to 10 members.
  • Develop and maintain bo webi dashboards. Complex dashboards and graph reports in webi.
  • Design of various drill reports consisting of custom hierarchies.
  • Participated in all phases including requirement analysis, client interaction, design, coding, testing, support and documentation
  • Responsible for data analysis and modeling of structure to better adhere to present & future reporting/business needs.
  • Universe design for both scheduled and adhoc reports
  • Developed complex webi reports for various functional groups within government agencies.
  • Source systems- sql server 2005, foxpro.
  • Used sql server management studio express for day to day query analysis.
  • Developed & modified reports using custom sql.
  • Created & maintained a base of multiple universes as part of changing business requirements.

Environment : sql server 2005, mainframe, business objects xir2.

Confidential, Mississauga, on

Business objects architect

Responsibilities:

  • Design of architecture for business objects environment.
  • Develop dashboards with performance manager for monitoring of metrics and user analysis.
  • Participated in all phases including requirement analysis, client interaction, design, coding, testing, support and documentation
  • Responsibilities included participating in functional design, performing data analysis, writing complex sql statements within business objects reports.
  • Universe design for both scheduled and adhoc reports
  • Complex dashboards and graph reports in web
  • Coordinating with offshore members for process plan purpose.

Environment : sap bw, oracle, sap, business objects.

Confidential, Milwaukee, wi

Business objects developer

Responsibilities:

  • Participated in all phases including requirement analysis, client interaction, design, coding, testing, support and documentation
  • Responsibilities included participating in functional design, performing data analysis, writing complex sql statements within business objects reports.
  • Worked extensively with business objects6.5 and xir2 to design and develop universes for report generation mainly from sybase and oracle9i
  • Migrated existing reports from business objects 6.5 to business objects xir2.
  • Analyzed various data and created reports in business objects xi in webi as per requirements.
  • Created complex scheduled reports using business objects xir2 desktop intelligence.
  • Created prompts and functions in reports according to the requirements.
  • Worked in with toad and sql advantage to do data analysis and write complex sql statements.
  • Generated and published reports on webi for end users. Reports included on demand, scheduled, monthly or weekly.
  • Generated reports in which data existed in multiple databases, using freehand sql and universe.

Environment : sybase 12, oracle 9i, business objects 6.5, business objects xir2, unix server, power builder, sql advantage, toad.

Hire Now