We provide IT Staff Augmentation Services!

Bi Tech Lead Resume

Houston, TexaS

SUMMARY:

  • Around 10 years of experience in as a Analytics role BI (SAP BO) and Data Visualization (Tableau) tools/techniques experience by solving business problems & providing analytical solutions to clients.
  • Working with enterprise wide business and IT senior management to understand reporting and data analysis needs.
  • As an Architect working closely with Business Analyst and customers in the gathering of requirements for reports and dashboards. Have extensive experience working with BO WebI tool.
  • Be principally responsible for designing BO universe layer for business intelligence solutions
  • SAP BO Architecture, schema design, modeling, development, trouble shooting and requirements gathering .
  • Hands - on experience in all phases of Software Development Lifecycle (SDLC) using Iterative, Agile and other internal SDLCs and technology delivery frameworks.
  • Business Objects Universe Designer/Architect is responsible and accountable for all Business Objects Development deliverables provided by the Enterprise reporting team.
  • Expertise in SAP Business Objects Development, QA and production support and Administration.
  • Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Modeling .
  • Installation and setup of servers, administration and support of Business Objects (BO 4.0, 3.1 and XI) development provide application support.
  • Develop and maintain reports, universe and macros to support the business community.
  • Perform Row level securities, Universe and Reports Migrations, Authentications, Scheduling, and Universe Backup and Tuning Reports and Universe get better performance.
  • Interact with users to document and analyze business requirements and deliver results appropriately.
  • Experienced in requirement gatherings from Business and create the specs for development of Universe Design/WebI.
  • Development and Support environment in the Business Intelligence based on business needs, to resolve defects as per agreed SLA and working on ServiceNow Tickets on priority.
  • Experience in Data Warehousing, ETL Data Integrations, Business Objects 4.1/3.0/R2, Tableau 8.3/9.0/9.1 Desktop , Server in various versions .
  • Expertise in various DB Databases skills like, SQL & PL SQL, SQL Server, Oracle, Teradata and Sybase.
  • Experience of playing various key roles such as Module Lead, Quality Analyst, Developer, tester etc. from offshore and onshore working with various clients.
  • Proficiency with SQL and other database tools to store, organize, retrieve, and manage data for Data analysis. SQL tuning and Performance tuning techniques
  • Excellent interpersonal communication skills and influencing skills. Demonstrate strong consultative and engaging presentation skills Self-motivated and strong team player.
  • Experience in Oil &Gas, Telecom-Media &Entertainment, Health Care/Life Insurance, Insurance and Banking/ Financial Services Domain.
  • Software development background, with expertise in Scrum, Waterfall, and hybrid methodologies.
  • Extensive knowledge in creating BRD, FRD and RFP documents.
  • Provides Estimates for Planning, Budgeting, Development execution of automated test cases.
  • Experience of playing various key roles such as Module Lead, Quality Analyst, Developer, tester etc. from Onshore and Offshore working with various clients .

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Texas

BI Tech Lead

Responsibilities:

  • Working as Tech Lead (12 team size) for the Development and Production Support project for the ETL Tableau and SAP Business Objects Technologies responsible for New Development and production support of Customer Requirements coordination with technical team.
  • Analyze data issues, identify and articulate the business impact of data problems.
  • Having experience on handling various customers, understand their requirements and involving in full product life cycle of the project.
  • Involved in Development, Production Support, Migrations and BO Server Administration (CMC).
  • Generating Sub Reports, Hyperlinks and Graph Reports by using chart expert of SAP BO Reports and developed 100+ reports.
  • Creating Users, Groups and Access Levels for Security by using Central Management Console (CMC).
  • Creating Publications and publish all the reports developed from BO Reports to the end user.
  • Extensively used Data validation SQL to verify if the data pulled by the report is correct and compared to the database data and to verify if the joins used in query are correct.
  • Created a backup of BO Reports and universe in BIAR format by using Import Wizard
  • Utilized all Tableau products including Tableau Desktop, Tableau Server, Tableau Reader and Tableau Public.
  • Experience in end to end development of a new set of reports, dashboards & KPI Scorecards.
  • Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters and parameter, drill-up and Drop-down menu option and Parameterized and Linked reports using Tableau.
  • Experience in creating aggregates, hierarchies, filters, quick filters, calculated measures.
  • Expertise with creating solution driven views and dashboards by developing different chart types including Line Charts, Bar Charts, Pie Charts, Histograms, Waterfall Charts, Gantt Charts, Donut Charts and Bullet Graphs in Tableau Desktop.
  • Implemented Tableau features such as parameters, table calculations, sets, groups, user filters.
  • Data blending to create views combining data from multiple data sources.
  • Experience in managing users, groups, projects, data connections, sites, permissions and roles on Tableau server.
  • Implemented Scheduled Updates to Published Tableau Data Extracts.
  • Using Service Now tool for the tickets as incidents, change request and RITMs based on the User's demand. Investigate new/existing issues in Customer Requirements.
  • Clearly document all findings in the issue tracking system as SharePoint.
  • Maintaining issue tracking system (SharePoint) daily. Provide feedback to the clients and Onsite managers (IM Owners).
  • Generate routine and ad-hoc reporting and analysis to assist in evaluating production performance and resolving issues
  • On call support for Enhancements and Issues for the Existence reports.
  • Generates the Reports based on the Data loading in tables JOB SET dependencies.
  • Preparing documentation as per the work stages. Like DOU (Document of Understanding), FRD (Functional Requirement Document) and Unit test cases.

Confidential, New York City, NY

BI Consultant

Responsibilities:

  • Created Relationships, actions, data blending, filters, parameters, hierarchies,
  • Calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
  • Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
  • Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau.
  • Handled Tableau admin activities granting access, managing extracts and Installations.
  • Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
  • Published Workbooks by creating user filters so that only appropriate teams can view it.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Design, deploy, and maintain various SSRS Reports in SQL Server 2008.
  • Designed and implemented Parameterized and cascading parameterized reports using SSRS..
  • Resolved Performance issues from Reporting standpoint as well as from the Database standpoint.
  • Responsible of creating some Administrative tasks like Creating Users, Groups, Assigning Users to the Groups and also Access to the end users.
  • Responsible for creating complete end to end documentation to the end users.

Environment: Tableau Desktop 8.0, Microsoft SQL Server 2008, SQL Reporting Services and SSAS.

Confidential

Sr. Software Engineer

Responsibilities:

  • Interacting with Customers, Understanding their requirements and involving in full development life cycle of the Account.
  • Creating a Project plan and responsible for smooth delivery without any hassles.
  • Reports migration from Actuate to Crystal using Monaco DB.
  • Expertise in gathering, analyzing and documenting Business Requirements, Functional Requirements, System Test Cases and Use Cases, Performance Testing Requirements, and Data Specifications for Business Objects Universes and Reports.
  • Expert in creating complex WebI Reports (Ad-hoc Reports, Frequency Reports, Summary Reports, Drill Down, Dynamic Grouping, Graphical, aging Reports)
  • Handling all the performance issues by tweaking the reports or queries where required.
  • Coordinating with team and getting the work done from them. Helping them if required
  • Tuning at DB Query level or at Report level based on the situation.
  • Responsible of 2 Months post Production support after the customer Go Live.

Environment: Business Objects BOXIR3.1, Crystal reports 2008, InfoView, Teradata, Oracle and Toad.

Confidential

Consultant

Responsibilities:

  • Interacted with Acquisition Deal Team, Investment Controllers and Asset Managers for requirement gathering and defining business processes/workflow diagrams.
  • Extensively involved in setting a new BO 3.1 Environment.
  • Having experience on handling various customers, Understand their requirements and involving in full product life cycle of the project.
  • Interacting with the team and getting the work done from them.
  • Involved in Development, Production Support, Migrations and BO Server Administration (CMC).
  • Generating Sub Reports, Hyperlinks and Graph Reports by using chart expert of SAP BO Reports and developed 100+ reports.
  • Creating Users, Groups and Access Levels for Security by using Central Management Console (CMC).
  • Creating Publications and publish all the reports developed from BO Reports to the end user.
  • Extensively used Toad to verify if the data pulled by the report is correct and compared to the database data and also to verify if the joins used in query are correct.
  • Developed Crystal Reports by using Stored Procedures etc.
  • Created a backup of BO Reports in BIAR format by using Import Wizard.
  • Requirement Collection, Documentation & high-level design.
  • Configured WebI reports 2008 to develop reports using Custom Coded functions.
  • Updated and maintained Universes to meet new reporting requirements.

Environment: Business Objects XI 3.1, Crystal reports 2008, InfoView, Oracle, Sybase and Toad.

Hire Now