Rss

PUSHPA R

Developer

Occupation:

Developer

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

Experience Summary * Skilled software professional over 8 years of IT industry experience with Microsoft SQL Server, Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS) environments. * Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server. * Experienced using T-SQL in SQL Server platform. * Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, effective functions, Cursors and Indexes using T-SQL. * Efficient in using Inner, Outer and Cross Joins, sub-queries for complex queries involving multiple tables. * Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. * Well versed in Normalization/ De-Normalization techniques for optimum performance in relational and dimensional database environments and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys. * Hands on experience in performance tuning, query optimization, and database optimization. * Expertise in solving dead Locks/Long running queries using Performance Monitor and SQL Profiler. * Experience in using Try Catch block introduced in SQL Server 2005. * Good knowledge in using system tables such as sys indexes, sys processes, and sys objects and sys comment in various queries and using Database Console Commands (DBCC). * Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance. * Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP. * Experience in data migration from Oracle/Access/Excel Sheets/Flat Files to SQL Server databases. * Migration experience with DTS to SSIS 2005. * Well-versed in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, Send mail task, For loop container, For each loop container, Sequence container) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge, Multi cast, Derived column, Character map, Union all, Sort, Row count, OLEDB command). * VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package. * Experience in enhancing and deploying SSIS Packages from development server to production server. * Experience in creating SSIS packages using Active X scripts and with Error Handling. * Created Crystal Reports on daily, weekly and monthly basis for manager's review. * Strong experience in developing parameterized, drill down, click through, chart, matrix, Ad-Hoc, sub reports using SSRS 2005 / 2008 using data from a variety of sources. * Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008. * Created stored procedure for generating reports using SQL Server Reporting Services (SSRS). * Experience in Designing and Building the Dimensions and cubes with star and Snowflake schemas using SQL Server Analysis Services (SSAS). * Experience in creating the MDX queries to access cubes and dimensions (SSAS). * Experience in Database Development, modeling, Data Warehousing, Design and Technical Management. * Worked on OLAP Data warehouse, Model, Design, and Implementation. * Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users, App Dev and Information architects to make sure all the requirements are fully covered - WA May 2014 - Till date

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseKeywords

Left_template4_bottom