Freelancers
freelancer
Email Verified George G
0.0/5 (0 Feedback)
Member since May 10, 2021

• Over 8 years of experience in design, development & analysis of SQL Server 2005/2008/2012 and SQ...

• Over 8 years of experience in design, development & analysis of SQL Server 2005/2008/2012 and SQL Server Business Intelligence tools (BIDS) – SSIS, SSRS, and SSAS. • Experience with Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting SQL Server 2005/2008. • Extensive experience in developing Stored Procedures, Functions using T-SQL. • Good understanding of ACID properties, RDBMS, Normalization /De-normalization and Database modeling. • Implemented Triggers at different levels of Database Objects to apply Security Constraints. • Good at improving Performance using Table Indexes, Indexed Views by implementing Schema Bindings. • Well experience in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2005/2008), DTS, Bulk Insert and Bulk Copy Program utility. • Experience at Transforming and Validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data. • Worked with Flat file, Excel file, SQL server OLEDB destinations for Loading data. • Experience in generating Parameterized Reports, Custom generated reports, Charts, Drill down, Drill Through reports using Local and Global Variables, Expressions and Filters in SSRS. • Developed Complex Queries, Stored Procedures and Functions for Report generation using SQL Server Reporting Services (SSRS 2005/2008) for organization requirements. • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule DTS/SSIS Packages. • Expert in monitoring SQL Server Performance using SQL Profiler. • Involved in administration tasks such as Data Loading, Batch Jobs, Data Unloading, Backup and Recovery, Upgrades, Creating Databases, Files, File groups and Transaction logs. • A multi tasking analytical thinker with the ability to work on fast paced work Environment. • Strong communication skills and an ability to work individually or part of a team and good learner to adapt new technologies that improve the business. TECHNICAL SKILLS: Databases MS SQL Server 2000/2005/2008/2012, Oracle 9i/10g, PL/SQL, MS Access Operating Systems Windows Server 2000/2003/2008 Windows XP/Vista. Programming Languages T-SQL, PL/SQL, HTML, XML, Oracle, C, C#, ASP.NET, JavaScript, Unix. Tools/Utilities Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Ervin Database Design Tools & Data Modeling MS Visio, MS Access, MS SQL Server 7.0/2000/2005/2008/2012, Star Schema/Snowflake Schema modeling. Physical & logical data modeling and De-Normalization techniques, Kimball & Inman Methodologies. Business Intelligence Tools Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), DTS Packages, Performance Point Server, Visual Studio. IT Processes Software Development Life Cycle (SDLC).

0

Ongoing projects

0

Completed projects

0

Cancelled projects

0

Ongoing services

0

Completed services

0

Cancelled services

$0.00

Total earnings

* Click the button to send an offer

Send offer