Software Developer Data
Resume:
SATABDI KUMAR DASH
Contact: +1-331-***-****; E-mail: **.*************@*****.***
Satabdi Kumar Dash
Team Lead
Larsen and Toubro Infotech
Raritan, New Jersey
Sub: Software Developer
Dear Sir/Madam,
I am submitting herewith my resume for your perusal consideration for the post of Software Developer in your organization.
Review of my credentials will indicate that I am a qualified experienced Software Developer with a progressive expertise in requirement Analysis, Development, Integration testing, Production implementation and Primary Production Support; currently spearheading as with Larsen and Toubro Infotech as Team Lead, prior to that had worked with Cognizant Technology Solutions as an Associate and Exilant Technologies Pvt. Ltd. as a Programmer Analyst. Equipped with the knowledge of various software, organizing technical demonstrations, with sound understanding of systems, designing, analysis, testing, Performance Tuning, database development and coding for modules while structuring customized solutions to meet customer’s specific needs.
I am an innovative thinker, able to apply analysis and creativity to problem solving. I am a highly personable, self-motivated and diligent individual with flexibility to adapt to new situations. Being a focused, motivated and goal-oriented professional, I have consistently proven my ability to handle operational and strategic levels of multiple responsibilities in crisis and pressure, while operating under rigorous deadlines.
With an innate sense of task prioritization and result oriented attitude towards accelerating organizational growth and that too in a high pressured, time bound and competitive environment, I reckon that my grooming level is apt to look outward for a challenging position, requiring complete grasp & grip of high level of professional loyalty, integrity and maturity.
A glance through my resume, attached along, shall familiarize you with my credentials. I am confident of fitting in the slot as well as in the team. However, should you desire personal interaction; I may be called upon where the possibility of our association could be explored further.
Yours sincerely,
Satabdi Kumar Dash
SATABDI KUMAR DASH
Contact: +1-331-***-****; E-mail: **.*************@*****.***
SOFTWARE DEVELOPER
Seeking challenging and rewarding assignments with a leading organization
PROFILE
Competent, diligent & result oriented software professional with a progressive experience of 9 years and 5 Months in Software Development; currently spearheading as with Larsen and Toubro Infotech as Team Lead, prior to that had worked with Cognizant Technology Solutions as an Associate and Exilant Technologies Pvt. Ltd. as a Programmer Analyst; handling Business Intelligence for Data warehousing by using various ETL tools such Informatica.
Thorough knowledge of complete Software Development Life Cycle from requirement analysis, design, coding, testing, implementation, maintenance, Report Generation while structuring customized solutions to meet customer’s specific needs.
Possess expertise in Development, Integration testing, Production implementation and Primary Production Support.
Good problem-solving abilities, ability to deal with people diplomatically, willingness to learn, Key team player, hard worker with good communication skills.
Core Competencies
SDLC Requirement Analysis Implementation Design Testing Troubleshooting/Fault Analysis Strong Interpersonal Skills
Technical Proficiency
Operating System
Mac Os (UNIX), Windows 98/XP/Windows 7 and familiar with LINUX.
Database (RDBMS)
Teradata (12.0, 13.0, 14.0,15.0 and 16.0), Oracle (10g). Netezza, Hive,Impala
Language Skills
UNIX shell Scripting
ETL Tools
Informatica 10.2/10.1/9.6/9.1/8.6
JOB Scheduling
AutoSys, Tidal, Control-M
Teradata Utilities
Bteq, Fastexport, Fastload, Multiload, TPUMP and TPT
PROFESSIONAL EXPERIENCE
LARSEN AND TOUBRO INFOTECH April 2017- Till Date
Team Lead
Providing Level 3 support to troubleshoot Informatica and Teradata job issues and following escalation procedures to resolve them.
Identifying recurring issues in the application & daily load jobs and providing the root cause analysis and Providing corrective/preventive actions that will reduce the risk of recurrence of issues.
Creating and maintaining documents like Knowledge Transfer Document for new application introduced to IT environment and for all known day to day activities.
Engaged in supporting the application with multiple Functional areas like Inventory, Bill of Material, Finance and Customer sales etc.
Day to day Client Interaction to discuss on the current issues, planning for future work.
COGNIZANT TECHNOLOGY SOLUTIONS Oct 2014- April 2017
Associate
Analysed the systems, met with end users and business units in order to define the requirements.
Used Informatica Power Center 9.1 to extract, transform and load data from multiple input sources like Teradata, flat files to target database.
Used Autosys to schedule the job on scheduled time.
Implemented efficient and effective performance tuning procedures.
Worked extensively on SQL, PL/SQL and UNIX shell scripting.
EXILANT TECHNOLOGY PVT. LTD. July 2011- Oct 2014
Programmer Analyst
Skilfully handling the complete life cycle of development/ support of projects including Requirement analysis, Development, Integration testing, Production implementation and Primary Production Support.
Strategically planning and analysing the basic requirements while setting up the technical infrastructure of the project while reviewing the project proposals.
Carrying out responsibilities such as developing informatica interfaces and writing Unix shell scripts and Teradata procedures.
Working with Teradata utilities such as TPT, Multiload, Fast export and Tpump.
Working as a part of the development team have gathered the ability to work in a team, willingness to explore business functionality in detail, ability to explore new technologies and new domain and delivering cost effective and scalable solutions.
Used Autosys to schedule the job on scheduled time.
EDUCATIONAL CREDENTIALS
Qualification
Institution
Board/University
Percentage
Year of passing
X
Sunshine Mission School
I.C.S.E
79
2005
XII
Bhadrak Junior College
C.H.S.E, Odisha
67.33
2007
B.Tech (Electrical.)
Konark Institute of Science & Technology, Odisha
BPUT
69.3
2011
CERTIFICATION
Teradata Vantage Certified Associate Advanced SQL Engine
Date of Birth: 1st October 1988; References: Available on request
The Details of Key Projects Handled have been mentioned under “Annexure”
ANNEXURE
Key Projects Handled
#1
Title
RNA
Organization
Larsen and Toubro Infotech
Client
Johnson and Johnson
Technology Used
Teradata, Shell scripting, Informatica and Hadoop
Team Size
25
Duration
April 2017 to Till Date
Description
RNA integrates MD&D data elements from multiple ERP systems into the Enterprise Data Warehouse for Supplier Delivery (Good Receipts) and Janssen Data warehouse for Forecast, Inventory, OTIF (LIFR) and Bill of Materials (BOM), projected inventory and targeted inventory to provide visibility on the respective Subject areas. Creating this Reporting Framework and reporting tools (Tableau) that is providing analytics Capability on the inventory for the Global Surgery Group to enable the users to monitor the inventory related metrics.
Contribution
Day to day Client Interaction to discuss on the current issues, planning for future work.
Identifying areas of improvement in the Informatica job execution times.
Working with business users to implement the code changes/enhancements that ensures faster availability of data to users.
Identifying recurring issues in the application & daily load jobs and providing the root cause analysis.
Providing Level 3 support to troubleshoot Informatica and Teradata job issues and following escalation procedures to resolve them.
Coordinating with multiple stakeholders to resolve issues and ensuring the business data availability to users without delay.
Application monitoring and maintenance, including the completion and execution of the tasks as per business requirements. Establishing measures for and reporting the availability and reliability of the application.
Providing data extracts to business users based on their requirements.
Creating and maintaining documents like Knowledge Transfer Document for new application introduced to IT environment and for all known day to day activities.
Engaged in supporting the application with multiple Functional areas like Inventory, Bill of Material, Finance and Customer sales etc.
Providing corrective/preventive actions that will reduce the risk of recurrence of issues.
#2
Title
CSX Project
Organization
Cognizant Technology Solution
Client
Apple Inc
Technology Used
Teradata, Shell scripting, Autosys and Informatica
Team Size
15
Duration
June-2016 to April 2017
Description
The mission is to build a new CRM suite for Customer Systems capable of fulfilling all existing functional requirements while simultaneously delivering linear scale, zero-downtime, accelerated development cycles, and high-availability across multiple data centers.
Contribution
In this project have played the role of a developer taking care of the Repair FT, CDM CS, Case 2.0.
Has been involved in developing interfaces to induct new tables from Mongo DB to Teradata and Hadoop.
Some of the tasks performed include setting up the entire interface flow from source to Teradata target tables, developing TD utilities (tptstream,tptload), Unix scripting and impact analysis for the interfaces involved and carrying out production deployment activities, performing root cause analysis & fixing real time failures encountered in production from offshore on a bi weekly basis.
Involved in repointing source to Mongo DB as tables in Oracle Db are getting decommissioned. Also worked on the impact analysis for this change like missing attributes and connect me page updates for the different applications.
As an active team member, had taken up the initiative to understand GBI’s generic framework used to induct the new tables and has contributed to the team’s overall knowledge and expertise over the framework.
Software used
Unix Shell Scripting, Informatica Power Center 9.1, Teradata (sqls, pl/sql) and Autosys.
#3
Title
Non –iTunes core team
Organization
Cognizant Technology Solution
Client
Apple Inc
Technology Used
Teradata, Shell scripting, Autosys and Informatica
Team Size
12
Duration
Oct-2015 to May-2016
Description
The Non –iTunes core team is responsible for taking care of extracting transforming and loading data into Teradata tables belonging to the non – iTunes subject area, the data is extracted from different sources such as Oracle, SAP, Teradata and flat files and Informatica serves as the extraction tool. Once the data is available in the staging zone the required transformations are carried out using Teradata stored procedures and loaded into the core database using a common generic framework designed to induct and enhance tables. Just as how data is brought into the EDW there are also jobs designed to take the data out of Teradata to other platforms primarily Oracle here again Informatica is used for extraction purpose.
Contribution
The project involves extensive use of Informatica, Unix scripting and Teradata tools such as fastload, tpump and tpt, Autosys is used as the job scheduling tool.
Software used
Unix Shell Scripting, Informatica Power Center 9.1, Teradata (sqls, pl/sql) and Autosys.
#4
Title
Iron Dome
Organization
Cognizant Technology Solution
Client
Apple Inc
Technology Used
Teradata, Shell scripting, Autosys and Informatica
Team Size
4
Duration
Oct-2014 to Oct-2015
Description
To ensure that Apple only offers warranty service on genuine Apple products, this project will mandate warranty eligibility verification of 5 components IMEI, MLB, Battery, Front & Back Camera for each diagnosis for the devices with OS 8.3 or higher. Currently “Veritas check” verifies the warranty against the Manual entry of the components by technician while eVeritas will capture the component details electronically using AST2. GBI will capture this data and will produce the report, which will be used by Compliance Team to prevent fraudulent activities.
Contribution
Analysed scenarios and used aggregation logic in Teradata procedure. Autosys is used as the job-scheduling tool.
Software used
Unix Shell Scripting, Teradata (sqls, pl/sql) and Autosys.
#5
Title
Sound Exchange Reporting.
Organization
Exilant Technologies Pvt Ltd.
Client
Apple Inc
Technology Used
Teradata, Oracle, Shell scripting, Autosys.
Team Size
3
Duration
Mar-2014 to Oct-2014
Description
Sound Exchange is a non-profit performance rights organization that collects royalties on the behalf of sound recording copyright owners (SRCOs — record labels, generally) and featured artists for non-interactive digital transmissions, including satellite and Internet radio.
Warner, Universal and Sony are the vendors who opt to share their royalties with Sound Exchange, so that Sound Exchange can distribute royalties to artists, record labels, etc.
Contribution
Involved in Designing DLDs and Design docs.
Analysed scenarios for calculating share for the Sound Exchange vendors from the royalty amount for the music vendors.
Carried out writing of Unix shell scripts and TD DMLs, TD procedures for inserting data and Oracle DMLs staging information of processed data.
Used TPT utilities to generate .txt reports.
Software used
Unix Shell Scripting, Oracle, Teradata (sqls, pl/sql) and Autosys.
#6
Title
iTunes Radio International launch and Enhancement
Organization
Exilant Technologies Pvt Ltd.
Client
Apple Inc
Technology Used
Teradata, Unix Shell scripting, Autosys.
Team Size
3
Duration
July 2011 to Feb-2014
Description
iTunes Radio is a free internet radio service by Apple Inc where the users are able to skip tracks, customize stations, and purchase the station's songs from iTunes store. The source of revenue for the apple is the Internet advertising from where it distributes royalty to its music vendors.
Contribution
Involved in Designing DLDs and Design docs.
Replicated source data from hadoop export file into both primary and secondary database.
Analysed scenarios for calculating royalty amount for the music vendors.
Used aggregation logic in Teradata procedure to calculate royalty amount.
Carried out writing of Unix shell scripts and TD DMLs, TD procedures for inserting data and TPT scripts to generate the reports.
Software used
Unix Shell Scripting, Oracle, Teradata (sqls, pl/sql) and Autosys.
Contact this candidate