SUMMARY

• 9+ years of experience in Information Technology industry with 5+ years in client facing role focused on Banking, Financial and Retail Service domain as well as Insurance industry having worked for Fortune 500 Clients such as Confidential, Confidential .
• Involved in various phases of Project life cycle such as Analysis, Design, Requirement, Implementation and Support.
• Currently working as a Techno Functional Lead (Big data Analytics) for one of the prestigious manufacturing giant.
• Cloudera Certified Administrator for Apache Hadoop (CCAH))
• M102 Certified MongoDB for DBAs
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Hands on experience using Hadoop, HDFS, Hive and PIG.
• Expert Knowledge on Hive partitioning, bucket concepts, SMB Join, Map Join, Reduce side Joins.
• Good knowledge on Hadoop Ecosystems like Hive, Pig, Sqoop, Map Reduce, Oozie,
• Efficient in building hive scripts.
• Good understanding of Linux/Unix shell scripting.
• Experienced in Working with users, engineering groups, and vendor support for troubleshooting of any production issues.
• Focused on process automation and documentation of processes and troubleshooting guides.
• Ability to effectively work with systems and network staff for hardware upgrades and issues
• Strong back ground in Mainframe concepts including expert knowledge on DB2 database technologies.
• Expert in writing complex and optimized SQL queries such as Joins, Unions, Order By, Group by.
• Being worked in multiple roles such as designer/developer, Tech lead, BSA, Technology evaluator has given me immense confidence in adapting new technologies and any challenging roles.
• Strong exposure to IT consulting, software project management, team leadership, design, development, implementation, maintenance/support and Integration of Enterprise Software Applications, Technology Evaluations in Proof of Concepts.
• Strong experience on projects involving mobile applications on Digital and Card Processing.
• Extensive experience working on projects with Agile Methodology which includes Story writing, Sprint Planning, providing updates thru Stand - ups, participating in Sprint retro with feature team.
• Experienced using VERSIONONE to manage agile projects.
• Strong experience on both Development and Maintenance/Support projects.
• Good team player with excellent communication skills.

TECHNICAL SKILLS

Technologies: Big data/Hadoop, Mainframe Legacy Systems, AB-INITIO, Data Virtualization

Tools: / Languages: HDP,CDH 4.2, Hive, Oozie, Autosys, Pig, Sqoop, Flume, Impala, COBOL, JCL, Java Map-Reduce, Jboss DV, Teiid Designer.

Databases: Mongo, DB2 V10.0

Operating Systems: Linux, Mainframe ZOS

Database Tools: OMEGAMON,SPUFI,DB2ADM, QMF, File Manager DB2,Datastudio,ERWIN, Jboss Studio

Scheduling Tools: Oozie,CA-7, Control-M

File Management & Version Control Tools: File Manager, CAFM, Endevor, ChangeMan

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

Technical Lead

Responsibilities:

• Working as Techno Functional lead
• Design, Articulate Hive aggregate tables
• Writing hive queries using partitioning, buckets, Map Join, SMB Join, Reduce Side Join, UDFs.
• Oozie and Metadata setup for Hive aggregates
• Coding, Review, Functional and unit testing of various components
• Production implementation
• Customer review and status meeting, Onsite-offshore co-ordination

Environment: HDP 1.3, Hadoop, HDFS, Hive, Unix, Oozie, Autosys, Eclipse, Java Map Reduce, SQL

Confidential, Richmond, VA

Tech Lead

Responsibilities:

• Writing High level and Detail designs
• Coding hive scripts, Pig scripts, shell scripts
• Registering datasets from different sources in Data registry before putting into the unprocessed region in HDFS Lake.
• Filling the data lake with customer data from various sources.
• Define ETL process for Data refining, Data quality (DQ) check using Pig scripts, Java MapReduce.
• Create and Load the data into Hive tables.
• Writing Hive queries involving Joins, Group by to analyze data on Hive tables.
• Evaluating Jboss Teiid as a data virtualization tool.
• Creating connection profiles for various data sources such as DB2, Teradata, Hive, Flatfile through JDBC/ODBC connections.
• Create, Deploy, Execute VDBs to test the abstract layer.
• Evaluating Apache JENA, RDB2RDF mapping to be able to create a symbolic layer on top of the abstract layer(Work in progress).

Environment: Hadoop, Hive, Pig, HDFS, CDH 5.2, Eclipse, Java Map Reduce, SQL, Cludera Manager, Hue, Hcatalog, Jboss Studio 8.0.0, Jboss DV 6.1 Beta, Teiid Designer, Eclipse, DB2, Teradata.

Confidential

Responsibilities:

• Understand System requirement, High level Design, Data Model and transform into Database design.
• Coordinate with project team to ensure optimized Table Design approach to be followed.
• Arrange High level Design Review, PDM Review with Platform team.
• Design the DB2 Objects across Dev and QA regions.
• Reviewing Queries in Batch or Online programs (Stored Procedures) to ensure optimal performance.
• Reviewing Load, Unload and other utility jobs.
• Executing regular DBA activities such as:
• Prepare and review Pre Prod Documents.
• Preparing Production scripts and working with Production DBA to perform the changes in production environment.
• Working with Production DBA to schedule Imagecopy jobs, RUNSTATs and REORG jobs as required.
• Support QS testing
• Support Performance testing and Production Implementations.
• Monitoring the query performance using OMEGAMON.

Environment: COBOL, JCL, DB2, ETL, IBM Data Studio, OmegaMon.

Confidential

Responsibilities:

• Leading offshore team.
• Preparing project statistics, estimation, Analysis, Design, Coding, Review.
• Writing complex COBOL and Native SQL DB2 stored procedures to extract data from ODS transaction table and pass it onto RTM (Real time messaging) environment.
• Writing Native SQL Stored procedure to do perform Real time inserts/updates/deletes based on requirement.
• Writing JCLs to perform HPU Unload, SORT, Transform and Load of huge volume data.
• Writing Insert/update batch programs with Restart logic.
• Unit testing for the Online and Batch applications.
• Writing technical design for ETL flow right from source to target which involves data quality check,
• System testing support, Performing Implementation tasks, Validations during project deployment.
• Reviewing complex business requirements and System requirements.
• Analyzing the requirements and Coordinating with multiple stake holders to design/propose an optimal solution using Mainframe/ETL technologies.
• Reviewing Detail Design, Implementation plan with Clients and external Project team.
• Reviewing system test cases, Supporting Integration testing, System testing, Driving Project Implementation.

Environment: COBOL, JCL, DB2, ETL, IBM Data Studio, OmegaMon, Control-M, Serena ChangeMan.

Confidential, Hartford, CT

Developer/Support Analyst

Responsibilities:

• Coding and Unit testing Scheduling and monitoring of various batch jobs.
• Preparing Scheduling Calendar yearly basis. Monitoring of the scheduled and On Demand jobs.
• Fixing any production abend, preparing the emergency jobs/procs and raising request to restart the same.
• Handling enhancements of some existing processes.
• Enhancement involves gathering requirements, preparing test cases and then coding, unit testing, supporting system testing and production deployment.

Environment: COBOL, JCL, DB2, CAFM, CA-7, ENDEVOR.