Smita Gautam
Plano,TX
Summary
Results-driven SQL/SSIS Developer with 4 years of comprehensive experience in requirement gathering, analysis, design, development, and implementation of enterprise solutions. Expertise in MS SQL Server (2005/2008/2014/2016), SSIS (2012/2014), and ETL processes. Proficient in creating complex SQL queries, stored procedures, and managing SSIS packages for optimized data integration. Skilled in performance tuning, CI/CD processes, and leveraging cloud technologies such as AWS. Adept in working with Big Data technologies and ensuring high-quality data solutions.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Database Developer
JP Morgan Chase & Co
Plano, TX
05.2022 - 05.2023
- Developed and automated SQL deployment processes in diverse environments and multiple data centers.
- Analyzed business requirements as part of the Software Development Life Cycle (SDLC)
- Developed SQL objects based on given specifications
- Developed and utilized SQL server 2014/2016 to implement business logic through index, views, complex stored procedures, triggers, and user-defined functions.
- Enhanced performance by utilizing SQL Profiler to optimize query execution and tuning.
- Worked on creating and managing SSIS packages
- Created SSIS Packages with components including Derived Columns, Conditional Split, merge, merge join, Union all, and Execute SQL Task in order to enhance data integration processes.
- Worked on Error Handling and Logging in SSIS packages
- Designed SQL scripts to analyze historical data and extracted required data to support management decisions
- Modified stored procedures and views as per requirements
- Extensively Worked on CI/CD automation using Jules, Jenkins, AIM
- Worked on SonarQube for code quality inspection, vulnerability using SSAP scan
- Deployment automation in various environments (Dev, UAT, PROD)
- Worked on PowerShell script and batch script for deployment process
- Created test cases for unit testing and Integration testing
- Managed and coordinated all activities related to Service Now releases as the primary contact.
SQL Developer
Spexoid Tech
01.2007 - 01.2010
- The project integrates sales Applications to be centralized received for all the distributors and creating a central database for the business performance analysis and to generate reports for the requirement management for the new enhancements
- Driving the technical design along with customer team, preparing design specs, functional specs, and other documents
- Involved in all aspects of software development life cycle
- These covers designing, coding, testing, implementing, deploying, and continued support of all projects owned by the team
- Interact with business users as well as other members of IT outside of the team
- Involved in preparation of specifications, development and testing of scripts
- Generated server-side SQL scripts for data manipulation and validation and created various snapshots and views for remote instances
- Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration
- Involved in writing various SQL stored procedures, functions.
Education
Post Graduate Program in Data Engineering -
Purdue University
06.2024
Master of Computer Science (MS) -
Maharshi Dayanand University
Advanced Diploma in Computer Applications -
DOEACC
Skills
- AWS Glue
- Data Warehousing
- SQL Server Integration Services (SSIS 2012/2014)
- ADF
- AWS RDS
- MS-SQL Server 2005/2008/2014/2016
- C#Net
- T-SQL
- Java
- PowerShell
- Batch script
- MS Visual Studio 2013/2017/2019
- MS-SQL Server Management Studio
- Bitbucket
- Subversion (SVN)
- Jules
- Jenkins
- Windows 10/7/Windows XP/2000
- Relational databases
- Microsoft SQL
- Agile Methodology
- Database analysis
- Database Development
- Performance Tuning
- Big data technologies
Certification
- AWS Certified Cloud Practitioner, 10/2023
- SUN Certified Programmer for Java
Timeline
Database Developer
JP Morgan Chase & Co
05.2022 - 05.2023
SQL Developer
Spexoid Tech
01.2007 - 01.2010
Post Graduate Program in Data Engineering -
Purdue University
Master of Computer Science (MS) -
Maharshi Dayanand University
Advanced Diploma in Computer Applications -
DOEACC