Sql Server Data
Resume:
Nikita
*********.*******@*****.***
Professional Summary:
5+ years of strong experience with demonstrated success in the Database Design, development of SQL Server 2005/2008/2008R2/2012/2014.
Designing and implement SQL Server Data Marts and Data Warehouses using best practices in accordance with Microsoft guidance.
Extensive experience in Database and Business Intelligence technologies with expertise in Installing, Upgrading, Troubleshooting and Configuring MS SQL Server Database, SSIS, SSRS, SSAS.
Experienced in SDLC (Software Development Life Cycle) involving System analysis, Design Development & Implementation using Waterfall methodology and Agile methodology.
Profound knowledge and ability to write complex stored procedures, temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
Experience in Data Modelling (Logical and Physical Design of Databases), Data Profiling, Data integrity, Normalization and building Referential Integrity Constraints.
Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems
Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
SQL Server Integration Services:
Exhaustive experience in Data Extraction and Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) in MS SQL Server to import/Export data, Bulk insert and BCP.
Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, and Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot).
Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
Experience in providing Logging, Error handling by using Event Handler, Query Optimization and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
SQL Server Reporting Services:
Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached, Ad-hoc reports and rendered them to HTML, XML, PDF and Excel formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
Strong experience in creating dashboards, KPI’s and scorecards using gauges and charts for analysis using SSRS 2012/2008 R2 and SharePoint 2010.
SQL Server Analysis Services:
Experience in Dimensional modeling using Star schema (identification of facts, measures and dimensions) and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
Experienced in working with Star Schema modeling to develop ROLAP/MOLAP Cubes using SQL Server 2008 Analysis Services.
Technical Skills:
RDBMS
SQLSERVER 2014/2012/2008R2/2008/2005, Oracle 10G/9i, Teradata, MySQL
Database Tools
BIDS, SS Management Studio, Query Analyzer, System Performance Monitor, SQL Profiler, Index Tuning Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), MSCS, Bulk Insert and BCP, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL, Oracle EBS, Data Quality Services(DQS), Master Data Services(MDS).
ETL & Reporting Tools
SSIS, SSRS, SSAS, EPIC clarity reporting 2008, Excel 2010, Cognos 8.3/8.4, QlikView, Tableau
Programming Languages
SQL, T-SQL, ANSI SQL, PL/SQL, C#, R, SAS, VB 6.0, Unix Shell, Python
Operating System
Windows 95/98, NT, Windows XP/2003/2000, Unix, Linux, MS-DOS
Web technologies
HTML, XML, VBScript, SharePoint 2010, C#, Apache, ADO.NET,VB.NET, Putty
Tools
Erwin 7.2, Visual Studio 2010/2008/2005, Visio, Visual Source Safe, Toad
Educational Qualifications:
Bachelors from North Maharashtra University, Jalgoan, India.
Professional Experience:
Penn National Insurance, Harrisburg, PA Feb 2016 – Current
MSBI Developer
Penn National Insurance is a global provider of property and casualty insurance and reinsurance. The goal of the project to create efficient centralized data delivery method; Data warehouse which provides a consolidated reporting solution that can be used at all levels of Endurance to provide the necessary information in a timely manner for the decision-making process. And also update some of the current processes that were running off of mainframe to change their source to EDW instead of mainframe. Create daily summery report using SSRS.
Responsibilities:
Developed User Defined Functions, store procedure. Responsible for error handling in Store procedure, indexes to generate the distinct data based on the type of the customer base, wrote T-SQL queries.
Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
Involved in maintaining batch log tables and error logging tables to handle errors using event handlers. Also in creating SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
Migrated packages from development server to production server using package configuration.
Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.
In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN 7.1.
Created dynamic reports using SSRS, generated report models using report builder for the end users.
Involved in scheduled reports on a weekly basis that was generated every Friday containing the details of weekly data.
Responsible for Scheduling and publishing reports using SSRS, Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
Environment: MS SQL Server 2014/2008R2/2008, Teradata, SQL Server Data Tools (SSDT), SQL Server Reporting Services, SQL Server Integration Services, Tableau, WINSCP, Putty, WinSQL, Toad, JIRA, PowerPivot 2013, Power Query, VB.NET, Visual Studio 2014, Team Foundation Server (TFS)
Bank of America, Addison, TX. May 2015 – Jan 2016
MSBI Developer
The goal of the project was to provide near real time data in SQL environment using CDC process, AS400 download database is refreshed from iSeries periodically to achieve this goal.
Responsibilities:
Participated in daily agile scrum meetings to understand business logic and requirements of the company and provide optimal solutions to the users.
Created SSIS packages for initial load from AS400 server to staging database, and implement CDC as per flags on row data
Created data retention queries and SSIS packages to ensure amount of history to be stored in all CDC database.
Created Merge queries to handle insert/delete/update flags from CDC (Change Data Capture)
Created Star schema dimensional modelling for the data mart and created dimension and fact tables based on the business requirement.
Designed SSIS packages to Extract data from different sources like SQL server 2008R2, MS Excel, MS Access transform them and load into Dimension and Fact tables in Data Warehouse using SSIS
Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split, Cache Transform and Derived column while developing the packages.
Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on daily basis.
Implemented data modelling, using ERWIN creates new relational or dimensional data models or reverse engineer’s legacy databases to move into a new environment.
Produced operational reports in SSRS 2012 i.e. drill-down, drill-through, dashboard and matrix reports.
Wrote complex SQL queries and stored procedure to create reports using SSRS 2012 from the relational database
Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
Configured the report server and generated the report models for user interactions
Wrote complex TSQL/PL SQL queries to get data from different sources and test results with expected results.
Implemented performance tuning for slow running packages, using execution plan and SQL Server Profiler. Implemented parallelism in SSIS.
Environment: MS SQL Server 2012/2008R2, SSIS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor and MS excel 2007, Visual Studio 2010/2012 (BIDS), AS400, iSeries, TFS, TOAD, JIRA.
Austere Technology Solutions, Pune India
Verizon Wireless Dec 2012- Dec 2014
MSBI SSIS/SSRS Developer
This was a pure Data Migration Project with a goal to migrate data related from old application with all necessary transformations applied to the new application. Make sure that new application can absorb old data and continue using it going forward. It also involves infrastructure design and metadata reporting.
Responsibilities:
Involved in Designing the ETL for incremental load to keep old and new applications in sync.
Worked with Change Data Capture (CDC) tasks in SSIS packages to achieve incremental loads.
Design and implement staging, landing and archive layers to bridge the gap between applications and improve performance for incremental load.
Developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views to implement the business rules and transformations.
Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
Involved in creating complex stored procedures, nested stored procedures, triggers, views, indexes and functions.
Extensively worked on SSIS packages design for data migration from scratch including package configurations and error handling.
Created SSIS packages from scratch to transfer data from source to destination using all required transformations applied.
Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
Designed and developed Unix Scripts as part of the ETL process, automate the process of loading and pulling the data.
Created reports which need an ability to be run on schedules, via command line parameters via front end modules, to generate PDF output.
Server upgrade and downgrade databases, perform database backup/recovery and cloning; perform operating system, application and performance monitoring and tuning.
Created parameterized reports using charts and sub reports.
Involved with Query Optimization to increase the performance of the Report.
Designed and Developed excel Model, Reports in EXCEL, Power Query and Power Pivot.
Worked on SSRS and Tableau for various reports including tabular, drilldown, drill through, matrix, parameterized, graphical reports, sub reports and metadata reports
Environment: MS SQL Server 2012/2008R2/2008, Teradata, Oracle 10G, SQL Server Data Tools (SSDT), Tableau, SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services, Data Quality Services, JIRA, PowerPivot 2013, VB.NET, Unix Shell, Korn Shell, ER/Studio, Visual Studio 2013/2012, Team Foundation Server (TFS)
Contact this candidate