SQL Developer -

Hi,

I hope you are doing well.

Off: 703-689-9945 Ext 151

Candidate Details:

Name: Vara
Visa : H1B
EXP : 9+
Availability: Immediately
Expected Rate : $75/HR
Resume: [Attached]

Sr.Microsoft Business Intelligence/Data Analyst/Power BI/Tableau Developer

PROFESSIONAL SUMMARY:

Extensive experience in Architecture, Design, Development, Implementation and Support of complex Data engineering solutions for building Enterprise Data warehouses, Data Marts and Business Intelligence needs.
Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Architecture, Analysis, Design, Development, and Implementation.
Experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data,author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
Experience connecting Power BI to various data sources, including databases (e.g., SQL Server, MySQL), cloud platforms (e.g., Azure, AWS),
Hands on experience in Logical and Physical Database design & development, ORDBMS Concepts, Normalization and Data modeling using Erwin data model in relational databases such as SQL Server 2012/2014/2017/2019.
Expertise in developing and maintaining reports in SSRS and Report Builder, and Crystal Reports.
Experience designing Crystal Reports and writing complex formulas at the summary level and group level to implement the business logic.
Experience creating complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports.
Experience creating various PL/SQL stored procedures, views, functions, and temporary tables for data input to Crystal Reports.
Extensive experience in leading Business Intelligence/ ETL implementations using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) and
Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing in SQL Server.
Expert in Design and optimization of OLTP, OLAP tools and OLAP Cubes.
Involved in ongoing support, design, and development of airline-based data warehouse, data marts and online OLAP analytical applications.
Built BI Products and Solution frameworks through Meta Data driven approaches.
Developed U-SQL scripts for processing massive amounts of data.
Wrote T-SQL Procedures, Functions, Views, and Indexes.
Wrote MDX queries to work with cube data.
Defined the custom data reader to read the data from flat files (Character data sets, delimited files, fixed text length) into Data Profiler and Data Cleanser.
Imported the Legacy Data Structures into Relational Data Structures and data mapping in the Relational database.
Developed, Deployed, Scheduled and Monitored SQL workflows/sessions for ETL Purposes.
Strong experience in handling Master Data (MDM), strong focus on the customer data.
Experience troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on a need basis.
Identified and made recommendations for the appropriate data sources for the best solution to extract the data for the project being worked on.
Experience in Excel pivot services and exposure to source safe, version controlling etc.
Experience in leading, mentoring teams and strictly adhering to SDLC/Agile processes.
Experienced in creating build environment setup using TeamCity to deploy Web and batch applications.