Neelam Ninawe

Location: Woodbridge, NJ - ***** Email: adirvy@r.postjobfree.com Mobile: 908-***-****

PROFESSIONAL SUMMARY:

Over 3+ years of experience in database development, modeling, testing, deployment and business intelligence using SQL Server 2016,2014,2012, 2008,MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS)

Worked with various teams and user groups in designing and developing the reporting warehouse.

Expert in designing reports using SQL Server Reporting Services (SSRS) based on OLAP cubes.

Experience in developing custom reports and different types of tabular, matrix and distributed reports into multiple formats with SQL Server Reporting Services (SSRS).

Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of data migration and data maintenance.

Designed SSIS package to extract appropriate records and output them to data marts and warehouse.

Designing and maintaining data management and data processing solutions using SSIS, includes error handling and Slowly Changing Dimensions (SCD).

Experience in creating jobs, SQL mail agent, alerts and schedule SSIS packages in SQL Server.

Experience in normalize and de-normalize data in the process of building database and reporting.

Familiar with process of testing, troubleshooting and debugging on each unit of work, including jobs, SSIS package, SSRS reports and SSAS cubes.

Expert in migration of databases from older versions of SQL Server 2008 to SQL Server 2012.

Extensive database programming Experience in developing complex T-SQL queries including stored procedures, User Defined Functions (UDF), triggers, views, temporary tables constraints and indexes using various DDL and DML commands.

Having full understanding of Software Development Life Cycle (SDLC) with substantial experience on object oriented analysis and design methodologies

Education Details:

Masters in Computer Application 06/2002 - 08/2005

Nagpur University, India

TECHNICAL SKILLS:

Programming Languages

C, C#, ASP.net, VB.net, Java, Python, SQL & PLSQL

Web Technologies

HTML, XML, JavaScript, AJAX,SOAP And Active X.

Database Environments

Oracle 11g/12c, MS SQL Server2008/2012/2016,MySQL, DB2 and MS Access

ETL Tools

SQL Server Integration Services (SSIS), and Informatica.

Reporting Tools

SSRS, Oracle Forms & Reports 6i/9i/10g, Crystal Reports 8.0, Tableau, Cognos and Power BI

Other Tools

Microsoft Visual Studio, Oracle 11g,, SSAS, SQL Developer, SQL Server Management Studio, Microsoft Azure, Eclipse IDE,

MS-Tools

MS-Visio, Outlook, Advance Excel, Word, and PowerPoint

Operating System

Windows NT/XP/Vista/7, Windows 95/98/2000/NT, Windows Server 2003/2008.

Version Control Tools

CVS, TFS, SVN, GIT

PROFISSIONAL EXPERIENCE:

Client: Visa, Littleton, CO 05/2018- Present

Senior ETL/ SSIS Developer

Responsibilities:

Worked with various SSIS control flow tasks and data transformation tasks like data conversion, merge, aggregate, sort, conditional split, SCD, derived column, look-up, fuzzy look-up, etc. as part of ETL.

Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

Experienced in enhancing and deploying the SSIS packages from development server to production server.

Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.

Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.

Experienced in working with partially / full blocking transformations and expertise in performance tuning of SSIS packages.

Used index tuning wizard, SQL profiler and SQL query analyzer for performance tuning.

Performed data validation checks during staging, before loading the data into the data warehouse.

Participated in testing and verification of the entire database/ data warehouse system after migration.

Generated drill down, drill through, ad-hoc, matrix reports, parameterized reports using SSRS.

Created SSRS reports using complex SQL queries/stored procedures which have sub-reports, dropdown menu options and charts.

Assigned permissions to the valid users for executing the reports and deploying reports to report servers.

Created dashboard using parameters, filters, sets, groups and calculations to manipulate data.

Combined views and reports into interactive dashboards in Power BI that were presented to business users, program managers, and end users.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS)/Visual Studio, T-SQL, MS Excel and Power BI.

Client: Care source, Dayton, OH 01/2017 – 04/ 2018

BI Developer

Responsibilities:

Created new database objects like stored procedures, functions, triggers, indexes and views using T-SQL in development and production environment for SQL Server 2014.

Maintained MS SQL Server 2014 configuration, tuning and provide 24 X 7 dedicated support to all production, development and clustered servers.

Involved in framing SQL queries for validating data between data warehouse and source systems.

Assist developers with difficult oracle PL/SQL code needed for queries, triggers, and stored procedures

Extensively involved in the analysis and tuning of the application code (SQL and PL/SQL Procedures)

Develop and maintain procedures to optimize application availability.

Optimized queries by obtaining explain plan, analyzing tables, providing hints, and adding indexes on tables where required.

Worked on database compression for different databases to save space across different environments.

Extensively used joins and common table expressions to simplify complex queries involving multiple tables.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

Designed layout of SSRS reports and determine the best way to present data to end users.

Developed SSRS reports using Microsoft Reporting Services platform (SSRS), Microsoft SQL, SSAS, SSIS, MS Excel, pivot tables and other tools.

Developed complex stored procedures and views to generate various drill-through reports, parameterized reports and linked reports using SSRS.

Migrated DTS packages from SQL Server 2008 to SQL Server 2014 as SSIS packages.

Created SSIS packages coming from text files and excel files to validate, extract, transform and load data to data warehouse.

Migrated old data from MS Access into SQL Server 2014 using SSIS packages in Business Intelligence Development Studio.

Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.

Deployed SSIS package into production and used package configuration to export various package properties to make package environment independent.

Implemented event handlers in SSIS packages and notified process results to various user communities.

Tested, cleaned and standardized data meeting the business standards using fuzzy /exact lookups using SSIS tasks.

Developed data management and data processing solutions using SSIS, which including error handling and Slowly Changing Dimensions (SCD).

Environment: T-SQL, PL/SQL, Oracle 11g, MS SQLServer2014 Enterprise Edition, SSIS, SSRS &SSAS.

Contact this candidate