Preeti

347-***-****

ac8ee9@r.postjobfree.com

SUMMARY:

Having 5+ years of Experience in Microsoft SQL Server 2008/2008R2/2012/2014, T- SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), Power BI, MS-Access and Excel in database and applications development and report design development.

Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and T-SQL.

I used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, slowly changing dimension (SCD), Script task and Send Mail task etc.

Expertise in writing complex SQL Queries, Sub-queries with many joins for generating Stored Procedures, User-defined Functions, Views, cluster index, non cluster index and many more on SQL SERVER databases.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.

Expert in T-SQL scripting for creating various database objects like Stored Procedures, Functions, Triggers and Views.

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Imported data from text files and excel spread sheets into SQL Server 2014 database using SSIS package.

Created/Updated database objects like tables, views, stored procedures, function and packages.

Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.

Designed and developed monthly, quarterly and yearly reports.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.

Used SQL Server Profiler to trace the slow running queries and the server activity.

Developed stored procedures to transform the data from data warehouse to SQL server and load data to fact tables.

Designed stylish Report Layouts and Deployed the Reports using SSRS.

Wrote Complex Stored Procedures, Triggers, Views and Queries.

Created indexes, Constraints and rules on database objects. TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Data Tools(SSDT) Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Crystal Reports, Power BI. Databases: SQL SERVER, MYSQL, SQL Server 2014/2012/2008R2, SQL Server Data Tools 2015.

Languages: C, C++, T-SQL, .Net, C#, HTML, CSS.

Development

skills:

T-SQL, SSIS/SSRS/SSAS.

Operating

Systems:

Windows XP, Windows 7, UNIX, LINUX.

Technologies: .NET, ASP.NET, SQL, JAVA.

CERTIFICATIONS:

SQL Server 2014 Administration and TSQL Programming Certificate

SQL Server Business Intelligence(SSIS,SSRS,SSAS) and Power BI Certificate

DISM (Diploma in Software Management) certificate from IANT (Institute of Advance Network Technology).

EDUCATION:

Masters : Masters in Computer Science

Name of the Institution : GTU University

Year of Passing : JUNE 2012

Bachelors : Bachelors in Science

Name of the Institution : HNGU University

Year of Passing : June 2008

PROFESSIONAL EXPERIENCE

Attained Certifications, on Maternity Leave June 2016 – Oct 2018

SQL Server 2014 Administration and TSQL Programming Certificate

SQL Server Business Intelligence(SSIS,SSRS,SSAS) and Power BI Certificate Employer : Accelerated Data Systems

Duration : November 2015–June 2016

Primary Role : SQL Developer

Location : Greenwood Village, CO

PROJECT DESCRIPTION:

Accelerated Data Systems developed AdvantEdge Collection Software that offers the most functionality and flexibility to debt industry. So it provides the service for people who didn’t paid their debt on time.

Responsibilities:

Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules

Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.

Designed and developed DTS packages for transferring data from flat files and Access files

Performing the ETL operations to support the data loads and transformations using SSIS.

Involved in migration from Oracle to SQL Server using SSIS.

Designed numerous ad-hoc and custom reports using SQL Reporting Services.

Created cluster and non cluster index on the table.

Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.

Maintenance and support of SQL server clustering, and other methods of disaster recovery.

Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2016.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Created reports using report builder (Browser Based) & using report designer (Visual studio).

Environment:

MS SQL Server 2014/2012 SSIS, SSRS, T-SQL, Visual Studio, MS Office, SQL Profiler, Windows 7, T-SQL, HTML, CSS, Microsoft Office Excel Employer : SYNAPSE SOFTECH PVT. LTD

Duration : January 2010–September 2012

Primary Role : Jr SQL DBA

Location : Ahmadabad, India

PROJECT DESCRIPTION:

Worked on retail collection system, a GUI based client/server bill collection software it carrying out daily transactions and for managing inventory. Responsibilities:

Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic using TSQL.

Involved in writing scripts for the programs.

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.

Expert in T-SQL scripting for creating various database objects like Stored Procedures, Functions, Triggers and Views.

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Imported data from text files and excel spread sheets into SQL Server 2014 database using SSIS package.

Created/Updated database objects like tables, views, stored procedures, function and packages.

Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.

Analyzed the existing application programs and tuned SQL queries using SQL Profiler.

Loading data from various data sources using MS Data Transformation Services.

Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.

Assisted in writing and optimizing complex SQL Queries.

SQL performance tuning by modifying SQL or adding/changing indexes.

Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML etc.

Environment:

MS SQL Server, T-SQL, ASP .NET, Microsoft Office Excel, HTML, SSIS, SSRS

Contact this candidate