ELAMARUTHAN MANOHARAN

Cary, NC ***** * 919-***-**** * ac8jx1@r.postjobfree.com

S U M M A R Y

Proficient problem-solver who envisions business and technical perspectives to develop workable solutions. Data warehousing team lead: 6+ years of experience in core ETL development. Proven ability to work on multiple projects with strict deadlines. Worked on ETL process consisting of data transformation, conversion, loading and data analysis, design and development of mappings. Noted for providing technology solutions that optimize the customer experience and drive revenue growth in the Healthcare Industry C O R E S K I L L S

Ab-Initio

Unix Shell Scripting

Teradata

DB2

Oracle

Control-M Scheduler

A C C O M P L I S H M E N T S

Involved in the development of the Ab-initio Analyzer tool which reverse engineers the Raw code into mapping document with source and target

Constructed a tool which provides all the code related information related to a table. This saved a significant amount of time and money in the solution scoping and analysis phase of projects

Successfully delivered a FastTrack project which enabled the BCBNC client to send campaigns to Users using SMS

Successfully rebuild the entire Claims and Account subject area in the Data Warehouse P R O F E S S I O N A L E X P E R I E N C E

BCBS-NC ACCENTURE, RALEIGH, NC

Role: Technical Team Lead

2014 – Present

Project: Large Group Migration

BCBSNC decided to change its claims adjudication processor from a legacy Power MHS system to a newer Facets System

Managed a team of 5+ in offshore/onshore model and involved in the entire SDLC process of the project

Involved in analyzing the entire Data Warehouse (80 tables and 120+ ETLs) and identifying the impacts of this change as the data will be different as the source processor changed

Conduct meetings with multiple vendors and Client SMEs to under the new Facets configuration and data

Constructed a tool which provides all the code related information related to a table. This saved a significant amount of time and money in the solution scoping and analysis phase of projects Project: Medicare Market Refresh

Display additional member details from the Medicare member’s user portal from the data warehouse

Planned and directed a team of 4 to consume this new data from the source and make it available in the multiple layers of the data warehouse

This is an Agile project and gained understanding how to Plan Agile releases Project: Contact Preference Center

Enable the BCBSNC to send out campaigns, Health reminders and Billing information to the user via multiple channels – Email, SMS, and Direct Email.

Involved in the End to end processing – Selecting the eligible members, sending email/SMS to user and handling the responses

Worked with Salesforce Team and gained understanding of the salesforce marketing cloud Project: BHI

All the Blues in country needs to send their member and claims related data to the BCBS association monthly and they provide certification for the Data Warehouse

Involved in building the complex extracts and summary reports from the data warehouse

Coordinated with Multiple teams onshore/offshore to send automate

Successfully got the North Carolina BCBS data Level 4 certified Project: Topaz Remediation

Multiple Service requests and Analytics team’s defects were combined to form this project and need to resolve this within stringent timelines

Managed a team of 6+ in offshore/onshore to analyze and provide fixes immediately

Involved in rebuilding the entire Claims and accounts subject area of the warehouse Project: Customer Hub

Customer Hub is the 360 degree view of the customer and it’s a single data mart which has all the information of the customer

Analyze the business requirements provided by the client and create technical design and apply business logics for Customer Hub subject area

Data Profiling of the source and target data

Project: NCTIO – Claims and Accounting

Played the role of Ab-Initio Developer in my team and responsible for developing Abinitio Graphs and Teradata SQLs as per the requirement

Responsible for the development of highest number deliverables in the Claims module and delivered every single item successfully within stipulated time frame

Created a reusable alternate graph for pre-process which does the pre-process of source files in minimal time (Used within the team)

VODAFONE UK IBM, Pune, MH, India

Role: ETL developer, July 2012 – May 2014

Served as an Analyst in the team and responsible for analyzing the data quality issues raised by Client

Worked closely with the Data Governance Team of Vodafone UK and have fluid understanding of Business Logics and reporting

Responsible for resolving all the data quality issues raised by the client's Data Governance Team and fixing them with the stipulated SLA timeframe

C E R T I F I C A T I O N S

America’s Health Insurance Plans (AHIP)

Oracle Certified Java Developer (OCJP)

R E L E V E N T S K I L L S

Languages: Shell scripting, Java, SQL, HTML

Frameworks: Ab-initio

Software: Eclipse, Toad, Teradata SQL Assistant, IBM Cognos ReporNet, IBM DataStage, Microsoft Office

Databases: Teradata, Oracle, MySQL

E D U C A T I O N

THIAGARAJAR COLLEGE OF ENGINEERING, Madurai, TN, India Bachelor of Technology – Information Technology - May 2012 A W A R D S A N D H O N O R S

Promoted to Team Lead and received performance appraisal award – 2018

Promoted to Senior Software Engineer and received performance appraisal award – 2017

Won the Accenture Excellence Award – 2015

Won Accenture Superstar Award - 2014

Received outstanding contributor of the team award - 2013

Contact this candidate