• Contributed in development of applications through the software cycle, from requirement definition through successful deployment.
• Updated access scripts into modern desktop applications; evaluate existing application to reprogram, update and add new features.
• Stored, retrieved, and manipulated data for close analysis of application capabilities.
• Design the database and table schemas for new and evolving applications, ensuring their stability and performance.
• Creating and modifying tables, stored procedures, views and functions to bring data into applications.

• Work very closely with the front-end developers to ensure data that is being brought in and is clean and accurate.

• Designed Windows Forms for application UI; perform unit and integration testing before launch.
• Created reports in application via report viewer.
• Performed all testing and troubleshooting methods and documented solution.
• Consulted regularly with customers, team members on project status, proposals and technical issues.
• Collaborate with team members to research, design, set and implement specifications for new applications.

Environment: Visual Studio 2015( Visual Basic, Visual C#, Report Viewer, Report Wizard) SQL Server 2008 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler).

n/a

• Lead requirements gathering from management, engineers, clients and business analysts; expedite and evaluate scope of work while accumulating data requirements.
• Expedite sessions with involved stakeholders and repeatedly evaluate progress while gathering business data requirements.
• Develop new and optimize existing complex report queries and stored procedures; designed reports to comply with clients and business units.
• Investigate and interpret business data to construct meaningful reports using SSRS for business units.
• Develop new stored procedures, views and complex queries; optimized existing SQL server objects.
• Published reports to SharePoint repository, and monitor database and server for performance improvements.
• Investigate and identify areas for improvement in database environment and monitor server to help identify opportunities for performance improvements.
• Build and maintain the Report Life Cycle Processes, Data Migration Plans, Report Inventory and BI program guidelines.
• Recording data and reporting it to proper parties such as clients or leadership
• Troubleshoot current/existing business intelligence reports

Environment: SQL Server 2008 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler) SSRS 2008, SSIS 2008, MS Excel, Windows 2000/2003, MS Visio

• Design/Build Extract Transform Load (ETL) procedures in SQL Server using SSIS and DTS packages and import/export data feeds to/from data warehouse and loan systems.
• Data Mapping between the source and the destination and documentation of the data mapping spreadsheet
• Extract, transform and load (ETL) data from different sources such as production database, flat files, excel files into database using SSIS and DTS
• Perform data validation, error checking, troubleshooting and performance tuning.
• Created queries to cleanse data (duplicated claims ) by using temp tables; created correlated and non-correlated sub-queries for complex business queries.
• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Worked on Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Modified SQL queries and stored procedures to generate data for reports.
• Troubleshooting problems by using SQL server profiler. Very Pro-active in identifying the problems before user complaints.
• Created and Scheduled the Reports to run on daily/weekly/monthly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Enhanced the old Excel Reports to new SQL Server Reports to fit new business requirement.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.

Environment: SQL Server 2000 (Query Analyzer, Enterprise Manager, DTS Designer, SQL Profiler, MS Excel, Windows 2000/2003, MS Visio, Progress Open Edge, Oracle, Sql Server, UNIX.

• Gained extensive knowledge of Progress and created database physical structure in test environment. Experimented database administration tasks including backup, recovery, dump and load, replication.
• Understood Client-Server architecture and practiced on test environment.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Demonstrated ability to effectively work in team structure. Assisting manager in performing database administration tasks.
• Participated in meeting for schema changes along with Business Analysts and Database Engineers.

• Involved in testing and debugging business logic in Store Procedures with Application Development Team. Involved in performing functional, systems, regression, and integration testing.
• Assisted mentor to review and finalize requirements. Participated in status meetings with other IT teams on new project
• Maintain communication channels with software engineers and project managers.
• Created queries to check for duplicate records, delete/modify them depending on the business rule. Rigorously tested and debugged all the scripts to test the validity of the data after the export/import/delete were done.
• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
• Involved in all phases of software development life cycle.