Candidate Information Title Power Bi Data Management Target Location US-MD-Fort Washington	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

Professional Summary:Over 7+ years of in-depth experience in database Design, Modeling, development and maintenance of SQL Server 2019/2016/2014/2012/ 2008R2/2008 large scale databases.Experience in Data Warehousing and Business Intelligence applications design, development, and Maintenance of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).Proficient in relational database modeling (Conceptual, Logical and Physical Modeling) and normalization.Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and TriggersExperienced in Data Import, Data Analysis, Data Migration, Data Cleansing, Transformation, and IntegrationProficient in using Power BI data visualization tool to analyze and obtain insights from large datasets, creating visually compelling and actionable interactive reports and dashboards.In-depth knowledge of SQL queries and working with RDBMS like Oracle, SQL Server, and MySQL in Agile project methodology.Experienced working with ETL teams on Data Migration using SQL, SQL Azure, Azure Storage, Azure Data Factory, and SSIS.Familiar with Azure cloud services, including Azure SQL Database, Azure Cosmos DB, and Azure DevOps.Involved in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Treemaps, etc. using Power BI.Experience creating Filters, quick filters, table calculations, calculated measures, and parameters in Power BI.Have good experience in creating advanced chart types, visualizations, and complex calculations to prepare the data as per business needs through Power BI.Experience utilizing DAX functions like Aggregation, Counting, Logical, Information, Text, and date functions.Experience Working on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and an interactive dashboard helped the business get a good handle on the team's productivity.Migrate existing SSRS reports to Power BI and created different reports and dashboards using power BI. Ability and willingness to learn new technology and deliver results in a timely manner.Proficient in ServiceNow administration, including configuration, customization, and maintenance.A well-organized, goal-oriented, highly motivated effective team member.TOOLS AND TECHNOLOGYRDBMSSQL Server 2019/2017/2016/2014/AZURE,SnowflkaeLanguages\ToolsVisual Basic, PowerShell, C#, T-SQL, Java, Python,.Net.Modeling ToolsMS Visio, Erwin and Oracle SQL Server Data Modeler.VisualizationPower BI Desktop, Report Builder, SSRS, TableauAnalysis ToolsSQL Server Analysis Service (Tabular and Multi-Dimensional)Project SummaryClient: FedEx Corp, Memphis, TN Jan 2023- PresentRole: SQL / Power BI DeveloperResponsibilities:Experienced in Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows Involved in creating functional and technical specification documents after gathering requirements from business.Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.Developed and maintained web applications using .NET technologies, including ASP.NET Core and MVC, and utilized Entity Framework and NHibernate for efficient database interactions.Designed and implemented RESTful APIs for network management systems, improving automation and orchestration capabilities, and managed network configuration and inventory data using ORM tools.Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.Building Analysis Services reporting modelsDeveloped visual reports, dashboards, and KPI scorecards using Power BI desktopConnected to data sources, importing data, and transforming data for Business IntelligenceExcellent in analytical thinking for translating data into informative visuals and reportsAble to implement row-level security on data and understand application security layer models in Power BIProficient in making DAX queries in Power BI desktopExpertise in using advanced level calculations on the data setResponsible for design methodology and project documentationAble to develop tabular and multidimensional models that are compatible with warehouse standardsAdopted, developed, publishing, and scheduling Power BI reports as per the business requirementsAble to properly understand the business requirements and develop data models accordingly by taking care of the resourcesShould have knowledge and experience in prototyping, designing, and requirement analysisAble to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS) or API automation. I and Also, experienced in developing custom visuals for Power BI.Create SSIS packages to extract data from different sources.Responsible for developing, supporting, and maintenance for ETL (Extract, Transform, and Load) processes using SSIS increased performance by 15%Aggregate, Derived Column, and Data Conversion Transformations.Create indexes on tables; Trace out any table that required any indexes and determine the type of indexes on it.Place huge table/non-clustered index on separate file group to improve performance by 40%.Worked with more than 20Client/Business Analysts to define data requirements for reporting and data maintenance.Interacting with Business Analysts and Developers in identifying requirements, designing, and implementing Database Schema.Attend backlog grooming, sprint planning, retrospective meetings, and experience as a scrum master.Worked as team following Agile/SCRUM methodology for iterative and incremental development.Environment: MS SQL Server 2012/2014, SSIS, SSRS, Erwin, Excel, Windows Server, Flat Files, Team Foundation Server (TFS), Jira (Atlassian)Client: Acentra, McLean, VA Jun 2021 -Jan 2023Role: SQL/SSIS/SSRS DeveloperResponsibilities:Requirements gathering, Analysis and Design of all the client requirements.Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to SQL server.Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation etc. to migrate the old Bills information, Customer Information, Contracts Information and other important data.Used Crystal Reports to tracked logins, mouse overs, click-through, session durations and demographical comparisons with SQL database of customer information.Used SSIS to upload amortization schedules sent by the client in. CSV format on to the staging tables, which were used for doing all the calculation. Then the data was moved to the core tables and the staging tables were deleted.Designed, coded and implemented ad hoc reports using existing report models in SSRS.Identified the Data Source and defined them to build the Data Source Views.Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports.Managed Alerts for successful or unsuccessful completion of scheduled Jobs.Used Crystal Reports to track successful/unsuccessful sent emails, emails that were read, click-through and demographical comparisons with SQL database of customer information.Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.Involved in testing, bug fixing and documentation for the project.Generated test data and tested database to meet the functionalities deliverables in the project documentation and specificationsDeveloped incremental loading using MERGE statement in SQL server 2008R2.Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profilerUsed Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databasesEnvironment: Microsoft SQL Server 2016/2017, 2019 MS Sql integration Services 2016, SSRS 2008, SSAS, Microsoft Excel, C#, XML, ASP.NET, MS Office.Client: JP Morgan, Jersey City, NJ Feb 2016-Jun 2021Role: SQL/ETL Server Developer (SSRS, SSIS)Responsibilities:Designed a complex SSIS package for data transfer from three different firm sources to a single destination like SQL Server 2005.Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.Regular monitored of SQL server, analyzing the logs, troubleshooting SQL Server problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems.Administered the MS SQL Server security by enforcing security policy, creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.Implemented a DB maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space) and running, SQL Tracer and SQL Profiler.Enhanced performance by running index tuning wizard for creating, rebuilding and reorganizing indexes on various tables.Used Merge replication to update the publisher from the subscribers as well as from the subscriber to the publisher in periodically.Log shipping database for reporting server within the firms latency objective.Performed full, differential and transaction log backups.Created the SQL Server Integration Services (SSIS) and DTS Packages for executing the required tasks.Designed Extraction Transformation and Loading (ETL) process using SSIS to extract data from flat files, excel files and SQL server database.Used the SQL Server profiler to capture and store the execution plan.Provided weekly, monthly, yearly quality control reports for work orders, service requests.Represent reports in different forms using graphs, charts, tabular, area and pie charts as required.Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).Environment: MS SQL Server 2016/2017/2019, MS SQL Server 2017, 2019 Reporting Service, MS SQL Server Integration Services 2016, 2017,2019, BIDS, Erwin, T-SQL, Windows XP.