SUMMARY

• 8 years of IT experience as a SQL Developer in Database Development, System Analysis, Implementation, and support of MS SQL Server.
• 4 years of experience working in Power BI using SQL Server 2012/2014/2016/2018 , and 4 years of experience in ETL Developer.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Experienced working with agile methodology involving in Analysis, Design and Development of MSBI solutions.
• Expert in Understanding the Technical Specification and creating and modifying the SSIS packages according to the Business requirements.
• Well versed in Using MDX (Multi - Dimensional Expressions) Queries to retrieve data from Multi-dimensional SSAS Cubes.
• Experience in implementing Microsoft Azure BI Solutions like Azure Data Factory, Power BI, Azure Databricks, Sql Server Integration, SQL Server Reporting Services and Tableau.
• Good knowledge in exploring data in a Variety of ways and across multiple visualizations using Power BI.
• Hands on experience in creating SQL datasets forPowerBIand Ad-hoc Reports.
• Expert on creating multiple kind ofPowerBIReports and Dashboards.
• Hands on experience in Creating, Maintain & schedule various reports inPowerBIlike Tabular Reports.
• Experienced on creating multiple kind of Report inPowerBIand present it using Story Points.
• Expertise in Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI andSSAS.
• Efficient in migrating existing data into thePowerBI.
• Experience in Power BI designed, developed and published multiple innovative visualization report and dashboard in MS SQL Server/Azure cloud environment.
• Heavily used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Generated context filters and data source filters while handling large volume of data using Power BI.
• Extensive experience in designing, developing, and delivering business intelligence solutions using PowerBI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Experience in report generation usingServer Reporting Services (SSRS) from relational databases and OLAP cubes.
• Good working experience in creating reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages.
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies using ETL.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Responsible for creating SQL datasets for Power BI and Ad-hoc reports and expert on creating multiple kinds of Power BI Reports and Dashboards.
• Expertise in writing Shell-Scripts, Cron Automation and Regular Expressions.
• Experience in scheduling Sequence and parallel jobs usingData Stage Director, UNIX scriptsandscheduling tools.
• Experience in identifying and resolve ETL production root cause issues.
• Experience in maintenance, enhancements, performance tuning of ETL code.

TECHNICAL SKILLS

Database: MS SQL Server, MS Access, Oracle, DB2, PostgreSQL

Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET, C#.Net, SharePoint

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Service(DTS), Tableau

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder.

Database Tools: SQL Server Management Studio, Oracle SQL Developer, pgAdmin, NoSQL, DB2, MySQL, Oracle, SQL Server, Sybase

SQL Server Tools: SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP &OLTP, Adobe Photoshop, Abode Flash, Hyper-V Manager

Operating Systems: Windows 10, Windows 2008, 2003R2, Windows Server 2008, Windows XP, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Tx

Business Intelligence Developer

Responsibilities:

• Collaborate with the stakeholders to understand business requirements and propose BI solutions to improve business operations
• Manage and Maintain various strategic reports and visualization dashboards with diverse users within the enterprise.
• Perform data analysis, cleaning, and reporting business operations, services and products.
• Developed Power BI reports and dashboards from multiple data sources.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts and created various Power BI reports.
• Involved in archetecting and developing the Azure data factory pipelines by creating the dataset and source and destination
• Developed Power BI reports with different kinds of filters using DAX queries and slicers to provide business users with effective interaction of reports. connection to move the data from oracle database to azure data lake.
• Design and deploy rich Graphic visualizations with drill-down and drop-down menu options and parameters using Tableau.
• Create various KPI measurement dashboards for enabling insights for the organization.
• Communicate and collaborate with cross-functional teams for creating effective business reports.
• Involved in creating database objects like tables, views, stored procedures, triggers, and functions for maintaining the data efficiently.
• Worked with ETL team and troubleshoot the issues with reports and dashboards.
• Using the SSIS platform as a ETL tool in extracting, transforming, and loading the data.
• Migrated and upgraded all the existing packages from 2008 R2 to 2019 version of Visual Studio and fixing all the issues related to jobs during this upgrade corresponding SQL server 2019.
• Built Power Bl Dashboards and reports using Tabular and multi-dimensional models using Power BI Desktop.
• Performance tuning of the reports and dashboards using Power BI tools.
• Worked with the Data Modeling team and provide suggestions during the model phase so that the reporting needs are not affected during the development phase of the project.
• Worked extensively in Agile environment and in two-week sprints model.
• Attend all scrum ceremonies including scrum planning, stand-up calls, backlog refinement, and retrospective meetings.
• Participate in PI planning meetings and plan for the upcoming quarter.
• Defined best practices and maintained the standard documentation for Tableau report development

Environment: Power BI Desktop, Power BI Service, Python 3.6, Flat files, SQL Server, MySQL, SQL Server Management Studio (SSMS), Windows 2008/2012, Informatica power center, SQL, Teradata.

Confidential, Tx

Power BI Developer

Responsibilities:

• Handled Power BI development and administration role
• Work with the database modeling manager to identify the requisites of a project
• Resolved data gateway issues like reconfiguration, create new data sources in existing gateway cluster by providing windows credentials, file path or server name by going to manage gateway then add these data sources to the gateway in schedule refresh window.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, CSV, Excel, and Text file from Client servers and through FTP.
• Created SSIS packages for ETL and used various transformations like Lookup, Fuzzy grouping, Row count for data cleansing before loading.
• Involved in configuring and upgrading th on premises data getway between various data sources like SQL server to azure services and PowerBi services.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type I and type II slowly changing dimensions.
• Recognized the fact and dimension tables in the OLAP database and created cubes using (SSAS).
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS. created Azure data lake analytics usng SQL for data transformation in azure data lake store to move from raw to stage and then to curated zones.
• Worked with Business Development team to gather requirements and create OLAP cube in SSAS 2008. Included multiple dimensions and measure groups, complex date related calculated fields, KPIs, and conditional formatting.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Generated Drilldown, Drill through, Cross-Tab & Summary reports by using SSRS.
• Used Report Builder to generate Ad Hoc Reports.
• Generated complex reports such as Dashboard, Scorecards, and graph-charts.
• Created and scheduled Report Snapshots in Report manager to improve the performance of SSRS.
• Deployed the reports and cubes in testing, staging and productions environments. Actively participated in production support of report server.

Environment: SQL Server, MS SQL Integration Services (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services (SSAS), Power BI, MS Visio, Report Builder 2.0, Flat Files.

Confidential

Power Bi Consultant

Responsibilities:

• Worked with Project team to outline Project requirements.
• Profiled the legacy database tables to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration
• Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
• Created measures, calculated columns and performed time series analysis using DAX in Power BI
• CreatedSSISpackages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2014 from different environments for the SSAS cubes.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis and published the reports on the Power BI Services.
• Created different chart types and drill down reports (SSRS)
• Applied advanced analytics to large data sets as needed.
• Worked in data and database integration techniques, including data modeling and data normalization.
• Worked in data analysis and data warehousing for performance in Power BI.
• Knowledge and experience with full SDLC lifecycle.
• Worked in Agile teams and working independently with Business stakeholders providing solutions and regular updates.
• Built enterprise data models using Power BI desktop
• Worked with Microsoft Azure platform and Power BI Desktop
• Strong understanding of Power BI application security layer models.
• Created sustainable and scalable data models and datasets in Power BI
• Sourcing and converted the legacy reports during this Power BI Report Migration.
• Experience Power BI (Dashboards, Paginated Reports, Datasets and Dataflows, Power Query, DAX)
• Formulated the technical strategy for BI solutions, with a specific focus on Microsoft Power BI.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Develop custom calculated measures using DAX in Power BI to satisfy business needs.
• Performedarchivingand achieved automated processing of the raw data through the ETL process inSSIS.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Developed and maintained SSIS Packages to integrate with different resources like MySQL, Oracle, SQL Server, Teradata, Flat files.
• Performed several performance tunings using execution plan and SQL profiler to improve the performance.

Environment: Power BI, DAX, MS SQL Server 2016/2014/2012/2008 R2, SQL, Team Foundation, JIIRA, MS Excel, CSS, SSRS, SSIS

Confidential

ETL Developer

Responsibilities:

• Created ETL SSIS packages both design and code to process data to target databases.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Debugging and troubleshooting the technical issues while implementing the applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Packages for extracting data from Flat Files, Excel, MS Access, Oracle, and MS SQL Server.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing complex transformations using SSIS/DTS packages.
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages and updating and maintaining Visual Source Safe.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers, and scanners.
• Documented all the work and all the process of integration and reporting services for further references.
• Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

Environment: MS SQL Server 2012/20014, SSIS, SQL Query Analyzer, SQL profiler, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, Visual Studio 2005/2010, MS Access, Crystal Reports, MS Excel 2007.