Junior Web Developer Resume

SUMMARY

3+ years of experience as a Database Developer with extensive knowledge of analyzing data using ETL tools.
Experience in data transformation and data loading using SSIS.
Sound knowledge on database models development and data repository development.
Experience in working with E - Commerce websites.
Sound knowledge on OLTP data analysis and reporting of OLAP data.
Experience in working with Oracle 11g and My SQL database technologies.
Extensively worked on creating stored procedures, functions and triggers adapting PL/SQL.
Software development experience in programming languages like Visual Basic, C#, Java, Javascript, ASP .NET MVC.
Experience in developing software using SDLC and Agile/Scrum methodologies.

TECHNICAL SKILLS

Web Design: VB Script, C, HTML, XML, CSS, Bootstrap

Database Administration: SQL, PL/SQL

Programming: ASP.NET, Java, C#, C++, JavaScript, ASP.NET MVC

Software: MS Word, MS Excel, MS Visio, MS PowerPoint, MS Outlook, NetBeans, Visual Studio, SQL Plus, Microsoft SQL Server, MySQL

PROFESSIONAL EXPERIENCE

Junior Web Developer

Confidential, Houston, Texas

Responsibilities:

Worked on websites developed on Shopify platform.
Communicated with the clients to know their requirements and assisted in developing the websites to satisfy their requirements.
After the website was developed, loaded the content or products through SSIS by using Visual Studio 2015 and SQL Server Management Studio. Performed ETL operations. Loaded the products file (excel sheet) on the SQL Server Management Studio database using SSIS tasks. Cleaned the data using the SQL queries. Used SQL queries to transform the data loaded from the Excel sheet to the appropriate Shopify Product API and after conversion loaded the products on the Shopify store using SSIS tasks
Tested the website to make sure that the website is working perfectly.

Junior Database Developer

Confidential

Responsibilities:

Collaborated with the Data Warehouse team for requirements gathering and identifying the source data.
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
Generated reports using Tableau as per the requirement.
Worked with database team in designing the Database using normalization and E-R diagrams (Data Modeling).
Developed Stored Procedures, Functions, Triggers, Cursors and Ref Cursors as per the requirement.
Involved in optimizing database performance by analyzing database objects, creating indexes etc.
Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Tools: /Technologies used: HTML, CSS, Javascript, node.js, angular JS.