SUMMARY

• Overall 11 years of IT experience with professional expertise in Application Development and Maintenance and Data Warehousing
• Extensive experience in Data Warehousing in Design Analysis, Development of ETL jobs and providing solutions in Banking and Financial Services using IBM Information ServerDataStage 8.7/9.1/11.5 , DB2 9.7, DB2 11.3 (BLU)
• Expert hands - on knowledge of Autosys scheduling techniques in a complex environment and mentored cross functional teams on the best practices and use of Autosys.
• Hands on knowledge using Autosys iDash for reports and SLA management
• Extensive experience in Technical documentation, understanding business requirements and functionality, preparation of system design with data flow diagrams
• Thorough understanding of the Autosys architecture
• Good experience in maintaining existing code and interacting with client and cross functional teams in enhancing applications.
• Strong experience in extracting data and integrating data from various data sources like Legacy Systems, Oracle, Teradata, SQL Server and Flat files
• Good experience in ensuring adherence to organizational data standards and development methodologies
• Expert knowledge in Datastage best practices and in designing ETL jobs for optimal performance
• In depth knowledge of Cloudera Hadoop Architecture and Ecosystem.
• Trained in different Hadoop ecosystem tools like - HDFS, Hive, Impala, Sqoop, Pig, HBase, Spark and also having good knowledge utilizing those tools in practical terms
• Experience with the Onshore/Offshore Support Model for application support as well as mentoring junior developers in offshore while developing code.
• Expert level skill in Datastage code reviews for helping in minimizing data processing flaws.
• Strong experience in debugging code issues in production, identifying root cause of defect and contributing in resolving issues
• Experience in creating required documentation for production support hand off, training production support team on commonly encountered problems
• Strong working experience in designing Datastage job scheduling outside the Datastage tool and also within the tool as required by Client/Customer company standards
• Hands on experience in System Testing and Integration Testing
• Good experience in working and communicating with Project Managers in providing estimations for development efforts to meet the project milestones and deliverables

PROFESSIONAL EXPERIENCE

Confidential - Agoura Hills, CA

Sr. Analyst & Developer

Responsibilities:

• Working with BKFS (Black Knight Financial Services) to be the new source of mortgage related information to 350+ BAC downstream applications.
• Involved in Requirements gathering meetings to understand the data flow, frequency of data loads and create mapping documents
• Analyzing business requirements and business rules, designing technical specifications, test cases for the solution provided, create high and low-level documents.
• Lead the project initiation of automating jobs’ execution using Autosys and deployed over 20K jobs.
• Designed and developed POC’s while providing possible solutions to meet business requirements or enhancements
• Used Autosys to schedule the DataStage ETL batch jobs on a daily, weekly and monthly basis which included creations of Jil’s (File watcher, Command & Box jobs), creating & modifying existing Calendars
• Providing in-house Autosys training for cross functional teams on best practices and standard naming conventions.
• Serving as a fully proficient technical resource when issues arise and be able to pin point the issue and triage the issues for onshore/offshore teams to fix.
• Design and develop Datastage jobs for Extracting, Transforming and Load processes and Master Sequences to meet complex business requirements.
• Develop common code ( shared containers) for reusability by extracting data from database tables for the given input values and providing return values, which can be used by multiple interfaces
• Develop Job streams (sequences) for regular processing, reprocessing for corrected data while creating target data for downstream business users
• As a Code Reviewer, involved in code review sessions and recommended possible job modifications to enhance job performance and to meet design standards.
• Supporting business users during User Acceptance Test.
• Executing and coordinating the Performance tests and Business line testing.
• Working on the Performance Tuning of the Datastage jobs.
• Coordinate with the downstream consumers of the application, understand the issue or requirement gap and make the necessary changes in the high/low level documents to bridge the gap. This also includes identifying the bug which is resulting in the issue and working with the offshore team to fix the issue and get it deployed to right environment at the earliest without impacting the delivery timings.

Environment: Autosys, IBM InfoSphere DataStage 11.5, Oracle, DB2, SQL Server, Linux, iDash, TOAD, Rally, JIRA

Confidential - New Castle, DE

Sr. Software Engineer

Responsibilities:

• Took care of production parallel batch cycles in UAT environment(Autosys Schedules)
• Execute and debug the Ab Initio jobs that Extract, Transform and load data from source systems.
• Created Automated processes to invoke jobs based on the need and to generate report of the execution stats.
• Worked closely with developers in closing the defects identified in the UAT.
• Worked on automated reports from Autosys for the team
• Interacted with Onshore/Offshore teams and mentoring team members
• Conducted weekly status meeting with the Business/Executive team.
• Coordinated with Business for UAT, Status meetings.
• Provided help in fixing the issues based on severity levels.

Environment: Ab Initio, DB2 9.7, Autosys, Unix Shell Scripting

Confidential

Senior Datastage Developer

Responsibilities:

• Developed Interface System Design (ISD) documents for Datastage which explains the role of Datastage as middleware, which gets source data from various sources and sends data to various downstream environments including Mainframes, Linux and various DB2 environments
• Designed and developed POC’s while providing possible solutions to meet business requirements or enhancements
• Designed and developed DataStage jobs for Extracting, Transforming and Load processes and Master Sequences to meet complex business requirements.
• Developed common code ( shared containers) for reusability by extracting data from database tables for the given input values and providing return values, which can be used by multiple interfaces
• Developed Job streams (sequences) for regular processing, reprocessing for corrected data while creating target data for downstream business users
• Decommissioned the interfaces built on the legacy databases(DB2 v9.2 and Vertica) and built new interface jobs that source data from/to the new DB2 BLU database
• Worked on decommissioning the existing 30K Autosys jobs and consolidated them into 16K jobs by identifying and eliminating redundant jobs
• As a Code Reviewer, involved in code review sessions and recommended possible job modifications to enhance job performance and to meet design standards
• Involved in Datastage job design standards, naming conventions to implement best practices in job development
• Interacting with Onshore/Offshore development teams and mentoring developers in developing DataStage jobs and job designs
• Conducted weekly status meeting with the Business/Executive team.
• Coordinating with Business for UAT, Status meetings.
• Providing help in Production support, for estimating time lines after verifying the DataStage director logs, in fixing the issues based on severity levels

Environment: IBM Infosphere Datastage 9.1, Unix Shell Scripting, DB2 9.7, DB2 11.3 (BLU), Autosys, Linux, Teradata