Sql Server Data

Swetha Reddy

Email: ***********.***@*****.*** Ph.: 662–801–1888

Visa Status: Green Card holder Address: 15623 Summer Maple Trail Cypress TX 77429 SQL BI Developer with 7 years of experience in Designing, Development and maintenance of database applications using SQL Server 2008 R2/2012 in OLTP/OLAP/BI environment. Extensive experience in disciplined Software Development Life Cycle (SDLC) process and familiar with Spiral and Agile Models.

Good understanding of Normalization /De-normalization, Normal Form and database design using Kimball methodology.

Used ER-Win Data modeling tool to design and implement Logical and Physical models of various Relational Databases.

Maintained Data Integrity and Consistency by passing Data through several analysis steps such as parsing and Prototyping.

Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

Expert in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services

(SSIS), Bulk Insert, BCP.

Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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. Created Perl and Shell test scripts in T-SQL to validate data staging tables and data warehouse tables to validate the data results on DEV/UAT/Prod environment. Implemented Data Mining techniques on production data, to create data mining databases like data collection, data cleaning, data selection, for specify requirements. Performed data cleansing using fuzzy transformations within SSIS packages to eliminate redundant data from the pre-staging database before applying business logic. Experienced in creating configuration files, Logging and Error handling using Event Handlers in SSIS. Experience in deploying and enhancing the SSIS Packages from development server to prod server. Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).

Experienced in creating reports using Grouping and Sorting and creating Sub Reports, Cascading parameterized Report, Report Snapshot, Drill-Through Reports, tabular and matrix reports Parameterized Reports, and ad hoc reports using SQL Server Reporting Services. Involved in Report generation using SSRS and Excel services and deployed them on SharePoint Server. Utilized Report Manager to secure the reports with windows user groups and roles for individual reports and also reports folders.

Expert hands on experience with Microsoft Office applications like Word, Excel, PowerPoint, Visio, manager.

Good knowledge on other reporting tools like Spotfire, Tableau and Qlik View reports. Great enthusiast and always open to learn new concepts and keep up with industry standards. 2

Skills and Abilities

Data Modeling Tools: Erwin, MS Visio

Databases: Oracle 10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, MS SQL Server 2012/2008/2005, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access

Programming Languages: SQL, PL/SQL, C, C++, HTML

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS, SharePoint 2010, Power Pivot Power View, TFS, JIRA ticketing system.

Script Languages: Shell Scripting, PERL

Operating Systems: Windows, UNIX, LINUX

Miscellaneous: Full Life–Cycle Development, Star and snowflake Schemas, Executive Dashboards, MS–Office (Word, Excel, PowerPoint) Professional Experience

American Campus Communities Real Estate, Austin, TX Jul’16– Present Sr. SQL Applications Developer

(Current Project)

Responsibilities:

Leading the reporting projects for four departments Leasing, Marketing, Collections and Market Survey.

Implement Agile Methodology and Kanban Strategies in organizing the Project timelines. Gathering, analyzing business requirements and organize one on one meetings with Business Users. Create database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012 as per the requirement. Implement Try catch, Merge in Stored Procedures

Generate reports using SQL Server Reporting Services (SSRS) (Visual Studio Professional 2015) and deploy to the report server and make it available for the users on local Intranet SharePoint. Create source to target mapping documents for reference. Design reports using Cascading parameters, Parameterized Reports and Report Models, Drilldown, Drill through, Sub reports based on Business requirement. Write complex store procedures and populate database tables for Ad-Hoc reports and sit through interactive sessions with the business users to educate on using Ad-Hoc reports. Create and manage Subscriptions on report server to schedule and automate delivery of reports. Create Release templates for all local environments as well as production environment using Microsoft Release Management Client for setting up automated deployments through TFS. Track and resolve production bugs and design new reports per requirement on JIRA project management software.

Designed the JIRA ticketing board for Reporting team with an organized working methodology structure involving Scrum Master, Business Analyst, Developers, Quality Analyst and UAT team. Schedule and organize monthly grooming sessions with business users to educate on reporting tool features available for enhancing the functionality of the existing reports. Optimized code and improved efficiency in databases including re-indexing, updating statistics, using SQL Profiler, and re-compiling Stored Procedures and performing other maintenance tasks. Participate in meetings with product owners and share insights on developments in future. Support user questions and issues in production.

Build solutions and deploy to staging and development environments and validate the results before releasing to QA and UAT.

Track and save the projects using Team Foundation Server as our version control software. Document the finished bugs and reporting solutions with its respective build versions and related SQL Stored Procedure’s and RDL files.

Implemented Release Management client for biweekly deployments of reports and releases into production.

Attend to expedited tickets for production bugs and schedule and release special deployments the very same day.

Used SQL Server Integration Services (SSIS) to create ETL packages to validate, extract, transform and load data into database.

Grouped, aggregated and split data using SSIS, to build local data marts. Designed and developed Operational data store to build datasets and views by extracting data from different data sources.

Designed and developed reports feeding off of the ODS datasets using PowerBI and conducted PowerBI training sessions for the business users.

Prepared POC with a future plan of moving all static SSRS reports feeding of the OLTP database to more of a dynamic functionality reports fed by the ODS and convert most of executive level SSRS reports to a reporting solution like Tableau and Cognos. Worked on validation of the tables and Reports.

Performed ADMIN activities on the Server by taking Back-up & restoring the DB, providing user access privileges, creating linked servers.

Implemented best practices for development and test environments for all the projects before releasing it to users.

Create and update deployment scripts and documents. Environment: MS SQL Server 2012, T-SQL, SQL Server Management Studio (SSMS), SQL Server Visual Studio Professional 2015, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TFS, JIRA, MS Excel, Flat File, ERWIN, MS Visio, SharePoint 2010, Power Pivot, Power View, Power BI. Federal Home Loan Bank, Des Moines, IA Jan’16 – Jun’16 SQL/SSIS/SSRS Developer

Responsibilities:

Analyzed business requirements and involved in designing the data models for data warehouse using ERWIN.

Created database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012 as per the requirement. 4

Used SQL Server Integration Services (SSIS) to create ETL packages to validate, extract, transform and load data into database.

Created SSIS design template packages for Source load, Type-1, Type-2 dimensions & Fact SSIS packages to use across the Project.

Designed and developed ETL (SSIS) packages for building a new Data Warehouse by extracting, transforming and loading data from Banks various legacy data warehouse sources. Automated SSIS Execution using Windows Scheduler using DTExec Command. Created logging, custom logging and error handling SSIS packages. Grouped, aggregated and split data using SSIS.

Developed SSIS packages to automate many FTP’s files and email to required list of clients. Extracted data from different sources (text based files, Excel spreadsheets CSV files, and Access) to SQL Server databases using SSIS.

Scheduled the packages and jobs to keep extracting the data from OLTP at specific time intervals using SSIS and SQL Server Agent.

Generated reports using SQL Server Reporting Services (SSRS) and deployed on the report server to make it available for the users.

Designed reports using Cascading parameters, Parameterized Reports and Report Models using SQL Server Reporting Services (SSRS) based on Business requirement. Modified MicroStrategy reports & dashboards.

Supported user questions and issues in production. Optimized code and improved efficiency in databases including re-indexing, updating statistics, using SQL Profiler, and re-compiling Stored Procedures and performing other maintenance tasks. Used Try Catch in Stored Procedures, added error handling in SSIS packages and used SSIS catalog. Worked on validation of the tables, SSIS packages and Reports. Performed ADMIN activities on the Server by taking Back-up & restoring the DB, providing user access privileges, creating linked servers.

Implemented best practices for development and test environments for all the projects before releasing it to users.

Created and updated deployment scripts and documents. Environment: MS SQL Server 2012, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Flat File, TFS, ERWIN, SAS, MicroStrategy, MS Visio, SharePoint 2010, Power Pivot, Power View, Visual Studio, Power BI. Wells Fargo, Des Moines, IA Dec’14 – Dec’15

SQL BI Developer

Responsibilities:

Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team. Used various approaches to collect the business requirements and worked with the business users for ETL application enhancements by conducting various JAD sessions. Used Erwin tool for dimensional modeling (Star schema). Forward Engineered Data Model of Staging Database to SQL 2012 Server and help database architecture to modify physical and logical data model for new add tables.

Involved in designing and optimizing various T-SQL database objects like tables (schemas), views, stored procedures, User Defined functions (UDF), indexes and triggers using Management Studio and SQL Profiler.

Created several tables, views using SQL Server 2008R2. These tables, views are created based upon the function specifications.

Created complex stored procedures and functions to perform data profiling, for efficient data storage and manipulation.

Analyze the requirements and fine-tune the stored procedures to improve performance. Created dynamic SQL batches to perform the bulk operation in OLTP environment. Worked on the Optimization and restructuring of stored procedures for the application by evaluating indexing and partitioning large tables.

Collected data from different data source, eliminated irrelevant and unneeded data, and imputed the missing values using different Data Mining Techniques. Improved data quality by implementing data mining concepts on the production database. Managed the entire ETL process involving the extraction, analysis, transformation, loading and presentation of information to the end users.

Designed Mappings between Sources to Operational Staging Targets, Using Star Schema, and designed logic for incremental load using slow changing dimension and Check sum. Created SSIS packages providing specific functionality like Data Profiling and Data Cleansing for a clean ETL process and populating Data-Marts.

Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split. Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Created Script Task to capture the Load counts, Miss Counts and Hit counts of data from one source to another using C#.NET

Implemented Master/Child Packages so only the Master Package has to be scheduled which will in turn fire the other packages.

Created package configurations using Parameters in 2012 to deploy in different environments like DEV, UAT and PRODUCTION.

Created Integration services catalog (SSIDB) using SQL 2012 to deploy the SSIS packages. Involved in debugging of packages with help of Breakpoints, Checkpoints, Event Handlers and Loggings.

Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it. Developed SQL-based test and audit scripts (Perl) to validate SSIS packages and data loads, SSRS reports and report stored procedures.

Created different types of reports like drill down reports, drill through reports, sub-reports, and parameterized reports.

Designed reports to include charts and logos that comply with the organizations culture and policies of reporting and documentation.

6

Designed and deployed Parameter-driven reports using parameters tab in the SSRS GUI procedures by Setting up the report-level parameters, along with Building parameter-driven queries and stored and placing them, in the data field.

Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.

Worked on Team Foundation Server (TFS) to synchronize the data with different-2 sources as well. Environment: SQL Server 2012/2008R2, Windows Server 2008, SSDT/SSIS/SSRS, MS Visio, TFS, SharePoint 2010, Power Pivot, Power View, .Net, Visual Studio, Power BI Schlumberger, Houston, TX Jun’13 – Nov’14

BI Developer

Clear channel Communications, San Antonio, TX Apr’12 – May’13 SQL/BI Developer

AMCAD, Herndon VA Oct’10 – Mar’12

SSIS/SSRS Developer

HSBC Bank, Hyderabad, India Aug’08 – Oct’10

SQL Developer

Education: Bachelor of Engineering in Computer Science, JNTU (Jawaharlal Nehru Technological University), India (2008)

Contact this candidate