SUMMARY:

• Almost 6 years of experience in development, testing, maintenance, and implementation of SQL database solutions with exceptional skills in data analysis using Microsoft Business Intelligence Suite (SSIS, SSRS, SSAS) and Power BI.
• Sound knowledge of Software Development Life Cycle (SDLC) with substantial experience with Object Oriented Analysis and Design methodologies.
• Skilled in BI tools of Tableau, Power BI, SSRS including report, query writing using SQL and building frontend BI applications as per specifications.
• Proficient in performing SSIS data transformation task like Fuzzy Look - ups, Aggregate Functions, Merge Join, Data Conversion, Derived Column, Event & Error Handlers.
• Expert in creating various types of complex reports using SSRS such as Drill-Down, Parameterized, Cascading, Conditional, Matrix, Ad-hoc, Sub-Reports, and Charts.
• Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Experience in Dimensional Modeling, ER Modeling, Star & Snowflake Schema and Operational Data Store (ODS).
• Implemented complex business logic with User-Defined-Functions, Indexed Views and created User Defined Data type, Clustered & Non-clustered Indexes.
• Proficient in database design, T-SQL, Complex Querying, Stored Procedures, Complex Joins, User Defined Functions (UDF), CTE's, Views using SQL Server Management Studio.
• Experience in monitoring SQL Server performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services and Power BI.
• Worked directly with end users and other developers to define requirements, review design, develop and test assigned components.

TECHNICAL SKILLS:

Databases: SQL Server, MS Access, Oracle, MySQL, Teradata

Languages: C/C++, HTML, JavaScript, Unix, VBScript, ASP.Net

Database Tools: BIDS, SSIS, SSRS, SSAS, SSMS, DTS

Reporting Tools: SSRS, Crystal Report, Power BI, Tableau

Office Tools: Word, Excel, Visio, PowerPoint

Operating Systems: Windows, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SQL/Power BI Developer

Responsibilities:

• Involved in applying data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Implemented advanced features and tools like Script Task, Lookup, Derived Columns, Condition Split, Union All, Copy Column, Data Conversion as per business requirements.
• Configured package with checkpoints, package logging, error handling and event handling to redirect error rows and fix the error in SSIS.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Optimized the SSAS tabular model process speed by properly designing data models and optimizing DAX calculations.
• Worked with live and import data in to Power BI for creating reports.
• Managed relationship between tables in Power BI using Star schema.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using SQL Server Profiler and Index Tuning Wizard.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Developed various visualization charts like Line charts, Pie charts, Maps, Tiles, Cards, Images, Tables, Bubble & Scatter Plots, Key Performance Indicators using Power BI.
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.
• Incorporated user level and row level security using permissions and filter in Power BI & Tableau. Scheduled jobs for weekly, daily data refresh on different Power BI reports.
• Installed On-Premise data gateway and scheduled daily data refresh in Power BI.
• Identified data quality issues and supported the data governance initiative by participating in necessary activities including data profiling.
• Created validation & test case mapping documents to match data from source to destination.
• Ensured the data refresh on reports, workbooks and dashboards were not coinciding with the server refresh schedule.

Confidential, Pittsburgh, PA

MSBI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database depending on business requirements and provided the documentation.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins and defined roles to implement business rules and control database access.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Involved in data cleaning to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformation.
• Used Power BI desktop to import and transform data for Business Intelligence, visualize data, author reports, schedule automated refresh, and share dashboards based on reports.
• Migrated few of the SSRS and Excel reports to Power BI using Power BI Pro license.
• Utilized DAX queries to design and develop the SSAS Tabular models, KPIs, calculated members as well as hierarchies.
• Used Query Analyzer, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Installation and Configuration of the virtual machine to load the data from On-premises SQL Server to Azure Data ware house.
• Create the Data lake Store and Azure Storage to store the structured and un structured data and set up the firewall rules to specific users to access the data.
• Integrated Custom Visuals like Word Cloud, Chiclet Slicer, Funnel chart, Timeline Slicer, Gantt chart and more based on business requirements using Power BI desktop.
• Created the security model (Row Level Security) in Power BI to restricted the access based on Region and Role of the user.
• Established the relationships among the tables in the database by assigning primary keys, Foreign keys and established the referential integrity.
• Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
• Involved in designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Involved in physical and logical data modeling using Erwin along with the architects.
• Prepared daily and weekly status reports and collaborated with other team members.

Confidential, Dallas, TX

MSBI Developer

Responsibilities:

• Involved in the SDLC with emphasis on the development & maintenance using best practices of code/build/release activities for large and complex implementations.
• Analyzing the requirements, design documents and understanding the functionality of both source and target systems.
• Wrote efficient stored procedures for the optimal performance of the system and Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS.
• Created parameter driven reports for SSRS driven by parameter based TSQL queries and stored procedures.
• Used SQL Profiler for erformance monitor to resolve Dead Locks and long running queries by checking appropriate changes to Transaction Isolation levels.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option and Parameterized and Linked reports.
• Designed, build, and supported complex integrations with external customers and clients for retrieving and supplying data to and from external systems.
• Created visualizations with interactive parameters, drilldowns and/or filters, supported business requirements and improve user experience.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Developed backup and recovery plans based on OLTP load and server down time.