| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address
EMAIL AVAILABLE, PHONE NUMBER AVAILABLETotal Experience: 12 years 00 monthsAcademic QualificationsBE in Electronics & Tele Communication from SSBTs College, North Maharashtra University, year of passing 2007 with aggregate of 61.5%.K.V 9 BRD, Pune (Class XII) 73.2%.K.V 9 BRD, Pune (Class X) 76.6%.CertificationsAWS Associate developerSAFe Agile 4.6Oracle 9iWork Experience DetailsCurrent Company : Atos Syntel IncCurrent Designation : Senior ConsultantJob Domain Expertise : Data Warehousing ETL(Ab-Initio)Current Company : Cognizant Technologies Solutions US CorpCurrent Designation : Senior AssociateJob Domain Expertise : Data Warehousing ETL(Ab-Initio)Previous Company : Wipro TechnologiesCurrent Designation : Senior Software EngineerJob Domain Expertise : Data Warehousing ETL(Ab-Initio)Previous Company : BitWise Solutions Pvt LtdCurrent Designation : Programmer AnalystJob Domain Expertise : Data Warehousing ETL(Ab-Initio)Career Summary27th Aug 2018 Till Date Atos - Syntel IncClient: Fedex Services, Collierville, TN, USA.Project Name: EDW and Data AcquisitionRole: Abinitio Developer at Onsite (Collierville, TN)Platform: UNIX, GDE- Ab-Initio 3.3.5, Co-operating System version 3.1.3Database: TeradataTeam Size: 6Duration: 27rd Aug 2018 Till DateProject Description:FedEx Express is a cargo airline based in Memphis, Tennessee, United States. It is the worlds largest airlines in terms of freight tons flown and the world's fourth largest in terms of fleet size. It is a subsidiary of Fedex Corporation. Customer wants to consolidate all their Customer Information Data and maintain for the customers across FedEx. Data Acquisition application is involved in capturing the data from various FedEx entities (sources) into the Enterprise Data Warehouse (EDW) which is in Teradata Platform. The data mostly contains the customer identity (customer demographic) information, revenue and shipment information. Where the beneficiary will be working on the Analysis of their business requirements on Enterprise data ware house, Purge criteria, Data retention period, Writing of Software requirement specification document, Mapping of the source to target elements, Data integration testing, Stake holders management.Tasks:Work on the development related to designing, coding, code level unit testing activities & deployment for Software application development tasks.Supporting the activities like application maintenance, server loads and calculation of various fields to understand the state of the servers.Working on the Defects that needs to be resolved as per the requirement. This involves design & code changes to adhere to the solution provided.Interacting with the client on requirements.Working on optimization of the code and design level changes if required to improve the performance.Mentoring & contributing to improvements of the overall application by discussing on the new features and changes in business, domain & technical areas. Understanding the issues faced by the team and providing solution19th Jan 2014 15th Aug 2018 Cognizant Technologies SolutionsClient: Capital One, Richmond, USA.Project Name : Customer Experience Metrics ProgramRole: Abinitio Developer at Onsite (Richmond, Virginia)Platform: UNIX, GDE- Ab-Initio 3.2.0, Co-operating System version 3.1.3Database: TeradataTeam Size: 10Duration: 23rd Feb 2015 Till DateProject Description:Capital Ones overall objective is to drive improved business results, via improvements to the customer experience. Currently, the company tracks a multitude of customer satisfaction across several independent programs that are either line of business or channel specific. The current metrics and their defintions are not consistent or actionable across business areas and impede the ability to obtain a holistic view of enterprise performance. The goal is to provide both a single enterprise view of our delivery to customers; as well as, drill-down customized views of LOB/channel performance ideally on the same reporting frequency.The first objective is to create a comprehensive, enterprise-wide customer satisfaction assessment program that will replace numerous overlapping and inconsistent customer satisfaction programs. The enterprise view will focus on the 10-12 key metrics. In addition, Capital Ones three US business units (Credit card, Bank and Financial Services) will have the opportunity to add a few additional questions to surveys of their customer interactions.Tasks:Involved in requirement gather meetings and AnalysisInvolved in detail design creation and design reviewCreation of Source to target MappingProcess ImprovementDeveloping Abinitio graphs and Shell ScriptsUnit testing of the codeSupporting QA team in testingUAT SupportInvolved in production supportCloud MigrationClient: Express Scripts, Franklin Lakes, NJ, USA.Project Name : Automated Benefit LoadRole: Abinitio Developer at Onsite (Franklin Lakes, New Jersey)Platform: UNIX, GDE- Ab-Initio 3.1.2, Co-operating System version 3.1.3Database: SQL ServerTeam Size: 6Duration: From 19th Jan 14 till 5th Feb 15Project Description:WellPoint client sent the XML files to the ABL system, after receiving the xml files data validation occurs and the file was processed/rejected. Based on coverage code, BPL was generated and passed to BRE for creating accum and copay files and sends to GDE Dev team. Later the process maps the fields in CBM after doing the transformation on the fields and based on add/update the benefits get updated in CBM and reports sent to client. After confirmation from client the Copay and Accums were loaded in CBPS system.Tasks:Involved in requirement gather meetings and AnalysisInvolved in detail design creation and design reviewDeveloping Abinitio graphs and Shell ScriptsCreate parameter sets including PDLs.Create Abinitio Plans using Conduct ItUnit testing of the codeDoing SIT testing with BRE and Java team.Supporting QA team in testingUAT SupportInvolved in production support11 March 13 17th Jan 14 Wipro Technologies, USAClient: Capital One, Richmond, USA.Project Name : Basel II (UK Card)Role: Abinitio Programmer at Onsite (Richmond, Virginia)Platform: UNIX, GDE- Ab-Initio 1.15, Co-operating System version 2.15Database: TeradataTeam Size: 8Duration: From 11th March 13 till 17th Jan 2014The Basel II Retail Credit Teradata Repository project will be responsible for implementing the Teradata Repository which will store all data elements required for the development and execution of Basel II. The data elements for each Retail Credit Line of Business (LOB) will be modeled within the Teradata container based on the Core Data deliverables produced by the Historical Data Collection Projects, combined with the RWA required data elements.The process involves creation of clean files once the init files from UK team received at US EDE end. The clean file is accumulated daily in MVS to create month end file. On month end the accumulated file published to DDE. All the transformations are done while creating the nrch file from accumulated file and later on load ready files are created which are loaded into PBASEL table.Tasks:Involved in data mapping review meetingsCoding as per the data mapping DocumentInvolved in design creation and design reviewUnit testing of the codeSupporting QA team in SIT testingUAT SupportCreation of Toss-G, technical design document and control m doc.Involved in production supportClient: CitiGroup, USA. JUN-2012 to FEB-2013Project Name : CCD (Commercial Cards)Organization: Wipro Technologies, IndiaRole: Abinitio Programmer at Onsite (Columbus Ohio)Platform: UNIX, GDE- Ab-Initio 1.15, Co-operating System version 2.15Database: OracleTeam Size: 15Duration: 7 monthsThe data from different region are sent to GDR system that is global data repository. These data are loaded into staging area and from staging to citicom database. The data from the GDR is read by Microstrategy team to create different report. The data is also sent to visa and master as per required format.Tasks:Gathering the requirements with Business for inbound and outbound process.Involved in data mappingCoding as per the requirement gatheredUnit testing, Integration testing and UAT of the application before delivery.Involved in the code walkthrough.Client: CitiGroup, USA. JUL-2010 to MAY 2012Project Name : ESA - CBR (Economic Stabilisation Act Cost Basis Reporting)Organization: Wipro Technologies, IndiaRole: Abinitio ProgrammerPlatform: UNIX, GDE- Ab-Initio 1.15, Co-operating System version 2.15Database: OracleTeam Size: 08Duration: 26 monthsThe Emergency Economic Stabilization Act of 2008 ("ESA" or "Act") and associated proposed regulations requires certain payers to provide their "U.S. Non-Exempt recipient" clients and the Internal Revenue Service with the adjusted cost basis of "covered securities" acquired after January 1, 2011. Adjusted cost basis is generally defined as the original purchase price of a security, adjusted for fees, corporate actions, wash sales and other tax-related adjustments.Tasks:Gathering the requirements for different sources(Total :10).Attending meetings to finalize layout for different sources.Unit testing and Integration testing of the application before delivery.Data validation was done by using comparison applications.Involved in the code walkthrough.Jan 08 May 10 BitWise Solutions Pvt. Ltd., Pune.Worked on all phases of development life cycle, from gathering requirements to implementation, testing and support.Demonstrated the required utilization of ETL tool Ab Initio with integrated utilization of UNIX and TERADATA (SQL).Exceptional background in analysis, design, development, customization and implementation and testing of data warehouse applications and utilities.Team player with good communication and problem solving skills.Technologies and Tools UsedAbinitioUnix(Shell scripting)Teradata SQL 6.2IBM job scheduling ConsoleProfessional ExperienceProject: DDS (Decision Data sourcing)Duration: Jan 2008 till dateRole: Programmer AnalystClient: Discover Financial ServicesDescription:Discover Financial Services is the major client of BitWise Solutions Pvt. Ltd. Decision Data Sourcing team is an important part of Discover environment.The Decision data sourcing system includes the STRATA system that is responsible in deciding the scores of credit card holders of Discover depending upon their behavioral patterns, loyalty and history. FICO Score, Super Score, Behavior Score are the type of scores calculated by the system.Data needed for the STRATA system has to be extracted from various sources, cleaned, updated, formatted, concentrated and then made available for further scoring process.Under Decision Data Sourcing team the projects includes impact analysis of any changes to the DDS process, preparing technical design and test plans for the proposed changes and making executables as per business requirements and maintaining the system and supporting it.Responsibilities:It included DDS support, maintenance and enhancements. In addition to my role as a developer in Ab-initio, I was often entrusted the tasks related to Shell scripting for the wrappers to catalog the files and some run scripts, process enhancements, data analysis, impact analysis, extraction and mappingProject SummaryProject Title: Scalable Batch (Phase I)Organization: BitWise Solutions Pvt. Ltd, IndiaClient Name: Discover Financial Services, U S.The objective of Scalable Batch project (Phase I) is to convert the historical files used into teradata tables to reduce the redundancy of data and speed up the processing. The required data is first transformed and stored in the files (load files) and then it is loaded into tables.Role:Backtracking of derived fields to find out the source field and file.Distinguishing the fields based on different criteria such as monetary fields, non-monetary fields etc.Creation of load files and testing the application using development tables.Used normalize, demoralize and output table components.Interacted with the onsite coordinators at US for knowledge transfer of the existing system and discussed the requirements, features, functionalities and the design of the new requirements.Used multi files as source.Project Title: Decision Batch Application MigrationRole: Team MemberProject Description:Decision Batch Application Migration involved migration of the data processed in Decision Data Sourcing from files to tables. Thereby increasing the performance of the applications extensively and reducing the space issues. This being a large scale project is being executed in phases. I am currently working for Phase 2 ImplementationUnder Phase 2 Implementation of this project, it involves migration of all the important inbound events that constitute the major applications of DDS to TeradataCurrently all the inbound events process the data by reading from files and write the processed data to files.However, with the implementation of DBAM the inbound events will read data from tables and load the processed data to be sent to Strata into tablesThis would lead to tremendous performance enhancement for DDSResponsibilities:Member of Development and Testing TeamCreation of DTD (Detailed Technical Design)Developing generic graphs and extensively using psets and pdl conceptDeveloping graphs to load data into Teradata tablesPerforming validation of the data loaded into tablesPerforming extensive Unit TestingProviding support for Development environment bug-fixing and problem solvingProject Title: Account TransferOrganization: BitWise Solutions Pvt. Ltd, IndiaClient Name: Discover Financial Services, U S.The objective of Account Transfer is to create an application(s) for assignment of new account numbers for accounts that are lost, stolen, or transferred in order not to lose historical data.Role:Interacting with the onsite coordinators for understanding the requirements and updating the status.Implementing the code design for the required fields.Unit testing and Integration testing of the application before delivery.Used the concept of lookup file and lookup function in reformat component.Project Title: Default Pricing ProjectOrganization: BitWise Solutions Pvt. Ltd, IndiaClient Name: Discover Financial Services, U S.The objective of Default Pricing Project is to create an application(s) for updating files with additional months data for existing fields by adding buckets.Role:Back tracking the required fields for identifying the source.Writing the transformations for implementing the rotation logic to keep the minimum of 12 months data and pulling the fields from the required source files.Creating new dml with the added fields.Validation of data by using multi files as source.Short Requests:Worked on short requests some of which are as follows:a.Backfilling of data.b.Optimization of application.c.Creating and updating analysis document of various applications.AchievementHas got excellence award twice for SBI project and Support Activity.Has got Thank You card from Project Manager for showing the commitment to work andproviding a defect free deliveryHas received appreciation from Onsite Co-coordinators for dedication to the project anddefect free deliveryAWS dev certificationPersonal DetailsName : Candidate's Name
Date of Birth : 24th July, 1986Gender : MaleMarital Status : SingleReligion : HinduNationality : IndianPassport Number : G6380850PAN : AGHPV8906BPermanent Address : Arya, Survey no 49/2, Opposite Relax Hotel, Vadgaon-sheri Pune-14, MaharashtraI hereby declare that the information furnished above is true to the best of my knowledge.Date:Place: Collierville, Tennessee Candidate's Name |
