SUMMARY:

• 8.2 years of Experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite SQL Server 2000/2005/2008 R 2/2010/2012.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2010/2012.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Created layered .Net Components using C#.NET and ADO.NET.
• Exposure to .NET Framework.
• Exposure to Object oriented programming concepts
• Experience with Entity Framework approaches such as code - first and database-first.
• Participated in maintenance phase of application.
• Used LINQ to SQL provider to query SQL server databases as well as sql server compact databases.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge and union all.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, Views, User defined data types, functions, and Indexes using T-SQL.
• Experience in Performance Tuning and Query Optimization.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Knowledge on Dimensional Data Modeling like Star and Snow Flake Schemas.
• Experience in Agile methodology and participated in sprint planning’s.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, Power BI

Database: MS SQL Server 2012, 2010, 2008 R2, 2005, 2000.

Language: VB.NET,ASP.NET,ADO.Net,.NET Frame Work, C#

Operating System: Windows 7/XP/NT/2000/2003

Tools: Erwin Data Modeler, MS Visio, Microsoft office 2013/2007, Visual Studio

Code Repository Tools: Team Foundation Server, GitHub

PROFESSIONAL EXPERIENCE:

Confidential, Saddle River, New Jersey

Database Engineer

Responsibilities:

• Validating, testing and loading Client data according to the pre-defined standards.
• Creating and maintaining objects like Stored Procedures, Functions, etc. required for the automation of data load.
• Created SSIS packages for loading different varieties of files into tables provided by the client.
• Extensively used Script component as Source/Transformation to load data from irregular files/to cleanse data which cannot be done by using other transformations.
• Used vb.net/C# code in script component/Script task to perform actions like file check, file moving, and sending emails.
• Developed and executed unit tests.
• Involved in deployment of database objects from QA/Dev environment into Prod environment.
• Involved in maintaining records in configuration tables which holds SSIS package configuration variables.
• Build custom package and used look up transformation to perform DML operations in lower environments to make sure some of the production configuration tables are up to date in lower environments. Scheduled the package to run every alternate week.
• Build matrix report to show the accounts distribution across different account level tables in a database. Created drill through report from this report to show few example accounts by clicking the distribution number.
• Wrote dynamic SQL in a SP and used it in SSRS report to check whether the standard objects exists in a database.
• Involved in creating and maintaining centralized event log table which keeps track of all the packages.
• Involved in creating and maintaining SQL objects for applications team.
• Wrote T-SQL procedures to use them in SSIS packages for minimizing complexity of the package.
• Created and maintained jobs using SQL Agent Jobs and scheduled according to the files availability in FTP Folders.
• Monitoring existing jobs to make sure data in SQL Server are up to date.
• Involved in bug fixing and testing the existing SSIS Packages.
• Re wrote old DTS packages to new standards (SSIS 2008R2). Tested and validated to make sure everything is perfect.
• Involved in testing the databases and other objects during server migrations.
• Converted SSIS 2005 packages to SSIS 2008 R2 and made required changes for the package to run perfectly.
• Contributed significant amount of time testing packages, database objects and applications during migration period ( R2).
• Creating custom views as per the request from applications team.

Environment: SQL Server 2005/2008 R2, SSIS, MS Office, Team Foundation Server, VB.Net, C#.

Confidential, Franklin Lakes, NJ

MS SQL Server/BI Developer (SSIS, SSRS)

Responsibilities:

• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Using SSIS tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Extensively used most of the transformations available on the SSIS toolbox such as Lookup, Derived column, Data conversion, Aggregate, Conditional split and Script task etc.
• Created stored procedures to use as the datasets for the Report Design.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• Expert in using variables and expressions in packages.
• Experience in writing VB scripts/C# in script component task.
• Created package configurations and custom logging. Worked on error handling to handle errors in SSIS packages.
• Created Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services 2008.

Environment: SQL Server 2005/2008 R2, SSIS, SSRS,SQL Profiler, MS Office, Erwin, Windows Server 2007, Team Foundation Server.

Confidential, Boston, MA

SQL BI Developer / DBA

Responsibilities:

• Routine checks of log and trace files to trace database activities and scheduling activities.
• Creating and scheduling all DB related jobs.
• Validating and creating user accounts
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Scheduling the SSIS packages and Jobs
• Good Knowledge on data visualization tools power BI and Power Pivot.
• Creating and deploying parameterized reports using power BI and Tableau.
• Highly responsible for development and management of SSAS, SSRS and SSIS projects.
• Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008R2
• Help improve performance of queries by analyzing the execution plans, monitoring resource utilization and Database engine tuning tool to identify indexes/statistics that can help in performance tuning
• Document Backup and recovery procedures.
• Monitoring day to day the performance of the DB running in the production as well as in the non-production servers.
• Duties also included database creation, backup/recovery, general troubleshooting, script development and documentation

Environment: SQL Server 2012 Enterprise Edition, SSAS, SSIS, SSRS, T-SQL, Windows Server 2008, MS excel 2003, Microsoft Visual Studio 2008.

Confidential, Sacramento, CA

SQL Server BI Developer

Responsibilities:

• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS
• Deployed SSIS packages and Reports to Production Servers.
• Involved in creation of Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provided high availability support.
• Worked on Migration of packages from DTS using SQL Server Integration Service (SSIS).
• Participated Databases Architecture and data modeling design.
• Created External list using Visual Studio 2010 with full CRUD functionality using Business Connectivity Services
• Created Custom Web parts in Visual Studio 2010
• Performing DBA functions, installing, configuring and supporting database systems.
• Developed various operational, drill-through and drill-down reports using SSRS.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Reviewed and developed data models and database designs with development teams
• Wrote store procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2005.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity, C#, ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential

SQL Server BI Developer

Responsibilities:

• Created ER diagrams either Logical/Physical using Erwin.
• Assisted in database design, creation of ER diagrams, phasing from development to QA and to production environment.
• Created user based databases and installed MS SQL Server 2005.
• Worked in Project planning, Designing & Implementation.
• Involved in creating tables, views, stored procedures, triggers, and cursors and other SQL joins and statements for applications.
• Wrote the stored procedures, checking the code for efficiency with routine backups and restoration. Data transfers between various servers using BCP.
• Defined and created indexes for query optimization and revising scripts for optimal performance.
• Used data transformation services (DTS) to populate data from various data sources using the concept of OLE DB.
• Installed SQL Server service packs based on the errors and flaws that are found in the application.
• Tested the stored procedures performance and its path of execution by using SQL profiler.
• Recovered the backups of SQL Server production databases in test server environment.

Environment: MS SQL Server 2005, Windows 2000 Advanced Server, VB 6.0, and XML.