SUMMARY

• Experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS).
• Experience in creating/deploying Data Transformation Services (DTS), Knowledge of Integration Services (SSIS) packages.
• Expertise in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Strong Experience in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, Joins, triggers, clustering, T - SQL, SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), relational database models, data dictionaries, and data integrity.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Created, Maintained & scheduled various reports in Power BI.
• Published Power BI reports from Power BI desktop to Power BI service.
• Created different visualization in Power BI according to the requirements.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Performed data cleaning, data validation, and a using data analysis expression (DAX), power query and power Pivot.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• Strong ability in defining query for generating drill down reports, handling parameterized reports, and creating stylish report layouts in SSRS.
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Develop solutions using SQL and Stored Procedures

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler, BI Development Studio, SSIS, Power BI.

RDBMS: SQL Server 2008/2005/2000

Languages: T-SQL, PL/SQL

Data Modeling: MS Office Visio 2003/2007.

Operating System: Microsoft Windows/Advanced Server, MS-DOS, UNIX.

Methodologies: Logical and Physical Database Design, Star Schema, Snow-Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Power BI Developer

Confidential, Houston TX

Responsibilities:

• Provide expertise in writing complex DAX functions in Power BI and Power Pivot.
• Write useful calculated columns, measures in power bi desktop that are useful in visuals including KPIs.
• Successfully plan, define, and design database based on the business requirement to increase efficiency.
• Create applicable dashboards, Tabular reports, Matrix reports, Charts and Graphs as per customer requirements using Power BI and SSRS.
• Utilize SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Present weekly to the business users about the reports, status, and take note of changes they wish done.
• Create database (DDL, DML, DCL), perform database tuning, SQL tuning, and performance planning.
• Successful create 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 Command, Merge Join, Look up, Sort, Data flow task.
• Carefully configure both Report Servers to manage paginated reports, mobile reports and KPI’s, allowing clients to consume them using a web browser, mobile device or as an email in their in- box.
• Create and develop Sub-Reports, Drilldown, Drill-through, and Parameterized reports using SSRS.
• Created and published various kinds of live interactive data visualization dashboard reports and workbooks from Power Bi desktop to Power BI Servers.
• Participated in gathering requirements and discuss details with team lead.
• Analyzed the source data and figured out correct data mapping to staging tables, data warehouse and data marts

SQL/Power BI Developer

Confidential, Houston, TX

Responsibilities:

• Experienced in writing complex DAX functions in Power BI and Created RLS.
• Used various sources to pull data into Power BI such as SQL Server, Oracle, and SQL Azure.
• Installed and configured Power BI desktop, Enterprise gateway and Personal gateway in Power BI service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Created all kind of reports such as Yearly, Quarterly, Monthly, and Daily and Adhoc.
• Created summary reports, sub reports, Drill Through and Drill-down reports using SSRS.
• Created stored procedures and SQL queries to pull data into Power Pivot model.
• Analyzed the source data and figured out correct data mapping to staging tables, data warehouse and data marts.
• Created Tables, Views, and Indexes, Stored Procedure and Triggers and join statements to retrieve data and update the tables.
• Design and develop T-SQL procedures, query performance tuning and SSIS packages.
• Created functions to provide custom functionality as per the requirements.
• Used SSIS to implement slowly changing transformation to maintain historical data in data warehouse.
• Used various SSIS transformations such as conditional split, look-up table and derived column for data scrubbing and data validation during staging, before loading the data into data warehouse
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent.
• Worked with database objects like Stored Procedures, User Defined Functions, Triggers, and Indexes using T-SQL to create complex scripts and batches.