Team Lead - Idms Data Conversion Specialist Resume
3.00/5 (Submit Your Rating)
OBJECTIVE:
- Seeking a role as a Jr. DBA, Jr. SQL developer, or business intelligence / data warehouse developer.
TECHNICAL SKILLS:
- Experience with SQL (Microsoft and some Oracle)
- SSIS creation and usage
- VBA, and basic programming
- Highly proficient with Microsoft Office
PROFESSIONAL EXPERIENCE:
Team Lead - iDMS Data Conversion Specialist
Confidential
Responsibilities:
- Maintained a library of MS Access and SQL Server databases for use in ETL and data conversions
- Performed ETL operations with flat files, database backups, ODBC drivers, and SSIS packages
- Currently working on a SQL Server database to replace the old and cumbersome MS Access method
- Redefined the role, created new tools, processes, and reporting methods—trained a team
Data Implementation Specialist
Confidential
Responsibilities:
- Integrated sales and marketing data into our CRM product for over 190 car dealerships. Trouble shot issues and errors during implementation, QA, and on-boarding process.
- Staged and cleaned data in SQL server via SSIS packages, ad-hoc queries, and stored procedures
- Troubleshot bad data files and worked with DBAs to improve SSIS packages across platform
- Wrote custom code in stored procedures according to customer preferences to ensure on-going data accuracy
Digital Order Analyst
Confidential
Responsibilities:
- Identified system issues and coordinated the efforts of cross-functional teams to provide resolutions
- Led an initiative that successfully developed inventory control policies for nike.com limited-supply pre-sale events
- Worked with business owners and programmers to fix coding and system automation issues
- Developed SQL queries and utilized SAP to provide analysis and planning for various stakeholders and teams
Product Analyst
Confidential
Responsibilities:
- Managed client relationships and provided education and training on the capabilities of our tools and reports
- Helped clients define requirements for their systems and subsequently designed and implemented customizations
- Designed, tested, and deployed changes to reports and database systems using SQL Server