Sr. Power Bi And Data Specialist Resume
SUMMARY
- 10+ years of experience with Database Design, Development and Business Intelligence of Microsoft SQL Server 2019/2017/2016/2014/2012 in Development, Test and Production Environments.
- Complete understanding of Software Development Lifecycle and core area of experience in validating end - to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in SSIS/SSRS.
- Good exposure to entire Software Life Cycle Phases (Analysis, Design, Implementation, Testing, Deployment and Maintenance/Support).
- Extensive proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAPcubes,Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS,Data Cleansing, MSSQL Databases, Analysis Services (SSAS) and Reporting Services (SSRS)
- Experience in working with Dynamics 365 to update/create/ new calculated data fields in SQL and push them back to the server using SSIS, KingsWaySoft/Scribe and TSQL.
- Experience in enhancing and deploying the SSIS Packages from development server to production server. Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS). Experience in Creation and deployment of cubes on SSAS.
- Read data from multiple sources like CSV/SQL Server 2016/AZURE SQL DB through Power BI for creating Dashboards/ Reports.
- Strong experience in Power BI 2.5x/2.7x designed developed and published multiple innovative visualization report and dashboard in MS SQL Server/Azure cloud environment.
- Created new SSRS reports and handled upgrades from on-prem systems to Online, using various data sources like Microsoft SQL Server, Microsoft Azure SQL Database, Microsoft SharePoint List, Dynamics 365 Fetch-XML, OLE DB, ODBC and XML
- Experience in providing full life cycle development for SharePoint sites and applications
- Map source system data elements to target system and develop, test, and support extraction, transformation, load processes, data profiling, data quality and clean ups for SSIS packages.
- Re-implemented client reports using Power BI, with API connections from various different sources including dynamics 365 APIs, SharePoint and ODBC data sources (including SQL Server, Azure SQL database and flat-files).
- Expert ETL design, Expertise in migrating data from MS-Access, MS-EXCEL, Flat-File, MySQL, SQL Server backup and other external data sources.
- Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
- Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
- Applied Power BI in a variety of different ways - from basic aggregation and report generation accessible through a web-page to reading server logs and sending alerts in case of any errors or outages.
- Integration Services (DTS/SSIS)
- Extensive knowledge in ETL Process & Progressive knowledge in using DTS/SSIS utilities.
- Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTSSSIS, and BCP & Bulk Insert utilities.
- Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
- Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
- Involved in migration of DTS Packages (2000) to SSIS (2005/2008R2/2012/2014) and troubleshoot migration issues. Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
TECHNICAL SKILLS
Databases Tools: Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), MySQL Workbench
ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Scribe Insights 7.8, 7.9, 7.9.5, SQL Server Migration Assistant
Reporting Tools: SQL Server Reporting Services (2008 R2,2012,2014), MS Access, MS Excel, Tableau.
Database: MS SQL Server 2017/2014/2012/2008/2005/2000 , MS Access, Oracle 11g/12c
Programming: T-SQL, PL-SQL, C, C#, PowerShell
Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL.
Operating Systems: Windows (95/98/2000), Windows 2003/2008/2012 Server, Windows XP, Windows Vista.
Other Tools: SharePoint, MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Team foundation Server, GIT, MS Team Foundation Services, Azure DevOps
PROFESSIONAL EXPERIENCE
Confidential
Sr. Power BI and Data Specialist
Responsibilities:
- Actively involved in the Analysis phase of the business requirement and reports/dashboards design.
- Coordinated with business users at various levels and call meetings during the different phases of projects to deliver successfully.
- Act as the primary data resource for post-implementation projects.
- Involved in ETL processes and develop source-to-target data mappings
- Coordinated with ETL team on data transformations using SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse and developed SSAS tabular model to use for Power BI
- Analyzed source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified.
- Read data from multiple sources like CSV/SQL Server 2016/AZURE SQL DB through Power BI for creating Dashboards/ Reports.
- Generated context filters and data source filters while handling large volume of data.
- Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
- Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
- Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
- Created and customized simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
- Created various views using Power BI (Tree maps, Scatter plot).
- Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
- Created multiple data model and used as a common data source for the reporting purpose.
- Used Power BI Gateways to keep the dashboards and reports up to date.
- Had refreshed/republished reports and data set manually.
- Improved performance by identifying the bottlenecks in Source table, recommended for creating index.
- Performed data validation, data profiling, data auditing and data cleansing activities to ensure high quality report deliveries.
- Analyzed reporting requirements and developed various Dashboards, using trend lines and reference lines.
- Performed Data profiling and analysis using complex SQL, data sitting into target tables.
- Performed detailed data investigation and analysis of known data quality issues in related databases through SQL
- Perform analysis for new data coming into CRM from external systems, using different data sources including databases and flat files.
- Perform analysis on incoming data and advise the clients on the best course of action for migrations and assimilations from incoming systems.
- Make necessary changes to accommodate the incoming data in a solution.
- Coordinate with the client over daily and weekly calls and take notes to ensure the project is headed in the right direction
- Build complex flows as parts of projects as per client specifications.
- Designed data mapping documents and detail design documents for ETL Flow.
- Design and developed the Customized Forms, Workflows, Site Pages and Site Collections on SharePoint 2013 (On - Prem and SharePoint Online)
- Presenting Reports at different platforms such as SharePoint, web or incorporating any platform independent designed page.
- Currently engaged to USDA support services in SharePoint and Data Analyst (Reports on Power BI), SharePoint Training, delivering to Team and Releases on time in an efficient manner.
- Migrate documents to SharePoint Online from SharePoint 2013 and SharePoint 2016.
- Build Flows to create a structure when a folder is created in SharePoint Online.
- Create SharePoint Web Apps and site collections based on client specifications
- Write PowerShell script for deployments.
- Upgrade SSRS reports to work with sources modified so that it works with the latest versions of CRM.
- Create Power BI reports and make them available to dashboards.
- Provide Level 2 support for over 140 clients.
- Implement data fixes and take backups as per request.
- Monitor and manage all the data being loaded through Scribe to all the Environments on a daily basis.
- Build and maintain flows as a part of the support queue.
- Build and maintain Power BI reports to track internal load times and
- Schedule calls with clients and coordinate with IT teams to deliver fixes.
- Create Application Registrations to be able to connect to the client through XRM Toolbox and other API based connection tools.
- Build and deploy SQL and Fetch XML based reports.
- Performed back-up and restore of the SQL database from the development environment to sync with the local environment
Environment: Microsoft Power BI 2.7x, SSIS, SQL Server 2016, Power BI Service, Power BI Gateway, Power BI Report Server, SQL Server 2014, MySQL, AZURE SQL DB, Advance Excel, SQL, T-SQL, SSIS.
Confidential
Power BI Developer/Data Engineer
Responsibilities:
- Developed optimized stored procedures, MS-SQL queries, User Defined Functions (UDF), Cursors, Views and
- Triggers, SQL Joins and other statements for reporting Application, maintained referential integrity and implemented complex logic
- Designed and created Report templates, Bar graphs and Pie charts based on the financial data.
- Dealt with huge amount of data and used SSAS in order to retrieve the data
- Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2014
- Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
- Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
- Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
- Gather requirements from business user and modify the stored procedures, codes to provide functionality as required.
- Perform including filters to the reports and make it parameter-driven. Perform including SQL Agent jobs to update source of data by use of SSIS package.
- Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL). Deploying the reports to staging server prior to business user acceptance testing.
- Perform including security to the reports and data in the application.
- Implement updates of reports in application to recognize same-day data updates/changes.
- Created data driven subscriptions for different users using Report Manager.
- Proficient with Dynamic HTML, XML, CSS, for building a dynamic flexible and highly interactive Real-Time User Interface.
- Validated information by creating several complex SQL queries, performing back-end testing, and determining data quality issues.
- Developed complex SQL queries while utilizing advanced SQL concepts, such as aggregate functions.
- Utilized Joins, sub-queries and explain, stats, cast and volatile tables on SQL server to write queries.
- Produced filters, quick filters, table calculations, and various views (Tree maps, Heat Maps, Scatter plot) in Tableau. Performed ad-hoc reporting analysis and manipulated complex data on MS SQL server.
- Revised coding to SAS and Python application upgrades and extensions.
- Analyze client needs and implement the required modules and features.
- Communicated with clients for requirement confirmation and technical advice and defined and documented business requirements for the SharePoint solution.
- Created views and database triggers, stored procedures and functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables.
- Examined and reduced errors in data to present inter-departmental communication and monthly reports.
- Resolved business problems while applying statistical techniques such as regression, cluster analysis, factor analysis, time series forecasting, experimental and design.
- Contributed in extraction, transformation, and loading of data from various source systems, such as flat files, Excel, Oracle and SQL Server
- Writing technical deployment and training documents.
- Setup migration environments for on-premises data transfers, including SQL Server 2017 installation, Visual Studio 2019 and KingswaySoft data integration solution.
- Create transformations and mappings to import data into CRM.
- Performed testing and debugging for the User Acceptance Testing (UAT) phase.
- Implement fixes as necessary and push the final load to PROD
Environment: MS SQL Server-2017/2014, Enterprise Edition, SSIS, SSRS, T-SQL, CRM, Performance Point Sever, Office, MS Excel, BI Development Studio 2017/2015/2014/2012/2008 , SQL Data tools 2015.
Confidential
Technical Support Specialist
Responsibilities:
- Extensively used ETL Components to Extract Data from Different Sources
- Design and development of SSIS packages to fetch data from different data sources
- Creation of reports using prompts/ combined queries, report level filters.
- Working on Test cases of SSIS Packages and Data cleansing
- Developed C#, VB.Net scripts as part of ETL coding
- Development of UNIT test cases and prepared technical specifications for SSIS packages
- Creation of source Queries at Analysis and Designing phase
- Preparation of mapping documents and technical design documents based on client requirement specifications
- Creating merged dimensions at report level by using multiple data providers
- Testing of reports for data validation at different levels and preparation of Test results document
- Universe and Reports Migration from Dev to UAT to Prod
- Worked in performance tuning and deployment phase
- Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
- Developed different type of reports by using SSRS and SQL Server 2008/2014
- Provide first line of support to over 80 clients, keeping up with strict SLAs.
- Escalate tickets to Dev or Data team and coordinate fixes in the best possible timeframe.
- Review client documentation and ensure they are up-to-date based on changes made to them during the support process.
- Customize and Configure CRM based on client requirements.
- Update licenses and ensure all services are up and running.
- Monitor daily processes and loads and route the issue to the relevant resource.
- Create SharePoint site collection file repository for new implementations.
- Troubleshoot reports using Visual Studio 2008 and SSDT
- Worked on Active Directory Federation Services (ADFS) in UI and interfaced through PowerShell to create/bulk create users and OUs.
- Created workflows in the CRM workflow engine to perform rudimentary tasks, like sending notifications and assigning tasks.
Environment: Windows server 2008/2010/2012 , MS SQL Server- 2017/ 2014/2012/2010/2008 Enterprise Edition, SSIS, SSRS, T-SQL, UNICA, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office- 2010/2012/2016 , MS ExcelInt
Confidential
SQL DBA/Developer
Responsibilities:
- Install, configure and deploy MS SQL Server. Perform capacity planning, performance turning, monitoring, troubleshooting and optimization of the databases.
- Establishes and builds strong working relations and partnerships with Business Units and Senior Management.
- Perform SQL administrative tasks including installing and upgrading SQL server products, creating maintenance plans, and creating database objects.
- Provides database assistance and problem support to application developers, business analysts and business users.
- Provides technical assistance and mentoring for staff for developing conceptual and logical database design and the physical database.
- Help developers improve the performance of that query by tweaking it or modifying indexes.
- Standardize and manage Database Administrator procedures for monitoring database performance, testing, archiving, and optimizing.
- Implemented Bash, PowerShell scripting to automate day to day job tasks.
- Hands-On Replication set-up and troubleshooting.
- Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
- Experienced in creating SSIS packages using proper control and data flow elements.
- Export and import data from source like flat files, row files using DTS, SQL Server Integration Services.
- Installed and configured The SQL Server Reporting Services (SSRS) and maintenance of the Reporting Servers.
- Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to import data from other sources to SQL databases.
- Excellent knowledge and hands on experience in Migrations from on-premise to Azure IAAS and PAAS servers
- Having very good knowledge on Pricing models of DTU/eDTU vs Vcore Model
- Having good expertise into Geo-Replication, Availability Group(s) and Data Sync
- Implemented Data Partitioning, Purging and Archiving solutions in the Azure model databases
- Having very good knowledge on saving the cost on Azure models
- Provided database administration support on production and development servers
- Migrated Databases between servers
- Created and managed database objects, store procedures, triggers, views and functions
- Created and monitored automated scheduling Jobs and Alerting using SQL Server Agent
- Scheduled jobs for backups and set notifications for job failures and disk issues
- Created new SQL Server Instance, Installation configuration, Managing server and security, move or copy database to multiple location
- Evaluated database performance and maintenance duties such as tuning, backup and disaster recovery
- Followed proper backup retention policy, keep copy of databases backup in remote location in case of disaster
- Implemented Database Maintenance Plan for Database Integrity checks, Reorganize and Rebuild Index and update statistics
Environment: Windows server 2008, MS SQL Server- 2014/2012/2010/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office-2010, MS Excel, C#.NET, Teradata SQL Assistant 14.10, JEdit 5.0, Putty 0.60.0.0, Business Intelligence Development Studio 2014/2012/2008.
Confidential
Data Analyst
Responsibilities:
- MS SQL Database, SSIS for ETL and SSRS as a reporting tool to understand the current trend of public health. The data received from almost 50 clinics and two major hospitals.
- Created custom c# application to parse the data and store it for analysis.
- Consulted with managers and end users to create requirement documentations.
- Creating data blending in case of merging two different datasets usingTableau and created Datasets in T-SQL, stored procedures for SSRS.
- Created SQL scripts for Loading the Aggregate tables and rollup dimensions and created package for automated Loading of Historical and Ongoing Data into aggregates.
- Fix and clean incorrect/missing information
- Respond to internal tickets assisting front end admins
- Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and involved in the creation, maintenance of Data Warehouse and repositories.
- Assist with System upgrade from Oracle 10g to Oracle 11g.
- Database design and maintaining it by using SQL objects likeStored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
- Created partitions, indexes and Aggregate tables where necessary.
- Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation and created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
- Developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
- Upgrade the front end application at the terminals match with the updated database infrastructure.
- Coordinate roll out plans with various different teams.
Confidential
Data Entry/Modeling Assistant
Responsibilities:
- Collect different instances of TEMS data with cell strengths captured.
- Engaged with Business users Involved in gathering the related Business Requirements and documented the performance of the system by understanding the existing Data Model.
- Use spreadsheets to enter and document bad cell site data.
- Mapped the Business Requirements and New Databases to the Logical Data Model which defines the project delivery needs.
- Analyze signal strengths and call drop rates and prepare extensive reports.
- Generated DDL statements and scripts from Physical Data Model to create objects like table, views, indexes, stored procedures and packages.
- Designed Fact tables, Dimension and aggregate tables for Data warehouse and worked on the conversion process of Data which is stored in flat files into Oracle tables.
- Assist with the planning and execution of site upgrades or expansion plans as per the reports.
- Travel to the sites with Technicians if needed and isolate the root cause.
- Chart a plan to collect and re-chart the data once the fixes have been implemented.