- Design and develop a Dataware house system for reporting - ETL processing around it for data processing and ingestion- Managed/Executed/Designed/Co-ordinated a huge 18TB+ DW from SybaseASE+Sybase IQ to Oracle. -- Upgrade executed seamlessly with minimal issues. -- Involved apt knowledge on various oracle latest product details such as advance algorithms for stats , compression techniques , inmemory tables etc. -- Designing solutions so that developer can work… Show more - Design and develop a Dataware house system for reporting - ETL processing around it for data processing and ingestion- Managed/Executed/Designed/Co-ordinated a huge 18TB+ DW from SybaseASE+Sybase IQ to Oracle. -- Upgrade executed seamlessly with minimal issues. -- Involved apt knowledge on various oracle latest product details such as advance algorithms for stats , compression techniques , inmemory tables etc. -- Designing solutions so that developer can work on the concept -- Designed solutions on oracle to match the performance stats in Sybase -- All solutions are designed in such manner that they can be decoupled from database layer - Working on Establishing a strategic Big data platform for more data requirements -- HIve -- Sqoop -- HDFS- PoC on usage of BigData stack in current frame work -- PySpark based ETL strategy -- Setting up ingestion pipe lines- Leading a team of 15+ talented work force - Stake holder management- Documenting project Show less

-- Extensive analysis of performance issues -- analysed the process performance issues -- solutioning for the performance improvement at app code level , database server level -- factoring the need based on workload and working infra team for best configuration

(through vendor) Being part of Sybase engineering team - worked on 1. design and development for new automation tools for SAP Sybase ASE/IQ/replication server - tasks - ASE deployer , Replication server latency pinger etc..2. Performance tuning 3. Evaluating new functionalities in SAP Sybase ASE and IQ product lines for production fitment.

-- Being part of Centre of excellence -- Participated in RFP presentation -- Solution designing -- Resource requirement calculation -- Participated in few SoS calls from companies customers -- Designed tools / scripts for faster analysis of performance issues -- Designed solutions for data migration useful for upgrade and migration projects.

- As database expert worked on performance tuning, data architecture and design. -- Designing data mart for the process of reporting various infrastructure KPIs- Performance tuning for an ongoing critical project -- Extensive performance tuning for ongoing issues and stabilising the system -- Presence at client location to carry the critical tuning part

Sybase developer

-- While working through Polaris -- worked on complex requirement of Agency Lending disclosure -- designed solution involving - data base design , scripting , mainframe

-- Worked as Sybase ASE + Java developer -- Out of existing team , a 4-member team was created (including me) which was tasked to work on creating a straight through processing of existing - counter party account set up system -- Worked with team for creating complex flows in simple manner -- Involved extensive analysis and understanding of existing process and then designing flow for new one -- For efficient testing designed a Java Spring UI based tool which could… Show more -- Worked as Sybase ASE + Java developer -- Out of existing team , a 4-member team was created (including me) which was tasked to work on creating a straight through processing of existing - counter party account set up system -- Worked with team for creating complex flows in simple manner -- Involved extensive analysis and understanding of existing process and then designing flow for new one -- For efficient testing designed a Java Spring UI based tool which could generate the data as per rules and run the simulations . Even this tool could accept the excel sheet as input. -- This tool greatly simplified the testing of complex project ,even this was selected for an award. Show less