Resume

Sign in

Sql Server Data

Location:
Cleveland, Ohio, United States
Posted:
November 14, 2017

Contact this candidate

KIRAN MAI BANALOLU

(201)-***-****

ac3bnx@r.postjobfree.com

SUMMARY

3+ years of IT/Analyst experience in Database Design and Development using Microsoft technologies SQL Server

****/******/****.

Experience in Requirement gathering from business owners and creating technical design to provide directions for developers.

Experience in IT Database Design, Development and Business Intelligence of Microsoft SQL Server

2012/2008R2/2005 in Development, Test environments with various business domains.

Created Stored Procedure, User-Defined functions, CTEs, Indexes, Views, Constraints, and effective triggers to facilitate efficient data manipulation and data consistency.

Expertise in developing T-SQL statements, Basic PL-SQL, Data Integrity, Performance Tuning, Query

Optimization.

Migrated DTS packages to DTSX packages.

Developed Packages to migrate data from SQL server to Oracle Destination and vice versa.

Designed SSIS packages using various Transformations such as SSD'S, Regular Expression, Lookup, Aggregate and Derived Column Transformations.

Involved in requirement gathering, analyzing, configuring, developing and administration of database applications.

Experience in creating, deploying SSIS Packages and migrating DTSX Packages from 2005 to 2014.

Worked on performance tuning of T-SQL queries and stored procedures by analyzing data and also using tools like SQL Server Profiler and Query analyzer.

Expertise in ETL design.

Expertise in loading data from MS-Access, MS-Excel and other external data sources.

Experience in using different transformations in SSIS packages to delete redundant data from the pre-staging database.

Good team work with effective communication, motivation and organizational skills combined with involvement business process improvements.

Unit Tested the SSIS packages after developing or upgrading and troubleshooting the issues

Microsoft SQL Server Business Intelligence

T-SQL, SSIS, SSRS

Tableau, Production Support

Control-M Enterprise Manager C, C# and VB

MySQL

Data warehouse

HIGHLIGHTS

Business Analysis Requirement gathering Data Migration

Interacting with business owners

ACCOMPLISHMENTS

Developed several internal tools to automate mundane tasks that were quickly adopted by other developers. Certification in Microsoft Business Intelligence and Business Analyst

Business Analyst/SQL BI Developer

Responsibilities:

EXPERIENCE

WeltmanWeinberg & Ries, Cleveland, Ohio

11/2015 to Current

Work with Business teams to understand the system requirements and project goals. Define Systems problems, Collect data, establish facts, and draw valid conclusions. Involve in design discussion and user experience sessions to provide inputs on layouts.

Works directly with IT architects, Software Developers and QA team to manage the technical aspects of development project.

Documents application flows and technical requirements from the application's User Interface standpoint. Provide Weekly Status reports and regular updates to leadership and executive team.

Performance tuning, and optimization of procedures and queries.

Using SSIS, building high performance data integration solutions, including extraction, transformation, and load

(ETL) packages for data warehousing and also Scheduling the SSIS packages and Jobs.

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.

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

Production Support, Creating SQL deploy Jobs and Deploying packages to various environment.

Environment:

SQL Server 2012/2008 (Query Analyzer, Enterprise Manager, SQL Profiler, SSMS), SSRS, SSIS, T-SQL, SQL Agent, (Control-M) Enterprise Manager, TFS (Team Foundation Server).

Survey Developer

Responsibilities:

COUNTY OF FAIRFAX

Fairfax, VA

09/2014 to 12/2014

Public health survey development and implementation.

Develop and employ a survey designed to assess public perceptions about diabetes. Develop survey questions bases on trends identified from literature review.

Work with partner organizations and residents as needed to ensure data collection.

Coordinate and conduct up to 3 focus groups in community settings for the purpose of gathering public perceptions on diabetes.

Assess data from focus groups in order to formulate goals and recommendations. Attend Outreach Team meetings and training as needed.

Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.

Actively designed the database to fasten certain daily jobs, stored procedures. Optimize query performance by creating indexes.

Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries, Stored

Procedures.

Involved in merging existing databases and designed new data models to meet the requirements. Performance tuning and optimization of procedures and queries.

Responsible for the creation and maintenance of entity relationship diagrams, Meta data repository and

Comprehensive system documentation including everything from environment configuration information through standards, policies and procedures.

Responsible for change control management documentation.

Interacted with higher management for reporting root cause analysis and suggested best practices to reduce the down time.

TECNOSOFT

Hyderabad, TG

Trainer (SQL Server Business Analyst/ Business Intelligence Developer) Responsibilities:

01/2012 to 12/2012

Created design flow for the new product launches occurred during the year as per back-end perspective. Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse. Back end Experience in MS SQL Server development, writing T-SQL stored procedures and manipulating existing stored procedures as per necessary changes.

ETL capabilities of SSIS were used to define imports of the data, build scheduling packages.

Design, develop and went live after migrating several SQL Server databases for corporate developers, resolving typical database issues.

Iteration planning for new features and user stories.

Created and maintained databases, tables, views, users, logins, indexes, check constraints and business rules using

T-SQL.

Loaded data from various sources like, flat files, to SQL Server database Using SSIS Package. Created SSIS Packages using slowly changing dimensions, FTP Task, Script task and different set of transformations.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008. Involved in the tuning of the existing Database Objects.

Developed event handlers for package and XML configuration files and Log files to track the execution time, errors, failure via email.

Tested packages in QA and data validation.

Scheduled jobs using SQL Agent and monitoring jobs.

Environment:

SQL Server 2012/2008 R2, SQL 2012 SSIS, SSRS, Microsoft Visual Studio 2008 R2/2012.

EDUCATION

MASTER OF SCIENCE: MPA IN INFORMATION TECHNOLOGY

2015

Virginia International University, Fairfax, VA, USA

BACHELOR OF SCIENCE

Jawaharlal Nehru and Technological University, Hyderabad, TG, India

2012



Contact this candidate