As a Software Engineer Developer, proactive team player, and highly motivated assiduous individual with overall 3 years of total IT experience in Ab Initio development, shell scripting, and DB2 data warehouse applications play significant roles in banking and finance . Proficient in all phases of SDLC and Agile methodologies with extensive experience in Requirement Analysis, Design, Development, deployment, and Status Reporting.Experienced in full project life cycle from design to implementation to integration. Detailed understanding of Multistage components and Continuous graph concepts. Expertise in parallel processing concepts and successfully managed multiple development, modernization projects, and Production Support.
Soft Skills and Techno-Functional Abilities:
• Analyze the user stories, assess the code changes and estimates required for the overall effort
• Develop the technical solutions to support the data needs of American Express Global commercial applications including Regulatory, Third-party, and External customers
• Partner with Portfolio Solution Architect in preparing Solution Architecture Review documents and disaster Recovery documents to be compliant with the Software Development Life Cycle
• Hands-on experience and strong proficiency in ETL Ab Initio Batch, GDE, and EME
• Designed and deployed applications in different models such as star and snowflake schemas.
• Experience in Project coordination using the Onsite-Offshore model
• Designed, developed, and deployed solutions to perform Data Analysis, Data masking for PI Data, Data Cleansing, Data Transformation, Data Migration and Data validation Ab initio.
• Excellent knowledge of Data Extraction, Transformation and load to the target systems
• Prepare System Requirement Specification Documents, High-level Design, and Low-Level Design Documents.
• Conceptualized, designed, developed, and socialized variable reusable utilities and Unit Framework to perform unit Testing and validate the data per Design Document using Unix Shell Scripts and Ab initio metaprogramming.
• Designed and developed the generic pset creation to create the psets to execute the code using Unix shell scripting.
• Designed and built DML to DDL creation using Unix shell scripting to convert the DMLs to DDLs across environments and applied the rules to convert the fields.
• Worked with senior stakeholders to define high-level business requirements and translate business requirements into comprehensive, complete, and accurate functional and technical specifications
• Proficient in writing Business Requirement Documents, Software Requirement Specifications and customizing already existing business practices, workflows, activities, and deliverables
• Preparing graphical depictions of use cases including Sequence diagrams, activity diagrams, and use case diagrams including the business workflow
• Provide technical support to promptly resolve escalated incidents/outages
• Had a work experience in Service Now Tool and have knowledge on Python
• Have knowledge in designing ,Developing and testing ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.2, Analyzing data from various sources, including databases and flat files
• Works closely with other subject matter experts to help design and build solutions for a multitude of applications, including; batch processing, OLTP, OLAP and data and data warehouse architecture
• Facilitate Project Documents & Requirements walkthrough for Impacted Application's Test Team along with Business to ensure successful project delivery.
• Excellent verbal and written communication with the ability to effectively articulate an communicate vision, possibilities, and outcomes across all levels in the organization.
• Proficient with MS Office with a good understanding of Visio and Sharepoint.
• Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.
• Microsoft Azure Fundamental AZ-900. Completed
• Certified on DB2 9 Fundamental. Completed
• GCP-Associate Cloud Engineer. In-Progress
Work Qualification : Open Work Permit