SUMMARY

• A professional with total of 9 years of extensive IT experience in Siebel CRM and SAP ERP and as a HADOOP Developer.
• 8 years of ETL experience with different technologies.
• Good knowledge of Hadoop ecosystems, HDFS, MapReduce, Pig Latin, HiveQL, Sqoop and Flume.
• Around 2+ years of experience in Installing, Configuring and using Hadoop ecosystem components like CDH3/4, Hadoop MapReduce, HDFS, HBase, Hive, Sqoop, Pig, and Flume.
• In depth knowledge of Job Tracker, Task Tracker, Name Node, Data Node and MapReduce concepts.
• Good Experience in data loading from RDBS system to HDFS system using Sqoop.
• Loading Weblog data into HDFS using Flume.
• Analyzing data using Pig scripts and Hive queries and writing Customs UDF’s for analysis.
• Defined and developed best practices in Hadoop.
• Loaded the dataset into Hive for analysis.
• Knowledge over SQL and NOSQL database. Hands - on experience with My SQL and HBASE.
• Worked on all phases of data warehouse development lifecycle, ETL design and implementation, and support of new and existing applications.
• Extensively used ETL methodology for supporting Data Extraction, transformations and load using Cransoft ETL tool for SAP data Migration.
• Involved in creating functional mappings, active transformations and also reusable transformations.
• Actively involved in cleansing Client Source data as per requirement and sending back reports for the same to the Client before the actual Transformations.
• Experienced in analysing business requirements and translating requirements into functional and technical design specifications.
• Experience in working with different data sources like Flat files, XML files and Databases.
• Hands on experience in Data Migration from various databases and applications into SAP.
• Created sample data for purpose of testing the developed mappings.
• Designed complex SAP data migration mappings designing the legacy and target mappings.
• Involved in creating the Specifications document according to the client requirement.
• Excellent technical and analytical skills with clear understanding of ETL design and project architecture based on reporting requirements.
• Delivered Superior quality data before the actual migration in the form of reports or load files.
• Work closely with teams to ensure Application GO LIVE’s are on schedule and on time.
• Excellent problem solving skills, high analytical skills, good communication and interpersonal skills.

TECHNICAL SKILLS

Big Data/ Hadoop: Apache Hadoop, HDFS, MapReduce (MRV1 and MRV2), Hive, Pig, HBASE, Sqoop, Flume, MRUnit, Cloudera CDH3/4.

ETL Tools: SAP BODS, Cransoft, DSP, Sqoop, FLUME,IBM Datastage

Operating Systems: Windows XP, 7 and 8, Unix

Databases: MySQL, HBASE, Oracle PL/SQL

Software Application: TOAD, Putty, WinSCP, FileZilla, BMC Remedy Application, HPQC

Programming Languages: Core java knowledge

PROFESSIONAL EXPERIENCE

Hadoop Developer

Confidential, Rockledge Florida

Responsibilities:

• Developed and Supported Map Reduce Programs those are running on the cluster.
• Brainstorming sessions with team to explore the features of Hadoop.
• Developed Hive queries to process the data and generate the data cubes for visualizing.
• Worked extensively with Sqoop for importing metadata from Oracle. Extensively used Pig for data cleansing.
• Importing test data into HDFS cluster from My SQL using Sqoop import, to test the ETL scripts in new environment.
• Executing the scripts in different modes like local mode, map-reduce mode.
• Created Hive tables and working on them using Hive QL.
• Installed and configured Pig and also written Pig Latin scripts for ad-hoc analysis.
• Analysed the data by performing Hive queries and running Pig scripts to know user behaviour.
• Involved in loading data from UNIX file system to HDFS.
• Handled importing of data from various data sources, performed transformations using Hive, MapReduce.
• Update maps, sessions and workflows as a part of ETL change.
• Modifications to existing ETL Code and document the changes.

Environment: Hadoop Ecosystem (HDFS, MRV1, Pig Latin, Hive, HBase), MY SQL, Core Java

Confidential

SAP Data Migration Analyst

Responsibilities:

• Part of the STP team for Canada SAP data Migration. STP stands for Source to Pay.
• Responsible for Vendor Master Creation and Deployment
• Active Data management specific role mapping (as part of deployment activities) - ownership, processes and tools
• Driving the Data Quality function of the team to ensure quality and integrity checks are developed and shared across data management functions to improve the operational processes.
• Constantly interacting with the client to understand the requirement to come up with the technical methodology and to implement the business logic
• Involved in Defects Fixing of the remaining objects that are held at offshore and onsite
• Successfully completed end to end Purchase orders Data Migration
• Completed end to end Purchase order migration that involved PO Output conditions, Open PO Upload, PO Inbound Deliveries, and PO Acknowledgements.
• Developed and modified the current BAPI programs for PO loads and SAP recordings to create/change/ modify data using SAP standard recording methods and Cransoft BDC recording too.
• Used Cransoft ETL tools i.e. DSW, Cranport, and BDC recording tools to Extract, transform and load data.
• Used Cransoft Ezmap mapping tool for all mapping documentation at both object design and value mapping level.
• Provided coverage for loading Vendor Master and Purchase Info Records.
• Single point of contact for all Vendor Master and PO related queries and solely responsible for the object loads.

Environment: Cransoft DSW, EzMap, Data Garage, Canport, MY SQL2008, HPQC

Confidential

SAP Data Migration Analyst

Responsibilities:

• Involved with Confidential in successful end to end SAP data migration.
• Gathered required information from Functional Consultants and business to transform data technically.
• Responsible for loading data for Poland Data Migration using Cransoft ETL tools i.e. Data Stage Warehouse, Cranport, Data Garage, BDC Direct, EZMap and Microsoft SQL Server.
• Build transformation Rules in MS SQL based on the Functional Spec and EzMap Field and Value mapping details.
• Create Cranport Packages to insert data from different databases and excel and text file using filters rules to get in the required data.
• Creating load files and Client reports using Microsoft Sql and Cransoft reporting tool
• Writing Remediation Rules to change data as per business requirement to change data in reports.
• Designed LSMW standard program to load Vendor Master Data.
• Created multiple recording using SAP recording T-codes and SAP LSMW recording method to load/change data as per the requirement.
• Loaded Vendor Master Data, Purchase Contracts and Purchase Orders.
• Single Point of contact for all vendor masters and PO related queries.
• Developed multiple BDC recordings, LSMW Programs for Vendor Master Data i.e. for LFA1, LFB1, LFBK, LFBW and LFM1.
• Worked with remediation and migration teams to ensure accurate and consistent master/ transaction data transformation.
• Moved the projects from Dev to ST, ST to UAT and UAT to Production.

Environment: Cransoft DSW, EzMap, Data Garage, Canport, MY SQL 2008, HPQC

Confidential

SAP Data Migration Analyst

Responsibilities:

• Worked with FI team to process the daily loads.
• Worked on SAP IS Utilities to help facilitate data migration.
• Followed a stable process of loading the data from source to target.
• Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Loading Cost centres, Profit centres, Company Code, GL Accounts data in SAP using BDC.
• Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
• Developed rules and reports for STS team.
• Loading the data in both Dev and QA Servers on daily basis.
• Analyzing errors occurred during load.
• Worked on Ezmap for loading functional design for HR Process.
• Assisting other teams like STS, OTC and P2P team in day to day process.
• Participated in detailed report design and created design specifications documents at report level.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, and Transformation and Generation of Load ready data files in LSMW format.
• Ability to interpret, configure and implement data mapping / transformation business rules using Cransoft.

Environment: Cransoft DSW, EzMap, Data Garage, Canport, MY SQL 2005

Confidential

Sr. Software Engineer

Responsibilities:

• Support for smooth functioning of the Crystal (Siebel) application.
• Responsible for loading data like CAF, CHURN, Bulk SR uploading, CUSTCODE, SMARTACT and DEMOGRAPHIC data received in flat file structure from legacy systems into Siebel Application on daily basis for 22 circles using Siebel EIM data loading concept.
• Writing Transformation queries using PL/SQL and moving data from Source to Target to Siebel Application.
• Writing ad-hoc reports in PL/SQL as and when required.
• Used IBM-Datastage for creating ETL jobs using Oracle Database as backend and PL/SQL for writing transformations.
• Making sure all the SR’s are automated and completed on the crystal application for providing smooth and uninterrupted service to IDEA customers.
• Communicating with IDEA client as and when needed through email or phone.
• Creation of BULK SR’s, cancelling and completion of SR’s using Siebel Business Service.
• Co-coordinating with different teams as and when required for the proper inflow and outflow of data from Crystal application to other applications and vice versa.
• Responsible for generation of daily business Reports required by business on daily basis and resolving Report issues as and when required.
• Responsible for making daily and monthly dashboards and also generating weekly and reports and sending across to IDEA clients on timely basis.
• Creation and deletion of users in crystal application and loading daily IDEA plans into Crystal Application and automate them at the Application level.
• End to End monitoring of SR’s raised at different levels making sure that response times are met to maintain SLA.
• Responsible for closing tickets related to Automation, Reports and data loading using BMC Remedy tool to provide timely resolution to IDEA client and customers.
• Provide training to Different IDEA Call Canter employees as and when any changes are made in crystal application by phone, email or by visiting client side.
• Also involved in testing Siebel application from an operational perspective for different circles during system GO LIVE.

Environment: Siebel 8.0, Siebel EIM, Siebel EAI, PL/SQL, IBM Web Sphere, Putty, Toad, BMC Remedy, DataStage, Oracle DB

Confidential

Software Engineer

Responsibilities:

• Installed Argis, SQL Server and ADT, with the required patches
• Identified the schema of the Legacy system used by the business
• Performed ETL (Extract, Transform and load) using Advance Data Transfer (ADT).
• Establish connection to source system using ODBC connectivity (Flat files, SQL Database, Excel, and Access)
• Identified, different Roles for a User to be associated with
• Created Filters to further restrict what kind of data a user can access
• Set up Access right with Roles and Filters for Argis Web
• Developed Multiple Transformers in ADT
• Analyzed the data sent by the Clients and prepared templates that can be used to load data into Argis using automated scripts
• Wrote complex queries to filter and validate the Data
• Automated the” cross check script” that would validated the data that was loaded against the data present in Target system
• Exported Reports as per Client requirement in CSV format
• Created Shared Drives for easy access. Exported Reports as per Client requirement in CSV format
• Created Shared Drives for easy access
• Led a broad range of SQL Server database administration functions, including creating tables, and indexes where needed; using DTS for loading, cleansing and reorganizing data; ensuring data integrity / system security and export/import techniques
• Worked on Asset Intelligence (A.I) to have it integrated with UAM and USD
• Developed complex queries to extract data from various tables so that they can be in accordance with the Client requirement
• Automated the script that loads Non- Confidential consumer finance individuals (as per business requirement)
• Tested Progress to develop Argis Reports
• Worked Extensively on MS Excel to filter and validate data

Environment: Argis, ADT, SQL Server, MS Excel