SUMMARY:

• Confidential is an Experienced Senior Big Data Solutions Architect / Advisor with over 20 years data management / consulting experience (3 years in Big Data ) mostly in defining, designing, implementing and maintaining large, complex business intelligence, data warehousing and big data analytical solutions.
• Confidential has extensive expertise in directing, managing and participating in all phases of big data strategy and development, as well as, leveraging his competencies to benefit the BI competencies of both the client and consultants.
• His experiences range from technical leadership, ETL architecture and data architecture to very hands - on and technical implementations.
• He possesses strong analytical and problem-solving skills with proven ability to mentor and provide technical leadership to other team members.
• He has delivered many BI & Big Data Analytical solutions and strategies including diagnostics, roadmaps, strategy initiatives and tools /platform selection, solution implementation.

KNOWLEDGE:

Technologies: Hadoop, HDFS, Cloudera CDH, Hortonworks, Pig, Hive, HBase, Impala, YARN, Flume, Sqoop, Cloudera Manager, Hue, HCatalog, Oozie, Oracle Big Data Appliances, DAC, Oracle, Teradata, SQL Server, Oracle Exadata, Informatica, Ab Initio, ERWin, ER Studio

Functional Expertise: Big Data analytics, Hadoop, Mapreduce, NoSQL, Data warehouse architecture, BI Strategy, ETL Architecture, Data Architecture, Agile Data Warehousing, Data Quality, MDM and Metadata Management.

PROFESSIONAL EXPERIENCE:

Confidential

Big Data Advisor, Solutions Architect & Data Scientist

Responsibilities:

• As a Senior Solutions Architect and Advisor, Confidential is responsible for providing thought leadership, and end-to-end solution architecture & design of medium to large scale data management / analytical solutions to our clients.
• He provides the advanced technical consulting and advice to proposal efforts, platform selections and solution designs.
• Providing and couching programs in Big Data Analytics & Hadoop ecosystem (HDFS, MapReduce, YARN, Hive, Pig, Impala, Sqoop, Flume, Oozie, Machine Learning, etc.)
• Trained over 40 professionals (developers, data scientists, analysts and managers) in Big Data. Helped them in jump start their learning and smooth transition into big data professionals through professional in - depth, hands on workshops and coaching.

Big Data Architect / Consultant

Confidential

Responsibilities:

• Designed strategies and programs to collect, store, analyze and visualize data from various sources.
• Responsible for implementation of complete Hadoop solutions, including data acquisition, storage, transformation, and analysis and a infrastructure planning, scaling, and administration considerations that are unique to Hadoop
• Worked on building architecture to integrate Hadoop with existing DW/ BI infrastructure.
• Lead the initiatives to offload some data warehouse components from Teradata to Hadoop systems for building a scalable, flexible solutions for much lower cost.
• Advised organizations about big data, a big data strategy, the implementation of big data, which technologies best fit the needs of the organization and even implements the selected big data solution
• Worked with data scientists and helped them extract actionable insights from huge amount of data on the Hadoop cluster
• Mentor, consult, collaborate, review and support Engineering teams, data scientists and business users
• Interface and consult with business unit and product management teams to educate them on big data tools and technologies, data structures and help them in producing data products and other analytical solutions.
• Worked with architects, developers and system engineers to define and build creative solutions that will transform evolving-and-immature requirements into deliverable products. Worked with the data scientists and helped build data products using data mining, predictive analytics and machine learning techniques

Technologies: Cloudera CDH, Oracle Big Data Appliances, Impala, Pig, Hive, Flume, Sqoop, Oozie, FUSE, R, Hue

Big Data Architect / Systems administrator

Confidential

Responsibilities:

• Developed Big Data Strategy, architecture, standards and guidelines
• Designed and built scalable solutions to acquire, store, integrate and analyze very large amounts of shopping data and integrate it with transactional data in EDW
• Designed data flow and processing pipelines for ingestion and analysis using Sqoop, Flume, Hive and Pig
• Provided administration supports to hadoop clusters on Oracle Big Data Appliances (Cloudera CDH 4.x / 5.x); accountable for configuring, administering, monitoring and managing Hadoop clusters
• Helped client grow their Hadoop environment from 5 node cluster to 54 node cluster. Managed Hadoop cluster with over 1 PB of data and advised the cpeople on which data to store, analyze and use for what purposes
• Work with vendors (Oracle and Cloudera) and resolve hadoop cluster issue, work on upgrades and patches

Technologies: Cloudera CDH, Oracle Big Data Appliances, Impala, Pig, Hive, Flume, Sqoop, Oozie, FUSE, R, Hue

Data Warehouse Architect on Oracle BI Applications implementation

Confidential

Responsibilities:

• As Solution Architect lead the customization and implementation of Procurement and Spend Analytics (part of Oracle BI Apps) application using Oracle 11g, OBIEE, Informatica, and DAC.
• Customized and Implemented Oracle’s Spend Classification BI App to re-classify expense categories
• Customized OBIA components (data model, ETL and DAC) as per the client’s environment and requirements.
• Performed installations, configuration and system administration of Informatica and DAC components

Technologies: Oracle 11G, Exadata,, OBIEE, Informatica, DAC, PeopleSoft

ETL Architect

Confidential

Responsibilities:

• Analyzed the current architecture and design to determine needed improvements including optimization and tuning of data loads and recommended appropriate optimizations and improvement techniques.
• Evaluated Hadoop related tools and technologies (HDFS, Hive, Pig, HBase) for Big Data Analytics
• Managed, Lead and mentored a team of 4-6 ETL Developers (mostly offshore)
• Architected, designed and implemented end to end ETL solutions to extract and integrate the data from variety of sources and loaded Hadoop environment for data processing and data discovery and then loaded EDW.

Technologies: SQL Server 2008, Informatica Power center, SAP, Oracle, Hadoop, HBase, Hive, Pig

Confidential

Senior Architect / Senior Manager

Responsibilities:

• Developed standards and guidelines for data acquisition, data modeling and ETL; Implemented logical and physical models for all layers of the data warehouse data model; Designed multi-dimensional (star) data structures to support current and future business requirements

Technologies: SAP R3 / BW, SQL Server 2008, Erwin, Business Objects Data Services

ETL / Informatica Architect

Confidential

Responsibilities:

• Implemented and customized Oracle’s OBIEE Service Analytics module
• Developed scalable, reusable ETL jobs utilizing the Informatica toolset ensuring data integrity and proper data transformations, integrating data from various sources to load data into the target data structures
• Developed and administered Informatica Repository, Mappings, Sessions, and Workflows.

Technologies: Oracle, OBIEE, DAC, Informatica Power Center, ERWin, Quality Center

EDW Architect

Confidential

Responsibilities:

• Provided technical leadership for EDW team and helped defining the EDW best practices and roadmaps.
• Responsible for identifying tools and technologies for EDW, defining technical and data architecture, data sourcing strategies, and high level ETL design
• Developed various frame works, templates and standards.

Technologies: AIX, DB2, Teradata, Informatica ETL Software, CA ERWin, MS Visio

Technical Architect

Confidential

Responsibilities:

• Performed assessment of the current DW/BI environment and played a key role in defining BI future vision and multi-year BI roadmap and presented the findings to the senior management. Provided technical leadership in defining BI architecture and best practices and establishing the technical strategy and presented the strategy, architecture and roadmap to the senior management. Lead the team in ETL tool evaluation / selection process as well as evaluation / selection process of industry standard data model.

Technologies: AIX, UDB / ADW, Teradata, Informatica ETL Software, CA ERWin, MS Visio