SUMMARY

• Having around 20 Years of experience in architecting enterprise BI solutions, Data Scientist, Certified Scrum Master & Data Modeling for Financial, Banking, Manufacturing, Energy & Utilities, Insurance, Healthcare, Media and Retail industries.
• Experience in analyzing business issues (as BA) and provide new solution on the process through IT technologies.
• Experience in analyzing existing system to provide remediation solutions.
• Worked as a Scrum Master to create EPIC, feature, story, task etc as well as conducted scrum calls with multiple stakeholders for each Sprint of deliverables.
• Provide metrics data on project status through RTC tool to the client Sr. management team and business.
• Conducted Agile scrum workshops to offshore team on story, task creation and status updation in RTC tool.
• Managed many data warehouse projects by leading the team on technical as well as functional (Data Analyst), completed Data Science Basic certification and projects through DataMites (India), projects as well.
• Worked extensively in Architecting, leading, developing and implementing report solutions on SAP - BI 4.x (BO), Business Objects XI Release II, Crystal Reports Server XI, SAP Lumira, Crystal Enterprise 10/9/8.5, Tableau 10.5, Web Intelligence XI, Desktop Intelligence, Business Objects Universe Designer (IDT), Crystal Reports Explorer 10.5.
• Experience in developing LDM, PDM and ER diagram for application development.
• Lead the migration projects of Legacy DW systems to Teradata, BO 3.0 to BO 4.0, DESKI to WEBI, Crystal 10 to XI.
• Lead the migration project from Mainframe to BO XI Deski & WebI (BO 3.0).
• Worked extensively Informatica 9.1 & IBM DataStage 11.5 as ETL tools to load source files and Data warehouse reconciliation.
• Worked on IBM DB2, IBM Data Studio, IBM Rational System Architect 11.4, IBM Cognos 10, IBM Cloud solution, and IBM Informix 12.1.
• Worked extensively in developing Procedures, Triggers, Views on databases like Teradata 13.10 Oracle 9i,10g, SQL Server 7.0,2000,2005, and IBM Informix 12.1
• Knowledge of programming languages like PL/SQL, SQL, Shell Script, C, C# and knowledge of Hadoop, Hive, Big Data.
• Experience in interacting with business users and business rules analysts on multiple projects.
• Expertise over preparing report specifications, database designs to support the reporting requirements.
• Active team player, certified Agile-Scrum Master and as an individual with Excellent Communication, Interpersonal skills, self-motivated, fast learner and good listener.

PROFESSIONAL EXPERIENCE

Business Analyst & Information Architect

Confidential

Responsibilities:

• Responsible for Business study at client location, Data Analysis, design, solution architecture and implementation lead.
• Worked with Business owners (act as BA) to understand the business scenarios and problem statements. Provided data mapping documents.
• Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
• Responsible for providing high level design and low-level design deliverables along with test plan and test strategies.
• Responsible for providing inputs and validate Data Quality and Data Governance process.
• Design and developed Audit & error handling model and implemented.

Information Architect

Confidential

Responsibilities:

• Responsible for Analysis, design, development, testing and implementation of IBM DataStage jobs, Control-M Schedules, Data Model of IIW and Netezza DB Scripts.
• Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
• Responsible for providing high level design and low-level design deliverables along with test plan and test strategies.
• Responsible for providing inputs and validate Data Quality and Data Governance process.
• Design and developed Audit & error handling model and implemented.
• Work with Business Analyst in translating business requirements into Functional Requirements Document and Detailed Design Documents
• Delivery of design documents, test cases, test results, methodologies documents, process documents to be followed by other technical groups.
• Using IBM in-house tools apply methodologies and process for development, testing and implementation.
• Worked as a Scrum Master to create EPIC, feature, story, task etc as well as conducted scrum calls with multiple stakeholders for each Sprint of deliverables.
• Provide metrics data on project status through RTC tool to the client Sr. management team and business.
• Conducted Agile scrum workshops to offshore team on story, task creation and status updation in RTC tool.
• Implement IIW data model v8.9 and customize as per customer need (as out of box) and integrate the source system.
• Analyze the existing source data model in ErWin to build and adopt to IIW Data model v8.9.
• Design and develop Tableau dashboard to provide the result out of IIW data model in parallel to SAP Lumira dashboard.
• Lead the development team on technical issues arrives during development, testing, implementation.

Environment: IBM Netezza, IBM Datastage 11.5, IBM IGC, IA, Linux, Erwin 9.6, SAP BI/BO Enterprise 4.2 - Universe & Lumira, Crystal Reports 2016 and Tableau 10.5.

Confidential

Information Architect (Data Architect)

Responsibilities:

• Responsible for Analysis, design, development and implementation of IBM Cloud solutions using IBM DB2 10.2, IBM Data Studio, IBM Rational System Architect 11.4, IBM Cognos 10, IBM Data Stage and Informix.
• Develop LDM, PDM and ER diagrams for application development to cover the business functionalities as well as BI solution.
• Provide complex SQL and explain to developers for application development.
• Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
• Responsible for providing high level design and low-level design deliverables
• Work with Business team (as BA) in translating business requirements into Functional Requirements Document and Detailed Design Documents with data mapping.
• Delivery of design documents, test cases, test results, methodologies documents, process documents to be followed by other technical groups.
• Using IBM in-house tools apply methodologies and process for development, testing and implementation.
• Lead the development and support team on technical issues arrives during development, testing, implementation.

Environment: IBM DB2, IBM Data Studio, IBM Rational System Architect 11.4, IBM Cognos 10, IBM DataStage, Informix and SPSS.

Confidential

BI Architect (BI Data Architect)

Responsibilities:

• Responsible for Analysis, design, development and implementation of SAP BO 4.1 Webi reports, Teradata Fact Design and batch scripts.
• Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
• Responsible for providing high level design and low-level design deliverables
• Work with Business (as BA) in translating business requirements into Functional Requirements Document and Detailed Design Documents with detailed data mapping.
• Delivery of design documents, test cases, test results, methodologies documents, process documents to be followed by other technical groups.
• Using IBM in-house tools apply methodologies and process for development, testing and implementation.
• Lead the development and support team on technical issues arrives during development, testing, implementation.
• Provide weekly / Monthly metrics for the projects for SCB project management team.
• Attend review meetings with SCB and IBM GEO team as well as business users on a regular basis to gather any changes on the system.
• Provide solution on the reporting system to easier SCB IT team to monitor the new system.
• Provide estimation on any new work item and prepare estimation document.
• Demonstrate new detailed design, solution, implementation plan to SCB IT team.
• Work with QA team to assist on the new system integration testing.
• Provide end-user training on new application and track any changes required through IBM tools.

Environment: Teradata 13.10 used as database, ODI tool 11g used as ETL tool and SAP-BI Business Objects, Dashboard, WEBi, Erwin 8.x, Crystal Reports used for Analytics and reporting.

Confidential

BI Architect

Responsibilities:

• Manage Distribution BI team by providing guidance on the current scope of the project.
• Provide Architectural solution for Distribution side of Legacy data warehouse systems.
• Create Architectural deliverables (B10 - Analytical Specification Document) for proposed data warehouse systems.
• Lead Distribution team on technical and functional level.
• Interact with client business, client IT on a regular basis and update the progress of data warehouse decommission to project management.
• Prepare and review test plan, test cases and results along with team as part of deliverables.
• Participate Data Modeling, Data Mapping discussions and provide inputs as needed.

Environment: Business Objects XI R3, IBM Rational ClearQuest suite, IBM Cognos, Linux, Teradata 13.2, PL/SQL, Informatica 8.6.1, IBM QMS, IBM clear case, IBM Rational portfolio.

Confidential

Data Architect

Responsibilities:

• Responsible for Analysis, design, development, testing and implementation of Business Objects XI R2 Reporting services, Informatica Mappings.
• Provide health check report on a daily basis on the new system.
• Performance metrics compared to existing data and analyze existing data, resolve architectural issues through new design
• Responsible for providing high level design and low-level design
• Work with Business Analyst in translating business requirements into Functional Requirements Document and Detailed Design Documents
• Delivery of design documents, test cases, test results, methodologies documents, process documents to be followed by other technical groups.
• Support ESVC & C3 applications 24x7 with technical team and manage stakeholders by providing weekly updates.
• Using IBM in-house tools apply methodologies and process for development, testing and implementation.
• Maintain the documents and work item with proper version control system using IBM tools
• Lead the development and support team on technical issues arrives during development, testing, implementation.
• Provide weekly / Monthly metrics of the system for Disney IT team to analyze system performance.
• Attend review meetings with Disney IT team as well as business users on a regular basis to gather any changes on the system.
• Provide solution on the reporting system to easier Disney IT team to monitor the new system.
• Provide estimation on any new work item and prepare estimation document.
• Demonstrate new detailed design, solution, implementation plan to Disney IT team.
• Develop POC on new system and demonstrate to business users to apply in various business systems.
• Work with vendor on vendor product issue such as Business Objects and Informatica etc.
• Work with QA team to assist on the new system integration testing.
• Provide end-user training on new application and track any changes required through IBM tools.
• Implement IBM Smarter ADM tools and IBM Cognos.

Environment: Business Objects XI R2, IBM Cognos, Windows 2000 Server, Linux, Oracle 10g, PL/SQL, Informatica 8.6.1, IBM Smarter ADM Tools, IBM QMS, IBM clear case, IBM Rational portfolio.