SUMMARY:

IT Professional leader with extensive experience in supporting large scale applications and systems both middle office and back office.

ENVIRONMENT/LANGUAGES

SQL SERVER 2008-2005, UNIX, Windows Server 2003, Outlook Administration, T-SQL, Shell scripting, Perl, HTML, XML

AS/400, Mainframe, IIS, .NET, Visual Basic, light C , BIDS, SSIS, SSRS, ETL, POWERSHELL, Visual Studio, Android OS, Blackberry Enterprise Server, Foglight Qwest, Windows , VmWare, Citrix, Remedy

PROFESSIONAL EXPERIENCE:

Confidential

Hosted Application Consultant

• Website design/development and database development consulting for launch and SEO optimization using web tools.
• Database security, backups, disaster recovery and reporting
• SQL SERVER express 2008 , PowerShell, HTML , CSS, JavaScript

Confidential

3 month Contract Database Administrator/ Senior Application Analyst

• This role was 3 part in nature. The role required day to day administration of the VM environment for various instances of SQL Server 2008 and 2005. The role also required the development and implementation of SSIS packages using standard ETL within the BIDS environment for daily migration of flat file data conversion to SQL databases
• Supported three field applications WellView-SiteView-Unidata utilized by the Engineering and Exploration.
• Sql Server administration day to day functions included security, backup, restore, log shipping, re-indexing, performance monitoring, job creation and implementation, sql server installation and configuration for both 2005 and 2008. 5 plus years of DBA experience using standard database practices-T-SQL, functions, views, triggers, joins, ad-hoc reporting, Stored Procedures, xpcmd, PowerShell, and xp exec, perfmon, failover, high availability practices and utilizing execution plans for proper performance tuning
• This contract position required excellent high level and low level communication with Infrastructure, vendor, and CTO meetings in order to provide metrics and/or gain relevant insight for a given matter.
• As this role was only a 3 month requirement, the tasks required immediate and vast knowledge for various systems and infrastructure in order to complete the requirement within the given timeframe and required after hours and weekend work which allowed for greater success for the given task.

Confidential

3 month Contract SCOM / Database Administrator/ Senior Application Analyst

• This position required day to day administration for the VM Microsoft SQL Server 2008, 2005 environment. : backing up / restoring databases, re-indexing, installation and monitoring Windows Server 2005, configuration of all application components which included IIS , Report Server , SQL Server 2005, 2008 systems. Also required MS-SQL job implementation, user and application security and role implementation.
• Within the SCOM environment this position also required new development of management packs for use within Report Server and the SCOM environment. Also required debugging of numerous .NET applications

Confidential

Global Applications Analyst and Production Management level 2 Support of Systems and firm wide global technology

• As part of the specialized Production Management Global Core Services L2 Operate team, responsibilities include supporting 35 JP Morgan proprietary trading systems and applications which house significant amounts of trade data 365 days a year encompassing all global markets while reporting directly to Investment Bank Technology Vice Presidents globally and numerous lines of business including but not limited to Commodities, Risk Simulation, Rates, Equities ECCD , whilst delivering data for all global markets including but not limited to NYSE
• Full Back Office and Middle office application support encompassing evaluation of issue, troubleshooting, and first fix on Investment bank firm wide applications and trading systems globally
• Provide system and data support for IBM AMVS Mainframe and National lead mainframe expert
• in depth coverage on batch processes and real time system and queues for delivery of data using AUTOSYS, control-m, bouncing of processes and tomcat servers with high stake Service Level Agreement for each line of business that must be followed for ensuring daily JP Morgan Investment bank data is flowing as required
• Performed regular and scheduled delivery of money market and foreign exchange cash to JP Morgan back office systems which required technical expertise on AMVS IBM Mainframe, trade data reporting, trade system first fix for trading floors in real time during market and close of all Investment bank branches daily
• UNIX Shell scripting in bash, ksh for chasing feeds and automation monitoring start of day for Asia and European markets on various systems and applications firm wide.
• Vast and low level in depth technical knowledge of trading systems, back office, middle office and system queues utilizing various applications including Informatica
• Preparing runbooks, documents, and flowcharts for daily business usage as well as training global technology team members for new application support during initial onboarding in a prompt and highly efficient manner
• Scheduled participation in meetings pursuant of increased reliability of application support and automation goals alongside development team members, and incident reporting utilizing the change management application
• Provided 15 minute SLA resolutions for numerous applications including start/end of business day transactions

Confidential

Hosted Applications Specialist Database Administration and Production Support of Web applications

• Reported directly to Infrastructure Vice President of Operations and infrastructure
• Performed regular and scheduled SQL SERVER administration and maintenance plans which includes backup, restore, job creation, query writing, performance tuning, re-indexing, monitoring using SQL Profiler using various tools such as SQLCMD, SQL PLUS, And Transact SQL
• SQL performance monitoring and tuning using execution plans and SQL Profiler
• DATA migration and ETL using SSIS and import/export tool
• Ad-hoc reporting using FOGLIGHT
• Stored procedure development and Query optimization
• Application patch updates in ORACLE 10G and SQL SERVER
• Provide documentation, flowchart support for database/data warehouse structure
• Solid experience in Microsoft SQL Server Reporting Services
• Solid understanding of c , visual basic, and perl
• Performed all .NET application launches and updates on SQL code to the UAT and production databases
• Designed Disaster Recovery / Failover Clustering in high availability and Log Shipping configuration within SQL SERVER 2005, 2008 environments
• Utilizing SSRS 2008 generated customized reports and performed data migration utilizing SSIS by building DTS Wrote PL/SQL to verify/update data tables in Oracle 10g
• Performed AUTOSYS job creation
• Performed SharePoint Application installation of modules
• Prompt resolution of .NET 2.0 application issues, IIS and Windows Server backend support as well as end user issues requiring strong multi tasking and low level knowledge of various applications
• Configuring Web.config files and for implementation of web application implementaton
• Monitoring of servers using Foglight monitoring software and configuration of additional servers added to the foglight environments.
• Microsoft SQL SERVER 2005 and 2008 troubleshooting, configuration and installations.
• Microsoft Report Server configuration and installation
• Proficient in SSIS data conversion and report generation
• Writing bat files to perform automated tasks
• Performing Microsoft Active Directory admin tasks such as adding new users to the .NET application
• Provided on call 24 hour support of Web Servers, and Database servers
• Proficient in Quest Foglight Monitoring
• Commendable record received during quarterly reviews
• Received bonus during first year of employment for my committed diligence and quick turnaround of DISASTER RECOVERY on SQL Server 2005 for our primary client Walmart Texas Retail Energy
• Certified in Texas Ercot training

Confidential

Web Support Technician

• Provided Web Host Support for Clients in .NET 2.0 environment and solid knowledge of Visual Basic, and C
• Provided support for FTP-DNS-Server Errors- SQL Server connectivity issues-programming errors- Web.config support, providing developers with connection strings -IIS Management support-URL REWRITE support-Utilized command prompt using TELNET-Database connection strings.
• Setting up mal accounts and hosting in OUTLOOK and c-panel
• Provided Knowledge and support for TCP-IP-FTP-HTTP-Sub domain support and MX record support. Also provided support using Microsoft Visual Studio and SQL Server 2005 to developers. Assisting them with correcting connection strings in the applications and bug fixes
• Changing Application pool settings for developers for their .NET application within the c-panel control panel
• Troubleshooting mail server related issues and customer connectively

Confidential

Technical Support II / Trainer

• Position included many objectives including outsource training, SEO reporting to our India technical support team
• Helpdesk support for OUTLOOK pst files, Blackberry Enterprise Server
• Customer-centric guidance and telephone support
• Finding / documenting bugs within application
• QA testing of product releases and updates
• Training technical support of outsourced team in India - preparing training documents
• Performed project planning, outsource support and technical writing of training manuals
• Worked closely with Director of Engineering and Director of Customer Service during implementation of India customer service rollout.
• Troubleshooting of Mac Panther, HP prnters and Windows XP/2000/NT/ QA testing, Firefox , IE, SEO Optimization, HTML, XML, Crystal Reports, PowerPoint, Excel, Outlook

Confidential

JR. Microsoft SQL DBA

• Technical skills as follows: SQL SERVER Management 2000 and T-SQL
• Performed regular and scheduled SQL SERVER administration and maintenance plans which includes backup, restore, Job creation, query writing, performance tuning, re-indexing, monitoring using SQL Profiler and utilization of execution plans for performance tuning. Also using various tools such as SQLCMD, SQL PLUS

Confidential

J.R. Web Administrator

• Strong knowledge of TCP/IP Stack,
• Provided backend IIS support.
• Monitoring Tomcat web servers daily and daily reporting of internet Usage, web logs and, URI Data using the skills below:
• IIS
• PERL, VBscript, JavaScript
• Window NT
• T-SQL

Confidential

POS Technical Support Analyst

• Provided Point of Sale technical support to all EXXON stations across the USA that included troubleshooting credit card network connectivity, cash register technical support, and training
• Provided reports per incident which involved gas leaks, sump pump disconnects and other hazard / catastrophe documentation
• Technical skills as follows: AS/400, mainframe network, SCHLUMBERGER Point of sale machines