Prasun Singh Email & Phone Number

Meridian, Id, Us

Meridian, Id, Us

• 5+ years of extensive experience in SQL Server database development/administration, extensively worked in OLTP, OLAP environment & development databases as a Developer/DBA in different environment.• 3+ Years of experience in Developing Application using Angular 2+, Python, Java, .Net Core • Technically guiding team on critical issues.• Led my Team in BI and DBA to achieve the clients requirements• Involved in the Business Analysis of the OLTP and OLAP data and in decision support.• Worked with the Team to come up with innovative ideas to optimize the existing processes• Experienced using Kimball Data Warehouse Methodology. • Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions. • Involved with Discussion with clients and coordinating the day to day task using Agile Methodologies.• Involved in code reviews and Idea Generation with team.• Facilitate the Team to achieve the goals in efficiently and with Quality• Implement corrective action plans to solve organizational or departmental problems.• Worked on Defining the scope, budget, resources and timeline of the project with Stake holders

Meridian, Id, Us

• Develop database architectural strategies at the modelling, design and implementation stages to address business or industry requirements.• Good hands-on knowledge of Source Code Management (Version Control System) tools like Git and Subversion.• Experience with automation/ integration tools like Jenkins, Gitlab and Azure CI/CD.• Experience in containerization and orchestration tools like Docker.• Familiarity with AWS and Azure cloud platforms.• Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.• Develop data models for applications, metadata tables, views or related database structures.• Document and communicate database schemas, using accepted notations.• Provide technical support to junior staff or clients.• Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.• Test changes to database applications or systems.• Created SSIS packages, staged data from different data sources into a SQL Server Database using SQL Server Integration Services. • Wrote stored procedures using T-SQL and implemented them.• Conducted code review.• Hands on experience with languages like Python, Java, .Net Core, Angular to develop enterprise level application.

Meridian, Id, Us

• Following the project life cycle methodology like Agile, defined under the process framework• Ensuring that the customers’ issues have been addressed on priority.• Communicating with clients to determine specific requirements and expectations, managing client expectations as an indicator of quality.• Experience in mentoring and coaching peer engineer working with them to resolve the issues.• Exposure to Java, Python, MSBI Stack, DevOps tools Git, Jenkins, Docker, AWS(EC2).• Worked with clients to understand the requirement and wrote the test suite.• Wrote shell script to post and upload the result to Comcen and notify through emails.• Experience with Tick, ELK and other monitoring tools.• Hands on Experience with Unix environment.

Bachelor Of Engineering (Be), Computer Engineering

10+2, Mathematics