SSIS
SHRADDHA GAIKWAD
Data Analyst
Navi Mumbai
Summary
A logical, analytical thinker with excellent managerial skills possesses three year and four months of experience as a SQL Analyst and worked as Team Lead. To get a challenging position where I can put all my experience and knowledge to give a significant growth to the organization. Supporting business development activities, managing and guiding junior consultants. Excel at working with databases, SQL, SSIS Package, ETL tool and basic programming knowledge.
Overview
3
3
years of professional experience
7
7
years of post-secondary education
1
1
Certification
1
1
Language
Work History
Senior Consultant
Squareone Insights Pvt. Ltd, Client-Tata Capital
Mumbai
03.2022 - Current
- Meet with finance department head for daily, monthly, weekly requirement of Spago reports
- Modifying SQL queries based on requirement of reports.
Team Leader
iNube Software Solutions Pvt Ltd, Client-SBIG
Mumbai
07.2020 - 03.2022
- Proactively monitor customer issues until they are fully resolved, keeping the customer informed along the way
- Log analysis (Ex.code log, Access Log, Server Log)
- Reports, SQL queries execution for engineering teams
- Knowledge of working with ticketing tools
- Writing SQL queries ,Stored Procedure
- Scheduling job, maintaining CPU utilization, restarting application and sanity test
- Drafted reports and worked with the management team
- Takes a collaborative approach to problem-solving
- Implemented new working processes to deliver multiple improvements.
- Led team of 10 members while providing exceptional customer service.
SQL Analyst
PCI Pest Control Private Limited
Mumbai
10.2016 - 10.2017
- Implementation of new ERP System (Odoo)
- Hands on in creating Stored Procedure,Trigger,Function,SQL Tables, Views, Constrains, Synonyms, Sequences
- Backup and Restore databases
- Load the data from MS Excel to Postgresql Table and Postgresql table to MS Excel
- Loaded the data using the SQL loader, Imports & UTL files based on file formats
- Experience with taking backup of database using UNIX command
- Provided on-call support for critical issues in EPR system
- Worked on migration of data from ERP data to Tally
- Worked on SpagoBI (Business Intelligent Tool) to generate statistical data analysis, design, and information flow as per the requirements from management
- Take the database reporting needs and turn them into powerful SQL queries that will extract data and compile it into reports as per the requirement given by the accounts dept
- Maintaining database backups
- Back and Restore Databases
- Designed SSIS Packages to transfer data from flat files,Excel,Raw Files to SQL Server and vice versa using Business Intelligence Development Studio
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, ForEachLoop Container
- Create SQL Server Profiler type logging in SSIS Package
- Extract file names from folders and save in SQL Server table by using SSIS Package.
Jr.SQL Developer
Keystone Systech pvt ltd
Mumbai
02.2016 - 10.2016
- Improves performance of T-SQL queries,Stored procedures
- SQL Dvelopment – Writing Transact SQL
- Gathered business requirements and converted it into SQL stored procedures for database specific projects.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
Education
B.E - Computer
Indira Gandhi College of Engineering, Mumbai University
Navi Mumbai 06.2011 - 07.2015
H.S.C - Science
Bharati Vidhyapeeth Junior College
Navi Mumbai 01.2008 - 05.2010
S.S.C -
IES School
Navi Mumbai 01.2008 - 05.2008
Skills
Programming Languages: SQL,PostgreSQL,MySQL
Databases: SQL server, Oracle, PostgreSQL
OS: Windows, LinuxETL/Reporting Tool: SpagoBI,PowerBI,SSIS,Crystal Reports
Data processingRoot cause analysisGood leadership abilitiesSQL development
T-SQL coding
Analytical and Critical Thinking
Software
SpagoBI
PowerBI
Certification
SAP Basis Training -Netweaver Technologies (IT Consulting & Outsourcing)
Timeline
Senior Consultant
Squareone Insights Pvt. Ltd, Client-Tata Capital
03.2022 - Current
Team Leader
iNube Software Solutions Pvt Ltd, Client-SBIG
07.2020 - 03.2022
SAP Basis Training -Netweaver Technologies (IT Consulting & Outsourcing)
01-2017
SQL Analyst
PCI Pest Control Private Limited
10.2016 - 10.2017
Jr.SQL Developer
Keystone Systech pvt ltd
02.2016 - 10.2016
B.E - Computer
Indira Gandhi College of Engineering, Mumbai University
06.2011 - 07.2015
H.S.C - Science
Bharati Vidhyapeeth Junior College
01.2008 - 05.2010
S.S.C -
IES School
01.2008 - 05.2008