Mahakash Mainder Email & Phone Number

Hyderabad, India

Extensive experience in Designing and Architecting of Highly Scalable and innovative data driven Products – Know Your Customer (“KYC”), Anti-Money Laundering (“AML”) and Combating the Financing of Terrorism (“CFT”) compliance for financial services industry clients. The products are designed for comprehensive monitoring solution for customer and account transactions across business lines and products, which helps a Financial Institutions detect and analyze potentially suspicious activity.Heading the total life-cycle of the product development starting from Data Architecture, Modeling, Design and Management, Performance Tuning in Data space across industry standard Database technologies (Oracle, MS SQL, MySQL, Sybase ASE), and other middle-tier technologies.

Hyderabad Area, India

Extensive experience in Enterprise Architecture with specialization in Data Architecture, Modeling, Design and Management, Migration, Performance Tuning in Transactional Database space across industry standard RDBMS (SAP Sybase ASE, Oracle, MS SQL), Sybase Replication, IQ, ECDA Servers.Heading Database Center of Excellence. Identifying talent, mentoring associates for engagements. Creating Internal White-papers, PoC, Building Tools and Solution Accelerators.Database Competency Development - details are in next sectionsBusiness Development Support - details are in next sections

Hyderabad Area, India

Database Competency Development:● Core Member of Technology Team for building database skill areas and heading Sybase Center of Excellence ● Regularly explored and prepared PoC of new products / versions to demonstrate features and functionalities and presented in Technology Forums to enrich different project teams; e.g. Big Data Technology using Hadoop, HIVE, Sybase CEP● Provided specialist technical expertise and oversight in Database Technology and Architecture Consulting projects● As Thought Leadership initiative, formulated Reference Data Architecture (D0) for Investment Banking● Developed Polaris Internal Certification exam on Sybase, SQL Server, Oracle for Employee Training programs● Contributed in Competency Building through White-papers / Technical Documents, Solution Accelerators, reusable frameworks, Thought Leadership such as - a) Cross RDBMS Database Migration and Deployment Methodologies b) Initial Approach to Data Virtualization c) Overview of Oracle Golden Gate Replication Technology d) Migrating vs. Upgrading to Oracle RDBMS e) Database Performance & Tuning - A Systematic Framework - covering Oracle, SQL server, Sybase, Informix and DB2Business Development Support:● Architected Database solutions and Technical Effort Estimation for Sales Proposals as Demand Creation Support, parallelly validated Database Architecture and effort estimates during Project Initiation phase● Conducted several client presentations on the solutions for their proposals, which positively influenced the outcome in new business generation● Provided direct specialist technology support to on-going projects which significantly increased customer confidence and appreciation, resulting in multiple new project opportunities and new business

Hyderabad Area, India

Northern Trust, Chicago, USA (Jan 2014 – Dec 2014) - Enterprise Data Architect for Designing and Upgrading integrated Sybase Databases and applications.Contributions: Architecture review of all applications and their databases. Optimizing overall system efficiency with emphasis on database upgrade and performance improvements. Achieved overall 70 to 85% database performance improvements. Received Customer Appreciation for overall individual contribution.Chicago Mercantile Exchange (CME), USA (Oct 2012 – Apr 2013) - Architecture review and DB performance optimization. Contributions: Review and redesign of extremely time critical application “SKEP” to improve manageability, performance and stability. Received Customer Appreciation for tuning the application to respond to over 3,000 concurrent users within milliseconds. This database changes were implemented to ensure minimum application changes. Database Environment - Oracle 11g; Modeling tool - Erwin Data Modeler r7.3. Deutsche Bank, New Jersey, USA (Jul 2011 – Aug 2012) - Sybase Database Performance Improvements.Contributions: Database Architecture review and redesign of critical applications: "Tracer" and "Margin" to improve Stability, enhance Performance, and reduce Fragmentation and Deadlocks of complex long running queries of "Margin Batch Processing". Achieved overall 25-30% performance improvement. Received customer’s senior technical team’s appreciation on presentation.

Hyderabad Area, India

DE Shaw, India (Feb 2010 - Feb 2011) - Enterprise Data Architecture Consulting to migrate Sybase ASE databases to MS SQL Server; and Database Performance & Tuning.Contributions: Designed and implemented of multiple-phase migration of interlinked databases/applications from Sybase to SQL Server via real-time cross-database replication. Architected “Database Object Change Management and Automation” and incorporated into client’s work-flow system. Received appreciation for flawless execution.Technologies - Sybase ASE 15.0.3(Sun Solaris) / MS SQL Server 2008/ Sybase ECDA Server / Sybase Replication ServerCitigroup Germany (Feb 2007 - Apr 2007 & May 2008 - Jul 2008) - DBA Support, Consulting, Performance & Tuning.Contributions: DB Upgradation of Sybase ASE & IQ, MS SQL and Oracle, monitoring, tuning and ensuring CITI standard compliance. NikkoCitigroup Tokyo, Japan (Jan 2006 - Mar 2006) - Automation and Streamlining of Performance and Health Monitoring for Critical Sybase/Oracle/MS SQL Databases in all environments and applications.Contributions: Conceptualised and architected a consolidated, centralized database monitoring platform to pre-empt outages/ performance issues. Developed data-model to capture monitored data (conf. changes, performance issues/outages) for all database servers (ASE, IQ, REPL, MS SQL, Oracle) in all environments (DEV, UAT, PROD) for future analysis; shell scripts to automate monitoring activities for early outage alerts. Received customer appreciation and 100% Satisfaction Rating.Citigroup, USA (Apr 2003 - Jan 2005) - Global DBA and Data Security Administrator on Sybase Database environmentsContributions: Received customer appreciations for changing the DBA operations in Citigroup from highly unorganized process to extremely organized and scalable process with global deployment. Provided Sybase Database Administration support to PROD, UAT, DEV applications in USA, Latin America, UK & Asia-Pacific regions.

Irvine, California, Usa

Architected database for ‘IWARE’ application used for ticketing in cinemas, stadiums and theme parks (e.g. Disney World). Designed and developed replication module to exchange data between head office, regional offices and cinemas. Configured warm standby using Sybase Replication technology (SQL remote) to ensure production continuity on hardware failure.Environment: Sybase SQL Anywhere Studio 8, SQL Remote, MS SQL Server 7.0, Delphi 5.0, Windows.

San Diego, California, Usa

Team Lead for DBA: Created detailed project plan based on long term functional requirements for DB Upgrades; delegated and coordinated tasks among DBAs and OS AdministratorSybase DBA: Installed, configured and maintained 24/7 Sybase databases and replication server warm standby environments. Upgraded and performance tuned Sybase servers. Estimated resource requirements based on database growth and performance requirementsDeveloped accelerators and reusable frameworks for database maintenance and data exchange between MS SQL Server 2000 to Sybase ASE using Unix ODBC driver. Optimised Sybase infrastructure by disk reorganisation and load balancing. Developed Stored Procedures for Reconciliation process of portfolios between ‘PORTIA’ and ‘BETA’ systemsEnvironment: Sybase SQL Server 11.0.3.3, 12.0.0.3, Replication 11.X, AIX 4.3.3, Windows, IIS, Crystal Reports.

Kolkata Area, India

Team Building: Led, Mentored and Trained Sybase Technical Support Team (part of Core division of Sybase Inc. India) Performed DB Architecture, Modeling, Installation, Upgradation, Migration, Performance Tuning, Trouble Shooting, and Technical Support. Guided and Led Application Development using Sybase (SQLs, stored procedures and triggers) and PowerBuilder Quality: Re-engineered and re-defined the technical support procedures to improve productivity based on customers' feedback, requirements and internal assessments to ensure high standards of supportProvided Technical Support Services to Sybase Production Installations at client locations all over India Conducted trainings/workshops on Sybase RDBMS products to multiple corporate clients and institutions including IITBuilt knowledge base repositories through documentation of unique solutionsDeveloped tools for Migration from Unify to Sybase and utility programs for backup automation, monitoring and auditing Environment: Sybase SQL Server 4.x – 11.9.2, Replication Server 10.X–11.X, Power Designer, PowerBuilder 4.X–6.5, HP/Sun/AIX/DEC UNIX O/S, Windows NT/95/98 and Novell Netware

Kolkata Area, India

Raymond Ltd Cement Division, India (Lafarge)- Multiple upgrades and updates from Sybase SQL Server 10.x to 11.x to 11.9.2; Analyzed the mix-workload environment (20+ applications) and performed application (query tuning, method re-engineering) and Database tuning (database configurations, index optimization, memory management, capacity re-planning, disk I/O load balance, re-sizing and assigning named caches); Enabled Database monitoring using 'cron' scheduled shell-scripts and reporting. Developed stored procedures for handling database threshold events (for both 'logsegment' and ‘datasegment’)National Aluminium Company Ltd., India - Designed and implemented the Sybase Replication Environment for distributed databases using publish-subscribe methodology for four locations nation-wide. Installed and configured two-way replication across four sites using mixed mode (Table level, applied function & request function) replication technology.Eveready Industries India Ltd., India - Developed various 'cron' scheduled shell-scripts to automate various regular routines (e.g. database consistency checks, daily log usage, table data defragmentation, index re-creation, etc.) to be run during the off-peak hours, (with filtered errors emailed to the DBA account). This was designed for proactive monitoring. Performed application query tuning and database tuning (capacity, disk IO load balance, database devices and segments, indexes, database configurations). Upgraded from Sybase SQL Server 10.0.2.4 / 11.5.1; supported all 11 different production server locations across India.Environment: Sybase SQL Server 4.2. to 11.5, Sybase Replication Server 11.5, Sybase Tool Set 5.5, DBLibrary/C, PowerBuilder 5.x to 6.5, Sun Solaris 2.6, Digital Unix 4.0 & Windows NT.

New Delhi Area, India

System Analysis and Design of Sales operations including dealer management, order status, tracking, Settlement of bills with customer and handling different types of sales transactions Object Based Database Management System design. Incorporation of a method to define newer types of sales transaction to improve the extendibility of the system.Environment: FoxBASE/Mac, Macintosh Version 7.1, and Apple Quadra

New Delhi Area, India

System Analysis and Design for the Integrated Computer System. Developed modules namely Bill of Material, Production Scheduling, Material Requirement Planning, Purchase, Goods inwards, Stock control, Production Monitoring & work in process, Finished goods & dispatch monitoring and Plant Maintenance.Environment: FoxPro and Unix

Post Graduate Diploma In Business Management, Specialization : Systems & Marketting

Post Graduate Diploma in Business Management with specialization in Systems and Marketting

Bachelor Of Science (Physics Honours), Chemistry, Mathematics

Bachelor of Science (Physics)

Higher Secondary, Science

Higher Secondary Science (Physics, Chemistry, Mathematics, Statistics)

Secondary Education, Cbse Class X

CBSE - 10 years of Schooling

Certification In "Introduction To Finance", Fundamentals Of Finance

Through Coursera in 2013