Home

Vardhan - PL/SQL Developer

[email protected]

Location: Piscataway, New Jersey, USA

Relocation: Yes

Visa: H1

Mahendra E-Mail: [email protected] Contact: +1 754-240-5253 Professional Summary: 7 Yearsof experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server 2017/2016/2014/2012/2000 DTS/SQL Server Integration, Reporting & AnalysisServices. Extensive SQL Development experience in Banking, Infrastructure and Telecommunication industries with a strong understanding of data & analytics. Handson experience in installation, configuration, performance tuning, optimization, backup, and recovery in SQL server. Designed and developed web application using Angular, ASP.NET MVC and Entity Framework. Improved the performance of an ASP.NET MVC application by taking advantage of the output cache. Experience in ASP.NET MVC and C# development. Migrate a classic asp project to asp.net application also migrate windows applications to web applications. Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python. Experience in ASP.NET MVC and C# development. Experience in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules. Extensive knowledge of Normalization and Relational Database Management Systems. Good understanding of database and data warehousing concepts (OLTP & OLAP). Hands on experience on various SQL Server Services like Integration Services (SSIS), and Reporting Services (SSRS). Proficient in Creating SQL Server Analysis Services SSAS representing aggregations in several ways - hierarchically and using custom groupings that the company will use to analyze performance. Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming, and problem-solving skills. Experience in migrating packages, reports, and analysis services projects from SQL server 2012 to SQL server 2016. Worked on analyzing Hadoop cluster and different big data analytics tools. Highly proficient in using T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins, and query writing. Used Spark SQL to load JSON data, create schema RDD, and handle structured data using Spark SQL. Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services. Data Loading Experience in SQL Server using SSIS ETL and Experience in developing packages in SSIS and DTS according to task. Knowledge of scripting languages, Python and Java. Object oriented programming in Python C/C SQL Unix/Linux/Mac/Windows Perl Shell scripting. Experience with logical and physical data modeling and database design using Erwin. Expert in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS). Highly motivated and a self-starter with effective communication and organizational skills, combined with attention to detail and business process improvements. TECHNICAL SKILLS: SQL Developer Tools SQL Developer, SQL plus, Toad Reporting Tools MS SQL Server Reporting Services (SSRS), Business Object Crystal Reports, Excel PowerPivot Data Modelling Erwin, MS Visio, MS Access Languages PL/SQL, T-SQL, C, C++, C#, Visual Basic, HTML5, Shell Script, CSS3, AJAX, I Frames, UML, UNIX Servers Apache Server, Windows IIS Server Methodologies Agile project Management Other Tools Visual Studio, WinSCP, Putty Cloud Technologies AWS, Microsoft Azure Databases SQL Server, Oracle, DB2, MySQL, Mongo DB Operating System Windows Family, UNIX, Mac PROFESSIONAL EXPERIENCE Genworth, Somerset NJ NOV 2022 to Till Date Oracle PL SQLDeveloper Responsibilities: Participated in analysis, design, coding, testing, implementation, and documentation of the development or the change requests. Involved in working with troubleshooting the stored procedures, functions, views, triggers, and parts to increase the performance tuning. Created PL/SQL stored procedures, functions, and packages for generating reports in required format. Wrote several SQL Scripts such as finding tables that have Identity Columns and finding tables that do not have primary keys. Knowledge of scripting languages, Python and Java. Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python. Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MySQL dB package to retrieve information. Experienced in developing web-based applications using Python, Django, Java, C++, XML, CSS, HTML, DHTML, JavaScript and jQuery. Developed and performed data modeling studies, and supported data selection, extraction, and cleansing of mediation applications. Developed SSIS ETL packages to meet data flow needs. Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases. Designed and developed web application using Angular, ASP.NET MVC and Entity Framework. Automated the SSIS jobs in SQL scheduler as SQL server agent jobs for daily, weekly, and monthly loads. Used TOAD, PL/SQL developer tools for faster application design and development. Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS. Extensively involved in replication and implemented Snapshot, Merge, and Transactional Replications. Monitoring of all daily scheduled processes and activities using PL/SQL queries, procedures, functions, and scripts daily to ensure smooth operations. Developed SSIS ETL Packages to meet data flow needs and build a platform with the use of SSIS. Involved in designing and publishing visually rich and intuitive Power BI dashboards. Executed SQLs using spark-shell by assigning desired executors, cores, and memory. Created shell scripts for data validation and database comparison. Published Power BI Desktop reports created in Report view to the Power BI service. Managed source code, keeping track of project deliverability such as defects, requirements, tasks, and versioning control with the use of Team Foundation Server. Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance. Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2012 R2 for further Data Analysis and Reporting by using multiple transformations, scheduled, and maintained nightly and weekly loads of data by creating the corresponding job tasks. Enhanced performance of databases using optimization techniques-normalization, indexing, and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts, and processes. Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc. Environment: MS SQL Server 2012 R2, ASP.NET, MS Access, SSIS, SSRS, Query Analyzer, Erwin, DTS, BCP, SQL Profiler, TFS, Power BI, Shell Script, UNIX. Next Era Energy Dec2020 to June 2022 DB2/SQLDeveloper Responsibilities Worked with Technical Architects and Database analysts for the Design of tables for efficient Report Design. Developed the SQL Server Integration Services (SSIS) packages to transform data as well as created interface stored procedures used in SSIS to load/transform data to the Database. Extracted the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data in the intermediate Staging Database using the SSIS ETL tool. Created Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights. Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MySQL dB package to retrieve information. Implemented business logic in Python to prevent, detect and claim duplicate payments. Wrote scripts to integrate APIs with third party applications. Python based web application, PostgreSQL, and integrations with third party email, messaging, storage services. Improved the performance of an ASP.NET MVC application by taking advantage of the output cache. Transform the data from the staging database and perform the transformation using the Data Flow Tasks. Designed and created data extracts, supporting SSRS, Power BI, Tableau, or other visualization tools reporting applications. Worked in developing OBIEE Repository. rpd at three layers Physical Layer, Business Model Presentation Layer. Generated reports from the cubes by connecting to Analysis server from SSRS. Developed various reports using SSRS, which included writing complex stored procedures for datasets. Involved in Report Authoring, Report Delivery (using both Pull and Push strategies), and Report Management for various types of reports. Prepared the reports for the day-to-day as well as weekly/monthly purposes in multiple formats like MS Excel, PDF, HTML, and XML etc. Wrote scripts to integrate APIs with third party applications. Python based web application, PostgreSQL, and integrations with third party email, messaging, storage services. Migrate a classic asp project to asp.net application, also migrate windows applications to web applications. Worked on POC to migrate existing on-premises BI platform to Azure Cloud. Worked on Azure cloud in spinning of new resources under resource group. Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables. Built cubes for a production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front-end applications using SSAS 2012/2016. Extensively involved in the SSAS storage and partitions, Aggregations, calculation of queries with MDX, Data Mining Models, and developing reports using MDX and SQL. Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, Documentation, and implementation. Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MySQL dB package to retrieve information. Using Kafka streamed the data using the Apache storm from source to Hadoop. Fetch the data from Oracle 10g by creating a linked server and using SQL Server to query the Oracle database. Expertise in writing complex DAX functions in Power BI and Power Pivot. Experience developing and Extending OLAP Cubes, Dimensions, and data source view. Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup, and management of linked servers to Non-SQL-Server databases. Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS. Environment: SQL Server 2016/2014/2012,ASP.NET, SQL Server Management Studio (SSMS), Tableau 9.7, .Net, Business Intelligence Studio (SSAS, SSIS, SSRS), OBIEE, T-SQL, Power BI, Erwin, MDX, Oracle 10g, MS Excel, MS Office. Ibase IT - India Jan 2017 to Nov 2020 ETL developer/MSBI Responsibilities Involved in ETL, data profiling, data quality and clean ups for SSIS packages. Migrated Packages from DTS to SSIS. Developed C# scripting for SSIS packages. Designing Logical and Physical Data Model with Erwin tools. Worked with installing, designing, and managing MS SQL Server. Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity. Created SSIS packages to populate data from various data sources. Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python. Knowledge of scripting languages, Python and Java. Object oriented programming in Python C/C SQL Unix/Linux/Mac/Windows Perl Shell scripting. Experienced in developing web-based applications using Python, Django, Java, C++, XML, CSS, HTML, DHTML, JavaScript and jQuery. Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server. Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer. Running DBCC consistency checks and fixing data corruption in application databases. Configured SSIS packages using package configuration wizard to allow packages to run on different environments. Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart. Migrated SSIS Packages from SQL Server 20012 to SQL Server 2016. Implemented business logic in Python to prevent, detect and claim duplicate payments. Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries. Deployed reports created report schedules and subscriptions. Managing and securing reports using SSRS. Built ad-hoc reports using SQL Server Reporting Services (SSRS). Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS). Involved in fine Tuning and Performance and Query optimization of the Database as required by the application. Environment: MS SQL Server 2016/2014,ASP.NET, Team Foundation Server, Microsoft SharePoint Server (MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio, Windows XP, T-SQL, VB.Net Keywords: cprogramm cplusplus csharp business intelligence database active directory information technology microsoft procedural language New Jersey