SUMMARY:

• A proactive Data Analyst stimulated and inspired by various challenges. During the 7.7 years tenure in the IT industry, with maximum experience in the telecom and Banking domain, worked on gathering requirements, feasibility analysis, data profiling and BRS/FRS preparation across domains. In addition to being an honest communicator and well equipped with excellent analytical and problem - solving skills, played pivotal role in gathering requirements during client interactions.
• A competent professional with 7.6 years of experience in the areas of IT Data Warehousing /Business Analysis.
• Developing Data Warehouse roadmap and strategy.
• Over 7+ years of experience in Datastage ETL Tool with extensive knowledge and working experience in Oracle, Netezza, DB2 and Teradata databases.
• 7+ years of strong experience in UNIX and Shell Scripting.
• 5+ years of design and development experience in Tivoli Workload Scheduler for automation.
• 1+ year of design and development experience in Big Data Eco-System using IBM Big Insight (Pig, Hive, BigSql, Load Hadoop, Sqoop import/Export, Flume, Oozie).
• Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer.
• Extensive experience in ETL DataStage development, administration and mentoring.
• End to end solutioning exposure for Data warehouse.
• Experience in Software Development Life Cycle (SDLC) - including functional specifications, analysis, design, programming, testing, implementation and maintenance.
• Extensive experience in writing Functional specification and technical design documents with excellent written and communication skills.
• Telecom and finance domain expertise with Business Intelligence while working with world biggest client like Confidential, Infratel and Confidential .

TECHNICAL SKILLS:

ETL Tools: DataStage(8.1,8,7,11.3 and 11.5), Pig

Databases: Oracle, Netezza, DB2,Teradata, Hive, IBM BigSql

Operating System: Linux, Aix

Programming Skills: Unix Shell Scripting, C, C++, Core Java, Pig

Scheduling Tools: Tivoli Workload Scheduler, Oozie

BigData Environment: IBM Big Insight, Pig, Hive, BigSql, Load Hadoop, Sqoop import/Export, Flume, Oozie

Other Skills: Toad 9.5, Aginity, Putty, Edit Plus, Confidential Compare 2, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential

Technical Team Lead

Responsibilities:

• It periodically ingests base data from operational data systems.
• It offers various delivery services for the ingested data, depending on the nature of the data and the required use case.

Confidential

Technical Team Lead / Senior Developer

Responsibilities:

• It periodically ingests base data from operational data systems.
• The data lake implements data governance including data lineage and meta-data management for all ingested data.
• It offers various delivery services for the ingested data, depending on the nature of the data and the required use case.

Confidential

Technical Team Lead / Senior Developer

Responsibilities:

• Upgraded the system software to latest version of Cognos being version 10.2.1.
• Retrieve current manual data from source systems (all data that can be retrieved from source systems now shall be taken up for automation now and balance shall be integrated with source system as and when feasible, without the need of change request),
• Provide access to Cognos user interface provide access on analysis studio, accommodate changes identified for correction as part of / post project Go-Live in 2013,

Confidential

Technical Team Lead / Senior Developer

Responsibilities:

• Single point of delivery to Senior Management on their handheld devices
• Single view to all CXO & Senior Management with Standardized approach in presentation of KPIs
• Dashboards will help highlight concerns areas & s in a pre-defined automated fashion for action.

Confidential

Technical Team Lead / Senior Developer

Responsibilities:

• Data Models will be created in Netezza Analytics server, where other MMFA models exist. These new models will also be built at MSISDN level. This project will bring new data from INF and WAP source system into the
• Big Data Platform. Big Data platform will be used as processing area for cleansing, modelling and daily aggregation.Further this daily aggregated data pushed into MMFA (Netezza) system to generate monthly aggregation as analytical model. MMFA system will be used as analytical platform & Big Data platform used as processing system only. As part of this project scope, Analyst or business user won’t use this Big Data platform and this platform treated as black box for business users.

Confidential

Senior Developer

Responsibilities:

• MMFA provides the MSISDN level data mart to the end users for their analysis. The data at individual subscriber level (MSISDN level) is analysed. With this insight, customer's aim at targeting the subscriber groups with appropriate campaigns for delivering better value to the subscribers and generate higher revenue in the process.Project -7

Confidential

ETL Developer

Responsibilities:

• Movement of the existing EDW project to Netezza environment by looking at its functionalities which includes compression, processing power and data filtering process.

Confidential

ETL Developer

Responsibilities:

• Version migration of existing project from Datastage version 8.1 to version 8.6. In this version migration project various steps involved lead to success migration like proper import export of code, data validation and verification and proper environment setup. Post migration bug fixing and parallel load of data.

Confidential

ETL Developer

Responsibilities:

• Files were containing backdated usages also due to the same customer not able to see the proper report on time for post-paid subscribers. Golden Gate implantation overcome the problem. We have improve the extraction process of post-paid subscriber usages and reduce the latency of backdated CDR’s.

Confidential

ETL Developer

Responsibilities:

• Confidential India is the largest service providers of GSM cellular service in India. It provides pre-paid, post-paid and value-added services like GPRS, WAP, and EDGE etc. to its customers. With the emerging technologies and competition Confidential has decided to move the Data Warehouse on to new technology for loading and transforming the data.