Senior Data Management Specialist Resume Profile, NY - Hire IT People

Qualification Summary

Over 10 year strong experience in the IT industry in multiple sector with high volume database and complex systems
Design, Implementation and Management of critical busines processe from busines requirement and high priority ad-hoc request with aggressive turnaround timeline from stakeholder including executive management
Expert t-SQL knowledge and experience for data mining, cleansing, analysis,
Extensive experience Creating, Configuring and Fine-tuning ETL workflow designed in SAP BOD 4.1 and M SQL Server Integration Service SSI . Strong SQL Server 2005/2008 Developer Skill including writing Stored Procedures, User Defined Functions, and Queries.
Expert in migration of data in fixed and delimited layout from multiple format including Excel, Flat file, Access, XML, MV to Microsoft SQL Server. Expert in extracting and transforming transactional information using DTS/SSI Import/Export wizard, and SSI Package from SQL Server.
Extensive experience in installation, upgrade and configuration of M SQL Server 2008, 2005 version on both Standalone and Cluster Environments. Experience with installation, configuration, administration and implementation of SAP Busines Object Data Service 3.2-4.1 in standalone and Window Server 2008.
Defined and administered database standards, controls, procedure and documented the same. Highly experienced in troubleshooting data quality issue and implementing and supervising Quality Assurance processes.

Professional Experience

Confidential

Senior Data Management Specialist/SQL Developer

Engaging and building relationship with key stakeholder from marketing, product and busines units
Liaise with executive management and client a technical and functional expert
SSIS, BODS, and t-SQL, and stored procedure ETL proces design for execution of complex t-SQL to identify customer data on highly-targeted attributes
Design, development and implementation of file creation and QA processe for ad-hoc vendor requests
Design and development of database cleansing, de-duping, addres standardization, complex matching processe in physician database RDM environment
Manage aspect of Direct Marketing campaign data setup including: design, development in aggressive timeframes
Fulfillment of customer segmentation and analysi request in a highly aggressive deadline driven environment
Data management, ETL, modeling, mining, querying, reporting, and analysi using t-SQL, SSI BOD in SQL Server 2005/2008 and SAP Busines Object Data Service 3.2/4.0/4.1
SAP BOD installation/administration/implementation on Win XP Win Server 2008
Data integration with M SQL Server, SSIS, M Excel, M Access, and multiple file formats
Development and maintenance of documentation, standards, and technical requirements

Confidential

Database Developer/Data Management Specialist

Busines Analysis, Design, Development Implementation of custom client tracking database application utilizing M Access, VBA and SQL Server 2005
M Acces Database Forms, Reports, Queries, Macros, VBA Development
Custom ETL automation in VB and SQL with SQL Server, Access, and Excel
Data quality analysis, requirements, specifications, cleansing, and management
Database integration design and development with existing database applications
Documentation, project plan and project management
Management of testing, training and support

Confidential

Data Quality / Implementation Manager

Software requirement specification and validation of functional busines requirements
Management of client implementation and post-implementation support
Risk, priority, needs, and expectation analysis
Management, escalation and resolution of issue and risk assessment
Clinical and practice workflow analysis, training, design recommendations
Configuration of user interface screen and template per user specification
Management of quality assurance, software requirements, UAT
Troubleshooting, issue analysis, documentation communication of technical errors, enhancement requests, and usability issues
On-site and internet based software training and deployment support
Help desk and remote support management
Planning and supervision of crisi response and resolution
User manual, training scripts, and proces documentation

Confidential

IT Specialist/Software Developer/Analyst

Analysis, design, development, full life cycle testing, support of legacy application utilizing Cobol, JCL, CICS
Technical lead of 200 offshore staff on legacy migration project
Work with project management and busines analyst to create software requirement specification
Development of SDLC documentation, requirements, technical specifications, test plan and user manuals
Training management of off-shore application and database development staff
Custom UI built in VBA and Cobol for Excel from Mainframe MV .

Confidential

The National Institute of Health Multisite HIV Prevention Trial

Freelance Projects

Confidential M Acces Database and Application Development
Design and development of UI application database utilizing M Access, VBA, MS-SQL

Confidential

Online Courseware Development

Confidential