Data Ssis

Damodar Reddy Ambati, SQL BI Developer

Tel: 716-***-**** E-mail: *******.***@*****.***

Executive Summary

Over 6 years of experience in Microsoft Database Technologies that includes experience in Database Design and Development in Financial, Retail and Healthcare Domains.

Extensive experience in Database Design, Data Modeling, T-SQL Development, Developing and Implementing ETL Packages using SSIS and Complex Reports using SSRS.

Experience in writing Efficient T-SQL queries, Stored Procedures, User Defined Functions, Database Triggers and Exception Handlers.

Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.

Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.

Experience in Administering SSIS packages such as Scheduling package execution, backing up and Restoring packages, Monitoring Integration services Performance and activity, and implementing Security considerations for SSIS Packages.

Experience in designing, creating and managing Cubes using SSAS.

Created Views and Tables in Snowflake database using SSIS and Talend.

Created ETL packages using Talend to load the data from different sources to Snowflake and SQL Server databases. Also responsible for scheduling and maintaining jobs in Talend cloud.

Good experience building star schema and snowflake schema depending on the business data requirements.

Experience in Deploying and Monitoring Analysis services.

Extensive knowledge of Designing, Developing and deploying various kinds of reports using Cognos BI series tools and SSRS using relational and multidimensional data.

Experience in creating Report Models for building Ad hoc reports using SSRS.

Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.

Experience in Administering, Managing and Troubleshooting Reporting services.

Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.

Extensive knowledge in Tuning SQL queries, T/SQL queries and improving the performance of the Database using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

Experience in C#/.NET application development environment to use SQL Server Databases.

Excellent communication, interpersonal and analytical skills.

Design, Develop and update reports in conjunction with multiple departments and individuals using Microsoft DAX reports, SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS) and

Other tools.

Skill Set

RDBMS: MS SQL Server 2008/2012/2014/2016, MS Access, Oracle 9i/10g, Snowflake.

Programming Languages: VB scripts, C, C# and UNIX Shell Script.

Tools & Packages: SQL Server Management studio, Talend Studio, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, Visual Studio .NET, WhereScape RED.

Operating Systems: Windows 2007/2008/2010, Windows Server 2008/2008R2/2012.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), TALEND, Power BI, DTS, SQL Server Analysis Services (SSAS), MS Visio, Erwin, Performance Point Server.

Web Technologies: XML, HTML, XSL, IIS.

Application Packages: MS Office Suite, MS Outlook, Microsoft Office SharePoint Server (MOSS).

Professional Experience

GreenSky, LLC. Atlanta, GA Nov 2015 - Present

Sr Data Engineer\Sr SQL BI Developer

Responsibilities:

Execute MS SQL Server queries for data extraction and reporting, performing data conversions (ETL) from several data sources using SQL Server Integration Services (SSIS), develop necessary SQL for loading, updating and maintaining data tables. Also, trouble-shooting data file related issues, and quality control.

Build efficient SSIS packages for processing fact and dimension tables with complex transforms.

Extract, Transform and Load source data into respective target tables to build the required data marts.

Created ETL process using SSIS to transfer data from heterogeneous data sources.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Supported Enterprise ETL Development and support for various Business Divisions interfacing Microsoft Applications.

Collected business requirements from users and translated them as technical specs and design docs for development.

Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2012 using SSIS, BCP and Bulk Insert.

Developed Power BI reports and dashboards from multiple data sources using data blending.

Created ETL packages to load everyday transactional data into Data warehouse and BCP to build analysis services cubes and create SSRS reports on top of the cubes to provide quarterly forecast about each product to the client.

Test and verify processes and systems to understand the cause of data issues. Statistically analyze data and interpret findings to identify opportunities for database and product improvements. Additionally, this position will create and maintain detailed documentation as required pertinent to problems and errors produced by database processes and applications. Coordinate various business improvement initiatives by applying excellent analytical and problem resolution skills.

Retrieve data from various sources and prepares data for analysis. Working on data manipulation and extraction using Microsoft SQL Server Management Studio 2014.

Develop complex SQL queries against various data and computer sources. Including complex Sub queries, correlated queries, and nested queries.

Scripting T-SQL Queries, Stored Procedures, Triggers and user defined functions.

Created Views and Tables in Snowflake database using Talend.

Created ETL packages using Talend to load the data from different sources to Snowflake, SQL Server databases. Also responsible for scheduling and maintaining jobs in Talend cloud.

Responsible for Deploying, Scheduling Jobs, Altering and Maintaining SSIS packages.

Analyze and interpret data, producing clear and compelling reports for different audiences which may include graphs and charts of data developed by analyzing situations and/or data models from which answers can be obtained.

Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization.

Supports business area projects by applying general knowledge of the business area processes including best practices.

Provided data and responded to questions to external groups/agencies/vendors when required.

Created dimensions and fact tables using WhereScape RED tool.

Concisely summarize and communicate recommendations to various levels of management maintaining confidential information.

Environment: SQL Server 2016/2014/2012/2008, Reporting Services(SSRS), Integration Services (SSIS), Analysis Services (SSAS), Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer DTS, MS SQL SERVER, T-SQL, TALEND, Snowflake, Windows 95/NT/2000/2003, XML, MS Excel and MS Access, WhereScape RED, Visual Team Foundation Server, visual studio 2008, visual studio 2012, visual studio 2015 .

FIS Global Jul 15 – Nov 15

Orlando, FL

BI/SSIS/SSRS Developer

Responsibilities:

Designed efficient ETL process to transform and load data from various sources through ESB across the enterprise.

Created Efficient Stored Procedures, Triggers, and Functions, Indexes, Tables, Views and other T-SQL scripts.

Extracted, Transformed and Loaded source data into respective target tables to build the required data marts.

Developed efficient SSIS packages for processing fact and dimension tables with complex transformations.

Developed custom reports and deployed them on server using Power BI.

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.

Developed the Efficient ways of Restartability strategies in case of any SSIS Package failures.

Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Migrated databases from SQL to DB2

Migrated Legacy Oracle and DB2 databases to SQL Server

Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.

Created Reports using SSRS and Created Parameterized reports Cascading reports using SSRS.

Created Cubes from which data can be retrieved rapidly by enterprise information consumers.

Worked on Multidimensional Expressions (MDX) queries on Cubes.

Experience in Modifying, Copying Adobe files containing embedded objects using Documentum

Developing .Net assemblies in C# for business logic and data access.

Designed ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planning.

Involved in the development of the Business logic layer using C# and Data access layer using C# and ADO.NET.

Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.

Created Cell Level Security in cubes using SSAS.

Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Involved in Weekly database maintenance plans and also tuning the databases and applications for better performance.

Created and maintained Database Projects for efficient application development and deployment.

Environment: SQL Server 2014/2012/2008, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Power BI, Index Analyzer DTS, MS SQL SERVER, T-SQL, Documentum, DB2, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access, Visual Team Foundation Server, Crystal Reports, TOAD, visual studio 2008,visual studio 2012 .

Novo InfoTech Aug 2012 – July 2013

Hyderabad, India

Software Engineer - SSIS/SSRS Developer

Roles and Responsibilities:

Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.

Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.

Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.

Converted packages from DTS to SSIS.

Created packages and scheduled them for automation.

Created ETL packages for data conversion using various transformations tasks.

Experience in building star schema and snowflake schema depending on the business data requirement.

Responsible for Query optimization and Performance tuning.

Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.

Developed List, Summary, Cross-Tab and Drill through reports using SSRS.

Environment: SQL Server 2008, BIDS, MSMS, SQL Server Integration Services (SSIS), .NET, C#, ASP.NET, ADO.NET

EDUCATION QUALIFICATION:

MSEE, USA - 2015

BACHELORS IN ENGINEERING, INDIA - 2012

Contact this candidate