Data Azure

Vandana Kollati +1-848-***-****

SQL Developer addl9c@r.postjobfree.com

Professional Summary:

** ***** ** ************ ********** in IT, as MS SQL Server 2017/2016/2012/2008/2005 Database Developer with SSIS, SSRS, SQL Azure, Azure Data Ware House, Active Directory, Data Factory, Data Lake, Data Bricks, blob storages.

Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing applications and Software Development Lifecycle (SDLC).

Expert in designing and implementing Database using various RDMS like SQL SERVER, Oracle and MS Access, MYSQL.

Extensive knowledge and experience in developing scripts using T-SQL for querying against databases

Expertise in implementing business logic using Triggers, Views and Stored Procedures and User defined functions.

Expertise in implementing Transparent Data Encryption (TDE), Always Encrypted, Static data masking and Dynamic Data Masking on SQL Server encryption using symmetric keys.

Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Very Strong on tools such as Erwin Data Modeler, Visio, TFS and have full understanding of the Software Development Life Cycle.

Experience in data warehousing solutions (Data mapping, ETL Development, metadata management, data migration, reporting solutions and Data modeling.

Expertise in writing T-SQL Queries using Joins, Sub queries, CTE, Window function.

Experienced with extract data from one or more sources like databases, file systems, Excel.

Load into one or more destinations those destinations can be a data warehouse and File system.

Experienced with SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages.

Experienced in creating various types of reports such as drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) on Relational databases.

Experienced on Managing SSIS packages with SQL server management studio, create SQL server agent jobs, configure jobs, configure data sources and schedule packages through SQL server agent jobs.

Hands on experienced in Deploying, Build, and SSIS Packages/Project, Securing SSIS packages, Managing and Browsing SSIS packages.

Knowledge in creating various types of reports in Tableau and Power BI.

Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

Hands-on Experience with different types of Normal forms (1NF,2NF and 3NF)

Developed C#.NET scripts for SSIS packages.

Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduling DTS and SSIS Packages.

In-depth knowledge in Tuning SQL Queries and improving query performance.

Having Experience in Migration from Sql server 2008 to 2012.

Design and create data reports and reporting tools to help business executives in their decision making,

Good understanding of Data Marts, Data Warehousing OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Create Users and assign permissions based on the level of database access the user would need.

Created SSIS packages to load data from Teradata to Sql server.

Good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

Assisted production support team in resolving performance issues, defects, and database availability issues

Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.

Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.

Creation of new database, planning the location of data, index, and transaction log files on the disks

Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.

Performed DBA activities like creating Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.

Has done DBCC checks to ensure the physical consistency of the database and objects.

Checking Space monitoring, Index Defrag, rebuild index and reorganize Index, Update Statistics.

Planning and implementation of database backup/restore Strategies.

Database refresh in QA environment.

Provided 7 x 24 Production support for the database and application issues.

Experience in working with shared code repository TFS, SVN and Git

Technical Skills:

MSBI Stack: SQL Server, SSIS, SSRS, MS Visio, C#, SQL Azure, Azure DataWare House, Active Directory, Data Factory, Data Lake, Data Bricks, blob storages.

Knowledge in Big Data Ecosystem: Hadoop, HDFS, Hive, HDInsight, USQL, Spark and Scala.

MS Servers: Windows 2000/2003/2008/2012, MOSS 2007, SharePoint2010/2013, Office 365, Windows Cluster Server, SQL Server, IIS Server, File Server, Proxy Server, Exchange Server, SMS server, Terminal Server.

Database: SQL Server 2017, 2016, 2012 & 2008 (design & development), azure SQL database, azure SQL data warehouse, Oracle, Teradata, DB2.

Methodologies: Agile / SCRUM and Waterfall.

Education:

• Bachelor’s in Computers and information technology, JNTU

Professional Experience:

Client: American Stock Transfer & Trust Company (NY) Feb ’18 – Till Date

Designation: SQL Developer

The American Stock Transfer and Trust Company is a professional organization for AST was originally founded as a transfer agent of Stock transfer, Stock Repurchase Program, Employee plan services to public companies, Transfer agency and registrar.

Responsibilities:

Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, Azure SQL Database and Azure data warehouse environment

Implemented Copy activity, Custom Azure Data Factory Pipeline Activities Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.

Optimize database systems for performance efficiency.

Worked on Data Factory Editor, to create linked services, tables, data sets, and pipelines by specifying JSON definitions for these artifacts.

Worked on Azure Data Factory which includes creating pipelines, various activities in Azure (lookup, metadata, loop etc.), and Azure data flows

Experience working with different data storage options including Azure BLOB storage, ADLS Gen 1 and Gen 2, FileSytems etc.

Hands-on experience writing complex SQL views, stored procedures in Azure SQL DW.

Built a solution using Azure managed services and Blob storage on-premises data to cloud using Azure Data Factory.

Prepare design specifications and functional documentations for assigned database projects.

Perform space management and capacity planning for database systems.

Develop database tables and dictionaries.

Expertise in implementing Transparent Data Encryption (TDE), Always Encrypted, Static data masking and Dynamic Data Masking on SQL Server encryption using symmetric keys.

Ensure data quality and integrity in databases.

Identify any issues related to database performance and provide corrective measures.

Create complex functions, scripts, stored procedures and triggers to support application development.

Participate in database design and architecture to support application development projects.

Perform data back-up and archival on regular basis.

Test databases and perform bug fixes.

Troubleshoot database related issues in a timely fashion.

Develop security procedures to protect databases from unauthorized usage.

Evaluate existing database and recommend improvements for performance efficiency.

Develop best practices for database design and development activities.

Tools:

MSBI Stack: SQL Server, SSIS, SSRS, MS Visio, C#,

Azure Technologies: Azure Data Factory, Azure Data Lake (Gen1 & Gen2), Lake Analytics, Azure Synapse Analytics (SQL DW).

Client: American Credit Acceptance (NC) Feb ’17– Feb’ 2018

Designation: System Analyst

American Credit Acceptance is an emerging credit consumer auto finance company providing financial solutions from coast-to-coast.

Responsibilities:

Involved in gathering, understanding and validating the project specifications.

Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for generating reports using SSRS.

Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.

Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using T-SQL.

Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2008.

Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.

Designed packages in SSIS 2008 with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task.

Designed different type of reports including: Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports.

Designed Cascading Collapsed, Printable, interacted reports drill-down and sorting functionality.

Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.

Created user variables, property expressions, script task in SSIS.

Experience in Performance Tuning and Query Optimization.

Tools:

Databases : SQL SERVER 2008 R2/2008/2005, 2012 Oracle, MS Access

SQL Tools : SSRS, SSIS, SSMS, Query Analyzer, Profiler, Import and Export, D2k, PowerBI

O/S : Windows Server 2008/XP/98/7

Languages : SQL, PL/SQL, VB.Net, C#, VBScript

Web Tech : Asp.Net, HTML, XML, Java Script

Client: American Institute of Architects (DC) Nov ’14 – Jan’ 2017

Designation: Senior Database developer

The American Institute of Architects (AIA) is a professional organization for architects in the United States. AIA Contract Documents (ACD) is the industry standard documents for the Construction agreements in United States. Currently they have windows based ACD4 application and they want to upgrade it to web based application i.e., ACD5. ACD5 is the new AIA Contract Documents online service. No matter where you are, if you have a computer and Internet availability, you’ll have convenient online access to the entire library of AIA documents as well as your project’s associated contracts and forms. With no need to download software onto your computer, you can start managing your contracts instantly. ACD5 Core Product requirements and provides more contexts to the desired ACD 5 Core application needs and online editing of document, save document, create drafts, check variance and finalizing the documents of product experience.

Responsibilities:

Involved in creation/review of functional requirement specifications, experience in database design process.

Designed and created SQL Databases, tables, indexes, and views based on user requirements.

Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2012 with T-SQL.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Database tuning and performance monitoring.

Scheduling the cold backup by creating the scheduler on daily basis.

Experienced in working with SQL Query Analyzer, scheduling jobs with SQL Server Agent, Index and SQL Profiler.

Performed unit level testing based on unit test case documents prepared from requirements.

Involved in Daily status call to update the progress.

Tools:

Databases : SQL SERVER 2008 R2/2008/2005, 2012 Oracle, MS Access

SQL Tools : SSRS, SSIS, SSMS, Query Analyzer, Profiler, Import and Export, D2k, PowerBI

O/S : Windows Server 2008/XP/98/7

Languages : SQL, PL/SQL, VB.Net, C#, VBScript

Web Tech : Asp.Net, HTML, XML, Java Script

Client: Microsoft (INDIA) Aug’13 - Mar’14

Designation: Database developer

MSL is an application that Microsoft uses to track large volumes of sales to both end customers and re-sellers. It is designed primarily for use in the Volume Licensing space. The primary product sold through MSL is not a physical box set with DVD’s and Manual’s – it is a license, is simply the right to use a piece of software on one computer. MSL allows two types of users ROC and CP.ROC super user who can perform any action on Agreements or PO or POLI or SOLI. CP on the other hand can process the PO and POLI and he cannot submit the order.

Responsibilities:

Analyzing the requirements and design documents and understanding the functionality.

Designing current database by adding tables, relationships, creating stored procedures, views and

Performance tuning of SQL queries and stored procedures.

Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2012 with T-SQL, Experience in Performance Tuning, Optimization.

Experienced with extract data from one or more sources like databases, file systems, Excel.

Experienced with SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages,

Hands on experienced in Deploying, Build, and SSIS Packages/Project, Securing SSIS packages

Worked with Package Configuration & logging and error handling.

Developed various operational Drill-through and Drill-down reports using SSRS.

Experienced in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server, Skills on designed new sites, lists, libraries, web parts and pages.

Tools:

Databases : SQL SERVER 2008 R2/2008/2005, 2012 Oracle, MS Access

SQL Tools : SSRS, SSIS, SSMS, Query Analyzer, Profiler, Import and Export, D2k

O/S : Windows Server 2008/XP/98/7

Languages : SQL, PL/SQL, VB.Net, C#, VBScript

Web Tech : Asp.Net, HTML, XML, Java Script

Client: Right path Computer Technologies Pvt Ltd.(INDIA) May’10 - Jul’13

Designation: Software Engineer

This product developed to forecast business in monthly and weekly buckets. As most of the clients were curious to know the demand for their product weekly and plan effectively, the concept of telescopic planning arose to accomplish the requirement. Shipped data Sales order detail, Master Data etc., is loaded to the engine,

Business logic which is handled in the backend performs few job steps and appropriate inputs will be provided to SOFE which does the required math and gives the forecasted results.

Often times the number of PCs that customers need to make-ready for employees to use (operating system, drivers, and applications) greatly outweigh the labor and hardware resources required to have an efficient roll-out. With Lenovo’s Custom Load standard service, customers simply send in their images (including updates and drivers needed for their environment) and Lenovo’s advanced automation process will apply those images and configuration settings while the customer’s PCs are being manufactured.

Responsibilities:

Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups and fact tables.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data.

Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008.

Worked with various tasks such as Execute Sql task, Data Flow task, File System etc...

Worked with transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, multicast, conditional split, derived column etc...

Worked with Package Configuration & logging and error handling.

Scheduled packages and different maintenance tasks using MS jobs, Job scheduling and alerts.

Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.

Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Staging Database

Experienced with extract data from one or more sources like databases, file systems, Excel.

Experienced with SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages.

Hands on experienced in Deploying, Build, and SSIS Packages/Project, Securing SSIS packages

Worked with Package Configuration & logging and error handling.

Developed various operational Drill-through and Drill-down reports using SSRS.

Experienced in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server, Skills on designed new sites, lists, libraries, web parts and pages.

Tools:

Databases : SQL SERVER 2008 R2/2008/2005, 2012 Oracle, MS Access

SQL Tools : SSRS, SSIS, SSMS, Query Analyzer, Profiler, Import and Export, D2k

O/S : Windows Server 2008/XP/98/7

Languages : SQL, PL/SQL, VB.Net, C#, VBScript

Web Tech : Asp.Net, HTML, XML, Java Script

Client: Bharat Heavy Electricals Ltd (India) Nov’05 - Jan’08

Designation: Assistance Engineer

The main aim of this project is to give a complete report of the pending Vendors list, this Contract will be with financial terms and conditions detailing the billing aspects like the value of goods, taxes, advances, payment schedules, dispatch payments, billing aspects.

Responsibilities:

Participated in KT & Training sessions.

Write T-SQL Queries for Report generation.

Responsible for Bug Fixing in the area of Identification Rule and Order Processing.

Responsible for data validation.

Involved in Daily status call to update the progress.

Involved in drafting the SP to pull the data to the Front End.

Responsible for DB Automation process

Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.

Tools:

Databases : SQL SERVER 2005, MS Access

SQL Tools : SSMS, Query Analyzer, Profiler, Import and Export, D2k

O/S : Windows Server 2000/XP/

Languages : SQL, PL/SQL, VB.Net, C#, VBScript

Web Tech : Asp.Net, HTML, XML, Java Script

Contact this candidate