SHALINI BASETTY

***** **** ****** *,

Plymouth, MN-55447

Ph: 210-***-****

Email: s69p4h@r.postjobfree.com

SUMMARY:

• Over 5+ years of experience in Microsoft SQL Server Database Management System.

• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008R2.

• Experience in Database Design, Development, Implementation and Support.

• Excellent skills in implementing ETL Packages using Data Transformation Services (DTS) and SSIS 2005/ 2008/2008R2.

• Migrated DTS packages to SSIS and modified using DTS editor wizard.

• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.

• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.

• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

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

• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.

• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005/2008/2008R2.

• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.

• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.

• Expert in creating Ad-Hoc reports, Linked reports, Snapshot reports, Cross-Tab, Conditional, Top N and Sub reports using SQL SSRS.

• Proficient in creating Standard Subscriptions and Data driven subscriptions for delivering reports to people internally within the project.

• Expert in deploying the SSRS reports using Report manager.

• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.

• Integration of SSRS Reports using various web parts into Share point (MOSS 2007) and various delivery mechanisms.

• Data modeling experience using Erwin Data Modeler and MS Visio, and other tools like IBM Data Studio, Razor SQL, System i Navigator, iSeries, Eureka Reporting Tool.

• Expertise in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views.

• Expert in Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.

• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.

• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor (DTA), DBCC Commands and Query Execution Plans.

• Experience in Data Analysis and Graphing Software using Origin Lab.

• Good knowledge in MATLAB and worked on with signal processing projects.

• Experience in circuit designs for Analog Devices using MultiSim and OrCAD software.

• Worked on with few designs in Nano-Materials using AutoCAD.

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

OBJECTIVE:

To emerge as a vision oriented professional in the conscientious engineering environment where I can experience constructive growth being as an asset to the organization.

EDUCATION:

Master of Science in Electrical Engineering GPA:3.8/4.0, Decemeber-2010

The University of Texas at San Antonio, TX

Bachelor of Technology in Electronics and Communications GPA:3.5/4.0, May -2008

VNR VJIET, Jawaharlal Nehru Technological University,

Hyderabad, India

COMPUTER SKILLS:

Languages C, C++, VHDL, VB.Net, HTML

Databases MS SQL SERVER 2000/2005/2008/2008R2, SSMS, SSIS, SSAS, SSRS

Reporting Tools SSRS, Eureka Reports, Microsoft SharePoint 2007/2010, Performance Point Server 2007/2010

Operating Systems Windows 98/2000, XP, Vista

Software IBM Data Studio, MATLAB, Origin Lab, OrCAD

Other Applications MS Office, MS Outlook, MS Visual Studio, MS Project Web Access, Microsoft Visual Studio, Team Foundation Server, Subversion, System i Navigator

WORK EXPERIENCE:

SSAS/SSRS, Database Analyst Aug 2011-Till Date

WELLS FARGO/RCIS, ANOKA, MINNESOTA

Responsibilities:

• Proficient in building complex OLAP Cubes with multiple measures and groups based on the OLAP reporting needs using SSAS.

• Efficient in defining referenced Relationships and creating attribute hierarchies in cubes.

• Experience in writing efficient multi-dimensional expression (MDX) as per the design requirements.

• Used MDX to create calculated members in the cube.

• Good experience in Performance Tuning of OLAP Cubes by designing Aggregations and Partitions in SSAS 2008R2.

• Excellent hands on experience in creating groups and measures, KPIs.

• Proficient in designing various SSRS Reports like Charts, Filters, Sub-Reports, Drill-Down, Drill-Through, Multi-valued parameters.

• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2010) and various delivery mechanisms.

• Experience in creating Dashboards, Scorecards, KPIs using Performance Point Server showing performance at a glance.

• Experience in creating reports off of OLAP cubes and T-SQL Stored procedures and DB2 stored procedures.

• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.

• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.

• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.

• Created Reports and dashboards using Spatial Data and GIS Shape files per business requirements combining multidimensional and relational data sources.

• Proficient in developing database objects such as constraints, indexes and views and creating complex stored procedures.

• Experience with System i Navigator, Razor SQL Tools, iSeries, Eureka Reporting Tools, IBM Data Studio for data retrieval from DB2 Databases.

• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query and generated reports using SSRS which were sent to different Clients, and managers

• Created complex stored procedures using dynamic SQL for various SSRS reporting needs.

• Exposure in using Team Foundation Server as a source control, source repository and project tracking solution.

Environment: MS SQL Server, SQL Server Analysis Services, SQL Server Reporting Services, T-SQL, DTS, Data Analyzer, Visual Studio 2008, VB Script, MS Access, System I Navigator, SharePoint MOSS 2007,Razor SQL, iSeries, Eureka Reporting Tool, IBM Data Studio

SQL Server Developer/SSIS Apr 2011- Aug 2011 PLAN ADMINISTRATORS INC, DE PERE, WISCONSIN

Responsibilities:

• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2008R2.

• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.

• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, Derived Column, Lookup etc. for creating many packages.

• Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.

• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.

• Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.

• Migrated DTS packages to SSIS and modified using DTS editor wizard.

• Involved developing, configuring and deploying SSIS packages and providing security.

• Involved in usage of third party component like Pivotal SSIS connector.

• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.

• Use SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

• Worked on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.

• Created packages in SSIS with error handling.

• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.

• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.

• Migrated all the packages to Test Environment and finally deployed from Test Environment.

• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

• Design and implementation of stored procedures and triggers for automating tasks.

Environment: MS SQL Server, SSIS, T-SQL, DTS, Data Analyzer, Visual Studio 2008, VB Script

Teaching Assistant in Department of EE & IS May 2008 - December 2010

THE UNIVERSITY OF TEXAS, SAN ANTONIO, TEXAS

Responsibilities:

• Assist students with T-SQL, SSMS, and Business Intelligence tools like SSIS, SSRS and SSAS.

• Assist students with Computer Architecture Course.

• Assist students in Advanced Engineering Mathematics.

• Assist students with hardware and software in Electronic Circuits Lab.

• Assist students with basic operations of circuit hardware and OrCAD software.

SQL Server Developer September 2007 – March 2008

LOKESH MACHINES LTD, HYDERABAD, INDIA

Responsibilities:

• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.

• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.).

• Managed Database files, transaction log and estimated space requirements.

• Monitored database application.

• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.

• Designed and implemented several complex reports and administration modules.

• Designed stored procedures for module integrity and application.

• Involved in installation, upgrade and configuration of Microsoft SQL Server and databases.

• Involved in Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.

• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.

• Involved in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.

• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

• Migrated DTS packages to SSIS and modified using DTS editor wizard.

• Design and develop SSIS packages, stored procedures and ETL code using code standards and according to functional requirements.

• Performed Extract Transform and Load (ETL) processes to load data into respective target tables to build the required data marts.

• Created SSIS packages to load data into SQL Server using various transformations in SSIS.

• Created, updated and documented reports using SQL Server Reporting Services (SSRS).

• Created report snapshots to improve the performance of SSRS.

Environment: SQL Server v2005, T-SQL, Win NT v4, MS Excel

Jr. SQL Server Developer

BSNL, HYDERABAD, INDIA June 2006- May 2007

Responsibilities:

• Involved in the entire System study, analysis and Design.

• Installation, configuration of MS SQL Server 2005 for development and testing purposes.

• Involved in developing database objects such as triggers, constraints, indexes and views.

• Used T-SQL to build dynamic stored procedures.

• Managed Database files, transaction log and estimated space requirements.

• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.

• Designed and implemented several complex reports and administration modules.

• Created DTS packages to schedule the jobs for batch processing.

• Created SSIS packages to clean and load data to data warehouse.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, MS Office.

PROJECTS:

Temperature and Frequency Dependence Refractive Index Measurements On Crystals

The University of Texas, San Antonio January 2010-May 2010

Overview:

• Calibration of the instrument was done for different wavelengths on test sample.

• Testing was performed on different crystals on sizes of less than 3mm over wide temperature ranges

• Data Analysis was performed using different techniques in Origin 8.1 software.

Detection and Analysis of Skin Cancer Using Down Sampling Technique, Signal Processing

The University of Texas, San Antonio August 2009- December 2009

Overview:

• Project is based on applying multi-level Transformation using low pass filters, high pass filters and 2 down sampling and FIR techniques to the input image

• Detection of defects and developed a procedure for Skin cancer detection and analysis.

Robotic Activity Monitoring and Control through Mobile Network

VNR VJIET, Jawaharlal Nehru Technological University, India January 2008-May 2008

Overview:

• Project is based on 8-bit Microcontroller which controls the robotic activity through interface.

• GSM Module is interfaced to the designed robot for transmission purposes.

• Cost-effective solution for controlling a robot through mobile network as well as locating the robot through a wireless device.

ACTIVITIES AND HONORS:

• SQL Server DBA Completion Certificate, RCIS, Anoka, MN

• ETA KAPPA NU, Member, UTSA, San Antonio, TX

• EE-Bhalla NSF Grad Fellowship, UTSA, San Antonio, TX

• UTSA Ambassador, ENGR-David & Jennifer Endo Scholarship, UTSA, San Antonio, TX

• NIIT Certifications - C, C++, Hyderabad, India

Contact this candidate