We provide IT Staff Augmentation Services!

Senior Ab Initio Developer Resume

0/5 (Submit Your Rating)

Columbus, OhiO

SUMMARY

  • More than 8 years of experience in Analysis, Design, Development, Testing, Implementation and Support of Ab Initio, Unix and Mainframe applications in Core Banking domain
  • Exceptional skills in designing, enhancing and supporting applications using Ab Initio Graphical Development Environment, Technical Repository Management Console and Operational Console hosted on Red Hat Enterprise Linux servers
  • Proficient in all phases of Software Development Life Cycle, Project Management techniques and Quality practices such as Six Sigma
  • Well experienced in building and implementing ETL solutions based on data warehousing concepts such as Facts, Dimensions, Star schema, Snowflake schema, Slowly changing dimensions, etc.
  • Knowledge in version control, dependency analysis, impact analysis using EME
  • Exceptional analytical skills with an ability to transform the needs of business users and stakeholders into functional/technical requirements
  • Experienced in working on complex requirements, building large plans/graphs involving complex transformation logic with efficient performance using parallelism techniques and simple and easy on - the-go plans and graphs for instant reports and statistics
  • Well versed in analysing and identifying performance tuning opportunities in plans, graphs and transformation rules
  • Experience in Unix shell scripting to build various ad-hoc reports, tools and value adds
  • Highly Skilled in writing simple and complex SQL queries in dealing with tables from databases such as DB2, Oracle and Teradata
  • Extensive knowledgein data analytics, business intelligence concepts, data integration and agile methodology
  • Extensive experience in Gap Analysis, Impact Analysis and Root Cause Analysis in complex financial projects
  • Worked on multiple projects for on-boarding new statements processing from inception to implementation, delivering high quality deliverables in a timely manner
  • Strong in analytical ability, problem solving techniques, verbal and written communications, presentation and inter personal skills
  • Excellent leadership quality and managerial skills including experience in driving teams from remote locations

TECHNICAL SKILLS

ETL Tools: Ab Initio Graphical Development Environment, Technical Repository Management Console, Enterprise Meta> Environment, Operational Console, Ab Initio Conduct>It

Operating Systems: Red Hat Enterprise Linux, z/OS, Windows

Languages: Abinitio Programming, UNIX shell scripting, COBOL, REXX, Easytrieve, PL/SQL, C, C++, Java, Perl

Database Systems: DB2, IMS, Oracle, Teradata

Specialized Software: Squirrel, Toad, File Aid, sFTP, OpenTextExstream, HP Service Manager

Quality: Lean Six Sigma

PROFESSIONAL EXPERIENCE

Senior Ab Initio Developer

Confidential, Columbus, Ohio

Responsibilities:

  • Attend Requirement meetings to gather business and technical requirements for a project
  • Come up with high level design and detailed technical design
  • Be a part of the Sprint planning meeting, daily stand up calls, Sprint review meeting and retrospective meetings of Agile team to provide input and valuable feedback.
  • Create ETL code by developing Ab Initio plans and graphs by following best practices, established coding standards and naming conventions
  • Develop Ab Initio plans and graphs to extract data from source system databases that include DB2 and Teradata, transform extracted data using components like scan, rollup, reformat according to business rules and mappings and load to target DB2 databases
  • Develop data warehousing models using Inmon top-down approach and Kimball bottom-up approach
  • Create, configure and schedule batch jobs using Ab Initio Operational Console and Control Center
  • Setup automated monitoring, SLA checks and alerting mechanism using Tivoli
  • Write shell scripts to automate repetitive tasks, to create statistical reports and invoke Ab Initio psets, plans or graphs
  • Create Ab initio graphs to generate and send XML based webservice requests and parse the response file using XML components
  • Test the code thoroughly in both IST and UAT environments with all possible test cases and through regression testing and stress testing
  • Collaborate with QA team in performing functional testing, positive/negative testing and boundary condition testing
  • Come up with detailed implementation plan to install the code in Production environment after carefully considering the peak processing times to ensure least impact to production
  • Verify and validate code deployment after the implementation is complete and perform production simulation testing
  • Provide post-implementation support and support future enhancements
  • Document test results, observations, best practices and lessons learnt during the course of the project
  • Lead, delegate and co-ordinate above tasks and responsibilities for a team of 6 Ab Initio developers
  • Review code changes made or developed by offshore for best practices, standards, quality of the deliverable, etc.
  • Always look for opportunities to improve the performance of code and implement them

Ab Initio Developer

Confidential, Columbus, Ohio

Responsibilities:

  • Gather business and technical requirements for a project
  • Come up with high level design and detailed technical design
  • Be a part of the Sprint planning meeting, daily stand up calls, Sprint review meeting and retrospective meetings of Agile team to provide input and valuable feedback.
  • Develop Ab Initio plans and graphs by following best practices, established coding standards and naming conventions
  • Develop Ab Initio plans and graphs to extract data from source system databases that include DB2 and Teradata, cleanse and transform extracted data using components like scan, rollup, reformat and write to target DB2 databases
  • Write shell scripts to automate repetitive tasks, to create statistical reports and invoke Ab Initio psets, plans or graphs
  • Create, configure and schedule batch jobs using Ab Initio Operational Console and Control Center
  • Test the code thoroughly in both IST and UAT environments with all possible test cases and through regression testing, stress testing, positive/negative testing and boundary testing
  • Come up with detailed implementation plan to install the code in Production environment after carefully considering the peak processing times to ensure least impact to production
  • Verify and validate code deployment after the implementation is complete and perform production simulation testing
  • Provide post-implementation support and support future enhancements
  • Document test results, observations, best practices and lessons learnt during the course of the project
  • Coordinate with offshore team on all above activities by designating tasks as part of project development, testing and implementation
  • Always look for opportunities to improve the performance of code and implement them

Ab Initio/Mainframe Developer

Confidential

Responsibilities:

  • Lead offshore team and drive projects according to timelines and deliver quality output
  • Develop new source programs, make code changes using COBOL according to the design provided
  • Develop new graphs and plans or make code changes to existing components using Ab Initio GDE according to the requirements and design provided
  • Perform Unit Testing, IST and UAT testing for various test cases identified
  • Participate in project status meetings with onshore and report on the status, issues and lessons learnt
  • Create supporting documentations for the projects such as Support Manual and Quick Reference Guides
  • Provide post-implementation support for production issues arising, if any

We'd love your feedback!