We provide IT Staff Augmentation Services!

Database Developer Resume

0/5 (Submit Your Rating)

Boston, MA

SUMMARY:

  • Five years’ experience in Information Technology field, with experience in SQL Server, SSIS, SSRS and Informatica Powerclient.
  • Effective team player as well as good in carrying out individual assignments under minimal supervision and direction.

TECHNICAL SKILLS:

Languages: .Net, C#, Shell scripting

Database: Oracle, MySQL, SQL Server, Netezza

Operating System: Windows (XP, Vista, 7, 8), Unix (Sun Solaris 5.9, 5.10)

Tools: ActiveCharge FusionWorks, Process Model, Ethereal, Geneva, Microsoft Visual SourceSafe, MS Office, Visio, Drupal, SSIS (SQL Server Integration Service),SSRS (SQL Server Reporting Service), SSAS(SQL Server Analysis Service), DM Express, Informatica (Power client 9.1), Wireshark

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Database Developer

Responsibilities:

  • Designed and developed ETL workflows
  • Build data cube using SSAS to perform data reconciliation
  • Created and deployed reports using SSRS
  • Developed SQL stored procedure to implement the business logic
  • Re - designed the ETL workflow from weekly processing to daily processing
  • Created an SSIS package with multiple data flows to migrate data between different platforms
  • Optimized SQL and ETL workflow to increase the efficiency by 200%
  • Created UNIX shell scripts for automating the process of splitting and loading files, which decreased memory usage

Confidential, Boston, MA

Database Developer Intern

Responsibilities:

  • Optimized the work flow, and developed new functionalities to address client needs
  • Generated QC reports on data warehouse using SQL, which increased the visibility of the process
  • Worked on migrating customers based on location mapping
  • Created an end to end process documentation of an ETL(Extract Transform Load)
  • Automated notification process for file transfers using SQL
  • Created an SSIS package to handle change in layout of customer report
  • Worked on loading the data warehouse using SSIS and DM Express
  • Worked on validating multiple data files using UNIX shell scripting

Confidential

System Engineer

Responsibilities:

  • Managed three different applications, handling 15 million transactions per day with a three member team
  • Involved in user requirement gathering, client’s proof of concept and analyzed IT implementation for new enhancements and new services
  • Oversaw software quality assurance for code change and new code deployment
  • Automated application monitoring, streamlined and redesigned the code flow, resulting in increased system stability per month from 80% to almost 100%
  • Optimized SQL queries which improved the system performance by 30%
  • Standardized customer data across different application, which reduced the billing issue by 30%+

We'd love your feedback!