SUMMARY

• I am Programmer Analyst with total 7 years of experience in healthcare and banking domain applications.
• 2 years of current experience in ETL Applications Development.
• 5 years of experience in Web Applications Development.
• I am customer - focused, results-driven and articulate with good analytical skills.
• I am strong in design and integration with good problem-solving skills.
• I have technical experience in Ab Initio, UNIX scripting, Mainframe files, ORACLE 11g, TERADATA Database, Python scripting, IBM UNICA, IBM Tivoli “JS console”, Rally, PHP, Java, C#, .NET, MySQL, with database analysis and design.
• I Have knowledge of ABI BRE to design business rules.
• As a part of automation process I have worked on Java batch application to support creating offer/campaign in IBM UNICA tool and also created python scripts to automate testing of Ab Initio application.
• Skilled in developing business plans, requirements specifications, user documentation.
• I have played Instrumental role in Business requirement gathering and preparing a Source-Target mapping document for ETL.
• I have Strong written and verbal communications.
• I am Interested in a challenging technical track career in an application development environment that appreciates pro activity and promotes a work culture that encourages stepping beyond role descriptions.

TECHNICAL SKILLS

ETL Tool: AB INITIO

Programming Languages: PYTHON, AWK, UNIX scripting, C#.NET, PHP

Database: SQL Server 2005/2000, MYSQL, ORACLE, TERADATA

Scheduling Tool: IBM Maestro/Js Console

Frameworks: .NET, AngularJS, jQuery, RequireJS, PHPUNI, NUNI, JUNIT

CMS: WORDPRESS, KENTICO, SharePoint 2013/office 365

Project Planning Tools: Microsoft Project management (MPP), Rally

Versioning Tool: GITHUB, EME, TFS

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer / Onsite Consultant

Responsibilities:

• Developed AB Iinito batch processing application capable of processing high volume customer, campaigns and Offers data efficiently.
• Managed and process mainframe file created by Campaign/Offer and target customer.
• Troubleshoot and Resolve Ab-initio ETL applications and data validations and issue resolution.
• Schedule batch jobs scheduler tool of IBM Tivoli “JS console”.
• During Dress Rehearsal (Test Run) running the application in various test regions and Cross check and validate the Source and O/P file data and format passed further to other teams.
• Use UNIX commands/scripts to debug issues/validate data created by applications.
• Gather business requirement from BA/product owners and create requirement documents which include data mapping models and business logic and application flow details.
• Worked on user stories created in rally and release the features as a part of sprint.
• To support existing application, worked for Production support environment on Ab-initio ETL, UNIX.
• Worked on Java spring boot batch processing application to automated campaign and offer creation process.
• Developed python scripts to validate Ab - initio application before installing on production server.
• Maintain java/python code versions using GITHUB.

Confidential

ETL Developer / Onsite Consultant

Responsibilities:

• Updated ABI graph to handle and manipulate DPL campaign/Targeted Customer Data based on issues identified and changed requirements.
• Managed and process mainframe file created by Campaign/Offer and target customer.
• Troubleshoot and Resolve Ab-initio ETL applications and data validations and issue resolution.
• Schedule batch jobs scheduler tool of IBM Tivoli “JS console”.
• During Dress Rehearsal (Test Run) running the application in various test regions and Cross check and validate the Source and O/P file data and format passed further to other teams.
• Use UNIX commands/scripts to debug issues/validate data created by applications.
• Gather business requirement from BA/product owners and create requirement documents which include data mapping models and business logic and application flow details.
• Worked on user stories created in Rally and release the features as a part of sprint.
• To support existing application, worked for Production support environment on Ab-initio ETL, UNIX.

Confidential

Programmer Analyst / Onsite Consultant

Responsibilities:

• Developed a website change Request Manager, a request management application using SharePoint 2013 and developed Data Migration application to migrate data from Lotus Notes to SharePoint 2013 online.
• Created wiki pages with the WSCR list details on it.
• Implemented email Notification functionality Using SharePoint Rest APIs and people picker and jQuery.
• Used data view webpart to display list details and configured to show customize results.
• Created Rest API data source for WSCR history log so that it can be viewed and available on SharePoint 2013 WSCR application for review.
• Used Infopath form to create WSCR email templates form.
• Created workflow to trigger notification email when WSCR is logged.
• Created JSON format data migrated from Lotus Notes using lotus Notes .Net library so that it can be ready for import in any database.
• Requirement analysis and gathering of the project.
• Creating user stories and tasks based on requirements.
• Review feedback, Follow up with team, manage client requests and clarify queries.
• Providing demo after iteration is complete.

Confidential

Programmer Analyst / Onsite Coordinator

Responsibilities:

• Developed complete dynamic client/server website using C#, PHP using CMS like Kentico, Wordpress, Joomla, Drupal.
• Developed Custom modules like events calendar, Patient registration, Contact forms, Bill payment using paypal, embedded online login form.
• Extensively used jQuery and Angular Js for creating frontend web pages and forms.
• Created and managed database design for website using SQL server, MYSQL.
• Used TDD approach using PHPUNIT testing framework to create PHP modules events calendar.
• Implemented Single Sign On using PHPSSO framework and Tivoli IBM server.
• Used Rest Api to data fetch and work with data.
• Managing and maintaining existing websites on daily basis through Ticket Management System.
• Used Microsoft TFS (Team Foundation Server) to maintain code versions.
• Creating project plans for ever website and custom modules developed using Microsoft project management (MPP).
• Followed Agile method to develop websites and custom modules.
• Created Websites and application pools on IIS6/7 webserver.
• Handle deployment process for stage and production environment.
• Requirement gathering from client through Conference calls and SKYPE on daily basis.
• Perform code review, unit testing and implementing best practices.

Confidential

Programmer

Responsibilities:

• Communicating with the client for understanding requirements.
• Redesigning and maintenance of client websites.
• Perform Data migration through scripts.