SAJEEV N D PMP®
Engineering Manager
Bangalore,Karnataka
Summary
Detailed-oriented, experienced Data Warehouse/ BI Manager with over a decade of experience in the field. Proven success in leveraging Data to drive policy improvement, profit, and process optimization. Demonstrated leadership in managing cross-functional teams and projects.
Overview
18
18
years of professional experience
5
5
Certificates
Work History
Engineering Manager
Xperi Inc
Bangalore
02.2022 - Current
- Managing the Production support team
- Work with the En Infra/Windows/Linux/Storage team to address production issues
- Work with the Engineering team address to do development work or the change in the code base due to performance issues
- Daily standup meeting
- Preparation for project status report for senior leadership
- Identify and escalate related issues and risks
- Report status to management on project progress
- Training the team in technical skills and best practices
- Demonstrated leadership skills in managing projects from concept to completion.
- Strengthened communication skills through regular interactions with others.
- Evaluated project requirements to identify and mitigate risks.
- Verified construction documentation to meet client requirements and vision.
TRDW Lead
Tech Mahindra
Bangalore
03.2020 - 11.2021
- Led development team along with managing L4 Support team
- Migrated 2008 R2 (46) application to SQL server 2016
- Worked with Product owner for the new product development.
- Architect, Design SSIS application &SQL server DB objects.
- Build & lead Azure development team for the new product.
- Adhered to timelines to meet quality assurance targets
- Wrote, reviewed and edited technical document in accordance with template requirements.
Advisory System Analyst
IBM India
Bangalore
05.2016 - 02.2020
- As an Advisory system, Analyst in CCBI Team, I am responsible for reviewing the requirements, feasibility checks, design, development, Unit Test, Integration test and production support
- Design & Developing SQL Server database and objects
- Design/Build ETL procedures in SSIS packages
- Code reviews
- Creating and automating the regular Jobs in SQL Server
- Production support (SQL Server /SSIS 2012)
- Performance Tuning
- Project Name
Technical Lead
Infinite Computer Solutions
Bangalore
04.2014 - 05.2016
- Data Migration
- Preparing Technical Specifications
- Conducted one-on-one sessions with business users to gather data warehouse requirements
- Developed logical data models and physical data models
- Design & Developing SQL Server database and objects
- Extracted data from Oracle and SQL Server using load it into a single data warehouse repository
- Design and Developing SSIS interfaces
- Applied data cleansing techniques to ensure consistency amongst data sets
- Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries
- Created the SSIS packages and scheduled them
- Data analysis, problem solving techniques to enable continuous business process improvement
Lead Developer
Sumeru Software Solutions
Bangalore
08.2010 - 01.2013
- Hands on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation
- Strong experience in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications
- Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development
- Preparing Technical Specifications
- Design & Developing SQL Server database and objects
- Design/Build ETL procedures in SSIS packages
- Code reviews
- Creating and automating the regular Jobs in SQL Server
- Recruited and trained four junior developers
- Provided support to development staff about database related issues
Associate Consultant
Wipro Technologies
Bangalore
11.2007 - 05.2010
- Estimation
- Preparing Technical Specifications
- Design and Developing SSIS interfaces
- Code reviews
- Support for Production Deployment
- Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries
- Created tables, indexes, constraints, and procedures
- Created the SSIS packages and scheduled them
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split and Send Mail task etc
- Trained six junior developers.
SQL Server Developer/DBA
NetLink IT Solutions
Cochin
01.2006 - 11.2007
- Designed and created SQL Databases, tables, indexes, and views based on user requirements
- Worked with the application developers and provide necessary SQL Scripts using T-SQL
- Created User Defined Functions, Stored Procedures, and Triggers
- Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes
- Database Backup, Recovery and Disaster Recovery procedures
- Page 3
Education
Master of Science - Information Technology
Manipal Academy of Higher Education
Manipal 04.2001 -
Skills
Expertise withMS SQL Server development including SSIS, Proficient in development of the Stored procedure, Views, Functions etc in MS SQL ServerExperienced with SQL Server Administration tasks such as Backup & restore, replication, linked server, query analyzer, DBCC commands, and data transfer from one DB server to other DB ServerPerformance TuningExcellent SQL and database skills in data storage, retrieval, and joining algorithms and parallel query processing, with extensive experience working with SQL Server, Oracle and Sybase databasesExtensive experience working with MSBI suiteKnowledge on Azure Data Factory, Data Flows, Transformations & Azure SQL ServerKnowledge on data encryptionMicrosoft SQL Server Data Management and AnalyticsTechnologyRDBMSSQL Server 2016/2012/2008/2005/2000, Azure SQL,SybaseGUIVisual Basic 60, Visual Studio Net 20ETL ToolSSIS 2012/08/05, DTS, ADFReportingSSRSOSWINDOWS 2008/2003/2000/8/XP/7/8ApplicationsMS Word, Excel, Access, Power point
Effective managerial techniques
Certification
MCSE: Microsoft SQL Server Data Management and Analytics
Timeline
Engineering Manager
Xperi Inc
02.2022 - Current
TRDW Lead
Tech Mahindra
03.2020 - 11.2021
Advisory System Analyst
IBM India
05.2016 - 02.2020
Technical Lead
Infinite Computer Solutions
04.2014 - 05.2016
Lead Developer
Sumeru Software Solutions
08.2010 - 01.2013
Associate Consultant
Wipro Technologies
11.2007 - 05.2010
SQL Server Developer/DBA
NetLink IT Solutions
01.2006 - 11.2007
Master of Science - Information Technology
Manipal Academy of Higher Education
04.2001 -