OBJECTIVE

To work in a dynamic and environmentally flat organization wherein my technical knowledge, business understanding, relationship management, analytical and leadership skills can be utilized and further developed to create greater value for the organization and self.

SUMMARY

• 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 the same in a productive manner.
• Able to assess business rules, collaborate with stakeholders and perform source to target data mapping, design and review.

TECHNICAL EXPERTISE

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

Responsibilities:

• Developed Hadoop (Pig/Hive/Sqoop) scripts to handle big data.
• Designed and developed Jobs by using IBM DataStage that extract data from the file to Teradata database, cleanse it, transform it as per business requirement and populate the data into Teradata.
• Provided complex solution to handle the 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 the control-M document and schedule the jobs for the batch process.
• Created supporting shell scripts for Datastage/java batch jobs.
• Mentoring and knowledge 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 the team to investigate Root Cause Analysis (RCA) of the issues faced by key users.
• Test case preparation and help to QA team.
• Requirement gathering and its documentation in the form of User Requirement Specification (URS) or Business Requirement Document (BRD).
• Validating and debugging the job and SQLs
• Involved in production deployment and further production support.
• Code and deployment management through Git-hub/SVN.

Confidential

Developer / Lead

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 the 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 knowledge transfer to new team members.
• Prepared the control-M document (Jobs dependency document) and schedule more than 50 jobs.
• Weekly and Daily status reporting to stakeholders on incidents and project progress.
• Product parallel run Hadoop code Vs datastage to verify the 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

Technology: Hadoop (Pig, Hive, Sqoop). MSTR, Datastage, DB2, Teradata, SQL server

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 the 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 the 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 the team to investigate Root Cause Analysis (RCA) of the issues faced by key users.

Confidential

Developer /Project Lead

Responsibilities:

• Designed and developed Jobs by using IBM DataStage that extract data from the file to Teradata database, cleanse it, transform it as per business requirement and populate the data into Teradata.
• Migrate the NZ-SQL’s in to TD-SQL.
• Prepared the High level Project Plan and full Implementation Plan.
• Prepared the control-M document and schedule more than 500 jobs.
• Test case preparation and execution.
• Validating and debugging the 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

Environment: Oracle10g, JavaScript, Unix Shell scripting, Java (Servlets, JSP, Struts), Tomcat server.

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 the batch processes using Unix Shell Scripts.
• Perform major role in static and dynamic UI pages for the same.
• Performed major role in testing and fixing bugs related with the module.

Confidential

Software Developer

Environment: Oracle10g, Java (Struts), UNIX shell scripting, Tomcat server.

Responsibilities:

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

Confidential

Software Developer

Environment: UNIX shell scripting, JavaScript, Oracle10g, Java (Struts), WebSphere Application Server V6.0.

Responsibilities:

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