PRIYANSHU

KANT

S Q L / S S I S / S S R S D E V E L O P E R

SKILLS

Problem Solving

Adaptability

Collaboration

Strong Work Ethic

Time Management

Critical Thinking

Handling Pressure

SUMMARY

Over 5 years of IT experience as SQL Developer

which includes Database Design and

Development, Confidential BI Solutions, ETL

Development, Data warehouse

Implementation, Report Development using

SQL Server 2022/2019/2017.

Strong experience working on Confidential

Business Intelligence applications.

Experienced in Agile Methodology.

Expertise in SSIS (SQL SERVER INTEGRATION

SERVICES), SSRS (SQL SERVER REPORTING

SERVICES), SSAS (SQL SERVER ANALYSIS

SERVICES), Power BI, Power Pivot and Tabular

Model, DAX, MDX queries.

Working knowledge on data modelling

techniques towards building enterprise data

warehouse.

Experienced in executing activities related to

end - to-end project management, including

project plans and estimates, scoping and

requirements through implementation,

Requirement Gathering, Requirement analysis,

Application environment Setup, Preparing Test

Scripts, Project Status reporting, bug fixing and

deployment.

Strong experience in logical and physical

database design and development using Erwin

and SQL server enterprise manager.

Expert in using Performance Tuning tools like

MS SQL Profiler, Index Tuning wizard, SQL Server

Database Engine Tuning Advisor.

CONTACT

469-***-****

ad3iin@r.postjobfree.com

Prosper, TX 75078

EDUCATION

Associate's degree

PRIYANSHU

KANT

S Q L / S S I S / S S R S D E V E L O P E R

Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.

Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database. Worked on SQL Server Analysis Services (SSAS) including in building cubes and writing MDX queries.

Worked on SQL Server Reporting Services in generating parameterized, linked, drilldown and sub reports.

CONTACT

469-***-****

ad3iin@r.postjobfree.com

Prosper, TX 75078

TECHNICAL SKILLS:

Database: SQL Server, Progress, MS Access

Prog. Languages: VB.NET, C#, VB Scripts, ASP.NET, XML, T - SQL, Progress 4GL Operating Sys: Unix (IBM RS6000/AIX, HP/UX, Sun Solaris 5.6), .NET BI Suite: SSAS, ProClarity, SSRS, MOSS, PPS, Hyperion Applications: Healthcare, Distribution/Logistics, Medical Billing, De-regulated Electric and Gas.

VANs: Advantis, Inovis, ICC, PUBNET, GXS, Walmart’s Retail-Link,SPS Commerce etc., Major Retailer: Walmart/Sam’s Club, Kohls, Burlington Coat Factory, Linens N’ Things, Barnes & Noble, Amazon, Federated Stores, Staples, West Marine, JC Penney, BJ’s Wholesale Club.

EXPERIENCE:

SQL/SSIS/SSRS Developer

Valley State Bank, Garden City, KS (Jan 2022- Present) Design & Develop front end for EDI application using ASP.NET for querying, sidetracking, sales reporting

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio. PRIYANSHU

KANT

S Q L / S S I S / S S R S D E V E L O P E R

CONTACT

469-***-****

ad3iin@r.postjobfree.com

Prosper, TX 75078

Wrote T-SQL queries, Stored Procedures and used them to build packages. Designed, Developed and Deployed packages in SQL server environment using SSIS. Designed, modified and troubleshoot SSIS packages. Used SSIS to load data from various sources into on SQL Server 2022 database and created packages.

Involved in tuning and configuration of SSIS.

Deployed SSIS packages from Development to Testing Servers Debugging of SSIS packages.

Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.

Event handlers, which are workflows that runs in response to the events raised by a package, task or container in SSIS.

Environment: Windows 2003/2000, XP, SQL Server 2022/2019, SQL Server Integration Services, SQL Server Analysis Services, T-SQL, SQL Query Analyzer, IIS 5.0, Power Designer, Visual Studio 2022/2019,T-SQL, Windows Server 2000. SQL Developer / MSBI

NTT Data Services, Plano, TX (Apr 2020- Dec 2021)

Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance. Excellent Experience in monitoring SQL Server Performance tuning in SQL Server Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.

Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages. Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.

PRIYANSHU

KANT

S Q L / S S I S / S S R S D E V E L O P E R

CONTACT

469-***-****

ad3iin@r.postjobfree.com

Prosper, TX 75078

Good working knowledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects. Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.

Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment: MS SQL Server 2019, SSRS, SSIS, SSAS, DB2/UDB 9.5, .NET Framework, C#, ASP.NET, Windows 2014 Advance Server, HTML, XML, MS Excel, MS Access. Junior SQL Developer

Southwest Medical Center, Liberal, KS (Aug 2018- Mar 2020) Build and maintain complex SQL queries using T SQL for data analysis, data mining and data manipulation. Organize analytical data ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.

Created/designed reports using SQL Server Reporting Services according to user requirements.

Responsible for writing SQL queries, Procedures, Functions and Database triggers. Good Experience in Tuning and Optimization of T- SQL stored procedures. Optimizing the current ETL process, identifying and eliminating bottle necks and decreasing data latency. Created synchronized mechanism for data management in SQL Server. Set the job dependencies of SQL jobs using MSDB objects Developed highly optimized stored procedures, functions, and database views to implement the business logic and also created clustered and non-clustered indexes.

PRIYANSHU

KANT

S Q L / S S I S / S S R S D E V E L O P E R

CONTACT

469-***-****

ad3iin@r.postjobfree.com

Prosper, TX 75078

Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension. Used various SSIS tasks such as Conditional Split, Multicast etc. which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Responsible for implementation of data viewers, Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Created and maintained data flow diagrams for existing and future ETL processes. Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).

Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.

Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports Environment: SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), C#,SQL Server Analysis Services (SSAS), Microsoft Visual studio 2010,IIS, VB.Net, Erwin

Contact this candidate