rahul kumar mishra
TRANSCRIPT
Rahul Kumar Mishra1449, Sector-2, HSR Layout, Bangalore, Karnataka, India Mobile: +91-8750987675/7829267675Email: rahulkmishra27 @gmail.com
Career Profile:
4 years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Powercenter, Unix shell scripting and Oracle. Excellent knowledge in Informatica, Unix and Oracle with credible experience in releasing and configuration management activities.
Professional Summary:
Excellent knowledge in Informatica Power Center 9X/8x gained over 48 months in IT industry. Involved in ETL and Reporting phases of Data warehousing projects that include Prototyping, Requirements
Gathering, Analysis, Design, Development, Implementation, Acceptance Testing and Production Support for end-to-end IT solution offerings.
Adept knowledge in Relational Database Concepts, Data warehousing concepts, Entity Relation Diagrams, Normalization and De normalization Concepts and expertise with UNIX shell scripting for File validation and SQL programming.
Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Look Up, Router, Filter, Union, Sorter, Update Strategy, Joiner, Sequence Generators and Rank.
Exposure of scheduling Informatica jobs through Informatica Scheduler, Cron job and Unix shell scripting (PM-CMD).
Excellent Problem solving, Interpersonal and Communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning.
Acquired Designing and Development Skills in Informatica 8.6 and 9.1. Proficient in analyzing information system needs, evaluating end-user requirements, custom designing solutions,
programming, troubleshooting for complex information systems management. Reviewing the Code, tracking and solving the defects occurring during the different phases of the Software
Development life cycle. Received Stellar award for consistent good performance and for understanding the requirements and delivering a
data extract very much ahead of the schedule.
Professional Experience:
Currently working as an Software engineer Analyst in Accenture Technology Solutions, Bangalore from Nov 2013 to till date.
Worked as System Engineer in TCS from Mar 2011 to Oct 2013.
PRIOR PROJECT EXPERIENCE SUMMARY (included only major projects)
Project NameUCM MDM(Master Data Management)
Client KPN
Description of the project
KPN is a Dutch landline and mobile telecommunications company which provides multiple telecom services to customers. UCM MDM projects aim to store and maintain the master database of all the customer’s contact, account, address data and provides the view to third party users to extract the data for reporting and analysis. In UCM MDM, Informatica is used to load the data from different sources in format of file or relational DB. Before loading data in UCM DB Informatica perform certain data quality check, profiling, standardization, Matching, Survivorship to maintain the data integrity and avoid the redundancy. This project is in Agile model..
Role Offshore Design/Development SME
Responsibility Working as SME and helping the team in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Testing of Data warehouses using Informatica.
Development (with strict adherence to the standards defined by the client), loading of data that deals with various subject areas.
Implementing the complex business rules by creating transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router Rank, Joiner, Update Strategy), reusable transformation, and developing complex Mapplets and Mappings.
Implement Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.
Started working in Informatica developer (IDQ).
Design and Code review to check whether the necessary coding standards are maintained
Software/Tools Informatica Power Center Designer v8.6.1,v9.6.1, IDQ, SQL Developer, Putty .61,WinSCP, CronJob
Project Name Marketing DataMart Project
Client VMWARE
Description of the project
Project is managing marketing data of VMWARE. VMWARE launches campaigns, from these campaign company got respondents and leads. These leads get converted in opportunity after buy any product. In this project, data is extracted from data warehouse and get loaded in marketing data mart. All the extraction logics is implemented according to data warehouse logic. OBIEE is used to generate reports
Role Offshore ETL Developer/Admin
Responsibility Design the architecture of Extract, Transform, and Load environment using Informatica Power Center.
Perform Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings..
Develop Slowly Changing Dimension Mappings of type I, II (flag and time stamp). Created UNIX scripts for file transfers, to remove unwanted characters from source
files, and purging. Worked as Informatica Admin, activities performed like repository, integration services
creation. Group, user creation assigning privileges to users and having sound knowledge on other
administrator activitiesSoftware/Tools Informatica PowerCenter Designer 9.1,Toad,Putty .61, Winscp
Project Name CVS CAREMARK (R6-R11)
Client CVS CAREMARK
Description of the project
Development, maintenance of batch jobs, Informatica jobs on the basis of pharmacy services of US landscape client. Extraction of data from relational source and flat file and load the data after some transformation in relational or flat file source..
Role Informatica Developer
Responsibility Development (with strict adherence to the standards defined by the client), loading of data that deals with various subject areas.
Implement Parameterizing of all variables, connections at all levels andCreate Sessions, Worklets and Workflows for carrying out test loads.
Transferring the data from various sources like flat files, relation DB into Oracle data warehouse
Performed data validation in the target tables using complex SQLs to make sure all the modules are integrated properly Bug fixing in case of issues rose in any of the subject areas.
Tested and tuned the SQL queries for better performance. Identified the bottlenecks in mapping logic and resolved performance issues.
Software/Tools Informatica Power Center developer, Oracle 10g,Putty .61,Winscp, Control-M
Training and Certification:
Description Type Institution DateORACLE 1Z0-047 SQL ORACLE 29th June 2013
Informatica Power Center(P2) Exam/Interview Accenture April 2014
Informatica 9.1.0 (E0) Examination TCS Oct 2012
PL/SQL (E0) Examination TCS Sep 2010
Process Improvement (PI) Examination TCS Nov 2010
Special Achievement:
Stellar award for best performer in Accenture. Received Appreciation and Accolades from client and Accenture leadership. Received Appreciation from client and TCS leadership. Received Awards and Appreciation from client and Accenture leadership.
Technical Expertise
Database Oracle 10g ,11g
ETL Tools Informatica Power Center 8.6.1 ,9.1,9.6.1 and IDQ
Other Tools Putty, WinSCP, Toad, SQL developer
Language Unix shell scripting, SQLscript
Academic Qualifications:
Bachelor’s Degree (B. Tech) in Information Technology from Krishna Institute of Engg. & Technology, Ghaziabad (Affiliated to Uttar Pradesh Technical University, Lucknow) with 71.2% marks in 2010.
Higher Secondary Certificate (HSC) from CBSE Board Kanpur with 66% marks in 2004. Secondary School Certificate (SSC) from CBSE Board Kanpur with 72.6% marks in 2002.
Personal Details:
Date of Birth: 27th August 1987Father's Name: Rahul Kumar MishraPassport Number H8751373 Date of Expiry 28/07/2018Languages Known: English, HindiPermanent Address Ramendu Nivas, 105/7, Savitri Nagar, Nai Jhunsi, Allahabad (U.P.) Pin-211019Nationality: IndianHobbies Numismatist, love cooking, Photography, reading booksDeclaration
I hereby declare that above furnished details are true and precise up to my knowledge.
Date: 22nd April 2015 Rahul Kumar Mishra