• 8.10 years of IT experience in the Business Requirement Analysis, System Analysis, Dimensional data modeling, Designing, Coding, Development, Testing and Implementation of Business Applications with RDBMS, Data Warehouse/Data marts, ETL and Reporting and Big Data Technologies• Strong experience in working on implementation of Data warehouse• Strong experience in working on ETL and Reporting development• Strong experience in creating the Design Documents for loading data into Data Warehouse and Data Mart tables• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake Schema, Dimensional Data Modeling experience using Normalization, Business Process Analysis, Fact & Dimension tables, Physical & Logical Data Modeling• Experience in working with multiple RDBMS including Oracle, Teradata & Sybase• Exceptional analytical and problem solving skills• Excellent understanding of Cassandra Architecture and management tool like OpsCenter• Experience on read and write processes, including SSTables, MemTables and Commitlog• Used DataStax OpsCenter and nodetool utilities to monitor the cluster• Experience in taking the data backups through nodetool snapshots• Experience in moving the SSTables data on to the live cluster• Experience in using Sqoop to import the data on to Cassandra tables from relational database• Tested the application and the cluster with different consistency levels to check for the writes and reads performance with respective to Consistency Level• Experience in Importing data from various sources to the Cassandra cluster using Java API’s• Experience in data modeling of Cassandra• Experience in creating tables involving collections,TTLs,counter,UDTs as part of data modeling• Worked on domains like Corporate Credit, Finance and Fleet Leasing Loan

Type : Maintenance & EnhancementDuration : 32 months; Technologies : Ab Initio (GDE-1.15, Co.op 2.15), UNIX Shell ScriptingDescription : CPS is an integrated transaction processing system that receives data as flat files from providers like TSYS and other customers. CPS transforms these files into a uniqueor customized format required by the client. The processed files are delivered to different clients in a standard layout based on client specifications. The formatted files are also routed to the intended destinations using FTP services.GE Corporate Payment services (GECPS) was taken over by AMEX. This take over presented us the huge challenge of migrating GE customer records that were on MasterCard and VISA cards to AMEX cards. Responsibilities:Understand the ETL specification and develop the mappings.Analyze the various standard and custom processes, and suggesting the optimal solution to the client.Gathered business knowledge from domain experts.Developed Ab Initio graphs for different customer needs files from the Flat files.Automated Ab Initio Processes using korn shell scripts and scheduling scripts through Autosys and Control M.Used UNIX environment variables in various .ksh files, which has reference to build Ab Initio Graphs.Designed and developed Ab Initio graphs to facilitate AMEX Migration. Created functional documents and technical support for AMEX Migration. Liaised with customer to Capture Business requirement Coordinated with third party Vendors (TSYS, AMEX) for data issue and code releases. Engaged in Unit and Integration Testing.Imparted technical and functional trainings to junior team members.Attended to trouble tickets raised by clients.Prepared estimation and SLA summary documents.