We provide IT Staff Augmentation Services!

Sql Developer Resume

Livonia, MI

PROFESSIONAL SUMMARY:

  • Over 10 years of experience working with SQL Server and Oracle databases, writing and managing packages, stored procedures, functions, triggers using SQL and PL/SQL
  • Expertise is troubleshooting issues related to programming using PL/SQL and T - SQL
  • Experienced with SSMS, TOAD, SQL Developer, Visual Studio, etc. tools
  • Over 7 years’ experience working directly with the clients to obtain business requirements and designing solutions, and resolving technical issues
  • Experience supporting JAVA based enterprise application and assisting clients with JavaScript
  • Over 3 years of developing front end applications and creating reports using Oracle Forms and Reports.
  • Experienced building SSRS reports and using SSIS for data integrations.
  • 1 Year experience working with IBM Cognos Reports.
  • Over 3 years’ experience working with UNIX Shell scripts and the scheduler software
  • 2 Years working with PHP.
  • Comfortable working in a multi-client and vendor atmosphere.
  • Experienced working in a fast paced environment where issues are required to be fixed in a very limited time handling real time critical data
  • Excellent technical support as rated by clients.
  • Documenting of processes and solutions for training purposes.

PROFESSIONAL EXPERIENCE:

Confidential, Livonia, MI

SQL Developer

  • Creating SQL Server databases, schemas and tables for day to day data warehouse maintenance.
  • Creating Data marts using star and/or snowflake schema design for reporting purposes.
  • Writing SQL queries, stored procedures and functions to support ETL processes and reporting.
  • Creating backup routines for different servers and monitoring the same.
  • Updating and deploying php scripts to derive data as required from the FACTS legacy system.
  • Troubleshooting existing SQL procedures and functions to resolve support related issues.
  • Creating and managing SSRS reports as requested by the internal sales teams for BI purposes.
  • Publishing the reports on the company’s internal CRM site making it accessible to end users.
  • Creating and maintaining SSIS projects to as part of the ETL processes.
  • Writing SQL procedures to pull data from Oracle databases into SQL server via linked server.
  • Maintaining SQL Server jobs and Reporting schedules to meet the needs of the end user.
  • Assisting the web development team in testing website webpages based on project BRDs.

Confidential, Troy, MI

Technical Support Engineer

  • Writing SQL Queries, Stored Procedures and Functions to format customer data for business intelligence purposes as charts and dashboards
  • Installing the software repository on Oracle, SQL Server, MySQL or DB2 databases on Windows, Linux, and Unix platforms
  • Deploying the application archives on Apache Tomcat, Web Logic or WebSphere web servers
  • Troubleshooting customer SQL queries and stored procedures to enable efficiency and compatibility with Confidential ’ s software
  • Writing JavaScript expressions to enable application level analytics
  • Troubleshooting issues related to various ODBC/JDBC database drivers
  • Designed and documented a solution for integrating the Confidential application with SharePoint
  • Continuously working on projects to design solutions such as Confidential software’s connectivity to MS Analysis Services Cubes, OBIEE catalogues, etc.
  • Document solutions and post articles on company support portal and blog (Zendesk)

Confidential, Southfield, MI

Application Support Engineer

  • Design and Develop changes to MIC's Oracle-based customs and trade software
  • Analyze customer change requests; formulate program and document changes to existing applications
  • Map customer requirements to application functionality, identify gaps, create program specifications and define software tests
  • Test implemented solutions, new applications, and assist customer with user acceptance testing

Confidential, Southfield, MI

Application Systems Engineer

  • Interacting with customers to obtain specifications on application design and function
  • Documenting customer specification and writing reports
  • Developing, debugging, and modifying code as per the customer specifications
  • Assisting the Quality Assurance department in testing the applications after configuration or modification of the applications

Confidential, Southfield, MI

Configuration Analyst

  • Wrote stored procedures and functions and other database objects to support payroll processes as per customer requirement
  • Fixed customer issues by making changes as required to preexisting applications
  • Tested any modified code and interacted with customers to dispatch the fixes

Hire Now