SUMMARY

• Project Lead wif overall 10+ years of results - oriented, progressive experience in application development and support to batch and transactional.
• Exposure to data quality analysis, data migration and data validation.
• Experience in using Apache Spark, Hive, Scoop, Flume and Cloudera Manager.
• Cloudera certified Spark and Hadoop developer
• Hands on experience in importing and exporting data using Sqoop from HDFS to Relational Database Systems and vice-versa.
• Professionally adaptable to 'get on board' quickly wif new technologies and new assignments, able to work independently or in a group/team setting to meet deadlines while handling multiple assignments.
• Hands on experience in developing applications using Apache Spark's APIs and SparkSQL
• Healthcare domain experience of close to 10 years wif detailed knowledge on Membership Enrollment, Claims Adjudication process and provider systems.
• Excellent communicator, leverages technical, business and financial acumen to communicate effectively wif client executives and their respective teams
• Performed teh role of 'PITL' (Primary IT Lead) for Confidential 's VA provider and NY Provider area, which involves teh full lifecycle from problem identification, initiation, prioritization, scoping & estimating, budgeting, resourcing, scheduling, monitoring and tracking, implementation and closure of work efforts
• Exposure to design, development and implementation of connectivity products dat efficiently exchange data between database and Hadoop ecosystem.
• Designs Technical Solutions and High-Level Design documents for teh stake holder requirements
• Coordinating wif offshore team on technical requirements, design, test plan, test results, pre-implementation activities and deployment
• Review Technical Design, Code, Unit Test Plans, Unit Test Results by development team and Test Plans, Test Cases documented by SIT Team
• Proficiency in SDLC Life Cycle, Agile and Waterfall models

TECHNICAL SKILLS

Big data ecosystem: Hadoop, MapReduce, HDFS, Hive, Flume, Sqoop, Hbase, Zookeeper, Cloudera VM 5.8, Oozie, InfoSphere BigInsight 4.2

Programming/scripting languages: Scala, Linux shell scripts, Cobol, JCL, XML, JSON, AVRO.

Framework: Apache Spark

Databases: Confidential -DB2, MySQL, IDMS, IMS-DB

Operating systems: Unix, centos 6.7, Z/OS, MVS, Windows … TSO

Development tools: SUBLIME 2, Eclipse, AVRO-TOOLS

Collaboration Tools: JIRA, Rational Team Concert, Rational ClearQuest, SharePoint

PROFESSIONAL EXPERIENCE

Senior System Analyst & Hadoop Developer

Confidential, Richmond, VA

Responsibilities:

• Involved in developing roadmap for migration from legacy system to Hadoop cluster.
• Create, validate and maintain scripts to load data using Sqoop manually.
• Create, validate and maintain scripts to extract and transform data from Confidential DB2 to flat files and JSON format.
• Create Oozie workflows and coordinators to automate Sqoop jobs weekly and monthly.
• Worked on reading multiple data formats on HDFS using Apache Spark.
• Wrote Scala scripts for spark to perform operations like data inspection, cleaning, load and transforms teh large sets of structured and semi-structured imported data
• Developed, validate and maintain HiveQL queries.
• Designed Hive tables to load data to and from external HDFS datasets
• Designed HiveQL script to create database, partitioned tables in hive metastore and wrote queries which will run internally in mapreduce way.
• Running weekly and monthly reports using SparkSQL and Scala scripts.

Environment: InfoSphere BigInsight 4.2, Hadoop 2.6, Apache Spark 1.6, Hive, Sqoop, Flume, Scala, Oozie, DB2 SQL

System Analyst

Confidential, Albany, NY

Responsibilities:

• As Delivery Lead, managed and coordinated multiple systems/teams involved to ensure successful delivery of teh efforts as per teh Business Requirements
• Ensure on-time delivery for teh SDLC phases for projects and SSCRs (Small System Change Requests)
• Perform weekly work forecast, LOE reviews and related negotiations
• Represent teh CHIPS VA provider and CS90 NY provider teams in teh weekly Client Portfolio and Stake Management calls
• Identify and raise Risks, Issues and dependencies to teh stakeholders and come up wif mitigations plans in a timely manner
• Review teh deployment plan and document implementation strategies wif teh Confidential management and SME's. Discuss risks, issues and dependencies in teh implementation procedures in a deployment across applications
• Prepare and review Level of Estimate in hours for each of teh efforts executed at Confidential . Based on industry standards teh LOE is prepared wif clear breakup for each phase of teh project and sometimes at activity level
• Arrange internal JAD sessions and come up wif teh best possible design approach to teh many projects and SSCRs
• Interacting wif SME's, Business, Application owners/end users to determine application requirements, user problems, participating in architecture and design activities
• SPOC for teh CHIPS VA provider and CS90 NY provider team for teh release management activities for teh Confidential CHIPS Virginia System and CS90 Newyork systems.
• Owner of teh Procedures and Process documentation for teh Confidential account and its maintenance

Environment: Z/OS, MVS, COBOL, JCL/PROC, VSAM, Cobol-XML, DB2 SQL, SPUFI, IMS, REXX, CLIST, VB scripting, ClearQuest, Share-point

Batch Process Lead & Application developer

Confidential - Rhode Island

Responsibilities:

• Studying teh different systems dat exist in Health-care insurance and their functional impact.
• Understanding teh client requirements and preparation of technical documents.
• Working and implementing teh code in teh mainframe environment.
• Understanding teh interfaces for claims software and PLASM language.
• Maintenance, enhancement and developments of programs coded in COBOL as per teh requirements.
• Working on teh Incidents primarily concerning claims (maintenance support system).
• Supporting teh high-priority live batch flow system.

Environment: Z/OS, MVS, COBOL, IMS-DB/DC, IDMS, JCL/PROC, REXX, CLIST.