Business Intelligence & Analytics Manager/Architect

Work Experience

• 7 Years of Experience in the Data Warehousing & Business Intelligence Technologies.
• Currently working as a Data Architect in Blackhawk Network.
• Played Key role in Managing and Designing Business Intelligence and Data Warehousing systems for various multinational companies like HP, GM, Wal-Mart, DFS and Hutch
• Result - Focused and Effectual Leader with proven ability to turnaround projects at risks
• Experienced in managing and coordinating various cross functional business & technical teams
• Skilled in preparing the project master plan and calibrating the plan over the course of the project
• Experienced in managing Project Roadmap, Budget & Purchase Orders
• Experienced in designing and developing efficient BI Systems using MicroStrategy
• Experienced in developing both server jobs and parallel jobs in DataStage
• Excellent skills in fine tuning DataStage jobs
• Expert in IBM InfoSphere DataStage and QualityStage
• Excellent skills in partnering with the business to understand business strategies and objectives
• Excellent skills in converting business requirements in to a robust technical designs
• Experienced in designing and implementing robust ETL and BI systems
• Experience in defining BI Vision & Roadmap for various business functions
• Good flair in learning new technologies and concepts, with proven track record for meeting objectives and deadlines with high quality
• Contributed towards building technical competency in the practice by conducting trainings and taking part in recruitment process.
• Experienced in mentoring and training teams for the data warehousing projects
• Excellent skills in handling training session on Data Warehousing technologies.
• Won many awards and appreciations for the quality of the deliverables and for taking additional responsibilities, while working in projects
• Successful in implementing strategic processes improvements in the projects
• Good Knowledge of Retail, Payment and Telecom Domain

Certifications

• IBM Certified Solution Developer - InfoSphere DataStage v8.0
• Cognizant Certified Professional in Data Warehousing.
• BRAINBENCH Certified in Data Warehousing Concepts
• BRAINBENCH Certified in OLAP
• BRAINBENCH Certified in RDBMS Concepts
• BRAINBENCH Certified in Data Modeling Concepts

IT Literacy

• BI, ETL and DW Tools: IBM InfoSphere Information Server (DataStage & QualityStage), Microstrategy, business Objects, Pentaho, Talend Data Profiler, QualityStage, Information analyzer, Change Data Capture
• Database: Informix Red Brick 6.1, Oracle 10g, DB2, Teradata

Professional Summary

Confidential
Pleasanton, CA
Data Architect Dec 2010 - Till Date

Key Responsibilities

• Define Enterprise Data Management and ETL Strategies
• Define Enterprise Business Intelligence and Reporting Roadmap
• Product owner for the Enterprise Data Warehouse and Operational Data Store Systems
• Manage the requirements from user of various departments and educate them on enhancements in the platform
• Work with the Directors to defining and prioritize the technology project backlog
• Work with the PMO organization for project budgeting needs
• Plan the resourcing needs and timelines of multiple projects and manage the engineering team in the development and enhancement projects
• Coordinate with multiple vendors for product evaluation and project execution

Key Results

• Adopt Scrum methodology for the Development projects in EDW & ODS
• Designed a robust near real time ODS Database, ETL and Reporting system and successfully completed the development in time with high degree of customer satisfaction
• Redesigned the EDW system to bring down the load time and increase the system availability and effectiveness
• Established a stable communication channel with the software vendors to communicate the challenges and get information on new features, recommendations and benchmarks

Tools & Technologies Used
Rally Agile Project Management, IBM InfoSphere Information Server v8.2, MicroStrategy 9.2, IBM Smart Analytical System, IBM Change Data Capture, Erwin 7.3

Confidential
Aliso Viejo, CA
Associate Consultant Apr 2010 - Dec 2010

Key Responsibilities

• Worked as a Technical consultant for multiple clients of UST Global
• Worked closely with Sales and Business Development team in Presales
• Worked on RFPs and Unsolicited proposals for Data Intelligence group
• Partnered with IT leaderships of the clients for project & resource planning
• Define Enterprise Data Management and ETL Strategies for various large clients like Safeway and Wal-Mart
• Define Enterprise Business Intelligence and Reporting Roadmap for various clients
• Organized trainings to groom in-house BI/DW technical capabilities
• Visited client sites to understand the technical challenges and provide solutions and manage projects
• Managed multiple projects with Onsite - Offshore model

Key Results

• Directly involved in winning Projects/Staff-Aug engagements worth more than $500K revenue
• Stepped into manage projects at risk and delivered the projects successfully, which helped to sustain the client engagements in more than one instances
• Trained and groomed a team of fresh graduates on Data Warehousing and Business Intelligence technologies and deployed them on projects

Tools & Technologies Used
MS Project Professional 2010 , IBM InfoSphere Information Server v8.2, MicroStrategy 9.2, IBM Smart Analytical System, IBM Information Analyzer, DataStage 7.5, MicroStegy 8.1, Teradata, OBIEE 10g, Pentaho BI Suite

Systems Analyst Mar 2008 - Mar 2010

Key Responsibilities

• Managed multiple team on Data Warehousing and Business Intelligence projects
• Worked as a Technical consultant for multiple clients of UST Global
• Partnered with IT leaderships of the clients for project & resource planning
• Designed robust and effective BI & ETL systems for multiple clients
• Organized trainings to groom in-house BI/DW technical capabilities
• Visited client sites to understand the technical challenges and provide solutions and manage projects
• Managed multiple projects with Onsite - Offshore model

Key Results

• Build a ETL and BI team from ground up, maintaining morale throughout challenging periods requiring extra tasks from limited number of employees
• Set up an Offshore - Onsite model for a new client from scratch for the development, maintenance and support their enterprise data warehouse and business intelligence system

Tools & Technologies Used
MS Project Professional 2007 , IBM InfoSphere Information Server v8.0, MicroStrategy 9.2, IBM Smart Analytical System, IBM Information Analyzer, DataStage 7.5, MicroStegy 8.1, Teradata, OBIEE 10g, Pentaho BI Suite, Erwin 7.3

Confidential
Bangalore, India
Senior Software Engineer Sep 2007 - Mar 2008

Key Responsibilities

• Worked as a Business Intelligence and Data Warehousing consultant for multiple clients
• Partnered with IT leaderships of the clients for setting up offshore teams
• Visited client sites to understand the technical challenges and provide solutions and manage projects
• Identified the infrastructure requirements for the seamless onsite - offshore model and worked closely with the network and IT team in establishing the connectivity and installing all the software required
• Evaluated the Open source BI and ETL tools available in the market by doing POC and submitted the results to the client

Key Results

• Established the onsite - offshore model of development for McDonald's Data Warehousing development
• Completed proof of concepts for evaluating the open source BI and ETL tools with proprietary software for GE Fleets

Tools & Technologies Used
MS Project Professional 2003, DB2 8.0 , DataStage 7.5, Business Objects 6.5, Business Objects XI, Teradata, Pentaho BI Suite

Confidential
Bangalore, India
Software Engineer June 2006 - Sep 2007

Key Responsibilities

• Worked as a Business Intelligence and Data Warehousing Developer for multiple clients
• Visited client sites to understand the technical challenges and develop ETL and BI systems
• Worked on projects to redesign the ETL and Data warehouse of the client to improve effectiveness of the system
• Worked closely with BI team to develop ETL for complex reports so that the reports performance SLA of the clients are achieved
• Worked on projects to redesign ETL to add more cleansing rules and process checks required for the business data quality
• Involved in the data profiling and data modeling while building new data warehouse systems
• Played the role of a mentor for a batch of fresh graduates and Trained them on data warehousing technologies, while working in project

Key Results

• Worked in multiple Data warehousing and Business Intelligence projects for renowned clients like General Motors and Hutch telecom
• Effectively redesigned the ETL system for a client to bring down the load window by more than 50%.
• Worked with multiregional clients and successfully completed the projects with complete customer satisfaction

Tools & Technologies Used
DataStage 7.5, Business Objects 6.5, Business Objects XI, Oracle 10g, Informatica 8.0

Confidential
Bangalore, India
Programmer Analyst Jan 2005 - June 2006

Key Responsibilities

• Worked as a Business Intelligence and Data Warehousing Developer for multiple clients
• Joined as a fresh graduate and learnt the BI and ETL tools and started delivering in projects
• Acquired retail domain knowledge and became more productive in the project for the clients
• Involved in other technical activities outside the project work to improve the technical capability of the team and create value adding tools

Key Results

• Involved in the completed lifecycle of 4 major projects for the BIDW practice
• Acquired technical knowledge on DataStage, Informatica, Eureka Strategy, MicroStrategy, Oracle DB and Redbrick DB
• Successfully completed the internal Data Warehousing certification program with 90% marks
• Worked in large Data Warehousing projects for renowned clients like Duty Free Shop (DFS Galleria) and MCI telecom.

Tools & Technologies Used
DataStage 7.0, DataStage 6.0, DataStage5.5, Business Objects 6.5, MicroStrategy 7, Eureka Strategy, Oracle 10g, Informatica 7, Redbrick

Academic Review

• Bachelor of Engineering (Computer Science) 2004