ANITHA POLAGARI

Ph: +1(862)247-2715
Email: Polagaria@gmail.com

PROFESSIONAL SUMMARY:
● Having 4 years of professional experience in the IT industry as an MS SQL Server Developer using
Microsoft SQL server 2017/2016/2014/2012 in Finance and Insurance domains.
● Experienced in logical and physical database design and development, Normalization, and data
modeling using MS SQL Server Enterprise Manager.
● Extensive experience in MS SQL Server 2012 and 2016, Business Intelligence technologies like
MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
● Experienced in migrating the programs written in VB and MS Access database to SSIS and SQL
server.
● Experienced in designing high-level ETL architecture for overall data transfer from the OLTP –
Online Transaction Processing to OLAP – Online Analytical Processing with the help of SSIS.
● Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by
using SSIS.
● Expert in designing and scheduling complex SSIS Packages for transferring data manually from
multiple data sources to SQL Server.
● Expert in creating, configuring, and fine-tuning ETL workflows designed in and MS SQL Server
Integration Services (SSIS).
● Extensive work experience in creating Script tasks using C#, ADO.Net, Visual Basics.
● Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
● Experienced in writing Parameterized Queries for generating Tabular reports, formatting report
layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data
source and subtotals for the reports using SSRS 2012, 2014,2016
● Expert in developing Drill through and Drill down reports using MS SQL Server Reporting Services
(SSRS)
● Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables,
user functions, relational database models and data integrity, SQL joins, and query writing.
● Extensively used performance monitor/SQL profiler to solve deadlocks/long-running queries.
● Excellent interpersonal skills and communication skills and ready to take challenges with proven
ability.

EDUCATION:
Bachelor of Science (2006), SK University, India.

TECHNICAL EXPERIENCE:
MS SQL Server 2017/2016/2014/2012, SSRS 2017/2016/2012, SSIS 2017/2016/2012, DB2, MS-Access
2000, MS Excel, MS Visio 2010, Oracle 11g/10g, T-SQL, PL/SQL, VB Script, C#, VB.Net, Visual Studio
2015/2013, MS office, Windows 2010/2007, Server/ XP, SharePoint, Confluence, TFS, Service Now, Jira

PROFESSIONAL EXPERIENCE:

Client: SEI Investments, Oaks, PA

Duration: March 2020 to Present
Role: SQL Server/SSIS/SSRS Developer
The project mainly involved designing, creating, and maintaining a database. It also includes designing
and developing SSIS packages for Cash and Asset reconciliation (CARS) applications. Analyzing
reconciliation results and trade breaks, appraising the daily transactions for multiple custodians, and
loading the data for business validation using SSIS packages and generating reports using SSRS.

Responsibilities:
● Gathered business requirements, definition, and design of data source and data flow.
● Created and maintained database objects (tables, stored procedures, temp tables, and views).
● Optimized the performance of queries with modification in T-SQL queries, normalized tables,
established joins, and create indexes.
● Designed various dynamic SSIS Packages to transfer data from flat files to SQL Server using Visual
Studio 2016 Business Intelligence tools.
● Migrated the programs written in VB and MS Access database to SSIS and SQL server.
● Extensively used SSIS transformations such as Lookup, Derived column, Data conversion,
Aggregate, Conditional split, Pivot, UnPivot, Expression task, multicast, file system task, row count,
flat file, excel, OLEDB source, OLEDB Destination and Send Mail task, etc.
● Worked with fixed-width DAT files, text files, excel files to load data on a daily basis.
● Experienced in working with many complex SQL queries using joins and unions, built-in and custom
functions to generate various reports.
● Created different complex stored procedures by understanding various business logic.
● Created complex stored procedures, views for complex reports developed using SSRS 2014/2016
● Designed and developed data warehouse, data marts, and business intelligence using multi-
dimensional models - star schema, snowflake schema.
● Used SSIS to create ETL packages to validate, extract, transform and load data into data
warehouse databases.
● Worked with different Control flow tasks in creating SSIS packages especially For Loop and For
Each Loop container with Execute SQL and Script Tasks.
● Created stored procedures comprising of dynamic scripts using Bulk Insert, Insert, and Update
tasks to copy data from multiple flat files to SQL Server staging tables.
● Involved in daily loads (full & incremental) into staging, troubleshooting process, issues, and errors
using SQL Server Integration Services (SSIS).
● Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history
of the data.
● Did Extensive testing on the performance of the data on application, stored procedures, tables.
● Created SSIS deployable packages and worked with dba for deployment.
● Created externalized SSIS Configuration XML file for easier updates and maintenance of
configuration.

Project Environment: MS SQL Server 2016 Enterprise Edition, MS SSRS 2016, MS SSIS 2016, T-SQL,
Windows Server 2010, Service Now, Visual Studio 2016, SharePoint, MS Visio.

Client: AIG, Berkeley Heights, NJ

Duration: Feb 2018 to Feb 2020
Role: SQL Server/SSIS/SSRS Developer

The Project mainly involved Designing, creating, and maintaining a database. It also includes developing
and maintaining SSIS packages and creating Regulatory reports using SSRS.

Responsibilities:
 ● Planned, defined, and designed data based on the business requirement.
● Designed high-level ETL/SSIS architecture for overall data transfer from the OLTP to the Data
warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the
mapping documents.
● Migrated data from different sources (text-based files, Excel spreadsheets, and CSV) to SQL Server
databases using SQL Server Integration Services (SSIS).
● Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data
into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing
Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging,
before loading the data into the Data warehouse.
● Performed Incremental load with several Data Flow tasks and Control Flow Tasks using SSIS.
● Reviewed and fine-tuned stored procedures and triggers before production migration.
● Experienced in creating jobs Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL
Server Agent job.
● Implemented various tasks and transformations for data cleansing and performance tuning of
packages by using SSIS.
● Created C# script using script task in SSIS for loading.
● Created XML and SQL Server package configuration to make package dynamic using SSIS
parameters, expressions, variables, and deploy packages to production Server.
● Involved in creating various Database Objects - Tables, Indexes, Store procedures, triggers, views,
and functions. Improved Performance by creating Clustered and Non-Clustered Indexes and by
optimizing the T-SQL statements using SQL profiler.
● Designed and developed different types of reports including Tabular forms, Matrix (cross Tab
report) form, Conditional, List items, Charts, and Sub reports, custom reports, Drill down reports
using SSRS.
● Responsible for Deployment of the report to the report server using SSRS and used Report
Subscription (Data-Driven and Standard) to publish reports.

Project Environment: MS SQL Server 2014/2012, Enterprise Edition, C#, .Net, MS SSRS 2012, MS SSIS
2012, T-SQL 2014, VB Script, Windows Server 2010, TFS, Jira, and Confluence.