SQL Server / ASP.NET Professional Skills
- Troubleshooting, Database Objects authorization, DTS, ETL Tools; using (SSIS), Objects Creation such as Tables, Views, Good Knowledge of Data Warehouse (SSAS) and SSRS.
- Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities./SQL Server Commands and DTA (Database Tuning Advisor)
- Excellent knowledge in system tables and system stored procedures using T-SQL.
- Experience with SQL Server 2005/2008/2012, DDL / DML Triggers.
- Experience in ETL of data using SQL Server SSIS; migration of Data from Excel, Flat file, and Retrieval of FTP files for import and archiving once loaded; performed Data analysis for correctness.
- Experience with Data Types, Indexes, Stored Procedures, Triggers, Table-Valued Functions.
- Experience of loading and merging data from different sources into database table or view in a user-specified format; utilizing the various Control Flow and Data Flow task components of SSIS, and the capturing of errors during a process for correction and later input
- Develop, & implement program logic with use of C# scripts in ETL processes..
- Good knowledge in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export
- Strong skills in documentation of procedures and processes of a system in a format that is easily understood
- Experience with MS Office Products / Visual Studio 5 / 6, 2012/2015, Visual C/C++, C#, TFS, SourceSafe. Good knowledge in WCF framework and Web API's.
- Familiar with XML technologies
- Experience with ADO.NET, ASP.NET and C# , LINQ, HTML, CSS and some JavaScript
- Generated reports using the report Wizard, and the report Model Builder approach; used the Query designer in querying database report model and editing the report format to satisfaction
- Documenting Relationship model with metadata / Data Modeling
- Leadership, project management and time management.
- Worked with database connections, SQL joins, loops, aliases, views, Designed Sources to Targets mapping from primarily Flat files to Tables within Database
Technology Knowledge& Experience
SOFTWARE
Microsoft Windows 2008 /Server etc. Winrunner 8.0, Microsoft Word 2007/2010, Excel 2007/2010, Access 2007/2010, Visual Studio 2008 / 2010/15, Microsoft Visual C++ 2.0 /5.0/6.0, Visual Basic 5.0/6.0, C# .Net, MVC/ Telerik WPF Controls. Crystal Report 6.0, JavaScript, SQL Server, HTML 4.0, CSS, Adobe Photoshop CS5, Dream Weaver MX 2004, Corel Draw 5, SQL Server: 2005, 2008 /2012, 2015, 20016 / SSRS, SSIS (ETL). Mainframe JCL –Version Control:- SVN, SourceSafe, TFS, GitHub, SVN/ Visio 5/2000/ 2010,
HARDWARE
In-depth knowledge of Mainframe Operating systems; PC hardware and Software