Oracle RDBMS concepts and PLSQL & SQL, Delhi & Noida,18 yrs exper.as Developer

Sanjay's CV

SANJAY PRATAP
Contact No.: +91-(concealed information)
E-Mail ID: (concealed information)

~SENIOR IT PROFESSIONAL~
Versatile, high-energy technocrat with the professional targeting senior level assignments in Data Analysis &Development/Coding with an organization of high repute preferably in IT industry



PROFILE SNAPSHOT

A competent professional with over 27 years of experience in:

~ Analysis & Implementation ~ Data Scientist / Analyst ~ Application Development
~ Requirement Gathering ~ Quality Assurance ~ Coding & support
~ Data Mining/ Machine Learning ~ Statistical Analysis ~ Big Data,R,WEKA
~ Oracle 8i/9i ~ D2k(Forms6i,Reports 6i,PLSQL) ~ Oracle DBA

• Insightful professional with knowledge of entire software development life cycle from requirement analysis to system study, development, coding, testing, de- bugging, documentation and implementation.
• Expertise in Data Science Field and Statistics and worked in Data Science; technical expertise entails D2k (Forms6i, Reports 6i, PL-SQL) and in-depth knowledge of WEKA, R Studio and Shiny
• Expertise technical expertise entails D2k (Forms6i, Reports 6i, PL-SQL,Database Triggers,Procedures,Functions) and in-depth knowledge of PLSQL
• Skilled in analysing information system needs, custom designing solutions, evaluating end-user requirements & troubleshooting web applications issues; expertise in the areas of Web Technologies, Client-server
• High integrity & energetic leader, capable of leading & motivating individuals to maximize levels of productivity

ORGANISATIONAL EXPERIENCE

Apr’03-Present
Synergy InfoNet Pvt. Ltd., Noida
Growth Path:
Apr’03-Apr’09 As Technical Leader
Apr’09-Till Date As Sr.Technical Leader/Data Analyst

Key Result Areas:
• Directing technology planning and direction, strategy development, leadership and implementation, business and operational transformation execution.
• collecting, processing and performing statistical data analysis on Raw Data.
• Mapping clients’ requirements and providing them best solutions within the scope of project requirements
• Meeting deadlines and Turn-Around-Time without compromising quality norms and adhering to SLA. Implementing short/long-term plans for achievement of process objectives
• Spearheading the functions pertaining to client/user interaction for requirement gathering, risk assessment, finalization of technical architecture and discussions for effort/cost/time estimation and client co-ordination and reporting
• Communicating with internal clients to determine specific requirements and expectations; managing client expectations as an indicator of quality; providing overall leadership to the entire project team including managing deliverables of other functional team leaders
• Strategizing resource requirements and multiple resourcing / delivery models, including resources to be working in-house or at the client site; optimizing system/database operations and resource utilization; performing system capacity analysis and planning
• Creating blueprint of the data for data management systems to integrate, centralize, protect and maintain data sources; analysing qualitative and quantitative data with statistical theories and method

Significant Accomplishments:
• Implemented 25 number of appraisals
• Led a team of 30 Database Programmers for building and managing Oracle databases and troubleshooting, debugging, evaluating, and resolving software issues in the organization’s custom and internal end-user applications
• Performed Oracle Apps upgradation in Production, User Acceptance Testing (UAT) and Development environments; conducted on-going tuning of database instances
• Spearheaded large-scale program management ranging from INR 1-2.5 Crores including iterative & waterfall project management, enterprise program governance, risk management, outsourcing/insourcing, and onshore development models.
• Built and led high-performing teams 8 members for projects such as ERP for manufacturing Unit ; enhanced morale, cross group collaboration, staff development and talent management
• Mentored and coached the project team on areas such as coding,analysis,support planned and integrated the work of multiple teams on a project; provided input on team performance and reward
• Acknowledged with 15 clients for managing multiple project modules with pre-calculated risk factor and delivering successful & complete technological transformation in a well-balanced way

PREVIOUS EXPERIENCE

May’93-Mar’03
Synergy Software Ltd., Noida
Growth Path:
May’93-May’99 As Application Developer
May’99-Mar’03 As Senior Application Developer

Oct’90-Apr’93
S. Kumar & Co., Noida as System In charge

IT SKILLS

• Operating Systems: Windows 8 / 7/ XP/2003/2000/NT/98/95, Unix, DOS
• Databases: Unify, Oracle 8i/9i, Foxpro, SQL-Server
• Reporting Tools: Crystal Report writer,D2k(Froms6i,Reports 6i)
• Languages: R, PL-SQL, Codebase, Codescreen (Libraries of C), ASP

CERTIFICATIONS/TRAININGS

• Big Data & Hadoop Courses Completed:
o IBM Certifications (Big Data University Online Courses)
o Hadoop Administration Level 1 on 3rd & 6th Jan’17.
o Big Data Foundations Level 1 on Dec’15
o Online Course on HDE 100, Apache Hadoop Essentials from MAPR Academy in Oct’15.
• Data Analysis & Machine Learning and Statistical Analysis Completed:
o 12 Weeks online course on Business Analytics & Data Mining Modeling Using R
From Department of Management Studies,I.I.T Roorkee - National Program on Technology Enhanced Learning.
Dec.2017 – Apr.2018 ( Result awaited)
o 8 Weeks online course on Data Analytics from Deptt.of Management Studies I.I.T Madras,National Program on
Technology Enhanced Learning.Jul-Sep.2107 got grade 52%.
o 9 Months online course on Data Science from Johns Hopkins University on Coursera Signature Track Program and got grade 94% in Sep’15.
o 4 weeks online course on Statistics & R from Harvard Extension School through edx.; secured: 97%
o SAS E course (SAS Programming 1 Essentials) from SAS Institute Inc., USA in Sep’16
o Merit of completing online course on Statistical Learning from Stanford University in Sep’16
o Oracle and D2k & Unix and C
o Certified Course on Unix & C from Computer Society of India, Delhi Chapter for 5 weeks in 1990.
o Certification course in Computing from Indra Gandhi National Open University
o ORACLE8i, D2K (Forms/Reports 6i, PLSQL/SQL) course from SQL Star International Ltd.(1997)

ACADEMIC DETAILS

• PGDCA from International Computer Institute, New Delhi in 1989.
• B.Sc. from Lucknow University, Lucknow in 1987 .

PERSONAL DETAILS

Date of Birth: 14th April 1966
Languages Known: English and Hindi
Address: N-908, Prateek Laurel, GH-01, Sector-120 ,Noida-201301, New Delhi
Passport Number: J0948036

Annexure

Synergy InfoNet Pvt. Ltd.
Title: BMI Analysis of Boys and Girls in Schools
Period: Dec-2017 to Feb.2018
Team size : 2
Tools used: Weka & R
Description: HOPE - An NGO who conducts monthly activity in various schools categorized in A(public
schools),B(private schools),C(Govt aided schools) in several districts in North India about
Hepatitis A,B,C in the age group of 10 to 19 years of students and impart knowledge about its
vaccination and knowledge about its cure and prevent the disease.They collect the Data
consists of Gender,Age,Height,Weight and their Lifestyles and food habits in an Excel file.We
calculate the BMI(Body Mass Index) -Weight & Height ratio and conculde the results with
statistical analysis that shows BMI of Boys & Girls of different age group categorywise(mean
and Analysis of variance using WEKA and R) and plot the graphs that shows BMI Analysis.

Title: Real Estate Analysis
Period: July’17 – Nov.-2017
Team Size: 4
Tools Used: WEKA and Rstudio
Description: The project deals with housing prices prediction for a well-known construction company (Builder) in Delhi region (NCR) based on historical data of about 10 years of various housing societies. An excel file Which contains multiple predictors (input) such as price per sq./ft., no. of bedrooms, air-conditioning, study/store option and no. of washrooms. A model is developed using Multivariate Regression Analysis using R and Shiny (web based application for R) for their future housing projects in various locations.

Title: School Admin Software- Examination Analytics
• Spearheading the analysis of School DataSet (Excel file) of examination & Monthly Fee and developing web application in Shiny & R using Statistical Analysis such as ANOVA and Regression
Period: Aug’16-Mar’17
Team Size: 2
Description: In this projects user upload excel file containing examination data such as Student Id, Examination Type (Unit Test/Half Yearly/Yearly) and Marks & Class & Section and Subject. The application reads excel file and based on user input shows output such as histogram and table of information of student in particular subject in particular exam. The User can view exam result information of particular student in all exams in all subjects as well as in particular subject. The analysis is done in WEKA and R.

Title: Fee Analytics
Period: Dec’15-June ’16
Team Size: 2
Description: This projects deals with analysing Master Fee Data which has various Fee heads such as Tuition, Activity Development and Annual in a particular year for each stream of each class. There is an another set of data containing school expense such as salaries of staff, transportation expenses, based on the data using statistical tools. This application suggests that in coming Year(s) administration has to increase / decrease (amount) in various fee heads subject to maximize revenue and minimize school expenses.

Title: School Admin Software.
Period: Apr’06 to Dec-08
Environment: Oracle 8i, D2k (Forms6i and Reports 6i & SQL/PL-SQL) .
Role:
• Spearheading design and development of software for Educational Institutes, Schools and Universities; leading a team of 7-8 developers
• Working as a DBA and performing daily/weekly activities; creating database and tablespaces for users and assign rights/roles to them
• Conducting fine tuning of SQL/PL-SQl statements for optimization and facilitating the backup & recovery procedures for taking incremental and full backups; troubleshooting of Applications in Oracle Database
• Develop and Implement customized & support Admin.Software in Lucknow Schools and Lucknow University.
• Software has 8 Modules such as Student Profile,Fee Processing Module,Library Module,Accounting Module,Payroll Module,Inventory Module,Examination System,Transportation Module.

Title: Call Management System
This is an Inhouse Software Developed to cater interdepartment Call management System that tracks Call made by Clients regarding Hardware/networking trouble and shows available hardware/Networking engineers and assign them to resolve issues at Client site and record the Status of the Call. System Generates various reports such as Daily Call sheet and pending call status and enginner wise Detailas well as Client wise Detail in a month.Also support the software after installation.
Period: Jan-09 to Apr 10
Environment: Oracle 9i.D2k(Forms 6i,Reports 6i,SQL & PLSQL)
Role: Develop and Implement inhouse Software requirement.

Title: Inventory Management System
This is also inhouse devloped software that manages various hardware & networking parts and issues to clients depending upon their AMC status and track repaired parts as well.It maintains replaced ,repair and new parts inventory as well clients AMC status and generates AMC letters to Clients and track reorder items and purchase through various vendors and generates various reports..
Period: July 10 to Jan-11
Environment: Oracle 9i and D2k(Forms 6i,Reports 6i,PLSQL)
Role: Develop and Implement inhouse Software requirement.


Synergy Software Ltd.
Title: Programmer / Developer
Period: May’93-Mar’03
Operating System: Dos6.22, Windows 95, 98, Vista, XP, NT, UNIX
Database: Oracle 8i, Unify, Codebase & CodeScreen
Role:
• Was a part of Development/Coding Team in ERP Projects such as :
o Multi Tech Ltd., Noida (Readymade Garments)
Role:Coding in Unify (Database)and C in Unix OS (Shell scripting).
Duration: 24 Months,Team Size: 4
o Tristar Products Ltd., Noida.(Makeup & Arts Brushes)
Role:Coding in D2k(Forms,Reports ,PLSQL,Database Triggers,Procedures,Functions)
Duration: 36 Months,Team Size: 3
o Financial & Insurance Management - for Zurich Insurance
Role:Coding in D2k(Forms,Reports ,PLSQL,Database Triggers,Procedures,Functions)
Duration: 20 Months,Team Size: 2
o Financial & Loan Management – for RR financial Services
Role:Coding in D2k(Forms,Reports ,PLSQL,Database Triggers,Procedures,Functions)
Duration: 18 Months,Team Size: 2
• Led the development of websites for various clients using ASP, HTML, Java; implemented and managed more than 10 client-server projects for various; mapped business requirement and designed functional specifications basis that provided coding logic to the team as per the requirement
• Interacted with the client and got UAT sign-off and the package implanted at client sites; extended support to the users, troubleshooting and managing enhancements requests

S.Kumar & Co., (Share & Stock Broker)
Title: System Incharge
Period: Nov.’89-Mar’93
Environment: Share Trading Package for Back Office Accounting
Role: Acted as an In charge for software & troubleshooting