We provide IT Staff Augmentation Services!

Sr Sql Developer Resume

Charlotte, NC

SUMMARY:

  • Over 8 years of professional experience as a SQL Developer/ETL/Business Intelligence/Teradata/InformaticaDeveloper, responsible for designing and developing T - SQLand PL-SQLqueries, creatingETL packages, and generating business reports using SQL Server Management Studio(SSMS), MS BI Suite withextensive experience inadministrating anddesigning databases and development of DB objects such as Stored Procedures, Indexes, Functions, Views,Triggers, and Performance Tuning.
  • Extensively worked on writing complex SQLqueries (cursors, ref cursors, sub queries, correlated sub queries and provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs using T-SQL.
  • Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
  • Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man), Teradata parallel support and Unix Shell scripting .
  • Strong experience with ETL tool Informatica 8.1/7.1/6.2, AB intio and DATA STAGE 8.0.1
  • Strong experience in Extraction, Transformation and Loading ( ETL ) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
  • Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata , VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
  • Built interactive websites using ASP.Net - that permitted users to enter a specific set of criteria for retrieving data and send their queries to the underlying database on the web server.
  • Possess strong programming and communication skills with great attention to detail.
  • Proficient with analyzing/validating incoming data and generate reports to monitor bad exceptions as well as provide statistics being reported to the lead management.
  • Built dynamic as well as ad-hoc reporting solutions using SQL Server Reporting Services.
  • In-depth knowledge in the OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created ad-hoc reports as well as canned/recurring reports (such as daily, monthly, and annual) from simple drilldowns to complex summaries with charts/graphs, cross-tabs, running totals, multiple sections, etc.
  • Involved in the ETL process of data from various warehouses using SQL Server Integration Services as well aswith IBM’s DataStage.
  • Utilized PowerBI to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-users to make filters.
  • Thorough knowledge of C# programming concepts, SDLC, testing and debugging methods, system design, and implementation, database system, including DB2 and relational databases, program documentation, web and desktop application development.
  • Comprehensive knowledge on Normalization and Relational Database Management Systems.
  • Highly skilled in performing Data Analysis and migration across multiple data storage entities.
  • Extensive experience in handling all functions in MS Excel, Access database and performed large-scale migrations across spreadsheets and database applications.
  • Efficient in performing Unit Testing, Integration Testing and Performance Testing.
  • Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
  • Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
  • Abiltity to work independent and as part of a team in fast paced environment, worked with various levels of management and maintain timelines and deliverables. Good understanding of Health care, Financial, Retail andmortgage servicing domains.
  • Highly motivated, multi-tasking programmer capable to adapt and work on multiple technologies.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server, Teradata, Oracle10g/11g

MS Office: MS Word, Excel, Access, Powerpoint

Languages: T-SQL, PL/SQL, HTML5, C#,Python, .NET

Reporting: SQL Server Reporting Services(SSRS), SQL Server Analysis Services, SAP Crystal Reports, PowerBI, Tableau

ETL Tools: SQL Server Integration Services(SSIS), IBM DataStage

Development Platforms: SQL Server Management Studio, SharePoint 2016/2017, Windows Server 2017 R2, Team Foundation Server.

EXPERIENCE:

Sr SQL Developer

Confidential, Charlotte, NC

Responsibilities:

  • Developed complex data solutions using SQL Server/Oracle applications in accordance with business rules, system technical requirements, specifications, and client security standards.
  • Worked on highly scalable web services and project forecasting measures in Tableau and in conjunctions with Financial Risk Management.
  • Worked extensively on Relational database management solutions to process data and to introducing data independency between multiple applications spanning various technologies.
  • Create ad-hoc reports as well as canned/recurring reports (such as daily, monthly, and annual) from simple drilldowns to complex summaries with charts/graphs, cross-tabs, running totals, multiple sections, etc.
  • Design and develop XMLA protocol for SQL Server Analysis Services for interaction between client application and instance of Analysis Services.
  • Implementation of C# programming concepts, SDLC, testing and debugging methods, system design, and implementation, database system, including DB2 and relational databases, program documentation, web and desktop application development.
  • Explored data in a variety of ways and across multiple visualizations using PowerBI Strategic expertise in design of experiments, data collection, analysis and visualization.
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Used Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems(oracle 10g,DB2,SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Worked on the teradata stored procedures and functions to confirm the data and have load it on the table.Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
  • Developed ETL process to source, filter, and transform data from various warehouses using SQL ServerIntegration Services as well as with IBM’s DataStage.
  • Built dynamic as well as ad-hoc reporting solutions using SQL Server Reporting Services.
  • Develop the business functionality using Powerbuilder, .net and Oarcle.
  • Translate technical specifications into technical deliverables as T-SQL, .net & Oracle stored procedures.
  • Responsible for designing backend database structures for the Financial Risk Management sector and also generating stored procedures and triggers that are complex in nature for the software's maintenance purposes.
  • Responsible for writing clean and clear code adhering to coding standards and documentation of code and technical deliverables.
  • Develop complex functions, scripts, stored procedures and triggers to support application development with focus on re-usability and avoid duplication of code.
  • Develop UI interfaces and Database objects as part of many enhancements.
  • Extensively worked in developing complex and mission critical Stored Procedures and Functions in Oracle (12G and 12 C), Sybase
  • Responsible for running and monitoring applications on diversified operating systems Windows, Linux, and UNIX platforms.
  • Used Team Foundation Services and GIT tools to deploy code and branching code to be used across multiple teams and have a unilateral co-ordination during deployment phase.
  • The ledger data from received from an external warehouse and added filters during ETL process to retrieve only the needed information prioritize mapping between whatever available in the listed AU’s and where exactly the corresponding regions a specific finance calculation is stemming from.
  • Developed backend frameworkthat consolidates the list of all available AU numbers and co-relate which of the following 3 namely region,resolution SPOE and recovery SPOE that they come under to.
  • Trigger Forecast builds were then computed as part of any automated registers that provide market conditions on how to perceive the early warning indicators of potential stress. Examples of specific market condition include wholesale funding spreads and WFC stock price movements.
  • Since most of our operations involve transferring the balance ledger from oracle based platform to our dedicated database for UI and other forecast based applications, and also involved extensively in the developmentof ETL package that drives and audits daily transactional data and whenever Finance has availability of those metrics in their system, we try to pull it into SQL Server to generate forecasts.
  • Developed stored procedures which involves identifying scenarios, cashflows, and projecting Risks and what steps the bank might need to accommodate during the time of crisis and consumer needs are subjective to be protected.
  • It also involved understanding capital and liquidity needs, maintaining contingency plans through stress and extreme stress, preparing for firm failure, and having the capacity to operate through failure is a core firm capability.
  • Predicting risks in a financial world involves projecting balances based on a given growth rate and interpreting how the various legal entities within a bank operates. For this purpose, I was involved in developing framework that revolves around calculating growth rates of their balances that needs forecasting through 9 quarters to determine risk and remedies to recover during the times of crisis.
  • Developed an ETL process to compute dynamic error handling capabilities based on what the business operations provide on mapping constraints to determine if technology needs to process a bad file or not.
  • Developed Email Functionality to enable and isolate records that are needed further review by the business and provide fixes to be processed again. Growth rates will be calculated on a defined grain to be computed balances through 9 quarters to determine how each nodes be at a stable point during a risk analysis situation.
  • Developed DB model to implement other forecast files and implement different model on how to determine validation. Once everything is being set, the automated trigger will begin as soon as File is being received by system and all the grain loads and processing of growth rates will be taken care automatically.

Sr SQL Developer

Confidential, Jacksonville, Florida

Responsibilities:

  • Created and implemented jobs using T-SQLto oversee the medical patents, timely doctor visits and insurance data that have been crosswalked with the exact facility information in our tables.
  • Developed HNI and DFT import process in order to keep track of insurance spending and develop strategies to provoke cost effectiveness to all the insurance providers.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
  • Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
  • Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router and Update Strategy in Informatica .
  • Developed, troubleshoot and implemented new and/or updates to application on ASP.NET server and its SQL database.
  • Developed dynamic and ad-hoc reporting for business needs and transactional data using SSRS.
  • Integrated and extracted source data using SSIS ETL tool and stored procedures created in SQL Server Management Studio (SSMS), and developed transformation logic and designed ETL packages
  • Involved in various phases of application life cycle; tasks included research, gathering, modelling, analysis, designing, development, debugging, testing, and deployment.
  • Developed administrative web system using ASP, VBScript, and SQL Server.Handled modules related to project development for logistics applications that includes analyzing, developing, debugging and testing code, in the real time application environment and designed Data Modeling, Design Specifications and to analyze Dependencies.
  • Generated documentation for system design, specification, and testing.

Sr BI/SQL Developer

Confidential, Jacksonville, Florida

Responsibilities:

  • Coordinated with users in analyzing business requirements and translating them to technical specifications.
  • Developed dynamic and ad-hoc reporting for business needs and transactional data using SSRS.
  • Designed and developed complex SSIS packages to extract data from various data sources especially from BlackKnight and FNMA loan entities.
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Developed mappings in Informatica using BAPI and ABAP function calls in SAP.
  • Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
  • Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
  • Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS)
  • Involved in various phases of application life cycle; tasks included research, gathering, modelling, analysis, designing, development, debugging, testing, and deployment.
  • Developed, troubleshoot and implemented new and/or updates to application on ASP.NET server and its SQL database.
  • Developed administrative web system using ASP, VBScript, and SQL Server.Handled modules related to project development for logistics applications that includes analyzing, developing, debugging and testing code, in the real time application environment and designed Data Modeling, Design Specifications and to analyze Dependencies.
  • Generated documentation for system design, specification, and testing.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in the development of a dynamic SSIS, SSRS project using SQL server database that projects the list of all borrowers who have made the trial payments pre-occuring to the Loss Mitigation Process using T-SQL as the programming language.
  • Designed SSIS Packages to transfer data from flat files to SQLServer using Business Intelligence Development Studio.
  • Assisting project manager in defining detailed specifications for specific functionality requirements as well as analyzing, designing, and encoding new systems using C# language.
  • Calculated number of trial payments were assigned to a list of Managers, SPOC, Directors using the Row Grouping functionality
  • Created sub-reports to link the numbers to direct the list of loans that have been assigned to the respectivemanagers.
  • Have created multiple parameters, functions, views and stored procedures to enable the complete functionality of the report.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Created SSIS Log Tracking database in SQL Server Management Studio (SSMS) containing multiple tables including Execution Status, Business Scope, Processing Log, Error Log, etc.
  • Involved in the creation of a dynamic report using SSRS that monitors the list of activities performed during theacknowledgement, decision letters of Foreclosing accounts.
  • We worked on gathering intensive loan and payment level information to suggest which accounts were vulnerable to foreclosing and bankruptcy process.
  • Developed Pie, bar charts with sub report functionality to create the dashboard.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in the development of the report which keeps track of all portfolios that covers the Freddie Mac loans warehoused within the Black Knight entity.
  • Calculated the financial turnover each quarter which were still using GTA loans.
  • Segregated the loans to generate the total portfolio list which were MSP and GTA independent.

Business Intelligence/SQL Developer

Confidential, KS

Responsibilities:

  • Involved in several application life cycle: development, enhancement, testing and research.
  • Developed business logic using stored procedures in SQL Server/ Oracle 11G and involved in the database/schema design for several Kansas State Projects.
  • Developed, troubleshoot and implemented new and/or updates to application on ASP.NET server and its SQL database.
  • Developed mappings in Informatica using BAPI and ABAP function calls in SAP.
  • Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
  • Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
  • Developed and deployed dynamic domain-driven reports using SQL Server Reporting Services.
  • Involved in Data Analysis and Data Migration and also reported to Senior Architect through professional documentation.
  • Integrated and extracted source data using SSIS ETL tool and stored procedures created in SQL Server Management Studio (SSMS), and developed transformation logic and designed ETL packages.
  • Generated multiple Enterprise reports using SSRS and SSAS and Report Builder 2.0 from SQL Server Database OLTP and SQL Server Analysis Services Database OLAP and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports Hyperlink etc.
  • Involved in Unit and Regression Testing for several website development projects.
  • Involved in Fine Tuning, Performance and Query optimization of the Database as required by the application.
  • Application Life cycle management using Microsoft Team Foundation Server.
  • Continuous learning about new emerging technologies and frameworks using PluralSight.
  • Involved in the Structure/Schema Design using Microsoft’s SQL Server and developed a domain driven
  • Reporting solutions using SSRS for the summary and percentages of Reports corresponding to the variousMCO’s.
  • A secure website application for Kansas Dept. of HealthCare Admins (KDHE) and Managed CareOrganizations (MCO) to create report cycles, submit reports and generate administrative status reports.
  • Structure involves a set of MCO’s who are allowed to submit Financial and HealthCare Reports for fiscal year or a quarter satisfying deadlines where the KRO(KanCare Report Owner) are eligible for processing the reportsbased on regulations by the Kansas Dept. of Healthcare.
  • Developed and deployed ad-hoc reports based on the organizations’ demand to interlink financial data andsubmission frequency on quarterly basis.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Developed, troubleshoot and implemented new and/or updates to application on ASP.NET server and its SQL database.
  • A robust and dynamic website for managing scholarship applications and manage annual performance data for eligible students in the state of Kansas.
  • Various programs and Student-Parent survey structures were designed in order to efficiently track student’s performance. Reporting were done to project how every student would qualify for the scholarship based on predefined criteria.
  • Involved in various phases of application life cycle; tasks included research, requirement gathering, analysis, architecting, designing, development, debugging, testing and deployment.
  • Architecting, designing, developing and maintaining business layer and infrastructure layer using .NET, SQL Server, Stored Procedure, SSRS,SSAS etc.
  • Wrote conversion scripts using SQL, PL/SQL stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in the development team to build a website for the Kansas Department of Public Water System to compute Water rates based on the financial data and expenditures and forecast results up to 10 years.
  • Generating and maintaining documents for requirements, system designing, function specifications, source code reviews, coding rules, testing cases etc.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in the development of a robust website which allows faculty to manage and assess performance of students for each programs and also allows students to view and validate those assessment results. The website also comprised of assessing evaluations specific to multiple terms, multiple professors with wide range of data.
  • Developed mappings in Informatica using BAPI and ABAP function calls in SAP.
  • Involved in the development of backend design, stored procedures and reporting using SSRS which is used to efficiently project assessment statistics of both faculty and the students to the user.
  • Periodically met with associates of the website administrators for requirement gathering system design.
  • Generated and maintained documentation for system design, specification and testing including source code review, Unit testing, Quality testing and user acceptance testing.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS) and integrated and extracted source data using SSIS ETL tool also developed transformation logic and designed ETL packages.
  • Developed mappings in Informatica using BAPI and ABAP function calls in SAP
  • Involved in the development of an offline website which involves an administrator to log mental health related issues of senior citizens and improve effectiveness in maintaining health insurance and medical treatments based on the records obtained.
  • Managing and generating team members’ tasks and projects using TFS and developed a UI web application using ASP.Net for patients to view their medical profile.
  • Generating and maintaining documents for requirements, system designing, function specifications, source code reviews, coding rules, testing cases etc.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in the back end development of a website which designed interfaces for EHR modules such as growth chart, immunization, CCD, and Appointment viewer along with the configuration modules.
  • Architected, designed and developed infrastructure using SQL Server, Stored Procedure and Telerik Controls.
  • Developed reporting solutions to project growth chart for EHR modules on monthly basis.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in the development of a desktop web application that facilitates to store and process medical assessment information either online or offline which thus synchronizes information between local storage and server.
  • Involved in development, research about implementing end-to-end security feature using JWE.
  • Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.
  • Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
  • Developed triggers using SQLite to manage and maintain data dynamically.
  • Involved in the creation of new tables, indexes required for new features and altering the tables for change request features using T-SQL for writing Stored procedures, triggers, functions and views and SSRS to generate dynamic and adhoc reporting solutions.
  • Involved in the development of a robust website which allows managing online trainings across multiple user platforms.
  • Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS) and integrated and extracted source data using SSIS ETL tool also developed transformation logic and designed ETL packages.
  • Tasks included validation and UI testing for various modules under the training environments to customize results based on the user profile and eligibility.
  • Enhanced Telerik Controls for better user experiences like Grid Search.
  • Wrote packages to fetch complex data from different tables using joins, sub queries and database links.
  • Involved in data migration tasks to import user profile data across multiple training websites as well as profile merging.

Datawarehouse Engineer

Confidential

Responsibilities:

  • Handled various customer related issues through in the aspects of stock transactions and report maintenance.
  • Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS) and integrated and extracted source data using SSIS ETL tool also developed transformation logic and designed ETL packages.
  • Developed mappings in Informatica using BAPI and ABAP function calls in SAP.
  • Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
  • Implemented complex business rules in Informatica Power Center by creating re-usable transformations, and robust Mapplets.
  • Developed, troubleshoot and implemented new and/or updates to application on ASP.NET server and its SQL database.
  • Skilled in performing Stock Transaction analysis from source data, filtering it based on user's constraints.
  • Intensive training and worked in various Datawarehousing tools and OLAP concepts.
  • Good experience on performing load operations using BTEQ Utilities in Teradata.
  • Has experience on ETL tools such as Datastage and Informatica with hands on experience in Unix Shell Scripts.

Hire Now