We provide IT Staff Augmentation Services!

Database Developer (sql, Oracle, Sql Server) Resume

Philadelphia, PA

OVERVIEW:

Senior software engineer with domain experience on healthcare applications catering to Claim Management System, Healthcare Practice Management System and DME Management

SUMMARY:

  • Over 9+ years of strong experience in analysis, design, development and implementation of software applications mainly in the field of Data Warehouse and Database application by using Microsoft SQL Server.
  • Proficient in Tuning T - SQL queries to improve the database performance and availability
  • Experience in SSIS (Integration Service) package design, constructing, and deployment.
  • ETL implementation using SQL Server Integration Services (SSIS).
  • Extensive experience to build stored procedures, functions, triggers and views in SQL-Server 2008/2012/2016
  • Extensive experience in Health Care, DME domain from order to claim processing.
  • Expertise in Transact-SQL (DDL, DML, DCL), Data Archiving of the database tables, SSRS Reports, Tableau Reports.
  • Possesses a firm grasp of database concepts and the T-SQL language including OLTP versus OLAP, clustered indexes vs. non-clustered indexes, Normalization versus Denormalization, and Data Warehouse methods.
  • Proficient in Relational Database Management Systems (RDBMS).
  • Experienced in taking ownership of IT projects starting with gathering business requirements, providing mockups of the deliverable, timeframe of delivery, development of solution, testing, setting up meetings to provide project status, assisting users with user testing, and delivery of the project requested.
  • Good Communication Skills and experience in working in Cross functional collaboration teams.

TECHNICAL SKILLS:

Software Methodologies: Agile, Scrum, Waterfall

Programming: MS SQL Server2008/2008 R2/2012,/2016 MySQL

Web Technologies: HTML5, Silver light.

Databases: MS SQL Server2008/2008 R2/2012, MySQL

Tools: Enterprise Manager, Profiler, Query Analyzer, SSRS,SSIS,SSAS RDBMS:MS SQL Server 2005/2008/2016 , MS Access, Tableau, Power BI, Team foundation Server

Operating Systems: Windows 2000/NT/XP, Windows 7, Windows 8, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Technologies: SQL Server 2017, SSIS, Tableau

Database Developer (SQL, Oracle, SQL Server)

Responsibilities:

  • Gather data from clients and prepare software requirements and specifications, and prepare flow charts.
  • Develop and modify various Stored Procedures, Functions, and Triggers.
  • Participate in system and database review meetings to develop modules and projects.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Create different Database environments and provide access rights to Users.
  • Scheduled Jobs to migrate data from various data sources using SSIS packages and accordingly monitor the jobs on a daily basis.
  • Provide root cause analysis and solution for any failures in the database or SSIS Packages.
  • End-to-end database development (setting up connections, ETL, table definitions, testing connectivity, monitoring).
  • Interact with Subject Matter Experts & End Users to gather business requirements and test.
  • Create conceptual, logical and physical models for OLTP, Data Warehouse Data Vault and Data Mart Star/Snowflake schema implementations
  • Analyze, review, and rewrite programs to increase operating efficiency or to adapt programs to new requirements.
  • Creating automation that will take the place of several manual tasks today and allow for more efficient reporting.
  • Develop daily Jobs for processing the data migration, and update/Insert data from staging tables to main tables in SQL server.
  • Provide support once the SSIS Packages are deployed in production if there were any data changes, system changes, or requirement changes.
  • Developed and improved databases based operational and OLAP data sources and reporting databases.
  • Working experience with Kimball Methodology and Data Vault Modeling

Confidential, West Chester, PA

Technologies: SQL Server 2016, SSIS, AngularJS, HTML5, silver Light, SSRS, Tableau

Business Analyst, SQL Developer, SSRS report developer, SSIS Developer, Tableau Report Developer

Responsibilities:

  • Gather data from clients and prepare software requirements and specifications, and prepare flow charts.
  • Develop and modify various Stored Procedures, Functions, and Triggers etc.
  • Developed normalized Logical and Physical database models to design OLTP system for insurance applications
  • Involved in full project lifecycle of SDLC and coordinated with all project teams.
  • Designed and developed a Business Intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
  • Interacted with Subject Matter Experts & End Users and gathered business requirements.
  • Fix the software enhancements, change requests approved and assist in testing to receive approval and deploy in production.
  • Worked on data modeling for migrating the data from old system to new system for patient module.
  • Prepare new SSRS reports as per the approved change request, receive approval for deployment and assist in deploying to production environment.
  • Develop daily Jobs for processing the data migration, and update/Insert data from staging tables to main tables in SQL server.
  • Enhance the existing Tableau reports based on the change requests approved.
  • Conducting Unit Testing and providing the evidence for performance impact and interface impact on bug fixes
  • Created SSIS packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
  • Developed the backend jobs to run on a daily basis as per the requirement.
  • Performing bug fixes and conducting unit tests on the changes made and deploying the changes to System Integration Test Server to perform a second layer of tests before finally deploying the changes to production server.
  • Designed and implemented process to log error logs in the application and jobs.
  • Designed and developed SSRS report to show error logs on daily basis.
  • Provide detailed evidence of the unit tests and performance tests conducted on the changes made in order to get the changes approved and deploy in Production server.
  • Created different SQL datasets for SSRS, Tableau and Ad-hoc reports.
  • Develop automated notification sending process to deliver notifications to business (Patients, Users etc.)
  • Wrote SSIS packages and T SQL procedures for importing data into an Operational Data Store (ODS) and helped in building standard and analytical reports. Implemented bug-tracking and issue management software. Involved in hands-on coding of VB.NET and C# based web pages, XML based web services.
  • Developed the business logic and the design of data queries and calculations used to extract and format data for project reports and external presentations
  • Prepared SSIS Packages to Re Insert the records in case of any failure in the transformation of records in Interfaces.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Interacted with users and business analysts to understand/document the requirements
  • Co-ordinate with interface teams in case of any failure in the production and develop database resolution via stored procedure upgrades/SQL scripts.
  • Developed queries to provide one-time data to business based on the requirements.
  • Designed and developed stored procedure for creating rental invoices for an order.
  • Implemented process of handling different organization process in a single database.

Confidential

Technologies: SQL Server, SSIS, SSRS Reports, Java, JavaScript, XHTML

Junior Software Engineer

Responsibilities:

  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Attend meetings and work with the clients to get requirement to develop the SSRS reports.
  • Provide one-time data to the clients by using SQL queries.
  • Design, Develop and Execute the Unit Tests for SQL server stored procedures.
  • Involved in Sprint Review and Previews.
  • Perform quality assurance and testing of SQL server environment
  • To support customers and operational staff in issue resolution
  • Generating daily reports as per the requirement of the customers.
  • Creating test programs according to specification.

Hire Now