Prosenjit Pramanick Email & Phone Number

United States

Created Logstash scripts, Elasticsearch queries, Elastic Pipeline (Ingest node), Kibana Reports & Dashboards Have experience in Kibana Canvas with drill down, widgets, KQLWorked on advanced visualizations in Kibana, Index maintenance and index pattern maintenanceHave experience in developing various filters(throttle,Fingeprint,etc) in Logstash scripts Worked Elasticsearch schema creation, search query, pipeline scripts, Understanding of Query DSL, Index, mapping, Alerting creation and maintenance.Logging of System Testing errors,watchers, Coordination activities with the development team for resolution of defectsHave set up & configure out of the box Machine learning capabilities in ElasticsearchHave experience in Instrumenting the following on in ELK is plus (HTTP logs, Container logs, Audit Logs, system logs, JVM logs, VM logs, Process logs, Config logs)Worked on converting SPLUNK dashboards to Elastic Kibana dashboards and real time alertsWorked on pulling data from Hive/Kafka/DB2/SQL-SERVERWorked on integrating elastic alerts in Webex

Mumbai Area, India

• My primary responsibilities includes building pipelines in Logstash for data ingestion into Elasticsearch.• Setup indexing templates using custom analyser, synonyms in order to create inverted index.• Create script templates and parameterize elastic query language using mustache• Implemented custom solutions in Elasticsearch using painless script to provide some features provided by Endeca search engine.• Used curators do delete the old indices and keep the last 5 days indices• Experience migrating elastic versions and dealing with issues around deprecation and rewriting existing logic.• Manage search infrastructure in elastic cloud i.e. setup and manage clusters, plugins etc.• Created distribution architecture for data ingestion using snapshot and restore feature. Helped decreased search cluster load by removing all CPU consumption.• Setup monitoring on clusters using watchers to send email alerts in case of search or indexing latency, high CPU usage, high memory usage, low disk space, cluster health etc.• Designed and developed a search engine management portal for business users • Designed, architecture and developed a real-time order search engine using Elasticsearch, Logstash, Kibana• Other activities include – Using AppDynamics to real-time monitoring, business insights, anomaly detection, and full visibility for the entire application landscape

Mumbai Area, India

Just completed real time data ingestion from Sensors data into Hbase via the integration of Apache Kafka/Storm/Hbase and then display the records from Hbase via Zeppelin.The code for the same is uploaded in GITHUB repository the link for the same is as below https://github.com/ppramanick/First

Skilled in developing and managing Databases using Oracle, PL/SQL, ,Querry Optimization SQL,BO Reports ,Ericsson Charging and Data Reporting System .

Kolkata Area, India

CRS –Charging data Reporting SystemEnvironment : Java, Servlet, JSP, JavaScript, Oracle 11g, Tomcat, UnixModules Worked : Flat file generation, Scheduling, ETL PL/SQL and BO reportingDuration :July 2011 to Till dateClient : AirTel, BSNL, Etisalat, MTN, Mobinil, Indosat,etcProduct DescriptionCRS is billing and reporting system for Telecom Domain. It process more than 400,000,000 records per day and generate web based online reports for customer care operator. It generate the output as flat file, web based report, Business Object report and Cristal report.CRS get the CDR from various network nodes. It processes all the CDRs and loads the data into oracle dwsadm schema. This dwsadm schema is used by customer case and data export. All the ETL PL/SQL procedures are started by scheduler and data is aggregated and moved to various data marts. Business object reports are generated from the data marts.Responsibilities· Involved in analyzing the requirement, Writing QS(Quick Study) document and developing the code· Planning and estimating the time for each task· Responsible for finishing the all the TR(Trouble Report) with the SLA· Responsible for submitting the monthly reportsabout the TRs· Developing and tuning the PL/SQL stored procedures, triggers.· Developed JAVA based AJAX GUI for scheduling the ETL and other task

Kolkata Area, India

BIG DATA Internal Project for Charging System(AIR/SDP) DATA for a telecom giantProject Duration From 12th MAR2014 to mar2015Scope of The projectIntroduce Big Data Analytics framework for CDR collection, processing and analytical purpose. GSI to showcase the power and ease of the visualization layer using tableau of the above mentioned framework from the final csv files and/or input data which the existing systems generate. Role:- To push the files(JSON files) coming from external mediation to HDFS in a external table with parttion enabled with creation_dt using python programme which will be in runtime(coding for the python programme done by me.)To create partion on the hive table using a shell script which will create partion daily and delete partition of the pervious 7th day(coding for shell script done by me).To Generate CSV files with header as customers reports from the loaded Hive table(shell script coding done my me.)Load the data from Hive to Impala for the visualization layer using tableau,using tableau to show different type of visualizationCreated Tableau standardized data reports for use by the account managers. Provided Tableau business reports and data anomaly reports.

Key Deliverables AT IFS Developing Reports using Crystal Report XI (Reports like Downtime Analysis of Machines). with pl/SQL at backend. Performing Data Migration.  Solving Bugs at client site.

 Handling various tasks under Software Development and VAS. Key member of the team that is currently involved in execution of the following project:Title: Value Added Services for Reliance Telecom Ltd.Team Size: 4 members (in the NE region) Duration: Since Feb’07Role: Facilitating smooth implementation of the project at client location. Extending post-implementation, application maintenance and technical support to the client.Platform: Windows 2000 Server, PL/SQL, SQL, My SQL, SQL Server, Oracle 9i, VNC, VOS, SS7The Project involves developing an MIS using Standard SQL queries. Using CTADL to build Codes, managing a database of 5.75 Lakh customers. Taking care of the SMSC and IVR Server. Undertaking necessary changes required using standard SQL queries and CTADL.Content Updation.Developing Stored Procedures (Pl/SQL) for The Contest that take place for Reliance Telecom Ltd West Bengal Circle. Independently managing Short Codes like 56300 (Voice Portal), 56800(Bengali Voice Portal), 55765 (Panditji Online), 56100 (Background Music Monthly Subscription) and 55486 (Contest).  Acknowledged for full dedication for timely completion of assigned tasks. Gave proposals on the present assignment for growth of the company on different occasions.

B-Tech, Information Technology, 1St Grade

Xii, Science, 1St Grade