Sanjeev Sen

SANJEEV SEN- S/O: Late Jagadish Sen and Late Chitra Sen KAR BAGAN P.O:Karna Madhabpur via NATAGARH ,Kolkata-700113, West Bengal- EDUCATION  Bachelor of Science :-1988 BIHAR UNIVERSITY,MUZAFFARPUR  P.G Diploma in Compter Science COMPUTER SKILLS    Operating System Programming Languages Databases & Tools *  Other Utilities Windows98/NT/2003/2008 server,Linux 5,AIX 6.1 Advanced SQL,Pl/Sql, Some Shell Scripting ,C,HTML Oracle(8i/9i/10G/11G), SQL Developer, MSAccess ,Oracle Enterprise Manager , Oracle DBCA, NETCA, Sql Loader,Export & Import ,FlashBack, RMAN Backup & Recovery of Oracle Database,Various DBMS Utility Packages ORACLE Forms & Reports 6i/9i/10g, , Sound knowledge of Pl/Sql Stored Procedures, Functions,Triggers, Packages,Sql*Plus Scripts,Objects & Collections. Installation of Oracle 9/10/11 on Windows/Linux. MS Word,Excell ,Advanced Excell,PowerPoint,Analytical Reporting. CERTIFICATIONS     Oracle 9i Certified Professional - OCP DBA Oracle 9i Certified Associate - OCA SQL, PL/SQL DEVELOPER Oracle 9i Certified Associate (NIIT)-Forms Developer Oracle 8i SQL & PL/SQL/Forms-5.0/Reports-3.0 Certified Developer (SSI) COURSES Oracle 9i Certified Associate (PL/SQL Developer)-COURSE from ORACLE UNIVERSITY:- Oracle 9i Certified Professional (DBA TRACK)-COURSE from ORACLE UNIVERSITY:- Oracle 9i Certified Professional (Bussiness Intelligence/Oracle Forms)-COURSE – from ORACLE UNIVERSITY:- Currently Persuing OCP 11g DBA/Developer and Upgrade for 11g in all above Certifications. PROFESSIONAL EXPERIENCE Asmaka Ventures,Kasba,Kolkata May2019 -present Senior Data Analyst,Report creator Asmaka Venmtures is a Kolkata based analytical report’s dashboard creation Company using its own Software “dRSTin”,my responsibilities are data mining/rectifying then create Dashboard of reports for most of the Clients. Onclave Systems Pvt.Ltd,Kolkata Dec2017 – April2018 Business Development Officer cum Developer Company Profile Onclave Systems is a fast growing Software Solutions Provider with main focus in developing Customized Software and Websites for various Clients,Working here as a Developer for Database and Sql related part of the Projects apart from as a Business Development Officer. MONIBA COMPU ACADEMY,Saltlake,Kolkata Mar2011 – Nov2017 Technical Trainer – Oracle 10G Admin, PL/SQL ,Forms/Reports10G , DB2 ,Some PHP/Mysql and C ,Advanced Excell, Company Profile MONIBA COMPU ACADEMY,Kolkata is IBM Authorized Training Center for IBM & Many High Profile Software Technologies. ROLES AND RESPONSIBILITIES worked in Moniba Compu Academy ,kolkata Technical Trainer for Oracle and DB2 Database Technologies,Pro*C etc.Trained various Batches from Corporate and Colleges. Conducted Corporate Training on RDBMS,SQL,PL/SQL,SQL TUNING,Oracle Forms 10G,DBA ADMIN ,SQL Developer to Techmahindra,Saltlake,Kolkata Employees with great success .The Training was conducted for 6 weeks Oct-Nov 2011 . Conducted Corporate Training Project which held in 2011 Imparted Training on PL/SQL to Techmahindra,Saltlake,Kolkata Employees for Level-1 Support with great Client satisfaction. Technology: Oracle 9i/10G/11G Databases RDBMS CONCEPTS,SQL,PL/SQL,Oracle 10G Forms & Reports,Explain Plan/AUTOTRACE/TKPROF .SQL DEVELOPER & TOAD Oracle 10G,11G RAC, Grid & Data Base Installation using VMWare on WIN2003/Linux. NIIT,Saltlake,Kolkata Sr.Faculty – Oracle 9i/10G Admin/BI/SQL/PLSQL,Excell,Word,Powerpoint 2007 –2011 DETAILS Technology: Oracle 9i/10G Database Admin,SQL,PL/SQL, Oracle 9iForms/Reports Company Profile NIIT offers IT training programs for students in Universities and Colleges. The company has tied up with reputed Universities across the world, including the Open University in the UK ,Oracle Corpopration/Sun over a dozen Universities in India, Australia, Malaysia and New Zealand and over 20 Universities in China and USA. ROLES AND RESPONSIBILITIES Worked as a Senior Faculty at NIIT in Kolkata.Teaching all four Papers of Oracle9i/10G DBA Track and all Three Papers of Oracle 9i Developer Track, Oracle University’s Course CurriculumHave rendered my services to three NIIT branches Jadavpur,Saltlake,VIP.Provided Training to many Batches on Oracle DBA track 4 Papers ,SQL,PL/SQl ,Oracle Forms etc.           Installation of Oracle Software on Windows/Linux Creation of Databases Creation of Sample schemas for Practical Training Database Sever and Client Configuration,& Monitoring Oracle 9i Forms installations and creation of Example Schemas Impartnig the Training as per the guidelines of Oracle University which includes extensive Practical exercises and their solutions related to all Oracle papers of DBA and Developer track, Training Oracle structured query language,Database Administration I,Database Administration II,Performence Tuning in the DBA 9iTrack. Co ordinating Cultural & Sport Activating for the Students Upgrading self Skills as per Industry requirements etc Advance Technology&Research INC (ATR INC) Smyrna,GA,USA Programmer/Analyst 1997 -2006 Company Profile ATR’s primary bussines is software and networking for wireless internetThey develop server based applications .They have many patents one of which is Pandora(E-Locker).Which work with Abaco (E-Commerse) Product.ATR also does Software development for its Clients and Import of consumer products For marketting in USA. Technology: Oracle 8i/9i Database,SQL, PL/SQL, Oracle Forms/Reports 6.0,Ms Access,Crystal Reports DETAILS Worked efficiently as a Programmer/Analyst and also as a Marketing Supervisor,met the deadlines set by the management by accomplishing the tasks and projects in timely and routine manner.Apart from working as a software developer also assisted the company in their marketing venture, Responsibilities included marketing of fancy Jute Items imported from India and other nations by ART INC to giant retail outlets of USA Like Wal-Mart, Doller General,Sams Etc. As a Programmer/Analyst was responsible for Data modeling,Schema design technical/ functional specification,Front End application Development using Oracle Forms & Reports 6.0,Oracle (8i/9i),MsAccess ,Creation of PL/SQL stored Packages ,Procedures,Functions and Triggers and creation of Statistical Reports,loading of data in test database etc,by creation of Loader Scripts. Personnel Projection System : The System Projects the next two years expences/budget of City of Georgia,GA,USA behind hiring of new Work Force & Utilities (also existing) based on their salary and fringe benefits etc,The system make calculations in four different department phases and each time new salary, fringe ,others variables are used to compute the expenses and based on that the department recommends for new positions, Each time the software is used to make various changes and computations and generate Position Reports for management considerations and at the 4th phase it updates the related systems when the projections are accepted finally apart from generating final Reports. Attendance Management System : The System Computerizes the Attendance System of Software Technical Services ,Ga,USA.It also calculates the leave accounting, time sht,over time, etc and updates the other related Sytems and generates Reports. ROLES AND RESPONSIBILITIES IN THE PROJECT  Study of requirement analysis documents  Creation of prototypes using Access and Oracle  Design & development of Application Schema  Design and development of back end Pl/sql Packages,Procedures,Functions and Triggers  Front end Application design ,development ,testing and deployment using Access/Oracle Forms 6  Loading test data and testing the application using sql*loader  Design,development, testing of many structured Reports using Oracle Reports/Crystal Reports OTHER ACTIVITIES  Represented college cricket team for four consequtive years INTERESTS    Singing light Classical Playing Harmonium Playing and watching Cricket and others Sports ********************