SUMMARY:

• Arround 6+ years of experience in Data Analysis, Design, Implementation, Administration and support of Business Intelligence using Power BI, SQL Server 2017/2016/2014/2012/2008 R2/2008, SSIS and SSRS.
• Good experience in Agile and SDLC methodologies.
• Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support.
• Expertise in writing complex DAX functions in Power BI.
• Developed Measures, Calculated Columns in Power BI Desktop to show data analysis techniques.
• Working knowledge in Agile/Scrum environments.
• Expert in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.
• Expertise gathering functional specification requirements for the development of dashboards and reports.
• Interactive Data Visualization products focused on Business Intelligence such as MICROSOFT POWER BI.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI.
• Designed different visualizations in Power BI according to the requirements.
• Expertise in developing various charts, matrix and complex designs.
• Expertise in writing transformation in M query and Power query.
• Designed data visualization to present current impact and growth.
• Expertise in VLOOKUP Formula development, pivot table generation and pivot reporting.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split in SQL Server Integration Services (SSIS).
• Excellent knowledge in creating Matrix Reports, List Reports, Chart Reports and Drill-Down Reports.
• Expert in creating ad-hoc reports by using Report Builder in SSRS.
• Created workspace and content packs for business users to view the developed reports.
• Proficient in using Quality center and JIRA.
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Exceptional team player with outstanding Communication Skills both written and verbal.
• Excellent Analytical, problem solving and interpersonal skills.
• Able to adapt to changing priorities and maintain a positive attitude and strong work ethic.
• Designed different visualizations in Power BI according to the requirements.
• Expertise in developing various charts, matrix and complex designs.
• Expertise in writing transformation in M query and Power query.
• Designed data visualization to present current impact and growth.
• Expertise in VLOOKUP Formula development, pivot table generation and pivot reporting.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split in SQL Server Integration Services (SSIS).
• Excellent knowledge in creating Matrix Reports, List Reports, Chart Reports and Drill-Down Reports.
• Expert in creating ad-hoc reports by using Report Builder in SSRS.
• Created workspace and content packs for business users to view the developed reports.

TECHNICAL SKILLS:

Operating Systems: Windows 10/ Windows 2007/Linux/ Windows Server 2019,2016,2012 /Windows Vista/ XP/ 2003/ 2000/ NT 4.0/ 9x, MS-DOS

Web Technologies: HTML, XML.

Databases: Microsoft SQL Server 2017, 2012/2008, MS-Access 97/2000/2003 , Oracle 9i/10g

Tools: /Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQLServer Profiler, Visual Studio .Net, Microsoft, Management Console, DTS, SSIS, Business Intelligence Development, Studio (BIDS), Crystal Reports 9.0, ETL,Database Design Tools MS Visio, Erwin.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Power BI

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

WORK EXPERIENCE:

Confidential, Norfolk, VA

Power BI/ SQL BI Developer

Responsibilities:

• Created Power BI Reports and effective Visualizations on Import Connection and published to Power BI Service.
• Worked on Power BI Dashboard to make some changes on behalf of Business requirements.
• Publish Power Bi reports to the Power BI service with client credentials, so it will be accessible to end
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Added data sources to Power BI Gateway and map users to the data source and created workspace in Power BI service after that add admins and members, so everyone can access those Power BI reports in Power BI Service and create dashboards.
• Integrated custom visuals based on business requirements using Power BI desktop.
• Created Measures and calculated columns using DAX Functions.
• Wrote calculated columns, Measures query’s in power BI to show good data analysis techniques.
• Create pivot tables and modify spreadsheets to achieve analytical goals.
• Scheduled Automatic refresh and scheduling refresh in power bi service. imported data from SQL Server DB to Power BI to generate reports.
• Created Dax Queries to generated computed columns in Power BI.
• Generated computed tables in Power BI by using Dax.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Responsible for creating a trace to identify and analyze the Poorly Performing Queries Identified by Profiler in SQL Server 2008 R2.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developing Cascading Reports for Analytics Reports, Ad-hoc Reports using Report Builder, SQL server Reporting Services (SSRS) 2008 R2
• Creating and deploying various Reports like Drill Down, Drill Through, Chart, Linked and Parameterized reports using SSRS
• Generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Performing Unit and Regression tests for Developed Reports and Deployed into the Server
• Created dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.

Environment: MS SQL server 2016/ 2014/2012 , BIDS, T-SQL, MS Server Integration services (SSIS) MS Server Analysis services (SSAS), MS Server Reporting services (SSRS),Power BI, Tableau.

Confidential, Dallas, TX

Power Bi Developer / SQL Developer

Responsibilities:

• Having experience in gathering requirements from Director’s and created the functional documentation using Confluence.
• I also have an experience in maintain the reports in power bi services and sharing with another team member’s in the organization.
• Creating row level security for the visuals and also had an experience in scheduling to refresh the data.
• I do have the experience in Power bi admin, like creating content packs, how many users are accessing the dashboard, how many users are using power bi Pro license.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Designed and developed Power BI dashboards, Reports and published it on Power BI sites.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.
• Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation.
• Published Power BI reports from Power BI desktop to Power BI service.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP .
• Modifying SSIS packages for business logic enhancements. Writing/modifying VB scripts for sales file moments and data loads.
• Involved in the continuous enhancements and fixing of production problems.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Migration experience with DTS.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Proficient in usage of SSIS Control Flow items (For Loop, executes package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server

Environment: s: MS SQL Server 2014/2012, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Power BI Desktop, Power Bi Service, Power Query, Power Piviot Studio, MS SQL Server Analysis Services (SSAS), T -SQL , Crystal Report,

Confidential

Power BI Developer

Responsibilities:

• Worked on data warehouse based on business requirements to provide quality information for publishing Power BI and SSRS Reports for the business executives.
• Worked across multiple functional projects to understand data usage and implications for data migration.
• Created Power BI Reports and effective Visualizations on Import Connection and published to Power BI Service.
• Worked on Power BI Dashboard to make some changes on behalf of Business requirements.
• Involved in application of the Star and Snow flake model to retain de-normalized data or to normalize the data for some relations in the schema.
• Publish Power Bi reports to the Power BI service with client credentials, so it will be accessible to end users.
• Added data sources to Power BI Gateway and map users to the data source and created workspace in Power BI service after that add admins and members, so everyone can access those Power BI reports in Power BI Service and create dashboards.
• Designed and Implemented the SSIS package to load the data from source to staging and Data warehouse.
• Created interactive tabular and matrix SSRS reports with Drill Down, Drill through, Cascade parameterized, Bookmarked and Sub-report functionalities.
• Flexible and versatile to adapt any new environment with a strong desire to keep pace with latest technologies and can work as an individual or as a team.
• Effective in working independently and collaboratively in teams and responsible for coordination between onsite and offshore teams in various projects.
• Involved in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
• Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources
• Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations
• Worked on Visuals from Marketplace like multi slicer and Hierarchy slicer.
• Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
• Created New Calculated Column and Measure using DAX Expression.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.
• Excellent in analytical thinking for translating data into informative visuals and reports.
• Expertise in using advance level calculations on the data set.
• Responsible for design methodology and project documentation.
• Developed, published and scheduled Power BI reports as per the business requirements.
• Integrated Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation

Confidential

SSIS/SSRS Developer

Responsibilities:

• Transformed data from MS SQL server2000 to MS SQL server2005 using OLE DB connection by creating various SSIS packages.
• Used the execute DTS package task to execute DTS packages.
• Designed, deployed, and maintained various SSRS Reports in SQL Server
• Created Sub-Reports, ad-hoc reports, Drilldown-Reports, Summary reports, and Cross Tab reports
• Actively participated in gathering Business Requirements that are focused on providing a user friendly System usage or ambience
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Created SSIS packages to download data from FTP sites and populating into different databases and tables.
• Created Drill down and drill through reports in SSRS.
• Expertise in scheduling reports to end-users and give acess to the report server.
• Created Subscriptions such as standard and data driven in Report Manager SSRS to generate email notifications.
• Developed and scheduled the cached reports in SSRS
• Created data transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Expert in developing SSIS2008 packages to Extract, Transform and Load (ETL)/DTS data into the Data Warehouse from heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Designed a new schema for the data mart databases.
• Designed, developed and deployed reports in MS SQL server environment using SSRS2008.
• Generated various reports like cascade type reports, tabular reports and drill down reports.
• Created different types of reports based on the complex T-SQL queries from the scratch like matrix.

Environment: MS SQL Server, SSRS, SSIS, Visual Studio 2005, MS SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, T-SQL.