Bi Architect, Lead Resume
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.
