Jitendra Kumar Shahi

Jitendra Kumar Shahi Email and Phone Number

IT Architect Specialist @ FIS
Bengaluru, KA, IN
Jitendra Kumar Shahi's Location
Bengaluru, Karnataka, India, India
Jitendra Kumar Shahi's Contact Details

Jitendra Kumar Shahi personal email

About Jitendra Kumar Shahi

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.

Jitendra Kumar Shahi's Current Company Details
FIS

Fis

View
IT Architect Specialist
Bengaluru, KA, IN
Website:
valuelink.co.uk
Employees:
3378
Jitendra Kumar Shahi Work Experience Details
  • Fis
    It Architect Specialist
    Fis
    Bengaluru, Ka, In
  • Fis
    It Architect Specialist
    Fis Aug 2024 - Present
    Bangalore Urban, Karnataka, India
  • Impact Analytics
    Sr. Database Engineering Manager
    Impact Analytics Dec 2023 - Aug 2024
    Bangalore Urban, Karnataka, India
  • Fis
    It Architect Senior
    Fis Nov 2022 - Dec 2023
    Bengaluru, Karnataka, India
  • Fis
    It Architect
    Fis Sep 2019 - Oct 2022
    Bengaluru, Karnataka, India
    Project 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.
  • Dsmart Systems Private Limited
    Technical Architect
    Dsmart Systems Private Limited Jun 2019 - Sep 2019
    Bengaluru, Karnataka, India
    Worked as Technical Architect
  • Société Générale
    Sr. Technical Lead
    Société Générale May 2016 - Jun 2019
    Bengaluru 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.
  • Capgemini
    Sr. Consultant
    Capgemini Aug 2010 - Apr 2016
    Bangalore
    • 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.
  • Syntel Limited
    Analyst Programmer
    Syntel Limited Apr 2008 - Jun 2010
    Mumbai 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.
  • Spryance (India) Pvt. Ltd
    Technical Support Software Engineer
    Spryance (India) Pvt. Ltd Jan 2007 - Apr 2008
    Mumbai 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.
  • Rmsi Pvt. Ltd
    Jr. Gis Engineer
    Rmsi Pvt. Ltd Mar 2005 - Jan 2007
    Noida 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.
  • Survey Of India
    Gis Trainee
    Survey Of India Apr 2004 - Mar 2005
    New Delhi Area, India

Jitendra Kumar Shahi Skills

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 Databases Oracle Html Visio Stored Procedures Sql Testing Requirements Gathering Sdlc Requirements Analysis Team Management Consulting Transact Sql Database Design Unix Data Warehousing Sql Server Reporting Services Business Intelligence Sql Server Integration Services Data Migration Data Analysis Sql Tuning Itil

Jitendra Kumar Shahi Education Details

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?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.