Mahendra Laxman Naik +91 9975671838

mahendranaik88@gmail.com

PROFESSIONAL SNAPSHOTSPROFESSIONAL SNAPSHOTS

3.4 years of extensive career experience in Data Warehousing and professional experience working with various industries such as Retail, Banking and Finance.

6 months of Technical and professional skills training at Infosys Limited, Mysore.

Experience in using IBM Web sphere DataStage v7.5, v8.1 and v9.1. Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

Designed Technical specifications and Mapping documents with Transformation rules. Also Documented and Performed unittest plans and testcasescenarios of developed code.

Experience in converting the Business Logic into Technical Specifications and exposure to Dimensional modelling techniques.

Extensive experience in loading high volume data, and performance tuning.

Trained in Business English and email etiquettes for End-User interaction, Onsite-offshore coordination.

Responsible Team player with good interpersonal skills, Strong Analytical, comprehensive problem solving abilities & a willingness to learn.

Proficiency at grasping new technical concepts quickly and utilising the same in a productive manner.

ACADEMICSACADEMICS

SSC : Scored 93.46% (11th Merit Rank) March 2004 HSC: Scored 88.66% February 2006 B.Tech (CE): Scored 7.71(CGPA) May 2010

TECHNICAL SKILLSTECHNICAL SKILLS

Data Warehousing: Ascential Datastage9.1/8.5.x/7.5 (Designer, Director, Manager, Administrator), DMExpress.Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema, Snow-Flake Schema, FACT and Dimensions Tables, Physical and Logical Data Modeling, Scheduling: Control-MDatabases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, Teradata V2R6/V2R5Tools -TOAD v9.5, SQL PLUS, WINSCPand UNIXputty v5.3Environments: Windows 2003/2000NT 4.0, AIX 5.2/4.3, UNIX

ORGANISATIONAL EXPERIENCEORGANISATIONAL EXPERIENCE

Bitwise Solutions Pvt. Ltd.(June 2015 – Till date)Programmer Analyst

Project Summary: Client : Global Payments Inc.

Global Payments Inc. is a provider of electronic transaction processing services for merchants, Independent Sales Organizations (ISOs), financial institutions, government agencies and multi-national corporations located throughout the United States, Canada, Europe, and the Asia-Pacific region.

Responsibilities: Using DMExpress as an ETL tool to develop processes for extracting,

cleansing, transforming, integrating, and loading data into data warehouse database.

Using different transformers such as Merge, Aggregator, Copy, Sort and Reformat

Working on Control-M scheduling to run the ETL process in Test/Prod environments.

Part of Value-added development tasks which contribute to the project.

IBM India Limited (Aug 2014- May 2015)Systems Analyst

Project Summary: Client : ANZ (Australia and New Zealand Bank)BIH (Batch Integration Hub) is the key component of ANZ’s architecture. This area represents the landing area for all the files from various source systems. These will be transferred to BIH layer by the Connect Direct (C: D) team. The transfer mechanism depends on the type of source systems.

Responsibilities: Strong understanding of the principles of Data Warehousing using fact

tables, dimension tables and star/snowflake schema modelling. Extensively used Parallel Job Stages like Dataset/Fileset, Aggregator, Join,

Transformer, Sort, Merge, Filter, Modify, Lookup, Funnel and Pivot. Extensive experience in Unit Testing, Functional Testing, System Testing,

Integration Testing, Regression Testing, User Acceptance Testing (UAT) and Performance Testing.

Worked with various databases like Oracle 10g/9i/8i, Teradata. Quality analysis by preparing Design Documents, Deployment Documents,

Test cases, Dry run results etc. Documented the Purpose of mapping so as to facilitate the personnel to

understand the process and incorporate the changes as and when necessary. Involved in writing the test plans based on Functional Requirement and

Business Requirement Documents. Tracked and reported Defects Using Test Director.

Infosys Limited (Nov 2010 - July 2013)Systems Engineer

Project #1 Client : USATelecom Client

This project was aimed for capturing GSM customer profile, GSM plan types and customer CDR’s, revenue generating patterns, generating churn reports etc. This project develops consolidated BW reports and detailed customer-wise BO report for assisting Decision Support System.

Responsibilities: Understanding the functional specifications and requirements gathering. Extracting data from the databases like oracle, DB2 flat files and transforming

in DataStage then loaded in to SAP BW, Green Plum and BO. Development of Parallel jobs using Parallel stages like Filter, Copy, Join,

Transformer, Aggregator, Merge and Sort etc. Design of DataStage ETL jobs to load data into respective DIMENSIONS. Design of multi-instance jobs in DataStage Jobs for the application which

extracts CDR (CallDetailRecord) data from ADC servers and load into staging tables.

Unix shell script to call DataStage job from UNIX and to generate Reconciliation Report for Billing Rated CDR.

DataStage job sequences using start and end loop activity, execute command activity, user variable activity to clear backlogs, send abort SMS, trigger dependency applications and extractions based on the parameters.

Project #2

Client Name : Ricoh Infrastructure and Data centre Strategy(RIDS)The intention of RIDS project is to create a new, scalable, flexible and agile platform that can migrate Ricoh’s existing business processes provided via SHARE project and its current live users.

Responsibilities: Development of Code for defect fixes, and performance tuning of DataStage

jobs for ETL process which runs in production environment. Deployment of Code for new releases and defect fixes on DataStage

Application server. Promptly worked on root cause analysis in case of failure in daily ETL process

and resolution within defined time. Administrative activities on DataStage Client. DataStage Server clean restart through UNIX. Review of Deployment documents.

TECHNICAL COURSESTECHNICAL COURSES

Certification Name: IBM Certified Solution DeveloperWebSphere IIS DataStage Enterprise Edition v7.5

Marks obtained : 96%Certification Date : March 21, 2012

ACHIEVEMENTS AND EXTRA CURRICULAR ACTIVITIESACHIEVEMENTS AND EXTRA CURRICULAR ACTIVITIES

Maharashtra State Board ranker. STAR Infoscion. Associated with and contribution to Greenpeace, India. Elected member of Training and Placement Cell from Computer Engineering

Department, Dr. BabasahebAmbedkar Technological University, Lonere, 2009-10

Secured Scholarships in various talent search examinations viz. MTSE, HSE, MSE

Participated in National Level paper Presentation on ‘Cloud Computing and Future’ held at WIT, Solapur in Feb 2010.

Silver medalist in Creative Writing Competition, at university level, 2008-09

PERSONAL DETAILSPERSONAL DETAILS

Date of Birth : 10 Nov, 1988.Address : C-401, Kumar Atman, Baner road, Baner, PuneMarital Status : SinglePassport number : xxxxxxxx (valid till April 2020)Pan number : AGQPN9617GLanguage Proficiency : English, Hindi, Marathi, FrenchHobbies : Fitness, Photography, Travelling

DECLARATIONDECLARATION

I hereby declare that the information and facts stated herein are true and correct to the best of my knowledge and belief.

Mahendra Laxman Naik