SQL Developer Resume Livonia, MI - Hire IT People

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