Manikandan Moorthy Email & Phone Number

Trondheim, Trøndelag, Norway

Trondheim, Trøndelag, Norway

- Designed & Developed the Analytical Datawarehouse for Sticos.- Import & export data from Hubspot, Younium, Wootric API using SSIS into SQL Server & Big Query Cloud.- Implementation of Snowplow logging for Sticos- Creation of customer 360 datamart

Trondheim, Trøndelag, Norway

Solution Architect, Division for Governance and Management Systems- Designed & developed Planning Analytics (PA) DataMart to store plan data into Datawarehouse. - Data Modeling & Design of Higher Education data from various sources into NTNU systems. - Optimized Bevisst Datawarehouse to maintain high data quality- Extraction of data from DBH API, Cristin API using python & Shell scripting- Design and Develop of ETL Packages using SSIS, SQL Server- Loading the education data into SQL server tables. - Visualization of higher education data from different sources into Cognos Analytics & Planning Analytics.- Designed data recovery management from user logs. - Design & development of TM1 planning analytics model to plan budget for future years.- Designed Data flow diagrams for Bevisst systems.

Raleigh-Durham, North Carolina Area

Blue Cross Blue Shield of North Carolina, Data Analyst- Requirement Gathering from non- Business users- Analysing the data and preparing data flow diagrams- Data Analysis and Preparation of Project FRD, Design specification , Data Model & Architecture- Designing and Developing of ETL using Ab initio ETL tool, Unix Shell Scripting- Using Teradata Utility BTEQ and Unix , built an asset for migrating the Teradata Databases to AWS & Hive (Bigdata)- Technical lead for various projects using client's technology by understanding their requirements- Deep knowledge in SQL Databases - Oracle, Teradata, SQL Server & DB2

Chennai Area, India

Task• Gathering the requirement from Client and ensure the ETL process developed is in line with business.• Excellent Experience in Designing, Developing, Documenting, Testing of ETL Graphs using Abinitio ETLtool.• Proficient in developing strategies for ETL mechanism• Coordination and knowledge sharing amongst team members.• Coordinating with offshore/onsite team and facilitated by setting up the development environment in shorttime.• Design and development of Abinitio Applications.• Design and development of generic framework applications in Abinitio.• Good understanding knowledge of creating reusable utilities and reusable component using Abinitio, UNIX and Teradata.• Visited the client place to gather the requirements and helped the offshore team to know BCBSNC current system.• Good Understanding of Health Care industry and US health care.Achievements• AHM 250 (Academy for Healthcare Management) certified professional.

Chennai

Project Name BCBCNC Enterprise Integration Client BCBSNCIndustry Health Care and Public Services Role Ab Initio Lead DeveloperSkills Ab Initio, Teradata SQL, Unix, DB2 , Control MDescription:Blue Cross Blue Shield of North Carolina (BCBSNC) is the largest health insurance provider in the state ofNorth Carolina. The Enterprise integration of BCBSNC is used to develop the ETL system to process theInter Plan Processing and Federal Employment Programs into EDW and also to process the files from BlueAssociation which contains the details of other state members and providers.Task• Gathering the requirement from Client and ensure the ETL process developed is in line with business.• Excellent Experience in Designing, Developing, Documenting, Testing of ETL Graphs using Abinitio ETLtool.• Using Teradata Utility BTEQ and Unix , built an asset to the client for migration of Teradata Databases toHive (Big data)• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism• Provide technical leadership for customer projects using the client's technology by understanding theirrequirements.• Demonstrate value through quality of deliverables.• Co-ordination and knowledge sharing amongst team members.• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issueson their side. Provide improvement initiatives through reviews.• Coordinating with offshore/onsite team and facilitated by setting up the development environment in shorttime.

Chennai Area, India

Sep ’14- July ‘15 Software Analyst at the Accenture Services Ltd, ChennaiProject Name NCTIO Client BCBS – NCIndustry Health Care and Public Services Role Ab initio Developer and Data AnalystSkills Ab initio, Teradata SQL , Unix, Control MDescription:Blue Cross Blue Shield of North Carolina (BCBSNC) is the largest health insurance provider in the state ofNorth Carolina. The new ETL system needs to be developed to load the Claims and Accounting data mart.Later the existing MHS system will be replaced with new system. As a part of project, following are the rolesand responsibilities.Task• Entire end to end requirement gathering, mapping validation, data model and physical data model validationwith mapping, source file identification, layout validation with respect to mapping, data profiling to criticalcolumns etc.• Designing of various component like source file capture and validation, Change data capture, error loggingand reporting into an error tables, Audit and log process designing.• Creation of various scripts to automate the ETL process like PSET creation, data creation, code reviewprocess.• Used various transformations like Rollup, Scan, Normalize, ICFF Lookup, Designing and optimizing thegraphs.• Estimation of work involved in project through analysis.• Involved in integration / deployment and delivery activities.• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issueson their side.• Created the ETL exception reports and validation reports after the data is loaded into the warehousedatabase• Analyzing the data in Claims and Accounting using Teradata sqls• Creating load data scripts/Reports in Teradata using TD utilities like MLOAD, FLOAD, BTEQ, etc.Achievements• Awarded as Star of the Month for my notable work during the delivery of NCTIO claims and Accounting

Chennai Area, India

Jan ‘14-Sep ‘14 Software Engineer at the HCL Technologies Limited, ChennaiProject Name Brocade IT Operations Client BrocadeIndustry Networking Role DeveloperSkills Ab Initio , Oracle PL\SQL, UnixTask• Designing of various component like source file capture and validation, Change data capture, error loggingand reporting into an error tables, Audit and log process designing.• Used various transformations like Rollup, Scan, Normalize, Reformat, Joins and optimizing the graphs.• Creating DB objects like tables, procedures, functions, packages, Triggers, DB links, etc. as per thefunctional requirement• Creating Sales Orders through Oracle Applications- Order Management Super User , Install Base• Designed a Tool to get the history of software.Achievements• Awarded Certificate of Recognition & Reward for my notable work by BROCADE for the year 2011-2012.

Chennai, India

Nov ’11 - Jan ’14 Software Engineer at the HCL Technologies Limited, ChennaiProject Name Brocade SW Portal Sustenance Client BrocadeIndustry Networking Role Database DeveloperSkills Oracle PL\SQL,Unix, Ab InitioTask• Preparation of Database Re-architecture scripts.• Creating DB objects like tables, procedures, functions, packages, Triggers, DB links, etc. as per thefunctional requirement• Working with DBA in environment Refreshes (DEV, QA and UAT) from Production environment.• Resolving Performance issues in queries and Tune it accordingly• Production Support to resolve the daily issues• Creating Sales Orders through Oracle Applications- Sales Order ManagementAchievements• Awarded for the Value Addition idea implementation on ‘IP Capacity SKU’s attributes & transaction History’.

B.E, Eee, First Class With Distinction

Activities and Societies: Vice President of Tamil Literature Club of Jerusalem College of EngineeringCourse Highlights: Electrical.

Hsc, Computer Science

Activities and Societies: Awarded as Child Scientist for presenting a project on “PURIFICATION OF SEWAGE WATER USING MICRO ORGANISMS”.

Sslc

Activities and Societies: Lead a project team on various projects in Biological science, social science and computer science and received.