SUMMARY

• 7+ years of professional experiences in application and database development with thorough knowledge of different phases of software development life cycles including analysis, design, development, documentation, deployment and system support.
• Experience in Microsoft T - SQL statements (DDL and DML) including features like Temporary Tables, Raking Functions, Joins, Pivot, For XML path, CTE, While Loops etc.
• Good experience in designing, implementing and managing high-availability & disaster recovery solutions utilizing Microsoft SQL Server 2019/ 2017/2016/2014/2012 /2008 R2Failover Clustering, Always On Availability Groups, Database Mirroring, SQL Server Log Shipping, Transactional replication etc.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services SSAS.
• Experience on T-SQL Programming, Store Procedure, Trigger, Function, view, Index
• Extensive experience in the design and development of N-tier Client Server application architecture using ASP.Net, MVC, Web API, WCF, EF, ADO.Net, C#, VB.Net, HTML, CSS, JavaScript, Typescript, jQuery, Ajax, Angular JS, Bootstrap.
• Experienced in Live Training, demos to clients on different modules on Microsoft Dynamics NAVISION ERP system.
• Experience with Node.js, Express.js, JSON schema and REST APIs
• Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the stored procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs)
• Excellent experience in Creating, Consuming and Publishing XML Web Services SOAP, WSDL, UDDI using .NET Framework and Solid understanding of Service Oriented Architectures.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Experienced creating SSIS packages, Scripts for data load (Text, Excel, XML) and OLAP cubes using SSAS.
• Experience in writing complex SQL queries involving multiple tables joins.
• Experience in client-side technologies such as HTML, JavaScript, AJAX, JSON and JQuery.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Excellent TSQL Scripting Skills in developing Efficient Stored Procedures, functions, applying business logic.
• Used tools like MS SQL Profiler, Index Tuning Wizard, and Windows performance for monitoring and tuning SQL Server performance.
• Experience upgrading classic ASP and .NET 1.1 applications, developing e-commerce applications.
• Experienced in utilizing the new integrated features of ASP.NET versions like Windows Communication Foundation (WCF) and expertise in Multithreading techniques for creating high performance applications, Good work experience with Windows Services.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Involved in Microsoft Dynamics Navision ERP system integration with Sana and Magento e-commerce solution for B2B and B2C clients.
• Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in creating and designing SSIS Packages for Integration and Migration of data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server using BCP and DTS
• Developed OLAP cubes using SSAS (SQL Server Analysis Services). and calculate the metrics that were revealed in the functional analysis
• Data Mapping Skills, Data Migration Methods and Validations from Legacy Systems.
• Designing and creating different SSIS packages using OLE DB connection sources from different sources by making use of multiple transformations provided in SSIS.
• Providing security by using row level security implementation.
• Experience in SDLC like Agile (Scrum), Waterfall and V-model.
• Good and Effective Communication with all levels of business partners with Business Analysts to ensure the requirements are completely analyzed and technical owners to minimize risks.

TECHNICAL SKILLS

Databases: SQL Server 2019/ 2017/2016/2014/2012 /2008/2005 , Azure, MS Access, Teradata, Oracle, DB2, AS400 and MySQL

DB Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, DBCC

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), OLAP tools, Crystal Reports9.0/XI

Languages: SQL, T-SQL, PL/SQL, Dynamic SQL, .NET, HTML,PostgreSQL, C, C++, C#, UNIX, MDX.

Microsoft Technologies: .NET Framework 4.0/3.5/3.0/2.0 , ASP.NET 4.0/3.5/3.0/2.0 /1.0, VS.NET 2010/2008/2005 , ADO.Net, WCF 4.0/3.0, Ajax, LINQ

Tools: & Technologies: Enterprise Manager, SSMS, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, Microsoft Office SharePoint Server 2007

Operating Systems: Windows 2000/NT 4.0, Windows 2003 Advanced Server/Windows 95/98/200/XP-pro, UNIX, AIX/Linux

PROFESSIONAL EXPERIENCE

Confidential, Oakland CA

Sr. SQL Server Developer

Responsibilities:

• Analyzed and designed software and database solutions.
• Experience in developing optimized SQL using best practices.
• Expertise in writing dynamic-SQL, complex stored procedures, functions and views.
• Hands on Experience in performance tuning using execution plans, SQL Profiler and DMVs.
• Incorporated complex business logic into stored procedures and functions for reusability.
• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
• Extensively worked on setting up Always On Availability Groups on a Multi-subnet failover network.
• Optimized the performance of queries with modifications in SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for management of Microsoft Dynamics Navision ERP system, including documentation, customization, maintenance and upgrades.
• Creating applications using VB.NET and enhancing projects for .NET applications.
• Design and development of SQL objects such as tables, views, stored procedures, Functions, triggers etc.
• Strong debugging skills and the ability to solve complex problems.
• Developed the Front End using ASP.NET and Code behind using C#.NET.
• Used features like Dataset, Data Reader and Data Adapter to develop a Data Access Layer using ADO.NET.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Utilized ASP .NET/C#, JavaScript, AJAX, and Cross-Origin-Resource-Sharing (CORS) technology with JSON to revam seamlessly connect to vendor cloud services.
• Created Node.js API for easier platform expansion and more efficient performance
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2019 tools like SQLServer Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked in Agile methodology in order to discuss status of the project twice a week and take further measures which includes scrum meetings daily to discuss product backlog.
• Constructed web pages for application in custom created framework extensively using JavaScript MVC, JQuery, Unit Test (Node JS) and wrote code that is modular and reusable
• Worked on Web API to build HTTP Services which return JSON data to the client.
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Writing stored procedures and triggers extensively and working very closely with developers, business analyst and end users.
• Facilitated simplified access of database for end users using views and created triggers on them to maintain to database integrity
• Created tables, views, triggers, stored procedures and indexes.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2017/2019 Analysis Services (SSAS) and Reporting service (SSRS)
• Created the merge plan and merge process document from Microsoft Dynamics NAV 2013 R2 to Microsoft Dynamics 365 Business Central SaaS (“D365BC-SaaS”).
• Involved in the Technical Upgrade Microsoft Dynamics NAV 2013 R2 to Microsoft Dynamics 365 Business Central SaaS (“D365BC-SaaS”).
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Designed various cube objects such as KPIs, drill through actions, aggregations, and translations. Implemented key performance indicators, actions, hierarchies, and attribute relationships with added functionalities.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2017 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Involved in Back-End Testing, database table manipulation of relational database systems by writing complex SQL queries.
• Efficiently used SQL queries to test the required data were properly loaded into the Target Database.
• Worked on Database validation using SQL queries.
• Developed PL/SQL packages and procedures that imported XML data files, inserted the files into CLOBs, and parsed the data into multiple tables while maintaining referential integrity in the process.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Design, development, and implementation of Web applications transforming XML data into RDBMS and exporting XML data from RDBMS into requested formats using XML Schema, DTD and XSLT.
• Provided technical operational reporting expertise to stakeholders to ensure all operational data are available to support business decisions.
• Configured and managed data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies and implemented cell level security in cubes using SSAS.
• Analyzed, converted & imported client’s data into TBS data base using C#, Excel and XML, then generate reports for client to verify.
• Produced comprehensive analysis report on legacy data, data structure and statistical summary with Python.
• Created reports with Analysis Services Cube as the data source using SQL Server 2017 Reporting Services.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience in creating Tabular Reports, Matrix Reports, Parameterized Reports, and Sub Reports using SQL Server Reporting Services (SSRS)

Environment: MS SQL Server 2019/ 2017/2016/2014/2012 , (SSMS), SSIS, MS SQL Server,Unix Shell script, MS Visual Studio 2010, MS Excel, Agile, SQL Server Reporting Services (SSRS), T-SQL, Autosys.

Confidential, Indianapolis, IN

Sr. SQL Server Developer

Responsibilities:

• Creating tables, stored procedures, views, functions, indexes and modify them as per business requirements for forrent.com.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Writing T-SQL Script, Complex Custom Query, Merge statements, Joins, pre-deployment scripts in SQL Server 2017 and2008R2 and post-deployment scripts in SQL Server Data Tool (SSDT) 2017.
• Building SSIS package and modify it using SSDT.
• Data Migration.
• Run SQL jobs and SSIS package.
• Written T-SQL queries for the retrieval of the data.
• Creating applications using VB.NET and enhancing projects for .NET applications.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Written JSON scripts to consume WCF service to display required information on the web application.
• Modify Reports/Create Report and Data Cube as per business requirements.
• Completed a Project to upload Insurance Agents (Address, Contract Details, License and Education), Agencies, Districts and Regional Managers details, remotely download from SPTP site in XML format.
• Developed database and staging tables to load XML data using SSIS package and generate reports using SSRS
• Completed Project to mapped insurance Policy details according ACORD (Association for Cooperative Operations Research and Development), developed Database, tables, stored procedures and SSIS package to generate XML files
• Writing Custom Query as per business need and verify results in Management Console Backend.
• Writing SQL scripts in SSMS and execute directly in production.
• Restore User Database and fix the database issues in own environment.
• Participating various meetings as a part of Agile Software Development Life Cycle.
• Participated various periodical database security trainings, various project workshops, peer programming.
• Creating different CORE release folders and branches in Team Foundation Server (TFS) to work for project and the Sprint.
• Used JSON, JQuery for the Client side to pass the parameters for hand shake across applications and for client-side AJAX call, validations.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Merge down and Merge up database changes into different branches.
• Resolve conflicts in SSDT after database changes.
• Build solutions before pushing codes to production and different servers.
• Commit pending changes in Team Explorer, publish database changes and deploy SSIS package to production as well as different servers.
• Knowledge on Coding Standard, Version control, Declarative Database Development, SQL Server Tools, Data-Modeling and Data Architecture, Diagnose Replication in dev and beta environment.
• Write complex custom query.
• Update database without having restore using SSDT Data Compare.

Environment: MS SQL Server 2017/2016/2014/2012 , MS SQL Server Integration Services (SSIS), MS SQL Server, Unix Shell script, PostgreSQL, MS Visual Studio 2010, MS Excel, Agile, SQL Server Reporting Services (SSRS), T-SQL, Autosys.

Confidential, Jacksonville, FL

MS SQL Developer

Responsibilities:

• Review and identify stored procedures, packages and functions for best practices, enhanced features and better performance.
• Writing ad-hoc queries to analyze the desired output from the relational model.
• Identify in-efficiently written SQL's for fine tuning in order to improve performance.
• Bulk updates/inserts using Merge statements.
• Wrote LINQ-TO- SQL queries to perform DML operations from Entity Data Model
• Developed Complex Queries using different SQL joins and T-SQL Queries.
• Optimize the PL/SQL code using collections and bind variable for bulk operations.
• Writing analytical queries for faster processing and better performance.
• Perform hands-on ETL and Oracle development. Design and weighting code for most complicated Oracle processes. Create code to load different types of data (csv, binary, xml, json).
• Hands on experience in Amazon RDS Aurora performance tuning.
• Responsible for writing SQL queries to find out correct data for testing.
• Using appropriate hints and query techniques for faster retrieval of information.
• Conversion and mapping of data, verifying the data integrity and validations.
• ETL activities like retrieval of data from external file using external table for data transformation.
• Loading detailed atomic data into dimensional structures using SQL Loader utility
• Exporting the database using data pump expdp/exp utility.
• Balance requirements and realities to deliver a DW/BI solution that's accepted by business users and that supports their decision-making.
• Accomplished database design, programming, data architecting, and SQL tuning. Created Oracle and SQL Server database objects as a part of a Web-based application. Worked with different types of source data such as flat files and XML. Utilized Oracle database DBMS packages for creating and parsing XML data.
• Structure dimensional models around business processes.
• Creating sample data for unit and integrated testing for end-to-end process.
• Perform functional testing to ensure technical accuracy based on functional specification document.

Environment: SQL Server 2005/2008/2012/2014/2016 , SQL Server Reporting Service (SSRS), SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), SQL Profiler, Microsoft Visio, MS Office 2003.

Confidential

MS SQL Developer

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database viewsto implement the business logic and also created clustered and non-clustered indexes.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions.
• Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for implementation of data viewers,Logging, error configurations for error handling the packages. Involved in complete life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.
• Created and maintained data flow diagrams for existing and future ETL processes.
• Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports
• Publishing PDF Reports obtained from Report Server on to SharePoint Portal

Environment: SQL Server 2005/2008/2012, SQL Server Reporting Service (SSRS), SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS)