Data Ssis

Bhavani Vetcha

Fairfax, VA 240-***-****

adj03e@r.postjobfree.com

SUMMARY

Over 4 years of extensive experience in database design, development, and administration with MS SQL Server versions 2016/2014/2012/2008R2 using SSIS ETL in Healthcare, Retail, Banking, finance, and industries.

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins, and query writing.

Hands-on experience in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to assist efficient data manipulation and data consistency.

Hands-on Experience in using tools like SQL Profiler and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance.

Worked extensively on system analysis, design, development, testing, and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.

Experience in Data Extraction, Transforming, and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, Bulk Insert, and BCP.

Developed, monitored, and deployed SSIS packages.

Experience in Database Installation, Configuration, Maintenance, Monitoring, Backup, and Disaster Recovery procedure and Replication.

Excellent interpersonal skills and communication skills and ready to take challenges with proven ability. Experience in creating Ad-hoc reports, data-driven subscription reports by using Report Builder in SSRS.

Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT, and Dimensions Tables using Analysis Services.

Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives, and Roles.

Expertise in creating various Parameterized, Cascaded, Linked, Drill-through, and Drill-down reports. Experience in Troubleshooting Report Processing, Subscription, Delivery, and Configuration Problems.

Writing MDX Scripts to create datasets to perform reporting and included interactive drill-down reports, report models, and dashboard reports.

With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions

Experience in performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes. Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.

Has a very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming, and problem-solving skills.

Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative, and the ability to think outside the box.

Expertise in defining the business process flow and gathering business requirements.

EDUCATION

Acharya Nagarjuna University – Master’s in Computer Science Jun’07 – Apr’09

EXPERIENCE

SQL/SSIS/SSRS Developer Jun '20 - Present

Visa Littleton, CO

Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.

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).

Having hands-on experience in DR Processes including Log Shipping and Database Mirroring.

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

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

Developed complex calculated measures using Data Analysis Expression Language using DAX.

Created SSIS/DTS packages to copy tables, schemas, and views and to extract data from Excel and Oracle.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs, etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Implementing all high availability techniques like clustering, log shipping, replication. Working knowledge with DMExpress ETL tool to filter data based on end requirements. Working experience with Column store indexes, table partitioning in SQL SERVER 2012. Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.

Generated Reports using Global Variables, Expressions, and Functions for the reports.

Writing complex MDX & DAX formula Develop the complex Dashboard by showing %age values.

Experience in creating Ad-hoc reports, data-driven subscription reports by using Report Builder in SSRS.

Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purposes.

Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) generated drill-down reports, parameterized reports, linked reports, sub-reports, matrix dynamics and filters, charts in SSRS 2008/2018.

Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, CTE's, redesigning schemas, and many more.

Also, went through query execution plans, SQL profilers, and did query optimization.

Designed high-level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse. Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Created multiple reports Power BI in Drill mode using tables, financial tables, crosses tabs, and charts. Create reports in the Power BI preview portal utilizing the SSAS Tabular.

Published Power BI Desktop reports created in Report view to the Power BI service. Transformed and combined the data using Query Editor in the Power BI

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012/2014, TSQL, Pl/SQL, Visual Studio 2008, Oracle 11g, Cognos, QlikView, Lotus Notes, SSRS, SSIS, OBIEE, Informatica, Erwin.

SQL/SSIS/SSRS Developer Nov '13 - Jun '15

UHG India

Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.

Extract, Transform, and Load (ETL) source data into respective target tables to build the required data marts. Involved in designing ETL as a part of Data warehousing and loading data into Fact tables using SSIS.

Supported Production Environment with scheduling the packages and make the package dynamic with SQL Server Package Configuration.

Developed SSIS packages using for each loop in Control Flow to process all excel files within a folder, File System Task to move the file into Archive after processing, an Execute SQL task to insert transaction log data into the SQL table.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from a relational database and data warehouse Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, and Maps.

Developed custom calculated measures using DAX in Power BI.

Create Common Table expressions (CTE) and temp tables to facilitate the complex queries

Generated and formatted Reports using Global Variables, Expressions, and Functions for the reports. Designed and implemented stylish report layouts.

Developed Query for generating drill down and drill through reports in SSRS.

Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.

Developed SQL queries or stored procedures used by reports to retrieve information from the relational databases and data warehouses.

Environment: Windows 2008 Advanced Server, ODBC, MS SQL Server 2005/2008/2012, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008/2010, SharePoint 2007/2010, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

SQL Server Developer Jan '12 - Oct '13

IBM India

Created new database objects like stored procedures, Functions, Triggers, Indexes, and Views using T-SQL in Development and Production environment for SQL Server 2008.

Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Created efficient, robust SSIS packages for data movement and loading with error checking and well-documented code. Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Created SSIS Packages to integrate data coming from Text files and Excel files.

Created SSIS packages to validate, extract, transform, and load data to data warehouse databases. Built connections to/pulling data from AS400, mainframe/db2, and Oracle.

Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Tested, Cleaned, and Standardized Data meeting the business standards using Fuzzy/exact lookups using SSIS tasks.

Data management and data processing solutions using SSIS includes Error Handling and Slowly Changing Dimensions.

Wrote many stored procedures for cleaning, manipulating, and processing data between the databases.

Worked with DBA team on Database Compression for different databases to save space across different environments.

Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables

Experience in creating Multidimensional cubes using SSAS and designing DW schemas.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports, and linked reports using SSRS.

Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.

Environment: SQL Server 2008/2012 Enterprise Edition, ODBC, BIDS, Crystal Reports 8.0, XML, ASP.NET, Visual Basic 6.0.

KEY SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, DAX, MDX, C, C++, C#, ASP.NET, XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2014,2012,2008R2,2008,2005

DWH/BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Cognos, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suite, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, ProClarity, Microsoft Office (MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP/2003, NT & Windows 9x, MS-DOS, and UNIX.

Contact this candidate