We provide IT Staff Augmentation Services!

Sr. Sql Server / Etl Developer Resume

Washington, DC

SUMMARY

  • Over 14+ years IT experience with 10+ years of Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2016, 2012, 2008, 2005, 2000 in Production, Test, Development
  • Experience in Application domain knowledge in Insurance, Financial, Telephone - Cellular, Marine, Software, Manufacturing, Educational, Service, Tours & Travel industries.
  • Experience in installation, configuration of MS SQL Server 2000, 2005, 2008, 2012, 2016
  • Knowledge of Relational Database Management systems.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures
  • Managing Projects, Deliver the Project within the Deadline as per SLA, managing on-site/off-shore model
  • Recruiting appropriate resources for the Team / Resource management
  • Experience working for enterprise level companies with more than 50000 employees
  • Experience with SSIS, Data Transformation Services, Batch processes, Import/Export and Backup/Restore.
  • Manual Testing, and Functionality Testing
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
  • Experience in supporting Large Databases.
  • Hands on experience in Troubleshooting database issues.
  • Good Knowledge working with Facts, Dimensions.
  • Experience in writing and debugging Stored Procedures and triggers using T-SQL queries.
  • Experience in Data Modeling using Erwin Design Tool
  • Knowledge of Networking Concepts and Object Modeling Technology.
  • Good interpersonal, Analytical and Communication skills and a team player
  • Can-Do, Will-Do Attitude, Problem solving, Self-directed, Ability to learn new tools and use them.
  • Experience working in VMWare Virtual Environment ESX 2.x
  • Install and Configure SQL Server 2005 on Virtual Machines

TECHNICAL SKILLS

Languages: VB6,SQL, Web Services, C, C++, Java, Perl

Operating Systems: Windows (2012, 2008, 2003, XP, Windows 10), VMWare - ESX

Databases: MS SQL Server (2016, 2012, 2008, 2005, 2000), DTS, SSIS

Reporting: SQL Server Reporting Services

Tools: SQL, Erwin, TOAD, T-Sql, TFS, ClearCase, Notion TimeSheet

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Sr. SQL Server / ETL Developer

Responsibilities:

  • As an ETL Specialist, need to adhere with HIPAA policies and State rules while delivering best solutions, in Agile Project delivery methodology.
  • The project is to integrate source transactional DB2 EBCDIC coded Flat File Data provided by Conduent, into Star Schema - MDW (Medicaid Data Warehouse), which contains Claims, Providers, Phamacy, Enrollments, and Eligibility, etc.
  • Closely work with Managers, Stakeholders to get various pieces of requirements Integrate DB2 Flat File EBCDIC coded data with SQLServer 2016 MedicaidData Warehouse.
  • Source - Target mappings, utilizing LOAD & Control Files provided by SourceETL into DataStage & ODS. Import CMS - CCW (Chronic Conditions Warehouse) historic SAS data into SQL.
  • Attend Stand-ups to provide day-day status to Scrum Master, and other team members;
  • Grooming sessions to manage work in deliverable PBI (Product Backlog Items) and Tasks.
  • Liaison with Reporting Team and external Clients for file format standardization Data Analysis / Mapping / understand & interpret data, provide technical guidance to junior developers in the team Index tuning, performance tuning, Query tuning Database Design, Dev Database administration, Roles, Permissions Writing Stored Procedures, Functions using TSQL; Design / Create database Objects ETL (Extract / Transform / Load) using SSIS. Event Handling, Logging, Configuring SSIS
  • Packages using Environment Variables and Project Deployment Model.
  • Design and Develop SSIS packages, Data codepage Conversion Import source zip files SFTP (Secure FTP) site into local server using SSIS and WinSCP.

Environment: SQL Server 2016, T-SQL, SSIS, TFS for version controlling, Visual Studio 2015, Power BI, SAS

Confidential, Arlington VA

Sr. SQL Server Developer

Responsibilities:

  • As as Sr. SQL Server Developer, need to adhere with HIPAA policies and rules while delivering best solutions to clientle, in Agile Project delivery methodology.
  • The project is to bring User Assessment Data (Member / Patient) belongs to different kinds of Assessments, clients into a common format and load the data into IDENTIFI front end database, which can be used by CM (Care Managers) when providing Patient level service.
  • The Assessment data was finally used by Rules Engine to calculate RAF (Risk Adjustment Factor), which will be used to rank Member or Patient, depending on the Risk score, to provide more value based services, both to Member and Physician.

Environment: SQL Server 2012, Excel 2013, Microsoft Cloud TFS

Confidential

SQL Server ETL Consultant

Responsibilities:

  • Worked as SQL Server / ETL developer using SQL Server 2008 R2 for WITI - PMUWS Project.
  • Developed and Managed Database for WITI - Wholesale IT Intelligence
  • Wrote Triggers, Stored Procedures, Functions, TSQL.
  • Created / Managed Table Indexes, Query Tuning
  • Performed Defect tracking and closing by using HP Quality Center
  • Designed and Deployed new SSIS Packages, Change existing SSIS Packages
  • Created SSIS Packages, Configured SSIS packages for different environments using dtsconfig XML file
  • Produced CSV, utilize CSV files as part of ETL Process
  • Changed existing mappings as of new Dash Board requirements, Add newdata elements to existing mappings
  • Source - Staging - End CSV file generation mapping
  • SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
  • Responsible for Code deployments / configurations/ config management in various environments
  • Extract-Transform-Load data into SQL Server 2008 R2 database from various sources
  • Scheduled SSIS packages using Autosys
  • Understanding old mappings from retiring PlanView Oracle database, implement same and additional mappings using SQL Server 2008 R2 -PMUWS (Project Management Universal Work Station)
  • Enhanced existing applications to meet new business requirements
  • UAT / Production Support
  • Enhanced existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
  • Deployed the code in various environments i.e. DEV/SIT/UAT
  • Created and maintained DB Change Log to track the state of the DB in each environment(Dev, Test, UAT, Pre-Prod)

Environemnt: SQL Server 2008 R2, VB.NET, Oracle 11g, Autosys, Share Point, SQL Server 2008 R2 Integration Services, Quality Center 10.0

Confidential, Herndon, VA

SQL Server Consultant

Responsibilities:

  • Worked as SQL Server Consultant using SQL Server 2008 for CMH Project.
  • Source Controling using IBM Rational ClearCase
  • Developed and Managed Database for Collateral Management and Hedging
  • Wrote Triggers, Stored Procedures, Functions, define User Defined Data Types, TSQL
  • Created and maintained Physical Structures.
  • Worked with Dynamic Management Views, System Views for Indexing and other Performance Problems
  • Created / Managed Table Indexes, Query Tuning, Performance Tuning, Deadlock Management
  • Defect tracking and closing by using HP Quality Center
  • Agile - Weekly Sprints / releases - CRs
  • Designed and Deployed SSIS Packages
  • Created SSIS Packages, Configure SSIS packages for different environments using dtsconfig
  • Produced CSV, utilize CSV files as part of ETL Process
  • Produced XML Files for Tibco (Real Time Data Transfer)
  • SSIS Error Handling, Event Handling, Logging, Batch Checks for data accuracy
  • Responsible for Code deployments / configurations/ config management in various environments
  • Create and Maintain Interface Control Documents (ICD)
  • Implemented Security, Roles, Logins, and Permissions
  • Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
  • Maintained Users / Roles / Permissions, Security
  • Scheduling SSIS packages using Autosys, writing JIL Scripts
  • Enhanced existing applications to meet new business requirements
  • L3 Production Support on Rotation basis
  • Enhanced existing stored procedures, views, functions, database objects to meet additional requirements of latest releases
  • Capacity Planning DBs, Disk Requirements
  • Deployed the code in various environments i.e. DEV/SIT/UAT
  • Created and maintained DB Change Log to track the state of the DB in each environment(Dev, Test, UAT, Pre-Prod)

Environemnt: SQL Server 2008, VB.NET, Oracle 10g, Sybase, Clear Case 7.1, Autosys, Share Point, SQL Server 2008 Integration Services, Quality Center 10.0, Compass Point

Hire Now