Programmer Analyst
CurrentRoles and responsibilities :• Involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support.• Experience in Database Design and Implementation of Client-Server Applications & Database systems using MSSQL SERVER 2014/2008 • Create stored procedure to fetch, clean, transform data from database based on validation provided in the requirement.• Analysis of production data and Create/Modify and troubleshoot SQL queries and stored procedure to fix issues.• Creation of index to enhance performance in SQL server.• Write stored procedures to extract data from XML files and load output to tables based on requirement.• Reporting requirement Objectives and Project status report in Excel• Creating Sub-Queries and Joins for complex queries involving multiple tables, Proficient in DQL, DML, DDL, and TCL.• Table Design and Creation depending upon the Client’s data.• Sound knowledge and working experience in agile and waterfall methodology.• Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing systems.
