Resume

Sign in

Data Power

Location:
Houston, TX, 77077
Posted:
March 12, 2020

Contact this candidate

Resume:

ATLURI RAMYA KRISHNA adb9sk@r.postjobfree.com

BI Reporting Analyst +1-281-***-****

Professional Summary:

•Overall 4+ years of professional software development experience in the areas of Microsoft Business Intelligence (MSBI) and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server.

•3+ years of experience in Power BI reporting which includes DAX and Data Models.

•Having a good Experience in Designing and Developing the SQL Server Integration Services - SSIS Packages with different Control Flow Tasks and Data Flow Transformations, Securing Packages and Deploying the Packages.

•Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, Drill Down, Parameterized, Cascaded and Sub-reports using SSRS.

•Experience in design and implement processes for Deploying and Extracting data for reporting using SQL Reporting Services (SSRS).

•Experienced in Data Warehouse concepts. Having knowledge on SQL Server Analysis Services - SSAS.

•Equal competence Integration Services, Reporting Services and Analysis Services.

•Experience with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.

•Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for on-cloud ETL Processing.

•Experience working with Google Cloud tools like BigQuery and CloudSQL.

•Experience scheduling the GCP flows using Airflow Composer (DAGs).

•Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).

•Experience working with SSIS Catalog Database and Data Mapping Environments.

•Experience in scheduling and deploying reports on Report Manger.

•Hands on experience in SQL Server Reporting Service (SSRS).

•Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.

•Highly motivated, quick learner and extremely versatile. Accepts responsibilities and job duties eagerly with minimal supervision required.

•Implementing and maintaining existing Reports and Dashboards.

•Good knowledge on Sub queries, Joins, Views, and Sub Queries.

•Hands of experience in creating Jobs, Alerts and Scheduled SSIS Packages from SSIS Catalog Database.

•Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

Technical Skills:

•Database Tools: MS SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

•Development skills: T-SQL, PL/SQL, SSIS/SSRS, Power BI

•Reporting Packages: SQL Server Reporting Services, MS Excel.

Professional Experience:

Sr. BI Analyst at Concentrix, Hyderabad (July 2017 – Jan 2019)

Responsibilities:

•Imported data from Excel, SQL Server DB to Power BI to generate reports.

•Created Dax Queries to generated computed columns in Power BI.

•Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

•Used Power BI Gateways to keep the dashboards and reports up to date.

•Creating Row level security with Power BI and integration with power bi service portal.

•Developed profit analysis reports and dashboards by products and customers.

•Implemented Copy activity, Custom Azure Data Factory Pipeline Activities.

•Implemented solutions which utilize Big Data cloud tools like Google BigQuery and CloudSQL.

•Worked on all types of transformations that are available in Power BI query editor.

•Scheduled Automatic refresh and scheduling refresh in Power BI service.

•Developed dashboards, analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions for Data Manipulation.

•Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.

•Configure and maintain using Report Manager and Report

Server for SSRS, Deployed and Scheduled the Reports in Report Manager

•Created Drill Down Reports, Drill Through Report by Region.

•Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

•Created SSIS packages to import data from Excel, OLE DB Source and Flat Files.

•Filtered bad data using Derived column, Lookups, Fuzzy Lookups, Conditional split.

•Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week.

•Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Environment: Power BI, SQL Server 2012, SSMS, SSIS, SSRS, SSAS, Visual Studio, Windows 7, MS Word, MS Excel, Tableau.

SQL/BI/SSIS/ETL Developer at Wipro, Hyderabad (Aug 2014 – July 2017)

Responsibilities:

•Highly responsible for data transformation from various formats to company’s format on a weekly basis. Managed external client project contracts from technical consultation to delivery of projects.

•Involved in Planning, Defining and Designing database based on business requirements and provided documentation.

•Implementation, Requirements gathering and understanding the business flow.

•Designed the Functional Requirements and Mapping Technical Specifications based on Functional Requirements.

•Creating Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.

•Creation of database tables and procedures to update and clean the old data.

•Transferred data from flat files, Excel spreadsheets, and XML Source data to SQL Server using SSIS.

•Designed dashboards, including scorecards and reporting with the Dashboard Designer.

•Involved in data modeling for the application and created ER diagram using Erwin.

•Created, Maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, and Master Reports & Parameterized Reports, Drill Down Report, Drill Through Report using SQL Server Reporting Services SSIS.

•Proficient on and designing Data Mart and Data Warehouse using Erwin in Star and Snowflake Schemas.

•Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server.

•Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

•Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

•Installed MS SQL Server and Management tools using SQL Server Setup Program.

•Coordinated with DBA in creating and managing tables, indexes, triggers, DB links and privileges.

•Designed, created and reviewed primary objects such as views, indexes based on logical design models, user requirements and physical constraints.

•Created document for Self-Service Deployment and Execution process for SSIS packages

•Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

•Responsible to tune ETL procedures and schemas to optimize load and query Performance.

Environment: Microsoft SQL Server Management Studio, SSIS, SSRS, SSAS, SQL Server, MS Word, MS Excel, MS Power Point, Visual Studio.

Internship:

Two months internship as a .NET Developer in Technology Department for ERMS enhancement in S & P Capital IQ Company.

Educational Qualification:

Bachelors of Technology in Information Technology, 2014

(Gokaraju Rangaraju Institute of Engg & Tech, Hyderabad, India)



Contact this candidate