SUMMARY:

• Experience in all phases of the software development life cycle such as Requirement Analysis, Design, Development, Testing using SQL Server. Experience in Waterfall and Agile working models.
• Develop Tables, Indexes, Stored Procedures, Functions, Views, Triggers and other objects utilizing latest DML and DDL syntax.
• Building and maintaining SQL scripts in Microsoft SQL Server 2008+, SSIS packages, SQL Jobs, complex SQL queries for data analysis and data extract.
• Design Indexes for existing applications, choosing when to add or remove indexes.
• Proficient in ETL Extract - Transform - Load) using SQL Server Integration Services 2014 (SSIS).
• Expert in Extracting and Transforming data using SSIS in SQL Server 2008, SQL Server Import Export, Bulk Insert and BCP.
• Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).
• Expert in Extracting and Transforming data SSIS in SQL Server, SQL Server Import Export, Bulk Insert.
• Migrated DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Experienced in Database Programming - Stored procedures, Functions, Triggers, Cursors using T-SQL.
• Created SSIS Packages to load data into database from various sources.
• Scheduled the jobs to do these tasks periodically. Identify, track, and resolve issues and challenges that arise throughout the SDLC while maintaining schedules, cost and quality.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Good experience in SSIS transformations and delivered many reports by using SSRS MSBI tools

TECHNICAL SKILLS:

Languages: T-SQL, SQL, PL/SQL, Java

RDBMS: SQL Server 2008/2012/2016, MS Access, DB2

Development Tools: Visual Studio

Tools: VSS, Jira

Reporting Tools: SSRS, BIDS,Tableau

Database Tools: MS SQL Server Enterprise Manager, SQL developer, SQL Profiler

SQL Server Tools: Profiler, Query Analyzer

Services Database Engine: SSIS, SSRS, SSAS

Operating Systems: Windows

PROFESSIONAL EXPERIENCE:

SQL Developer/Reports

Confidential

• Developed cost effective software solutions for database creation, migration, replication and recovery for clients at Hillview Inc. using Microsoft SQL platform
• Involved in full development cycle of planning, analysis, design, development, testing and implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constrains in data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL programs required to retrieve data using cursors and exception handling.
• Designed data modeling design specifications and to analyze dependencies.
• Creating indexes on the table to improve the performance by eliminating the full table scans and views for hiding the actual table and to eliminate the complexity of the large queries.
• Fine-tuned procedures SQL queries for maximum efficiency in various databases using oracle hints, for rule based optimization.
• Create some customer reports and forms for end users to check the details and errors.
• Worked closely with the clients to establish problem specifications and system design.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring sessions as well as performance tuning of mappings and sessions.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Monitor data processing, maintain code and work with Operations Team
• Analyzed the business requirements and systematically designed a database for clients, employed best practices in creating a complete solution to meet customers requirement.
• Employing system development life cycle from the conceptual to physical phase of customers requirement.
• Creating schemas for tables, stored procedures, views, clustered and non-clustered indexes and triggers.
• Created numerous simple to complex queries involving self joins, correlated subqueries. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• Utilizing SSIS in ETL data extraction, transformation and loading.
• Developed a backup and recovery plan based on the data availability requirements of the library and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies.
• Created and designed SSRS reports based on specs with charts and figures. Created report templates.
• Design and implement reporting solution architecture
• Wrote SQL queries for data manipulation to meet data specifications for reports.
• Developed stored procedures, queries, views and Parameters necessary to support SSRS reports
• Deploy complex reports in SSRS server and converted reports from Microsoft MS to SSRS.
• Responsible for prompt resolution to issues during UAT and QA phase. Completed report enhancements and bug solution when issues were forwarded by testers before Go-live
• Employing Service Brokers enabling HTTP support and establishing Notification Services

Database Developer

Confidential

• Designed database, tables and views structure for the application.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and for the application.
• Utilize DDL,DML,DCL,TCL in data manipulation
• Responsible for optimizing SQL queries, stored procedures to improve the performance time.
• Extract data from a data source, transform and load, using SSIS (ETL)
• Responsible for maintaining data referential integrity and backup within the centralized database
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures
• Developed reports on the report server for onward implementation
• Perform requirements analysis, detail design, troubleshooting, source code construction, system testing, integration testing and implementation for reports/data
• Interact with customers and other team members when developing ETL code, and researching and troubleshooting technical issues
• Data Grids, Data Views, and Datasets were used to display Reports which were generated using stored procedures.
• Stored Procedures, Triggers and Views for the data access were implemented in SQL Scripts and tested in SQL Server.
• Developed Custom reports using stored procedures.
• Involved in analyzing, designing and prototyping the initial design.
• Designed and implemented a three-tier architecture that included Presentation, Business and Data Access Layers.
• Developed various subprograms, procedures, packages, functions, database triggers and DDL, DML complex queries in SQL.
• Create and Manage schema objects, Indexes, sequences & Views.
• Wrote complex SQL queries by using joins.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote many Adhoc queries for testing the old verses new architecture data to determine if the new system could meet the requirement of minimal loan failure.
• Designed and developed Packages to import and export data from MS Excel, SQL Server and Flat files.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.