
 SRAVANTHI SETTIPALLI                                          
 Email-id: sravanthimca99@gmail.com
-16192519113500 Contact No:  9886226202
Professional Summary:
5  years of experience in SQL and SQL Server DBA and SSIS.
Strong knowledge in SQL Commands like (DDL, DML, DCL, TCL).
Extensive experience with SQL Server and T-SQL in constructing Procedures, triggers, Tables, Table variables, user functions, views, indexes, CTE, temp tables.
Strong knowledge in Dynamic SQL (sp_executesql, exec).
Good Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
I have experience in SQL Server DBA in Production, Development and Test Environment in 2005, 2008, 2008R2, 2012, 2014, 2016 2017, 2019 &amp;amp; 2022.
Working Experience on Installation, Configuration and Administration of SQL 
                           Server, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 &amp;amp; 2022Experience in performing different types of Backups, Restore and Recovery models.
Experience on tempdb, logfile full, blocking issues and space issues.
Monitoring Disk Space of all the Servers and shrink the data and log files.
Monitoring SQL Server agent scheduled jobs and alerts troubleshooting.
Experience in creating and deploying SQL Server Integration Services (SSIS) packages, using different types of tasks and transformations.
On Data Flow Items like Sources, Transformations and Destinations.
Experience in Importing and Exporting data between different sources like CSV, Excel, OLEDB and Oracle
Experience in creating Reports, Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages.
Experts in generating Drill down Reports, Drill through Reports, Sub Reports, Matrix Reports, and Chart Reports by using SSRS.
I have Good Knowledge in Power BI (Desktop and Service) and DAX.
Employment Details
Currently working as a Developer in Geojit Financial Services, Kochi.
Education
Master of Computer Applications (M.C.A) from S V University with Aggregate of 71% (2008-2011).
Technical Skills
GUI: Visual Studio, SSMS, Power BI
Operating Systems : Windows XP/7.0, 2007, 2010
Databases             : SQL Server 2008 R2, 2012, 2014
REAL TIME PROJECTS INVOLVED 
Project                      : Mutual Fund Investment
Client        : GEOJIT, Cochin
Term        : Nov 2018-Jan2020
Databases        : SQL 2014
Role        : SQL SERVER Admin
Description:
                   The Project Requirement is about Registering a customer for buying and selling of mutual funds and getting funds details such as rating, performance since last few years and mandate creation process.
Roles &amp;amp; Responsibilities
User management and database security imposition by creation and granting of roles and privileges.
Create Logins and granting privileges as per requirement.
SQL Server jobs scheduling and creating alerts and operators and Trouble shoot the Job failures.
Worked on SQL Queries using Joins, Sub Queries &amp;amp; Correlated sub queries to retrieve data from the database.
Requirement gathering from the Business Team.
Working with Triggers, Synonyms, views, Joins, Cross/ Outer Apply, and Table Valued Parameters (Table Type Object). 
Writing Complex Queries, inline queries, Stored Procedures and Functions, CTE&rsquo;s  
Planning a strategy to migrate data from one database to another.
Working with SCD Techniques and data quality.
Developed SSIS packages to get the data from Oracle server, xml, Excel (xls, xlsx, xlsm), Cloud, text, CSV and different types of files to SQLSERVER 
Developed SSIS Packages to read the data from web service, writing into Flat Files and upload them into Remote server using WinSCP.
Worked on different types of SSIS data loads like weekly and monthly Packages.
Automate the SSIS Packages using SQL Server Agent and Windows Task scheduler.
Creating Linked Servers. 
Coordinating the Developing activities with the development team And QA team 
Working with event handlers, Logging and different types of configurations in SSIS packages.
Project                      : Mutual Fund Brokerage Reconciliation
Client        : GEOJIT, Cochin
Term        : Jan 2020-Till now
Databases        : SQL 2014
Role        : SQL SERVER DEVELOPER
Description:
            The Geojit is a one of the Leading Mutual fund broker in India, It is doing a large number of mutual fund Transactions Every month. The Transaction are mainly through 44 AMC&rsquo;s. The Company has records of Mutual fund Transactions of its Customers, for various income from the MF transactions the company depends on the transaction statements given by the RTA each month.
               Since the number of transactions in every month is large in number and it is found difficulty in reconcile these transactions manually the company has decided to implement an automated system which will calculate various heads of income from the MF Transactions and reconcile these calculated figures with that in the statements given by the RTAs.
Roles &amp;amp; Responsibilities
Worked on SQL Queries using Joins, Sub Queries &amp;amp; Correlated sub queries to retrieve data from the database.
Requirement gathering from the Business Team.
Working with Triggers, Synonyms, views, Joins, Cross/ Outer Apply, and Table Valued Parameters (Table Type Object). 
Writing Complex Queries, inline queries, Stored Procedures and Functions, CTE&rsquo;s  
Planning a strategy to migrate data from one database to another.
Working with SCD Techniques and data quality.
Developed SSIS packages to get the data from Oracle server, xml, Excel (xls, xlsx, xlsm), Cloud, text, CSV and different types of files to SQLSERVER 
Developed SSIS Packages to read the data from web service, writing into Flat Files and upload them into Remote server using WinSCP.
Worked on different types of SSIS data loads like weekly and monthly Packages.
Automate the SSIS Packages using SQL Server Agent and Windows Task scheduler.
Creating Linked Servers. 
Coordinating the Developing activities with the development team And QA team 
Working with event handlers, Logging and different types of configurations in SSIS packages.
Get data from different data sources like SQL Server, Excel.
Data cleaning after get data from source to Power BI Desktop by using Power Query Editor.
Created multiple transformations and loaded data from multiple sources into the Power BI Dashboard.
                I hereby declare that the above written particulars are true to the best my knowledge and belief.
   
                                                                                               Signature
                                                                                           (S.SRAVANTHI)

