We provide IT Staff Augmentation Services!

Sr. Database Developer Resume

3.00/5 (Submit Your Rating)

Atlanta, GeorgiA

SUMMARY

  • Senior SQL Server Developer with over 5 years of experience with strong background in Analyzing, Designing, Developing, Administering, Implementing and Testing of Client/Server application’s using MS SQL Server 2012/2008(R2)/2008/2005 and its suite of products SSIS, SSAS, and SSRS and BI - ETL experience using Pentaho Data Integration (Kettle and Spoon)
  • In depth knowledge of SQL server / T-SQL programming. Involved in creating database Tables, Views, Triggers and Stored procedures in T-SQL as required for enhancements and change requests.
  • Experience in Database Development, Modeling, with good understanding of Normalization /De-normalization, Normal Form and database design methodology.
  • Expertise in utilizing Lookups, sorting, filtering, implementing pivot tables, understanding Excel data item and project status report compiling.
  • Migration of Data from one database to another new or existing database or up gradation of Facets Database using SQL Loader Tools.
  • Proficient in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
  • Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.
  • Experience in creating KPI's, Aggregation, Perspectives, Partitions in CUBE using SQL Analysis Services.
  • Extensive knowledge of programming UNIX and other high-level languages.
  • Proven mentor and trainer, skilled at communicating with all organizational levels and cross-functional teams to develop a shared vision and foster a culture of excellence.
  • Generated periodic reports based on the statistical analysis of the data from various time frames and division using SQL Server Reporting Services (SSRS), Developed various operational Drill-through and Drill-down reports using SSRS.
  • Implemented high availability solutions, including Clustering, Database Mirroring (Synchronous and Asynchronous modes).
  • Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps and hadoop-hdfs-hive based data transformations.
  • Strong expertise in writing PL/SQL scripts, functions, stored procedures, complex SQL queries, PL/SQL analytical functions, hierarchical, parent-child queries.
  • Expertise in creating, monitoring and optimizing the performance of the Queries using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views (DMV's).
  • Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
  • Involved in upgrading and migrating servers and databases from earlier versions to latest versions.

TECHNICAL SKILLS

  • MSSQLServer (2016/2014/2012/2008 R 2/2008/2005/2000 )
  • MS Access
  • Oracle 11g.
  • Windows servers 2012/20 / NT.
  • SQL Query Analyzer
  • SQL Enterprise Manager
  • Management Studio
  • SQL Server Query Editor
  • Solution Explorer
  • Analysis Manager
  • Reporting Server
  • SQL profiler
  • SQL Mail. SQL Server Integration Services (SSIS)
  • Data Transformation Services (DTS)
  • Import Export Data
  • Bulk Copy Program (BCP)
  • SQL ServerReporting Services (2016/2014/2008/2005/2000 )
  • MS Access. HTML
  • DHTML
  • XML
  • CSS
  • PERL. SQL
  • T-SQL
  • PL-SQL
  • C. Erwin
  • OLAP & OLTP
  • Adobe Photoshop
  • Adobe Flash
  • Tortoise SVN racle 11g
  • TOAD
  • SQL Developer
  • UNIX
  • LINUX
  • PENTAHO PDI

PROFESSIONAL EXPERIENCE

Sr. Database Developer

Confidential, Atlanta, Georgia

Responsibilities:

  • Defined and designed the data sourcing and data flows, data quality analysis.
  • Participated in the Data Modeling to generate target database layout use for the data marts.
  • Identified, mapped data sources from homogenous data sources to the EDW.
  • Created Logical and Physical design of the data warehouse and Operational Data-base Store (ODS) in SQL Server 2016.
  • Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations
  • Designed Stored Procedures, Triggers, Views and Queries, created indexes, constraints and rules.
  • Designed and developed SSIS packages for loading data from ODS to Data Ware-house.
  • Performed various SSIS transformations before loading such as Derived Column, Slowly Changing Dimension etc.
  • Designed dynamic stored procedures to carry out complex cleaning and data scrubbing transformations.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
  • Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
  • Implemented and maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
  • Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
  • Implemented new features in SQL Server 2016 like Incremental package deployment, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
  • Performed data partitioning for efficient management of database tables and indexes.
  • Extensively working on performance issues like update statistics, Auto Stats. Coordinated with QA team for QA demo and executed Ad hoc test cases.

Environment: MS SQL Server 2016, T-SQL, SQL Server Data Tools, SSIS, SSRS, MS Excel, Unix, Linux, SQL Analyzer and Enterprise Manager, SQL Agent, TFS, toad, Microsoft Visual Studio 2017/2016, Tortoise SVN, Oracle 11g, SQL Developer

Pentaho/ Data Warehouse Developer

Confidential, Atlanta, Georgia

Responsibilities:

  • Gathering requirements from Business Users, conversion of business requirements to Pentaho PDI designs.
  • Interact with functional business units to analyze, gather and prioritize business and reporting requirements.
  • Formulated and provided status updates on project plans and schedules to meet goals/objectives and assumed leadership role in design, implementation, testing, and roll-out of enterprise data warehouse and data marts.
  • Created and enforced corporate standards for data warehouse design and data integrity and ensured data architecture supports existing and future requirements of evolving business model.
  • Evaluate and analyze existing OLTP databases and develop/maintain integrations to data warehouse by understanding OLTP and OLAP designs.
  • Transferred data from various data sources / business systems including MS Excel, MS Access, and Flat Files etc. to SQL server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
  • Used various SSIS transformations like Conditional Split, Multicast, Fuzzy look up etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into Data warehouse.
  • Designed Dynamic SSIS Packages to transfer data crossing between platforms, validate data during transferring and archived data files for different DBMS.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Converted existing SSIS packages to Pentaho 5.4 Data Integration Jobs (Pentaho transformations and Jobs)
  • Used the Pentaho Enterprise Repository to: Create folders, Store transformations, Jobs, move, lock revise, delete and restore artifacts.
  • Used Pentaho Data Integration/Kettle to design all ETL processes to extract data from various sources including live system and external files and cleanse and load the data into target data warehouse.
  • Created cubes with Start schema in SSAS/Pentaho and developed SSRS report based on the cubes.
  • Migrating data from traditional warehouse to Google Cloud Platform (GCP) with the help of Google Big query using integration software products like Talend, Pentaho which thereby helps to structure the information logically.
  • Involved in User Acceptance Training (UAT) with user to create reports using Report Builder tool.
  • Wrote UNIX Shell Scripts for file validations and scheduling jobs and for preprocessing and post processing of files.
  • Generated reports using Global Variables, Expressions and Functions for the reports. .
  • Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS.
  • Used performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.

Environment: Windows 2012R2/2012/2008R2, MS SQL Server 2014/2012, T-SQL, SQL Server Data Tools, SSIS, SSRS, MS Excel, Pentaho, Pentaho Data Integration, Kettle, Spoon, Unix, Linux, SQL Analyzer and Enterprise Manager, SQL Agent, toad, Microsoft Visual Studio 2014/2012, Tortoise SVN, Oracle 11g, SQL Developer, Data Studio, Tableau

SQL Server Developer

Confidential, Atlanta, Georgia

Responsibilities:

  • Planning, designing, developing and testing software systems or applications for software enhancements and new products.
  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
  • Involved in developing T-SQL stored procedures, triggers, views, and Creating/Updating tables for data loading, transformation and data extraction.
  • Created, tested and executed entity relationship schemas, table creation, Indexing, Primary Key, Unique Key, Foreign Key, Default, Check constraints, Sequences, Views, and Queries
  • Created, developed and managed internal procedures for various job functions and triggers to establish data integrity and performance management of database updates and querying.
  • Designing, Developing, Implementing and Configuring complex SSIS packages to export and import data from CSV files, Text files and Excel Spreadsheets and load them on to the Database using transformations.
  • Creating Control Flow, Data Flow Tasks, Workflow and Event Handlers at required intervals using SQL Server Agent.
  • Creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Script Task, Conditional Split, Derived Column, Fuzzy Lookup, Partition task and For-Each loop condition, merge and union all tasks.
  • Involved in ETL architecture enhancements to increase the performance using query optimizer, Event Handlers and Error Handling through SSIS packages.
  • Co-ordinated with the functional team to gather the requirements from the business users for designing various types of reports as per the business needs and developed different types of reports like Drill Down, drill through, sub reports, Cross tab, bar graphs, Pie charts, ad hoc reports and parameterized reports using Advanced extensible SSRS reporting skills.
  • Deploying the SSIS Packages and SSRS reports in Different environment servers.
  • Ensured effective and reliable backups are being performed and distributed properly.
  • Implemented Disaster Recovery for business contingency on mission critical Database servers and application by integrating Processes and people with zero down of business process.
  • Performed performance tuning by analyzing indexes, queries, table sizes using SQL Profiler and Query Execution plan tools.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval and also optimized queries by looking at Execution Plan for better tuning of the database.
  • Provide input to training and/or documentation materials regarding latest technical and functional design changes.

Environment: Windows 2012R2/2012/2008R2, MS SQL Server 2014/2012, T-SQL, SQL Server Data Tools, SSIS, SSRS, MS Excel, SQL Analyzer and Enterprise Manager, SQL Agent, Microsoft Visual Studio 2014/2012, SharePoint, Tortoise SVN, Oracle 11g, SQL Developer

Application Architect

Confidential, New York City, NY

Responsibilities:

  • Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
  • Identified various data sources, formulated data dictionaries and developed data models (physical/logical data models) based on the given requirements.
  • Developed complex Stored Procedures, triggers, Indexes and views for the application using TSQL.
  • Executed Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
  • Created ETL processes using SAS Enterprise Guide/Base SAS (Windows + Unix) to integrate data from Tera data, Excel and SAS to create a SAS Reporting Repository/Data- mart.
  • Experience in querying any ODBC database and exporting data from the database to a file on a PC using Tera data SQL Assistant.
  • Used Pentaho Data Integration Designer to create ETL transformations.
  • Developed ETL transformations that sourced from a variety of Heterogeneous sources including Microsoft Access, Text files, CSV files.
  • Implemented user level security by creating a table that stored usernames, user groups and their specific permissions.
  • Created dashboards in Pentaho using Pentaho Dashboard Designer.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc.
  • Developed, monitored and deployed SSIS package to load data from CSV files and SQL Server 2005 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate and Pivot Transformation.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
  • Monitored SQL Server logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.
  • Experience in building the necessary components like Tabular, Matrix, Grid, chart, pivot, parameterized, drill through, drill down reports which are associated to Store / Album using Blue light and SSRS.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.
  • Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
  • Performed operations like Datareconciliation, validation and error handling after Extracting data from Tera Data source into SQL Server.

Environment: Windows 2012R2/2012/2008R2, MS SQL Server 2014/2012, T-SQL, SQL Server Data Tools, SSIS, MS Excel, SQL Analyzer and Enterprise Manager, SQL Agent, Microsoft Visual Studio 2014/2012, SharePoint, SQL Developer, Pentaho, Kettle, Spoon, Tera data SQL Assistant, SAS Enterprise Guide, UNIX, LINUX

Senior SQL Server Developer

Confidential, Buffalo, NY

Responsibilities:

  • Interacting with the Business Users and Project Managers to analyze the business requirements and transform the business requirements into the technical requirement in alignment with technical architecture.
  • Designing, Developing, Implementing and Configuring complex SSIS packages to export and import data from CSV files, Text files and Excel Spreadsheets and load them on to the Database using transformations.
  • Served as a point of contact for CMS and trading partners to do the testing for various types of claims and real time transactions for Medicare and Medicaid programs in FACETS.
  • Performed performance tuning by analyzing indexes, queries, table sizes using SQL Profiler and Query Execution plan tools.
  • Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
  • Involved in developing T-SQL stored procedures, triggers, views, and Creating/Updating tables for data loading, transformation and data extraction.
  • Creating Control Flow, Data Flow Tasks, Workflow and Event Handlers at required intervals using SQL Server Agent.
  • Created Complex SSIS packages using Data transformations like Lookup, Script Task, Conditional Split, Derived Column, Partition task and For-Each loop container including Error handling.
  • Involved in implementing the OLAP processing for changing and maintaining the warehouse, optimizing dimensions, hierarchies, partitioning and adding aggregations to the CUBE using SSAS.
  • Conducting code review with team members before migration of code to Quality Assurance environment.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008)
  • Generated Periodic reports, Optimized reports, Drill through reports, Dill down reports, linked reports and Parameterized reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Created SQL agent jobs to schedule the package, stored procedure and various processes to be executed at regular time intervals.
  • Documented all the work and all the process of integration and reporting services for further references.
  • Collaborated with testers and administrators for troubleshooting performance issues and fine-tuning queries and stored procedures using SQL Profiler.
  • Involved in extracting, integrating, analyzing the Medicaid, New York state exchange data and generating reports.

Environment: Windows 2012R2/2012/2008R2, MS SQL Server 2014/2012, T-SQL, Facets, SQL Server Data Tools, SSIS, SSAS, SSRS, MS Excel, SQL Analyzer and Enterprise Manager, C#, SQL Agent, Microsoft Visual Studio 2014/2012, SharePoint, Tortoise SVN, Oracle 11g, TOAD, SQL Developer

Senior SQL Server Developer

Confidential, IL

Responsibilities:

  • Attended JAD sessions with Data Modeler’s, Business Analysts and created technical design documentation for ETL process.
  • Experience in Extract Transform and load (ETL) from databases by means of Excel, and in giving technological solutions and complete coding elements.
  • Established effective partnership with delivery management team and significantly improved communications and teaming for end-to-end global support across service delivery centers.
  • Designed and implemented a daily and monthly reporting process for pro-active service management.
  • Responsible for leading, coordinating and assigning tasks to onsite and offshore development staff for quality delivery to business users.
  • Implemented time-management and prioritization skills to ensure project deadlines were met and compiled reports of project status.
  • Ensured all Client Satisfaction goals, Service Level Agreements and Contractual Commitments were met.
  • Experience in source code migration from other source control tools Rational Clear Case to TFS.
  • Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components.
  • Effectively managed financial control of the delivery program meeting all budget requirements.
  • Created correlated and non-correlated sub-queries, triggers, stored procedures for complex business queries involving multiple tables by enforcing business rules via checks and constraints.
  • Participated in team meetings to discuss about enhancements of the existing reports, generating new reports, creating views for the report usage and also resolved issues related to complex reports.
  • Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
  • Overseeing and providing hands-on project management of medium to large projects including all phases of project life cycle and/or SDLC
  • Migrated data from heterogeneous data sources and legacy system to centralized SQL Server Database using SSIS.
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS and Scheduling the SSIS packages and Jobs.
  • Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
  • Implemented log shipping as a part of Disaster recovery solution.
  • Worked closely with SME’s, and Business users and resolved any business process related issues.
  • Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in SQL Server 2008 by using Query Analyzer and Database Engine Tuning Wizard.
  • Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measure groups and KPIs to analyze performance of Strategic Business Units.
  • Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
  • Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.
  • Performed daily tasks such as backup and restore by using SQL Server Management Studio.
  • Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: MS SQL Server 2012/2008 R2, SSIS, SSAS, SSRS, C#, MS Excel, Visual Studio, Erwin, Windows 2012/2008R2/2008, TFS, MS Visio, MS Access, ADO.Net, SQL server Profiler, MS Office, SharePoint, Tortoise SVN, SDLC

We'd love your feedback!