SUMMARY:

Over 14 years of IT experience in software analysis, design, development, maintenance for various domains and providing Business Intelligence solutions in Data Warehousing for Decision Support Systems with Agile and non - agile methodologies including and using Vertica Analytic DB, Teradata, Oracle, Greenplum, Hive, Impala and ETL tools like Informatica, DataStage, MSIIS, Spark, Sqoop, DTS and OLAP application development using Tableau, Business Objects, OBIEE and MS OLAP Services. Specialist in Data modeling, DW, Big data and ETL Architecture.

COMPETENCIES:

• Informatica8.x,9.x,10
• TeradataV2R5,12,13
• SQL Server
• ERWin
• Business Objects5.x,6.x
• Data Modeling
• Clear Case
• Hive
• HDFS
• Datastage7.x,8.x
• Oracle9i,11g
• Vertica5.x,7.x
• Linux
• Tableau
• Autosys
• Jenkins
• Impala
• Spark
• SSIS (MS BI)
• Talend
• GreenPlum
• Shell Scripting
• DW Architecture
• Tivoli
• Agile(Mingle)
• Sqoop
• Python

EXPERIENCE:

Confidential

Integration Lead

Environment: Talend BDI 6.3, Salesforce, HDFS, Hive, Impala, Sqoop, Spark, Linux and Python.

Responsibilities:

• Understanding the current Citi retail and sales business model, technologies and requirements.
• Extensively working on Salesforce data Migration design and development using Talend ETL (BDI/DI).
• Design and development of WORM compliance framework for better data integrity.
• Design the integration of sales data from Salesforce and HDFS into DMS for better analysis and distribution of data.
• Helping the team in completing technical POC/solutions with different Bigdata ecosystem tools.

Confidential

ETL Architect

Environment: Informatica PC Adv 10, DB2, Linux and windows, Pega-BPM,Erwin data modeler.

Responsibilities:

• Understanding the current Confidential business model, technologies and requirements.
• Creating ETL architecture in canonical model to integrate As-Is systems and To-Be(Pega-BPM) system and newly created Databases.
• Designing ETL frameworks for better data migration (from Mainframes and Pega) and systems integration with reusability.
• Estimation of complete ETL integration w.r.t resources and timelines.

Confidential

Data Modeler

Environment: MS SQL server 2014, Erwin data modeler.

Responsibilities:

• Understanding the current CAS business model and requirements.
• Creating Logical Data Model and Physical Data Model (OLTP & OLAP) using ERwin data modeler for CAS.
• Support the CAS development team during “CAS Nurse Call Administration” Application development.

Confidential

DW Designer & Vertica DBA

Environment: Talend Platform for Big Data Management, Vertica, Job Scheduler, TAC, AWS S3 Cloud, HDFS, Pig, Hive, UNIX, Python.

Responsibilities:

• Understanding the business process and analyzing the data for designing better solutions with ETL and Reporting systems with Vertica Analytics and Big data ecosystem tools.
• As a lead designer, designed and developed Talend Jobs using different components to fulfill business requirements.
• As a designer, converted business requirements into Technical requirements and created mappings specifications.
• Vertica Database Schema design to store and retrieve huge volumes of customer data from different source systems like legacy SQL, MongoDB, HDFS, with different security levels.
• Supporting Vertica Users and developers to full fill their development activities and business queries as Vertica Lead and support as DBA.
• Managing DB Clusters and Nodes and day to day monitoring of all databases across environments.
• Maintaining DB Statistics and DBD activities for query and load performance.
• Creating and maintaining Super and Custom Projections for better query and reporting performance at ETL/ELT and reporting layers.
• Creating and loading data into Vertica Flex tables to read and transform unstructured data from JSON files.
• Training development and QA teams with Vertica to support their day to day activities.
• Supporting other analytical queries from data lakes for Pig and Hive.

Confidential

ETL Architect & Lead Consultant

Environment: Informatica9.5.0, UNIX, Oracle11g, Autosys

Responsibilities:

• Understanding the business process and analyzing the data for designing better and low cost communication channel between BR (clients) and its clients.
• Designed and developed Informatica mappings using different transformations to fulfill business requirements.
• Database Schema design to store and retrieve huge volumes of customer data, with different security levels.

Confidential

ETL Architect & Lead Consultant

Environment: Informatica9.5.0, UNIX, Python, Greenplum DB, Autosys

Responsibilities:

• Designing TaxPreProcessor ETL Architecture.
• Physical Data Modeling on Greenplum DB and Oracle DB.
• Converting functional requirements into technical designs documents for developer’s understanding.
• Creating mapping templates and mappings using Informatica Mapping Architect for visio and PC designer.
• Data validations for Business and Non-Business logics and reconciliation.
• Design and development of mappings for Beta to Standard Layouts, to GP DB tables and to external tables.

Confidential

Sr. Consultant

Environment: Informatica9.5.0, UNIX, Oracle, Netezza, Teradata

Responsibilities:

• Part of Coventry POC, analysed existing Oracle SPs and converted them into Informatica solution.
• Teradata training deck preparation as part of skill building program.

Confidential

Sr. Consultant

Environment: Vertica, Tableau, Pentaho Kettle, UNIX, Bryte, BigData Ecosystem

Responsibilities:

• As a Pre-Sales Consultant lead number of Proof of Concepts (POC) with the main focus on Vertica Analytic Database. POCs include MTS Telecom, ECI Telecom for Vodafone India, TRUE Mobile in Thailand.
• Vertica Technical workshop with Happiest Minds walking them through Vertica key capabilities and comparison with Teradata.
• Supported the Vertica POC with the integration and testing of client’s technical environment various other clients.
• Done POCs and given integration solutions on Vertica, HDFS and Hive.

Confidential

Technical Leader

Environment: Datastage V8.5, Teradata 13, UNIX, Windows XP, Tivoli, Clear Case, Oracle10g

Responsibilities:

• Source systems Analysis, tech design, leading the team, platform migration from ‘Oracle-Datastage’ flat form to Teradata-Datastage, conversion of Oracle Packages and procedures to Teradata Procedures and BTEQs
• Handled offshore to deliver (Development, UT, SIT and UAT support) Pre-Rainbow implementation for Russia. Delivery of EDW rollout for CEMEA.

Confidential

Sr. Technical Consultant

Environment: MS SQL Server technologies

Responsibilities:

• Understanding the business process and identifying complexities in existing source system.
• Building the DW model to solve existing complexities and to model information stars.
• Designing Logical and physical models.
• Designing the ETL architecture.

Confidential, Philippines

Technical Consultant

Environment: Informatica9.x, UNIX, Teradata, Green-plum

Responsibilities:

• Supporting POC activities for Thai AirLines to propose EDW platform on Teradata and Informatica as ETL tool.
• Supporting POC activities for SMART Telecom - PH, Disaster Management and Data migration from Teradata to Green-plum DB.

Confidential

EDW Consultant

Environment: Windows XP Professional, Red Hat Linux, Teradata V2R6, Oracle9i/10g, Mainframes, Informatica PowerCenter8.5.1, Teradata Utilities8.2, Erwin7.1, Perl, C, AWK

Responsibilities:

• Early Data Inventory (EDI), ETL design, Physical data modeling on Teradata DW.
• Leading ETL team, Informatica administration and assigning tasks and continues technical support to technical consultants and developers.
• Data Profiling using SQL Assistant and Teradata warehouse Miner.
• Source Data Mapping, Informatica mapping templates, mappings, sessions, workflows. And Informatica integration with Bteq, FastLoad, MultiLoad, TPump and FastExport.
• Performance tuning, Designed and developed statistics collection utility using Teradata SPs and Informatica.
• Scheduling scripts using shell, versioning using Oracle-SCM.