SUMMARY:

• A Confidential Certified Professional with 10 years of IT experience in the Design, Development, Modeling, Implementation and Support of SQL Server 2005/2008 R2/2012 in OLTP/OLAP/BI environments.
• Extensive experience in MS SQL Server 2005/ 2008/2012, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from multiple sources and load into various Business Entities.
• Extensive experience in developing & deploying cubes using SQL Server Analysis Services (SSAS ) involving multidimensional data.
• Assisted in the design of Star schema and Snow flake schema and development, maintenance and optimization of OLAP cubes and data sets.
• Good experience in developing the table and matrix reports using SSRS and s scheduling the r reports weekly and monthly basis as per the client requirement.
• Experienced in designing and developing SSRS reports using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs and expertise in enhancing and deploying the SSIS Packages from development server to production server using SSIS catalog.
• Experience in SQL Server Optimization by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Integration Services 2008/2012.
• Expertise in designing and developing applications using ASP.NET, MVC, ADO.NET, Enterprise Library, LINQ, C#.NET, SQL SERVER 2008/2012, Web services, SOAP, HTML 4/5, XML, JSON, CSS,Java Script, jQuery, AJAX, Web Forms.
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experienced in using various methodologies in Software Development Life Cycle (SDLC) like SCRUM/AGILE, Waterfall.
• Working knowledge of UNIX,Sybase,Autosys and Shell scripting.

TECHNICAL SKILLS:

Databases: SQL Server 2008R2/2012/2014, MS-Access

.Net Technologies: .Net Framework 2.0/3.5/4.0/4.5, C#, WCF, LINQ

Web: ASP.NET, HTML, AJAX, Web-Services, Restful services, MVC 4/3

Scripting: XML, CSS, Java Script, VBScript, jQuery

Tools: SSIS, MS Reporting Services 2005/2008, Crystal Reports

Versioning Tools: Visual Source Safe (VSS), Team Foundation Server

WORK EXPERIENCE:

Confidential, New York, NY

MSSQL Server/MSBI Developer

Responsibilities:

• Responsible for the database migration of the legacy LBBW Soft application developed in MS Access 2003 to .NET 4.5, Prism and SQL Server 2008 and to 2014.
• Analyzed various business requirements to provide estimates for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move).
• Perform ETL processes using SSIS tool for SQL Server.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files (4GB) data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge, Join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Design/develop complex queries efficiently as per the given business requirements.
• Responsible for stored procedures optimization, performance tuning and index tuning.
• Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins) and scheduled Jobs and Alerting using SQL Server Agent.
• Implemented custom logging, auditing and custom email notifications using SSIS 2008/2012.
• Worked with DBAs to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.

Technologies: MS SQL Server 2008R2/2012/2014, MS SQL Server Integration / Reporting Services 2012 OLTP, T-SQL, MS Excel, C#.NET, VB.NET, XML, SQL profiler, SQL Server Configuration Tools, Toad for SQL Server, SQL Compare.

MSSQL Server Developer

Responsibilities:

• Responsible for stored procedures optimization, performance tuning and index tuning.
• Set-up SQL jobs to load the data daily into database objects related to multiple modules.
• Enhanced the performance of databases using Execution Plan and SQL Profiler to optimize queries.
• Implemented ETL process from Excel and flat file to MS SQL Server using SSIS.
• Created SSIS packages, including lookups, derived columns, data conversions, aggregations, conditional splits, SQL tasks, script tasks, send mail tasks and FTP tasks for file transfer.
• Implemented multiple connection managers to connect to different data sources using C#.Net/script components.
• Perform ETL processes using SSIS tool for SQL Server.
• Design/develop complex queries efficiently as per the given business requirements.
• Created database tables, views, stored procedures, functions and triggers as required.
• Worked on table partitioning to load current and historical data.
• Developed views, sub-queries and joins for complex queries involving multiple tables.
• Worked with Business Analysts to understand the requirements.

Technologies: MS SQL Server 2008, MS BIDS, T-SQL, SQL Server Integration Services (SSIS), Management Studio, Transact-SQL, MS Excel, .NET framework 4.0, Windows XP/2003.

Production Support Engineer

Responsibilities:

• Responsible for managing batch processing including setting up Autosys scheduler and maintaining/enhancing existing batch applications using shell scripts, Perl scripts in UNIX.
• Responsible for incident management from job monitoring to root-cause analysis to issues resolution. Coordinated with the responsible parties identifying issues, logging and tracking issues, conducting team meetings for implementing fixes and communicating status to all tactical teams and management.
• Performed proactive sanity EOD checks for production environment to ensure availability of various systems and data within the agreed service level agreement.
• Responsible for L1/L2 support of EOD batch cycle such as monitoring batch jobs, providing on-call support, analyzing job failures, fixing bugs/job failures, and performing batch tuning.

Technologies: Sybase, Autosys, JIRA and UNIX

.NET Developer

Responsibilities:

• Developed and Implemented Win Forms, Web Forms using ASP.NET and coded the Business logic in C#.
• Used HTML and advanced CSS custom templates to ensure unified look for the user interface.
• Developed WCF services to be used by ASP.NET applications.
• Used User Control, Ajax Toolkit to develop the application.
• Used JavaScript and .NET Validation Controls for performing client-side validations.
• Designed a Master Page and used CSS for to provide a consistent look and feel of inherited web pages.
• Involved in the Analysis, Design and Development of the Web Based Intranet Application using ASP.NET, C#, Multiview, jQuery, JavaScript, session states.
• Configured security features for the application using Form Based Authentication and Role Based Authorization using C# and ASP.NET.
• Developed the Web Application in ASP.Net 3.5 using Master Page, Themes & skins to maintain the consistent look and feel throughout the application.
• Involved in developing Web Service classes using SOAP to communicate with legacy systems and also deployed web services as per business requirement.
• Designed and Developed Web Services to synchronize data from Remote application database to Online Database .

Technologies: .NET Framework 3 .5, ASP.NET 3.5, IIS 7.0, ADO.Net, Windows Services, C#, HTML, WCF, Visual S tudio 2008, Oracle .

.NET Developer

Responsibilities:

• Involved in designing and development of Inbound and Outbound modules.
• Developed and consumed Web Services to extract information from the database and other services.
• Created various Web forms for user login, account summary, loan applications and history pages using ASP.Net.
• Used various advanced Server Controls and developed Custom Controls.
• Implemented F orms based authentication and maintained Session State information throughout the web transaction.
• Implemented server side business logic using C#.
• Implemented Client and Server side validations using JavaScript and ASP.Net validation controls.
• Used HTML, DHTML and CSS for developing Web Pages.
• Designed CSS aiming for a rich personalization of server side controls.
• Provided database connectivity using ADO.Net and created procedures, Indexes and Triggers using MS SQL Server 2005 .
• Used T-SQL to examine the database information.
• Used Data Adapters and Datasets of ADO.Net to manipulate data in the SQL server database.
• Extensively used Datagrid and Datalist controls to display information on the web pages.

Environment: .Net Framework 3.0, Visual Studio 2005, ASP.Net, C#, Web services, ADO.Net, XML, HTML, JavaScript, Webforms, SQL Server 2005, T-SQL, CSS, IIS, Visual Source Safe.