SUMMARY:

• Proficient in Big data/Hadoop/ Data Warehousing/Data Integration/Master Data Management, Data Migration and Operational Data Store, BI Reporting projects with a deep focus in design, development and deployment of BI and data solutions using custom, open source and off the shelf BI tools.
• Specialized in delivery of data and BI projects for various business groups and proven track record of executing BI and Data Projects end to end.
• Proficient in architecture, design, project management, planning and execution.
• Actively involved in various EDW project life cycle which involves architecture, design, modeling, develop & maintenance activities of large and complex Enterprise Data Warehouse and Reporting BI applications.
• Experience in implementing enterprise level applications and platforms across domains like Retail, Banking & Finance, Customer Support systems, High Tech manufacturing, Health, Social Media & Health & Fitness.
• Extensive hands on expertise on BI & ETL tools like IBM Information Server Suite Data Stage V 7.5.1(PX), Informatica Power Center V6.5/V 8.0/V9.1,OBAW,Talend Data Integration, Informatica Bigdata Edition, Informatica Vibe, SAP BW, ODI, Pentaho, Custom applications.
• Experience with Talend latest versions project implementation, TAS and TOS, Migration projects.
• Extensive experience in designing Analytical Data Marts using OBIEE, Micro Strategy, Business Objects, Hyperion Essbase 9, Oracle BI Apps and Tableau.
• Experience in extracting data from heterogeneous sources like SQL server, ORACLE, DB2, and Teradata.
• Proficiency on DBMS technologies on Teradata v12/13, Oracle V 8i/9i/10g/11g, DB2 V9, MySQL 5.6
• Effective skills in planning, coordination, and execution of system applications and engineering projects.
• Experience in design, development and implementation of end - to-end software cycles.
• Experienced in writing system specifications, translating user requirements to technical specifications
• Expert in Hadoop and Big Data Technologies.
• Thorough knowledge of Data modelling and MDM.
• Business gap analysis and solution oriented approach.
• Experienced in building teams in On-site/Offshore model,
• BI Product upgrades, setup, installation and configurations,
• Excellent Leadership skills.
• Passionate about new technologies.
• BI tools & Products evaluation & analysis Technology Horizon
• Worked in Agile environment and sprints.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant/ Architect

• Responsible for assessing, data and BI requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse and for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort.
• Leading a team of developers both onsite and offshore for data integration and data reporting requirements.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Implementation of big data pipe line, hive jobs, pig jobs on Hadoop clusters.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Managing and delivered various technical projects for different business groups like call center, manufacturing, sales, CRM etc.
• Solution architecture for various Business intelligence systems.
• Managing the system support and stability of the BI applications.
• Drive new technological solutions to support data and catering to different business needs. Delivering complex data integration and reporting projects to support various business needs.
• Hands on design, architecture and development of various Data warehouse system integration, platform development and BI reporting solutions.
• Solution architecture for various Business intelligence systems.
• Managing the system support and stability of the BI applications.
• Drive new technological solutions to support data and catering to different business needs.
• Implemented various technologies like data integration, data consuming platforms, B2B applications, consumer facing applications and reporting applications.
• Leading team of developers both onsite and offshore for data integration and data reporting requirements.
• Design and development of complete Data warehouse and system data integration, platform development and BI reporting solutions.
• Implementations on AWS Cloud solutions for Big data stack.
• Hands on experience with scalable solutions on DW, BI platforms using AWS Redshift, Oracle, MySQL, Informatica, Talend DI, Tableau, SSIS, SQL Server.
• Define key business drivers for the data warehouse initiative
• Deliver a project scope that directly supports the key business drivers
• Supporting the different business user groups for various BI reporting requirements in Agile and Traditional Data warehousing methodologies.
• Define, Design and Build the overall data warehouse architecture using Informatica, Oracle and Teradata for ETL and Business Objects/Tableau for reporting.
• Define technical requirements, technical and data architectures for the data warehouse
• Managing production support related activities with the support team.

Confidential, CA

Consultant/ Architect

• Responsible for assessing, data and BI requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse and for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort.
• Leading a team of developers both onsite and offshore for data integration and data reporting requirements.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Implementation of big data pipe line, hive jobs, pig jobs on Hadoop clusters.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Managing and delivered various technical projects for different business groups like call center, manufacturing, sales, CRM etc.
• Solution architecture for various Business intelligence systems.
• Managing the system support and stability of the BI applications.
• Drive new technological solutions to support data and catering to different business needs. Delivering complex data integration and reporting projects to support various business needs.
• Hands on design, architecture and development of various Data warehouse system integration, platform development and BI reporting solutions.
• Solution architecture for various Business intelligence systems.
• Managing the system support and stability of the BI applications.
• Drive new technological solutions to support data and catering to different business needs.
• Implemented various technologies like data integration, data consuming platforms, B2B applications, consumer facing applications and reporting applications.
• Leading team of developers both onsite and offshore for data integration and data reporting requirements.
• Design and development of complete Data warehouse and system data integration, platform development and BI reporting solutions.
• Implementations on AWS Cloud solutions for Big data stack.
• Hands on experience with scalable solutions on DW, BI platforms using AWS Redshift, Oracle, MySQL, Informatica, Talend DI, Tableau, SSIS, SQL Server.
• Define key business drivers for the data warehouse initiative
• Deliver a project scope that directly supports the key business drivers
• Supporting the different business user groups for various BI reporting requirements in Agile and Traditional Data warehousing methodologies.
• Define, Design and Build the overall data warehouse architecture using Informatica, Oracle and Teradata for ETL and Business Objects/Tableau for reporting.
• Define technical requirements, technical and data architectures for the data warehouse
• Managing production support related activities with the support team.

Confidential, CA

Consultant/Data Engineer/Data Architect

• Responsible for assessing Applications, data and BI requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse and for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased Big data applications and data warehouse effort.
• Hands on experience with scalable solutions on DW, BI platforms using AWS Redshift, Oracle, MySQL, Talend DI, Java, Tableau, Amazon S3.
• Involved and ingesting different types of the data streams to the Data lake like click stream data and web log data ingestion.
• Implementation of Data lake architecture to support the different products and business analytics needs.
• Managing the data architecture, file system storage and maintenance of Hadoop clusters.
• Hands on with Hadoop administration, security and management of the clusters.
• Responsible for delivering end to end data products, business analytics applications and product engagement apps.
• Managing end to end technical delivery of data products and projects.

Confidential, CA

Data Architect | Lead Data Engineer

• Responsible for assessing Big data, data and BI requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse and for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Experience with Talend latest versions project implementation, TAS and TOS, Migration projects.
• Hands on experience with scalable solutions on BI data and reporting solution platforms using AWS, Informatica, Amazon S3, Redshift, OWB, ODI, Oralce, MySQL,Tableau etc.
• Hands on design, architecture and development of various Data warehouse system integration, platform development and BI reporting solutions.
• Solution architecture for various platforms, Data integration, Data warehouse and analytics platforms and applications.
• Leading a team of developers both onsite and offshore for data integration and data reporting requirements.
• Define key business drivers for the data integration and data warehouse initiatives.
• Involved in defining the technical stack for the big data and traditional data ware house platforms.
• Deliver a project scope that directly supports the key business drivers
• Supporting the different business user groups for various BI reporting requirements in Agile and Traditional Data warehousing methodologies.
• Define, Design and Build the overall data warehouse architecture using Informatica, Oracle, Oracle Warehouse Builder, Mysql for ETL and OBIEE/Tableau for reporting.
• Define technical requirements, technical and data architectures for the data warehouse
• Recommend/select data warehouse technologies (e.g., ETL, DBMS, Data Quality, BI)
• Design and develop the ETL process, including data quality and testing
• Developing the ETL process integrating with the source systems, staging areas, Presentation layer (BI layer) for BI projects and reporting requirements.
• Design and direct the information access and delivery effort for the data warehouse
• Define and develop the implementation of security requirements for the data warehouse
• In detail in development cycle designing the ETL processes using Oracle, setting up Informatica workflows/mappings/sessions as per the interface requirements for processing data on to the EDW area.
• Implementation of Tableau reporting at enterprise level.
• Managing end to end delivery of data products and projects.

Confidential, CA

Technical Architect | Technical Lead

• Responsible for assessing data and BI requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse and for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort.
• Leading a team of developers both onsite and offshore for data integration and data reporting requirements.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Implementation of big data pipe line, hive jobs, pig jobs on Hadoop clusters.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Managing and delivered various technical projects for different business groups like call center, manufacturing, sales, CRM etc.
• Leading team of developers both onsite and offshore for data integration and data reporting requirements.
• Design and development of complete Data warehouse and system data integration, platform development and BI reporting solutions.
• Solution architecture for various Business intelligence systems.
• Managing the system support and stability of the BI applications.
• Drive new technological solutions to support data and catering to different business needs. Delivering complex data integration and reporting projects to support various business needs.
• Hands on design, architecture and development of various Data warehouse system integration, platform development and BI reporting solutions.
• Solution architecture for various Business intelligence systems.
• Managing the system support and stability of the BI applications.
• Drive new technological solutions to support data and catering to different business needs.
• Implemented various technologies like data integration, data consuming platforms, B2B applications, consumer facing applications and reporting applications.
• Define key business drivers for the data warehouse initiative
• Deliver a project scope that directly supports the key business drivers
• Supporting the different business user groups for various BI reporting requirements in Agile and Traditional Data warehousing methodologies.
• Define, Design and Build the overall data warehouse architecture using Informatica, Oracle and Teradata for ETL and Business Objects/Tableau for reporting.
• Define technical requirements, technical and data architectures for the data warehouse
• Managing production support related activities with the support team.
• Define metadata standards for the data warehouse.
• Direct the data warehouse meta data capture and access effort.
• Define production release requirements and sustainment architecture.
• Post Production Warranty support for the systems that have been implemented.

Confidential, AZ

Technical Architect/ Tech lead

• Responsible for assessing data and BI requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse and for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort.
• Architecting, managing and delivering the technical projects /products for various business groups.
• Hands on experience with scalable solutions data and reporting solution platforms, IBM Bigdata Edition, MicroStrategy, DB2 and Unix etc.
• Managing and lead a technical team of around 10 people both onsite and offshore members.
• Leading team of developers for technical delivery of projects.
• Design, architect and develop various data integration and reporting projects which varies from medium to complex in nature.
• Providing solution architecture for various Data warehouse and Business intelligence systems.
• Maintain system support and stability of the BI applications.
• Drive new technological solutions to support data and catering to different business needs.
• Delivering complex data integration and reporting projects to support various business needs
• Serving as a Senior DW ETL Architect/Lead in defining, developing, and enhancing custom DW/BI system
• Primary responsibilities include but not limited to coordinating, planning, and conducting interviews with various business users in identifying and capturing business requirements.
• Defining and developing project scope/plan, creating and developing Enterprise wide Data warehouse and multi-dimensional Datamart data models.
• Designed, Developed and implemented complex data models for large enterprise data like Merchant Credit Card system, Card member data reporting and analytics solutions.
• Mainly involved in architecting the project right from the initial design phase, existing reporting system migration to the new proposed systems, building the ETL integration part, Staging layer and BI layer for reporting solutions.
• Designed and Developed the EDW Model which has 13 subject areas and data marts for Supporting various needs of the business using DB2, Data stage, Control M and Micro strategy
• Designing data profiling strategies for improving the source data quality that is being loaded to the EDW systems.
• Supported the production support teams during the pre-and post-warranty of the BI reporting projects on time in resolving production failures or issues.
• Proposed and maintained performance tuning improvements to the ETL processes, reporting solutions in attaining the optimal performance or meeting the SLA requirements of the business.
• Training business users in how to navigate through the environment, creating and accessing reports.

Confidential

Sr. Software Engineer | Lead

• Lead a team of people for various data projects.
• Implemented enterprise level data integration and data warehouse projects.
• Design, architect and development various data integration and reporting projects which varies from medium to complex in nature.
• Solution architecture for various Business intelligence systems.
• Manage system support and stability of the BI applications.
• Lead and involved technical development team in construction of ETL, BI solutions and Data warehousing implementations.
• Interacting with the project stakeholders, technical teams, source systems involved in the project life cycle
• Designed data marts employing Kimball’s Dimensional Modeling methodologies
• Designed, developed, implemented the REDW and DataMart’s for Enterprise wide financial credit systems using IBM Information Server Data stage, Informatica, Siebel OBIEE Suite, Oracle and DAC.
• Gathered the requirements, completed the proof of concept, designed, developed and tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Implemented the Guest CRM Applications integration to EDW for enabling reporting solutions using Datastage, Control M and DB2 Etc.
• Majorly involved in Informatica Mappings, Workflows, jobs for complete ETL interfaces and BI reporting products.
• Designed, created and tested reports, dashboards and created ad-hoc report according to the client needs
• Designed, Developed and Tested Data security and Dashboard security in OBIEE
• Worked with Data Governance board on developing roles, tasks, processes, standards, etc.
• Involved in development of huge and enterprise wide data warehouse implementations for Target Financial services and Target Guest systems.
• Implemented OBIEE for Development, QA and Production environments.
• Track the project efficiently with constants updates on the progress and hurdles, focusing on the overall deliverables.
• Production support systems in support of warranty pre and post production implemented projects.

Confidential

Software Engineer

• Design and development of complete DW and data system integration, platform development and BI reporting solutions.
• Implemented enterprise level data integration and data warehouse projects.
• Interacting with the project stakeholders, technical teams, source systems involved in the project life cycle
• Designed data marts employing Kimball’s Dimensional Modeling methodologies
• Gathered the requirements, completed the proof of concept, designed, developed and tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Designed, developed and implemented the REDW and DataMart’s for systems using Informatica, Siebel and Oracle.