Home

Praveen B - Sr SQL Developer

[email protected]

Location: Denton, Texas, USA

Relocation:

Visa: H1B

Resume file: Praveen B SQLBI Developer Updated resume_1757704286025.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Praveen B Sr SQL/BI Developer [email protected] +1 9405971347 Experience Summary: Around 10 years of experience working with Design, Development & Maintenance of various applications using most of the Microsoft suites like .Net Framework, SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), PowerBI, object-oriented programming Languages (C#). Experience building and maintaining stored procedures, user defined functions, SQL scripts, indexes, and dynamic SQL queries for data analysis and extraction. Experience in handling production support and ongoing developmental activities during the same time. Automated file mapping (v1 to v2); update integration logic and SDKs. Migrated Large number of files and folders from source to destination Mapping with file mapping, folder mapping and matching all details of the same with latest version of migration tools. Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER. Worked in the development and deployment of Power BI Reports. Developed interactive Power BI reports within Microsoft Fabric, enabling cross-functional teams to access real-time insights from a centralized semantic model. Good Experience with Django, a high - level Python Web framework. Specialist in building various kinds of reports like drill down reports, drill through reports using Microsoft SQL Server Reporting Services (SSRS). Knowledge in analyzing the existing code and optimizing, enhanced the existing procedures and SQL statements for better performance. Experience in creating SSIS mappings to extract, transform and load data from Oracle and SQL Server Sources onto the data warehouse. Experienced in running Pyspark with Azure Data Brick. Developed Complex p objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Created database objects like tables, users, roles, cursors, triggers using Oracle and SQL Server Databases Importing data from flat files/Excel sheets/XML files/Various Database Instances to SQL Server with SSIS. Worked on migrating the on-premises SQL server databases to Microsoft Azure Cloud database. Designed and implemented end-to-end data pipelines using Microsoft Fabric s unified platform, integrating Data Factory, and One Lake. Excellent programming skills and strong in Object Oriented programming (OOP) concepts. Strong Knowledge in End-to-End Software Development Life Cycle, Application Development Methodology (ADM) and Agile Methodologies, ER Diagram. Designed and developed scalable ADO.NET services for efficient data access and manipulation across enterprise applications. Strong working knowledge in Analysis, Design, Development and Implementation of multi-tier web-based applications and distributed applications using WCF/Web services Standards based on Service Oriented Architecture (SOA). Experience in analysis, design, coding, testing and maintenance of SQL Server, ASP.NET MVC, ADO.NET, Web APIs, .NET Web Services. Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables. Experience in analyzing complex COBOL Programs and developing SSIS Interfaces for Batch Process. Good Knowledge with Entity Framework, LINQ with Collection and SQL and UI skills like HTML, CSS, XML, XSLT, JavaScript, jQuery, and AJAX. Good Experience in configuring and managing Internet Information Services (IIS) - WEB Server. Skill Set: RDBMS SQL-SERVER, MS-ACCESS, Business Intelligence (BI), ORACLE,DBA ETL SSIS Reporting Tools SSRS, Power BI Programming Languages C#.NET, VB.NET, C, C++, T-SQL, PL/SQL, PYTHON, COBOL Operating Systems Windows, Mac, UNIX, .NET Technologies Duck Creek, .NET Framework, Web Forms, MVC, Win Forms, Web Services, WCF, WEB APIs, ASP.NET, ADO.NET, Entity Framework, LINQ, AJAX, WPF, SOAP. Web Technologies HTML, DHTML, XHTML, XML, XSLT, JSON, CSS, Java Script, VB Script, jQuery. Development Tools Visual Studio, MS Project, SQL Server Management Studio (SSMS), Team Foundation Server (TFS), GIT Visual Modeling and Design Tool Rational Software Modeler, Microsoft Visio. Middleware ADO.NET, Entity Framework, ORM. Web Servers Internet Information Server (IIS) Cloud Computing Microsoft Azure, Microsoft Fabric, Azure Data Factory Ticketing Systems JIRA, Azure Dev Ops, workday PROFESSIONAL EXPERIENCE: Client: Citizen Bank, TX Feb 2024 to Present Role: Senior SQL/BI Developer Participated in the process of defining business needs in conjunction with senior management, subject matter experts, and IT teams. Developed PL/SQL triggers and master tables for automatic creation of primary keys. Functional and nonfunctional requirements were derived from the business requirements that were transformed. Developed intricate stored processes in order to carry out a variety of duties, some of which include, but are not limited to, index maintenance, data profiling, metadata searches, and loading of the data management system. Designed, built, and tested the ETL approach in order to populate data from a number of different source systems. SSIS packages were implemented in order to carry out ETL data messaging procedures, which included data profiling, cleansing, and verification. Reading and writing data into Parquet les for Columnar storage by using Pyspark. The data mart was populated via checksum and timestamp approaches, and incremental loads were designed to meet the requirements. Created parameterized reports and Drill down reports using SSRS. Installing and Configuring PostgreSQL from source or packages on Linux machines. Implemented business logic in Python to prevent, detect and claim the duplicate payments. Master-child packages were developed in order to integrate data from many data sources into SQL server. These packages also had the ability to execute package tasks, which enabled modular programming. Package configurations were implemented on the development, test, and production environments by making use of parameters. Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. Having experience in establishing data mapping, performance tuning, and identifying bottlenecks of sources, mappings, targets, and sessions has been provided. Expertise in data modeling in the context of a data warehouse system, including familiarity with star schema and snow flake schema. KPIs and aggregation were added to SSAS cubes that were created for the front-end analysis team. Analysis services made use of a multi-dimensional and tabular model in order to pull and generate reports straight from in-memory from relational data sources located on the back end. Developed SSRS reports for purposes of doing in-depth business assessments. Expressions that were designed to calculate, group, filter, parameterize, and format the contents of the report. Using Tableau, score cards were generated along with executive summary dashboards in order to display performance monitoring measures. Reports were delivered on demand in a variety of rendering formats, offering both basic and data-driven subscriptions. Power BI graphical and visualization solutions were designed and built, together with business requirement documents and plans for the creation of interactive dashboards are included. Developed a number of analytical dashboards with the use of Power BI (Power View), which illustrates important key performance indicators (KPIs) such legal case matter, billing hours, and case proceedings. These dashboards also include slicers and dicers that allow end-users to set filters. Excel Power Pivot was used to generate ad hoc reports, and then Power BI was used to distribute those reports to decision makers for the purpose of strategic planning. Utilized Power Query within Power BI to pivot and un-pivot the data model in order to do data cleansing and data massaging. Created PL/SQL scripts to extract the data from the operational database into simple at text les using UTL_FILE package. Implemented a number of DAX functions for performing a variety of fact calculations in order to facilitate effective data display in Power BI. Dashboards and reports were kept up to date with on-premise data sources through the utilization of the Power BI gateway. Responsible for creating SSIS Packages to migrate data from LSP and HBMS to FIMMAS. Managed numerous versions of complex code within TFS and implemented code check-in and check-out procedures. Virtual machines (VMs) with SQL Server were provisioned in the cloud by employing Microsoft Azure, and connectivity was established with the assistance of endpoints. Implemented Redgate with Azure Data Factory in order to migrate an enterprise database to Microsoft Azure. Contributed to the development of a backup and recovery plan for databases that were hosted on a virtualization environment that utilized Microsoft Azure. Carry out exhaustive unit testing on all platforms that are pertinent in order to guarantee correct implementation. Developed MDX queries for analysis and designed the SSAS Cube environment. Managing modifications to the source code with the use of Team Foundation Server (TFS). Involving in designing test cases for Unit Testing. Environment: SQL Server 2012, T-SQL, SSMS, Excel, SSIS, SSAS, SSRS, SharePoint, Power BI, Tableau, TFS, DTA, SQL Profiler, MS Azure, Data Factory, Visual Studio, C#. Client: Accenture, India Sep 2021 June 2023 Role: Senior SQL/ BI Developer Responsible for the creation of Business Requirement Documents (BRD) as well as analytical documents for important compliance tests. Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus. Utilizing SSMS 2018, I was able to write complex SQL queries, user functions, stored procedures, CTEs, views, and indexes. Additionally, I was able to create templates and tables. Participated in the process of normalizing and de-normalizing existing tables in order to facilitate the retrieval of queries more quickly. Reading and writing data into JSON les for API out put reads by using Pyspark. Developed reports using SSRS that could be used to send information to dierent Primary Vendors, Clients, and managers. To extract massive quantities of data from various data points on Microsoft SQL Server and Teradata SQL Assistant, complex SQL queries were implemented utilizing DML and DDL instructions. Working on issues that are occurring on the live site to resolve stored procedures, triggers, and other issues that are causing slow running, as well as providing root cause analysis. Created Map Reduce programs in Python to reconcile the payment history and account payable files. Knowledge and experience in data analysis, including the ability to recognize patterns and trends in data. Through the development of SSIS (SQL Server Integration Services) packages, experience in extracting, transforming, and loading (ETL) data from Excel, flat files, and a variety of other data sources into Microsoft SQL Server. SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script job, and Send Mail task, among others, were utilized and utilized extensively. The implementation of error and failure management using event handlers, row redirects, and loggings was accomplished through the creation of SSIS packages. Developed SSIS packages in such a way that make it possible for them to be dynamically deployed into environments for development, testing, and production. Using SQL Server Analysis Services (SSAS), I was able to create and configure OLAP Cubes: Star Schema and Snow Flex Schema. Tableau and Power BI were utilized in the development of data visualizations and dashboards. Involved in SSAS storage and partitions, as well as aggregations, as well as the formulation of queries using MDX, Data Mining Models, and the development of reports using MDX and SQL. KPIs, Partitions, Perspectives, and Calculated Measures were all created, and DAX queries and roles were utilized. Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances. Utilized DAX in Power BI to create calculated columns and measures queries in order to demonstrate effective data analysis strategies. Reporting on key performance indicators and scorecards have been completed. Tableau and Power BI dashboards were designed to provide customers with a visual picture of MTD sales growth, visual statistics on injuries, dealer location map, and other relevant information. Installing and monitoring PostgreSQL database using the standard monitoring tools. Worked on a variety of Tableau visualization approaches, including scatter plots, histograms, and heat maps, among others. Developed a variety of tabular reports by utilizing the features of Power BI and enhancing them according to the requirements of the users. Designed many scorecards and dashboards with the help of Power BI in order to display information that was required by various departments as well as more senior management. completed the installation and configuration of the on-premises gateway in Power BI services. Microsoft Power BI services have both scheduled automatic refresh and scheduled refresh. Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database. maintained and developed bug fixes for both the existing and new Power BI Reports. Provided ongoing maintenance and development. Through the use of SharePoint Server, dashboards were published on an intranet site. conducted independent validation and approval of compliance tests in collaboration with a variety of stakeholders representing a variety of business divisions. Environment: MS SQL Server 2012/ 2014/ 2017 , Microsoft Management Studio, Microsoft Visual Studio, MS SQL Server Integration Services (SSIS) 2012/2008R2/2008, SQL Server Reporting Services (SSRS), Power BI, Tableau, TSQL Client: NIIT Technologies, India April 2018 Aug 2021 Role: SQL BI Developer Determined the potential for growth by analyzing the business practices and product performance of the company. Participates in the process of developing database objects such as tables, indexes, views, user-defined functions, and parameterized stored procedures. Developed a large number of stored processes for the purpose of cleaning, altering, and processing data between the databases. Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling. Acquired expertise in the strategic implementation of indexes, including clustered indexes, non-clustered indexes, and covering indexes on data structures, with the goal of achieving faster data retrieval. SQL queries were utilized extensively in order to facilitate the transformation of data into information that is useful for decision making. ManagingPostgreSQLproduction databases. Applying PostgreSQL patches and schema changes. Design and develop ETL processes in PL/SQL to pull data from multiple sources into a single database source for end user reporting purposes at Fannie Mae Corporation. SQL Servers were used to implement complex SQL queries, which included DML and DDL instructions, in order to extract enormous quantities of data from many data points. Through the use of the SSIS ETL tool, the data was extracted from the various sources (including CSV files, flat files, Excel files, and MS SQL files), and then it was put in the intermediate staging database. Created extremely complicated SSIS packages by utilizing a variety of data transformations, such as conditional splitting, lookup, for each loop, and error handling. Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python. Tableau report development recommended procedures have been defined. Tableau report development best practices were defined, and the data blending capability of Tableau was utilized in an efficient manner. Reading data from CSV les by using Pyspark parallel data processing and perform ETL operations and convert the Pyspark DataFrames into Pandas DataFrames. To integrate error and failure handling with row redirects, SSIS packages were created. SQL Analysis Services (SSAS) was used to develop Cubes, while Cube Wizard was used to develop Dimensions. Named calculations and named queries were executed and generated. Having experience in designing and building the dimensions, cubes with star schema, and snowflakes schema with SQL Server Analysis Services (SSAS) for the purpose of conduct analysis. Cubes allowed for the creation of partitions as well as the design of aggregations. Through participation in Cube Partitioning, Refresh strategy and planning, and Dimensional data modeling in Analysis Services (SSAS), I designed and deployed data models and reports in Power BI to assist clients in analyzing data in order to detect market trends, competition, and customer behavior. For the purpose of comparing the company's performance throughout the industry, we developed custom computed metrics using DAX in Power BI. Various visualizations, including a stacked bar chart, a clustered bar chart, a scatter chart, a pie chart, a donut chart, a line and clustered column chart, a map, a slicer, and a time brush, were created in Power BI in accordance with the requirements. Developed dashboards that included a variety of displays, such as bar charts, pie charts, scatter charts, bubble charts, and shape maps. Design, develop, and support PL/SQL ETL processes for loading data from external as well as internal systems using SQL Loader and External tables. In Power BI, page level filters, report level filters, and visual level filters were all created in accordance with the standards. Participated in the reporting of key performance indicators (KPI) and gauges for certain criteria in order to monitor who the closest competitors in the industry are. papers on market research that were comprehensive and included both qualitative and quantitative methodologies. Utilizing Power BI graphics, a SWOT analysis was performed on the financial data. According to the findings of the data-driven analysis, new services are recommended. Environment: MS SQL Server 2012/ 2014/ 2016 , Microsoft Management Studio, Microsoft Visual Studio, Power BI, Power Pivot, Tableau, DAX. Client ZOHO Corporation, India Aug 2015 Mar 2018 Role: .Net Developer Involved in maintenance and ongoing enhancements to application developed in .net Framework 4.0/3.5, ASP.NET, C#, Web services, WCF Service, JavaScript, XML, HTML, T-SQL. Developed day-to-day documents for reporting and developing the application. Designed & developed web user interface using ASP.net, C#, HTML, CSS, JavaScript, server controls, and developed customized Web controls. Used Team Foundation Server to keep track of new created SSIS packages, and to modify and update existing packages when it is necessary. Reading and writing data into XML les by using Pyspark. Created Business Logic using Python to create Planning and Tracking functions. Create PL/SQL packages, stand alone procedures, and stand alone functions. Maintained state of the Webpages by using View State and Session Memory objects. Worked on exposing web services using WCF architecture for the client to communicate and exchange data and involved design of WCF based Service. Involved in debugging, analyzing critical application issues by looking at the logs and other connectivity. Implemented Service Oriented Architecture (SOA) and used WCF to expose business logic as services and consumed those services from client applications. Defined service contracts implemented service contracts and hosted in IIS 6.0. All service (contracts) configured with secured bindings. Involved in giving NON-Prod Support for 24 hours by analyzing the issues and resolving. Took responsibility of troubleshooting by starting and stopping the engines and services of the application whenever required on support. Worked in Agile development environment and participated in meetings and discussions with department heads, project managers, architects and co developers. Worked on writing stored procedures and queries in Oracle PL/SQL and SQL Server. Created database objects like tables, views, users, roles, triggers, and cursors. Wrote stored procedures to automatically create tables depending on their existence in the database. Environment: Microsoft .NET 4.0, ASP.NET, C#, Visual Studio, SQL Server 2008, Oracle PL/SQL, SQL Server Management Studio, Team Foundation Server (TFS), XML, WCF, IIS, HTML, CSS, JavaScript. Keywords: cprogramm cplusplus csharp user interface business intelligence active directory information technology microsoft procedural language Colorado Delaware Texas