SUMMARY

• With over 8 years of experience in Information Technology, currently working as ETL/Hadoop developer. Involved in architecting, consulting and providing software solutions to businesses across various domains including clients such as New York Times, Confidential & Confidential, TIAA - CREF, HISNA, Confidential Capital.
• Cloudera Certified Apache Hadoop Developer (CCDH -410)
• Areas of interests include: Distributed computing, Customer Insights, e-Commerce, Trend analysis, Sentimental analytics, Data Mining, Cloud Computing, Functional and Technical evaluations of New Products.
• Close to 2 years of experience exclusively on Hadoop Eco-System viz., HDFS, MapReduce, Hive, Pig, Flume, Oozie, Impala and Sqoop.
• Architecting and configuring Cloudera Manager as a single-node and multi-node Hadoop cluster (CDH4/CDH5/EC2/EMR) which also includes setting up Hadoop cluster on AWS-EC2/S3.
• Hands on experience on Various NoSQL databases such as Hbase and MongoDB.
• Vast experience on ETL Architecture, analysis, design, development, testing, implementation, maintenance and support of Siebel Warehouse, Enterprise Data Warehouse (EDW), Business Intelligence (BI) solutions using OLAP.
• ETL: Informatica 6.x, 7.x, 8.x and 9.x
• Design and development of an enterprise wide Data warehouse.
• Informatica server administration and platform upgrades
• ETL Performance tuning involving Query Optimization, Memory Management and Network Bandwidth Utilization.
• Business Intelligence:
• Design, Configuration and trouble shooting of Oracle BI Suite (7.x, 10.x, 11.x)
• Techno-Functional consulting on Data visualization for Oracle BI Dashboards.
• OBIEE server administration.
• Worked on various schedulers including Oracle DAC, Autosys, ControlM.
• Database: Oracle 10g, 11g, 9i, Teradata, Netezza & MS SQL.
• OS/scripting: Unix Shell Scripting and Windows batch scripting.
• Project execution: Requirements gathering, Impact Analysis, Solutions proposals as per Industry standards, On-shore/offshore coordination, end user interaction, release management, translation of business requirements into technical design, worked on enterprise wide application deployment guidelines.
• Project Implementation: Involved in all phases of Software Development Life Cycle.

PROFESSIONAL EXPERIENCE

Confidential

Hadoop Developer

Responsibilities:

• Requirements gathering, analysis and Design coordination.
• Architected and built a scalable distributed Data Solutions System using Hadoop Ecosystem (Hadoop, Pig, Hive, Sqoop, Impala, HBase).
• Implemented a 50 node Cloudera CDH4 Hadoop clustered on AWS (SUSE Linux).
• Extensively worked on PIG scripts & Pig UDFs to perform ETL activities.
• Worked on Pig Scripts to create file dumps for downstream analytical processing.
• Worked on Performance tuning related to Pig queries.
• Created Hive Tables and worked on Hive QL & UDFs for all adhoc reporting.
• Hands on experience on Java MapReduce jobs to handle different types of files including Text, XML, JSON.
• Worked on Sqoop jobs in order to export/import data from/into HDFS.
• Handled incremental data loads from RDBMS into HDFS using Sqoop.
• Supported in setting up QA environment and updating configurations for implementing scripts with Pig and Sqoop.
• Used Apache Maven extensively for building jar files of MapReduce programs and deployed to Cluster.
• Hands on experience on RHadoop for statistical analysis of IVR data.
• Hands on experience on machine learning and NLP.
• Responsible for all admin activities including Administering Cluster health, adding/decommissioning of data nodes, Job scheduling/monitoring.

Confidential, Tampa

Senior BI Developer

Responsibilities:

• Worked on upgradation of OBIE E 10.1.3.4 to OBIEE 11g.
• Primary roles included Onsite Co-ordinator and lead for requirement gathering, impact analysis and migration of reports and dashboards from OBIEE 10.1.3.4 to 11g.
• Loading data from Flat files and other databases.
• Restructuring of OBIEE repository to complement the upgraded Datawarehouse
• Data analysis and adhoc report generation.
• Requirement gathering, Impact Analysis, Data analysis, integration, Solution proposals, business - technical translation, Low Level Design and Onshore/Offshore Co-Ordination.
• Unit and SIT testing.

Confidential, Charlotte

Data Integration Analyst

Responsibilities:

• Design, development, troubleshooting and enhancing Informatica to extract and load data into Datawarehouse.
• Design of Star and Snow Flake schemas, SCDs to fit business needs.
• Loading data from Flat files and other database.
• Building adhoc OBIEE reports for forecasting and data analysis.
• Requirements gathering, Impact Analysis, Data analysis, integration, Solution proposals, business - technical translation, Low Level Design and Onshore/Offshore Co-Ordination.
• Informatica & DAC administration.
• SQL Tuning and performance analysis.
• Unix shell scripting and job scheduling using Autosys and CA7.

Confidential

ETL Developer

Responsibilities:

• Worked on Datawarehouse design
• Requirement gathering, design and configuration of Informatica Application for all ETL activities pertaining to different entities for reporting.
• Developed Informatica workflows for all the data flows from Siebel and external systems to SRMW Datwarehouse.
• Unit testing, System Integration testing on all the Informatica jobs for the OLAP.
• Unix shell scripting to automate the Informatica jobs.

Confidential

Data Integration Analyst

Responsibilities:

• Impact and Gap analysis for the Informatica upgrade from 6.2.2 to 7.1.2
• Customization of all Informatica Mappings, Workflows, batch and Shell scripts.
• Informatica Mapping and workflow development, troubleshooting and deployment.
• Data analysis, integration, cleansing and database migration.
• Informatica Application administration.
• Coordination with Onshore teams.

Confidential

ETL Developer

Responsibilities:

• Requirements gathering, preparation of High Level Design and Low Level Design Documents.
• Development of Informatica Mappings and Workflows to load data into Datawarehouse.
• Unit Testing, Systems Integration testing
• Unix Shell scripting for scheduling and automation of ETL jobs.
• Post production support for bugs and enhancements.

Confidential

ETL Developer

Responsibilities:

• Development of Informatica jobs to import data from Legacy Mainframes into CRM Siebel Staging tables.
• Development of Siebel EIM jobs to load data into Siebel CRM.
• Post production support of bug fixes and enhancements related to the Informatica and Siebel EIM data loads.
• Unit and Systems Integration testing.
• Loading data from Flat files and other databases.
• Siebel EIM data administration and Data Mapping.