| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidatemayurichowdaryd@gmail.comCandidate's Name
PHONE NUMBER AVAILABLEProfessional SummarySenior BI Lead Developer with 12 years of experience in the IT Industry, having the primary focus on Database Design, Application, Development, Implementation, Testing and Deployment in the MS SQL Server Environment and MSBI Tools SSIS&SSRS (BIDS/SSDT), Power BI Strong understanding of Normalization/Denormalization and database design methodology. Well-versed in SQL Server 2016,2014,2012, 2008R2, 2005, 2000.Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs.Experienced in Installing, Upgrading and Configuring Microsoft SQL Server and Databases.Experience in Creating Tables, Views, Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T-SQL statements for various applications.Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins.Experience in coding the T-SQL using the Temp tables, Table variables by analysing the Business logics.Generated complex Transact SQL(T-SQL) queries, Sub queries, Correlated subqueries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring various Connection Managers using SSIS.Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.Involved in usage of various SSIS components such as For loop, For-each loop, Fuzzy lookup and hands on experience in Event Handlers, Error Handlers etc.Proficient in data exploration, analysis, and storytelling through Tableau to convey insights effectively to stakeholders.Skilled in optimizing Tableau performance and usability through dashboard design best practices and performance tuning.Strong understanding of data manipulation and preparation techniques to ensure data integrity and accuracy in Tableau visualizations.Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams to deliver impactful Tableau solutions.Experienced in creating master and child packages, Package Configurations and Logging Using SSIS.Excellent knowledge of using Variables and Expressions in packages of SSIS.Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS PackagesExcellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.Experience in different types of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports.Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS) 2008 R2/2012/2014Involved in handling Enterprise-wide reporting needs using SQL Reporting Services, Crystal Reports.Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modelling for FACT and Dimension Tables using SQL Server Analysis Services.Worked in dimensional modelling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables.SkillsLanguages: C, C++, T-SQL,VB.NETRDBMS: MS SQL Server 2014/2012/2008/2008 R2, 2005, 7.0, ORACLE, TERADATA, MS-AccessWeb Technologies: HTML,XMLProductivity Applications : MS Word, MS Excel, MS Access, MS FrontPage.SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSASData Modelling Tool: ERWIN, VisioOperating System: Windows 95/98/2000/XP/NT,MS Dos and UNIXReporting Tools: SSRS (SQL Server Reporting Services), Crystal ReportsTools: Microsoft Visual Studio 2014/2012/2008, MS Office, Teradata SQL Assistance, Oracle SQL DeveloperETL Tools: SSIS (SQL Server Integration Services), DTSBI Tools: Power BI (server, services), Google Data studio, TableauWork ExperienceTechnical BI LeadEssentra Dec 20 Till DateTechnologies : MS T-SQL, SSIS, SSRS, SSAS, Power BI Services, Power BI AppsCoordinated daily activity and flow of projects through multiple departments to verify on-time product delivery.Gather report requirements and determine the best solution to provide the results in Power BI reports to support organizations strategic decisions.Worked on DAX query to create calculated columns and calculated measures based on Requirements.API Design and Development and Testing and Quality AssuranceDeveloped Power BI dashboards, visualizations, and interfaces with SharePoint and SSRS to deliver meaningful and actionable insight.Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, Waterfall, and Project Management Methodologies.Published BI Reports in the required originations and made BI Dashboards available in web clients.Involved in creating data visualizations like Clustered Column Chart, Line Chart, Slicer, Gauge Visualization etc. with BI.Designed and developed Tableau dashboards and reports to visualize key performance metrics, trends, and KPIs, enabling stakeholders to make data-driven decisions.Conducted data analysis and exploration using Tableau to identify trends, patterns, and outliers in large datasets, providing actionable insights to business stakeholders.Optimized Tableau dashboards for performance and usability, including data source optimization, dashboard layout design, and filter and parameter optimization.Collaborated with business users to gather requirements and translate them into Tableau visualizations that meet business needs and objectives.Provided Tableau training and support to team members and business users, empowering them to self-serve and explore data independentlyUtilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.Developing visual reports, dashboards and KPI scorecards using Power BI desktopSharing of Power BI reports and managing workspaces in Power BI service.Involved in architecting, designing, and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schema and Snowflake Schema.Developed Stored Procedures, User Defined Functions, Views, Triggers, T-SQL Scripting for complex business logic.Extensively used Joins, correlated and uncorrelated subqueries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.Optimized the database by creating various clustered, non-clustered indexes and indexed views.Involved in creating, maintaining tables and Performance tuning of long running stored procedures and Queries.Developed customized reports, summarizing and presenting data in visually appealing format.Enhanced data integrity by applying meticulous attention to detail when reviewing and analysing data maintenance processes.Continuously assessed current reporting techniques and developed improvements to boost accuracy.Identified and reported variances between employee time sheets and employee transaction reports from the time management system.Sr. BI DeveloperHISCOX May 14 - Dec 20Technologies: SQL, MSBI, Power BI, Tableau, Google Data Studio (Looker)Understand Requirement and Source Databases like SQL server and Azure analysis servicesPerformed data changes suitable for better Modelling and visualizationsGenerated different reports and dashboards for data showing business of different line of business across different geographical locations for clientCreated different visualizations using Bars, Lines and Pies, Maps, Bubbles, Tree maps and Highlight, crosstabs etcProficient in data exploration, analysis, and storytelling through Tableau to convey insights effectively to stakeholders.Skilled in optimizing Tableau performance and usability through dashboard design best practices and performance tuning.Strong understanding of data manipulation and preparation techniques to ensure data integrity and accuracy in Tableau visualizations.Excellent communication and collaboration skills, with the ability to work effectively with cross-functional teams to deliver impactful Tableau solutions.Creating Weekly and Monthly, Quarterly, Yearly KPI and so many kinds of reports as per my business needs depending on the client requirementsEffective EAM implementation contributes to reduced operational costs, increased reliability, enhanced safety, and better decision-making for organizations that rely on physical assets to achieve their business goals.Implemented drill down and bookmarking options and parameters wherever requiredConstructing or ensuring appropriate Data Model before report development Involved in Data Modelling for Dashboard designScheduling the Reports Weekly and Monthly basis as per the Client RequirementsWorked on rewriting the Old Oracle Stored Procedures to T-SQL by deep understanding of the business logic.Worked on creating complex queries to pull up data from various tables using Loops and creating variables.Extracted large volumes of data from various data sources and loaded the data into target data destinations by performing different kinds of transformations using SQL Server Integration services (SSIS).Created SSIS/SSDT packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files, Oracle, Teradata Etc.,) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).Involved in migrating the data in between SQL Server, Oracle and Teradata.Worked in scripting Teradata load utilities (Fast load and Multi Load) and used to run through SSIS by using Execute Process taskScheduling the Jobs using the ESP Jobs scheduler in Mainframes.Extensively Worked on Migrating the DTS packages to SSIS(2008) and to SSDT(2014).Have deployed packages on different servers by using Project Deployment in SSIS 2012/2014 using Project and Package Parameters.Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.Created complex SSIS packages using proper Control and Data flow elements.Extensively worked on Variables and Complex Expressions in packages of SSISDocumented all the processes involved in maintaining the database and all the SSDT packages for future reference.Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.SQL BI DeveloperMAXOR Health Care Sept 12 - May 14Technologies: SQL, SSIS, SSRS, SSASWritten complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.Worked on creating complex queries to pull up data from various tables using Loops and creating variables.Developed Stored Procedures in SQL Server 2012/2014 and modified existing stored procedures as needed.Extensively designed the packages and data mapping using Data flow task, for each Loop Container, Execute SQL Task, File System task and Script Task in SSIS Designer.Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Flat Files, Excel and other OLEDB, ODBC data sources.Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).Involved in Analysing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS.Defined KPI's, Actions and Calculations in SSAS using MDX.Developed Query for generating Drill Down and Drill Through Reports in SSRS 2012 and 2008.Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databasesExperienced in writing Queries using SQL Server Analysis Services (SSAS).Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures and Partitions.Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.EducationCompleted Bachelors in Engineering Technology (B.Tech) from JNTU 2006 |
