QUALIFICATION SUMMARY:

• I am a performance driven, experienced, and dedicated leader in various areas such as data analytics and mortgage with the ability to exceed all business related goals in a high pressured environment.
• Highly motivated IT and mortgage Professional with 2 years of experience using SQL Server Programming, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services (Tabular) and 2 years of supporting SQL Server connectivity SQL Server authentication, SSRS, and Power BI.
• Having worked thoroughly in MS - BI development tools such as SQL Server integration implemented using Microsoft SQL server 2012 in development, testing & production environments.
• Well versed with T-SQL and database development tasks
• Created unique and complex solutions with the optimization of Stored Procedures, Triggers, Views, Joins, Indexes, and Tables for various applications
• Created SQL queries to retrieve complex data from different tables in various databases using database links, joins, and formatted the results into different reports
• Complex T-SQL batches were written with Common Table Expressions (CTE’s), Temporary tables, and variables for recursive operations
• To view the performance of indexes I used SQL profiler and execution plan objectives
• Created and optimized stored procedures to create Clustered and Non-Clustered Indexes for Query Performance
• Developed complex stored procedures and input/output parameterized reports
• Designed Customized Interactive Dashboards in SSRS using Drill Down, Drill Through and variables
• Developed complex formulas in SSRS to query database and generate different types of reports
• Used SSRS to develop Drill Downs, Drill Through, Linked, Parameterized, and Sub-reports for Business Intelligence
• Used SQL Server Data Tools to create tabular reports, charts, and graphs for various requirements
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Developed completed & effective queries for high-performance reporting & rendered them to HTML, XML and Excel format using Reporting Services (SSRS)
• Used data transformation to create complex packages consist of transformations like Conditional Split, For Each Loop, Multi-Cast, Sort Component, Data Conversion, Script Components, Merge Join, Lookups, Row Count
• Implemented error handling using try and catch blocks. While enabling the logging for stored procedures by capturing system functions such as Error Number() and Error Name
• Used control flow items constantly such as Execute SQL Task for incorporating set updates and deletes, also execute task for parallel package execution using the package ideology for master-child, for auditing purposes for backup folders filled with flat files were moved using the File System Task, For Each Loop Container for loading multiple files of same structure
• I’ve gathered excellent knowledge and experience of creating Jobs, Alerts, SQL Mail Agent, using various Control flow items (such as Execute package task, Execute Process Task, Script Task, FTP Task, Send Email Task, For Loop Container, For Each Loop Container)
• Strong experience in Creating, Designing and Processing a Tabular Data Models ( Dimensions, Measures, defining Referenced Relationships, creating Hierarchies) using Visual Studios
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Proficient in tuning data flow tasks in SSIS using SQL Profiler, SSIS performance monitor
• Advanced in Tabular Modeling and DAX
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Expertise in creating Dashboard Reports to support end users using SSAS.
• Create reports in Power BI Desktop and Service utilizing the connectors and content pack
• Expertise in creating different organization content pack, and service packs
• Expertise in creating reports from importing, Direct Query and Live data from several data sources
• Proficient in tuning data flow tasks in SSIS using SQL Profiler, SSIS performance monitor
• Expertise in data transformations such as added calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Expertise in creating DAX queries
• Created different reports in Power BI Desktop and publish to Power BI online
• Expertise in scheduling refresh and troubleshooting refresh issues
• Expertise in installing, maintaining and troubleshooting the Personal and On-Premise Gateway
• Expertise in maintaining and troubleshooting the different data sources
• Expertise in creating different dashboards and reports
• Expertise in creating Power BI Embedded Reports

PROFESSIONAL EXPERIENCE:

Data Migration and Sample Execution Analyst

Confidential, Dallas, TX

Responsibilities:

• Apply highly advanced data access routines to extract data from various source systems to monitor and ensure compliance along multiple lines of business and work streams.
• Review and test SQL procedures for accuracy of the expected results from the business requirements document.
• Create data collection plans containing all information related to the tests, access source systems and execute procedures to extract the required data.
• Execute SSIS packages for compliance and accuracy to be assured the procedure is executing properly according to the line of business requirements.
• Be sure all documentation is synchronized across the end to end process for the testing of data packages.
• Delivery of data samples to various departments along with the results for archiving and auditing purposes.

SQL Business Intelligence and Power BI Support Engineer

Confidential, Richardson, TX

Responsibilities:

• Help manage the ever-growing information needs our clients
• Serve as an advanced technical resource that can act as an advocate for our customers
• Communicate with business clients via telephone and written correspondence regarding technical questions and issues related to SQL Server technologies.
• Provide advanced technical support to resolve issues related to SQL Server issues related to SQL Server connectivity, linked servers, data movement, and SQL BI related to SSRS.
• Develop solutions for SQL Server issues related to Installation, Administration of Reporting Services (SSRS) including Report Builder, Report Viewer, and SQL On-Premise environments.
• Assisting customers with configuring Kerberos and Windows authentication.
• Supported developers and end users with issues connecting to various data sources through Power BI Desktop.
• Supported customers with issues importing data through the Desktop.
• Assisted customers with creating reports, issues with publishing reports, transforming the data, and the use of multiple visualizations.
• Helped end users with problems installing the desktop, the personal and enterprise gateway.
• Supported customers with configuring the personal, enterprise gateway and connecting to data sources and adding users/administrators.
• Assisting Power BI users with various sign in and sign up issues.
• Helped our customers with different refresh issues in the Power BI online service.
• Supported end users with connecting and importing data from multiple content packs. I.e. Google Analytics, Visual Studio, Adobe Analytics etc.
• Assisted with issues with connecting and importing data from OneDrive business and personal.

Professional SQL Business Developer/Reporting Analyst

Confidential, Dallas, TX

Responsibilities:

• Wrote complex Stored procedures to fetch the data from the give Jobs.
• Created databases, tables, views, functions, and triggers using T- SQL.
• Efficient use of Joins and sub-queries in queries that retrieve data from multiple tables.
• Loaded files into system using MS SQL Server 2012
• Created logical and physical database design, data structures, primary key, foreign key and implemented large databases
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, SQL Server automatic email notification and backup strategy
• Created and managed structured objects like tables, views, stored procedures, views and triggers all while maintaining Referential Integrity
• While using reporting services (SSRS) I designed and created Report templates, Area charts, Data bars, Column charts, Line charts, Bar graphs, Pie charts, Polar charts, Range charts, Scatter charts, Shape charts, and Stock charts based on the financial data.
• Designed Dashboards, Matrixes, Drill Down, Drill Through, Parameters for professional reporting of data.
• Involved in scheduling, creating snapshots, and subscriptions of reports
• Responsible for ongoing maintenance to existing reports and optimized report performance within SSRS