Dot-net C#/ms Sql Developer Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- I want to be a reliable team member to a small or mid - size company and effectively contribute to their growth. I have earlier participated in bringing valuable experience and extensive support to multiple organizations.
- I assisted with system administration, application development, scripting, web development, database administration, prototyping of applications. I am a self-trained software developer specializing in C#, MS SQL back-end traditionally, more recently front-end programming using HTML, Javascript, jQuery, bootstrap and angular.
- Gather Functional requirements, identify and document of the business process.
- Categorize and Prioritize requirements and create project milestones and timeline plan.
- Meet Domain experts analyze existing processes and programs get current limitations.
- Meet with Account managers get feedback and make appropriate changes for each program.
- Create object model and align to data model discuss relationships and referential integrity.
- Create project flow diagrams, with the individual use cases, analyze data state transitions.
- Discuss and Select the n-Tier architecture, MVVM strategy and evaluate DTO objects.
- Create tests, analyze queries, build indexes, research performances and build reports.
- Create new or modify existing Html templates analyze dissect JavaScript and Css.
- Maintain JavaScript library’s client, server, data and view. Test UI flow and logic.
- Developed and Test complex application using JavaScript / jQuery.
- Refactor code and modules structure, develop libraries for reuse and engage in meetings.
- Tools used Webpack, Grunt, Gulp, Bower ESLint, Concat and Minify
- Write SQL queries using table inner and outer joins incorporating complex logic within.
- Optimize the queries by creating various clustered, non-clustered indexes and indexed views.
- Creating Tables, Views, Triggers, Stored Procedures and User Defined Functions.
- Backup, restore, move, create and manage databases on MS SQL server 2008/12.
PROFESSIONAL EXPERIENCE:
Confidential
dot-net C#/MS SQL developer
Environment: Windows / Mac
Confidential
Responsibilities:
- This Project is an automated multi-triggered system which polls Edex's Severs for new data, receives XML data and stores the same to a local MS SQL Server (2008).
- A second process scans the SQL Server for data not transmitted, identifies the format and pushes the same to the vendor's web-service, at regular intervals, saving the result back to the SQL Server.
- The project also automatically re-transmits errored data and generates weekly reports.
- As a solo developer, I was responsible for creating the entire design, queries/joins, stored procedures and program flow for this project.
- The entire client/vendor testing, staging to live production, deployment was handled by me.
- This also involved various change requests from the clients as well as Edex Staff.
Confidential
Responsibilities:
- In this assignment, I had to research iMacros, a Browser Automation, Data Extraction, and Web Scripting (like Selenium) to automate the online form submission to DWC website.
- I built an embedded XML schema validator to validate and identify the type of document being submitted, completed the multi-page submission with multiple attachments and logged the result while transmitting the success token to a web-service (to Edex).
- This project also involved a complex archiving system and the State Pattern Design pattern was used to move the process through various stages and retry failed stages.
- This was a real-time project and had to be monitored 24/7 as downtime would result in monetary loss.
Confidential
Responsibilities:
- The billing module had complex pricing logic. This billing had to be run at cutoff dates, having multiple individual clients, vendors supporting multiple clients and agents accounts with separate handing instructions.
- Using MS SQL stored procedures I ran reports consolidated by the required order using multiple SQL queries, joins and data exports, creating multiple tables and dropping them to transform data into the required format.
Confidential
Responsibilities:
- The System Admin Website was created for account managers to manage client information to communicate between front-end and back-end servers. We used JSON data services but not in a pure Restful implementation. I assisted in developing Bootstrap templates and in standardization of CSS libraries. I introduced Can.js and mustache templates. As a team we set design standards, incorporated MVVM structure and refactored controllers and data libraries several times.