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%+