SUMMARY

• To work in a dynamic and environmentally flat organization wherein my technical noledge, business understanding, relationship management, analytical and leadership skills can be utilized and further developed to create greater value for teh organization and self.
• 10+ years of professional IT experience in coding, requirement gathering, application maintenance and support, requirement and functional specification documentation, execution and reporting for software systems in airline, ecommerce and Retail industries.
• Hands on experience in application development using Datastage, Hadoop (Big Data), RDBMS, Java and UNIX shell scripting.
• Successfully converted datastage parallel jobs to Hadoop supported scripts.
• 5.5 years - Good experience on Extraction, Transformation and Loading (ETL) processes from various sources into Data Warehouse/ Data Marts using Ascential DataStage 8.1 (Manager, Designer, Administrator and Director).
• 4+ years - Worked on Hadoop/Java including MapReduce, Pig, Hive, Sqoop and Java UDF.
• Experience in UNIX shell /AWK scripting with PL/SQL block, Hadoop, Datastage, Java.
• Familiarity with Oracle, SQL Server, Datameer, Netezza systems and business intelligence tool Microstartegy.
• Strong leadership skills, quick learner, problem-solving approach, multi-tasking skills, resource management skills, planning & tracking of project schedules.
• Onshore - Offshore co-ordination skills.
• Strong Critical thinking, communication, collaboration & team building skills with proficiency at grasping new functional & technical concepts quickly and utilized teh same in a productive manner.
• Able to assess business rules, collaborate with stakeholders and perform source to target data mapping, design and review

TECHNICAL SKILLS

Scripting /Languages: Java(Core), Hadoop (Pig/Hive/Sqoop), Datastage, UNIX Shell, Sed/Awk, HTML, Java Script, Perl/Python (basic)

Databases: DB2, Netezza, TeraData, Oracle 8i/9i/10g, SQL server, MySQL

Operating Systems: Windows 98/Me/XP/Vista, UNIX, Linux

Software Engineering Tools: TOAD 8.0, JIRA, SQL assistant, MS office, Eclipse, PUTTY, dbvisualizer, Notepad++Version Control: VSS, SVN, Github

PROFESSIONAL EXPERIENCE

Confidential

Developer /Project Lead

Roles & Responsibilities:

• Developed Hadoop (Pig/Hive/Sqoop) scripts to handle big data.
• Designed and developed Jobs by using IBM DataStage that extract data from teh file to Teradata database, cleanse it, transform it as per business requirement and populate teh data into Teradata.
• Provided complex solution to handle teh performance in Hadoop/Teradata.
• Enhanced legacy application with new features and bug fixes.
• Automation in DB2+Teradata+UNIX shells scripting with java batch jobs.
• Prepared teh control-M document and schedule teh jobs for teh batch process.
• Created supporting shell scripts for Datastage/java batch jobs.
• Mentoring and noledge transfer to new team members.
• Weekly and Monthly status reporting to stakeholders on incidents and project progress.
• Coordination between teams using various sources (WebEx, bridge calls and emails) to close open incidents and changes.
• Working with teh team to investigate Root Cause Analysis (RCA) of teh issues faced by key users.
• Test case preparation and help to QA team.
• Requirement gathering and its documentation in teh form of User Requirement Specification (URS) or Business Requirement Document (BRD).
• Validating and debugging teh job and SQLs
• Involved in production deployment and further production support.
• Code and deployment management through Git-hub/SVN.

Confidential

Developer / Lead

Roles & Responsibilities:

• Assisted in designing and development of ETL procedures as per business requirements.
• Participated in coding of application programs with Java UDF and other scripting languages.
• Assisted in designing, development and architecture of Hadoop systems and domain.
• Coding in Hadoop (pig/hive/Sqoop/UDF) to convert complex datastage code to Hadoop and also written shell scripts to trigger teh jobs as per project framework including email notification in case jobs fail or any data mismatch issue.
• Automated processes for application of new technologies as per latest changes
• Conducting CAB meeting to discuss on changes within various application support and implementation groups.
• Mentoring and noledge transfer to new team members.
• Prepared teh control-M document (Jobs dependency document) and schedule more TEMPthan 50 jobs.
• Weekly and Daily status reporting to stakeholders on incidents and project progress.
• Product parallel run Hadoop code Vs datastage to verify teh results and prepared detailed testing results documents.
• CDH3 to CDH4.3 migration.
• Managed and reviewed Hadoop log files
• Code and deployment management through SVN.

Confidential

Developer /Project Lead

Responsibilities:

• Designing, developing, testing, performance tuning and scheduling Datastage jobs.
• Developed incremental load Netezza SQL scripts and designed execution flow with ETL sequencer jobs.
• Developed Parallel and Sequencer ETL jobs to load data from source to Netezza staging and reporting database.
• Closely working with teh end business users to comprehend their requirements in order to design and develop interactive reports that meet business expectations.
• Scheduled UNIX scripts and DataStage jobs using teh Control M scheduler.
• Enhanced ETL datastage jobs with new features and bug fixes.
• Created supporting shell scripts with Teradata for Datastage/java batch jobs.
• Handling Reporting team and Daily status meeting with clients.
• Suggested processes for enhancement of application features and stability in coordination with subject matter experts.
• Working with teh team to investigate Root Cause Analysis (RCA) of teh issues faced by key users.

Confidential

Developer /Project Lead

Roles & Responsibilities:

• Designed and developed Jobs by using IBM DataStage that extract data from teh file to Teradata database, cleanse it, transform it as per business requirement and populate teh data into Teradata.
• Migrate teh NZ-SQL’s in to TD-SQL.
• Prepared teh High level Project Plan and full Implementation Plan.
• Prepared teh control-M document and schedule more TEMPthan 500 jobs.
• Test case preparation and execution.
• Validating and debugging teh job and SQLs
• Involved in production deployment and further production support.
• Code and deployment management through Git-hub
• Coordination between teams using various sources (WebEx, bridge calls and emails) to close open incidents and changes.

Confidential

Software Developer

Roles & Responsibilities:

• Developed Java classes in Servlet/JSP/Struts.
• Developed Shell scripts and SQL control files to load data through SQL Loader.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained teh batch processes using Unix Shell Scripts.
• Perform major role in static and dynamic UI pages for teh same.
• Performed major role in testing and fixing bugs related with teh module.

Confidential

Software Developer

Roles & Responsibilities:

• Developed Java classes in Servlet/JSP/Struts.
• Perform First level role in static and dynamic UI pages for teh same and also developed database design for users and user access rights. me have also done client site all validation for this site in java script.
• Performed major role in testing and fixing bugs related with teh module.
• Providing directions on how to use to an application to end users and key users.
• Managing client escalation to teh right group and resolving queries on priority basis.

Confidential

Software Developer

Roles & Responsibilities:

• Developed Java classes in Servlet/JSP/Struts.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained teh batch processes using Unix Shell Scripts.
• Perform major role in static and dynamic UI pages for teh same and also developed database design for users and user access rights. me have also done client site all validation for this site in java script.
• Performed major role in testing and fixing bugs related with teh module.
• Impact Analysis and Mapping of teh current process with new application functionality.
• Client side validation in JavaScript.
• Coordination with teh infrastructure team during server setups