SUMMARY

• Over 10+ years of experience in software development and maintenance. Passionate towards working in Hadoop and Big data Technologies.
• Expertise in data analysis and data Visualization. Strong knowledge in healthcare and retail domain. Proficient in building Tools & Automation, Efficiency Improvement.
• Experienced in providing production support, investigating and resolving system defects and fixing bugs.
• Worked as part of a Confidential Delivery team in a multi - location, multi-cultural and collaborative project delivery framework with responsibilities including technical leadership and client interaction at various client locations .

SKILLS

Hadoop, Apache Spark, Map Reduce, Hive, Pig, Sqoop, Flume, Spark Streaming, Kafka, Avro, Parquet, Hue, Cassandra, MongoDB, Hbase, Cloudera CDH, MySQL, iSeries, RPGILE, CLLE, Synon/2E, Showcase ETL tool, FTP/SFTP, Mimix, Robot, Implementer, Turn over, Hawkeye, Ezview, Remedy, Service now, HP Quality center.

PROFESSIONAL EXPERIENCE

Confidential

Data warehouse/Data Analytics (Big data)

Responsibilities:

• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using showcase warehouse builder to extract the data from multiple source systems that comprises of databases like As400 DB2, SQL Server, flat files and Excel sheets.
• Worked on the maintenance and enhancements.
• Involved in DB2 configuration, data modeling, and identification of trusted data sources, database creation, and ETL processes.
• Maintained SQL scripts and complex queries for analysis and extraction.
• Created the Source and Target Definitions using showcase warehouse builder.
• Tuning of SQL queries for better performance.
• Executed Spark jobs to perform data analytics on data stored in HDFS to study Healthcare data processing system
• Involved in installing Hadoop cluster components and configuration.
• Involved in loading data from AS400 DB2 to HDFS.
• Ingested data using SQOOP from Relational Database systems to HDFS.
• Involved in creating Hive tables, partitioning, buckets in hive and loading/analyzing data using hive queries.
• Designed and built the reporting applications that use the Spark SQL to fetch and generate reports on Hive table data.
• Implemented FLUME to collect, aggregate and store the web log data from different sources like web servers to be pushed into HDFS.
• Scheduled Oozie jobs to run multiple Hive scripts.
• Worked in proof of concepts for streaming analytics for AS400 job abends/logs and web server logs using Kafka.
• Worked on the proof-of-concept for distributed data storage initiation using Apache Hadoop & Cloudera framework.

Technologies: Help systems showcase (ETL tool), Hadoop, Sqoop, Pig, Hive, Scala, Spark, Flume, Spark streaming, Kafka, RPGILE, SQLRPG, CLLE, DB2/400, Implementer, Robot Scheduler, Secured FTP, Mimix.

Confidential, CA

HN AO MHN production support

Responsibilities:

• Leading the production support team to address the technical and functional issues.
• Assisted in designing and implementation of IT solutions for AS400 application.
• Experience in managing offshore teams for developing and testing various projects.
• Provide adhoc reports on business impacts due to critical production issues.
• Building automation tools and utilities to simplify the day to day repeatable activities of business users.
• Involved in data center migration project for MHN applications.
• Involved in disaster recovery process for application.
• Provided subject matter expertise to a project team that planned, designed and implemented lot of solutions leading to improved end user accessibility and efficiency.
• Performance improvement for critical application batches.
• Prepared mapping/functional documents for AS400 migration project.
• Implemented and managed project Change Control System and processes to tracks project issues resolution
• Responsible for providing timely updates to the customer.
• Responsible for attending the Triage calls and getting clarifications and reporting issues
• Supported team members in reduction of IT support and service costs by optimization of system processes.
• Develop custom data replication tool for export data to new server LPAR.

Technologies: Synon, RPG400, SQL RPGLE, RPGILE, CLLE, Implementer, Robot Scheduler, DB2400.

Confidential

Responsibilities:

• Application lead for MHN claims processing system.
• Worked on EDI standard file formats like 837,834,277CA etc.
• Wrote functional specification and detailed design document for the projects
• Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Participated in providing the project estimates for development team efforts for the off shore as well as on-site
• Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project
• Involved in working with project Managers and analysts on estimates, timelines, and resource plans.
• Submitting weekly status reports.
• Programming, Debugging & Testing the Application programs according to the requirements
• Implemented procedures for product rollout, quality control and code reviews

Technologies: Synon, RPG400, SQL RPGLE, RPGILE, CLLE, Implementer, Robot Scheduler, DB2400.

Confidential

Project Engineer

Responsibilities:

• instrumental in the study analysis of the system and working on the various minor enhancements including bug fixing and finding RCA for each incident and implementing permanent fix for more number of repeatable issues and by reduced number of incidents over a period of time.
• Improved performance of system and batch jobs to maintain the stability of application.
• Coordinating and taking training for new joiners inducted into the project and developing project specific tools, thereby creating value-adds to clients
• Requirement analysis, impact/data analysis, enhancing and maintenance, improving user interfaces and improving performance of system.

Technologies: Synon, RPG400, RPGILE, CL400, COBOL400, Zebra Programming Language, Turn over, Robot Scheduler.

Confidential

Responsibilities:

• Converting Business Specification into Technical Specifications
• Creation of the Transaction Specification document
• Coding of objects concurring to client requirements
• Review technical design and code.
• Creation and Execution of Unit test cases, execution of test cases in the Integration and System Testing phase, verification of results, Defect reporting, Bug Fixing and Status consolidation

Technologies: OS 400, RPG400, RPGILE, CL400, DB2/400, Turnover

Confidential

Project Engineer

Responsibilities:

• Creation and Execution of Unit test cases.
• Execution of test cases in the Integration and System Testing phase.
• Verification of results, Defect reporting, Bug Fixing and Status consolidation

Technologies: HP Quality Centre, RPG, CLP, OS 400, DB2/400.