Lead Developer / Team Lead Resume
SUMMARY
- 19+ years’ experience in Information Technology area. More than 10 years’ experience as SQL Database Developer, 7 years’ experience as DBA. Specialized in SQL Server 6.5/7/2000/2005/2008/2012/2014 and MySQL.
- Proficient in data architecture, database design, analysis, installations, upgrades, performance tuning, scheduling backups/recovery, migrating databases, SSIS, SSRS, Enterprise Data Warehousing.
- Experienced in documentation, data migration, OLAP, data modeling, ETL and BI development, including stored procedures, functions, views and triggers.
- 5 years’ experience in management. Ability to work in team and with individuals of different skill levels, strong commitment to meet deadlines under pressure.3 years’ experience in Web development. ASP.NET, MVC, Ajax, JavaScript, C#.
TECHNICAL SKILLS
Work - related qualities and skills: Dependable and hardworking, comfortable with tight schedules, able to learn new technologies and products rapidly, self-motivated and responsible, good team player, excellent communicational skills, good problem solving skills.
Software Knowledge: SQL Server 7.0-2014, Crystal Reports 8-11, Platinum SQL ERP, Clientele, TFS, MySQL, Pentaho, Visual Studio, Sage 50, MS Office 365
Programming Languages and Technologies: Transact-SQL, ASP.NET, C#, MVC, Ajax, JavaScript, VBA, HTML, ADO, SSIS, SSRS, OLAP, OLTP, ETL, EDW
PROFESSIONAL EXPERIENCE
Confidential
Lead Developer / Team Lead
Responsibilities:
- Managing a team of developers, assigning tasks, defining goals and terms
- BI development and reporting
- Created SSIS packages, data modeling, mapping, ETL
- Data warehouse and SSAS development
- SharePoint Development
- Web Development
- Enterprise Data Warehouse development
Technologies: SQL Server 2008/2008 R2 - 2014, SSIS, SSRS, SSAS, ASP.NET, MVC, T-SQL
Managing Partner
Confidential
Responsibilities:
- Database development and Administering using MS SQL Server
- MS Access, MS Office, VBA
- Crystal Reports
- Sage 50 Reporting, customization and integration
- Web Development
- Mawer Investment Management, Enterprise Data Warehouse development
- Ensign Atlantic, incident reports delivery solution
- Sage 50 (Simply Accounting) Custom Reporting
- InterVisa Inc web application
Technologies: SQL Server 2014, ASP.NET, C#, MVC, Ajax
Confidential
Senior Database Developer
Responsibilities:
- Created database objects as such as tables, store procedures, triggers, views, indexes and user-defined functions
- Created SSIS packages, data modeling
- BI development and reporting
- Web development
- Managing team of report developers and database developers
- Database Administering
Technologies: SQL Server 2005/2008 R2, SSIS, SSRS, OLAP, ASP.NET, MVC
Confidential
DBA
Responsibilities:
- Executed database backups and recovery, implementation, tuning, monitoring, capacity planning, query performance tuning, database server performance tuning, security, database maintains, code reviews, data architecture and analysis;
- Documented database servers’ environment, user manuals;
- Recommendations for development team;
- Developed web application based on Google maps;
- Developed BI reports for executive team.
Technologies: Pentaho ETL, PHP, Ajax, JavaScript, MySQL, MS SQL Server, Excel, RDBMS, SSIS
Confidential
ETL Developer
Responsibilities:
- Data migrating from JD Edwards to MS Dynamics Axapta (Oracle and MS SQL Server 2005)
Technologies: ETL, MS SQL Server, Oracle, Excel, RDBMS, SSIS
Confidential
Win/Web developer
Responsibilities:
- Reports and Database development.
- Created internal banking applications.
- Worked on design of new banking system database.
- DBA duties (SQL Server 2000 and 2005): backup, recovery, security, performance, tuning.
- Database analysis in banking conversion project.
Technologies: MS SQL Server, .NET, T-SQL, Crystal Reports, Excel, RDBMS, SSIS
Confidential
Database developer
Responsibilities:
- Reports and database development;
- Developed new modules and features for Platinum SQL ERP;
- Provided maintenance/support activities;
- Created DTS packages and OLAP solutions;
- Executed database backups and recovery, implementation, tuning, monitoring, capacity planning, provided general technical and network troubleshooting, performance tuning.
- Created internal tracking system.
Technologies: DTS, PHP, MS SQL Server, Crystal Reports, T-SQL, DTS, OLAP, VBA, RDBMS
Confidential
Technical Support Engineer
Responsibilities:
- Analyzed clients’ databases and troubleshooting;
- Recommendations on improvement of the system functionality for development team.
- Solving problems in administering SQL Server 2000 as backup and recovery database, maintenance tasks configuring, managing database files, jobs, troubleshooting, performance tuning;
- Provided technical support of Platinum SQL ERP system.
- Interface development, development tools, test environments and Installation at client sites;
- Developed accounting applications based on SQL Server platform.
Technologies: MS SQL Server, Crystal Reports, T-SQL, Delphi, RDBMS
