Technical Lead Resume
SUMMARY
- 10 years of industry experience, strong expertise in enterprise architecture, design & development of multiple solutions in distributed technologies using ETL tools.
- Have experience in full development life cycle (SDLC) involving analysis, design, development, testing, implementation and maintenance of ETL applications.
- Involved in reviewing legacy application architecture and worked on Tech uplift, Migration and Modernization in teh required applications.
- Have extensive experience in working on improving teh performance of highly utilized big ETL applications.
- Extensive knowledge in Data warehousing concepts and ETL tools such as Abinitio, Informatica, EME Metadata Hub and Unix Shell scripting and Database concepts in SQL, Oracle servers.
- Involved in teh Abinitio code review meetings like Solution Review board and Detail Technical Review Board to maintain teh ETL code standards across teh teams.
- Developed automation tool for feed file generation and Validation using UNIX Scripting, VB Scripting and SQL Scripts which have been significantly used in current Amex projects. This Framework TEMPhas automated manual processes and provided tremendous value additions and cost saving to teh client.
- Developed a generic outbound GUI to create outbound feeds for different internal and external client partners of AMEX. This resulted in a lot of development cost savings and reduced team efforts.
- Experienced on developing and deploying applications on ePaaS, Cornerstone, Solace messaging queues and Abinitio MQs.
- Experience in working wif multiple clients and geographically distributed teams.
- Experience in building and managing scalable distributed systems.
- Working on POC in migrating teh on - premise servers to cloud solutions like eCP.
- Working on POC to migrate teh current Abinitio jobs to Informatica using Cornerstone Database.
- Worked in POC for building API using Cornerstone Database.
- Worked on projects in waterfall, agile and Kanban methodology.
- Have high level knowledge on Snowflake Data Sharing methods.
- Have worked on an internal projec that involves monitoring DataStage jobs in Control M and CS jobs in Event Engine.
- Have high level knowledge on Spark, Puthon, Scala and NiFi.
TECHNICAL SKILLS
Technologies: AbInitio, Informatica
Scripts: Unix, Shell Scripting
Database and utilities: Oracle, MySQL, DB2, SQL Server.
Version Control Tools: EME, Metadata Hub
Case Tools: SCRUM, AGILE, SDLC, KANBAN
Scheduling Tools: Control M, XL Release
Cloud platforms: eCP
PROFESSIONAL EXPERIENCE
Confidential
Technical Lead
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Analyzing teh existing Legacy ETL applications.
- Understanding requirements for new business growth and new ETL infrastructure.
- Design documents like Mapping, HLD, LLD creation.
- Evaluating and identifying various technologies available to meet teh requirement.
- Building a comprehensive generic framework from scratch which meets teh business requirements and customer needs.
- Participated in code and design reviews and created a tool using shell script for code quality improvements.
- Create files for Integration and User acceptance testing and defect fixes.
- Project deployment in production and PIV.
- Align wif teh production support team for application impacts and support and risks associated.
Confidential
Technical Lead
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Responsible for entire application development & Dealt wif multiple projects at teh same time.
- Design & Development of Ab Initio graphs that run on a daily, weekly and monthly basis and FTP reports/files to client Servers.
- Creation of Unix wrapper scripts for supporting teh Graphs in teh PROD environment.
- Project management for teh respective modules.
- Assisting teh project manager for estimation/requisition of resources for teh project duration and their respective allocation/release.
- Analysis and gathering of requirements for new implementations.
- Coordinating and assisting teh team to ensure that teh tasks are delivered on schedule.
- Involved in Onsite-Offshore calls for providing clarifications and updating work status.
- Providing teh Review comments and methods to enhance teh Abinitio Jobs Performance.
- Execution of teh projects as per quality processes.
- Testing - E2E SIT and UAT.
- Production Support.
- Ensuring adherence to quality standards on teh deliverables made.
- Troubleshooting and defect fixing on teh delivered code.
- Respond to teh queries from business users and provide support to teh application.
Confidential
Technical Lead
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Worked extensively wif teh Data Analysis team to create mapping documents for teh comparison tasks.
- Extensively participated in requirements gathering sessions and contributed in documenting teh aligned discussions.
- Created complex Ab Initio graphs for comparison purpose of CIR - GCBC sources
- Worked wif Reformat, Rollup, Scan Join, Partition, lookups, Read Excel and Write Excel Components.
- Used teh sub graphs to increase teh clarity of graph and to impose reusable business restrictions
- Capacity of designing solutions around Ab initio, wif advanced skills in high performance and parallelism in Ab Initio
- Had been responsible for implementing data parallelism through graphs, which deals wif data, divided into segments and operates on each segment simultaneously through teh Ab-Initio partition components to segment data.
- Implemented error logging logic to capture teh rejected/wrong data in teh mapping for further analysis.
- Create/Maintain database stored procedures, functions, packages, views, types, tables.
- Worked wif Workflow Manager for teh creation of various tasks like Worklets, Sessions, Batches, Event Wait, E-mail notifications, Decision and to Schedule jobs.
Confidential
Technical Lead
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Prepared documents like HLD, LDD, solution architecture, security interaction and test case document etc.
- Understanding and preparation of requirements for teh user stories.
- Designing a basic framework that ensures maintenance of proper coding standards.
- Interacting wif teh other Team members and resolving teh concerns wifin teh other modules of teh Project.
- Considering teh challenges that are faced and documenting these and take it to teh clients for deciding on teh exact resolution Methods.
- Conducted Knowledge Transition (KT) sessions to other developers.
- Design & Development of Ab Initio graph that runs daily as per business requirements.
- Creation of Unix wrapper scripts for supporting teh Graphs in teh PROD environment.
- Worked in a sandbox environment while extensively interacting wif EME to maintain version control on objects. Sandbox features like Check In and Check Out were used for this purpose.
- Performing Transformations on source data wif Transform Components like Reformat, Filter-by-Expression, Rollup etc.
- Done appropriate unit-level testing, log defects in QC and teh management of teh review process for teh Ab Initio deliverables.
- Warranty Support.
Confidential
Sr Abinitio Developer
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Prepared documents like LDD, solution architecture, security interaction and test case document etc.
- Development of Ab Initio graph that runs daily as per business requirements.
- Worked in a sandbox environment while extensively interacting wif EME to maintain version control on objects. Sandbox features like Check in and Check Out were used for this purpose.
- Performing Transformations on source data wif Transform Components like Reformat, Filter-by-Expression, Rollup etc.
- Done appropriate unit-level testing, log defects in QC and teh management of teh review process for teh Ab Initio deliverables.
- Created different shell scripts and used them as pre/post session commands
- Created many files during teh process, fixed length record file was created in one of teh processes which is similar to teh XML layout.
- Closely worked wif Business Objects (BO) team to ensure proper data in teh reports
Confidential
Sr. Analyst Programmer
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Team coordination, issues escalations and proper handling teh situations
- Actively involving in all teh Team meetings, Weekly meetings and monthly meetings
- Coordination between offshore and onshore
- Monitor production environment for application generated alerts
- Receive, register and respond/acknowledge to tickets/user requests
- Monitor and execute scheduled activities
- Respond to support hotline
- In-depth troubleshooting of application/server/system
- Analysis of logs, errors and rejects
- Define additional monitoring in order to notify of problems, incidents, or SLA breaches
- Monitor teh scheduled activities like month-end jobs and build
- Coordinate wif operations team on ad-hoc request
- Create and update production support documentation
- Perform application availability check after OS/DB upgrades
- Support continuance of business testing and planning
- Code analysis and bug identification
- Analysis and follow-up long-running issues Perform Root Cause Analysis (RCAs)
- Purging and Archival of data in PROD and UAT environments
- Provided functional support during UAT for business users
- Execution of teh projects as per quality processes.
Confidential
Sr. Analyst Programmer
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Worked wif teh Data Analysis team extensively to create mapping documents for teh report generation.
- Have handled teh project alone throughout and well communicated and coordinated teh changes wif clients TEMPeffectively wifout any miss.
- As a developer worked on Abinitio graph creation from scratch as per teh business needs.
- Worked wif Reformat, Rollup, Scan Join, Partition, lookups, Read Excel and Write Excel Components.
- Used teh sub graphs to increase teh clarity of graph and to impose reusable business restrictions
- Capacity of designing solutions around Ab initio, wif advanced skills in high performance and parallelism in Ab Initio
- Had been responsible for implementing data parallelism through graphs, which deals wif data, divided into segments and operates on each segment simultaneously through teh Ab-Initio partition components to segment data.
- Worked in a sandbox environment while extensively interacting wif EME to maintain version control on objects. Sandbox features like Check In and Check Out were used for this purpose.
- Performing Transformations on source data wif Transform Components like XML reformat, Reformat, Filter-by-Expression, Rollup etc.
- Done appropriate unit-level testing, log defects in QC and teh management of teh review process for teh Ab Initio deliverables.
Confidential
Sr. Software Engineer
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Design and Development of Ab Initio graph that runs daily.
- Documentation.
- Worked wif Partition, De-partition, Sort and Transform Components for faster processing of data.
- Designing of a basic framework that ensures maintenance of proper coding standards.
- Interacting wif teh other Team members and resolving teh concerns wifin teh other modules of teh Project.
- Done appropriate unit-level testing.
- Was involved in Onsite- Offshore calls for clarifications and updating teh work status.
- Delivered on time all teh assignments that were assigned and responsible for.
Confidential
Senior Programmer
Environment: Ab Initio, UNIX, DB2
Responsibilities:
- Prepared documents like LDD, solution architecture, security interaction and test case document etc.
- Have implemented more TEMPthan 25 user stories so far in Kanban methodology.
- Designing of a basic framework that ensures maintenance of proper coding standards.
- Involved in extensive usage of Rally.
- Tasks completion wifin teh specified iteration.
- Story and task creation and allocation to teh team members.
- Day to day task updates in Rally board.
