Now you can Instantly Chat with Ruman!
About Me
Overall 9 years of IT experience in a variety of industries, which includes hands on experience in Big Data,Azure and SQL,PLSQL. Looking forward always to work in challenging scenarios. Have worked in various domains like banking, Healthcare and Tele...
Show MoreSkills
Portfolio Projects
Description
Creating data pipeline from Azure to DBCreated Data flows based on desired functionalitiesCreated transformation on data using expression builder to enrich received dataAble to adapt quickly to new requests in all phases of SDLC, co-ordinate with the Infrastructureteam in case of maintenance and unavailability of application.An effective communicator with excellent analytical capabilities, with a self-motivated andpositive approach within an organization.Hands-on experience for writing UNIX commandsHave worked in complete agile environment attending all scrum ceremonies.
Show More Show LessDescription
- used HIVE-MapReduce to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
- fetching data using Sqoop from legacy systems and saving data in hive tables.
- dealt with hive partitioned tables and analyzing data using hive queries.
- inserting data into Hbase tables and creating views for them.
Description
used HIVE-MapReduce to parse the raw data, populate staging tables and store the refined datain partitioned tables in the EDW.fetching data using Sqoop from legacy systems and saving data in hive tables.dealt with hive partitioned tables and analyzing data using hive queries.inserting data into Hbase tables and creating views for them.dealt with snapshots in HBASE for data backup and restore.
Show More Show LessDescription
It is a project of predictive analysis where we receive data from urban pharmacies and applying some business logic on it , we try to predict the data for rural areas as well and develop and joint report for it.
used HIVE-MapReduce to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
Show More Show LessDescription
- Translated requirements and functional designs into technical designs.
- Responsible for day-to-day systems maintenance, space monitoring, file systems maintenance, performance monitoring, and tuning.
- Monitoring logs using grep.
- Process monitoring.
- Provided technical production applications support and assistance to customers.
- Analyzed Unix production related issues, inquiries and requests.
- Provided feedback and developed production support procedures.
Description
Modify/create Unix scripts for scheduling various data cleansing scripts and loading processWork on all issues related to database and Unix scripts.Create Tables/Stored Procedures/Triggers/Views.Generating daily Status report through script & sending to clientUsed SQL Loader to load bulk data to tables.Wrote database triggers to ensure validity of dataTuned SQL queries with hints, created indexes, used Oracle bulk binding for faster execution ofthe conversion process.Involved in writing database packages/procedures/functionsTuned SQL statements using explain plan and logical grouping of the database for the project.
Show More Show Less