Anik Kumar Email & Phone Number

Newcastle Upon Tyne, England, United Kingdom

Design and develop High Level and Low Level ETL framework for Ingestion, Curation, Analytical and Extraction modules.Analyze data requirements and business processes.Optimize and debug high performance data pipelines and tune complex ETL/SQL processes.Discuss and defend Architectural decisions with team of strong technical architectsActively collaborate with business analysts and program for progress updates and discuss on design queries.Provide build effort estimations as per the complexity of the requirements.Mentor graduate trainees and new members of the team.Participate in technical discussions on technology choices, approaches, risks and considerations.Review the code and build artifacts created by other developers.Develop and enhance Unix shell scriptsCreate DB Objects like PL/SQL Procedures, Dimensions, Facts,, Views, MViews and ETL code. Performance Tuning the Code (SQL, PL/SQL Procs, ETL) to ensure the batch timing do not add on to the existing massive overnight ETL Batch.Co-ordinate with middle ware team for transfer of files from multiple source system.Co-ordinate with Test squad for SIT and UAT defect resolutionsCo-ordinate with scheduling team and create the required artifacts to schedule the jobs in UAT and Live environments.Ensure that the deliverable are executed as per defined SDLC and standards.Package and deploy code to higher environments for SIT/UAT and Prod migration.Creation of project artifacts like Unit Test Document, Deployment Notes, Problem Determination guide etc.Creation of Request/Incidents for Deployments and hot fixes.Creation of hand over document to assist support team with the BAU execution of the code.Currently technical stack : Cloud(AWS) and Hadoop env, Unix shell, Oracle 11.2, IBM Data Stage, Hive, Oozie, Control M, Postgres, AWS S3, EC2, Code Commit, Oracle Warehouse builder OWB, Apache Zeppelin, SQL, PL/SQL

Pune, Maharashtra, India

 Worked as a Developer and Team lead responsible for Build, Unit Testing, System testing, supporting User Acceptance testing and System Integration testing.  Developed and designed High Level and Low Level ETL framework, Staging & acquisition Module. Mentored graduate trainees and new members of the team. Have provided 15 Days classroom training on ETL Tool and DWH Methodologies to PATs in Cognizant Pune. Secured top 2 positions at Hackathon events organised within Cognizant in 2014 and 2016 respectively. Created Batch and Tickle Scripts for processes related specific to Windows Env. Experience on version control and planning tools like Tortoise SVN, Jira, Confluence, TFS. Worked on automating the Informatica PC mapping generation by using Template tool MAV. Worked on Informatica PowerCenter, Oracle, Teradata and Unix system for the build and maintenance of DWH Coordinate with Business analysts and program for progress updates and discussion on design queries. Provide build effort estimations Review the code and build artefacts created by other developers. Development and maintenance of Unix shell scripts Co-ordinate with middleware team for successful transfer of files from multiple source system. Co-ordinate with scheduling team and create the required artefacts in Visio to schedule the jobs in UAT and Live environments. Ensure that the deliverables are executed as per defined SDLC and standards. Packaging and deployment of code to higher environments for SIT/UAT and Prod migration. Creation of project artifacts like Unit Test Document, Deployment Notes, Problem Determination guide etc. Creation of Request/Incidents for Deployments and hot fixes. Creation of hand over document to assist support team with the BAU execution of the code. Demonstrated strong analytical and problem solving attitudeTechnical stack : Informatica Powercenter, Unix scripting, Oracle 11.2, Teradata 14.0 Control M, Postgres, SQL, PL/SQL, Jira

Hyderabad Area, India

Started as a Graduate Trainee and made my way up to ETL Developer for National Australia Bank(NAB). Customer Account Management system (CAMS) and Current account Savings Bank (CASB), a mainframe ledger system used to manage around 5 million accounts, including personal accounts and business accounts. This system manages transaction accounts, term deposit, loans, corporate accounts etc. The project was to source data from multiple heterogeneous source system and acquire in the on premise DB to fulfill the strategic and regulatory requirements of the bank.The role at NAB offshore development centre required expertise in key areas of Database, Informatica Power Center, Unix scripting and SQL queries.Key ResponsibilitiesAnalyze business requirements and translate them via ETL codePrepare Low Level design of ETL processesAccountable for Build, Unit Testing, System testing, supporting SIT and UAT.Analyze data requirements and business processes.Ensure that the deliverable are executed as per defined SDLC and standards.Collaborate with business analysts to discuss on design queries.Develop and enhance Unix shell scriptsPackage and deploy code to higher environments.Key TechnologiesInformatica Powercenter, Oracle, SQL Developer/Toad, WinSCP, Putty, Control M, HP ALm, Jira, Unix scripting, CSV filesKey Achievements/ProjectsDeveloped re-usable ETL components.Identified process bottlenecks and implemented solutions to fine tune them.Got 2 consecutive top star ratings and a rare promotion within 2 years of joining as Graduate engineer.

Hyderabad, India

Started as a Graduate Trainee to Radio Frequency(RF) Engineer. The project was for a new Telecom carrier in the Indian market Sistema TeleServises who were installing their telecom network infrastructure.This role was related core telecommunication job where I was on the field and one of the most interesting job I have ever done.Key ResponsibilitiesWorked as a RF Engineer (Drive Test Engineer) responsible for setting up and rectifying the Mobile RF signals.Provide the RF signals stats to the design team for further enhancement and accommodate increase in traffic and clutter.Monitoring, performance analysis and optimization on BSC/RNC and cell levelPerform and guide planning activities (antenna azimuth, tilt )Supervise a team of 4-5 site surveyors and prepare the survey report for antenna/tower installations.Check the RF signals post implementation, resolve interference, coverage issue, work cells list, perform UAT and attend to customer feedback.Key TechnologiesTEMS Investigation, Multi-band Test phone devices, GPS, Altimeter, Microsoft OfficeKey Achievements/ProjectsStarted off as Graduate trainee to a mentor and a rare promotion to RF engineer in a short span of 6 months in the job. Was moved off field and into office to supervise a team of graduate trainees myself which I think was quite an achievement for me.

Bachelor Of Technology (B.Tech.), Electrical, Electronics And Communications Engineering

Diploma In Electronics, Electronics, First

High School Cbse Board, High School/Secondary Diplomas And Certificates