Mayank Tyagi
Mumbai
Summary
Results-oriented project leader with leadership 17+ yrs experience overseeing 30+ projects, including high-impact ventures such as the BSEIndia Website and BSEStarMF. Proven track record of driving operational efficiency through innovative enhancements and automation. Proficient in SQL Server, PostgreSQL, and Power BI for data visualization and analysis. Strong background in T-SQL development and database administration.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Deputy General Manager
BSE Technologies Pvt. Ltd
Mumbai
12.2010 - Current
- Led a team of 55+ employees to develop and support 30+ projects, notably BSEIndia Website, Listing Center, BCRMS and BSEStarMF.
- Spearheaded key projects including BSEStarMF, achieving remarkable growth from in year 1.3 Crores to handling 4.30 Crores transactions per month.
- Implemented enhancements such as Purchase and Redemption OMB, Auto Refund, Payment Integrator, and Funds Reconciliation, significantly improving operational efficiency.
- Increased system capacity to handle over 10 Crores transactions through automation of file systems.
- Led the development of the BSEIndia Website, catering to investors and brokers.
- Managed projects like Listing, BCRMS (Compliance portal), ensuring seamless operations and compliance adherence.
- Conducted backend development of various platforms including BSEIndia Website, India INX ,Listing, BCMRS, BSEStarMF, Mobile Apps, Power Exchange, and BEAM.
- Proficient in segments including Equity, Derivative, Debt, Currency, SLB, and Commodity market.
- Familiar with the Common Feed File structure of RTA CAMS and KFin.
- Skilled in SQL Server and PostgreSQL development including all versions from 2000 onwards.
- Working knowledge of SQL replication, high availability, and In-Memory OLTP for performance optimization.
- Proficient in Power BI for data visualization and analysis.
- Good in data analytics for deriving insights from large datasets.Supervised team members, established performance goals, provided feedback, and conducted performance reviews.
- Identified areas of improvement in operational processes and developed solutions accordingly.
- Recommended changes in database design based on changing requirements from users or new technologies available in market place.
- Configured monitoring tools such as Solarwinds Database Performance Analyzer to proactively detect potential problems before they become major issues.
- Developed and implemented automated database maintenance tasks to improve data integrity.
- Established standards, procedures and policies related to database design, coding, security and backup and recovery operations.
- Optimized SQL queries for better performance by creating necessary indexes on tables or by rewriting the query itself.
- Identified, protected and leveraged existing data.
Software Engineer
Zenith Infotech Pvt Ltd
Mumbai
07.2010 - 11.2010
- Designed databases to store application data using SQL Server 2005 /2008
- Developed T-SQL procedures, functions, triggers, and CLR for cloud creation ticketing system and real-time NAS storage alerting system.
- Created real-time dashboards using SQL for efficient monitoring and management of cloud resources.
- Creating the structure of the database including tables, relationships, indexes, and constraints.
- Writing SQL queries: Developing complex queries to retrieve, manipulate, and analyze data stored in the database.
- Optimizing database performance by fine-tuning queries, indexing strategies, and database configurations.
- Working closely with other team members such as software developers, data analysts, and system administrators to ensure the database meets the needs of the organization.
Database Administrator
Idealake Information Technologies Pvt. Ltd
Mumbai
01.2007 - 07.2010
- Administered databases for the Maharashtra Sales Tax project, handling tasks such as backup and recovery, T-SQL development, optimization, and maintenance.
- Contributed to optimization through indexing, reindexing, and defragmentation techniques.
- Monitored database performance and addressed performance bottlenecks.
- Developed a disaster recovery plan ensuring data availability and integrity in the event of an outage.
Education
B.Tech - Computer Science
Shobhit Institute And Engineering Technology
Meerut 10-2006
Skills
- Project Management
- Database Design & Development
- Performance Issue Diagnosis
- Microsoft SQL 2000 to 2019
- Microsoft PowerShell
- Data Analytics
- Data Security
- PostgreSQL
- Microsoft Power BI
- Working knowledge on AWS RDS
Certification
- Completed C# and SQL certifications from NIIT in 2007.
- Pursuing a certification in IBM Data Analyst.
Accomplishments
Projects I've worked on or accomplished include:
StarMF:
- Funds Payments Matching Engine
- Order Settlement
- Auto Refund
- Bank Reconciliation (Purchase and Redemption)
BSEINDIA WEBSITE:
- Index View and stocks view streamer on Redis
- Index Contribution
- Circuit Breaks
- IPO bids details
LISTING CENTRE:
- Corporate Filing Announcement Result Ship
- Reading XBRL Data to Generate Compliance Alerts
- SOP fine calculator
Timeline
Deputy General Manager
BSE Technologies Pvt. Ltd
12.2010 - Current
Software Engineer
Zenith Infotech Pvt Ltd
07.2010 - 11.2010
Database Administrator
Idealake Information Technologies Pvt. Ltd
01.2007 - 07.2010
B.Tech - Computer Science
Shobhit Institute And Engineering Technology
Similar Profiles
Sashi SinghSashi Singh
Assistant General Manager-Information Security at BSE TECHNOLOGIES PVT LTD(BOMBAY STOCK EXCHANGE LTD)Assistant General Manager-Information Security at BSE TECHNOLOGIES PVT LTD(BOMBAY STOCK EXCHANGE LTD)
Aarya NandavadekarAarya Nandavadekar
Asst.Manager - Information Security at BSE Technologies Pvt Ltd (BSEIndia)Asst.Manager - Information Security at BSE Technologies Pvt Ltd (BSEIndia)
Indrajit Kumar SinghIndrajit Kumar Singh
AVP – Tech Ops at RTVTech Systems Pvt Ltd.AVP – Tech Ops at RTVTech Systems Pvt Ltd.