Data & Analytics Architect Resume
SUMMARY:
- Chief Data Architect /Manager with over 16 years of experience in offering Data, Analytical and BI technology solutions with very well defined business values.
- Primary goal is to provide strategic vision & tactical directions in Data Management and Analytics at Enterprise Level.
- Great leadership qualities to drive a team size of 20+ and annual budget of $5M to get to tangible business values are the key focus. Core competencies includes
- Strategic Planning, Road Mapping and Execution
- Result Oriented Leadership & Directions, Team building, Problem Solving
- Client/Partner Relations, Revenue driven Customer success management
- Drive operational metrics and insights into global service organization
- Excellent Communication skills - written, verbal - keynote and or elevator pitch
- Leadership on BI, Data Engineering and Analytics Organization
- Expertise in Data Migration/Conversions with Data Architecture Best Practices
- Building Enterprise Data warehouses, Data models and BI following Kimball Approach
- Translate Business requirements in to simple layman’s terms and also to technology team.
- Influence peers, leadership team and stakeholders driving towards results
- Demonstrate deliverables building Proof of concept
- Data Analysis, Data Modeling, Data Mapping, Transformation & Loading
- Technical Leader implementing UI and UX with Traditional & Big Data Eco System
- Business Areas: Supply Chain, OM, Sales, Finance, Marketing, Retail, wholesale, Click stream web analytics, HR and Sales Compensation
- Tableau Trainer, Speaker. Hosting Silicon Valley SMB Tableau user group Events(@svsmbtug)
- Account, Relationship Management with Key Performance Indicators.
TECHNICAL SKILLS:
Data Integration & Management: BODS, BODI, Informatica, Talend, SSIS and PL/SQL
Data sources: SAP R/3, Oracle EBS, SFDC and Custom Built ERP - Rx solutions
Data Modeling: Erwin, ER/Studio and Data Virtuality.
Databases: MSSQL Server, Oracle, DB2, Netezza, Teradata, Redshift and Big Data
Big Data Eco System: Hadoop, Hive, Map Reduce, Spark, Kafka, Sqoop and Oozie.
Programming Languages: Java, JIRA, Python and R statistical Analysis
Presentation Layer: SAP IBP, Tableau, OBIEE, Looker, Business Objects and MicroStrategy
On Premises and Cloud Technologies: AWS - EC2, S3, Redshift, Tableau.
PROFESSIONAL EXPERIENCE:
Confidential
Data & Analytics Architect
Responsibilities:
- Prototyped the solution in Tableau and Looker demonstrated and deployed.
- Designed and developed Redshift and Tableau solution design for Datawarehousing
- Installed and configured Tableau Enterprise and Desk top following best practices
- Understand business requirements and built dashboard visualizations using Tableau.
- Publish Tableau dashboards with optimal performance
- Loaded the aggregate data into Redshift for reporting, dash boarding and ad-hoc analyses, which revealed ways to reduce manual work by 80% and operating cost savings by 20%
- Installed, configured and Data Loads-Kafka, Spark, Hive and Apache Hadoop
- Define and Manage - Data Governance, Policies, Standards and MDM
- Documentation of entire processes and methods for reusability.
Environment: AWS (S3, Talend, Redshift), Kafka, SparkStreaming, Hive, Sqoop, Oozie, Hadoop and Tableau
Confidential
Presentation Architect
Responsibilities:
- Implemented and Documented Tableau Administration best practices
- Created and provided set of custom built usage report in Tableau
- Number of Extracts and Reports were consolidated and tremendous savings in resources
- Trained users on Tableau 9.0 with special features
- Improved Tableau Adoption at various levels of the organization with interactive reports
- Improved Performance on complex Tableau dashboards by SQL query tuning.
Environment: Oracle, Tableau 8.0 and Tableau 9.0, Informatica Powercenter, Visio and OBIEE.
Confidential
Data Architect / Project Manager
Responsibilities:
- Designed and Implemented Architecture framework - Business, Technical and Enterprise Architecture
- Implemented Documented web ex business processes as Data Flow
- Strategic Assistance in defining and understanding Business and Data Flow processes
- Created Data Flows that helped visual understanding of business processes.
- Evaluated various technologies and provided recommendation including Tableau
- Prototyped click stream solution in Tableau demonstrated and deployed.
Environment: Erwin, Red shift, Java, JIRA, Github, SSIS, Informatica Powercenter, Tableau and Hadoop Eco System, Togaf and Zachman Framework processes.
Confidential
IT Project Manager (BI/DW)
Responsibilities:
- Created special dashboards in BusinessObjects for executive decision making.
- Rebuild operational BI KPIs using BOBJ with SLAs met at near 100%..
Environment: Oracle, Informatica, Erwin, SharePoint, Informatica Powercenter, BusinessObjects and Remedy.
Confidential
Data Analyst/ Project Manager
Responsibilities:
Responsibilities:
- Delivered multiple Projects
- Installed and upgraded OBIEE to 11g
- Installed and configured Tableau - Administrated and built UI/UX in Tableau for Adoption.
- Allocation shipment and billing goals and attainment were improved by 50%
Environment: Linux, Oracle, OBIEE11g, Java, Red shift, Tableau, Big Data, Hadoop Eco System
Confidential
Data Architect/Project Manager
Responsibilities:
- Define Develop and Enforce data standards, procedures, guidelines and policies that meet strategic information requirements
- Develop and interpret key performance indicators (KPIs) to measure the effectiveness of data management processes.
- Enforce Data modeling standards and best practices across EDW and NRT layers.
- Installed and configured Tableau - Administrated and built UI/UX in Tableau for Adoption.
Environment: Oracle EBS, Business Objects, Informatica Powercenter, ER Studio, Teradata, Informatica, Java, OBIEE & Tableau.
Confidential
Data Architect
Responsibilities:
- Provided long term strategic vision in Data Management and BI Architecture
- Work closely with solution architects and SMEs to design data & BI services that are scalable and highly available to users.
- Develop and interpret key performance indicators (KPIs) to measure the effectiveness of data management processes.
- Query performance tuning of EDW data which saved the data extraction time by 50%
- Reduced annual expense by 35% through architecture simplification and process optimization
- Enforce Data modeling standards and best practices across EDW and NRT layers.
- Define and Manage - Data Governance, Policies, Standards and MDM
- Installed and configured Tableau - Administrated and built UI/UX in Tableau for Adoption.
Environment: Oracle EBS,Java, Siebel, SAP, Erwin, Informatica Powercenter, Tableau and MS Project
Confidential
Data Architect/Manager
Responsibilities:
- Cross functional team communication to manage multiple projects.
- Developed key performance indicators (KPIs) to measure the effectiveness of Comp data
- Query performance tuning of compdata which reduced the extract completion time by 50%
- Streamlined the Commissions operational process and shorten the monthly pay cycle by 50%.
- Reduced annual expense by 35% through architecture simplification and process optimization
Environment: Oracle DB, DataStage, Java, Oracle ERP, Siebel, SAP, MS Project and SharePoint.