SUMMARY

• 9 years of experience in the IT industry in Big Data, Web Development, Data Integration and Analysis.
• Cloudera & Horton Certified Hadoop Developer with 2+ years of experience in Map Reduce and Hadoop ecosystem components like Hive, Pig, Sqoop and Oozie.
• Worked extensively in developing Pig Script Hive DDL, HQL and Hive UDF.
• Good Knowledge on NoSQL database like HBase, MongoDB, Casandara and Flume.
• Experience in Data migration from existing data stores to Hadoop using Sqoop and HDFS commands.
• Expertise in writing MapReduce program using Java.
• Experience in developing Web Application/Services Development using Asp .Net Java/J2EE technologies.
• Good working experience in writing Oracle, SQL queries and PL/SQL procedures.
• Worked on data integration tool SSIS in developing and scheduling the packages.
• Has experience in Development and Operational/Production environment.
• Worked on IDE tools like Visual Studio & Eclipse and Microsoft & Oracle database.
• Having core functional expertise on Healthcare & Wellness domain.
• Involved extensively on requirement analysis, design and development phase of application using Waterfall methodology.
• Experience in writing test cases and design document.
• Experience in production defect analysis & break fixes.
• Data extraction based on various business requests on members claim and wellness data, web and product usage.
• Data analysis on impact resulted from production defect to user/member/business level and work on corrective action at back end, via update query/store procedure or reloading the correct data.
• Has experience in leading team of 10 and worked as an onsite coordinator and conducted team meetings and created project level planning’s for new projects and existing projects.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Languages: C# 3.5, JAVA 5, J2EE, Java script

UI Development: Asp .Net 3.5, JSP, HTML, CSS

Databases: Microsoft SQL Server, Oracle.

Frameworks: MapReduce, Pig, Hive, Asp .Net, Windows Communication Foundation (WCF).

Tools: Sqoop, HUE, Eclipse, Visual Studio, SSIS, Microsoft - SQL Developer, PL/SQL Developer.

Operating systems: Windows, UNIX, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Developer

Responsibilities:

• Gathering data requirements and identifying sources for acquisition.
• Data discovery to translate & Map business rule attributes to low-level data elements
• Participate and contribute to estimations and Project Planning with team and Project Manager
• Create script to import data file sent by vendor into HDFS.
• Data cleansing using Pig Script.
• Write Hive query to load the Pig processed into Hive table.
• Develop Hive UDF to handle the values like which are in different format and convert t to uniform date format as per the required format
• Coding & peer review of assigned task. Unit testing and Volume Testing. Bug fixing.
• Responsible for test case review for all components of the project
• Involved in discussion on design and future expansion of project with integration of data to NoSQL database.

Confidential, Chicago

Developer

Responsibilities:

• Import 3 years of vitality and claims data from RDBMS (Oracle) to HDFS using Sqoop.
• Create external Hive table for the imported data.
• Create Hive script to extract data based on business requirement to study data on member’s health stats of those who submitted claim and members who have not, members whose health stats are in risk.
• Writing Sqoop script to import incremental data.
• Create Oozie workflow to schedule the process of importing and loading of data into Hive environment and to generate the report on members health stats.
• Create deployment plan, run book and implementation checklist.
• Interaction with DBAs and SysAdmins.
• Perform root cause analysis and providing a permanent fix to the problems identified.
• Involved in presenting induction to the new joiner’s in the project.
• Ensure availability of document/code for review.

Confidential, Chicago

Tech Lead/Analyst

Responsibilities:

• Develop and deploy SSIS package to read excel/text file containing member biometric and event data, format date field and map attributes value in the file corresponding to event configured in vitality system and load the data.
• Triaging and resolving production issues.
• Data analysis on impact resulted from production defect to user/member/business level and work on corrective action at back end, via update query/store procedure or by reloading the correct data.
• Generate report based on various business requests on members claim and wellness data, web and product usage from Data Warehouse in PL/SQL Developer.
• Co-ordinate with external vendor to which client application has partnered with, on any production issues and work closer with them for resolution of the issue.

Confidential

.Net Developer

Responsibilities:

• Requirements Analysis and create Design Document for Business approval
• Development of application including Design, coding and store procedure creation using Visual Studio 2003 for front end and Microsoft SQL Server 2008 for back end data base.
• Test Case creation and System Testing the application as per the test cased developed.

Confidential

Support Analyst

Responsibilities:

• Responsible for the management of production issue of the WCF service and data issue, ensuring effective and timely resolution
• Monitoring daily batch job run and to ensure timely completion of the job processing.
• Interaction with end user to know the end to end problem and to find the root cause of the issue and provide permanent fix for the issue
• Analyze the current procedure and coding performance and provide suggestion for performance tuning to improvise the process

Confidential

Web Developer- .Net

Responsibilities:

• Develop Web application using Asp .Net 2.0 based on the design provided by client.
• Write Store Procedure on Microsoft SQL which is to be called by application for data access.
• Create System Test cases for complete testing on the developed application.
• Address issue and fix raised on warranty support.
• Develop technical design documents.

Confidential

Java Developer

Responsibilities:

• Analyzing the Scope and business rules.
• Create XSD based on the HL7 type and generate JAXB object and business logic to read pipe delimited.
• Designing front end application to upload the HL7 and generate xml.
• Preparing the Unit Test cases & Testing.
• Code Review and Document review