Sql Server Manager
Resume:
Pavan Kumar
SQL BI Developer
***********@*****.***
Professional Summary
Over 4 years of IT experience in Financials/ Medical and Retail sectors as a SQL server Developer that includes Database Design and Development of SQL Server 2016/2012/2008.
Expertise in developing application using.NET, C#, SQL Server.
Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server2016/2012/2008.
Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) &OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2016/2012/2008.
Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
Experience in debugging the SSIS packages using breakpoints and checkpoints.
Hands-on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)
Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.
Certified POWERBI Developer
Technical Skills
RDBMS:MS SQL Server 2000/2005/2008, MS Access, Oracle 9i/10g, Sybase.
Programming Languages: T-SQL, PL/SQL, C#, Java, VB scripts, Oracle.
Tools & Packages: SQL Server Management studio, Enterprise Manager, Profiler, Business Intelligence
DBTools: SQL Management Studio, Data tools (SSIS/SSRS/SSAS), SQL Server Enterprise Manager, T-SQL, DBCC, BCP, SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Agent, oracle enterprise manager and TOAD.
Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2016/2012/2008.
BI Tools: SQL Server Reporting Services (SSRS), Power BI, SQL Server Integration Services (SSIS), SQL Ser OLAP tool
Work Experience
Dell Services, TX
August 2016 – Till Date
SSIS/PowerBI Developer
Responsibilities/ Roles:
Designed and created reports in different formats such as Excel, PDF, HTML, and CSV using SQL Server 2005/2008/2012 Reporting servers (SSRS).
Generated reports using SQL Server Reporting Services 2012 from OLTP and OLAP data sources.
Extract, Transform and Load source data into respective target tables to build the required data tables.
Worked on complete SSIS life cycle in creating SSIS packages, building, and executing the packages in both the environments (Development and QA)
Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.
Strong experience in designing and implementing ETL packages using SSIS for integrating data using OLE DB connection from heterogeneous sources
Performed all kinds of Transformations like Import Column, Export Column, Lookups, Derived Column, Merge Join, Lookup, For Loop, Conditional Split, Union all, Script component in SSIS as per the client's Requirement.
Developed Dashboard Reports using SQL Server Reporting Services (PowerBI).
Creating and designing complex Reports like Drill Through, Tabular, Drill Down, Matrix and Sub Reports in SSRS.
Developed SSIS Packages for migrating data from Staging Area of SQL Server 2012 to SQL Server 2016.
Created Complex ETL Packages using SSIS which upsets data from staging table to database tables.
Created Reports using Power BI and published on Office 365 SharePoint online.
Applications used: Outlook, Word, Excel, Dropbox, Google Applications, and Power BI
Generation of reports using tools such as Pivot Tables, Power BI, Excel, and InfoPath.
Extensively used Power BI desktop and DAX to create Dashboards for data analysis/business needs
Used to export and import of different databases using Oracle Exp / Imp and data pump utilities
Environment: Windows Server 2003/2008/2012, MS SQL AZURE, Server 2012/2014/2016, Visual Studio 2008/2012, SSRS, SSIS, SSAS, MS Office, C#, SharePoint, Power BI, Tableau, Java
KIMS, INDIA
2015 January to 2015 July
SQL Server/SSIS Developer
Responsibilities/ Roles:
Partially involved in system study and database designing.
Installation of SQL Server 2012 in Windows 2008.
Creation of database objects.
Configured SQL Server Environment.
Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
Performed job scheduling in the SQL Server Environment.
Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
Created views consisting of computed columns to facilitate easy user interface.
Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.
Designed and implemented user log in and security.
Developed stored procedures, triggers, row level audit tables in SQL Server.
Developed cursors and views to improve performance in data transactions.
Environment: SQL Server 2008 R2, 2014, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Windows Servers, SharePoint, TFS.
Jeme Global, India
2013 July to 2015 January
SQL Server Developer
Responsibilities/ Roles:
Interacted with end users to gather Requirements. Created technical, user documentation.
Studied and designed the system.
Install, Update, Configure and Maintain the MS SQL Server.
Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
Written Java Script for different validations.
Used SQL Statements to Present Query responses.
Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O.
Environment: MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Access 2000 & Windows NT platform, Reporting Services, DTS, Business Objects 4.0/6.5, Windows Active Directory.
Educational Qualifications
Masters In IT from Pittsburg State University, USA
Bachelor’s In Computes at JNTU
PowerBI Certification
5006a7f6246a40afa0e334cc2b6081f4
Contact this candidate