P Varush
SQL Developer
Ph: 805-***-**** Email_id: ****************@*****.***
Summary:
Over all 1+ Year of experience on SQL Server.
Had a good experience on SSIS/SSRS.
Good hands-on working experience with using all kinds of SQL Server Constraints Primary Keys, Foreign Keys, Defaults, Checks, and Unique, Writing Transact SQL T-SQL Queries, Dynamic-queries.
I also worked on Power BI Desktop for creating reports. I have used all types of KPI's in my reports.
Implemented Power bi gateway difference source to matching analysis criteria and further modeling for power pivot and power view.
Excellent report creation skills using Microsoft Reporting Services SSRS.
Highly experienced in Sub queries, CTE's, joins involving multiple tables.
Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
Extensive experience in different type of reports including: Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports.
Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
Solid understanding of RDBMS database concepts and Experience in writing complex stored procedures, functions, Indexed views and triggers for data consistency and manipulation.
Experience with SQL Server and T-SQL in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
Educational Details
MS Software Engineering from Vellore Institute of Technology in 2019.
Technical Skills
Programming Languages : C, C++, Basic knowledge on Java, SQLplus, Oracle.
Web-Design : HTML, CSS, Java Script, PHP.
Testing : Junit Testing, Performance Testing, Rational rose, Eclipse.
Software’s : Visual Studio, Rational Rose.
Experience
Working with Abhra Inc as a SQL Server SSIS/SSRS Developer.
DigitoHub as a SQL Data Base Developer.
Projects:
Project # 2
Project Title : FARM (Flexible Agile Resource Model) 2020 Feb to Till
Client Side : Javascript, Jquery, Boostrap, Ajax, Forms
Role : SQL Server SSIS and SSRS Developer
Backend : SQL
Description:
FARM is an HR application. This application has 5 phases Admin, Partners, Requirement, Capacity and users. These phases are useful to post the clients requirements and their capacities. Partner can know another partner resources and capacities which will help client to fulfill another partners requirements without any duplicate submissions which will reduce the time and cost of the companies. FARM application is used for the companies to reduce the companies IT support and implementation costs. By using this application the companies to expedite the project delivery and have the access to optimizes and verifies talent. This application is function with integrity and the companies will work with the best partners.
Roles & Responsibilities
Created detailed reports for the partners to help them to analyze which requirements has been published by showing geo graphical information based on various parameters
Performance based reports for the partners to show in various measures like duration of the project, preferred location, and primary skills
Participated in the Normalization and De-Normalization of database along with creating and managed clustered and non-clustered indexes to improve database performance.
Designed SSIS packages that could run on various environments by creating various types of XML and SQL Server configuration files for the variables being used in the packages.
Extensively used SSIS Import/Export Wizard, for performing the ETL operations and actively supported partner users for change requests.
Extensively used for loop Containers and for each loop containers to perform dynamic tasks in SSIS.
Monitored performance and optimized SQL queries for maximum efficiency and planned the complete Back-up of various Databases for disaster recovery scenarios.
Identified and added the report parameters uploaded reports on to the report manager and organized them in folders.
Used VBA for exporting and importing data.
Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data.
Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
Worked on Excel Power Pivot for providing ad-hoc reporting for the clients.
Deployed the generated reports on to the server and fine-tuned the database objects and server to ensure efficient data retrieval.
Created reports using SSRS from various sources like SQL Server and Cubes from Analysis Services.
Worked on SSRS Reports, Sub Reports, Data Drill-Down, and Data sorting/grouping.
Designed reports using bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel.
Project # 1 2019 July to 2020 Feb
Client : Digitohub
Product : PureData
Duration : April 2019 – till date
Technologies : SQL Server, PHP, My SQL, Python, Codeignitor
Puredata:
Puredata is a SAAS based tool developed by Digitohub which has provided Out of the Box (OOTB) data validation rules & framework to kick start your data quality journey. Puredata leverages industry best practices, latest technologies, efficient processes and trained team to deliver improved data quality.
The PureData tool is enabled through other supported PureData Engines & Accelerators. These accelerators are built on multitude of technologies consisting of JavaScript’s, Python, CSS technologies, AWS
Role & Responsibilities
Writing the business rules– standardization of the data
Confirmation of business rules with the SME
Loading of Business rules into the product
Testing & Validation of the tool.
Ongoing support for maintaining the PureData Tool.