Tushar Seravade
Mumbai, Maharashtra, India
Summary
Results-driven Data Management Specialist with over 10 years of expertise in data collection, analysis, and dataset optimization. Proven track record in developing and disseminating high-quality datasets while adeptly troubleshooting data discrepancies. Proficient in a variety of statistical tools and technologies, including OBIEE Reporting, Power BI, MIT Surveillance Reporting, SQL, Tableau, and ETL software. Committed to leveraging analytical skills to drive data-informed decision-making and enhance organizational performance.
Overview
11
11
years of professional experience
Work History
Data Management Specialist
EisnerAmper
02.2020 - Current
- Act as a liaison for the Data Manager as well as support day-to-day operations.
- Support development, enhancement and maintenance of multiple datasets.
- Evaluate datasets for consistency, completeness, accuracy and reasonableness.
- Interact with customers and other teams to obtain data requirements for new and existing applications.
- Partner with business groups and IT to implement enhancements to workflow and process within CRM tool.
- Work closely with Marketing and Operations to ensure reports are being utilized by field teams and provide pertinent information that can be used to manage the business.
- Audit data on a regular basis and ensure data integrity; daily, weekly, monthly, quarterly, annually.
- Maintains error log, daily, weekly, monthly, quarterly, annually.
- Develop process improvements for data management activities.
- Perform data analysis using statistical tools.
- Identify and correct data entry errors and address any issues, questions and problems in accurate and timely manner.
- Monitor and analyze information and data systems and evaluate their performance to discover ways of enhancing them (new technologies, upgrades etc.) Create a database for storing data dictionaries and troubleshooting problems.
- Developed portfolio summaries, KPI dashboards, and financial reports using Power BI Report with SQL.
- Troubleshoot complex PL/SQL packages, views, materialized views, and optimized queries.
- Large enterprises, privately owned companies and high net worth individuals face near- and far-term accounting issues. They turn to Eisner Amper for comprehensive audit, accounting, advisory, consulting, and tax services – as well as smart, analytical insight delivered in an approachable style.
- Implemented document management solutions with primary focus on document control, distribution and knowledge management.
- Used standard document management tools to register documents and maintain databases used to produce logs, transmittal receipts and other reports.
- Tested software applications and systems to identify enhancement opportunities.
- Collaborated with multi-functional roles to communicate and align development efforts.
- Prepared functional and technical documentation data for warehouses.
- Selected methods and criteria for warehouse data evaluation procedures.
- Completed quality reviews for designs, codes, test plans and documentation methods.
- Performed systems and data analysis using variety of computer languages and procedures.
Senior Consultant
NCDEX E Markets
09.2016 - 02.2020
- Assessed needs for projects and made proposals to senior executives.
- Developed custom solutions based upon clients' strict requirements.
- Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.
- Exceeded customer requirements with accurate and deliverable solutions.
- Proficient in Oracle 10g/11g/12c, SQL, PL/SQL, and Oracle Reports Builder.
- Generating CustomizedReports through DDR i.e. SQL Queries & Analytics using OBIEE.
- ETL Batch Monitoring.
- Developed Advance PL/SQL procedures, triggers and functions to implement business logic.
- Strong SQL knowledge and ability to write Simple to medium complex queries.
- Effectively interacted with the end users for requirement gathering and defined requirement specifications document
- Gathering information from Compliance User Creating BRS and Implementation Document
- Created Tables, Views, Constraints.
- Perform regular reviews of the database to identify performance problems, inadequate programming, and data duplication problems.
- Development of Reports through MIT surveillance Tool Vendor Based application.
- ETL Report Development
- Shell scripting changes for splitting the files and then uploading the files on the server.
- Created dashboard and reports on POWER BI Desktop and Published on POWER BI Platform.
- Worked on Orders and Trade table also on Views to create interactive Dashboards along with data.
- Daily Reports, Weekly Reports, Monthly Reports are designed using POWER BI Desktop
- Have send this Reports in various Traders, SEBI Board to analyse the business requirements on one click
- Create trade details reports and closing price reports.
- Designed and developed custom Oracle Reports (both paper and web-based) using Reports Builder.
- Worked with Parameter Forms, Lexical Parameters, Bind Variables, and User Parameters for dynamic report generation.
- Created matrix, tabular, master-detail, and drill-down reports for various business needs.
- Tuned complex SQL and PL/SQL queries for performance enhancement.
- Integrated reports with Oracle Forms and deployed them to application servers.
- Worked on concurrent programs and report registration in Oracle E-Business Suite (EBS) (if applicable).
- Migrated reports from Oracle Reports to BI Publisher / ADF (if relevant).
- Interacted with end users for requirement gathering, UAT, and post-deployment support.
- Liaised with customers, management, and sales team to better understand customer needs and recommend appropriate solutions.
- Gathered, organized and input information into digital database.
- Helped meet changing demands by recommending improvements to business systems or procedures.
- Created and managed project plans, timelines and budgets.
- Evaluated customer needs and feedback to drive product and service improvements.
Associate Consultant
Mindcraft Software Pvt Ltd
06.2015 - 05.2016
- Evaluated diverse organizational systems to identify workflow, communication, and resource utilization issues.
- Reviewed internal systems and organized training plans to address areas in need of improvement.
- Provided advice, made recommendations and implemented problem-solving strategies when business needed to re-energize.
- Led various projects under guidance and supervision of chief consultant.
- Generating Customized Reports through DDR i.e. SQL Queries & Analytics using OBIEE
- Created BI Publisher reports using rtf template and excel template.
- Scheduled OBIEE Agents and BI Publisher Jobs to achieve automation.
- Providing support to monitor production OBIEE high availability environment.
- Created shell scripts for splitting and Dending Files on the Extranet Server.
- Designed and built complex reports and dashboards with sub-reports, ad hoc views, crosstabs, and custom charts
- Created style sheets, input controls, and script lets; enabled exports (PDF, Excel, HTML) and interactive drill-downs
- Configured Jasper Server: automated scheduling, role‑based access, domain/views setup.
- Implemented security via Active Directory integrations; performance-tuned database interactions
- Involved in DR (Disaster Recovery) activities.
- Tuned SQL queries and wrote stored procedures for optimal report performance
- Involved in Deployment of Obiee Reports and Maintaining the job scheduling.
- Fixing the errors of Procedures in ETL development.
- Done with Job scheduling Practices.
Database and Software Tester
Fino PayTech
01.2015 - 06.2015
- Collaborated with QA team to test software quality through manual and automated testing.
- Wrote and optimized test cases to maximize success of manual software testing with consistent, thorough approaches.
- Supported test review, defect control and configuration management within delivery pipeline.
- Developed, implemented and maintained automated testware for scripts, functions and programs to boost testing efficiency.
- Convert the functional requirements into technical document as per the business standards.
- Creating views and prepared the Business Reports Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
- Wrote SQL Queries using Joins and Sub Queries to retrieve data from the database.
- Knowledge sharing sessions on development improvements
- Development of Complex Transformation Scenarios.
- Manage physical database design, implementation and performance tuning
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Proactive measures for effective collaboration and smooth delivery.
- Involved in Business Requirements, System analysis and Design of the application.
Education
Master of Computer Applications - IT,Computers
Bharti Vidyapeeth Institute of Management
Mumbai, India06-2015
BSC IT - Computers, IT
Mumbai University
Mumbai05-2012
Skills
- Information security management
- Database design
- Big data technologies
- Data migration
- Data lifecycle management
- Data warehousing
- Data analysis expertise
- Analytical thinking
- Performance tuning
- Data analysis
- Database design expertise
- Data mapping
- Oracle database
- Data analysis
- Problem-solving
- Effective communication
- Decision-making
- Teamwork
- Clear and concise writing
- Agile methodologies
- Analytical skills
- Test planning
- Process modeling
- Excellent communication
- Large dataset management
- Team building
- Self motivation
- SQL programming
- Communication
- Time management
- Requirements gathering
- Adaptability and flexibility
- Relationship building
- Problem-solving abilities
- Professionalism
- Technical troubleshooting
- Multitasking
- Data repositories
- Interpersonal communication
- Big data management
Timeline
Data Management Specialist
EisnerAmper
02.2020 - Current
Senior Consultant
NCDEX E Markets
09.2016 - 02.2020
Associate Consultant
Mindcraft Software Pvt Ltd
06.2015 - 05.2016
Database and Software Tester
Fino PayTech
01.2015 - 06.2015
Master of Computer Applications - IT,Computers
Bharti Vidyapeeth Institute of Management
BSC IT - Computers, IT
Mumbai University