Sales Developer
Resume:
Resume:
SUSHOVON SENGUPTA
**L,Garden Terrace
North Arlington
New Jersey-07031
USA
Present status:
Working as an Oracle PL/SQL and UNIX SHELL SCRIPT Developer with 6.2 years of professional experience in software development and consulting.
Strong Knowledge in ORACLE Pl/SQL, ORACLE QUERY TUNING, SHELL SCRIPTING, PERL, ETL TECHNOLOGY, BIRT REPORT, ORACLE REPORT.
Strong domain knowledge on Media, Telecom, Retail.
Basic Knowledge on INFORMATICA development.
Knowledge in ETL Technology and concepts.
Knowledge in all new advance PL/SQL concept for making existing process more faster like Bulk Collect, For ALL, Save Exception, Append Mode INSERT, Parallel query processing.
Total Experience: 6.2 yrs
Date Of Birth: 01/12/1984
Nationality: Indian
Phone number: +1-551-***-****
E-mail: ********.********@*****.***/**************@*****.**.** Current Location: New York
Current Company: GENPACT LLC
Highest Qualification: B.Tech(I.T)
Current Ctc: 84440$ USD/Year
Notice Period: 15 Days
Visa Details: H1B Visa valid up to OCT 2016 and it can extend more 3.5 Years Professional Experience
GENPACT:
1.CI Data Migration in NBC Universal(Oct 2014 to Present): The CI (Commercial Innovation) is a phased drive, targeted towards centralized administration of its Ad Sales management system. A large number of networks that were being managed by multiple diverse system were planned to be brought under a single system for comprehensive management and creating an easier and effective Commercial Operations process ROLE:
Creating PL/SQL procedure to move the data from source database to target database.
Implementing the APPEND mode insert, BUIK COLLECT LIMIT,SAVE EXCEPTRION,,FOR ALL, PL/SQL TABLES to make the insert process faster and robust.
Working on analyze the existing code and introduce some tuning steps like re-write the query and making index or giving index hint so the SQL Queries ran fast.
Analyzing the EXPLAIN PLAN to understand the query behavior and also took proper steps to resolve issue.
Working with defect management team to handle all the defect management process of the project.
He gathers knowledge in MEDIA business and tries to implement that business logic in code. Wipro Experience:
1) Sony Music(Nov 2013 to OCT 2014)
SAMIS stands for Sales and Marketing Information System. It is a tool that enables users to look at sales data. Users can generate many
different reports depending on their individual requirements .the tool allows complete flexibility in terms of report layout and selected measures / values. (multi dimensional slice and dice technology) Reports can be created in SAMIS to show sales for your own combination of titles, TOP lists in your country, for specific partners e.g. Apple iTunes, region or worldwide, etc. (adhoc- and Standard Reports) ROLE:
Worked as a Pl/SQL and Unix Shell Script developer to support ad sales reporting system.
Use the PERL script to process the files and make them a global format.
Use the SQL LOADER, CONTROL FILES to load the data from raw files to staging tables.
I made all the Wrapper Shell Script to automate those PL/SQL procedures.
After analyze the existing code and introduce some tuning steps like re-write the query and making index or giving index hint so the SQL process ran fast.
I was an onsite coordinator between offshore and onsite.
I was responsible for taking requirement from business person and worked with offshore team to deliver those.
Analyzing the EXPLAIN PLAN to understand the query behavior and also took proper steps to resolve issue.
2) Project RDF BI(June 2012-Nov 2013)
Project Details:
I worked as a Pl/SQL and Unix Shell Scripting developer to support the large databases for storing and reporting sales data of the retail client and also he worked as an Oracle application DBA to optimize the existing system through Query tuning,Portioning Index, Parallel Query AWR reports. He worked in a 24*7 production support module. ROLE:
Worked as a Pl/SQL and Unix Shell Scripting developer to support the large databases for storing and reporting sales.
Created all the PL/SQL Procedure for INFORMATICA to drop the index and constraints before data load and create or rebuild the index after data load.
Developed the automated process to gather stats of all staging table after and data load so that selection from that table is faster.
I introduce the PARALLEL processing in index rebuild process.
Worked on the change to make the GLOBAL index to local index for better index management.
I worked on Data compression technology to compress the archive data of the database.. 3) Project Overdue Letter System(Nov 2011-May 2012) Project Details:
Project is about maintain and enhancement of a web based java/j2ee and Oracle Application for ABS which is a leading marine and offshore classification society of America, now we are making a module of this application for giving notification of suspension/cancellation of vessel
(ship),this module called Overdue Letter System.
ROLE:
Worked as a Pl/SQL and Unix Shell Scripting developer to support a web based application to send notification for Suspended Vessel.
Analyzing the existing code and introduce some tuning steps like re-write the query and making index or giving index hint so the SQL process ran fast.
I introduce the loop iteration process in existing code so that insertion works faster than previous.
Introduce the append mode insert to make the insert faster insert.
Analyzing the EXPLAIN PLAN to understand the query behavior and also took proper steps to resolve issue.
4) Project Fraud Management System(Feb 2010- OCT 2011) Project Details:
We are making parser/xml to process the CDR(Call Details Records) with business logic, which are coming form different switch element, and pass the data into NIKIRA system for loading, during data load NIKIRA create alarm on the basis on pre configure RULE. after the Alarm is raise business analysis monitor the CDR and if he analysis the Telecom Fraud, Lots of reports are present in system which are help full also for detecting Telecom fraud.
ROLE:
Worked as a Pl/SQL and Unix Shell Scripting developer to generate reports for Telecom Fraud Management.
Analyzing the existing code and introduce some tuning steps like re-write the query and making index or giving index hint so the SQL process ran fast.
I introduce the loop iteration process in existing code so that insertion works faster than previous.
I use the append mode insert to make the insert faster insert.
I took the requirement from client and create all the BIRT reports.
I used the BULK COLLECT, FOR ALL for optimizing the existing PL/SQL CODE. He used the EXPLAIN PLAN to understand the query behavior and also took proper steps.
EDUCATIONAL QUALFICATION
Examination
Passed
UNIVERSITY INSTITUTE YEAR OF
PASSING
Y.G.P.A
B.TECH(I.T) W.B.U.T Techno India 2008 8.26
Madhyamik
W.B.S.E Bhatpara Amar
Krishna Pathsala
2001 74.5%
H.S
W.B.C.H.S.E Bhatpara Amar
Krishna Pathsala
2003 67.8%
Contact this candidate