Bi Architect / Project Manager Resume
SUMMARY:
- IT professional with focus on Business Intelligence, Data Warehouse and Bigdata analytics.
- Experienced in architecting and delivering end to end BI Solutions on - premise & Cloud.
- Strong technical knowledge with excellent leadership, analytic and communication skills.
SPECIALTIES:
- Pre-sales activities and proof-of-concept implementations
- Requirements gathering, specification documents, functional/technical design, Data modelling & solution architecture
- Implementation, delivery and support of data warehousing and business intelligence projects
- Team leadership and project management
KEY SKILLS:
Functional: Project Management, BI Solution Architecture, Pre-Sales, Team Leader, Business Analysis
Technical: Big data analytics (HDFS, Hive, Sqoop, Spark), AWS Services ( S3, EC2, EMR & Redshift), Data Modelling (Dimensional)
Database: GreenPlum, Oracle, Teradata, Redshift
ETL Tools: Talend, SAP BODS, Informatica, GP Functions
Reporting Tools: SAP BO, Cognos
Visualization Tools: Tableau, Confidential, Spotfire, Sisense
PROFESSIONAL EXPERIENCE:
Confidential
BI Architect / Project Manager
Responsibilities:
- Responsibility (Reflect on the proprietary Tools /methodologies used)
- Requirement gathering
- Estimation & Project Plan
- Scrum Master for dev projects
- RTS Lead /On site On call
- Data Model Design
- ETL Design
- Building reusable template
- GreenPlum functions for loading
- Talend Jobs for scheduling
- Shell scripts for control & execution
- Confidential /Tableau report templates
- Defining coding Standards
- Review of deliverables
- Preparing and sending status report
Confidential
Project: Architect/ Design & developer
Tech: Redshift, Confidential, BO, shell script
Responsibilities:
- Designed and developed Confidential data sources to capture data from various data sources and creating Redshift ETL jobs to load target data
- Creating Confidential visualization using datasets created in above steps
- Dev cloud Migration
- CIO initiative to lower operations cost of dev/QA environment by moving applications to Cloud environment
ETL Architect & Admin
Confidential
Tech: SAP BODS, Linux
Responsibilities:
- Installation and configuration of SAP BODS on AWS EC2 servers and establishing connectivity with various data sources
Confidential
Scrum Master/ ETL Architect / GreenPlum Functions developer
Tech: Greenplum, Talend, Tableau
Responsibilities:
- Data Model design for reporting requirements using dimension modelling techniques
- Developed Greenplum functions for loading target tables from Mirror tables in Greenplum DB.
- Developed Talend jobs to pull data from different sources to load data in Greenplum mirror layer
Confidential
Project Lead
Responsibilities:
- Requirement gathering
- Data Model Design
- ETL Design
- Coordinate development activities
- Review of deliverables
- Preparing and sending status report
Hardware: Unix, PL SQL developer, MS Office
Confidential
Project Lead
Responsibilities:
- Requirement gathering
- ETL Design
- Development activities
- Review of deliverables
- Preparing and sending status report
Software: Unix, PL SQL developer, MS Office
Confidential
Onsite Coordinator & Project Lead
Responsibilities:
- Requirement gathering
- Preparing Macro document
- Data Model Design
- ETL Design
- Coordinate development activities
- Review of deliverables
- Preparing and sending status report
Software: Unix, Sql Assistant, MS office