Dipankar Sahoo Email and Phone Number
More than 10 yrs. of prolific experience in the field of Backend & Database Development with primary expertise in RDBMS concepts, Oracle SQL-PLSQL and adequate competency in SQL Server, Data Integration, Data Warehousing, ETL Concepts, Data Integration Solution with ETL Tool like Informatica PowerCenter, Data Visualization, Business Intelligence Concepts, Tableau. Also having knowledge in Unix Commands and coding abilities in Talend. I have 2 yrs. experience in Telecom Billing-BSS-Rating & almost 7 yrs. experience in Retail OFMCG Domain. An assiduous Software Engineer with client communication skill, good Coding ability in Oracle & developing ETL program in Informatica, striking logical thinking skills. Also capable of developing the Dashboard in Tableau. Willing to work in an innovative, challenging, rewarding environment which offers a profound knowledge base to enhance my coding, problem-solving skills, industrial exposure and where I can exploit my knowledge of Database, ETL or BI Programming to meet subsequent business requirements. CAREER SUMMARY:•Good experience in SQL/PLSQL coding with knowledge of different DB Objects like Views, Synonyms, Sequences, Index-Partitioning, MV, PL/SQL Cursor, Procedures, Functions, Packages, Triggers and Jobs at Database level.•Knowledge in creation of Users, Roles & Privileges, Table/Index/Rollback Segments and Constraints.•Having knowledge of ETL and Data Integration in developing ETL mappings and scripts in Informatica PowerCenter using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.•Expertise in creating Transformations like Filter, Expression, Sequence Generator, Lookups, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.•Having strong knowledge of Data Visualization & Business Intelligence Dashboard design and development skills in Tableau.•Developed complex dashboards using different Tableau elements like functions, parameters, filters, context filter, actions.•Knowledge in the architecture of the Retail OFMCG Business including Billing-Invoicing, Products-Order Management, Loyalty, Schemes, Promotions, Discounts and Adjustments in retail business.•Having adequate idea in MS-Office, Software Development Life Cycle with Issue Management System thru JIRA.
Infosys
View- Website:
- infosys.com
- Employees:
- 217514
-
Technology LeadInfosys Dec 2023 - Present
-
Associate It ConsultantItc Infotech Jun 2016 - Dec 2023Kolkata Area, IndiaResponsibilities: •Involved in the reporting module where different degree of data preparation and data analysis as per client’s requirement. Several reports need to be prepared through SQL & PLSQL coding on Sales figure, Customer & Product details. •Development & customization needs to be done on existing logic to implement new business requirements & enhancements in current logic to smoothen current business scenario.•Having knowledge of loyalty, scheme, promotion & adjustment in retail business. Also developed and implemented these modules in ongoing process as per business requirement. Very much fluent to solve various degree of queries related to these retail modules.•Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica to implement the business requirements.•Create new mapping designs using various tools in Informatica PowerCenter like Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer, Session Task Developer, Worklet & Workflow Designer according to technical specifications.•Created complex mappings and several reusable Transformations and Mapplets that involved implementation of Business Logic to load data in to staging area. •Performed data manipulations using various Transformations like Filter, Expression, Sequence Generator, Lookups, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union to develop various mappings using Mapping Designer.•Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.•Effectively worked on development & enhancement of different Tableau dashboards based on the business need.•Building BI Reports comprising of certain logic to meet user requirements by using different Tableau elements.•Preparing understanding documents and BRD for new enhancements and implementation as per business requirements. -
Software EngineerUshacomm Aug 2014 - Jun 2016Kolkata Area, IndiaResponsibilities:•Involved actively in the project including the scheduled execution of billing engine for processing the Billing of Postpaid Data and Payments modules.•Preparing audit checklist for Billing & Payment Process modules in Production. Considering the ongoing process of both modules, regularly trace out the issues and resolve them as required to maintain the flow of processes.•Take care the Invoicing, Rating, Provisioning, Payments, Issue Resolution Modules. Also involved in improvement on existing logic in OFFERING, RATING, DISCOUNTING and Reporting Modules as well as for the Adjustments/Promo-Codes.• Test Call Generation (CDR preparation) for UAT testing. Configuration of OFFERING, RATING & DISCOUNTING. Testing of Billing, Payments, Discounting in UAT. Telecomm CRM & Order Management (Customer-Service Registration, Plan-Product, Email-Alert).•Product customization includes, changes in existing codes for adding new functionalities, guiding clients according to their needs on the existing business logic. Preparing basic documents template with HTML and bit of coding in JAVA to customize the product.•Providing the solution for the issues thru JIRA (IMS Bug Tracking System) or the mail communication.•Code walks through with team lead/end users on regular basis and creating UD for the applications developed.•Attended weekly client call to discuss the existing business impact analysis of new releases. Client communication also needed for sharing reports on various requirements after analyzing highly complex data sets, performing ad-hoc analysis. -
Jr. Software EngineerProtex Computers Pvt Ltd Sep 2013 - Jul 2014Kolkata Area, IndiaResponsibilities:*Customize product to satisfy Client’s requirements including changes in existing code, implementing new logic.*Coding (Java, JSP, JavaScript) & Writing & Developed Packages, Procedures, Functions, Triggers, Cursors in Oracle.*Designing and Coding Reports through Oracle Reports6i as per user’s needs.*Developed data entry screens and generated code. Prepared design specification documents, test plan for all modules.*Arranging demos as to make the users familiar with our system, train them to use the system etc.*Required client communication and providing support as per their need.
Dipankar Sahoo Education Details
-
Bachelor Of Technology (B.Tech.) -
Hindu SchoolHigher Secondary
Frequently Asked Questions about Dipankar Sahoo
What company does Dipankar Sahoo work for?
Dipankar Sahoo works for Infosys
What is Dipankar Sahoo's role at the current company?
Dipankar Sahoo's current role is Database, ETL Developer | Oracle | ETL | BI | Informatica PowerCenter.
What schools did Dipankar Sahoo attend?
Dipankar Sahoo attended West Bengal University Of Technology, Hindu School.
Who are Dipankar Sahoo's colleagues?
Dipankar Sahoo's colleagues are Nilesh Patel, Nur Syazwani Aqilah Mohamad Aris, Suryakant Kumar, Noufal Mundodan, Pithani Rohith Vamsi, Tarak Dutta, Mradul Gupta.
Not the Dipankar Sahoo you were looking for?
-
-
Dipankar Sahoo
Bengaluru -
-
Dipankar Sahoo
University Institute Of Technology,Burdwan-It'26 | Aspiring Software Developer | Competitive Programming EnthusiastKharagpur
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial