Pragnya Naik

SQL BI Developer Email: admzgd@r.postjobfree.com Mobile: 213-***-**** Whittier CA-90606

PROFESSIONAL SUMMARY:

Over 4 years of experience working on SQL server integration services, SQL server reporting services, SQL server Analysis Services and TSQL Development.

Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.

Experience with Relational and Dimensional data modeling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys, drill down and drill across approach.

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2016/2014/2012/2008.

Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014/2016.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications.

Worked Extensively on ETL process using SSIS package.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.

Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.

Extensive experience working with SAP Cubes and DSO`s and ETL Process.

Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS

Languages

C, C++, JAVA, C#.NET, T-SQL

Database

MS-SQL Server 2008/2012/2014

Operating Systems

Windows XP/NT/2005/2008/2014

Web Technologies

JSP, Servlets, ASP.NET, HTML, XML

Developer Tools

SSIS, SSRS, SSAS, SAP BW, Power BI, Business Objects.

Other Tools

Ajax, Apache, Tabular Model, MAP Reduce, HIVE, PIG and TABLEAU

Client: The Irvine Company CA 01/2020– Present

Role: SQL Developer

Responsibilities:

Interacted with business resources on a daily basis for analyze business processes, requirements progress and deliverables.

Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In

Designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.

Design of the data source and data flows, data quality analysis and incorporated business defined transformation logic to loaded SQL and Teradata Tables.

Gathered business requirements, working in conjunction with the data warehouse architect on the development of logical data models.

Created Stored Procedures, Views and User Defined Functions to support the front-end application.

Implementation of Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Created Jobs using SQL server agent and JAMS agent to automatically run the SSIS Packages and stored procedures in scheduled time.

Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for cleaning and massing.

Utilized Power BI Gateway to keep the dashboards and reports up to date.

Configuring Power BI Gateway for SSAS live connection.

Developed complex DAX Queries to generate computed columns.

Storage development and design utilizing Blobs, Tables, Queues, Files

Developed and published reports and dashboards using Power BI.

Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services.

Generated xlma’s to Refresh Tabular Model and scheduled jobs for respective xmla’s through JAMS

Optimized packages minimizing use blocking transformations, adjusting buffer size, parallel executing packages in control flow, and using proper event handing, loggings and check points.

Designed, deployed and maintained various SSRS Reports in SQL Server 2008 and 2012.

Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create SSRS reports

Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS.

Created report for users in different departments in organization using SSRS and Power Bi.

Scheduled and monitored dependency and pre-check jobs using JAMS and Schedule jobs to run according to business days using the SQL Server Agent.

Created Complex Views and complex functions to expose the particular columns as per the client requirement.

Worked actively in performance tuning and optimizing the SQL queries using the SQL Profiler, query execution plan & SQL DMV’s, DBCC commands and Activity Monitor.

Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation. Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.

Environment: SQL Server 2012/2008R2/2008/2005, T-SQL, SQL Integration Services (SSIS), SQL

Reporting Services (SSRS), SSAS, Power Bi, Business Intelligence Studio, Visual Studio 2012/2010,

BI Xpress, SharePoint, Project Server, C#, VB, HTML, Team Foundation Server (TFS), Service Now.

Client: CTS, India 12/17– 07/18

Role: SQL Server BI Developer

Responsibilities:

Successful migration of the data from 2005 SQL database to SQL 2008, 2012 database by converting and re-writing DTS packages and updating them to SSIS packages.

Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server 2008

Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration Services (SSIS) on different Data Sources.

Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.

Implementation of Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Designed and optimized various T-SQL database objects like tables, views, stored procedures, functions, indexes and triggers using Management Studio and SQL Profiler.

Created Stored Procedures, Triggers and User Defined Functions to support the front-end application.

Created Triggers (Instead of and After) for Auditing Purpose.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Created Jobs using sql server agent to automatically run the stored procedures in scheduled time.

Worked on de-bugging package execution using break points in control flow and data viewer in data flow.

Worked on importing and exporting data from MS-Access Database and XML to SQL Server Database.

Developed, created and implemented complex ETL strategy to grab the data from OLTP, perform various transformations and dump the incremental data into Data Mart.

Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Optimized ETL packages using various SSIS features at Control Flow and Data Flow level.

Designed, deployed and maintained various SSRS Reports in SQL Server 2008 and 2012.

Used Dynamic SQL extensively in T-SQL increasing usability of code and also used dynamic query to create parameterized, cascading parameterized reports, drill down, drill thorugh and Tab reports

Generated daily, weekly, monthly, subscription reports for the analysis of managers & end-users using SSRS.

Optimized packages minimizing use blocking transformations, adjusting buffer size, parallel executing packages in control flow, and using proper event handing, loggings and check points.

Used XML nas SQL server package configuration in deploying packages to production environment.

Involved in De-Normalization of existing tables for faster query retrieval.

Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.

Experience in Using and maintaining the Visual Source Safe for version control.

Created Complex Views and complex functions to expose the columns as per the client requirement.

Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.

Automate the backup and the recovery strategies for the Production environments.

Implemented DB maintenance plans by appropriately re-indexing the indexes to resolve fragmentation.

Analyzed and addressed DB performance issues to resolve the blocking, deadlocks and optimized the performance.

Environment: SQL Server 2008R2/2008/2005, T-SQL, SQL Integration Services(SSIS), SQL

Reporting (SSRS), SSAS, Business Intelligence Studio, Visual Studio 2008, Erwi4.0, SharePoint,

MOSS2007, C#, HTML, Visual Source Safe (VSS),

Client: SunraySys Solutions Pvt Ltd - India 02/16 – 11/17

Role: MSBI Developer

Responsibilities:

Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs

Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.

Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS

Installed, configured and maintained SQL Server Integration Services (SSIS).

Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB.

Experience with the Share point 2007 to upload the SSIS packages in to Web portal.

Participated in requirement gathering, cube design, application design, SSAS development, training operational users.

Implemented SQL Server OLAP services (SSAS) for building the data cubes.

Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.

Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS)

Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.

Developed reports using SSRS and published as PDF, Excel, and CSV formats.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Designing and building data load procedures using MS SQL Server.

Designed and implemented Stored Procedures and Triggers for automating tasks.

Configured product meta-data tables to support client data reporting needs.

Incremental and full database recovery with experience of complex recovery scenarios.

Performance: Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries

Environment: SQL Server 2005/2008, MS Analysis Service SSAS Developer 2008, MS Project, MS Access 2000 & Windows 2K platform.

Education:

University of New Haven, CT, United States 08/2018-12/2019

Master of Science

MGM’s college of Engineering and Technology, Mumbai, India 08/2013-05/2017

Bachelor of Engineering

Contact this candidate