Subhash . Email & Phone Number

7+ Years of experience with SQL Server technlogies.Design Database Architecture to meet business needs. Data Migration/Conversion to different applications/platforms. Designing/Deploying SSIS Packages. Query Optimization.Writing Stored procedures as per business requirements.Writing views, functions, triggers, designing database, setting up referential integrity and constraints.Understanding of Table Partitioning, creating schema and function for the same.Designing and deployment of SSRS reports.Creating static or dynamic report subscriptions.Drill-Down and Drill-Through, Sub-Report, multiple dynamic parameter report design.Complex report design as per business requirement in SSRS.Configure Reporting services via SSRS configuration wizard.Created SSIS packages to Extract and Load data from diverse source (flat file, excel, csv, xml and sql).Used Join/Merge/Lookup Stages to replicate integration logic based on the volumes of the data.Created Data Flow’s for Aggregate, sort, lookup, Conversion, Derived Columns, merge, union all and fuzzy lookups and various expression, checkpoints.Used containers for repetitive control flow tasks like ForEach.Used Send Mail, Bulk Insert, Web Service, Execute SQL, Data Flow, Import Export control extensively in SSISPerformed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSISScheduled package execution in SSISDesigning ETL processes.Working with development team to help them to implement Business logic in to database and writing insert T-SQL scripts for the same.Interaction with customers for reporting requirements.Backup/restoration of databases.Installation and Configuration of MS SQL Server 2005 and 2008, 2008R2, 2012, 2014.Trouble shooting database problems.Database Index management.Performance and optimization of databases.