We provide IT Staff Augmentation Services!

Database Engineer/database Developer Resume

Houston, TexaS

SUMMARY

  • Extensive programming experience (8+) as Database & Report Developer in Microsoft SQL Server 2008/2012 using T - SQL and Business Intelligence Data Tools and various platforms.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Good experience in Design, Development, Implementation and Testing of Database systems using MS SQL Server 2005/2008/2012 DDL, DML, DRL and DCL commands for various Data Warehouse and business applications.
  • Worked with databases like SQL Server 2005/2008/2012 , Oracle 10g/ 9i, MS Access and Expert in MS Office 2010.
  • Exquisite skills in Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling native Backup/Recovery of databases, Database Maintenance Planning.
  • Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments like Data warehouse and reporting.
  • Experience in writing Complex T-SQL Queries, Dynamic Queries, Sub-queries, Complex Joins.
  • Utilize existing enterprise BI tool set (e.g., SQL Server Reporting Services, SS Analysis Services, SharePoint, and Crystal reports and Power BI, Tableau) and web services that provide standard analytic computations that can be leveraged in multiple BI solutions .
  • Utilize existing enterprise BI tool set (e.g., SQL Server Reporting Services, SS Analysis Services, SharePoint, and Crystal reports and Power BI, Tableau) and web services that provide standard analytic computations that can be leveraged in multiple BI solutions .
  • Expert in T / PL / MS SQL and database scripting.
  • Expert in Data Modeling and Multi-Dimensional Modeling.
  • Extensive experience in Database design using SQL, T-SQL in Stored Procedures, Views, Functions, Constraints (Primary Key, Foreign Key), Triggers and Batch Scripts.
  • Connecting to different data sources to blend and modeling Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server 7.0 and 8.2 for reporting and analyzing of data
  • Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in Tabular dimensional and multi-dimensional modeling.
  • Experience in Performance Tuning and Query Optimization.
  • Have reviewed various stored procedures with options, Function and T-SQL code and Improved the performance of queries by suggesting the DBA for appropriate Index, Views and Join Hints.
  • Performed Tuning on the T-SQL code and checked the values if it is retrieved appropriately. Have Analyzed the Execution Plan and Statistics to check if the values are retrieved fast.
  • Good knowledge in RDBMS concepts, data models, Star/ Snow Flake Schema.
  • Created database objects such as views, synonyms, Tables, Indexes, Sequences as well as custom packages tailored to business requirements.
  • Expert in Extraction, Transformation, and Loading (ETL) data from various data sources using SSIS. Created packages to extract data from Oracle, Flat file and load into MSSQL.
  • In SSIS I have worked with Lookups, Slowly Changing Dimensions, Fuzzy Lookup, Web Services, and Container and created Fact and Dimension Tables to use in Analysis Services (SSAS) for Creating Cubes and used that in Reporting Service (SSRS).
  • Developed reports on SSRS on SQL Server (2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cubes and Architecture.
  • Used SSRS and created Table Report, adding calculated Values, Using Document Maps, Tablix Report, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
  • Created reports that have been defined by business architect and generated canned reports.
  • Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
  • Build, Deployed and Published the Reports to Report Manager Website.
  • Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
  • Strong in Analytical, Technical Skills coupled with Good Communication and Interpersonal Skills and Ability to work in team environment and also individually.
  • Have good ability to gather the Requirements, Analyze, and Plan according to the deadlines, Develop Queries, Test and Maintain in future.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2005/2008/2012 /2016, Oracle 11i/10g/9i, MS- Access.

Languages: SQL, T-SQL, PL/SQL, EDI, C, C++, XML, JSON, API, .NET, Power BI, c#.

Operating Systems: Windows 7/ Vista/ XP.

Tools: Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio, Oracle, Report Builder 3.0

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) Report Manager, Tabular Analysis, ORACLE Report Builder, ORACLE Forms Developer, MS Excel.

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, TEXAS

DATABASE ENGINEER/DATABASE DEVELOPER

Responsibilities:

  • Responsible for supporting day-to-day operations attendant to a cyber security data mart utilized across the enterprise to depict business unit-level and centralized cyber readiness.
  • Maintained and enhanced a Kimball-based dimensional model integrating people, asset, usage, exception, compliance, patching, vulnerability, and myriad other cyber security data.
  • Supported and enhanced SSIS packages for staging, transforming, and loading data from a variety of cyber data streams, including SQL Server, Oracle, and web services sources.
  • Maintained system integrating over 15 distinct data sources spanning three environments (Development, Quality Assurance, and Production), supporting Integration Services Catalogs, environment variables, and scheduled jobs across multiple servers via SQL Server Agent .
  • Constructed new SSIS packages utilizing transformations including Conditional Split, Bulk Insert, Merge, Union All, Lookup, For Loop and For Each Loop containers.
  • Designed and implemented secure SQL Server views that expose integrated data to custom Spotfire and PowerBI analytics.
  • Performed extensive data analysis to investigate and resolve a wide variety of business problems, including exploratory opportunities to integrate new data sources, performance bottlenecks, and data discrepancies within existing sources.
  • Maintained, performed code reviews and builds for DDL, T-SQL, C# code, and SSIS packages in Visual Studio within TFS and Git/Azure DevOps .
  • Performed data validation and schema comparisons through SQL Server data validation tools.
  • Managed work using Agile Scrum methodology based on SAFe principles .
  • Participated in and lent expertise to numerous agile ceremonies, including planning iteration workshops, daily scrum, backlog grooming sessions, sprint planning, and sprint retrospectives.

Confidential

MS SQL Server Developer/ETL Developer

Responsibilities:

  • Developed SSIS packages for integrating data using OLE DB connection from many sources (Excel, CSV, Oracle, Flat file, Text format data) by using multiple tools like conditional split, Bulk insert, merge, Union All, Lookup, For loop and for each loop container.
  • Developed software to read data (backend for one User data entering tool) from XML files and loading into MS SQL Server tables.
  • In-depth knowledge and work experience of over 5 years in ETL, OLAP Cubes, BI Reports and Dashboards, Tableau, Power BI, Power Query, Power View, Power Pivot. (Microsoft BI Stack).
  • Used Power BI, Power Pivot and JET Reports (Excel Reporting) Tools for creating these BI Reports.
  • Created Ad hoc reports for equipment and notification reports using Power BI. Used SSAS tabular models at backend for data models and power view/power map for visualization (tables, score cards, charts)
  • Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements using Data Blending.
  • Oversee and maintain the company data warehouse infrastructure and develop new subject areas as required by the business.
  • Single handedly performed SQL Server upgrade from 2008 to 2014 version for the data warehouse, and SSIS packages and implemented an efficient data import process from the legacy database to the new database.
  • Successfully implemented ETL processes that used third party tools such as Win SCP, Kansans Checksum, Avaya ODBC to help the process fulfill the business needs.
  • Performed data validation and schema comparison by using data validation tools and wrote test scripts to ensure all records are migrated as well as column values were accurate.
  • Responsible for the 24/7 availability of the data warehouse and the daily processes that feeds the data warehouse.
  • Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
  • Developed SQL scripts to Insert/Update and Delete data in MS-SQL database.
  • Used Exceptional Handling and log in SSIS to handle errors and track the package execution.
  • Configure SSIS Package for run time Parameters and Config file.
  • Scheduled the SQL jobs and SSIS Packages using Job Controller (Enterprise Scheduler).
  • Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors, UDFs.
  • Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
  • Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Used TFS for configuration management.
  • Worked on fine tuning SQL Queries. Worked on creation of SSIS packages for loading data into the database.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Developed, monitored and deployed SSIS packages.
  • Scheduled and executed SSIS Packages using SQL Server Agent.
  • Migrated data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
  • Performed the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Worked on SSRS to display the data effectively in the form of reports.
  • Worked on SSIS to extract and load data.

Confidential, Long Island City, NY

MS SQL Server Developer

Responsibilities:

  • Created complex Stored Procedures, functions, triggers, views, and other SQL Joins for application using T-Sql.
  • Experience in Subscribing the Azure subscription and setting up Azure for Organization
  • Provided a Cost / Risk Conversion Analysis detailing the anticipated time and resources needed to potentially convert the existing Pentaho Kettle ETL framework over to an SSIS ETL framework.
  • Responsible for performance tuning and bug fix of the existing Pentaho Kettle installation.
  • Experience in writing T-SQL scripts, dynamic SQL, Constraints, relational database models, data dictionary and data integrity.
  • Designed and developed interactive dashboards that enabled stakeholders to focus on performance drivers.
  • Designed and developed Tableau Reports, Dashboards and Stories using visual design best practices .
  • Developed multiple processes of daily reports using SSIS and SSRS.
  • Created views for specific columns to maintain privacy of the customer data.
  • The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
  • Designed SSIS packages for synchronizing the data between two different servers.
  • Experience with creating complex SSIS Package using proper control and data flow elements with error handling.
  • Created numerous ad-hoc and canned Reports using SSRS.
  • Designed and developed matrix and tabular report with drill down, drill through and drop-down menu option.
  • Scheduled and maintained routine jobs, tasks, and alerts. For instance, an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
  • Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL Reporting Services.
  • Implemented various reports for the migration to SSRS.
  • Knowledge in creating Basic table report, adding calculated Values, Using Document Maps, Tablix Report, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
  • Involved in post deployment and maintenance of reports.
  • Developed ETL framework to extract and load the data from multiple database from SQL Server 2008 to File Server.
  • Good knowledge on auditing the data that is entered in the OLTP and updated in Data Warehouse and used in report.

Confidential, Madison, WI

SQL/BI Developer

Responsibilities:

  • Involved in requirement gathering, analysis, design, development and deployment.
  • Created SSIS Packages to load the data in to the target servers/locations and scheduled jobs to run ETL processes on hourly basis.
  • Responsible for writing T-SQL (DDL/DML) Queries, Stored Procedures, Views, Functions and Triggers.
  • Worked extensively with debugging, defect tracking and troubleshooting issues.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Developed different types of tabular reports, matrix reports (crosstab or pivot), charts and graphs, reports that aggregate data, reports containing parameters and groups, reports containing totals and subtotals, drill-down reports and ad-hoc reports using SQL Server 2008 R2 Reporting Services.
  • Designed and created reports and distributed reports in multiple formats such as Excel, PDF, XML, HTML, TIFF and CSV using SQL Server 2008 R2/2012 Reporting Services.
  • Developed different Scripts for the Data analysts for Verification of reports.
  • Worked on Side by Side migration of multiple SQL 2005 instances to SQL 2008.
  • Developed Entity-Relationship modeling for OLTP system using MS Visio 2007.
  • Created calculated measures for business calculations using complex MDX scripts
  • Implemented hierarchies on Cubes, wrote MDX for creating calculated measures.
  • Responsible for creating OLAP cubes for deep through analysis using SSAS 2008.
  • Created materialized views, dimensions and stored outlines for optimal performance.
  • Responsible for creating use cases for data mart and cube testing and also performed initial validations to check data consistency.

Confidential

SQL Server Developer, SSRS/ SSIS Developer

Responsibilities:

  • Implemented the business logic in stored procedures calling different functions.
  • Developed Query for generating drilldown/drill through reports in SSRS.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Worked on different database development environments like Dev, QA, Staging and Production.
  • Transformed data from various data sources like MS Excel, MS Access, and Flat Files to SQL Server using SSIS/DTS using various features like data conversion, conditional split, etc. Created derived columns from the present columns for the given requirements.
  • Scheduled and executed SSIS Packages using SQL Server Agent.
  • Worked with the calculated members (CTEs) and XML Data.
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Analyzed reports and fixed bugs in stored procedures.
  • Monitored and killed processes that create deadlocks within the database.
  • Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
  • Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
  • Responsible for developing processes, automation of maintenance jobs, SQL Server, locks and indexes configurations.
  • Extensively involved in the SSAS storage and Partitions, Aggregations, calculation of queries with SQL in SSAS.

Confidential

SQL Developer/MSBI Developer

Responsibilities:

  • Responsible for all technical SQL Server database operation, Checked the database consistency on a regular basis using DBCC commands to minimize complexity; performed and monitored daily database operations and set up backup schedule for various in-house databases.
  • Designed and developed various database objects like Tables, Stored Procedures, Rules, User Defined Data types and functions.
  • Modified current database by adding tables and relationships to support online system.
  • Responsible for all technical SQL Server database operation, Checked the database consistency on a regular basis using DBCC commands to minimize complexity; performed and monitored daily database operations and set up backup schedule for various in-house databases.
  • Defined constraints, rules, and defaults and involved in Database Normalization.
  • Developed SSIS packages for integrating data using OLE DB connection from many sources (Excel, CSV, Oracle, Flat file, Text format data) by using multiple tools like conditional split, Bulk insert, merge, Union All, Lookup, For loop and for each loop container.
  • Created several tables, views using SQL Server management studio, based upon the functional specifications and primary key & foreign key constraints.
  • Experience in building star and snowflake schema depending on the business data requirements.
  • Scheduled nightly jobs for some of the process to run for the data flow.
  • After creating the packages deployed the packages into management studio.
  • Ability to run the packages from various methods like XML, cmd prompts, Sql Server.
  • Customized existing Reports and developed new Reports to suit client requirements. Also created the test scripts for the generated final Reports.
  • Used various types of reports layout options like charts (bars, lines, pie etc….), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
  • Formatted the reports using Global Variables and expressions.
  • Experience in deploying the created Reports in various sources like Web Browser and XML.
  • Experience in developing custom reports and many types of Tabular Reports, Matrix Reports, and Drill down Reports, Parameterized, Conditional and Sub Reports using SQL Server Reporting Services (SSRS) in Business Intelligence.

Confidential

Jr. SQL Server Developer

Responsibilities:

  • Participated in design of the database tables. worked on creation of SSIS packages for loading data into the database. Worked on creation of SSIS packages for loading data into the database.
  • Worked on fine tuning SQL Queries.
  • Involved in creating database objects - Tables, Stored Procedures, Cursors and Triggers.
  • Involved in health of DB servers, databases, performance, availability, security, upgrades, etc. and monitoring status of Maintenance jobs including schedules to run daily and on weekends (tasks like rebuilding Indexes, Shrink Database and Database complete backup)
  • Checked the database consistency on a regular basis using DBCC commands to minimize complexity; performed and monitored daily database operations and set up backup schedules.
  • Involved in creating the database architecture and the database schema.
  • Involved in performance tuning of SQL queries and critical components.
  • Worked on SSIS to extract and load data.
  • Part of Developing Business Layer and Data Access Layer to Fetch Data from corresponding lists and display in Checked the database consistency on a regular basis using DBCC commands to minimize complexity; performed and monitored daily database operations and set up backup schedules
  • Checked the database consistency on a regular basis using DBCC commands to minimize complexity; performed and monitored daily database operations and set up backup schedules.
  • Worked on SSRS to display the data effectively in the form of reports.

Hire Now