PROFILE:

• Over twelve years and seven months of experience of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Ten years seven months of experience in Data Integration projects using IBM InfoSphere Information Server suite components.
• Around 2 years of experience in Hadoop projects.
• Two years’ experience on Java projects.
• Developed reusable assets: Parse DSX, ListDSFileNames and DOCIT Macro.
• Participated in providing Datastage trainings and UNIX trainings in Confidential and IBM with in the project team and at organization level.
• Developed File Watcher Report Automation script that reduces the production support team manual daily efforts of 2 hours.
• Proficient in analyzing and translating business requirements to technical requirements and implementation.
• Strong extensive experience with analysis, design and development of ES/GBS (Enterprise Solution/Global Business Solution) services using IBM InfoSphere Information Server suite components, database skills and UNIX shell scripting.
• Experience in leading and managing teams. Handled multiple roles - Technical Lead, Team Lead, Subject Matter Expert, Interface Designer and Developer.
• Executed software projects for Insurance and Retail industry.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS:

ETL: IBM Information Server - Suit v11.3/v8.1/8.0/7.5 Components Include IBM InfoSphere Fast Track, Information Analyzer, InfoSphere DataStage, InfoSphere Quality Stage and InfoSphere Optim.

RDBMS: Oracle 10g, Teradata 13.0.

Languages: Python 2.6.6, PL/SQL, UNIX shell scripting, Core Java.

Scheduling Tools: Autosys, CNTL-M and CA7.

Management Tools: Star team, Serena release control.

Functional Modules: Insurance, Retail.

O/S: Windows 7/XP Server, Linux.

GUI: SQL Developer, Teradata SQL Assistant, Hue browser.

Framework: IBM’s BDW (Banking Data Warehouse Model), IBM’s MDM (Master Data Management Model)

Cluster: Spark 1.6.0

PROFESSIONAL EXPERIENCE:

IT Specialist

Confidential, Charlotte, NC

Responsibilities:

• Customize, enhance and support future state model of ListDSFileNames and DOCIT Macro integration asset for existing and new engagements in Confidential project.
• Created PySpark script for daily balance Hadoop project and the configuration adjustments made is based on the nodes (executors and cores) in the prodfix Hadoop cluster decreased the run time for each date from 35 minutes to 8 minutes.
• Worked on Information Analyzer POC, enhancing the concepts of scheduling, runtime parameters, intermediate files/tables, record retrieval from IA DB and reporting capabilities.
• Created Teradata Stored Procedures to purge the data from the identified huge size tables. The logic is implemented using Stored Procedure cursor concept to loop through the tables. The Stored Procedure is written to be as generic for future use. The Stored Procedure also delete the records after archiving data into HDFS.
• Worked on Map Reduce java programs, Sqoop and HDFS commands for transferring the archive files to Hadoop File System and the performance optimization check with simple java programming and Map Reduce java programming.
• Developed Sqoop Unix script/Java programs to extract records from Teradata database and write it into a HDFS file.
• Implementation of assets (Parse DSX, ListDSFileNames and DOCIT Macro) created in response to business requirements to reach the new approach and high quality solutions to the client.
• Developed File Watcher Report Automation script that reduces the production support team manual daily efforts of 2 hours.
• Provided training on Unix Shell Scripting to the team of 20+.
• Worked on DS Upgrade project that migrates and validates the DS jobs of all DS RMW projects from DataStage V8.1 to DataStage V11.3. Prepared Inventory sheets that captures the DS Job details (Job Names, Autosys JIL Name, Source File, Target File, Database credentials, Script Names, shared containers Names, Parameter Set Names,Scheduled time) of all migrated jobs.
• Conducted and contributed in knowledge share sessions on technology and Confidential project business requirements with in the team.
• Translate customer requirements into design documents; establish specific solutions through InfoSphere DataStage Jobs, UNIX shell script, Autosys JIL’s and PL/SQL that culminate in client acceptance of the results.
• Responsible for management of trackers (Task tracker, Status tracker and Issue log tracker), change control (version control sheet) and migration documents (Production transition doc, DOCIT, Traceability Matrix and Change implementation plan) of the project.
• Accomplished and provided InfoSphere DataStage trainings to the graduate hires in IBM.
• Responsible for team wrap-up through External and Internal technical interviews.
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
• Appreciation Email from Confidential Client recognizing the quality, pace and transparency of deliverable in the project Confidential .
• Maintains current knowledge of technical innovations in database solutions and integration solutions, and develops plans to utilize appropriate technologies in support of future enterprise data integration requirements.
• Provide solution in design & building data integration modules using IBM information sever accelerators for real time data integration, shell scripting for complex computation and customize and implementation of the assets that is used across the teams and projects.
• Provide technical leadership for solution architecture development and review with regard to data integration architecture design and implementation for all initiatives within the Enterprise. Develop and drive the review / approval of data integration specific Solution definitions through the enterprise architecture review process.
• Collaborate with the data modeling architects, business intelligence architects, business analysts, and data subject matter experts to define standards and best practices that meet the needs of the business.
• Collaborate closely with other solution architects to define and implement effective and efficient solutions to business challenges and opportunities.
• Guide and mentor delivery teams in all aspects of Data Integration application design including Extract Transform Load, data movement, data replication, and data distribution.
• Collaborate closely with Enterprise Architecture to ensure alignment of the Enterprise Data Warehouse, Operational Data Systems and Master Data Management to ensure proper integration of data across the entire enterprise.
• Work closely with database administration to establish and maintain highly resilient, scalable, reusable, and high performance data integration patterns and architecture.

Environment: IBM Information Server V11.3 - Python Spark Scripts, Hue browser, Hive, Sqoop, InfoSphere DataStage, Teradata, Oracle, PL/SQL, Autosys, UNIX scripts and Star Team, Teradata Stored Procedures.

Technology Lead

Confidential, Bentonville, Arkansas

Responsibilities:

• Key task includes the implementation of script for FTP Put and FTP Get the files from remote server into landing zone. Also developed the generic script to extract the recursive job logs of a sequencer.
• Responsible to lead the team and deliver solutions to our customer.
• Involved in issue resolutions in tasks within the team. Few like junk characters in source, data type conversion issues, logical implementation issues.
• Work with Onsite coordinators to translate business requirements from Functional Requirements Document to Detailed Design Documents.
• Coordinate and communicate daily tasks with developers.
• Contributed in peer code reviews to ensure the development is performed as per the requirements.
• Work with QA to create test scripts and scenarios for enhancements and customizations to the core product.
• Communicate activities/progress to the project managers and clients for almost 15+ interfaces delivered in release R1.5.
• Took part in interviews to build up the team for release R2.

Environment: IBM Information Server V8.1 - InfoSphere DataStage, Teradata, Oracle, PL/SQL, Mainframe DB2, UNIX scripts, Autosys and Version Control.

Technology Lead

Confidential

Responsibilities:

• Responsible to gather requirements and its analysis, design, development and unit test cases for OT09-Sellable Item Data Interface.
• Extended assistance to the team to process the source data and to create output XML files and vice versa.
• Contributed in POC and created the CPU utilization chart for the InfoSphere DataStage jobs triggered. The POC is done on DEV environment and with the sample records available as source.
• Responsible for support of code defects, debug issues in IT and ST environment runs.
• Responsible to contribute on peer code reviews for Technical Design Documents and for code reviews.
• Certificate of Appreciation from Confidential for dedication and contributions to the PPO project.

Environment: IBM Information Server V8.1 - InfoSphere DataStage, Teradata, Mainframe DB2, and UNIX scripts, Share IT.

Technical Designer

Confidential, Bentonville, Arkansas

Responsibilities:

• Implemented the quality stage jobs to cleanse and standardize the data.
• Work with Onsite coordinators to gather business requirements.
• Formulate the technical design document and unit test cases of the interfaces.
• Coordinated to assign the task to the developers.
• Coordinate Onsite and Offshore calls to discuss on the weekly and monthly status reports.
• Maintained the Change Requirement, Status, Daily task, Issue log and Leave trackers.
• Responsible to conduct and participate in peer code reviews for Technical Design Documents and for code reviews.

Environment: IBM Information Server V8.1 - InfoSphere DataStage and InfoSphere Quality Stage, DB2, UNIX.

Technical Designer/Developer

Confidential

Responsibilities:

• Responsible to gather business requirements in functional document transition from Onsite client.
• Responsible in requirement analysis and prepared the design, development, unit test cases, unit test results and shell scripts for BPN SIL ProdFeed Interface. There is an individual script to run each interface.
• Successfully suggested the client and technical lead to have a single interface of BPN SIL ProdFeed instead of 5 interfaces; one for each source (ProductsByStore, EAN, Products, SFH and SKU).
• Successfully suggested the client and technical lead to create automation scripts that moves all interfaces source files from landing directory to the staging directory instead changing all the InfoSphere DataStage jobs to point to the new landing directory path.
• Responsible for implementation of a script that archives the log files older than 7 days of all the 5 interfaces.
• Responsible for support of code defects, debug issues in IT and ST environment runs.
• Responsible to conduct and participate in peer code reviews for Technical Design Documents, code and for UTP.

Environment: IBM Information Server V8.0 - InfoSphere DataStage and Web-Sphere MQ, SQL Server, UNIX scripts.

Technical Designer/Developer

Confidential, San Francisco, California

Responsibilities:

• Analyzed requirements and developed customized solutions for the interfaces involved in form of technical design documents, code, unit test cases and unit test results.
• Developed customized unit test results for test data available in DEV environment.
• Actively participated in code review meetings, knowledge transitions in the project and understood the concept to attain the standards in a project.

Environment: InfoSphere DataStage v7.5, Oracle 10g, DB2, Teradata, UNIX, Shell Script, CA7 scheduling tool.

Software Programmer

Confidential

Responsibilities:

• Developed program for the sub system module Payroll.
• Responsible for execution of unit test plans and integration test plans.
• Created traceability matrix and defect log tracker.
• Participated in Java trainings conducted in the organization.

Environment: Servlets, JSP, Java, JDBC, SQL Server.