| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Herndon, VA Street Address
PHONE NUMBER AVAILABLEEMAIL AVAILABLESUMMARY6+ years of experience as a PowerBI Developer adept at executing database projects and employing dialogue mapping to gather requirements. Proficient in deploying Oracle data modeling & collaborating with global teams. Skilled at creating a schema and implementing SSIS packages to deliver user-centric solutions and maximize customer satisfaction.Building and publishing PowerBI reports utilizing complex calculated fields, table calculations, filters, parametersExperience in using Tableau and PowerBI to generate various reportsExperienced in creating interactive dashboards and scorecards utilizing PowerBIHands-on experience in MS PowerBI Desktop and PowerBI serviceExpert in ETL(SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word, and Text Format DataExperience in using SSIS Import and Export Wizard, SSIS Designer, and other package execution utilities for performing the ETL operationsHands on Experience in SSIS Configuration, Logging, Procedural Error Handling, and Data Error HandlingExperience in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All and Slowly Changing DimensionExperience in creating various SSIS packages, troubleshooting errors, and creating alerts using Send Mail tasksCreated stored procedure for generating reports using SQL Server Reporting Services SSRS.Experience in designing reports using SQL Server Reporting Services, generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamic, filters, and charts in SSRSImplemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.Involved in complex data mapping, modeling data, and understanding business data relationshipsExpertise in generating reports using SQL Server Reporting Services, Crystal Reports, MS Excel spreadsheets, and Power pivotExpert in presenting multi-platform data visualization like pie/bar/graph charts and Dundas chartsExperience in implementing the Indexes such as clustered index, non-clustered index, covering index appropriately on data structure to achieve faster data retrievalExperience in writing Sub-queries, Joins, T-SQL queries to create database objects and simplify complex queries involving different tables, and create relationships between tables using the foreign key and primary keyExperience in Database/Data Mart Design, stored procedures, Triggers, Indexes, Data Cleansing/Data MiningExperience working with Agile and Waterfall methodologies in SDLCAble to work collaboratively, quickly understanding the system architect and business needs towards achieving goalsExcellent communication and management skills. Quick learner and excellent team player, ability to complete the task on timePROFESSIONAL SKILLS: Query Review Code Optimization Query Development Database Table Designing Database Table Coding Data Modelling Database Triggers Development Table Index Development Project Management Requirement Gathering SQL Programming & Scripting Languages: C, C++, Java, JavaScript, MS SQL Server2016,2014,2012,2008, MS-Access, Oracle, MySQL, DB2 Operating Systems: Mac-OS, LINUX, UNIX, Windows 10/8.1/8/7/XP, Windows Server 10/8.1/8/7/XP, Windows 2003/NT BI Programming language: T-SQL, PL/SQL, C, C++, .NET, VB.NET, HTML BI Tools: MSBI Stack (SSIS, SSRS), Microsoft Visio, SQL Server Management Studio GUI: DTS Import/Export, SQL Server Integration Services Reporting Tool: SQL Server Reporting Services (SSRS), MS Excel, PowerBI, Tableau Reporting Tool ETL Tool: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Informatica Version control tools: Visual Source Safe (VSS), Subversion (SVN), Team Foundation Server (TFS)WORK EXPERIENCE:Envista, Carmel, IN May 2022 to CurrentPowerBI DeveloperResponsibilities:Developed calculated columns and measures using DAX in PowerBIExpertise in data migration in Microsoft Dynamics 365, including data mapping, data extraction, data transformation, and data loadingExperience in working with different data sources, including databases, spreadsheets, and flat files, and migrating data into Dynamics 365Created SSIS packages to perform filtering operations and to import the data daily from the legacy data sources to SQL Server 2016Creating complex SQL scripts to transform legacy data in the staging area using SSIS packagesConfiguring SSIS packages for runtime parameters and configuring filesUsed SSIS for Extracting and Merging data from a different source to a single sourceScheduling Jobs to run SSIS Packages in the night feed to DSS for fresh day dataScripting using SSIS packages for data cleansing, encrypting, and decrypting sensitive informationCreated SSIS packages to automate different FTP files and emailing to different clientsDesigned, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services-2008.Created SSIS packages using various Transformation to generate underlying data for the report and to export the cleaned data from Excel, CSV, Flat file, and MS Access to the data warehouseCreated notifications and alerts, subscriptions to reports in the PowerBI serviceDeployed Reports to Report Manager and Troubleshooting for any errors during in executionDeveloped transact-SQL commands including complex queries, views, functions, stored procedures, cursors and triggers on SQL server 2008 R2/2008/2005/2000.Migrated DTS objects to SQL Server Integrated Services SSIS environment.Scheduled the Reports to run on a daily and weekly basis in Report Manager and email them to the directors and analyst to review in an Excel sheetResponsible for extracting, transforming and loading data from Multiple Sources to Data Warehouse using SSIS.Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.Created Sub-Report, Matrix Report Tablix Report Drill Down Report and Charts using SSRSDeployed and subscribe Reports using SSRS to generate all daily, weekly and monthly reportsDeveloped SSIS packages that can extract data from various sources and merge them into one only source for Power BI reportsDesigned a PowerBI Data model with multiple Facts and Dimension Tables based on the requirementDesigned and Implemented analytics solutions using PowerBI Dashboard and ReportsParticipated in testing during the UAT (QA Testing). Mentored and monitored team development and statusDrop and recreate Index on the DSS System while migrating dataBased on the business requirement written complex T-SQL queries to perform data and graph validation to make sure that the test results are matchedCreated trace in SQL Profiler and used Database engine tuning advisor for performance tuning on scripts and stores proceduresEnvironment: SQL Server 2014/2016, SQL Server Integration Services, PowerBI MS Excel 2016, MS Access 2016, Management Studio, SQL Profiler and SSRS.Verizon, Herndon, VA Mar 2021 to April 2022MSBI DeveloperResponsibilities:Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from the staging environment based on the requirement and pushed the required data to the UAT environmentCreated simple to complex Store Procedures to re-use all the complex queries that I wrote for the Enterprise Data Warehouse (EDW) in a specific format with the help of the given templateResponsible to create various Tables, Views and Functions based on the requirement specified by the EDW team and wrote complex Join statements for combining data from various Databases and tables in different relational model database servers such as Oracle and DB2Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or PowerBIInvolved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.Designed and implemented Stored Procedures and Triggers for automating tasks.Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizardInvolved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning WizardsCreated effective reports using visualizations such as Bar charts, Clustered Column Chart, Waterfall Chart, Gauges, Pie Charts, TreeMap, etc. in PowerBIInvolved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drill down Reports.Fine-tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, and Execution Plan and Index Tuning wizardHelped in Rebuilding the Indexes at regular intervals for better performanceGenerated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.Worked with a Congos team and helped to create complex weekly, quarterly and annual reports by writing code based on the requirement.Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.Produced operational reports in SSRS 2012/2008R2 i.e., Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reportsConverted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2Involved in configuring the report viewing security for various users at various levels using Report ManagerMaintained Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on requestDeveloped dashboards with PowerBI which display key KPIs for business analysis and decision makingImproved performance of SQL Queries using SQL Execution Plan and SQL ProfilerPublished reports on PowerBI services, shared dashboards utilizing within office 365Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing DimensionUsed SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databasesHelped in planning out the coding and offered different solutions in the initial planning of the projectEnvironment: -MS SQL Server 2012, 2008r2, SSIS, SSRS, T-SQL, SSMS Execution Plan, SQL Profiler, Log Shipping, Windows 2008 Server, and Erwin 8.0, MS-Office, MS Outlook Express, Linux, WindowsBOEING, Seattle, WA Feb 2018 to Mar 2021SQL DeveloperResponsibilities:Migrated SQL Server 2008 databases to SQL Server 2012 and upgraded SSIS PackagesUsed Performance Monitor and SQL Profiler for Monitoring memory, processor and SQL QueriesDeployed the created SSIS packages in Development and Testing environmentsUsed SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databasesImplemented various sets of loggings (Text log, SQL Server Log) for SSIS PackagesUsed various SSIS tasks such as Conditional Split, Derived column, data validation checks etc. during staging, before loading the data into various sourcesSuccessfully migrated SSIS packages from development to test and production environment using SSIS Configuration files and development wizardInstalled and configured and maintained PowerBI Report ServerCreated the PowerBI dashboard and generated reports using the SQL server tables as a source. Lock objects on the reportsCreated reports on PowerBI Desktop and published them on the PowerBI Report ServerInvolved in migration and conversion of Reports from SSRS 2008 to 2012Involved in developing Bar graphs, Pie charts and Report templates based on financial data.Developed Multi-dimensional objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).Building OLAP Cubes for analyzing claims data and business processCreating and Modifying T-SQL Stored Procedures/ Triggers for Validating Integrity.Rebuilding Indexes and Tables as part of the performance tuning exerciseCreated Database Objects-Tables, Views and functions and developed procedures for implementing application functionality at the database side for performance improvementEnvironment: MS SQL Server Management Studio 2012/2014, SQL Profiler, Index Tuning Wizard, MS SQL Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual Studio.EDUCATION:Bachelors from Kakatiya University |
