SUMMARY

• Experience as Data Engineering,Migration and Analytics using Databricks, Spark, Scala, Pyspark.
• Experience in designing application and automation framework using Amazon EC2, Amazon S3, Kinesis, Lambda, Aurora, Dynamo DB, API Gateway, SQS, CloudFormation, CloudFront.
• Experience in REST API and Webservices.
• Experience in Dashboard design for Scheduler and Healthcheck of various applications.
• Experience in Chatbot design & development using Natural Language processing and Web scraping.
• Experience in Docker/Container for automation apps deployment and maintenance.
• Experience in build tools like maven, jenkins.
• Experience in scheduler AROW for job automations.
• Experience in application development, production support and providing architectural assessment for Mainframe applications on platform OS/390 using COBOL, CICS, JCL, SYNCSORT, VSAM, DB2, EASYTRIEVE, Web Services, ISPF, PERL, DBeaver and TOAD, Intertest, Tracemaster, Expediter,
• Extensive experience working as an onsite coordinator attending the project review meetings wif Clients, gathering requirements, preparing High Level Design (HLD), Low Level Design (LLD), transitioning the requirements and design to offshore for the Build activity.
• Experience working in the domain of Healthcare, Retail & Security & Banking applications. Extensive hands on experience on Confidential Mainframe Application programming
• Experience in maintaining the Confidential DB2 as Junior Database Administrator.
• Excellent working knowledge in Core Application design, Development, Testing and Production support. Experience working on developing DB2 Stored Procedures & online CICS tools.
• Knowledge on all QMS (Quality Management System) processes like Project initiation, Detailed Requirements Specifications, Impact Analysis, System Run Chart (flow chart), Program Specifications, Operation Manual, Program Development, Coding, Unit Test Plan, System Test plan, Inter System Test plan, Implementation plan and Post implementation check etc.

TECHNICAL SKILLS

Cloud Technologies: Amazon EC2, Amazon S3, Kinesis, Lambda, Aurora, Dynamo DB, API Gateway, SQS, CloudFormation, CloudFront. Snowflake, Glacier, Sage maker.

SOFTWARE PRODUCTS: Apache Spark, Scala/Pyspark, Python,, Docker, VS COBOL - II, Confidential MQ Series, SQL, JCL, Connect Direct, CICS, CA-7, TSO / ISPF, Confidential Utilities like DFSORT, ICETOOL. Confidential Data Studio, Control M, Github.

Databases: DB2, MondoDb, Postgres, Dynamo Db.

Mainframe Tools / Technologies: VSAM, ISPF, IDCAMS, Tracemaster, SPUFI, File AID for DB2, QMF, SPUFI, File AID, INSYNC, Endevor, BMC, MQ Series, Core JAVA, PERL scripting, Global File Transfer System, Easytrieve, Artificial Intelligence using Machine Learning & NLP.

Domain Expertise: Healthcare/Medicare, Retail - Merchandise Positioning & Pricing and Security and Banking - Trade Router.

Confidential, Rolling Medows, IL

Responsibilities:

• Design Retail Credit Card data transformation and migration from Mainframe to Cloud based platform - Using Cloud based technologies EC2, S3, Postgres, REST API, Spark, Scala/Pyspark, Shell Script.
• Setup Sensitive data Scanning tool on S3 and cloud based data stores..
• Development of apache pyspark and scala scripts for data mapping and profiling of various customer and card related data which can be loaded to Snowflake tables.
• Designing and development of REST wrapper api in order to insert/update/delete data in cloud based relational databases(Postgres or dynamoDb).
• Syncing legacy system tables betweeen cloud based postgres tables and db2 tables using mainframe tools and technologies jcls, cobol,db2.
• Design and Development of new Automation scripts to generate Business intelligence report using Python.
• Preparation of TS (Technical Specifications) based on the existing functionality and requirements.
• Supporting the production mainframe batch jobs - COBOL, DB2, JCL & VSAM, including table maintenance i.e. reorg, imagecopy, cleanup.

Technologies: AWS - Amazon EC2, Amazon S3, Kinesis, Lambda, Aurora, Dynamo DB, API Gateway, SQS, CloudFormation, CloudFront. Snowflake, Glacier, Sagemaker Python,COBOL, JCL, Endevor, DB2, REXX, Abnitio ETL tool, Control M

PROFESSIONAL EXPERIENCE

Automation Architect,

Confidential, Naperville, IL

Responsibilities:

• Design and development of Mission critical incident creation based on email alert(i.e Server failures, Critical claim abend, critical reporting) using Linux, Postfix, Docker, Python, Mongodb,.
• Develop Automated dashboard using python/Django framework.
• Design & Development of Auto ticket resolver using Machine Learning algorithms and analytics tools.
• Design healthcare data from Mainframe to Cloud based platform - Using Cloud based technologies EC2, S3, Postgres, REST API, Spark, Scala/Pyspark, Shell Script.
• Development of Mainframe CICS screen prints Image processing using Python/Tesseract.
• Design & Develop Digital Chatbot application using Natural Language Processing, Python’s Flask framework and web scraping thru selenium.
• Design and Development of new Automation scripts to generate Business intelligence report and Dashboard using Python.
• Design Critical job Monitoring and notification of mainframe schedule using Python and Mainframe Zeke scheduler.
• Preparation of TS (Technical Specifications) based on the existing functionality and requirements.
• Created detailed technical design specification for enhancing the batch programs, care was taken to re-use most of the existing components/modules.
• Development of the new batch programs using COBOL, DB2, JCL & VSAM

Lead Engineer,

Jefferson City, MO

Responsibilities:

• Providing architecture solutions and identifying bottlenecks in the existing application
• Creating and running DB triggers and Stored procedures.
• Analyze and understand the requirements & functional specifications.
• Conduct JAD to review the business document wif a team of business end users, application developers and technical analysts.
• Preparation of TS (Technical Specifications) based on the existing functionality and requirements.
• Created detailed technical design specification for enhancing the batch programs, care was taken to re-use most of the existing components/modules.
• Knowledge Transfer to the offshore team wif business functionality and the new requirements.
• Worked closely wif Web Team to develop customized Web application for Healthcare providers.
• Worked wif and assigned tasks to ETL team for Data warehouse processesMigrating data from Db2 to Oracle Datawarehouse.
• Maintaining COBOL/IMS based program.
• Development of the new batch programs using COBOL, DB2, JCL & VSAM
• Development of Easytrieve programs for reporting and provider/agent updates
• Maintaining infrastructure using Global File Transfer System on Z/os mainframe.
• Development of Electronic Data interchange map(834) using WTX Transformer Pack.
• Setting up Process to be followed from Offshore.
• Perform Peer review and log any issues and track till it is closed.
• Database Design and maintaining as DBA using Toad and Dbeaver.
• Using Runstat, Imagecopy, Load/Unload utilities on Db2 tables.
• Creating and running DDL, DML statement, using Explain to optimize query.

Environment: COBOL, JCL, Endevor, IMS and DB2, ORACLE Confidential WTX Extender, PERL, Core Java, Control M, Easytrieve

Lead Engineer,

Philadelphia, PA

Responsibilities:

• Analyze and understand the requirements & functional specifications.
• Conduct JAD to review the business document wif a team of business end users, application developers and technical analysts.
• Preparation of TS (Technical Specifications) based on the existing functionality and requirements.
• Prepare turnover elements check list to make the turnover process is seamless.
• Responsible for correct versioning of code by creating and moving the requests using configuration management tools.
• Status Reporting and Responsible for the final delivery.
• Created detailed technical design specification for enhancing the batch programs, care was taken to re-use most of the existing components/modules.
• Knowledge Transfer to the offshore team wif business functionality and the new requirements.
• Development of the new batch programs using COBOL, DB2, JCL & VSAM
• Setting up Process to be followed from Offshore.
• Perform Peer review and log any issues and track till it is closed.

Environment: COBOL, JCL, SCLM, VSAM, CICS, MQ and DB2

Mainframe Developer,

Confidential,

Responsibilities:

• Providing architecture solutions and identifying bottlenecks in the existing application
• Analyze and understand the requirements & functional specifications.
• Preparation of TS (Technical Specifications) based on the existing functionality and requirements.
• Created detailed technical design specification for enhancing the batch programs, care was taken to re-use most of the existing components/modules.
• Created detailed design for Data warehouse process built to migrate data from z/os Db2 to Oracle Db.
• Created high level design for creating report out of ORACLE DW.
• Development of the new batch programs using COBOL, DB2 & IMS DB, JCL & VSAM, MQ.
• Development of Easytrieve programs for Trades/securities reporting.
• Debugging and implementing the system using Confidential Debug tools.
• Involved in preparing test plans for Independent Unit testing and System testing.
• Impact analysis for requirement changes, finding effected list of programs and homogeneous implementation.
• Perform Peer review and log any issues and track till it is closed.
• Prepare turnover elements check list to make the turnover process is seamless.
• Responsible for correct versioning of code by creating and moving the requests using configuration management tools.
• Status Reporting and Responsible for the final delivery.