Crop Picture
NOTE: Do not upload any image that violates our Picture Policy. Doing so will result in the removal of the concerned image without prior notification.
概要
• Over 8 years Database experience with design, development and administration experience in both OLTP and OLAP
• Expert in Creating Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Extensive knowledge of clustering environment.
• Data Architecture (Conceptual, Logical, Physical) experience involves Normal forms (RDBMS) & Star Schema, Dimension (Slowly Changing, Snowflake) & Facts.
• Excellent experience of managing BI environment (Microsoft Azure SQL Database/ Azure SQL Data Warehouse Parallel Data Warehouse ,Microsoft Business Intelligence Suit, Amazon RedShift, PolyBase), which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
项目
工作经历
Advisory Software Engineer (Business Intelligence)
-Design and Development of Data warehouse (Dimensional Modelling, Database design and ETL) and Business Intelligence (Report, KPI, Scorecards, Dashboards)
-Develop and Design the integration process for Data warehouse.
-Designed data marts.
-Tuned ETL stored procedures, triggers and user defined functions. Designed and developed SSIS packages, designed and enhanced OLAP cubes.
-Participated in numerous report development utilizing Microsoft Power BI and Tableau.
Principal Software Engineer
-Design and Development of Database
-Develop Store Procedure, Functions UDF, Packages and Triggers
-Maintain and Manage Indexes, Query Optimization, Database Configurations
-Good in performance tuning especially tuning complex queries, procedure and indexing strategies
-Analyzing data for quality and reconciling data issues.
-Resolving data integrity issues across stakeholders.
-Bug fixing Expert
-Prototype new applications to refine requirements.
-Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration.
-Creation and maintenance of technical documentation.
Sr. Software Engineer (Database)
- Design and Development of Database
- Develop Store Procedure, Functions (UDF), Packages and Triggers
- Maintain and Manage Indexes, Query Optimization, Database Configurations
- Good in performance tuning especially tuning complex queries, procedure and indexing strategies
- Analyzing data for quality and reconciling data issues.
- Resolving data integrity issues across stakeholders.
- Bug fixing Expert
- Prototype new applications to refine requirements.
- Analyze, define and document system requirements for data, workflow, logical processes, interfaces with other systems, auditing, reporting requirements and production configuration.
- Creation and maintenance of technical documentation.
Sr Software Engineer (Database)
- Design and Development of Data warehousing
- Design and Develop ETLs
- Handling of data over 100 million rows.
- Designing the dimension models using the star schemas.
- Schema Optimization and Data warehousing Optimization.
- Checking the data correction and consistency while loading the data into data warehouse
- Migrating the data from data marts & log files from S3 server to centralized data warehouse
- Finding and fixing the bugs (Redundant Data).
- Write complex SQL queries using condition statements for the generation of user reports.
- Designing and creating the aggregate tables for some huge data sets.
Database Administrator
- Initiated, prepared, implemented and now maintaining the security policies regarding database servers and databases.
- Standardized the privileges with respect of team and their needs for accessing the data.
- Responsible for the physical as well as logical design of physical configuration on the storage media.
- Data Modeling, Data Purging &Performance Tuning (Both OS and Databases).
- Optimization of Queries and database architecture.
- Taking Backups (Migration, Cloning, Full Backups and Incremental Backups).
- Reviewing queries which needed to be deployed on QA, SCM and Production servers. Also, standardized the rules for writing the queries and communicated it to developers.
- Preparing a plan of parent child hierarchy of DB so that all partners can come under one instance and we can move towards MySQL cluster.
- Providing Disaster Recovery Plan, Failovers and High Availability through different types of replication.
- Providing Level-3 Technical Support
