Sql Server Developer

OBJECTIVE

To obtain a challenging and upwardly mobile position with an innovative company that will allow me to utilize my education, communication, analytical and leadership skills accompanied with fourteen years of work experience in application development, maintenance and design. To utilize my abilities a proactive team player with emphasis on speed-to-market and delivery of quality products/services to achieve customer, employee and enterprise’s strategic goals and objectives.

PROFESSIONAL SUMMARY

8years of experience as a Microsoft SQL Server Database Developer experienced in designing, developing, implementing, analyzing, and tuning, database applications utilizing various segments of the System Development Life Cycle (SDLC), using Microsoft SQL Server 2008/2005/2000, T-SQL, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)

Proficient in using SQL Server Integration Services (SSIS) and Data Transformation Services (DTS) to build Data Integration and Workflow Solutions to extract, transform and load data (ETL)

Proficient in Business Intelligence (BI) Application Crystal Reports 8, 9and 10

Experience in Application Development Analysis, Requirements Analysis, Scoping, Developing, Debugging, Testing, and Documenting Client/Server Applications

Excellent communication, interpersonal and organizational skills

Proven ability to quickly learn new technology and programming languages

10 years of Legacy Applications Development and Integration

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008, 2010, Excel, Access

Programming Languages: SQL, T-SQL, NET, Visual Basic 6.0, Active Server Pages, SQL Server 2005, Visual InterDev, Visual C++, Java C++, C, COBOL, CICS, Visual FoxPro, Microsoft Access, XML

IDE & BI Tools: Crystal Reports 8/ 9/10, MS SSRS, MS Visual Studio, and MS SQL Server Management Studio 2008/2005

ETL Tools: Microsoft SSIS, DTS, Oracle Jdeveloper

Packages: Microsoft Office 2007/2003/2000

EXPERIENCE and ACCOMPLISHMENTS

Hudson Bay Company(Saks Inc)

Middleware Developer (March 2015 to Present)

2 years of experience in analysis, design and development of enterprise applications using SOA,BPEL, Java, j2EE,and Database technologies.

2 years experience in large-scale SOA/EAI implementations using Oracle Fusion Middleware (OracleJDeveloper, Oracle SOA Suite, Oracle OSB, Oracle BAM and Oracle Weblogic)

Solid understanding in Service-Oriented Architecture and its related technologies like BPEL, Web Services, WSDL, SOAP, XML, XSD, XSLT and Web Service Security.

Experienced using the following SOA Suite technology adapters for integration with Oracle ERP and external/legacy systems: Database, JMS, B2B, FTP/FileWeb Service, BAM, and Oracle applications.

Experienced in Java-based XML technologies like DOM, JAXP, XPATH, JAXB, and XSL.

Lead Developer in Service and environment Migration to Oracle SOA Suite 12c with the new adapters such as Oracle Event Processing in 12c

Telapex Inc

Computer Systems Analyst/Application Programmer (May 2010 to December 2014)

Architected, Designed, Implemented, and Maintained Custom Database Schema, Tables, Stored Procedures, Functions, Constraints, Indexes, Functions, Views, Rules, Defaults and complex T-SQL statements

Manage accounts to ensure accurate data processing in Pearson Student Data Management System (SMS)

Created multiple ETL packages to automate data transfer and integration between enterprise transactional database and various vendor databases

Created automated stored procedures for day end operations using SQL Server Agent Scheduler

Coordinated with front-end ( business owners) for implementing business logic in custom stored procedures and functions, and reporting

Instructed, directed and verified the work of other programming personnel

Data cleansing, data verification, and ETL Processes (extraction, staging, transformation, and loading)

Worked as basic DBA’s to ensure application’s implementation, and efficiency

Worked as DBA to implement Recovery policy

Mississippi Army National Guard-Iraq

Company Intelligence Support Team (February 2009 to May 2010)

Provided Threat Analysis to Company Commander and Battalion Intelligence officer

Evaluated Potential Security Risks and Hazards

Collected Patrol Reports and Photos Coded, debugged, tested and documented application programs

Updated weather and map intelligence

Briefed and debriefed Patrols and their missions

Produce Power Point presentation for the Commander

Telapex Inc

Systems Programmer (March 2007 to February2009)

Developed and maintained MS SQL applications and Databases

Developed and authored functional requirements and documentation based on accepted criteria

Designed and transformed user requirements into application programs

Coded, debugged, tested and documented application programs

Coordinated and lead project development of medium to large sizes

Developed Crystal Reports

Business Objects Administrators

Memphis Managed Health Care

Systems Programmer (February2006 to November 2006)

Health Care Systems

Responsible for generating reports through SQL and various other tools.

Designed and transformed user requirements into application programs

Coded, debugged, tested and documented application programs

Programmed and maintained several Health Care sub-systems (billing, claims processing…etc)

Performed Data Manipulation to Prepare McKessons Data Warehouse

Mississippi Army National Guard-Iraq

Scout Vehicle Commander(August 2004- February 2006)

Responsible for training, safety and welfare of my crew during combat operations.

Responsible for compound security and operations

Responsible to take over Platoon Operations when direct supervisor was not available.

Memphis Managed Health Care

System Software Analysts (May 2003 to August 2004)

Responsible for maintenance and upgrading of the customer service call tracking software and hardware.

Responsible for maintaining and upgrading Disease Management databases from Access to SQL.

Developed Crystal Reports to allow Management to access data on the SQL server

THYSSENKRUP ELEVATOR

System Administrator(October 1999 to May 2003)

Exchange Server Administration

Desktop Software Support Level II

Lead technician on new projects, which included overall planning, and management of software distribution and on-going support.

EDUCATION

Christian Brothers University – Memphis,TN

Bachelor of Science – Business Managment,– August 1987

Southwest Tennessee Community College-Memphis TN

Associates of Science-Visual Programming-December 1999

Deans List 5 out of 5 semesters

Excellent References Available Upon Request

Contact this candidate