P. MANOHAR SAKARE
Technical Lead
Summary
Quality-driven Technical Lead well-versed in Oracle Technologies best practices, project management requirements and support operations. Successful at building robust solutions for changing business needs. Driven professional enthusiastic about meeting market challenges with scalable technologies.
Fifteen plus years’ experience in Application analysis, development, Enhancement, Maintenance, Post Implementation and Production support using the Oracle Relational Database Management System (RDBMS) and Linux/Unix Shell scripting. PROFILE SUMMARY Eleven Plus Years’ experience in Oracle PL/SQL Development which includes Performance Tuning. Two Years’ experience in Unix Shell scripting. Two Years’ experience in Data Modelling. Worked in Domain Areas Telecommunications, Media, Manufacturing, Life sciences, Finance, Management Information System. Knowledge om Cloud AWS. Knowledge on Big Data Applications using HADOOP, HIVE, SQOOP, SPARK, SCALA, PYTHON, PYSPARK.
Overview
16
16
years of professional experience
8
8
years of post-secondary education
Work History
Technical Lead
Hexaware
Chennai
03.2021 - Current
- Northern Trust
- Domain: Finance
- Technology: Oracle12c,SQL,PL/SQL,Linux Shell script,GitHub,SQL developer,JIRA
- Key Responsibilities: Programming, Testing,Deploying
- Developed Procedures for loading Equity File(s), Portfolios, Port groups , Developed Linux job to call the Package/Procedure
- Developed Procedure in LDI Package for generating Quarterly/Yearly Broker report/Updating new Portfolios to Portfolio table
- Converted LDI/CFS/RTT Linux scripts having ftp to sftp for secure file transfer
- Deploying the Linux scripts to Production Server
- Monitoring Production jobs and fixing the issues
- Created Knowledge documents on SFTP migration of jobs/scripts, Created Knowledge document on Regression Testing Process which helps for Testers, document for migration from ftp to sftp scripts.
Technical Lead
Tech Mahindra Ltd, British Telecom
Bangalore
01.2019 - 11.2019
- Domain: Telecommunication, Networking, Products
- Technology: Oracle 12c,PL/SQL, GIT,JIRA,Agile
- Key Responsibilities:
- Leading a team for continuous change, enhancement implementation, issue fixing to the Application
- Estimating the project task as per Agile user story
- Modelled the Data Requirements using ERwin from Business requirements
- Creation/Modifying of Procedures, Tables..etc to support new requirement(s)
- Scripts for Uplifting data for old quote’s whenever new attribute/functionality is added (inserting a a row in Line_item/Line_item_detail table for the new attribute for corresponding quote)
- Preparing the scripts for Reconciling the MPTP data of previous years for old quotes/line item’s
- Code and Data Fixing the real time/live issues along with team
- Supporting the Production Deployment during the releases
- Deploying the production PL/SQL code and objects to Github code repository
- Preparation of Design Document/Process Documents
- Migrating the few particular DB objects Table(s)..etc from WEBPASDM to PMC_INFT_ADMIN.
- Investigated system issues and implemented resolutions to reduce downtime.
- Evaluated and adopted new technologies to address changing industry needs.
Application Development Specialist
Jconnect Infotech Ltd
07.2017 - 12.2017
- Key Responsibilities:
- Designing the design document for the module ESAP/XSAP (Europe) and INDIA transactions
- Creating External table to load the feed file
- Creating the staging table to load the data and perform cleansing
- Created UNIX shell scripts to automate load the transaction file received and scheduling jobs
- Preparing checklist and deployment process for QC and Production.
- Resolved system test and validation problems to provide normal program functioning.
Team Lead
Accenture Software Services
Bangalore
08.2010 - 04.2017
- Domain: Telecommunication, Life Sciences, HR
- Technology: Oracle 11g, PL/SQL, Reports 10g, Unix Shell script, Oracle WebLogic server(s),SVN,CVS
- Key Responsibilities:
- Leading a Team of Six Members, Data Modelling (DB Design) with ER win tool
- Creating/Modifying new procedures/packages, Functions, Tables, Views Indexes, dblinks (server side scripts) to support new functionality along with onsite team, Data setup , unit testing, capturing results and submitting to onsite team
- Performance Optimization of SQL Queries, PL/SQL Procedures, Packages
- Solving production tickets, writing the queries script to solve production issue for populating the data concerned table(s) and analysing the data,Monitoring the POS applications, monitor system health of POS servers, Web servers, Restarting the server(s) to make application up
- Testing and Raising defects for Migration objects using HPQC for Clinical Trial Management – Synope application
- Creation/Modification of Technical Design/Functional/Process Document(s)/ Requirement Traceability Matrix (RTM) document ,Creation of Audit Documents for Internal Auditing
- Deployment support in production with Delivery Note(s), Knowledge Transfer to Team Members
- Achievement: Contributed for DF(Demand Fulfilment) Upgrade tool in i2 project, where the adapters are hanging during work flow for populating tables so_cons_plan,so_promise for order details, but one of the table is not populating
- Created SQL script to populate all tables such as input tables and output
- Coached team members in techniques necessary to complete job tasks.
- Minimized resource and time losses by addressing employee or production issue directly and implementing timely solutions.
Software Engineer
Future Focus Infotech
Bangalore
06.2010 - 07.2010
- Writing sql scripts of producing the day/weekly reports and submitting at higher level
- Writing sql scripts to capture count of address and posting in production server having Oracle database
- Supporting database related activities such as assigning assignments to capturer, reviewing assignments to reviewer
- Synchronizing address related house hold information between the captured Resident table and actual customer who use Telephone that exist in GE database, and updating to Fairpoint database.
Senior Software Engineer
Melstar Technologies
Bangalore
09.2009 - 02.2010
- Domain: Telecommunication
- Technology, 9i, PL/SQL, SQL
- UNIX Shell script, HPOpenview, CVS
- Key Responsibilities:
- Created PL/SQL stored procedures, functions, Tables and packages for new enhancement
- Designing Control files for SQL
- Loader to load the data from flat file(s) and Writing Unix shell scripts
- Production support for Monitoring the Jobs, co-coordinating with production DBA’s for CRP application and Attending status call
- Involved in Module Level Design Documents /Functional Document(s) to keep up to date.
- Checked client code for bugs and weaknesses using approved troubleshooting methods.
- Worked with project managers, developers, quality assurance and customers to resolve technical issues.
Software Engineer
Wipro Technologies
Bangalore
06.2006 - 08.2009
- Domain: Telecommunication, Media, Manufacturing, Retail
- Technology: Erwin 9.2, Oracle 10g, PL/SQL, SQL
- Loader, UNIX Shell script, CVS, Ticketing Tool, Key Responsibilities:
- Designing/ Data Modelling ER diagram using Erwin tool
- Creating PL/SQL stored procedures, functions , Materialized Views/Views for new enhancement/Change Request
- Data setup and UNIT Testing/ Integration Testing, Capturing the results in Excel sheet and co-ordinating with onshore for System Testing
- Solving the tickets raised by customers under production support
- Monitoring the UNIX jobs and coordinating with DBA for any issue with DB server
- Generating the Daily Reports for Bolt transactions and submitting to stake holders
- Manually Processing of Bolt offer queues (BOQ) which are not picked by Job
- Downloading the SONY-BMG daily sales data through web , formatting into excel using macros to map proper DB columns, converting into data file and loading into target DB using SQL
- Loader, generating report to submit onsite
- Creating, Maintaining/Updating Technical Design Documents/Functional/
- Process document(s) to get Knowledge Transfer to team.
- Coordinated with other engineers to evaluate and improve software and hardware interfaces.
- Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
Programmer
JSYS, World, GOK
Bangalore
08.2001 - 07.2006
- Domain: Government, Water Resources, Management Information System(MIS)
- UNIX Shell script
- Key Responsibilities:
- Development of MIS application for capturing Tank (Technical/Civil works)/Social Data base
- Co-ordinated with district programmers for day to day regular requirement and collecting civil & social progress data for consolidation and feeding into application
- Generating MIS Reports and submitting into Management for analysis
- Involved in setting up of Servers, Systems , networking in MIS section
- Submitted Hardware and Software configuration details for procuring at state head office and district project unit(s)
- Installed Oracle 9i, MIS software in SPU and District Project Units(DPU)
- Conducting Review Meetings with Stake Holders and DPU programmers
- Managed a Team of Ten Programmers.
Programmer Trainee
Hindustan Latex Ltd, Ministry of Health, Govt of
Belgaum
02.1999 - 07.2001
- Domain: Health Products/ Life Sciences , Management Information System(MIS)
- Oracle 7.3, PL/SQL, SQL, Key Responsibilities:
- Modification and Creation of new modules of Integrated Management Information system (IMIS) modules having Production Planning, Production, Stores, Finance, Marketing and Sales for Branch office, Belguam Plant
- Creating Procedures, functions, Oracle Forms for new requirement and Testing
- Modification and generation of reports written in SQL Script, Pro
- C
- Knowledge Transfer and User Training for Department(s) Personal
- ACHIEVEMENTS
- Submitted Paper on‘Partitioning in Oracle.’ and ‘Collections in Oracle.’
- Prepared Material and Conducted Internal Trainings on Oracle Technology and Unix Operating system.
- Analyzed, reviewed and revised programs to increase operating efficiency.
Education
Master of Science - Computer And Information Sciences
Karnataka University
Dharwad 02.1992 - 01.1997
Bachelor of Science - Electronics
Veerashaiva College, Gulbarga University
06.1988 - 07.1991
Advanced SQL for Data Scientists through LinkedIn Learning -
Linkeldn
01.2020 - 01.2020
Postgres SQL through LinkedIn Learning -
Linkeldn
03.2020 - 04.2020
Basic Python Skill Validation Test from Cutshort -
CutShort
09.2020 - 09.2020
Certificate course on “Secure Computer User Group” from Sheild Intelligence and Cyber securities - undefined
Skills
TECHNICAL SKILLSLanguages SQL, PL/SQL, SQLLoader, PROCRDBMS Oracle 19c,Oracle 12c, Oracle 11g, Oracle10g, Oracle 9iOracle 736, MySQL, PostgreSQLOracle Tools: Export/Import, Tkprof, AWR, Oracle Sql developer,TOADSQL Workbench/JBig Data Hadoop ,Hive ,SQOOP ,Python, PySparkCloud Amazon (AWS) EC2, S3, RDSGUI Developer/2000 (Reports)ER Tool Erwin 95SDLC Methodologies WaterFall, AGILEVersion Tools CVS, SVN 80, PVCS, Perforce 72, BigBucket, GitHubAgile Tool Rally, Cloud AzureBug / Issue Tracking: JIRAOffice Tools MS-Office 2007, MS-Office 2010, Library office, PLDoc 15(PL/SQL Documentation)WebLogic Servers Oracle WebLogicFTP Tools Filezolla, WinscpQuality HPQCService Desk HP OpenviewContent Management SharePoint 2010SystemsOperating System HP-UNIX, LINUX, SUN-SOLARIS, SCO-UNIX, Windows XP, Windows 70
Customer relationship management
Functional requirements understanding
Solutions deployment
Software applications
Agile
Build releases
Technical Writing
Programming
Code reviews
Database management software
Hardware and software installation
Database programming
Testing and maintenance
Technical Analysis
Systems Development Lifecycle Management
Quality assurance
Customer relationship management
Technological integration
Timeline
Technical Lead
Hexaware
03.2021 - Current
Basic Python Skill Validation Test from Cutshort -
CutShort
09.2020 - 09.2020
Postgres SQL through LinkedIn Learning -
Linkeldn
03.2020 - 04.2020
Advanced SQL for Data Scientists through LinkedIn Learning -
Linkeldn
01.2020 - 01.2020
Technical Lead
Tech Mahindra Ltd, British Telecom
01.2019 - 11.2019
Application Development Specialist
Jconnect Infotech Ltd
07.2017 - 12.2017
Team Lead
Accenture Software Services
08.2010 - 04.2017
Software Engineer
Future Focus Infotech
06.2010 - 07.2010
Senior Software Engineer
Melstar Technologies
09.2009 - 02.2010
Software Engineer
Wipro Technologies
06.2006 - 08.2009
Programmer
JSYS, World, GOK
08.2001 - 07.2006
Programmer Trainee
Hindustan Latex Ltd, Ministry of Health, Govt of
02.1999 - 07.2001
Master of Science - Computer And Information Sciences
Karnataka University
02.1992 - 01.1997
Bachelor of Science - Electronics
Veerashaiva College, Gulbarga University
06.1988 - 07.1991