Summary
Skills
Work History
Education
Certification
Trainings
Overview
Generic
Srishti

Srishti

Senior Business Analyst
SAS Nagar Mohali

Summary

High-performing, MCP Certified (SQL) professional with extensive experience (10+ years) managing largescale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Hands-on experience with large Financial Databases and also familiar with BI concepts.

Smart and committed to staying up-to-date with new technologies and advancements.

Skills

Querying SQL Server using TSQL

undefined

Work History

Senior Data Engineer

FIS Global
Mohali, Punjab
08.2019 - Current
  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Development and performance optimization of complex SQL queries based upon Banking Clients Requirements.
  • Synthesized current business intelligence data to produce BI Reports and create BI dashboards using Cognos/PowerBI / SSIS tools.
  • Participated in requirements meetings and data mapping sessions, and working closely with Business and other functional teams to understand business needs.
  • Trained and mentored team of 12 members.
  • Leading & supporting UAT & Production rollouts.

Sr. Integration Consultant

Basware India Pvt. Ltd.
Chandigarh (UT)
07.2018 - 08.2019
  • Worked as Senior Integration Consultant for Source-2-Pay (S2P) solution of organization
  • Developing programming scripts/configurations to integrate SaaS based P2P application and customers' ERP solution.
  • Created complex SQL views and stored procedures to join multiple tables for Invoicing solution of Basware.
  • Leading integrations by translating technical requirements to project deliverables.
  • Worked with SQL/Oracle Databases for providing solution to team.
  • Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning.

Sr. SQL Developer

ResponseTek India Pvt. Ltd.
Mohali, Punjab
10.2013 - 07.2018
  • Performing ETL tasks and loading data via XML, CSV and flat files into system.
  • Maintained SQL scripts Indexes and complex queries for analysis and extraction.
  • Designed and implemented stored procedures views and other application database code objects.
  • Accountable for creating and maintaining technical documentations.
  • Support client through User Acceptance Testing (UAT), including investigation and troubleshooting necessary for resolution of defects.
  • Leading an integration team of 12 members for the On-Time, On-Budget delivery of the integration projects, involving the configurations of organization's product with customer's needs.
  • Direct interactions with clients in business meetings and requirement gathering sessions.

Associate System Engineer

Tata Consultancy Services
Chennai, Tamil Nadu
02.2013 - 07.2013
  • Completed process oriented training in ASP.NET and mapped to Hospitality Domain for Quantas Airlines Account.
  • Followed SDLC approach while working at project.
  • Prepared Stored Procedures & query optimization for the existing project.
  • Developed SQL triggers and master tables for automatic creation of primary keys.

Jr. Software Engineer

Deftsoft Informatics Pvt. Ltd.
Mohali
01.2012 - 01.2013
  • Manipulated and implemented object-oriented programming models.
  • Analyzed code defects and failures and presented code refactors and design fixes.
  • Produced advanced and clean code for diverse applications.

Education

Post Graduate Diploma in Computer Applications - Computer Applications

Panjab University
Chandigarh
12.2020 - 07.2021

B.Tech in Computer Science - Computer Science And Programming

Punjab Technical University
Jallandhar
08.2008 - 05.2012

Certification

Microsoft Certified Professional (2016) in 'Querying Microsoft SQL Server 2012/2014'

Trainings

  • Microsoft Power BI Desktop for Business Intelligence
  • Datawarehouse Fundamentals

Overview

11
11
years of professional experience
4
4
years of post-secondary education
1
1
Certificate

Similar Profiles

CREATE PROFILE
Srishti Senior Business Analyst