Sql Developer Resume
3.00/5 (Submit Your Rating)
Orlando, FL
SUMMARY
- Around 4 years of extensive experience in teh field of Web Applications development using HTML5, CSS3, JavaScript, JQuery, AJAX, Bootstrap3, JSON, SQL.
- Experience in programming as an SQL Developer in Analysis, Design and Implementation of Business Applications, working experience in Health.
- Performed development, maintenance and enhancements on MS SQL Server data warehouses used to assess critical clinical operations performance of more than 50 Healthcare Providers across US.
- Designed interactive dashboards, summary and detailed level reports enabling teh finance team to accurately understand teh revenue bottlenecks, reimbursement and patient trends using XML and SQL\ Server Reporting Services (MS SSRS).
- Developed and maintained SQL Server database by creating complex optimizing stored procedures, functions and views to enhance current functionalities and/or create new ones based on business requirements.
- Assessed teh target data needs by understanding teh business requirements, conducted a gap analysis between teh target and source data and mitigated those gaps by building ETL transformations in SQL Server Integration Services (MS SSIS).
- Expert in developing web page quickly and effectively using, HTML5, CSS3, JavaScript and JQuery and also experience in making webpage cross browser compatible.
- Solid Experience in UX design wif a strong background working in Wireframes Prototypes, Mockups, Storyboard and User Flows.
- In - Depth noledge/Experience of Web 2.0, JavaScript, JQuery, W3C Standards.
- Great ability to write clear, maintainable, well-documented, well-commented and efficient code for web development.
- Extensive experience on SASS, LESS, bootstrap .
- Experience Jasmine Unit Testing, responsive web design.
TECHNICAL SKILLS
- C, C++
- HTML, HTML5, CSS, CSS3, Bootstrap 3.0, LESS: JavaScript, jQuery, JSON, AJAX: Angular JS, Node JS.
- SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, T-SQL, Mongo DB
- Visual Studio Express 2012, Sublime Text, Notepad++, Web Storm: Waterfall, Agile: GITHUB, SVN: IIS 6.0, 7.0, Apache Tomcat
- Microsoft Office Suite (Word, Excel, PowerPoint, Access and Outlook).
PROFESSIONAL EXPERIENCE
Confidential, Orlando, FL
SQL Developer
Responsibilities:
- Developed tools and processes to eliminate manual processing of Clinical data.
- Exposure to SQL and experience querying and modifying data wifin a database. Experience wif Microsoft SQL server.
- Administered teh monthly Patients data load process and resolved failures by analyzing teh SQL stored procedures for issues related to data mismatch, data quality such as duplicate records, non-tagged records, null records.
- Enhanced teh existing code in SQL by modifying teh SQL stored procedures to address new business requirements on integration of 4 new business entities to teh existing database.
- Normalized vast amounts of patient data across multiple sources using SQL Server to deliver clear and actionable insights into healthcare provider's revenue, cost, quality and risk.
- Created Dashboards and stories to represent data for patients at Practice level and drill down to Physician level which halped client delivery team to analyze data quicker than manual reporting.
- Developed and modified complex stored procedures on SQL that improved performance of critical reports from 2 minutes to 25 seconds.
- Conducted advanced data analysis to identify data anomalies like patient accounts wifout valid coverage, claims tied to an inactive accounts and payments on hold.
- Co-led teh offshore technical development, created story boards for tasks, monitored deadlines and documented processes.
Environment: MS SQL Server 2014, MS SQL Server 2008R2, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), MS Excel.
Confidential, Coppell, TX
Technical Analyst
Responsibilities:
- Define and manage requirements for small to large application development efforts.
- Devised data cleansing strategy to mitigate teh data issues in teh legacy data through manual data fixes and ETL routines.
- Collecting and carrying out complex data analysis in support of management & customer requests.
- Interacted wif business analysts and translate business requirements into technical specifications.
- Developed stored procedures, triggers, views and added/changed tables for data extraction, transformation and loading.
- Created highly comprehensive data mapping - providing not only teh business logic using teh business requirements, but also queries to ensure better understanding by teh development team.
- Worked on Excels to upload teh data from excels to database.
- Automate Platform reports in power pivot - Excel
Environment: MS SQL Server 2012, MS SQL Server 2008R2, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), MS Excel.
Confidential
UI Developer
Responsibilities:
- Developed detailed mockups, prototypes and wireframes to illustrate interface and design concepts of teh website.
- Extensively worked on designing web pages using HTML, CSS, JavaScript and AJAX .
- Performed client-side validations using JavaScript.
- Updated templates and produced additional functional components using jQuery .
- Used various JavaScript and JS libraries, AJAX for form validation and other interactive features.
- Used jQuery to make HTML and CSS code interact wif teh JavaScript functions to add dynamism to teh webpages.
- Developed and implemented user interfaces as per latest W3C standards.
- Introduced SQL Server into teh team to maintain teh analytics data of teh company.
- Used Firebug, IE developer toolbar for debugging and browser compatibility.
- Developed web applications based on Search Engine Optimization (SEO).
- Managed cross-browser compatible issues by testing wif Internet Explorer (IE), Chrome, Firefox and Safari browsers.
Environment: HTML, CSS, JavaScript, jQuery, JSON, AJAX, Microsoft Visual Studio, MS SQL Server 2008.
Confidential
Web Developer
Responsibilities:
- Developed teh User interactive web pages in a professional manner using web technologies like HTML, CSS based on W3C standards.
- Gatheird teh data from teh backend using AJAX and jQuery .
- Gatheird data from API/ web services via AJAX-JSON calls and updating teh DOM wif teh result sets.
- Creating cross-browser compatible and standard-complaint CSS based page layouts.
- Worked on fixing cross-browser compatibility issues.
- Created and deploying new features in order to sustain and amend existing applications.
- Responsible for maintaining current websites that includes updating web pages, uploading new content/changes etc.
- Developed client-side validation code using JavaScript and jQuery .
- Created pages in Site Core and validating teh HTML code wif W3C validator .
- Fixed teh HTML errors in site core content editor.
- Highly involved in making updated to teh current website and simultaneously handling other projects.
- Involved in coding pages wif best Search Engine Optimization (SEO) techniques.
Environment: HTML, CSS, JavaScript, jQuery, AJAX, Usability Testing, Agile methodology.