We provide IT Staff Augmentation Services!

Bi Architect, Lead Resume

4.00/5 (Submit Your Rating)

Cincinnati, OH

PROFESSIONAL SUMMARY:

  • Business Intelligence professional with overall 9 Years 10 Months of experience in managing, leading, developing and architecting end to end BI projects for multiple General Electric businesses through Confidential .
  • Professional who has played wide range of roles ranging from Project Manager, BI Architect, BI Lead, BI Business Analyst, BI Developer, Onsite Co ordinator & Agile Scrum Master.
  • Experience executing projects both on shore and offshore in multiple geographies.
  • Currently based out of the USA with a valid H1B visa.
  • Experience in leading both Agile and Waterfall project implementation frameworks.
  • Having good exposure in Pre - Sales activities which includes - developing POC, Presentations, preparing RFP’s and project estimations.
  • Capability to scale up, explore, learn and understand new business domains and technology.
  • Excellent written and oral communication skills with exhaustive client facing experience.
  • Professional with excellent team skills, solid sense of ownership and dedication.

TECHNOLOGY STACK, KNOW-HOWS & SKILLS:

Reporting Tools: OBIEE (Oracle Certified), Cognos, Qlikview & Spotfire

ETL Tools: Informatica, Teradata BTeq, Talend (Trained)

Databases: Oracle, Greenplum, Teradata & SQL Server.

Other Tools: Ervin (data modelling), Pandora (Data Profiling)

Project Management: Rally Agile Tool, MS Excel

Domain Knowledge: Supply Chain, Services, CRM, OM, AR, Inventory, HRMS

Source Systems Knowhow: Oracle Apps, Siebel CRM, Custom ERP Systems

Industry Experience: Healthcare, Aviation, Banking

EMPLOYMENT HISTORY:

Confidential, Cincinnati, OH

Environment: Spotfire, Greenplum DB, PostgreSQL, Rally

BI Architect, Lead

Responsibilities:

  • Requirement gathering & documenting customer expectations.
  • Design and estimation. Define Architecture and strategy for Datalake components and Spotfire reporting tool.
  • Requirement Gap Analysis and mitigation.
  • Optimize the tool for better performance.
  • Impact analysis
  • Drive the User Acceptance Testing and track bugs and issues to closure.
  • Suggest strategies for future enhancements and scaling up of environments.
  • Defining coding standards and making sure teams adhere to coding standards and best practices.

Confidential, Milwaukee, WI

Environment: Celek Tool (Excel Based Reporting), Teradata

BI Business Analyst & Scrum Master

Responsibilities:

  • Requirement gathering & documenting customer expectations.
  • Current System Understanding
  • Gap Analysis
  • Execute POC’s to understand the capability of the tools in providing flexibility expected by users.
  • Impact analysis
  • Estimation of work
  • Managing the Agile - Rally tool, lead the scrum calls and work allocation to the offshore teams.
  • Development of master mapping for solution through Metadata tool
  • EDW Data modeling and creation of SQL queries for reporting.
  • Drive the User Acceptance Testing.

Confidential

Tool: Qlikview, Informatica, Oracle DB, SQL Server, Pandora

BI Business Analyst & OBI Project Lead

Responsibilities:

  • Requirement gathering & Analysis
  • Data modeling, design and define the Architecture of the project.
  • Impact analysis and gap analysis
  • Develop Qlikview reports
  • Work with teams to define ETL using the Oracle DB and Informatica platform
  • Play the role of Scrum Master and drive the Scrum calls, plan, estimate and manage work allocation to teams.

Confidential

Environment: OBIEE, Teradata, Informatica

BI Business Analyst & OBI Project Lead

Responsibilities:

  • Business Analyst - Worked with client to prepare a detailed documentation for requirement understanding which included Field Mapping Document, Metric Calculation Document and supporting excel and graphical representations of the calculations.
  • Presented a POC to the client based out of the legacy JDE system to showcase OBIEE capabilities as compared to existing BI application.
  • Estimation & Planning - Did estimation and assessment of timelines for the project.
  • Team management.
  • Design - Designed the RPD and the reporting formats. Was actively involved in table design and data modeling.
  • Coding:
  • RPD Development
  • Creation of reports and pages using Answers and Dashboards
  • Testing
  • Unit Testing.
  • System Testing.
  • Performance Testing.
  • Data Validation Testing
  • Release management.
  • Client & User communication management.

Confidential

Environment: OBIEE (BI APPS), Teradata, Informatica

Team Lead

Responsibilities:

  • Estimation - Did estimation and assessment of timelines for the project.
  • Coding:
  • Bug fixes.
  • RPD Development.
  • Creation of reports and pages using Answers and Dashboards.
  • Performance improvements for the reports.

Confidential

Environment: OBIEE, Teradata, Informatica

Reporting Lead & Team Manager

Responsibilities:

  • Requirement Analysis - Did a detailed POC for the client requirements to showcase OBIEE capabilities as compared to existing Java application. Worked with client to prepare a detailed documentation for requirement understanding which included Field Mapping Document, Metric Calculation Document and supporting excel and graphical representations of the calculations.
  • Estimation - Did estimation and assessment of timelines for the project.
  • Design - Designed the RPD and the reporting formats. Was actively involved in table design and data modeling.
  • Coding:
  • RPD Development
  • Creation of reports and pages using Answers and Dashboards.
  • Documentation -
  • Creation of SRS, SDS, Requirement Understanding Docs.
  • Requirement Traceability Matrix.
  • Preparation of Unit test cases, system test cases.
  • Project Management:
  • Task allocation to the team members.
  • Client interaction to understand issues and requirements.
  • Code Migration management from Dev to Prod
  • Defect Tracking and resolution.
  • Grooming fresh recruits.
  • Coordinating with different teams for project execution.
  • Knowledge transfer to RTS team.

Confidential

Environment: OBIEE, Teradata

Developer

Responsibilities:

  • Requirement Analysis - Was actively involved in the POC phase of the project and during the development phase worked on the report specific requirements.
  • Estimation - Was actively involved in estimation and assessment of timelines for the project.
  • Designing reports - Worked on the different formats and designs the reports will be viewed.
  • Coding:
  • OBIEE:
  • RPD Development
  • Creation of reports and pages using Answers and Dashboards.
  • Implementation of Usage tracking.
  • Security.
  • Teradata:
  • Analysis, creation and modification of views
  • Data Validation.
  • Testing:
  • Unit Testing.
  • Regression Testing.
  • System Testing.
  • Performance Testing.
  • Documentation -
  • Creation of High Level Design & Low Level Design Documents.
  • Requirement Traceability Matrix.
  • Involved in preparation of SRDS, SRS
  • Preparation of Unit test cases, system test cases.

We'd love your feedback!