Description
SUMMARY: * Over 9 years of IT experience in SQL Server (SSIS, SSAS, SSRS) using Microsoft technologies and Business Intelligence. * Experience in all facets of Software Development Lifecycle (SDLC) including requirements gathering, analysis, design, development, Reporting, Testing, implementation, and post implementation support. * Expertize in TSQL and PL/SQL writing SQL Queries, Stored procedures, Functions, Views, Triggers and cursors. * Extensive experience in creating ETL packages using SSIS (SQL Server Integration Services) and writing SQL jobs. * Proficient in creating reports using Crystal Report and SSRS. * Experience in Qlikview reporting in Dashboard in chart form. * Good experience in Autosys jobs, Automatic Job Alert. * Proficient in performing various administrative tasks in SQL such as Attaching and detaching database, backup and restore the database, creating users and granting permissions on database. * Experience in writing VBScript and batch files using DOS Commands. * Experience in working Cloud Server. Cloud applications can be updated, tested and deployed quickly, providing enterprises with fast time to market and agility. This speed can lead to culture shifts in business operations. * Experience in gathering business information, analyzing and documenting business and system requirements using standard templates. * Experience in programming DTS and SSIS packages using SQL Server Business Intelligence Studio. * Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures. * Experience in System Testing, UAT Support, Production Support and Maintenance Services. * Good interaction skills with developers, managers and team members to coordinate job tasks. * Good communication, interpersonal and analytical skills. Ability to communicate ideas issues and proposes solutions to both business and technology clientele. * Experience in handling team of 5 members in onsite-offshore model.
Accomplishments
Highlights:
Keywords
