SUMMARY

• Solid experience in Data Warehousing and Data Integration/Data Ingestion Projects based on ETL Ab Initio tool.
• Experience in Architecting and Designing ETL Applications both Real time and Batch Processing’s using one of the most Niche ETL tool Ab Initio.
• Worked on Ab Initio MetadataHub and Express IT.
• Having in depth knowledge of Technical Designing, Managing and delivering ETL projects end to end.
• Very well versed in designing Fault tolerant, highly available, Parallel processing or distributed processing applications.
• Considered Auditing, Reconciliation and Disaster recovery scenarios while Architecting the applications.
• Always Designed and Developed ETL projects considering Ab Initio Best Practices and Standards.
• Experience in designing, developing and deploying Ab Initio Graphs, coordinating testing and production deployments, efficient in trouble shooting and performance enhancement.
• Intermediate experienced in Big Data ecosystem experimenting/exploring - Syncsort, Git Hub, Pig, Hive, Hadoop, HDFS, AWS.
• Intermediate experience in AWS Cloud Platform and its features such as S3, EC2 and Redshift.
• Strong exposure to data quality best practices and data governance.
• Progressive IT industry experience in project / delivery management and client relationships.
• Vast experience of working with direct Bank Business Analysts and Solution Architects.
• Hands on with Erwin data modeler for designing/Editing Business data models.
• Ability to understand SQL statements and relational database internal processes.
• Utilize Waterfall and Agile software development model.
• Demonstrated leadership skills in working with multiple cross-functional teams in major organizations.
• Outstanding drive and focus on organizational objectives and customer need.
• Upskilled and Cross-skilled new/existing resources by facilitating adequate trainings on technologies required on the project.
• Strong change management expertise including risk mitigation, infusing new ideas and providing value adds.
• Skilled in project implementation, project scoping, risk and feasibility analysis, functional mapping, designing project schedule, change management, quality and delivery management.
• Delivered high quality solutions in a timely manner meeting and exceeding the business expectations. This involved working with business change managers, technology managers and business sponsors
• I have acquired strong stakeholder management skills and exposure to various proven industry standards which will help me provide strategic inputs to any future role I am involved with.
• Worked in distributed and multicultural working environment and worked physically in US, UK and India. Results oriented and always keen to learn new technologies to acquire more business skills.

PROFESSIONAL EXPERIENCE

Confidential

Ab Initio Solutions Architect

Responsibilities:

• Responsible for Project delivery from technology side involving Ab Initio design and architecture, development and testing in Dev and all higher environments and deploying the final code into Production.
• Ensure Best Practices are followed for reducing redundancy of code and major focus on improving Performance and reusability of artifacts across the projects.
• Handling Onsite and Offshore resources maintaining equilibrium in work distribution, team satisfaction and getting effective output to meet deliverables on time.
• Worked on Ab Initio design documents, development, scheduling and execution of jobs through control center.
• Works with stakeholders and functional areas to understand and develop Business requirements.
• Involved in Design meetings, Discussing FRD’s (Functional requirement document) with BA’s and creating HLD’s for Technical Implementation.
• Define strategy, roadmap, and Data governance process for ETL Ab Initio engagements.
• Sets deadlines, assigns responsibilities, mentors, and monitors progress of the team.
• Involved in discussions with Infrastructure Teams to understand the Storage allocations made for different environments to support daily volume of data.
• Focused on Data Quality and supports the DQ teams on all issues identified in Testing environments.
• Leading the responsibility to drive innovation based on data, which is a first-time effort in the organization to move towards completely data driven business.
• Build POC for Big Data Ingestion Tool for migrating existing Mainframe feed to Hadoop environment.
• Build POC to improve performance of data processing by using appropriate data compression formats (Parquet/Avro).
• Build POC on Analytics reports using Tableau.

Confidential

Application Delivery Lead

Responsibilities:

• In this role migrated approximately 500 feeds from AB Initio to new AWS platform bringing down the cost from legacy applications.
• Assisted client in reducing the AB Initio licensing cost by enabling Big Data technology framework.
• Build POC for Big Data Ingestion Tool for migrating existing Ab Initio code.
• Design POC s for converting existing ETL graphs to Hadoop HDFS ecosystem.
• Designed application to move data from Ab Initio/Teradata to AWS redshift.
• Managed multiple data warehousing/business intelligence related projects directed toward strategic business and other organizational objectives.
• Support Big Data Business Lake programs.
• Define strategy, roadmap, and Data governance process for ETL/Big Data engagements.
• Design and deploy AWS solutions using EC2, S3 and Redshift.
• Installed application on AWS EC2 instances and configured the storage on S3 buckets.
• Design and program logic for data transformation.
• Build, test and deploy interfaces using ETL tool Ab Initio/Snaplogic.
• Design programming logic for data transformation as per requirements of the business.
• Built the Big Data Offshore team for Confidential PDW.
• Interact with clients on technical complexity and provide end to end solutions.
• Design and program logic for data transformation using Ab Initio.
• Build, test and deploy interfaces using ETL tool Ab Initio.
• Design programming logic for data transformation as per requirements of the business.
• Interact with clients on technical complexity and provide end to end solutions.
• Migrated Ab Initio project to new platform using Big Data tools/AWS to create a robust application for Confidential .

Confidential

Application Development Lead

Responsibilities:

• Handled a team of 15 resources involving both Developers and testers working on Data warehousing Projects.
• Performed requirement gathering and analysis of incoming reference data.
• Designed programming logic for data transformation as per Business rules and Mappings.
• Built ETL process technical design documentation in real time using Continuous flows.
• Built, tested and designed interfaces using ETL tool Ab Initio.
• Created low level design based on high level design documents.
• Built, tested and deployed interfaces using ETL tool Ab Initio.
• Provided Quality Assurance support to the QA team.
• Facilitated testing process in UAT/QA region.
• Scheduled production jobs using control M scheduler.
• Performed process definition and functional mapping, design BRD in co-ordination with technology team.
• Defined business rules with client to provide accurate reports to regulatory bodies, and design and functional testing of ETL processes.

Confidential

Onsite ETL Lead - Credit Risk Portfolio

Responsibilities:

• Onsite lead for delivery of ETL piece of major Credit risk program.
• Worked and managed the Data Integration and datawarehousing projects from inception to implementation. Delivered high quality solutions in a timely manner meeting and exceeding the business requirements. This involved working with business change managers, technology managers and business sponsors.
• Designed and created numerous Data mappings/workflows to move data from source to target data warehouse as per business needs.
• Done data profiling to clean the data to make it fit for purpose.
• Participated in data architecture reviews of applications as part of the project lifecycle and ensured that data governance processes are established and integrated in existing systems as well as in the formation of new and revised systems.
• Gathering business requirements and preparing design and technical specifications to fit into enterprise architecture level.
• Following up the Ab Initio standards and using best Ab Initio Best practices to give performance