BI Solution Architect Resume

SUMMARY

Competent Professional with 12+ Years of experience in
Business Intelligence/Data Warehousing, Solution Architecting, Systems Development, Data Analysis, Data Modelling, Data Integration along with expertise in Project Management.
Expertise in Building and Implementing Large programs like Advanced Commercial Banking Systems(ACBS), Consumer Lending replacement, Basel II, Credit approval, Regulatory requirements etc. for Banking and Financial Domains.
Performed enterprise strategic BI DW Assessment and prepared roadmap based on the findings from the assessment process.
Defining and documenting the existing data architecture through gathering of requirements performing reverse engineering; interacting with end users, software developers and database administrators; designing and presenting data architecture to management; modeling the physical and logical data models of existing database structures.
Worked Closely with IT and Business units and translated the business requirements in to technical specifications.
Expertise in Data Analysis and producing Data Requirement Template(DRT), Data Requirement Document (DRD), Functional Design document(FDD), Detailed Design Document (DDD) and review with business for Formal sign off.
Competent in Data integration projects along with expertise in ETL design and development using informatica.
Well versed in Project Management, Project Planning, Estimation, Resource allocation, SOW, Project Approval, EMF, RFP etc.
Designed and implemented various automated solutions for process/performance improvements in data warehouse.
Data quality checks for key data elements and report the findings to business.
Expertise in executing projects related to Basel, Regulatory reporting, Credit risk management, RWA etc.

Business Intelligence Delivery Solutions.
ETL / Data warehousing design Solutions.
Architecture.
Data Analysis.
Data Modelling.
Project Management.
Customer Relationship.

TECHNICAL SKILLS

Skill: Informatica Oracle SQL Server Teradata Greenplum Autosys HPSM MKS Meta Data Repository(MDR) Linux Jira

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

Defining and documenting the existing data architecture through gathering of requirements performing reverse engineering; interacting with end users, software developers and database administrators; designing and presenting data architecture to management; modeling the physical and logical data models of existing database structures.
Worked Closely with IT and Business units and translated the business requirements in to technical specifications.
Creating a framework for data governance and ensuring the data from new system is available for all the downstream consuming from data warehouse .
Design and implementing the Architecture to integrate data from multiple sources in to data warehouse and from there load into data into multiple Data Mart’s as per the business needs .
Working closely with downstream to understand the data requirements and ensuring those are transformed in to the Data Requirement Document (DRD) required for planning phase of project.
Created framework to document the End to end lineage starting from sources to its final landing zone for the existing process.
Data quality checks for key data elements and report the findings to business.
Performed enterprise strategic BI DW Assessment and prepared roadmap based on the findings from the assessment process.
Designed and developed ETL process for integrating the data from different systems and provision the data in data warehouse for downstream consumptions.
Working closely with business units in understanding their objectives and preparing the road map for the achieving the objectives and presenting the same to management for its approval.
Working closely with business to understand on the portfolio’s that are being migrated to new systems and its integration into the existing process.
Educating the business units in adopting the new technologies and process that could benefit and simply the data needs of the bank.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship