Jitendra Kumar Shahi personal email
- Valid
As an accomplished Database Solution Architect with over 20 years of experience, I specialize in designing, implementing, and managing robust database solutions tailored to meet a variety of business needs. My passion for data architecture drives my commitment to delivering high-performance, scalable, and secure database systems that empower organizations to excel in today’s data-centric environment.Expertise and Skills:I possess extensive expertise in database design, performance tuning, and data integration across a diverse range of technologies, including SQL Server, Oracle, Google Big Query, Sybase, MySQL, Data Lake, Big Data, HIVE, OLAP, OLTP, ETL, and NoSQL solutions. My technical skills include:• Database Architecture: Proficient in creating logical and physical database designs thatensure optimal performance and scalability, adhering to industry best practices.• Data Modelling and Integration: Experienced in developing comprehensive data models andintegrating diverse data sources for seamless data flow across systems.• Performance Optimization: Demonstrated success in query optimization, indexing strategies,and database tuning, resulting in significant enhancements in data processing and retrievalspeeds.• Team Leadership: Strong leadership skills, mentoring and guiding database engineeringteams while fostering a collaborative environment that promotes innovation and efficiency,along with facilitating training and professional development for team members.• Project Management: Skilled in overseeing database projects from initiation to completion,ensuring timely delivery aligned with business objectives.Approach and Philosophy:I believe effective database management extends beyond mere data maintenance; it requires a deep understanding of underlying business processes and the development of solutions that empower stakeholders to make informed decisions. My approach emphasizes close collaboration with cross-functional teams, gathering requirements, and translating them into actionable database strategies. I prioritize data integrity, security, and compliance, fostering trust in the systems I manage.Achievements:Throughout my career, I have successfully led numerous database migration and automation projects, optimized large-scale database environments, and developed data governance frameworks that have significantly improved data quality and accessibility. My contributions have resulted in enhanced operational efficiencies and reduced costs for the organizations I've served.
-
It Architect SpecialistFisBengaluru, Ka, In -
It Architect SpecialistFis Aug 2024 - PresentBangalore Urban, Karnataka, India -
Sr. Database Engineering ManagerImpact Analytics Dec 2023 - Aug 2024Bangalore Urban, Karnataka, India -
It Architect SeniorFis Nov 2022 - Dec 2023Bengaluru, Karnataka, India -
It ArchitectFis Sep 2019 - Oct 2022Bengaluru, Karnataka, IndiaProject Name: Information Governance PortalTools Used: SQL Server 2016, 2014, SSIS, SSDT, Power BIRole: Database Architect, responsible for designing, integration, new server builds, server cost optimization, disaster recovery planning, performance tuning, query optimization, development, enhancements, maintenance, report generation, and establishing an alerting system as needed.Responsibilities:• Acted as a Database Expert, designing and redesigning multiple databases while identifying and resolving various application logical issues and server performance bottlenecks.• Currently involved in designing a new server to overhaul the entire application, along with developing a database maintenance and backup strategy.• Redesigned and converted over 100 existing SSIS packages for dynamic execution.• Developed the SSIS data processing model and rewrote code, resulting in significant improvements in data processing efficiency.• Solely accountable for database design, integration, and data processing tasks.• Assisted team members from other projects in redesigning their databases and optimizing performance.• Proposed innovative server build design approaches for new database and disaster recovery servers.• Engaged in database programming to meet business requirements.• Recommended best practices for the team to follow. -
Technical ArchitectDsmart Systems Private Limited Jun 2019 - Sep 2019Bengaluru, Karnataka, IndiaWorked as Technical Architect -
Sr. Technical LeadSociété Générale May 2016 - Jun 2019Bengaluru Area, India• Worked as a Senior Technical Lead, involved in database design, architecture, and data model modifications, as well as designing SSIS packages and SSRS reports based on requirements.• Automated numerous manual tasks to save time and reduce debugging efforts (e.g., QTZ automation, FRY7N report automation).• Participated in the preparation and review of documents such as the Impact Analysis Document (IAD) and Unit Test Plan (UTP).• Conducted requirement analysis and ensured traceability with both Low-Level and High-Level Designs, including impact assessment and estimation for enhancement tasks and projects.• Engaged in cloud migration efforts and managed the import and export functionality for databases.• Incorporated various business logic into existing database objects, including stored procedures, tables, and views, while implementing error handling, performance tuning, and query optimization.• Worked on several stored procedures to enhance database performance.• Assigned tasks and allocated work among team members.• Responsible for resolving all quarter-end issues related to regulatory reporting.• Followed the AGILE methodology, participating in daily SCRUM/standup meetings to prioritize tasks.• Took part in Change Review Board (CRB) meetings, code reviews, and audits. -
Sr. ConsultantCapgemini Aug 2010 - Apr 2016Bangalore• Served as a Technical Lead, focusing on database design, versioning, and data model modifications in accordance with requirements and work allocation.• Managed the migration of databases from SQL Server 2005 to SQL Server 2008 R2.• Participated in the preparation and review of key documents, including the Impact Analysis Document (IAD) and Unit Test Plan (UTP), while providing Knowledge Transfer (KT) and Rough Order of Magnitude (ROM) estimates for various modules.• Played a pivotal role in requirement analysis and ensured traceability with both Low-Level and High-Level Designs, as well as managing the import and export functionality for databases.• Developed and modified queries, stored procedures, and functions; implemented error handling logic; performed performance tuning and query optimization; resolved bugs; conducted data auditing; created and modified SSIS packages; and monitored production jobs.• Addressed significant data quality issues and implemented effective solutions.• Created SSIS packages utilizing various transformations, such as Lookup, Aggregate, Derived Column, Conditional Split, and Data Conversion.• Worked with SQL Server Service Broker and implemented SQL injection techniques for login audits and database activity tracking.• Reviewed and tested packages, addressing any bugs using SQL Server 2008 Business Intelligence Development Studio.• Developed documentation for installation, rollback procedures, and test plans to deploy code on production database servers, including interactions with the Change Advisory Board (CAB) during the Request for Change (RFC) approval process.• Utilized a SQL generator to automatically create SQL code for the same set of columns across different stored procedures.• Participated in LEAN/WOM board meetings. -
Analyst ProgrammerSyntel Limited Apr 2008 - Jun 2010Mumbai Area, India• Analyze and understand business requirements to align database solutions accordingly.• Monitor database servers and jobs, troubleshoot issues, and implement timely fixes; design and develop new queries while modifying existing ones; write stored procedures, views, and functions; and implement error handling code.• Responsible for creating SSIS packages and integrating data for Data Mart, Data Warehouse, and SSAS Cubes, including adding dimensions and measures to existing cubes and writing or modifying MDX queries for use in SSRS report generation.• Develop and maintain a real-time data warehouse environment by integrating new data sources and optimizing performance.• Create reports using SSRS, including list reports, drill-down and drill-through reports, linked reports, sub-reports, tabular reports, and matrix reports.• Analyze query execution plans and performance counters, identify performance benchmarks, and tune queries to exceed performance standards.• Contributed to the MockDB project, ensuring data quality testing from source to destination within a two-minute timeframe.• Prepare weekly status reports utilizing MKS Source Integrity 2006. -
Technical Support Software EngineerSpryance (India) Pvt. Ltd Jan 2007 - Apr 2008Mumbai Area, India• Monitor the production database server, analyze production-related issues, and implement timely resolutions.• Design and develop queries, modify existing queries, write stored procedures, views, and functions, implement cursors, and optimize queries for improved performance.
-
Jr. Gis EngineerRmsi Pvt. Ltd Mar 2005 - Jan 2007Noida Area, India• Analyze topographic data according to requirements and create a corresponding topography database.• Digitize data to prepare maps, including point, area, and line objects.• Develop logic to identify dangling roads and create buffers for specified objects to facilitate data analysis and assess future impacts. -
Gis TraineeSurvey Of India Apr 2004 - Mar 2005New Delhi Area, India
Jitendra Kumar Shahi Skills
Jitendra Kumar Shahi Education Details
-
Information Technology -
Computer Software Engineering -
Computing (Cic) -
Biology, General
Frequently Asked Questions about Jitendra Kumar Shahi
What company does Jitendra Kumar Shahi work for?
Jitendra Kumar Shahi works for Fis
What is Jitendra Kumar Shahi's role at the current company?
Jitendra Kumar Shahi's current role is IT Architect Specialist.
What is Jitendra Kumar Shahi's email address?
Jitendra Kumar Shahi's email address is jk****@****hoo.com
What schools did Jitendra Kumar Shahi attend?
Jitendra Kumar Shahi attended Indira Gandhi National Open University, National Institute Of Information Technology, Indira Gandhi National Open University, Deendayal Upadhyay Gorakhpur University.
What are some of Jitendra Kumar Shahi's interests?
Jitendra Kumar Shahi has interest in Modeling And Performance Tuning, Data Warehousing, Learning New Bi Tools, Science And Technology, Database Programming, Performance Tuning.
What skills is Jitendra Kumar Shahi known for?
Jitendra Kumar Shahi has skills like Sybase, Ssis, Ssrs, Visio 2007, Ssas, Performance Tuning, Sql Server 2012, Itil V3 Foundations Certified, Lean Six Sigma, Microsoft Sql Server, Business Analysis, Software Project Management.
Who are Jitendra Kumar Shahi's colleagues?
Jitendra Kumar Shahi's colleagues are Shueb Akhtar, Sajid Ahmad, Abhijeet Gurav, Uzma Gani, Laura Taddeo, August Lorenz, Allison W..
Not the Jitendra Kumar Shahi you were looking for?
-
Jitendra kumar Shahi
Alwar District -
1yahoo.co.in
-
1bel.co.in
-
JITENDRA KUMAR SHAHI
Ex Deputy General Manager At Bharat Electronics, Navi MumbaiMumbai Metropolitan Region1gmail.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial