Data Etl

RADHIKA VUYYURU

Email: *************@*****.***

Mobile: +1-717-***-****

Work Permit: Green Card

A Microsoft Certified Associate in Power BI having 7+ years of qualitative experience in Database Design, Development and maintenance of database applications in SQL/MSBI/Power BI technologies.

PROFESSIONAL OVERVIEW

Over 7+ Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2014/2012/2008R2/2005, SSIS, SSRS, and SSAS.

Good Experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Mapping, Data Loading.

Experienced in interacting with Business Users for analyse the business processes and requirements, transforming the requirements into designing databases.

Excellent experience to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSRS and SSAS) including MS solutions like Microsoft Excel.

Extensively worked on ETL process consisting of data transformations, data sourcing, mapping, conversion and loading.

Experience in creating configuration files to deploy the SSIS packages across all environments.

Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row, Block and Unblock Transformations.

Experience in creating schedule jobs and SSIS Packages using SQL Server Agent.

Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, partition and aggregation using SQL Server Analysis Services (SSAS).

Expertise in Creating, Managing and Deploying SSRS Reports on the portal for user accessibility.

Strong Experience in creating Drilldown, Drill through, parameterized, Cascade Parameterized, Sub, Linked, Charts and Snapshots using SSRS based on Relational and Multidimensional databases.

Experienced in installing and configuring Reporting services and assigning permissions to different levels of users and worked with Report manager for deploying the reports across all the environments.

Experience in developing and designing Power BI reports and dashboards.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Absolute knowledge of Software development life cycle (SDLC), database design, RDBMS, data warehousing and data modelling concepts.

Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions and Views.

Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and knowledge in query optimization & performance tuning.

Worked with cross-functional teams to achieve project objectives.

TECHNICAL OVERVIEW

Integration Tools: SQL Server Integration Services 2017/2012/2008/2005, BCP, SQL Loader, Import/Export Wizard

Reporting Tools: SQL Server Reporting Services 2017/2012/2008/2005

Databases: SQL-Server 2018/2014/2012/2008/2005, Oracle 11g/10g

Languages: T-SQL, PL/SQL

SQL Server Tools: SQL Server Management Studio, Business Development Studio, Visual Studio 2005, 2008

Operating Systems: Windows 10, 2007, 2003

CAREER SCAN

Client: ServiceMaster, Memphis, TN Aug 2017 – Till Date

Role: SQL/BI/ETL Consultant

Description: Worked as SQL, ETL and MSBI consultant, responsible for overall project execution in the area of application software development and data processing. Collaborated with architecture and development teams to design, develop, and deliver integrated solutions that are scalable, adaptable, and sustainable in accordance with established standards.

Responsibilities:

Working with complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Involved in complete SSIS life cycle by creating SSIS packages, building, deploying and executing the packages in different environments.

Maintain existing ETL processes and trouble shoot issues as they arise.

Created package configurations for dynamic connection string to enhance the ease of package deployment.

Provided guidance to Support team during migration of MSSQL database from 2012 version to 2018.

Developed complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code for to meet the business requirements.

Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.

Worked on adding attributes in Star and Snowflake schemas and updating relationships.

Designed and developed cascading parameter reports to show Area/Region/Sub-Regions wise.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Performed administration related activities in Power BI as required to help support team.

Collaborate with the team members and customers to maintain a continuous stream of information regarding the project status and progress.

Helped the offshore team engaged in developing the SSIS Packages/ Reports/Queries/Application/Databases.

Environment:

MS SQL Server 2018/2012/2008R2/2005, Microsoft Visual Studio, SQL Server Business Intelligence Development Studio (SSIS, SSAS), Power BI.

Client: Charter Communication, St. Louis MO Aug 2015 – Jul 2017

Role: MSBI Developer

Description: MSBI developer who administers and develop Extract, Transform, Load (ETL) processes in support of analytics and reporting functions to deliver accurate, timely, and consolidated key operational metrics in support of business planning activities. Perform data profiling to ensure efficient and accurate delivery of data.

Responsibilities:

Involved in complete SSIS life cycle by creating SSIS packages, building, deploying and executing the packages in different environments.

Maintain existing ETL processes and trouble shoot issues as they arise.

Created package configurations for dynamic connection string to enhance the ease of package deployment.

Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.

Developed optimized SQL to implement ETL job steps using ETL tools, including Informatica and SQL Server Integration Services (SSIS).

Analyzed and extract relevant data using SQL and ETL processes from large data sets to produce responses to legal and regulatory inquiries.

Responsible for performance tuning, troubleshooting, and enhancing daily processes within the team’s ETL projects.

Supported maintenance of OLAP Cubes containing Star and Snowflake schemas, Dimensions and data source view.

Developed Drilldown, Drill through, Cross tab Reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements using SSRS.

Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

Environment:

MS SQL Server 2012/2008R2, Visual Studio 2010/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SharePoint Server 2010, Visual Basic 6.0/VB.net, VB Script, MS Office 2013.

Client: Genesys, Hyderabad, India Oct 2012 – Mar 2015

Role: ETL Developer

Description: ETL Developer who is part of newly setup BI team chartered with defining and executing an enterprise business intelligence strategy. This includes BI tool implementation, data optimization, and content access/distribution in a partnership with business and IT stakeholders.

Responsibilities:

Designed and developed SSIS Packages to extract sales data of the new products using Flat-Files.

Validated the consistency of data of existing data flows by reconciling the data from the direct access of Virtual Providers to the application data from the source system.

Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Responsible for implementation of Data Viewers, SSIS Logging, Error Configurations for error handling the packages.

Maintained technical documentation

Performed unit testing

Assisted with application support

Performed application and environment setups/configuration.

Environment:

MS SQL Server 2012/2008R2, Visual Studio 2010/2008, SQL Server Integration Services (SSIS)

Contact this candidate