Mayank Tripathi Email & Phone Number

Nashville, Tn, Us

Nashville, Tennessee, United States

Nashville, Tennessee, United States

Currently working as Data Modeler (Architect) / Associate Principal Technology with total experience of 16+ years working with various Databases such as Oracle; PL/SQL; MySQL; MS-SQL Server; T-SQL; SQLite; Graph Database as Neo4j (SQL and NoSQL); and Other programming languages and tools such as Python, PySpark, Databricks, GitHub Actions, Jenkins, AWS, CloudFormation & Terraform as IaC, ETL, Data Warehouse etc.Managed teams of software, data engineer and database professionals resulting in a 15%-20% increase in productivity.Used PySpark to write code for ETL processing using AWS Glue, and loading into OLTP and OLAP (AWS Redshift) databases.Used various tools for data modeling such as Toad Data Modeler; Oracle SQL Developer; ER/Studio; Erwin Data Modeler; Lucid Charts and PlantUML (for Cloud) for specific purposes.Developing Python and PySpark program for data analysis in Databricks and sharing the analytics data and reporting to Business for proactive decisions.Experienced in Data Modeling, Erwin, Star/Snowflake Schema modeling, creating Fact & Dimensional tables, conceptual, physical & logical data modeling.Responsible for architecture design, data modeling and implementation of Big Data platform and analytics applications.Responsible for Database security management. Which includes data security for customers PII data, overall database security on on-prem and on cloud using various methods to name a few as creating users;, AWS Security Group; AWS IAM Users and Roles; AWS NACL; AWS Route Table; Data Encryption etc.Analyzing and translating business needs into long-term solution data pipelines.Working with the development team to create conceptual data flows.Mentor and coach junior program managers resulting in a 15% increase in team productivity.Worked with the Data and Analytics team to architect and build data lake using various AWS services like EMR; S3; Athena; Glue; Redshift etc.

India

1) Worked as a Data Architect to design the Data Model for SQL and NoSQL database, used Erwin tool, Star/Snowflake Schema modeling, creating Fact & Dimensional tables, conceptual, physical & logical data modeling.2) Troubleshooting performance issues and Database Tuning.3) Implemented dimensional Data Modeling to deliver Multi-Dimensional STAR, Snowflake schemas by normalizing the dimensional tables as appropriate in Data Warehouse.4) Developed the ETL data pipeline to extract the data from various sources and loading into SQL server data warehouse after transforming and manipulation for further decision making.5) Implemented best practices for database maintenance, alert notifications, knowledge repository.6) Involved in functions such as database design, logging databases, developing scalable code7) Daily health checks and status reporting of Development servers8) Worked on SSIS, Import-Export Wizard, data migration scripts9) Ability to create or review architecture and specification documents ensuring database security, Performance, and integrity10) Working on Agile methodology11) Working with cross-functional teams12) Coordinating database activities with internal project and client teams.13) Used various tools for data modeling such as Toad Data Modeler; Oracle SQL Developer; ER/Studio; Erwin Data Modeler for specific purposes.

Gurgaon, India

1) Worked on Oracle and SQL Server 2005 / 2008 and MongoDB technologies as a Software Engineer.2) Troubleshooting performance issues and Database Tuning.3) Implemented best practices for database maintenance, alert notifications, knowledge repository.4) Involved in functions such as database design, logging databases,developing scalable code5) Daily health checks and status reporting of Development servers6) Worked on SSIS, Import-Export Wizard, data migration scripts7) Providing Reporting Solutions.8)Responsible for administration, maintenance, performance analysis and capacity planning for 9)MongoDB.10)Set and tune system parameters for MongDB.11)Install and Run MongoDB with multiple instances on servers.12)Optimizing MongoDB CRUD Operations.13)Setting up MongoDB profiling to get slow-queries.

Mumbai Area, India

Indore Area, India

Worked on Java; SQL Server and SSRS.Was one of the key member for achieving CMMi Level 5.

Master Of Business Administration - Mba, Computer/Information Technology Administration And Management, A

Activities and Societies: Attended various Seminars during the Master Degree.Achieve 9.85 GGPA and passed with distinction.

Bachelor'S Degree, Computer Science, A